Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.image AS image_2,
  b0_.is_enabled AS is_enabled_3,
  b0_.is_activated AS is_activated_4,
  b0_.redirect_url AS redirect_url_5,
  b0_.start_at AS start_at_6,
  b0_.end_at AS end_at_7,
  b0_.sort AS sort_8,
  b0_.type AS type_9,
  b0_.image_name AS image_name_10,
  b0_.image_original_name AS image_original_name_11,
  b0_.image_mime_type AS image_mime_type_12,
  b0_.image_size AS image_size_13,
  b0_.image_updated_at AS image_updated_at_14,
  b0_.lang_id AS lang_id_15
FROM
  banner b0_
WHERE
  b0_.is_enabled = ?
  AND b0_.is_activated = ?
  AND b0_.start_at <= ?
  AND (
    (
      b0_.end_at IS NULL
      OR b0_.end_at >= ?
    )
  )
ORDER BY
  b0_.sort ASC,
  b0_.start_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.is_enabled AS is_enabled_3, b0_.is_activated AS is_activated_4, b0_.redirect_url AS redirect_url_5, b0_.start_at AS start_at_6, b0_.end_at AS end_at_7, b0_.sort AS sort_8, b0_.type AS type_9, b0_.image_name AS image_name_10, b0_.image_original_name AS image_original_name_11, b0_.image_mime_type AS image_mime_type_12, b0_.image_size AS image_size_13, b0_.image_updated_at AS image_updated_at_14, b0_.lang_id AS lang_id_15 FROM banner b0_ WHERE b0_.is_enabled = 1 AND b0_.is_activated = 1 AND b0_.start_at <= '2026-04-16 00:00:00' AND ((b0_.end_at IS NULL OR b0_.end_at >= '2026-04-16 00:00:00')) ORDER BY b0_.sort ASC, b0_.start_at DESC;

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,
  e0_.poll_id AS poll_id_35,
  e0_.event_group_id AS event_group_id_36,
  e1_.lang_id AS lang_id_37,
  e1_.event_id AS event_id_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
WHERE
  e0_.is_calendar = ?
  AND e0_.is_enabled = ?
  AND e0_.is_activated = ?
  AND e0_.start_at IS NOT NULL
  AND e0_.start_at < ?
  AND (
    e0_.end_at IS NULL
    OR e0_.end_at >= ?
  )
ORDER BY
  e0_.start_at 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, e0_.poll_id AS poll_id_35, e0_.event_group_id AS event_group_id_36, e1_.lang_id AS lang_id_37, e1_.event_id AS event_id_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 WHERE e0_.is_calendar = 1 AND e0_.is_enabled = 1 AND e0_.is_activated = 1 AND e0_.start_at IS NOT NULL AND e0_.start_at < '2027-01-01 00:00:00' AND (e0_.end_at IS NULL OR e0_.end_at >= '2026-01-01 00:00:00') ORDER BY e0_.start_at 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,
  s3_.id AS id_35,
  s3_.name AS name_36,
  s3_.type AS type_37,
  e0_.poll_id AS poll_id_38,
  e0_.event_group_id AS event_group_id_39,
  e1_.lang_id AS lang_id_40,
  e1_.event_id AS event_id_41
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 IS NOT NULL
  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
LIMIT
  5

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, s3_.id AS id_35, s3_.name AS name_36, s3_.type AS type_37, e0_.poll_id AS poll_id_38, e0_.event_group_id AS event_group_id_39, e1_.lang_id AS lang_id_40, e1_.event_id AS event_id_41 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 IS NOT NULL AND ((e0_.start_at >= '2026-04-16 12:39:01' OR (e0_.end_at IS NOT NULL AND e0_.end_at >= '2026-04-16 12:39:01'))) AND e0_.status IN ('active', 'online', 'postponed') ORDER BY e0_.start_at ASC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  specialty t0
  INNER JOIN event_specialty ON t0.id = event_specialty.specialty_id
WHERE
  event_specialty.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM specialty t0 INNER JOIN event_specialty ON t0.id = event_specialty.specialty_id WHERE event_specialty.event_id = 5;

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_;