22222
Queries: 458, Total time: 114.576 ms [By time] [By id] [By file]
1 (0.234)
SELECT `data`
FROM `oc_session`
WHERE session_id = '0f9810ad7f5be294cce2b2a41f' AND expire > 1594499729
/var/www/u0795645/data/www/svechi.site/system/library/session/db.php:21
2 (0.276)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/u0795645/data/www/svechi.site/system/library/openbay.php:61
3 (0.184)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
4 (0.046)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/u0795645/data/www/svechi.site/system/library/openbay.php:61
5 (0.227)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'e103c933630cc04ee45933bc44' AND expire > 1594499729
/var/www/u0795645/data/www/svechi.site/system/library/session/db.php:21
6 (0.379)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://svechi.site/'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/controller/startup/startup.php:6
7 (3.849)
SELECT *
FROM `oc_setting`
WHERE store_id = 0
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/controller/startup/startup.php:30
8 (0.268)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/u0795645/data/www/svechi.site/catalog/model/localisation/language.php:15
9 (0.186)
SELECT *
FROM oc_currency
ORDER BY title ASC
/var/www/u0795645/data/www/svechi.site/catalog/model/localisation/currency.php:15
10 (0.138)
SELECT *
FROM oc_currency
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/cart/currency.php:10
11 (0.506)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2807')
ORDER BY tr1.priority ASC
/var/www/u0795645/data/www/svechi.site/system/library/cart/tax.php:16
12 (0.336)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2807')
ORDER BY tr1.priority ASC
/var/www/u0795645/data/www/svechi.site/system/library/cart/tax.php:44
13 (0.250)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/u0795645/data/www/svechi.site/system/library/cart/weight.php:10
14 (0.243)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/u0795645/data/www/svechi.site/system/library/cart/length.php:10
15 (0.221)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 36 HOUR)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/cart/cart.php:33
16 (0.046)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/u0795645/data/www/svechi.site/system/library/openbay.php:61
17 (1.764)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/u0795645/data/www/svechi.site/catalog/model/setting/event.php:4
18 (0.331)
SELECT language_id
FROM oc_seo_url
WHERE keyword = 'voskovye-svechi-cvetnie' AND store_id = '0' LIMIT 1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/seopro.php:570
19 (0.185)
SELECT code
FROM oc_language
WHERE language_id = '1' AND status = '1' LIMIT 1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/seopro.php:574
20 (0.170)
SELECT language_id
FROM oc_language
WHERE code = '0' AND status = '1' LIMIT 1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/seopro.php:584
21 (0.161)
SELECT category_id, parent_id
FROM oc_category
ORDER BY parent_id
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/seopro.php:378
22 (0.326)
SELECT keyword, query, store_id, language_id
FROM oc_seo_url
WHERE 1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/seopro.php:415
23 (0.219)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
24 (0.301)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
25 (0.114)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
26 (0.960)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
27 (0.898)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '7389'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:907
28 (1.808)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '7388'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:907
29 (1.419)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '7390'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:907
30 (0.724)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '7381'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:907
31 (0.417)
SELECT COUNT(*) AS total
FROM ( SELECT p.product_id, p.price, p.sort_order, p.quantity, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p2c.category_id = '7385' GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:747
32 (0.592)
SELECT p.product_id, p.price, p.sort_order, p.quantity, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price))) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p2c.category_id = '7385' AND pd.language_id = '1' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY field(p.quantity, 10000, 100, 50, 25, 0), actual_price ASC, pd.name ASC LIMIT 0, 48
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:143
33 (0.199)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
34 (0.052)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
35 (1.491)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'moytop_main_category_key'
/var/www/u0795645/data/www/svechi.site/catalog/model/setting/setting.php:6
36 (0.133)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
37 (1.277)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
38 (0.743)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
39 (1.764)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
40 (1.992)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
41 (0.558)
SELECT *
FROM oc_module
WHERE module_id = '47'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
42 (1.874)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, agd.name AS group_name, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN ( SELECT p.*
FROM `oc_product` AS p
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p2c.category_id = '7385') AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
INNER JOIN `oc_attribute_group` AS ag ON (ag.attribute_group_id = a.attribute_group_id)
INNER JOIN `oc_attribute_group_description` AS agd ON (agd.attribute_group_id = a.attribute_group_id)
INNER JOIN `oc_product_to_store` AS ps ON (p.product_id = ps.product_id)
WHERE agd.language_id = '1' AND ad.language_id = '1' AND av.language_id = '1' AND ps.store_id = '0' AND p.status = 1 GROUP BY av.attribute_value_id
ORDER BY ag.sort_order, ag.attribute_group_id, a.sort_order, ad.name, av.sort_order, av.value
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/brainyfilter.php:988
43 (0.401)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
44 (0.377)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/pagination' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
45 (0.156)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
46 (0.433)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '7385' AND store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:58
47 (0.594)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:4
48 (0.585)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:14
49 (0.584)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
50 (0.621)
SELECT *
FROM oc_mega_menu
WHERE parent_id='0' AND status='0' AND module_id = '36'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:23
51 (0.242)
SELECT *
FROM oc_mega_menu
WHERE parent_id='89' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
52 (0.831)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
53 (0.294)
SELECT *
FROM oc_mega_menu
WHERE parent_id='143' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
54 (0.310)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '6' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
55 (0.358)
SELECT *
FROM oc_mega_menu
WHERE parent_id='102' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
56 (0.255)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '11' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
57 (0.249)
SELECT *
FROM oc_mega_menu
WHERE parent_id='156' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
58 (0.237)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
59 (0.213)
SELECT *
FROM oc_mega_menu
WHERE parent_id='167' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
60 (0.837)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
61 (0.065)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
62 (0.054)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
63 (0.046)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
64 (0.047)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
65 (0.049)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
66 (0.631)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
67 (0.519)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
68 (0.474)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
69 (0.174)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/uni_megamenu/main_menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
70 (0.148)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/uni_megamenu/left_menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
71 (0.215)
SELECT *
FROM oc_module
WHERE module_id = '55'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
72 (0.252)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/tags' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
73 (0.413)
SELECT DISTINCT *, (select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id
FROM oc_tag t
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
LEFT JOIN oc_tag_to_store ts ON (t.tag_id = ts.tag_id)
WHERE t.tag_id = '1' AND td.language_id = '1' AND ts.store_id = '0' AND t.status = '1'
/var/www/u0795645/data/www/svechi.site/catalog/model/catalog/tags.php:17
74 (0.915)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product p
LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ((ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1' OR p.product_id in (select product_id
from oc_product_to_tag
where tag_id = 1) ) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:379
75 (0.333)
SELECT DISTINCT *, (select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id
FROM oc_tag t
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
LEFT JOIN oc_tag_to_store ts ON (t.tag_id = ts.tag_id)
WHERE t.tag_id = '2' AND td.language_id = '1' AND ts.store_id = '0' AND t.status = '1'
/var/www/u0795645/data/www/svechi.site/catalog/model/catalog/tags.php:17
76 (0.317)
SELECT t.tag_id, pt.product_id
FROM oc_product_to_tag pt
INNER JOIN oc_tag t ON (t.tag_id = pt.tag_id)
INNER JOIN oc_tag_to_store ts ON (pt.tag_id = ts.tag_id)
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
WHERE td.language_id = '1' AND ts.store_id = '0' AND pt.product_id > 0 AND t.status = '1' AND t.tag_id = '2' LIMIT 0, 1
/var/www/u0795645/data/www/svechi.site/catalog/model/catalog/tags.php:288
77 (0.329)
SELECT DISTINCT *, (select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id
FROM oc_tag t
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
LEFT JOIN oc_tag_to_store ts ON (t.tag_id = ts.tag_id)
WHERE t.tag_id = '3' AND td.language_id = '1' AND ts.store_id = '0' AND t.status = '1'
/var/www/u0795645/data/www/svechi.site/catalog/model/catalog/tags.php:17
78 (0.947)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (p.date_available > '2020-07-04 00:00:00' OR p.product_id in (select product_id
from oc_product_to_tag
where tag_id = 3) ) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,1
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:379
79 (1.067)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2113' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
80 (0.706)
SELECT *
FROM oc_seo_url
WHERE `query` = 'tag_id=3' AND `language_id` = '1' AND `store_id` = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/controller/startup/seo_url.php:142
81 (0.133)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/tags'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
82 (0.127)
SELECT *
FROM oc_module
WHERE module_id = '46'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
83 (1.135)
SELECT od.name AS namegroup, ovd.name, ovd.option_value_id, pov.option_id, ov.image, ov.sort_order
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p.product_id = p2s.product_id)
INNER JOIN `oc_product_option_value` AS pov ON (p.product_id = pov.product_id)
INNER JOIN `oc_option_description` AS od ON (pov.option_id = od.option_id)
INNER JOIN `oc_option_value_description` AS ovd ON (pov.option_value_id = ovd.option_value_id)
INNER JOIN `oc_option` AS o ON (pov.option_id = o.option_id)
INNER JOIN `oc_option_value` AS ov ON (pov.option_value_id = ov.option_value_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND p.date_available <= NOW() AND ovd.language_id = '1' AND od.language_id = '1' AND p2s.store_id = '0' AND p2c.category_id = '7385' GROUP BY pov.option_value_id
ORDER BY o.sort_order, ov.sort_order, od.name, ovd.name
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/brainyfilter.php:1132
84 (0.638)
SELECT DISTINCT m.manufacturer_id AS id, m.name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `oc_manufacturer_to_store` AS m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND p.date_available <= NOW() AND m2s.store_id = '0' AND p2c.category_id = '7385'
ORDER BY m.sort_order, m.name
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/brainyfilter.php:1056
85 (0.469)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/brainyfilter.php:1077
86 (0.489)
SELECT *
FROM oc_module
WHERE module_id = '58'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
87 (0.246)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/html'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
88 (0.188)
SELECT *
FROM oc_module
WHERE module_id = '59'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
89 (0.121)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/column_left'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
90 (0.080)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '7385' AND store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:58
91 (0.065)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:4
92 (0.175)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:14
93 (0.100)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/column_right'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
94 (0.040)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '7385' AND store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:58
95 (0.032)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:4
96 (0.121)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:14
97 (0.048)
SELECT *
FROM oc_module
WHERE module_id = '47'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
98 (0.142)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/content_top'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
99 (0.044)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '7385' AND store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:58
100 (0.031)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:4
101 (0.174)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/u0795645/data/www/svechi.site/catalog/model/design/layout.php:14
102 (0.167)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/matrosite/looked' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
103 (0.525)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_matrosite_looked'
/var/www/u0795645/data/www/svechi.site/catalog/model/setting/setting.php:6
104 (0.480)
SELECT *
FROM oc_module
WHERE module_id = '64'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
105 (0.142)
SELECT *
FROM oc_module
WHERE module_id = '66'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
106 (0.317)
SELECT *
FROM oc_product_related_wb pr
LEFT JOIN oc_product p ON (pr.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.category_id = '7385' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 5
/var/www/u0795645/data/www/svechi.site/catalog/model/catalog/cms.php:22
107 (0.183)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/featured_product' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
108 (0.238)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/featured_product'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
109 (0.132)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/content_bottom'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
110 (0.128)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
111 (0.126)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
112 (0.317)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/extension.php:4
113 (0.235)
SELECT *
FROM oc_module
WHERE module_id = '38'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
114 (0.466)
SELECT *
FROM oc_mega_menu
WHERE parent_id='0' AND status='0' AND module_id = '38'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:23
115 (1.654)
SELECT *
FROM oc_mega_menu
WHERE parent_id='136' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
116 (0.087)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
117 (0.255)
SELECT p.product_id
FROM oc_product p
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
ORDER BY p.date_added DESC LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:477
118 (0.727)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
119 (1.012)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
120 (1.025)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2142' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
121 (0.996)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2141' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
122 (0.408)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
123 (1.583)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
124 (0.845)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
125 (0.499)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
126 (0.485)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
127 (0.433)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
128 (0.442)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
129 (0.672)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
130 (0.681)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '7392'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:907
131 (0.383)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
132 (0.343)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
133 (0.045)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
134 (0.286)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
135 (0.136)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
136 (0.249)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
137 (0.052)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
138 (0.252)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
139 (0.095)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
140 (0.543)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
141 (0.105)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
142 (0.484)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
143 (0.466)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
144 (0.090)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
145 (1.637)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
146 (0.665)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
147 (0.266)
SELECT *
FROM oc_mega_menu
WHERE parent_id='138' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
148 (0.096)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '6' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
149 (0.150)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
150 (0.181)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
151 (0.152)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
152 (0.217)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
153 (0.118)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
154 (0.097)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
155 (0.107)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
156 (0.127)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
157 (0.067)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
158 (0.049)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
159 (0.055)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
160 (0.064)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
161 (0.053)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
162 (0.257)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
163 (0.106)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
164 (0.112)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
165 (0.089)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
166 (0.107)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
167 (0.088)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
168 (0.093)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
169 (0.110)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
170 (0.090)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
171 (0.111)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
172 (0.585)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
173 (0.487)
SELECT *
FROM oc_mega_menu
WHERE parent_id='144' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
174 (0.478)
SELECT *
FROM oc_mega_menu
WHERE parent_id='137' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
175 (0.709)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '10' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
176 (0.082)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
177 (0.115)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
178 (0.094)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
179 (0.098)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
180 (0.128)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
181 (0.104)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
182 (0.132)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
183 (0.078)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
184 (0.059)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
185 (0.045)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
186 (0.049)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
187 (0.145)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
188 (0.078)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
189 (0.073)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
190 (0.066)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
191 (0.084)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
192 (0.069)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
193 (0.077)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
194 (0.062)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
195 (0.073)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
196 (0.070)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
197 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
198 (0.065)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
199 (0.622)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
200 (0.359)
SELECT *
FROM oc_mega_menu
WHERE parent_id='150' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
201 (0.514)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
202 (0.120)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
203 (0.132)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
204 (0.109)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
205 (0.078)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
206 (0.068)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
207 (0.083)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
208 (0.489)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
209 (0.075)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
210 (0.110)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
211 (0.072)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
212 (0.077)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
213 (0.093)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
214 (0.078)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
215 (0.080)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
216 (0.095)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
217 (0.086)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
218 (0.129)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
219 (0.109)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
220 (0.076)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
221 (0.082)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
222 (0.072)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
223 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
224 (0.075)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
225 (0.636)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
226 (0.224)
SELECT *
FROM oc_mega_menu
WHERE parent_id='151' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
227 (0.414)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
228 (0.127)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
229 (0.100)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
230 (0.105)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
231 (0.083)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
232 (0.132)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
233 (0.087)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
234 (0.076)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
235 (0.166)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
236 (0.127)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
237 (0.096)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
238 (0.093)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
239 (0.101)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
240 (0.043)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
241 (0.047)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
242 (0.041)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
243 (0.061)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
244 (0.045)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
245 (0.044)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
246 (0.054)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
247 (0.042)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
248 (0.044)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
249 (0.044)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
250 (0.088)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
251 (0.567)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
252 (0.188)
SELECT *
FROM oc_mega_menu
WHERE parent_id='152' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
253 (0.253)
SELECT *
FROM oc_mega_menu
WHERE parent_id='140' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
254 (0.053)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
255 (0.054)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
256 (0.050)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
257 (0.047)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
258 (0.065)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
259 (0.100)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
260 (0.099)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
261 (0.093)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
262 (0.075)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
263 (0.063)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
264 (0.084)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
265 (0.077)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
266 (0.069)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
267 (0.087)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
268 (0.070)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
269 (0.074)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
270 (0.070)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
271 (0.082)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
272 (0.069)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
273 (0.084)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
274 (0.053)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
275 (0.147)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
276 (0.110)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
277 (0.594)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
278 (0.229)
SELECT *
FROM oc_mega_menu
WHERE parent_id='141' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
279 (0.049)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
280 (0.140)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
281 (0.060)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
282 (0.043)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
283 (0.041)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
284 (0.074)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
285 (0.054)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
286 (0.053)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
287 (0.045)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
288 (0.039)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
289 (0.044)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
290 (0.048)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
291 (0.043)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
292 (0.045)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
293 (0.044)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
294 (0.084)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
295 (0.060)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
296 (0.058)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
297 (0.060)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
298 (0.059)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
299 (0.056)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
300 (0.052)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
301 (0.057)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
302 (0.903)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
303 (0.304)
SELECT *
FROM oc_mega_menu
WHERE parent_id='153' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
304 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
305 (0.070)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
306 (0.066)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
307 (0.074)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
308 (0.065)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
309 (0.057)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
310 (0.062)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
311 (0.060)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
312 (0.072)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
313 (0.054)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
314 (0.058)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
315 (0.077)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
316 (0.106)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
317 (0.079)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
318 (0.073)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
319 (0.134)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
320 (0.075)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
321 (0.078)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
322 (0.074)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
323 (0.117)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
324 (0.079)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
325 (0.061)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
326 (0.061)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
327 (0.558)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
328 (0.256)
SELECT *
FROM oc_mega_menu
WHERE parent_id='154' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
329 (0.059)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
330 (0.202)
SELECT *
FROM oc_mega_menu
WHERE parent_id='166' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
331 (0.165)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/uni_megamenu/footer_menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
332 (1.072)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:13
333 (0.153)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2020-07-11 19:35:29'
/var/www/u0795645/data/www/svechi.site/catalog/model/tool/online.php:4
334 (0.179)
REPLACE INTO `oc_customer_online` SET `ip` = '3.236.59.63', `customer_id` = '0', `url` = 'https://svechi.site/voskovye-svechi-cvetnie', `referer` = '', `date_added` = '2020-07-11 20:35:29'
/var/www/u0795645/data/www/svechi.site/catalog/model/tool/online.php:6
335 (0.296)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/footer'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
336 (0.092)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/extension.php:4
337 (0.248)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
338 (0.168)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
339 (0.144)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/currency'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
340 (0.300)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
341 (1.609)
SELECT *
FROM oc_blog_category c
LEFT JOIN oc_blog_category_description cd ON (c.blog_category_id = cd.blog_category_id)
LEFT JOIN oc_blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id)
WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, cd.name
/var/www/u0795645/data/www/svechi.site/catalog/model/blog/category.php:16
342 (0.304)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'blog/menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
343 (0.244)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
344 (0.298)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/search'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
345 (0.247)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
346 (0.371)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e103c933630cc04ee45933bc44'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/system/library/cart/cart.php:65
347 (0.442)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/extension.php:4
348 (0.234)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
349 (0.459)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
350 (0.311)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/u0795645/data/www/svechi.site/system/library/cart/customer.php:122
351 (0.434)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
352 (0.286)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/cart'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
353 (0.308)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
354 (0.154)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
355 (0.160)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
356 (0.075)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
357 (0.103)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:13
358 (0.176)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
359 (0.111)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
360 (0.097)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
361 (0.096)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/cart'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
362 (0.089)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
363 (0.035)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
364 (0.202)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/cart_mobile'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
365 (0.043)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
366 (0.035)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
367 (0.038)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
368 (0.220)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/cart_mobile_menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
369 (0.038)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
370 (0.035)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'moytop/main' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
371 (0.033)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/u0795645/data/www/svechi.site/catalog/model/design/translation.php:6
372 (0.044)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/u0795645/data/www/svechi.site/catalog/model/localisation/language.php:15
373 (0.128)
SELECT *
FROM oc_module
WHERE module_id = '37'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
374 (0.327)
SELECT *
FROM oc_mega_menu
WHERE parent_id='0' AND status='0' AND module_id = '37'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:23
375 (0.238)
SELECT *
FROM oc_mega_menu
WHERE parent_id='122' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
376 (0.184)
SELECT *
FROM oc_mega_menu
WHERE parent_id='160' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
377 (0.056)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
378 (0.066)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
379 (0.057)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
380 (0.059)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
381 (0.050)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
382 (0.050)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
383 (0.048)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
384 (0.050)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
385 (0.049)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
386 (0.041)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
387 (0.048)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
388 (0.074)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
389 (0.040)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
390 (0.074)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
391 (0.194)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
392 (0.058)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
393 (0.049)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
394 (0.050)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
395 (0.045)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
396 (0.059)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
397 (0.051)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
398 (0.046)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
399 (0.051)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
400 (0.751)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
401 (0.236)
SELECT *
FROM oc_mega_menu
WHERE parent_id='123' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
402 (0.060)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
403 (0.061)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
404 (0.056)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
405 (0.053)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
406 (0.049)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
407 (0.050)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
408 (0.181)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
409 (0.077)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
410 (0.082)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
411 (0.070)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
412 (0.080)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
413 (0.079)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
414 (0.087)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
415 (0.068)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
416 (0.056)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
417 (0.059)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
418 (0.057)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
419 (0.058)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
420 (0.056)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
421 (0.178)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
422 (0.122)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
423 (0.101)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
424 (0.106)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
425 (1.548)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
426 (0.641)
SELECT *
FROM oc_mega_menu
WHERE parent_id='124' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
427 (0.126)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
428 (0.149)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
429 (0.134)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
430 (0.124)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
431 (0.117)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
432 (0.094)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
433 (0.093)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
434 (0.090)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
435 (0.096)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
436 (0.078)
SELECT * , c.category_id as id
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 4
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:447
437 (0.089)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
438 (0.087)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
439 (0.090)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
440 (0.084)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
441 (0.073)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
442 (0.072)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
443 (0.072)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
444 (0.080)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7381' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
445 (0.160)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
446 (0.101)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
447 (0.092)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
448 (0.082)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
449 (0.087)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '7384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/category.php:4
450 (0.756)
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT date_end
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_special, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/product.php:14
451 (0.281)
SELECT *
FROM oc_mega_menu
WHERE parent_id='125' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
452 (0.117)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '11' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/catalog/information.php:4
453 (0.465)
SELECT *
FROM oc_mega_menu
WHERE parent_id='158' AND status='0'
ORDER BY rang
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/extension/module/uni_megamenu.php:113
454 (0.261)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'extension/module/uni_megamenu/top_menu'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
455 (0.077)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/u0795645/data/www/svechi.site/system/storage/modification/catalog/model/setting/module.php:4
456 (0.322)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/styles'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
457 (0.309)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'common/header'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4
458 (0.361)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'moytop' AND route = 'product/category'
/var/www/u0795645/data/www/svechi.site/catalog/model/design/theme.php:4