Query Metrics

45 Database Queries
3 Different statements
26.64 ms Query time
0 Invalid entities
54 Managed entities

Queries

Group similar statements

# Time Info
1 6.82 ms
SELECT u0_.uid AS uid_0, u0_.username AS username_1, u0_.password AS password_2, u0_.username_externe_inaturalist AS username_externe_inaturalist_3, u0_.id_externe_kollect AS id_externe_kollect_4, u0_.forgotpassword_key AS forgotpassword_key_5, u0_.token_suppression_compte AS token_suppression_compte_6, u0_.mail_transitoire_code_verif AS mail_transitoire_code_verif_7, u0_.mail AS mail_8, u0_.mail_transitoire AS mail_transitoire_9, u0_.prenom AS prenom_10, u0_.nom AS nom_11, u0_.utilisation_perso_newsletter AS utilisation_perso_newsletter_12, u0_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_13, u0_.creation_en_interne AS creation_en_interne_14, u0_.date_creation_compte AS date_creation_compte_15, u0_.date_suppression_compte AS date_suppression_compte_16, u0_.date_derniere_connexion AS date_derniere_connexion_17, u0_.utilisation_perso_commentaire AS utilisation_perso_commentaire_18, u0_.user_simulation AS user_simulation_19 FROM ipn_user.utilisateur u0_ INNER JOIN ipn_photo.photo_taxon p1_ ON (u0_.uid = p1_.gestionnaire) WHERE p1_.id_licence <> 'Copyright' GROUP BY u0_.uid, u0_.nom, u0_.prenom
Parameters:
[]
2 1.01 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1263
]
3 0.52 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  644
]
4 0.44 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  366
]
5 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  220
]
6 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  18
]
7 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1062
]
8 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  2540
]
9 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1295
]
10 0.44 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  498
]
11 0.44 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  234
]
12 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1057
]
13 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  226
]
14 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  210
]
15 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1513
]
16 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  503
]
17 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1834
]
18 0.40 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  26
]
19 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1273
]
20 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  641
]
21 0.43 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  117
]
22 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1835
]
23 0.48 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  689
]
24 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  540
]
25 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1777
]
26 0.40 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  364
]
27 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  236
]
28 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1064
]
29 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  196
]
30 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  251
]
31 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  786
]
32 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  14
]
33 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  301
]
34 0.44 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1582
]
35 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  619
]
36 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  20
]
37 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  3316
]
38 0.42 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  262
]
39 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  1230
]
40 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  694
]
41 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  362
]
42 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  594
]
43 0.40 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  16
]
44 0.41 ms
SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = ?
Parameters:
[
  570
]
45 1.10 ms
SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = ?
Parameters:
[
  1
]

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\User 43
App\Entity\Droits\ValidationDonneesCache 11