Maver

Maver

Sortare după:

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.12MM

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.12MM

670012

Livrare 48-72 ore

41,58Lei

COSULET MAVER JURASSIC CAGE FEEDER RIVER 200g

COSULET MAVER JURASSIC CAGE FEEDER RIVER 200g

00416200

Livrare imediată!

25,00Lei(-15%) 21,34Lei

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.30MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.30MM

626030

Livrare 48-72 ore

97,49Lei

COSULET MAVER JURASSIC DISTANCE FEEDER 30X50mm 50g

COSULET MAVER JURASSIC DISTANCE FEEDER 30X50mm 50g

00422050

Livrare 48-72 ore

20,50Lei(-14%) 17,68Lei

CARLIGE LEGATE MAVER JURASSIC J09 NR 2-0.28

CARLIGE LEGATE MAVER JURASSIC J09 NR 2-0.28

j0900228

Livrare 48-72 ore

8,00Lei(-5%) 7,61Lei

Lanseta Maver Reality Tele Boat 2.40m, 20-80g

Lanseta Maver Reality Tele Boat 2.40m, 20-80g

5722240

Livrare 48-72 ore

230,70Lei

CARLIGE MAVER KATANA SERIA MATCH KM3 NR 20 BRONZ

CARLIGE MAVER KATANA SERIA MATCH KM3 NR 20 BRONZ

km03a020

Livrare 48-72 ore

14,63Lei

VARTEJ CU RULMENT MAVER MONSTER STEEL Nr.16 100kg 10BUC/PLIC

VARTEJ CU RULMENT MAVER MONSTER STEEL Nr.16 100kg 10BUC/PLIC

01573016

Livrare 48-72 ore

47,00Lei(-17%) 39,23Lei

CARLIGE MAVER KATANA SERIA SEA KS2 NR 6 Black Nickel

CARLIGE MAVER KATANA SERIA SEA KS2 NR 6 Black Nickel

ks02a006

Livrare 48-72 ore

16,15Lei

AGRAFA MAVER MV-R STEEL NR.14 60kg 10buc/plic

AGRAFA MAVER MV-R STEEL NR.14 60kg 10buc/plic

01569014

Livrare 48-72 ore

7,50Lei(-5%) 7,10Lei

CARLIGE MAVER KATANA SERIA CRAP 0.3B NR 18 BARBLESS

CARLIGE MAVER KATANA SERIA CRAP 0.3B NR 18 BARBLESS

03bkca18

Livrare 48-72 ore

15,65Lei

VARGA MAVER REALITY SL 5.0M

VARGA MAVER REALITY SL 5.0M

8449b500

Livrare 48-72 ore

439,15Lei

CARLIGE MAVER KATANA IRIDIUM TUNA NR 2/0

CARLIGE MAVER KATANA IRIDIUM TUNA NR 2/0

i771a2/0

Livrare 48-72 ore

13,10Lei

CARLIGE MAVER KATANA 1040 NICHEL NR 10

CARLIGE MAVER KATANA 1040 NICHEL NR 10

1040a010

Livrare 48-72 ore

23,27Lei

CARLIGE MAVER KATANA 1091 BRONZ NR 14

CARLIGE MAVER KATANA 1091 BRONZ NR 14

1091a014

Livrare 48-72 ore

25,30Lei

CARLIGE MAVER KATANA 1130 NICHEL NR 15

CARLIGE MAVER KATANA 1130 NICHEL NR 15

1130a015

Livrare 48-72 ore

21,24Lei

CARLIGE MAVER KATANA 1175 NEGRU NR 12

CARLIGE MAVER KATANA 1175 NEGRU NR 12

1175a012

Livrare 48-72 ore

16,15Lei

PLUTA MAVER WIN RED 0.75GR

PLUTA MAVER WIN RED 0.75GR

9050075

Livrare imediată!

11,57Lei

PLUTA MAVER CAORLE 5.0GR PORT STARLET 4.5MM

PLUTA MAVER CAORLE 5.0GR PORT STARLET 4.5MM

7905500

Livrare 48-72 ore

14,12Lei

SONDA ADANCIME CU PLUTA MAVER 8GR

SONDA ADANCIME CU PLUTA MAVER 8GR

164008

Livrare 48-72 ore

11,07Lei

Afişare 261 - 280 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: 109.948 ms [By time] [By id] [By file]

1 (0.094)

SELECT data
FROM `oc_session`
WHERE session_id = '1b509b99c8a03b2aa43cb00ee5'

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

2 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.131)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

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

4 (0.083)

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 (47.653)

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 (61.783)

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 260,20

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

7 (0.097)

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