Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.display_order AS display_order_1,
  p1_.id AS id_2,
  p1_.slug AS slug_3,
  p1_.title AS title_4,
  p1_.broadcast_at AS broadcast_at_5,
  p1_.youtube AS youtube_6,
  p1_.dailymotion AS dailymotion_7,
  p1_.vimeo AS vimeo_8,
  p1_.description AS description_9,
  p1_.current_provider AS current_provider_10,
  p1_.created_at AS created_at_11,
  p1_.updated_at AS updated_at_12,
  p1_.iframe AS iframe_13,
  p1_.iframe2 AS iframe2_14,
  p1_.playlist_monday AS playlist_monday_15,
  p1_.playlist_tuesday AS playlist_tuesday_16,
  p1_.playlist_wednesday AS playlist_wednesday_17,
  p1_.playlist_thursday AS playlist_thursday_18,
  p1_.playlist_friday AS playlist_friday_19,
  p1_.playlist_saturday AS playlist_saturday_20,
  p1_.playlist_sunday AS playlist_sunday_21,
  p1_.playlist_recent_successes AS playlist_recent_successes_22,
  p1_.product_link AS product_link_23,
  p1_.product_text AS product_text_24,
  p1_.alt AS alt_25,
  m2_.name AS name_26,
  m2_.description AS description_27,
  m2_.enabled AS enabled_28,
  m2_.provider_name AS provider_name_29,
  m2_.provider_status AS provider_status_30,
  m2_.provider_reference AS provider_reference_31,
  m2_.provider_metadata AS provider_metadata_32,
  m2_.width AS width_33,
  m2_.height AS height_34,
  m2_.length AS length_35,
  m2_.content_type AS content_type_36,
  m2_.content_size AS content_size_37,
  m2_.copyright AS copyright_38,
  m2_.author_name AS author_name_39,
  m2_.context AS context_40,
  m2_.cdn_is_flushable AS cdn_is_flushable_41,
  m2_.cdn_flush_identifier AS cdn_flush_identifier_42,
  m2_.cdn_flush_at AS cdn_flush_at_43,
  m2_.cdn_status AS cdn_status_44,
  m2_.updated_at AS updated_at_45,
  m2_.created_at AS created_at_46,
  m2_.id AS id_47,
  r0_.program_id AS program_id_48,
  r0_.recent_success_collection_id AS recent_success_collection_id_49,
  p1_.category_id AS category_id_50,
  p1_.image_id AS image_id_51,
  p1_.user_id AS user_id_52,
  p1_.product_image_id AS product_image_id_53
FROM
  recent_success r0_
  INNER JOIN program p1_ ON r0_.program_id = p1_.id
  AND (
    (
      p1_.youtube IS NOT NULL
      OR p1_.dailymotion IS NOT NULL
      OR p1_.vimeo IS NOT NULL
      OR p1_.iframe IS NOT NULL
      OR p1_.iframe2 IS NOT NULL
    )
    AND p1_.broadcast_at <= CURRENT_TIMESTAMP
  )
  INNER JOIN media__media m2_ ON p1_.image_id = m2_.id
ORDER BY
  r0_.display_order ASC

