Query Metrics

115 Database Queries
11 Different statements
1534.31 ms Query time
0 Invalid entities
115 Managed entities

Queries

Group similar statements

# Time Info
1 1.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "video-nadzor"
]
2 0.80 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ip-kamere"
]
3 0.95 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.description AS description_4, p0_.position AS position_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.is_publish AS is_publish_9, p0_.is_archived AS is_archived_10, p0_.tree_root AS tree_root_11, p0_.parent_id AS parent_id_12 FROM product_category p0_ WHERE p0_.parent_id = ? AND p0_.is_archived = ? ORDER BY p0_.position ASC
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1001
    __toString(): "8127323e-58f7-4a21-9a7f-da63120338c8"
  }
  0
]
4 1.75 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN product_category p1_ ON a0_.product_category_id = p1_.id WHERE p1_.slug = ? AND a0_.parent_id IS NULL ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "ip-kamere"
]
5 0.89 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1247
    __toString(): "701987ec-125a-499c-9007-771c0aada24f"
  }
]
6 1.18 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "tip-kucista-1"
]
7 12.17 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "dome-1"
]
8 8.86 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "dome-ik10-1"
]
9 10.35 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "bullet-1"
]
10 7.83 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "bullet-ik10"
]
11 21.71 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "box-1"
]
12 8.11 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "fisheye-1"
]
13 13.08 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "pinhole-1"
]
14 5.92 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "specijalne-kamere"
]
15 7.70 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ptz-1"
]
16 7.78 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ptz-ik10"
]
17 7.42 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "pt-kamera"
]
18 0.52 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1232
    __toString(): "8b38fcca-46b8-4097-bd40-3e576aba75eb"
  }
]
19 0.95 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "rezolucija-1"
]
20 8.45 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-mpx-1"
]
21 7.10 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "3-mpx"
]
22 14.96 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "4-mpx-1"
]
23 18.72 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "5-mpx-1"
]
24 11.03 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "6-mpx-1"
]
25 9.21 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "8-mpx-1"
]
26 10.61 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "10-mpx"
]
27 9.18 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "12-mpx-1"
]
28 0.87 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1224
    __toString(): "4dc22eeb-8324-412d-9a06-4f19a254552e"
  }
]
29 1.56 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "objektiv-1"
]
30 10.19 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "1-4-mm"
]
31 8.47 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "3-5-mm"
]
32 9.70 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-mm"
]
33 18.26 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-1-mm"
]
34 9.44 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-5-mm"
]
35 37.65 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-8-mm"
]
36 23.56 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "3-6-mm-1"
]
37 19.46 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "4-mm"
]
38 26.67 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "6-mm-1"
]
39 12.74 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-4-mm-6-mm"
]
40 16.82 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-7-mm-12-mm-1"
]
41 22.64 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-8-mm-12-mm"
]
42 32.15 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-7-mm-13-mm"
]
43 18.68 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "2-7-mm-13-5-mm-1"
]
44 17.05 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "5-mm-50-mm"
]
45 16.78 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "7-mm-35-mm"
]
46 20.55 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "8-mm-32-mm"
]
47 16.28 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "4x-zoom-1"
]
48 26.14 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "6x-zoom"
]
49 13.04 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "12x-zoom"
]
50 15.03 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "15x-zoom-1"
]
51 17.01 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "23x-zoom"
]
52 20.07 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "25x-zoom-1"
]
53 25.09 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "30x-zoom-1"
]
54 25.47 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "32x-zoom-1"
]
55 23.13 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "40x-zoom-1"
]
56 25.08 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "45x-zoom-1"
]
57 34.57 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "63x-zoom"
]
58 11.81 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1215
    __toString(): "32219554-61fe-4709-b520-d88a3cd7f988"
  }
]
59 11.86 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "ir-domet-1"
]
60 22.62 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "10-m-1"
]
61 17.31 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "15-m"
]
62 9.77 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "20-m-1"
]
63 19.42 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "30-m-1"
]
64 11.22 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "40-m-1"
]
65 19.74 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "50-m-1"
]
66 10.91 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "60-m-1"
]
67 20.12 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "80-m-1"
]
68 11.75 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "100-m-199-m-1"
]
69 15.15 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "200-m-500-m-1"
]
70 1.64 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1258
    __toString(): "78470c66-a8fa-44bb-ba8b-4e796dd65d07"
  }
]
71 1.47 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "wdr-1"
]
72 14.71 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "true-wdr-100-db"
]
73 15.71 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "true-wdr-120-db"
]
74 17.43 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "true-wdr-140-db"
]
75 18.72 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "dwdr-1"
]
76 9.53 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1264
    __toString(): "9459ca6b-b01a-4a4b-ab0a-b7a8f8e65515"
  }
]
77 1.23 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "ip-zastita-1"
]
78 9.15 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ip-65"
]
79 17.04 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ip-66-1"
]
80 17.69 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ip-67-1"
]
81 32.72 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ip-68-1"
]
82 0.87 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1252
    __toString(): "a7e7265f-100c-4d16-8822-a6205f8c907f"
  }
]
83 1.00 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN attribute a1_ ON a0_.parent_id = a1_.id WHERE a1_.slug = ? ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "dodatne-karakteristike"
]
84 13.46 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "lpr"
]
85 8.53 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "video-analitika-1"
]
86 17.35 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "starlight-1"
]
87 16.80 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "smart-dual-light"
]
88 15.56 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "polar-day"
]
89 15.74 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "full-color-1"
]
90 16.79 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "wi-fi"
]
91 21.84 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "micro-sd-slot"
]
92 16.24 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "epoe-1"
]
93 13.84 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "alarm-in-out-1"
]
94 8.12 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ugraden-mikrofon-1"
]
95 15.46 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "ugraden-zvucnik"
]
96 14.94 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "auto-tracking"
]
97 23.86 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "people-counting"
]
98 20.33 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "perimetar-protection-1"
]
99 23.33 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "active-deterrence"
]
100 13.71 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "early-warning"
]
101 14.80 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "smd-1"
]
102 15.59 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "tioc-2-0"
]
103 14.87 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "4g-kamere"
]
104 15.30 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
Parameters:
[
  "ip-kamere"
  1
  0
  "solarno-napajanje"
]
105 40.91 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.show_in_category AS show_in_category_17, p0_.is_highlighted AS is_highlighted_18, p0_.is_b2_c AS is_b2_c_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.documents AS documents_22, p0_.related_products AS related_products_23, p0_.stock_quantity AS stock_quantity_24, p0_.category_id AS category_id_25, p0_.brand_id AS brand_id_26 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id INNER JOIN product_attribute p5_ ON p0_.id = p5_.product_id INNER JOIN attribute a4_ ON a4_.id = p5_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug IN (?) AND a4_.slug IN (?) ORDER BY p0_.created_at DESC LIMIT 24
Parameters:
[
  "ip-kamere"
  1
  0
  "8-mpx-1"
  "dome-1"
]
106 13.08 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id INNER JOIN product_attribute p3_ ON p0_.id = p3_.product_id INNER JOIN attribute a2_ ON a2_.id = p3_.attribute_id INNER JOIN product_attribute p5_ ON p0_.id = p5_.product_id INNER JOIN attribute a4_ ON a4_.id = p5_.attribute_id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug IN (?) AND a4_.slug IN (?)
Parameters:
[
  "ip-kamere"
  1
  0
  "8-mpx-1"
  "dome-1"
]
107 3.24 ms
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery AS delivery_6, t0.delivery_price AS delivery_price_7, t0.customer_note AS customer_note_8, t0.company_id AS company_id_9, t0.user_id AS user_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
  "cart"
]
108 3.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.featured_image AS featured_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.web_url AS web_url_8, t0.color AS color_9 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  "65bb129f-e7e3-45dd-b66f-80f8c9dbb78d"
]
109 3.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "f6d46fcd-8b43-455b-8b59-2a9423cea3c4"
]
110 2.92 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "f2072373-828f-437d-8776-32a27cf05cd0"
]
111 6.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.featured_image AS featured_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.web_url AS web_url_8, t0.color AS color_9 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  "54ffad9d-b58f-40be-aadd-e9f0be310470"
]
112 3.91 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "90dee347-50fd-42e6-83e1-78e3f84acd0c"
]
113 4.64 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "05407ace-95d2-4c1b-892b-0268053273d2"
]
114 1.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "7bbfb111-b9c2-464b-938c-e8e36d85c7d1"
]
115 1.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "d2dfd97a-e02e-43cf-abd2-b57e7036fd39"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Attribute 93
App\Entity\ProductCategory 14
App\Entity\Product 6
App\Entity\Brand 2

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\Attribute No errors.
App\Entity\Brand No errors.
App\Entity\Tag No errors.
App\Entity\Order No errors.
App\Entity\Company No errors.
App\Entity\User No errors.