Symfony Profiler

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.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
  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,
  p3_.id AS id_35,
  p3_.language AS language_36,
  p3_.local_title AS local_title_37,
  p3_.working_title AS working_title_38,
  p3_.synopsis_home_entertainment AS synopsis_home_entertainment_39,
  p3_.synopsis_theatrical AS synopsis_theatrical_40,
  p3_.season_text AS season_text_41,
  p3_.series_text AS series_text_42,
  p3_.series_name AS series_name_43,
  p4_.id AS id_44,
  p4_.country AS country_45,
  p0_.product_type AS product_type_46,
  p0_.copyright_owner AS copyright_owner_47,
  p0_.aspect_ratio_id AS aspect_ratio_id_48,
  p0_.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_49,
  p0_.primary_nav_title_id AS primary_nav_title_id_50,
  p0_.original_image_id AS original_image_id_51,
  p0_.created_by AS created_by_52,
  p0_.release_date_sweden_edited_by AS release_date_sweden_edited_by_53,
  p2_.series_id AS series_id_54,
  p3_.product_id AS product_id_55,
  p4_.product_id AS product_id_56,
  p4_.asset_online_id AS asset_online_id_57
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_release_dates p5_ ON p0_.product_id = p5_.product_id
  AND (p5_.domain_id = ?)
  INNER JOIN product_domains p7_ ON p0_.product_id = p7_.product_id
  INNER JOIN press_sites_domains p6_ ON p6_.id = p7_.domain_id
  INNER JOIN product_localized_text p3_ ON p0_.product_id = p3_.product_id
  AND (p3_.language = ?)
  LEFT JOIN product_primary_nf_video_image p4_ ON p0_.product_id = p4_.product_id
  AND (p4_.country = 'DK')
WHERE
  p0_.published = ?
  AND p5_.release_date IS NOT NULL
  AND (
    p5_.release_date BETWEEN ?
    AND ?
  )
GROUP BY
  p0_.product_id
ORDER BY
  p5_.release_date DESC,
  p4_.country ASC
LIMIT
  5

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, p3_.id AS id_35, p3_.language AS language_36, p3_.local_title AS local_title_37, p3_.working_title AS working_title_38, p3_.synopsis_home_entertainment AS synopsis_home_entertainment_39, p3_.synopsis_theatrical AS synopsis_theatrical_40, p3_.season_text AS season_text_41, p3_.series_text AS series_text_42, p3_.series_name AS series_name_43, p4_.id AS id_44, p4_.country AS country_45, p0_.product_type AS product_type_46, p0_.copyright_owner AS copyright_owner_47, p0_.aspect_ratio_id AS aspect_ratio_id_48, p0_.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_49, p0_.primary_nav_title_id AS primary_nav_title_id_50, p0_.original_image_id AS original_image_id_51, p0_.created_by AS created_by_52, p0_.release_date_sweden_edited_by AS release_date_sweden_edited_by_53, p2_.series_id AS series_id_54, p3_.product_id AS product_id_55, p4_.product_id AS product_id_56, p4_.asset_online_id AS asset_online_id_57 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_release_dates p5_ ON p0_.product_id = p5_.product_id AND (p5_.domain_id = 3) INNER JOIN product_domains p7_ ON p0_.product_id = p7_.product_id INNER JOIN press_sites_domains p6_ ON p6_.id = p7_.domain_id INNER JOIN product_localized_text p3_ ON p0_.product_id = p3_.product_id AND (p3_.language = 'da') LEFT JOIN product_primary_nf_video_image p4_ ON p0_.product_id = p4_.product_id AND (p4_.country = 'DK') WHERE p0_.published = 1 AND p5_.release_date IS NOT NULL AND (p5_.release_date BETWEEN '2024-04-02' AND '2024-07-02') GROUP BY p0_.product_id ORDER BY p5_.release_date DESC, p4_.country ASC LIMIT 5;

