Query Metrics
4
Database Queries
3
Different statements
0.49 ms
Query time
0
Invalid entities
18
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 ms |
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.nom_organisateur AS nom_organisateur_3, a0_.url_organisateur AS url_organisateur_4, a0_.url_billeterie AS url_billeterie_5, a0_.tel_reservation AS tel_reservation_6, a0_.en_ligne AS en_ligne_7, a0_.slug AS slug_8, a0_.event_status AS event_status_9, a0_.prive AS prive_10, a0_.high_price AS high_price_11, a0_.low_price AS low_price_12, a0_.low_price_texte AS low_price_texte_13, a0_.high_price_text AS high_price_text_14, a0_.availability AS availability_15, a0_.meta_description AS meta_description_16, a0_.date AS date_17, a0_.acces AS acces_18, a0_.raison_annulation AS raison_annulation_19, a0_.sous_titre AS sous_titre_20, a0_.description AS description_21, a0_.slug_texte AS slug_texte_22, a0_.lettre_diffusion AS lettre_diffusion_23, a0_.image_agenda AS image_agenda_24, a0_.inverse_titre_sous_titre AS inverse_titre_sous_titre_25, a0_.en_avant AS en_avant_26, a0_.resume AS resume_27, a0_.affiche AS affiche_28, a0_.old_slug AS old_slug_29, a0_.touteplage_horaire AS touteplage_horaire_30, a0_.texte_plage_horaire AS texte_plage_horaire_31, a0_.suitecrm_id AS suitecrm_id_32, a0_.spectacle_id AS spectacle_id_33, a0_.lieu_id AS lieu_id_34, a0_.structure_id AS structure_id_35, a0_.evenement_id AS evenement_id_36 FROM agenda a0_ LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id WHERE s1_.url = ? AND a0_.date_debut >= ? AND a0_.en_ligne = 1 ORDER BY a0_.date_debut ASC
Parameters:
[ "fight-impro.fr" "2026-09-09 17:08:57" ] |
| 2 | 0.10 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.description AS description_6, t0.slug AS slug_7, t0.en_ligne AS en_ligne_8, t0.archive AS archive_9, t0.annee_creation AS annee_creation_10, t0.jauge AS jauge_11, t0.slogan AS slogan_12, t0.resume_technique AS resume_technique_13, t0.duree AS duree_14, t0.genre_spectacle AS genre_spectacle_15, t0.video AS video_16, t0.priorite AS priorite_17, t0.url AS url_18, t0.argument_pro AS argument_pro_19, t0.argument_en_avant AS argument_en_avant_20, t0.titre_section_principale AS titre_section_principale_21, t0.derniere_modif AS derniere_modif_22, t0.structure_principal_id AS structure_principal_id_23, t0.image_entete_id AS image_entete_id_24, t0.affiche_id AS affiche_id_25, t0.affiche_spectacle_id AS affiche_spectacle_id_26, t0.compagnie_id AS compagnie_id_27, t0.gallerie_id AS gallerie_id_28, t0.dossier_gallerie_id AS dossier_gallerie_id_29 FROM spectacle t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0.08 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.url_site AS url_site_6, t0.telephone AS telephone_7, t0.salle_spectacle AS salle_spectacle_8 FROM lieu t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 0.07 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.url_site AS url_site_6, t0.telephone AS telephone_7, t0.salle_spectacle AS salle_spectacle_8 FROM lieu t0 WHERE t0.id = ?
Parameters:
[
127
]
|
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\Agenda | 11 |
| App\Entity\Lieu | 2 |
| App\Entity\Spectacle | 1 |
| App\Entity\Structure | 1 |
| App\Entity\Image | 1 |
| App\Entity\AfficheSpectacle | 1 |
| App\Entity\Compagnie | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Agenda | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Spectacle | No errors. |
| App\Entity\Lieu | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Distribution | No errors. |
| App\Entity\RevuePresse | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\AfficheSpectacle | No errors. |
| App\Entity\Compagnie | No errors. |
| App\Entity\Gallerie | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\SpectacleType | No errors. |
| App\Entity\Bloc | No errors. |
| App\Entity\Soutien | No errors. |
| App\Entity\TypePublic | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\CommuniquePresse | No errors. |
| App\Entity\PhotoSpectacle | No errors. |
| App\Entity\LivreDor | No errors. |
| App\Entity\Clients | No errors. |
| App\Entity\SpectaclePage | No errors. |
| App\Entity\Atelier | No errors. |