Symfony Profiler

Query Metrics

48 Database Queries

11 Different statements

128.71 ms Query time

0 Invalid entities

51 Managed entities

Queries


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 = ? 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 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 COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
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 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 = ? 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 = ? 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 = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
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 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 = ? 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 = ? 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 = ? 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 = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
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 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 = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ?
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 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? AND p0_.is_publish = ? AND p0_.is_archived = ? AND a2_.slug = ?
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 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 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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	10.58 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"`] View formatted query View runnable query Explain query 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;
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: [`"xvr-hd-analogni-snimaci"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' LIMIT 1;
3	1.09 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`] View formatted query View runnable query 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;
4	1.61 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: [`"xvr-hd-analogni-snimaci"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND a0_.parent_id IS NULL ORDER BY a0_.position ASC, a0_.title ASC;
5	7.28 ms	SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ? Parameters: [`Ramsey\Uuid\Lazy\LazyUuidFromString {#1247 __toString(): "9bcee274-7a45-4fa6-8a3a-3856aa299b15" }`] View formatted query View runnable query 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 = '9bcee274-7a45-4fa6-8a3a-3856aa299b15';
6	1.39 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: [`"broj-kanala-xvr"`] View formatted query View runnable query Explain query 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 = 'broj-kanala-xvr' ORDER BY a0_.position ASC, a0_.title ASC;
7	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "4-kanala"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '4-kanala';
8	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "8-kanala"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '8-kanala';
9	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "16-kanala"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '16-kanala';
10	7.02 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: [`"xvr-hd-analogni-snimaci" 1 0 "32-kanala-2"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '32-kanala-2';
11	0.78 ms	SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ? Parameters: [`Ramsey\Uuid\Lazy\LazyUuidFromString {#1232 __toString(): "4a328939-df94-4634-bfcc-281eb48e5b27" }`] View formatted query View runnable query 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 = '4a328939-df94-4634-bfcc-281eb48e5b27';
12	1.15 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: [`"hard-disk-xvr"`] View formatted query View runnable query Explain query 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 = 'hard-disk-xvr' ORDER BY a0_.position ASC, a0_.title ASC;
13	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "1-hdd"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '1-hdd';
14	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "2-hdd"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '2-hdd';
15	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "4-hdd"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '4-hdd';
16	1.66 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: [`"xvr-hd-analogni-snimaci" 1 0 "8-hdd-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '8-hdd-1';
17	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "sd-kartica"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'sd-kartica';
18	0.68 ms	SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ? Parameters: [`Ramsey\Uuid\Lazy\LazyUuidFromString {#1224 __toString(): "18ac00e6-5853-49da-a926-d8500f384730" }`] View formatted query View runnable query 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 = '18ac00e6-5853-49da-a926-d8500f384730';
19	1.12 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-snimanja-xvr"`] View formatted query View runnable query Explain query 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-snimanja-xvr' ORDER BY a0_.position ASC, a0_.title ASC;
20	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "full-hd"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'full-hd';
21	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "4k"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = '4k';
22	0.67 ms	SELECT COUNT(a0_.id) AS sclr_0 FROM attribute a0_ WHERE a0_.parent_id = ? Parameters: [`Ramsey\Uuid\Lazy\LazyUuidFromString {#1215 __toString(): "c2bbe3a2-7143-45df-accf-379c465b9adf" }`] View formatted query View runnable query 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 = 'c2bbe3a2-7143-45df-accf-379c465b9adf';
23	1.22 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: [`"ostalo-xvr"`] View formatted query View runnable query Explain query 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 = 'ostalo-xvr' ORDER BY a0_.position ASC, a0_.title ASC;
24	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "smd-2"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'smd-2';
25	1.60 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: [`"xvr-hd-analogni-snimaci" 1 0 "artificial-intelligence-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'artificial-intelligence-1';
26	1.50 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: [`"xvr-hd-analogni-snimaci" 1 0 "face-recognition-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'face-recognition-1';
27	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "perimetar-protection-2"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'perimetar-protection-2';
28	9.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: [`"xvr-hd-analogni-snimaci" 1 0 "alarm-i-o"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'alarm-i-o';
29	2.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: [`"xvr-hd-analogni-snimaci" 1 0 "audio-in-1-out-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'audio-in-1-out-1';
30	1.88 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: [`"xvr-hd-analogni-snimaci" 1 0 "audio-in-4-out-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'audio-in-4-out-1';
31	1.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: [`"xvr-hd-analogni-snimaci" 1 0 "audio-in-8-out-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'audio-in-8-out-1';
32	1.58 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: [`"xvr-hd-analogni-snimaci" 1 0 "audio-in-16-out-1"`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 AND a2_.slug = 'audio-in-16-out-1';
33	28.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 WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? ORDER BY p0_.created_at DESC LIMIT 24 Parameters: [`"xvr-hd-analogni-snimaci" 1 0`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0 ORDER BY p0_.created_at DESC LIMIT 24;
34	1.18 ms	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 = ? Parameters: [`"xvr-hd-analogni-snimaci" 1 0`] View formatted query View runnable query Explain query 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 = 'xvr-hd-analogni-snimaci' AND p0_.is_publish = 1 AND p0_.is_archived = 0;
35	0.50 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"`] View formatted query View runnable query Explain query 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;
36	1.98 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"`] View formatted query View runnable query Explain query 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 = ? 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 = '65bb129f-e7e3-45dd-b66f-80f8c9dbb78d';
37	0.70 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: [`"472aa3ba-7b1c-4a7e-856e-dbd63e7f59cb"`] View formatted query View runnable query Explain query 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 = ? 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 = '472aa3ba-7b1c-4a7e-856e-dbd63e7f59cb';
38	4.54 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: [`"8fba7f2f-c018-4f34-b579-6482dd4ecea9"`] View formatted query View runnable query Explain query 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 = ? 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 = '8fba7f2f-c018-4f34-b579-6482dd4ecea9';
39	0.88 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: [`"87104e24-9b13-43d9-b619-5dffea1aa07d"`] View formatted query View runnable query Explain query 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 = ? 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 = '87104e24-9b13-43d9-b619-5dffea1aa07d';
40	1.01 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: [`"c3a23f91-1a8b-4f5b-8101-20d825619e57"`] View formatted query View runnable query Explain query 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 = ? 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 = 'c3a23f91-1a8b-4f5b-8101-20d825619e57';
41	0.88 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: [`"d292ee99-afbb-4e4d-b06d-6eb0d99b2910"`] View formatted query View runnable query Explain query 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 = ? 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 = 'd292ee99-afbb-4e4d-b06d-6eb0d99b2910';
42	0.76 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: [`"38121b16-f277-4a2e-9713-15bde256566b"`] View formatted query View runnable query Explain query 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 = ? 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 = '38121b16-f277-4a2e-9713-15bde256566b';
43	0.77 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: [`"e34d23d8-e28e-43c1-a47d-4459735019dd"`] View formatted query View runnable query Explain query 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 = ? 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 = 'e34d23d8-e28e-43c1-a47d-4459735019dd';
44	0.95 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: [`"6d3f2074-ea15-4b9f-a537-481c2ae32224"`] View formatted query View runnable query Explain query 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 = ? 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 = '6d3f2074-ea15-4b9f-a537-481c2ae32224';
45	0.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: [`"567d9a8f-0bf7-4706-b465-4c4ee44f4ceb"`] View formatted query View runnable query Explain query 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 = ? 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 = '567d9a8f-0bf7-4706-b465-4c4ee44f4ceb';
46	0.81 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: [`"128554c7-d0e7-4e05-a899-a1f1735cdafa"`] View formatted query View runnable query Explain query 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 = ? 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 = '128554c7-d0e7-4e05-a899-a1f1735cdafa';
47	7.36 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: [`"6f4007f0-38e6-4ce2-84d1-fc5eb59d364b"`] View formatted query View runnable query Explain query 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 = ? 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 = '6f4007f0-38e6-4ce2-84d1-fc5eb59d364b';
48	1.14 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: [`"728c560f-baf9-4547-8507-2152c2729d76"`] View formatted query View runnable query Explain query 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 = ? 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 = '728c560f-baf9-4547-8507-2152c2729d76';

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	24
App\Entity\ProductCategory	14
App\Entity\Product	12
App\Entity\Brand	1

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.

Symfony Profiler

GET https://mastermontenegro.com/index.php/proizvodi/video-nadzor/xvr-hd-analogni-snimaci

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping