Ваш заказ принят. В ближайшее время с вами свяжется оператор.
1 (0.105)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anapa.mypads.ru/'
/var/www/alys2007/data/www/production.mypads.ru/index.php:171
2 (0.102)
SELECT *
FROM language
/var/www/alys2007/data/www/production.mypads.ru/index.php:284
3 (0.096)
SELECT *
FROM currency
/var/www/alys2007/data/www/production.mypads.ru/system/library/currency.php:13
4 (0.150)
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.131)
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.234)
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.087)
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.069)
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.060)
SELECT *
FROM geoip_rule
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:227
10 (0.057)
SELECT *
FROM geoip_redirect
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/module/geoip.php:234
11 (0.278)
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.084)
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.101)
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.158)
SELECT *
FROM url_alias
WHERE keyword IN ('aks-dlya-telefonov', 'asus-phone', 'chehol-asus-zenfone-2-deluxe-special-edition')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:35
15 (0.175)
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 = '3937'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
16 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
17 (213.494)
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.461)
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.150)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '73'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
20 (0.099)
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.303)
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.134)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '1547'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
23 (0.102)
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.315)
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 = '3937' 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.121)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
26 (0.098)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
27 (0.186)
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 (3937)
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.355)
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 = '3937'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:584
29 (0.480)
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 = '3937' 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.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11321'
AND pd.language_id = '1'
AND 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.316)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8727'
AND pd.language_id = '1'
AND 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.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11318'
AND pd.language_id = '1'
AND 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.313)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11323'
AND pd.language_id = '1'
AND 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.293)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '55102'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
35 (0.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11317'
AND pd.language_id = '1'
AND 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.323)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25209'
AND pd.language_id = '1'
AND 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.323)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25211'
AND pd.language_id = '1'
AND 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.287)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25210'
AND pd.language_id = '1'
AND 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.331)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39242'
AND pd.language_id = '1'
AND 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.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '17691'
AND pd.language_id = '1'
AND 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.318)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7742'
AND pd.language_id = '1'
AND 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.319)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120975'
AND pd.language_id = '1'
AND 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.309)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6460'
AND pd.language_id = '1'
AND 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.334)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '17692'
AND pd.language_id = '1'
AND 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.340)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11329'
AND pd.language_id = '1'
AND 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.304)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '49042'
AND pd.language_id = '1'
AND 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.290)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7741'
AND pd.language_id = '1'
AND 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.315)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '33862'
AND pd.language_id = '1'
AND 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.330)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '49513'
AND pd.language_id = '1'
AND 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.341)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '176437'
AND pd.language_id = '1'
AND 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.316)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11316'
AND pd.language_id = '1'
AND 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.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39241'
AND pd.language_id = '1'
AND 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.295)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7786'
AND pd.language_id = '1'
AND 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.349)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7491'
AND pd.language_id = '1'
AND 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.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13196'
AND pd.language_id = '1'
AND 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.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 = '39240'
AND pd.language_id = '1'
AND 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.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 = '19253'
AND pd.language_id = '1'
AND 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.340)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11330'
AND pd.language_id = '1'
AND 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.333)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6459'
AND pd.language_id = '1'
AND 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.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11325'
AND pd.language_id = '1'
AND 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.310)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '79920'
AND pd.language_id = '1'
AND 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.318)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11332'
AND pd.language_id = '1'
AND 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.333)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39180'
AND pd.language_id = '1'
AND 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.327)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11335'
AND pd.language_id = '1'
AND 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.322)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '19258'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
66 (0.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '19254'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
67 (0.293)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7743'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
68 (0.320)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11328'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
69 (0.288)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39239'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
70 (0.282)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11326'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
71 (0.322)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8714'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
72 (0.316)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11334'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
73 (0.293)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11333'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
74 (0.284)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '204019'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
75 (0.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '218784'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
76 (0.342)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '191192'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
77 (0.332)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '22774'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
78 (0.325)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '183819'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
79 (0.337)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39181'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
80 (0.314)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11331'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
81 (0.287)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11319'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
82 (0.322)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '16614'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
83 (0.317)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11097'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
84 (0.289)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '211401'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
85 (0.351)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '25280'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
86 (0.305)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11322'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
87 (0.300)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11320'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
88 (0.307)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '56691'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
89 (0.303)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '36682'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
90 (0.314)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_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
91 (0.310)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '17690'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
92 (0.302)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11324'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
93 (0.296)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer,
(SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '16615'
AND pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:45
94 (0.069)
SELECT `image`
FROM `category`
WHERE `category_id` = 3937
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
95 (0.056)
SELECT `image`
FROM `category`
WHERE `category_id` = 1547
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/product/category.php:890
96 (0.148)
SELECT *
FROM product_image
WHERE product_id = '11321'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
97 (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 = '11321' 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
98 (0.088)
SELECT *
FROM product_video
WHERE product_id = '11321'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
99 (0.094)
SELECT category_id
FROM product_to_category
WHERE product_id = '11321'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
100 (0.150)
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '2614'
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:281
101 (0.145)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11321')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
102 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11321&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
103 (0.078)
SELECT *
FROM product_image
WHERE product_id = '8727'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
104 (0.314)
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 = '8727' 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.077)
SELECT *
FROM product_video
WHERE product_id = '8727'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
106 (0.089)
SELECT category_id
FROM product_to_category
WHERE product_id = '8727'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
107 (0.136)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=8727')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
108 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=8727&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
109 (0.105)
SELECT *
FROM product_image
WHERE product_id = '11318'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
110 (0.314)
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 = '11318' 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.089)
SELECT *
FROM product_video
WHERE product_id = '11318'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
112 (0.091)
SELECT category_id
FROM product_to_category
WHERE product_id = '11318'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
113 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11318')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
114 (0.109)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11318&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
115 (0.087)
SELECT *
FROM product_image
WHERE product_id = '11323'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
116 (0.284)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_stick p2s ON (ps.stick_id = p2s.stick_id)
WHERE p2s.product_id = '11323' 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.089)
SELECT *
FROM product_video
WHERE product_id = '11323'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
118 (0.095)
SELECT category_id
FROM product_to_category
WHERE product_id = '11323'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
119 (0.124)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11323')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
120 (0.116)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11323&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
121 (0.089)
SELECT *
FROM product_image
WHERE product_id = '55102'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
122 (0.279)
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 = '55102' 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.077)
SELECT *
FROM product_video
WHERE product_id = '55102'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
124 (0.089)
SELECT category_id
FROM product_to_category
WHERE product_id = '55102'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
125 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=55102')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
126 (0.110)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=55102&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
127 (0.092)
SELECT *
FROM product_image
WHERE product_id = '11317'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
128 (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 = '11317' 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.078)
SELECT *
FROM product_video
WHERE product_id = '11317'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
130 (0.091)
SELECT category_id
FROM product_to_category
WHERE product_id = '11317'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
131 (0.133)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11317')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
132 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=11317&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
133 (0.096)
SELECT *
FROM product_image
WHERE product_id = '25209'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
134 (0.269)
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 = '25209' 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.078)
SELECT *
FROM product_video
WHERE product_id = '25209'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
136 (0.091)
SELECT category_id
FROM product_to_category
WHERE product_id = '25209'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
137 (0.129)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25209')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
138 (0.111)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25209&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
139 (0.078)
SELECT *
FROM product_image
WHERE product_id = '25211'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
140 (0.254)
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 = '25211' 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.073)
SELECT *
FROM product_video
WHERE product_id = '25211'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
142 (0.085)
SELECT category_id
FROM product_to_category
WHERE product_id = '25211'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
143 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25211')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
144 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25211&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
145 (0.087)
SELECT *
FROM product_image
WHERE product_id = '25210'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
146 (0.224)
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 = '25210' 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.070)
SELECT *
FROM product_video
WHERE product_id = '25210'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
148 (0.085)
SELECT category_id
FROM product_to_category
WHERE product_id = '25210'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
149 (0.125)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25210')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
150 (0.113)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=3937', 'product_id=25210&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
151 (0.087)
SELECT *
FROM product_image
WHERE product_id = '39242'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
152 (0.261)
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 = '39242' 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.076)
SELECT *
FROM product_video
WHERE product_id = '39242'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
154 (0.102)
SELECT category_id
FROM product_to_category
WHERE product_id = '39242'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
155 (0.140)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=39242')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
156 (0.114)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=39242&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
157 (0.093)
SELECT *
FROM product_image
WHERE product_id = '17691'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
158 (0.239)
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 = '17691' 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.089)
SELECT *
FROM product_video
WHERE product_id = '17691'
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:483
160 (0.085)
SELECT category_id
FROM product_to_category
WHERE product_id = '17691'
ORDER BY main_category DESC LIMIT 1
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:247
161 (0.126)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=17691')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
162 (0.117)
SELECT *
FROM url_alias
WHERE `query` IN ('category_id=73', 'category_id=1547', 'category_id=2614', 'product_id=17691&dynamic_id=3937')
/var/www/alys2007/data/www/production.mypads.ru/catalog/controller/common/seo_pro.php:199
163 (0.093)
SELECT *
FROM product_image
WHERE product_id = '7742'
ORDER BY sort_order ASC
/var/www/alys2007/data/www/production.mypads.ru/catalog/model/catalog/product.php:476
164 (0.230)
SELECT p2s.product_id, p2s.date_start, p2s.date_end, ps.*
FROM product_stick ps
INNER JOIN product_to_st
