Ваш заказ принят. В ближайшее время с вами свяжется оператор.
1 (0.107)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://abakan.mypads.ru/'
/var/www/alys2007/data/www/production.mypads.ru/index.php:171
2 (0.080)
SELECT *
FROM language
/var/www/alys2007/data/www/production.mypads.ru/index.php:284
3 (0.070)
SELECT *
FROM currency
/var/www/alys2007/data/www/production.mypads.ru/system/library/currency.php:13
4 (0.139)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/alys2007/data/www/production.mypads.ru/system/library/weight.php:9
5 (0.104)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/alys2007/data/www/production.mypads.ru/system/library/length.php:9
6 (0.203)
SELECT f1.postalcode f1_postalcode, CONCAT(f1.shortname, ' ', f1.offname) f1_name,
f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname,
CONCAT(f2.offname, ' ', f2.shortname) f2_name,
f2.level f2_level, f2.fias_id f2_fias_id,
CONCAT(f3.offname, ' ', f3.shortname) f3_name,
f3.level f3_level, f3.fias_id f3_fias_id,
CONCAT(f4.offname, ' ', f4.shortname) f4_name,
f4.level f4_level, f4.fias_id f4_fias_id
FROM fias f1
LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
WHERE f1.offname = 'Хьюстон'
AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США')
AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:208
7 (0.074)
SELECT *
FROM country c
WHERE c.iso_code_2 = "US"
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:148
8 (0.050)
SELECT code
FROM geoip_currency
WHERE country_id = 0
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:241
9 (0.042)
SELECT *
FROM geoip_rule
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:227
10 (0.038)
SELECT *
FROM geoip_redirect
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:234
11 (0.219)
SELECT CONCAT_WS(', ', CONCAT(f1.shortname, ' ', f1.offname), CONCAT(f2.offname, ' ', f2.shortname),
CONCAT(f3.offname, ' ', f3.shortname)) label, CONCAT(f1.shortname, ' ', f1.offname) value,
f1.fias_id
FROM fias f1
LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
WHERE ((f1.offname = 'абакан'))
AND (f1.level = 6 OR f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
ORDER BY f1.level, f2.level, f3.level, f1.shortname
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:40
12 (0.070)
SELECT zone_id
FROM zone_to_fias
WHERE fias_id = 69
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:162
13 (0.074)
SELECT c.country_id, c.name country_name, z.zone_id, z.name zone_name
FROM zone z
LEFT JOIN country c ON z.country_id = c.country_id
WHERE z.zone_id = "2721"
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:141
14 (0.120)
SELECT *
FROM url_alias
WHERE keyword IN ('aks-dlya-telefonov', 'alcatel', 'chehly-dlya-alcatel-pixi-3-45-5017x')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:35
15 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '10117'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
16 (0.107)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
17 (235.269)
SELECT top, cd.`category_id`, `parent_id`, `name`, `sort_order`, `column`, u.keyword as url
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN url_alias u ON (CONCAT('category_id=',c.category_id) = u.`query`)
WHERE cd.language_id = '1' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/optimization/main.php:100
18 (0.488)
SELECT DISTINCT top, description, image, seo_title, meta_description, meta_keyword, seo_h1, cd.`category_id`, `parent_id`, `name`, `sort_order`, `column`, u.keyword as url
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN url_alias u ON (CONCAT('category_id=',c.category_id) = u.`query`)
WHERE c.category_id = '73' AND cd.language_id = '1' AND c.status = '1'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:65
19 (0.184)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '73'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
20 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
21 (0.369)
SELECT DISTINCT top, description, image, seo_title, meta_description, meta_keyword, seo_h1, cd.`category_id`, `parent_id`, `name`, `sort_order`, `column`, u.keyword as url
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN url_alias u ON (CONCAT('category_id=',c.category_id) = u.`query`)
WHERE c.category_id = '649' AND cd.language_id = '1' AND c.status = '1'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:65
22 (0.171)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '649'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
23 (0.123)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
24 (0.356)
SELECT DISTINCT top, description, image, seo_title, meta_description, meta_keyword, seo_h1, cd.`category_id`, `parent_id`, `name`, `sort_order`, `column`, u.keyword as url
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN url_alias u ON (CONCAT('category_id=',c.category_id) = u.`query`)
WHERE c.category_id = '10117' AND cd.language_id = '1' AND c.status = '1'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:65
25 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
26 (0.151)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
27 (0.213)
SELECT top, description, image, seo_title, meta_description, meta_keyword, seo_h1, cd.`category_id`, `parent_id`, `name`, `sort_order`, `column`, u.keyword as url
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN url_alias u ON (CONCAT('category_id=',c.category_id) = u.`query`)
WHERE cd.language_id = '1' AND c.status = '1' AND c.category_id IN (10117)
ORDER BY c.parent_id, c.sort_order, cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/optimization/main.php:190
28 (0.337)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '10117'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:584
29 (0.328)
SELECT p.product_id
FROM product p
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '10117' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(p.name) ASC LIMIT 0,100
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:215
30 (0.475)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '63138'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
31 (0.419)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '227214'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
32 (0.415)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '62759'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
33 (0.422)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '174882'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
34 (0.440)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '78882'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
35 (0.427)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '202464'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
36 (0.422)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '217229'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
37 (0.419)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '189637'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
38 (0.414)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '63634'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
39 (0.414)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '182264'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
40 (0.422)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '209846'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
41 (0.444)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '64723'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
42 (0.431)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '73513'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
43 (0.084)
SELECT `image`
FROM `category`
WHERE `category_id` = 10117
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
44 (0.065)
SELECT `image`
FROM `category`
WHERE `category_id` = 649
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
45 (0.170)
SELECT *
FROM product_image
WHERE product_id = '63138'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
46 (0.439)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '63138' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
47 (0.107)
SELECT *
FROM product_video
WHERE product_id = '63138'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
48 (0.128)
SELECT category_id
FROM product_to_category
WHERE product_id = '63138'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
49 (0.226)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=63138')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
50 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=63138&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
51 (0.132)
SELECT *
FROM product_image
WHERE product_id = '227214'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
52 (0.363)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '227214' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
53 (0.108)
SELECT *
FROM product_video
WHERE product_id = '227214'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
54 (0.154)
SELECT category_id
FROM product_to_category
WHERE product_id = '227214'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
55 (0.208)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=227214')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
56 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=227214&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
57 (0.149)
SELECT *
FROM product_image
WHERE product_id = '62759'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
58 (0.428)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '62759' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
59 (0.104)
SELECT *
FROM product_video
WHERE product_id = '62759'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
60 (0.134)
SELECT category_id
FROM product_to_category
WHERE product_id = '62759'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
61 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=62759')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
62 (0.189)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=62759&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
63 (0.139)
SELECT *
FROM product_image
WHERE product_id = '174882'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
64 (0.383)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '174882' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
65 (0.103)
SELECT *
FROM product_video
WHERE product_id = '174882'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
66 (0.126)
SELECT category_id
FROM product_to_category
WHERE product_id = '174882'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
67 (0.211)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=174882')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
68 (0.195)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=174882&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
69 (0.153)
SELECT *
FROM product_image
WHERE product_id = '78882'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
70 (0.416)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '78882' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
71 (0.112)
SELECT *
FROM product_video
WHERE product_id = '78882'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
72 (0.136)
SELECT category_id
FROM product_to_category
WHERE product_id = '78882'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
73 (0.238)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=78882')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
74 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=78882&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
75 (0.169)
SELECT *
FROM product_image
WHERE product_id = '202464'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
76 (0.453)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '202464' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
77 (0.111)
SELECT *
FROM product_video
WHERE product_id = '202464'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
78 (0.135)
SELECT category_id
FROM product_to_category
WHERE product_id = '202464'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
79 (0.231)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=202464')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
80 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=202464&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
81 (0.143)
SELECT *
FROM product_image
WHERE product_id = '217229'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
82 (0.480)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '217229' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
83 (0.107)
SELECT *
FROM product_video
WHERE product_id = '217229'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
84 (0.122)
SELECT category_id
FROM product_to_category
WHERE product_id = '217229'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
85 (0.230)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=217229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
86 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=217229&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
87 (0.138)
SELECT *
FROM product_image
WHERE product_id = '189637'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
88 (0.388)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '189637' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
89 (0.101)
SELECT *
FROM product_video
WHERE product_id = '189637'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
90 (0.130)
SELECT category_id
FROM product_to_category
WHERE product_id = '189637'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
91 (0.189)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=189637')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
92 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=189637&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
93 (0.137)
SELECT *
FROM product_image
WHERE product_id = '63634'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
94 (0.367)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '63634' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
95 (0.099)
SELECT *
FROM product_video
WHERE product_id = '63634'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
96 (0.179)
SELECT category_id
FROM product_to_category
WHERE product_id = '63634'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
97 (0.258)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=63634')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
98 (0.214)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=63634&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
99 (0.172)
SELECT *
FROM product_image
WHERE product_id = '182264'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
100 (0.376)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '182264' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
101 (0.102)
SELECT *
FROM product_video
WHERE product_id = '182264'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
102 (0.129)
SELECT category_id
FROM product_to_category
WHERE product_id = '182264'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
103 (0.199)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=182264')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
104 (0.215)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=182264&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
105 (0.156)
SELECT *
FROM product_image
WHERE product_id = '209846'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
106 (0.350)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '209846' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
107 (0.113)
SELECT *
FROM product_video
WHERE product_id = '209846'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
108 (0.135)
SELECT category_id
FROM product_to_category
WHERE product_id = '209846'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
109 (0.212)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=209846')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
110 (0.193)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=209846&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
111 (0.157)
SELECT *
FROM product_image
WHERE product_id = '64723'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
112 (0.330)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '64723' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
113 (0.112)
SELECT *
FROM product_video
WHERE product_id = '64723'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
114 (0.133)
SELECT category_id
FROM product_to_category
WHERE product_id = '64723'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
115 (0.221)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=64723')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
116 (0.221)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=64723&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
117 (0.161)
SELECT *
FROM product_image
WHERE product_id = '73513'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
118 (0.319)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '73513' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
119 (2.788)
SELECT *
FROM product_video
WHERE product_id = '73513'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
120 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '73513'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
121 (0.187)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=73513')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
122 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=73513&dynamic_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
123 (0.161)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
124 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
125 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
126 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
127 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
128 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
129 (0.122)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
130 (0.120)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
131 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
132 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
133 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
134 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
135 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
136 (0.089)
SELECT *
FROM category_to_layout
WHERE category_id = '10117' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
137 (0.132)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
138 (0.150)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
139 (0.076)
SELECT *
FROM category_to_layout
WHERE category_id = '10117' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
140 (0.116)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
141 (0.128)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
142 (0.073)
SELECT *
FROM category_to_layout
WHERE category_id = '10117' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
143 (0.119)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
144 (0.126)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
145 (0.238)
SELECT c.category_id, cd.name
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1' AND c.parent_id = '0'
ORDER BY c.sort_order
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:98
146 (0.957)
SELECT c.category_id, cd.name
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1' AND c.parent_id = '73'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
147 (0.840)
SELECT c.category_id, cd.name
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1' AND c.parent_id = '649'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
148 (0.090)
SELECT *
FROM category_to_layout
WHERE category_id = '10117' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
149 (0.119)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
150 (0.128)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
151 (0.413)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '100376'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
152 (0.125)
SELECT category_id
FROM product_to_category
WHERE product_id = '100376'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
153 (0.174)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '13946'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
154 (0.141)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=13946', 'product_id=100376')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
155 (0.346)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117194'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
156 (0.135)
SELECT category_id
FROM product_to_category
WHERE product_id = '117194'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
157 (0.153)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '20081'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
158 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=20081', 'product_id=117194')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
159 (0.372)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127394'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
160 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '127394'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
161 (0.150)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '3082'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
162 (0.139)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=127394')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
163 (0.344)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120752'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
164 (0.119)
SELECT category_id
FROM product_to_category
WHERE product_id = '120752'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
165 (0.149)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17812'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
166 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120752')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
167 (0.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '124849'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
168 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '124849'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
169 (0.149)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '3759'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
170 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124849')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
171 (0.344)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108998'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
172 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '108998'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
173 (0.136)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16366'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
174 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16366', 'product_id=108998')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
175 (0.361)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108980'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
176 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '108980'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
177 (0.151)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17806'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
178 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17806', 'product_id=108980')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
179 (0.341)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153521'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
180 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '153521'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
181 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17394'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
182 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153521')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
183 (0.345)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117185'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
184 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '117185'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
185 (0.139)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16371'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
186 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=117185')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
187 (0.365)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '758'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
188 (0.123)
SELECT category_id
FROM product_to_category
WHERE product_id = '758'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
189 (0.135)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '10495'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
190 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=758')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
191 (0.344)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117235'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
192 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '117235'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
193 (0.145)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17802'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
194 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117235')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
195 (0.325)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '130624'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
196 (0.123)
SELECT category_id
FROM product_to_category
WHERE product_id = '130624'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
197 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16360'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
198 (0.150)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16360', 'product_id=130624')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
199 (0.329)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108602'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
200 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '108602'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
201 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108602')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
202 (0.345)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108981'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
203 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '108981'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
204 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108981')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
205 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120763'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
206 (0.105)
SELECT category_id
FROM product_to_category
WHERE product_id = '120763'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
207 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120763')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
208 (0.400)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109000'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
209 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '109000'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
210 (0.187)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17131'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
211 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109000')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
212 (0.356)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109016'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
213 (0.112)
SELECT category_id
FROM product_to_category
WHERE product_id = '109016'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
214 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16373'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
215 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=109016')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
216 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '147462'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
217 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '147462'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
218 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=147462')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
219 (0.343)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117249'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
220 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '117249'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
221 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117249')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
222 (0.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '254'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
223 (0.112)
SELECT category_id
FROM product_to_category
WHERE product_id = '254'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
224 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=254')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
225 (0.354)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120756'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
226 (0.117)
SELECT category_id
FROM product_to_category
WHERE product_id = '120756'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
227 (0.155)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=120756')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
228 (0.338)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108993'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
229 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '108993'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
230 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108993')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
231 (0.338)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120754'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
232 (0.110)
SELECT category_id
FROM product_to_category
WHERE product_id = '120754'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
233 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120754')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
234 (0.361)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109011'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
235 (0.105)
SELECT category_id
FROM product_to_category
WHERE product_id = '109011'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
236 (0.152)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17132'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
237 (0.155)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17132', 'product_id=109011')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
238 (0.335)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117188'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
239 (0.118)
SELECT category_id
FROM product_to_category
WHERE product_id = '117188'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
240 (0.149)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16353'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
241 (0.131)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16353', 'product_id=117188')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
242 (0.331)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108996'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
243 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '108996'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
244 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17806', 'product_id=108996')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
245 (0.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '74510'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
246 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '74510'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
247 (0.139)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=74510')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
248 (0.336)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
249 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '158'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
250 (0.146)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17828'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
251 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10511', 'category_id=17828', 'product_id=158')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
252 (0.350)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120746'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
253 (0.117)
SELECT category_id
FROM product_to_category
WHERE product_id = '120746'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
254 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=120746')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
255 (0.339)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1067'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
256 (0.103)
SELECT category_id
FROM product_to_category
WHERE product_id = '1067'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
257 (0.139)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '3761'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
258 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=1067')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
259 (0.341)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '152599'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
260 (0.110)
SELECT category_id
FROM product_to_category
WHERE product_id = '152599'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
261 (0.192)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=152599')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
262 (0.350)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '28920'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
263 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '28920'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
264 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=28920')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
265 (0.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120862'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
266 (0.105)
SELECT category_id
FROM product_to_category
WHERE product_id = '120862'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
267 (0.157)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120862')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
268 (0.344)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108997'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
269 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '108997'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
270 (0.145)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16365'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
271 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16365', 'product_id=108997')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
272 (0.306)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127471'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
273 (0.098)
SELECT category_id
FROM product_to_category
WHERE product_id = '127471'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
274 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17803'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
275 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17803', 'product_id=127471')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
276 (0.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109014'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
277 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '109014'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
278 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=109014')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
279 (0.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8799'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
280 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '8799'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
281 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=8799')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
282 (0.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '586'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
283 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '586'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
284 (0.132)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=586')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
285 (0.308)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153702'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
286 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '153702'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
287 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153702')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
288 (0.301)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117190'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
289 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '117190'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
290 (0.139)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '13754'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
291 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117190')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
292 (0.308)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108217'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
293 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '108217'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
294 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108217')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
295 (0.318)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '585'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
296 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '585'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
297 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=585')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
298 (0.318)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117174'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
299 (0.098)
SELECT category_id
FROM product_to_category
WHERE product_id = '117174'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
300 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16361'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
301 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16361', 'product_id=117174')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
302 (0.312)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108989'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
303 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '108989'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
304 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108989')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
305 (0.308)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120755'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
306 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '120755'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
307 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120755')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
308 (0.310)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12511'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
309 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '12511'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
310 (0.124)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=12511')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
311 (0.319)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117165'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
312 (0.097)
SELECT category_id
FROM product_to_category
WHERE product_id = '117165'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
313 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16374'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
314 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16374', 'product_id=117165')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
315 (0.317)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '61477'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
316 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '61477'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
317 (0.145)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '9961'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
318 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=721', 'category_id=9961', 'product_id=61477')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
319 (0.322)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153942'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
320 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '153942'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
321 (0.140)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17395'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
322 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17395', 'product_id=153942')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
323 (0.317)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153623'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
324 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '153623'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
325 (0.141)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153623')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
326 (0.315)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108985'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
327 (0.097)
SELECT category_id
FROM product_to_category
WHERE product_id = '108985'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
328 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108985')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
329 (0.309)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108218'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
330 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '108218'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
331 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108218')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
332 (0.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109010'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
333 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '109010'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
334 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109010')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
335 (0.316)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108984'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
336 (0.098)
SELECT category_id
FROM product_to_category
WHERE product_id = '108984'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
337 (0.128)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108984')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
338 (0.315)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120747'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
339 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '120747'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
340 (0.150)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=120747')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
341 (0.320)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108986'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
342 (0.097)
SELECT category_id
FROM product_to_category
WHERE product_id = '108986'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
343 (0.122)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108986')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
344 (0.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117176'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
345 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '117176'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
346 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117176')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
347 (0.319)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9150'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
348 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '9150'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
349 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=9150')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
350 (0.309)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117236'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
351 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '117236'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
352 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=117236')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
353 (0.323)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127481'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
354 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '127481'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
355 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17800'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
356 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17800', 'product_id=127481')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
357 (0.350)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127467'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
358 (0.131)
SELECT category_id
FROM product_to_category
WHERE product_id = '127467'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
359 (0.208)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17810'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
360 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17810', 'product_id=127467')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
361 (0.545)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120855'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
362 (0.134)
SELECT category_id
FROM product_to_category
WHERE product_id = '120855'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
363 (0.206)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17370'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
364 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16356', 'category_id=17370', 'product_id=120855')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
365 (0.464)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '130354'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
366 (0.133)
SELECT category_id
FROM product_to_category
WHERE product_id = '130354'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
367 (0.203)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '13805'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
368 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13805', 'product_id=130354')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
369 (0.475)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127480'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
370 (0.132)
SELECT category_id
FROM product_to_category
WHERE product_id = '127480'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
371 (0.202)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17800', 'product_id=127480')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
372 (0.473)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120745'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
373 (0.139)
SELECT category_id
FROM product_to_category
WHERE product_id = '120745'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
374 (0.228)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120745')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
375 (0.471)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108990'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
376 (0.161)
SELECT category_id
FROM product_to_category
WHERE product_id = '108990'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
377 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108990')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
378 (0.546)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120888'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
379 (0.140)
SELECT category_id
FROM product_to_category
WHERE product_id = '120888'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
380 (0.229)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '13839'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
381 (0.216)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13801', 'category_id=13839', 'product_id=120888')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
382 (0.384)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109013'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
383 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '109013'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
384 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109013')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
385 (0.324)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117175'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
386 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '117175'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
387 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117175')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
388 (0.329)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120863'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
389 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '120863'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
390 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=13946', 'product_id=120863')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
391 (0.333)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120744'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
392 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '120744'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
393 (0.151)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120744')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
394 (0.338)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120764'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
395 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '120764'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
396 (0.147)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17807'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
397 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17807', 'product_id=120764')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
398 (0.331)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153522'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
399 (0.154)
SELECT category_id
FROM product_to_category
WHERE product_id = '153522'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
400 (0.223)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153522')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
401 (0.508)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109002'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
402 (0.130)
SELECT category_id
FROM product_to_category
WHERE product_id = '109002'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
403 (0.222)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109002')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
404 (0.473)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '152587'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
405 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '152587'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
406 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=152587')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
407 (0.302)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108999'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
408 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '108999'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
409 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=108999')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
410 (0.310)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '65567'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
411 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '65567'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
412 (0.151)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '6107'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
413 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=215', 'category_id=6107', 'product_id=65567')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
414 (0.304)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '101424'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
415 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '101424'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
416 (0.137)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '19717'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
417 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=4398', 'category_id=19717', 'product_id=101424')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
418 (0.370)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '124825'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
419 (0.319)
SELECT category_id
FROM product_to_category
WHERE product_id = '124825'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
420 (0.583)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124825')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
421 (0.493)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153714'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
422 (0.163)
SELECT category_id
FROM product_to_category
WHERE product_id = '153714'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
423 (0.230)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '92'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
424 (0.238)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=18', 'category_id=76', 'category_id=92', 'product_id=153714')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
425 (0.456)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120753'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
426 (0.141)
SELECT category_id
FROM product_to_category
WHERE product_id = '120753'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
427 (0.218)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120753')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
428 (0.444)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7738'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
429 (0.145)
SELECT category_id
FROM product_to_category
WHERE product_id = '7738'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
430 (0.209)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16370'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
431 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'product_id=7738')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
432 (1.709)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '74507'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
433 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '74507'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
434 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'product_id=74507')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
435 (0.441)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108229'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
436 (0.125)
SELECT category_id
FROM product_to_category
WHERE product_id = '108229'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
437 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
438 (0.450)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109018'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
439 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '109018'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
440 (0.153)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=109018')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
441 (0.392)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '229'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
442 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '229'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
443 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
444 (0.450)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109019'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
445 (0.131)
SELECT category_id
FROM product_to_category
WHERE product_id = '109019'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
446 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=109019')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
447 (0.440)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153943'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
448 (0.137)
SELECT category_id
FROM product_to_category
WHERE product_id = '153943'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
449 (0.218)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153943')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
450 (0.446)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109009'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
451 (0.138)
SELECT category_id
FROM product_to_category
WHERE product_id = '109009'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
452 (0.191)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109009')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
453 (0.451)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153400'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
454 (0.140)
SELECT category_id
FROM product_to_category
WHERE product_id = '153400'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
455 (0.292)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153400')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
456 (0.448)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109015'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
457 (0.127)
SELECT category_id
FROM product_to_category
WHERE product_id = '109015'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
458 (0.230)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16357'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
459 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16357', 'product_id=109015')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
460 (0.494)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '124853'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
461 (0.134)
SELECT category_id
FROM product_to_category
WHERE product_id = '124853'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
462 (0.212)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=124853')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
463 (0.453)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153547'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
464 (0.131)
SELECT category_id
FROM product_to_category
WHERE product_id = '153547'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
465 (0.197)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17461'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
466 (0.197)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17461', 'product_id=153547')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
467 (0.360)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108991'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
468 (0.137)
SELECT category_id
FROM product_to_category
WHERE product_id = '108991'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
469 (0.179)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108991')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
470 (0.448)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117163'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
471 (0.143)
SELECT category_id
FROM product_to_category
WHERE product_id = '117163'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
472 (0.282)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117163')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
473 (0.432)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108994'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
474 (0.135)
SELECT category_id
FROM product_to_category
WHERE product_id = '108994'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
475 (0.186)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108994')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
476 (0.428)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(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 ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120762'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
477 (0.117)
SELECT category_id
FROM product_to_category
WHERE product_id = '120762'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
478 (0.225)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16372'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
479 (0.196)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16372', 'product_id=120762')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
480 (0.217)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=152587')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
481 (0.205)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=18', 'category_id=76', 'category_id=92', 'product_id=153714')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
482 (0.202)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13801', 'category_id=13839', 'product_id=120888')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
483 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17806', 'product_id=108996')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
484 (0.180)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=117185')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
485 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=254')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
486 (0.215)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=215', 'category_id=6107', 'product_id=65567')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
487 (0.199)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109002')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
488 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13805', 'product_id=130354')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
489 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=109019')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
490 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109010')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
491 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=74510')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
492 (0.195)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=586')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
493 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=13946', 'product_id=100376')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
494 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117163')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
495 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16366', 'product_id=108998')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
496 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16365', 'product_id=108997')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
497 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=108999')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
498 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153623')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
499 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108993')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
500 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=120747')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
501 (0.151)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108984')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
502 (0.202)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17803', 'product_id=127471')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
503 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=758')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
504 (0.207)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120862')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
505 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=127394')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
506 (0.189)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16356', 'category_id=17370', 'product_id=120855')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
507 (0.208)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120744')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
508 (0.208)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17395', 'product_id=153942')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
509 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153702')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
510 (0.179)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16357', 'product_id=109015')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
511 (0.208)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120752')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
512 (0.182)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=120756')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
513 (0.204)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153521')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
514 (0.205)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=28920')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
515 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108990')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
516 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108217')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
517 (0.118)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124849')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
518 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=8799')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
519 (0.128)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16374', 'product_id=117165')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
520 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117235')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
521 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=109016')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
522 (0.176)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109009')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
523 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108991')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
524 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10511', 'category_id=17828', 'product_id=158')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
525 (0.192)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17132', 'product_id=109011')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
526 (0.151)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16353', 'product_id=117188')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
527 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=147462')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
528 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=117236')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
529 (0.166)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=13946', 'product_id=120863')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
530 (0.192)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109013')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
531 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17807', 'product_id=120764')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
532 (0.188)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=4398', 'category_id=19717', 'product_id=101424')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
533 (0.172)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=20081', 'product_id=117194')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
534 (0.177)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120745')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
535 (0.187)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120763')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
536 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
537 (0.161)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=109018')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
538 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16372', 'product_id=120762')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
539 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17806', 'product_id=108980')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
540 (0.197)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120755')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
541 (0.180)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109000')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
542 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108981')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
543 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17800', 'product_id=127480')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
544 (0.184)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17810', 'product_id=127467')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
545 (0.182)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
546 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120753')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
547 (0.215)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=721', 'category_id=9961', 'product_id=61477')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
548 (0.196)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17800', 'product_id=127481')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
549 (0.179)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117190')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
550 (0.158)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108989')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
551 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108994')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
552 (0.169)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108986')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
553 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153400')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
554 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17461', 'product_id=153547')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
555 (0.178)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117249')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
556 (0.161)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=1067')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
557 (0.187)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=9150')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
558 (0.208)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=109014')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
559 (0.205)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117176')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
560 (0.267)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=12511')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
561 (0.213)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153522')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
562 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108985')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
563 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'product_id=74507')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
564 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108602')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
565 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108218')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
566 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16360', 'product_id=130624')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
567 (0.239)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=124853')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
568 (0.189)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16361', 'product_id=117174')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
569 (0.193)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124825')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
570 (0.202)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'product_id=7738')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
571 (0.198)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117175')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
572 (0.239)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=152599')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
573 (0.198)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=585')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
574 (0.196)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=120746')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
575 (0.217)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120754')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
576 (0.237)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153943')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
577 (0.190)
CREATE TABLE IF NOT EXISTS subscribe (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_id` varchar(225) NOT NULL,
`name` varchar(225) NOT NULL,
`option1` varchar(225) NOT NULL,
`option2` varchar(225) NOT NULL,
`option3` varchar(225) NOT NULL,
`option4` varchar(225) NOT NULL,
`option5` varchar(225) NOT NULL,
`option6` varchar(225) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Index_2` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/account/newslettersubscribe.php:34
578 (0.167)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=5')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
579 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=6')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
580 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=4')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
581 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=249')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
582 (0.169)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
583 (0.220)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649', 'category_id=10117', 'product_id=10117')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
584 (1.105)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:75
585 (0.295)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16844'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
586 (0.192)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=16844')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
587 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=649')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
588 (0.220)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '224'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
589 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=224')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
590 (0.182)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '1547'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
591 (0.123)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
592 (0.181)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '228'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
593 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=228')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
594 (0.191)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '639'
/var/www/alys2007/data/www/production.mypads.ru/catalog/con
