Symfony Profiler

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

Query Metrics

SELECT category.id as id, category.external_id as external_id, category.slug as slug, category.status as status, category.position as position FROM category INNER JOIN event_category event_category ON event_category.category_id = category.id INNER JOIN event event ON event.id = event_category.event_id INNER JOIN city city ON event.city_id = city.id WHERE (category.status = ?) AND (category.use_in_filtration = 1) AND (event.status = ?) AND (event.fm_status = ?) AND (event.event_status IN (?)) AND (city.domain = ?) GROUP BY category.id ORDER BY category.position asc, category.slug asc

[
  1
  1
  0
  "InStock"
  "khmelnitsky.bavtest.net"
]

SELECT
  category.id as id,
  category.external_id as external_id,
  category.slug as slug,
  category.status as status,
  category.position as position
FROM
  category
  INNER JOIN event_category event_category ON event_category.category_id = category.id
  INNER JOIN event event ON event.id = event_category.event_id
  INNER JOIN city city ON event.city_id = city.id
WHERE
  (category.status = ?)
  AND (category.use_in_filtration = 1)
  AND (event.status = ?)
  AND (event.fm_status = ?)
  AND (
    event.event_status IN (?)
  )
  AND (city.domain = ?)
GROUP BY
  category.id
ORDER BY
  category.position asc,
  category.slug asc

SELECT category.id as id, category.external_id as external_id, category.slug as slug, category.status as status, category.position as position FROM category INNER JOIN event_category event_category ON event_category.category_id = category.id INNER JOIN event event ON event.id = event_category.event_id INNER JOIN city city ON event.city_id = city.id WHERE (category.status = 1) AND (category.use_in_filtration = 1) AND (event.status = 1) AND (event.fm_status = 0) AND (event.event_status IN ('InStock')) AND (city.domain = 'khmelnitsky.bavtest.net') GROUP BY category.id ORDER BY category.position asc, category.slug 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

[
  "en"
  "2025-01-23 06:01:24"
  "2025-01-23 06:01:24"
]

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='en' WHERE (running_line.starts_at <= '2025-01-23 06:01:24') AND (running_line.finishes_at >= '2025-01-23 06:01:24') ORDER BY running_line.position asc LIMIT 100;