Query Metrics

10 Database Queries
6 Different statements
0.47 ms Query time
0 Invalid entities
92 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.07 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0._order AS _order_4, t0.professional AS professional_5, t0.image AS image_6, t0.status AS status_7 FROM faq_category t0 WHERE t0.professional = ? AND t0.status = ? ORDER BY t0._order ASC
Parameters:
[
  0
  "published"
]
2 0.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0._order AS _order_4, t0.professional AS professional_5, t0.image AS image_6, t0.status AS status_7 FROM faq_category t0 WHERE t0.professional = ? AND t0.status = ? ORDER BY t0._order ASC
Parameters:
[
  1
  "published"
]
3 0.07 ms
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.slug AS slug_2, f0_.answer AS answer_3, f0_._order AS _order_4, f0_.popular AS popular_5, f0_.status AS status_6, f0_.category_id AS category_id_7 FROM faq_item f0_ LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id WHERE f0_.popular = ? AND f1_.professional = ? AND f0_.status = ? AND f1_.status = ? ORDER BY f0_._order ASC
Parameters:
[
  1
  0
  "published"
  "published"
]
4 0.05 ms
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.slug AS slug_2, f0_.answer AS answer_3, f0_._order AS _order_4, f0_.popular AS popular_5, f0_.status AS status_6, f0_.category_id AS category_id_7 FROM faq_item f0_ LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id WHERE f0_.popular = ? AND f1_.professional = ? AND f0_.status = ? AND f1_.status = ? ORDER BY f0_._order ASC
Parameters:
[
  1
  1
  "published"
  "published"
]
5 0.04 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.route_name AS route_name_4, t0.slug AS slug_5, t0.url AS url_6 FROM static_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "front_faq"
]
6 0.04 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.route_name AS route_name_4, t0.slug AS slug_5, t0.url AS url_6 FROM static_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "front_faq"
]
7 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link_href AS link_href_3, t0.link_order AS link_order_4, t0.picto_class AS picto_class_5, t0.status AS status_6 FROM main_menu_item t0 WHERE t0.status = ? ORDER BY t0.link_order ASC
Parameters:
[
  "published"
]
8 0.04 ms
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.created_at AS created_at_2, n0_.published_at AS published_at_3, n0_.status AS status_4, n0_.title AS title_5 FROM notification n0_ WHERE n0_.published_at <= ? AND n0_.status = ? ORDER BY n0_.published_at DESC
Parameters:
[
  "2026-11-07 11:59:32"
  "published"
]
9 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link_href AS link_href_3, t0.link_order AS link_order_4, t0.picto_class AS picto_class_5, t0.status AS status_6 FROM main_menu_item t0 WHERE t0.status = ? ORDER BY t0.link_order ASC
Parameters:
[
  "published"
]
10 0.05 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.background_image AS background_image_2, b0_.background_image_mobile AS background_image_mobile_3, b0_.content AS content_4, b0_.cta_name AS cta_name_5, b0_.cta_url AS cta_url_6, b0_.status AS status_7, b0_.dynamic_pages AS dynamic_pages_8, b0_.created AS created_9, b0_.updated AS updated_10 FROM banner b0_ WHERE b0_.status = ? AND b0_.dynamic_pages LIKE ?
Parameters:
[
  "published"
  "%"front_faq"%"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
historic doctrine.dbal.historic_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FaqItem 67
App\Entity\FaqCategory 17
App\Entity\MainMenuItem 5
App\Entity\StaticPage 1
App\Entity\Notification 1
App\Entity\Banner 1

Entities Mapping

Class Mapping errors
App\Entity\FaqCategory No errors.
App\Entity\FaqItem No errors.
App\Entity\StaticPage No errors.
App\Entity\MainMenuItem No errors.
App\Entity\Notification No errors.
App\Entity\Banner No errors.
App\Entity\CMSPage No errors.