GET https://pcboomboom.rs/shop/list/1306?page=477&salex=1

Query Metrics

48 Database Queries
9 Different statements
1511.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 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 1.62 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.49 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 538.64 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 914.48 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 9520
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.18 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
  1022728
  1022730
  1022732
  1022733
  1022737
  1022738
  1022739
  1022741
  1022742
  1022744
  1022746
  13428
  13427
  24509
  23331
  22350
  22351
  22352
  22315
  15214
]
7 1.47 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.52 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 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
  1022728
]
10 0.85 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
  1022728
]
11 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
  1022730
]
12 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
  1022730
]
13 0.79 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
  1022732
]
14 1.24 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
  1022732
]
15 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
  1022733
]
16 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
  1022733
]
17 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
  1022737
]
18 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
  1022737
]
19 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
  1022738
]
20 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
  1022738
]
21 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
  1022739
]
22 0.61 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
  1022739
]
23 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
  1022741
]
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
  1022741
]
25 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
  1022742
]
26 0.61 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
  1022742
]
27 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
  1022744
]
28 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
  1022744
]
29 0.47 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
  1022746
]
30 0.45 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
  1022746
]
31 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
  13428
]
32 5.37 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
  13428
]
33 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
  13427
]
34 3.97 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
  13427
]
35 4.08 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
  24509
]
36 2.27 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
  24509
]
37 1.30 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
  23331
]
38 5.82 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
  23331
]
39 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
  22350
]
40 1.16 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
  22350
]
41 1.01 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
  22351
]
42 1.17 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
  22351
]
43 0.83 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
  22352
]
44 1.13 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
  22352
]
45 0.93 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
  22315
]
46 0.75 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
  22315
]
47 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
  15214
]
48 0.94 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
  15214
]

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.