Query Metrics
8
Database Queries
8
Different statements
6.47 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.85 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.image_path AS image_path_6, t0.is_visible AS is_visible_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM brand t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
2 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.image_path AS image_path_8, t0.banner_image_path AS banner_image_path_9, t0.is_active AS is_active_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.tree_root AS tree_root_17, t0.parent_id AS parent_id_18 FROM category t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"electromenager"
]
|
||||||||||||||||||||||||||||
3 | 1.43 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.is_active AS is_active_6, c0_.deleted_at AS deleted_at_7, c0_.tree_root AS tree_root_8 FROM category c0_ INNER JOIN product p1_ ON c0_.id = p1_.category_id AND p1_.is_active = 1 AND p1_.deleted_at IS NULL AND p1_.brand_id = ? WHERE c0_.is_active = 1 AND c0_.deleted_at IS NULL AND ( (c0_.rgt < ? AND c0_.lft > ? AND c0_.tree_root = ?) OR c0_.id = ? ) ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters:
[ 1 88 1 4 4 ]
|
||||||||||||||||||||||||||||
4 | 0.99 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) WHERE (p0_.is_active = 1 AND p1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL)
Parameters:
[ 7 8 9 10 11 58 14 21 27 79 80 31 32 34 1 ] |
||||||||||||||||||||||||||||
5 | 0.75 ms |
SELECT DISTINCT p0_.id AS id_0 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) WHERE (p0_.is_active = 1 AND p1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL) LIMIT 21 OFFSET 21
Parameters:
[ 7 8 9 10 11 58 14 21 27 79 80 31 32 34 1 ] |
||||||||||||||||||||||||||||
6 | 0.60 ms |
SELECT p0_.id AS sclr_0, p0_.name AS sclr_1, p0_.slug AS sclr_2, p0_.sale_price AS sclr_3, p0_.solde_price AS sclr_4, p0_.discount AS sclr_5, p0_.final_price AS sclr_6, p0_.is_new_arrival AS sclr_7, p0_.is_special_offer AS sclr_8, p0_.main_image_path AS sclr_9 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) WHERE (p0_.is_active = 1 AND p1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.brand_id IN (?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL)
Parameters:
[ 7 8 9 10 11 58 14 21 27 79 80 31 32 34 1 309 310 311 312 313 314 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 ] |
||||||||||||||||||||||||||||
7 | 0.65 ms |
SELECT MIN(p0_.final_price) AS sclr_0, MAX(p0_.final_price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) WHERE (p0_.is_active = 1 AND p1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL)
Parameters:
[ 7 8 9 10 11 58 14 21 27 79 80 31 32 34 1 ]
|
||||||||||||||||||||||||||||
8 | 0.59 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.image_path AS image_path_7, c0_.banner_image_path AS banner_image_path_8, c0_.is_active AS is_active_9, c0_.meta_title AS meta_title_10, c0_.meta_description AS meta_description_11, c0_.meta_keywords AS meta_keywords_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15, c0_.tree_root AS tree_root_16, c0_.parent_id AS parent_id_17 FROM category c0_ WHERE (c0_.lft <= 1 AND c0_.rgt >= 88 AND c0_.tree_root = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
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\Category | No errors. |
App\Entity\Brand | No errors. |
App\Entity\Product | No errors. |
App\Entity\ProductVariant | No errors. |