1 (0.475)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'
/var/www/r2d2/data/www/novelki.ru/index.php:48
2 (2.822)
SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/r2d2/data/www/novelki.ru/index.php:58
3 (0.479)
SELECT *
FROM language
WHERE status = '1'
/var/www/r2d2/data/www/novelki.ru/index.php:137
4 (0.433)
SELECT *
FROM currency
/var/www/r2d2/data/www/novelki.ru/system/library/currency.php:13
5 (0.443)
SELECT *
FROM weight_class wc
/var/www/r2d2/data/www/novelki.ru/system/library/weight.php:9
6 (0.375)
SELECT *
FROM length_class mc
/var/www/r2d2/data/www/novelki.ru/system/library/length.php:9
7 (0.797)
SELECT *
FROM url_alias
WHERE keyword IN ('iskusstvennye-elki-90sm', 'peneri-sofija-zolotaja-90-sm')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:22
8 (1.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
9 (2.070)
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/novelki.ru/catalog/model/catalog/category.php:16
10 (0.910)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
11 (0.783)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
12 (2.087)
SELECT p.product_id, p.name as name,
(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_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
LEFT JOIN product_to_category p2c
ON (p.product_id = p2c.product_id)
WHERE p.status = '1' and p2s.status = '1' AND p2s.store_id = '0'
AND p.date_available <= '2023-06-04 '
AND p2c.store_id = '0' AND p2c.category_id = '929' GROUP BY p.product_id
/var/www/r2d2/data/www/novelki.ru/catalog/model/module/filter.php:12
13 (2.676)
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 = '72669'
AND p.date_available <= '2023-06-04' 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/novelki.ru/catalog/model/catalog/product.php:111
14 (1.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
15 (1.030)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
16 (1.153)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
17 (0.445)
SELECT *
FROM manufacturer_sertif
WHERE manufacturer_id = '774'
ORDER BY sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:906
18 (0.479)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
WHERE p.product_id = '72669' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/review.php:53
19 (0.771)
SELECT *
FROM url_alias
WHERE `query` IN ('manufacturer_id=774')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
20 (0.575)
SELECT *
FROM product_image
WHERE product_id = '72669'
ORDER BY sort_order ASC
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:656
21 (0.437)
SELECT *
FROM product_video
WHERE product_id = '72669'
ORDER BY sort_order ASC
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:662
22 (0.339)
SELECT *
FROM product_discount
WHERE product_id = '72669' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:650
23 (1.230)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72669'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
24 (0.795)
SELECT ag.attribute_group_id, ag.name, a.attribute_type
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
WHERE pa.product_id = '72669' and pa.store_id='0'
GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, ag.name
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:545
25 (0.482)
SELECT ag.attribute_group_id, ag.name, a.attribute_type
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
WHERE pa.product_id = '72669' and pa.store_id='0'
GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, ag.name
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:545
26 (0.669)
SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '72669' AND p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:671
27 (0.417)
SELECT *
FROM product_tag
WHERE product_id = '72669'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:681
28 (0.624)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '6'
AND i2s.store_id = '0' AND i.status = '1'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/information.php:12
29 (0.310)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '72669'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:49
30 (0.451)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
31 (0.546)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
32 (0.560)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
33 (1.349)
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/novelki.ru/catalog/model/catalog/category.php:114
34 (1.283)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
35 (1.259)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
36 (0.973)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
37 (0.798)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
38 (0.787)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
39 (0.915)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
40 (0.854)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
41 (0.788)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
42 (0.793)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
43 (0.771)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
44 (0.771)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
45 (0.781)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
46 (0.779)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
47 (0.779)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
48 (0.777)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
49 (0.764)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
50 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
51 (0.763)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
52 (0.762)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
53 (0.749)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
54 (0.764)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
55 (0.755)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
56 (0.755)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
57 (0.772)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
58 (0.756)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
59 (0.642)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
60 (0.537)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
61 (0.515)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
62 (0.520)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
63 (0.534)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
64 (0.515)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
65 (0.516)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
66 (0.536)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
67 (0.381)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
68 (0.390)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
69 (0.378)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
70 (0.391)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
71 (0.380)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
72 (0.391)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
73 (0.380)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
74 (0.388)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
75 (0.378)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
76 (0.376)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
77 (0.364)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
78 (0.303)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
79 (0.309)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
80 (0.303)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
81 (0.301)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
82 (0.307)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
83 (0.306)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
84 (0.320)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
85 (0.314)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
86 (0.306)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
87 (0.312)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
88 (0.303)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
89 (0.307)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
90 (0.313)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
91 (0.251)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
92 (0.250)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
93 (0.256)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
94 (0.091)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
95 (0.127)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
96 (0.136)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
97 (0.090)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
98 (0.122)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
99 (0.125)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
100 (0.088)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
101 (0.123)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
102 (0.122)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
103 (0.084)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
104 (0.117)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
105 (0.131)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
106 (0.084)
SELECT *
FROM product_to_layout
WHERE product_id = '72669' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
107 (0.117)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/r2d2/data/www/novelki.ru/catalog/model/design/layout.php:4
108 (0.121)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
109 (0.745)
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 = '72669'
AND p.date_available <= '2023-06-04' 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/novelki.ru/catalog/model/catalog/product.php:111
110 (1.811)
SELECT *
FROM (
SELECT DISTINCT
p.product_id,
p.complect,
p.price,
p.tax_class_id,
p.sku,
p.top_100,
p.recommend,
p.present,
p2s.description,
p.name AS name,
p.image,
(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 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,
p.sort_order
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.product_id <> '72669'
AND p.status = '1'
AND p2c.category_id = '929'
AND p2c.main_category = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND p2s.status = '1'
) p1
WHERE IF(p1.special>0, p1.special>='-6291' AND p1.special<='7689' , p1.price>='-6291' AND p1.price<='7689')
LIMIT 0,15
/var/www/r2d2/data/www/novelki.ru/catalog/model/module/similar_products.php:50
111 (0.350)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '16409'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
112 (0.310)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=16409')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
113 (0.252)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72324'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
114 (0.301)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72324')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
115 (0.253)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72951'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
116 (0.307)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72951')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
117 (0.221)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72676'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
118 (0.257)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72676')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
119 (0.219)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405783'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
120 (0.258)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=405783')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
121 (0.215)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405794'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
122 (0.257)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=405794')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
123 (0.260)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405809'
ORDER BY o.sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:604
124 (0.285)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=405809')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
125 (0.353)
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/novelki.ru/catalog/model/catalog/information.php:12
126 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
127 (0.223)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
128 (0.222)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
129 (0.211)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
130 (0.169)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
131 (0.219)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
132 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
133 (0.176)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
134 (0.177)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
135 (0.187)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
136 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
137 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
138 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
139 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
140 (0.189)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
141 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
142 (0.155)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
143 (0.201)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
144 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
145 (0.178)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
146 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
147 (0.150)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
148 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
149 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
150 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
151 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
152 (0.177)
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/novelki.ru/catalog/model/catalog/information.php:12
153 (0.205)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
154 (0.191)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
155 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
156 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
157 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
158 (0.195)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
159 (0.051)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
160 (0.101)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
161 (0.200)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
162 (0.187)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
163 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
164 (0.207)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
165 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
166 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
167 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
168 (0.193)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
169 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
170 (0.132)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
171 (0.170)
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/novelki.ru/catalog/model/catalog/information.php:12
172 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
173 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
174 (0.201)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
175 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
176 (0.212)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
177 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929', 'product_id=72669')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
178 (0.076)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
179 (0.078)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4