Query Metrics
10
Database Queries
6
Different statements
0.47 ms
Query time
0
Invalid entities
92
Managed entities
Queries
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. |