Carp Zoom

Carp Zoom

Sortare după:

SWINGER CARP ZOOM 2 in 1 S5 LUMINO ROSU

SWINGER CARP ZOOM 2 in 1 S5 LUMINO ROSU

cz1086

Livrare imediată!

36,49Lei

MOMITOR CARP ZOOM STRIAT CU TIJA 20gr

MOMITOR CARP ZOOM STRIAT CU TIJA 20gr

cz9884

Livrare imediată!

10,06Lei

Pelete CARP ZOOM Premium Select Super Atract Pellets 4.5mm, 800g

Pelete CARP ZOOM Premium Select Super Atract Pellets 4.5mm, 800g

cz5538

Livrare 48-72 ore

32,47Lei

Lanseta Carp Zoom Predator Z Oplus Twitch Cast 2.05m 7-28g

Lanseta Carp Zoom Predator Z Oplus Twitch Cast 2.05m 7-28g

cz0559

Livrare 48-72 ore

286,62Lei

Vartej Rapid cu Anou CARP ZOOM Quick Change Spinner Swivel with Micro Ring, Nr.7, 10buc/pac

Vartej Rapid cu Anou CARP ZOOM Quick Change Spinner Swivel with Micro Ring, Nr.7, 10buc/pac

cz4692

Livrare 48-72 ore

17,17Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 517 nr.16 10/plic

CARLIGE CARP ZOOM FEEDER COMPETITION 517 nr.16 10/plic

cz2751

Livrare imediată!

9,64Lei

Avertizor Carp Zoom PFX

Avertizor Carp Zoom PFX

cz3666

Livrare imediată!

82,00Lei(-28%) 58,96Lei

CARP ZOOM CATFISH MEGA PELLET 30mm 340gr Liver - Blood

CARP ZOOM CATFISH MEGA PELLET 30mm 340gr Liver - Blood

cz5066

Livrare 48-72 ore

31,55Lei

Mulineta Carp Zoom Multifish Junior 3000RD

Mulineta Carp Zoom Multifish Junior 3000RD

cz3093

Livrare imediată!

78,18Lei

PLUTA CARP ZOOM PIKE PREDATOR Z 4 18gr

PLUTA CARP ZOOM PIKE PREDATOR Z 4 18gr

cz3857

Livrare imediată!

9,03Lei

PELETE CARP ZOOM SOFT 8mm 30gr Mussel

PELETE CARP ZOOM SOFT 8mm 30gr Mussel

cz9002

Livrare imediată!

12,50Lei(-13%) 10,88Lei

MULINETA CARP ZOOM TEMPO 5000 BBC BaitRunner

MULINETA CARP ZOOM TEMPO 5000 BBC BaitRunner

cz9828

Livrare imediată!

200,00Lei(-18%) 163,69Lei

CARLIGE CARP ZOOM FEEDER COMPETITION KO.3 CARP METHOD nr 12

CARLIGE CARP ZOOM FEEDER COMPETITION KO.3 CARP METHOD nr 12

cz0152

Livrare imediată!

11,50Lei(-13%) 10,06Lei

SUPORT CARP ZOOM SCREW 50-90cm

SUPORT CARP ZOOM SCREW 50-90cm

cz8067

Livrare imediată!

47,77Lei

CARLIGE CARP ZOOM MARSHAL ORIGO CLASSIC BOILIE nr 4 Barbless

CARLIGE CARP ZOOM MARSHAL ORIGO CLASSIC BOILIE nr 4 Barbless

cz0565

Livrare 48-72 ore

13,61Lei

VARTEJ CARP ZOOM DIAMOND EYE CU AGRAFA nr.6

VARTEJ CARP ZOOM DIAMOND EYE CU AGRAFA nr.6

cz0848

Livrare 48-72 ore

9,53Lei

SHAD CARP ZOOM PREDATOR-Z OPLUS KILLER 10cm CZ7954

SHAD CARP ZOOM PREDATOR-Z OPLUS KILLER 10cm CZ7954

cz7954

Livrare 48-72 ore

21,01Lei(-20%) 16,86Lei

Spin de Momeala Carp Zoom cu Inel de Silicon M 10buc/plic 0.6x10mm

Spin de Momeala Carp Zoom cu Inel de Silicon M 10buc/plic 0.6x10mm

cz9156

Livrare imediată!

12,18Lei

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea L

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea L

cz9583

Livrare 48-72 ore

19,20Lei

MINCIOG Carp Zoom CRAP VIP BOILIE 106x106x100 180cm

MINCIOG Carp Zoom CRAP VIP BOILIE 106x106x100 180cm

cz2934

Livrare 48-72 ore

362,00Lei(-23%) 278,49Lei

Afişare 1001 - 1020 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.127 ms [By time] [By id] [By file]

1 (0.219)

SELECT data
FROM `oc_session`
WHERE session_id = '5cac147185fc4d67246e898caa'

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

2 (0.083)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.102)

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

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

4 (0.092)

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.073)

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

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

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

7 (0.150)

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