Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.name AS name_2,
  p0_.alt AS alt_3,
  p0_.position AS position_4,
  p0_.activated AS activated_5,
  p0_.description AS description_6,
  p0_.image_id AS image_id_7
FROM
  program_category p0_
  INNER JOIN media__media m1_ ON p0_.image_id = m1_.id
WHERE
  p0_.activated = 1
  AND EXISTS (
    SELECT
      p2_.id
    FROM
      program p2_
    WHERE
      p2_.category_id = p0_.id
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.alt AS alt_3, p0_.position AS position_4, p0_.activated AS activated_5, p0_.description AS description_6, p0_.image_id AS image_id_7 FROM program_category p0_ INNER JOIN media__media m1_ ON p0_.image_id = m1_.id WHERE p0_.activated = 1 AND EXISTS (SELECT p2_.id FROM program p2_ WHERE p2_.category_id = p0_.id) ORDER BY p0_.position ASC;

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.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id IN (?)

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.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id IN (5);

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.title AS title_2,
  p0_.broadcast_at AS broadcast_at_3,
  p0_.youtube AS youtube_4,
  p0_.dailymotion AS dailymotion_5,
  p0_.vimeo AS vimeo_6,
  p0_.description AS description_7,
  p0_.current_provider AS current_provider_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.iframe AS iframe_11,
  p0_.iframe2 AS iframe2_12,
  p0_.playlist_monday AS playlist_monday_13,
  p0_.playlist_tuesday AS playlist_tuesday_14,
  p0_.playlist_wednesday AS playlist_wednesday_15,
  p0_.playlist_thursday AS playlist_thursday_16,
  p0_.playlist_friday AS playlist_friday_17,
  p0_.playlist_saturday AS playlist_saturday_18,
  p0_.playlist_sunday AS playlist_sunday_19,
  p0_.playlist_recent_successes AS playlist_recent_successes_20,
  p0_.product_link AS product_link_21,
  p0_.product_text AS product_text_22,
  p0_.alt AS alt_23,
  m1_.name AS name_24,
  m1_.description AS description_25,
  m1_.enabled AS enabled_26,
  m1_.provider_name AS provider_name_27,
  m1_.provider_status AS provider_status_28,
  m1_.provider_reference AS provider_reference_29,
  m1_.provider_metadata AS provider_metadata_30,
  m1_.width AS width_31,
  m1_.height AS height_32,
  m1_.length AS length_33,
  m1_.content_type AS content_type_34,
  m1_.content_size AS content_size_35,
  m1_.copyright AS copyright_36,
  m1_.author_name AS author_name_37,
  m1_.context AS context_38,
  m1_.cdn_is_flushable AS cdn_is_flushable_39,
  m1_.cdn_flush_identifier AS cdn_flush_identifier_40,
  m1_.cdn_flush_at AS cdn_flush_at_41,
  m1_.cdn_status AS cdn_status_42,
  m1_.updated_at AS updated_at_43,
  m1_.created_at AS created_at_44,
  m1_.id AS id_45,
  p0_.category_id AS category_id_46,
  p0_.image_id AS image_id_47,
  p0_.user_id AS user_id_48,
  p0_.product_image_id AS product_image_id_49
FROM
  program p0_
  INNER JOIN media__media m1_ ON p0_.image_id = m1_.id
WHERE
  p0_.category_id = ?
  AND p0_.broadcast_at <= CURRENT_TIMESTAMP
  AND (
    p0_.youtube IS NOT NULL
    OR p0_.dailymotion IS NOT NULL
    OR p0_.vimeo IS NOT NULL
    OR p0_.iframe IS NOT NULL
    OR p0_.iframe2 IS NOT NULL
  )
ORDER BY
  p0_.broadcast_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.broadcast_at AS broadcast_at_3, p0_.youtube AS youtube_4, p0_.dailymotion AS dailymotion_5, p0_.vimeo AS vimeo_6, p0_.description AS description_7, p0_.current_provider AS current_provider_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.iframe AS iframe_11, p0_.iframe2 AS iframe2_12, p0_.playlist_monday AS playlist_monday_13, p0_.playlist_tuesday AS playlist_tuesday_14, p0_.playlist_wednesday AS playlist_wednesday_15, p0_.playlist_thursday AS playlist_thursday_16, p0_.playlist_friday AS playlist_friday_17, p0_.playlist_saturday AS playlist_saturday_18, p0_.playlist_sunday AS playlist_sunday_19, p0_.playlist_recent_successes AS playlist_recent_successes_20, p0_.product_link AS product_link_21, p0_.product_text AS product_text_22, p0_.alt AS alt_23, m1_.name AS name_24, m1_.description AS description_25, m1_.enabled AS enabled_26, m1_.provider_name AS provider_name_27, m1_.provider_status AS provider_status_28, m1_.provider_reference AS provider_reference_29, m1_.provider_metadata AS provider_metadata_30, m1_.width AS width_31, m1_.height AS height_32, m1_.length AS length_33, m1_.content_type AS content_type_34, m1_.content_size AS content_size_35, m1_.copyright AS copyright_36, m1_.author_name AS author_name_37, m1_.context AS context_38, m1_.cdn_is_flushable AS cdn_is_flushable_39, m1_.cdn_flush_identifier AS cdn_flush_identifier_40, m1_.cdn_flush_at AS cdn_flush_at_41, m1_.cdn_status AS cdn_status_42, m1_.updated_at AS updated_at_43, m1_.created_at AS created_at_44, m1_.id AS id_45, p0_.category_id AS category_id_46, p0_.image_id AS image_id_47, p0_.user_id AS user_id_48, p0_.product_image_id AS product_image_id_49 FROM program p0_ INNER JOIN media__media m1_ ON p0_.image_id = m1_.id WHERE p0_.category_id = 1 AND p0_.broadcast_at <= CURRENT_TIMESTAMP AND (p0_.youtube IS NOT NULL OR p0_.dailymotion IS NOT NULL OR p0_.vimeo IS NOT NULL OR p0_.iframe IS NOT NULL OR p0_.iframe2 IS NOT NULL) ORDER BY p0_.broadcast_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3
FROM
  parameter t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3 FROM parameter t0 WHERE t0.`key` = 'currentVideoProvider' LIMIT 1;