Елки заснеженные

1 (0.058)

SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://domelki.ru/'

/var/www/r2d2/data/www/domelki.ru/index.php:48

2 (0.660)

SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

/var/www/r2d2/data/www/domelki.ru/index.php:60

3 (0.050)

SELECT *
FROM language
WHERE status = '1'

/var/www/r2d2/data/www/domelki.ru/index.php:139

4 (0.041)

SELECT *
FROM currency

/var/www/r2d2/data/www/domelki.ru/system/library/currency.php:13

5 (0.063)

SELECT *
FROM weight_class wc

/var/www/r2d2/data/www/domelki.ru/system/library/weight.php:9

6 (0.058)

SELECT *
FROM length_class mc

/var/www/r2d2/data/www/domelki.ru/system/library/length.php:9

7 (0.165)

SELECT *
FROM url_alias
WHERE keyword IN ('elki_zasnejennye')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:22

8 (0.094)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

9 (0.397)

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, c.name

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:16

10 (0.118)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

11 (0.094)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

12 (0.119)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

13 (0.540)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND p2c.category_id = '940'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:830

14 (0.092)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

15 (0.409)

SELECT DISTINCT p2c.category_id, c.name as name, c.image as image, c.parent_id, c1.name as name_parent
FROM product_to_category p2c
LEFT JOIN category c ON (p2c.category_id = c.category_id)
LEFT JOIN category c1 ON (c.parent_id = c1.category_id)
WHERE p2c.product_id IN ('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') AND p2c.main_category='1' AND p2c.store_id = '0' GROUP BY p2c.category_id
ORDER BY c.sort_order, c1.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/manufacturer.php:90

16 (0.836)

SELECT p.product_id, IF(ps.price>0,ps.price,p.price) as su, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= '2025-12-15' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0' AND p2c.category_id = '940'
ORDER BY p.sort_order ASC LIMIT 0,40

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:329

17 (0.558)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416120' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

18 (0.367)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414932' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

19 (0.441)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415005' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

20 (0.404)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416027' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

21 (0.407)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416125' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

22 (0.362)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414937' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

23 (0.352)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415008' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

24 (0.426)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416035' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

25 (0.413)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416127' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

26 (0.388)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414938' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

27 (0.395)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415011' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

28 (0.386)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416036' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

29 (0.390)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416128' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

30 (0.357)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414993' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

31 (0.434)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415792' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

32 (0.397)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416037' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

33 (0.406)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416135' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

34 (0.402)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414923' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

35 (0.387)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414994' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

36 (0.387)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415793' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

37 (0.355)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416041' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

38 (0.427)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416136' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

39 (0.393)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414681' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

40 (0.382)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414928' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

41 (0.403)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414995' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

42 (0.384)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415794' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

43 (0.400)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416042' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

44 (0.402)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416140' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

45 (0.396)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414682' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

46 (0.401)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414929' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

47 (0.385)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415003' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

48 (0.411)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416025' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

49 (0.401)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416043' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

50 (0.398)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416152' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

51 (0.395)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414683' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

52 (0.406)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414930' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

53 (0.396)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '415004' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

54 (0.374)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416026' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

55 (0.402)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '416118' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

56 (0.404)

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '414878' AND p.date_available <= '2025-12-15' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:111

57 (0.127)

SELECT *
FROM product_image
WHERE product_id = '416120'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

58 (0.223)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416120'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

59 (0.140)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416120')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

60 (0.113)

SELECT *
FROM product_image
WHERE product_id = '414932'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

61 (0.206)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414932'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

62 (0.135)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414932')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

63 (0.080)

SELECT *
FROM product_image
WHERE product_id = '415005'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

64 (0.266)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415005'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

65 (0.161)

SELECT category_id
FROM product_to_category
WHERE product_id = '415005' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

66 (0.171)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415005')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

67 (0.095)

SELECT *
FROM product_image
WHERE product_id = '416027'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

68 (0.234)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416027'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

69 (0.185)

SELECT category_id
FROM product_to_category
WHERE product_id = '416027' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

70 (0.258)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416027')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

71 (0.135)

SELECT *
FROM product_image
WHERE product_id = '416125'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

72 (0.204)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416125'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

73 (0.158)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416125')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

74 (0.129)

SELECT *
FROM product_image
WHERE product_id = '414937'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

75 (0.211)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414937'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

76 (0.181)

SELECT category_id
FROM product_to_category
WHERE product_id = '414937' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

77 (0.122)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414937')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

78 (0.084)

