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 = 'protivprovalni-sistemi' 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 = 'dahua-protivprovalna-oprema' 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 = '47855e38-4c16-4f28-83e5-dbb7d8fb671c' 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 = 'dahua-protivprovalna-oprema' 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 = '032db286-935c-4986-a364-4d173eac8017';

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 = 'dahua-protivprovalne-centrale' 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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'zicane-centrale';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicne-centrale';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'alarmni-kompleti';

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 = 'd7e4fa20-348a-4a6b-a732-a2748dc50dab';

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 = 'sifratori-i-moduli-za-upravljanje' 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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'zicani-sifratori';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicni-sifratori';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'dahua-daljinski-upravljaci';

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 = '7b97baf0-b038-45e5-a1b6-9ef8358abab5';

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 = 'detektori-i-magnetni-kontakti-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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicni-detektori-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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicni-magnetni-kontakti-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 = '6f18b1a9-3c6c-44b9-920c-4ad7c05bc096';

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 = 'alarmne-sirene' 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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'zicane-sirene';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicne-sirene';

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 = 'c87cf7c2-d90c-4c8e-bf68-0e759cc8b472';

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 = 'detekcija-stanja-okoline' 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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'zicani-detektori';

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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicni-detektori-2';

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 = '3447bae4-1e33-41ed-8013-9ea7fed28711';

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 = 'moduli-prosirenja' 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 = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'bezicno-prosirenje';

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
WHERE
  p1_.slug = ?
  AND p0_.is_publish = ?
  AND p0_.is_archived = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  24

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 WHERE p1_.slug = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0 ORDER BY p0_.created_at DESC LIMIT 24;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_publish = ?
  AND p0_.is_archived = ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.slug = 'dahua-protivprovalna-oprema' AND p0_.is_publish = 1 AND p0_.is_archived = 0;

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

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