Query Metrics
14
Database Queries
9
Different statements
20.58 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.51 ms (26.75%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.is_button AS is_button_7, t0.footer_category_id AS footer_category_id_8 FROM footer_item t0 WHERE t0.footer_category_id = ?
Parameters:
[
1
]
|
4.05 ms (19.67%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_type AS url_type_3, t0.url AS url_4, t0.route AS route_5, t0.header_category_id AS header_category_id_6 FROM header_item t0 WHERE t0.header_category_id = ?
Parameters:
[
1
]
|
1.94 ms (9.41%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.created_at AS created_at_3, b0_.end_date_at AS end_date_at_4, b0_.picture_header AS picture_header_5, b0_.alt_picture_header AS alt_picture_header_6, b0_.slug AS slug_7, b0_.visible_start_date AS visible_start_date_8, b0_.visible_expired_date AS visible_expired_date_9 FROM bandeau b0_ WHERE b0_.end_date_at >= ? AND b0_.created_at <= ? ORDER BY b0_.id DESC
Parameters:
[ "2025-07-05 00:00:00" "2025-07-05 00:00:00" ] |
1.79 ms (8.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.picture AS picture_3, t0.information AS information_4, t0.city AS city_5, t0.alt_picture AS alt_picture_6 FROM institution t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.72 ms (8.37%) |
1 |
SELECT f0_.id AS id_0 FROM footer f0_ ORDER BY f0_.id DESC LIMIT 1
Parameters:
[] |
1.43 ms (6.96%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.column_index AS column_index_3, t0.footer_id AS footer_id_4 FROM footer_category t0 WHERE t0.footer_id = ?
Parameters:
[
1
]
|
1.42 ms (6.90%) |
1 |
SELECT h0_.id AS id_0 FROM header h0_ ORDER BY h0_.id DESC LIMIT 1
Parameters:
[] |
1.37 ms (6.66%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.picture AS picture_3, t0.id_crm_animal AS id_crm_animal_4, t0.description AS description_5, t0.alt_picture AS alt_picture_6, t0.institution_id AS institution_id_7 FROM animals t0 WHERE t0.institution_id = ?
Parameters:
[
1
]
|
1.35 ms (6.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.header_id AS header_id_7 FROM header_category t0 WHERE t0.header_id = ?
Parameters:
[
1
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Bandeau | No errors. |
App\Entity\Institution | No errors. |
App\Entity\Animals | No errors. |
App\Entity\Header | No errors. |
App\Entity\HeaderCategory | No errors. |
App\Entity\HeaderItem | No errors. |
App\Entity\Footer | No errors. |
App\Entity\FooterCategory | No errors. |
App\Entity\FooterItem | No errors. |