Queries: 10, Total time: 10.121 ms [By time] [By id] [By file]
1 (1.552)
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 (1.250)
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.577)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1qosob3qgoe6o5a9mttvjeo6i7'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (0.991)
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 (2.368)
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
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/manufacturer.php:59
6 (0.983)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer' LIKE route
ORDER BY route DESC LIMIT 1
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:11
7 (0.671)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
8 (0.661)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
9 (0.563)
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
10 (0.505)
SELECT *
FROM oc_theme
WHERE theme = '' AND route = 'product/manufacturer_list'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:11