SELECT *
FROM product_image
WHERE product_id = '415008'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

79 (0.244)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415008'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

80 (0.099)

SELECT category_id
FROM product_to_category
WHERE product_id = '415008' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

81 (0.135)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415008')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

82 (0.065)

SELECT *
FROM product_image
WHERE product_id = '416035'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

83 (0.248)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416035'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

84 (0.155)

SELECT category_id
FROM product_to_category
WHERE product_id = '416035' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

85 (0.141)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416035')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

86 (0.076)

SELECT *
FROM product_image
WHERE product_id = '416127'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

87 (0.213)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416127'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

88 (0.137)

SELECT category_id
FROM product_to_category
WHERE product_id = '416127' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

89 (0.128)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416127')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

90 (0.124)

SELECT *
FROM product_image
WHERE product_id = '414938'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

91 (0.203)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414938'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

92 (0.130)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414938')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

93 (0.071)

SELECT *
FROM product_image
WHERE product_id = '415011'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

94 (0.206)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415011'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

95 (0.105)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415011')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

96 (0.070)

SELECT *
FROM product_image
WHERE product_id = '416036'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

97 (0.216)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416036'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

98 (0.156)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416036')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

99 (0.147)

SELECT *
FROM product_image
WHERE product_id = '416128'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

100 (0.200)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416128'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

101 (0.073)

SELECT category_id
FROM product_to_category
WHERE product_id = '416128' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

102 (0.164)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416128')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

103 (0.161)

SELECT *
FROM product_image
WHERE product_id = '414993'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

104 (0.257)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414993'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

105 (0.113)

SELECT category_id
FROM product_to_category
WHERE product_id = '414993' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

106 (0.109)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414993')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

107 (0.083)

SELECT *
FROM product_image
WHERE product_id = '415792'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

108 (0.208)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415792'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

109 (0.150)

SELECT category_id
FROM product_to_category
WHERE product_id = '415792' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

110 (0.136)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415792')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

111 (0.069)

SELECT *
FROM product_image
WHERE product_id = '416037'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

112 (0.217)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416037'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

113 (0.150)

SELECT category_id
FROM product_to_category
WHERE product_id = '416037' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

114 (0.195)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416037')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

115 (0.119)

SELECT *
FROM product_image
WHERE product_id = '416135'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

116 (0.212)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416135'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

117 (0.083)

SELECT category_id
FROM product_to_category
WHERE product_id = '416135' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

118 (0.121)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416135')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

119 (0.110)

SELECT *
FROM product_image
WHERE product_id = '414923'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

120 (0.207)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414923'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

121 (0.147)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414923')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

122 (0.087)

SELECT *
FROM product_image
WHERE product_id = '414994'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

123 (0.214)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414994'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

124 (0.147)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414994')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

125 (0.116)

SELECT *
FROM product_image
WHERE product_id = '415793'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

126 (0.209)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415793'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

127 (0.144)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415793')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

128 (0.100)

SELECT *
FROM product_image
WHERE product_id = '416041'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

129 (0.274)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416041'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

130 (0.133)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416041')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

131 (0.102)

SELECT *
FROM product_image
WHERE product_id = '416136'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

132 (0.201)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416136'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

133 (0.144)

SELECT category_id
FROM product_to_category
WHERE product_id = '416136' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

134 (0.141)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416136')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

135 (0.110)

SELECT *
FROM product_image
WHERE product_id = '414681'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

136 (0.242)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414681'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

137 (0.136)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414681')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

138 (0.097)

SELECT *
FROM product_image
WHERE product_id = '414928'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

139 (0.203)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414928'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

140 (0.122)

SELECT category_id
FROM product_to_category
WHERE product_id = '414928' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

141 (0.145)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414928')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

142 (0.107)

SELECT *
FROM product_image
WHERE product_id = '414995'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

143 (0.242)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414995'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

144 (0.110)

SELECT category_id
FROM product_to_category
WHERE product_id = '414995' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

145 (0.107)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414995')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

146 (0.084)

SELECT *
FROM product_image
WHERE product_id = '415794'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

147 (0.206)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415794'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

148 (0.152)

SELECT category_id
FROM product_to_category
WHERE product_id = '415794' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

149 (0.134)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415794')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

150 (0.078)

SELECT *
FROM product_image
WHERE product_id = '416042'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

151 (0.236)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416042'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

152 (0.143)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416042')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

153 (0.105)

SELECT *
FROM product_image
WHERE product_id = '416140'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

154 (0.204)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416140'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

