Query Metrics

4 Database Queries
2 Different statements
0.53 ms Query time
0 Invalid entities
16 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.35 ms
(65.56%)
3
SELECT e0_.id AS id_0, e0_.prenom AS prenom_1, e0_.nom AS nom_2, e0_.bio AS bio_3, e0_.affiche AS affiche_4, e0_.url AS url_5, e0_.linkedin AS linkedin_6, e0_.photo_portrait AS photo_portrait_7, e0_.credit_photo AS credit_photo_8, e0_.archive AS archive_9, e0_.membre AS membre_10, e0_.facebook AS facebook_11, e0_.instagram AS instagram_12, e0_.lien_bio AS lien_bio_13 FROM equipe e0_ LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id WHERE e0_.affiche = 1 AND e0_.membre = ? AND e0_.archive = ? AND s1_.url = ? ORDER BY e0_.nom ASC
Parameters:
[
  1
  0
  "fight-impro.fr"
]
0.18 ms
(34.44%)
1
SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN ? AND ?) GROUP BY e0_.prenom
Parameters:
[
  "2026-08-01 00:00:00"
  "2027-08-01 00:00:00"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Equipe 16

Entities Mapping

Class Mapping errors
App\Entity\Equipe No errors.
App\Entity\Structure No errors.
App\Entity\Distribution No errors.
App\Entity\Agenda No errors.