Query Metrics
8
Database Queries
7
Different statements
388.39 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
316.67 ms (81.53%) |
1 |
SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"victoriapaton12@gmail.com"
]
|
52.58 ms (13.54%) |
1 |
"COMMIT"
Parameters:
[] |
5.63 ms (1.45%) |
2 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.date AS date_3, t0.idblog AS idblog_4, t0.descreption AS descreption_5, t0.idposition AS idposition_6, t0.idref AS idref_7, t0.iduser AS iduser_8 FROM attachment t0 WHERE t0.id = ?
Parameters:
[
701
]
|
4.84 ms (1.25%) |
1 |
INSERT INTO user (nbconnx, username, adresse, fonction, etablisment, numMobile, logourl, Datedepart, dateFlagDepot, flagDepot, nom, prenom, roles, email, password, salt, date_creation, nometablisment, randomnotice, infocomple, reponseemail, password_non_cripted, cnxparent, accompaplus, activatemail, Jeton, showpubprod, showdetailsalbum, showdetailslivre, showdetailsphotos, showdetailsretros, showdetailscal, cnxpartenaire, smsnotif, mailnotif, AccoPlusToPartenaire, jetonAccoPlusSejourGratuit, adresslivraison, adressfactoration, statut, usersecondaire, comptebanque, idFonction_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "victoriapaton12@gmail.com" null null null "0620423953" null null null null "Paton" "Véronique " "["ROLE_PARENT"]" "victoriapaton12@gmail.com" "$2y$13$tOPH18AMifyeoNm6EhAR5.3ZKrZkpNkCpVBV1/.4ukxcKMn331AzG" null "2025-05-18 15:26:06" null null null null null null null null null true null null null null null null 1 0 null null null null null null null null ] |
3.40 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.typeemail AS typeemail_3, t0.id_user_creation AS id_user_creation_4, t0.id_image1 AS id_image1_5, t0.id_image2 AS id_image2_6, t0.statut AS statut_7, t0.id_destinataire AS id_destinataire_8 FROM emailing t0 WHERE t0.typeemail = ? AND t0.statut = ? LIMIT 1
Parameters:
[ 26 9 ] |
2.78 ms (0.72%) |
1 |
SELECT t0.id AS id_1, t0.libiller AS libiller_2, t0.code AS code_3, t0.typeref AS typeref_4 FROM ref t0 WHERE t0.id = ?
Parameters:
[
26
]
|
2.49 ms (0.64%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\User |
|
App\Entity\Adress | No errors. |
App\Entity\Ref | No errors. |
App\Entity\Comptebancaire | No errors. |
App\Entity\Fonctions | No errors. |
App\Entity\Commande |
|
App\Entity\Etablisment | No errors. |
App\Entity\Blog |
|
App\Entity\Sejour |
|
App\Entity\SejourAttachment | No errors. |
App\Entity\Panier | No errors. |
App\Entity\Etiquette | No errors. |
App\Entity\CommentaireEtiquette | No errors. |
App\Entity\LogPromotions | No errors. |
App\Entity\PromoParents | No errors. |
App\Entity\Photonsumeriques | No errors. |
App\Entity\Typeref | No errors. |
App\Entity\Promotions | No errors. |
App\Entity\Emailing | No errors. |
App\Entity\Attachment | No errors. |
App\Entity\Position | No errors. |