img
img
img

Jaunākās preces

Attēls Produkta nosaukums Cena Produkta kods text_stock entry_qty
TestaProdukts3 TestaProdukts3 10.00€ Test3
text_stock: 1
TestaProdukts2 TestaProdukts2 99.00€ Test2
Izpārdots
Benzīna ģenerators 8000W, KS 10000E-3 ATS, KONNER & SOHNEN Benzīna ģenerators 8000W, KS 10000E-3 ATS, KONNER & SOHNEN 1,131.35€ KS-10000E-3-ATS
text_stock: 1
Benzīna ģenerators 8000W, KS 10000E-1/3, KONNER & SOHNEN Benzīna ģenerators 8000W, KS 10000E-1/3, KONNER & SOHNEN 1,131.35€ KS-10000E-1/3
text_stock: 986
Universāla motoreļļa 1l, KS 10W-30 OIL, KONNER & SOHNEN Universāla motoreļļa 1l, KS 10W-30 OIL, KONNER & SOHNEN
5.00€ 8.47€
KS-10W-30-OIL
text_stock: 983

Jaunākie produkti Skatīt vairāk

Aktuālās preces Skatīt vairāk

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
HP EliteBook 850 G5 HP EliteBook 850 G5
600.00€ 900.00€
HP EliteBook 850 G5
Noliktavā: 331
Lenovo ThinkPad L480 20LS001APB Lenovo ThinkPad L480 20LS001APB
847.00€ 928.19€
Lenovo ThinkPad L480 20LS001APB
Noliktavā: 455
Lenovo ThinkPad L480 20LS001APB Lenovo ThinkPad L480 20LS001APB
575.48€ 928.19€
Lenovo ThinkPad L480 20LS001APB
Noliktavā: 333
Lenovo ThinkPad P52s 20LB000HPB Elite Lenovo ThinkPad P52s 20LB000HPB Elite
31.00€ / gab 50.00€
Lenovo ThinkPad P52s 20LB000HPB
2-3 dienas
Lenovo ThinkPad X1 Carbon 6th Gen Black Lenovo ThinkPad X1 Carbon 6th Gen Black
367.55€ 1,976.05€
Lenovo ThinkPad X1 Carbon 6th Gen Black
Noliktavā: 1081

Jaunākās ziņas Apskatīt visus

Ziemassvētku aktualitātes

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Pirktākie 2020. gada viedtālruņi

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Pirmās pavasara puķes

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Kādu telti izvēlēties pārgājieniem?

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
#

Par piegādi

Interneta veikals padara iepirkšanos vienkāršu un ērtu - izdari pasūtījumu, izvēlies vēlamo apmaksas un piegādes veidu un saņem savu jauno pirkumu maksimāli ātri. Piedāvajam preces saņemt birojā, piegādāt uz Tavu vēlamo adresi, vai arī saņemt kādā no piegādes punktiem.

Uzzināt vairāk

Ražotāji

Queries: 61, Total time: 27.071 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.736)
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.406)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'l3jkju29gund3sr4p9hvn6uupg'
/var/www/dev4.nomasveikals.lv/web/system/library/cart/cart.php:44
4 (0.726)
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.434)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4'
ORDER BY sort_order
/var/www/dev4.nomasveikals.lv/web/catalog/model/design/layout.php:29
6 (0.477)
SELECT *
FROM oc_banner b
LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '7' AND b.status = '1' AND bi.language_id = '1'
ORDER BY bi.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:4
7 (0.358)
SELECT *
FROM oc_product_to_category
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
8 (0.418)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '243' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
9 (0.333)
SELECT *
FROM oc_category_description
WHERE `category_id` = '243' 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
10 (0.318)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
11 (0.250)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
12 (0.212)
SELECT *
FROM oc_product_to_category
WHERE product_id = '640'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
13 (0.382)
SELECT *
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 = '640' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
14 (0.341)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '640' 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:359
15 (0.208)
SELECT *
FROM oc_product_to_category
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
16 (0.348)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '221' AND cd.language_id = '1' AND c.status = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/category.php:4
17 (0.263)
SELECT *
FROM oc_category_description
WHERE `category_id` = '221' 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.319)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
19 (0.227)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
20 (0.159)
SELECT *
FROM oc_product_to_category
WHERE product_id = '639'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
21 (0.331)
SELECT *
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 = '639' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
22 (0.221)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '639' 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:359
23 (0.236)
SELECT *
FROM oc_product_to_category
WHERE product_id = '631'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
24 (0.409)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
25 (0.245)
SELECT *
FROM oc_product_to_category
WHERE product_id = '631'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
26 (0.423)
SELECT *
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 = '631' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
27 (0.390)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '631' 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:359
28 (0.285)
SELECT *
FROM oc_product_to_category
WHERE product_id = '632'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
29 (0.418)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
30 (0.295)
SELECT *
FROM oc_product_to_category
WHERE product_id = '632'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
31 (0.527)
SELECT *
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 = '632' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
32 (0.417)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '632' 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:359
33 (0.272)
SELECT *
FROM oc_product_to_category
WHERE product_id = '629'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
34 (0.399)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/dev4.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
35 (0.358)
SELECT *
FROM oc_product_to_category
WHERE product_id = '629'
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1337
36 (0.467)
SELECT *
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 = '629' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/dev4.nomasveikals.lv/web/storage/modification/catalog/model/catalog/product.php:1143
37 (0.373)
SELECT seo_keyword
FROM oc_product_description
WHERE `product_id` = '629' 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:359
38 (1.071)
SELECT *
FROM oc_blog n
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
LEFT JOIN oc_blog_to_category n2c ON (n.blog_id = n2c.blog_id)
WHERE nd.language_id = '1' AND n2c.blog_category_id = '50' AND n.status = '1' AND n.sort_order <> '-1'
ORDER BY n.sort_order, n.blog_id DESC LIMIT 0,5
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:71
39 (0.827)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '25' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
40 (0.765)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '24' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
41 (0.532)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '23' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
42 (0.730)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '16' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/dev4.nomasveikals.lv/web/catalog/model/blog/blog.php:161
43 (0.584)
SELECT *
FROM oc_url_alias
WHERE `query` = 'blog/home'
/var/www/dev4.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:394
44 (2.626)
SELECT m.*, md.*, product_count
FROM oc_manufacturer m
LEFT JOIN (SELECT manufacturer_id, COUNT(product_id) AS product_count
FROM oc_product
WHERE status = 1 GROUP BY manufacturer_id) AS p ON (m.manufacturer_id = p.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
WHERE m.status = 1 AND product_count > 0
ORDER BY name ASC LIMIT 0,24
/var/www/dev4.nomasveikals.lv/web/catalog/model/catalog/manufacturer.php:45
45 (0.498)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '1371' 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:359
46 (0.412)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '326' 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:359
47 (0.307)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '786' 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:359
48 (0.328)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3430' 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:359
49 (0.276)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3434' 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:359
50 (0.252)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3426' 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:359
51 (0.287)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3432' 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:359
52 (0.278)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3437' 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:359
53 (0.268)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3436' 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:359
54 (0.281)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3424' 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:359
55 (0.208)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3414' 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:359
56 (0.195)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3431' 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:359
57 (0.351)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3429' 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:359
58 (0.280)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3435' 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:359
59 (0.231)
SELECT seo_keyword
FROM oc_manufacturer_description
WHERE `manufacturer_id` = '3413' 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:359
60 (0.559)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/dev4.nomasveikals.lv/web/catalog/model/extension/module.php:11
61 (0.552)
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