Symfony Profiler

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

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 = 'video-nadzor' LIMIT 1;

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

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 = 'ip-kamere' LIMIT 1;

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

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 = '8127323e-58f7-4a21-9a7f-da63120338c8' AND p0_.is_archived = 0 ORDER BY p0_.position ASC;

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

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 = 'ip-kamere' AND a0_.parent_id IS NULL ORDER BY a0_.position ASC, a0_.title ASC;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attribute a0_
WHERE
  a0_.parent_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = '701987ec-125a-499c-9007-771c0aada24f';

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

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 = 'tip-kucista-1' ORDER BY a0_.position ASC, a0_.title ASC;

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'dome-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'dome-ik10-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bullet-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bullet-ik10';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'box-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'fisheye-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'pinhole-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'specijalne-kamere';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'ptz-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'ptz-ik10';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'pt-kamera';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attribute a0_
WHERE
  a0_.parent_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = '8b38fcca-46b8-4097-bd40-3e576aba75eb';

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

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 = 'rezolucija-1' ORDER BY a0_.position ASC, a0_.title ASC;

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '2-mpx-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '3-mpx';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '4-mpx-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '5-mpx-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '6-mpx-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '8-mpx-1';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '10-mpx';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '12-mpx-1';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attribute a0_
WHERE
  a0_.parent_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = '4dc22eeb-8324-412d-9a06-4f19a254552e';

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

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 = 'objektiv-1' ORDER BY a0_.position ASC, a0_.title ASC;

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '1-4-mm';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '3-5-mm';

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 = ?

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 = 'ip-kamere' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '2-mm';

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 = ?