155 (0.136)

SELECT category_id
FROM product_to_category
WHERE product_id = '416140' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

156 (0.132)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416140')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

157 (0.072)

SELECT *
FROM product_image
WHERE product_id = '414682'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

158 (0.200)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414682'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

159 (0.145)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414682')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

160 (0.110)

SELECT *
FROM product_image
WHERE product_id = '414929'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

161 (0.237)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414929'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

162 (0.148)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414929')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

163 (0.113)

SELECT *
FROM product_image
WHERE product_id = '415003'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

164 (0.258)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415003'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

165 (0.159)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415003')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

166 (0.099)

SELECT *
FROM product_image
WHERE product_id = '416025'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

167 (0.201)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416025'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

168 (0.163)

SELECT category_id
FROM product_to_category
WHERE product_id = '416025' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

169 (0.149)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416025')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

170 (0.100)

SELECT *
FROM product_image
WHERE product_id = '416043'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

171 (0.268)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416043'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

172 (0.147)

SELECT category_id
FROM product_to_category
WHERE product_id = '416043' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

173 (0.105)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416043')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

174 (0.069)

SELECT *
FROM product_image
WHERE product_id = '416152'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

175 (0.203)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416152'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

176 (0.120)

SELECT category_id
FROM product_to_category
WHERE product_id = '416152' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

177 (0.146)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416152')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

178 (0.085)

SELECT *
FROM product_image
WHERE product_id = '414683'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

179 (0.211)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414683'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

180 (0.138)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414683')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

181 (0.100)

SELECT *
FROM product_image
WHERE product_id = '414930'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

182 (0.243)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414930'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

183 (0.148)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414930')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

184 (0.103)

SELECT *
FROM product_image
WHERE product_id = '415004'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

185 (0.207)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415004'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

186 (0.114)

SELECT category_id
FROM product_to_category
WHERE product_id = '415004' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

187 (0.112)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=415004')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

188 (0.071)

SELECT *
FROM product_image
WHERE product_id = '416026'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

189 (0.206)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416026'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

190 (0.125)

SELECT category_id
FROM product_to_category
WHERE product_id = '416026' and store_id='0'
ORDER BY main_category DESC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:228

191 (0.146)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416026')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

192 (0.081)

SELECT *
FROM product_image
WHERE product_id = '416118'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

193 (0.210)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '416118'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

194 (0.145)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=416118')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

195 (0.091)

SELECT *
FROM product_image
WHERE product_id = '414878'
ORDER BY sort_order ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:664

196 (0.202)

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414878'
ORDER BY o.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/product.php:612

197 (0.145)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940', 'product_id=414878')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

198 (0.110)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

199 (0.079)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

200 (0.157)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

201 (0.118)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

202 (0.106)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

203 (0.103)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

204 (0.083)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

205 (0.106)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

206 (0.095)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

207 (0.068)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

208 (0.055)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

209 (0.062)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

210 (0.229)

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1' AND c.top='1'
ORDER BY c.parent_id, c.sort_order, c.name

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:114

211 (0.089)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

212 (0.079)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

213 (0.076)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

214 (0.113)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

215 (0.077)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

216 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

217 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

218 (0.076)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

219 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

220 (0.077)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

221 (0.077)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

222 (0.074)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

223 (0.109)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

224 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

225 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

226 (0.074)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

227 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

228 (0.077)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

229 (0.041)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

230 (0.055)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

231 (0.062)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

232 (0.037)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

233 (0.051)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

234 (0.063)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

235 (0.062)

SELECT DISTINCT layout_id
FROM layout_route
WHERE store_id = '0' AND route = 'product/category'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:149

236 (0.220)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top' AND b.slider = '0' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:50

237 (0.118)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top' AND b.slider = '1' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:95

238 (0.110)

SELECT MAX(bi.width) AS width, MAX(bi.height) AS height
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top' AND slider = '1' AND bi.status = '1' AND b.status = '1'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:133

239 (0.080)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

240 (0.089)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

241 (0.090)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

242 (0.056)

SELECT DISTINCT layout_id
FROM layout_route
WHERE store_id = '0' AND route = 'product/category'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:149

243 (0.125)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top_left' AND b.slider = '0' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:50

244 (0.157)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top_left' AND b.slider = '1' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:95

245 (0.135)

SELECT MAX(bi.width) AS width, MAX(bi.height) AS height
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'header_top_left' AND slider = '1' AND bi.status = '1' AND b.status = '1'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:133

246 (0.043)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

