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_.format AS format_12,
          e0_.created_at AS created_at_13,
          e0_.is_show_chat AS is_show_chat_14,
          e0_.is_registration AS is_registration_15,
          e0_.is_calendar AS is_calendar_16,
          e0_.is_nmo AS is_nmo_17,
          e0_.is_show_slider AS is_show_slider_18,
          e0_.image_name AS image_name_19,
          e0_.image_original_name AS image_original_name_20,
          e0_.image_mime_type AS image_mime_type_21,
          e0_.image_size AS image_size_22,
          e0_.image_updated_at AS image_updated_at_23,
          e0_.card_image_name AS card_image_name_24,
          e0_.card_image_original_name AS card_image_original_name_25,
          e0_.card_image_mime_type AS card_image_mime_type_26,
          e0_.card_image_size AS card_image_size_27,
          e0_.card_image_updated_at AS card_image_updated_at_28,
          e1_.id AS id_29,
          e1_.title AS title_30,
          e1_.seo_title AS seo_title_31,
          e1_.seo_description AS seo_description_32,
          e1_.content AS content_33,
          l2_.id AS id_34,
          l2_.name AS name_35,
          s3_.id AS id_36,
          s3_.name AS name_37,
          s3_.type AS type_38
        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_specialty e4_ ON e0_.id = e4_.event_id
          LEFT JOIN specialty s3_ ON s3_.id = e4_.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_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38 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_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-05-22 14:00:09' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-05-22 14:00:09'))) 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_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.title AS title_30,
  e1_.seo_title AS seo_title_31,
  e1_.seo_description AS seo_description_32,
  e1_.content AS content_33,
  l2_.id AS id_34,
  l2_.name AS name_35,
  s3_.id AS id_36,
  s3_.name AS name_37,
  s3_.type AS type_38,
  e0_.poll_id AS poll_id_39,
  e0_.event_group_id AS event_group_id_40,
  e1_.lang_id AS lang_id_41,
  e1_.event_id AS event_id_42
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_specialty e4_ ON e0_.id = e4_.event_id
  LEFT JOIN specialty s3_ ON s3_.id = e4_.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_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38, e0_.poll_id AS poll_id_39, e0_.event_group_id AS event_group_id_40, e1_.lang_id AS lang_id_41, e1_.event_id AS event_id_42 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_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-05-22 14:00:09' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-05-22 14:00:09'))) 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_.format AS format_12,
          e0_.created_at AS created_at_13,
          e0_.is_show_chat AS is_show_chat_14,
          e0_.is_registration AS is_registration_15,
          e0_.is_calendar AS is_calendar_16,
          e0_.is_nmo AS is_nmo_17,
          e0_.is_show_slider AS is_show_slider_18,
          e0_.image_name AS image_name_19,
          e0_.image_original_name AS image_original_name_20,
          e0_.image_mime_type AS image_mime_type_21,
          e0_.image_size AS image_size_22,
          e0_.image_updated_at AS image_updated_at_23,
          e0_.card_image_name AS card_image_name_24,
          e0_.card_image_original_name AS card_image_original_name_25,
          e0_.card_image_mime_type AS card_image_mime_type_26,
          e0_.card_image_size AS card_image_size_27,
          e0_.card_image_updated_at AS card_image_updated_at_28,
          e1_.id AS id_29,
          e1_.title AS title_30,
          e1_.seo_title AS seo_title_31,
          e1_.seo_description AS seo_description_32,
          e1_.content AS content_33,
          l2_.id AS id_34,
          l2_.name AS name_35,
          s3_.id AS id_36,
          s3_.name AS name_37,
          s3_.type AS type_38
        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_specialty e4_ ON e0_.id = e4_.event_id
          LEFT JOIN specialty s3_ ON s3_.id = e4_.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_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38 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_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = 1 AND e0_.is_activated = 1 AND ((e0_.start_at >= '2026-05-22 14:00:09' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-05-22 14:00:09'))) 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.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
  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_;