Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.created_at AS created_at_1,
  b0_.updated_at AS updated_at_2,
  b0_.name AS name_3,
  b0_.domain AS domain_4,
  b0_.contact_email AS contact_email_5,
  b0_.source AS source_6,
  b0_.linked_to_live AS linked_to_live_7,
  b0_.linked_to_interview AS linked_to_interview_8,
  b0_.linked_to_homework AS linked_to_homework_9,
  b0_.linked_to_prompt AS linked_to_prompt_10,
  b0_.code AS code_11,
  b0_.phone_number AS phone_number_12,
  b0_.address_line1 AS address_line1_13,
  b0_.address_line2 AS address_line2_14,
  b0_.post_code AS post_code_15,
  b0_.city AS city_16,
  b0_.gtmid AS gtmid_17,
  b0_.schedule_link AS schedule_link_18
FROM
  brand b0_
WHERE
  b0_.domain LIKE ?

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.updated_at AS updated_at_2, b0_.name AS name_3, b0_.domain AS domain_4, b0_.contact_email AS contact_email_5, b0_.source AS source_6, b0_.linked_to_live AS linked_to_live_7, b0_.linked_to_interview AS linked_to_interview_8, b0_.linked_to_homework AS linked_to_homework_9, b0_.linked_to_prompt AS linked_to_prompt_10, b0_.code AS code_11, b0_.phone_number AS phone_number_12, b0_.address_line1 AS address_line1_13, b0_.address_line2 AS address_line2_14, b0_.post_code AS post_code_15, b0_.city AS city_16, b0_.gtmid AS gtmid_17, b0_.schedule_link AS schedule_link_18 FROM brand b0_ WHERE b0_.domain LIKE 'ecole-sante-naturelle.%';

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.tagline AS tagline_4,
  t0.value_proposition AS value_proposition_5,
  t0.header_video AS header_video_6,
  t0.vimeo_access_token AS vimeo_access_token_7,
  t0.brand_id AS brand_id_8
FROM
  website_config t0
WHERE
  t0.brand_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.tagline AS tagline_4, t0.value_proposition AS value_proposition_5, t0.header_video AS header_video_6, t0.vimeo_access_token AS vimeo_access_token_7, t0.brand_id AS brand_id_8 FROM website_config t0 WHERE t0.brand_id = 20 LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.created_at AS created_at_1,
  l0_.updated_at AS updated_at_2,
  l0_.is_private AS is_private_3,
  l0_.speaker_name AS speaker_name_4,
  l0_.moderator AS moderator_5,
  l0_.chat_widget AS chat_widget_6,
  l0_.disciplines AS disciplines_7,
  l0_.nb_evaluations AS nb_evaluations_8,
  l0_.avg_evaluation AS avg_evaluation_9,
  l0_.nb_technical_problems AS nb_technical_problems_10,
  l0_.position AS position_11,
  l0_.nb_potential_viewers AS nb_potential_viewers_12,
  l0_.nb_viewers AS nb_viewers_13,
  l0_.nb_replay_viewers AS nb_replay_viewers_14,
  l0_.nb_live_viewers AS nb_live_viewers_15,
  l0_.nb_finished_viewers AS nb_finished_viewers_16,
  l0_.is_pinned AS is_pinned_17,
  l0_.active AS active_18,
  l0_.video_conference_url AS video_conference_url_19,
  l0_.title AS title_20,
  l0_.token AS token_21,
  l0_.start_at AS start_at_22,
  l0_.shutdown_at AS shutdown_at_23,
  l0_.youtube_url AS youtube_url_24,
  l0_.vimeo_url AS vimeo_url_25,
  l0_.vimeo_thumb_url AS vimeo_thumb_url_26,
  l0_.quiz_widget AS quiz_widget_27,
  l0_.second_tab_label AS second_tab_label_28,
  l0_.instruction AS instruction_29,
  l0_.summary AS summary_30,
  l0_.summary_html AS summary_html_31,
  l0_.start AS start_32,
  l0_.video_duration AS video_duration_33,
  l0_.end_at AS end_at_34,
  l0_.ended AS ended_35,
  l0_.subtopic_id AS subtopic_id_36,
  l0_.question_assistant_id AS question_assistant_id_37,
  l0_.attachments_id AS attachments_id_38,
  l0_.chat_room_id AS chat_room_id_39,
  l0_.brand_id AS brand_id_40
