https://eyobu.fuprobenin.org/categorie/Banane-e-derives

Method
GET
HTTP Status
200
IP
216.73.216.84
Profiled on
Token
48f89a

Query Metrics

22 Database Queries
3 Different statements
15.86 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.54 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 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "Banane-e-derives"
]
View formatted query    View runnable query    Explain query
2 0.81 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
3 0.56 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
4 0.78 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
5 0.76 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
6 0.59 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
7 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
8 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: 
[
  5
]
View formatted query    View runnable query    Explain query
9 0.74 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
10 0.55 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
11 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: 
[
  8
]
View formatted query    View runnable query    Explain query
12 0.67 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
13 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: 
[
  11
]
View formatted query    View runnable query    Explain query
14 0.54 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
15 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
16 0.55 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
17 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: 
[
  16
]
View formatted query    View runnable query    Explain query
18 0.59 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
19 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: 
[
  18
]
View formatted query    View runnable query    Explain query
20 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: 
[
  19
]
View formatted query    View runnable query    Explain query
21 0.58 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
22 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: 
[
  21
]
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\CategorieProduits No 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\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.