| 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` = '9e926ff0335cb699bfb8d25337' AND `expire` > '2026-04-11 21:38:53' |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
| 0.0004 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0003 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = '746ce2b2423815ac64a5d8d5e2' AND `expire` > '2026-04-11 21:38:53' |
| 0.0004 sec. | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://elprom-st.ru/' |
| 0.0027 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.0004 sec. | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.0004 sec. | SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' |
| 0.0004 sec. | SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' |
| 0.0004 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.0005 sec. | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 0.0003 sec. | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.0029 sec. | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 0.0006 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'vibroizolyatsionnye-shumopogloschayuschie-sistemy' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'dempfery-tselnometallicheskie' 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=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0011 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.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 = '320' 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=320' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0018 sec. | SELECT * FROM oc_category_files WHERE category_id = '321' AND type = 'default' ORDER BY id |
| 0.0018 sec. | SELECT * FROM oc_category_files WHERE category_id = '321' AND type = 'image' ORDER BY id |
| 0.0006 sec. | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '321' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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.0404 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0007 sec. |
SELECT * FROM (
SELECT DISTINCT
# pc.category_id pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
'' pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_product_to_category pc
LEFT JOIN oc_category c ON ( c.category_id = pc.category_id )
LEFT JOIN oc_category_to_store c2s ON ( pc.category_id = c2s.category_id )
LEFT JOIN oc_category_descriprion_temp cd ON ( pc.category_id = cd.category_id )
WHERE
c.parent_id = 321
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0029 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 = 321
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.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 = '963' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '966' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=966' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1147' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=1147' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '964' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=964' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '965' |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '962' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=962' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '941' |
| 0.0005 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '934' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=934' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '954' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=954' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '928' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=928' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '927' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=927' 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 = '931' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=931' 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 = '930' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=930' 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 = '929' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=929' 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 = '936' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '932' |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=932' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0007 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '926' |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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 = '933' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=933' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 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 = '935' |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0019 sec. | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '321' |
| 0.0037 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 = 321 GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 ) AS optimized_getProduct |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '95622' 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 = '95623' 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 = '95624' 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 = '95722' 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 = '95725' 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 = '95726' 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 = '95728' 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 = '95731' 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 = '95733' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0021 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 = '95732' 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 = '95734' 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 = '95735' 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 = '95736' 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 = '95737' 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 = '95738' 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 = '95729' 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 = '95739' 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 = '95740' 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 = '95741' 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 = '95742' 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 = '95743' 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 = '95744' 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 = '95730' 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 = '95727' 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 = '95860' 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 = '95745' 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 = '95746' 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 = '95747' 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 = '95748' 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 = '95749' 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 = '95750' 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 = '95751' 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 = '95753' 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 = '95752' 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 = '95754' 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 = '93451' 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 = '93452' 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 = '93450' 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 = '93453' 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 = '93454' 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 = '93455' 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 = '94930' 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 = '94931' 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 = '94932' 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 = '94933' 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 = '94934' 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 = '94935' 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 = '94936' 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 = '94937' 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 = '94938' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95622' |
| 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 = '1147' 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 = '95622' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=1147' 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=95622' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95623' |
| 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 = '1147' 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 = '95623' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=1147' 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=95623' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95624' |
| 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 = '954' 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 = '95624' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=954' 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=95624' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95722' |
| 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 = '962' 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 = '95722' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=962' 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=95722' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95725' |
| 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 = '934' 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 = '95725' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=934' 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=95725' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95726' |
| 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 = '928' 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 = '95726' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=928' 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=95726' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95728' |
| 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 = '927' 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 = '95728' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=927' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=95728' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95731' |
| 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 = '930' 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 = '95731' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=930' 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=95731' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95733' |
| 0.0006 sec. | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '931' 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 = '95733' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=931' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=95733' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95732' |
| 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 = '930' 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 = '95732' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=930' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=95732' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95734' |
| 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 = '931' 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 = '95734' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=931' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=95734' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95735' |
| 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 = '929' 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 = '95735' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=929' 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=95735' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95736' |
| 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 = '929' 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 = '95736' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=929' 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=95736' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95737' |
| 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 = '929' 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 = '95737' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=929' 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=95737' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95738' |
| 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 = '929' 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 = '95738' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=929' 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=95738' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95729' |
| 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 = '927' 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 = '95729' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=927' 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=95729' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95739' |
| 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 = '936' 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 = '95739' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95739' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95740' |
| 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 = '936' 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 = '95740' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95740' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95741' |
| 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 = '936' 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 = '95741' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95741' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95742' |
| 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 = '936' 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 = '95742' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95742' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95743' |
| 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 = '936' 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 = '95743' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95743' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95744' |
| 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 = '936' 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 = '95744' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=936' 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=95744' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95730' |
| 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 = '927' 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 = '95730' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=927' 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=95730' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95727' |
| 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 = '928' 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 = '95727' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=928' 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=95727' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95860' |
| 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 = '932' 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 = '95860' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=932' 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=95860' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95745' |
| 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 = '926' 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 = '95745' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95745' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95746' |
| 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 = '926' 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 = '95746' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95746' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95747' |
| 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 = '926' 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 = '95747' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95747' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95748' |
| 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 = '926' 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 = '95748' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95748' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95749' |
| 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 = '926' 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 = '95749' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95749' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95750' |
| 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 = '926' 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 = '95750' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95750' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95751' |
| 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 = '926' 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 = '95751' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95751' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95753' |
| 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 = '926' 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 = '95753' ORDER BY main_category DESC LIMIT 1 |
| 0.0008 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95753' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95752' |
| 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 = '926' 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 = '95752' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=926' 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=95752' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '95754' |
| 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 = '933' 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 = '95754' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=933' 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=95754' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93451' |
| 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 = '935' 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 = '93451' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93451' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93452' |
| 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 = '935' 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 = '93452' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93452' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93450' |
| 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 = '935' 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 = '93450' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93450' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93453' |
| 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 = '935' 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 = '93453' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93453' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93454' |
| 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 = '935' 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 = '93454' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93454' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '93455' |
| 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 = '935' 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 = '93455' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=935' 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=93455' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94930' |
| 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 = '963' 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 = '94930' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=963' 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=94930' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94931' |
| 0.0006 sec. | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '963' 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 = '94931' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=963' 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=94931' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94932' |
| 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 = '963' 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 = '94932' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94932' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94933' |
| 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 = '963' 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 = '94933' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0009 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=963' 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=94933' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94934' |
| 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 = '963' 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 = '94934' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94934' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94935' |
| 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 = '963' 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 = '94935' ORDER BY main_category DESC LIMIT 1 |
| 0.0007 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94935' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94936' |
| 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 = '963' 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 = '94936' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94936' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94937' |
| 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 = '963' 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 = '94937' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94937' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '94938' |
| 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 = '963' 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 = '94938' ORDER BY main_category DESC LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' 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=963' 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=94938' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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=320' 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=321' 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.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '321' 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 = '321' 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.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_right' |
| 0.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '321' 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.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/search_suggestion' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_top' |
| 0.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '321' 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.0002 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.0018 sec. | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 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.0004 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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.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/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.0009 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_fmap' OR route = 'ru-ru') |
| 0.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_fmap' |
| 0.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.0004 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.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0015 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.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.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.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.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/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.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_modal' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/footer' |
| 0.0011 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_logo' |
| 0.0005 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.0011 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_menu' |
| 0.0004 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_cart' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 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.0003 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 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.0002 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 = '746ce2b2423815ac64a5d8d5e2' |
| 0.0004 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '746ce2b2423815ac64a5d8d5e2' |
| 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.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_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.0003 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.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 = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_contacts' |
| 0.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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/register' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 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.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.0005 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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=320' 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=321' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog/latest' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0008 sec. | SELECT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=69' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=70' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'blog/menu' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/header' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'product/category' |
