Query Metrics
95
Database Queries
8
Different statements
117.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
48.76 ms (41.50%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0
Parameters:
[ 1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 ] |
|
30.22 ms (25.72%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ?
Parameters:
[
"1434"
]
|
|
15.21 ms (12.94%) |
48 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
Parameters:
[
1434
]
|
|
12.38 ms (10.53%) |
40 |
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
Parameters:
[ 1 21564 ] |
|
6.18 ms (5.26%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 360
Parameters:
[ 1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 ] |
|
2.56 ms (2.18%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.title ASC
Parameters:
[ 1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 21564 2854 3003 3082 3442 4194 1397 1619 2495 4407 27141 27140 27139 33994 33248 3183 2104 2281 1664 28791 ] |
|
1.47 ms (1.25%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC LIMIT 1
Parameters:
[
1434
]
|
|
0.73 ms (0.62%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC
Parameters:
[
1434
]
|
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\User | No errors. |
| App\Entity\Choice | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Comment | No errors. |