Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 20
• Events
• Routing
• Cache
• Translation 3
• 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 (?)) AND (city.domain = ?) GROUP BY category.id ORDER BY category.position asc, category.slug asc

[
  1
  1
  0
  "InStock"
  "gorishnie-plavni.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 = 'gorishnie-plavni.bavtest.net') GROUP BY category.id ORDER BY category.position asc, category.slug asc;