Ваш заказ принят. В ближайшее время с вами свяжется оператор.
1 (0.117)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anapa.mypads.ru/'
/var/www/alys2007/data/www/production.mypads.ru/index.php:171
2 (0.094)
SELECT *
FROM language
/var/www/alys2007/data/www/production.mypads.ru/index.php:284
3 (0.099)
SELECT *
FROM currency
/var/www/alys2007/data/www/production.mypads.ru/system/library/currency.php:13
4 (0.144)
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.143)
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.259)
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.124)
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.068)
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.075)
SELECT *
FROM geoip_rule
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:227
10 (0.061)
SELECT *
FROM geoip_redirect
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:234
11 (0.309)
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.083)
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.126)
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.182)
SELECT *
FROM url_alias
WHERE keyword IN ('aks-dlya-telefonov', 'fly-phones', 'fly-iq4511-tornado-one-octa')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:35
15 (0.204)
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 = '2073'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
16 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
17 (223.331)
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.459)
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.163)
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.108)
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.333)
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 = '639' AND cd.language_id = '1' AND c.status = '1'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:65
22 (0.171)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '639'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
23 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
24 (0.358)
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 = '2073' 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.122)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
26 (0.157)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
27 (0.208)
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 (2073)
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.286)
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 = '2073'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:584
29 (0.269)
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 = '2073' 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.358)
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 = '5324'
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.330)
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 = '4261'
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.329)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '32739'
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.360)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '173990'
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.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 = '78298'
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.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 = '201569'
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.366)
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 = '216334'
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.376)
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 = '188745'
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.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 = '21871'
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.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 = '181372'
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.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 = '208951'
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.367)
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 = '76130'
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.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 = '35541'
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.076)
SELECT `image`
FROM `category`
WHERE `category_id` = 2073
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
44 (0.066)
SELECT `image`
FROM `category`
WHERE `category_id` = 639
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
45 (0.126)
SELECT *
FROM product_image
WHERE product_id = '5324'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
46 (0.367)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '5324' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
47 (0.099)
SELECT *
FROM product_video
WHERE product_id = '5324'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
48 (0.130)
SELECT category_id
FROM product_to_category
WHERE product_id = '5324'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
49 (0.211)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=5324')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
50 (0.193)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=5324&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
51 (0.137)
SELECT *
FROM product_image
WHERE product_id = '4261'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
52 (0.300)
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 = '4261' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
53 (0.096)
SELECT *
FROM product_video
WHERE product_id = '4261'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
54 (0.119)
SELECT category_id
FROM product_to_category
WHERE product_id = '4261'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
55 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=4261')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
56 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=4261&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
57 (0.116)
SELECT *
FROM product_image
WHERE product_id = '32739'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
58 (0.271)
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 = '32739' AND (p2s.date_start IS NULL OR p2s.date_start <= NOW()) AND (p2s.date_end IS NULL OR p2s.date_end >= NOW())
ORDER BY ps.sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:666
59 (0.082)
SELECT *
FROM product_video
WHERE product_id = '32739'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
60 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '32739'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
61 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=32739')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
62 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=32739&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
63 (0.096)
SELECT *
FROM product_image
WHERE product_id = '173990'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
64 (0.284)
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 = '173990' 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.071)
SELECT *
FROM product_video
WHERE product_id = '173990'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
66 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '173990'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
67 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=173990')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
68 (0.168)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=173990&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
69 (0.118)
SELECT *
FROM product_image
WHERE product_id = '78298'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
70 (0.274)
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 = '78298' 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.082)
SELECT *
FROM product_video
WHERE product_id = '78298'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
72 (0.091)
SELECT category_id
FROM product_to_category
WHERE product_id = '78298'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
73 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=78298')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
74 (0.123)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=78298&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
75 (0.109)
SELECT *
FROM product_image
WHERE product_id = '201569'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
76 (0.264)
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 = '201569' 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.065)
SELECT *
FROM product_video
WHERE product_id = '201569'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
78 (0.092)
SELECT category_id
FROM product_to_category
WHERE product_id = '201569'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
79 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=201569')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
80 (0.164)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=201569&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
81 (0.092)
SELECT *
FROM product_image
WHERE product_id = '216334'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
82 (0.296)
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 = '216334' 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.064)
SELECT *
FROM product_video
WHERE product_id = '216334'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
84 (0.103)
SELECT category_id
FROM product_to_category
WHERE product_id = '216334'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
85 (0.186)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=216334')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
86 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=216334&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
87 (0.141)
SELECT *
FROM product_image
WHERE product_id = '188745'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
88 (0.305)
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 = '188745' 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.092)
SELECT *
FROM product_video
WHERE product_id = '188745'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
90 (0.096)
SELECT category_id
FROM product_to_category
WHERE product_id = '188745'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
91 (0.183)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=188745')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
92 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=188745&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
93 (0.122)
SELECT *
FROM product_image
WHERE product_id = '21871'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
94 (0.275)
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 = '21871' 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.081)
SELECT *
FROM product_video
WHERE product_id = '21871'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
96 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '21871'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
97 (0.169)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=21871')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
98 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=21871&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
99 (0.127)
SELECT *
FROM product_image
WHERE product_id = '181372'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
100 (0.313)
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 = '181372' 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.079)
SELECT *
FROM product_video
WHERE product_id = '181372'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
102 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '181372'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
103 (0.161)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=181372')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
104 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=181372&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
105 (0.125)
SELECT *
FROM product_image
WHERE product_id = '208951'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
106 (0.281)
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 = '208951' 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.066)
SELECT *
FROM product_video
WHERE product_id = '208951'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
108 (0.096)
SELECT category_id
FROM product_to_category
WHERE product_id = '208951'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
109 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=208951')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
110 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=208951&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
111 (0.091)
SELECT *
FROM product_image
WHERE product_id = '76130'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
112 (0.271)
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 = '76130' 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.079)
SELECT *
FROM product_video
WHERE product_id = '76130'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
114 (0.118)
SELECT category_id
FROM product_to_category
WHERE product_id = '76130'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
115 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=76130')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
116 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=76130&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
117 (0.122)
SELECT *
FROM product_image
WHERE product_id = '35541'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
118 (0.302)
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 = '35541' 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.095)
SELECT *
FROM product_video
WHERE product_id = '35541'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
120 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '35541'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
121 (0.164)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=35541')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
122 (0.162)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=35541&dynamic_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
123 (0.164)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
124 (0.132)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
125 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
126 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
127 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
128 (0.118)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
129 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
130 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
131 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
132 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
133 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
134 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
135 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
136 (0.081)
SELECT *
FROM category_to_layout
WHERE category_id = '2073' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
137 (0.112)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
138 (0.165)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
139 (0.071)
SELECT *
FROM category_to_layout
WHERE category_id = '2073' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
140 (0.101)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
141 (0.141)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
142 (0.082)
SELECT *
FROM category_to_layout
WHERE category_id = '2073' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
143 (0.104)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
144 (0.130)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
145 (0.207)
SELECT c.category_id, cd.name
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1' AND c.parent_id = '0'
ORDER BY c.sort_order
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:98
146 (1.064)
SELECT c.category_id, cd.name
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1' AND c.parent_id = '73'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
147 (0.899)
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 = '639'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
148 (0.090)
SELECT *
FROM category_to_layout
WHERE category_id = '2073' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
149 (0.106)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/design/layout.php:4
150 (0.138)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
151 (0.439)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '124849'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
152 (0.117)
SELECT category_id
FROM product_to_category
WHERE product_id = '124849'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
153 (0.157)
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
154 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124849')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
155 (0.419)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
156 (0.136)
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
157 (0.164)
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
158 (0.133)
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
159 (0.488)
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
160 (0.102)
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
161 (0.170)
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
162 (0.144)
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
163 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117194'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
164 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '117194'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
165 (0.172)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '20081'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
166 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=20081', 'product_id=117194')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
167 (0.426)
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
168 (0.113)
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
169 (0.171)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16366'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
170 (0.143)
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
171 (0.387)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153623'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
172 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '153623'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
173 (0.173)
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
174 (0.175)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153623')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
175 (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 = '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
176 (0.117)
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
177 (0.154)
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
178 (0.435)
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
179 (0.119)
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
180 (0.150)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17800'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
181 (0.198)
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
182 (0.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
183 (0.118)
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
184 (0.142)
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
185 (0.395)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108991'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
186 (0.148)
SELECT category_id
FROM product_to_category
WHERE product_id = '108991'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
187 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16371'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
188 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108991')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
189 (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 = '758'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
190 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '758'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
191 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=758')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
192 (0.414)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
193 (0.114)
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
194 (0.163)
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
195 (0.204)
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
196 (0.445)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120855'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
197 (0.124)
SELECT category_id
FROM product_to_category
WHERE product_id = '120855'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
198 (0.186)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17370'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
199 (0.186)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16356', 'category_id=17370', 'product_id=120855')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
200 (0.448)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
201 (0.118)
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
202 (0.181)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17812'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
203 (0.201)
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
204 (0.423)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153714'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
205 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '153714'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
206 (0.173)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '92'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
207 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=18', 'category_id=76', 'category_id=92', 'product_id=153714')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
208 (0.400)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
209 (0.121)
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
210 (0.166)
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
211 (0.171)
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
212 (0.405)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117176'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
213 (0.110)
SELECT category_id
FROM product_to_category
WHERE product_id = '117176'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
214 (0.148)
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
215 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117176')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
216 (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 = '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
217 (0.103)
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
218 (0.192)
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
219 (0.441)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
220 (0.113)
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
221 (0.150)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16373'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
222 (0.171)
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
223 (0.446)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
224 (0.100)
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
225 (0.160)
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
226 (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 = '153943'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
227 (0.115)
SELECT category_id
FROM product_to_category
WHERE product_id = '153943'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
228 (0.176)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153943')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
229 (0.419)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108993'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
230 (0.123)
SELECT category_id
FROM product_to_category
WHERE product_id = '108993'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
231 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108993')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
232 (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 = '130354'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
233 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '130354'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
234 (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 = '13805'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
235 (0.180)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13805', 'product_id=130354')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
236 (0.398)
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
237 (0.114)
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
238 (0.145)
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
239 (0.400)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
240 (0.117)
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
241 (0.193)
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
242 (0.433)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109000'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
243 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '109000'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
244 (0.186)
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
245 (0.168)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109000')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
246 (0.389)
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
247 (0.102)
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
248 (0.159)
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
249 (0.391)
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
250 (0.107)
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
251 (0.120)
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
252 (0.433)
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
253 (0.103)
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
254 (0.117)
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
255 (0.414)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120756'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
256 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '120756'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
257 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=120756')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
258 (0.405)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108217'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
259 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '108217'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
260 (0.179)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108217')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
261 (0.482)
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
262 (0.097)
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
263 (0.160)
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
264 (0.182)
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
265 (0.451)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
266 (0.122)
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
267 (0.174)
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
268 (0.406)
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
269 (0.125)
SELECT category_id
FROM product_to_category
WHERE product_id = '100376'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
270 (0.158)
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
271 (0.144)
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
272 (0.358)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109015'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
273 (0.112)
SELECT category_id
FROM product_to_category
WHERE product_id = '109015'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
274 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16357'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
275 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16357', 'product_id=109015')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
276 (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 = '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
277 (0.123)
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
278 (0.152)
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
279 (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 = '101424'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
280 (0.103)
SELECT category_id
FROM product_to_category
WHERE product_id = '101424'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
281 (0.147)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '19717'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
282 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=4398', 'category_id=19717', 'product_id=101424')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
283 (0.357)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120888'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
284 (0.134)
SELECT category_id
FROM product_to_category
WHERE product_id = '120888'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
285 (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 = '13839'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
286 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13801', 'category_id=13839', 'product_id=120888')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
287 (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
288 (0.105)
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
289 (0.139)
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
290 (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 = '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
291 (0.106)
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
292 (0.141)
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
293 (0.332)
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.138)
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.142)
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.137)
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.329)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
298 (0.104)
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
299 (0.165)
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
300 (0.338)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
301 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '12511'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
302 (0.136)
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
303 (0.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
304 (0.103)
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
305 (0.149)
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
306 (0.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '152587'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
307 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '152587'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
308 (0.145)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17802'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
309 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=152587')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
310 (0.348)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120763'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
311 (0.105)
SELECT category_id
FROM product_to_category
WHERE product_id = '120763'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
312 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120763')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
313 (0.357)
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
314 (0.107)
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
315 (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 = '3761'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
316 (0.133)
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
317 (0.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
318 (0.106)
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
319 (0.139)
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
320 (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 = '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
321 (0.113)
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
322 (0.134)
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
323 (0.137)
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
324 (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 = '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
325 (0.106)
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
326 (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 = '16374'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
327 (0.141)
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
328 (0.359)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108986'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
329 (0.109)
SELECT category_id
FROM product_to_category
WHERE product_id = '108986'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
330 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108986')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
331 (0.395)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108994'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
332 (0.111)
SELECT category_id
FROM product_to_category
WHERE product_id = '108994'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
333 (0.142)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108994')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
334 (0.355)
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
335 (0.104)
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
336 (0.125)
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
337 (0.348)
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
338 (0.101)
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
339 (0.138)
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
340 (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 = '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
341 (0.098)
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
342 (0.170)
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
343 (0.174)
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
344 (0.354)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120746'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
345 (0.097)
SELECT category_id
FROM product_to_category
WHERE product_id = '120746'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
346 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=120746')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
347 (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 = '229'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
348 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '229'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
349 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
350 (0.339)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '130624'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
351 (0.103)
SELECT category_id
FROM product_to_category
WHERE product_id = '130624'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
352 (0.142)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16360'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
353 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16360', 'product_id=130624')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
354 (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 = '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
355 (0.098)
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
356 (0.155)
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
357 (0.159)
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
358 (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 = '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
359 (0.096)
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
360 (0.150)
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
361 (0.372)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
362 (0.102)
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
363 (0.127)
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
364 (0.346)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
365 (0.106)
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
366 (0.138)
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
367 (0.146)
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
368 (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 = '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
369 (0.103)
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
370 (0.126)
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
371 (0.357)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120754'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
372 (0.105)
SELECT category_id
FROM product_to_category
WHERE product_id = '120754'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
373 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120754')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
374 (0.364)
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
375 (0.114)
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
376 (0.156)
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
377 (0.372)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '28920'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
378 (0.108)
SELECT category_id
FROM product_to_category
WHERE product_id = '28920'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
379 (0.164)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=28920')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
380 (0.368)
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
381 (0.118)
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
382 (0.153)
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
383 (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 = '117235'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
384 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '117235'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
385 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117235')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
386 (0.340)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '117174'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
387 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '117174'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
388 (0.146)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16361'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
389 (0.149)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16361', 'product_id=117174')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
390 (0.333)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109018'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
391 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '109018'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
392 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=109018')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
393 (0.334)
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
394 (0.105)
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
395 (0.147)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=147462')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
396 (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 = '108989'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
397 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '108989'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
398 (0.131)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108989')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
399 (0.355)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153702'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
400 (0.103)
SELECT category_id
FROM product_to_category
WHERE product_id = '153702'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
401 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153702')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
402 (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 = '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.123)
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.145)
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.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 = '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
406 (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
407 (0.148)
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
408 (0.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120752'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
409 (0.098)
SELECT category_id
FROM product_to_category
WHERE product_id = '120752'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
410 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120752')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
411 (0.339)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109014'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
412 (0.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '109014'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
413 (0.120)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=109014')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
414 (0.376)
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
415 (0.112)
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
416 (0.147)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '9961'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
417 (0.161)
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
418 (0.329)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
419 (0.099)
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
420 (0.135)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16365'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
421 (0.134)
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
422 (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 = '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
423 (0.104)
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
424 (0.142)
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
425 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '585'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
426 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '585'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
427 (0.124)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=585')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
428 (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 = '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
429 (0.100)
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
430 (0.141)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17803'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
431 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17803', 'product_id=127471')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
432 (0.354)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8799'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
433 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '8799'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
434 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=8799')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
435 (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 = '117188'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
436 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '117188'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
437 (0.142)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16353'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
438 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16353', 'product_id=117188')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
439 (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 = '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
440 (0.110)
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
441 (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 = '17807'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
442 (0.149)
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
443 (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 = '127394'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
444 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '127394'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
445 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=127394')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
446 (0.321)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '152599'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
447 (0.119)
SELECT category_id
FROM product_to_category
WHERE product_id = '152599'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
448 (0.151)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=152599')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
449 (0.335)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
450 (0.105)
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
451 (0.140)
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
452 (0.348)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109009'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
453 (0.100)
SELECT category_id
FROM product_to_category
WHERE product_id = '109009'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
454 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109009')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
455 (0.346)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '124825'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
456 (0.101)
SELECT category_id
FROM product_to_category
WHERE product_id = '124825'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
457 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124825')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
458 (0.345)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
459 (0.108)
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
460 (0.146)
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
461 (0.378)
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
462 (0.112)
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
463 (0.148)
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
464 (0.355)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108981'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
465 (0.106)
SELECT category_id
FROM product_to_category
WHERE product_id = '108981'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
466 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108981')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
467 (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 = '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
468 (0.102)
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
469 (0.145)
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
470 (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 = '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
471 (0.115)
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
472 (0.142)
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
473 (0.166)
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
474 (0.338)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108984'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
475 (0.104)
SELECT category_id
FROM product_to_category
WHERE product_id = '108984'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
476 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108984')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
477 (0.369)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109016'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
478 (0.130)
SELECT category_id
FROM product_to_category
WHERE product_id = '109016'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
479 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=109016')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
480 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=152599')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
481 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108981')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
482 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13801', 'category_id=13839', 'product_id=120888')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
483 (0.134)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108984')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
484 (0.138)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16356', 'category_id=17370', 'product_id=120855')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
485 (0.126)
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
486 (0.156)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=215', 'category_id=6107', 'product_id=65567')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
487 (0.123)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=758')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
488 (0.133)
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
489 (0.146)
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
490 (0.121)
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
491 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108993')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
492 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=586')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
493 (0.153)
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
494 (0.159)
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
495 (0.143)
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
496 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4399', 'category_id=13805', 'product_id=130354')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
497 (0.141)
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
498 (0.143)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=4397', 'category_id=4398', 'category_id=19717', 'product_id=101424')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
499 (0.156)
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
500 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=109009')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
501 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120752')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
502 (0.153)
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
503 (0.123)
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
504 (0.129)
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
505 (0.135)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153702')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
506 (0.148)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153943')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
507 (0.138)
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
508 (0.149)
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
509 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=109000')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
510 (0.128)
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
511 (0.120)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=109014')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
512 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108991')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
513 (0.141)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=117235')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
514 (0.137)
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
515 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108989')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
516 (0.153)
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
517 (0.128)
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
518 (0.143)
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
519 (0.127)
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
520 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124825')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
521 (0.139)
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
522 (0.117)
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
523 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=152587')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
524 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=18', 'category_id=76', 'category_id=92', 'product_id=153714')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
525 (0.121)
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
526 (0.130)
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
527 (0.140)
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
528 (0.123)
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
529 (0.132)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120763')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
530 (0.135)
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
531 (0.148)
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
532 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108986')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
533 (0.119)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=10495', 'product_id=120746')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
534 (0.135)
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
535 (0.141)
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
536 (0.132)
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
537 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108994')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
538 (0.123)
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
539 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16373', 'product_id=109016')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
540 (0.120)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16353', 'product_id=117188')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
541 (0.131)
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
542 (0.141)
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
543 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17802', 'product_id=229')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
544 (0.141)
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
545 (0.131)
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
546 (0.139)
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
547 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=585')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
548 (0.136)
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
549 (0.124)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=8799')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
550 (0.123)
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
551 (0.113)
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
552 (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
553 (0.142)
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
554 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=20081', 'product_id=117194')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
555 (0.105)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'product_id=124849')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
556 (0.140)
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
557 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=120756')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
558 (0.144)
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
559 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16360', 'product_id=130624')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
560 (0.152)
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
561 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=108217')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
562 (0.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16361', 'product_id=117174')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
563 (0.124)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16357', 'product_id=109015')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
564 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3761', 'product_id=109018')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
565 (0.117)
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
566 (0.130)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=3082', 'product_id=127394')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
567 (0.123)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=2317', 'category_id=13754', 'product_id=117176')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
568 (0.128)
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
569 (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
570 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=17393', 'category_id=17394', 'product_id=153623')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
571 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16370', 'category_id=17812', 'product_id=120754')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
572 (0.122)
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
573 (0.153)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16352', 'category_id=17131', 'product_id=28920')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
574 (0.138)
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
575 (0.140)
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
576 (0.131)
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
577 (0.109)
CREATE TABLE IF NOT EXISTS subscribe (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_id` varchar(225) NOT NULL,
`name` varchar(225) NOT NULL,
`option1` varchar(225) NOT NULL,
`option2` varchar(225) NOT NULL,
`option3` varchar(225) NOT NULL,
`option4` varchar(225) NOT NULL,
`option5` varchar(225) NOT NULL,
`option6` varchar(225) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Index_2` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/account/newslettersubscribe.php:34
578 (0.112)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=5')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
579 (0.094)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=6')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
580 (0.087)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=4')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
581 (0.092)
SELECT *
FROM url_alias
WHERE `query` IN ('information_id=249')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
582 (0.129)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
583 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=639', 'category_id=2073', 'product_id=2073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
584 (0.884)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:75
585 (0.172)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '16844'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
