1 (0.046)
SET time_zone = '+00:00'
/var/www/www-root/data/www/3-15.ru/system/framework.php:84
2 (1.810)
DELETE
FROM `oc_session`
WHERE `expire` < '2024-06-08 20:28:41'
/var/www/www-root/data/www/3-15.ru/system/library/session/db.php:53
3 (7.774)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
4 (3.089)
SET SQL_BIG_SELECTS = 1
/var/www/www-root/data/www/3-15.ru/system/library/ocfilter/opencart.php:31
5 (0.733)
SHOW TABLES LIKE 'oc_ocfilter_setting'
/var/www/www-root/data/www/3-15.ru/system/library/ocfilter/setting.php:10
6 (0.276)
SELECT *
FROM oc_ocfilter_setting
/var/www/www-root/data/www/3-15.ru/system/library/ocfilter/setting.php:18
7 (1.736)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '9ee73d8dd8c205d2a57db07a87' AND `expire` > '2024-06-08 20:28:42'
/var/www/www-root/data/www/3-15.ru/system/library/session/db.php:16
8 (1.736)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://3-15.ru/'
/var/www/www-root/data/www/storage315/modification/catalog/controller/startup/startup.php:6
9 (1.862)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/www-root/data/www/storage315/modification/catalog/controller/startup/startup.php:25
10 (1.745)
SET time_zone = '+00:00'
/var/www/www-root/data/www/storage315/modification/catalog/controller/startup/startup.php:40
11 (24.103)
SELECT *
FROM oc_currency
/var/www/www-root/data/www/3-15.ru/system/library/cart/currency.php:10
12 (33.380)
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 = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761')
ORDER BY tr1.priority ASC
/var/www/www-root/data/www/3-15.ru/system/library/cart/tax.php:16
13 (0.385)
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 = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761')
ORDER BY tr1.priority ASC
/var/www/www-root/data/www/3-15.ru/system/library/cart/tax.php:44
14 (0.194)
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'
/var/www/www-root/data/www/3-15.ru/system/library/cart/weight.php:10
15 (0.607)
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'
/var/www/www-root/data/www/3-15.ru/system/library/cart/length.php:10
16 (25.455)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:15
17 (22.817)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/event.php:4
18 (2.046)
SELECT c.*
FROM prmn_cm_city c
ORDER BY sort, name
/var/www/www-root/data/www/3-15.ru/catalog/model/extension/module/progroman/citymanager.php:19
19 (9.556)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'extension/module/progroman/citymanager/confirm'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
20 (7.309)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'extension/module/progroman/citymanager/content'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
21 (36.722)
SELECT language_id
FROM oc_seo_url
WHERE keyword = 'specials' AND store_id = '0' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:566
22 (0.184)
SELECT code
FROM oc_language
WHERE language_id = '1' AND status = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:570
23 (0.110)
SELECT language_id
FROM oc_language
WHERE code = '0' AND status = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:580
24 (0.104)
SELECT category_id, parent_id
FROM oc_category
ORDER BY parent_id
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:367
25 (0.155)
SELECT query
FROM oc_seo_url
WHERE keyword = 'specials' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:440
26 (0.128)
SELECT *
FROM oc_seo_url
WHERE keyword = 'specials' AND store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/controller/startup/seo_url.php:46
27 (0.164)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
28 (11.471)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/special' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
29 (1.511)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
30 (0.623)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
31 (0.197)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/compare' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
32 (1.848)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:4
33 (1.751)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND `code` = 'ocfilter'
/var/www/www-root/data/www/3-15.ru/system/library/ocfilter/core.php:78
34 (0.924)
SELECT *
FROM oc_ocfilter_setting
WHERE `key` = 'placement_layout'
/var/www/www-root/data/www/3-15.ru/system/library/ocfilter/setting.php:68
35 (723.735)
SELECT COUNT(DISTINCT ps.product_id) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND p.quantity > 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()))
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:659
36 (801.646)
SELECT DISTINCT ps.product_id, (SELECT AVG(rating)
FROM oc_review r1
WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, ((p.price - ps.price) / (p.price / 100)) AS special_percent
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.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 p.status = '1' AND p.quantity > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,40
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:353
37 (41.744)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '95810' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
38 (5.224)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97202' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
39 (17.852)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97206' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
40 (22.197)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97207' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
41 (1.087)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97203' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
42 (0.894)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63480' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
43 (0.791)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63376' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
44 (0.696)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63414' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
45 (4.229)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '95178' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
46 (8.415)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63484' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
47 (9.718)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '67698' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
48 (9.555)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63495' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
49 (11.119)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63462' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
50 (60.680)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '67290' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
51 (0.789)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63496' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
52 (0.673)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63385' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
53 (0.664)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63354' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
54 (0.636)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63512' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
55 (0.643)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63423' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
56 (0.792)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63361' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
57 (10.245)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63457' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
58 (1.546)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63397' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
59 (1.815)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63438' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
60 (4.125)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63432' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
61 (2.537)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63459' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
62 (3.696)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63488' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
63 (11.400)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '67407' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
64 (0.693)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63366' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
65 (2.021)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63444' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
66 (0.659)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63429' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
67 (0.702)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97209' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
68 (0.686)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97201' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
69 (0.668)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '63435' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
70 (0.708)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97215' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
71 (0.660)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
72 (0.636)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97217' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
73 (0.677)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97218' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
74 (42.113)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97219' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
75 (3.064)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97210' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
76 (3.439)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, m.image as manufacturer_logo, m.warranty as warranty, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 = '1' 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 = '1') 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 = '97213' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/www-root/data/www/storage315/modification/catalog/model/catalog/product.php:11
77 (12.175)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '95810'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
78 (0.243)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
79 (1.187)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=95810' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
80 (0.168)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97202'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
81 (15.381)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
82 (0.588)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97202' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
83 (0.244)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97206'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
84 (1.418)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
85 (0.167)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97206' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
86 (1.271)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97207'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
87 (0.196)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
88 (0.205)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97207' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
89 (0.210)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97203'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
90 (6.127)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
91 (0.186)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97203' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
92 (1.955)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63480'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
93 (1.688)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
94 (0.228)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63480' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
95 (3.955)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63376'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
96 (0.265)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
97 (0.178)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63376' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
98 (9.991)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63414'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
99 (1.272)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
100 (28.823)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63414' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
101 (14.352)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '95178'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
102 (1.275)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
103 (0.172)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=95178' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
104 (12.849)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63484'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
105 (0.244)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
106 (0.154)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63484' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
107 (1.040)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '67698'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
108 (0.211)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
109 (0.185)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=67698' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
110 (43.966)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63495'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
111 (0.183)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
112 (0.481)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63495' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
113 (35.095)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63462'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
114 (1.075)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
115 (0.227)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63462' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
116 (11.289)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '67290'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
117 (0.748)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
118 (0.190)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=67290' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
119 (3.987)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63496'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
120 (0.273)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
121 (0.202)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63496' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
122 (2.303)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63385'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
123 (0.212)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
124 (0.173)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63385' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
125 (1.337)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63354'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
126 (0.190)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
127 (0.163)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63354' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
128 (34.614)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63512'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
129 (0.212)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
130 (0.149)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63512' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
131 (1.448)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63423'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
132 (0.184)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
133 (0.137)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63423' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
134 (1.167)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63361'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
135 (0.158)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
136 (0.131)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63361' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
137 (11.916)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63457'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
138 (0.245)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
139 (0.169)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63457' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
140 (1.294)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63397'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
141 (0.162)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
142 (0.131)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63397' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
143 (14.158)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63438'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
144 (3.572)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
145 (1.574)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63438' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
146 (1.613)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63432'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
147 (0.171)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
148 (0.146)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63432' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
149 (35.944)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63459'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
150 (0.312)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
151 (4.337)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63459' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
152 (11.085)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63488'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
153 (0.191)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
154 (0.134)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63488' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
155 (27.453)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '67407'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
156 (0.834)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
157 (0.189)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=67407' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
158 (3.566)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63366'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
159 (1.094)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
160 (0.175)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63366' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
161 (15.159)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63444'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
162 (0.420)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
163 (1.024)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63444' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
164 (26.906)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63429'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
165 (0.254)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
166 (1.692)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63429' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
167 (16.259)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97209'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
168 (0.703)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
169 (0.199)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97209' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
170 (5.923)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97201'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
171 (0.788)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
172 (0.167)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97201' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
173 (2.740)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '63435'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
174 (0.348)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
175 (0.150)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=63435' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
176 (17.758)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97215'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
177 (0.323)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
178 (0.142)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97215' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
179 (9.432)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97216'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
180 (0.672)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
181 (0.172)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97216' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
182 (65.575)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97217'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
183 (0.189)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
184 (0.136)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97217' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
185 (0.198)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97218'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
186 (0.144)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
187 (0.620)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97218' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
188 (4.144)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97219'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
189 (0.545)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
190 (0.155)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97219' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
191 (16.005)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97210'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
192 (1.305)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
193 (2.210)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97210' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
194 (9.505)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '97213'
ORDER BY main_category DESC LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:606
195 (1.165)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'category_id=61' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
196 (0.238)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product_id=97213' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
197 (0.664)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
198 (0.556)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
199 (1.149)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
200 (1.141)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
201 (0.791)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
202 (0.381)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
203 (2.174)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
204 (0.416)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
205 (1.165)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
206 (1.087)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
207 (0.361)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
208 (0.593)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
209 (1.868)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
210 (1.824)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
211 (4.318)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
212 (2.549)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
213 (1.004)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
214 (0.406)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
215 (10.129)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:4
216 (6.527)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:14
217 (0.624)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/column_left'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
218 (15.538)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:4
219 (2.492)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:14
220 (1.544)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/column_right'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
221 (14.792)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:4
222 (1.405)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:14
223 (1.526)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/content_top'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
224 (11.960)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:4
225 (4.109)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/www-root/data/www/3-15.ru/catalog/model/design/layout.php:14
226 (0.828)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/content_bottom'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
227 (6.857)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
228 (88.933)
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
/var/www/www-root/data/www/3-15.ru/catalog/model/catalog/information.php:10
229 (14.889)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information_id=4' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
230 (0.930)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information_id=6' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
231 (0.153)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information_id=3' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
232 (0.155)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information_id=5' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
233 (0.165)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
234 (0.152)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/return/add' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
235 (1.480)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information/sitemap' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
236 (0.663)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
237 (0.698)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/manufacturer' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
238 (0.167)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/voucher' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
239 (0.522)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'affiliate/login' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
240 (0.144)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
241 (1.198)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
242 (2.187)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
243 (0.156)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
244 (0.245)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/newsletter' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
245 (0.140)
SELECT *
FROM oc_module
WHERE module_id = '38'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/module.php:4
246 (0.505)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/footer'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
247 (14.760)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/extension.php:4
248 (0.435)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
249 (2.472)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
250 (0.620)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
251 (0.144)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
252 (0.571)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
253 (0.153)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/account' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
254 (0.649)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/register' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
255 (0.147)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/login' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
256 (0.292)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/order' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
257 (1.854)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/transaction' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
258 (1.911)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/download' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
259 (2.125)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'account/logout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
260 (0.442)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
261 (0.319)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
262 (0.996)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'information/contact' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
263 (4.976)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
264 (2.797)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
265 (32.962)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/language'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
266 (7.260)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
267 (1.168)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
268 (5.013)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'product/special' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
269 (0.178)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/currency'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
270 (52.465)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
271 (0.182)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'blog/latest' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
272 (17.798)
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
/var/www/www-root/data/www/3-15.ru/catalog/model/blog/category.php:16
273 (14.207)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'blog/menu'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
274 (15.513)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
275 (0.263)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/search'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
276 (41.790)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
277 (11.528)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '9ee73d8dd8c205d2a57db07a87'
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:36
278 (0.179)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/extension.php:4
279 (0.173)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
280 (0.156)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '9ee73d8dd8c205d2a57db07a87'
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:36
281 (0.177)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '9ee73d8dd8c205d2a57db07a87'
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:36
282 (2.042)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
283 (0.117)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/www-root/data/www/3-15.ru/system/library/cart/customer.php:122
284 (2.311)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
285 (0.543)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '9ee73d8dd8c205d2a57db07a87'
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:36
286 (1.461)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '9ee73d8dd8c205d2a57db07a87'
/var/www/www-root/data/www/3-15.ru/system/library/cart/cart.php:36
287 (10.348)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
288 (0.189)
SELECT LCASE(keyword) as keyword
FROM oc_seo_url
WHERE query = 'checkout/simplecheckout' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/www-root/data/www/storage315/modification/system/library/seopro.php:466
289 (22.631)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/cart'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
290 (29.382)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'pavmegamenu_params'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/setting.php:6
291 (4.555)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'menu/megamenu' OR route = 'ru-ru')
/var/www/www-root/data/www/3-15.ru/catalog/model/design/translation.php:6
292 (0.854)
SHOW TABLES LIKE 'oc_megamenu'
/var/www/www-root/data/www/3-15.ru/catalog/model/extension/menu/megamenu.php:388
293 (4.353)
SELECT m.*, md.title,md.description
FROM oc_megamenu m
LEFT JOIN oc_megamenu_description md ON m.megamenu_id=md.megamenu_id AND language_id=1
WHERE m.`published`=1 AND store_id=0
ORDER BY `position`
/var/www/www-root/data/www/3-15.ru/catalog/model/extension/menu/megamenu.php:48
294 (6.789)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'extension/module/pavmegamenu'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
295 (26.203)
SELECT *
FROM oc_module
WHERE module_id = '59'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/module.php:4
296 (0.200)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'common/header'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
297 (0.512)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/www-root/data/www/3-15.ru/catalog/model/setting/setting.php:6
298 (0.145)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'webtronics' AND route = 'product/special'
/var/www/www-root/data/www/3-15.ru/catalog/model/design/theme.php:4
