Query Metrics
29
Database Queries
20
Different statements
2139.10 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2085.93 ms (97.51%) |
1 |
SELECT a0_.asset_id AS asset_id_0, a0_.drupal_nid AS drupal_nid_1, a0_.display_title AS display_title_2, a0_.published AS published_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a1_.short_name AS short_name_6, a1_.identifier AS identifier_7, a1_.has_subtitles AS has_subtitles_8, a1_.subtitle_format AS subtitle_format_9, a1_.subtitle_type AS subtitle_type_10, a1_.item_no AS item_no_11, a1_.video_aspect_format AS video_aspect_format_12, a1_.video_frame_rate AS video_frame_rate_13, a1_.approved_for_external_use AS approved_for_external_use_14, a1_.primary_trailer AS primary_trailer_15, a1_.embedded_metadata AS embedded_metadata_16, a1_.copyright AS copyright_17, a1_.extension AS extension_18, c2_.name AS name_19, c2_.enabled AS enabled_20, c2_.slug AS slug_21, c2_.description AS description_22, c2_.position AS position_23, c2_.created_at AS created_at_24, c2_.updated_at AS updated_at_25, c2_.id AS id_26, c2_.nav_code AS nav_code_27, c2_.visible AS visible_28, c2_.operator_content_type AS operator_content_type_29, c2_.shown_in_filter AS shown_in_filter_30, m3_.name AS name_31, m3_.description AS description_32, m3_.enabled AS enabled_33, m3_.provider_name AS provider_name_34, m3_.provider_status AS provider_status_35, m3_.provider_reference AS provider_reference_36, m3_.provider_metadata AS provider_metadata_37, m3_.width AS width_38, m3_.height AS height_39, m3_.length AS length_40, m3_.content_type AS content_type_41, m3_.copyright AS copyright_42, m3_.author_name AS author_name_43, m3_.context AS context_44, m3_.cdn_is_flushable AS cdn_is_flushable_45, m3_.cdn_flush_identifier AS cdn_flush_identifier_46, m3_.cdn_flush_at AS cdn_flush_at_47, m3_.cdn_status AS cdn_status_48, m3_.updated_at AS updated_at_49, m3_.created_at AS created_at_50, m3_.id AS id_51, m3_.size AS size_52, m3_.content_size AS content_size_53, a4_.id AS id_54, a4_.language AS language_55, a0_.asset_type AS asset_type_56, a0_.product_id AS product_id_57, a0_.created_by AS created_by_58, a0_.updated_by AS updated_by_59, a1_.file_id AS file_id_60, a1_.asset_type_id AS asset_type_id_61, a1_.content_type_id AS content_type_id_62, a1_.video_resolution_aspect_id AS video_resolution_aspect_id_63, c2_.parent_id AS parent_id_64, c2_.context AS context_65, c2_.media_id AS media_id_66, a4_.asset_online_id AS asset_online_id_67 FROM asset_online a1_ INNER JOIN asset a0_ ON a1_.asset_id = a0_.asset_id INNER JOIN classification__category c2_ ON a1_.content_type_id = c2_.id INNER JOIN product p5_ ON a0_.product_id = p5_.product_id LEFT JOIN product_movie p6_ ON p5_.product_id = p6_.product_id LEFT JOIN product_tvseries p7_ ON p5_.product_id = p7_.product_id INNER JOIN media__media m3_ ON a1_.file_id = m3_.id LEFT JOIN asset_online_domains a9_ ON a1_.asset_id = a9_.asset_id LEFT JOIN press_sites_domains p8_ ON p8_.id = a9_.domain_id LEFT JOIN asset_online_language a4_ ON a1_.asset_id = a4_.asset_online_id WHERE (c2_.id IN (?) AND p5_.product_id = ? AND a4_.language IN (?) AND p8_.id = ? AND a1_.extension NOT IN (?)) OR (a0_.asset_id IN (SELECT a10_.asset_id FROM asset_online a11_ INNER JOIN asset a10_ ON a11_.asset_id = a10_.asset_id INNER JOIN product p12_ ON a10_.product_id = p12_.product_id LEFT JOIN product_movie p13_ ON p12_.product_id = p13_.product_id LEFT JOIN product_tvseries p14_ ON p12_.product_id = p14_.product_id INNER JOIN asset_online_domains a16_ ON a11_.asset_id = a16_.asset_id INNER JOIN press_sites_domains p15_ ON p15_.id = a16_.domain_id WHERE p15_.id = ? AND p12_.product_id = ? AND a11_.extension NOT IN (?))) OR (a0_.asset_id IN (SELECT a17_.asset_id FROM asset_online a18_ INNER JOIN asset a17_ ON a18_.asset_id = a17_.asset_id INNER JOIN product p19_ ON a17_.product_id = p19_.product_id LEFT JOIN product_movie p20_ ON p19_.product_id = p20_.product_id LEFT JOIN product_tvseries p21_ ON p19_.product_id = p21_.product_id INNER JOIN classification__category c22_ ON a18_.content_type_id = c22_.id INNER JOIN asset_online_domains a24_ ON a18_.asset_id = a24_.asset_id INNER JOIN press_sites_domains p23_ ON p23_.id = a24_.domain_id WHERE c22_.context = ? AND LOWER(c22_.name) IN (?) AND p19_.product_id = ? AND p23_.id = ?))
Parameters:
[ [ 472 574 576 580 586 542 546 567 626 317 384 389 623 380 591 420 533 485 476 482 474 475 478 508 501 490 481 480 ] 1548 [ "nor" ] 5 [ "zip" "tif" "tiff" ] 5 1548 [ "zip" "tif" "tiff" ] "asset_content_type" [ "added-value" "billingblock" "biography-cv" "cast-crew" "copyright-line" "credits-start-end" "credits-end" "credits-start" "photo-credit" "press-release-dvd" ] 1548 5 ] |
10.23 ms (0.48%) |
2 |
SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.display_title AS display_title_3, t0.default_language_code AS default_language_code_4, t0.language_code AS language_code_5, t0.site_type AS site_type_6, t0.date_format AS date_format_7, t0.enabled AS enabled_8, t0.drupal_ids AS drupal_ids_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM press_sites_domains t0 WHERE t0.hostname = ? AND t0.enabled = ?
Parameters:
[ "he-proxied.dev.nordiskfilm.com" 1 ] |
7.65 ms (0.36%) |
6 |
SELECT t0.person_id AS person_id_1, t0.display_title AS display_title_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.created_by AS created_by_5 FROM person t0 WHERE t0.person_id = ?
Parameters:
[
3835
]
|
6.66 ms (0.31%) |
1 |
SELECT p0_.product_id AS product_id_0, p0_.drupal_nid AS drupal_nid_1, p0_.display_title AS display_title_2, p0_.box AS box_3, p0_.num_of_discs_in_dvd AS num_of_discs_in_dvd_4, p0_.num_of_discs_in_bluray AS num_of_discs_in_bluray_5, p0_.rights_comment AS rights_comment_6, p0_.duration_24fps AS duration_24fps_7, p0_.duration_25fps AS duration_25fps_8, p0_.available_in_color AS available_in_color_9, p0_.resolution AS resolution_10, p0_.available_in_3d AS available_in_3d_11, p0_.production_year AS production_year_12, p0_.norwegian_media_authority_id AS norwegian_media_authority_id_13, p0_.eidr AS eidr_14, p0_.imdb_id AS imdb_id_15, p0_.isan AS isan_16, p0_.release_date_tba AS release_date_tba_17, p0_.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_18, p0_.published AS published_19, p0_.tv_sales_comment AS tv_sales_comment_20, p0_.nearline_asset_movie_format AS nearline_asset_movie_format_21, p0_.nearline_asset_trailer_format AS nearline_asset_trailer_format_22, p0_.copyright_line AS copyright_line_23, p0_.release_date_sweden_tba AS release_date_sweden_tba_24, p0_.release_date_sweden AS release_date_sweden_25, p0_.release_date_he_dk_tba AS release_date_he_dk_tba_26, p0_.release_date_he_se_tba AS release_date_he_se_tba_27, p0_.release_date_he_no_tba AS release_date_he_no_tba_28, p0_.release_date_he_fi_tba AS release_date_he_fi_tba_29, p0_.created_at AS created_at_30, p0_.updated_at AS updated_at_31, p2_.tv_series_type AS tv_series_type_32, p2_.episodes_number AS episodes_number_33, p2_.season_no AS season_no_34, p0_.product_type AS product_type_35, p0_.copyright_owner AS copyright_owner_36, p0_.aspect_ratio_id AS aspect_ratio_id_37, p0_.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_38, p0_.primary_nav_title_id AS primary_nav_title_id_39, p0_.original_image_id AS original_image_id_40, p0_.created_by AS created_by_41, p0_.release_date_sweden_edited_by AS release_date_sweden_edited_by_42, p2_.series_id AS series_id_43 FROM product p0_ LEFT JOIN product_movie p1_ ON p0_.product_id = p1_.product_id LEFT JOIN product_tvseries p2_ ON p0_.product_id = p2_.product_id INNER JOIN product_domains p4_ ON p0_.product_id = p4_.product_id INNER JOIN press_sites_domains p3_ ON p3_.id = p4_.domain_id WHERE p0_.product_id = ? AND p3_.id = ? AND p3_.language_code = ? LIMIT 1
Parameters:
[ 1548 5 "no" ] |
4.17 ms (0.19%) |
3 |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.description AS description_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.nav_code AS nav_code_9, t0.visible AS visible_10, t0.operator_content_type AS operator_content_type_11, t0.shown_in_filter AS shown_in_filter_12, t0.parent_id AS parent_id_13, t0.context AS context_14, t0.media_id AS media_id_15 FROM classification__category t0 WHERE t0.id = ?
Parameters:
[
243
]
|
3.57 ms (0.17%) |
2 |
SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.slug AS slug_2, p1_.content AS content_3, p1_.language_code AS language_code_4 FROM press_sites_pages p0_ INNER JOIN press_sites_pages_localization p1_ ON p0_.id = p1_.page_id INNER JOIN press_sites_pages_domains p3_ ON p0_.id = p3_.page_id INNER JOIN press_sites_domains p2_ ON p2_.id = p3_.domain_id WHERE p2_.id = ? AND p0_.region = ? AND p1_.language_code = ? AND p1_.slug IS NOT NULL
Parameters:
[ 5 "header" "no" ] |
2.09 ms (0.10%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1 FROM classification__category c0_ WHERE c0_.context = ? AND c0_.enabled = ? AND c0_.name IN (?) ORDER BY c0_.name ASC
Parameters:
[ "asset_content_type" 1 [ "cover-bd-vst-inlay" "cover-dvd-vst-inlay" "cover-pdf" "keyart" "vod-keyart-1400-2100" "vod-keyart-1400-2100-layer" "vod-keyart-720-1080" "vod-keyart-584-800" "vod-keyart-320-460" "vod-keyart-2000-2000" "vod-keyart-730-330" "vod-still-1920-1080-tt" "vod-background-1920-1080-notitle" "vod-horizontal-544-208" "vod-horizontal-1920-1080" "vod-horizontal-1920-1080-layer" "packshot-bd" "packshot-dvd" "pos-dvd" "poster-dvd" "still" "added-value" "billingblock" "biography-cv" "cast-crew" "copyright-line" "credits-start-end" "credits-end" "credits-start" "photo-credit" "press-release-dvd" ] ] |
1.85 ms (0.09%) |
1 |
SELECT n0_.item_id AS item_id_0, n0_.drupal_nid AS drupal_nid_1, n0_.display_title AS display_title_2, n0_.item_code AS item_code_3, n0_.company AS company_4, n0_.ean_code AS ean_code_5, n0_.description AS description_6, n0_.country AS country_7, n0_.release_date AS release_date_8, n0_.last_modified_date AS last_modified_date_9, n0_.sales_expire_date AS sales_expire_date_10, n0_.prod_expire_date AS prod_expire_date_11, n0_.department_code AS department_code_12, c1_.name AS name_13, c1_.enabled AS enabled_14, c1_.slug AS slug_15, c1_.description AS description_16, c1_.position AS position_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.id AS id_20, c1_.nav_code AS nav_code_21, c1_.visible AS visible_22, c1_.operator_content_type AS operator_content_type_23, c1_.shown_in_filter AS shown_in_filter_24, n0_.nav_title AS nav_title_25, n0_.item_window AS item_window_26, n0_.item_format AS item_format_27, n0_.last_modified_by AS last_modified_by_28, c1_.parent_id AS parent_id_29, c1_.context AS context_30, c1_.media_id AS media_id_31 FROM nav_item n0_ INNER JOIN nav_title n2_ ON n0_.nav_title = n2_.title_id INNER JOIN product p3_ ON n2_.product_id = p3_.product_id LEFT JOIN product_movie p4_ ON p3_.product_id = p4_.product_id LEFT JOIN product_tvseries p5_ ON p3_.product_id = p5_.product_id INNER JOIN classification__category c1_ ON n0_.item_format = c1_.id WHERE p3_.product_id = ? AND n0_.country = ? AND n0_.release_date IS NOT NULL AND c1_.nav_code IN (?)
Parameters:
[ 1548 "NO" [ "DVD" "BLURAY" "EST" "TVOD" ] ] |
1.57 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.display_title AS display_title_3, t0.default_language_code AS default_language_code_4, t0.language_code AS language_code_5, t0.site_type AS site_type_6, t0.date_format AS date_format_7, t0.enabled AS enabled_8, t0.drupal_ids AS drupal_ids_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM press_sites_domains t0 INNER JOIN product_domains ON t0.id = product_domains.domain_id WHERE product_domains.product_id = ?
Parameters:
[
1548
]
|
1.49 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.genre AS genre_2, t0.product_id AS product_id_3 FROM product_genre t0 WHERE t0.product_id = ?
Parameters:
[
1548
]
|
1.45 ms (0.07%) |
1 |
SELECT t1.asset_id AS asset_id_2, t1.drupal_nid AS drupal_nid_3, t1.display_title AS display_title_4, t1.published AS published_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.short_name AS short_name_8, t0.identifier AS identifier_9, t0.has_subtitles AS has_subtitles_10, t0.subtitle_format AS subtitle_format_11, t0.subtitle_type AS subtitle_type_12, t0.item_no AS item_no_13, t0.video_aspect_format AS video_aspect_format_14, t0.video_frame_rate AS video_frame_rate_15, t0.approved_for_external_use AS approved_for_external_use_16, t0.primary_trailer AS primary_trailer_17, t0.embedded_metadata AS embedded_metadata_18, t0.copyright AS copyright_19, t0.extension AS extension_20, t1.product_id AS product_id_21, t1.created_by AS created_by_22, t1.updated_by AS updated_by_23, t0.file_id AS file_id_24, t0.asset_type_id AS asset_type_id_25, t0.content_type_id AS content_type_id_26, t0.video_resolution_aspect_id AS video_resolution_aspect_id_27, t1.asset_type FROM asset_online t0 INNER JOIN asset t1 ON t0.asset_id = t1.asset_id WHERE t1.asset_id = ?
Parameters:
[
241504
]
|
1.43 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.weight AS weight_2, t0.`type` AS type_3, t0.product_id AS product_id_4, t0.person_id AS person_id_5, t0.company_id AS company_id_6 FROM product_crew t0 WHERE t0.product_id = ? ORDER BY t0.weight ASC
Parameters:
[
1548
]
|
1.43 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.content AS content_3, t0.rating AS rating_4, t0.rating_symbol AS rating_symbol_5, t0.product_id AS product_id_6 FROM product_censorship t0 WHERE t0.product_id = ?
Parameters:
[
1548
]
|
1.42 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.language AS language_2, t0.local_title AS local_title_3, t0.working_title AS working_title_4, t0.synopsis_home_entertainment AS synopsis_home_entertainment_5, t0.synopsis_theatrical AS synopsis_theatrical_6, t0.season_text AS season_text_7, t0.series_text AS series_text_8, t0.series_name AS series_name_9, t0.product_id AS product_id_10 FROM product_localized_text t0 WHERE t0.product_id = ?
Parameters:
[
1548
]
|
1.41 ms (0.07%) |
1 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.copyright AS copyright_12, t0.author_name AS author_name_13, t0.context AS context_14, t0.cdn_is_flushable AS cdn_is_flushable_15, t0.cdn_flush_identifier AS cdn_flush_identifier_16, t0.cdn_flush_at AS cdn_flush_at_17, t0.cdn_status AS cdn_status_18, t0.updated_at AS updated_at_19, t0.created_at AS created_at_20, t0.id AS id_21, t0.size AS size_22, t0.content_size AS content_size_23 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
228304
]
|
1.39 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.drupal_nid AS drupal_nid_2, t0.extended_nav_code AS extended_nav_code_3, t0.title_no AS title_no_4, t0.extended_title AS extended_title_5, t0.original_title AS original_title_6, t0.department_code AS department_code_7, t0.language AS language_8, t0.duration AS duration_9, t0.season_number AS season_number_10, t0.episode_number AS episode_number_11, t0.category_type AS category_type_12, t0.expire_date AS expire_date_13, t0.excluded_itunes AS excluded_itunes_14, t0.excluded_all AS excluded_all_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.aspect_ratio_id AS aspect_ratio_id_18, t19.id AS id_20, t19.drupal_nid AS drupal_nid_21, t19.created_at AS created_at_22, t19.updated_at AS updated_at_23, t19.title_id AS title_id_24, t0.product_id AS product_id_25 FROM vod_titles t0 LEFT JOIN vod_dp_movie t19 ON t19.title_id = t0.id WHERE t0.product_id = ?
Parameters:
[
1548
]
|
1.39 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.weight AS weight_2, t0.`character` AS character_3, t0.`type` AS type_4, t0.product_id AS product_id_5, t0.person_id AS person_id_6 FROM product_cast t0 WHERE t0.product_id = ? ORDER BY t0.weight ASC
Parameters:
[
1548
]
|
1.34 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.product_id AS product_id_3, t0.asset_online_id AS asset_online_id_4 FROM product_primary_nf_video_image t0 WHERE t0.product_id = ? ORDER BY t0.country ASC
Parameters:
[
1548
]
|
1.32 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.link_type AS link_type_2, t0.country AS country_3, t0.link_title AS link_title_4, t0.description AS description_5, t0.link_url AS link_url_6, t0.metadata AS metadata_7, t0.product_id AS product_id_8 FROM product_link t0 WHERE t0.product_id = ?
Parameters:
[
1548
]
|
1.31 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.product_id AS product_id_3 FROM product_production_country t0 WHERE t0.product_id = ?
Parameters:
[
1548
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\PressSite\DomainManager | No errors. |
Sonata\ClassificationBundle\Entity\BaseCategory | No errors. |
App\Entity\SonataClassificationCategory | No errors. |
App\Entity\Product | No errors. |
App\Entity\ProductMovie | No errors. |
App\Entity\ProductTVSeries | No errors. |
App\Entity\Company | No errors. |
Sonata\UserBundle\Entity\BaseUser | No errors. |
App\Entity\SonataAdminUser | No errors. |
App\Entity\NavTitle | No errors. |
App\Entity\Asset | No errors. |
App\Entity\AssetOnline | No errors. |
App\Entity\Series | No errors. |
App\Entity\ProductGenre | No errors. |
App\Entity\ProductSubtitle | No errors. |
App\Entity\ProductProductionCountry | No errors. |
App\Entity\ProductSpokenLanguage | No errors. |
App\Entity\ProductLocalizedText | No errors. |
App\Entity\ProductCensorship | No errors. |
App\Entity\ProductVideoInfo | No errors. |
App\Entity\ProductOriginalRelease | No errors. |
App\Entity\ProductLink | No errors. |
App\Entity\ProductAward | No errors. |
App\Entity\ProductAvailability | No errors. |
App\Entity\ProductCast | No errors. |
App\Entity\ProductCrew | No errors. |
App\Entity\ProductPrimaryTheatricalImage | No errors. |
App\Entity\ProductPrimaryNFVideoImage | No errors. |
App\Entity\ProductSalesCategory | No errors. |
App\Entity\VOD\Title | No errors. |
App\Entity\ProductReleaseDate | No errors. |
App\Entity\PressSite\PageManager | No errors. |
App\Entity\PressSite\PageManagerLocalization | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
App\Entity\SonataMediaMedia | No errors. |
App\Entity\AssetOnlineLanguage | No errors. |
App\Entity\AssetOnlineAudioLanguage | No errors. |
App\Entity\AssetOnlineMovieLanguage | No errors. |
App\Entity\AssetOnlineSubtitleLanguage | No errors. |
Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
App\Entity\SonataMediaGalleryItem | No errors. |
App\Entity\Person | No errors. |
App\Entity\PersonBiography | No errors. |
App\Entity\VOD\DPMovie | No errors. |
App\Entity\VOD\TitleReleaseDate | No errors. |
App\Entity\VOD\Order | No errors. |
App\Entity\VOD\TitleConsumerChannelLocalizedTexts | No errors. |
App\Entity\VOD\TitleLocalizedText | No errors. |
App\Entity\VOD\TitleMediaFormat | No errors. |
App\Entity\VOD\TitleItemNumber | No errors. |
App\Entity\VOD\TitleSvodOperatorDates | No errors. |
App\Entity\VOD\TitleExcludedOperator | No errors. |
App\Entity\VOD\TitleInitialPriceCategory | No errors. |
App\Entity\VOD\TitleEstInitialPriceCategory | No errors. |
App\Entity\VOD\TitleTvodInitialPriceCategory | No errors. |
App\Entity\VOD\TitleChapters | No errors. |
App\Entity\VOD\DPMovieDetail | No errors. |
App\Entity\NavItem | No errors. |
Sonata\ClassificationBundle\Entity\BaseContext | No errors. |
App\Entity\SonataClassificationContext | No errors. |