https://eyobu.fuprobenin.org/

Query Metrics

34 Database Queries
5 Different statements
20.71 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.92 ms
(47.89%)
20
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
]
4.39 ms
(21.20%)
10
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:
[
  31
]
3.77 ms
(18.21%)
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.active = ? ORDER BY t0.id DESC LIMIT 10
Parameters:
[
  1
]
1.47 ms
(7.09%)
2
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:
[]
1.16 ms
(5.62%)
1
SELECT u0_.id AS id_0, u0_.telephone AS telephone_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenoms AS prenoms_5, u0_.email AS email_6, u0_.sexe AS sexe_7, u0_.adresse AS adresse_8, u0_.secteur_activite AS secteur_activite_9, u0_.terminal AS terminal_10, u0_.is_verified AS is_verified_11, u0_.fcm_token AS fcm_token_12, u0_.localite_id AS localite_id_13 FROM `user` u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_ACTEUR_FUPRO%"
]

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\User
  • The mappings App\Entity\User#fcm_tokens and App\Entity\ApiToken#utilisateur are inconsistent with each other.
App\Entity\Quartier
  • The mappings App\Entity\Quartier#produit and App\Entity\User#localite 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.
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.