Query Metrics
14
Database Queries
9
Different statements
16.70 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.31 ms (25.81%) |
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
]
|
3.20 ms (19.15%) |
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.83 ms (10.99%) |
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.75 ms (10.49%) |
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:
[
2
]
|
1.23 ms (7.36%) |
1 |
SELECT h0_.id AS id_0 FROM header h0_ ORDER BY h0_.id DESC LIMIT 1
Parameters:
[] |
1.16 ms (6.94%) |
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:
[
2
]
|
1.13 ms (6.75%) |
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
]
|
1.09 ms (6.55%) |
1 |
SELECT f0_.id AS id_0 FROM footer f0_ ORDER BY f0_.id DESC LIMIT 1
Parameters:
[] |
1.00 ms (5.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
]
|
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\AnimalEvents | No errors. |
App\Entity\Footer | No errors. |
App\Entity\FooterCategory | No errors. |
App\Entity\FooterItem | No errors. |