GET https://adbs.spontaneit.fr/

Query Metrics

26 Database Queries
10 Different statements
30.05 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.image_name AS image_name_4, t0.introduction AS introduction_5, t0.insert_html AS insert_html_6, t0.description AS description_7, t0.date_create AS date_create_8, t0.date_update AS date_update_9, t0.commentaire_accepte AS commentaire_accepte_10, t0.reserve_adherent AS reserve_adherent_11, t0.signature AS signature_12, t0.date_publication AS date_publication_13, t0.filename AS filename_14, t0.filename2 AS filename2_15, t0.filename3 AS filename3_16, t0.type_id AS type_id_17, t0.auteur_id AS auteur_id_18, t0.statut_id AS statut_id_19 FROM article t0 WHERE t0.statut_id = ? ORDER BY t0.date_publication DESC LIMIT 12
Parameters:
[
  2
]
2 1.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.introduction AS introduction_4, t0.description AS description_5, t0.date_publication AS date_publication_6, t0.date_update AS date_update_7, t0.illustration_liste_name AS illustration_liste_name_8, t0.illustration_detail_name AS illustration_detail_name_9, t0.meta_description AS meta_description_10, t0.user_create_id AS user_create_id_11 FROM communique t0 ORDER BY t0.date_publication DESC LIMIT 12
Parameters:
[]
3 2.55 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date_debut AS date_debut_3, e0_.date_fin AS date_fin_4, e0_.pays AS pays_5, e0_.adresse1 AS adresse1_6, e0_.adresse2 AS adresse2_7, e0_.code_postal AS code_postal_8, e0_.ville AS ville_9, e0_.alias AS alias_10, e0_.latitude AS latitude_11, e0_.longitude AS longitude_12, e0_.date_create AS date_create_13, e0_.date_update AS date_update_14, e0_.introduction AS introduction_15, e0_.insert_html AS insert_html_16, e0_.image_name AS image_name_17, e0_.commentaire_accepte AS commentaire_accepte_18, e0_.horaires AS horaires_19, e0_.reserve_adherent AS reserve_adherent_20, e0_.signature AS signature_21, e0_.filename AS filename_22, e0_.date_publication AS date_publication_23, e0_.filename2 AS filename2_24, e0_.filename3 AS filename3_25, e0_.rubrique_id AS rubrique_id_26, e0_.user_create_id AS user_create_id_27, e0_.user_update_id AS user_update_id_28, e0_.statut_id AS statut_id_29, e0_.auteur_id AS auteur_id_30 FROM evenement e0_ WHERE e0_.date_debut >= ? AND e0_.statut_id = 2 ORDER BY e0_.date_debut ASC LIMIT 12
Parameters:
[
  "2024-11-21 06:04:02"
]
4 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "thematiques"
]
5 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "regionaux"
]
6 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "sectoriels"
]
7 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "outils"
]
8 1.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[
  1093
  1
]
9 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[
  6
  1
]
10 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[
  1095
  1
]
11 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[
  1097
]
12 2.11 ms
SELECT f0_.date_debut AS date_debut_0, f0_.date_fin AS date_fin_1, f1_.name AS name_2, f1_.alias AS alias_3, f0_.modalites AS modalites_4, f0_.lieu AS lieu_5 FROM formation_session f0_ INNER JOIN formation f1_ ON f0_.formation_id = f1_.id WHERE f0_.date_debut >= ? GROUP BY f0_.id LIMIT 4
Parameters:
[
  "2024-11-21 06:04:02"
]
13 2.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.image_name AS image_name_4, t0.lien_libelle AS lien_libelle_5, t0.lien_url AS lien_url_6, t0.couleur AS couleur_7, t0.ordre AS ordre_8, t0.date_update AS date_update_9 FROM slider_accueil t0 ORDER BY t0.ordre ASC
Parameters:
[]
14 0.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN evenement_groupe ON t0.id = evenement_groupe.groupe_id WHERE evenement_groupe.evenement_id = ?
Parameters:
[
  292419
]
15 1.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  184
]
16 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  183
]
17 1.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  181
]
18 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  180
]
19 1.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  182
]
20 1.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  148
]
21 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  169
]
22 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  172
]
23 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  176
]
24 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  171
]
25 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  175
]
26 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  177
]

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\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\User No errors.
App\Entity\Statut No errors.
App\Entity\Groupe No errors.
App\Entity\Thematique No errors.
App\Entity\ArticleLien No errors.
App\Entity\ArticleCommentaire No errors.
App\Entity\Communique No errors.
App\Entity\Evenement No errors.
App\Entity\EvenementRubrique No errors.
App\Entity\EvenementType No errors.
App\Entity\Metier
  • The association App\Entity\Metier#formations refers to the owning side field App\Entity\Formation#metiers which does not exist.
App\Entity\EvenementCommentaire No errors.
App\Entity\EvenementLien No errors.
App\Entity\GroupeType No errors.
App\Entity\Segment No errors.
App\Entity\UserGroupeException No errors.
App\Entity\Partenaire No errors.
App\Entity\CompteRenduReunion No errors.
App\Entity\FormationSession No errors.
App\Entity\Formation No errors.
App\Entity\SliderAccueil No errors.