Symfony Profiler

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

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 = 55)) AND p7_.id = 5 ORDER BY sclr_1 ASC, sclr_0 ASC, v2_.id ASC;

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
  t1.product_id AS product_id_2,
  t1.drupal_nid AS drupal_nid_3,
  t1.display_title AS display_title_4,
  t1.box AS box_5,
  t1.num_of_discs_in_dvd AS num_of_discs_in_dvd_6,
  t1.num_of_discs_in_bluray AS num_of_discs_in_bluray_7,
  t1.rights_comment AS rights_comment_8,
  t1.duration_24fps AS duration_24fps_9,
  t1.duration_25fps AS duration_25fps_10,
  t1.available_in_color AS available_in_color_11,
  t1.resolution AS resolution_12,
  t1.available_in_3d AS available_in_3d_13,
  t1.production_year AS production_year_14,
  t1.norwegian_media_authority_id AS norwegian_media_authority_id_15,
  t1.eidr AS eidr_16,
  t1.imdb_id AS imdb_id_17,
  t1.isan AS isan_18,
  t1.release_date_tba AS release_date_tba_19,
  t1.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_20,
  t1.published AS published_21,
  t1.tv_sales_comment AS tv_sales_comment_22,
  t1.nearline_asset_movie_format AS nearline_asset_movie_format_23,
  t1.nearline_asset_trailer_format AS nearline_asset_trailer_format_24,
  t1.copyright_line AS copyright_line_25,
  t1.release_date_sweden_tba AS release_date_sweden_tba_26,
  t1.release_date_sweden AS release_date_sweden_27,
  t1.release_date_he_dk_tba AS release_date_he_dk_tba_28,
  t1.release_date_he_se_tba AS release_date_he_se_tba_29,
  t1.release_date_he_no_tba AS release_date_he_no_tba_30,
  t1.release_date_he_fi_tba AS release_date_he_fi_tba_31,
  t1.created_at AS created_at_32,
  t1.updated_at AS updated_at_33,
  t0.tv_series_type AS tv_series_type_34,
  t0.episodes_number AS episodes_number_35,
  t0.season_no AS season_no_36,
  t1.copyright_owner AS copyright_owner_37,
  t1.aspect_ratio_id AS aspect_ratio_id_38,
  t1.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_39,
  t1.primary_nav_title_id AS primary_nav_title_id_40,
  t1.original_image_id AS original_image_id_41,
  t1.created_by AS created_by_42,
  t1.release_date_sweden_edited_by AS release_date_sweden_edited_by_43,
  t0.series_id AS series_id_44,
  t1.product_type
FROM
  product_tvseries t0
  INNER JOIN product t1 ON t0.product_id = t1.product_id
WHERE
  t1.product_id = ?

SELECT t1.product_id AS product_id_2, t1.drupal_nid AS drupal_nid_3, t1.display_title AS display_title_4, t1.box AS box_5, t1.num_of_discs_in_dvd AS num_of_discs_in_dvd_6, t1.num_of_discs_in_bluray AS num_of_discs_in_bluray_7, t1.rights_comment AS rights_comment_8, t1.duration_24fps AS duration_24fps_9, t1.duration_25fps AS duration_25fps_10, t1.available_in_color AS available_in_color_11, t1.resolution AS resolution_12, t1.available_in_3d AS available_in_3d_13, t1.production_year AS production_year_14, t1.norwegian_media_authority_id AS norwegian_media_authority_id_15, t1.eidr AS eidr_16, t1.imdb_id AS imdb_id_17, t1.isan AS isan_18, t1.release_date_tba AS release_date_tba_19, t1.release_date_overwrite_theatrical_date AS release_date_overwrite_theatrical_date_20, t1.published AS published_21, t1.tv_sales_comment AS tv_sales_comment_22, t1.nearline_asset_movie_format AS nearline_asset_movie_format_23, t1.nearline_asset_trailer_format AS nearline_asset_trailer_format_24, t1.copyright_line AS copyright_line_25, t1.release_date_sweden_tba AS release_date_sweden_tba_26, t1.release_date_sweden AS release_date_sweden_27, t1.release_date_he_dk_tba AS release_date_he_dk_tba_28, t1.release_date_he_se_tba AS release_date_he_se_tba_29, t1.release_date_he_no_tba AS release_date_he_no_tba_30, t1.release_date_he_fi_tba AS release_date_he_fi_tba_31, t1.created_at AS created_at_32, t1.updated_at AS updated_at_33, t0.tv_series_type AS tv_series_type_34, t0.episodes_number AS episodes_number_35, t0.season_no AS season_no_36, t1.copyright_owner AS copyright_owner_37, t1.aspect_ratio_id AS aspect_ratio_id_38, t1.release_date_overwrite_theatrical_date_edited_by AS release_date_overwrite_theatrical_date_edited_by_39, t1.primary_nav_title_id AS primary_nav_title_id_40, t1.original_image_id AS original_image_id_41, t1.created_by AS created_by_42, t1.release_date_sweden_edited_by AS release_date_sweden_edited_by_43, t0.series_id AS series_id_44, t1.product_type FROM product_tvseries t0 INNER JOIN product t1 ON t0.product_id = t1.product_id WHERE t1.product_id = 682;