Ваш заказ принят. В ближайшее время с вами свяжется оператор.
1 (0.120)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anapa.mypads.ru/'
/var/www/alys2007/data/www/production.mypads.ru/index.php:171
2 (0.087)
SELECT *
FROM language
/var/www/alys2007/data/www/production.mypads.ru/index.php:284
3 (0.093)
SELECT *
FROM currency
/var/www/alys2007/data/www/production.mypads.ru/system/library/currency.php:13
4 (0.151)
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.138)
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.267)
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.080)
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.076)
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.052)
SELECT *
FROM geoip_rule
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:227
10 (0.041)
SELECT *
FROM geoip_redirect
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:234
11 (0.295)
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.069)
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.104)
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.165)
SELECT *
FROM url_alias
WHERE keyword IN ('aks-dlya-telefonov', 'asus-phone', 'chehol-asus-live-g500tg')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:35
15 (0.231)
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 = '4592'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
16 (0.181)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
17 (227.177)
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.425)
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.154)
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.101)
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.414)
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 = '1547' 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.229)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '1547'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
23 (0.127)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
24 (0.364)
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 = '4592' 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.196)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
26 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
27 (0.219)
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 (4592)
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.376)
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 = '4592'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:584
29 (0.394)
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 = '4592' 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.578)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '65160'
AND pd.language_id = '1'
AND 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.746)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30657'
AND pd.language_id = '1'
AND 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.549)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30660'
AND pd.language_id = '1'
AND 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.508)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25073'
AND pd.language_id = '1'
AND 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.582)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '65161'
AND pd.language_id = '1'
AND 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.514)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30656'
AND pd.language_id = '1'
AND 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.506)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30649'
AND pd.language_id = '1'
AND 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.586)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '137400'
AND pd.language_id = '1'
AND 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.536)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '33868'
AND pd.language_id = '1'
AND 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.511)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '176443'
AND pd.language_id = '1'
AND 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.545)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30648'
AND pd.language_id = '1'
AND 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.555)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30666'
AND pd.language_id = '1'
AND 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.558)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30662'
AND pd.language_id = '1'
AND 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.466)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '137399'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
44 (0.624)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '79926'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
45 (0.702)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30663'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
46 (0.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 = '65159'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
47 (0.490)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30655'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
48 (0.564)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30659'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
49 (0.507)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '204025'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
50 (0.562)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '218790'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
51 (0.600)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '191198'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
52 (0.546)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25071'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
53 (0.516)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '183825'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
54 (0.503)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30665'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
55 (0.458)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30658'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
56 (0.529)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30650'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
57 (0.461)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30661'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
58 (0.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 = '211407'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
59 (0.371)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25072'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
60 (0.417)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30654'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
61 (0.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 = '36688'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
62 (0.411)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30664'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
63 (0.508)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '94564'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
64 (0.487)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30647'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
65 (0.094)
SELECT `image`
FROM `category`
WHERE `category_id` = 4592
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
66 (0.086)
SELECT `image`
FROM `category`
WHERE `category_id` = 1547
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
67 (0.148)
SELECT *
FROM product_image
WHERE product_id = '65160'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
68 (0.392)
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 = '65160' 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
69 (0.152)
SELECT *
FROM product_video
WHERE product_id = '65160'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
70 (0.159)
SELECT category_id
FROM product_to_category
WHERE product_id = '65160'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
71 (0.244)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65160')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
72 (0.380)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65160&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
73 (0.138)
SELECT *
FROM product_image
WHERE product_id = '30657'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
74 (0.374)
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 = '30657' 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
75 (0.118)
SELECT *
FROM product_video
WHERE product_id = '30657'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
76 (0.163)
SELECT category_id
FROM product_to_category
WHERE product_id = '30657'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
77 (0.211)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30657')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
78 (0.242)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30657&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
79 (0.163)
SELECT *
FROM product_image
WHERE product_id = '30660'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
80 (1.012)
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 = '30660' 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
81 (0.095)
SELECT *
FROM product_video
WHERE product_id = '30660'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
82 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '30660'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
83 (0.198)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30660')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
84 (0.266)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30660&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
85 (0.138)
SELECT *
FROM product_image
WHERE product_id = '25073'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
86 (0.427)
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 = '25073' 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
87 (0.138)
SELECT *
FROM product_video
WHERE product_id = '25073'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
88 (0.138)
SELECT category_id
FROM product_to_category
WHERE product_id = '25073'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
89 (0.278)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25073')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
90 (0.229)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25073&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
91 (0.156)
SELECT *
FROM product_image
WHERE product_id = '65161'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
92 (1.930)
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 = '65161' 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
93 (0.162)
SELECT *
FROM product_video
WHERE product_id = '65161'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
94 (0.168)
SELECT category_id
FROM product_to_category
WHERE product_id = '65161'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
95 (0.270)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65161')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
96 (0.240)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65161&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
97 (0.193)
SELECT *
FROM product_image
WHERE product_id = '30656'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
98 (0.403)
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 = '30656' 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
99 (0.136)
SELECT *
FROM product_video
WHERE product_id = '30656'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
100 (0.144)
SELECT category_id
FROM product_to_category
WHERE product_id = '30656'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
101 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30656')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
102 (0.222)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30656&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
103 (0.337)
SELECT *
FROM product_image
WHERE product_id = '30649'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
104 (0.405)
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 = '30649' 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
105 (0.249)
SELECT *
FROM product_video
WHERE product_id = '30649'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
106 (0.149)
SELECT category_id
FROM product_to_category
WHERE product_id = '30649'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
107 (0.245)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30649')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
108 (0.237)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30649&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
109 (0.174)
SELECT *
FROM product_image
WHERE product_id = '137400'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
110 (0.472)
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 = '137400' 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
111 (0.217)
SELECT *
FROM product_video
WHERE product_id = '137400'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
112 (0.132)
SELECT category_id
FROM product_to_category
WHERE product_id = '137400'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
113 (0.259)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=137400')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
114 (0.232)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=137400&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
115 (0.167)
SELECT *
FROM product_image
WHERE product_id = '33868'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
116 (0.448)
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 = '33868' 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
117 (0.132)
SELECT *
FROM product_video
WHERE product_id = '33868'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
118 (0.235)
SELECT category_id
FROM product_to_category
WHERE product_id = '33868'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
119 (0.363)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=33868')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
120 (0.292)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=33868&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
121 (0.167)
SELECT *
FROM product_image
WHERE product_id = '176443'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
122 (0.392)
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 = '176443' 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
123 (0.101)
SELECT *
FROM product_video
WHERE product_id = '176443'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
124 (0.132)
SELECT category_id
FROM product_to_category
WHERE product_id = '176443'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
125 (0.364)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=176443')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
126 (0.236)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=176443&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
127 (0.152)
SELECT *
FROM product_image
WHERE product_id = '30648'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
128 (0.310)
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 = '30648' 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
129 (0.106)
SELECT *
FROM product_video
WHERE product_id = '30648'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
130 (0.137)
SELECT category_id
FROM product_to_category
WHERE product_id = '30648'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
131 (0.167)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30648')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
132 (0.224)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30648&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
133 (0.254)
SELECT *
FROM product_image
WHERE product_id = '30666'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
134 (0.375)
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 = '30666' 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
135 (0.112)
SELECT *
FROM product_video
WHERE product_id = '30666'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
136 (0.135)
SELECT category_id
FROM product_to_category
WHERE product_id = '30666'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
137 (0.219)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30666')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
138 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30666&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
139 (0.163)
SELECT *
FROM product_image
WHERE product_id = '30662'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
140 (0.370)
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 = '30662' 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
141 (0.134)
SELECT *
FROM product_video
WHERE product_id = '30662'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
142 (0.117)
SELECT category_id
FROM product_to_category
WHERE product_id = '30662'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
143 (0.170)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30662')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
144 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30662&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
145 (0.151)
SELECT *
FROM product_image
WHERE product_id = '137399'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
146 (0.402)
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 = '137399' 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
147 (0.135)
SELECT *
FROM product_video
WHERE product_id = '137399'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
148 (0.129)
SELECT category_id
FROM product_to_category
WHERE product_id = '137399'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
149 (0.367)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=137399')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
150 (0.190)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=137399&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
151 (0.163)
SELECT *
FROM product_image
WHERE product_id = '79926'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
152 (0.461)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '79926' 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
153 (0.121)
SELECT *
FROM product_video
WHERE product_id = '79926'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
154 (0.155)
SELECT category_id
FROM product_to_category
WHERE product_id = '79926'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
155 (0.275)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=79926')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
156 (0.326)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=79926&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
157 (0.189)
SELECT *
FROM product_image
WHERE product_id = '30663'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
158 (0.509)
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 = '30663' 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
159 (0.161)
SELECT *
FROM product_video
WHERE product_id = '30663'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
160 (0.156)
SELECT category_id
FROM product_to_category
WHERE product_id = '30663'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
161 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30663')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
162 (0.211)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30663&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
163 (0.144)
SELECT *
FROM product_image
WHERE product_id = '65159'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
164 (0.503)
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 = '65159' 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
165 (0.141)
SELECT *
FROM product_video
WHERE product_id = '65159'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
166 (0.171)
SELECT category_id
FROM product_to_category
WHERE product_id = '65159'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
167 (0.243)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65159')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
168 (0.244)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=65159&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
169 (0.290)
SELECT *
FROM product_image
WHERE product_id = '30655'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
170 (0.721)
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 = '30655' 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
171 (0.137)
SELECT *
FROM product_video
WHERE product_id = '30655'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
172 (0.170)
SELECT category_id
FROM product_to_category
WHERE product_id = '30655'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
173 (0.253)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30655')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
174 (0.216)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30655&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
175 (0.156)
SELECT *
FROM product_image
WHERE product_id = '30659'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
176 (0.471)
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 = '30659' 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
177 (0.162)
SELECT *
FROM product_video
WHERE product_id = '30659'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
178 (0.352)
SELECT category_id
FROM product_to_category
WHERE product_id = '30659'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
179 (0.255)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30659')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
180 (0.222)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30659&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
181 (0.159)
SELECT *
FROM product_image
WHERE product_id = '204025'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
182 (1.082)
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 = '204025' 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
183 (0.200)
SELECT *
FROM product_video
WHERE product_id = '204025'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
184 (0.265)
SELECT category_id
FROM product_to_category
WHERE product_id = '204025'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
185 (0.234)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=204025')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
186 (0.342)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=204025&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
187 (0.146)
SELECT *
FROM product_image
WHERE product_id = '218790'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
188 (0.422)
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 = '218790' 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
189 (0.126)
SELECT *
FROM product_video
WHERE product_id = '218790'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
190 (0.146)
SELECT category_id
FROM product_to_category
WHERE product_id = '218790'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
191 (0.212)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=218790')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
192 (0.207)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=218790&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
193 (0.147)
SELECT *
FROM product_image
WHERE product_id = '191198'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
194 (0.414)
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 = '191198' 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
195 (0.133)
SELECT *
FROM product_video
WHERE product_id = '191198'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
196 (0.158)
SELECT category_id
FROM product_to_category
WHERE product_id = '191198'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
197 (0.231)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=191198')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
198 (0.207)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=191198&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
199 (0.135)
SELECT *
FROM product_image
WHERE product_id = '25071'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
200 (0.509)
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 = '25071' 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
201 (0.415)
SELECT *
FROM product_video
WHERE product_id = '25071'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
202 (0.164)
SELECT category_id
FROM product_to_category
WHERE product_id = '25071'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
203 (0.210)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25071')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
204 (0.199)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25071&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
205 (0.144)
SELECT *
FROM product_image
WHERE product_id = '183825'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
206 (0.422)
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 = '183825' 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
207 (0.104)
SELECT *
FROM product_video
WHERE product_id = '183825'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
208 (0.128)
SELECT category_id
FROM product_to_category
WHERE product_id = '183825'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
209 (0.223)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=183825')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
210 (0.212)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=183825&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
211 (0.146)
SELECT *
FROM product_image
WHERE product_id = '30665'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
212 (0.405)
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 = '30665' 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
213 (0.125)
SELECT *
FROM product_video
WHERE product_id = '30665'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
214 (0.114)
SELECT category_id
FROM product_to_category
WHERE product_id = '30665'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
215 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30665')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
216 (0.168)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30665&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
217 (0.106)
SELECT *
FROM product_image
WHERE product_id = '30658'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
218 (0.307)
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 = '30658' 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
219 (0.133)
SELECT *
FROM product_video
WHERE product_id = '30658'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
220 (0.140)
SELECT category_id
FROM product_to_category
WHERE product_id = '30658'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
221 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30658')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
222 (0.204)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30658&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
223 (0.119)
SELECT *
FROM product_image
WHERE product_id = '30650'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
224 (0.387)
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 = '30650' 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
225 (0.116)
SELECT *
FROM product_video
WHERE product_id = '30650'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
226 (0.133)
SELECT category_id
FROM product_to_category
WHERE product_id = '30650'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
227 (0.169)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30650')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
228 (0.164)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30650&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
229 (0.117)
SELECT *
FROM product_image
WHERE product_id = '30661'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
230 (0.316)
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 = '30661' 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
231 (0.116)
SELECT *
FROM product_video
WHERE product_id = '30661'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
232 (0.126)
SELECT category_id
FROM product_to_category
WHERE product_id = '30661'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
233 (0.203)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30661')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
234 (0.182)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30661&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
235 (0.133)
SELECT *
FROM product_image
WHERE product_id = '211407'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
236 (0.346)
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 = '211407' 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
237 (0.096)
SELECT *
FROM product_video
WHERE product_id = '211407'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
238 (0.107)
SELECT category_id
FROM product_to_category
WHERE product_id = '211407'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
239 (0.184)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=211407')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
240 (0.174)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=211407&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
241 (0.145)
SELECT *
FROM product_image
WHERE product_id = '25072'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
242 (0.341)
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 = '25072' 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
243 (0.097)
SELECT *
FROM product_video
WHERE product_id = '25072'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
244 (0.147)
SELECT category_id
FROM product_to_category
WHERE product_id = '25072'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
245 (0.218)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25072')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
246 (0.235)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=25072&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
247 (0.142)
SELECT *
FROM product_image
WHERE product_id = '30654'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
248 (0.349)
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 = '30654' 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
249 (0.134)
SELECT *
FROM product_video
WHERE product_id = '30654'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
250 (0.140)
SELECT category_id
FROM product_to_category
WHERE product_id = '30654'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
251 (0.250)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30654')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
252 (0.233)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30654&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
253 (0.162)
SELECT *
FROM product_image
WHERE product_id = '36688'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
254 (0.344)
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 = '36688' 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
255 (0.101)
SELECT *
FROM product_video
WHERE product_id = '36688'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
256 (0.132)
SELECT category_id
FROM product_to_category
WHERE product_id = '36688'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
257 (0.193)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=36688')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
258 (0.173)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=36688&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
259 (0.123)
SELECT *
FROM product_image
WHERE product_id = '30664'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
260 (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 = '30664' 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
261 (0.106)
SELECT *
FROM product_video
WHERE product_id = '30664'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
262 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '30664'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
263 (0.171)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30664')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
264 (0.160)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30664&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
265 (0.132)
SELECT *
FROM product_image
WHERE product_id = '94564'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
266 (0.304)
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 = '94564' 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
267 (0.090)
SELECT *
FROM product_video
WHERE product_id = '94564'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
268 (0.122)
SELECT category_id
FROM product_to_category
WHERE product_id = '94564'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
269 (0.176)
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 = '5614'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
270 (0.167)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=5614', 'product_id=94564')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
271 (0.158)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=5614', 'product_id=94564&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
272 (0.119)
SELECT *
FROM product_image
WHERE product_id = '30647'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
273 (0.268)
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 = '30647' 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
274 (0.105)
SELECT *
FROM product_video
WHERE product_id = '30647'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
275 (0.116)
SELECT category_id
FROM product_to_category
WHERE product_id = '30647'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
276 (0.159)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30647')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
277 (0.165)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592', 'product_id=30647&dynamic_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
278 (0.150)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
279 (0.137)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
280 (0.154)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
281 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
282 (0.150)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
283 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
284 (0.144)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
285 (0.146)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
286 (0.128)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
287 (0.163)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
288 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
289 (0.152)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
290 (0.141)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=4592')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
291 (0.096)
SELECT *
FROM category_to_layout
WHERE category_id = '4592' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
292 (0.153)
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
293 (0.166)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
294 (0.091)
SELECT *
FROM category_to_layout
WHERE category_id = '4592' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
295 (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
296 (0.140)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
297 (0.080)
SELECT *
FROM category_to_layout
WHERE category_id = '4592' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
298 (0.111)
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
299 (0.133)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
300 (0.316)
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
301 (1.002)
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
302 (0.607)
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 = '1547'
ORDER BY cd.name
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/module/cfilter.php:105
303 (0.087)
SELECT *
FROM category_to_layout
WHERE category_id = '4592' AND store_id = '0'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/category.php:114
304 (0.124)
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
305 (0.142)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/setting/extension.php:4
306 (0.520)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
307 (0.144)
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
308 (0.174)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17132'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
309 (0.217)
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
310 (0.510)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
311 (0.163)
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
312 (0.168)
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
313 (0.204)
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
314 (0.458)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
315 (0.119)
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
316 (0.162)
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
317 (0.162)
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
318 (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 = '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
319 (0.110)
SELECT category_id
FROM product_to_category
WHERE product_id = '120754'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
320 (0.151)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17812'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
321 (0.160)
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
322 (0.363)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
323 (0.117)
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
324 (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 = '13754'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
325 (0.156)
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
326 (0.390)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
327 (0.105)
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
328 (0.153)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '10495'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
329 (0.156)
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
330 (0.431)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
331 (0.108)
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
332 (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 = '13839'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
333 (0.175)
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
334 (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 = '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
335 (0.110)
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
336 (0.144)
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
337 (0.156)
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
338 (0.428)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
339 (0.106)
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
340 (0.166)
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
341 (0.408)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
342 (0.112)
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
343 (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
344 (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 = '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
345 (0.122)
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
346 (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 = '16370'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
347 (0.150)
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
348 (0.456)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
349 (0.152)
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
350 (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 = '19717'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
351 (0.166)
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
352 (0.444)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
353 (0.127)
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
354 (0.210)
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
355 (0.454)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
356 (0.145)
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
357 (0.179)
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
358 (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 = '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
359 (0.103)
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
360 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=3759', 'category_id=16371', 'product_id=108993')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
361 (0.471)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
362 (0.110)
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
363 (0.161)
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
364 (0.353)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
365 (0.116)
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
366 (0.152)
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
367 (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 = '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
368 (0.104)
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
369 (0.154)
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
370 (0.150)
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
371 (0.356)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
372 (0.104)
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
373 (0.152)
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
374 (0.533)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
375 (0.120)
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
376 (0.162)
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
377 (0.453)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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.123)
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.178)
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
380 (0.204)
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
381 (0.471)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
382 (0.130)
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
383 (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 = '13805'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
384 (0.179)
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
385 (0.461)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
386 (0.112)
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
387 (0.197)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17802'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
388 (0.186)
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
389 (0.480)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
390 (0.128)
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
391 (0.231)
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
392 (0.506)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
393 (0.160)
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
394 (0.198)
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
395 (0.517)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
396 (0.120)
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
397 (0.207)
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
398 (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 = '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
399 (0.124)
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
400 (0.138)
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
401 (0.416)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
402 (0.128)
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
403 (0.159)
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
404 (0.124)
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
405 (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 = '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
406 (0.124)
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
407 (0.160)
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
408 (0.363)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
409 (0.104)
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
410 (0.171)
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
411 (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 = '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
412 (0.106)
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
413 (0.143)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '17810'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
414 (0.157)
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
415 (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 = '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
416 (0.102)
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
417 (0.162)
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
418 (0.353)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
419 (0.127)
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
420 (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 = '16372'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
421 (0.146)
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
422 (0.365)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
423 (0.129)
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
424 (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 = '17461'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
425 (0.192)
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
426 (0.468)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
427 (0.134)
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
428 (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 = '16373'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
429 (0.136)
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
430 (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 = '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
431 (0.114)
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
432 (0.168)
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
433 (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 = '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
434 (0.131)
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
435 (0.157)
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
436 (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 = '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
437 (0.114)
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
438 (0.168)
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
439 (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 = '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
440 (0.119)
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
441 (0.178)
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
442 (0.394)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
443 (0.110)
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
444 (0.173)
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
445 (0.380)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
446 (0.125)
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
447 (0.148)
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
448 (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 = '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
449 (0.112)
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
450 (0.174)
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
451 (0.460)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
452 (0.116)
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
453 (0.177)
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
454 (0.455)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
455 (0.116)
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
456 (0.170)
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
457 (0.464)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
458 (0.121)
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
459 (0.193)
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
460 (0.427)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
461 (0.126)
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
462 (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 = '17803'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
463 (0.174)
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
464 (0.454)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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.134)
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.172)
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.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 = '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
468 (0.115)
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
469 (0.158)
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
470 (0.481)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
471 (0.145)
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
472 (0.192)
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
473 (0.411)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
474 (0.115)
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
475 (0.193)
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
476 (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
477 (0.471)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '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
478 (0.109)
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
479 (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 = '17370'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
480 (0.165)
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
481 (0.420)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
F