Query Metrics
7
Database Queries
7
Different statements
38.40 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.88 ms (33.54%) |
1 |
SELECT t0.id AS id_1, t0.ville_nom_reel AS ville_nom_reel_2, t0.ville_nom AS ville_nom_3, t0.ville_code_postal AS ville_code_postal_4, t0.ville_longitude_deg AS ville_longitude_deg_5, t0.ville_latitude_deg AS ville_latitude_deg_6, t0.ville_slug AS ville_slug_7, t0.departements_id AS departements_id_8 FROM villes t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"Option2"
]
|
10.10 ms (26.30%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.email = ? LIMIT 2
Parameters:
[
"ldmokzpd@do-not-respond.me"
]
|
7.70 ms (20.06%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM pays t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"1"
]
|
3.43 ms (8.94%) |
1 |
"COMMIT"
Parameters:
[] |
3.30 ms (8.60%) |
1 |
INSERT INTO user (email, roles, password, civilite, nom, prenom, raison_sociale, siret, tva, adresse, code_postal, telephone, logo, type, actif, credits, created, token_mobile, villes_id, pays_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "ldmokzpd@do-not-respond.me" "["ROLE_PART"]" "$2y$10$FDP5rg6s4uoqa5vNf0czPeX1Gcq4zfPpxR183TUaZa6W9ZfRK5Qi." "Choisissez..." "Hello" "John" null null null "John" "Hello" "John" null "part" 1 0 "2025-02-27 10:15:02" null null 1 ] |
0.71 ms (1.84%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"ldmokzpd@do-not-respond.me"
]
|
0.28 ms (0.72%) |
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\Pays | No errors. |
App\Entity\User | No errors. |
App\Entity\Villes | No errors. |
App\Entity\Alertes | No errors. |
App\Entity\Categories | No errors. |
App\Entity\Departements | No errors. |
App\Entity\Favoris | No errors. |
App\Entity\Annonces | No errors. |
App\Entity\NotesEnseignes |
|
App\Entity\NotesAnnonces | No errors. |
App\Entity\Commandes | No errors. |
App\Entity\Factures | No errors. |