| 0.0009 sec. | DELETE FROM `oc_session` WHERE expire < DATE_SUB(NOW(), INTERVAL 3024000 SECOND); |
| 0.0007 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = 'd6deea09421292b99337bad562' AND `expire` > '2026-04-11 20:45:55' |
| 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.0004 sec. | SELECT `data` FROM `oc_session` WHERE `session_id` = 'fce4487e557a08fff666d98afa' AND `expire` > '2026-04-11 20:45:55' |
| 0.0003 sec. | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://elprom-st.ru/' |
| 0.0028 sec. | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 0.0004 sec. | SELECT * FROM oc_currency |
| 0.0005 sec. | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.0005 sec. | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '0' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
| 0.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.0005 sec. | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 MONTH) |
| 0.0003 sec. | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
| 0.0006 sec. | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
| 0.0004 sec. | SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1 |
| 0.0032 sec. | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 0.0006 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'rele-avtomatika' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT query FROM oc_seo_url WHERE keyword = 'upravlenie-osvescheniem' 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=271' 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=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.001 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.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 = '271' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0019 sec. | SELECT * FROM oc_category_files WHERE category_id = '272' AND type = 'default' ORDER BY id |
| 0.0017 sec. | SELECT * FROM oc_category_files WHERE category_id = '272' 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 = '272' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | DROP TABLE IF EXISTS oc_category_descriprion_temp; |
| 0.049 sec. | CREATE TEMPORARY TABLE IF NOT EXISTS oc_category_descriprion_temp (PRIMARY KEY (category_id)) SELECT * FROM oc_category_description |
| 0.0009 sec. |
SELECT * FROM (
SELECT DISTINCT
# pc.category_id pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
'' pc_category_id, c.category_id, c.image, c.parent_id, c.top, c.column, c.sort_order, c.status, c.date_added, c.date_modified, c.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_product_to_category pc
LEFT JOIN oc_category c ON ( c.category_id = pc.category_id )
LEFT JOIN oc_category_to_store c2s ON ( pc.category_id = c2s.category_id )
LEFT JOIN oc_category_descriprion_temp cd ON ( pc.category_id = cd.category_id )
WHERE
c.parent_id = 272
AND cd.language_id = 1
AND c2s.store_id = 0
AND c.status = 1
) t1
WHERE FALSE # Отключили запрос. Сергей
ORDER BY sort_order, LCASE(name)
|
| 0.0015 sec. |
SELECT * FROM (
SELECT DISTINCT
'' pc_category_id, cc.category_id, cc.image, cc.parent_id, cc.top, cc.column, cc.sort_order, cc.status, cc.date_added, cc.date_modified, cc.noindex, cd.language_id, cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword, cd.meta_h1, c2s.store_id
FROM oc_category cc
INNER JOIN oc_category_description cd ON ( cc.category_id = cd.category_id )
INNER JOIN oc_category_to_store c2s ON ( cc.category_id = c2s.category_id )
WHERE
cc.parent_id = 272
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 = '1167' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1167' 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 = '860' |
| 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 = '535' |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=535' 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 = '536' |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=536' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.001 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 = '272' |
| 0.002 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 = 272 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 = '69014' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69003' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69004' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0015 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 = '69005' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69006' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69007' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69015' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69016' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69008' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69009' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69010' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69011' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69012' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69013' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69017' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '69018' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0012 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '27917' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0011 sec. | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '0' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '0' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '0') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '27916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 0.0004 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69014' |
| 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 = '1167' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0005 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '69014' ORDER BY main_category DESC LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1167' 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=69014' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69003' |
| 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 = '1166' 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 = '69003' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1166' 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=69003' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69004' |
| 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 = '1166' 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 = '69004' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69004' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69005' |
| 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 = '1166' 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 = '69005' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1166' 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=69005' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69006' |
| 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 = '1166' 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 = '69006' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1166' 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=69006' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69007' |
| 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 = '1166' 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 = '69007' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69007' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69015' |
| 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 = '1167' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 0.0007 sec. | SELECT category_id FROM oc_product_to_category WHERE product_id = '69015' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1167' 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=69015' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69016' |
| 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 = '1167' 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 = '69016' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1167' 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=69016' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69008' |
| 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 = '1166' 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 = '69008' ORDER BY main_category DESC LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1166' 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=69008' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69009' |
| 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 = '1166' 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 = '69009' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1166' 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=69009' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69010' |
| 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 = '1166' 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 = '69010' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69010' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69011' |
| 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 = '1166' 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 = '69011' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69011' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69012' |
| 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 = '1166' 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 = '69012' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69012' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69013' |
| 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 = '1166' 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 = '69013' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1166' 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=69013' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69017' |
| 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 = '1167' 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 = '69017' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=1167' 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=69017' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '69018' |
| 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 = '1167' 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 = '69018' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=1167' 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=69018' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '27917' |
| 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 = '536' 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 = '27917' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=536' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=27917' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_product_to_category WHERE product_id = '27916' |
| 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 = '535' 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 = '27916' ORDER BY main_category DESC LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' 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=535' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=27916' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' 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=272' 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=271' 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=272' 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=271' 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=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '272' AND store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.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.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '272' AND store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0003 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/column_right' |
| 0.0002 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '272' AND store_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/search_suggestion' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_top' |
| 0.0003 sec. | SELECT * FROM oc_category_to_layout WHERE category_id = '272' AND store_id = '0' |
| 0.0003 sec. | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/content_bottom' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru') |
| 0.0012 sec. | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 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.0002 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.0002 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.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 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.0002 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.0005 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_fmap' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_fmap' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_footer' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0012 sec. | SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=8' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=7' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=10' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=21' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information_id=9' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 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.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '-1' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order ASC |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_footer' |
| 0.0009 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_modal' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/footer' |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_logo' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_menu' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_menu' |
| 0.0003 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_cart' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0002 sec. | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fce4487e557a08fff666d98afa' |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_cart' |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_hlinks' |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_links' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_search' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'extension/module/frametheme/ft_search' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_contacts' OR route = 'ru-ru') |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.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.0006 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.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/frametheme/ft_global' OR route = 'ru-ru') |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0006 sec. | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_frame' |
| 0.0003 sec. | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 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.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0005 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/register' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/transaction' 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/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.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0004 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'checkout/checkout' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/language' |
| 0.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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=271' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=272' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/currency' |
| 0.0002 sec. | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
| 0.0003 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.0006 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.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=69' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0003 sec. | SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'blog_category_id=70' AND store_id = '0' AND language_id = '1' LIMIT 1 |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'blog/menu' |
| 0.0002 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'common/header' |
| 0.0003 sec. | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'ft_frame' AND route = 'product/category' |