247 (0.057)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

248 (0.063)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

249 (0.056)

SELECT DISTINCT layout_id
FROM layout_route
WHERE store_id = '0' AND route = 'product/category'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:149

250 (0.115)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'content_top' AND b.slider = '0' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:50

251 (0.110)

SELECT b.slider, b.slider_arrow, b.slider_button, bi.link, bi.image, bi.width, bi.height, bi.name
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'content_top' AND b.slider = '1' AND bi.status = '1' AND b.status = '1'
ORDER BY b.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:95

252 (0.103)

SELECT MAX(bi.width) AS width, MAX(bi.height) AS height
FROM banner_advanced_parts b
LEFT JOIN banner_advanced_image bi ON bi.banner_advanced_image_id = b.banner_advanced_image_id
WHERE b.layout_id = '3' AND b.part_id = '940' AND b.store_id = '0' AND ( ((bi.date_start <= CURDATE() OR bi.date_start = '0000-00-00') AND (bi.date_end >= CURDATE() OR bi.date_end = '0000-00-00')) OR (bi.date_start = '0000-00-00' AND bi.date_end = '0000-00-00') ) AND b.position = 'content_top' AND slider = '1' AND bi.status = '1' AND b.status = '1'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/banner_advanced.php:133

253 (0.697)

SELECT a.name, a.attribute_id,pa.attribute_value_id
FROM attribute a
LEFT JOIN product_attribute pa on pa.attribute_id=a.attribute_id
WHERE a.use_in_filter='1' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') group by a.attribute_id

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

254 (0.887)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='391' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

255 (0.605)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='404' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

256 (0.993)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='412' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

257 (0.562)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='430' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

258 (0.524)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='676' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

259 (0.597)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='677' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

260 (0.580)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='742' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

261 (0.656)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='763' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

262 (0.614)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='764' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

263 (0.866)

SELECT distinct av.value, (select count(pa1.product_id)
from product_attribute pa1
left join product pp on pp.product_id=pa1.product_id
where pa1.store_id='0' and pa1.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152' ) and av.attribute_value_id=pa1.attribute_value_id ) as count, av.attribute_value_id
FROM attribute_value av
LEFT JOIN product_attribute pa on pa.attribute_value_id=av.attribute_value_id
left join attribute_to_category a2c on a2c.attribute_id=pa.attribute_id
where av.attribute_id='765' and pa.store_id='0' and pa.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and a2c.category_id IN('940')
order by av.sort_order

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

264 (0.628)

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and p2s.status = '1' and p2s.store_id='0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

265 (0.471)

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('414681','414682','414683','414878','414879','414880','414890','414891','414892','414893','414894','414895','414896','414897','414901','414923','414928','414929','414930','414932','414937','414938','414993','414994','414995','415003','415004','415005','415008','415011','415792','415793','415794','416025','416026','416027','416035','416036','416037','416041','416042','416043','416118','416120','416125','416127','416128','416135','416136','416140','416152') and p2s.status = '1' and p2s.store_id='0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/module/filter.php:12

266 (0.047)

SELECT *
FROM category_to_layout
WHERE category_id = '940' AND store_id = '0'

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/category.php:87

267 (0.061)

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

/var/www/r2d2/data/www/domelki.ru/catalog/model/design/layout.php:4

268 (0.064)

SELECT *
FROM extension
WHERE `type` = 'module'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

269 (0.293)

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/information.php:12

270 (0.118)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

271 (0.080)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

272 (0.082)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

273 (0.119)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

274 (0.117)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

275 (0.104)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

276 (0.104)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

277 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

278 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

279 (0.082)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=939')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

280 (0.105)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

281 (0.075)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=941')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

282 (0.148)

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

/var/www/r2d2/data/www/domelki.ru/catalog/model/catalog/information.php:12

283 (0.087)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

284 (0.079)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

285 (0.077)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

286 (0.074)

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

287 (0.082)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

288 (0.081)

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=940')

/var/www/r2d2/data/www/domelki.ru/catalog/controller/common/seo_pro.php:181

289 (0.050)

SELECT *
FROM extension
WHERE `type` = 'total'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

290 (0.094)

SELECT *
FROM extension
WHERE `type` = 'total'

/var/www/r2d2/data/www/domelki.ru/catalog/model/setting/extension.php:4

Елки заснеженные

Информация

Служба поддержки

Дополнительно

+7 (495) 125-42-75

Елки литые 100% PE

Елки заснеженные

Елки настольные

Корзина

Елки заснеженные