Query Metrics

19 Database Queries
14 Different statements
20.48 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.79 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_menu AS sous_menu_3, t0.anglais AS anglais_4 FROM menu t0
Parameters:
[]
2 1.22 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3, t0.is_active AS is_active_4, t0.description AS description_5, t0.titreanglais AS titreanglais_6, t0.descriptionanglais AS descriptionanglais_7 FROM video t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
3 1.31 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.link AS link_3, t0.anglais AS anglais_4, t0.photo AS photo_5, t0.description AS description_6, t0.other_images AS other_images_7, t0.menu_id AS menu_id_8 FROM sous_menu t0
Parameters:
[]
4 1.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0
Parameters:
[]
5 1.16 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.hauteur AS hauteur_2, p0_.diametre AS diametre_3, p0_.poids AS poids_4, p0_.capacite AS capacite_5, p0_.couleur AS couleur_6, p0_.prix AS prix_7, p0_.image_name AS image_name_8, p0_.is_top AS is_top_9, p0_.anglais AS anglais_10, p0_.description AS description_11, p0_.descanglais AS descanglais_12, p0_.other_images AS other_images_13, p0_.is_new_arrival AS is_new_arrival_14, p0_.is_promoted AS is_promoted_15, p0_.discount AS discount_16, p0_.categorie_id AS categorie_id_17, p0_.sous_categorie_id AS sous_categorie_id_18, p0_.brand_id AS brand_id_19 FROM produit p0_ WHERE p0_.is_top = ? ORDER BY p0_.id ASC
Parameters:
[
  1
]
6 1.03 ms
SELECT t0.id AS id_1, t0.date AS date_2 FROM new_arrival t0
Parameters:
[]
7 1.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0 INNER JOIN new_arrival_produit ON t0.id = new_arrival_produit.produit_id WHERE new_arrival_produit.new_arrival_id = ?
Parameters:
[
  2
]
8 1.55 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.hauteur AS hauteur_2, p0_.diametre AS diametre_3, p0_.poids AS poids_4, p0_.capacite AS capacite_5, p0_.couleur AS couleur_6, p0_.prix AS prix_7, p0_.image_name AS image_name_8, p0_.is_top AS is_top_9, p0_.anglais AS anglais_10, p0_.description AS description_11, p0_.descanglais AS descanglais_12, p0_.other_images AS other_images_13, p0_.is_new_arrival AS is_new_arrival_14, p0_.is_promoted AS is_promoted_15, p0_.discount AS discount_16, p0_.categorie_id AS categorie_id_17, p0_.sous_categorie_id AS sous_categorie_id_18, p0_.brand_id AS brand_id_19 FROM produit p0_ INNER JOIN promotion_produit p2_ ON p0_.id = p2_.produit_id INNER JOIN promotion p1_ ON p1_.id = p2_.promotion_id WHERE p1_.date_debut <= ? AND p1_.date_fin >= ?
Parameters:
[
  "2024-11-30 03:53:49"
  "2024-11-30 03:53:49"
]
9 0.75 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image_name AS image_name_3, t0.is_active AS is_active_4, t0.description AS description_5, t0.titreanglais AS titreanglais_6, t0.descriptionanglais AS descriptionanglais_7 FROM banniere t0
Parameters:
[]
10 0.93 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.photo AS photo_2 FROM categorie c0_ WHERE c0_.id <> ? ORDER BY c0_.id ASC
Parameters:
[
  1
]
11 0.65 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.categorie_id AS categorie_id_4 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
  4
]
12 0.95 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.categorie_id AS categorie_id_4 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
  6
]
13 0.94 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.categorie_id AS categorie_id_4 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
  15
]
14 0.82 ms
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.value AS value_3 FROM configuration t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
  "HOME_HEADER"
]
15 0.59 ms
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.value AS value_3 FROM configuration t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
  "FOOTER_RS"
]
16 0.65 ms
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.value AS value_3 FROM configuration t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
  "FOOTER_INFOS"
]
17 1.62 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0
Parameters:
[]
18 1.33 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3 FROM brand t0
Parameters:
[]
19 1.30 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.link AS link_3, t0.anglais AS anglais_4, t0.photo AS photo_5, t0.description AS description_6, t0.other_images AS other_images_7, t0.menu_id AS menu_id_8 FROM sous_menu t0 WHERE t0.menu_id = ?
Parameters:
[
  2
]

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\Menu No errors.
App\Entity\SousMenu No errors.
App\Entity\Video No errors.
App\Entity\Produit
  • The field App\Entity\Produit#promotions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Promotion#produits does not contain the required 'inversedBy="promotions"' attribute.
App\Entity\Categorie No errors.
App\Entity\SousCategorie No errors.
App\Entity\Brand No errors.
App\Entity\Promotion No errors.
App\Entity\NewArrival No errors.
App\Entity\Banniere No errors.
App\Entity\Configuration No errors.