1 (2.255)
SET time_zone = '+00:00'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/framework.php:84
2 (2.113)
DELETE
FROM `session`
WHERE `expire` < '2026-07-23 23:26:12'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/session/db.php:53
3 (7.028)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
4 (4.917)
SELECT `data`
FROM `session`
WHERE `session_id` = '1b43fd3b91ffe6e335d6406471' AND `expire` > '2026-07-23 23:26:13'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/session/db.php:16
5 (3.062)
SHOW TABLES LIKE 'region_allshortcodes_new'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:122
6 (1.084)
SHOW TABLES LIKE 'region_city_new'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:122
7 (1.086)
SHOW TABLES LIKE 'region_default_shortcodes_new'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:122
8 (0.886)
SHOW TABLES LIKE 'region_city_shortcodes_new'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:122
9 (2.043)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:192
10 (2.282)
SHOW TABLES LIKE 'region_city_new'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:43
11 (2.421)
SELECT *
FROM region_city_new
WHERE seo_url = 'msk' AND status = '1'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:51
12 (0.748)
SELECT s.code, cs.value
FROM region_allshortcodes_new s
JOIN region_city_shortcodes_new cs ON s.id = cs.shortcode_id
WHERE cs.city_id = 84 AND s.status = 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/shortcodes.php:219
13 (0.518)
SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://msk.ubiquiti-russia.com/'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:16
14 (6.498)
SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:35
15 (0.251)
SET time_zone = '+03:00'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:50
16 (14.135)
SELECT *
FROM currency
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/currency.php:10
17 (10.946)
SELECT *
FROM seo_url
WHERE `store_id` = '0' AND `language_id` = '1' AND `keyword` = 'korpusa-termoboksy-kejsy-nakladki' LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:383
18 (2.574)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 43200 MINUTE)
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:261
19 (2.722)
SELECT *
FROM cart
WHERE customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:266
20 (9.943)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/tax.php:16
21 (1.226)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/tax.php:44
22 (0.661)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/weight.php:10
23 (2.898)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/length.php:10
24 (0.569)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:15
25 (8.302)
SELECT *
FROM `event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/event.php:4
26 (13.395)
SELECT language_id
FROM language
WHERE code = '0' AND status = '1' LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:659
27 (34.067)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
28 (30.695)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
29 (4.726)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '111' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:4
30 (12.845)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
31 (5.570)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
32 (14.644)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '111' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:10
33 (37.455)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '111' GROUP BY p.product_id
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:778
34 (7.881)
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 category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '111' GROUP BY p.product_id HAVING realprice >=-0.5
ORDER BY (p.quantity>0) DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 24,24
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:368
35 (3.392)
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 = '1707' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
36 (2.711)
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 = '1520' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
37 (4.139)
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 = '1486' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
38 (3.767)
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 = '1521' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
39 (4.020)
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 = '1522' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
40 (0.697)
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 = '1523' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
41 (3.178)
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 = '1524' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
42 (3.989)
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 = '1530' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
43 (1.611)
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 = '1531' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
44 (1.477)
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 = '1532' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
45 (1.386)
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 = '1593' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
46 (0.857)
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 = '1559' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
47 (1.083)
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 = '1558' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
48 (1.412)
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 = '940' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
49 (1.339)
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 = '1149' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
50 (6.613)
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 = '974' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
51 (1.857)
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 = '975' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
52 (0.860)
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 = '1235' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
53 (1.385)
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 = '1507' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:37
54 (19.829)
SELECT count(*) as c
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='ubiquiti-russia.com' AND TABLE_NAME='category' AND COLUMN_NAME='noindex'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/themes899/helper.php:363
55 (2.056)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
56 (12.864)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1707'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
57 (1.250)
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 = '1707' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
58 (3.818)
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 = '1707' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
59 (0.959)
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 = '1707' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
60 (2.891)
SELECT category_id
FROM product_to_category
WHERE product_id = '1707'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
61 (0.348)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
62 (0.502)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1520'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
63 (0.794)
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 = '1520' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
64 (0.722)
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 = '1520' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
65 (2.445)
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 = '1520' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
66 (0.533)
SELECT category_id
FROM product_to_category
WHERE product_id = '1520'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
67 (1.706)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
68 (0.277)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1486'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
69 (0.657)
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 = '1486' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
70 (3.412)
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 = '1486' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
71 (0.641)
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 = '1486' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
72 (7.864)
SELECT category_id
FROM product_to_category
WHERE product_id = '1486'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
73 (3.928)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
74 (3.748)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1521'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
75 (11.907)
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 = '1521' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
76 (1.638)
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 = '1521' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
77 (6.361)
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 = '1521' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
78 (1.551)
SELECT category_id
FROM product_to_category
WHERE product_id = '1521'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
79 (5.758)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
80 (2.490)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1522'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
81 (5.346)
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 = '1522' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
82 (3.178)
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 = '1522' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
83 (0.599)
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 = '1522' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
84 (3.951)
SELECT category_id
FROM product_to_category
WHERE product_id = '1522'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
85 (0.375)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
86 (0.290)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1523'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
87 (1.581)
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 = '1523' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
88 (5.384)
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 = '1523' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
89 (1.475)
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 = '1523' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
90 (0.296)
SELECT category_id
FROM product_to_category
WHERE product_id = '1523'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
91 (1.881)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
92 (3.839)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1524'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
93 (1.687)
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 = '1524' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
94 (0.747)
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 = '1524' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
95 (0.741)
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 = '1524' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
96 (0.485)
SELECT category_id
FROM product_to_category
WHERE product_id = '1524'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
97 (1.535)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
98 (2.260)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1530'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
99 (0.567)
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 = '1530' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
100 (1.574)
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 = '1530' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
101 (5.661)
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 = '1530' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
102 (3.323)
SELECT category_id
FROM product_to_category
WHERE product_id = '1530'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
103 (0.425)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
104 (0.351)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1531'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
105 (0.508)
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 = '1531' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
106 (0.490)
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 = '1531' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
107 (1.198)
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 = '1531' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
108 (1.363)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
109 (3.618)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1532'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
110 (3.739)
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 = '1532' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
111 (1.363)
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 = '1532' 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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
112 (0.532)
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 = '1532' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
113 (0.579)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
114 (0.387)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1593'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
115 (0.404)
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 = '1593' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
116 (0.913)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
117 (0.306)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1559'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
118 (1.112)
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 = '1559' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
119 (3.905)
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 = '1559' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
120 (9.099)
SELECT category_id
FROM product_to_category
WHERE product_id = '1559'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
121 (3.279)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
122 (5.807)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1558'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
123 (0.900)
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 = '1558' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
124 (0.969)
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 = '1558' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
125 (1.051)
SELECT category_id
FROM product_to_category
WHERE product_id = '1558'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
126 (5.430)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
127 (6.178)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '940'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
128 (2.557)
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 = '940' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
129 (0.705)
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 = '940' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
130 (0.810)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
131 (0.261)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1149'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
132 (7.016)
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 = '1149' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
133 (1.700)
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 = '1149' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
134 (5.795)
SELECT category_id
FROM product_to_category
WHERE product_id = '1149'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
135 (3.560)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
136 (0.402)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '974'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
137 (0.504)
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 = '974' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
138 (2.033)
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 = '974' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
139 (0.708)
SELECT category_id
FROM product_to_category
WHERE product_id = '974'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
140 (2.639)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
141 (3.156)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '975'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
142 (4.895)
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 = '975' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
143 (20)
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 = '975' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
144 (0.790)
SELECT category_id
FROM product_to_category
WHERE product_id = '975'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
145 (4.593)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
146 (1.274)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1235'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
147 (3.102)
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 = '1235' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
148 (0.505)
SELECT category_id
FROM product_to_category
WHERE product_id = '1235'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
149 (3.889)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
150 (0.404)
SELECT COUNT(*) AS total
FROM customer_wishlist
WHERE product_id = '1507'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/account/wishlist.php:84
151 (3.875)
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 = '1507' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:512
152 (1.714)
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 = '1507' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/product.php:517
153 (3.930)
SELECT category_id
FROM product_to_category
WHERE product_id = '1507'
ORDER BY main_category DESC LIMIT 1
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:685
154 (43.216)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
155 (26.989)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
156 (76.588)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category_grid'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
157 (2.487)
SELECT *
FROM category_to_layout
WHERE category_id = '111' AND store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:58
158 (0.629)
SELECT COUNT(*) as total
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'ubiquiti-russia.com' AND TABLE_NAME = 'ocdevwizard_setting'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/helper.php:55
159 (15.762)
SELECT *
FROM ocdevwizard_setting
WHERE store_id = '0' AND `key` = 'form_builder_form_data'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/helper.php:15
160 (19.811)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14
161 (0.892)
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 = '3' AND f.position = 'column_left' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15
162 (1.161)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
163 (22.597)
SELECT *
FROM category_to_layout
WHERE category_id = '111' AND store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:58
164 (4.668)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14
165 (4.781)
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 = '3' AND f.position = 'column_right' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15
166 (12.177)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
167 (10.299)
SELECT *
FROM category_to_layout
WHERE category_id = '111' AND store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:58
168 (4.601)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14
169 (0.822)
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 = '3' AND f.position = 'content_top' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15
170 (2.860)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
171 (21.573)
SELECT *
FROM category_to_layout
WHERE category_id = '111' AND store_id = '0'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/catalog/category.php:58
172 (5.215)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14
173 (1.911)
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 = '3' AND f.position = 'content_bottom' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15
174 (0.338)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
175 (41.425)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/fx' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
176 (0.464)
SELECT language_id
FROM language
WHERE code = 'ru-ru'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:741
177 (4.622)
SELECT form_id
FROM ocdw_form_builder_form
WHERE display_type IN (1,3) AND selector_module_call_status = '1'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:39
178 (7.622)
SELECT *
FROM extension
WHERE `type` = 'analytics'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/extension.php:4
179 (14.689)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
180 (9.709)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
181 (12.456)
SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/model/setting/setting.php:6
182 (13.500)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
183 (2.993)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
184 (14.116)
SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275
185 (6.280)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
186 (22.368)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
187 (3.655)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
188 (38.986)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
189 (5.961)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
190 (14.200)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
191 (2.731)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
192 (22.612)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
193 (12.777)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
194 (13.335)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
195 (10.684)
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/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/blog/category.php:16
196 (3.922)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'blog/menu'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
197 (33.191)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
198 (3.648)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
199 (31.960)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
200 (3.377)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
201 (1.164)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/extension.php:4
202 (19.146)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
203 (0.479)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
204 (0.307)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
205 (20.611)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
206 (0.435)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
207 (14.529)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
208 (3.958)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
209 (11.770)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
210 (3.905)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
211 (1.562)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
212 (14.924)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
213 (3.237)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1b43fd3b91ffe6e335d6406471'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36
214 (3.840)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
215 (0.565)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
216 (21.404)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/fx' OR route = 'ru-ru')
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6
217 (57.514)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
218 (33.229)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_5'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
219 (35.081)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
220 (31.465)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category'
/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4
