| 0.0005 sec. | DELETE FROM `oc_session` WHERE expire < DATE_SUB(NOW(), INTERVAL 3024000 SECOND); |
| 0.0004 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = 'f428dd161c4ead6fb61385564e' AND `expire` > '2026-04-11 21:23:15' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0005 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0004 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = 'a83e2333c822abc979471ff2e8' AND `expire` > '2026-04-11 21:23:15' |
| 0.0003 sec. | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://elprom-st.ru/' |
| 0.0029 sec. | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 0.0005 sec. | SELECT * FROM oc_currency |
| 0.0006 sec. | 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 = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.0005 sec. | 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 = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.0005 sec. | 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.0005 sec. | 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.0006 sec. | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 MONTH) |
| 0.0005 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0006 sec. | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 0.0004 sec. | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.0035 sec. | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 0.0007 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'avtomaticheskie-vyklyuchateli-uzo' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'avtomaticheskie-vyklyuchateli-v-litom-korpuse-mccb' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'blochnye-avtomaticheskie-vyklyuchateli-ap50b' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | 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 = '235' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.001 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | 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 = '237' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0018 sec. | SELECT * FROM oc_category_files WHERE category_id = '400' AND type = 'default' ORDER BY id |
| 0.0017 sec. | SELECT * FROM oc_category_files WHERE category_id = '400' AND type = 'image' ORDER BY id |
| 0.0006 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.001 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | DROP TABLE IF EXISTS oc_category_descriprion_temp; |
| 0.0504 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0008 sec. |
SELECT * FROM (
SELECT DISTINCT
# pc.category_id pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
'' pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_product_to_category pc
LEFT JOIN oc_category c ON ( c.category_id = pc.category_id )
LEFT JOIN oc_category_to_store c2s ON ( pc.category_id = c2s.category_id )
LEFT JOIN oc_category_descriprion_temp cd ON ( pc.category_id = cd.category_id )
WHERE
c.parent_id = 400
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0011 sec. |
SELECT * FROM (
SELECT DISTINCT
'' pc_category_id, cc.category_id, cc.image, cc.parent_id, cc.top, cc.column, cc.sort_order, cc.status, cc.date_added, cc.date_modified, cc.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_category cc
INNER JOIN oc_category_description cd ON ( cc.category_id = cd.category_id )
INNER JOIN oc_category_to_store c2s ON ( cc.category_id = c2s.category_id )
WHERE
cc.parent_id = 400
AND EXISTS (
SELECT DISTINCT 1
FROM oc_product_to_category pc1
INNER JOIN oc_category AS C1 ON ( C1.category_id = pc1.category_id )
#ХЗ Roft WHERE ( cc.category_id = C1.parent_id )
)
AND cd.language_id = 1
AND c2s.store_id = 0
AND cc.status = 1
) t2
ORDER BY sort_order, LCASE(name)
|
| 0.0145 sec. | 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '400' |
| 0.049 sec. |
SELECT
optimized_getProduct.*
FROM (
SELECT
p.product_id AS 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
ORDER BY
NULL) AS rating,
(SELECT
pd2.price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND pd2.customer_group_id = 0
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
ps.price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = 0
AND (
(
ps.date_start = '0000-00-00'
OR ps.date_start < NOW()
)
AND (
ps.date_end = '0000-00-00'
OR ps.date_end > NOW()
)
)
ORDER BY
ps.priority ASC,
ps.price ASC LIMIT 1) AS special
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON (
cp.category_id = p2c.category_id
) LEFT JOIN
oc_product p
ON ( p2c.product_id = p.product_id ) INNER JOIN
oc_product_description pd
ON (
p.product_id = pd.product_id
)
INNER JOIN
oc_product_to_store p2s
ON (
p.product_id = p2s.product_id
)
WHERE
pd.language_id = 1
AND p.status = 1
AND p.date_available <= NOW()
AND p2s.store_id = 0
AND cp.path_id = 400 GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 ) AS optimized_getProduct |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98865' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98867' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98868' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98869' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98870' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98871' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98873' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3067' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98874' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99373' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98875' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '120273' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98877' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98878' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98879' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98880' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99443' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98881' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98882' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3068' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98883' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98885' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3069' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98886' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98888' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98889' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98890' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3070' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98891' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99441' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98892' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98893' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98894' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98895' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98896' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99374' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98897' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99442' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98898' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98899' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98900' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98901' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98902' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98903' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98904' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98905' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98906' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0009 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3071' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0008 sec. | SELECT DISTINCT *, pd.name AS name, p.image, 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 = '0' 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 = '0' 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 = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '98907' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98865' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0002 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98865' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98865' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98867' |
| 0.0002 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98867' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98867' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98868' |
| 0.0002 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98868' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98868' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98869' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98869' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98869' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98870' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98870' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98870' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98871' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98871' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98871' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98873' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98873' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98873' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '3067' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '3067' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=3067' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98874' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98874' ORDER BY main_category DESC LIMIT 1 |
| 0.001 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98874' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '99373' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '99373' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=99373' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98875' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98875' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98875' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '120273' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '120273' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=120273' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98877' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98877' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98877' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98878' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98878' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98878' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98879' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98879' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98879' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98880' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98880' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98880' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '99443' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '99443' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=99443' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98881' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98881' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98881' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98882' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98882' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98882' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '3068' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '3068' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=3068' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98883' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98883' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98883' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98885' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98885' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98885' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '3069' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '3069' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=3069' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98886' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98886' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98886' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98887' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98887' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98887' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98888' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98888' ORDER BY main_category DESC LIMIT 1 |
| 0.001 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98888' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98889' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98889' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98889' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98890' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98890' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98890' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '3070' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '3070' ORDER BY main_category DESC LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=3070' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98891' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98891' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98891' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '99441' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0004 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '99441' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=99441' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98892' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98892' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98892' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98893' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98893' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98893' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98894' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98894' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98894' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98895' |
| 0.0005 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98895' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98895' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98896' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98896' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98896' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '99374' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '99374' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=99374' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98897' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98897' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98897' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '99442' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '99442' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=99442' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98898' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98898' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98898' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98899' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98899' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98899' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98900' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98900' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98900' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98901' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98901' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98901' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98902' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98902' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98902' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98903' |
| 0.0004 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98903' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98903' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98904' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98904' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98904' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98905' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98905' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98905' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98906' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98906' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98906' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '3071' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '3071' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=3071' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '98907' |
| 0.0003 sec. | 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 = '400' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0003 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '98907' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=98907' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '400' AND store_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_left' |
| 0.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '400' AND store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_right' |
| 0.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '400' AND store_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/search_suggestion' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_top' |
| 0.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '400' AND store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_bottom' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru') |
| 0.0016 sec. | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_fmap' OR route = 'ru-ru') |
| 0.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_fmap' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_footer' OR route = 'ru-ru') |
| 0.0007 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0018 sec. | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '-1' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order ASC |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_footer' |
| 0.0007 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_modal' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/footer' |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_logo' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_menu' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_menu' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_cart' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a83e2333c822abc979471ff2e8' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_cart' |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_hlinks' |
| 0.0011 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_links' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_search' OR route = 'ru-ru') |
| 0.0012 sec. | DROP TABLE IF EXISTS oc_category_descriprion_temp; |
| 0.0536 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0009 sec. |
SELECT * FROM (
SELECT DISTINCT
# pc.category_id pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
'' pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_product_to_category pc
LEFT JOIN oc_category c ON ( c.category_id = pc.category_id )
LEFT JOIN oc_category_to_store c2s ON ( pc.category_id = c2s.category_id )
LEFT JOIN oc_category_descriprion_temp cd ON ( pc.category_id = cd.category_id )
WHERE
c.parent_id = 0
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0026 sec. |
SELECT * FROM (
SELECT DISTINCT
'' pc_category_id, cc.category_id, cc.image, cc.parent_id, cc.top, cc.column, cc.sort_order, cc.status, cc.date_added, cc.date_modified, cc.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_category cc
INNER JOIN oc_category_description cd ON ( cc.category_id = cd.category_id )
INNER JOIN oc_category_to_store c2s ON ( cc.category_id = c2s.category_id )
WHERE
cc.parent_id = 0
AND EXISTS (
SELECT DISTINCT 1
FROM oc_product_to_category pc1
INNER JOIN oc_category AS C1 ON ( C1.category_id = pc1.category_id )
#ХЗ Roft WHERE ( cc.category_id = C1.parent_id )
)
AND cd.language_id = 1
AND c2s.store_id = 0
AND cc.status = 1
) t2
ORDER BY sort_order, LCASE(name)
|
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_search' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_contacts' OR route = 'ru-ru') |
| 0.0009 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_contacts' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/register' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/transaction' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/download' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/language' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=235' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=237' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog/latest' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=69' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=70' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'blog/menu' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/header' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'product/category' |
