В корзине пусто!
27 500 р.
32 400 р.
38 400 р.
27 600 р.
32 300 р.
38 400 р.
27 600 р.
32 100 р.
38 200 р.
31 100 р.
35 100 р.
40 100 р.
43 400 р.
22 000 р.
20 000 р.
Total time: 0.2036 s | Queries: 325 | Slow queries (>0.003 s): 2
| # | Query time (s) | Controller | Query |
|---|---|---|---|
| 1 | 0.0006 | SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type' | |
| 2 | 0.0001 | SET SQL_BIG_SELECTS = 1 | |
| 3 | 0.0004 | SHOW TABLES LIKE 'oc_ocfilter_setting' | |
| 4 | 0.0002 | SELECT * FROM oc_ocfilter_setting | |
| 5 | 0.0001 | ControllerStartupStartup | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://navi-cars.ru/' |
| 6 | 0.002 | ControllerStartupStartup | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 7 | 0.0003 | ControllerEventCompatibility | SELECT f1.offname f1_name, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_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.fias_id = 41 |
| 8 | 0.0003 | ControllerEventCompatibility | SELECT * FROM oc_currency |
| 9 | 0.0003 | ControllerEventCompatibility | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC |
| 10 | 0.0002 | ControllerEventCompatibility | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC |
| 11 | 0.0002 | ControllerEventCompatibility | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_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 |
| 12 | 0.0002 | ControllerEventCompatibility | SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' |
| 13 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' |
| 14 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 15 | 0.0004 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper' |
| 16 | 0.0003 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper_share' |
| 17 | 0.0006 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 18 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY) |
| 19 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY) |
| 20 | 0.0002 | ControllerEventCompatibility | SELECT `session_id` FROM `oc_cart` WHERE `session_id` = '7cf405b61a2e6358d338ee1c56486f77' LIMIT 1 |
| 21 | 0.0003 | ControllerStartupEvent | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| 22 | 0.0015 | ControllerStartupSeoPro | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 23 | 0.0007 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'shtatnaja-magnitola' LIMIT 1 |
| 24 | 0.0006 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'toyota-dvd' LIMIT 1 |
| 25 | 0.0005 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'tacoma' LIMIT 1 |
| 26 | 0.0381 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'shtatnaja-magnitola/toyota-dvd/tacoma/' LIMIT 1 |
| 27 | 0.0003 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 28 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 29 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 30 | 0.0002 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 31 | 0.0002 | ControllerProductCategory | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_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' |
| 32 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 33 | 0.0001 | ControllerProductCategory | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 34 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 35 | 0.0002 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 36 | 0.0001 | ControllerProductCategory | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '839' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 37 | 0.0001 | ControllerProductCategory | SELECT * FROM oc_category c WHERE c.category_id = '839' |
| 38 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 39 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 40 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 41 | 0.0001 | ControllerProductCategory | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 42 | 0.0005 | ControllerProductCategory | SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '839' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 43 | 0.0002 | ControllerProductCategory | SELECT * FROM oc_category c WHERE c.category_id = '839' |
| 44 | 0.0002 | ControllerProductCategory | SELECT * FROM oc_category_to_layout WHERE category_id = '839' AND store_id = '0' |
| 45 | 0.0002 | ControllerProductCategory | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 46 | 0.0001 | ControllerProductCategory | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND `code` = 'ocfilter' |
| 47 | 0.0001 | ControllerProductCategory | SELECT c.category_id FROM oc_category c LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '839' AND c2s.store_id = '0' LIMIT 1 |
| 48 | 0.0017 | ControllerProductCategory | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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.quantity != '-1' AND p.catalog_output = '1' AND p2c.category_id = '839' |
| 49 | 0.004 | ControllerProductCategory | SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_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 oc_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 oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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.catalog_output = '1' AND p2c.category_id = '839' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 45,15 |
| 50 | 0.0007 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '105359' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 51 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '105358' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 52 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '105357' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 53 | 0.0005 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '155130' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 54 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '156601' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 55 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '157008' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 56 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '150605' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 57 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '151012' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 58 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '152457' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 59 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '138366' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 60 | 0.0006 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '139812' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 61 | 0.0005 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '140219' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 62 | 0.0007 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '141664' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 63 | 0.0008 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '108834' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 64 | 0.0008 | ControllerProductCategory | SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_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 oc_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 oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '118754' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 65 | 0.0011 | ControllerProductCategory | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '105359' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 66 | 0.0006 | ControllerProductCategory | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105359' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 67 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '105359' ORDER BY main_category DESC LIMIT 1 |
| 68 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 69 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 70 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 71 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=105359' LIMIT 1 |
| 72 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '105358' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 73 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105358' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 74 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '105358' ORDER BY main_category DESC LIMIT 1 |
| 75 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 76 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 77 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 78 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=105358' LIMIT 1 |
| 79 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '105357' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 80 | 0.0006 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '105357' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 81 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '105357' ORDER BY main_category DESC LIMIT 1 |
| 82 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 83 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 84 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 85 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=105357' LIMIT 1 |
| 86 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '155130' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 87 | 0.0006 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '155130' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 88 | 0.0002 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '155130' ORDER BY main_category DESC LIMIT 1 |
| 89 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 90 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 91 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 92 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=155130' LIMIT 1 |
| 93 | 0.001 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '156601' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 94 | 0.0008 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '156601' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 95 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '156601' ORDER BY main_category DESC LIMIT 1 |
| 96 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 97 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 98 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 99 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=156601' LIMIT 1 |
| 100 | 0.0012 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '157008' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 101 | 0.0008 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '157008' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 102 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '157008' ORDER BY main_category DESC LIMIT 1 |
| 103 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 104 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 105 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 106 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=157008' LIMIT 1 |
| 107 | 0.0009 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '150605' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 108 | 0.0009 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '150605' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 109 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '150605' ORDER BY main_category DESC LIMIT 1 |
| 110 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 111 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 112 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 113 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=150605' LIMIT 1 |
| 114 | 0.0009 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '151012' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 115 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '151012' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 116 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '151012' ORDER BY main_category DESC LIMIT 1 |
| 117 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 118 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 119 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 120 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=151012' LIMIT 1 |
| 121 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '152457' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 122 | 0.0006 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '152457' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 123 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '152457' ORDER BY main_category DESC LIMIT 1 |
| 124 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 125 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 126 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 127 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=152457' LIMIT 1 |
| 128 | 0.0009 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '138366' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 129 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '138366' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 130 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '138366' ORDER BY main_category DESC LIMIT 1 |
| 131 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 132 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 133 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 134 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=138366' LIMIT 1 |
| 135 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '139812' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 136 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '139812' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 137 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '139812' ORDER BY main_category DESC LIMIT 1 |
| 138 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 139 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 140 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 141 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=139812' LIMIT 1 |
| 142 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '140219' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 143 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '140219' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 144 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '140219' ORDER BY main_category DESC LIMIT 1 |
| 145 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 146 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 147 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 148 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=140219' LIMIT 1 |
| 149 | 0.0009 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '141664' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 150 | 0.0007 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '141664' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 151 | 0.0004 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '141664' ORDER BY main_category DESC LIMIT 1 |
| 152 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 153 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 154 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 155 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=141664' LIMIT 1 |
| 156 | 0.0011 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '108834' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 157 | 0.0007 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '108834' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 158 | 0.0004 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '108834' ORDER BY main_category DESC LIMIT 1 |
| 159 | 0.0002 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 160 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 161 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 162 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=108834' LIMIT 1 |
| 163 | 0.0008 | ControllerUniShopStickers | SELECT ag.attribute_group_id, agd.name, agd.tooltip FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '118754' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name LIMIT 1 |
| 164 | 0.0005 | ControllerUniShopStickers | SELECT a.attribute_id, ad.name, ad.tooltip, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '118754' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name LIMIT 3 |
| 165 | 0.0003 | ControllerUniShopStickers | SELECT category_id FROM oc_product_to_category WHERE product_id = '118754' ORDER BY main_category DESC LIMIT 1 |
| 166 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 167 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 168 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 169 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=118754' LIMIT 1 |
| 170 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 171 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 172 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 173 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 174 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 175 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 176 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 177 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 178 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 179 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 180 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 181 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 182 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 183 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 184 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 185 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 186 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 187 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 188 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 189 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 190 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 191 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 192 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 193 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 194 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 195 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 196 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 197 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 198 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 199 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 200 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 201 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 202 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 203 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 204 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 205 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 206 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 207 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 208 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 209 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 210 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 211 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 212 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 213 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 214 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 215 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 216 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 217 | 0.0001 | ControllerUniShopStickers | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 218 | 0.0002 | ControllerEventCompatibility | SELECT c.category_id FROM oc_category c LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '839' AND c2s.store_id = '0' LIMIT 1 |
| 219 | 0.0003 | ControllerEventCompatibility | SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM oc_category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM oc_url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM oc_ocfilter_page p LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '839' AND p.category = '1' ORDER BY p.page_id DESC |
| 220 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
| 221 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '376952915' |
| 222 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 223 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_category_to_layout WHERE category_id = '839' AND store_id = '0' |
| 224 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 225 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
| 226 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 227 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 228 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 229 | 0.0003 | ControllerEventCompatibility | SELECT CONCAT(f.filter_id, '.', f.source) AS filter_key FROM oc_ocfilter_filter f LEFT JOIN oc_ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source) LEFT JOIN oc_ocfilter_filter_to_category f2c ON (f.filter_id = f2c.filter_id) WHERE f.status = '1' AND f2s.store_id = '0' AND (f2c.category_id = '839' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source |
| 230 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '799108249' |
| 231 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3463394037' |
| 232 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2227517088' |
| 233 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1116309364' |
| 234 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2146021060' |
| 235 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '944362516' |
| 236 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3070828980' |
| 237 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2322139140' |
| 238 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1878850573' |
| 239 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1753499047' |
| 240 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3888427015' |
| 241 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3668220343' |
| 242 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2634343271' |
| 243 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1798838642' |
| 244 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '676231095' |
| 245 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3145798297' |
| 246 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '4230047817' |
| 247 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1830280939' |
| 248 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2080489485' |
| 249 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '186735218' |
| 250 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1260304742' |
| 251 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3501978889' |
| 252 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2804230137' |
| 253 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1209565721' |
| 254 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3552431734' |
| 255 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '811715008' |
| 256 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3121255658' |
| 257 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '1429680394' |
| 258 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3465706853' |
| 259 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3104616341' |
| 260 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '4282333823' |
| 261 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2899773125' |
| 262 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '2950491053' |
| 263 | 0.0001 | ControllerEventCompatibility | SELECT `value` FROM oc_ocfilter_cache WHERE `key` = '3628218717' |
| 264 | 0.0003 | ControllerEventCompatibility | SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM oc_category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM oc_url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM oc_ocfilter_page p LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p.category_id = '839' AND p.module = '1' ORDER BY p.page_id DESC |
| 265 | 0.0003 | ControllerCommonColumnRight | SELECT * FROM oc_category_to_layout WHERE category_id = '839' AND store_id = '0' |
| 266 | 0.0002 | ControllerCommonColumnRight | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 267 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 268 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_category_to_layout WHERE category_id = '839' AND store_id = '0' |
| 269 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 270 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 271 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM oc_category_to_layout WHERE category_id = '839' AND store_id = '0' |
| 272 | 0.0002 | ControllerCommonContentBottom | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 273 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 274 | 0.0003 | ControllerEventCompatibility | SELECT m.*, (SELECT description FROM oc_multi_modal_translate WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title, (SELECT description FROM oc_multi_modal_translate WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content FROM oc_multi_modals m WHERE m.status = 1 |
| 275 | 0.0002 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 276 | 0.0008 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_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 |
| 277 | 0.0002 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information_id=4' LIMIT 1 |
| 278 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information_id=3' LIMIT 1 |
| 279 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information_id=10' LIMIT 1 |
| 280 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information_id=11' LIMIT 1 |
| 281 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information_id=14' LIMIT 1 |
| 282 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 283 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/return/add' LIMIT 1 |
| 284 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/sitemap' LIMIT 1 |
| 285 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1 |
| 286 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/voucher' LIMIT 1 |
| 287 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'affiliate/account' LIMIT 1 |
| 288 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/special' LIMIT 1 |
| 289 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 290 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 291 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 292 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/newsletter' LIMIT 1 |
| 293 | 0.0002 | ControllerCommonHeader | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 294 | 0.0002 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 295 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 296 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 297 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 298 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 299 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1 |
| 300 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1 |
| 301 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 302 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/transaction' LIMIT 1 |
| 303 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/download' LIMIT 1 |
| 304 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 305 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 306 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |
| 307 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 308 | 0.0001 | ControllerExtensionAnalyticsGoogleAnalytics | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 309 | 0.0003 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/language/language' LIMIT 1 |
| 310 | 0.0002 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 311 | 0.0001 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 312 | 0.0001 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 313 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/currency/currency' LIMIT 1 |
| 314 | 0.0002 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=20' LIMIT 1 |
| 315 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=77' LIMIT 1 |
| 316 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=839' LIMIT 1 |
| 317 | 0.0009 | ControllerCommonSearch | SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_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) |
| 318 | 0.0002 | ControllerCommonCart | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '7cf405b61a2e6358d338ee1c56486f77' |
| 319 | 0.0001 | ControllerCommonCart | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 320 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '7cf405b61a2e6358d338ee1c56486f77' |
| 321 | 0.0003 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '7cf405b61a2e6358d338ee1c56486f77' |
| 322 | 0.0001 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '7cf405b61a2e6358d338ee1c56486f77' |
| 323 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '7cf405b61a2e6358d338ee1c56486f77' |
| 324 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 325 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |