| 0.00018000602722168 | SET time_zone = '+00:00' |
| 0.013726949691772 | DELETE FROM `oc_session` WHERE `expire` < '2025-05-28 12:40:33' |
| 0.00017714500427246 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
| 0.00011396408081055 | SET SQL_BIG_SELECTS = 1 |
| 0.00064897537231445 | SHOW TABLES LIKE 'oc_ocfilter_setting' |
| 0.00010299682617188 | SELECT * FROM oc_ocfilter_setting |
| 0.00027108192443848 | SELECT `data` FROM `oc_session` WHERE `session_id` = 'fa3cda0016a0028ecad1c9438e' AND `expire` > '2025-05-28 12:40:33' |
| 8.392333984375E-5 | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://santeho.com.ua/' |
| 9.2029571533203E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 0.00011110305786133 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00066995620727539 | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 0.00015997886657715 | SET time_zone = '+03:00' |
| 0.00012803077697754 |
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-poltave/' OR r_s.`domain` = 'http://santeho.com.ua/v-poltave/' AND r_s.`status` = 1
LIMIT 1
|
| 0.00014495849609375 | SELECT value FROM oc_setting WHERE `key`='config_currency' |
| 9.0837478637695E-5 | SELECT * FROM oc_currency |
| 9.8228454589844E-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 |
| 7.9870223999023E-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 |
| 8.6069107055664E-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' |
| 0.00010299682617188 | 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.00051283836364746 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) |
| 7.5817108154297E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 0.00037693977355957 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 9.1075897216797E-5 | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 7.1048736572266E-5 | SELECT language_id FROM oc_seo_url WHERE keyword = 'svarochnoe-oborudovanie' AND store_id = '0' LIMIT 1 |
| 6.2942504882812E-5 | SELECT code FROM oc_language WHERE language_id = '1' AND status = '1' LIMIT 1 |
| 6.1988830566406E-5 | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.00013113021850586 | SELECT `value` FROM `oc_setting` WHERE `key` = 'config_language' |
| 6.0081481933594E-5 | SELECT * FROM oc_language WHERE status = '1' |
| 6.8902969360352E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'uk-ua') |
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/city' OR route = 'uk-ua') |
| 5.793571472168E-5 | SELECT * FROM oc_regional_store_settings |
| 5.1975250244141E-5 | SELECT domain FROM oc_regional_store WHERE id = '1' |
| 4.6014785766602E-5 | SELECT domain FROM oc_regional_store WHERE id = '2' |
| 4.3153762817383E-5 | SELECT domain FROM oc_regional_store WHERE id = '3' |
| 4.4107437133789E-5 | SELECT domain FROM oc_regional_store WHERE id = '4' |
| 4.3869018554688E-5 | SELECT domain FROM oc_regional_store WHERE id = '5' |
| 4.2915344238281E-5 | SELECT domain FROM oc_regional_store WHERE id = '6' |
| 4.3153762817383E-5 | SELECT domain FROM oc_regional_store WHERE id = '7' |
| 4.3153762817383E-5 | SELECT domain FROM oc_regional_store WHERE id = '8' |
| 4.2915344238281E-5 | SELECT domain FROM oc_regional_store WHERE id = '9' |
| 4.5061111450195E-5 | SELECT domain FROM oc_regional_store WHERE id = '10' |
| 4.4107437133789E-5 | SELECT domain FROM oc_regional_store WHERE id = '11' |
| 4.887580871582E-5 | SELECT domain FROM oc_regional_store WHERE id = '12' |
| 4.5061111450195E-5 | SELECT domain FROM oc_regional_store WHERE id = '13' |
| 4.3869018554688E-5 | SELECT domain FROM oc_regional_store WHERE id = '14' |
| 4.4107437133789E-5 | SELECT domain FROM oc_regional_store WHERE id = '15' |
| 4.4107437133789E-5 | SELECT domain FROM oc_regional_store WHERE id = '16' |
| 4.2915344238281E-5 | SELECT domain FROM oc_regional_store WHERE id = '17' |
| 4.3869018554688E-5 | SELECT domain FROM oc_regional_store WHERE id = '18' |
| 4.4107437133789E-5 | SELECT domain FROM oc_regional_store WHERE id = '19' |
| 5.4121017456055E-5 | SELECT domain FROM oc_regional_store WHERE id = '20' |
| 4.2915344238281E-5 | SELECT domain FROM oc_regional_store WHERE id = '21' |
| 4.4822692871094E-5 | SELECT domain FROM oc_regional_store WHERE id = '23' |
| 5.1021575927734E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/city' |
| 5.4121017456055E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 6.3180923461914E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 5.5074691772461E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 8.1062316894531E-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 = '100' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' |
| 6.103515625E-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 = '118' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0097799301147461 | 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 = 2 AND ptc.category_id = 118 ORDER BY p.price ASC LIMIT 3 |
| 0.0033330917358398 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 6.6041946411133E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 0.0099380016326904 | 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 = 2 AND ptc.category_id = 118 ORDER BY p.viewed DESC LIMIT 3 |
| 0.00026202201843262 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 6.103515625E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 4.4107437133789E-5 | SELECT value FROM oc_currency WHERE currency_id = 2 LIMIT 1 |
| 0.012784004211426 | 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 = 2 AND ptc.category_id = 118 ORDER BY p.date_added DESC LIMIT 3 |
| 8.702278137207E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 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 = '118' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 4.4107437133789E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '118' AND store_id = '0' |
| 4.4822692871094E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 4.6014785766602E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND `code` = 'ocfilter' |
| 0.69973516464233 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '136' |
| 0.69215297698975 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '132' |
| 0.65503311157227 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '127' |
| 0.67805099487305 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '121' |
| 0.54884791374207 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '390' |
| 0.43365287780762 | SELECT COUNT(DISTINCT p.product_id) AS total 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_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '119' |
| 0.013482093811035 | 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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '118' |
| 0.018376111984253 | 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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '118' GROUP BY p.product_id ORDER BY (p.quantity>0) DESC,p.sort_order DESC, LCASE(pd.name) DESC LIMIT 0,30 |
| 0.0010020732879639 | 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 = '2') 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 = '2') 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 = '2') 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 = '16097' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00099802017211914 | 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 = '2') 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 = '2') 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 = '2') 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 = '17034' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00055789947509766 | 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 = '2') 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 = '2') 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 = '2') 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 = '14855' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00051498413085938 | 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 = '2') 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 = '2') 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 = '2') 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 = '16351' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00055313110351562 | 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 = '2') 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 = '2') 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 = '2') 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 = '17015' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00055193901062012 | 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 = '2') 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 = '2') 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 = '2') 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 = '16641' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0005040168762207 | 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 = '2') 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 = '2') 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 = '2') 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 = '16949' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00051116943359375 | 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 = '2') 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 = '2') 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 = '2') 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 = '17019' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0005028247833252 | 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 = '2') 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 = '2') 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 = '2') 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 = '9317' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00051093101501465 | 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 = '2') 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 = '2') 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 = '2') 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 = '17025' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00051093101501465 | 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 = '2') 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 = '2') 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 = '2') 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 = '17582' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00052499771118164 | 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 = '2') 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 = '2') 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 = '2') 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 = '17040' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00053310394287109 | 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 = '2') 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 = '2') 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 = '2') 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 = '16988' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00050711631774902 | 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 = '2') 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 = '2') 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 = '2') 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 = '7553' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00049996376037598 | 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 = '2') 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 = '2') 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 = '2') 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 = '17064' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00050783157348633 | 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 = '2') 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 = '2') 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 = '2') 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 = '17581' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00050091743469238 | 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 = '2') 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 = '2') 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 = '2') 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 = '17035' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00049614906311035 | 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 = '2') 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 = '2') 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 = '2') 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 = '7393' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00050997734069824 | 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 = '2') 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 = '2') 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 = '2') 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 = '17017' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00060606002807617 | 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 = '2') 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 = '2') 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 = '2') 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 = '17042' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00069189071655273 | 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 = '2') 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 = '2') 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 = '2') 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 = '16350' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0010159015655518 | 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 = '2') 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 = '2') 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 = '2') 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 = '17039' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00057411193847656 | 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 = '2') 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 = '2') 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 = '2') 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 = '16348' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0006260871887207 | 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 = '2') 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 = '2') 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 = '2') 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 = '16950' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00052905082702637 | 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 = '2') 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 = '2') 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 = '2') 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 = '17020' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00055813789367676 | 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 = '2') 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 = '2') 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 = '2') 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 = '16349' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00056004524230957 | 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 = '2') 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 = '2') 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 = '2') 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 = '17058' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0005340576171875 | 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 = '2') 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 = '2') 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 = '2') 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 = '17063' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00057387351989746 | 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 = '2') 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 = '2') 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 = '2') 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 = '16397' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00057196617126465 | 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 = '2') 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 = '2') 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 = '2') 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 = '17057' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.00011777877807617 | 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 = '62' AND md.language_id = '2' AND m2s.store_id = '0' |
| 6.2942504882812E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.1007995605469E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 9.7990036010742E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16097' ORDER BY main_category DESC LIMIT 1 |
| 0.0016400814056396 | 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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 7.6055526733398E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.1007995605469E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.9141387939453E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17034' ORDER BY main_category DESC LIMIT 1 |
| 7.4863433837891E-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 = '62' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.2928924560547E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 3.8862228393555E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00011301040649414 | SELECT category_id FROM oc_product_to_category WHERE product_id = '14855' ORDER BY main_category DESC LIMIT 1 |
| 0.0002598762512207 | 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 = '85' AND md.language_id = '2' AND m2s.store_id = '0' |
| 6.7949295043945E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.2928924560547E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 9.7990036010742E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16351' ORDER BY main_category DESC LIMIT 1 |
| 0.00010514259338379 | 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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 6.413459777832E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1021575927734E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.7009201049805E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17015' ORDER BY main_category DESC LIMIT 1 |
| 0.00011491775512695 | 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 = '62' AND md.language_id = '2' AND m2s.store_id = '0' |
| 8.5830688476562E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1975250244141E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 8.4877014160156E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16641' ORDER BY main_category DESC LIMIT 1 |
| 8.702278137207E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.9843063354492E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.6028366088867E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 9.9897384643555E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16949' ORDER BY main_category DESC LIMIT 1 |
| 7.0810317993164E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.2928924560547E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.0016279220581055 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17019' ORDER BY main_category DESC LIMIT 1 |
| 7.8201293945312E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 6.5803527832031E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.4148178100586E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.2002410888672E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '9317' ORDER BY main_category DESC LIMIT 1 |
| 0.00010013580322266 | 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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 6.7949295043945E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.3180923461914E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.5101852416992E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17025' ORDER BY main_category DESC LIMIT 1 |
| 9.4890594482422E-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 = '2' AND m2s.store_id = '0' |
| 7.0095062255859E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.9141387939453E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.0040738582611084 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17582' ORDER BY main_category DESC LIMIT 1 |
| 8.702278137207E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 7.3909759521484E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 3.9100646972656E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.8889389038086E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17040' ORDER BY main_category DESC LIMIT 1 |
| 0.00012087821960449 | 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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 0.00021100044250488 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 8.0108642578125E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16988' ORDER BY main_category DESC LIMIT 1 |
| 0.0025999546051025 | 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 = '18' AND md.language_id = '2' 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 = '2' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.2956085205078E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '7553' ORDER BY main_category DESC LIMIT 1 |
| 7.1048736572266E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.3869018554688E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 3.504753112793E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.0018579959869385 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17064' ORDER BY main_category DESC LIMIT 1 |
| 9.7036361694336E-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 = '2' 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 = '2' LIMIT 1 |
| 5.9843063354492E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00065302848815918 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17581' ORDER BY main_category DESC LIMIT 1 |
| 0.00076699256896973 | 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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 8.7976455688477E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.8902969360352E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00011491775512695 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17035' ORDER BY main_category DESC LIMIT 1 |
| 0.0015881061553955 | 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 = '170' AND md.language_id = '2' AND m2s.store_id = '0' |
| 0.00052905082702637 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.4121017456055E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.6028366088867E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '7393' ORDER BY main_category DESC LIMIT 1 |
| 6.3896179199219E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.1975250244141E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1021575927734E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.6028366088867E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17017' ORDER BY main_category DESC LIMIT 1 |
| 5.9843063354492E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.1975250244141E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.9114227294922E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.103515625E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17042' ORDER BY main_category DESC LIMIT 1 |
| 0.00011706352233887 | 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 = '85' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.793571472168E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.887580871582E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.2942504882812E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16350' ORDER BY main_category DESC LIMIT 1 |
| 6.5088272094727E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 5.1975250244141E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.1988830566406E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00011897087097168 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17039' ORDER BY main_category DESC LIMIT 1 |
| 7.5817108154297E-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 = '85' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.7922134399414E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4822692871094E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16348' ORDER BY main_category DESC LIMIT 1 |
| 5.3167343139648E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.3869018554688E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4822692871094E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16950' ORDER BY main_category DESC LIMIT 1 |
| 4.9829483032227E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.2956085205078E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.7922134399414E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17020' ORDER BY main_category DESC LIMIT 1 |
| 5.5074691772461E-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 = '23' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.1961669921875E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1975250244141E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16349' ORDER BY main_category DESC LIMIT 1 |
| 5.5074691772461E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.2915344238281E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17058' ORDER BY main_category DESC LIMIT 1 |
| 5.1975250244141E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17063' ORDER BY main_category DESC LIMIT 1 |
| 5.2928924560547E-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 = '23' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.4107437133789E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.2915344238281E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '16397' ORDER BY main_category DESC LIMIT 1 |
| 5.1975250244141E-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 = '37' AND md.language_id = '2' AND m2s.store_id = '0' |
| 4.4822692871094E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.3153762817383E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.6982040405273E-5 | SELECT category_id FROM oc_product_to_category WHERE product_id = '17057' ORDER BY main_category DESC LIMIT 1 |
| 6.3180923461914E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/microdatapro/category_manufacturer' |
| 4.6014785766602E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 4.7922134399414E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 4.9829483032227E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua') |
| 0.00050187110900879 | 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 = '2' 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 = '2' AND p.category_id = '118' AND p.category = '1' ORDER BY p.page_id DESC |
| 4.4822692871094E-5 | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '118' AND store_id = '0' |
| 4.57763671875E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 4.6968460083008E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
| 4.6968460083008E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua') |
| 6.8902969360352E-5 | 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 = '118' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source |
| 0.00027799606323242 | 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 = '21' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00025296211242676 | 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 = '160' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022506713867188 | 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 = '167' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022482872009277 | 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 = '168' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022196769714355 | 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 = '169' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 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 = '276' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00024986267089844 | 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 = '356' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00020909309387207 | 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 = '357' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022697448730469 | 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 = '358' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023484230041504 | 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 = '359' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0002448558807373 | 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 = '360' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00021886825561523 | 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 = '361' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00025582313537598 | 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 = '362' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00031280517578125 | 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 = '363' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00038790702819824 | 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 = '441' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0002739429473877 | 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 = '448' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00036716461181641 | 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 = '449' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00040698051452637 | 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 = '450' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00026106834411621 | 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 = '501' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0004570484161377 | 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 = '951' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00034093856811523 | 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 = '1155' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00039410591125488 | 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 = '1497' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00037693977355957 | 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 = '1539' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00027894973754883 | 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 = '1540' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00026798248291016 | 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 = '1541' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00021481513977051 | 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 = '1542' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00028681755065918 | 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 = '1543' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00032496452331543 | 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 = '1544' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00033807754516602 | 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 = '1545' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023198127746582 | 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 = '1547' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0003201961517334 | 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 = '1644' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00036907196044922 | 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 = '1645' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019383430480957 | 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 = '1646' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00031089782714844 | 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 = '1647' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018095970153809 | 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 = '1648' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0001671314239502 | 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 = '1649' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017905235290527 | 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 = '1650' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017595291137695 | 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 = '1651' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019979476928711 | 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 = '1652' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00025796890258789 | 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 = '1653' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017404556274414 | 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 = '1654' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019693374633789 | 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 = '1655' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017499923706055 | 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 = '1656' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017189979553223 | 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 = '1657' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018715858459473 | 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 = '1658' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018191337585449 | 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 = '1659' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022006034851074 | 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 = '1758' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00024199485778809 | 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 = '1760' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018692016601562 | 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 = '1762' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00020408630371094 | 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 = '1763' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018310546875 | 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 = '1787' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017309188842773 | 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 = '1788' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017690658569336 | 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 = '1789' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00016117095947266 | 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 = '1790' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0001680850982666 | 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 = '1791' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00020384788513184 | 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 = '1792' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0001990795135498 | 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 = '1793' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022387504577637 | 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 = '1913' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00024199485778809 | 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 = '1914' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0001990795135498 | 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 = '1915' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00029802322387695 | 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 = '2011' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0004270076751709 | 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 = '4218' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022315979003906 | 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 = '4219' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00024008750915527 | 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 = '4220' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019192695617676 | 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 = '4221' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023913383483887 | 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 = '4222' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00020003318786621 | 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 = '4223' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023794174194336 | 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 = '4224' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00018787384033203 | 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 = '4225' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019288063049316 | 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 = '4226' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00024986267089844 | 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 = '4227' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00019097328186035 | 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 = '4228' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023698806762695 | 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 = '4288' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0002899169921875 | 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 = '4452' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00029087066650391 | 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 = '4453' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00017714500427246 | 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 = '4454' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0002439022064209 | 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 = '4455' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0001988410949707 | 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 = '4456' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00023508071899414 | 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 = '4457' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00022792816162109 | 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 = '4458' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00040507316589355 | 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 = '4459' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00028681755065918 | 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 = '4460' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0099499225616455 | 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 = '4461' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00038790702819824 | 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 = '4465' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0003659725189209 | 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 = '4769' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00030779838562012 | 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 = '4770' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0027649402618408 | 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 = '4771' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00038480758666992 | 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 = '4772' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0006260871887207 | 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 = '4790' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0004580020904541 | 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 = '4791' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0005030632019043 | 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 = '4792' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00037598609924316 | 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 = '4793' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0004580020904541 | 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 = '4800' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00051999092102051 | 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 = '5454' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00038790702819824 | 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 = '5494' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00054788589477539 | 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 = '6222' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.00030899047851562 | 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 = '6223' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 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 = '6224' AND f.source = '2' AND f.status = '1' AND fd.language_id = '2' |
| 0.0015280246734619 | 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 = '21' AND fv.source = '2' AND fvd.language_id = '2' 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.00035500526428223 | 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 = '160' AND fv.source = '2' AND fvd.language_id = '2' 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.00051283836364746 | 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 = '167' AND fv.source = '2' AND fvd.language_id = '2' 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.00037908554077148 | 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 = '168' AND fv.source = '2' AND fvd.language_id = '2' 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.0010161399841309 | 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 = '169' AND fv.source = '2' AND fvd.language_id = '2' 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.00034713745117188 | 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 = '276' AND fv.source = '2' AND fvd.language_id = '2' 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.00065898895263672 | 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 = '356' AND fv.source = '2' AND fvd.language_id = '2' 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.00037717819213867 | 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 = '357' AND fv.source = '2' AND fvd.language_id = '2' 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.00031709671020508 | 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 = '358' AND fv.source = '2' AND fvd.language_id = '2' 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.00029087066650391 | 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 = '359' AND fv.source = '2' AND fvd.language_id = '2' 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.0047659873962402 | 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 = '360' AND fv.source = '2' AND fvd.language_id = '2' 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.0032877922058105 | 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 = '361' AND fv.source = '2' AND fvd.language_id = '2' 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.00035595893859863 | 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 = '362' AND fv.source = '2' AND fvd.language_id = '2' 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.00049495697021484 | 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 = '363' AND fv.source = '2' AND fvd.language_id = '2' 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.00072097778320312 | 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 = '441' AND fv.source = '2' AND fvd.language_id = '2' 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.00047087669372559 | 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 = '448' AND fv.source = '2' AND fvd.language_id = '2' 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.00060296058654785 | 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 = '449' AND fv.source = '2' AND fvd.language_id = '2' 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.00062704086303711 | 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 = '450' AND fv.source = '2' AND fvd.language_id = '2' 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.0038261413574219 | 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 = '951' AND fv.source = '2' AND fvd.language_id = '2' 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.00086593627929688 | 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 = '1155' AND fv.source = '2' AND fvd.language_id = '2' 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.00091314315795898 | 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 = '1497' AND fv.source = '2' AND fvd.language_id = '2' 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.00067496299743652 | 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 = '1539' AND fv.source = '2' AND fvd.language_id = '2' 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.0007319450378418 | 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 = '1540' AND fv.source = '2' AND fvd.language_id = '2' 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.00071620941162109 | 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 = '1541' AND fv.source = '2' AND fvd.language_id = '2' 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.0010209083557129 | 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 = '1542' AND fv.source = '2' AND fvd.language_id = '2' 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.0011558532714844 | 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 = '1543' AND fv.source = '2' AND fvd.language_id = '2' 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.0015199184417725 | 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 = '1544' AND fv.source = '2' AND fvd.language_id = '2' 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.0013971328735352 | 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 = '1545' AND fv.source = '2' AND fvd.language_id = '2' 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.0012519359588623 | 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 = '1547' AND fv.source = '2' AND fvd.language_id = '2' 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.0027570724487305 | 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 = '1644' AND fv.source = '2' AND fvd.language_id = '2' 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.0006859302520752 | 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 = '1645' AND fv.source = '2' AND fvd.language_id = '2' 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.0006568431854248 | 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 = '1646' AND fv.source = '2' AND fvd.language_id = '2' 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.00080299377441406 | 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 = '1647' AND fv.source = '2' AND fvd.language_id = '2' 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.00049877166748047 | 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 = '1648' AND fv.source = '2' AND fvd.language_id = '2' 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.00044894218444824 | 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 = '1649' AND fv.source = '2' AND fvd.language_id = '2' 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.00050902366638184 | 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 = '1650' AND fv.source = '2' AND fvd.language_id = '2' 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.00046896934509277 | 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 = '1651' AND fv.source = '2' AND fvd.language_id = '2' 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.00059103965759277 | 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 = '1652' AND fv.source = '2' AND fvd.language_id = '2' 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.00038504600524902 | 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 = '1653' AND fv.source = '2' AND fvd.language_id = '2' 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.00040006637573242 | 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 = '1654' AND fv.source = '2' AND fvd.language_id = '2' 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.00050592422485352 | 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 = '1655' AND fv.source = '2' AND fvd.language_id = '2' 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.00034713745117188 | 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 = '1656' AND fv.source = '2' AND fvd.language_id = '2' 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.0003349781036377 | 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 = '1657' AND fv.source = '2' AND fvd.language_id = '2' 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.0003209114074707 | 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 = '1658' AND fv.source = '2' AND fvd.language_id = '2' 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.00035500526428223 | 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 = '1659' AND fv.source = '2' AND fvd.language_id = '2' 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.00036907196044922 | 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 = '1758' AND fv.source = '2' AND fvd.language_id = '2' 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.00026893615722656 | 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 = '1760' AND fv.source = '2' AND fvd.language_id = '2' 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.0063378810882568 | 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 = '1762' AND fv.source = '2' AND fvd.language_id = '2' 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.00033903121948242 | 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 = '1763' AND fv.source = '2' AND fvd.language_id = '2' 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.00039100646972656 | 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 = '1787' AND fv.source = '2' AND fvd.language_id = '2' 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.00047206878662109 | 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 = '1788' AND fv.source = '2' AND fvd.language_id = '2' 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.00041604042053223 | 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 = '1789' AND fv.source = '2' AND fvd.language_id = '2' 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.00047111511230469 | 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 = '1790' AND fv.source = '2' AND fvd.language_id = '2' 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.00037693977355957 | 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 = '1791' AND fv.source = '2' AND fvd.language_id = '2' 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.00049805641174316 | 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 = '1792' AND fv.source = '2' AND fvd.language_id = '2' 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.00060200691223145 | 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 = '1793' AND fv.source = '2' AND fvd.language_id = '2' 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.0004417896270752 | 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 = '1913' AND fv.source = '2' AND fvd.language_id = '2' 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.00039982795715332 | 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 = '1914' AND fv.source = '2' AND fvd.language_id = '2' 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.00035715103149414 | 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 = '1915' AND fv.source = '2' AND fvd.language_id = '2' 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.0010020732879639 | 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 = '2011' AND fv.source = '2' AND fvd.language_id = '2' 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.00044488906860352 | 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 = '4218' AND fv.source = '2' AND fvd.language_id = '2' 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.00031590461730957 | 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 = '4219' AND fv.source = '2' AND fvd.language_id = '2' 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.00032591819763184 | 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 = '4220' AND fv.source = '2' AND fvd.language_id = '2' 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.00035691261291504 | 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 = '4221' AND fv.source = '2' AND fvd.language_id = '2' 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.00034213066101074 | 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 = '4222' AND fv.source = '2' AND fvd.language_id = '2' 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.00056791305541992 | 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 = '4223' AND fv.source = '2' AND fvd.language_id = '2' 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.00055599212646484 | 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 = '4224' AND fv.source = '2' AND fvd.language_id = '2' 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.0010249614715576 | 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 = '4225' AND fv.source = '2' AND fvd.language_id = '2' 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.00084590911865234 | 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 = '4226' AND fv.source = '2' AND fvd.language_id = '2' 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.00058984756469727 | 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 = '4227' AND fv.source = '2' AND fvd.language_id = '2' 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.0005340576171875 | 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 = '4228' AND fv.source = '2' AND fvd.language_id = '2' 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.0057368278503418 | 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 = '4288' AND fv.source = '2' AND fvd.language_id = '2' 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.0010509490966797 | 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 = '4452' AND fv.source = '2' AND fvd.language_id = '2' 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.0010900497436523 | 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 = '4453' AND fv.source = '2' AND fvd.language_id = '2' 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.0011110305786133 | 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 = '4454' AND fv.source = '2' AND fvd.language_id = '2' 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.020834922790527 | 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 = '4455' AND fv.source = '2' AND fvd.language_id = '2' 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.0011000633239746 | 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 = '4456' AND fv.source = '2' AND fvd.language_id = '2' 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.0010190010070801 | 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 = '4457' AND fv.source = '2' AND fvd.language_id = '2' 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.00066804885864258 | 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 = '4458' AND fv.source = '2' AND fvd.language_id = '2' 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.00070309638977051 | 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 = '4459' AND fv.source = '2' AND fvd.language_id = '2' 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.00057601928710938 | 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 = '4460' AND fv.source = '2' AND fvd.language_id = '2' 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.00075483322143555 | 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 = '4461' AND fv.source = '2' AND fvd.language_id = '2' 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.0011420249938965 | 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 = '4465' AND fv.source = '2' AND fvd.language_id = '2' 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.00084996223449707 | 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 = '4769' AND fv.source = '2' AND fvd.language_id = '2' 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.00060296058654785 | 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 = '4770' AND fv.source = '2' AND fvd.language_id = '2' 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.00075292587280273 | 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 = '4771' AND fv.source = '2' AND fvd.language_id = '2' 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.00076508522033691 | 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 = '4772' AND fv.source = '2' AND fvd.language_id = '2' 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.00060200691223145 | 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 = '4790' AND fv.source = '2' AND fvd.language_id = '2' 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.00060200691223145 | 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 = '4791' AND fv.source = '2' AND fvd.language_id = '2' 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.00059795379638672 | 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 = '4792' AND fv.source = '2' AND fvd.language_id = '2' 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.00064301490783691 | 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 = '4793' AND fv.source = '2' AND fvd.language_id = '2' 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.0006558895111084 | 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 = '4800' AND fv.source = '2' AND fvd.language_id = '2' 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.0010271072387695 | 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 = '5454' AND fv.source = '2' AND fvd.language_id = '2' 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.0008540153503418 | 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 = '5494' AND fv.source = '2' AND fvd.language_id = '2' 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.00052595138549805 | 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 = '6222' AND fv.source = '2' AND fvd.language_id = '2' 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.0011649131774902 | 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 = '6223' AND fv.source = '2' AND fvd.language_id = '2' 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.00060486793518066 | 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 = '6224' AND fv.source = '2' AND fvd.language_id = '2' 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.00059700012207031 | 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 = '2' 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 = '2' AND p.category_id = '118' AND p.module = '1' ORDER BY p.page_id DESC |
| 0.00010895729064941 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/ocfilter48/module' |
| 0.00038409233093262 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.0810317993164E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.392333984375E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/column_left' |
| 7.2002410888672E-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
|
| 9.2029571533203E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '118' AND store_id = '0' |
| 8.2015991210938E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 9.608268737793E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 8.2969665527344E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/column_right' |
| 8.5115432739258E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 8.702278137207E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.5101852416992E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '118' AND store_id = '0' |
| 7.7009201049805E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 6.9141387939453E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 7.7009201049805E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/search_suggestion' |
| 7.1048736572266E-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
|
| 7.2956085205078E-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
|
| 7.4863433837891E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '118' AND store_id = '0' |
| 6.9141387939453E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 6.9856643676758E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 7.7962875366211E-5 | SELECT * FROM oc_module WHERE module_id = '34' |
| 7.0095062255859E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/content_bottom' |
| 6.7949295043945E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 7.4863433837891E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 7.5101852416992E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/buyoneclick' OR route = 'uk-ua') |
| 7.2956085205078E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'uk-ua') |
| 7.4148178100586E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 0.00013899803161621 | 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 = '2' 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.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
|
| 7.7009201049805E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.9141387939453E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.8902969360352E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.6028366088867E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.7206878662109E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.4121017456055E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.8160552978516E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1975250244141E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.8160552978516E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.9114227294922E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00033903121948242 | DELETE FROM `oc_customer_online` WHERE date_added < '2025-05-28 14:40:39' |
| 0.0036189556121826 | REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.166', `customer_id` = '0', `url` = 'https://santeho.com.ua/ua/v-poltave/stroitelnaia-tehnika/svarochnoe-oborudovanie', `referer` = '', `date_added` = '2025-05-28 15:40:39' |
| 9.5129013061523E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/footer' |
| 0.0038371086120605 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 8.1062316894531E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 9.3936920166016E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/widget_multi_connect' OR route = 'uk-ua') |
| 0.00011610984802246 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'extension/module/widget_multi_connect' |
| 7.319450378418E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 9.7990036010742E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 8.0108642578125E-5 | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 0.00014305114746094 | 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 = '2' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 8.9883804321289E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'uk-ua') |
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 4.7206878662109E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1021575927734E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 5.1021575927734E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.7206878662109E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.4822692871094E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/simpleregister' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 7.1048736572266E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.7220458984375E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/transaction' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/download' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.5061111450195E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'uk-ua') |
| 4.8160552978516E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 0.00011086463928223 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/language' |
| 5.1975250244141E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.5074691772461E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 5.793571472168E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'uk-ua') |
| 4.887580871582E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.103515625E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/currency' |
| 5.1975250244141E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.1975250244141E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 5.4836273193359E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'uk-ua') |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 6.7949295043945E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/currency' |
| 4.6968460083008E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.0067901611328E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'uk-ua') |
| 4.9829483032227E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 5.2213668823242E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/search' |
| 4.6014785766602E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 4.9114227294922E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 6.6995620727539E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'uk-ua') |
| 5.1021575927734E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 5.1975250244141E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 5.9127807617188E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 5.1021575927734E-5 | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 5.1975250244141E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'uk-ua') |
| 5.0067901611328E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 4.9114227294922E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 5.1021575927734E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/credit' OR route = 'uk-ua') |
| 4.9114227294922E-5 | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 5.2213668823242E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'uk-ua') |
| 5.1975250244141E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 5.5074691772461E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 5.1975250244141E-5 | SELECT * FROM oc_setting WHERE `code` = 'module_autobonus' |
| 5.0067901611328E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fa3cda0016a0028ecad1c9438e' |
| 6.103515625E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 4.6968460083008E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 5.0067901611328E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/cart' |
| 4.6968460083008E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 4.9829483032227E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 9.2983245849609E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'uk-ua') |
| 5.0067901611328E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '2' AND (route = 'stroimarket/stroimarket' OR route = 'uk-ua') |
| 4.6014785766602E-5 | SELECT keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '2' LIMIT 1 |
| 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 = '0' AND cd.language_id = '2' 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 = '146' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.4121017456055E-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 = '130' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5789947509766E-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 = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.103515625E-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 = '149' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '156' AND cd.language_id = '2' 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 = '1155' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5789947509766E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5074691772461E-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 = '168' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '193' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 7.5101852416992E-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 = '365' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.9127807617188E-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 = '1380' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '714' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '160' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.7949295043945E-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 = '2' 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 = '187' AND cd.language_id = '2' 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 = '216' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '228' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00018215179443359 | 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 = '2' 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 = '1373' AND cd.language_id = '2' 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 = '243' AND cd.language_id = '2' 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 = '394' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 0.00020599365234375 | 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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.103515625E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.1988830566406E-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 = '374' AND cd.language_id = '2' 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 = '108' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.7234039306641E-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 = '115' AND cd.language_id = '2' 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 = '102' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.9141387939453E-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 = '109' AND cd.language_id = '2' 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 = '118' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.7220458984375E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8889389038086E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' 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 = '373' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.1988830566406E-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 = '2' 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 = '338' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.3896179199219E-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 = '342' AND cd.language_id = '2' 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 = '309' AND cd.language_id = '2' 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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.5803527832031E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8889389038086E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.103515625E-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 = '2' 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 = '142' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.0108642578125E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' 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 = '196' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5789947509766E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.4836273193359E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5074691772461E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' 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 = '86' AND cd.language_id = '2' 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 = '268' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.1988830566406E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6028366088867E-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 = '2' 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 = '215' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.793571472168E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5074691772461E-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 = '2' 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 = '1364' AND cd.language_id = '2' 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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 8.1062316894531E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.5803527832031E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.793571472168E-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 = '2' 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 = '265' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.0081481933594E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8889389038086E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' 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 = '256' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.4836273193359E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8174133300781E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' 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 = '202' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.9127807617188E-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 = '2' 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 = '350' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.5088272094727E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.413459777832E-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 = '2' 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 = '271' AND cd.language_id = '2' 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 = '380' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5789947509766E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.2942504882812E-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 = '2' 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 = '363' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5074691772461E-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 = '1381' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.6982040405273E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.0796737670898E-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 = '2' 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 = '372' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 6.0081481933594E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8889389038086E-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 = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.5074691772461E-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 = '2' 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 = '96' AND cd.language_id = '2' 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 = '371' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) |
| 5.8174133300781E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/menu' |
| 7.2002410888672E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.2928924560547E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00012016296386719 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'common/header' |
| 8.082389831543E-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.0095062255859E-5 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
| 5.2928924560547E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'stroimarket' AND route = 'product/category' |
| 4.9829483032227E-5 |
SELECT extension_id
FROM `oc_extension`
WHERE code = 'regional_store'
|
| 5.1975250244141E-5 |
SELECT domain
FROM `oc_regional_store`
WHERE system_store_id = 0
|
| 0.00010013580322266 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
