Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 21
• Events
• Routing
• Cache
• Translation 23
• Security
• Twig
• Twig Components
• HTTP Client 2
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Doctrine MongoDB 0
• Configuration

Query Metrics

SELECT id FROM building b WHERE b.parent_id=?

[
  "018eb73e-7196-7420-8f3d-a93dd251d5f3"
]

SELECT
  id
FROM
  building b
WHERE
  b.parent_id = ?

SELECT id FROM building b WHERE b.parent_id='018eb73e-7196-7420-8f3d-a93dd251d5f3';

SELECT event.id as id, event.fm_id as fm_id, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.currency_id as currency_id, event.slug as slug, event.sticker_id as sticker_id, event.use_event_name as use_event_name, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.price_from as price_from, event.price_to as price_to, event.event_status as event_status, event.fm_status as fm_status, event.event_date as event_date, event.free_places as free_places, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event.free_places as free_places, event.available_to_sell as available_to_sell, event_lang_default.name as default_name, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.custom_link as custom_link, CASE
               WHEN event.event_date <= CURRENT_DATE AND (event.event_end_date >= CURRENT_DATE OR event.event_end_date IS NULL) THEN CURRENT_DATE
               WHEN (event.event_end_date > CURRENT_DATE OR event.event_date < CURRENT_DATE OR event.event_end_date IS NULL) THEN COALESCE(event.event_end_date, event.event_date)
            END AS virtual_date FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = ? LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = ? WHERE (event.sales_end_time > ?) AND (event.building_id IN  (?)) AND (event.status = ?) AND (COALESCE(event.event_end_date, event.sales_end_time, event.event_date) >= ?) ORDER BY virtual_date asc, event_date asc

[
  "ua"
  "en"
  "2025-01-23 02:04:13"
  "018eb73e-7196-7420-8f3d-a93dd251d5f3"
  1
  "2025-01-23 00:01"
]

SELECT
  event.id as id,
  event.fm_id as fm_id,
  event.city_id as city_id,
  event.building_id as building_id,
  event.activity_id as activity_id,
  event.currency_id as currency_id,
  event.slug as slug,
  event.sticker_id as sticker_id,
  event.use_event_name as use_event_name,
  event.sticker_activity_time_from as sticker_activity_time_from,
  event.sticker_activity_time_to as sticker_activity_time_to,
  event.price_from as price_from,
  event.price_to as price_to,
  event.event_status as event_status,
  event.fm_status as fm_status,
  event.event_date as event_date,
  event.free_places as free_places,
  event.event_end_date as event_end_date,
  event.sales_end_time as sales_end_time,
  event_lang.name as name,
  event.free_places as free_places,
  event.available_to_sell as available_to_sell,
  event_lang_default.name as default_name,
  event.image_big as image_big,
  event.image_medium as image_medium,
  event.image_large as image_large,
  event.image_small as image_small,
  event.custom_link as custom_link,
  CASE WHEN event.event_date <= CURRENT_DATE
  AND (
    event.event_end_date >= CURRENT_DATE
    OR event.event_end_date IS NULL
  ) THEN CURRENT_DATE WHEN (
    event.event_end_date > CURRENT_DATE
    OR event.event_date < CURRENT_DATE
    OR event.event_end_date IS NULL
  ) THEN COALESCE(
    event.event_end_date, event.event_date
  ) END AS virtual_date
FROM
  event
  LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id
  AND event_lang.language_code = ?
  LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id
  AND event_lang_default.language_code = ?
WHERE
  (event.sales_end_time > ?)
  AND (
    event.building_id IN (?)
  )
  AND (event.status = ?)
  AND (
    COALESCE(
      event.event_end_date, event.sales_end_time,
      event.event_date
    ) >= ?
  )
ORDER BY
  virtual_date asc,
  event_date asc

SELECT event.id as id, event.fm_id as fm_id, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.currency_id as currency_id, event.slug as slug, event.sticker_id as sticker_id, event.use_event_name as use_event_name, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.price_from as price_from, event.price_to as price_to, event.event_status as event_status, event.fm_status as fm_status, event.event_date as event_date, event.free_places as free_places, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event.free_places as free_places, event.available_to_sell as available_to_sell, event_lang_default.name as default_name, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.custom_link as custom_link, CASE
               WHEN event.event_date <= CURRENT_DATE AND (event.event_end_date >= CURRENT_DATE OR event.event_end_date IS NULL) THEN CURRENT_DATE
               WHEN (event.event_end_date > CURRENT_DATE OR event.event_date < CURRENT_DATE OR event.event_end_date IS NULL) THEN COALESCE(event.event_end_date, event.event_date)
            END AS virtual_date FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'ua' LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = 'en' WHERE (event.sales_end_time > '2025-01-23 02:04:13') AND (event.building_id IN  ('018eb73e-7196-7420-8f3d-a93dd251d5f3')) AND (event.status = 1) AND (COALESCE(event.event_end_date, event.sales_end_time, event.event_date) >= '2025-01-23 00:01') ORDER BY virtual_date asc, event_date asc;

SELECT running_line.image_desktop, running_line.image_tablet, running_line.image_mobile, running_line.gtm_event, running_line.gtm_event_name, running_line.starts_at, running_line.finishes_at, running_line_lang.link FROM running_line LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id AND running_line_lang.language_code=? WHERE (running_line.starts_at <= ?) AND (running_line.finishes_at >= ?) ORDER BY running_line.position asc LIMIT 100

[
  "ua"
  "2025-01-23 00:04:13"
  "2025-01-23 00:04:13"
]

SELECT
  running_line.image_desktop,
  running_line.image_tablet,
  running_line.image_mobile,
  running_line.gtm_event,
  running_line.gtm_event_name,
  running_line.starts_at,
  running_line.finishes_at,
  running_line_lang.link
FROM
  running_line
  LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id
  AND running_line_lang.language_code = ?
WHERE
  (running_line.starts_at <= ?)
  AND (running_line.finishes_at >= ?)
ORDER BY
  running_line.position asc
LIMIT
  100

SELECT running_line.image_desktop, running_line.image_tablet, running_line.image_mobile, running_line.gtm_event, running_line.gtm_event_name, running_line.starts_at, running_line.finishes_at, running_line_lang.link FROM running_line LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id AND running_line_lang.language_code='ua' WHERE (running_line.starts_at <= '2025-01-23 00:04:13') AND (running_line.finishes_at >= '2025-01-23 00:04:13') ORDER BY running_line.position asc LIMIT 100;