Query Metrics
16
Database Queries
12
Different statements
6.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.14 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titreh1 AS titreh1_3, t0.titreh2 AS titreh2_4, t0.contenu AS contenu_5, t0.titreproduits AS titreproduits_6, t0.nombtnservice AS nombtnservice_7, t0.titrelienproduits AS titrelienproduits_8, t0.description AS description_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.updated_at AS updated_at_12, t0.soustitre1 AS soustitre1_13, t0.textlienvoirplus AS textlienvoirplus_14, t0.titreproduitspromo AS titreproduitspromo_15 FROM paramaccueil t0 LIMIT 1
Parameters:
[] |
| 2 | 0.61 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.datevue AS datevue_4, c0_.nbre AS nbre_5, c0_.image_name AS image_name_6, c0_.image_size AS image_size_7, c0_.updated_at AS updated_at_8, c0_.principal AS principal_9, c0_.parent_id AS parent_id_10 FROM categorie c0_ WHERE c0_.image_name IS NOT NULL AND c0_.principal = 1 ORDER BY c0_.nbre DESC LIMIT 8
Parameters:
[] |
| 3 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.datevue AS datevue_4, c0_.nbre AS nbre_5, c0_.image_name AS image_name_6, c0_.image_size AS image_size_7, c0_.updated_at AS updated_at_8, c0_.principal AS principal_9, c0_.parent_id AS parent_id_10 FROM categorie c0_ WHERE c0_.principal = 0 ORDER BY c0_.nbre DESC LIMIT 8
Parameters:
[] |
| 4 | 0.42 ms |
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.slug AS slug_2, m0_.nbre AS nbre_3, m0_.image_name AS image_name_4, m0_.image_size AS image_size_5, m0_.updated_at AS updated_at_6 FROM marque m0_ WHERE m0_.image_name IS NOT NULL ORDER BY m0_.nbre DESC LIMIT 6
Parameters:
[] |
| 5 | 0.15 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titreh1 AS titreh1_3, t0.titreh2 AS titreh2_4, t0.contenu AS contenu_5, t0.titreproduits AS titreproduits_6, t0.nombtnservice AS nombtnservice_7, t0.titrelienproduits AS titrelienproduits_8, t0.description AS description_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.updated_at AS updated_at_12, t0.soustitre1 AS soustitre1_13, t0.textlienvoirplus AS textlienvoirplus_14, t0.titreproduitspromo AS titreproduitspromo_15 FROM paramaccueil t0 LIMIT 1
Parameters:
[] |
| 6 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.date AS date_4, p0_.datevue AS datevue_5, p0_.vues AS vues_6, p0_.image_name AS image_name_7, p0_.image_size AS image_size_8, p0_.updated_at AS updated_at_9, p0_.prix AS prix_10, p0_.prixpromo AS prixpromo_11, p0_.stock AS stock_12, p0_.datepanier AS datepanier_13, p0_.datecommande AS datecommande_14, p0_.nbrepanier AS nbrepanier_15, p0_.nbrecommande AS nbrecommande_16, p0_.marque_id AS marque_id_17 FROM produit p0_ ORDER BY p0_.vues DESC LIMIT 5
Parameters:
[] |
| 7 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.date AS date_4, p0_.datevue AS datevue_5, p0_.vues AS vues_6, p0_.image_name AS image_name_7, p0_.image_size AS image_size_8, p0_.updated_at AS updated_at_9, p0_.prix AS prix_10, p0_.prixpromo AS prixpromo_11, p0_.stock AS stock_12, p0_.datepanier AS datepanier_13, p0_.datecommande AS datecommande_14, p0_.nbrepanier AS nbrepanier_15, p0_.nbrecommande AS nbrecommande_16, p0_.marque_id AS marque_id_17 FROM produit p0_ ORDER BY p0_.vues ASC LIMIT 6
Parameters:
[] |
| 8 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.datevue AS datevue_4, c0_.nbre AS nbre_5, c0_.image_name AS image_name_6, c0_.image_size AS image_size_7, c0_.updated_at AS updated_at_8, c0_.principal AS principal_9, c0_.parent_id AS parent_id_10 FROM categorie c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.nbre DESC LIMIT 8
Parameters:
[] |
| 9 | 0.38 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.copyright AS copyright_5, t0.sender AS sender_6, t0.adresse AS adresse_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.updated_at AS updated_at_10, t0.twitter AS twitter_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.youtube AS youtube_15, t0.tiktok AS tiktok_16 FROM param t0 LIMIT 1
Parameters:
[] |
| 10 | 0.43 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.datevue AS datevue_5, t0.nbre AS nbre_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.principal AS principal_10, t0.parent_id AS parent_id_11 FROM categorie t0 WHERE t0.parent_id = ?
Parameters:
[
5
]
|
| 11 | 0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.datevue AS datevue_5, t0.nbre AS nbre_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.principal AS principal_10, t0.parent_id AS parent_id_11 FROM categorie t0 WHERE t0.parent_id = ?
Parameters:
[
9
]
|
| 12 | 0.64 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.date AS date_5, t0.datevue AS datevue_6, t0.vues AS vues_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.updated_at AS updated_at_10, t0.prix AS prix_11, t0.prixpromo AS prixpromo_12, t0.stock AS stock_13, t0.datepanier AS datepanier_14, t0.datecommande AS datecommande_15, t0.nbrepanier AS nbrepanier_16, t0.nbrecommande AS nbrecommande_17, t0.marque_id AS marque_id_18 FROM produit t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.produit_id WHERE produit_categorie.categorie_id = ?
Parameters:
[
14
]
|
| 13 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.date AS date_5, t0.datevue AS datevue_6, t0.vues AS vues_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.updated_at AS updated_at_10, t0.prix AS prix_11, t0.prixpromo AS prixpromo_12, t0.stock AS stock_13, t0.datepanier AS datepanier_14, t0.datecommande AS datecommande_15, t0.nbrepanier AS nbrepanier_16, t0.nbrecommande AS nbrecommande_17, t0.marque_id AS marque_id_18 FROM produit t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.produit_id WHERE produit_categorie.categorie_id = ?
Parameters:
[
15
]
|
| 14 | 0.22 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.copyright AS copyright_5, t0.sender AS sender_6, t0.adresse AS adresse_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.updated_at AS updated_at_10, t0.twitter AS twitter_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.youtube AS youtube_15, t0.tiktok AS tiktok_16 FROM param t0 LIMIT 1
Parameters:
[] |
| 15 | 0.29 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.slug AS slug_4 FROM page t0
Parameters:
[] |
| 16 | 0.22 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.datevue AS datevue_4, c0_.nbre AS nbre_5, c0_.image_name AS image_name_6, c0_.image_size AS image_size_7, c0_.updated_at AS updated_at_8, c0_.principal AS principal_9, c0_.parent_id AS parent_id_10 FROM categorie c0_ WHERE c0_.principal = 0 ORDER BY c0_.nbre DESC LIMIT 20
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\Paramaccueil | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Marque | No errors. |
| App\Entity\Commanderapide | No errors. |
| App\Entity\Commande | No errors. |
| App\Entity\Commandeproduit | No errors. |
| App\Entity\Param | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Pageservice | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Contact | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |