Carp Zoom


SET CROSETE Carp Zoom ORIGO 4in1 BAITING NEEDLES

SET CROSETE Carp Zoom ORIGO 4in1 BAITING NEEDLES

cz2873
Livrare 48-72 ore

47,67Lei

Naluca Carp Zoom PREDATOR-Z TESTOASA TORTUGA 5.5cm 11gr

Naluca Carp Zoom PREDATOR-Z TESTOASA TORTUGA 5.5cm 11gr

cz3337
Livrare 48-72 ore

27,35Lei

MOMITOR Maver IT MV-R METHOD FEEDER M 60gr

MOMITOR Maver IT MV-R METHOD FEEDER M 60gr

0040260m
Livrare 48-72 ore

38,51Lei

Stoper Boilies Transparent 200/plic -Carp Zoom

Stoper Boilies Transparent 200/plic -Carp Zoom

cz1656
Livrare imediată!

9,14Lei

Husa Scaun CarpZoom CZ Avix 100x85x24cm

Husa Scaun CarpZoom CZ Avix 100x85x24cm

cz6246
Livrare imediată!

149,35Lei

NADA CARP ZOOM CARP FIESTA 1KG AROMA CAPSUNI

NADA CARP ZOOM CARP FIESTA 1KG AROMA CAPSUNI

cz3233
Livrare 48-72 ore

18,22Lei

TUB SILICON CARPZOOM FLEXI 0.5/1.5mm 1m Verde

TUB SILICON CARPZOOM FLEXI 0.5/1.5mm 1m Verde

cz5560
Livrare 48-72 ore

11,07Lei

PUFARINE CARP ZOOM NPF FLOTANTE PELETE MINI 30GR VANILIE

PUFARINE CARP ZOOM NPF FLOTANTE PELETE MINI 30GR VANILIE

cz0581
Livrare imediată!

11,18Lei

VARTEJ CARP ZOOM ROLLING FEEDER COMPETITION Nr 7 TEFLONAT

VARTEJ CARP ZOOM ROLLING FEEDER COMPETITION Nr 7 TEFLONAT

cz8533
Livrare 48-72 ore

9,53Lei

SWINGER CARP ZOOM S1 LUMINO VERDE

SWINGER CARP ZOOM S1 LUMINO VERDE

cz3520
Livrare 48-72 ore

71,06Lei

CUTIE ACCESORII CARP ZOOM 13.3x7.2x2.9cm

CUTIE ACCESORII CARP ZOOM 13.3x7.2x2.9cm

cz4245
Livrare imediată!

11,17Lei

STOPER BOILIE L TRANSPARENT CARP ZOOM

STOPER BOILIE L TRANSPARENT CARP ZOOM

cz1670
Livrare imediată!

11,07Lei

MONTURA BOILIE CARP ZOOM CLASSIC NR.6 15LB 20CM

MONTURA BOILIE CARP ZOOM CLASSIC NR.6 15LB 20CM

cz0933
Livrare 48-72 ore

21,24Lei

CARLIGE CARP ZOOM SLIM KILLER nr.10

CARLIGE CARP ZOOM SLIM KILLER nr.10

cz4930
Livrare imediată!

4,46Lei

Apicale Vergi Carp Zoom Line Connector, 2mm, 10buc/plic

Apicale Vergi Carp Zoom Line Connector, 2mm, 10buc/plic

cz2414
Livrare imediată!

26,41Lei

PLUMB CARP ZOOM FANATIC HEAVY INLINE 140GR

PLUMB CARP ZOOM FANATIC HEAVY INLINE 140GR

cz1398
Livrare 48-72 ore

18,17Lei

Porumb Artificial Carp Zoom CZ ART-X Corn, Strawberry, 6-8-10mm, 24buc

Porumb Artificial Carp Zoom CZ ART-X Corn, Strawberry, 6-8-10mm, 24buc

cz3459
Livrare 48-72 ore

22,25Lei

BRANTURI BOCANCI CARP ZOOM 41

BRANTURI BOCANCI CARP ZOOM 41

cz4665
Livrare 48-72 ore

9,53Lei

BUZZ BAR CARP ZOOM EASY ALU 2 LANSETE 30CM

BUZZ BAR CARP ZOOM EASY ALU 2 LANSETE 30CM

cz1215
Livrare imediată!

36,59Lei

Protectie Carp Zoom Pentru Carlige, 20buc/plic

Protectie Carp Zoom Pentru Carlige, 20buc/plic

cz2469
Livrare 48-72 ore

14,12Lei

Afişare 1641 - 1660 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: 99.921 ms [By time] [By id] [By file]
1 (0.156)
SELECT data
FROM `oc_session`
WHERE session_id = '83ee2b8157e4295c7dcf32d351'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Carp-Zoom'
/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 = '75' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (38.006)
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 (61.377)
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 1640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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