SELECT r0_.id AS id_0, r0_.display_order AS display_order_1, p1_.id AS id_2, p1_.slug AS slug_3, p1_.title AS title_4, p1_.broadcast_at AS broadcast_at_5, p1_.youtube AS youtube_6, p1_.dailymotion AS dailymotion_7, p1_.vimeo AS vimeo_8, p1_.description AS description_9, p1_.current_provider AS current_provider_10, p1_.created_at AS created_at_11, p1_.updated_at AS updated_at_12, p1_.iframe AS iframe_13, p1_.iframe2 AS iframe2_14, p1_.playlist_monday AS playlist_monday_15, p1_.playlist_tuesday AS playlist_tuesday_16, p1_.playlist_wednesday AS playlist_wednesday_17, p1_.playlist_thursday AS playlist_thursday_18, p1_.playlist_friday AS playlist_friday_19, p1_.playlist_saturday AS playlist_saturday_20, p1_.playlist_sunday AS playlist_sunday_21, p1_.playlist_recent_successes AS playlist_recent_successes_22, p1_.product_link AS product_link_23, p1_.product_text AS product_text_24, p1_.alt AS alt_25, m2_.name AS name_26, m2_.description AS description_27, m2_.enabled AS enabled_28, m2_.provider_name AS provider_name_29, m2_.provider_status AS provider_status_30, m2_.provider_reference AS provider_reference_31, m2_.provider_metadata AS provider_metadata_32, m2_.width AS width_33, m2_.height AS height_34, m2_.length AS length_35, m2_.content_type AS content_type_36, m2_.content_size AS content_size_37, m2_.copyright AS copyright_38, m2_.author_name AS author_name_39, m2_.context AS context_40, m2_.cdn_is_flushable AS cdn_is_flushable_41, m2_.cdn_flush_identifier AS cdn_flush_identifier_42, m2_.cdn_flush_at AS cdn_flush_at_43, m2_.cdn_status AS cdn_status_44, m2_.updated_at AS updated_at_45, m2_.created_at AS created_at_46, m2_.id AS id_47, r0_.program_id AS program_id_48, r0_.recent_success_collection_id AS recent_success_collection_id_49, p1_.category_id AS category_id_50, p1_.image_id AS image_id_51, p1_.user_id AS user_id_52, p1_.product_image_id AS product_image_id_53 FROM recent_success r0_ INNER JOIN program p1_ ON r0_.program_id = p1_.id AND ((p1_.youtube IS NOT NULL OR p1_.dailymotion IS NOT NULL OR p1_.vimeo IS NOT NULL OR p1_.iframe IS NOT NULL OR p1_.iframe2 IS NOT NULL) AND p1_.broadcast_at <= CURRENT_TIMESTAMP) INNER JOIN media__media m2_ ON p1_.image_id = m2_.id ORDER BY r0_.display_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.activated AS activated_2,
  p0_.broadcast_at AS broadcast_at_3,
  p1_.id AS id_4,
  p1_.position AS position_5,
  p2_.id AS id_6,
  p2_.slug AS slug_7,
  p2_.title AS title_8,
  p2_.broadcast_at AS broadcast_at_9,
  p2_.youtube AS youtube_10,
  p2_.dailymotion AS dailymotion_11,
  p2_.vimeo AS vimeo_12,
  p2_.description AS description_13,
  p2_.current_provider AS current_provider_14,
  p2_.created_at AS created_at_15,
  p2_.updated_at AS updated_at_16,
  p2_.iframe AS iframe_17,
  p2_.iframe2 AS iframe2_18,
  p2_.playlist_monday AS playlist_monday_19,
  p2_.playlist_tuesday AS playlist_tuesday_20,
  p2_.playlist_wednesday AS playlist_wednesday_21,
  p2_.playlist_thursday AS playlist_thursday_22,
  p2_.playlist_friday AS playlist_friday_23,
  p2_.playlist_saturday AS playlist_saturday_24,
  p2_.playlist_sunday AS playlist_sunday_25,
  p2_.playlist_recent_successes AS playlist_recent_successes_26,
  p2_.product_link AS product_link_27,
  p2_.product_text AS product_text_28,
  p2_.alt AS alt_29,
  m3_.name AS name_30,
  m3_.description AS description_31,
  m3_.enabled AS enabled_32,
  m3_.provider_name AS provider_name_33,
  m3_.provider_status AS provider_status_34,
  m3_.provider_reference AS provider_reference_35,
  m3_.provider_metadata AS provider_metadata_36,
  m3_.width AS width_37,
  m3_.height AS height_38,
  m3_.length AS length_39,
  m3_.content_type AS content_type_40,
  m3_.content_size AS content_size_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,
  p1_.playlist_id AS playlist_id_52,
  p1_.video_id AS video_id_53,
  p2_.category_id AS category_id_54,
  p2_.image_id AS image_id_55,
  p2_.user_id AS user_id_56,
  p2_.product_image_id AS product_image_id_57
