SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://zaezd.com.ua/'
Время выполнения скрипта: 0 сек.


SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
Время выполнения скрипта: 0.0002 сек.


SELECT * FROM `language` WHERE status = '1'
Время выполнения скрипта: 0.0078 сек.


SELECT * FROM currency
Время выполнения скрипта: 0.0116 сек.


SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC
Время выполнения скрипта: 0.0126 сек.


SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC
Время выполнения скрипта: 0.0129 сек.


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'
Время выполнения скрипта: 0.0133 сек.


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'
Время выполнения скрипта: 0.0138 сек.


SELECT * FROM extension WHERE `type` = 'openbay'
Время выполнения скрипта: 0.0175 сек.


SELECT * FROM event
Время выполнения скрипта: 0.0177 сек.


SELECT c.category_id FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c2s.store_id = '0' AND c.left = '1'
Время выполнения скрипта: 0.1223 сек.


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 = '8174'
Время выполнения скрипта: 0.144 сек.


SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '10102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.1479 сек.


SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '4398' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.1483 сек.


SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '8174' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.1486 сек.


SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '10102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.149 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '8174'
Время выполнения скрипта: 0.1492 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '4398'
Время выполнения скрипта: 0.1493 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '3988'
Время выполнения скрипта: 0.1494 сек.


SELECT path_id FROM category_path WHERE category_id = 8174 AND level >= 1 ORDER BY level ASC
Время выполнения скрипта: 0.1495 сек.


SELECT path_id FROM category_path WHERE category_id = 10102 AND level >= 0 ORDER BY level ASC
Время выполнения скрипта: 0.1499 сек.


SELECT *, IF(td.name_short IS NULL or td.name_short = '', td.name, td.name_short) as name, (select category_id from tag_to_category where tag_id = t.tag_id) as category_id, (select count(*) from product_to_tag where tag_id = pt.tag_id) as kol FROM product_to_tag pt INNER JOIN tag t ON (t.tag_id = pt.tag_id) INNER JOIN tag_description td ON (t.tag_id = td.tag_id) INNER JOIN tag_to_store ts ON (pt.tag_id = ts.tag_id) INNER JOIN product_to_category pc ON (pt.product_id = pc.product_id) WHERE td.language_id = '1' AND ts.store_id = '0' AND t.status = '1' AND pc.category_id = 10102 group by t.tag_id ORDER BY kol desc
Время выполнения скрипта: 0.15 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '8174' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.1502 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8175' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1543 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8176' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1565 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8177' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1583 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8178' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1594 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8179' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.161 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8180' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1627 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8181' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1642 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8182' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1662 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8183' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.169 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '24746' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1709 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8184' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1713 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8185' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1724 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8186' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1736 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8187' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1755 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8188' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1778 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '8189' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1802 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '24750' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1841 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11380' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1849 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11381' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.187 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11382' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1898 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '24754' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1934 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11383' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1944 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11384' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.1978 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '11385' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.2009 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '19478' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.2044 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '24758' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.207 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '26596' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.2087 сек.


SELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '29702' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.2128 сек.


SELECT SQL_CALC_FOUND_ROWS p.*,pd.*,COUNT(r.`rating`)AS reviews ,r.`rating` ,NULL AS special ,p.`stock_status_id` AS stock_status ,p.`price` AS price_sort ,m.`name` AS manufacturer FROM `product` p LEFT JOIN `product_description` pd ON(p.`product_id`=pd.`product_id`) LEFT JOIN `review` AS r ON(p.`product_id`=r.`product_id`) LEFT JOIN `manufacturer` m ON(p.`manufacturer_id`=m.`manufacturer_id`) JOIN `product_to_category` p2c ON(p.`product_id`=p2c.`product_id`) WHERE p2c.`category_id`=10102 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '8174') AND p.`status`=1 AND pd.`language_id`=1 GROUP BY p.`product_id` ORDER BY (p.`quantity`>0) DESC, p.price ASC LIMIT 36,12
Время выполнения скрипта: 0.2138 сек.


