| 0.00012707710266113 | SET time_zone = '+00:00' |
| 0.011620044708252 | DELETE FROM `oc_session` WHERE `expire` < '2025-05-28 02:49:30' |
| 0.00011706352233887 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
| 9.4175338745117E-5 | SET SQL_BIG_SELECTS = 1 |
| 0.001147985458374 | SHOW TABLES LIKE 'oc_ocfilter_setting' |
| 9.4890594482422E-5 | SELECT * FROM oc_ocfilter_setting |
| 0.00023603439331055 | SELECT `data` FROM `oc_session` WHERE `session_id` = '71f2a968298afd7d69fc9083a3' AND `expire` > '2025-05-28 02:49:30' |
| 0.00020480155944824 | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://santeho.com.ua/' |
| 6.7949295043945E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.103515625E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00046396255493164 | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 0.00012803077697754 | SET time_zone = '+03:00' |
| 8.2015991210938E-5 |
SELECT *
FROM `oc_regional_store` r_s
JOIN `oc_regional_store_settings` r_s_s ON r_s.`id` = r_s_s.`id_regional_store`
WHERE r_s.`domain` = 'https://santeho.com.ua/v-rovno/' OR r_s.`domain` = 'http://santeho.com.ua/v-rovno/' AND r_s.`status` = 1
LIMIT 1
|
| 7.2956085205078E-5 | SELECT value FROM oc_setting WHERE `key`='config_currency' |
| 5.4836273193359E-5 | SELECT * FROM oc_currency |
| 5.1975250244141E-5 | 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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3490') ORDER BY tr1.priority ASC |
| 6.0081481933594E-5 | 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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3490') ORDER BY tr1.priority ASC |
| 9.608268737793E-5 | 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' |
| 4.6014785766602E-5 | 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' |
| 0.00059795379638672 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) |
| 5.5074691772461E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 0.00030994415283203 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 7.1048736572266E-5 | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 0.0003359317779541 | SELECT language_id FROM oc_seo_url WHERE keyword = 'paialniki' AND store_id = '0' LIMIT 1 |
| 4.0054321289062E-5 | SELECT code FROM oc_language WHERE language_id = '2' AND status = '1' LIMIT 1 |
| 6.1988830566406E-5 | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.00019502639770508 | SELECT `value` FROM `oc_setting` WHERE `key` = 'config_language' |
| 8.2969665527344E-5 | SELECT * FROM oc_language WHERE status = '1' |
| 8.0108642578125E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
| 8.7976455688477E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 5.8889389038086E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/city' OR route = 'ru-ru') |
| 8.6069107055664E-5 | SELECT * FROM oc_regional_store_settings |
| 5.2928924560547E-5 | SELECT domain FROM oc_regional_store WHERE id = '1' |
| 3.6954879760742E-5 | SELECT domain FROM oc_regional_store WHERE id = '2' |
| 3.814697265625E-5 | SELECT domain FROM oc_regional_store WHERE id = '3' |
| 3.504753112793E-5 | SELECT domain FROM oc_regional_store WHERE id = '4' |
| 3.2901763916016E-5 | SELECT domain FROM oc_regional_store WHERE id = '5' |
| 3.504753112793E-5 | SELECT domain FROM oc_regional_store WHERE id = '6' |
| 3.2901763916016E-5 | SELECT domain FROM oc_regional_store WHERE id = '7' |
| 3.4093856811523E-5 | SELECT domain FROM oc_regional_store WHERE id = '8' |
| 5.3882598876953E-5 | SELECT domain FROM oc_regional_store WHERE id = '9' |
| 3.6001205444336E-5 | SELECT domain FROM oc_regional_store WHERE id = '10' |
| 3.6954879760742E-5 | SELECT domain FROM oc_regional_store WHERE id = '11' |
| 3.504753112793E-5 | SELECT domain FROM oc_regional_store WHERE id = '12' |
| 3.4093856811523E-5 | SELECT domain FROM oc_regional_store WHERE id = '13' |
| 3.6954879760742E-5 | SELECT domain FROM oc_regional_store WHERE id = '14' |
| 3.6001205444336E-5 | SELECT domain FROM oc_regional_store WHERE id = '15' |
| 3.7908554077148E-5 | SELECT domain FROM oc_regional_store WHERE id = '16' |
| 3.504753112793E-5 | SELECT domain FROM oc_regional_store WHERE id = '17' |
| 3.2901763916016E-5 | SELECT domain FROM oc_regional_store WHERE id = '18' |
| 3.4093856811523E-5 | SELECT domain FROM oc_regional_store WHERE id = '19' |
| 3.504753112793E-5 | SELECT domain FROM oc_regional_store WHERE id = '20' |
| 4.1961669921875E-5 | SELECT domain FROM oc_regional_store WHERE id = '21' |
| 3.8862228393555E-5 | SELECT domain FROM oc_regional_store WHERE id = '23' |
| 6.2942504882812E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/city' |
| 6.0796737670898E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.3882598876953E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.4863433837891E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 8.3208084106445E-5 | 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 = '216' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 6.8902969360352E-5 | 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 = '217' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.00051999092102051 | 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 = '341' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.00084400177001953 | SELECT p.product_id as product_id, p.price as price, p.currency_id as currency_id, p.tax_class_id as tax_class_id, pd.name as name FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category ptc ON (p.product_id = ptc.product_id) WHERE p.status = 1 AND p.price > 1 AND pd.language_id = 1 AND ptc.category_id = 341 ORDER BY p.price ASC LIMIT 3 |
| 0.0001060962677002 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 4.9829483032227E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 4.887580871582E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 0.00074291229248047 | SELECT p.product_id as product_id, p.price as price, p.currency_id as currency_id, p.tax_class_id as tax_class_id, pd.name as name FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category ptc ON (p.product_id = ptc.product_id) WHERE p.status = 1 AND p.price > 1 AND pd.language_id = 1 AND ptc.category_id = 341 ORDER BY p.viewed DESC LIMIT 3 |
| 5.6982040405273E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 6.5803527832031E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 4.5061111450195E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 0.0006868839263916 | SELECT p.product_id as product_id, p.price as price, p.currency_id as currency_id, p.tax_class_id as tax_class_id, pd.name as name FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category ptc ON (p.product_id = ptc.product_id) WHERE p.status = 1 AND p.price > 1 AND pd.language_id = 1 AND ptc.category_id = 341 ORDER BY p.date_added DESC LIMIT 3 |
| 5.6028366088867E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 4.9114227294922E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 0.00011277198791504 | SELECT keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.001121997833252 | 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 = '341' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.0002291202545166 | SELECT * FROM oc_category_to_layout WHERE category_id = '341' AND store_id = '0' |
| 7.6055526733398E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 9.1075897216797E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND `code` = 'ocfilter' |
| 0.00069189071655273 | 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 p2c.category_id = '341' |
| 0.0018172264099121 | 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 p2c.category_id = '341' GROUP BY p.product_id ORDER BY (p.quantity>0) DESC,p.sort_order DESC, LCASE(pd.name) DESC LIMIT 0,30 |
| 0.0011670589447021 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17502' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011110305786133 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17501' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011270046234131 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '15558' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010490417480469 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17500' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010511875152588 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17499' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010638236999512 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17090' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010809898376465 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17091' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010700225830078 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17096' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010528564453125 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17092' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010449886322021 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17095' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010590553283691 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17169' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010130405426025 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '15559' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010080337524414 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '15560' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010299682617188 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '17167' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00094413757324219 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '40113' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00089311599731445 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '16077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009000301361084 | SELECT DISTINCT *, pd.name AS name, p.image, p.currency_id, p.noindex AS noindex, m.name 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 pr.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 = '16078' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0001220703125 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.392333984375E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.1988830566406E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00027585029602051 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17502' ORDER BY main_category DESC LIMIT 1 |
| 0.00012493133544922 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 7.9870223999023E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.3896179199219E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00034713745117188 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17501' ORDER BY main_category DESC LIMIT 1 |
| 0.00014805793762207 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '262' AND md.language_id = '1' AND m2s.store_id = '0' |
| 9.7990036010742E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.7949295043945E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003211498260498 | SELECT category_id FROM oc_product_to_category WHERE product_id = '15558' ORDER BY main_category DESC LIMIT 1 |
| 0.00011610984802246 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.1062316894531E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.7220458984375E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00031113624572754 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17500' ORDER BY main_category DESC LIMIT 1 |
| 0.00013303756713867 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.392333984375E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.9856643676758E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00033402442932129 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17499' ORDER BY main_category DESC LIMIT 1 |
| 0.00014305114746094 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.8930130004883E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.2002410888672E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00028204917907715 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17090' ORDER BY main_category DESC LIMIT 1 |
| 9.8943710327148E-5 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 7.5101852416992E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 8.702278137207E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00021886825561523 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17091' ORDER BY main_category DESC LIMIT 1 |
| 8.7976455688477E-5 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 6.4849853515625E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.9127807617188E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002138614654541 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17096' ORDER BY main_category DESC LIMIT 1 |
| 8.7976455688477E-5 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 7.7962875366211E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 8.2015991210938E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00019598007202148 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17092' ORDER BY main_category DESC LIMIT 1 |
| 8.8930130004883E-5 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 6.4849853515625E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.2942504882812E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00025606155395508 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17095' ORDER BY main_category DESC LIMIT 1 |
| 0.00010323524475098 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.2015991210938E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.5101852416992E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00021195411682129 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17169' ORDER BY main_category DESC LIMIT 1 |
| 0.00018095970153809 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '262' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.4161758422852E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0001370906829834 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004580020904541 | SELECT category_id FROM oc_product_to_category WHERE product_id = '15559' ORDER BY main_category DESC LIMIT 1 |
| 0.00014710426330566 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '262' AND md.language_id = '1' AND m2s.store_id = '0' |
| 0.00011110305786133 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.319450378418E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00028896331787109 | SELECT category_id FROM oc_product_to_category WHERE product_id = '15560' ORDER BY main_category DESC LIMIT 1 |
| 0.00010490417480469 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '329' AND md.language_id = '1' AND m2s.store_id = '0' |
| 9.2983245849609E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.4148178100586E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00024199485778809 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17167' ORDER BY main_category DESC LIMIT 1 |
| 0.0001070499420166 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '319' AND md.language_id = '1' AND m2s.store_id = '0' |
| 0.00011396408081055 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.1048736572266E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00024604797363281 | SELECT category_id FROM oc_product_to_category WHERE product_id = '40113' ORDER BY main_category DESC LIMIT 1 |
| 0.00011587142944336 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '313' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.392333984375E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.2002410888672E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00025010108947754 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16077' ORDER BY main_category DESC LIMIT 1 |
| 0.00014495849609375 | SELECT DISTINCT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '313' AND md.language_id = '1' AND m2s.store_id = '0' |
| 8.6784362792969E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.6995620727539E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00029611587524414 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16078' ORDER BY main_category DESC LIMIT 1 |
| 0.21660208702087 | SELECT p.price,
(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_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE cp.path_id = '341'
AND p.status = 1
AND p.price > 0
AND p2s.store_id = '0'
AND p.date_available <= '2025-05-28' |
| 0.00012302398681641 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/microdatapro/category_manufacturer' |
| 9.3936920166016E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.6995620727539E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.1062316894531E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocfilter' OR route = 'ru-ru') |
| 0.00036811828613281 | 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 su.keyword FROM oc_seo_url su WHERE su.language_id = '1' AND su.store_id = '0' AND su.`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 = '341' AND p.category = '1' ORDER BY p.page_id DESC |
| 7.9154968261719E-5 | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
| 0.00036716461181641 | SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2025-05-28' AND p.quantity > '0' AND p2c.category_id = '341' GROUP BY vid |
| 0.00034189224243164 | SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid FROM oc_ocfilter_filter_value_to_product fv2p LEFT JOIN oc_product p ON (fv2p.product_id = p.product_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= '2025-05-28' AND p.quantity > '0' AND p2c.category_id = '341' GROUP BY fk, vid |
| 9.7990036010742E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.3896179199219E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '341' AND store_id = '0' |
| 8.6069107055664E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 6.4849853515625E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
| 6.7949295043945E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocfilter' OR route = 'ru-ru') |
| 0.00035810470581055 | 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 = '341' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source |
| 0.00024509429931641 | SELECT * FROM oc_ocfilter_filter f LEFT JOIN oc_ocfilter_filter_description fd ON (f.filter_id = fd.filter_id AND f.source = fd.source) WHERE f.filter_id = '3823' AND f.source = '2' AND f.status = '1' AND fd.language_id = '1' |
| 0.0002129077911377 | SELECT * FROM oc_ocfilter_filter f LEFT JOIN oc_ocfilter_filter_description fd ON (f.filter_id = fd.filter_id AND f.source = fd.source) WHERE f.filter_id = '4135' AND f.source = '2' AND f.status = '1' AND fd.language_id = '1' |
| 0.00067496299743652 | SELECT MIN(price) AS `min`, MAX(price) AS `max` FROM (SELECT p.price FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.price > '0' AND p.status = '1' AND p.date_available <= '2025-05-28' AND p.quantity > '0' AND p2c.category_id = '341') result |
| 0.00092315673828125 | SELECT fv.value_id, fv.color, fv.image, fvd.name FROM oc_ocfilter_filter_value fv LEFT JOIN oc_ocfilter_filter_value_description fvd ON (fv.value_id = fvd.value_id AND fv.source = fvd.source) WHERE fv.filter_id = '3823' AND fv.source = '2' AND fvd.language_id = '1' ORDER BY fv.sort_order, (fvd.name = '-') DESC, (fvd.name = '0') DESC, (fvd.name + 0 > 0) DESC, (fvd.name + 0), IF(CONCAT('', (SUBSTRING(fvd.name, 1, 1) * 1)) = SUBSTRING(fvd.name, 1, 1), LENGTH(fvd.name), 1), fvd.name |
| 0.00043702125549316 | SELECT fv.value_id, fv.color, fv.image, fvd.name FROM oc_ocfilter_filter_value fv LEFT JOIN oc_ocfilter_filter_value_description fvd ON (fv.value_id = fvd.value_id AND fv.source = fvd.source) WHERE fv.filter_id = '4135' AND fv.source = '2' AND fvd.language_id = '1' ORDER BY fv.sort_order, (fvd.name = '-') DESC, (fvd.name = '0') DESC, (fvd.name + 0 > 0) DESC, (fvd.name + 0), IF(CONCAT('', (SUBSTRING(fvd.name, 1, 1) * 1)) = SUBSTRING(fvd.name, 1, 1), LENGTH(fvd.name), 1), fvd.name |
| 0.00048279762268066 | 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 su.keyword FROM oc_seo_url su WHERE su.language_id = '1' AND su.store_id = '0' AND su.`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 = '341' AND p.module = '1' ORDER BY p.page_id DESC |
| 0.00012302398681641 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/ocfilter48/module' |
| 9.5844268798828E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 0.00010108947753906 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.5830688476562E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/column_left' |
| 7.176399230957E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.7009201049805E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.082389831543E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '341' AND store_id = '0' |
| 6.8902969360352E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 7.2002410888672E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 6.7949295043945E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/column_right' |
| 6.7949295043945E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.5101852416992E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.7962875366211E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '341' AND store_id = '0' |
| 6.8902969360352E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 7.0095062255859E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 8.6069107055664E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/search_suggestion' |
| 6.8902969360352E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.2002410888672E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.2969665527344E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/content_top' |
| 6.7949295043945E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.0095062255859E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.9883804321289E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '341' AND store_id = '0' |
| 6.7949295043945E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 6.6041946411133E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 6.7949295043945E-5 | SELECT * FROM oc_module WHERE module_id = '34' |
| 7.7962875366211E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/content_bottom' |
| 7.0095062255859E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.7949295043945E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.7962875366211E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/buyoneclick' OR route = 'ru-ru') |
| 7.4863433837891E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru') |
| 7.2002410888672E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 0.00012683868408203 | 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 |
| 7.7962875366211E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/microdatapro/company' |
| 6.6995620727539E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.2002410888672E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.2969665527344E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.6041946411133E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.1988830566406E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.793571472168E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.6028366088867E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.2002410888672E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.00053000450134277 | DELETE FROM `oc_customer_online` WHERE date_added < '2025-05-28 04:49:31' |
| 0.0001990795135498 | REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.34', `customer_id` = '0', `url` = 'https://santeho.com.ua/v-rovno/instrument/elektroinstrument/paialniki', `referer` = '', `date_added` = '2025-05-28 05:49:31' |
| 9.3936920166016E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/footer' |
| 8.702278137207E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.7009201049805E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00014209747314453 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/widget_multi_connect' OR route = 'ru-ru') |
| 8.5115432739258E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/widget_multi_connect' |
| 6.7949295043945E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.4849853515625E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 9.2029571533203E-5 | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 0.00011301040649414 | 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 |
| 8.2015991210938E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
| 7.1048736572266E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 6.5088272094727E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 6.413459777832E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 7.2956085205078E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 7.8916549682617E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.7922134399414E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.6041946411133E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.1021575927734E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.5088272094727E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/transaction' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/download' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.9127807617188E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.2915344238281E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 8.1062316894531E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 6.6995620727539E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 9.2029571533203E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/language' |
| 0.00010299682617188 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.2002410888672E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00012111663818359 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 8.1777572631836E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0001068115234375 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/currency' |
| 7.1048736572266E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.4849853515625E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.1062316894531E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 6.5088272094727E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 8.392333984375E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/currency' |
| 6.1988830566406E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.2002410888672E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 6.8902969360352E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru') |
| 0.011459827423096 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 0.00014996528625488 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/search' |
| 0.00012707710266113 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 0.00011014938354492 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 9.4890594482422E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru') |
| 8.8930130004883E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 8.082389831543E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 7.5101852416992E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 7.7962875366211E-5 | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 0.00098705291748047 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
| 8.8930130004883E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 5.2928924560547E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 0.00010991096496582 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
| 5.4121017456055E-5 | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 0.00011205673217773 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
| 7.5817108154297E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 6.7949295043945E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 7.1048736572266E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 6.3180923461914E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '71f2a968298afd7d69fc9083a3' |
| 6.1988830566406E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 5.8889389038086E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 6.9856643676758E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/cart' |
| 6.5088272094727E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.7949295043945E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.8214874267578E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru') |
| 0.00017690658569336 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'stroimarket/stroimarket' OR route = 'ru-ru') |
| 0.00016307830810547 | 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) |
| 0.00015497207641602 | 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 = '146' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.2969665527344E-5 | 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 = '169' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010395050048828 | 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 = '269' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011491775512695 | 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 = '149' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.7990036010742E-5 | 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 = '166' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011110305786133 | 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 = '130' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.0837478637695E-5 | 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 = '190' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00052404403686523 | 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 = '168' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00012683868408203 | 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 = '193' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011301040649414 | 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 = '714' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.702278137207E-5 | 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 = '153' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011396408081055 | 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 = '160' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00012707710266113 | 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 = '365' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011205673217773 | 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 = '1380' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.3936920166016E-5 | 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 = '175' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.5844268798828E-5 | 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 = '187' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00013399124145508 | 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 = '156' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00013399124145508 | 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 = '1155' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00017786026000977 | 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 = '216' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010395050048828 | 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 = '228' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.7036361694336E-5 | 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 = '1373' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00012707710266113 | 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 = '243' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010013580322266 | 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 = '394' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00033211708068848 | 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 = '217' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00014686584472656 | 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 = '100' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.2029571533203E-5 | 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 = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00013184547424316 | 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 = '115' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.0001368522644043 | 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 = '102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.918212890625E-5 | 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 = '389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.3936920166016E-5 | 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 = '116' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.3936920166016E-5 | 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 = '358' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00013399124145508 | 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 = '373' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010204315185547 | 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 = '338' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010895729064941 | 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 = '342' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00017094612121582 | 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 = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010299682617188 | 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 = '309' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011706352233887 | 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 = '374' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00015711784362793 | 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 = '108' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010013580322266 | 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 = '109' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.6055526733398E-5 | 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 = '335' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010895729064941 | 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 = '364' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.3909759521484E-5 | 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 = '82' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7009201049805E-5 | 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 = '143' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7009201049805E-5 | 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 = '275' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.1075897216797E-5 | 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 = '142' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7962875366211E-5 | 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 = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.5129013061523E-5 | 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 = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011706352233887 | 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 = '196' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.6055526733398E-5 | 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 = '144' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.9154968261719E-5 | 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 = '197' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.4148178100586E-5 | 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 = '209' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.8201293945312E-5 | 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 = '203' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.4148178100586E-5 | 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 = '113' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.5115432739258E-5 | 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 = '212' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.0095062255859E-5 | 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 = '201' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.0095062255859E-5 | 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 = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.9856643676758E-5 | 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 = '204' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010395050048828 | 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 = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010204315185547 | 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 = '268' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.6041946411133E-5 | 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 = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.5817108154297E-5 | 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 = '84' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.7036361694336E-5 | 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 = '336' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7962875366211E-5 | 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 = '215' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.8902969360352E-5 | 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 = '340' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.9897384643555E-5 | 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 = '345' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.3909759521484E-5 | 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 = '292' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00012803077697754 | 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 = '202' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7962875366211E-5 | 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 = '381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.0001220703125 | 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 = '350' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011992454528809 | 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 = '380' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.0122222900391E-5 | 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 = '376' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.8943710327148E-5 | 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 = '378' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.3221664428711E-5 | 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 = '306' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.7036361694336E-5 | 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 = '379' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7009201049805E-5 | 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 = '271' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.2969665527344E-5 | 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 = '1364' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.6055526733398E-5 | 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 = '1379' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.7990036010742E-5 | 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 = '264' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.6995620727539E-5 | 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 = '205' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.2002410888672E-5 | 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 = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011897087097168 | 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 = '265' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.9154968261719E-5 | 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 = '286' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.5817108154297E-5 | 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 = '712' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.2002410888672E-5 | 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 = '257' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.1048736572266E-5 | 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 = '266' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010299682617188 | 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 = '256' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.8916549682617E-5 | 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 = '167' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.9856643676758E-5 | 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 = '141' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7962875366211E-5 | 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 = '298' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00010085105895996 | 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 = '363' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.319450378418E-5 | 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 = '718' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7009201049805E-5 | 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 = '715' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011515617370605 | 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 = '1381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.6055526733398E-5 | 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 = '295' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.4849853515625E-5 | 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 = '719' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00011610984802246 | 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 = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.0810317993164E-5 | 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 = '395' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 9.4890594482422E-5 | 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 = '371' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00017905235290527 | 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 = '372' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.7962875366211E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/menu' |
| 8.2015991210938E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.4849853515625E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 9.608268737793E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/header' |
| 5.4121017456055E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 0.00010490417480469 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.2956085205078E-5 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
| 4.6014785766602E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'product/category' |
| 4.4107437133789E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.3167343139648E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.0108642578125E-5 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
Аккумуляторные кусторезы
Аксессуары для садовой техники
Бензопилы
Дровоколы
Инкубаторы
Комбисистемы для сада
Кормоизмельчители
Мотобуры
Садовая мебель
Садовые измельчители веток
Садовые пылесосы
Сельхозтехника
Сеялки садовые
Снегоуборочные машины (Снегоуборщик)
Тракторы для стрижки газона
Электрические высоторезы
Электропилы
Аккумуляторные инструменты
Осушители воздуха
Ручной инструмент
Тельферы
Электроинструмент
Бетономешалки
Глубинные вибраторы
Дорожная техника
Керноотборники
Лазерная техника
Пилорамы
Пневмооборудование
Прожекторы
Рабочая одежда
Сварочное оборудование
Складское оборудование
Станки
Станочное оборудование
Стремянки
Удлинители электрические
Агрегаты бесперебойного питания АБП
Аккумуляторные батареи
Инверторы для солнечных электростанций
Источники бесперебойного питания
Преобразователи частоты
Стабилизаторы напряжения
АВР для генератора
Бензиновые генераторы
Газовые генераторы
Дизельные генераторы
Дизельные генераторы большой мощности
Инверторные генераторы
Комплект работы на газу
Распределитель электропитания
Сварочные генераторы
Автомобильный компрессор
Зарядное устройство для автомобильного аккумулятора
Инструмент для СТО
Оборудование для техосмотра
Пояс для инструмента
Шиномонтажные станки
Ящики для инструментов
Аксессуары для бытовой техники
Биокамины
Климатическая техника
Крупная бытовая техника
Мелкая бытовая техника
Телевизоры
Техника для кухни
Электровентилятор
Автопогрузчик
Велосипеды
Квадроцикл
Мотоцикл
Самокаты
Сигвей
Скутеры
Газовые баллоны
Промышленные обогреватели
Солнечные коллекторы
Детские бассейны
Детские электромобили
Инфракрасные сауны
Посуда
Садовые грили
Системы очистки воды
Смесители
Тепловое оборудование
Уборочная техника