FROM
  live l0_
  LEFT JOIN subtopic s1_ ON l0_.subtopic_id = s1_.id
  LEFT JOIN topic t2_ ON s1_.topic_id = t2_.id
WHERE
  l0_.end_at < ?
  AND l0_.brand_id = ?
  AND l0_.is_private = 0
  AND l0_.active = 1
  AND s1_.active = 1
  AND t2_.active = 1
ORDER BY
  l0_.is_pinned DESC,
  l0_.start_at DESC

SELECT l0_.id AS id_0, l0_.created_at AS created_at_1, l0_.updated_at AS updated_at_2, l0_.is_private AS is_private_3, l0_.speaker_name AS speaker_name_4, l0_.moderator AS moderator_5, l0_.chat_widget AS chat_widget_6, l0_.disciplines AS disciplines_7, l0_.nb_evaluations AS nb_evaluations_8, l0_.avg_evaluation AS avg_evaluation_9, l0_.nb_technical_problems AS nb_technical_problems_10, l0_.position AS position_11, l0_.nb_potential_viewers AS nb_potential_viewers_12, l0_.nb_viewers AS nb_viewers_13, l0_.nb_replay_viewers AS nb_replay_viewers_14, l0_.nb_live_viewers AS nb_live_viewers_15, l0_.nb_finished_viewers AS nb_finished_viewers_16, l0_.is_pinned AS is_pinned_17, l0_.active AS active_18, l0_.video_conference_url AS video_conference_url_19, l0_.title AS title_20, l0_.token AS token_21, l0_.start_at AS start_at_22, l0_.shutdown_at AS shutdown_at_23, l0_.youtube_url AS youtube_url_24, l0_.vimeo_url AS vimeo_url_25, l0_.vimeo_thumb_url AS vimeo_thumb_url_26, l0_.quiz_widget AS quiz_widget_27, l0_.second_tab_label AS second_tab_label_28, l0_.instruction AS instruction_29, l0_.summary AS summary_30, l0_.summary_html AS summary_html_31, l0_.start AS start_32, l0_.video_duration AS video_duration_33, l0_.end_at AS end_at_34, l0_.ended AS ended_35, l0_.subtopic_id AS subtopic_id_36, l0_.question_assistant_id AS question_assistant_id_37, l0_.attachments_id AS attachments_id_38, l0_.chat_room_id AS chat_room_id_39, l0_.brand_id AS brand_id_40 FROM live l0_ LEFT JOIN subtopic s1_ ON l0_.subtopic_id = s1_.id LEFT JOIN topic t2_ ON s1_.topic_id = t2_.id WHERE l0_.end_at < '2026-02-09 08:19:31' AND l0_.brand_id = 20 AND l0_.is_private = 0 AND l0_.active = 1 AND s1_.active = 1 AND t2_.active = 1 ORDER BY l0_.is_pinned DESC, l0_.start_at DESC;

SELECT
  t0_.name AS name_0,
  t0_.icon_class AS icon_class_1
FROM
  topic t0_
  LEFT JOIN subtopic s1_ ON t0_.id = s1_.topic_id
  LEFT JOIN live l2_ ON s1_.id = l2_.subtopic_id
WHERE
  t0_.active = 1
  AND t0_.brand_id = ?
  AND l2_.active = 1
  AND l2_.start_at < ?
GROUP BY
  t0_.id,
  t0_.created_at,
  t0_.updated_at,
  t0_.active,
  t0_.name,
  t0_.position,
  t0_.icon_class,
  t0_.token,
  t0_.brand_id
ORDER BY
  t0_.position ASC

SELECT t0_.name AS name_0, t0_.icon_class AS icon_class_1 FROM topic t0_ LEFT JOIN subtopic s1_ ON t0_.id = s1_.topic_id LEFT JOIN live l2_ ON s1_.id = l2_.subtopic_id WHERE t0_.active = 1 AND t0_.brand_id = 20 AND l2_.active = 1 AND l2_.start_at < '2026-02-09 04:19:31' GROUP BY t0_.id, t0_.created_at, t0_.updated_at, t0_.active, t0_.name, t0_.position, t0_.icon_class, t0_.token, t0_.brand_id ORDER BY t0_.position ASC;