Ваш заказ принят. В ближайшее время с вами свяжется оператор.
1 (0.161)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anapa.mypads.ru/'
/var/www/alys2007/data/www/production.mypads.ru/index.php:171
2 (0.138)
SELECT *
FROM language
/var/www/alys2007/data/www/production.mypads.ru/index.php:284
3 (0.121)
SELECT *
FROM currency
/var/www/alys2007/data/www/production.mypads.ru/system/library/currency.php:13
4 (0.221)
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.164)
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.365)
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.116)
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.080)
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.064)
SELECT *
FROM geoip_rule
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:227
10 (0.060)
SELECT *
FROM geoip_redirect
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:234
11 (0.364)
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.132)
SELECT zone_id
FROM zone_to_fias
WHERE fias_id = 14
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:162
13 (0.111)
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 = "2751"
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:141
14 (0.202)
SELECT *
FROM url_alias
WHERE keyword IN ('aks-dlya-telefonov', 'acer-phone', 'chehol-acer-liquid-z330-duo')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:35
15 (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 = '4266'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
16 (0.191)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
17 (250.797)
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.413)
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.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 = '73'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
20 (0.087)
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.293)
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 = '651' 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.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 = '651'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
23 (0.108)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
24 (0.344)
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 = '4266' 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.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
26 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
27 (0.196)
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 (4266)
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.295)
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 = '4266'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:584
29 (0.317)
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 = '4266' 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.362)
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 = '23270'
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.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 = '27488'
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.311)
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 = '23268'
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.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 = '27360'
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.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 = '27356'
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.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 = '27362'
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.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 = '27352'
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.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 = '27353'
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.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 = '27355'
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.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 = '27354'
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.294)
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 = '27490'
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.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 = '27480'
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.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 = '27484'
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.295)
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 = '23267'
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
44 (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 = '33178'
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
45 (0.311)
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 = '174985'
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
46 (0.311)
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 = '27495'
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
47 (0.299)
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 = '27494'
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
48 (0.300)
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 = '78933'
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
49 (0.300)
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 = '23269'
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
50 (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 = '202567'
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
51 (0.291)
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 = '217332'
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
52 (0.305)
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 = '189740'
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
53 (0.297)
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 = '22203'
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
54 (0.295)
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 = '182367'
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
55 (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 = '18797'
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
56 (0.296)
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 = '209949'
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
57 (0.292)
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 = '27499'
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
58 (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 = '18796'
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
59 (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 = '35992'
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
60 (0.313)
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 = '27498'
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
61 (0.070)
SELECT `image`
FROM `category`
WHERE `category_id` = 4266
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
62 (0.054)
SELECT `image`
FROM `category`
WHERE `category_id` = 651
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
63 (0.119)
SELECT *
FROM product_image
WHERE product_id = '23270'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
64 (0.251)
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 = '23270' 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.077)
SELECT *
FROM product_video
WHERE product_id = '23270'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
66 (0.090)
SELECT category_id
FROM product_to_category
WHERE product_id = '23270'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
67 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23270')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
68 (0.122)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23270&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
69 (0.102)
SELECT *
FROM product_image
WHERE product_id = '27488'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
70 (0.236)
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 = '27488' 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.075)
SELECT *
FROM product_video
WHERE product_id = '27488'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
72 (0.082)
SELECT category_id
FROM product_to_category
WHERE product_id = '27488'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
73 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27488')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
74 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27488&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
75 (0.094)
SELECT *
FROM product_image
WHERE product_id = '23268'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
76 (0.221)
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 = '23268' 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.068)
SELECT *
FROM product_video
WHERE product_id = '23268'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
78 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '23268'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
79 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23268')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
80 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23268&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
81 (0.074)
SELECT *
FROM product_image
WHERE product_id = '27360'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
82 (0.222)
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 = '27360' 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.071)
SELECT *
FROM product_video
WHERE product_id = '27360'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
84 (0.094)
SELECT category_id
FROM product_to_category
WHERE product_id = '27360'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
85 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27360')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
86 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27360&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
87 (0.071)
SELECT *
FROM product_image
WHERE product_id = '27356'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
88 (0.223)
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 = '27356' 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.073)
SELECT *
FROM product_video
WHERE product_id = '27356'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
90 (0.078)
SELECT category_id
FROM product_to_category
WHERE product_id = '27356'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
91 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27356')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
92 (0.110)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27356&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
93 (0.071)
SELECT *
FROM product_image
WHERE product_id = '27362'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
94 (0.225)
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 = '27362' 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.066)
SELECT *
FROM product_video
WHERE product_id = '27362'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
96 (0.076)
SELECT category_id
FROM product_to_category
WHERE product_id = '27362'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
97 (0.116)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27362')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
98 (0.111)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27362&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
99 (0.080)
SELECT *
FROM product_image
WHERE product_id = '27352'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
100 (0.495)
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 = '27352' 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.091)
SELECT *
FROM product_video
WHERE product_id = '27352'
/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 = '27352'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
103 (0.158)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27352')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
104 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27352&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
105 (0.104)
SELECT *
FROM product_image
WHERE product_id = '27353'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
106 (0.216)
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 = '27353' 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.069)
SELECT *
FROM product_video
WHERE product_id = '27353'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
108 (0.074)
SELECT category_id
FROM product_to_category
WHERE product_id = '27353'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
109 (0.116)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27353')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
110 (0.101)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27353&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
111 (0.066)
SELECT *
FROM product_image
WHERE product_id = '27355'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
112 (0.195)
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 = '27355' 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.064)
SELECT *
FROM product_video
WHERE product_id = '27355'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
114 (0.071)
SELECT category_id
FROM product_to_category
WHERE product_id = '27355'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
115 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27355')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
116 (0.111)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27355&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
117 (0.061)
SELECT *
FROM product_image
WHERE product_id = '27354'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
118 (0.195)
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 = '27354' 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 (0.059)
SELECT *
FROM product_video
WHERE product_id = '27354'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
120 (0.071)
SELECT category_id
FROM product_to_category
WHERE product_id = '27354'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
121 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27354')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
122 (0.122)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27354&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
123 (0.075)
SELECT *
FROM product_image
WHERE product_id = '27490'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
124 (0.247)
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 = '27490' 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
125 (0.067)
SELECT *
FROM product_video
WHERE product_id = '27490'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
126 (0.120)
SELECT category_id
FROM product_to_category
WHERE product_id = '27490'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
127 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27490')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
128 (0.106)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27490&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
129 (0.080)
SELECT *
FROM product_image
WHERE product_id = '27480'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
130 (0.593)
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 = '27480' 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
131 (0.115)
SELECT *
FROM product_video
WHERE product_id = '27480'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
132 (0.118)
SELECT category_id
FROM product_to_category
WHERE product_id = '27480'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
133 (0.197)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27480')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
134 (0.157)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27480&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
135 (0.096)
SELECT *
FROM product_image
WHERE product_id = '27484'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
136 (0.321)
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 = '27484' 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
137 (0.079)
SELECT *
FROM product_video
WHERE product_id = '27484'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
138 (0.092)
SELECT category_id
FROM product_to_category
WHERE product_id = '27484'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
139 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27484')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
140 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27484&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
141 (0.091)
SELECT *
FROM product_image
WHERE product_id = '23267'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
142 (0.573)
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 = '23267' 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
143 (0.107)
SELECT *
FROM product_video
WHERE product_id = '23267'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
144 (0.119)
SELECT category_id
FROM product_to_category
WHERE product_id = '23267'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
145 (0.217)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23267')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
146 (0.180)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23267&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
147 (0.131)
SELECT *
FROM product_image
WHERE product_id = '33178'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
148 (0.353)
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 = '33178' 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
149 (0.095)
SELECT *
FROM product_video
WHERE product_id = '33178'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
150 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '33178'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
151 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=33178')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
152 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=33178&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
153 (0.113)
SELECT *
FROM product_image
WHERE product_id = '174985'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
154 (0.321)
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 = '174985' 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
155 (0.085)
SELECT *
FROM product_video
WHERE product_id = '174985'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
156 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '174985'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
157 (0.179)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=174985')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
158 (0.158)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=174985&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
159 (0.104)
SELECT *
FROM product_image
WHERE product_id = '27495'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
160 (0.501)
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 = '27495' 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
161 (0.105)
SELECT *
FROM product_video
WHERE product_id = '27495'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
162 (0.126)
SELECT category_id
FROM product_to_category
WHERE product_id = '27495'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
163 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27495')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
164 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27495&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
165 (0.106)
SELECT *
FROM product_image
WHERE product_id = '27494'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
166 (0.398)
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 = '27494' 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
167 (0.140)
SELECT *
FROM product_video
WHERE product_id = '27494'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
168 (0.113)
SELECT category_id
FROM product_to_category
WHERE product_id = '27494'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
169 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27494')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
170 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27494&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
171 (0.122)
SELECT *
FROM product_image
WHERE product_id = '78933'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
172 (0.250)
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 = '78933' 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
173 (0.088)
SELECT *
FROM product_video
WHERE product_id = '78933'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
174 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '78933'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
175 (0.141)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=78933')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
176 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=78933&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
177 (0.166)
SELECT *
FROM product_image
WHERE product_id = '23269'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
178 (0.461)
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 = '23269' 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
179 (0.118)
SELECT *
FROM product_video
WHERE product_id = '23269'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
180 (0.126)
SELECT category_id
FROM product_to_category
WHERE product_id = '23269'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
181 (0.202)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23269')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
182 (0.194)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=23269&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
183 (0.149)
SELECT *
FROM product_image
WHERE product_id = '202567'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
184 (0.379)
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 = '202567' 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
185 (0.096)
SELECT *
FROM product_video
WHERE product_id = '202567'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
186 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '202567'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
187 (0.201)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=202567')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
188 (0.185)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=202567&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
189 (0.122)
SELECT *
FROM product_image
WHERE product_id = '217332'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
190 (0.361)
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 = '217332' 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
191 (0.107)
SELECT *
FROM product_video
WHERE product_id = '217332'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
192 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '217332'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
193 (0.191)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=217332')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
194 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=217332&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
195 (0.127)
SELECT *
FROM product_image
WHERE product_id = '189740'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
196 (0.327)
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 = '189740' 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
197 (0.091)
SELECT *
FROM product_video
WHERE product_id = '189740'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
198 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '189740'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
199 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=189740')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
200 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=189740&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
201 (0.126)
SELECT *
FROM product_image
WHERE product_id = '22203'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
202 (0.357)
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 = '22203' 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
203 (0.096)
SELECT *
FROM product_video
WHERE product_id = '22203'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
204 (0.128)
SELECT category_id
FROM product_to_category
WHERE product_id = '22203'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
205 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=22203')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
206 (0.186)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=22203&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
207 (0.146)
SELECT *
FROM product_image
WHERE product_id = '182367'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
208 (0.372)
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 = '182367' 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
209 (0.096)
SELECT *
FROM product_video
WHERE product_id = '182367'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
210 (0.129)
SELECT category_id
FROM product_to_category
WHERE product_id = '182367'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
211 (0.197)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=182367')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
212 (0.178)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=182367&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
213 (0.135)
SELECT *
FROM product_image
WHERE product_id = '18797'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
214 (0.381)
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 = '18797' 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
215 (0.103)
SELECT *
FROM product_video
WHERE product_id = '18797'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
216 (0.122)
SELECT category_id
FROM product_to_category
WHERE product_id = '18797'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
217 (0.200)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=18797')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
218 (0.177)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=18797&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
219 (0.133)
SELECT *
FROM product_image
WHERE product_id = '209949'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
220 (0.338)
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 = '209949' 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
221 (0.105)
SELECT *
FROM product_video
WHERE product_id = '209949'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
222 (0.131)
SELECT category_id
FROM product_to_category
WHERE product_id = '209949'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
223 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=209949')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
224 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=209949&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
225 (0.105)
SELECT *
FROM product_image
WHERE product_id = '27499'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
226 (0.329)
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 = '27499' 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
227 (0.104)
SELECT *
FROM product_video
WHERE product_id = '27499'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
228 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '27499'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
229 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27499')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
230 (0.169)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27499&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
231 (0.136)
SELECT *
FROM product_image
WHERE product_id = '18796'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
232 (0.359)
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 = '18796' 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
233 (0.090)
SELECT *
FROM product_video
WHERE product_id = '18796'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
234 (0.120)
SELECT category_id
FROM product_to_category
WHERE product_id = '18796'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
235 (0.245)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=18796')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
236 (0.198)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=18796&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
237 (0.174)
SELECT *
FROM product_image
WHERE product_id = '35992'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
238 (0.410)
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 = '35992' 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
239 (0.097)
SELECT *
FROM product_video
WHERE product_id = '35992'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
240 (0.136)
SELECT category_id
FROM product_to_category
WHERE product_id = '35992'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
241 (0.223)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=35992')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
242 (0.186)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=35992&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
243 (0.144)
SELECT *
FROM product_image
WHERE product_id = '27498'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
244 (0.386)
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 = '27498' 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
245 (0.082)
SELECT *
FROM product_video
WHERE product_id = '27498'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
246 (0.128)
SELECT category_id
FROM product_to_category
WHERE product_id = '27498'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
247 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27498')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
248 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266', 'product_id=27498&dynamic_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
249 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
250 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
251 (0.109)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
252 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
253 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
254 (0.099)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
255 (0.107)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
256 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
257 (0.094)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
258 (0.095)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
259 (0.095)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
260 (0.092)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
261 (0.103)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=651', 'category_id=4266')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
262 (0.092)
SELECT *
FROM category_to_layout
WHERE category_id = '4266' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
263 (0.156)
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
264 (0.144)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
265 (0.059)
SELECT *
FROM category_to_layout
WHERE category_id = '4266' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
266 (0.081)
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
267 (0.103)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
268 (0.058)
SELECT *
FROM category_to_layout
WHERE category_id = '4266' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
269 (0.083)
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
270 (0.106)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
271 (0.247)
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
272 (1.000)
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
273 (0.398)
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 = '651'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
274 (0.070)
SELECT *
FROM category_to_layout
WHERE category_id = '4266' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
275 (0.123)
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
276 (0.127)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
277 (0.472)
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
278 (0.097)
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
279 (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
280 (0.122)
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
281 (0.352)
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
282 (0.091)
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
283 (0.123)
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
284 (0.168)
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
285 (0.373)
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
286 (0.099)
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
287 (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 = '3082'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
288 (0.116)
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
289 (0.407)
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
290 (0.109)
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
291 (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 = '16371'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
292 (0.136)
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
293 (0.409)
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
294 (0.096)
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
295 (0.128)
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
296 (0.125)
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
297 (0.351)
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
298 (0.095)
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
299 (0.143)
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
300 (0.143)
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
301 (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 = '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
302 (0.094)
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
303 (0.127)
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
304 (0.179)
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
305 (0.477)
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
306 (0.107)
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
307 (0.129)
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
308 (0.133)
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
309 (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 = '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
310 (0.083)
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
311 (0.119)
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
312 (0.136)
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
313 (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 = '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
314 (0.085)
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
315 (0.117)
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
316 (0.132)
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
317 (0.300)
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
318 (0.088)
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
319 (0.114)
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
320 (0.337)
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
321 (0.088)
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
322 (0.121)
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
323 (0.117)
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
324 (0.337)
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
325 (0.090)
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
326 (0.116)
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
327 (0.115)
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
328 (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 = '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
329 (0.080)
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
330 (0.116)
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
331 (0.153)
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
332 (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 = '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
333 (0.096)
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
334 (0.136)
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
335 (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 = '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
336 (0.085)
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
337 (0.123)
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
338 (0.123)
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
339 (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 = '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
340 (0.096)
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
341 (0.121)
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
342 (0.124)
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
343 (0.342)
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
344 (0.094)
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
345 (0.120)
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
346 (0.127)
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
347 (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
348 (0.093)
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
349 (0.119)
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
350 (0.133)
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
351 (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 = '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
352 (0.083)
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
353 (0.119)
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
354 (0.305)
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
355 (0.080)
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
356 (0.122)
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
357 (0.128)
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
358 (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 = '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
359 (0.102)
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
360 (0.123)
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
361 (0.134)
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
362 (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 = '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
363 (0.089)
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
364 (0.125)
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
365 (0.303)
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
366 (0.084)
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
367 (0.112)
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
368 (0.102)
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
369 (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 = '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
370 (0.096)
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
371 (0.119)
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
372 (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 = '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
373 (0.090)
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
374 (0.127)
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
375 (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 = '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
376 (0.085)
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
377 (0.117)
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
378 (0.104)
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
379 (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 = '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
380 (0.098)
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
381 (0.128)
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
382 (0.305)
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
383 (0.084)
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
384 (0.114)
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
385 (0.311)
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
386 (0.086)
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
387 (0.115)
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
388 (0.327)
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
389 (0.082)
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
390 (0.106)
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
391 (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 = '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
392 (0.082)
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
393 (0.132)
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
394 (0.126)
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
395 (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 = '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
396 (0.083)
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
397 (0.105)
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
398 (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 = '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
399 (0.121)
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
400 (0.177)
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
401 (0.201)
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
402 (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 = '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
403 (0.111)
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
404 (0.188)
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
405 (0.436)
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
406 (0.111)
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
407 (0.204)
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
408 (0.418)
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
409 (0.108)
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
410 (0.158)
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
411 (0.412)
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
412 (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
413 (0.185)
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
414 (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 = '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
415 (0.102)
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
416 (0.183)
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
417 (0.477)
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
418 (0.101)
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
419 (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 = '10495'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
420 (0.176)
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
421 (0.462)
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
422 (0.107)
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
423 (0.129)
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
424 (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 = '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
425 (0.086)
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
426 (0.143)
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
427 (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 = '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
428 (0.087)
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
429 (0.111)
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
430 (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 = '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
431 (0.090)
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
432 (0.123)
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
433 (0.101)
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
434 (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 = '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
435 (0.092)
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
436 (0.138)
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
437 (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 = '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
438 (0.089)
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
439 (0.106)
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
440 (0.313)
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
441 (0.085)
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
442 (0.117)
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
443 (0.305)
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
444 (0.088)
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
445 (0.126)
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
446 (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
447 (0.085)
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
448 (0.110)
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
449 (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 = '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
450 (0.091)
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
451 (0.131)
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
452 (0.116)
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
453 (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 = '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
454 (0.100)
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
455 (0.122)
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
456 (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 = '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
457 (0.084)
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
458 (0.112)
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
459 (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 = '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
460 (0.089)
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
461 (0.120)
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
462 (0.135)
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
463 (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 = '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
464 (0.118)
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
465 (0.129)
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
466 (0.126)
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
467 (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</
