https://he.dev.nordiskfilm.com/fi/movies/8022

Query Metrics

34 Database Queries
23 Different statements
2125.54 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2072.75 ms
(97.52%)
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 = ?)) OR (a0_.asset_id IN (SELECT a25_.asset_id FROM product_tvseries p26_ INNER JOIN product p27_ ON p26_.product_id = p27_.product_id INNER JOIN asset a25_ ON p27_.product_id = a25_.product_id LEFT JOIN asset_online a28_ ON a25_.asset_id = a28_.asset_id LEFT JOIN asset_nearline a29_ ON a25_.asset_id = a29_.asset_id LEFT JOIN asset_offline a30_ ON a25_.asset_id = a30_.asset_id INNER JOIN series s31_ ON p26_.series_id = s31_.series_id INNER JOIN (asset_online a32_ INNER JOIN asset a33_ ON a32_.asset_id = a33_.asset_id) ON (a25_.asset_id = a33_.asset_id) INNER JOIN asset_online_domains a35_ ON a32_.asset_id = a35_.asset_id INNER JOIN press_sites_domains p34_ ON p34_.id = a35_.domain_id AND (p34_.id = ?) WHERE s31_.series_id = ? AND p27_.product_id <> ? AND p27_.published = ?))
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
  ]
  8022
  [
    "fin"
  ]
  6
  [
    "zip"
    "tif"
    "tiff"
  ]
  6
  8022
  [
    "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"
  ]
  8022
  6
  6
  50
  8022
  1
]
7.27 ms
(0.34%)
5
SELECT t0.product_id AS product_id_3, t0.drupal_nid AS drupal_nid_4, t0.display_title AS display_title_5, t0.box AS box_6, t0.num_of_discs_in_dvd AS num_of_discs_in_dvd_7, t0.num_of_discs_in_bluray AS num_of_discs_in_bluray_8, t0.rights_comment AS rights_comment_9, t0.duration_24fps AS duration_24fps_10, t0.duration_25fps AS duration_25fps_11, t0.available_in_color AS available_in_color_12, t0.resolution AS resolution_13, t0.available_in_3d AS available_in_3d_14, t0.production_year AS production_year_15, t0.norwegian_media_authority_id AS norwegian_media_authority_id_16, t0.eidr AS eidr_17, t0.imdb_id AS imdb_id_18, t0.isan AS isan_19, t0.release_date_tba AS release_date_tba_20, t0.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_21, t0.published AS published_22, t0.tv_sales_comment AS tv_sales_comment_23, t0.nearline_asset_movie_format AS nearline_asset_movie_format_24, t0.nearline_asset_trailer_format AS nearline_asset_trailer_format_25, t0.copyright_line AS copyright_line_26, t0.release_date_sweden_tba AS release_date_sweden_tba_27, t0.release_date_sweden AS release_date_sweden_28, t0.release_date_he_dk_tba AS release_date_he_dk_tba_29, t0.release_date_he_se_tba AS release_date_he_se_tba_30, t0.release_date_he_no_tba AS release_date_he_no_tba_31, t0.release_date_he_fi_tba AS release_date_he_fi_tba_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.copyright_owner AS copyright_owner_35, t0.aspect_ratio_id AS aspect_ratio_id_36, t0.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_37, t0.primary_nav_title_id AS primary_nav_title_id_38, t0.original_image_id AS original_image_id_39, t0.created_by AS created_by_40, t0.release_date_sweden_edited_by AS release_date_sweden_edited_by_41, t0.product_type, t2.tv_series_type AS tv_series_type_42, t2.episodes_number AS episodes_number_43, t2.season_no AS season_no_44, t2.series_id AS series_id_45 FROM product t0 LEFT JOIN product_movie t1 ON t0.product_id = t1.product_id LEFT JOIN product_tvseries t2 ON t0.product_id = t2.product_id WHERE t0.product_id = ?
Parameters:
[
  7981
]
5.18 ms
(0.24%)
4
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:
[
  14008
]
5.10 ms
(0.24%)
1
SELECT ABS(v0_.episode_number) AS sclr_0, ABS(v0_.season_number) AS sclr_1, v0_.id AS id_2, v0_.drupal_nid AS drupal_nid_3, v0_.extended_nav_code AS extended_nav_code_4, v0_.title_no AS title_no_5, v0_.extended_title AS extended_title_6, v0_.original_title AS original_title_7, v0_.department_code AS department_code_8, v0_.language AS language_9, v0_.duration AS duration_10, v0_.season_number AS season_number_11, v0_.episode_number AS episode_number_12, v0_.category_type AS category_type_13, v0_.expire_date AS expire_date_14, v0_.excluded_itunes AS excluded_itunes_15, v0_.excluded_all AS excluded_all_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, v1_.id AS id_19, v1_.language AS language_20, v1_.export_approved AS export_approved_21, v1_.download_available AS download_available_22, v1_.subtitles_not_required AS subtitles_not_required_23, v1_.linear_content AS linear_content_24, v1_.required_subtitles AS required_subtitles_25, v1_.local_title AS local_title_26, v1_.series_name AS series_name_27, v1_.series_text AS series_text_28, v1_.short_synopsis AS short_synopsis_29, v1_.long_synopsis AS long_synopsis_30, v1_.season_text AS season_text_31, v1_.approved_at AS approved_at_32, v2_.id AS id_33, v2_.format AS format_34, v3_.id AS id_35, v3_.drupal_nid AS drupal_nid_36, v3_.created_at AS created_at_37, v3_.updated_at AS updated_at_38, v0_.aspect_ratio_id AS aspect_ratio_id_39, v0_.product_id AS product_id_40, v1_.vod_title_id AS vod_title_id_41, v1_.approved_by_id AS approved_by_id_42, v2_.title_id AS title_id_43, v3_.title_id AS title_id_44 FROM vod_titles v0_ INNER JOIN product p4_ ON v0_.product_id = p4_.product_id LEFT JOIN product_movie p5_ ON p4_.product_id = p5_.product_id LEFT JOIN product_tvseries p6_ ON p4_.product_id = p6_.product_id LEFT JOIN vod_title_localized_texts v1_ ON v0_.id = v1_.vod_title_id INNER JOIN vod_title_media_formats v2_ ON v0_.id = v2_.title_id LEFT JOIN vod_dp_movie v3_ ON v0_.id = v3_.title_id INNER JOIN product_domains p8_ ON p4_.product_id = p8_.product_id INNER JOIN press_sites_domains p7_ ON p7_.id = p8_.domain_id WHERE v0_.language = ? AND (v0_.id IN (SELECT v9_.id FROM product_tvseries p10_ INNER JOIN product p11_ ON p10_.product_id = p11_.product_id INNER JOIN vod_titles v9_ ON p11_.product_id = v9_.product_id INNER JOIN series s12_ ON p10_.series_id = s12_.series_id INNER JOIN product_domains p14_ ON p11_.product_id = p14_.product_id INNER JOIN press_sites_domains p13_ ON p13_.id = p14_.domain_id WHERE p13_.id = ? AND s12_.series_id = ?)) AND p7_.id = ? ORDER BY sclr_1 ASC, sclr_0 ASC, v2_.id ASC
Parameters:
[
  "fin"
  6
  50
  6
]
4.26 ms
(0.20%)
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:
[
  241
]
3.61 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:
[
  6
  "header"
  "fi"
]
2.85 ms
(0.13%)
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
]
2.13 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.91 ms
(0.09%)
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:
[
  8022
]
1.78 ms
(0.08%)
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:
[
  8022
  6
  "fi"
]
1.74 ms
(0.08%)
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:
[
  8022
  "FI"
  [
    "DVD"
    "BLURAY"
    "EST"
    "TVOD"
  ]
]
1.71 ms
(0.08%)
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:
[
  8022
]
1.49 ms
(0.07%)
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:
[
  8022
]
1.45 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:
[
  8022
]
1.40 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:
[
  143320
]
1.40 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:
[
  8022
]
1.39 ms
(0.07%)
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:
[
  8022
]
1.39 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:
[
  8022
]
1.39 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:
[
  130120
]
1.35 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:
[
  8022
]
1.34 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:
[
  8022
]
1.34 ms
(0.06%)
1
SELECT t0.series_id AS series_id_1, t0.display_title AS display_title_2, t0.original_language AS original_language_3 FROM series t0 WHERE t0.series_id = ?
Parameters:
[
  50
]
1.32 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:
[
  8022
]

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\SeriesGenre No errors.
App\Entity\SeriesLocalizedText No errors.
App\Entity\SeriesImage 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.
App\Entity\AssetNearline No errors.
App\Entity\AssetOffline No errors.