Filtrs
Filtrs Atiestatīt visu
Atslēgvārdi
Kategorijas
2063
2064
2036
2084
2028
2030
2029
2033
2034
2031
2024
2010
2076
2078
2077
2081
2082
2079
2021
2009
2023
2083
2011
2025
2022
1823
1821
1822
1819
1818
1817
1824
2055
2053
2054
2051
2052
2050
2049
2057
66
65
2129
2140
2138
2139
2135
2132
2133
2131
2134
2136
2142
2137
2141
2059
2060
1988
1995
1993
1996
1991
1990
1992
1888
1890
1887
1889
1952
1953
1955
1951
1957
1950
1956
1954
1935
1946
1944
1937
1940
1938
1941
1942
1943
1939
1945
1948
1949
2086
1947
1985
1977
1961
1960
1962
1963
1959
1964
1975
1973
1972
1974
1982
1983
1970
1968
1969
1966
1980
1979
1843
1833
1844
1841
1832
1837
1838
1826
1834
1827
1831
1828
1829
1835
1830
1842
1836
1839
1840
1904
1917
1901
1926
1930
1919
1895
1927
1894
1912
1897
1914
1910
1924
1915
1893
2121
1913
1925
1916
1911
1896
1902
1908
1929
1898
1906
1923
1928
2120
2111
2112
2118
2117
2119
2104
2105
2106
2114
2115
2108
2109
2098
2096
2095
2091
2090
2092
2093
1903
1920
1921
1909
1907
1905
1899
1900
1931
1922
1918
1892
1813
1812
1800
1809
1795
1806
1808
1807
1803
1794
1805
1810
1804
1799
1801
1796
1798
1802
1811
2070
2073
2072
2123
2125
2124
2071
1873
1874
1876
1877
1878
1880
1856
1855
1848
1849
1851
1853
1885
1866
2085
1860
1859
1869
1871
1863
1862
1864
1882
1883
2061
2122
2068
2066
2067
2042
2044
2045
2046
2041
2043
2040
2039
2047
2074
1986
2005
2006
1998
2003
2001
2000
2002
2004
Sākums Produktu filtrs

Produktu filtrs

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts 54.99€ / m2 0024022.315
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Oranži CYCRA STEALTH MX ALLOY roku sargi, Oranži 52.95€ / m2 0024030.010
Ir pieejams Noliktavā 221
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Balti CYCRA STEALTH MX ALLOY roku sargi, Balti 52.95€ / m2 0024030.030
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Zili CYCRA STEALTH MX ALLOY roku sargi, Zili 52.95€ / m2 0024030.040
Izpārdots
/ m2
CYCRA STEALTH PRIMAL roku sargi, Oranži CYCRA STEALTH PRIMAL roku sargi, Oranži 39.95€ / m2 0024058.010
Izpārdots
/ m2
CYCRA SERIES ONE NO CLAMPS roku sargi, Zili CYCRA SERIES ONE NO CLAMPS roku sargi, Zili 74.95€ / m2 0024070.040
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Balts) CYCRA NUMBERPLATE atslēgu piekariņš (Balts) 2.95€ / m2 0024218.030
Ir pieejams Noliktavā 444
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Zils) CYCRA NUMBERPLATE atslēgu piekariņš (Zils) 2.95€ / m2 0024218.040
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) 2.95€ / m2 0024218.110
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) 100.00€ / m2 0024218.130
Ir pieejams Noliktavā 220
/ m2
Velcro slīpēšanas sprausla SENDI #200 Velcro slīpēšanas sprausla SENDI #200 14.00€ 01120001032
Ir pieejams Noliktavā 1
Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy) Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy) 14.00€ 01120001033
Ir pieejams Noliktavā 1
Velcro slīpēšanas sprausla SENDI #200 (Copy) Velcro slīpēšanas sprausla SENDI #200 (Copy) 14.00€ 01120001034
Ir pieejams Noliktavā 1
SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai 29.00€ 01961204300
Izpārdots
400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem 400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem 109.00€ 10120024020
Izpārdots
RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals) RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals) 52.00€ 11133053029
Izpārdots
50W LED Prožektors 50W LED Prožektors 75.96€ 475345
Ir pieejams Noliktavā 101
50W Sensora LED Prožektors 50W Sensora LED Prožektors 51.95€ 475431
Izpārdots
CeraMAX 1800 Mechanic lielformāta darba galds CeraMAX 1800 Mechanic lielformāta darba galds 762.00€ 71419031035
Ir pieejams Noliktavā 1
Mapei Ultracare gluds silikons 750ml silikona aerosols Mapei Ultracare gluds silikons 750ml silikona aerosols 11.48€ 8022452220937
Ir pieejams Noliktavā 1
cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab cc3829013
Ir pieejams Noliktavā 4
/ gab
Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab. Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab. 8.00€ GL-FORM-RINK-4
Ir pieejams Noliktavā 1
HP EliteBook 850 G5 MAIN HP EliteBook 850 G5 MAIN 619.83€ / gab HP EliteBook Main
Ir pieejams Noliktavā 40
BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla 22.00€ LFBSL-TXP
Ir pieejams Noliktavā 1
test2 test2 474.00€ test2
Ir pieejams Noliktavā 113
LED lentu profila stiprinājuma detaļas komplekts LED lentu profila stiprinājuma detaļas komplekts 1.17€ WD00-18
Ir pieejams Noliktavā 111
HP EliteBook 850 G5 HP EliteBook 850 G5 743.80€ 123456
Ir pieejams Noliktavā 20
aa Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT aa Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab aa3829013
Ir pieejams Noliktavā 3
/ gab
bb Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT bb Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab bb3829013
Ir pieejams Noliktavā 4
/ gab
Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab 3829013
Ir pieejams Noliktavā 1
/ gab
dd Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT dd Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab dd3829013
Ir pieejams Noliktavā 4
/ gab
Lodveida krāns ar taurenīti /I-I/ 7752, 1/2 Lodveida krāns ar taurenīti /I-I/ 7752, 1/2 4.45€ / gab 0620004
Ir pieejams Noliktavā 12
Makita PROWADNICA 40cm 1,3mm 3/8" DO UC4030A >>>191G34-7 Makita PROWADNICA 40cm 1,3mm 3/8" DO UC4030A >>>191G34-7 6.09€ / gab G-15/5
Ir pieejams Noliktavā 140
/ gab
<TEST> un " un 'un /(medium mask) <TEST> un " un 'un /(medium mask) 5.30€ / gab test12345
Ir pieejams Noliktavā 114
/ gab
Lenovo ThinkPad 1111 Lenovo ThinkPad 1111
1,300.00€ 1,569.80€
Lenovo ThinkPad 111
Ir pieejams Noliktavā 99986
Lenovo ThinkPad P52s 20LB000HPB Lenovo ThinkPad P52s 20LB000HPB 1,569.80€ Lenovo ThinkPad P52s 20LB000HPB
Ir pieejams Noliktavā 99982
Lenovo ThinkPad L480 20LS001APB Lenovo ThinkPad L480 20LS001APB 300.00€ Lenovo ThinkPad L480 20LS001APB
Ir pieejams Noliktavā 456
Lenovo ThinkPad L480 20LS001APB Lenovo ThinkPad L480 20LS001APB 767.10€ Lenovo ThinkPad L480 20LS001APB
Ir pieejams Noliktavā 996
2Lenovo ThinkPad L480 20LS001APB 2Lenovo ThinkPad L480 20LS001APB
700.00€ 767.10€
LenovoXX
Ir pieejams Noliktavā 991
Lenovo ThinkPad X1 Carbon 6th Gen Black Lenovo ThinkPad X1 Carbon 6th Gen Black 1,633.10€ Lenovo ThinkPad X1 Carbon 6th Gen Black
Ir pieejams Noliktavā 988
Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts
Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts 54.99€ / m2
/ m2
Izpārdots
Produkta kods: 0024022.315
CYCRA STEALTH MX ALLOY roku sargi, Oranži
CYCRA STEALTH MX ALLOY roku sargi, Oranži 52.95€ / m2
/ m2
Ir pieejams Noliktavā 221
Produkta kods: 0024030.010
CYCRA STEALTH MX ALLOY roku sargi, Balti
CYCRA STEALTH MX ALLOY roku sargi, Balti 52.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024030.030
CYCRA STEALTH MX ALLOY roku sargi, Zili
CYCRA STEALTH MX ALLOY roku sargi, Zili 52.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024030.040
CYCRA STEALTH PRIMAL roku sargi, Oranži
CYCRA STEALTH PRIMAL roku sargi, Oranži 39.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024058.010
CYCRA SERIES ONE NO CLAMPS roku sargi, Zili
CYCRA SERIES ONE NO CLAMPS roku sargi, Zili 74.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024070.040
CYCRA NUMBERPLATE atslēgu piekariņš (Balts)
CYCRA NUMBERPLATE atslēgu piekariņš (Balts) 2.95€ / m2
/ m2
Ir pieejams Noliktavā 444
Produkta kods: 0024218.030
CYCRA NUMBERPLATE atslēgu piekariņš (Zils)
CYCRA NUMBERPLATE atslēgu piekariņš (Zils) 2.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024218.040
CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans)
CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) 2.95€ / m2
/ m2
Izpārdots
Produkta kods: 0024218.110
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš)
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) 100.00€ / m2
/ m2
Ir pieejams Noliktavā 220
Produkta kods: 0024218.130
Velcro slīpēšanas sprausla SENDI #200
Velcro slīpēšanas sprausla SENDI #200 14.00€
Ir pieejams Noliktavā 1
Produkta kods: 01120001032
Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy)
Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy) 14.00€
Ir pieejams Noliktavā 1
Produkta kods: 01120001033
Velcro slīpēšanas sprausla SENDI #200 (Copy)
Velcro slīpēšanas sprausla SENDI #200 (Copy) 14.00€
Ir pieejams Noliktavā 1
Produkta kods: 01120001034
SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai
SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai 29.00€
Izpārdots
Produkta kods: 01961204300
400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem
400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem 109.00€
Izpārdots
Produkta kods: 10120024020
RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals)
RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals) 52.00€
Izpārdots
Produkta kods: 11133053029
50W LED Prožektors
50W LED Prožektors 75.96€
Ir pieejams Noliktavā 101
Produkta kods: 475345
50W Sensora LED Prožektors
50W Sensora LED Prožektors 51.95€
Izpārdots
Produkta kods: 475431
CeraMAX 1800 Mechanic lielformāta darba galds
CeraMAX 1800 Mechanic lielformāta darba galds 762.00€
Ir pieejams Noliktavā 1
Produkta kods: 71419031035
Mapei Ultracare gluds silikons 750ml silikona aerosols
Mapei Ultracare gluds silikons 750ml silikona aerosols 11.48€
Ir pieejams Noliktavā 1
Produkta kods: 8022452220937
cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT
cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab
/ gab
Ir pieejams Noliktavā 4
Produkta kods: cc3829013
Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab.
Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab. 8.00€
Ir pieejams Noliktavā 1
Produkta kods: GL-FORM-RINK-4
HP EliteBook 850 G5 MAIN
HP EliteBook 850 G5 MAIN 619.83€ / gab
Ir pieejams Noliktavā 40
Produkta kods: HP EliteBook Main
BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla
BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla 22.00€
Ir pieejams Noliktavā 1
Produkta kods: LFBSL-TXP
test2
test2 474.00€
Ir pieejams Noliktavā 113
Produkta kods: test2
LED lentu profila stiprinājuma detaļas komplekts
LED lentu profila stiprinājuma detaļas komplekts 1.17€
Ir pieejams Noliktavā 111
Produkta kods: WD00-18
HP EliteBook 850 G5
HP EliteBook 850 G5 743.80€
Ir pieejams Noliktavā 20
Produkta kods: 123456
aa Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT
aa Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab
/ gab
Ir pieejams Noliktavā 3
Produkta kods: aa3829013
bb Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT
bb Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab
/ gab
Ir pieejams Noliktavā 4
Produkta kods: bb3829013
Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT
Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab
/ gab
Ir pieejams Noliktavā 1
Produkta kods: 3829013
dd Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT
dd Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab
/ gab
Ir pieejams Noliktavā 4
Produkta kods: dd3829013
Lodveida krāns ar taurenīti /I-I/ 7752, 1/2
Lodveida krāns ar taurenīti /I-I/ 7752, 1/2 4.45€ / gab
Ir pieejams Noliktavā 12
Produkta kods: 0620004
Makita PROWADNICA 40cm 1,3mm 3/8" DO UC4030A >>>191G34-7
Makita PROWADNICA 40cm 1,3mm 3/8" DO UC4030A >>>191G34-7 6.09€ / gab
/ gab
Ir pieejams Noliktavā 140
Produkta kods: G-15/5
<TEST> un " un 'un /(medium mask)
<TEST> un " un 'un /(medium mask) 5.30€ / gab
/ gab
Ir pieejams Noliktavā 114
Produkta kods: test12345
-17% Atlaide Lenovo ThinkPad 1111
Lenovo ThinkPad 1111
1,300.00€ 1,569.80€
Ir pieejams Noliktavā 99986
Produkta kods: Lenovo ThinkPad 111
Lenovo ThinkPad P52s 20LB000HPB
Lenovo ThinkPad P52s 20LB000HPB 1,569.80€
Ir pieejams Noliktavā 99982
Produkta kods: Lenovo ThinkPad ... Lenovo ThinkPad P52s 20LB000HPB
Lenovo ThinkPad L480 20LS001APB
Lenovo ThinkPad L480 20LS001APB 300.00€
Ir pieejams Noliktavā 456
Produkta kods: Lenovo ThinkPad ... Lenovo ThinkPad L480 20LS001APB
Lenovo ThinkPad L480 20LS001APB
Lenovo ThinkPad L480 20LS001APB 767.10€
Ir pieejams Noliktavā 996
Produkta kods: Lenovo ThinkPad ... Lenovo ThinkPad L480 20LS001APB
-9% Atlaide 2Lenovo ThinkPad L480 20LS001APB
2Lenovo ThinkPad L480 20LS001APB
700.00€ 767.10€
Ir pieejams Noliktavā 991
Produkta kods: LenovoXX
Lenovo ThinkPad X1 Carbon 6th Gen Black
Lenovo ThinkPad X1 Carbon 6th Gen Black 1,633.10€
Ir pieejams Noliktavā 988
Produkta kods: Lenovo ThinkPad ... Lenovo ThinkPad X1 Carbon 6th Gen Black
Queries: 84, Total time: 84.386 ms [By time] [By id] [By file]
1 (1.177)
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/elvijs.nomasveikals.lv/web/system/library/cart/tax.php:53
2 (0.602)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '0098f4691801024901839b3191da20d0'
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/cart.php:48
3 (0.624)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/event.php:4
4 (0.281)
SELECT sort_by
FROM oc_category
WHERE category_id = '0'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:59
5 (0.232)
SELECT view_type
FROM oc_category
WHERE category_id = '0'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:65
6 (0.521)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
7 (0.440)
SELECT cp.path_id AS category_id, cd.name, cd.seo_keyword
FROM oc_category_path cp
INNER JOIN oc_category c ON (cp.path_id = c.category_id)
INNER JOIN oc_category_description cd ON (cp.path_id = cd.category_id)
WHERE cp.category_id = '0' AND cd.language_id = '1'
ORDER BY cp.level
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:29
8 (2.092)
SELECT COUNT(*) AS total
FROM ( 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
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)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1599
9 (3.302)
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, pr_restricted.value AS restrict_customer_group, pr_blocked.value AS block_customer_group, pp.image, pp.model
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_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)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) AND pd.language_id = '1' GROUP BY p.product_id, product_id HAVING match_filters = 1
ORDER BY LCASE(pp.image) ASC, LCASE(pp.model) ASC LIMIT 0, 40
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:245
10 (3.817)
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 p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
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 <= p.minimum 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 <= p.minimum 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_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('374','375','376','377','378','379','380','381','382','383','349','347','348','344','342','343','352','353','341','350','335','345','324','346','340','351','310','331','332','330','336','337','338','339','11','17','309','13','16','18') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
11 (5.400)
SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340,351,310,331,332,330,336,337,338,339,11,17,309,13,16,18) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340,351,310,331,332,330,336,337,338,339,11,17,309,13,16,18)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2056
12 (1.485)
SELECT *
FROM oc_product p
WHERE p.product_id IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340,351,310,331,332,330,336,337,338,339,11,17,309,13,16,18)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2004
13 (3.389)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
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 = '11')
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 = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum 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 = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum 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 = '11')
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_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('11','13','16','17','18','309','310','324','331','330','332','335','336','341','337','338','339','340','342','343','344','345','346','347','348','349','350','351','352','353','374','375','376','377','378','379','380','381','382','383') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
14 (0.639)
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/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1767
15 (0.470)
SELECT *
FROM oc_stock_status
WHERE language_id = '1'
ORDER BY sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/localisation/stock_status.php:11
16 (0.466)
SELECT *
FROM oc_product_to_category
WHERE product_id IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340,351,310,331,332,330,336,337,338,339,11,17,309,13,16,18)
ORDER BY product_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1304
17 (1.544)
SELECT po.product_id, COUNT(*) AS total
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 IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340,351,310,331,332,330,336,337,338,339,11,17,309,13,16,18) AND od.language_id = '1' GROUP BY po.product_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1326
18 (0.286)
SELECT *
FROM oc_product_to_category
WHERE product_id = '374'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
19 (0.237)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '374'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
20 (0.296)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
21 (0.330)
SELECT *
FROM oc_product_to_category
WHERE product_id = '375'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
22 (0.291)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '375'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
23 (0.282)
SELECT *
FROM oc_product_to_category
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
24 (0.262)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
25 (0.253)
SELECT *
FROM oc_product_to_category
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
26 (0.263)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
27 (0.284)
SELECT *
FROM oc_product_to_category
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
28 (0.267)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
29 (0.327)
SELECT *
FROM oc_product_to_category
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
30 (0.300)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
31 (0.283)
SELECT *
FROM oc_product_to_category
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
32 (0.256)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
33 (0.274)
SELECT *
FROM oc_product_to_category
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
34 (0.265)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
35 (0.300)
SELECT *
FROM oc_product_to_category
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
36 (0.348)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
37 (0.292)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
38 (0.307)
SELECT *
FROM oc_product_to_category
WHERE product_id = '349'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
39 (0.304)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '349'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
40 (0.309)
SELECT *
FROM oc_product_to_category
WHERE product_id = '347'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
41 (0.238)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '347'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
42 (0.247)
SELECT *
FROM oc_product_to_category
WHERE product_id = '348'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
43 (0.280)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '348'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
44 (0.392)
SELECT *
FROM oc_product_to_category
WHERE product_id = '344'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
45 (0.457)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '344'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
46 (0.289)
SELECT *
FROM oc_product_to_category
WHERE product_id = '342'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
47 (0.319)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '342'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
48 (0.284)
SELECT *
FROM oc_product_to_category
WHERE product_id = '343'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
49 (0.255)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '343'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
50 (0.260)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '353'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
51 (0.270)
SELECT *
FROM oc_product_to_category
WHERE product_id = '341'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
52 (0.311)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '341'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
53 (0.269)
SELECT *
FROM oc_product_to_category
WHERE product_id = '350'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
54 (0.228)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '350'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
55 (0.306)
SELECT *
FROM oc_product_to_category
WHERE product_id = '335'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
56 (0.256)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '335'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
57 (0.221)
SELECT *
FROM oc_product_to_category
WHERE product_id = '345'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
58 (0.289)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '345'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
59 (0.295)
SELECT *
FROM oc_product_to_category
WHERE product_id = '346'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
60 (0.260)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '346'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
61 (0.269)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '340'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
62 (0.238)
SELECT *
FROM oc_product_to_category
WHERE product_id = '351'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
63 (0.302)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '331'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
64 (0.259)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '332'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
65 (0.279)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '330'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
66 (0.293)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '336'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
67 (0.208)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '337'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
68 (0.279)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '338'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
69 (0.300)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '11'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
70 (0.327)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '17'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
71 (0.291)
SELECT *
FROM oc_product_to_category
WHERE product_id = '309'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
72 (0.340)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '309'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
73 (0.344)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '13'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
74 (0.340)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '16'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
75 (6.984)
SELECT category_id, layout_id
FROM oc_category_to_layout
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:117
76 (0.318)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '0'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:142
77 (0.671)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route
ORDER BY route DESC LIMIT 1
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/layout.php:11
78 (0.635)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3'
ORDER BY sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/layout.php:29
79 (0.298)
SELECT *
FROM oc_module
WHERE module_id = '62'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
80 (2.165)
SELECT COUNT(*) AS total
FROM ( 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
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)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1223
81 (29.459)
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 c.status = 1 AND cd.language_id = '1'
ORDER BY c.parent_id, c.sort_order, LCASE(cd.name)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1878
82 (0.227)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'extension/module/brainyfilter'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15
83 (0.406)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/customer.php:144
84 (0.330)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'snippets/category/category_no_subcategories'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15