Query Metrics
36
Database Queries
11
Different statements
27.05 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.99 ms (48.03%) |
21 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.description AS description_4, t0.disponibilite AS disponibilite_5, t0.unite_mesure AS unite_mesure_6, t0.type_prix AS type_prix_7, t0.prix AS prix_8, t0.stock AS stock_9, t0.valide AS valide_10, t0.feature AS feature_11, t0.terminal AS terminal_12, t0.active AS active_13, t0.localite_id AS localite_id_14, t0.utilisateur_id AS utilisateur_id_15, t0.categorie_id AS categorie_id_16 FROM produits t0 WHERE t0.categorie_id = ?
Parameters:
[
7
]
|
|
4.60 ms (17.02%) |
6 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.lien AS lien_3, t0.produit_id AS produit_id_4 FROM images_produits t0 WHERE t0.produit_id = ?
Parameters:
[
12
]
|
|
2.62 ms (9.67%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.description AS description_4, t0.disponibilite AS disponibilite_5, t0.unite_mesure AS unite_mesure_6, t0.type_prix AS type_prix_7, t0.prix AS prix_8, t0.stock AS stock_9, t0.valide AS valide_10, t0.feature AS feature_11, t0.terminal AS terminal_12, t0.active AS active_13, t0.localite_id AS localite_id_14, t0.utilisateur_id AS utilisateur_id_15, t0.categorie_id AS categorie_id_16 FROM produits t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"riz-etu-2"
]
|
|
2.16 ms (7.97%) |
1 |
SELECT t0.id AS id_1, t0.lib_quart AS lib_quart_2, t0.arrondissement_id AS arrondissement_id_3 FROM quartier t0 WHERE t0.id = ?
Parameters:
[
1255
]
|
|
0.93 ms (3.42%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.84 ms (3.12%) |
1 |
SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.email AS email_7, t0.sexe AS sexe_8, t0.adresse AS adresse_9, t0.secteur_activite AS secteur_activite_10, t0.terminal AS terminal_11, t0.is_verified AS is_verified_12, t0.fcm_token AS fcm_token_13, t0.localite_id AS localite_id_14 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
16
]
|
|
0.75 ms (2.78%) |
1 |
SELECT t0.id AS id_1, t0.adresse_ip AS adresse_ip_2, t0.premiere_connection AS premiere_connection_3, t0.derniere_connexion AS derniere_connexion_4, t0.nb_visite AS nb_visite_5 FROM visiteurs t0 WHERE t0.adresse_ip = ? LIMIT 1
Parameters:
[
"216.73.216.84"
]
|
|
0.70 ms (2.59%) |
1 |
SELECT t0.derniere_connexion AS derniere_connexion_1, t0.nb_visite AS nb_visite_2, t0.produit_id AS produit_id_3, t0.visiteur_id AS visiteur_id_4 FROM produitstatsvisite t0 WHERE t0.visiteur_id = ? AND t0.produit_id = ? LIMIT 1
Parameters:
[ 297 12 ] |
|
0.65 ms (2.42%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.images AS images_4, t0.parent_id AS parent_id_5 FROM categorie_produits t0
Parameters:
[] |
|
0.50 ms (1.85%) |
1 |
INSERT INTO produitstatsvisite (derniere_connexion, nb_visite, produit_id, visiteur_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "2026-01-27 12:42:40" 2 => 1 3 => 12 4 => 297 ] |
|
0.31 ms (1.13%) |
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\Produits | No errors. |
| App\Entity\Quartier |
|
| App\Entity\User |
|
| App\Entity\CategorieProduits | No errors. |
| App\Entity\ImagesProduits | No errors. |
| App\Entity\LignesCommandes | No errors. |
| App\Entity\Panier | No errors. |
| App\Entity\Produitstatsvisite |
|
| App\Entity\FavorisProduits | No errors. |
| App\Entity\Visiteurs | No errors. |
| App\Entity\Arrondissement | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Commandes | No errors. |
| App\Entity\AdresseLivraison | No errors. |
| App\Entity\ApiToken |
|