SELECT FOUND_ROWS()AS total
Время выполнения скрипта: 0.2325 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '151978' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2329 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2348 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '150451' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2353 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2366 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '151289' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.237 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2387 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '150397' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2393 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2427 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '151992' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2923 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2951 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '150418' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2957 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.2975 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '150436' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.2979 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152086' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.3012 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3031 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152110' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.3039 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3056 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152154' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.3065 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3082 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152573' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.3091 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3107 сек.


SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152613' AND pd.language_id = '1' AND p.status = '1'
Время выполнения скрипта: 0.3112 сек.


SELECT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '687' AND m2s.store_id = '0'
Время выполнения скрипта: 0.3125 сек.


SELECT * FROM category_to_layout WHERE category_id = '8174' AND store_id = '0'
Время выполнения скрипта: 0.3157 сек.


SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
Время выполнения скрипта: 0.3159 сек.


SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
Время выполнения скрипта: 0.3161 сек.


SELECT p.`product_id`,p.`manufacturer_id`,IF(p.`quantity`>0,1,0)AS quantity_new ,p.`price` AS price_sort FROM `product` p JOIN `product_to_category` p2c ON(p.`product_id`=p2c.`product_id`) WHERE p2c.`category_id`=8174 AND p.`status`=1 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102') GROUP BY p.`product_id`
Время выполнения скрипта: 0.3228 сек.


SELECT afv.`product_id`,afv.`attr_text` ,COUNT(afv.`attr_text`)AS total FROM `attribute_filter_vier` afv LEFT JOIN `product` p ON(p.`product_id`=afv.`product_id`) LEFT JOIN `product_to_category` p2c ON(p.`product_id`=p2c.`product_id`) WHERE p2c.`category_id` IN(8174) AND p.`status`=1 AND afv.`attribute_id` IN(43,44,63,68,69,70,71,73,74,75,78,79,80,81,82,85,86,87,88,89,90,91,92,93,94,95,97,98) AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102') GROUP BY afv.`attr_text`
Время выполнения скрипта: 0.3303 сек.


SELECT link FROM `filter_vier_hand_links`
Время выполнения скрипта: 0.3365 сек.


SELECT MIN(p.`price`)AS price_min,MAX(p.`price`)AS price_max FROM `product` p JOIN `product_to_category` p2c USE INDEX(PRIMARY)USING(`product_id`) WHERE p2c.`category_id` IN(8174) AND p.`status`=1 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '10102')
Время выполнения скрипта: 0.3369 сек.


SELECT `link`,`title`,`meta_descr`,`keywords`,`meta_h1`,`discrib` FROM `filter_vier_hand_links` WHERE `link`='/aksessuary-ekster-era/nissan-x-trail/page-4/' LIMIT 1
Время выполнения скрипта: 0.4804 сек.


SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '10102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.4809 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '8174'
Время выполнения скрипта: 0.481 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '4398'
Время выполнения скрипта: 0.4811 сек.


SELECT c.parent_id, cd.name FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id = '3988'
Время выполнения скрипта: 0.4812 сек.


SELECT * FROM module WHERE module_id = '1'
Время выполнения скрипта: 0.484 сек.


SELECT * FROM module WHERE module_id = '2'
Время выполнения скрипта: 0.4842 сек.


SELECT c.category_id FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.name = 'left-menu' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.4844 сек.


SELECT c.category_id, cd.name ,(SELECT COUNT(DISTINCT pt1.product_id) FROM product_to_category AS pt1 WHERE pt1.category_id = c.category_id AND pt1.product_id IN (SELECT pt2.product_id FROM product_to_category AS pt2 WHERE pt2.category_id = 10102)) AS count_pp FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3988' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.4845 сек.


