Filter
Atslēgvārdi
Kategorijas
1433
1555
1553
1552
1556
1554
1557
1437
1577
1582
1574
1578
1579
1575
1581
1580
1576
1435
1567
1566
1569
1565
1568
1434
1560
1559
1561
1558
1563
1562
1564
1431
1542
1545
1541
1544
1540
1543
1438
1585
1584
1583
144
1537
1538
1539
1428
1484
1481
1478
1480
1483
1482
1497
1498
1494
1496
1501
1486
1489
1495
1491
1477
1476
1479
1485
1502
1492
1493
1490
1487
1499
1488
1500
179
1429
1504
1509
1507
1505
1503
1508
1511
1510
1506
1430
1519
1518
1521
1522
1525
1517
1515
1516
1513
1524
1514
1512
1520
1523
1436
1571
1572
1570
1573
1427
1464
1472
1460
1459
1461
1467
1465
1475
1471
1466
1468
1474
1470
1458
1462
1469
1457
1473
1463
145
1529
1534
1536
1531
1530
1532
1527
1526
1533
1528
1535
142
1455
1454
1444
1456
1446
1445
1443
1450
1451
1447
1441
1442
1453
1449
1448
1440
1452
1432
1548
1546
1550
1549
1551
1547
1439
1592
1587
1588
1589
1590
1586
1591
Cena
Preces krāsa var atšķirties no attēlā redzamās. Produkta apraksts ir vispārīgs, tajā ne vienmēr ir minētas visas produkta īpašības. Produktu cenas e-veikalā var atšķirties no cenām lielveikalos un servisa centros. Preču atlikums noliktavā un e-veikalā var atšķirties, tāpēc šādos gadījumos piegādes nosacījumi var atšķirties no tiem, kas norādīti pasūtījuma veikšanas brīdī un / vai nevarēsim izpildīt Jūsu pasūtījumu vai tikai daļēji izpildīt (tādos gadījumos Pircējs tiek informēts nekavējoties).
Pamanījāt kļūdu? Ziņojiet mums
Queries: 44, Total time: 66.924 ms [By time] [By id] [By file]
1 (0.885)
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.572)
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.364)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1rtp6jp738a7jbvn7c2rvm283p'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (1.178)
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.396)
SELECT c.category_id
FROM `oc_category_description` cd
LEFT JOIN oc_category c ON c.category_id = cd.category_id
WHERE cd.seo_keyword = 'sporta-preces' AND c.parent_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:96
6 (0.218)
SELECT sort_by
FROM oc_category
WHERE category_id = '141'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:28
7 (0.227)
SELECT view_type
FROM oc_category
WHERE category_id = '141'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:34
8 (0.283)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '141' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
9 (0.564)
SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.seo_keyword
ORDER BY cp.level SEPARATOR '____') as seo_keyword, GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR '____') AS name, GROUP_CONCAT(cd1.category_id
ORDER BY cp.level SEPARATOR '____') AS category_id, c1.parent_id, c1.sort_order
FROM oc_category_path cp
LEFT JOIN oc_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN oc_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN oc_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN oc_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE cd1.language_id = '1' AND cd2.language_id = '1' AND cp.category_id = '141'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/controller/product/category.php:115
10 (0.746)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '141' AND cd.language_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:22
11 (0.405)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
12 (0.253)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
13 (0.267)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
14 (0.218)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
15 (0.335)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
16 (0.213)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
17 (0.365)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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.244)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
19 (0.304)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
20 (0.241)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
21 (0.265)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
22 (0.231)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
23 (0.322)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
24 (0.234)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
25 (0.299)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
26 (0.228)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
27 (0.239)
SELECT *
FROM oc_category_description
WHERE `category_id` = '141' 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
28 (2.158)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:761
29 (3.232)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (product_id)) ENGINE=InnoDB WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT /*+ MAX_EXECUTION_TIME(10000) */ p.product_id, p.sort_order, "1" AS match_filters, (CASE WHEN MIN(psf.price) IS NOT NULL THEN MIN(psf.price) WHEN MIN(psp.percentage) IS NOT NULL THEN (100 - MIN(psp.percentage)) * p.price / 100 WHEN MIN(pdf.price) IS NOT NULL THEN MIN(pdf.price) WHEN MIN(pdp.percentage) IS NOT NULL THEN (100 - MIN(pdp.percentage)) * p.price / 100 ELSE p.price END * IF(MIN(psf.price) IS NULL AND MIN(psp.percentage) IS NULL AND (IFNULL(MIN(cgd.percentage), 0) + IFNULL(MIN(cd.percentage), 0) + IFNULL(MIN(md.percentage), 0) + IFNULL(MIN(vd.percentage), 0)) < 100, (100 - (IFNULL(MIN(cgd.percentage), 0) + IFNULL(MIN(cd.percentage), 0) + IFNULL(MIN(md.percentage), 0) + IFNULL(MIN(vd.percentage), 0))) / 100, 1) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
INNER JOIN `oc_bf_filter_guest` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity = '1' AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity = '1' AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category` AS cc ON (cc.category_id = c.parent_id)
LEFT JOIN `oc_category_discount` AS cd ON (cd.category_id IN (c.category_id, cc.category_id) AND cd.status = '1' AND cd.customer_group_id = '1' AND IF(c.parent_id IS NOT NULL, cd.affect = '1', 1) AND cd.qty IN (0, 1) AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
LEFT JOIN `oc_manufacturer_discount` AS md ON (md.manufacturer_id = p.manufacturer_id AND md.status = '1' AND md.customer_group_id = '1' AND md.qty <= p.minimum AND (md.date_start = '0000-00-00' OR md.date_start < NOW()))
LEFT JOIN `oc_volume_discount` AS vd ON (vd.status = '1' AND vd.customer_group_id = '1' AND vd.qty <= p.minimum AND (vd.date_start = '0000-00-00' OR vd.date_start < NOW()))
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`
WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '117' AND zone_id IN ('0', '0')) OR (based = 'shipping' AND country_id = '117' AND zone_id IN ('0', '0'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND p2c.category_id = '141' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) GROUP BY p.product_id
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:762
30 (0.291)
SELECT COUNT(*) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1356
31 (0.666)
SELECT p.*, pr_restricted.value AS restrict_customer_group, pr_blocked.value AS block_customer_group, pp.sort_order
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_rule` AS pr_restricted ON (pr_restricted.product_id = p.product_id AND pr_restricted.type = 'restrict_customer_group')
LEFT JOIN `oc_product_rule` AS pr_blocked ON (pr_blocked.product_id = p.product_id AND pr_blocked.type = 'block_customer_group')
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
LEFT JOIN `oc_stock_status` AS ss ON (ss.language_id = '1' AND ss.stock_status_id = CASE WHEN pp.quantity > 0 AND pp.in_stock_status_id > 0 THEN pp.in_stock_status_id WHEN pp.quantity <= 0 AND pp.out_of_stock_status_id > 0 THEN pp.out_of_stock_status_id WHEN pp.quantity > 0 AND (pp.in_stock_status_id IS NULL OR pp.in_stock_status_id < 0) THEN '7' ELSE '5' END)
WHERE match_filters = 1 AND pd.language_id = '1' AND (pr_blocked.value NOT LIKE '%guest%' OR pr_blocked.value IS NULL) GROUP BY product_id
ORDER BY ss.sort_order ASC, pp.sort_order ASC LIMIT 0, 16
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:361
32 (0.422)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE ucd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1527
33 (6.482)
SELECT category_id, layout_id
FROM oc_category_to_layout
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:86
34 (0.525)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
35 (0.837)
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 = '141') 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)
WHERE agd.language_id = '1' AND ad.language_id = '1' AND av.language_id = '1' 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/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1137
36 (0.611)
SELECT od.name AS namegroup, ovd.name, ovd.option_value_id, pov.option_id, ov.image, ov.sort_order, pov.o2p_title, pov.o2p_override
FROM `oc_product` AS p
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 pov.quantity > 0 AND p.status = 1 AND p.date_available <= NOW() AND ovd.language_id = '1' AND od.language_id = '1' AND p2c.category_id = '141' GROUP BY pov.option_value_id, pov.o2p_title, pov.o2p_override
ORDER BY o.sort_order, ov.sort_order, od.name, ovd.name
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1339
37 (0.487)
SELECT fgd.name AS namegroup, fd.name, f.filter_id, fg.filter_group_id, f.sort_order
FROM `oc_product` AS p
INNER JOIN `oc_product_filter` AS pf ON (p.product_id = pf.product_id)
INNER JOIN `oc_filter` AS f ON (f.filter_id = pf.filter_id)
INNER JOIN `oc_filter_description` AS fd ON (fd.filter_id = pf.filter_id)
INNER JOIN `oc_filter_group` AS fg ON (fg.filter_group_id = fd.filter_group_id)
INNER JOIN `oc_filter_group_description` AS fgd ON (fd.filter_group_id = fgd.filter_group_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 fd.language_id = '1' AND fgd.language_id = '1' AND p2c.category_id = '141' GROUP BY f.filter_id
ORDER BY fg.sort_order, f.sort_order, fgd.name, fd.name
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1419
38 (0.360)
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_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND m.status = 1 AND p.date_available <= NOW() AND p2c.category_id = '141'
ORDER BY m.sort_order, m.name
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1209
39 (0.422)
SELECT DISTINCT ss.stock_status_id AS id, ss.name
FROM `oc_stock_status` AS ss
INNER JOIN `oc_product` AS p ON (CASE WHEN p.quantity > 0 AND p.in_stock_status_id > 0 THEN p.in_stock_status_id WHEN p.quantity <= 0 AND p.out_of_stock_status_id > 0 THEN p.out_of_stock_status_id WHEN p.quantity > 0 AND (p.in_stock_status_id IS NULL OR p.in_stock_status_id < 0) THEN '7' ELSE '5' END = ss.stock_status_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE ss.language_id = '1' AND p2c.category_id = '141'
ORDER BY ss.sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1262
40 (0.241)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1081
41 (38.352)
SELECT cd.name, c.category_id AS id, c.parent_id AS pid
FROM `oc_category` AS c
INNER JOIN `oc_category_description` AS cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '1'
ORDER BY c.parent_id, c.sort_order, LCASE(cd.name)
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1454
42 (0.917)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter_guest` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) GROUP BY filter_group, filter_id
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1006
43 (0.440)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
44 (0.385)
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