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.0068 сек.
SELECT * FROM currency Время выполнения скрипта: 0.0096 сек.
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.0105 сек.
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.0107 сек.
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.0111 сек.
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.0114 сек.
SELECT * FROM extension WHERE `type` = 'openbay' Время выполнения скрипта: 0.0142 сек.
SELECT * FROM event Время выполнения скрипта: 0.0144 сек.
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.1193 сек.
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 = '4184' Время выполнения скрипта: 0.1401 сек.
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 = '14506' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' Время выполнения скрипта: 0.1477 сек.
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 = '4174' 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 = '4184' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' Время выполнения скрипта: 0.1488 сек.
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 = '14506' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' Время выполнения скрипта: 0.1496 сек.
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 = '4184' Время выполнения скрипта: 0.1499 сек.
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 = '4174' Время выполнения скрипта: 0.1501 сек.
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.1502 сек.
SELECT path_id FROM category_path WHERE category_id = 4184 AND level >= 1 ORDER BY level ASC Время выполнения скрипта: 0.1506 сек.
SELECT path_id FROM category_path WHERE category_id = 14506 AND level >= 0 ORDER BY level ASC Время выполнения скрипта: 0.1518 сек.
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 = '14506' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) Время выполнения скрипта: 0.1519 сек.
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 = 14506
group by t.tag_id ORDER BY kol desc Время выполнения скрипта: 0.1521 сек.
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 = '4184' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) Время выполнения скрипта: 0.1526 сек.
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 = '5820' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1573 сек.
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 = '5821' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1599 сек.
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 = '5822' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1625 сек.
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 = '5823' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1655 сек.
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 = '5824' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1682 сек.
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 = '5825' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1705 сек.
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 = '5826' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1723 сек.
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 = '23358' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1741 сек.
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 = '5827' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1748 сек.
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 = '5828' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1781 сек.
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 = '5829' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1805 сек.
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 = '5830' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1831 сек.
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 = '5831' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.188 сек.
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 = '5832' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1906 сек.
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 = '23362' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 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 = '5833' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1941 сек.
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 = '5834' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1969 сек.
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 = '5835' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.1991 сек.
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 = '5836' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2015 сек.
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 = '5837' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2039 сек.
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 = '5838' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2061 сек.
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 = '10629' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2085 сек.
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 = '10630' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2108 сек.
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 = '23366' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2138 сек.
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 = '10631' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2144 сек.
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 = '10632' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2159 сек.
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 = '19977' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2173 сек.
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 = '23370' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2189 сек.
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 = '31332' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2195 сек.
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 = '27763' AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.2203 сек.
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`=14506 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '4184') AND p.`status`=1 AND pd.`language_id`=1 GROUP BY p.`product_id` ORDER BY (p.`quantity`>0) DESC, p.price ASC LIMIT 96,12 Время выполнения скрипта: 0.2209 сек.
SELECT FOUND_ROWS()AS total Время выполнения скрипта: 0.2405 сек.
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 = '104416' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2411 сек.
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 = '689' AND m2s.store_id = '0' Время выполнения скрипта: 0.2437 сек.
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 = '104417' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.245 сек.
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 = '689' AND m2s.store_id = '0' Время выполнения скрипта: 0.2481 сек.
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 = '104126' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2492 сек.
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 = '689' AND m2s.store_id = '0' Время выполнения скрипта: 0.2517 сек.
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 = '102529' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2528 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2545 сек.
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 = '102530' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.256 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2584 сек.
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 = '102338' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.26 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.263 сек.
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 = '102339' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2645 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2676 сек.
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 = '101923' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.269 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2747 сек.
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 = '102026' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2781 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2825 сек.
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 = '102766' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2847 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2881 сек.
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 = '102833' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.289 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2915 сек.
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 = '102916' AND pd.language_id = '1' AND p.status = '1' Время выполнения скрипта: 0.2927 сек.
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 = '690' AND m2s.store_id = '0' Время выполнения скрипта: 0.2949 сек.
SELECT * FROM category_to_layout WHERE category_id = '4184' AND store_id = '0' Время выполнения скрипта: 0.2986 сек.
SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 Время выполнения скрипта: 0.2991 сек.
SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order Время выполнения скрипта: 0.2994 сек.
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`=4184 AND p.`status`=1 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') GROUP BY p.`product_id` Время выполнения скрипта: 0.3068 сек.
SELECT m.`manufacturer_id`,p.`product_id`,m.`name`,m.`image` ,COUNT(p.`manufacturer_id`)AS totall FROM `manufacturer` m LEFT JOIN `product` p ON(m.`manufacturer_id`=p.`manufacturer_id`) LEFT JOIN `product_to_category` p2c ON(p.`product_id`=p2c.`product_id`) WHERE p2c.`category_id` IN(4184) AND p.`status`=1 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') GROUP BY m.`manufacturer_id` ORDER BY m.`sort_order`,m.`name` ASC Время выполнения скрипта: 0.3143 сек.
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(4184) 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 = '14506') GROUP BY afv.`attr_text` Время выполнения скрипта: 0.3208 сек.
SELECT agd.`attribute_group_id`,agd.`name` AS name_group,tfv.`attribute_id`,tfv.`attr_text`,tfv.`text_id`,ad.`name`,afvl.`text` FROM (SELECT DISTINCT afv.`attribute_id`,afv.`attr_text`,afv.`text_id` FROM `attribute_filter_vier` afv,`product` p ,`product_to_category` p2c WHERE afv.`product_id`=p.`product_id` AND p2c.`product_id`=p.`product_id` AND p2c.`category_id` IN(4184) 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 = '14506') )tfv LEFT JOIN `attribute_filter_vier_lang` afvl ON(tfv.`attr_text`=afvl.`attr_text`) LEFT JOIN `attribute` a ON(tfv.`attribute_id`=a.`attribute_id`)LEFT JOIN `attribute_description` ad ON(a.`attribute_id`=ad.`attribute_id`)LEFT JOIN `attribute_group_description` agd ON(a.`attribute_group_id`=agd.`attribute_group_id`)LEFT JOIN `attribute_group` ag ON(agd.`attribute_group_id`=ag.`attribute_group_id`) WHERE ad.`language_id`=1 AND afvl.`language_id`=1 AND agd.`language_id`=1 ORDER BY ag.`sort_order`,a.`sort_order`,ad.`name`,(afvl.`text`+0),afvl.`text` Время выполнения скрипта: 0.3339 сек.
SELECT link FROM `filter_vier_hand_links` Время выполнения скрипта: 0.3549 сек.
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(4184) AND p.`status`=1 AND p.product_id IN (SELECT product_id FROM product_to_category WHERE category_id = '14506') Время выполнения скрипта: 0.3554 сек.
SELECT `link`,`title`,`meta_descr`,`keywords`,`meta_h1`,`discrib` FROM `filter_vier_hand_links` WHERE `link`='/bagazhniki-i-krepleniya-bagazhniki-bagazhniki-avtomobil-nye/ford-focus/page-9/' LIMIT 1 Время выполнения скрипта: 0.6982 сек.
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 = '14506' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' Время выполнения скрипта: 0.6988 сек.
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 = '4184' Время выполнения скрипта: 0.699 сек.
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 = '4174' Время выполнения скрипта: 0.6991 сек.
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.6992 сек.
SELECT * FROM module WHERE module_id = '1' Время выполнения скрипта: 0.7023 сек.
SELECT * FROM module WHERE module_id = '2' Время выполнения скрипта: 0.7025 сек.
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.7026 сек.
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 = 14506)) 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.7027 сек.
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 = 14506)) 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 = '4174'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) Время выполнения скрипта: 0.7074 сек.
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 = 14506)) 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 = '4184'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) Время выполнения скрипта: 0.7106 сек.
SELECT * FROM category_to_layout WHERE category_id = '4184' AND store_id = '0' Время выполнения скрипта: 0.7128 сек.
SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 Время выполнения скрипта: 0.713 сек.
SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order Время выполнения скрипта: 0.7132 сек.
SELECT * FROM category_to_layout WHERE category_id = '4184' AND store_id = '0' Время выполнения скрипта: 0.7143 сек.
SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 Время выполнения скрипта: 0.7144 сек.
SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order Время выполнения скрипта: 0.7146 сек.
SELECT * FROM category_to_layout WHERE category_id = '4184' AND store_id = '0' Время выполнения скрипта: 0.7154 сек.
SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 Время выполнения скрипта: 0.7155 сек.
SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order Время выполнения скрипта: 0.7156 сек.
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.7175 сек.
SELECT * FROM extension WHERE `type` = 'analytics' Время выполнения скрипта: 0.7241 сек.
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.7293 сек.
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.7295 сек.
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.7297 сек.
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.7299 сек.
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.7306 сек.
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.7313 сек.
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.7319 сек.
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.7321 сек.
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.7331 сек.
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.7336 сек.
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.7341 сек.
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.7353 сек.
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.7355 сек.
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.7364 сек.
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.7372 сек.
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.7373 сек.
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.738 сек.
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.7381 сек.
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.7388 сек.
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.7392 сек.
SELECT * FROM extension WHERE `type` = 'total' Время выполнения скрипта: 0.7425 сек.
SELECT `link`,`title`,`meta_descr`,`keywords`,`meta_h1`,`discrib` FROM `filter_vier_hand_links` WHERE `link`='/bagazhniki-i-krepleniya-bagazhniki-bagazhniki-avtomobil-nye/ford-focus/page-9/' LIMIT 1 Время выполнения скрипта: 2.8665 сек.
SELECT * FROM module WHERE module_id = '42' Время выполнения скрипта: 2.8671 сек.
SELECT * FROM module WHERE module_id = '42' Время выполнения скрипта: 2.8676 сек.
Багажники автомобильные Ford Focus - страница 9
Обратный звонок
Не можете дозвониться?
Нет возможности позвонить?
Оставьте свои контакты и мы перезвоним вам сами
Где купить качественные автомобильные багажникиFord Focus?
В нашем интернет-магазине вы можете купить автомобильные багажники от лучших производителей Украины. После оформления заявки, ваш заказ будет отправлен в кратчайшие сроки. Мы осуществляем доставку в Житомир, Херсон, Кировоград, Черкассы, Сумы, Днепр, Ивано-Франковск, Черновцы, Одессу, Хмельницкий, Запорожье, Чернигов, Винницу, Николаев, Ровно, Полтаву, Луцк, Тернополь, Закарпатье, Харьков и другие города Украины. Заказ отправляется как наложенным платежом так и по предоплате на банковскую карту. Точную информацию вы можете согласовать с менеджером при оформлении заказа
Ассортимент автомобильные багажниковFord Focus в магазине Заезд
В интернет-магазине Заезд представлены автомобильные багажники от лучших производителей Украины. У нас есть:
Автомобильные багажники на рейлинги (просветные). Рейлинги представляют собой две рейки, которые крепятся на кузове в нескольких местах и проходят вдоль крыши. Багажники на рейлинги устанавливаются очень просто и быстро. Подобный вид крепления очень эффективен потому что позволяет равномерно распределить нагрузку на крыше в зависимости от перевозимого груза. Это достигается благодаря универсальной установке поперечин на рейлинги.
Автомобильные багажники с креплением для гладкой крыши. Многие модели автомобили не имеют заводских креплений для установки багажника. В таком случае единственным вариантом установки автомобильного багажника является крепление за дверные проемы. С помощью специальных боковых изгибов конструкция надежно крепится на кузов. Благодаря тому, что эти изгибы обычно имеют резиновую прокладку, кузов машины остается без повреждений.
Автомобильные багажники с крепежными местами. Некоторые автомобили уже с завода выпускаются со штатными крепежными выемками на крыше автомобиля. Эти места предназначены для выдерживания высокой нагрузки, что делает данный вид крепления наиболее надежным.
Автомобильные багажники с креплением на водостоки. Этот вид крепления, как правило используется в автомобилях старых моделей. В данном случае багажник крепится к бортикам на краях крыши, которые предусмотрены для отвода воды.