SELECT
  (
    CASE WHEN p0_.release_date_tba = 1 THEN 1 ELSE 0 END
  ) AS sclr_0,
  p0_.product_id AS product_id_1,
  p0_.drupal_nid AS drupal_nid_2,
  p0_.display_title AS display_title_3,
  p0_.box AS box_4,
  p0_.num_of_discs_in_dvd AS num_of_discs_in_dvd_5,
  p0_.num_of_discs_in_bluray AS num_of_discs_in_bluray_6,
  p0_.rights_comment AS rights_comment_7,
  p0_.duration_24fps AS duration_24fps_8,
  p0_.duration_25fps AS duration_25fps_9,
  p0_.available_in_color AS available_in_color_10,
  p0_.resolution AS resolution_11,
  p0_.available_in_3d AS available_in_3d_12,
  p0_.production_year AS production_year_13,
  p0_.norwegian_media_authority_id AS norwegian_media_authority_id_14,
  p0_.eidr AS eidr_15,
  p0_.imdb_id AS imdb_id_16,
  p0_.isan AS isan_17,
  p0_.release_date_tba AS release_date_tba_18,
  p0_.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_19,
  p0_.published AS published_20,
  p0_.tv_sales_comment AS tv_sales_comment_21,
  p0_.nearline_asset_movie_format AS nearline_asset_movie_format_22,
  p0_.nearline_asset_trailer_format AS nearline_asset_trailer_format_23,
  p0_.copyright_line AS copyright_line_24,
  p0_.release_date_sweden_tba AS release_date_sweden_tba_25,
  p0_.release_date_sweden AS release_date_sweden_26,
  p0_.release_date_he_dk_tba AS release_date_he_dk_tba_27,
  p0_.release_date_he_se_tba AS release_date_he_se_tba_28,
  p0_.release_date_he_no_tba AS release_date_he_no_tba_29,
  p0_.release_date_he_fi_tba AS release_date_he_fi_tba_30,
  p0_.created_at AS created_at_31,
  p0_.updated_at AS updated_at_32,
  p2_.tv_series_type AS tv_series_type_33,
  p2_.episodes_number AS episodes_number_34,
  p2_.season_no AS season_no_35,
  p3_.id AS id_36,
  p3_.language AS language_37,
  p3_.local_title AS local_title_38,
  p3_.working_title AS working_title_39,
  p3_.synopsis_home_entertainment AS synopsis_home_entertainment_40,
  p3_.synopsis_theatrical AS synopsis_theatrical_41,
  p3_.season_text AS season_text_42,
  p3_.series_text AS series_text_43,
  p3_.series_name AS series_name_44,
  p4_.id AS id_45,
  p4_.country AS country_46,
  p0_.product_type AS product_type_47,
  p0_.copyright_owner AS copyright_owner_48,
  p0_.aspect_ratio_id AS aspect_ratio_id_49,
  p0_.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_50,
  p0_.primary_nav_title_id AS primary_nav_title_id_51,
  p0_.original_image_id AS original_image_id_52,
  p0_.created_by AS created_by_53,
  p0_.release_date_sweden_edited_by AS release_date_sweden_edited_by_54,
  p2_.series_id AS series_id_55,
  p3_.product_id AS product_id_56,
  p4_.product_id AS product_id_57,
  p4_.asset_online_id AS asset_online_id_58
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_release_dates p5_ ON p0_.product_id = p5_.product_id
  AND (p5_.domain_id = ?)
  INNER JOIN product_domains p7_ ON p0_.product_id = p7_.product_id
  INNER JOIN press_sites_domains p6_ ON p6_.id = p7_.domain_id
  INNER JOIN product_localized_text p3_ ON p0_.product_id = p3_.product_id
  AND (p3_.language = ?)
  LEFT JOIN product_primary_nf_video_image p4_ ON p0_.product_id = p4_.product_id
  AND (p4_.country = 'DK')
WHERE
  p0_.published = ?
  AND p5_.release_date IS NOT NULL
  AND (
    p5_.release_date BETWEEN ?
    AND ?
  )
GROUP BY
  p0_.product_id
ORDER BY
  sclr_0 ASC,
  p5_.release_date ASC,
  p4_.country ASC
LIMIT
  5

