Query Metrics

1574 Database Queries
6 Different statements
535.53 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
172.03 ms
(32.12%)
393
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.adresse AS adresse_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.tel AS tel_8, t0.tel_comment AS tel_comment_9, t0.tel2 AS tel2_10, t0.email AS email_11, t0.formalites AS formalites_12, t0.frequence_contact AS frequence_contact_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.meteo AS meteo_16, t0.client_id AS client_id_17 FROM capitainerie t0 INNER JOIN evenement_capitainerie ON t0.id = evenement_capitainerie.capitainerie_id WHERE evenement_capitainerie.evenement_id = ?
Parameters:
[
  8844
]
118.93 ms
(22.21%)
393
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5 FROM image t0 INNER JOIN evenement_image ON t0.id = evenement_image.image_id WHERE evenement_image.evenement_id = ?
Parameters:
[
  8844
]
113.18 ms
(21.13%)
393
SELECT t0.id AS id_1, t0.icone AS icone_2, t0.lien AS lien_3, t0.evenement_id AS evenement_id_4, t0.actualite_id AS actualite_id_5, t0.partenaire_id AS partenaire_id_6, t0.capitainerie_id AS capitainerie_id_7 FROM reseau t0 WHERE t0.evenement_id = ?
Parameters:
[
  8844
]
100.56 ms
(18.78%)
393
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.entite_id AS entite_id_4, t0.partenaire_id AS partenaire_id_5, t0.evenement_id AS evenement_id_6, t0.actualite_id AS actualite_id_7, t0.capitainerie_id AS capitainerie_id_8 FROM lien t0 WHERE t0.evenement_id = ?
Parameters:
[
  8844
]
30.58 ms
(5.71%)
1
SELECT e0_.id AS id_0, e0_.description AS description_1, e0_.titre AS titre_2, e0_.create_at AS create_at_3, e0_.update_at AS update_at_4, e0_.adresse AS adresse_5, e0_.cp AS cp_6, e0_.ville AS ville_7, e0_.tel AS tel_8, e0_.tel2 AS tel2_9, e0_.email AS email_10, e0_.latitude AS latitude_11, e0_.longitude AS longitude_12, e0_.date_debut AS date_debut_13, e0_.heure_debut AS heure_debut_14, e0_.date_fin AS date_fin_15, e0_.heure_fin AS heure_fin_16, e0_.tourin_soft_id AS tourin_soft_id_17, e0_.est_synchronise AS est_synchronise_18, e0_.est_epingle AS est_epingle_19, e0_.client_id AS client_id_20 FROM evenement e0_ INNER JOIN evenement_capitainerie e2_ ON e0_.id = e2_.evenement_id INNER JOIN capitainerie c1_ ON c1_.id = e2_.capitainerie_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?) AND e0_.date_fin >= ? GROUP BY e0_.id ORDER BY e0_.est_epingle DESC, e0_.date_debut ASC LIMIT 500
Parameters:
[
  28
  29
  30
  31
  32
  33
  34
  "2026-01-30 13:10:14"
]
0.25 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_type AS image_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.version AS version_8, t0.latest_features AS latest_features_9, t0.code AS code_10 FROM client t0 WHERE t0.id = ?
Parameters:
[
  17
]

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

Class Mapping errors
App\Entity\Evenement No errors.
App\Entity\Capitainerie
  • The association App\Entity\Capitainerie#image refers to the owning side field App\Entity\Image#capitainerie which does not exist.
  • The mappings App\Entity\Capitainerie#piece_joint and App\Entity\PieceJointe#capitainerie are inconsistent with each other.
App\Entity\Client
  • The association App\Entity\Client#partenaire refers to the inverse side field App\Entity\Partenaire#clients which does not exist.
App\Entity\Lien
  • The association App\Entity\Lien#entite refers to the inverse side field App\Entity\Entite#liens which does not exist.
  • The association App\Entity\Lien#partenaire refers to the inverse side field App\Entity\Partenaire#liens which does not exist.
App\Entity\Reseau No errors.
App\Entity\Image No errors.
App\Entity\Saison No errors.
App\Entity\Annuaire No errors.
App\Entity\CapitainerieService
  • The mappings App\Entity\CapitainerieService#icone and App\Entity\Icone#capitainerieServices are inconsistent with each other.
App\Entity\PieceJointe
  • The association App\Entity\PieceJointe#capitainerie refers to the inverse side field App\Entity\Capitainerie#piece_jointe which does not exist.
App\Entity\Actualite No errors.
App\Entity\Institution No errors.
App\Entity\Camera No errors.
App\Entity\Administrateur
  • The association App\Entity\Administrateur#client refers to the inverse side field App\Entity\Client#administrateurs which does not exist.
App\Entity\Partenaire
  • The association App\Entity\Partenaire#capitainerie refers to the inverse side field App\Entity\Capitainerie#partenaires which does not exist.
  • The association App\Entity\Partenaire#image refers to the owning side field App\Entity\Image#partenaire which does not exist.
App\Entity\Entite
  • The association App\Entity\Entite#capitainerie refers to the inverse side field App\Entity\Capitainerie#entite which does not exist.
  • The association App\Entity\Entite#images refers to the owning side field App\Entity\Image#entite which does not exist.
App\Entity\Categorie No errors.
App\Entity\MobileApp No errors.