Maver

Maver

Sortare după:

FIR MONOFILAMENT MAVER SMART DUAL BAND 150M 0.25MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 150M 0.25MM

631025

Livrare 48-72 ore

46,65Lei

COSULET MAVER JURASSIC OPEN END FEEDER LARGE 30X44MM 40g

COSULET MAVER JURASSIC OPEN END FEEDER LARGE 30X44MM 40g

00428040

Livrare 48-72 ore

14,00Lei(-11%) 12,39Lei

CARLIGE MAVER JURASSIC SERIE J16 NR 18

CARLIGE MAVER JURASSIC SERIE J16 NR 18

j1601800

Livrare imediată!

5,47Lei

COSULET MAVER JURASSIC CAPPED BIG CAGE FEEDING FEEDER 20g XXL

COSULET MAVER JURASSIC CAPPED BIG CAGE FEEDING FEEDER 20g XXL

00419003

Livrare 48-72 ore

38,50Lei(-16%) 32,32Lei

CARLIGE LEGATE MAVER JURASSIC J22 NR 4-0.20 90CM

CARLIGE LEGATE MAVER JURASSIC J22 NR 4-0.20 90CM

j2210420

Livrare 48-72 ore

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

VARTEJ MAVER MV-R DUAL COLOR NR.20 10buc/plic

VARTEJ MAVER MV-R DUAL COLOR NR.20 10buc/plic

01558020

Livrare imediată!

9,99Lei(-9%) 9,14Lei

CARLIGE MAVER KATANA SERIA TROUT KT1 NR 10 Nickel

CARLIGE MAVER KATANA SERIA TROUT KT1 NR 10 Nickel

kt01a010

Livrare imediată!

12,18Lei

AGRAFA MAVER MV-R MONSTER STEEL NR.6 140kg 5buc/plic

AGRAFA MAVER MV-R MONSTER STEEL NR.6 140kg 5buc/plic

01574006

Livrare 48-72 ore

9,00Lei(-8%) 8,32Lei

CARLIGE MAVER KATANA SERIA CRAP 0.3A NR 8

CARLIGE MAVER KATANA SERIA CRAP 0.3A NR 8

03akca08

Livrare 48-72 ore

15,13Lei

Varga Maver Stealth BLX 6.00M

Varga Maver Stealth BLX 6.00M

8462b600

Livrare imediată!

306,05Lei

CARLIGE MAVER KATANA C012 NR 2

CARLIGE MAVER KATANA C012 NR 2

c012a002

Livrare 48-72 ore

13,61Lei

Juvelnic Comercial Maver IT MV-R Patrat, 3.00m

Juvelnic Comercial Maver IT MV-R Patrat, 3.00m

8041300

Livrare 48-72 ore

500,15Lei

CARLIGE MAVER KATANA 1115 BLACK NICHEL NR 20

CARLIGE MAVER KATANA 1115 BLACK NICHEL NR 20

1115a020

Livrare 48-72 ore

25,30Lei

CARLIGE MAVER KATANA 1090 NICHEL NR 10

CARLIGE MAVER KATANA 1090 NICHEL NR 10

1090a010

Livrare 48-72 ore

25,30Lei

CARLIGE MAVER KATANA 1113 GALBEN NR 12

CARLIGE MAVER KATANA 1113 GALBEN NR 12

1113a012

Livrare 48-72 ore

25,30Lei

CARLIGE MAVER KATANA 1150 NICHEL NR 16

CARLIGE MAVER KATANA 1150 NICHEL NR 16

1150a016

Livrare 48-72 ore

19,20Lei

CARLIGE MAVER KATANA 1245 NEGRU NR 10

CARLIGE MAVER KATANA 1245 NEGRU NR 10

1245a010

Livrare 48-72 ore

16,15Lei

PLUTA MAVER GROSSETO 4.0GR PORT STARLET 4.5MM

PLUTA MAVER GROSSETO 4.0GR PORT STARLET 4.5MM

7902400

Livrare 48-72 ore

15,13Lei

MOMITOR MAVER PRO-FEEDER RACK OPEN END 30GR

MOMITOR MAVER PRO-FEEDER RACK OPEN END 30GR

179330

Livrare imediată!

14,70Lei(-16%) 12,39Lei

Agrafa Rapida NR 2 MAVER

Agrafa Rapida NR 2 MAVER

1495002

Livrare 48-72 ore

13,10Lei

Afişare 641 - 660 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: 97.428 ms [By time] [By id] [By file]

1 (0.140)

SELECT data
FROM `oc_session`
WHERE session_id = '0a0bee4cefd604ebbed5a892f2'

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

2 (0.118)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.142)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

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

4 (0.137)

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

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

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

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

7 (0.121)

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