1 (1.391)
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 = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/dev4.nomasveikals.lv/web/storage/modification/system/library/cart/tax.php:23
2 (0.736)
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 = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/dev4.nomasveikals.lv/web/storage/modification/system/library/cart/tax.php:51
3 (0.406)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'l3jkju29gund3sr4p9hvn6uupg'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (0.726)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/event.php:4
5 (0.434)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
6 (0.477)
SELECT *
FROM oc_banner b
LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '7' AND b.status = '1' AND bi.language_id = '1'
ORDER BY bi.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:4
7 (0.358)
SELECT *
FROM oc_product_to_category
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
8 (0.418)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '243' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
9 (0.333)
SELECT *
FROM oc_category_description
WHERE `category_id` = '243' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:410
10 (0.318)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
11 (0.250)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
12 (0.212)
SELECT *
FROM oc_product_to_category
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
13 (0.382)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '640' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
14 (0.341)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '640' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
15 (0.208)
SELECT *
FROM oc_product_to_category
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
16 (0.348)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '221' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
17 (0.263)
SELECT *
FROM oc_category_description
WHERE `category_id` = '221' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:410
18 (0.319)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
19 (0.227)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
20 (0.159)
SELECT *
FROM oc_product_to_category
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
21 (0.331)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '639' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
22 (0.221)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '639' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
23 (0.236)
SELECT *
FROM oc_product_to_category
WHERE product_id = '631'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
24 (0.409)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
25 (0.245)
SELECT *
FROM oc_product_to_category
WHERE product_id = '631'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
26 (0.423)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '631' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
27 (0.390)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '631' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
28 (0.285)
SELECT *
FROM oc_product_to_category
WHERE product_id = '632'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
29 (0.418)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
30 (0.295)
SELECT *
FROM oc_product_to_category
WHERE product_id = '632'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
31 (0.527)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '632' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
32 (0.417)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '632' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
33 (0.272)
SELECT *
FROM oc_product_to_category
WHERE product_id = '629'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
34 (0.399)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
35 (0.358)
SELECT *
FROM oc_product_to_category
WHERE product_id = '629'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
36 (0.467)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '629' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
37 (0.373)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '629' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
38 (1.071)
SELECT *
FROM oc_blog n
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
LEFT JOIN oc_blog_to_category n2c ON (n.blog_id = n2c.blog_id)
WHERE nd.language_id = '1' AND n2c.blog_category_id = '50' AND n.status = '1' AND n.sort_order <> '-1'
ORDER BY n.sort_order, n.blog_id DESC LIMIT 0,5
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:71
39 (0.827)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '25' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
40 (0.765)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '24' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
41 (0.532)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '23' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
42 (0.730)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '16' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
43 (0.584)
SELECT *
FROM oc_url_alias
WHERE `query` = 'blog/home'
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:394
44 (2.626)
SELECT m.*, md.*, product_count
FROM oc_manufacturer m
LEFT JOIN (SELECT manufacturer_id, COUNT(product_id) AS product_count
FROM oc_product
WHERE status = 1 GROUP BY manufacturer_id) AS p ON (m.manufacturer_id = p.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
WHERE m.status = 1 AND product_count > 0
ORDER BY name ASC LIMIT 0,24
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/manufacturer.php:45
45 (0.498)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '1371' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
46 (0.412)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '326' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
47 (0.307)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '786' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
48 (0.328)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3430' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
49 (0.276)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3434' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
50 (0.252)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3426' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
51 (0.287)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3432' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
52 (0.278)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3437' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
53 (0.268)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3436' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
54 (0.281)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3424' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
55 (0.208)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3414' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
56 (0.195)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3431' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
57 (0.351)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3429' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
58 (0.280)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3435' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
59 (0.231)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3413' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:359
60 (0.559)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
61 (0.552)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/customer.php:143