Query Metrics
3
Database Queries
3
Different statements
4.23 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.33 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.position AS position_1 FROM slider s0_ LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id AND m1_.discr IN ('media_slider') LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_slider') WHERE s0_.start_date IS NOT NULL AND s0_.start_date < ? AND s0_.end_date IS NOT NULL AND s0_.end_date > ? AND s0_.online = ? ORDER BY s0_.position ASC LIMIT 30
Parameters:
[ "2025-12-11 21:41:41" "2025-12-11 21:41:41" 1 ] |
| 2 | 1.09 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.position AS position_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.online AS online_5, s0_.cible AS cible_6, s0_.url AS url_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.deleted_at AS deleted_at_13, m1_.file_path AS file_path_14, m2_.id AS id_15, m2_.created_at AS created_at_16, m2_.updated_at AS updated_at_17, m2_.deleted_at AS deleted_at_18, m2_.file_path AS file_path_19, m1_.discr AS discr_20, m1_.object_id AS object_id_21, m2_.discr AS discr_22, m2_.object_id AS object_id_23 FROM slider s0_ LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id AND m1_.discr IN ('media_slider') LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_slider') WHERE s0_.start_date IS NOT NULL AND s0_.start_date < ? AND s0_.end_date IS NOT NULL AND s0_.end_date > ? AND s0_.online = ? AND s0_.id IN (?) ORDER BY s0_.position ASC
Parameters:
[ "2025-12-11 21:41:41" "2025-12-11 21:41:41" 1 "5e077b90-8b34-4a87-9d43-321b1bc401f5" ] |
| 3 | 0.81 ms |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM slider s0_ LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id AND m1_.discr IN ('media_slider') LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_slider') WHERE s0_.start_date IS NOT NULL AND s0_.start_date < ? AND s0_.end_date IS NOT NULL AND s0_.end_date > ? AND s0_.online = ?
Parameters:
[ "2025-12-11 21:41:41" "2025-12-11 21:41:41" 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\Slider | No errors. |
| App\Entity\MediaObject\MediaObject | No errors. |
| App\Entity\MediaObject\MediaSlider | No errors. |
| App\Entity\MediaObject\MediaMobileSlider | No errors. |
| App\Entity\Menu | No errors. |