Query Metrics
45
Database Queries
11
Different statements
10.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.39 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4 FROM magasin t0 WHERE t0.nom IN (?)
Parameters:
[
"Julico"
]
|
| 2 | 0.29 ms |
SELECT m0_.id AS id_0, m0_.start_time AS start_time_1, m0_.end_time AS end_time_2, m0_.description AS description_3, m0_.is_active AS is_active_4 FROM maintenance_schedule m0_ WHERE m0_.is_active = ? AND m0_.start_time <= ? AND m0_.end_time >= ? ORDER BY m0_.end_time DESC LIMIT 1
Parameters:
[ 1 "2026-02-15 09:22:37" "2026-02-15 09:22:37" ] |
| 3 | 0.24 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4 FROM magasin t0
Parameters:
[] |
| 4 | 0.20 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_
Parameters:
[] |
| 5 | 0.43 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.tax AS tax_14 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND p0_.magasin_id IN (?)) dctrn_result) dctrn_table
Parameters:
[ 0 7 ] |
| 6 | 0.25 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
Parameters:
[] |
| 7 | 0.31 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
Parameters:
[] |
| 8 | 0.45 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11 FROM produit p0_ WHERE p0_.publish_date <= ? AND p0_.publish_date >= ? AND (p0_.publish_item = 1 OR ? = 1) AND p0_.magasin_id IN (?)) dctrn_result) dctrn_table
Parameters:
[ "2026-02-15 09:22:37" "2026-01-16 09:22:37" 0 7 ] |
| 9 | 0.37 ms |
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.tax AS tax_14 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND p0_.magasin_id IN (?)) dctrn_result LIMIT 24
Parameters:
[ 0 7 ] |
| 10 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.tax AS tax_14, p0_.category_id AS category_id_15, p0_.user_id AS user_id_16, p0_.magasin_id AS magasin_id_17 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND p0_.magasin_id IN (?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 0 7 18 19 21 22 27 28 29 30 32 35 36 38 39 40 41 42 43 45 53 55 56 58 ] |
| 11 | 0.22 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
18
]
|
| 12 | 0.21 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
18
]
|
| 13 | 0.20 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
19
]
|
| 14 | 0.20 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
19
]
|
| 15 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
21
]
|
| 16 | 0.20 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
21
]
|
| 17 | 0.21 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
22
]
|
| 18 | 0.18 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
22
]
|
| 19 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
27
]
|
| 20 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
28
]
|
| 21 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
29
]
|
| 22 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
30
]
|
| 23 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
32
]
|
| 24 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
35
]
|
| 25 | 0.18 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
35
]
|
| 26 | 0.17 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
36
]
|
| 27 | 0.21 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
36
]
|
| 28 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
38
]
|
| 29 | 0.18 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
38
]
|
| 30 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
39
]
|
| 31 | 0.21 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
39
]
|
| 32 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
40
]
|
| 33 | 0.19 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
41
]
|
| 34 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
42
]
|
| 35 | 0.21 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
43
]
|
| 36 | 0.20 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
45
]
|
| 37 | 0.21 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
45
]
|
| 38 | 0.21 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
53
]
|
| 39 | 0.22 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
53
]
|
| 40 | 0.20 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
55
]
|
| 41 | 0.24 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
55
]
|
| 42 | 0.21 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
56
]
|
| 43 | 0.20 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
56
]
|
| 44 | 0.20 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
58
]
|
| 45 | 0.22 ms |
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
58
]
|
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\Magasin | No errors. |
| App\Entity\MagasinUser | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\MaintenanceSchedule | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CommandeDetails | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ProduitPromotion | No errors. |
| App\Entity\ProduitVariant | No errors. |
| App\Entity\Commande | No errors. |
| App\Entity\Addresse | No errors. |
| App\Entity\PaymentT | No errors. |
| App\Entity\Promotion | No errors. |
| App\Entity\ParamColor | No errors. |
| App\Entity\ParamSize | No errors. |
| App\Entity\CommandeStatus | No errors. |
| App\Entity\Facture | No errors. |