Queries: 223, Total time: 539.941 ms [By time] [By id] [By file]
1 (0.048)
SET time_zone = '+00:00'
/var/www/bx-russia.com/data/www/bx-russia.com/system/framework.php:84
2 (5.967)
DELETE
FROM `session`
WHERE `expire` < '2026-10-03 11:00:40'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/session/db.php:53
3 (5.152)
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 (2.097)
SET SQL_BIG_SELECTS = 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/opencart.php:31
5 (1.784)
SHOW TABLES LIKE 'ocfilter_setting'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:10
6 (11.838)
SELECT *
FROM ocfilter_setting
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:18
7 (6.255)
DELETE
FROM ocfilter_cache
WHERE `expire` < '1791025240'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/core.php:78
8 (0.240)
SELECT `data`
FROM `session`
WHERE `session_id` = 'c799b35da8162f2d68bbc15624' AND `expire` > '2026-10-03 11:00:40'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/session/db.php:16
9 (1.822)
SHOW TABLES LIKE 'region_allshortcodes_new'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:100
10 (5.999)
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
11 (7.313)
SHOW TABLES LIKE 'region_city_new'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/shortcodes.php:39
12 (12.275)
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
13 (8.577)
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
14 (1.783)
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
15 (1.489)
SET time_zone = '+03:00'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/controller/startup/startup.php:50
16 (2.273)
SELECT *
FROM currency
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/cart/currency.php:10
17 (5.202)
SELECT *
FROM seo_url
WHERE `store_id` = '0' AND `language_id` = '1' AND `keyword` = 'baxi' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/controller/jetcache/jetcache.php:383
18 (0.934)
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
19 (0.285)
SELECT *
FROM cart
WHERE customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/controller/jetcache/jetcache.php:266
20 (7.630)
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
21 (4.782)
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
22 (4.506)
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
23 (2.867)
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
24 (0.475)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 30 DAY)
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:15
25 (1.714)
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
26 (1.707)
SELECT language_id
FROM seo_url
WHERE keyword = 'baxi' AND store_id = '0' LIMIT 1
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/seopro.php:673
27 (0.936)
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
28 (3.027)
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
29 (0.805)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/manufacturer' OR route = 'ru-ru')
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/translation.php:6
30 (2.963)
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
31 (7.913)
SELECT DISTINCT *
FROM manufacturer m
LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '22' AND md.language_id = '1' AND m2s.store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/manufacturer.php:17
32 (4.894)
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
33 (0.274)
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
34 (6.691)
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
35 (6.456)
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
36 (5.709)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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 (1.505)
SELECT *
FROM layout_module
WHERE layout_id = '17' AND `code` = 'ocfilter'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/core.php:78
38 (2.772)
SELECT *
FROM ocfilter_setting
WHERE `key` = 'placement_layout'
/var/www/bx-russia.com/data/www/bx-russia.com/system/library/ocfilter/setting.php:68
39 (17.750)
SELECT COUNT(DISTINCT p.product_id) AS total
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)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '22' GROUP BY p.product_id
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:820
40 (46.309)
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_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 p.manufacturer_id = '22' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 160,20
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:389
41 (9.473)
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 = '196' 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
42 (2.948)
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 = '167' 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
43 (7.633)
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 = '56' 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
44 (1.095)
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 = '19' 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
45 (0.920)
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 = '219' 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
46 (4.976)
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 = '393' 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
47 (1.453)
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 = '396' 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 (0.891)
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 = '329' 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 (0.777)
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 = '399' 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 (1.061)
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 = '113' 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.841)
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 = '438' 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 (3.287)
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 = '418' 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 (6.212)
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 = '380' 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 (8.375)
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 = '421' 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 (0.812)
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 = '353' 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 (0.734)
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 = '359' 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.028)
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 = '373' 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 (0.741)
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 = '260' 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 (1.798)
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 = '135' 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 (2.408)
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 = '272' 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 (2.305)
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
62 (3.167)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
63 (0.855)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '196'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
64 (16.498)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '196' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
65 (1.025)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '196' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
66 (0.367)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
67 (0.182)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '167'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
68 (0.422)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '167' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
69 (0.416)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '167' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
70 (0.851)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
71 (0.179)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '56'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
72 (0.583)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '56' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
73 (0.301)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '56' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
74 (0.217)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
75 (0.401)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '19'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
76 (0.299)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '19' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
77 (0.260)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '19' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
78 (0.322)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
79 (0.239)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '219'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
80 (0.326)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '219' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
81 (0.660)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '219' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
82 (0.247)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
83 (5.972)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '393'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
84 (1.915)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '393' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
85 (5.364)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '393' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
86 (6.231)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
87 (3.993)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '396'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
88 (1.448)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '396' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
89 (0.463)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '396' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
90 (1.187)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
91 (0.160)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '329'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
92 (0.338)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '329' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
93 (1.206)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '329' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
94 (0.661)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
95 (0.408)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '399'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
96 (1.529)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '399' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
97 (0.575)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '399' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
98 (4.573)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
99 (0.723)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '113'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
100 (2.033)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '113' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
101 (0.360)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '113' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
102 (0.875)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
103 (0.157)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '438'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
104 (2.515)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '438' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
105 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '438' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
106 (0.229)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
107 (0.307)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '418'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
108 (1.125)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '418' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
109 (0.291)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '418' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
110 (1.817)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
111 (0.278)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '380'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
112 (0.288)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '380' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
113 (0.319)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '380' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
114 (0.959)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
115 (0.171)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '421'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
116 (0.301)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '421' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
117 (3.839)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '421' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
118 (0.270)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
119 (0.171)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '353'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
120 (0.272)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '353' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
121 (0.282)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '353' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
122 (7.115)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
123 (1.099)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '359'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
124 (5.888)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '359' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
125 (0.420)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '359' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
126 (0.284)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
127 (0.221)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '373'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
128 (0.354)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '373' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
129 (1.315)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '373' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
130 (0.284)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
131 (0.656)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '260'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
132 (10.031)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '260' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
133 (1.498)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '260' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
134 (1.950)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
135 (0.461)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '135'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
136 (1.929)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '135' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
137 (1.196)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '135' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
138 (1.695)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
139 (0.187)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '272'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
140 (0.362)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '272' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:540
141 (1.369)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '272' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/catalog/model/catalog/product.php:545
142 (3.584)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/microdatapro/category_manufacturer'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
143 (5.787)
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
144 (1.292)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category_grid'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4
145 (1.680)
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
146 (0.864)
SELECT *
FROM manufacturer_to_layout
WHERE manufacturer_id = '22' AND store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/manufacturer.php:8
147 (2.574)
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
148 (25)
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
149 (0.650)
SELECT *
FROM layout_module
WHERE layout_id = '17' AND position = 'column_left'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
150 (4.117)
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 = '17' 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
151 (1.301)
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
152 (2.998)
SELECT *
FROM manufacturer_to_layout
WHERE manufacturer_id = '22' AND store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/manufacturer.php:8
153 (0.605)
SELECT *
FROM layout_module
WHERE layout_id = '17' AND position = 'column_right'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
154 (0.576)
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 = '17' 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
155 (0.570)
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
156 (2.201)
SELECT *
FROM manufacturer_to_layout
WHERE manufacturer_id = '22' AND store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/manufacturer.php:8
157 (0.821)
SELECT *
FROM layout_module
WHERE layout_id = '17' AND position = 'content_top'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
158 (0.290)
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 = '17' 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
159 (0.706)
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
160 (2.311)
SELECT *
FROM manufacturer_to_layout
WHERE manufacturer_id = '22' AND store_id = '0'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/catalog/manufacturer.php:8
161 (0.357)
SELECT *
FROM layout_module
WHERE layout_id = '17' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/layout.php:14
162 (1.860)
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 = '17' 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
163 (1.379)
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
164 (3.041)
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
165 (0.285)
SELECT LCASE(keyword) as keyword
FROM seo_url
WHERE query = 'product/manufacturer/info' 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
166 (0.172)
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
167 (0.725)
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
168 (4.188)
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
169 (4.387)
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
170 (0.322)
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
171 (0.426)
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
172 (0.296)
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
173 (5.716)
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
174 (0.310)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
175 (0.970)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
176 (0.485)
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
177 (0.996)
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
178 (0.426)
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
179 (0.387)
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
180 (3.089)
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
181 (1.321)
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
182 (0.212)
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
183 (3.406)
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
184 (0.316)
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
185 (0.175)
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
186 (2.618)
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
187 (2.447)
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
188 (0.428)
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
189 (1.512)
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
190 (5.227)
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
191 (6.607)
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
192 (10.443)
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
193 (1.858)
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
194 (4.047)
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
195 (3.021)
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
196 (2.853)
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
197 (0.327)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
198 (6.414)
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
199 (0.365)
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
200 (0.680)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
201 (0.216)
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
202 (0.401)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
203 (0.864)
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
204 (0.427)
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
205 (3.338)
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
206 (0.495)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
207 (1.747)
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
208 (0.297)
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
209 (0.569)
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
210 (0.212)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
211 (0.134)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
212 (0.175)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
213 (0.173)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c799b35da8162f2d68bbc15624'
/var/www/bx-russia.com/data/www/bx-russia.com/system/storage/modification/system/library/cart/cart.php:36
214 (0.277)
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
215 (0.861)
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
216 (3.479)
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
217 (105)
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
218 (0.334)
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
219 (0.321)
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
220 (0.372)
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
221 (1.980)
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
222 (0.196)
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
223 (0.200)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/manufacturer_info'
/var/www/bx-russia.com/data/www/bx-russia.com/catalog/model/design/theme.php:4