FROM
  playlist p0_
  INNER JOIN playlist_video p1_ ON p0_.id = p1_.playlist_id
  INNER JOIN program p2_ ON p1_.video_id = p2_.id
  AND (
    (
      p2_.youtube IS NOT NULL
      OR p2_.dailymotion IS NOT NULL
      OR p2_.vimeo IS NOT NULL
      OR p2_.iframe IS NOT NULL
      OR p2_.iframe2 IS NOT NULL
    )
    AND p2_.broadcast_at <= CURRENT_TIMESTAMP
  )
  INNER JOIN media__media m3_ ON p2_.image_id = m3_.id
WHERE
  p0_.activated = 1
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.activated AS activated_2, p0_.broadcast_at AS broadcast_at_3, p1_.id AS id_4, p1_.position AS position_5, p2_.id AS id_6, p2_.slug AS slug_7, p2_.title AS title_8, p2_.broadcast_at AS broadcast_at_9, p2_.youtube AS youtube_10, p2_.dailymotion AS dailymotion_11, p2_.vimeo AS vimeo_12, p2_.description AS description_13, p2_.current_provider AS current_provider_14, p2_.created_at AS created_at_15, p2_.updated_at AS updated_at_16, p2_.iframe AS iframe_17, p2_.iframe2 AS iframe2_18, p2_.playlist_monday AS playlist_monday_19, p2_.playlist_tuesday AS playlist_tuesday_20, p2_.playlist_wednesday AS playlist_wednesday_21, p2_.playlist_thursday AS playlist_thursday_22, p2_.playlist_friday AS playlist_friday_23, p2_.playlist_saturday AS playlist_saturday_24, p2_.playlist_sunday AS playlist_sunday_25, p2_.playlist_recent_successes AS playlist_recent_successes_26, p2_.product_link AS product_link_27, p2_.product_text AS product_text_28, p2_.alt AS alt_29, m3_.name AS name_30, m3_.description AS description_31, m3_.enabled AS enabled_32, m3_.provider_name AS provider_name_33, m3_.provider_status AS provider_status_34, m3_.provider_reference AS provider_reference_35, m3_.provider_metadata AS provider_metadata_36, m3_.width AS width_37, m3_.height AS height_38, m3_.length AS length_39, m3_.content_type AS content_type_40, m3_.content_size AS content_size_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, p1_.playlist_id AS playlist_id_52, p1_.video_id AS video_id_53, p2_.category_id AS category_id_54, p2_.image_id AS image_id_55, p2_.user_id AS user_id_56, p2_.product_image_id AS product_image_id_57 FROM playlist p0_ INNER JOIN playlist_video p1_ ON p0_.id = p1_.playlist_id INNER JOIN program p2_ ON p1_.video_id = p2_.id AND ((p2_.youtube IS NOT NULL OR p2_.dailymotion IS NOT NULL OR p2_.vimeo IS NOT NULL OR p2_.iframe IS NOT NULL OR p2_.iframe2 IS NOT NULL) AND p2_.broadcast_at <= CURRENT_TIMESTAMP) INNER JOIN media__media m3_ ON p2_.image_id = m3_.id WHERE p0_.activated = 1 ORDER BY p1_.position ASC;

SELECT
  a0_.id AS id_0,
  a0_.slug AS slug_1,
  a0_.title AS title_2,
  a0_.content AS content_3,
  a0_.alt AS alt_4,
  a0_.header_video AS header_video_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.status AS status_8,
  a0_.broadcast_at AS broadcast_at_9,
  m1_.name AS name_10,
  m1_.description AS description_11,
  m1_.enabled AS enabled_12,
  m1_.provider_name AS provider_name_13,
  m1_.provider_status AS provider_status_14,
  m1_.provider_reference AS provider_reference_15,
  m1_.provider_metadata AS provider_metadata_16,
  m1_.width AS width_17,
  m1_.height AS height_18,
  m1_.length AS length_19,
  m1_.content_type AS content_type_20,
  m1_.content_size AS content_size_21,
  m1_.copyright AS copyright_22,
  m1_.author_name AS author_name_23,
  m1_.context AS context_24,
  m1_.cdn_is_flushable AS cdn_is_flushable_25,
  m1_.cdn_flush_identifier AS cdn_flush_identifier_26,
  m1_.cdn_flush_at AS cdn_flush_at_27,
  m1_.cdn_status AS cdn_status_28,
  m1_.updated_at AS updated_at_29,
  m1_.created_at AS created_at_30,
  m1_.id AS id_31,
  a0_.header_image_id AS header_image_id_32,
  a0_.user_id AS user_id_33
