1 (0.131)
SET time_zone = '+00:00'
/var/www/bx-russia.com/data/www/bx-russia.com/system/framework.php:84
2 (2.423)
DELETE
FROM `session`
WHERE `expire` < '2026-07-25 20:06:39'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/session/db.php:53
3 (0.822)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
4 (0.168)
SET SQL_BIG_SELECTS = 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/opencart.php:31
5 (0.779)
SHOW TABLES LIKE 'ocfilter_setting'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:10
6 (0.738)
SELECT *
FROM ocfilter_setting
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:18
7 (0.259)
SELECT `data`
FROM `session`
WHERE `session_id` = '6ce897e666ee74a495f213a3e5' AND `expire` > '2026-07-25 20:06:39'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/session/db.php:16
8 (0.990)
SHOW TABLES LIKE 'region_allshortcodes_new'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:100
9 (11.193)
SELECT s.code, COALESCE(ds.value, '') as value
FROM region_allshortcodes_new s
LEFT JOIN region_default_shortcodes_new ds ON s.id = ds.shortcode_id
WHERE s.status = 1
ORDER BY s.sort_order, s.code
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:121
10 (1.077)
SHOW TABLES LIKE 'region_city_new'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:39
11 (0.702)
SELECT *
FROM region_city_new
WHERE seo_url = 'bx-russia' AND status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:47
12 (0.671)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://bx-russia.com/'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/startup.php:16
13 (6.510)
SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/startup.php:35
14 (0.190)
SET time_zone = '+03:00'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/startup.php:50
15 (0.566)
SELECT *
FROM currency
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/cart/currency.php:10
16 (5.873)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 43200 MINUTE)
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/controller/jetcache/jetcache.php:261
17 (4.779)
SELECT *
FROM cart
WHERE customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/controller/jetcache/jetcache.php:266
18 (16.993)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/tax.php:16
19 (0.760)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/tax.php:44
20 (0.860)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/cart/weight.php:10
21 (4.551)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/cart/length.php:10
22 (0.265)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:15
23 (0.738)
SELECT *
FROM `event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/setting/event.php:4
24 (0.647)
SELECT language_id
FROM seo_url
WHERE keyword = '' AND store_id = '0' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:673
25 (0.435)
SELECT code
FROM language
WHERE language_id = '1' AND status = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:677
26 (0.193)
SELECT language_id
FROM language
WHERE code = '0' AND status = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:687
27 (0.497)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
28 (0.435)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
29 (0.361)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
30 (1.219)
SELECT *
FROM layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:4
31 (0.351)
SELECT COUNT(*) as total
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'bx-russia.com' AND TABLE_NAME = 'ocdevwizard_setting'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/extension/ocdevwizard/helper.php:55
32 (0.575)
SELECT *
FROM ocdevwizard_setting
WHERE store_id = '0' AND `key` = 'form_builder_form_data'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/extension/ocdevwizard/helper.php:15
33 (0.619)
SELECT *
FROM layout_module
WHERE layout_id = '1' AND position = 'column_left'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
34 (0.785)
SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '1' AND f.position = 'column_left' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:15
35 (0.854)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
36 (0.309)
SELECT *
FROM layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:4
37 (0.254)
SELECT *
FROM layout_module
WHERE layout_id = '1' AND position = 'column_right'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
38 (0.303)
SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '1' AND f.position = 'column_right' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:15
39 (0.236)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
40 (0.307)
SELECT *
FROM layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:4
41 (0.249)
SELECT *
FROM layout_module
WHERE layout_id = '1' AND position = 'content_top'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
42 (0.287)
SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '1' AND f.position = 'content_top' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:15
43 (5.054)
SELECT *
FROM module
WHERE module_id = '45'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/setting/module.php:4
44 (0.360)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/featured' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
45 (0.258)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
46 (0.526)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
47 (3.986)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '197' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
48 (1.203)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
49 (1.260)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '30' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
50 (6.696)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '465' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
51 (1.196)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
52 (1.036)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
53 (1.010)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
54 (7.795)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '159' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
55 (6.577)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '40' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
56 (1.133)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '107' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
57 (1.100)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '66' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
58 (1.052)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
59 (0.882)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '69' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
60 (0.956)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '198' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
61 (0.858)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '171' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
62 (0.885)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '467' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
63 (0.652)
SELECT count(*) as c
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='bx-russia.com' AND TABLE_NAME='category' AND COLUMN_NAME='noindex'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/themes899/helper.php:363
64 (1.308)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
65 (0.649)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '197'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
66 (0.331)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
67 (0.242)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
68 (0.266)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
69 (0.205)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '154'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
70 (0.242)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
71 (0.215)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
72 (1.293)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
73 (0.234)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '30'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
74 (0.316)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
75 (0.229)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '465'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
76 (0.261)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
77 (0.248)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '464'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
78 (0.258)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
79 (0.241)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
80 (0.249)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
81 (0.199)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '168'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
82 (0.203)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
83 (0.224)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
84 (0.271)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
85 (0.199)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '39'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
86 (0.243)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
87 (0.218)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '159'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
88 (0.266)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
89 (0.233)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '40'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
90 (0.264)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
91 (0.221)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
92 (0.271)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
93 (0.203)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '107'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
94 (0.249)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
95 (0.191)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '66'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
96 (0.296)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
97 (0.269)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '145'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
98 (0.263)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
99 (0.316)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
100 (0.250)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
101 (0.225)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '69'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
102 (0.236)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
103 (0.188)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '198'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
104 (0.207)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
105 (0.181)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '171'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
106 (0.199)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
107 (0.211)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '467'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
108 (0.289)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_product_tabs'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
109 (0.598)
SELECT *
FROM module
WHERE module_id = '66'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/setting/module.php:4
110 (0.477)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_category' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
111 (4.038)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
112 (0.848)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '6' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
113 (0.798)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '27' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
114 (0.545)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '54' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
115 (0.534)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
116 (0.501)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '38' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
117 (0.531)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '51' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
118 (0.491)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '47' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
119 (6.692)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '28' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
120 (4.342)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '39' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
121 (0.498)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '40' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
122 (0.489)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '42' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
123 (0.642)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '43' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
124 (0.470)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '44' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
125 (0.470)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '48' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
126 (0.651)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
127 (0.496)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '19' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
128 (14.174)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
129 (0.792)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
130 (0.546)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '23' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
131 (0.494)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '21' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
132 (0.806)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
133 (0.500)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
134 (0.440)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '46' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
135 (0.462)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
136 (0.458)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
137 (0.427)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
138 (0.408)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '9' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
139 (0.456)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
140 (0.469)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
141 (0.703)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
142 (0.546)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '29' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
143 (0.895)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '13' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
144 (0.705)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '12' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
145 (1.097)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '35' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
146 (0.505)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '22' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
147 (0.672)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
148 (2.097)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
149 (0.538)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '55' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
150 (0.984)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '30' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
151 (0.843)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '33' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
152 (0.414)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '31' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
153 (3.575)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '2' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
154 (0.468)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
155 (1.723)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '36' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
156 (1.504)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
157 (0.667)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '16' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
158 (0.470)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '32' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
159 (0.476)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '34' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
160 (0.500)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '45' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
161 (0.500)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
162 (0.470)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '5' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
163 (0.491)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
164 (0.544)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
165 (0.442)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
166 (0.434)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '49' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
167 (7.057)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
168 (0.995)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '14' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
169 (0.472)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '37' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
170 (0.527)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
171 (1.539)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '15' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
172 (0.549)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '26' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
173 (0.347)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_category'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
174 (1.240)
SELECT *
FROM module
WHERE module_id = '65'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/setting/module.php:4
175 (0.327)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/featured' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
176 (0.264)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
177 (0.515)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
178 (0.284)
SELECT *
FROM ocfilter_setting
WHERE `key` = 'placement_layout'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:68
179 (3.985)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM 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 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, coalesce((SELECT price
FROM 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), (SELECT price
FROM 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), p.price) as realprice, p.quantity
FROM product p
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (62,38,51,47) GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,16
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:389
180 (7.727)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
181 (1.818)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '197' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
182 (2.326)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '39' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
183 (2.072)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '75' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
184 (2.331)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '106' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
185 (1.133)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '144' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
186 (3.340)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '545' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
187 (1.312)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '465' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
188 (1.670)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '466' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
189 (2.585)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '463' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
190 (2.108)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
191 (2.888)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '47' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
192 (1.155)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '83' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
193 (1.799)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '120' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
194 (2.086)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
195 (2.604)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '157' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
196 (1.144)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
197 (0.814)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '168'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
198 (0.525)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
199 (0.310)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
200 (0.412)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
201 (0.290)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '197'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
202 (0.392)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
203 (0.477)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
204 (0.363)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
205 (0.293)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '39'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
206 (0.395)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
207 (0.286)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '75'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
208 (0.470)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
209 (0.357)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
210 (0.353)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
211 (0.314)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '106'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
212 (0.304)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
213 (0.281)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '144'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
214 (0.355)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
215 (0.297)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
216 (0.290)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
217 (0.227)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '545'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
218 (0.297)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
219 (0.228)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '465'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
220 (0.284)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
221 (0.279)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '466'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
222 (0.301)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
223 (0.264)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
224 (0.367)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
225 (0.267)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '463'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
226 (0.270)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
227 (0.333)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
228 (0.312)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
229 (0.254)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '464'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
230 (0.293)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
231 (0.284)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
232 (0.544)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
233 (0.314)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '47'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
234 (0.261)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
235 (0.239)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '83'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
236 (0.426)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
237 (0.272)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '120'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
238 (0.332)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
239 (0.331)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
240 (0.279)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
241 (0.261)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '154'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
242 (0.330)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
243 (0.281)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
244 (0.520)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
245 (0.274)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '157'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
246 (4.756)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM 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 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, coalesce((SELECT price
FROM 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), (SELECT price
FROM 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), p.price) as realprice, p.quantity
FROM product p
LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (39,40,41,8) GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,16
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:389
247 (1.919)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '40' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
248 (1.288)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '107' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
249 (1.728)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '66' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
250 (1.236)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
251 (2.065)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '170' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
252 (4.869)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '140' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
253 (4.771)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '171' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
254 (2.054)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '198' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
255 (2.122)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '41' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
256 (1.800)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '69' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
257 (1.586)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
258 (1.442)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '199' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
259 (1.395)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
260 (1.332)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '51' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
261 (1.336)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '89' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
262 (1.311)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '127' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
263 (3.947)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
264 (0.340)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '40'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
265 (0.711)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
266 (0.291)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
267 (0.277)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
268 (0.222)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '107'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
269 (0.398)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
270 (0.277)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '66'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
271 (0.308)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
272 (0.249)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '145'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
273 (0.337)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
274 (0.267)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
275 (0.307)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
276 (0.245)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '170'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
277 (0.283)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
278 (0.301)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '140'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
279 (0.383)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
280 (0.240)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '171'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
281 (0.341)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
282 (0.288)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '198'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
283 (0.322)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
284 (0.336)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '41'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
285 (0.319)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
286 (0.270)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '69'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
287 (0.343)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
288 (0.271)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '108'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
289 (0.334)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
290 (0.276)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '199'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
291 (0.355)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
292 (0.314)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '14'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
293 (0.335)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
294 (0.282)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '51'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
295 (0.287)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
296 (0.263)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '89'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
297 (0.272)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
298 (0.336)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
299 (0.320)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
300 (0.253)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '127'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
301 (0.393)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_product_tabs'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
302 (0.447)
SELECT *
FROM module
WHERE module_id = '44'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/setting/module.php:4
303 (0.411)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
304 (0.785)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
305 (0.394)
SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:291
306 (3.630)
SELECT *
FROM prostore_news i
LEFT JOIN prostore_news_description id ON (i.news_id = id.news_id)
LEFT JOIN prostore_news_to_store i2s ON (i.news_id = i2s.news_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.date_added DESC LIMIT 0,10
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/extension/module/prostorenews.php:10
307 (0.344)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
308 (0.376)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
309 (0.289)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
310 (0.278)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
311 (0.305)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
312 (0.300)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
313 (0.418)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
314 (0.274)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
315 (0.309)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
316 (0.274)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
317 (0.394)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_news_list'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
318 (0.423)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
319 (1.700)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
320 (0.278)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_subscribe'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
321 (0.398)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
322 (0.427)
SELECT *
FROM layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:4
323 (0.453)
SELECT *
FROM layout_module
WHERE layout_id = '1' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
324 (0.425)
SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '1' AND f.position = 'content_bottom' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:15
325 (0.350)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
326 (0.326)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
327 (2.379)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:10
328 (0.419)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/microdatapro/company'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
329 (0.763)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'information/tracking' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
330 (0.248)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'information/regions' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
331 (1.090)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
332 (0.281)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
333 (0.267)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
334 (0.305)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/captcha/google'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
335 (0.368)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
336 (0.317)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
337 (0.304)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
338 (7.658)
SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:291
339 (0.431)
SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:291
340 (0.610)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
341 (1.219)
SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoresoclinks'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/setting/setting.php:6
342 (0.925)
SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/setting/setting.php:6
343 (1.099)
SELECT *
FROM country
WHERE country_id = '176' AND status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/localisation/country.php:4
344 (18)
SELECT *
FROM zone
WHERE zone_id = '2761' AND status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/localisation/zone.php:4
345 (0.531)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
346 (0.521)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
347 (0.489)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
348 (0.367)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
349 (0.351)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
350 (0.550)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
351 (0.321)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
352 (0.457)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '14' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
353 (0.293)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
354 (0.379)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/footer'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
355 (0.442)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
356 (0.303)
SELECT language_id
FROM language
WHERE code = 'ru-ru'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:741
357 (0.481)
SELECT form_id
FROM ocdw_form_builder_form
WHERE display_type IN (1,3) AND selector_module_call_status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/extension/ocdevwizard/form_builder.php:39
358 (0.616)
SELECT *
FROM extension
WHERE `type` = 'analytics'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/setting/extension.php:4
359 (0.339)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
360 (0.267)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
361 (0.273)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
362 (0.258)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
363 (0.242)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
364 (1.035)
SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/setting/setting.php:6
365 (0.354)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
366 (0.231)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
367 (0.697)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
368 (0.242)
SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:291
369 (0.307)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
370 (0.309)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
371 (0.265)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
372 (0.275)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
373 (0.240)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/language/language' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
374 (0.223)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
375 (0.264)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
376 (0.250)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
377 (0.234)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
378 (0.292)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
379 (0.235)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
380 (0.222)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/currency/currency' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
381 (0.246)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'common/home' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
382 (0.225)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
383 (0.252)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
384 (0.755)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'blog/latest' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
385 (7.592)
SELECT *
FROM blog_category c
LEFT JOIN blog_category_description cd ON (c.blog_category_id = cd.blog_category_id)
LEFT JOIN 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/bx-russia.com/data/www/bx-russia.com/catalog/model/blog/category.php:16
386 (0.274)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'blog/menu'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
387 (0.264)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
388 (0.212)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
389 (0.269)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
390 (0.300)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
391 (0.252)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/setting/extension.php:4
392 (0.256)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
393 (1.290)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
394 (0.329)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
395 (0.281)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
396 (0.303)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
397 (0.335)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/captcha/google'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
398 (0.300)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
399 (0.832)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
400 (0.278)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
401 (0.680)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
402 (0.265)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
403 (0.245)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
404 (0.276)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
405 (0.213)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
406 (0.220)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6ce897e666ee74a495f213a3e5'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
407 (0.352)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'checkout/cart' AND store_id = '0' AND language_id = '1' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:569
408 (0.289)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
409 (0.252)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
410 (0.293)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
411 (0.299)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/menu'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
412 (0.402)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/fx' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
413 (0.285)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
414 (0.507)
SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/information.php:4
415 (0.238)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
416 (0.276)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_5'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
417 (0.290)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
418 (0.311)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/home'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
На складе
Артикул: 7814105 Настенный газовый котёл ECO Life 1.24 F (одноконтурный) - 7814105
Под заказ
Артикул: 7104651 Настенный газовый конденсационный котел LUNA Duo-tec MP+ 1.90 - 7104651
На складе
Артикул: CSE45224358 Котел газовый настенный BAXI LUNA-3 Comfort 240 i - CSE45224358-
На складе
Артикул: CSE45531358 Котел газовый настенный BAXI LUNA-3 Comfort 1.310 Fi - CSE45531358-
На складе
Артикул: CSE45124358 Котел газовый настенный BAXI LUNA-3 Comfort 1.240 i - CSE45124358-
Под заказ
Артикул: A7810405 Уличный газовый конденсационный котел Baxi LUNA AIR 28 - A7810405
На складе
Артикул: 100023941 Котел газовый настенный BAXI ECO Nova 1.24F (NEW 2025) одноконтурный
На складе
Артикул: 7814108 Настенный газовый котёл ECO Life 1.31 F (одноконтурный) - 7814108
На складе
Артикул: CSE45524358 Котел газовый настенный BAXI LUNA-3 Comfort 1.240 Fi - CSE45524358-
На складе
Артикул: CSE45624358 Котел газовый настенный BAXI LUNA-3 Comfort 240 Fi - CSE45624358-
На складе
Артикул: CSE45631358 Котел газовый настенный BAXI LUNA-3 Comfort 310 Fi - CSE45631358-
На складе
Артикул: 7219693 Котел газовый настенный конденсационный BAXI LUNA Platinum+ 33 - 7219693
На складе
Артикул: A7720022 Котел газовый настенный конденсационный BAXI LUNA Duo-tec E 1.12 - A7720022
На складе
Артикул: A7720023 Котел газовый настенный конденсационный BAXI LUNA Duo-tec E 1.24 - A7720023
На складе
Артикул: A7720024 Котел газовый настенный конденсационный BAXI LUNA Duo-tec E 1.28 - A7720024
На складе
Артикул: A7720025 Котел газовый настенный конденсационный BAXI LUNA Duo-tec E 24 - A7720025
