Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.external_id AS external_id_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_index AS is_index_7, t0.css AS css_8, t0.js_head AS js_head_9, t0.js_body_start AS js_body_start_10, t0.js_body_end AS js_body_end_11 FROM page t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1

[
  "the-show-must-go-on-3"
  1
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.external_id AS external_id_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.is_index AS is_index_7,
  t0.css AS css_8,
  t0.js_head AS js_head_9,
  t0.js_body_start AS js_body_start_10,
  t0.js_body_end AS js_body_end_11
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.external_id AS external_id_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_index AS is_index_7, t0.css AS css_8, t0.js_head AS js_head_9, t0.js_body_start AS js_body_start_10, t0.js_body_end AS js_body_end_11 FROM page t0 WHERE t0.slug = 'the-show-must-go-on-3' AND t0.status = 1 LIMIT 1;

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"
  "vinnitsa.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 = 'vinnitsa.bavtest.net') GROUP BY category.id ORDER BY category.position asc, category.slug asc;