1 (0.484)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'
/var/www/r2d2/data/www/novelki.ru/index.php:48
2 (2.879)
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.496)
SELECT *
FROM language
WHERE status = '1'
/var/www/r2d2/data/www/novelki.ru/index.php:137
4 (0.447)
SELECT *
FROM currency
/var/www/r2d2/data/www/novelki.ru/system/library/currency.php:13
5 (0.535)
SELECT *
FROM weight_class wc
/var/www/r2d2/data/www/novelki.ru/system/library/weight.php:9
6 (0.394)
SELECT *
FROM length_class mc
/var/www/r2d2/data/www/novelki.ru/system/library/length.php:9
7 (0.827)
SELECT *
FROM url_alias
WHERE keyword IN ('iskusstvennye-elki-90sm', 'triumph-norvezhskaja-90-sm-zelenaja')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:22
8 (1.170)
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
9 (2.122)
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.926)
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.831)
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 (3.151)
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 = '72951'
AND p.date_available <= '2023-09-22' 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
13 (1.066)
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
14 (1.048)
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
15 (1.149)
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
16 (0.455)
SELECT *
FROM manufacturer_sertif
WHERE manufacturer_id = '769'
ORDER BY sort_order
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:906
17 (0.501)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
WHERE p.product_id = '72951' 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
18 (0.791)
SELECT *
FROM url_alias
WHERE `query` IN ('manufacturer_id=769')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
19 (0.503)
SELECT *
FROM product_image
WHERE product_id = '72951'
ORDER BY sort_order ASC
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:656
20 (0.531)
SELECT *
FROM product_video
WHERE product_id = '72951'
ORDER BY sort_order ASC
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:662
21 (0.380)
SELECT *
FROM product_discount
WHERE product_id = '72951' 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
22 (1.163)
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
23 (0.920)
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 = '72951' 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
24 (0.523)
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 = '72951' 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.698)
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 = '72951' 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
26 (0.397)
SELECT *
FROM product_tag
WHERE product_id = '72951'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:681
27 (0.675)
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
28 (0.337)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '72951'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:49
29 (0.501)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
30 (0.561)
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
31 (0.575)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
32 (1.117)
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
33 (0.836)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
34 (0.800)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
35 (0.789)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
36 (0.775)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
37 (0.769)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
38 (0.783)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
39 (0.778)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
40 (0.770)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
41 (0.764)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
42 (0.779)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
43 (0.770)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
44 (0.764)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
45 (0.776)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
46 (0.743)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
47 (0.768)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
48 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
49 (0.768)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
50 (0.764)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
51 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
52 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
53 (0.958)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
54 (0.849)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
55 (0.798)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
56 (0.807)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
57 (0.804)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
58 (0.810)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
59 (0.829)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
60 (0.808)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
61 (0.702)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
62 (0.817)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
63 (0.774)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
64 (0.774)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
65 (0.771)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
66 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
67 (0.763)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
68 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
69 (0.768)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
70 (0.765)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
71 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
72 (0.770)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
73 (0.765)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
74 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
75 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
76 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
77 (0.763)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
78 (0.765)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
79 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
80 (0.771)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
81 (0.770)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
82 (0.765)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
83 (0.765)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
84 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
85 (0.770)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
86 (0.768)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
87 (0.791)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
88 (0.780)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
89 (0.769)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
90 (0.767)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
91 (0.766)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
92 (0.768)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
93 (0.304)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
94 (0.451)
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
95 (0.400)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
96 (0.303)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
97 (0.450)
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
98 (0.402)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
99 (0.305)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
100 (0.412)
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
101 (0.410)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
102 (0.296)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
103 (0.412)
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
104 (0.520)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
105 (0.389)
SELECT *
FROM product_to_layout
WHERE product_id = '72951' AND store_id = '0'
/var/www/r2d2/data/www/novelki.ru/catalog/model/catalog/product.php:686
106 (0.400)
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
107 (0.416)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
108 (2.071)
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 = '72951'
AND p.date_available <= '2023-09-22' 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
109 (5.720)
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 <> '72951'
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>='-24210' AND p1.special<='29590' , p1.price>='-24210' AND p1.price<='29590')
LIMIT 0,15
/var/www/r2d2/data/www/novelki.ru/catalog/model/module/similar_products.php:50
110 (0.914)
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
111 (1.191)
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
112 (0.927)
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
113 (1.188)
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
114 (0.936)
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
115 (1.089)
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
116 (1.026)
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
117 (1.092)
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
118 (1.034)
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
119 (1.077)
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
120 (1.023)
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
121 (1.086)
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
122 (1.002)
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
123 (1.093)
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
124 (1.108)
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
125 (0.820)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
126 (0.811)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
127 (0.813)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
128 (0.815)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
129 (0.809)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
130 (0.803)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
131 (0.912)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
132 (0.714)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
133 (0.532)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
134 (0.550)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
135 (0.547)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
136 (0.545)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
137 (0.581)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
138 (0.616)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
139 (0.521)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
140 (0.492)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
141 (0.438)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
142 (0.463)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
143 (0.415)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
144 (0.425)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
145 (0.490)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
146 (0.432)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
147 (0.387)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
148 (0.353)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
149 (0.306)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
150 (0.333)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
151 (0.361)
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
152 (0.324)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
153 (0.338)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
154 (0.306)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
155 (0.341)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
156 (0.430)
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
157 (0.422)
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
158 (0.155)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
159 (0.166)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
160 (0.398)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
161 (0.360)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
162 (0.332)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
163 (0.321)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
164 (0.312)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
165 (0.346)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
166 (0.309)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
167 (0.332)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
168 (0.326)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
169 (0.312)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
170 (0.337)
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
171 (0.288)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
172 (0.331)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
173 (0.319)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
174 (0.311)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')
/var/www/r2d2/data/www/novelki.ru/catalog/controller/common/seo_pro.php:181
175 (0.442)
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
176 (0.441)
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
177 (0.163)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4
178 (0.142)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/r2d2/data/www/novelki.ru/catalog/model/setting/extension.php:4