FROM
  article a0_
  LEFT JOIN media__media m1_ ON a0_.header_image_id = m1_.id
WHERE
  a0_.status = ?
  AND (
    a0_.broadcast_at IS NULL
    OR a0_.broadcast_at <= CURRENT_TIMESTAMP
  )
ORDER BY
  a0_.created_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.content AS content_3, a0_.alt AS alt_4, a0_.header_video AS header_video_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.status AS status_8, a0_.broadcast_at AS broadcast_at_9, m1_.name AS name_10, m1_.description AS description_11, m1_.enabled AS enabled_12, m1_.provider_name AS provider_name_13, m1_.provider_status AS provider_status_14, m1_.provider_reference AS provider_reference_15, m1_.provider_metadata AS provider_metadata_16, m1_.width AS width_17, m1_.height AS height_18, m1_.length AS length_19, m1_.content_type AS content_type_20, m1_.content_size AS content_size_21, m1_.copyright AS copyright_22, m1_.author_name AS author_name_23, m1_.context AS context_24, m1_.cdn_is_flushable AS cdn_is_flushable_25, m1_.cdn_flush_identifier AS cdn_flush_identifier_26, m1_.cdn_flush_at AS cdn_flush_at_27, m1_.cdn_status AS cdn_status_28, m1_.updated_at AS updated_at_29, m1_.created_at AS created_at_30, m1_.id AS id_31, a0_.header_image_id AS header_image_id_32, a0_.user_id AS user_id_33 FROM article a0_ LEFT JOIN media__media m1_ ON a0_.header_image_id = m1_.id WHERE a0_.status = 1 AND (a0_.broadcast_at IS NULL OR a0_.broadcast_at <= CURRENT_TIMESTAMP) ORDER BY a0_.created_at DESC LIMIT 4;

SELECT
  y0_.id AS id_0,
  y0_.type AS type_1,
  p1_.id AS id_2,
  p1_.slug AS slug_3,
  p1_.title AS title_4,
  p1_.broadcast_at AS broadcast_at_5,
  p1_.youtube AS youtube_6,
  p1_.dailymotion AS dailymotion_7,
  p1_.vimeo AS vimeo_8,
  p1_.description AS description_9,
  p1_.current_provider AS current_provider_10,
  p1_.created_at AS created_at_11,
  p1_.updated_at AS updated_at_12,
  p1_.iframe AS iframe_13,
  p1_.iframe2 AS iframe2_14,
  p1_.playlist_monday AS playlist_monday_15,
  p1_.playlist_tuesday AS playlist_tuesday_16,
  p1_.playlist_wednesday AS playlist_wednesday_17,
  p1_.playlist_thursday AS playlist_thursday_18,
  p1_.playlist_friday AS playlist_friday_19,
  p1_.playlist_saturday AS playlist_saturday_20,
  p1_.playlist_sunday AS playlist_sunday_21,
  p1_.playlist_recent_successes AS playlist_recent_successes_22,
  p1_.product_link AS product_link_23,
  p1_.product_text AS product_text_24,
  p1_.alt AS alt_25,
  m2_.name AS name_26,
  m2_.description AS description_27,
  m2_.enabled AS enabled_28,
  m2_.provider_name AS provider_name_29,
  m2_.provider_status AS provider_status_30,
  m2_.provider_reference AS provider_reference_31,
  m2_.provider_metadata AS provider_metadata_32,
  m2_.width AS width_33,
  m2_.height AS height_34,
  m2_.length AS length_35,
  m2_.content_type AS content_type_36,
  m2_.content_size AS content_size_37,
  m2_.copyright AS copyright_38,
  m2_.author_name AS author_name_39,
  m2_.context AS context_40,
  m2_.cdn_is_flushable AS cdn_is_flushable_41,
  m2_.cdn_flush_identifier AS cdn_flush_identifier_42,
  m2_.cdn_flush_at AS cdn_flush_at_43,
  m2_.cdn_status AS cdn_status_44,
  m2_.updated_at AS updated_at_45,
  m2_.created_at AS created_at_46,
  m2_.id AS id_47,
  p3_.id AS id_48,
  p3_.slug AS slug_49,
  p3_.name AS name_50,
  p3_.alt AS alt_51,
  p3_.position AS position_52,
  p3_.activated AS activated_53,
  p3_.description AS description_54,
  y0_.program_id AS program_id_55,
  p1_.category_id AS category_id_56,
  p1_.image_id AS image_id_57,
  p1_.user_id AS user_id_58,
  p1_.product_image_id AS product_image_id_59,
  p3_.image_id AS image_id_60
