Query Metrics
48
Database Queries
9
Different statements
1389.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.98 ms |
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.is_images AS is_images_6, t0.description AS description_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.meta_keywords AS meta_keywords_10, t0.created AS created_11, t0.updated AS updated_12, t0.edit_by_id AS edit_by_id_13, t0.parent_id AS parent_id_14, t0.choice_id AS choice_id_15, t0.slika_id AS slika_id_16 FROM categories t0 WHERE t0.id = ?
Parameters:
[
"1306"
]
|
| 2 | 0.93 ms |
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:
[
1306
]
|
| 3 | 1.20 ms |
WITH RECURSIVE category_tree AS ( SELECT id, parent_id FROM categories WHERE id = :categoryId UNION ALL SELECT c.id, c.parent_id FROM categories c INNER JOIN category_tree ct ON c.parent_id = ct.id ) SELECT id FROM category_tree
Parameters:
[ "categoryId" => 1306 ] |
| 4 | 599.24 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN clients c2_ ON p0_.vendor_id = c2_.id LEFT JOIN images i3_ ON p0_.main_image_id = i3_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0
Parameters:
[ 1306 1243 1307 1327 1099 1239 1248 1315 1345 1350 1369 1470 1471 1472 1473 1478 1492 1559 1563 1564 1308 1309 1310 1311 1312 1313 1314 1562 1240 1241 1242 1317 1318 1560 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 ] |
| 5 | 757.89 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.is_out_of_stock AS is_out_of_stock_1, p0_.title AS title_2 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN clients c2_ ON p0_.vendor_id = c2_.id LEFT JOIN images i3_ ON p0_.main_image_id = i3_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 ORDER BY p0_.is_out_of_stock ASC, p0_.title ASC LIMIT 20 OFFSET 20540
Parameters:
[ 1306 1243 1307 1327 1099 1239 1248 1315 1345 1350 1369 1470 1471 1472 1473 1478 1492 1559 1563 1564 1308 1309 1310 1311 1312 1313 1314 1562 1240 1241 1242 1317 1318 1560 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 ] |
| 6 | 3.81 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, c1_.id AS id_2, p0_.product_key AS product_key_3, p0_.price_pdv AS price_pdv_4, p0_.price_prikaz AS price_prikaz_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, c2_.title AS title_14, i3_.thumbnail_500x500 AS thumbnail_500x500_15 FROM product p0_ LEFT JOIN categories c2_ ON p0_.category_id = c2_.id LEFT JOIN clients c1_ ON p0_.vendor_id = c1_.id LEFT JOIN images i3_ ON p0_.main_image_id = i3_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.is_out_of_stock ASC, p0_.title ASC
Parameters:
[ 1306 1243 1307 1327 1099 1239 1248 1315 1345 1350 1369 1470 1471 1472 1473 1478 1492 1559 1563 1564 1308 1309 1310 1311 1312 1313 1314 1562 1240 1241 1242 1317 1318 1560 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1034633 1035828 1027687 1035830 1035831 1035832 1035833 1035834 1035835 1035836 1035837 1035838 1035839 1027690 1034634 1027691 1037626 1035840 1035841 1035842 ] |
| 7 | 1.06 ms |
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:
[
1306
]
|
| 8 | 1.28 ms |
WITH RECURSIVE category_tree AS ( SELECT id, parent_id, title FROM categories WHERE id = :categoryId UNION ALL SELECT c.id, c.parent_id, c.title FROM categories c INNER JOIN category_tree ct ON c.parent_id = ct.id ) SELECT id, parent_id, title FROM category_tree ORDER BY title ASC
Parameters:
[ "categoryId" => 1306 ] |
| 9 | 1.05 ms |
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 1034633 ] |
| 10 | 0.80 ms |
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 1034633 ] |
| 11 | 0.86 ms |
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 1035828 ] |
| 12 | 0.77 ms |
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 1035828 ] |
| 13 | 0.70 ms |
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 1027687 ] |
| 14 | 0.72 ms |
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 1027687 ] |
| 15 | 0.60 ms |
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 1035830 ] |
| 16 | 0.53 ms |
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 1035830 ] |
| 17 | 0.65 ms |
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 1035831 ] |
| 18 | 0.58 ms |
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 1035831 ] |
| 19 | 0.55 ms |
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 1035832 ] |
| 20 | 0.44 ms |
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 1035832 ] |
| 21 | 0.44 ms |
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 1035833 ] |
| 22 | 0.40 ms |
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 1035833 ] |
| 23 | 0.44 ms |
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 1035834 ] |
| 24 | 0.56 ms |
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 1035834 ] |
| 25 | 0.57 ms |
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 1035835 ] |
| 26 | 0.57 ms |
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 1035835 ] |
| 27 | 0.54 ms |
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 1035836 ] |
| 28 | 0.51 ms |
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 1035836 ] |
| 29 | 0.56 ms |
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 1035837 ] |
| 30 | 0.54 ms |
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 1035837 ] |
| 31 | 0.63 ms |
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 1035838 ] |
| 32 | 0.56 ms |
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 1035838 ] |
| 33 | 0.57 ms |
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 1035839 ] |
| 34 | 0.57 ms |
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 1035839 ] |
| 35 | 0.58 ms |
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 1027690 ] |
| 36 | 0.62 ms |
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 1027690 ] |
| 37 | 0.55 ms |
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 1034634 ] |
| 38 | 0.54 ms |
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 1034634 ] |
| 39 | 0.52 ms |
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 1027691 ] |
| 40 | 0.54 ms |
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 1027691 ] |
| 41 | 0.50 ms |
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 1037626 ] |
| 42 | 0.51 ms |
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 1037626 ] |
| 43 | 0.49 ms |
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 1035840 ] |
| 44 | 0.49 ms |
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 1035840 ] |
| 45 | 0.56 ms |
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 1035841 ] |
| 46 | 0.54 ms |
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 1035841 ] |
| 47 | 0.60 ms |
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 1035842 ] |
| 48 | 0.64 ms |
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 1035842 ] |
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\Image | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Comment | No errors. |