Carp Zoom

Carp Zoom

Sortare după:

MOMITOR CARP ZOOM FEEDER PICATURA ECOLOGIC 10gr

MOMITOR CARP ZOOM FEEDER PICATURA ECOLOGIC 10gr

cz9457

Livrare imediată!

11,07Lei

Porumb CARP ZOOM Corn-X, Natural, 25g

Porumb CARP ZOOM Corn-X, Natural, 25g

cz6061

Livrare 48-72 ore

13,10Lei

JIG CARP ZOOM B-ROUND PREDATOR-Z 14gr 5/PLIC

JIG CARP ZOOM B-ROUND PREDATOR-Z 14gr 5/PLIC

cz2287

Livrare 48-72 ore

18,17Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 545 nr.6 10/plic

CARLIGE CARP ZOOM FEEDER COMPETITION 545 nr.6 10/plic

cz2911

Livrare imediată!

9,64Lei

CARLIGE CARP ZOOM MARSHAL ORIGO WIDE GAPE nr 6 10/PLIC

CARLIGE CARP ZOOM MARSHAL ORIGO WIDE GAPE nr 6 10/PLIC

cz4656

Livrare imediată!

12,69Lei

Varf feeder Carp Zoom Feeder Competition Serie Fine 3.60m

Varf feeder Carp Zoom Feeder Competition Serie Fine 3.60m

cz5745

Livrare 48-72 ore

42,00Lei(-20%) 33,44Lei

Spreader Block Carp Zoom pentru Minciog

Spreader Block Carp Zoom pentru Minciog

cz5738

Livrare imediată!

27,44Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.12 10/PLIC

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.12 10/PLIC

cz6650

Livrare imediată!

10,56Lei

Lanseta Carp Zoom Tele Allround 90, 2.70m, 40-90g

Lanseta Carp Zoom Tele Allround 90, 2.70m, 40-90g

cz6094

Livrare 48-72 ore

133,08Lei

Maner Minciog Carp Zoom Feeder Competition 3.00m

Maner Minciog Carp Zoom Feeder Competition 3.00m

cz5967

Livrare imediată!

89,36Lei

Geanta Carp Zoom Multi Fishing Camou 57x27x31cm

Geanta Carp Zoom Multi Fishing Camou 57x27x31cm

cz7053

Livrare 48-72 ore

239,00Lei(-23%) 183,92Lei

MARKER CARP ZOOM BUOYANT CU LUMINA SI SENZOR ROSU

MARKER CARP ZOOM BUOYANT CU LUMINA SI SENZOR ROSU

cz0398

Livrare 48-72 ore

59,97Lei

VARTEJ CARP ZOOM ROLLING X-PATTERN nr.10

VARTEJ CARP ZOOM ROLLING X-PATTERN nr.10

cz1005

Livrare 48-72 ore

7,51Lei

Geaca Carp Zoom Polar Full Zip XXL

Geaca Carp Zoom Polar Full Zip XXL

cz7251

Livrare 48-72 ore

136,00Lei(-22%) 105,63Lei

FIR TEXTIL CARP ZOOM PREDATOR-Z ZRX 8X 120m 0.30mm

FIR TEXTIL CARP ZOOM PREDATOR-Z ZRX 8X 120m 0.30mm

cz7428

Livrare 48-72 ore

72,00Lei(-15%) 60,89Lei

Sita pentru Nada Carp Zoom Feeder Competition 36cm 4.5mm

Sita pentru Nada Carp Zoom Feeder Competition 36cm 4.5mm

cz0084

Livrare 48-72 ore

92,41Lei

MARKER Carp Zoom CU LUMINA TWILIGHT FLOAT

MARKER Carp Zoom CU LUMINA TWILIGHT FLOAT

cz2996

Livrare 48-72 ore

28,35Lei

MANUSI Carp Zoom NEOPRENE CARP ZOOM SMART M

MANUSI Carp Zoom NEOPRENE CARP ZOOM SMART M

cz2811

Livrare 48-72 ore

92,41Lei

STRUNA TITAN CARP ZOOM PREDATOR Z 30CM 15KG 2/PLIC

STRUNA TITAN CARP ZOOM PREDATOR Z 30CM 15KG 2/PLIC

cz5616

Livrare imediată!

27,00Lei(-21%) 21,24Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FEEDER 300m 0.20mm 5.6kg Brown

FIR MONOFILAMENT CARPZOOM BULL-DOG FEEDER 300m 0.20mm 5.6kg Brown

cz6437

Livrare 48-72 ore

19,20Lei

Afişare 441 - 460 din 1706 (86 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: 95.858 ms [By time] [By id] [By file]

1 (0.183)

SELECT data
FROM `oc_session`
WHERE session_id = 'e97a51e5f55b156d111c59b03f'

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

2 (0.147)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.104)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Carp-Zoom'

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

4 (0.138)

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

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

5 (39.001)

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 = '0' AND p.manufacturer_id = '75'

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

6 (56.160)

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 = '0' AND p.manufacturer_id = '75' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20

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

7 (0.125)

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

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