| 0.0004 sec. | DELETE FROM `oc_session` WHERE expire < DATE_SUB(NOW(), INTERVAL 3024000 SECOND); |
| 0.0004 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = '51a1cbc4764eb14addc11a039a' AND `expire` > '2026-04-11 21:19:54' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0003 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` = 'e197099792a2f12f2cef9e2984' AND `expire` > '2026-04-11 21:19:55' |
| 0.0004 sec. | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://elprom-st.ru/' |
| 0.0028 sec. | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 0.0004 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.0005 sec. | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.0005 sec. | SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' |
| 0.0005 sec. | SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' |
| 0.0005 sec. | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 MONTH) |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0006 sec. | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 0.0004 sec. | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.0034 sec. | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 0.0007 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'upravlenie-i-signalizatsiya' 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=286' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0017 sec. | SELECT * FROM oc_category_files WHERE category_id = '286' AND type = 'default' ORDER BY id |
| 0.0018 sec. | SELECT * FROM oc_category_files WHERE category_id = '286' AND type = 'image' ORDER BY id |
| 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 = '286' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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.0501 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0008 sec. |
SELECT * FROM (
SELECT DISTINCT
# pc.category_id pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
'' pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_product_to_category pc
LEFT JOIN oc_category c ON ( c.category_id = pc.category_id )
LEFT JOIN oc_category_to_store c2s ON ( pc.category_id = c2s.category_id )
LEFT JOIN oc_category_descriprion_temp cd ON ( pc.category_id = cd.category_id )
WHERE
c.parent_id = 286
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0022 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 = 286
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 = '751' |
| 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 = '750' |
| 0.0009 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 = '711' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=711' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0044 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 = '704' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=704' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0011 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 = '1022' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1022' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0043 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 = '705' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=705' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 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 = '712' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=712' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0079 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 = '706' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 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 = '1746' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1746' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0028 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 = '1730' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1730' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0013 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 = '1729' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1729' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0025 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 = '1616' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=1616' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0288 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 = '286' |
| 0.082 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 = 286 GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 ) AS optimized_getProduct |
| 0.0012 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 = '38966' 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 = '38967' 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 = '38968' 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 = '39095' 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 = '39096' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 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 = '39097' 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 = '39602' 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 = '39098' 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 = '39099' 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 = '39100' 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 = '39101' 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 = '39102' 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 = '39103' 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 = '39104' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0013 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 = '39105' 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 = '39106' 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 = '39107' 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 = '39108' 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 = '39109' 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 = '39110' 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 = '39111' 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 = '39112' 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 = '39113' 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 = '111095' 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 = '111096' 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 = '111097' 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 = '111098' 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 = '111099' 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 = '111100' 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 = '111101' 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 = '111102' 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 = '111103' 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 = '96915' 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 = '96914' 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 = '39603' 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 = '38943' 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 = '38944' 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 = '35871' 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 = '35873' 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 = '110403' 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 = '110404' 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 = '111202' 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 = '111204' 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 = '111205' 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 = '38888' 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 = '38889' 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 = '38890' 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 = '38891' 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 = '38892' 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 = '38893' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38966' |
| 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 = '706' 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 = '38966' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38966' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38967' |
| 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 = '706' 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 = '38967' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38967' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38968' |
| 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 = '706' 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 = '38968' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38968' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39095' |
| 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 = '706' 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 = '39095' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39095' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39096' |
| 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 = '706' 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 = '39096' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39096' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39097' |
| 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 = '706' 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 = '39097' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39097' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39602' |
| 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 = '706' 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 = '39602' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39602' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39098' |
| 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 = '706' 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 = '39098' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39098' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39099' |
| 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 = '706' 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 = '39099' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39099' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39100' |
| 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 = '706' 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 = '39100' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39100' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39101' |
| 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 = '706' 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 = '39101' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39101' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39102' |
| 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 = '706' 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 = '39102' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39102' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39103' |
| 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 = '706' 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 = '39103' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39103' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39104' |
| 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 = '706' 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 = '39104' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39104' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39105' |
| 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 = '706' 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 = '39105' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39105' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39106' |
| 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 = '706' 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 = '39106' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39106' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39107' |
| 0.0002 sec. | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '706' 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 = '39107' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39107' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39108' |
| 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 = '706' 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 = '39108' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39108' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39109' |
| 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 = '706' 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 = '39109' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39109' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39110' |
| 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 = '706' 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 = '39110' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39110' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39111' |
| 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 = '706' 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 = '39111' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39111' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39112' |
| 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 = '706' 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 = '39112' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39112' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39113' |
| 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 = '706' 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 = '39113' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39113' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111095' |
| 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 = '1616' 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 = '111095' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111095' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111096' |
| 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 = '1616' 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 = '111096' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111096' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111097' |
| 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 = '1616' 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 = '111097' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111097' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111098' |
| 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 = '1616' 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 = '111098' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111098' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111099' |
| 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 = '1616' 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 = '111099' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111099' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111100' |
| 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 = '1616' 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 = '111100' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111100' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111101' |
| 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 = '1616' 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 = '111101' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111101' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111102' |
| 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 = '1616' 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 = '111102' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111102' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111103' |
| 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 = '1616' 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 = '111103' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111103' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '96915' |
| 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 = '1729' 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 = '96915' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1729' 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=96915' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '96914' |
| 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 = '1729' 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 = '96914' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=1729' 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=96914' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '39603' |
| 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 = '706' 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 = '39603' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=39603' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38943' |
| 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 = '706' 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 = '38943' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38943' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38944' |
| 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 = '706' 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 = '38944' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=38944' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '35871' |
| 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 = '705' 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 = '35871' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=705' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=35871' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '35873' |
| 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 = '705' 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 = '35873' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=705' 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=35873' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '110403' |
| 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 = '1616' 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 = '110403' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=110403' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '110404' |
| 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 = '1616' 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 = '110404' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=110404' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111202' |
| 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 = '1616' 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 = '111202' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111202' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111204' |
| 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 = '1616' 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 = '111204' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111204' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '111205' |
| 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 = '1616' 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 = '111205' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=1616' 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=111205' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38888' |
| 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 = '706' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0005 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '38888' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38888' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38889' |
| 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 = '706' 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 = '38889' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38889' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38890' |
| 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 = '706' 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 = '38890' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38890' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38891' |
| 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 = '706' 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 = '38891' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38891' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38892' |
| 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 = '706' 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 = '38892' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38892' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '38893' |
| 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 = '706' 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 = '38893' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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=706' 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=38893' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' 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=286' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '286' AND store_id = '0' |
| 0.0004 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_left' |
| 0.0004 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '286' AND store_id = '0' |
| 0.0004 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_right' |
| 0.0004 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '286' AND store_id = '0' |
| 0.0004 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/search_suggestion' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_top' |
| 0.0004 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '286' AND store_id = '0' |
| 0.0004 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_bottom' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru') |
| 0.0019 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.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 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.0005 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.0005 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.0005 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.0005 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.0005 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.0005 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.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.001 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.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_fmap' |
| 0.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.0003 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.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.002 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.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 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.0005 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.0005 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.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 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.0005 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.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 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.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_footer' |
| 0.0011 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_modal' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/footer' |
| 0.0008 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.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_logo' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_menu' OR route = 'ru-ru') |
| 0.0009 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0005 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_menu' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_cart' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0005 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e197099792a2f12f2cef9e2984' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_cart' |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_hlinks' |
| 0.001 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_links' |
| 0.0003 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.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_search' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_contacts' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_contacts' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 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 LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/register' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/transaction' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/download' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/language' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' 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.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=286' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
| 0.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.0003 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' |
