Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.event_id AS event_id_7,
  t0.user_id AS user_id_8,
  t0.command_id AS command_id_9
FROM
  cart t0
WHERE
  (
    t0.user_id IN (?)
    OR t0.user_id IS NULL
  )
  AND t0.event_id IN (?)
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.description AS description_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.event_id AS event_id_7, t0.user_id AS user_id_8, t0.command_id AS command_id_9 FROM cart t0 WHERE (t0.user_id IN (NULL) OR t0.user_id IS NULL) AND t0.event_id IN (1) AND t0.status = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.civility AS civility_4,
  t0.complementary_infos AS complementary_infos_5,
  t0.portrait AS portrait_6,
  t0.social_media AS social_media_7,
  t0.deleted_at AS deleted_at_8
FROM
  person_of_interest t0
  INNER JOIN event_person_of_interest ON t0.id = event_person_of_interest.person_of_interest_id
WHERE
  event_person_of_interest.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.civility AS civility_4, t0.complementary_infos AS complementary_infos_5, t0.portrait AS portrait_6, t0.social_media AS social_media_7, t0.deleted_at AS deleted_at_8 FROM person_of_interest t0 INNER JOIN event_person_of_interest ON t0.id = event_person_of_interest.person_of_interest_id WHERE event_person_of_interest.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.public_title AS public_title_3,
  t0.type AS type_4,
  t0.is_global AS is_global_5,
  t0.position AS position_6,
  t0.status AS status_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  slider t0
  INNER JOIN event_slider ON t0.id = event_slider.slider_id
WHERE
  event_slider.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.public_title AS public_title_3, t0.type AS type_4, t0.is_global AS is_global_5, t0.position AS position_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM slider t0 INNER JOIN event_slider ON t0.id = event_slider.slider_id WHERE event_slider.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.url AS url_2,
  e0_.thumbnail AS thumbnail_3,
  e0_.cover AS cover_4,
  e0_.is_test_stream AS is_test_stream_5,
  e0_.place AS place_6,
  e0_.is_bloc AS is_bloc_7,
  e0_.is_presential AS is_presential_8,
  e0_.title AS title_9,
  e0_.description AS description_10,
  e0_.subtitle AS subtitle_11,
  e0_.created_at AS created_at_12,
  e0_.updated_at AS updated_at_13,
  e0_.deleted_at AS deleted_at_14,
  e0_.status AS status_15,
  e0_.start_date AS start_date_16,
  e0_.stop_date AS stop_date_17
FROM
  event e0_
  INNER JOIN program p1_ ON e0_.id = p1_.event_id
  AND (p1_.deleted_at IS NULL)
  INNER JOIN part_program p2_ ON p1_.id = p2_.program_id
  AND (p2_.deleted_at IS NULL)
  INNER JOIN content_part_part_program c4_ ON p2_.id = c4_.part_program_id
  INNER JOIN content_part c3_ ON c3_.id = c4_.content_part_id
  AND (c3_.deleted_at IS NULL)
