Pubblicato: 23.03.2009
Pubblicato: 27.05.2010 | Durata: 00:00:40 | Visualizzazioni: 2126
Gioco Digitale ha il più alto livello di sicurezza e di integrità di gioco. Tutte le informazioni sono protette dalla più avanzata tecnologia di criptatura, dei sistemi automatici monitorizzano il gioco e assicurano che il gioco sia condotto nell'interesse dei nostri utenti.
Dopo esserti registrato potrai versare sul tuo Conto Gioco col metodo che preferisci!
© Gioco Digitale Italia - P.I. 05522130961 - Tutti i diritti riservati
| # | type | message |
|---|---|---|
| 1 | Context | initialization |
| 2 | Controller | initialization |
| 3 | Routing | match route [default] "/:module/:action/*" |
| 4 | Request | request parameters array ( 'module' => 'content', 'action' => 'video_list', 'CatId' => '9',) |
| 5 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'username' => '****', ), FLAGS: 1 |
| 6 | Other | GiocoAuth: cookie INVALID |
| 7 | User | user is not authenticated |
| 8 | Controller | dispatch request |
| 9 | Filter | executing filter "sfRenderingFilter" |
| 10 | Filter | executing filter "sfWebDebugFilter" |
| 11 | Filter | executing filter "sfCommonFilter" |
| 12 | Filter | executing filter "sfFlashFilter" |
| 13 | Filter | executing filter "sfExecutionFilter" |
| 14 | Action | call "contentActions->executeVideo_list()" |
| 15 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 16 | Creole | executeQuery(): [0.19 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 17 | Creole | prepareStatement(): SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=? |
| 18 | Creole | applyLimit(): SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=1, offset: 0, limit: 1 |
| 19 | Creole | executeQuery(): [0.14 ms] SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=1 LIMIT 1 |
| 20 | Creole | prepareStatement(): SELECT syndication_client.ID, syndication_client.NAME FROM syndication_client WHERE syndication_client.ID=? |
| 21 | Creole | executeQuery(): [0.11 ms] SELECT syndication_client.ID, syndication_client.NAME FROM syndication_client WHERE syndication_client.ID=-1 |
| 22 | Creole | prepareStatement(): SELECT COUNT(contentcategory.ID) FROM (contentcategory, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_i18n.ID |
| 23 | Creole | executeQuery(): [0.13 ms] SELECT COUNT(contentcategory.ID) FROM (contentcategory, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_i18n.ID |
| 24 | Creole | prepareStatement(): SELECT COUNT(content.ID) FROM (content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) INNER JOIN contentcategory_has_content ON (content.ID=contentcategory_has_content.CONTENT_ID) WHERE content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=? AND content.IS_COMERCIAL=? AND content_i18n.VALID=? AND content_i18n.IS_AVAILABLE=? AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=? OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_has_content.CONTENTCATEGORY_ID=? AND content_i18n.CULTURE=? AND content.ID=content_i18n.ID |
| 25 | Creole | executeQuery(): [1.55 ms] SELECT COUNT(content.ID) FROM (content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) INNER JOIN contentcategory_has_content ON (content.ID=contentcategory_has_content.CONTENT_ID) WHERE content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=1 AND content.IS_COMERCIAL=0 AND content_i18n.VALID=1 AND content_i18n.IS_AVAILABLE=1 AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=-1 OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_has_content.CONTENTCATEGORY_ID=9 AND content_i18n.CULTURE='it_IT' AND content.ID=content_i18n.ID |
| 26 | View | initialize view for "content/video_list" |
| 27 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/content/video_listSuccess.php" |
| 28 | View | initialize view for "content/_list_controls" |
| 29 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/content/_list_controls.php" |
| 30 | Creole | prepareStatement(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS, content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM (content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) INNER JOIN contentcategory_has_content ON (content.ID=contentcategory_has_content.CONTENT_ID) WHERE content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=? AND content.IS_COMERCIAL=? AND content_i18n.VALID=? AND content_i18n.IS_AVAILABLE=? AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=? OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_has_content.CONTENTCATEGORY_ID=? AND content_i18n.CULTURE=? AND content.ID=content_i18n.ID ORDER BY content_i18n.PUBLICATION_TIME DESC |
| 31 | Creole | applyLimit(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS, content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM (content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) INNER JOIN contentcategory_has_content ON (content.ID=contentcategory_has_content.CONTENT_ID) WHERE content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=1 AND content.IS_COMERCIAL=0 AND content_i18n.VALID=1 AND content_i18n.IS_AVAILABLE=1 AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=-1 OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_has_content.CONTENTCATEGORY_ID=9 AND content_i18n.CULTURE='it_IT' AND content.ID=content_i18n.ID ORDER BY content_i18n.PUBLICATION_TIME DESC, offset: 0, limit: 6 |
| 32 | Creole | executeQuery(): [2.96 ms] SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS, content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM (content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) INNER JOIN contentcategory_has_content ON (content.ID=contentcategory_has_content.CONTENT_ID) WHERE content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=1 AND content.IS_COMERCIAL=0 AND content_i18n.VALID=1 AND content_i18n.IS_AVAILABLE=1 AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=-1 OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_has_content.CONTENTCATEGORY_ID=9 AND content_i18n.CULTURE='it_IT' AND content.ID=content_i18n.ID ORDER BY content_i18n.PUBLICATION_TIME DESC LIMIT 6 |
| 33 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 34 | Creole | executeQuery(): [0.12 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 35 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 36 | Creole | executeQuery(): [0.14 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=1222 |
| 37 | Creole | prepareStatement(): SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=? AND contentcategory_i18n.CULTURE=? |
| 38 | Creole | executeQuery(): [0.13 ms] SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=9 AND contentcategory_i18n.CULTURE='it_IT' |
| 39 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 40 | Creole | executeQuery(): [0.12 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 41 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 42 | Creole | executeQuery(): [0.13 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=1183 |
| 43 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 44 | Creole | executeQuery(): [0.10 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 45 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 46 | Creole | executeQuery(): [0.11 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=990 |
| 47 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 48 | Creole | executeQuery(): [0.10 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 49 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 50 | Creole | executeQuery(): [0.11 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=719 |
| 51 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 52 | Creole | executeQuery(): [0.11 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 53 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 54 | Creole | executeQuery(): [0.11 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=606 |
| 55 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 56 | Creole | executeQuery(): [0.10 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 57 | Creole | prepareStatement(): SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=? |
| 58 | Creole | executeQuery(): [0.11 ms] SELECT thumbnail.ID, thumbnail.TITLE, thumbnail.DESCRIPTION, thumbnail.FILENAME, thumbnail.HEIGHT, thumbnail.WIDTH, thumbnail.TYPE, thumbnail.FILE_VIDEO_QUALITY, thumbnail.FILE_HIGH_QUALITY, thumbnail.CONTENT_ID FROM thumbnail WHERE thumbnail.ID=516 |
| 59 | View | decorate content with "sf_root_dir/web/theme/giocco_digitale_3/templates/layout.php" |
| 60 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/layout.php" |
| 61 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 62 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 63 | Creole | prepareStatement(): SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=? AND contentcategory_i18n.CULTURE=? |
| 64 | Creole | executeQuery(): [0.12 ms] SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=9 AND contentcategory_i18n.CULTURE='it_IT' |
| 65 | Creole | prepareStatement(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT FROM videoformat |
| 66 | Creole | executeQuery(): [0.44 ms] SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT FROM videoformat |
| 67 | Creole | prepareStatement(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=? |
| 68 | Creole | applyLimit(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1, offset: 0, limit: 1 |
| 69 | Creole | executeQuery(): [0.15 ms] SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1 LIMIT 1 |
| 70 | Creole | prepareStatement(): SELECT frontpage_i18n.ID, frontpage_i18n.CULTURE, frontpage_i18n.NAME, frontpage_i18n.DESCRIPTION, frontpage_i18n.VALID, frontpage_i18n.LIVECHANNEL_ID, frontpage_i18n.FRONT_CONTENT_ID, frontpage_i18n.LIVEPLAYLIST_ID, frontpage_i18n.WIDGET_FRONT_CONTENT_ID, frontpage_i18n.VISUAL_IDENTITY_PACKAGE_ID FROM frontpage_i18n WHERE frontpage_i18n.ID=? AND frontpage_i18n.CULTURE=? |
| 71 | Creole | executeQuery(): [0.13 ms] SELECT frontpage_i18n.ID, frontpage_i18n.CULTURE, frontpage_i18n.NAME, frontpage_i18n.DESCRIPTION, frontpage_i18n.VALID, frontpage_i18n.LIVECHANNEL_ID, frontpage_i18n.FRONT_CONTENT_ID, frontpage_i18n.LIVEPLAYLIST_ID, frontpage_i18n.WIDGET_FRONT_CONTENT_ID, frontpage_i18n.VISUAL_IDENTITY_PACKAGE_ID FROM frontpage_i18n WHERE frontpage_i18n.ID=1 AND frontpage_i18n.CULTURE='it_IT' |
| 72 | Creole | prepareStatement(): SELECT live_playlist.ID, live_playlist.START_TIME, live_playlist.GENERATED_CONTENT_TIME, live_playlist.PPV_CONTENT_ID, live_playlist.SHOW_EMBED, live_playlist.SHOW_LINK, live_playlist.REPEAT_IN_SCHEDULE, live_playlist.LAST_UPDATE_TIME FROM live_playlist WHERE live_playlist.ID=? |
| 73 | Creole | executeQuery(): [0.12 ms] SELECT live_playlist.ID, live_playlist.START_TIME, live_playlist.GENERATED_CONTENT_TIME, live_playlist.PPV_CONTENT_ID, live_playlist.SHOW_EMBED, live_playlist.SHOW_LINK, live_playlist.REPEAT_IN_SCHEDULE, live_playlist.LAST_UPDATE_TIME FROM live_playlist WHERE live_playlist.ID=1 |
| 74 | PartialHelper | call "contentcategory->executeInlineList()" |
| 75 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 76 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC, offset: 0, limit: 30 |
| 77 | Creole | executeQuery(): [0.21 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC LIMIT 30 |
| 78 | View | initialize view for "contentcategory/_inlineList" |
| 79 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/contentcategory/_inlineList.php" |
| 80 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 81 | Creole | executeQuery(): [0.18 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=19 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 82 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 83 | Creole | executeQuery(): [0.19 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=11 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 84 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 85 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=34 |
| 86 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 87 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=42 |
| 88 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 89 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=42 |
| 90 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 91 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=23 |
| 92 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 93 | Creole | executeQuery(): [0.18 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=5 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 94 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 95 | Creole | executeQuery(): [0.19 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=36 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 96 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 97 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=6 |
| 98 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 99 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=28 |
| 100 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 101 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=28 |
| 102 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 103 | Creole | executeQuery(): [0.18 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=8 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 104 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 105 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=18 |
| 106 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 107 | Creole | executeQuery(): [0.18 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=41 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 108 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 109 | Creole | executeQuery(): [0.18 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 110 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 111 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 112 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 113 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 114 | PartialHelper | call "contentcategory->executeSubcategory()" |
| 115 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 116 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC, offset: 0, limit: 15 |
| 117 | Creole | executeQuery(): [0.18 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC LIMIT 15 |
| 118 | View | initialize view for "contentcategory/_subcategory" |
| 119 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/contentcategory/_subcategory.php" |
| 120 | PartialHelper | call "content->executeShow()" |
| 121 | Creole | prepareStatement(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=? |
| 122 | Creole | applyLimit(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1, offset: 0, limit: 1 |
| 123 | Creole | executeQuery(): [0.18 ms] SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1 LIMIT 1 |
| 124 | Creole | prepareStatement(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=? |
| 125 | Creole | applyLimit(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=1125, offset: 0, limit: 1 |
| 126 | Creole | executeQuery(): [0.49 ms] SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=1125 LIMIT 1 |
| 127 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE content_has_mediafiles.CONTENT_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 128 | Creole | executeQuery(): [0.13 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE content_has_mediafiles.CONTENT_ID=1125 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 129 | Creole | prepareStatement(): SELECT language.ID, language.CULTURE FROM language WHERE language.CULTURE=? |
| 130 | Creole | applyLimit(): SELECT language.ID, language.CULTURE FROM language WHERE language.CULTURE='it_IT', offset: 0, limit: 1 |
| 131 | Creole | executeQuery(): [0.11 ms] SELECT language.ID, language.CULTURE FROM language WHERE language.CULTURE='it_IT' LIMIT 1 |
| 132 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 133 | Creole | executeQuery(): [0.15 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 134 | Creole | prepareStatement(): SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM streamingserver_has_mediafile WHERE streamingserver_has_mediafile.MEDIAFILE_ID=? |
| 135 | Creole | executeQuery(): [0.12 ms] SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM streamingserver_has_mediafile WHERE streamingserver_has_mediafile.MEDIAFILE_ID=1051 |
| 136 | Creole | prepareStatement(): SELECT mediafile_subtitle.ID, mediafile_subtitle.CONTENTHASMEDIAFILES_ID FROM mediafile_subtitle, mediafile_subtitle_i18n WHERE mediafile_subtitle.CONTENTHASMEDIAFILES_ID=? AND mediafile_subtitle_i18n.CULTURE=? |
| 137 | Creole | executeQuery(): [0.11 ms] SELECT mediafile_subtitle.ID, mediafile_subtitle.CONTENTHASMEDIAFILES_ID FROM mediafile_subtitle, mediafile_subtitle_i18n WHERE mediafile_subtitle.CONTENTHASMEDIAFILES_ID=2071 AND mediafile_subtitle_i18n.CULTURE='it_IT' |
| 138 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=? ORDER BY content_has_mediafiles.PRIORITY ASC |
| 139 | Creole | executeQuery(): [0.11 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=1125 ORDER BY content_has_mediafiles.PRIORITY ASC |
| 140 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 141 | Creole | executeQuery(): [0.16 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 142 | Creole | prepareStatement(): SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM (video_player_type, webserver_has_streamingserver) INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND streamingserver_has_mediafile.ENABLED=? AND streamingserver_has_mediafile.MEDIAFILE_ID=? ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 143 | Creole | executeQuery(): [0.13 ms] SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM (video_player_type, webserver_has_streamingserver) INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=19 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND streamingserver_has_mediafile.ENABLED=1 AND streamingserver_has_mediafile.MEDIAFILE_ID=1051 ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 144 | Creole | prepareStatement(): SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM (video_player_type, webserver_has_streamingserver) INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND streamingserver_has_mediafile.ENABLED=? AND streamingserver_has_mediafile.MEDIAFILE_ID=? AND video_player_type.SHOW_TYPE IS NULL ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 145 | Creole | executeQuery(): [0.12 ms] SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM (video_player_type, webserver_has_streamingserver) INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=19 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND streamingserver_has_mediafile.ENABLED=1 AND streamingserver_has_mediafile.MEDIAFILE_ID=1051 AND video_player_type.SHOW_TYPE IS NULL ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 146 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=? AND mediafile.FORMAT IS NULL ORDER BY content_has_mediafiles.PRIORITY ASC |
| 147 | Creole | executeQuery(): [0.11 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND mediafile.FORMAT IS NULL ORDER BY content_has_mediafiles.PRIORITY ASC |
| 148 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=? ORDER BY content_has_mediafiles.PRIORITY ASC |
| 149 | Creole | executeQuery(): [0.11 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=1125 ORDER BY content_has_mediafiles.PRIORITY ASC |
| 150 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 151 | Creole | executeQuery(): [0.15 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 152 | Creole | prepareStatement(): SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM video_player_type INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=? AND streamingserver_has_mediafile.MEDIAFILE_ID=? |
| 153 | Creole | executeQuery(): [0.13 ms] SELECT video_player_type.ID, video_player_type.NAME, video_player_type.SHOW_TYPE FROM video_player_type INNER JOIN video_player_type_has_mediafiletype ON (video_player_type.ID=video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID) INNER JOIN video_player_type_has_streamingserver ON (video_player_type.ID=video_player_type_has_streamingserver.VIDEO_PLAYER_TYPE_ID) INNER JOIN streamingserver ON (video_player_type_has_streamingserver.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN streamingserver_has_mediafile ON (streamingserver.ID=streamingserver_has_mediafile.STREAMINGSERVER_ID) WHERE video_player_type_has_mediafiletype.MEDIAFILETYPE_ID=19 AND streamingserver_has_mediafile.MEDIAFILE_ID=1051 |
| 154 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM (content_has_mediafiles, webserver_has_streamingserver, mediafile, streamingserver) LEFT JOIN mediafiletype ON (mediafile.MEDIAFILETYPE_ID=mediafiletype.ID) LEFT JOIN video_player_type_has_mediafiletype ON (mediafiletype.ID=video_player_type_has_mediafiletype.MEDIAFILETYPE_ID) LEFT JOIN video_player_type ON (video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID=video_player_type.ID) LEFT JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE webserver_has_streamingserver.WEBSERVER_ID=? AND streamingserver_has_mediafile.ENABLED=? AND (video_player_type.SHOW_TYPE=? OR mediafile.FORMAT=?) AND content_has_mediafiles.CONTENT_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 155 | Creole | executeQuery(): [0.14 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM (content_has_mediafiles, webserver_has_streamingserver, mediafile, streamingserver) LEFT JOIN mediafiletype ON (mediafile.MEDIAFILETYPE_ID=mediafiletype.ID) LEFT JOIN video_player_type_has_mediafiletype ON (mediafiletype.ID=video_player_type_has_mediafiletype.MEDIAFILETYPE_ID) LEFT JOIN video_player_type ON (video_player_type_has_mediafiletype.VIDEO_PLAYER_TYPE_ID=video_player_type.ID) LEFT JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE webserver_has_streamingserver.WEBSERVER_ID=1 AND streamingserver_has_mediafile.ENABLED=1 AND (video_player_type.SHOW_TYPE='flv' OR mediafile.FORMAT='flv') AND content_has_mediafiles.CONTENT_ID=1125 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 156 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 157 | Creole | executeQuery(): [0.17 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 158 | Creole | prepareStatement(): SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM (streamingserver_has_mediafile, webserver_has_streamingserver) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) WHERE streamingserver_has_mediafile.ENABLED=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND streamingserver_has_mediafile.MEDIAFILE_ID=? AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 159 | Creole | executeQuery(): [0.12 ms] SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM (streamingserver_has_mediafile, webserver_has_streamingserver) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) WHERE streamingserver_has_mediafile.ENABLED=1 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND streamingserver_has_mediafile.MEDIAFILE_ID=1051 AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 160 | Creole | prepareStatement(): SELECT streamingserver.ID, streamingserver.AVAILABLE, streamingserver.SERVER_NAME, streamingserver.SERVER_IP, streamingserver.PROTOCOL_ID, streamingserver.LIVE_PUBLISHING_POINT, streamingserver.ON_DEMAND_POINT, streamingserver.STREAMINGSERVERTYPE_ID, streamingserver.WSX_FTP_USERNAME, streamingserver.WSX_FTP_PASSWORD, streamingserver.WSX_FTP_PATH, streamingserver.WSX_FTP_DNS_NAME, streamingserver.WSX_FTP_PORT, streamingserver.WSX_FTP_PASSIVE, streamingserver.WSX_FTP_TIMEOUT, streamingserver.PATH, streamingserver.STREAMER, streamingserver.ENABLE_PREFIX, streamingserver.IS_INTRANET FROM streamingserver WHERE streamingserver.ID=? |
| 161 | Creole | executeQuery(): [0.13 ms] SELECT streamingserver.ID, streamingserver.AVAILABLE, streamingserver.SERVER_NAME, streamingserver.SERVER_IP, streamingserver.PROTOCOL_ID, streamingserver.LIVE_PUBLISHING_POINT, streamingserver.ON_DEMAND_POINT, streamingserver.STREAMINGSERVERTYPE_ID, streamingserver.WSX_FTP_USERNAME, streamingserver.WSX_FTP_PASSWORD, streamingserver.WSX_FTP_PATH, streamingserver.WSX_FTP_DNS_NAME, streamingserver.WSX_FTP_PORT, streamingserver.WSX_FTP_PASSIVE, streamingserver.WSX_FTP_TIMEOUT, streamingserver.PATH, streamingserver.STREAMER, streamingserver.ENABLE_PREFIX, streamingserver.IS_INTRANET FROM streamingserver WHERE streamingserver.ID=3 |
| 162 | Creole | prepareStatement(): SELECT streaming_protocol.ID, streaming_protocol.PROTOCOL FROM streaming_protocol WHERE streaming_protocol.ID=? |
| 163 | Creole | executeQuery(): [0.12 ms] SELECT streaming_protocol.ID, streaming_protocol.PROTOCOL FROM streaming_protocol WHERE streaming_protocol.ID=1 |
| 164 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=? ORDER BY content_has_mediafiles.PRIORITY ASC |
| 165 | Creole | executeQuery(): [0.11 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) WHERE content_has_mediafiles.CONTENT_ID=1125 ORDER BY content_has_mediafiles.PRIORITY ASC |
| 166 | Creole | prepareStatement(): SELECT content_tag.ID FROM content_has_tag LEFT JOIN content_tag ON (content_has_tag.TAG_ID=content_tag.ID) WHERE content_has_tag.CONTENT_ID IS NULL |
| 167 | Creole | executeQuery(): [0.10 ms] SELECT content_tag.ID FROM content_has_tag LEFT JOIN content_tag ON (content_has_tag.TAG_ID=content_tag.ID) WHERE content_has_tag.CONTENT_ID IS NULL |
| 168 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 169 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 170 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 171 | Creole | executeQuery(): [0.16 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 172 | Creole | prepareStatement(): SELECT DISTINCT video_player.ID, video_player.NAME, video_player.CODE, video_player.FORMAT FROM video_player, contentcategory, mediafiletype, video_player_has_media_file_type WHERE contentcategory.ID=? AND mediafiletype.EXTENSION=? AND video_player.ID=contentcategory.VIDEO_PLAYER_ID AND video_player.ID=video_player_has_media_file_type.VIDEO_PLAYER_ID AND video_player_has_media_file_type.MEDIAFILETYPE_ID=mediafiletype.ID |
| 173 | Creole | applyLimit(): SELECT DISTINCT video_player.ID, video_player.NAME, video_player.CODE, video_player.FORMAT FROM video_player, contentcategory, mediafiletype, video_player_has_media_file_type WHERE contentcategory.ID=9 AND mediafiletype.EXTENSION='flv' AND video_player.ID=contentcategory.VIDEO_PLAYER_ID AND video_player.ID=video_player_has_media_file_type.VIDEO_PLAYER_ID AND video_player_has_media_file_type.MEDIAFILETYPE_ID=mediafiletype.ID, offset: 0, limit: 1 |
| 174 | Creole | executeQuery(): [0.12 ms] SELECT DISTINCT video_player.ID, video_player.NAME, video_player.CODE, video_player.FORMAT FROM video_player, contentcategory, mediafiletype, video_player_has_media_file_type WHERE contentcategory.ID=9 AND mediafiletype.EXTENSION='flv' AND video_player.ID=contentcategory.VIDEO_PLAYER_ID AND video_player.ID=video_player_has_media_file_type.VIDEO_PLAYER_ID AND video_player_has_media_file_type.MEDIAFILETYPE_ID=mediafiletype.ID LIMIT 1 |
| 175 | View | initialize view for "content/_show" |
| 176 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/content/_show.php" |
| 177 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 178 | Creole | executeQuery(): [0.18 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 179 | Creole | prepareStatement(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>? ORDER BY ratio ASC |
| 180 | Creole | applyLimit(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC, offset: 0, limit: 1 |
| 181 | Creole | executeQuery(): [0.12 ms] SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC LIMIT 1 |
| 182 | View | initialize view for "content/_flvshow" |
| 183 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/content/_flvshow.php" |
| 184 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 185 | Creole | executeQuery(): [0.16 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 186 | Creole | prepareStatement(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>? ORDER BY ratio ASC |
| 187 | Creole | applyLimit(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC, offset: 0, limit: 1 |
| 188 | Creole | executeQuery(): [0.11 ms] SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC LIMIT 1 |
| 189 | Creole | prepareStatement(): SELECT content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM content_i18n WHERE content_i18n.ID=? AND content_i18n.CULTURE=? |
| 190 | Creole | executeQuery(): [0.20 ms] SELECT content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM content_i18n WHERE content_i18n.ID=1125 AND content_i18n.CULTURE='it_IT' |
| 191 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE mediafile.FORMAT=? AND content_has_mediafiles.CONTENT_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 192 | Creole | executeQuery(): [0.12 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE mediafile.FORMAT='flv' AND content_has_mediafiles.CONTENT_ID=1125 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 193 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 194 | Creole | executeQuery(): [0.15 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 195 | Creole | prepareStatement(): SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM (streamingserver_has_mediafile, webserver_has_streamingserver) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) WHERE streamingserver_has_mediafile.ENABLED=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND streamingserver_has_mediafile.MEDIAFILE_ID=? AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 196 | Creole | executeQuery(): [0.12 ms] SELECT streamingserver_has_mediafile.ID, streamingserver_has_mediafile.STREAMINGSERVER_ID, streamingserver_has_mediafile.MEDIAFILE_ID, streamingserver_has_mediafile.DATASERVER_ID, streamingserver_has_mediafile.ENABLED FROM (streamingserver_has_mediafile, webserver_has_streamingserver) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) WHERE streamingserver_has_mediafile.ENABLED=1 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND streamingserver_has_mediafile.MEDIAFILE_ID=1051 AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID ORDER BY webserver_has_streamingserver.PRIORITY ASC |
| 197 | Creole | prepareStatement(): SELECT streamingserver.ID, streamingserver.AVAILABLE, streamingserver.SERVER_NAME, streamingserver.SERVER_IP, streamingserver.PROTOCOL_ID, streamingserver.LIVE_PUBLISHING_POINT, streamingserver.ON_DEMAND_POINT, streamingserver.STREAMINGSERVERTYPE_ID, streamingserver.WSX_FTP_USERNAME, streamingserver.WSX_FTP_PASSWORD, streamingserver.WSX_FTP_PATH, streamingserver.WSX_FTP_DNS_NAME, streamingserver.WSX_FTP_PORT, streamingserver.WSX_FTP_PASSIVE, streamingserver.WSX_FTP_TIMEOUT, streamingserver.PATH, streamingserver.STREAMER, streamingserver.ENABLE_PREFIX, streamingserver.IS_INTRANET FROM streamingserver WHERE streamingserver.ID=? |
| 198 | Creole | executeQuery(): [0.13 ms] SELECT streamingserver.ID, streamingserver.AVAILABLE, streamingserver.SERVER_NAME, streamingserver.SERVER_IP, streamingserver.PROTOCOL_ID, streamingserver.LIVE_PUBLISHING_POINT, streamingserver.ON_DEMAND_POINT, streamingserver.STREAMINGSERVERTYPE_ID, streamingserver.WSX_FTP_USERNAME, streamingserver.WSX_FTP_PASSWORD, streamingserver.WSX_FTP_PATH, streamingserver.WSX_FTP_DNS_NAME, streamingserver.WSX_FTP_PORT, streamingserver.WSX_FTP_PASSIVE, streamingserver.WSX_FTP_TIMEOUT, streamingserver.PATH, streamingserver.STREAMER, streamingserver.ENABLE_PREFIX, streamingserver.IS_INTRANET FROM streamingserver WHERE streamingserver.ID=3 |
| 199 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=? |
| 200 | Creole | executeQuery(): [0.15 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM mediafile WHERE mediafile.ID=1051 |
| 201 | Creole | prepareStatement(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>? ORDER BY ratio ASC |
| 202 | Creole | applyLimit(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC, offset: 0, limit: 1 |
| 203 | Creole | executeQuery(): [0.11 ms] SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT, ABS((width/height)-1.77678571429) AS ratio FROM videoformat WHERE videoformat.ID<>-1 ORDER BY ratio ASC LIMIT 1 |
| 204 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID |
| 205 | Creole | applyLimit(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID, offset: 0, limit: 1 |
| 206 | Creole | executeQuery(): [0.17 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID LIMIT 1 |
| 207 | Creole | prepareStatement(): SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE mediafile.MEDIA_EDITION_ID=? AND content_has_mediafiles.CONTENT_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 208 | Creole | executeQuery(): [0.12 ms] SELECT content_has_mediafiles.ID, content_has_mediafiles.CONTENT_ID, content_has_mediafiles.MEDIAFILE_ID, content_has_mediafiles.PRIORITY FROM content_has_mediafiles, mediafile WHERE mediafile.MEDIA_EDITION_ID=2 AND content_has_mediafiles.CONTENT_ID=1125 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID |
| 209 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID |
| 210 | Creole | applyLimit(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID, offset: 0, limit: 1 |
| 211 | Creole | executeQuery(): [0.19 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID LIMIT 1 |
| 212 | Creole | prepareStatement(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=? AND webserver_has_streamingserver.WEBSERVER_ID=? AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID |
| 213 | Creole | applyLimit(): SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID, offset: 0, limit: 1 |
| 214 | Creole | executeQuery(): [0.17 ms] SELECT mediafile.ID, mediafile.FILE_SIZE, mediafile.FILE_NAME, mediafile.FULL_PATH, mediafile.DURATION, mediafile.DURATION_IN_SECONDS, mediafile.BITRATE, mediafile.FORMAT, mediafile.LIVE_URL1, mediafile.LIVE_URL2, mediafile.LIVE_URL3, mediafile.LIVE_URL4, mediafile.LIVE_URL5, mediafile.MEDIA_TYPE_ID, mediafile.MEDIAFILETYPE_ID, mediafile.MEDIAFILE_CULTURE, mediafile.MEDIA_EDITION_ID, mediafile.MEDIA_LANGUAGE, mediafile.PLAYLIST_ID, mediafile.FLASH_IDENTIFIER1, mediafile.FLASH_IDENTIFIER2, mediafile.FLASH_IDENTIFIER3, mediafile.FLASH_IDENTIFIER4, mediafile.FLASH_IDENTIFIER5, mediafile.WIDTH, mediafile.HEIGHT, mediafile.ASPECT_W, mediafile.ASPECT_H, mediafile.STREAMING_TYPE, mediafile.IS_PUBLIC FROM (mediafile, content_has_mediafiles, webserver_has_streamingserver, streamingserver) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) WHERE content_has_mediafiles.CONTENT_ID=1125 AND webserver_has_streamingserver.WEBSERVER_ID=1 AND content_has_mediafiles.MEDIAFILE_ID=mediafile.ID AND streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID LIMIT 1 |
| 215 | Creole | prepareStatement(): SELECT COUNT(content_has_content.ID) FROM content_has_content WHERE content_has_content.CONTENT1_ID=? |
| 216 | Creole | executeQuery(): [0.12 ms] SELECT COUNT(content_has_content.ID) FROM content_has_content WHERE content_has_content.CONTENT1_ID=1125 |
| 217 | PartialHelper | call "content->executeDetails()" |
| 218 | Creole | prepareStatement(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=? |
| 219 | Creole | applyLimit(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=1125, offset: 0, limit: 1 |
| 220 | Creole | executeQuery(): [0.18 ms] SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=1125 LIMIT 1 |
| 221 | Creole | prepareStatement(): SELECT content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM content_i18n WHERE content_i18n.ID=? AND content_i18n.CULTURE=? |
| 222 | Creole | executeQuery(): [0.13 ms] SELECT content_i18n.ID, content_i18n.CULTURE, content_i18n.VALID, content_i18n.TITLE, content_i18n.AUTHOR_ID, content_i18n.COPYRIGHT, content_i18n.DESCRIPTION, content_i18n.TIME_SECONDS, content_i18n.IS_AVAILABLE, content_i18n.IS_PUBLIC, content_i18n.CREATION_TIME, content_i18n.EXPIRATION_TIME, content_i18n.THUMBNAIL_ID, content_i18n.PRELOADER_ID, content_i18n.SHOW_CONTROLS, content_i18n.ABSTRACT_TEXT, content_i18n.PUBLICATION_TIME, content_i18n.NOTE FROM content_i18n WHERE content_i18n.ID=1125 AND content_i18n.CULTURE='it_IT' |
| 223 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 224 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 225 | Creole | prepareStatement(): SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=? AND contentcategory_i18n.CULTURE=? |
| 226 | Creole | executeQuery(): [0.12 ms] SELECT contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM contentcategory_i18n WHERE contentcategory_i18n.ID=9 AND contentcategory_i18n.CULTURE='it_IT' |
| 227 | Creole | prepareStatement(): SELECT content_tag.ID FROM content_has_tag LEFT JOIN content_tag ON (content_has_tag.TAG_ID=content_tag.ID) WHERE content_has_tag.CONTENT_ID IS NULL |
| 228 | Creole | executeQuery(): [0.10 ms] SELECT content_tag.ID FROM content_has_tag LEFT JOIN content_tag ON (content_has_tag.TAG_ID=content_tag.ID) WHERE content_has_tag.CONTENT_ID IS NULL |
| 229 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 230 | Creole | executeQuery(): [0.14 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=9 |
| 231 | Creole | prepareStatement(): SELECT COUNT(content_has_content.ID) FROM (content_has_content, content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) WHERE content_has_content.CONTENT1_ID=? AND content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=? AND content.IS_COMERCIAL=? AND content_i18n.VALID=? AND content_i18n.IS_AVAILABLE=? AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=? OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND content_has_content.CONTENT2_ID=content.ID |
| 232 | Creole | executeQuery(): [0.59 ms] SELECT COUNT(content_has_content.ID) FROM (content_has_content, content, content_i18n) INNER JOIN webserver_has_content ON (content.ID=webserver_has_content.CONTENT_ID) WHERE content_has_content.CONTENT1_ID=1125 AND content.PARENT_CONTENT_ID IS NULL AND EXISTS (SELECT * FROM content_has_mediafiles INNER JOIN mediafile ON (content_has_mediafiles.MEDIAFILE_ID=mediafile.ID) INNER JOIN streamingserver_has_mediafile ON (mediafile.ID=streamingserver_has_mediafile.MEDIAFILE_ID) INNER JOIN streamingserver ON (streamingserver_has_mediafile.STREAMINGSERVER_ID=streamingserver.ID) INNER JOIN webserver_has_streamingserver ON (streamingserver.ID=webserver_has_streamingserver.STREAMINGSERVER_ID) WHERE content_has_mediafiles.content_id = content.id AND mediafile.MEDIA_TYPE_ID != -1 AND webserver_has_streamingserver.webserver_id = 1) AND webserver_has_content.WEBSERVER_ID=1 AND content.IS_COMERCIAL=0 AND content_i18n.VALID=1 AND content_i18n.IS_AVAILABLE=1 AND (content_i18n.EXPIRATION_TIME IS NULL OR content_i18n.EXPIRATION_TIME>=CURRENT_TIMESTAMP) AND (content_i18n.PUBLICATION_TIME IS NULL OR content_i18n.PUBLICATION_TIME<=CURRENT_TIMESTAMP) AND (content.CONTENT_OWNER_ID=-1 OR EXISTS (SELECT * FROM content_syndicated_to_client JOIN content_syndicated_to_client_to_webserver ON content_syndicated_to_client.id = content_syndicated_to_client_to_webserver.content_syndicated_to_client_id WHERE content_syndicated_to_client.copy_content_id = content.id AND content_syndicated_to_client.content_owner_id =-1 AND content_syndicated_to_client_to_webserver.webserver_id = 1 AND (content_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client.start_time)) AND (content_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client.expiration_time)) AND (content_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.start_time)) AND (content_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(content_syndicated_to_client_to_webserver.expiration_time)) )) AND content_has_content.CONTENT2_ID=content.ID |
| 233 | Creole | prepareStatement(): SELECT COUNT(comment.ID) FROM comment WHERE comment.CONTENT_ID=? AND comment.ALLOW=? |
| 234 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(comment.ID) FROM comment WHERE comment.CONTENT_ID=1125 AND comment.ALLOW=1 |
| 235 | Creole | prepareStatement(): SELECT COUNT(bibliography.ID) FROM bibliography WHERE bibliography.CONTENT_ID=? |
| 236 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(bibliography.ID) FROM bibliography WHERE bibliography.CONTENT_ID=1125 |
| 237 | Creole | prepareStatement(): SELECT COUNT(externlink.ID) FROM externlink WHERE externlink.CONTENT_ID=? |
| 238 | Creole | executeQuery(): [0.10 ms] SELECT COUNT(externlink.ID) FROM externlink WHERE externlink.CONTENT_ID=1125 |
| 239 | Creole | prepareStatement(): SELECT COUNT(saleitem.ID) FROM saleitem WHERE saleitem.CONTENT_ID=? |
| 240 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(saleitem.ID) FROM saleitem WHERE saleitem.CONTENT_ID=1125 |
| 241 | Creole | prepareStatement(): SELECT COUNT(content_has_content.ID) FROM content_has_content, file, file_i18n WHERE file.CONTENT_ID=? AND file_i18n.VALID=? |
| 242 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(content_has_content.ID) FROM content_has_content, file, file_i18n WHERE file.CONTENT_ID=1125 AND file_i18n.VALID=1 |
| 243 | Creole | prepareStatement(): SELECT COUNT(comment.ID) FROM comment, file, file_i18n WHERE file.CONTENT_ID=? AND file_i18n.VALID=? AND comment.CONTENT_ID=? AND comment.ALLOW=? |
| 244 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(comment.ID) FROM comment, file, file_i18n WHERE file.CONTENT_ID=1125 AND file_i18n.VALID=1 AND comment.CONTENT_ID=1125 AND comment.ALLOW=1 |
| 245 | Creole | prepareStatement(): SELECT COUNT(file.ID) FROM file WHERE file.CONTENT_ID=? |
| 246 | Creole | executeQuery(): [0.10 ms] SELECT COUNT(file.ID) FROM file WHERE file.CONTENT_ID=1125 |
| 247 | Creole | prepareStatement(): SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=? AND content_image_i18n.VALID=? |
| 248 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=1125 AND content_image_i18n.VALID=1 |
| 249 | Creole | prepareStatement(): SELECT credit.ID, credit.CONTENT_ID, credit_i18n.ID, credit_i18n.CULTURE, credit_i18n.TITLE, credit_i18n.TEXT, credit_i18n.VALID, credit_i18n.FILE FROM credit, credit_i18n WHERE credit.CONTENT_ID=? AND credit_i18n.VALID=? AND credit_i18n.CULTURE=? AND credit.ID=credit_i18n.ID |
| 250 | Creole | executeQuery(): [0.12 ms] SELECT credit.ID, credit.CONTENT_ID, credit_i18n.ID, credit_i18n.CULTURE, credit_i18n.TITLE, credit_i18n.TEXT, credit_i18n.VALID, credit_i18n.FILE FROM credit, credit_i18n WHERE credit.CONTENT_ID=1125 AND credit_i18n.VALID=1 AND credit_i18n.CULTURE='it_IT' AND credit.ID=credit_i18n.ID |
| 251 | Creole | prepareStatement(): SELECT COUNT(comment.ID) FROM comment WHERE comment.CONTENT_ID=? AND comment.WEBSERVER_ID=? AND comment.ALLOW=? |
| 252 | Creole | executeQuery(): [0.10 ms] SELECT COUNT(comment.ID) FROM comment WHERE comment.CONTENT_ID=1125 AND comment.WEBSERVER_ID=1 AND comment.ALLOW=1 |
| 253 | View | initialize view for "content/_details" |
| 254 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/content/_details.php" |
| 255 | Creole | prepareStatement(): SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=? AND content_image_i18n.VALID=? AND content_image_i18n.CULTURE=? AND content_image.ID=content_image_i18n.ID |
| 256 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=1125 AND content_image_i18n.VALID=1 AND content_image_i18n.CULTURE='it_IT' AND content_image.ID=content_image_i18n.ID |
| 257 | Creole | prepareStatement(): SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=? |
| 258 | Creole | executeQuery(): [0.11 ms] SELECT author.ID, author.NAME, author.COPYRIGHT, author.MAIL, author.INFO FROM author WHERE author.ID=-1 |
| 259 | Creole | prepareStatement(): SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=? AND content_image_i18n.VALID=? AND content_image_i18n.CULTURE=? AND content_image.ID=content_image_i18n.ID |
| 260 | Creole | executeQuery(): [0.12 ms] SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=1125 AND content_image_i18n.VALID=1 AND content_image_i18n.CULTURE='it_IT' AND content_image.ID=content_image_i18n.ID |
| 261 | Creole | prepareStatement(): SELECT COUNT(content.ID) FROM content WHERE content.PARENT_CONTENT_ID=? |
| 262 | Creole | executeQuery(): [0.19 ms] SELECT COUNT(content.ID) FROM content WHERE content.PARENT_CONTENT_ID=1125 |
| 263 | Creole | prepareStatement(): SELECT COUNT(content.ID) FROM content WHERE content.PARENT_CONTENT_ID=? |
| 264 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(content.ID) FROM content WHERE content.PARENT_CONTENT_ID=1125 |
| 265 | Creole | prepareStatement(): SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=? AND content_image_i18n.VALID=? AND content_image_i18n.CULTURE=? AND content_image.ID=content_image_i18n.ID |
| 266 | Creole | executeQuery(): [0.11 ms] SELECT COUNT(content_image.ID) FROM content_image, content_image_i18n WHERE content_image.CONTENT_ID=1125 AND content_image_i18n.VALID=1 AND content_image_i18n.CULTURE='it_IT' AND content_image.ID=content_image_i18n.ID |
| 267 | Creole | prepareStatement(): SELECT COUNT(contentcategory.ID) FROM (contentcategory, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_i18n.ID |
| 268 | Creole | executeQuery(): [0.13 ms] SELECT COUNT(contentcategory.ID) FROM (contentcategory, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_i18n.ID |
| 269 | Creole | prepareStatement(): SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=? |
| 270 | Creole | executeQuery(): [0.43 ms] SELECT content.ID, content.IS_COMERCIAL, content.DURATION, content.IS_LIVE, content.IS_FRONTEND, content.VIDEOFORMAT_ID, content.SHOW_RATING, content.SHOW_COMMENTS, content.SHOW_BOOKMARKS, content.SHOW_INDEX, content.SHOW_EXTERN_LINKS, content.SHOW_TELL_A_FRIEND, content.SHOW_FILES, content.SHOW_IMAGES, content.SHOW_CREDITS, content.SHOW_EMBED, content.SHOW_LINK, content.IS_PAY_PER_VIEW, content.FRONTEND_USER_ID, content.WRITER_ID, content.CONTENT_OWNER_ID, content.EXTERN_CONTENT_ID, content.STRING_ID, content.SHOW_ON_BACKEND, content.VIEWS, content.PARENT_CONTENT_ID, content.START_TIME, content.END_TIME, content.USE_DEFAULT_PLAYER_OPTIONS, content.SHOW_CHAPTERS, content.NICKNAME, content.ORIGINAL_CONTENT_ID, content.OVERLAY_AD_ZONE_ID, content.INLINE_AD_ZONE_ID, content.CITY_ID, content.PLAYER_LOGO_ID, content.ALBUM_ID, content.ARTIST_ID, content.SEASON_ID, content.HOME_TEAM_ID, content.AWAY_TEAM_ID, content.RESULT, content.GAME_SERIE_ID, content.GAME_ROUND_ID, content.SCORERS FROM content WHERE content.ID=1125 |
| 271 | Creole | prepareStatement(): SELECT COUNT(content_has_content.ID) FROM content_has_content WHERE content_has_content.CONTENT1_ID=? |
| 272 | Creole | executeQuery(): [0.13 ms] SELECT COUNT(content_has_content.ID) FROM content_has_content WHERE content_has_content.CONTENT1_ID=1125 |
vars & config
logs & msgs
111
9026.9 KB
336 ms
---
parameterHolder:
symfony/default:
CatId: 9
action: video_list
module: content
attributeHolder:
symfony/default:
tellContentID: 1125
---
cookies:
httpHeaders:
Content-Type: text/html; charset=utf-8
parameterHolder:
helper/asset/auto/httpmeta:
Content-Type: text/html; charset=utf-8
helper/asset/auto/javascript:
/sf/prototype/js/prototype: /sf/prototype/js/prototype
/sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
helper/asset/auto/meta:
description: K.iTV, Internet Television
dottv: Softing (http://www.eu-softing.com)
keywords: K.iTV, Internet, Television
robots: index, follow
title: K.iTV 2.0
helper/asset/auto/stylesheet:
/sf/sf_web_debug/css/main:
symfony/response/http/headers:
Content-Type: text/html; charset=utf-8
symfony/view/asset:
javascripts_included:
stylesheets_included:
---
app_sfCaptchaGDPlugin_routes_register:
dottv2_common_cookie_domain:
dottv2_hash_key_iv: abc123+=
dottv2_hash_key_secret: >
Softing d.o.o. secret key for hashkey
algo
dottv_adserver_config_dir: >
http://static004.ksoft.tv/production.giocodigitale/openx/ads-config/
dottv_designer_css_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/css/
dottv_designer_flash_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/flash/
dottv_designer_image_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/images/
dottv_designer_js_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/js/
dottv_designer_min_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/min/
dottv_designer_silverlight_dir: /theme/giocco_digitale_3/silverlight/
dottv_designer_template_dir: >
/var/www/vcms/giocodigitale/web/theme/giocco_digitale_3/templates
dottv_designer_theme: giocco_digitale_3
dottv_designer_xml_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/xml/
dottv_openx_dir: >
http://static004.ksoft.tv/production.giocodigitale/openx/
dottv_sponsors_upload_dir: >
http://static004.ksoft.tv/production.giocodigitale/uploads/sponsors/
enable_multiple_login: 1
enable_packages:
error_404_url: http://www.pokerdigitale.it/blog/error
i_am_live_report_frequency: 86400
kitv_external_autentication_class: GiocoAuth
kitv_search_on_whole_words: 1
kitv_static_webroot: >
http://static004.ksoft.tv/production.giocodigitale
mobile_dns_names:
tv.pokerdigitale.it: iphone.gdpoker.ksoft.tv
tv.gdpoker.it: iphone.gdpoker.ksoft.tv
tv.giocodigitale.it: iphone.gdpoker.ksoft.tv
staging.giocodigitale.ksoft.tv: iphone.giocodigitale.ksoft.tv
mod_content_enabled: 1
mod_content_is_internal:
mod_content_view_class: my
mod_contentcategory_enabled: 1
mod_contentcategory_is_internal:
mod_contentcategory_view_class: my
openx_conf:
server_url: http://openx.ksoft.tv/
affiliate_id: 3
manager_username:
manager_password:
default_vod_overlay_zone: 8
default_live_overlay_zone: 6
default_vod_inline_zone: 0
default_live_inline_zone: 0
paypal_ipn_notify_email: mujo.kodro@eu-softing.com
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
/var/www/vcms/giocodigitale/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
/var/www/vcms/giocodigitale/apps/frontend
sf_app_i18n_dir: >
/var/www/vcms/giocodigitale/web/theme/giocco_digitale_3/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
/var/www/vcms/giocodigitale/apps/frontend/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: >
/var/www/vcms/giocodigitale/apps/frontend/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: >
/var/www/vcms/giocodigitale/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_asx_dir: >
/var/www/vcms/giocodigitale/web/uploads/asx
sf_asx_dir_name: asx
sf_autoloading_functions:
sf_available: 1
sf_backend_dns_name: tv.gdpoker.it
sf_backend_menu:
-
group_title: Home
group_items:
-
title: Frontpage
module: frontpage
action: list
-
group_title: Content Statistics
group_items:
-
title: Content library
module: content_library_stats
action: list
-
title: Most viewed contents
module: content_library_stats
action: mostview
-
group_title: Vod
group_items:
-
title: Media Contents
module: content
action: list
-
title: VOD Channels
module: contentcategory
action: list
-
title: Playlists
module: playlist
action: list
-
title: Authors
module: author
action: list
-
title: Thumbnails
module: thumbnail
action: list
-
title: Artists
module: writer
action: list
-
title: Tags
module: tag
action: list
-
title: Players
module: videoplayer
action: list
-
title: Player Logos
module: player_logo
action: list
-
group_title: Playout
group_items:
-
title: Live Channel WM
module: livechannel
action: list
-
title: Live Playlist FLV
module: live_playlist
action: list
-
title: Live Broadcast Messages
module: livemessage
action: list
-
group_title: Advertising
group_items:
-
title: Video Ads
module: comercial
action: list
-
title: Banners
module: sponsor
action: list
-
group_title: Interactivity
group_items:
-
title: Comments
module: comment
action: list
-
title: Polls
module: poll
action: list
-
title: RSS Ticker
module: scroll
action: list
-
title: Static Pages
module: staticpage
action: list
-
title: Bookmark and Share
module: bookmark_and_share
action: list
-
title: Press Release
module: pressrelease
action: list
-
group_title: Subscribers
group_items:
-
title: Registred Users
module: frontend_user
action: list
-
title: User Groups Administration
module: frontendusergroup
action: list
-
title: Subscritpion Packages
module: package
action: list
-
title: Subscritpion Packages PPV content
module: package_contentcategory_has_content
action: list
-
title: Mailing List
module: maillist
action: list
-
group_title: Podcast
group_items:
-
title: Podcast
module: podcast
action: list
-
group_title: Ugc
group_items:
-
title: User Generated Content
module: usergeneratedcontent
action: list
-
group_title: Syndication
group_items:
-
title: Content Syndication Center
module: contentsyndicationcenter
action: list
-
title: Syndacation Clients
module: syndication_client
action: list
-
title: Syndication Messages
module: syndication_messages
action: list
-
group_title: K.iTV SETUP MENU
group_items:
-
group_title: Administrators
group_items:
-
title: Users
module: user
action: list
-
title: Roles
module: role
action: list
-
group_title: Cdn
group_items:
-
title: Webservers
module: webserver
action: list
-
title: Streamingservers
module: streamingserver
action: list
-
title: Countries
module: country
action: list
-
title: Streaming Server Type
module: streamingservertype
action: list
-
title: Storage Servers
module: dataserver
action: list
-
title: Podcast Storage
module: podcast_storage
action: list
-
group_title: Transcoding
group_items:
-
title: Transcoder Server
module: transcoderserver
action: list
-
title: Transcoder Profile
module: transcoderprofile
action: list
-
title: Transcoder Tasks
module: transcodertask
action: list
-
title: Watch Folders
module: watchfolder
action: list
-
title: Watch Folder Transcoding Task
module: watchfoldertranscodingtask
action: list
-
title: UGC Generate Config
module: usergenerateconfig
action: list
-
group_title: Interactivity Modules Setup
group_items:
-
title: Extern Link Type
module: externlink_type
action: list
-
group_title: K.iTV Layout
group_items:
-
title: Template Engine
module: cctheme
action: list
-
group_title: Multilanguage Configuration
group_items:
-
title: Language
module: language
action: list
-
title: Backend Languages
module: languagebackend
action: list
-
group_title: VOD Configuration
group_items:
-
title: Media Edition
module: mediaedition
action: list
-
title: Media Type
module: mediafiletype
action: list
-
title: Media Aspect Ratio
module: videoformats
action: list
-
group_title: Debug
group_items:
-
title: Error Logs
module: sfErrorLog
action: list
-
title: FFmpeg Logs
module: ffmpeglog
action: list
-
group_title: Affiliate
group_items:
-
title: Affilate users
module: affiliate_user
action: list
-
title: Payment invoices
module: affiliate_invoice
action: list
-
title: Statistics
module: affiliate_statistics
action: >
index?filters[day]=&filters[mounth]=&filters[year]=0&filters[show_visits]=1&filters[show_registered]=1&filters[show_transactions]=1&filters[show_percentage_profit]=1&filter=filter
-
title: Configurator
module: affiliate_config
action: list
sf_backend_script_name: /backend.php
sf_backend_webroot: http://tv.gdpoker.it
sf_base_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend
sf_bibliographies_dir_name: bibliographies
sf_bin_dir: /var/www/vcms/giocodigitale/batch
sf_bin_dir_name: batch
sf_cache:
sf_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock:
sf_check_symfony_version:
sf_compressed:
sf_config_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/config
sf_config_dir: /var/www/vcms/giocodigitale/config
sf_config_dir_name: config
sf_content_images_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/content_images/
sf_credits_dir_name: credits
sf_data_dir: /var/www/vcms/giocodigitale/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_cache_lifetime: 31536000
sf_default_module: default
sf_doc_dir: /var/www/vcms/giocodigitale/data/doc
sf_doc_dir_name: doc
sf_enabled_modules:
- default
- sfCaptchaGD
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: frontpage
sf_error_log_mail: production@eu-softing.com
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag:
sf_feed_no_download_link: true
sf_files_dir: >
/var/www/vcms/giocodigitale/web/uploads/files
sf_files_dir_name: files
sf_i18n: 1
sf_i18n_cache: 1
sf_i18n_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/i18n/web/theme/giocco_digitale_3
sf_i18n_debug:
sf_i18n_default_culture: it_IT
sf_i18n_source: XLIFF
sf_i18n_untranslated_prefix: [T]
sf_i18n_untranslated_suffix: [/T]
sf_interactivity_modules:
poll: Polls
podcast: Podcasts
search: Search
videogallery: Video gallery
sf_lib_dir: /var/www/vcms/giocodigitale/lib
sf_lib_dir_name: lib
sf_log_dir: /var/www/vcms/giocodigitale/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate:
sf_login_action: login
sf_login_module: frontend_user
sf_max_forwards: 5
sf_menu:
- Content Modules
- Syndication
- Addin Modules
- CDN Modules
- Setup Modules
sf_model_dir: /var/www/vcms/giocodigitale/lib/model
sf_model_dir_name: model
sf_model_lib_dir: /var/www/vcms/giocodigitale/lib/model
sf_module_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/modules
sf_module_dirs:
/var/www/vcms/giocodigitale/cache/frontend/dev/modules: 1
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name:
sf_orm: propel
sf_password_recovery_mail: info@tv.gdpoker.it
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_player_logo_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/player_logo/
sf_plugins_dir: /var/www/vcms/giocodigitale/plugins
sf_plugins_dir_name: plugins
sf_podcast_files: /uploads/podcast_files/
sf_poll_images_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/poll_images/
sf_pool_upload_dir: >
/var/www/vcms/giocodigitale/web/uploads/poll_images
sf_pool_upload_dir_name: uploads/poll_images
sf_preloader_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/preloader_files/
sf_preloaders_dir: >
/var/www/vcms/giocodigitale/web/uploads/preloader_files
sf_preloaders_dir_name: preloader_files
sf_pressrelease_dir_webroot: /uploads/press_release
sf_prototype_web_dir: /sf/prototype
sf_reg_noti_mail: users@tv.gdpoker.it
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /var/www/vcms/giocodigitale/cache
sf_root_dir: /var/www/vcms/giocodigitale
sf_routing_defaults:
sf_culture: it_IT
sf_saleitem_dir_name: saleitems_files
sf_secure_action: secure
sf_secure_module: default
sf_sponsor_dir_name: sponsors
sf_standard_helpers:
- Partial
- Cache
- Form
sf_stats:
sf_strip_comments: 1
sf_subtitles_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/subtitles/
sf_suffix: .
sf_symfony_data_dir: /var/www/vcms/giocodigitale/data/symfony
sf_symfony_lib_dir: /var/www/vcms/giocodigitale/lib/symfony
sf_temp_dir: /var/www/vcms/giocodigitale/web/temp/
sf_temp_gen_thumbs: temp/gen_thumbs/
sf_temp_web_root: http://tv.gdpoker.it/temp/
sf_template_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/template
sf_test:
sf_test_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/test
sf_test_dir: /var/www/vcms/giocodigitale/test
sf_test_dir_name: test
sf_theme_dir: /var/www/vcms/giocodigitale/web/theme
sf_thumbnails_dir: >
/var/www/vcms/giocodigitale/web/uploads/thumbnails
sf_thumbnails_dir_name: thumbnails
sf_thumbnails_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/thumbnails/
sf_timeout: 86400
sf_timer_start: 1283794012.32
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /var/www/vcms/giocodigitale/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:
sf_validation_error_suffix:
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/vcms/giocodigitale/web
sf_web_dir_name: web
sf_wsx_dir: /var/www/vcms/giocodigitale/data/wsx
supervisor_syndicate_contents:
tv_use_wmv:
---
cookie:
dottv2frontend: 325112a3db0491d6ab096e6d1bc3a8aa
env:
LANG: C
PATH: /usr/local/bin:/usr/bin:/bin
PWD: /root
SHLVL: 1
_: /usr/sbin/apache2
files:
get:
post:
server:
DOCUMENT_ROOT: /var/www/vcms/giocodigitale/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: >
text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING: gzip
HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
HTTP_CACHE_CONTROL: no-cache
HTTP_CONNECTION: close
HTTP_COOKIE: >
dottv2frontend=325112a3db0491d6ab096e6d1bc3a8aa
HTTP_HOST: tv.gdpoker.it
HTTP_PRAGMA: no-cache
HTTP_USER_AGENT: >
CCBot/1.0
(+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID: ccc02-01
PATH: /usr/local/bin:/usr/bin:/bin
PATH_INFO: /content/video_list/CatId/9
PATH_TRANSLATED: redirect:/index.php/video_list/CatId/9
PHP_SELF: >
/frontend_dev.php/content/video_list/CatId/9
QUERY_STRING:
REMOTE_ADDR: 38.107.191.92
REMOTE_PORT: 23943
REQUEST_METHOD: GET
REQUEST_TIME: 1283794012
REQUEST_URI: >
/frontend_dev.php/content/video_list/CatId/9
SCRIPT_FILENAME: >
/var/www/vcms/giocodigitale/web/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 94.75.214.154
SERVER_ADMIN: m.panc@ksoft.tv
SERVER_NAME: tv.gdpoker.it
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: |
<address>Apache/2.2.3 (Debian) PHP/5.2.0-8+etch15 Server at tv.gdpoker.it Port 80</address>
SERVER_SOFTWARE: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch15
UNIQUE_ID: lhG8zF5L1poAACG6kDcAAAAL
argc: 0
argv:
session:
symfony/user/sfUser/attributes:
tv.gdpoker.it:
webserver_id: 1
default_culture: it_IT
it_IT:
theme: giocco_digitale_3
symfony/user/sfUser/attributes:
frontend_culture: it_IT
category_id: 14
category_selected_id: 14
content_show: 1
symfony/user/sfUser/authenticated:
symfony/user/sfUser/credentials:
symfony/user/sfUser/culture: it_IT
symfony/user/sfUser/lastRequest: 1283793913
--- php: 5.2.0-8+etch15 os: > Linux DIN004 2.6.18-6-686 #1 SMP Fri Dec 12 16:48:28 UTC 2008 i686 extensions: - zip - xmlwriter - libxml - xml - wddx - tokenizer - sysvshm - sysvsem - sysvmsg - session - SimpleXML - sockets - soap - SPL - shmop - standard - Reflection - posix - mime_magic - mbstring - json - iconv - hash - gettext - ftp - filter - exif - dom - dba - date - ctype - calendar - bz2 - bcmath - zlib - pcre - openssl - xmlreader - apache2handler - uploadprogress - curl - eAccelerator - gd - mysql - mysqli - PDO - pdo_mysql
| type | calls | time (ms) |
|---|---|---|
| Configuration | 16 | 3.28 |
| Action "content/video_list" | 1 | 22.00 |
| Database | 111 | 20.67 |
| View "Success" for "content/video_list" | 1 | 208.60 |
| Partial "content/_list_controls" | 1 | 8.93 |
| Component "contentcategory/inlineList" | 1 | 5.87 |
| Partial "contentcategory/_inlineList" | 1 | 44.35 |
| Component "contentcategory/subcategory" | 1 | 3.81 |
| Partial "contentcategory/_subcategory" | 1 | 0.41 |
| Component "content/show" | 1 | 42.46 |
| Partial "content/_show" | 1 | 22.51 |
| Partial "content/_flvshow" | 1 | 17.95 |
| Component "content/details" | 1 | 22.64 |
| Partial "content/_details" | 1 | 6.50 |