img
img
img
kle

Jaunākie produkti LV Skatīt vairāk

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) 100.00€ / m2 0024218.130
Ir pieejams Noliktavā 220
/ 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ņš (Zils) CYCRA NUMBERPLATE atslēgu piekariņš (Zils) 2.95€ / m2 0024218.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 SERIES ONE NO CLAMPS roku sargi, Zili CYCRA SERIES ONE NO CLAMPS roku sargi, Zili 74.95€ / m2 0024070.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 STEALTH MX ALLOY roku sargi, Zili CYCRA STEALTH MX ALLOY roku sargi, Zili 52.95€ / m2 0024030.040
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Balti CYCRA STEALTH MX ALLOY roku sargi, Balti 52.95€ / m2 0024030.030
Izpārdots
/ m2

Akcijas preces Skatīt vairāk

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
Lenovo ThinkPad 1111 Lenovo ThinkPad 1111
1,300.00€ 1,569.80€
Ir pieejams Noliktavā 99986
2Lenovo ThinkPad L480 20LS001APB 2Lenovo ThinkPad L480 20LS001APB
700.00€ 767.10€
Ir pieejams Noliktavā 991

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ā stiprināt imūnsistēmu ziemas mēnešos?

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

Queries: 29, Total time: 16.972 ms [By time] [By id] [By file]
1 (0.969)
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.340)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3v554qqha399pc49rj4hkqk0lf'
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/cart.php:45
3 (0.451)
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.498)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4'
ORDER BY sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/layout.php:29
5 (1.408)
SHOW COLUMNS
FROM `oc_banner` LIKE 'width'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
6 (1.028)
SHOW COLUMNS
FROM `oc_banner` LIKE 'height'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
7 (0.995)
SHOW COLUMNS
FROM `oc_banner` LIKE 'width_m'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
8 (1.018)
SHOW COLUMNS
FROM `oc_banner` LIKE 'height_m'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
9 (0.959)
SHOW COLUMNS
FROM `oc_banner` LIKE 'slider_speed'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
10 (0.975)
SHOW COLUMNS
FROM `oc_banner` LIKE 'autoplay_speed'
/var/www/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:67
11 (0.378)
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/elvijs.nomasveikals.lv/web/storage/modification/catalog/model/design/banner.php:6
12 (0.533)
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 = '61' 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
13 (0.675)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:31
14 (0.431)
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 = '66' 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
15 (0.357)
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 = '489' 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
16 (0.414)
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 = '488' 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
17 (0.361)
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 = '487' 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
18 (0.340)
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 = '556' 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
19 (0.380)
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 = '553' 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
20 (0.342)
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 = '1613' 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
21 (0.333)
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 = '503' 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
22 (0.832)
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/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:71
23 (0.553)
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/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
24 (0.455)
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/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
25 (0.437)
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/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
26 (0.385)
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 = '19' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
27 (0.421)
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/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
28 (0.402)
SELECT *
FROM oc_url_alias
WHERE `query` = 'blog/home' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:425
29 (0.302)
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