WHERE
  (
    e0_.id = ?
    AND (
      c3_.replay_video_id IS NOT NULL
      OR c3_.replay_video_id <> ''
    )
  )
  AND (e0_.deleted_at IS NULL)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.url AS url_2, e0_.thumbnail AS thumbnail_3, e0_.cover AS cover_4, e0_.is_test_stream AS is_test_stream_5, e0_.place AS place_6, e0_.is_bloc AS is_bloc_7, e0_.is_presential AS is_presential_8, e0_.title AS title_9, e0_.description AS description_10, e0_.subtitle AS subtitle_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.deleted_at AS deleted_at_14, e0_.status AS status_15, e0_.start_date AS start_date_16, e0_.stop_date AS stop_date_17 FROM event e0_ INNER JOIN program p1_ ON e0_.id = p1_.event_id AND (p1_.deleted_at IS NULL) INNER JOIN part_program p2_ ON p1_.id = p2_.program_id AND (p2_.deleted_at IS NULL) INNER JOIN content_part_part_program c4_ ON p2_.id = c4_.part_program_id INNER JOIN content_part c3_ ON c3_.id = c4_.content_part_id AND (c3_.deleted_at IS NULL) WHERE (e0_.id = 1 AND (c3_.replay_video_id IS NOT NULL OR c3_.replay_video_id <> '')) AND (e0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.thumbnail AS thumbnail_4,
  t0.color AS color_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  tag t0
  INNER JOIN event_tag ON t0.id = event_tag.tag_id
WHERE
  event_tag.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.thumbnail AS thumbnail_4, t0.color AS color_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM tag t0 INNER JOIN event_tag ON t0.id = event_tag.tag_id WHERE event_tag.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.title AS title_1,
  t0.id AS id_2,
  t0.public_title AS public_title_3,
  t0.vimeo_id_video AS vimeo_id_video_4,
  t0.wowza_link_hls AS wowza_link_hls_5,
  t0.youtube_id_video AS youtube_id_video_6,
  t0.status AS status_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  room t0
  INNER JOIN event_room ON t0.id = event_room.room_id
WHERE
  event_room.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.title AS title_1, t0.id AS id_2, t0.public_title AS public_title_3, t0.vimeo_id_video AS vimeo_id_video_4, t0.wowza_link_hls AS wowza_link_hls_5, t0.youtube_id_video AS youtube_id_video_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM room t0 INNER JOIN event_room ON t0.id = event_room.room_id WHERE event_room.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.thumbnail AS thumbnail_2,
  t0.replay_video_id AS replay_video_id_3,
  t0.youtube_id_video AS youtube_id_video_4,
  t0.show_title AS show_title_5,
  t0.title AS title_6,
  t0.description AS description_7,
  t0.subtitle AS subtitle_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.event_id AS event_id_12
FROM
  bloc_replay t0
WHERE
  t0.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.replay_video_id AS replay_video_id_3, t0.youtube_id_video AS youtube_id_video_4, t0.show_title AS show_title_5, t0.title AS title_6, t0.description AS description_7, t0.subtitle AS subtitle_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.event_id AS event_id_12 FROM bloc_replay t0 WHERE t0.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.subtitle AS subtitle_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.start_date AS start_date_8,
  t0.stop_date AS stop_date_9,
  t0.event_id AS event_id_10,
  t0.room_id AS room_id_11
FROM
  program t0
WHERE
  t0.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.subtitle AS subtitle_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.start_date AS start_date_8, t0.stop_date AS stop_date_9, t0.event_id AS event_id_10, t0.room_id AS room_id_11 FROM program t0 WHERE t0.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.value AS value_3,
  t0.discount AS discount_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  price t0
  INNER JOIN event_price ON t0.id = event_price.price_id
WHERE
  event_price.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.discount AS discount_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM price t0 INNER JOIN event_price ON t0.id = event_price.price_id WHERE event_price.event_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.show_title AS show_title_2,
  t0.show_date AS show_date_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.subtitle AS subtitle_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.start_date AS start_date_10,
  t0.stop_date AS stop_date_11,
  t0.program_id AS program_id_12
FROM
  part_program t0
WHERE
  t0.program_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.show_title AS show_title_2, t0.show_date AS show_date_3, t0.title AS title_4, t0.description AS description_5, t0.subtitle AS subtitle_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.start_date AS start_date_10, t0.stop_date AS stop_date_11, t0.program_id AS program_id_12 FROM part_program t0 WHERE t0.program_id = 5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.thumbnail AS thumbnail_2,
  t0.replay_video_id AS replay_video_id_3,
  t0.show_title AS show_title_4,
  t0.show_date AS show_date_5,
  t0.wowza_link_hls AS wowza_link_hls_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.subtitle AS subtitle_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.start_date AS start_date_13,
  t0.stop_date AS stop_date_14
FROM
  content_part t0
  INNER JOIN content_part_part_program ON t0.id = content_part_part_program.content_part_id
WHERE
  content_part_part_program.part_program_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.replay_video_id AS replay_video_id_3, t0.show_title AS show_title_4, t0.show_date AS show_date_5, t0.wowza_link_hls AS wowza_link_hls_6, t0.title AS title_7, t0.description AS description_8, t0.subtitle AS subtitle_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.start_date AS start_date_13, t0.stop_date AS stop_date_14 FROM content_part t0 INNER JOIN content_part_part_program ON t0.id = content_part_part_program.content_part_id WHERE content_part_part_program.part_program_id = 8 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.civility AS civility_4,
  t0.complementary_infos AS complementary_infos_5,
  t0.portrait AS portrait_6,
  t0.social_media AS social_media_7,
  t0.deleted_at AS deleted_at_8
FROM
  person_of_interest t0
  INNER JOIN part_program_person_of_interest ON t0.id = part_program_person_of_interest.person_of_interest_id
WHERE
  part_program_person_of_interest.part_program_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.civility AS civility_4, t0.complementary_infos AS complementary_infos_5, t0.portrait AS portrait_6, t0.social_media AS social_media_7, t0.deleted_at AS deleted_at_8 FROM person_of_interest t0 INNER JOIN part_program_person_of_interest ON t0.id = part_program_person_of_interest.person_of_interest_id WHERE part_program_person_of_interest.part_program_id = 8 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.civility AS civility_4,
  t0.complementary_infos AS complementary_infos_5,
  t0.portrait AS portrait_6,
  t0.social_media AS social_media_7,
  t0.deleted_at AS deleted_at_8
FROM
  person_of_interest t0
  INNER JOIN content_part_person_of_interest ON t0.id = content_part_person_of_interest.person_of_interest_id
WHERE
  content_part_person_of_interest.content_part_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.civility AS civility_4, t0.complementary_infos AS complementary_infos_5, t0.portrait AS portrait_6, t0.social_media AS social_media_7, t0.deleted_at AS deleted_at_8 FROM person_of_interest t0 INNER JOIN content_part_person_of_interest ON t0.id = content_part_person_of_interest.person_of_interest_id WHERE content_part_person_of_interest.content_part_id = 10 AND ((t0.deleted_at IS NULL));

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.url AS url_2,
  e0_.thumbnail AS thumbnail_3,
  e0_.cover AS cover_4,
  e0_.is_test_stream AS is_test_stream_5,
  e0_.place AS place_6,
  e0_.is_bloc AS is_bloc_7,
  e0_.is_presential AS is_presential_8,
  e0_.title AS title_9,
  e0_.description AS description_10,
  e0_.subtitle AS subtitle_11,
  e0_.created_at AS created_at_12,
  e0_.updated_at AS updated_at_13,
  e0_.deleted_at AS deleted_at_14,
  e0_.status AS status_15,
  e0_.start_date AS start_date_16,
  e0_.stop_date AS stop_date_17
FROM
  event e0_
WHERE
  (e0_.is_bloc <> 1)
  AND (e0_.deleted_at IS NULL)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.url AS url_2, e0_.thumbnail AS thumbnail_3, e0_.cover AS cover_4, e0_.is_test_stream AS is_test_stream_5, e0_.place AS place_6, e0_.is_bloc AS is_bloc_7, e0_.is_presential AS is_presential_8, e0_.title AS title_9, e0_.description AS description_10, e0_.subtitle AS subtitle_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.deleted_at AS deleted_at_14, e0_.status AS status_15, e0_.start_date AS start_date_16, e0_.stop_date AS stop_date_17 FROM event e0_ WHERE (e0_.is_bloc <> 1) AND (e0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.subtitle AS subtitle_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.start_date AS start_date_8,
  t0.stop_date AS stop_date_9,
  t0.event_id AS event_id_10,
  t0.room_id AS room_id_11
FROM
  program t0
WHERE
  t0.room_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.subtitle AS subtitle_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.start_date AS start_date_8, t0.stop_date AS stop_date_9, t0.event_id AS event_id_10, t0.room_id AS room_id_11 FROM program t0 WHERE t0.room_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.url AS url_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  brand t0
  INNER JOIN slider_brand ON t0.id = slider_brand.brand_id
WHERE
  slider_brand.slider_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.url AS url_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM brand t0 INNER JOIN slider_brand ON t0.id = slider_brand.brand_id WHERE slider_brand.slider_id = 1 AND ((t0.deleted_at IS NULL));