# | Query time (s) | Controller | Query |
---|
1 | 0.0011 | | SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type' |
2 | 0.0002 | | SELECT * FROM extension WHERE `type` = 'openbay' |
3 | 0.0001 | ControllerStartupStartup | SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://robofor.ru/' |
4 | 0.0045 | ControllerStartupStartup | SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
5 | 0.0004 | ControllerStartupStartup |
SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level,
f1.fias_id f1_fias_id, f1.shortname f1_shortname,
CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id,
CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id,
CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id
FROM fias f1
LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
WHERE f1.offname = 'Феърфилд'
AND (f3.offname = 'США'
OR f2.offname = 'США'
OR f4.offname = 'США')
AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.')) |
6 | 0.0001 | ControllerStartupStartup | SELECT * FROM country c WHERE c.iso_code_2 = 'US' |
7 | 0.0002 | ControllerStartupStartup | SELECT * FROM currency |
8 | 0.0004 | ControllerStartupStartup | 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 = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
9 | 0.0002 | ControllerStartupStartup | 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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
10 | 0.0002 | ControllerStartupStartup | 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 |
11 | 0.0001 | ControllerStartupStartup | 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' |
12 | 0.0001 | ControllerStartupStartup | 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' |
13 | 0.0003 | ControllerStartupStartup | DELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH) |
14 | 0.0001 | ControllerStartupStartup | SELECT * FROM extension WHERE `type` = 'openbay' |
15 | 0.0005 | ControllerStartupEvent | SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
16 | 0.0004 | ControllerStartupSeoPro | SHOW TABLES LIKE 'soconfig' |
17 | 0.0001 | ControllerStartupSeoPro | select * from soconfig where store_id='0' |
18 | 0.0002 | ControllerStartupSeoPro | SHOW TABLES LIKE 'soconfig' |
19 | 0.0001 | ControllerStartupSeoPro | select * from soconfig where store_id='0' |
20 | 0.0002 | ControllerProductProduct | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
21 | 0.001 | ControllerProductProduct | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '104' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
22 | 0.0002 | ControllerProductProduct | SHOW COLUMNS FROM product_description LIKE 'video1' |
23 | 0.0001 | ControllerProductProduct | SELECT DISTINCT `video1` FROM product_description pd WHERE pd.product_id = '104' AND pd.language_id = '1' |
24 | 0.0001 | ControllerProductProduct | SHOW COLUMNS FROM product_description LIKE 'tab_title' |
25 | 0.0001 | ControllerProductProduct | SELECT DISTINCT `tab_title` FROM product_description pd WHERE pd.product_id = '104' AND pd.language_id = '1' |
26 | 0.0001 | ControllerProductProduct | SHOW COLUMNS FROM product_description LIKE 'html_product_tab' |
27 | 0.0001 | ControllerProductProduct | SELECT DISTINCT `html_product_tab` FROM product_description pd WHERE pd.product_id = '104' AND pd.language_id = '1' |
28 | 0.0001 | ControllerProductProduct | SHOW COLUMNS FROM product_description LIKE 'html_product_shortdesc' |
29 | 0.0001 | ControllerProductProduct | SELECT DISTINCT `html_product_shortdesc` FROM product_description pd WHERE pd.product_id = '104' AND pd.language_id = '1' |
30 | 0.0001 | ControllerProductProduct | SELECT date_end FROM product_special WHERE product_id='104' AND customer_group_id = '1' |
31 | 0.0005 | ControllerProductProduct | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '104' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
32 | 0.0002 | ControllerProductProduct | SELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '104' AND w.status = '1' |
33 | 0.0002 | ControllerProductProduct | SELECT * FROM product_image WHERE product_id = '104' ORDER BY sort_order ASC |
34 | 0.0001 | ControllerProductProduct | SELECT * FROM product_discount WHERE product_id = '104' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC |
35 | 0.0006 | ControllerProductProduct | SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '104' AND od.language_id = '1' ORDER BY o.sort_order |
36 | 0.0009 | ControllerProductProduct | SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '104' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
37 | 0.0004 | ControllerProductProduct | SELECT a.attribute_id, ad.name, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '104' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
38 | 0.0002 | ControllerProductProduct | SELECT a.attribute_id, ad.name, pa.text FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '104' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
39 | 0.0003 | ControllerProductProduct | SELECT * FROM product_related pr LEFT JOIN product p ON (pr.related_id = p.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '104' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
40 | 0.0007 | ControllerProductProduct | SELECT rd.* FROM product_recurring pr JOIN recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 104 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC |
41 | 0.0005 | ControllerProductProduct | SELECT * FROM product_to_download pd LEFT JOIN download d ON(pd.download_id=d.download_id) LEFT JOIN download_description dd ON(pd.download_id=dd.download_id) WHERE product_id = '104' AND dd.language_id = '1' |
42 | 0.0002 | ControllerProductProduct | UPDATE product SET viewed = (viewed + 1) WHERE product_id = '104' |
43 | 0.0002 | ControllerCommonColumnLeft | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
44 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
45 | 0.0002 | ControllerCommonColumnLeft | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order |
46 | 0.0005 | ControllerEventCompatibility | SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
47 | 0.0004 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
48 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '182' |
49 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '198' |
50 | 0.0001 | ControllerEventCompatibility | 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 = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
51 | 0.0003 | ControllerEventCompatibility | SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR ' > ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id = '96' AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC |
52 | 0.0061 | ControllerEventCompatibility | SELECT p.product_id, (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 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 SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales 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) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (96) GROUP BY p.product_id ORDER BY sales ASC, LCASE(pd.name) ASC LIMIT 0,8 |
53 | 0.0006 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '218' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
54 | 0.0005 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '219' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
55 | 0.0005 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '223' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
56 | 0.0001 | ControllerEventCompatibility | SELECT * FROM product_image WHERE product_id ='218' ORDER BY sort_order ASC; |
57 | 0.0001 | ControllerEventCompatibility | SELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '218' AND w.status = '1' |
58 | 0.0001 | ControllerEventCompatibility | SELECT * FROM product_image WHERE product_id ='219' ORDER BY sort_order ASC; |
59 | 0.0001 | ControllerEventCompatibility | SELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '219' AND w.status = '1' |
60 | 0.0001 | ControllerEventCompatibility | SELECT * FROM product_image WHERE product_id ='223' ORDER BY sort_order ASC; |
61 | 0.0001 | ControllerEventCompatibility | SELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '223' AND w.status = '1' |
62 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
63 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
64 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order |
65 | 0.0001 | ControllerCommonContentTop | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
66 | 0.0001 | ControllerCommonContentTop | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
67 | 0.0001 | ControllerCommonContentTop | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order |
68 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
69 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
70 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order |
71 | 0.0001 | ControllerExtensionSoconfigContentFootertop | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
72 | 0.0001 | ControllerExtensionSoconfigContentFootertop | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
73 | 0.0001 | ControllerExtensionSoconfigContentFootertop | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footertop' ORDER BY sort_order |
74 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '178' |
75 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '181' |
76 | 0.0001 | ControllerExtensionSoconfigFooterblock1 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
77 | 0.0001 | ControllerExtensionSoconfigFooterblock1 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
78 | 0.0001 | ControllerExtensionSoconfigFooterblock1 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block1' ORDER BY sort_order |
79 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '242' |
80 | 0.0002 | ControllerExtensionSoconfigFooterblock2 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
81 | 0.0001 | ControllerExtensionSoconfigFooterblock2 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
82 | 0.0001 | ControllerExtensionSoconfigFooterblock2 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block2' ORDER BY sort_order |
83 | 0.0001 | ControllerExtensionSoconfigFooterblock3 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
84 | 0.0001 | ControllerExtensionSoconfigFooterblock3 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
85 | 0.0001 | ControllerExtensionSoconfigFooterblock3 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block3' ORDER BY sort_order |
86 | 0.0001 | ControllerExtensionSoconfigFooterblock4 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
87 | 0.0001 | ControllerExtensionSoconfigFooterblock4 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
88 | 0.0001 | ControllerExtensionSoconfigFooterblock4 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block4' ORDER BY sort_order |
89 | 0.0001 | ControllerExtensionSoconfigFooterblock5 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
90 | 0.0001 | ControllerExtensionSoconfigFooterblock5 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
91 | 0.0001 | ControllerExtensionSoconfigFooterblock5 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block5' ORDER BY sort_order |
92 | 0.0001 | ControllerExtensionSoconfigFooterblock6 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
93 | 0.0001 | ControllerExtensionSoconfigFooterblock6 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
94 | 0.0001 | ControllerExtensionSoconfigFooterblock6 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footer_block6' ORDER BY sort_order |
95 | 0.0001 | ControllerExtensionSoconfigContentFooterbottom | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
96 | 0.0001 | ControllerExtensionSoconfigContentFooterbottom | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
97 | 0.0001 | ControllerExtensionSoconfigContentFooterbottom | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'footerbottom' ORDER BY sort_order |
98 | 0.0012 | ControllerEventTheme | 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 |
99 | 0.0002 | ControllerEventTheme | DELETE FROM `customer_online` WHERE date_added < '2024-11-09 16:15:38' |
100 | 0.0001 | ControllerEventTheme | REPLACE INTO `customer_online` SET `ip` = '3.233.242.216', `customer_id` = '0', `url` = 'http://robofor.ru/nabory/bokovye-shetki-dlya-robota-pylesosa-irobot-roomba-800-900-serii/', `referer` = '', `date_added` = '2024-11-09 17:15:38' |
101 | 0.0003 | ControllerEventTheme | SHOW TABLES LIKE 'soconfig' |
102 | 0.0001 | ControllerEventTheme | select * from soconfig where store_id='0' |
103 | 0.0001 | ControllerCommonHeader | SELECT * FROM extension WHERE `type` = 'analytics' |
104 | 0.0001 | ControllerExtensionSoconfigContentSearch | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
105 | 0.0001 | ControllerExtensionSoconfigContentSearch | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
106 | 0.0001 | ControllerExtensionSoconfigContentSearch | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_search' ORDER BY sort_order |
107 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '94' |
108 | 0.0006 | ControllerEventCompatibility | SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
109 | 0.0004 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
110 | 0.0003 | ControllerEventCompatibility | 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 = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
111 | 0.0002 | ControllerEventCompatibility | 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 = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
112 | 0.0002 | ControllerEventCompatibility | 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 = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
113 | 0.0002 | ControllerEventCompatibility | 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 = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
114 | 0.0002 | ControllerEventCompatibility | 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 = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
115 | 0.0002 | ControllerEventCompatibility | 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 = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
116 | 0.0002 | ControllerEventCompatibility | 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 = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
117 | 0.0003 | ControllerEventCompatibility | 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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
118 | 0.0002 | ControllerEventCompatibility | 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 = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
119 | 0.0002 | ControllerEventCompatibility | 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 = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
120 | 0.0003 | ControllerEventCompatibility | 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 = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
121 | 0.0002 | ControllerEventCompatibility | 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 = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
122 | 0.0002 | ControllerEventCompatibility | 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 = '87' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
123 | 0.0002 | ControllerEventCompatibility | 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 = '88' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
124 | 0.0002 | ControllerEventCompatibility | 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 = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
125 | 0.0002 | ControllerEventCompatibility | 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 = '91' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
126 | 0.0002 | ControllerEventCompatibility | 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 = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
127 | 0.0003 | ControllerEventCompatibility | 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 = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
128 | 0.0002 | ControllerEventCompatibility | 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 = '81' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
129 | 0.0002 | ControllerEventCompatibility | 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 = '82' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
130 | 0.0002 | ControllerEventCompatibility | 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 = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
131 | 0.0002 | ControllerEventCompatibility | 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 = '84' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
132 | 0.0002 | ControllerEventCompatibility | 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 = '100' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
133 | 0.0002 | ControllerEventCompatibility | 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 = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
134 | 0.0002 | ControllerEventCompatibility | 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 = '93' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
135 | 0.0002 | ControllerEventCompatibility | 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 = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
136 | 0.0002 | ControllerEventCompatibility | 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 = '95' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
137 | 0.0002 | ControllerEventCompatibility | 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 = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
138 | 0.0002 | ControllerEventCompatibility | 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 = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
139 | 0.0497 | ControllerEventCompatibility | SELECT p.product_id, (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 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 SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = 1 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,5 |
140 | 0.0009 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '103' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
141 | 0.0006 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '104' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
142 | 0.0005 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '107' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
143 | 0.0006 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '106' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
144 | 0.0005 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '83' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
145 | 0.0001 | ControllerExtensionSoconfigContentMenu | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
146 | 0.0001 | ControllerExtensionSoconfigContentMenu | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
147 | 0.0001 | ControllerExtensionSoconfigContentMenu | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_menu' ORDER BY sort_order |
148 | 0.0001 | ControllerExtensionSoconfigContentMenu1 | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
149 | 0.0001 | ControllerExtensionSoconfigContentMenu1 | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
150 | 0.0001 | ControllerExtensionSoconfigContentMenu1 | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_menu1' ORDER BY sort_order |
151 | 0.0001 | ControllerEventCompatibility | SELECT * FROM module WHERE module_id = '124' |
152 | 0.0003 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='0' AND status='0' AND module_id = '124' ORDER BY rang |
153 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='278' AND status='0' ORDER BY rang |
154 | 0.0002 | ControllerEventCompatibility | 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 = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
155 | 0.0002 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
156 | 0.0002 | ControllerEventCompatibility | 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 = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
157 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
158 | 0.0001 | ControllerEventCompatibility | 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 = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
159 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
160 | 0.0001 | ControllerEventCompatibility | 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 = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
161 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
162 | 0.0001 | ControllerEventCompatibility | 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 = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
163 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
164 | 0.0001 | ControllerEventCompatibility | 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 = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
165 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
166 | 0.0001 | ControllerEventCompatibility | 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 = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
167 | 0.0001 | ControllerEventCompatibility | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
168 | 0.0006 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
169 | 0.0002 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='287' AND status='0' ORDER BY rang |
170 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='277' AND status='0' ORDER BY rang |
171 | 0.0002 | ControllerEventCompatibility | 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 = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
172 | 0.0001 | ControllerEventCompatibility | 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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
173 | 0.0002 | ControllerEventCompatibility | 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 = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
174 | 0.0001 | ControllerEventCompatibility | 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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
175 | 0.0001 | ControllerEventCompatibility | 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 = '97' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
176 | 0.0001 | ControllerEventCompatibility | 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 = '103' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
177 | 0.0007 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
178 | 0.0002 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='289' AND status='0' ORDER BY rang |
179 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='291' AND status='0' ORDER BY rang |
180 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='279' AND status='0' ORDER BY rang |
181 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='299' AND status='0' ORDER BY rang |
182 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='280' AND status='0' ORDER BY rang |
183 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='281' AND status='0' ORDER BY rang |
184 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='283' AND status='0' ORDER BY rang |
185 | 0.0001 | ControllerEventCompatibility | SELECT * FROM mega_menu WHERE parent_id='282' AND status='0' ORDER BY rang |
186 | 0.0002 | ControllerExtensionSoconfigContentTopbar | SELECT * FROM product_to_layout WHERE product_id = '104' AND store_id = '0' |
187 | 0.0002 | ControllerExtensionSoconfigContentTopbar | SELECT * FROM layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
188 | 0.0002 | ControllerExtensionSoconfigContentTopbar | SELECT * FROM layout_module WHERE layout_id = '2' AND position = 'content_topbar' ORDER BY sort_order |
189 | 0.0006 | ControllerEventTheme | SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
190 | 0.0005 | ControllerEventTheme | SELECT COUNT(DISTINCT(sbc.simple_blog_category_id)) AS total FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name) |
191 | 0.0005 | ControllerEventTheme | SELECT * FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name) |
192 | 0.0008 | ControllerEventTheme | SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
193 | 0.0005 | ControllerEventTheme | 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
194 | 0.0004 | ControllerEventTheme | 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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
195 | 0.0005 | ControllerEventTheme | 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 = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
196 | 0.0005 | ControllerEventTheme | 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 = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
197 | 0.0003 | ControllerEventTheme | 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 = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
198 | 0.0002 | ControllerCommonCart | SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9da385c55eaa61bf7059571ac18a1397' |
199 | 0.0001 | ControllerCommonCart | SELECT * FROM extension WHERE `type` = 'total' |
200 | 0.0001 | ControllerEventCompatibility | SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9da385c55eaa61bf7059571ac18a1397' |
201 | 0.0005 | ControllerEventCompatibility | SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0' |
202 | 0.0002 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9da385c55eaa61bf7059571ac18a1397' |
203 | 0.0003 | ControllerEventCompatibility | SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9da385c55eaa61bf7059571ac18a1397' |
204 | 0.0005 | ControllerEventTheme | SHOW TABLES LIKE 'soconfig' |
205 | 0.0002 | ControllerEventTheme | select * from soconfig where store_id='0' |
206 | 0.0005 | ControllerExtensionModulePcbg | SELECT * FROM pcbg WHERE target_product_id = '104' limit 1 |
207 | 0.0011 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '41' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
208 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM product_to_category WHERE product_id = '41' ORDER BY main_category DESC LIMIT 1 |
209 | 0.0009 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '41' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
210 | 0.0005 | ControllerEventCompatibility | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '41' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |