Query Metrics

3 Database Queries
3 Different statements
5.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.61 ms
(48.79%)
1
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-13 09:17:07"
  "2025-12-13 09:17:07"
  1
]
1.46 ms
(27.35%)
1
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-13 09:17:07"
  "2025-12-13 09:17:07"
  1
  "5e077b90-8b34-4a87-9d43-321b1bc401f5"
]
1.27 ms
(23.85%)
1
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-13 09:17:07"
  "2025-12-13 09:17:07"
  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