Query Metrics
23
Database Queries
10
Different statements
75.71 ms
Query time
8
Invalid entities
164
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.13 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.nom_canonique = ? LIMIT 1
Parameters:
[
"nike"
]
|
| 2 | 4.03 ms |
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.nom_canonique = ? LIMIT 1
Parameters:
[
"TTT"
]
|
| 3 | 2.67 ms |
SELECT t0.id AS id_1, t0.evenement AS evenement_2, t0.validite AS validite_3, t0.dateajout AS dateajout_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.explication AS explication_7, t0.urlvideos AS urlvideos_8, t0.image AS image_9 FROM topbannieres t0 WHERE t0.validite = ? ORDER BY t0.dateajout DESC LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.58 ms |
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 5 | 10.02 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
1708
]
|
| 6 | 6.40 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
3
]
|
| 7 | 3.99 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
2497
]
|
| 8 | 0.51 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
4
]
|
| 9 | 0.46 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
1706
]
|
| 10 | 0.42 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
5
]
|
| 11 | 0.42 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
2499
]
|
| 12 | 0.46 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
7
]
|
| 13 | 0.42 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
2501
]
|
| 14 | 0.41 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
8
]
|
| 15 | 0.53 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
2505
]
|
| 16 | 0.46 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
9
]
|
| 17 | 0.42 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
2507
]
|
| 18 | 0.48 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
10
]
|
| 19 | 0.47 ms |
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 20 | 3.10 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.code AS code_3, t0.description AS description_4, t0.position AS position_5, t0.slideauto AS slideauto_6, t0.pagination AS pagination_7, t0.control AS control_8, t0.valide AS valide_9, t0.intervalle AS intervalle_10, t0.height AS height_11, t0.bottomcontent AS bottomcontent_12, t0.bottomcolor AS bottomcolor_13, t0.bottomtext AS bottomtext_14, t0.bottombg AS bottombg_15, t0.link AS link_16, t0.categorie_id AS categorie_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM hh_caroussels t0 WHERE t0.valide = ? LIMIT 1
Parameters:
[
1
]
|
| 21 | 12.98 ms |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.caroussel_id = ?
Parameters:
[
3
]
|
| 22 | 18.53 ms |
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = ?
Parameters:
[
2
]
|
| 23 | 2.80 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.sous_categorie_id WHERE article_has_sous_categorie.article_idarticle = ?
Parameters:
[
85
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Image | 88 |
| App\Entity\Article | 37 |
| App\Entity\SousCategorie | 27 |
| App\Entity\Categorie | 7 |
| App\Entity\Etat | 2 |
| App\Entity\Marque | 1 |
| App\Entity\Topbannieres | 1 |
| App\Entity\Caroussels | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Marque |
|
| App\Entity\Image | No errors. |
| App\Entity\Article |
|
| App\Entity\Nouveaute |
|
| App\Entity\Categorie |
|
| App\Entity\SousCategorie |
|
| App\Entity\Topbannieres | No errors. |
| App\Entity\Caroussels | No errors. |
| App\Entity\ProduitMannuels | No errors. |
| App\Entity\CaracteristiqueModel | No errors. |
| App\Entity\Etat | No errors. |
| App\Entity\Commande | No errors. |
| App\Entity\Caracteristique | No errors. |
| App\Entity\RubriqueHasArticle | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Rubrique | No errors. |
| App\Entity\PointsTransaction |
|
| App\Entity\PanierAlimentaires | No errors. |
| App\Entity\ImageBaniere | No errors. |
| App\Entity\Description | No errors. |
| App\Entity\Annonces | No errors. |
| App\Entity\UserLog | No errors. |
| App\Entity\CommandeUnique | No errors. |
| App\Entity\CommandeProduitNaturels | No errors. |
| App\Entity\DemandeArticles | No errors. |
| App\Entity\Pannier |
|
| App\Entity\ChatbotParoles | No errors. |
| App\Entity\Contacts | No errors. |
| App\Entity\Partenaires | No errors. |
| App\Entity\InfoClient |
|
| App\Entity\Users | No errors. |
| App\Entity\Baniere | No errors. |
| App\Entity\CommandeArticles | No errors. |
| App\Entity\Denrees | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |