Symfony Profiler

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 = ?
    )
  )

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 (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) AND p5_.product_id = 9118 AND a4_.language IN ('nor') AND p8_.id = 5 AND a1_.extension NOT IN ('zip', 'tif', 'tiff')) 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 = 5 AND p12_.product_id = 9118 AND a11_.extension NOT IN ('zip', 'tif', 'tiff'))) 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 = 'asset_content_type' AND LOWER(c22_.name) IN ('added-value', 'billingblock', 'biography-cv', 'cast-crew', 'copyright-line', 'credits-start-end', 'credits-end', 'credits-start', 'photo-credit', 'press-release-dvd') AND p19_.product_id = 9118 AND p23_.id = 5)) 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 = 5) WHERE s31_.series_id = 4 AND p27_.product_id <> 9118 AND p27_.published = 1));

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 = ?

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 = 9119;

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 = ?

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 = 243;

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

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 = 'nor' 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 = 5 AND s12_.series_id = 4)) AND p7_.id = 5 ORDER BY sclr_1 ASC, sclr_0 ASC, v2_.id ASC;

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

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 = 5 AND p0_.region = 'header' AND p1_.language_code = 'no' AND p1_.slug IS NOT NULL;

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 = ?

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 = 'he-proxied.dev.nordiskfilm.com' AND t0.enabled = 1;

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 = ?

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 = 157;

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

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM classification__category c0_ WHERE c0_.context = 'asset_content_type' AND c0_.enabled = 1 AND c0_.name IN ('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') ORDER BY c0_.name ASC;

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 (?)

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 = 9118 AND n0_.country = 'NO' AND n0_.release_date IS NOT NULL AND c1_.nav_code IN ('DVD', 'BLURAY', 'EST', 'TVOD');