Filter
Atslēgvārdi
Kategorijas
1313
1314
1317
1319
1316
1315
1318
1139
1227
1228
1229
1230
1231
1232
1233
1162
1173
1176
1178
1179
1180
1181
1182
1183
1184
1170
1185
1186
1171
1163
1187
1164
1188
1189
1190
1168
1167
1191
1192
1193
1165
1194
1195
1169
1196
1197
1198
1166
1199
1140
1172
1151
1141
1146
1150
1152
1144
1153
1148
1154
1155
1147
1156
1142
1225
1157
1158
1159
1149
1143
1160
1161
1145
1247
1248
1249
1250
1251
1252
1253
1254
1255
1234
1235
1243
1242
1239
1244
1236
1245
1246
1241
1240
1237
1238
1286
1287
1257
1258
1259
1226
1265
1266
1267
1285
1282
1283
1284
1279
1278
1280
1256
1268
1269
1270
1271
1272
1261
1262
1263
1264
1260
1281
1220
1222
1221
1223
1224
1200
1204
1209
1210
1205
1211
1206
1203
1212
1202
1213
1208
1207
1214
1201
1215
1273
1275
1276
1274
1277
1340
1288
1300
1292
1309
1298
1311
1302
1295
1294
1303
1293
1291
1290
1307
1308
1310
1299
1306
1305
1304
1297
1296
1289
1301
1320
1331
1333
1321
1328
1325
1324
1329
1330
1323
1326
1332
1327
1322
1028
1071
1073
1075
1076
1077
1072
1078
1074
1079
1081
1083
1084
1085
1082
1080
1138
1134
1124
1130
1129
1131
1132
1127
1126
1125
1128
1137
1034
1039
1044
1045
1040
1041
1046
1042
1036
1047
1048
1037
1043
1035
1038
1101
1104
1105
1102
1106
1103
1114
1116
1117
1118
1115
1119
1092
1094
1095
1096
1093
1029
1030
1033
1032
1031
1135
1086
1088
1091
1089
1087
1090
1049
1052
1054
1055
1056
1050
1057
1053
1058
1051
1113
1133
1059
1062
1060
1061
1107
1108
1112
1110
1109
1111
1136
1120
1121
1122
1123
1064
1068
1067
1065
1069
1066
1070
1097
1098
1099
1100
1334
1335
1338
1337
1336
1339
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: 33, Total time: 55.832 ms [By time] [By id] [By file]
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.788)
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.366)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'o2suoitv71gno2bmffpiut0rpp'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (2.282)
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.906)
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 = 'majsaimniecibas-preces' AND c.parent_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:96
6 (0.281)
SELECT sort_by
FROM oc_category
WHERE category_id = '1027'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:28
7 (0.176)
SELECT view_type
FROM oc_category
WHERE category_id = '1027'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:34
8 (0.427)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '1027' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
9 (0.888)
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 = '1027'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/controller/product/category.php:115
10 (0.776)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '1027' 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.346)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.265)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.301)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.294)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.305)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.302)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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.270)
SELECT *
FROM oc_category_description
WHERE `category_id` = '1027' 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 (3.080)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:761
19 (4.482)
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 = '1027' 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
20 (0.397)
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
21 (0.930)
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
22 (0.611)
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
23 (0.691)
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
24 (1.286)
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 = '1027') 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
25 (0.867)
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 = '1027' 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
26 (0.664)
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 = '1027' 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
27 (0.511)
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 = '1027'
ORDER BY m.sort_order, m.name
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1209
28 (0.443)
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 = '1027'
ORDER BY ss.sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module/brainyfilter.php:1262
29 (0.312)
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
30 (29.517)
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
31 (0.624)
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
32 (0.528)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
33 (0.525)
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