Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 41
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• Twig Components
• HTTP Client 2
• 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 (?)) GROUP BY category.id ORDER BY category.position asc, category.slug asc

[
  1
  1
  0
  "InStock"
]

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 (?)
  )
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')) GROUP BY category.id ORDER BY category.position asc, category.slug asc;

SELECT DISTINCT(MONTH(event.event_date)) as month, YEAR(event.event_date) as year FROM event WHERE (event.event_date <= ?) AND (event.event_date >= ?) AND (event.status = ?) AND (event.fm_status IN (?, ?, ?)) AND (event.event_status IN (?, ?, ?, ?, ?, ?, ?)) ORDER BY year,month

[
  "2026-05-02"
  "2025-08-02"
  1
  0
  3
  2
  "Discontinued"
  "InStock"
  "LimitedAvailability"
  "PreOrder"
  "PreSale"
  "Rescheduled"
  "Cancelled"
]

SELECT
  DISTINCT(
    MONTH(event.event_date)
  ) as month,
  YEAR(event.event_date) as year
FROM
  event
WHERE
  (event.event_date <= ?)
  AND (event.event_date >= ?)
  AND (event.status = ?)
  AND (
    event.fm_status IN (?, ?, ?)
  )
  AND (
    event.event_status IN (?, ?, ?, ?, ?, ?, ?)
  )
ORDER BY
  year,
  month

SELECT DISTINCT(MONTH(event.event_date)) as month, YEAR(event.event_date) as year FROM event WHERE (event.event_date <= '2026-05-02') AND (event.event_date >= '2025-08-02') AND (event.status = 1) AND (event.fm_status IN (0, 3, 2)) AND (event.event_status IN ('Discontinued', 'InStock', 'LimitedAvailability', 'PreOrder', 'PreSale', 'Rescheduled', 'Cancelled')) ORDER BY year,month;