https://eyobu.fuprobenin.org/produits/ventes-ventes

Method
GET
HTTP Status
200
IP
216.73.216.84
Profiled on
Token
16d0ee

Query Metrics

36 Database Queries
11 Different statements
19.75 ms Query time
4 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.50 ms 
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: 
[
  "ventes-ventes"
]
View formatted query    View runnable query    Explain query
2 0.84 ms 
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"
]
View formatted query    View runnable query    Explain query
3 0.74 ms 
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
  26
]
View formatted query    View runnable query    Explain query
4 0.34 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.44 ms 
INSERT INTO produitstatsvisite (derniere_connexion, nb_visite, produit_id, visiteur_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  1 => "2026-01-27 12:01:55"
  2 => 1
  3 => 26
  4 => 297
]
View formatted query    View runnable query    Explain query
6 0.31 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.60 ms 
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
]
View formatted query    View runnable query    Explain query
8 0.65 ms 
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: 
[]
View formatted query    View runnable query    Explain query
9 0.56 ms 
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: 
[
  1
]
View formatted query    View runnable query    Explain query
10 0.51 ms 
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: 
[
  2
]
View formatted query    View runnable query    Explain query
11 0.47 ms 
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: 
[
  3
]
View formatted query    View runnable query    Explain query
12 0.57 ms 
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: 
[
  4
]
View formatted query    View runnable query    Explain query
13 0.42 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
14 0.52 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
15 0.50 ms 
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
]
View formatted query    View runnable query    Explain query
16 0.85 ms 
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: 
[
  8
]
View formatted query    View runnable query    Explain query
17 0.48 ms 
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: 
[
  9
]
View formatted query    View runnable query    Explain query
18 0.49 ms 
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: 
[
  11
]
View formatted query    View runnable query    Explain query
19 0.46 ms 
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: 
[
  12
]
View formatted query    View runnable query    Explain query
20 0.48 ms 
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: 
[
  13
]
View formatted query    View runnable query    Explain query
21 0.37 ms 
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: 
[
  14
]
View formatted query    View runnable query    Explain query
22 0.35 ms 
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: 
[
  15
]
View formatted query    View runnable query    Explain query
23 0.34 ms 
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: 
[
  16
]
View formatted query    View runnable query    Explain query
24 0.34 ms 
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: 
[
  17
]
View formatted query    View runnable query    Explain query
25 0.35 ms 
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: 
[
  18
]
View formatted query    View runnable query    Explain query
26 0.34 ms 
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: 
[
  19
]
View formatted query    View runnable query    Explain query
27 0.42 ms 
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: 
[
  20
]
View formatted query    View runnable query    Explain query
28 0.37 ms 
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: 
[
  21
]
View formatted query    View runnable query    Explain query
29 0.56 ms 
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: 
[
  26
]
View formatted query    View runnable query    Explain query
30 0.50 ms 
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: 
[
  25
]
View formatted query    View runnable query    Explain query
31 0.94 ms 
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: 
[
  5153
]
View formatted query    View runnable query    Explain query
32 0.40 ms 
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: 
[
  10
]
View formatted query    View runnable query    Explain query
33 0.34 ms 
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: 
[
  11
]
View formatted query    View runnable query    Explain query
34 0.35 ms 
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
]
View formatted query    View runnable query    Explain query
35 0.40 ms 
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: 
[
  13
]
View formatted query    View runnable query    Explain query
36 0.65 ms 
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: 
[
  14
]
View formatted query    View runnable query    Explain query

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
  • The mappings App\Entity\Quartier#produit and App\Entity\User#localite are inconsistent with each other.
App\Entity\User
  • The mappings App\Entity\User#fcm_tokens and App\Entity\ApiToken#utilisateur are inconsistent with each other.
App\Entity\CategorieProduits No errors.
App\Entity\ImagesProduits No errors.
App\Entity\LignesCommandes No errors.
App\Entity\Panier No errors.
App\Entity\Produitstatsvisite
  • The association App\Entity\Produitstatsvisite#visiteur refers to the inverse side field App\Entity\Visiteurs#stats which does not exist.
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
  • The association App\Entity\ApiToken#utilisateur refers to the inverse side field App\Entity\User#fcm_token which is not defined as association.
  • The association App\Entity\ApiToken#utilisateur refers to the inverse side field App\Entity\User#fcm_token which does not exist.