SELECT c.category_id, cd.name ,(SELECT COUNT(DISTINCT pt1.product_id) FROM product_to_category AS pt1 WHERE pt1.category_id = c.category_id AND pt1.product_id IN (SELECT pt2.product_id FROM product_to_category AS pt2 WHERE pt2.category_id = 10102)) AS count_pp FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4398' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5028 сек.


SELECT c.category_id, cd.name ,(SELECT COUNT(DISTINCT pt1.product_id) FROM product_to_category AS pt1 WHERE pt1.category_id = c.category_id AND pt1.product_id IN (SELECT pt2.product_id FROM product_to_category AS pt2 WHERE pt2.category_id = 10102)) AS count_pp FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '8174' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5119 сек.


SELECT * FROM category_to_layout WHERE category_id = '8174' AND store_id = '0'
Время выполнения скрипта: 0.5172 сек.


SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
Время выполнения скрипта: 0.5174 сек.


SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
Время выполнения скрипта: 0.5175 сек.


SELECT * FROM category_to_layout WHERE category_id = '8174' AND store_id = '0'
Время выполнения скрипта: 0.5182 сек.


SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
Время выполнения скрипта: 0.5183 сек.


SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
Время выполнения скрипта: 0.5185 сек.


SELECT * FROM category_to_layout WHERE category_id = '8174' AND store_id = '0'
Время выполнения скрипта: 0.519 сек.


SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
Время выполнения скрипта: 0.5193 сек.


SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
Время выполнения скрипта: 0.5196 сек.


SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
Время выполнения скрипта: 0.5213 сек.


SELECT * FROM extension WHERE `type` = 'analytics'
Время выполнения скрипта: 0.5258 сек.


SELECT c.category_id FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.name = 'top-menu' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
Время выполнения скрипта: 0.5294 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3999' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5297 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '9973' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5299 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '12054' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5301 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '12037' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.531 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '22027' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5319 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '10102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.533 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18255' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5333 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '26483' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5344 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '21873' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5356 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '32025' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5371 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '12034' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5389 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '12036' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5391 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18761' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5401 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '21605' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5416 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '21606' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5419 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '14377' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5432 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '14409' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5435 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '32107' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5447 сек.


SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '14378' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Время выполнения скрипта: 0.5455 сек.


SELECT * FROM extension WHERE `type` = 'total'
Время выполнения скрипта: 0.5526 сек.


SELECT `link`,`title`,`meta_descr`,`keywords`,`meta_h1`,`discrib` FROM `filter_vier_hand_links` WHERE `link`='/aksessuary-ekster-era/nissan-x-trail/page-4/' LIMIT 1
Время выполнения скрипта: 2.8593 сек.


SELECT * FROM module WHERE module_id = '42'
Время выполнения скрипта: 2.8601 сек.


SELECT * FROM module WHERE module_id = '42'
Время выполнения скрипта: 2.8605 сек.


Аксессуары экстерьера - страница 4

Аксессуары экстерьера - Страница 4

Фильтр

Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: RedLine V1
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Erkul

4 272 грн

  • Версия порога: Bosphorus Grey
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 14- (Erkul)
Боковые пороги Nissan X-Trail 14- (Erkul)
Erkul

4 272 грн

  • Версия порога: Vision New Black
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: Duru
  • Материал: Нержавеющая сталь
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: RedLine Black
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: Bosphorus Black
  • Материал: Нержавеющая сталь
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: Bosphorus Grey
  • Материал: Нержавеющая сталь
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: Vision New Black
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Боковые пороги Nissan X-Trail 03-08 (Erkul)
Erkul

4 272 грн

  • Версия порога: Vision New Grey
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Erkul

4 272 грн

  • Версия порога: Vision New Grey
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Erkul

4 272 грн

  • Версия порога: RedLine V1
  • Материал: Алюминий
  • Страна производитель: Турция
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Боковые пороги Nissan X-Trail 07-14 (Erkul)
Erkul

4 272 грн

  • Версия порога: Duru
  • Материал: Алюминий
  • Страна производитель: Турция

Подберите по году

2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
Смотреть больше