Query Metrics
48
Database Queries
9
Different statements
1525.33 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.94 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 | 10.37 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.55 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 | 651.50 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 | 832.58 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 28900
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 | 2.32 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 22931 22934 22939 23983 23984 23986 23987 23988 23990 23178 41338 23181 1033175 23182 23183 23184 23185 23324 26985 22556 ] |
| 7 | 1.07 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.61 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.14 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 22931 ] |
| 10 | 0.98 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 22931 ] |
| 11 | 1.04 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 22934 ] |
| 12 | 1.00 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 22934 ] |
| 13 | 0.73 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 22939 ] |
| 14 | 0.76 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 22939 ] |
| 15 | 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 23983 ] |
| 16 | 0.87 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 23983 ] |
| 17 | 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 23984 ] |
| 18 | 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 23984 ] |
| 19 | 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 23986 ] |
| 20 | 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 23986 ] |
| 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 23987 ] |
| 22 | 0.41 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 23987 ] |
| 23 | 0.46 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 23988 ] |
| 24 | 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 23988 ] |
| 25 | 0.34 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 23990 ] |
| 26 | 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 23990 ] |
| 27 | 0.46 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 23178 ] |
| 28 | 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 23178 ] |
| 29 | 0.48 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 41338 ] |
| 30 | 0.66 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 41338 ] |
| 31 | 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 23181 ] |
| 32 | 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 23181 ] |
| 33 | 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 1033175 ] |
| 34 | 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 1033175 ] |
| 35 | 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 23182 ] |
| 36 | 0.67 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 23182 ] |
| 37 | 0.69 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 23183 ] |
| 38 | 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 23183 ] |
| 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 23184 ] |
| 40 | 0.48 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 23184 ] |
| 41 | 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 23185 ] |
| 42 | 0.42 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 23185 ] |
| 43 | 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 23324 ] |
| 44 | 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 23324 ] |
| 45 | 0.46 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 26985 ] |
| 46 | 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 26985 ] |
| 47 | 0.48 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 22556 ] |
| 48 | 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 22556 ] |
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. |