FROM
  youtube_top y0_
  INNER JOIN program p1_ ON y0_.program_id = p1_.id
  INNER JOIN media__media m2_ ON p1_.image_id = m2_.id
  LEFT JOIN program_category p3_ ON p1_.category_id = p3_.id
WHERE
  y0_.type = ?
LIMIT
  4

SELECT y0_.id AS id_0, y0_.type AS type_1, p1_.id AS id_2, p1_.slug AS slug_3, p1_.title AS title_4, p1_.broadcast_at AS broadcast_at_5, p1_.youtube AS youtube_6, p1_.dailymotion AS dailymotion_7, p1_.vimeo AS vimeo_8, p1_.description AS description_9, p1_.current_provider AS current_provider_10, p1_.created_at AS created_at_11, p1_.updated_at AS updated_at_12, p1_.iframe AS iframe_13, p1_.iframe2 AS iframe2_14, p1_.playlist_monday AS playlist_monday_15, p1_.playlist_tuesday AS playlist_tuesday_16, p1_.playlist_wednesday AS playlist_wednesday_17, p1_.playlist_thursday AS playlist_thursday_18, p1_.playlist_friday AS playlist_friday_19, p1_.playlist_saturday AS playlist_saturday_20, p1_.playlist_sunday AS playlist_sunday_21, p1_.playlist_recent_successes AS playlist_recent_successes_22, p1_.product_link AS product_link_23, p1_.product_text AS product_text_24, p1_.alt AS alt_25, m2_.name AS name_26, m2_.description AS description_27, m2_.enabled AS enabled_28, m2_.provider_name AS provider_name_29, m2_.provider_status AS provider_status_30, m2_.provider_reference AS provider_reference_31, m2_.provider_metadata AS provider_metadata_32, m2_.width AS width_33, m2_.height AS height_34, m2_.length AS length_35, m2_.content_type AS content_type_36, m2_.content_size AS content_size_37, m2_.copyright AS copyright_38, m2_.author_name AS author_name_39, m2_.context AS context_40, m2_.cdn_is_flushable AS cdn_is_flushable_41, m2_.cdn_flush_identifier AS cdn_flush_identifier_42, m2_.cdn_flush_at AS cdn_flush_at_43, m2_.cdn_status AS cdn_status_44, m2_.updated_at AS updated_at_45, m2_.created_at AS created_at_46, m2_.id AS id_47, p3_.id AS id_48, p3_.slug AS slug_49, p3_.name AS name_50, p3_.alt AS alt_51, p3_.position AS position_52, p3_.activated AS activated_53, p3_.description AS description_54, y0_.program_id AS program_id_55, p1_.category_id AS category_id_56, p1_.image_id AS image_id_57, p1_.user_id AS user_id_58, p1_.product_image_id AS product_image_id_59, p3_.image_id AS image_id_60 FROM youtube_top y0_ INNER JOIN program p1_ ON y0_.program_id = p1_.id INNER JOIN media__media m2_ ON p1_.image_id = m2_.id LEFT JOIN program_category p3_ ON p1_.category_id = p3_.id WHERE y0_.type = 2 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;