| 0.0005 sec. | DELETE FROM `oc_session` WHERE expire < DATE_SUB(NOW(), INTERVAL 3024000 SECOND); |
| 0.0005 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = '9ed19ffd45713cb8dacd5348de' AND `expire` > '2026-04-11 20:48:13' |
| 0.0005 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0004 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` = '37e823d61e1539a9c8ded20f3f' AND `expire` > '2026-04-11 20:48:13' |
| 0.0003 sec. | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://elprom-st.ru/' |
| 0.0033 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.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 = '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.0004 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.0004 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.0005 sec. | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 MONTH) |
| 0.0003 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0005 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.0029 sec. | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 0.0006 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'rezervnoe-besperebojnoe-pitanie-i-komponenty' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'avtomaticheskij-vvod-rezerva-avr-na-avtomaticheskih-vyklyuchatelyah' 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=289' 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=290' 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.0004 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.0008 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 = '289' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0014 sec. | SELECT * FROM oc_category_files WHERE category_id = '290' AND type = 'default' ORDER BY id |
| 0.0013 sec. | SELECT * FROM oc_category_files WHERE category_id = '290' AND type = 'image' ORDER BY id |
| 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 = '290' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | DROP TABLE IF EXISTS oc_category_descriprion_temp; |
| 0.0425 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0007 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 = 290
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0015 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 = 290
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.0008 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 = '1747' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=1747' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 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 = '1584' |
| 0.0005 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 = '784' |
| 0.0017 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 = '690' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 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 = '1656' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=1656' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 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 = '908' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0019 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 = '290' |
| 0.0058 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 = 290 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 = '131404' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.001 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 = '131405' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.001 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 = '131399' 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 = '131400' 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 = '131401' 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 = '131402' 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 = '131403' 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 = '100541' 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 = '100542' 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 = '108240' 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 = '108241' 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 = '108242' 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 = '108243' 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 = '108244' 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 = '108245' 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 = '108246' 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 = '108247' 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 = '108248' 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 = '108249' 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 = '108050' 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 = '108051' 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 = '108052' 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 = '108053' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.001 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 = '108054' 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 = '108055' 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 = '108056' 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 = '108057' 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 = '108058' 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 = '108059' 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 = '108060' 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 = '108061' 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 = '109038' 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 = '109037' 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 = '109036' 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 = '109054' 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 = '118033' 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 = '118034' 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 = '118035' 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 = '118036' 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 = '109040' 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 = '109039' 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 = '118037' 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 = '118038' 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 = '109044' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0007 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 = '118044' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0007 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 = '109043' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0007 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 = '109042' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0007 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 = '109041' 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 = '118039' 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 = '118040' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131404' |
| 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 = '908' 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 = '131404' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131404' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131405' |
| 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 = '908' 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 = '131405' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131405' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131399' |
| 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 = '908' 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 = '131399' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131399' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131400' |
| 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 = '908' 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 = '131400' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131400' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131401' |
| 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 = '908' 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 = '131401' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131401' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131402' |
| 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 = '908' 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 = '131402' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131402' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '131403' |
| 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 = '908' 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 = '131403' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=908' 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=131403' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '100541' |
| 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 = '1747' 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 = '100541' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=1747' 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=100541' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '100542' |
| 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 = '1747' 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 = '100542' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=1747' 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=100542' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108240' |
| 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 = '690' 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 = '108240' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108240' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108241' |
| 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 = '690' 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 = '108241' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108241' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108242' |
| 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 = '690' 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 = '108242' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108242' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108243' |
| 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 = '690' 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 = '108243' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108243' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108244' |
| 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 = '690' 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 = '108244' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108244' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108245' |
| 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 = '690' 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 = '108245' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108245' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108246' |
| 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 = '690' 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 = '108246' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108246' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108247' |
| 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 = '690' 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 = '108247' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108247' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108248' |
| 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 = '690' 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 = '108248' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108248' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108249' |
| 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 = '690' 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 = '108249' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108249' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108050' |
| 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 = '690' 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 = '108050' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108050' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108051' |
| 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 = '690' 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 = '108051' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108051' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108052' |
| 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 = '690' 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 = '108052' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108052' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108053' |
| 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 = '690' 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 = '108053' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108053' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108054' |
| 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 = '690' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0023 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '108054' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108054' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108055' |
| 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 = '690' 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 = '108055' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108055' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108056' |
| 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 = '690' 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 = '108056' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108056' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108057' |
| 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 = '690' 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 = '108057' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108057' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108058' |
| 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 = '690' 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 = '108058' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108058' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108059' |
| 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 = '690' 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 = '108059' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108059' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108060' |
| 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 = '690' 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 = '108060' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108060' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '108061' |
| 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 = '690' 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 = '108061' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=108061' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109038' |
| 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 = '690' 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 = '109038' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109038' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109037' |
| 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 = '690' 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 = '109037' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109037' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109036' |
| 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 = '690' 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 = '109036' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109036' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109054' |
| 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 = '690' 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 = '109054' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109054' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118033' |
| 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 = '690' 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 = '118033' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118033' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118034' |
| 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 = '690' 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 = '118034' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118034' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118035' |
| 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 = '690' 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 = '118035' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118035' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118036' |
| 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 = '690' 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 = '118036' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118036' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109040' |
| 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 = '690' 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 = '109040' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109040' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109039' |
| 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 = '690' 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 = '109039' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109039' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118037' |
| 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 = '690' 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 = '118037' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118037' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118038' |
| 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 = '690' 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 = '118038' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118038' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109044' |
| 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 = '690' 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 = '109044' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109044' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118044' |
| 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 = '690' 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 = '118044' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118044' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109043' |
| 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 = '690' 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 = '109043' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109043' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109042' |
| 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 = '690' 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 = '109042' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109042' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '109041' |
| 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 = '690' 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 = '109041' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=109041' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118039' |
| 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 = '690' 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 = '118039' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118039' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '118040' |
| 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 = '690' 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 = '118040' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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=690' 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=118040' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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=289' 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=290' 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 = '290' 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 = '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.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '290' 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 = '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 = '290' 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.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/search_suggestion' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_top' |
| 0.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '290' 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_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.0012 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.0003 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.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.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.0003 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.0003 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.0006 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.0006 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_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.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0012 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.0003 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.0002 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.0003 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.0002 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.0002 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.0003 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.0002 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.0002 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.0003 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.0002 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.0002 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.0002 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.0006 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.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/footer' |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 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.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_logo' |
| 0.0002 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.0006 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_menu' |
| 0.0003 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.0002 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.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
| 0.0002 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 = '37e823d61e1539a9c8ded20f3f' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '37e823d61e1539a9c8ded20f3f' |
| 0.0004 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.0004 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.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_cart' |
| 0.0006 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_hlinks' |
| 0.0006 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_links' |
| 0.0002 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.0006 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_search' |
| 0.0002 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.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 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.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_contacts' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' 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_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.0007 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.0003 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.0003 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 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/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/register' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 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.0002 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/transaction' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 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.0002 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.0003 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.0004 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.0002 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.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 0.0003 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.0002 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.0003 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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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.0004 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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=289' 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=290' 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.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
| 0.0004 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.0007 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.0004 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.0004 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.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'blog/menu' |
| 0.0002 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' |
