Maver

Maver

Sortare după:

FIR MAVER ZERO FLUOROCARBON 50M 0.386MM

FIR MAVER ZERO FLUOROCARBON 50M 0.386MM

732386

Livrare 48-72 ore

74,11Lei

FIR MONOFILAMENT MAVER ARCADIUM SILVER SOFT 100M 0.218MM

FIR MONOFILAMENT MAVER ARCADIUM SILVER SOFT 100M 0.218MM

680218

Livrare imediată!

21,70Lei(-45%) 11,98Lei

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.106MM

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.106MM

725106

Livrare 48-72 ore

30,40Lei

COSULET MAVER JURASSIC CAGE FEEDER ROTUND MASH 4X12 MESH 20gr

COSULET MAVER JURASSIC CAGE FEEDER ROTUND MASH 4X12 MESH 20gr

00413020

Livrare 48-72 ore

11,00Lei(-10%) 9,95Lei

FIR MONOFILAMENT MAVER SMART RED DEVIL 150M 0.30MM

FIR MONOFILAMENT MAVER SMART RED DEVIL 150M 0.30MM

652030

Livrare 48-72 ore

27,35Lei

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X43MM 40g

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X43MM 40g

00425040

Livrare 48-72 ore

21,01Lei(-14%) 18,08Lei

FIR MONOFILAMENT MAVER SMART X LINE 600M 0.18MM

FIR MONOFILAMENT MAVER SMART X LINE 600M 0.18MM

637018

Livrare 48-72 ore

51,00Lei(-45%) 27,84Lei

CARLIGE LEGATE MAVER JURASSIC J21 NR 6-0.24

CARLIGE LEGATE MAVER JURASSIC J21 NR 6-0.24

j2100624

Livrare 48-72 ore

7,01Lei(-2%) 6,90Lei

VARTEJ MAVER MV-R DIAMOND NR.14 31kg 10buc/plic

VARTEJ MAVER MV-R DIAMOND NR.14 31kg 10buc/plic

01541014

Livrare imediată!

7,10Lei

CARLIGE MAVER KATANA SERIA MATCH KM5 NR 22 Nickel

CARLIGE MAVER KATANA SERIA MATCH KM5 NR 22 Nickel

km05a022

Livrare 48-72 ore

19,71Lei

AGRAFA MAVER MV-R DUO LOOK SPIN STEEL NR.8 80kg 5/plic

AGRAFA MAVER MV-R DUO LOOK SPIN STEEL NR.8 80kg 5/plic

01572008

Livrare 48-72 ore

6,50Lei(-3%) 6,29Lei

CARLIGE MAVER KATANA SERIA SEA KS4 NR 10 Black Nickel

CARLIGE MAVER KATANA SERIA SEA KS4 NR 10 Black Nickel

ks04a010

Livrare imediată!

15,65Lei

BORSETA EVA REALITY SMART BAG BIG 26X16X9cm

BORSETA EVA REALITY SMART BAG BIG 26X16X9cm

6108020

Livrare 48-72 ore

174,77Lei

CARLIGE MAVER KATANA SERIA CRAP 0.6A NR 12

CARLIGE MAVER KATANA SERIA CRAP 0.6A NR 12

06akca12

Livrare 48-72 ore

21,24Lei

MULINETA MAVER LASER 6000 10+1RUL

MULINETA MAVER LASER 6000 10+1RUL

809mla60

Livrare 48-72 ore

413,72Lei

CARLIGE MAVER KATANA C002 NR 6

CARLIGE MAVER KATANA C002 NR 6

0c002006

Livrare imediată!

25,30Lei

CARLIGE MAVER KATANA 1041 BRONZ NR 16

CARLIGE MAVER KATANA 1041 BRONZ NR 16

1041a016

Livrare 48-72 ore

23,27Lei

CARLIGE MAVER KATANA 1110 NICHEL NR 10

CARLIGE MAVER KATANA 1110 NICHEL NR 10

1110a010

Livrare 48-72 ore

25,30Lei

CARLIGE MAVER KATANA 1131 BRONZ NR 14

CARLIGE MAVER KATANA 1131 BRONZ NR 14

1131a014

Livrare 48-72 ore

21,24Lei

CARLIGE MAVER KATANA 1215 NEGRU NR 12

CARLIGE MAVER KATANA 1215 NEGRU NR 12

1215a012

Livrare 48-72 ore

20,22Lei

Afişare 941 - 960 din 1728 (87 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 104.190 ms [By time] [By id] [By file]

1 (0.107)

SELECT data
FROM `oc_session`
WHERE session_id = '4c0141dbf6b6abc8fe2cdce024'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.098)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.116)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.120)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '49' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (41.333)

SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '49'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (62.256)

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '49' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 940,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.160)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37