Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.28 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.14 ms (48.28%)	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"`] View formatted query View runnable query Explain query 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 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 = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr' ORDER BY e0_.date_fin DESC LIMIT 1;
0.08 ms (27.46%)	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.url = ? LIMIT 1 Parameters: [`"fight-impro.fr"`] View formatted query View runnable query Explain query 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 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 = 'fight-impro.fr' LIMIT 1;
0.07 ms (24.27%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 5;

Time▼

Count

Info

0.14 ms
(48.28%)

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"
]

View formatted query View runnable query Explain query

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

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 = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr' ORDER BY e0_.date_fin DESC LIMIT 1;

0.08 ms
(27.46%)

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"
]

View formatted query View runnable query Explain query

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

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 = 'fight-impro.fr' LIMIT 1;

0.07 ms
(24.27%)

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
]

View formatted query View runnable query Explain query

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 = ?

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 = 5;

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\Structure	2
App\Entity\Evenement	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.

Symfony Profiler

GET https://fight-impro.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CEvenementController%253A%253AprochainEvenement

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping