Актуальные акции

Скидка -22%

Основная щетка роботов-пылесосов для Xiaomi Mijia 1C / Xiaomi Mi Robot Vacuum - Mop

480 р. 612 р.

Основная щетка роботов-пылесосов  для Xiaomi Mijia 1C / Xiaomi Mi Robot Vacuum - MopНе подходит для Xiaomi Mi Robot Vacuum Cleaner и Xiaomi Mijia Mi Robot Mop Pro STYTJ02YM..

Щётки

Изношенные щетки - причина некачественной уборки

Боковая щётка для iRobot Roomba 500,600,700 серии

167 р.

Боковая щетка для Neato Botvac / Botvac D

120 р.

Боковая щетка для Xiaomi Mi Robot Vacuum Cleaner (1 шт.)

156 р.

Боковые щетки (3 шт.) для iRobot Roomba 500, 600, 700 серии

441 р.

Боковые щетки (3 шт.) для iRobot Roomba 800, 900 серии

441 р.

Модуль боковой щетки для Roomba e5, i7

1 700 р.

Набор для iRobot Roomba iRobot Roomba 800 и 900 серии

1 301 р.

Фильтр для iRobot Roomba S9,S9+

234 р.

Щетка боковая для iRobot Roomba e5, i7/iRobot

431 р.

Щётка боковая для робота-пылесоса Xiaomi Mijia 1C / Xiaomi Mi Robot Vacuum - Mop

165 р.

Боковая щётка для iRobot Roomba 800,900 серии

167 р.
Скидка -22%

Основная щетка роботов-пылесосов для Xiaomi Mijia 1C / Xiaomi Mi Robot Vacuum - Mop

480 р. 612 р.
Показано с 1 по 12 из 15 (всего 2 страниц)

Total time: 0.2365 s | Queries: 280 | Slow queries (>0.003 s): 2

#Query time (s)ControllerQuery
10.0011 SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
20.0003 SELECT * FROM extension WHERE `type` = 'openbay'
30.0002 ControllerStartupStartupSELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://robofor.ru/'
40.0043 ControllerStartupStartupSELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
50.0005 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 = 'г.'))
60.0002 ControllerStartupStartupSELECT * FROM country c WHERE c.iso_code_2 = 'US'
70.0005 ControllerStartupStartupSELECT * FROM language WHERE status = '1' ORDER BY sort_order, name
80.0003 ControllerStartupStartupSELECT * FROM currency ORDER BY title ASC
90.0001 ControllerStartupStartupSELECT * FROM currency
100.0006 ControllerStartupStartupSELECT 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
110.0002 ControllerStartupStartupSELECT 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
120.0002 ControllerStartupStartupSELECT 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
130.0002 ControllerStartupStartupSELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
140.0002 ControllerStartupStartupSELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
150.0005 ControllerStartupStartupDELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)
160.0001 ControllerStartupStartupSELECT * FROM extension WHERE `type` = 'openbay'
170.0005 ControllerStartupEventSELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
180.0006 ControllerStartupSeoProSELECT LOWER(`keyword`) as 'keyword', `query` FROM url_alias ORDER BY url_alias_id
190.0006 ControllerStartupSeoProSELECT 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 = '57'
200.0005 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
210.0002 ControllerStartupSeoProselect * from soconfig where store_id='0'
220.0003 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
230.0001 ControllerStartupSeoProselect * from soconfig where store_id='0'
240.0003 ControllerProductCategorySELECT 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 = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
250.0001 ControllerProductCategorySELECT 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 = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
260.0005 ControllerProductCategorySELECT * 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)
270.0002 ControllerProductCategorySELECT 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 = '81'
280.0003 ControllerProductCategorySELECT 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 = '82'
290.0001 ControllerProductCategorySELECT 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 = '83'
300.0001 ControllerProductCategorySELECT 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 = '84'
310.0001 ControllerProductCategorySELECT 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 = '100'
320.0008 ControllerProductCategorySELECT 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) 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 = '57'
330.0011 ControllerProductCategorySELECT 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 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 = '57' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12
340.0008 ControllerProductCategorySELECT 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 = '30' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
350.0005 ControllerProductCategorySELECT 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 = '180' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
360.0005 ControllerProductCategorySELECT 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 = '144' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
370.0006 ControllerProductCategorySELECT 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'
380.0005 ControllerProductCategorySELECT 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'
390.0004 ControllerProductCategorySELECT 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 = '166' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
400.0004 ControllerProductCategorySELECT 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 = '105' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
410.0004 ControllerProductCategorySELECT 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 = '195' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
420.0004 ControllerProductCategorySELECT 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 = '186' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
430.0004 ControllerProductCategorySELECT 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 = '120' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
440.0005 ControllerProductCategorySELECT 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'
450.0005 ControllerProductCategorySELECT 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 = '191' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
460.0004 ControllerProductCategorySELECT 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 = '30' AND w.status = '1'
470.0002 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '30' ORDER BY sort_order ASC
480.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='30' AND customer_group_id = '1'
490.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '30' ORDER BY main_category DESC LIMIT 1
500.0002 ControllerProductCategorySELECT 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 = '180' AND w.status = '1'
510.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '180' ORDER BY sort_order ASC
520.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='180' AND customer_group_id = '1'
530.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '180' ORDER BY main_category DESC LIMIT 1
540.0002 ControllerProductCategorySELECT 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 = '93'
550.0003 ControllerProductCategorySELECT 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 = '144' AND w.status = '1'
560.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '144' ORDER BY sort_order ASC
570.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='144' AND customer_group_id = '1'
580.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '144' ORDER BY main_category DESC LIMIT 1
590.0001 ControllerProductCategorySELECT 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 = '99'
600.0002 ControllerProductCategorySELECT 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 = '103' AND w.status = '1'
610.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '103' ORDER BY sort_order ASC
620.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='103' AND customer_group_id = '1'
630.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '103' ORDER BY main_category DESC LIMIT 1
640.0001 ControllerProductCategorySELECT 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 = '25'
650.0002 ControllerProductCategorySELECT 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'
660.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '104' ORDER BY sort_order ASC
670.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='104' AND customer_group_id = '1'
680.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '104' ORDER BY main_category DESC LIMIT 1
690.0002 ControllerProductCategorySELECT 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 = '166' AND w.status = '1'
700.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '166' ORDER BY sort_order ASC
710.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='166' AND customer_group_id = '1'
720.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '166' ORDER BY main_category DESC LIMIT 1
730.0001 ControllerProductCategorySELECT 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 = '92'
740.0002 ControllerProductCategorySELECT 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 = '105' AND w.status = '1'
750.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '105' ORDER BY sort_order ASC
760.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='105' AND customer_group_id = '1'
770.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '105' ORDER BY main_category DESC LIMIT 1
780.0002 ControllerProductCategorySELECT 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 = '195' AND w.status = '1'
790.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '195' ORDER BY sort_order ASC
800.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='195' AND customer_group_id = '1'
810.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '195' ORDER BY main_category DESC LIMIT 1
820.0002 ControllerProductCategorySELECT 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 = '186' AND w.status = '1'
830.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '186' ORDER BY sort_order ASC
840.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='186' AND customer_group_id = '1'
850.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '186' ORDER BY main_category DESC LIMIT 1
860.0003 ControllerProductCategorySELECT 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 = '120' AND w.status = '1'
870.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '120' ORDER BY sort_order ASC
880.0002 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='120' AND customer_group_id = '1'
890.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '120' ORDER BY main_category DESC LIMIT 1
900.0002 ControllerProductCategorySELECT 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 = '41' AND w.status = '1'
910.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '41' ORDER BY sort_order ASC
920.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='41' AND customer_group_id = '1'
930.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '41' ORDER BY main_category DESC LIMIT 1
940.0003 ControllerProductCategorySELECT 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 = '191' AND w.status = '1'
950.0001 ControllerProductCategorySELECT * FROM product_image WHERE product_id = '191' ORDER BY sort_order ASC
960.0001 ControllerProductCategorySELECT date_end FROM product_special WHERE product_id='191' AND customer_group_id = '1'
970.0001 ControllerProductCategorySELECT category_id FROM product_to_category WHERE product_id = '191' ORDER BY main_category DESC LIMIT 1
980.0004 ControllerCommonColumnLeftSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
990.0002 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1000.0009 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
1010.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '1'
1020.0007 ControllerEventCompatibilitySELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM review r LEFT JOIN product p ON (r.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5
1030.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '109' ORDER BY main_category DESC LIMIT 1
1040.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '182'
1050.0002 ControllerCommonColumnRightSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1060.0001 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1070.0001 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
1080.0001 ControllerCommonContentTopSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1090.0001 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1100.0001 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
1110.0001 ControllerCommonContentBottomSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1120.0001 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1130.0001 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
1140.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1150.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1160.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footertop' ORDER BY sort_order
1170.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '178'
1180.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '181'
1190.0002 ControllerExtensionSoconfigFooterblock1SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1200.0001 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1210.0001 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block1' ORDER BY sort_order
1220.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '242'
1230.0001 ControllerExtensionSoconfigFooterblock2SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1240.0001 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1250.0001 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block2' ORDER BY sort_order
1260.0001 ControllerExtensionSoconfigFooterblock3SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1270.0001 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1280.0001 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block3' ORDER BY sort_order
1290.0001 ControllerExtensionSoconfigFooterblock4SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1300.0001 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1310.0001 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block4' ORDER BY sort_order
1320.0001 ControllerExtensionSoconfigFooterblock5SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1330.0001 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1340.0001 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block5' ORDER BY sort_order
1350.0001 ControllerExtensionSoconfigFooterblock6SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1360.0001 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1370.0001 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footer_block6' ORDER BY sort_order
1380.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1390.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1400.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'footerbottom' ORDER BY sort_order
1410.0012 ControllerEventThemeSELECT * 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
1420.0002 ControllerEventThemeDELETE FROM `customer_online` WHERE date_added < '2023-06-04 13:56:20'
1430.0001 ControllerEventThemeREPLACE INTO `customer_online` SET `ip` = '3.238.111.130', `customer_id` = '0', `url` = 'http://robofor.ru/shchetka-dlya-robota-pylesosa/', `referer` = '', `date_added` = '2023-06-04 14:56:20'
1440.0003 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
1450.0001 ControllerEventThemeselect * from soconfig where store_id='0'
1460.0001 ControllerCommonHeaderSELECT * FROM extension WHERE `type` = 'analytics'
1470.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1480.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1490.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_search' ORDER BY sort_order
1500.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '94'
1510.0005 ControllerEventCompatibilitySELECT * 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)
1520.0004 ControllerEventCompatibilitySELECT * 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)
1530.0002 ControllerEventCompatibilitySELECT * 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)
1540.0002 ControllerEventCompatibilitySELECT * 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)
1550.0002 ControllerEventCompatibilitySELECT * 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)
1560.0002 ControllerEventCompatibilitySELECT * 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)
1570.0002 ControllerEventCompatibilitySELECT * 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)
1580.0002 ControllerEventCompatibilitySELECT * 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)
1590.0002 ControllerEventCompatibilitySELECT * 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)
1600.0003 ControllerEventCompatibilitySELECT * 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)
1610.0002 ControllerEventCompatibilitySELECT * 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)
1620.0002 ControllerEventCompatibilitySELECT * 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)
1630.0003 ControllerEventCompatibilitySELECT * 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)
1640.0002 ControllerEventCompatibilitySELECT * 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)
1650.0002 ControllerEventCompatibilitySELECT * 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)
1660.0002 ControllerEventCompatibilitySELECT * 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)
1670.0002 ControllerEventCompatibilitySELECT * 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)
1680.0002 ControllerEventCompatibilitySELECT * 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)
1690.0002 ControllerEventCompatibilitySELECT * 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)
1700.0003 ControllerEventCompatibilitySELECT * 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)
1710.0002 ControllerEventCompatibilitySELECT * 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)
1720.0002 ControllerEventCompatibilitySELECT * 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)
1730.0002 ControllerEventCompatibilitySELECT * 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)
1740.0002 ControllerEventCompatibilitySELECT * 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)
1750.0002 ControllerEventCompatibilitySELECT * 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)
1760.0002 ControllerEventCompatibilitySELECT * 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)
1770.0002 ControllerEventCompatibilitySELECT * 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)
1780.0002 ControllerEventCompatibilitySELECT * 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)
1790.0002 ControllerEventCompatibilitySELECT * 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)
1800.0002 ControllerEventCompatibilitySELECT * 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)
1810.0002 ControllerEventCompatibilitySELECT * 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)
1820.0719 ControllerEventCompatibilitySELECT 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
1830.0007 ControllerEventCompatibilitySELECT 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'
1840.0005 ControllerEventCompatibilitySELECT 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 = '109' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1850.0005 ControllerEventCompatibilitySELECT 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 = '105' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1860.0004 ControllerEventCompatibilitySELECT 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'
1870.0005 ControllerEventCompatibilitySELECT 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'
1880.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '107' ORDER BY main_category DESC LIMIT 1
1890.0002 ControllerExtensionSoconfigContentMenuSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1900.0001 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1910.0001 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_menu' ORDER BY sort_order
1920.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
1930.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1940.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_menu1' ORDER BY sort_order
1950.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '124'
1960.0003 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='0' AND status='0' AND module_id = '124' ORDER BY rang
1970.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='278' AND status='0' ORDER BY rang
1980.0001 ControllerEventCompatibilitySELECT 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'
1990.0001 ControllerEventCompatibilitySELECT 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'
2000.0001 ControllerEventCompatibilitySELECT 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 = '64'
2010.0001 ControllerEventCompatibilitySELECT 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'
2020.0004 ControllerEventCompatibilitySELECT 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'
2030.0001 ControllerEventCompatibilitySELECT 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 = '65'
2040.0001 ControllerEventCompatibilitySELECT 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'
2050.0001 ControllerEventCompatibilitySELECT 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'
2060.0001 ControllerEventCompatibilitySELECT 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 = '66'
2070.0001 ControllerEventCompatibilitySELECT 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'
2080.0001 ControllerEventCompatibilitySELECT 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'
2090.0001 ControllerEventCompatibilitySELECT 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 = '67'
2100.0001 ControllerEventCompatibilitySELECT 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'
2110.0001 ControllerEventCompatibilitySELECT 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'
2120.0001 ControllerEventCompatibilitySELECT 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 = '105'
2130.0001 ControllerEventCompatibilitySELECT 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'
2140.0001 ControllerEventCompatibilitySELECT 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'
2150.0001 ControllerEventCompatibilitySELECT 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 = '98'
2160.0001 ControllerEventCompatibilitySELECT 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'
2170.0001 ControllerEventCompatibilitySELECT 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'
2180.0001 ControllerEventCompatibilitySELECT 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 = '104'
2190.0002 ControllerEventCompatibilitySELECT p.product_id FROM product p LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' ORDER BY p.date_added DESC LIMIT 4
2200.0005 ControllerEventCompatibilitySELECT 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 = '217' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2210.0005 ControllerEventCompatibilitySELECT 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 = '213' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2220.0004 ControllerEventCompatibilitySELECT 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 = '211' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2230.0004 ControllerEventCompatibilitySELECT 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 = '210' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2240.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '217' ORDER BY main_category DESC LIMIT 1
2250.0001 ControllerEventCompatibilitySELECT 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 = '96'
2260.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '213' ORDER BY main_category DESC LIMIT 1
2270.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '211' ORDER BY main_category DESC LIMIT 1
2280.0001 ControllerEventCompatibilitySELECT category_id FROM product_to_category WHERE product_id = '210' ORDER BY main_category DESC LIMIT 1
2290.0003 ControllerEventCompatibilitySELECT 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'
2300.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='287' AND status='0' ORDER BY rang
2310.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='277' AND status='0' ORDER BY rang
2320.0001 ControllerEventCompatibilitySELECT 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'
2330.0001 ControllerEventCompatibilitySELECT 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'
2340.0001 ControllerEventCompatibilitySELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM category t0 LEFT JOIN category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '73'
2350.0001 ControllerEventCompatibilitySELECT 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'
2360.0001 ControllerEventCompatibilitySELECT 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'
2370.0001 ControllerEventCompatibilitySELECT 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 = '74'
2380.0001 ControllerEventCompatibilitySELECT 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'
2390.0001 ControllerEventCompatibilitySELECT 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'
2400.0005 ControllerEventCompatibilitySELECT 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'
2410.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='289' AND status='0' ORDER BY rang
2420.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='291' AND status='0' ORDER BY rang
2430.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='279' AND status='0' ORDER BY rang
2440.0002 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='299' AND status='0' ORDER BY rang
2450.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='280' AND status='0' ORDER BY rang
2460.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='281' AND status='0' ORDER BY rang
2470.0002 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='283' AND status='0' ORDER BY rang
2480.0002 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='282' AND status='0' ORDER BY rang
2490.0002 ControllerEventCompatibilitySELECT 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 = '20'
2500.0001 ControllerEventCompatibilitySELECT 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 = '18'
2510.0001 ControllerEventCompatibilitySELECT 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 = '17'
2520.0001 ControllerEventCompatibilitySELECT 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 = '95'
2530.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'
2540.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2550.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_topbar' ORDER BY sort_order
2560.0004 ControllerEventThemeSELECT * 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)
2570.0004 ControllerEventThemeSELECT 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)
2580.0003 ControllerEventThemeSELECT * 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)
2590.0006 ControllerEventThemeSELECT * 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)
2600.0004 ControllerEventThemeSELECT * 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)
2610.0003 ControllerEventThemeSELECT * 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)
2620.0003 ControllerEventThemeSELECT * 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)
2630.0001 ControllerEventThemeSELECT 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 = '86'
2640.0001 ControllerEventThemeSELECT 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 = '87'
2650.0001 ControllerEventThemeSELECT 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 = '88'
2660.0001 ControllerEventThemeSELECT 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 = '89'
2670.0001 ControllerEventThemeSELECT 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 = '91'
2680.0001 ControllerEventThemeSELECT 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 = '101'
2690.0003 ControllerEventThemeSELECT * 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)
2700.0003 ControllerEventThemeSELECT * 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)
2710.0001 ControllerCommonCartSELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bb89de3aead27fef16c9c2f3ab9d84f5'
2720.0001 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
2730.0001 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bb89de3aead27fef16c9c2f3ab9d84f5'
2740.0003 ControllerEventCompatibilitySELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
2750.0002 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bb89de3aead27fef16c9c2f3ab9d84f5'
2760.0001 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bb89de3aead27fef16c9c2f3ab9d84f5'
2770.0003 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
2780.0001 ControllerEventThemeselect * from soconfig where store_id='0'
2790.0003 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
2800.0001 ControllerEventThemeselect * from soconfig where store_id='0'