Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      start_at_9
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.slug AS slug_1,
          e0_.program_name AS program_name_2,
          e0_.program_original_name AS program_original_name_3,
          e0_.program_mime_type AS program_mime_type_4,
          e0_.program_size AS program_size_5,
          e0_.program_updated_at AS program_updated_at_6,
          e0_.is_activated AS is_activated_7,
          e0_.is_enabled AS is_enabled_8,
          e0_.start_at AS start_at_9,
          e0_.end_at AS end_at_10,
          e0_.status AS status_11,
          e0_.created_at AS created_at_12,
          e0_.is_show_chat AS is_show_chat_13,
          e0_.is_registration AS is_registration_14,
          e0_.is_calendar AS is_calendar_15,
          e0_.is_nmo AS is_nmo_16,
          e0_.is_show_slider AS is_show_slider_17,
          e0_.image_name AS image_name_18,
          e0_.image_original_name AS image_original_name_19,
          e0_.image_mime_type AS image_mime_type_20,
          e0_.image_size AS image_size_21,
          e0_.image_updated_at AS image_updated_at_22,
          e0_.card_image_name AS card_image_name_23,
          e0_.card_image_original_name AS card_image_original_name_24,
          e0_.card_image_mime_type AS card_image_mime_type_25,
          e0_.card_image_size AS card_image_size_26,
          e0_.card_image_updated_at AS card_image_updated_at_27,
          e1_.id AS id_28,
          e1_.title AS title_29,
          e1_.seo_title AS seo_title_30,
          e1_.seo_description AS seo_description_31,
          e1_.content AS content_32,
          l2_.id AS id_33,
          l2_.name AS name_34,
          e3_.id AS id_35,
          e3_.slug AS slug_36,
          e3_.created_at AS created_at_37,
          e3_.is_activated AS is_activated_38,
          e4_.id AS id_39,
          e4_.title AS title_40,
          e4_.content AS content_41,
          s5_.id AS id_42,
          s5_.is_enabled AS is_enabled_43,
          s5_.created_at AS created_at_44,
          s5_.image_name AS image_name_45,
          s5_.image_original_name AS image_original_name_46,
          s5_.image_mime_type AS image_mime_type_47,
          s5_.image_size AS image_size_48,
          s5_.image_updated_at AS image_updated_at_49,
          s6_.id AS id_50,
          s6_.name AS name_51,
          s6_.content AS content_52,
          s7_.id AS id_53,
          s7_.name AS name_54,
          s7_.type AS type_55
        FROM
          event e0_
          LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id
          LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
          LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id
          LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id
          LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id
          LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id
          LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id
          LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id
          LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id
        WHERE
          e0_.is_enabled = ?
          AND e0_.is_activated = ?
          AND (
            (
              e0_.start_at >= ?
              OR (
                e0_.end_at IS NOT NULL
                AND e0_.end_at >= ?
              )
            )
          )
          AND e0_.status IN (?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      start_at_9 ASC,
      id_0 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, e3_.id AS id_35, e3_.slug AS slug_36, e3_.created_at AS created_at_37, e3_.is_activated AS is_activated_38, e4_.id AS id_39, e4_.title AS title_40, e4_.content AS content_41, s5_.id AS id_42, s5_.is_enabled AS is_enabled_43, s5_.created_at AS created_at_44, s5_.image_name AS image_name_45, s5_.image_original_name AS image_original_name_46, s5_.image_mime_type AS image_mime_type_47, s5_.image_size AS image_size_48, s5_.image_updated_at AS image_updated_at_49, s6_.id AS id_50, s6_.name AS name_51, s6_.content AS content_52, s7_.id AS id_53, s7_.name AS name_54, s7_.type AS type_55 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-04-16 10:14:42' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-04-16 10:14:42'))) AND e0_.status IN ('active', 'online', 'postponed')) dctrn_result_inner ORDER BY start_at_9 ASC, id_0 ASC) dctrn_result LIMIT 10;

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.created_at AS created_at_12,
  e0_.is_show_chat AS is_show_chat_13,
  e0_.is_registration AS is_registration_14,
  e0_.is_calendar AS is_calendar_15,
  e0_.is_nmo AS is_nmo_16,
  e0_.is_show_slider AS is_show_slider_17,
  e0_.image_name AS image_name_18,
  e0_.image_original_name AS image_original_name_19,
  e0_.image_mime_type AS image_mime_type_20,
  e0_.image_size AS image_size_21,
  e0_.image_updated_at AS image_updated_at_22,
  e0_.card_image_name AS card_image_name_23,
  e0_.card_image_original_name AS card_image_original_name_24,
  e0_.card_image_mime_type AS card_image_mime_type_25,
  e0_.card_image_size AS card_image_size_26,
  e0_.card_image_updated_at AS card_image_updated_at_27,
  e1_.id AS id_28,
  e1_.title AS title_29,
  e1_.seo_title AS seo_title_30,
  e1_.seo_description AS seo_description_31,
  e1_.content AS content_32,
  l2_.id AS id_33,
  l2_.name AS name_34,
  e3_.id AS id_35,
  e3_.slug AS slug_36,
  e3_.created_at AS created_at_37,
  e3_.is_activated AS is_activated_38,
  e4_.id AS id_39,
  e4_.title AS title_40,
  e4_.content AS content_41,
  s5_.id AS id_42,
  s5_.is_enabled AS is_enabled_43,
  s5_.created_at AS created_at_44,
  s5_.image_name AS image_name_45,
  s5_.image_original_name AS image_original_name_46,
  s5_.image_mime_type AS image_mime_type_47,
  s5_.image_size AS image_size_48,
  s5_.image_updated_at AS image_updated_at_49,
  s6_.id AS id_50,
  s6_.name AS name_51,
  s6_.content AS content_52,
  s7_.id AS id_53,
  s7_.name AS name_54,
  s7_.type AS type_55,
  e0_.poll_id AS poll_id_56,
  e0_.event_group_id AS event_group_id_57,
  e1_.lang_id AS lang_id_58,
  e1_.event_id AS event_id_59,
  e4_.lang_id AS lang_id_60,
  e4_.event_group_id AS event_group_id_61,
  s6_.speaker_id AS speaker_id_62,
  s6_.lang_id AS lang_id_63
FROM
  event e0_
  LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id
  LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
  LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id
  LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id
  LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id
  LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id
  LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id
  LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id
  LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id
WHERE
  e0_.is_enabled = ?
  AND e0_.is_activated = ?
  AND (
    (
      e0_.start_at >= ?
      OR (
        e0_.end_at IS NOT NULL
        AND e0_.end_at >= ?
      )
    )
  )
  AND e0_.status IN (?, ?, ?)
  AND e0_.id IN (?, ?, ?)
ORDER BY
  e0_.start_at ASC,
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, e3_.id AS id_35, e3_.slug AS slug_36, e3_.created_at AS created_at_37, e3_.is_activated AS is_activated_38, e4_.id AS id_39, e4_.title AS title_40, e4_.content AS content_41, s5_.id AS id_42, s5_.is_enabled AS is_enabled_43, s5_.created_at AS created_at_44, s5_.image_name AS image_name_45, s5_.image_original_name AS image_original_name_46, s5_.image_mime_type AS image_mime_type_47, s5_.image_size AS image_size_48, s5_.image_updated_at AS image_updated_at_49, s6_.id AS id_50, s6_.name AS name_51, s6_.content AS content_52, s7_.id AS id_53, s7_.name AS name_54, s7_.type AS type_55, e0_.poll_id AS poll_id_56, e0_.event_group_id AS event_group_id_57, e1_.lang_id AS lang_id_58, e1_.event_id AS event_id_59, e4_.lang_id AS lang_id_60, e4_.event_group_id AS event_group_id_61, s6_.speaker_id AS speaker_id_62, s6_.lang_id AS lang_id_63 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-04-16 10:14:42' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-04-16 10:14:42'))) AND e0_.status IN ('active', 'online', 'postponed') AND e0_.id IN (3, 4, 5) ORDER BY e0_.start_at ASC, e0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.slug AS slug_1,
          e0_.program_name AS program_name_2,
          e0_.program_original_name AS program_original_name_3,
          e0_.program_mime_type AS program_mime_type_4,
          e0_.program_size AS program_size_5,
          e0_.program_updated_at AS program_updated_at_6,
          e0_.is_activated AS is_activated_7,
          e0_.is_enabled AS is_enabled_8,
          e0_.start_at AS start_at_9,
          e0_.end_at AS end_at_10,
          e0_.status AS status_11,
          e0_.created_at AS created_at_12,
          e0_.is_show_chat AS is_show_chat_13,
          e0_.is_registration AS is_registration_14,
          e0_.is_calendar AS is_calendar_15,
          e0_.is_nmo AS is_nmo_16,
          e0_.is_show_slider AS is_show_slider_17,
          e0_.image_name AS image_name_18,
          e0_.image_original_name AS image_original_name_19,
          e0_.image_mime_type AS image_mime_type_20,
          e0_.image_size AS image_size_21,
          e0_.image_updated_at AS image_updated_at_22,
          e0_.card_image_name AS card_image_name_23,
          e0_.card_image_original_name AS card_image_original_name_24,
          e0_.card_image_mime_type AS card_image_mime_type_25,
          e0_.card_image_size AS card_image_size_26,
          e0_.card_image_updated_at AS card_image_updated_at_27,
          e1_.id AS id_28,
          e1_.title AS title_29,
          e1_.seo_title AS seo_title_30,
          e1_.seo_description AS seo_description_31,
          e1_.content AS content_32,
          l2_.id AS id_33,
          l2_.name AS name_34,
          e3_.id AS id_35,
          e3_.slug AS slug_36,
          e3_.created_at AS created_at_37,
          e3_.is_activated AS is_activated_38,
          e4_.id AS id_39,
          e4_.title AS title_40,
          e4_.content AS content_41,
          s5_.id AS id_42,
          s5_.is_enabled AS is_enabled_43,
          s5_.created_at AS created_at_44,
          s5_.image_name AS image_name_45,
          s5_.image_original_name AS image_original_name_46,
          s5_.image_mime_type AS image_mime_type_47,
          s5_.image_size AS image_size_48,
          s5_.image_updated_at AS image_updated_at_49,
          s6_.id AS id_50,
          s6_.name AS name_51,
          s6_.content AS content_52,
          s7_.id AS id_53,
          s7_.name AS name_54,
          s7_.type AS type_55
        FROM
          event e0_
          LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id
          LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
          LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id
          LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id
          LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id
          LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id
          LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id
          LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id
          LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id
        WHERE
          e0_.is_enabled = ?
          AND e0_.is_activated = ?
          AND (
            (
              e0_.start_at >= ?
              OR (
                e0_.end_at IS NOT NULL
                AND e0_.end_at >= ?
              )
            )
          )
          AND e0_.status IN (?, ?, ?)
        ORDER BY
          e0_.start_at ASC,
          e0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, e3_.id AS id_35, e3_.slug AS slug_36, e3_.created_at AS created_at_37, e3_.is_activated AS is_activated_38, e4_.id AS id_39, e4_.title AS title_40, e4_.content AS content_41, s5_.id AS id_42, s5_.is_enabled AS is_enabled_43, s5_.created_at AS created_at_44, s5_.image_name AS image_name_45, s5_.image_original_name AS image_original_name_46, s5_.image_mime_type AS image_mime_type_47, s5_.image_size AS image_size_48, s5_.image_updated_at AS image_updated_at_49, s6_.id AS id_50, s6_.name AS name_51, s6_.content AS content_52, s7_.id AS id_53, s7_.name AS name_54, s7_.type AS type_55 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id LEFT JOIN event_speaker e8_ ON e0_.id = e8_.event_id LEFT JOIN speaker s5_ ON s5_.id = e8_.speaker_id LEFT JOIN speaker_translate s6_ ON s5_.id = s6_.speaker_id LEFT JOIN event_specialty e9_ ON e0_.id = e9_.event_id LEFT JOIN specialty s7_ ON s7_.id = e9_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-04-16 10:14:42' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-04-16 10:14:42'))) AND e0_.status IN ('active', 'online', 'postponed') ORDER BY e0_.start_at ASC, e0_.id ASC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.is_enabled AS is_enabled_2,
  t0.created_at AS created_at_3,
  t0.image_name AS image_name_4,
  t0.image_original_name AS image_original_name_5,
  t0.image_mime_type AS image_mime_type_6,
  t0.image_size AS image_size_7,
  t0.image_updated_at AS image_updated_at_8
FROM
  speaker t0
WHERE
  t0.is_enabled = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.created_at AS created_at_3, t0.image_name AS image_name_4, t0.image_original_name AS image_original_name_5, t0.image_mime_type AS image_mime_type_6, t0.image_size AS image_size_7, t0.image_updated_at AS image_updated_at_8 FROM speaker t0 WHERE t0.is_enabled = 1 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.speaker_id AS speaker_id_4,
  t0.lang_id AS lang_id_5
FROM
  speaker_translate t0
WHERE
  t0.speaker_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.speaker_id AS speaker_id_4, t0.lang_id AS lang_id_5 FROM speaker_translate t0 WHERE t0.speaker_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  specialty t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM specialty t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.is_activated AS is_activated_4
FROM
  event_group t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.is_activated AS is_activated_4 FROM event_group t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM language t0 WHERE t0.id = 2;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2
FROM
  specialty s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_;