Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.alt AS alt_4,
  t0.position AS position_5,
  t0.activated AS activated_6,
  t0.description AS description_7,
  t0.image_id AS image_id_8,
  t9.name AS name_10,
  t9.description AS description_11,
  t9.enabled AS enabled_12,
  t9.provider_name AS provider_name_13,
  t9.provider_status AS provider_status_14,
  t9.provider_reference AS provider_reference_15,
  t9.provider_metadata AS provider_metadata_16,
  t9.width AS width_17,
  t9.height AS height_18,
  t9.length AS length_19,
  t9.content_type AS content_type_20,
  t9.content_size AS content_size_21,
  t9.copyright AS copyright_22,
  t9.author_name AS author_name_23,
  t9.context AS context_24,
  t9.cdn_is_flushable AS cdn_is_flushable_25,
  t9.cdn_flush_identifier AS cdn_flush_identifier_26,
  t9.cdn_flush_at AS cdn_flush_at_27,
  t9.cdn_status AS cdn_status_28,
  t9.updated_at AS updated_at_29,
  t9.created_at AS created_at_30,
  t9.id AS id_31
FROM
  program_category t0
  LEFT JOIN media__media t9 ON t0.image_id = t9.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.alt AS alt_4, t0.position AS position_5, t0.activated AS activated_6, t0.description AS description_7, t0.image_id AS image_id_8, t9.name AS name_10, t9.description AS description_11, t9.enabled AS enabled_12, t9.provider_name AS provider_name_13, t9.provider_status AS provider_status_14, t9.provider_reference AS provider_reference_15, t9.provider_metadata AS provider_metadata_16, t9.width AS width_17, t9.height AS height_18, t9.length AS length_19, t9.content_type AS content_type_20, t9.content_size AS content_size_21, t9.copyright AS copyright_22, t9.author_name AS author_name_23, t9.context AS context_24, t9.cdn_is_flushable AS cdn_is_flushable_25, t9.cdn_flush_identifier AS cdn_flush_identifier_26, t9.cdn_flush_at AS cdn_flush_at_27, t9.cdn_status AS cdn_status_28, t9.updated_at AS updated_at_29, t9.created_at AS created_at_30, t9.id AS id_31 FROM program_category t0 LEFT JOIN media__media t9 ON t0.image_id = t9.id WHERE t0.slug = 'categorie-test' LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  program p0_
  INNER JOIN media__media m1_ ON p0_.image_id = m1_.id
  LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM program p0_ INNER JOIN media__media m1_ ON p0_.image_id = m1_.id LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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);

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.broadcast_at AS broadcast_at_1
FROM
  program p0_
  INNER JOIN media__media m1_ ON p0_.image_id = m1_.id
  LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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
  8

SELECT DISTINCT p0_.id AS id_0, p0_.broadcast_at AS broadcast_at_1 FROM program p0_ INNER JOIN media__media m1_ ON p0_.image_id = m1_.id LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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 8;

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,
  p2_.id AS id_46,
  p2_.slug AS slug_47,
  p2_.name AS name_48,
  p2_.alt AS alt_49,
  p2_.position AS position_50,
  p2_.activated AS activated_51,
  p2_.description AS description_52,
  p0_.category_id AS category_id_53,
  p0_.image_id AS image_id_54,
  p0_.user_id AS user_id_55,
  p0_.product_image_id AS product_image_id_56,
  p2_.image_id AS image_id_57
FROM
  program p0_
  INNER JOIN media__media m1_ ON p0_.image_id = m1_.id
  LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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
  )
  AND p0_.id IN (?)
ORDER BY
  p0_.broadcast_at DESC

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, p2_.id AS id_46, p2_.slug AS slug_47, p2_.name AS name_48, p2_.alt AS alt_49, p2_.position AS position_50, p2_.activated AS activated_51, p2_.description AS description_52, p0_.category_id AS category_id_53, p0_.image_id AS image_id_54, p0_.user_id AS user_id_55, p0_.product_image_id AS product_image_id_56, p2_.image_id AS image_id_57 FROM program p0_ INNER JOIN media__media m1_ ON p0_.image_id = m1_.id LEFT JOIN program_category p2_ ON p0_.category_id = p2_.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) AND p0_.id IN (17) ORDER BY p0_.broadcast_at DESC;

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;