Query Metrics

27 Database Queries
19 Different statements
2.32 ms Query time
2 Invalid entities
14 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.34 ms
(14.54%)
6
SELECT 'main'
Parameters:
[]
0.25 ms
(10.69%)
2
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
Parameters:
[]
0.21 ms
(9.05%)
1
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 LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id WHERE a0_.date_debut > ? AND a0_.en_ligne = ? AND (s1_.url = ? OR s2_.url = ?) AND a0_.prive = 0 ORDER BY a0_.date_debut ASC LIMIT 3
Parameters:
[
  "2026-09-09 12:04:41"
  1
  "fight-impro.fr"
  "fight-impro.fr"
]
0.16 ms
(6.72%)
1
SELECT t.name AS table_name,
                   c.*
              FROM sqlite_master t
              JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, c.cid
Parameters:
[
  "doctrine_migration_versions"
]
0.15 ms
(6.37%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "fight-impro.fr"
]
0.15 ms
(6.34%)
1
SELECT e0_.id AS id_0, e0_.titre AS titre_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.doc_pdf AS doc_pdf_4, e0_.resume AS resume_5, e0_.texte AS texte_6, e0_.affiche AS affiche_7, e0_.structure_principale_id AS structure_principale_id_8 FROM evenement e0_ LEFT JOIN structure s1_ ON e0_.structure_principale_id = s1_.id LEFT JOIN evenement_structure e3_ ON e0_.id = e3_.evenement_id LEFT JOIN structure s2_ ON s2_.id = e3_.structure_id WHERE s1_.url = ? OR s2_.url = ? ORDER BY e0_.date_fin DESC LIMIT 1
Parameters:
[
  "fight-impro.fr"
  "fight-impro.fr"
]
0.14 ms
(6.03%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM agenda a0_ LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id WHERE a0_.date_debut > ? AND a0_.en_ligne = ? AND (s1_.url = ? OR s2_.url = ?) AND a0_.prive = 0 ORDER BY a0_.date_debut ASC) dctrn_result) dctrn_table
Parameters:
[
  "2026-09-09 12:04:41"
  1
  "fight-impro.fr"
  "fight-impro.fr"
]
0.11 ms
(4.82%)
2
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "doctrine_migration_versions"
]
0.09 ms
(3.93%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.09 ms
(3.79%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.credits AS credits_3, t0.nom_fichier AS nom_fichier_4, t5.id AS id_6, t5.titre AS titre_7, t5.meta_title AS meta_title_8, t5.meta_description AS meta_description_9, t5.resume AS resume_10, t5.description AS description_11, t5.slug AS slug_12, t5.en_ligne AS en_ligne_13, t5.archive AS archive_14, t5.annee_creation AS annee_creation_15, t5.jauge AS jauge_16, t5.slogan AS slogan_17, t5.resume_technique AS resume_technique_18, t5.duree AS duree_19, t5.genre_spectacle AS genre_spectacle_20, t5.video AS video_21, t5.priorite AS priorite_22, t5.url AS url_23, t5.argument_pro AS argument_pro_24, t5.argument_en_avant AS argument_en_avant_25, t5.titre_section_principale AS titre_section_principale_26, t5.derniere_modif AS derniere_modif_27, t5.structure_principal_id AS structure_principal_id_28, t5.image_entete_id AS image_entete_id_29, t5.affiche_id AS affiche_id_30, t5.affiche_spectacle_id AS affiche_spectacle_id_31, t5.compagnie_id AS compagnie_id_32, t5.gallerie_id AS gallerie_id_33, t5.dossier_gallerie_id AS dossier_gallerie_id_34 FROM affiche_spectacle t0 LEFT JOIN spectacle t5 ON t5.affiche_spectacle_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.09 ms
(3.75%)
1
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.date_debut AS date_debut_3, a0_.date_fin AS date_fin_4, a0_.jour AS jour_5, a0_.duree AS duree_6, a0_.duree_seance AS duree_seance_7, a0_.tarif AS tarif_8, a0_.horaire AS horaire_9, a0_.type AS type_10, a0_.url_inscription AS url_inscription_11, a0_.slug AS slug_12, a0_.meta_description AS meta_description_13, a0_.meta_title AS meta_title_14, a0_.en_ligne AS en_ligne_15, a0_.titre_court AS titre_court_16, a0_.age_min AS age_min_17, a0_.age_max AS age_max_18, a0_.affiche_sur_accueil AS affiche_sur_accueil_19, a0_.image_entete AS image_entete_20, a0_.resume AS resume_21, a0_.structure_principale_id AS structure_principale_id_22, a0_.lieu_id AS lieu_id_23, a0_.organisateur_id AS organisateur_id_24 FROM atelier a0_ LEFT JOIN atelier_structure a2_ ON a0_.id = a2_.atelier_id LEFT JOIN structure s1_ ON s1_.id = a2_.structure_id WHERE a0_.affiche_sur_accueil = ? AND a0_.date_debut >= ? AND (a0_.structure_principale_id = ? OR s1_.id = ?) ORDER BY a0_.date_debut ASC
Parameters:
[
  1
  "2026-09-09 00:00:00"
  1
  1
]
0.08 ms
(3.63%)
1
SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq
Parameters:
[
  "doctrine_migration_versions"
]
0.08 ms
(3.62%)
1
SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq
Parameters:
[
  "doctrine_migration_versions"
]
0.08 ms
(3.32%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.nom_fichier AS nom_fichier_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5, t0.credits AS credits_6, t0.en_ligne AS en_ligne_7, t0.slug AS slug_8, t0.legende AS legende_9, t0.nom AS nom_10, t0.ordre AS ordre_11 FROM photo_spectacle t0 INNER JOIN spectacle_photo_spectacle ON t0.id = spectacle_photo_spectacle.photo_spectacle_id WHERE spectacle_photo_spectacle.spectacle_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.08 ms
(3.24%)
1
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
]
0.06 ms
(2.71%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]
0.06 ms
(2.67%)
1
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
]
0.06 ms
(2.41%)
1
SELECT * FROM PRAGMA_TABLE_INFO (?)
Parameters:
[
  "doctrine_migration_versions"
]
0.05 ms
(2.36%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.credits AS credits_3, t0.fichier AS fichier_4, t0.nom AS nom_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\PhotoSpectacle 4
App\Entity\Structure 2
App\Entity\Agenda 2
App\Entity\Evenement 1
App\Entity\Spectacle 1
App\Entity\Lieu 1
App\Entity\Image 1
App\Entity\AfficheSpectacle 1
App\Entity\Compagnie 1

Entities Mapping

Class Mapping errors
App\Entity\Structure No errors.
App\Entity\Article No errors.
App\Entity\Spectacle No errors.
App\Entity\Agenda No errors.
App\Entity\RevuePresse No errors.
App\Entity\Atelier No errors.
App\Entity\Bloc No errors.
App\Entity\SpectacleType No errors.
App\Entity\Evenement No errors.
App\Entity\Equipe No errors.
App\Entity\CommuniquePresse No errors.
App\Entity\Lettre\Abonne No errors.
App\Entity\Lettre\LettreDiffusion
  • The association App\Entity\Lettre\LettreDiffusion#articles refers to the inverse side field App\Entity\Article#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#Presse refers to the inverse side field App\Entity\RevuePresse#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#photoSpectacle refers to the inverse side field App\Entity\PhotoSpectacle#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#imageCompagnie refers to the inverse side field App\Entity\Image#lettreDiffusions which does not exist.
App\Entity\Soutien No errors.
App\Entity\Dossier No errors.
App\Entity\MenuSite No errors.
App\Entity\Utilisateur No errors.
App\Entity\Rubrique No errors.
App\Entity\Image No errors.
App\Entity\PhotoSpectacle No errors.
App\Entity\Gallerie No errors.
App\Entity\AfficheSpectacle No errors.
App\Entity\TypePublic No errors.
App\Entity\Distribution No errors.
App\Entity\Compagnie No errors.
App\Entity\LivreDor No errors.
App\Entity\Clients No errors.
App\Entity\SpectaclePage No errors.
App\Entity\Lieu No errors.
App\Entity\Organisateur No errors.
App\Entity\Page No errors.
App\Entity\MotCle
  • The association App\Entity\MotCle#structure refers to the inverse side field App\Entity\Structure#tags which does not exist.
App\Entity\Role No errors.
App\Entity\Lettre\Categorie No errors.
App\Entity\LieuSuitecrmMapping No errors.
App\Entity\Galerie No errors.
App\Entity\SpectacleSuitecrmMapping No errors.
Vich\UploaderBundle\Entity\File No errors.