Filter
Filter Atiestatīt visu
Atslēgvārdi
Kategorijas
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
871
870
872
873
874
875
876
847
877
878
879
880
881
883
884
885
886
887
888
889
890
891
892
893
Cena
€ – €
Sākums Remontam Instrumenti

Instrumenti

Adapteris Adapteris Ampērmetrs Ampērmetrs Āmurs Āmurs Asmeņi Asmeņi Atslēgas Atslēgas Atslēgu komplekti Atslēgu komplekti Bīdmērs Bīdmērs Birstes Birstes Cirvji Cirvji Citi Citi Darba galdi Darba galdi Dimanta disks Dimanta disks Ēvele Ēvele Flīžu griezējs Flīžu griezējs Flīžu skavas Flīžu skavas Instrumenti Instrumenti Instrumentu kastes Instrumentu kastes Instrumentu soma Instrumentu soma Izolācijas lente Izolācijas lente Josta Josta Kalts Kalts Kastes Kastes Ķelle Ķelle Knaibles Knaibles Kniedētājs Kniedētājs Komplekti Komplekti Lauznis Lauznis Lāzera līmeņrādis Lāzera līmeņrādis Lāzera tālmērs Lāzera tālmērs Leņķa zāģis Leņķa zāģis Leņķis Leņķis Līme Līme Līmeņrādis Līmeņrādis Līmes pistoles Līmes pistoles Līmlente Līmlente Lineāls Lineāls Mērlenta Mērlenta Mikrometrs Mikrometrs Montāžas putu pistole Montāžas putu pistole Multimetrs Multimetrs Nazis Nazis Plakanknaibles Plakanknaibles Silikona pistole Silikona pistole Skavas Skavas Šķēres Šķēres Skrūvgriezis Skrūvgriezis Skrūvgriežu komplekts Skrūvgriežu komplekts Smērvielas Smērvielas Spainis Spainis Špakteļlāpstiņa Špakteļlāpstiņa Sprieguma indikators Sprieguma indikators Stellatslēgas Stellatslēgas Stepleris Stepleris Stikla griezējs Stikla griezējs Sūklis Sūklis Transportrati Transportrati Urbis Urbis Uzgaļi Uzgaļi Vīle Vīle Zāģi Zāģi Zīmulis Zīmulis
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: 91, Total time: 74.934 ms [By time] [By id] [By file]
1 (1.140)
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:24
2 (0.612)
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:53
3 (0.381)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'iia0sdhgrpa4vt91m8eago9s66'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (0.472)
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.393)
SELECT sort_by
FROM oc_category
WHERE category_id = '831'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:28
6 (0.259)
SELECT view_type
FROM oc_category
WHERE category_id = '831'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:34
7 (0.496)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '831' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
8 (0.717)
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 = '831'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/controller/product/category.php:115
9 (1.681)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '831' 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
10 (0.578)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
11 (0.476)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
12 (0.506)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
13 (0.514)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
14 (0.338)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
15 (0.462)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
16 (0.273)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
17 (0.263)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
18 (0.254)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
19 (0.361)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
20 (0.386)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
21 (0.324)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
22 (0.351)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
23 (0.303)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
24 (0.316)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
25 (0.281)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
26 (0.243)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
27 (0.305)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
28 (0.253)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
29 (0.239)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
30 (0.268)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
31 (0.212)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
32 (0.232)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
33 (0.480)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
34 (0.431)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
35 (0.348)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
36 (0.300)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
37 (0.298)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
38 (0.298)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
39 (0.265)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
40 (0.273)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
41 (0.292)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
42 (0.268)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
43 (0.287)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
44 (0.255)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
45 (0.251)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
46 (0.558)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
47 (0.284)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
48 (0.280)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
49 (0.269)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
50 (0.263)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
51 (0.305)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
52 (0.268)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
53 (0.268)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
54 (0.301)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
55 (0.258)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
56 (0.254)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
57 (0.293)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
58 (0.251)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
59 (0.818)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
60 (0.502)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
61 (0.833)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
62 (0.729)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
63 (0.566)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
64 (0.551)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
65 (0.552)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
66 (0.277)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
67 (0.218)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
68 (0.210)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
69 (0.210)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
70 (0.210)
SELECT *
FROM oc_category_description
WHERE `category_id` = '831' 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:427
71 (3.120)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:761
72 (3.513)
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 = '831' 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
73 (0.247)
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:1386
74 (0.566)
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:391
75 (0.774)
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:1557
76 (0.454)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
77 (0.675)
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 = '831') 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
78 (0.454)
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 = '831' 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
79 (0.388)
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 = '831' 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
80 (0.291)
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 = '831'
ORDER BY m.sort_order, m.name
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1209
81 (0.332)
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 = '831'
ORDER BY ss.sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1262
82 (0.196)
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
83 (30.857)
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
84 (0.839)
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
85 (0.860)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
86 (0.731)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
87 (0.765)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
88 (0.492)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
89 (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
90 (0.437)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_menu'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
91 (0.917)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_after'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29