SELECT (CASE WHEN p0_.release_date_tba = 1 THEN 1 ELSE 0 END) AS sclr_0, p0_.product_id AS product_id_1, p0_.drupal_nid AS drupal_nid_2, p0_.display_title AS display_title_3, p0_.box AS box_4, p0_.num_of_discs_in_dvd AS num_of_discs_in_dvd_5, p0_.num_of_discs_in_bluray AS num_of_discs_in_bluray_6, p0_.rights_comment AS rights_comment_7, p0_.duration_24fps AS duration_24fps_8, p0_.duration_25fps AS duration_25fps_9, p0_.available_in_color AS available_in_color_10, p0_.resolution AS resolution_11, p0_.available_in_3d AS available_in_3d_12, p0_.production_year AS production_year_13, p0_.norwegian_media_authority_id AS norwegian_media_authority_id_14, p0_.eidr AS eidr_15, p0_.imdb_id AS imdb_id_16, p0_.isan AS isan_17, p0_.release_date_tba AS release_date_tba_18, p0_.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_19, p0_.published AS published_20, p0_.tv_sales_comment AS tv_sales_comment_21, p0_.nearline_asset_movie_format AS nearline_asset_movie_format_22, p0_.nearline_asset_trailer_format AS nearline_asset_trailer_format_23, p0_.copyright_line AS copyright_line_24, p0_.release_date_sweden_tba AS release_date_sweden_tba_25, p0_.release_date_sweden AS release_date_sweden_26, p0_.release_date_he_dk_tba AS release_date_he_dk_tba_27, p0_.release_date_he_se_tba AS release_date_he_se_tba_28, p0_.release_date_he_no_tba AS release_date_he_no_tba_29, p0_.release_date_he_fi_tba AS release_date_he_fi_tba_30, p0_.created_at AS created_at_31, p0_.updated_at AS updated_at_32, p2_.tv_series_type AS tv_series_type_33, p2_.episodes_number AS episodes_number_34, p2_.season_no AS season_no_35, p3_.id AS id_36, p3_.language AS language_37, p3_.local_title AS local_title_38, p3_.working_title AS working_title_39, p3_.synopsis_home_entertainment AS synopsis_home_entertainment_40, p3_.synopsis_theatrical AS synopsis_theatrical_41, p3_.season_text AS season_text_42, p3_.series_text AS series_text_43, p3_.series_name AS series_name_44, p4_.id AS id_45, p4_.country AS country_46, p0_.product_type AS product_type_47, p0_.copyright_owner AS copyright_owner_48, p0_.aspect_ratio_id AS aspect_ratio_id_49, p0_.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_50, p0_.primary_nav_title_id AS primary_nav_title_id_51, p0_.original_image_id AS original_image_id_52, p0_.created_by AS created_by_53, p0_.release_date_sweden_edited_by AS release_date_sweden_edited_by_54, p2_.series_id AS series_id_55, p3_.product_id AS product_id_56, p4_.product_id AS product_id_57, p4_.asset_online_id AS asset_online_id_58 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_release_dates p5_ ON p0_.product_id = p5_.product_id AND (p5_.domain_id = 3) INNER JOIN product_domains p7_ ON p0_.product_id = p7_.product_id INNER JOIN press_sites_domains p6_ ON p6_.id = p7_.domain_id INNER JOIN product_localized_text p3_ ON p0_.product_id = p3_.product_id AND (p3_.language = 'da') LEFT JOIN product_primary_nf_video_image p4_ ON p0_.product_id = p4_.product_id AND (p4_.country = 'DK') WHERE p0_.published = 1 AND p5_.release_date IS NOT NULL AND (p5_.release_date BETWEEN '2024-07-02' AND '2025-07-02') GROUP BY p0_.product_id ORDER BY sclr_0 ASC, p5_.release_date ASC, p4_.country ASC LIMIT 5;

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

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

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

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

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

SELECT
  t0.id AS id_1,
  t0.release_date AS release_date_2,
  t0.all_release_dates AS all_release_dates_3,
  t0.product_id AS product_id_4,
  t0.domain_id AS domain_id_5,
  t0.item_window_id AS item_window_id_6,
  t0.item_format_id AS item_format_id_7
FROM
  product_release_dates t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.release_date AS release_date_2, t0.all_release_dates AS all_release_dates_3, t0.product_id AS product_id_4, t0.domain_id AS domain_id_5, t0.item_window_id AS item_window_id_6, t0.item_format_id AS item_format_id_7 FROM product_release_dates t0 WHERE t0.product_id = 10241;

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

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

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

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

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

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

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

SELECT
  t0.id AS id_1,
  t0.release_date AS release_date_2,
  t0.all_release_dates AS all_release_dates_3,
  t0.product_id AS product_id_4,
  t0.domain_id AS domain_id_5,
  t0.item_window_id AS item_window_id_6,
  t0.item_format_id AS item_format_id_7
FROM
  product_release_dates t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.release_date AS release_date_2, t0.all_release_dates AS all_release_dates_3, t0.product_id AS product_id_4, t0.domain_id AS domain_id_5, t0.item_window_id AS item_window_id_6, t0.item_format_id AS item_format_id_7 FROM product_release_dates t0 WHERE t0.product_id = 10180;

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

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

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

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

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