Carp Zoom

Carp Zoom

Sortare după:

Carp Zoom DIP BOILIE 80ml Spice Mix

Carp Zoom DIP BOILIE 80ml Spice Mix

cz4396

Livrare imediată!

15,66Lei

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Porumb Dulce & Capsuna

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Porumb Dulce & Capsuna

cz6925

Livrare 48-72 ore

17,70Lei

ADITIV CARP ZOOM SUPERB BRITISH BREAD CRUMBS FLOATING 250gr Orange

ADITIV CARP ZOOM SUPERB BRITISH BREAD CRUMBS FLOATING 250gr Orange

cz8677

Livrare 48-72 ore

13,63Lei

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice

cz9377

Livrare 48-72 ore

43,67Lei

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.28mm 10.3kg Fluo Green

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.28mm 10.3kg Fluo Green

cz7809

Livrare imediată!

52,76Lei

Fir Textil Carp Zoom Catfish 8X, Fluo Green, 61kg, 0.60mm, 300m

Fir Textil Carp Zoom Catfish 8X, Fluo Green, 61kg, 0.60mm, 300m

cz2179

Livrare 48-72 ore

85,29Lei

Wafters Carp Zoom Duo Dumbel, Lemon-Biscuit, 10-14mm, 15g

Wafters Carp Zoom Duo Dumbel, Lemon-Biscuit, 10-14mm, 15g

cz3220

Livrare 48-72 ore

17,19Lei

Wafters Carp Zoom Dumbel, Paprika-Bread, 8-12mm, 15g

Wafters Carp Zoom Dumbel, Paprika-Bread, 8-12mm, 15g

cz3497

Livrare 48-72 ore

20,25Lei

Inel Dublu CARP ZOOM Catzoom Heavy Duty Double Ring, Size M, 300kg, 6buc/pac

Inel Dublu CARP ZOOM Catzoom Heavy Duty Double Ring, Size M, 300kg, 6buc/pac

cz5071

Livrare 48-72 ore

17,17Lei

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

cz5164

Livrare imediată!

13,63Lei

Carp Zoom PELETE SOFT 12mm 30gr Chocolate

Carp Zoom PELETE SOFT 12mm 30gr Chocolate

cz3924

Livrare 48-72 ore

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

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Porumb Dulce & Capsuna

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Porumb Dulce & Capsuna

cz6697

Livrare 48-72 ore

17,19Lei

JUVELNIC CARPZOOM BASIC-N 40x150cm

JUVELNIC CARPZOOM BASIC-N 40x150cm

cz5683

Livrare imediată!

30,49Lei

BORSETA CARP ZOOM ACCESORII CU TOP TRANSPARENT 27X16X9CM

BORSETA CARP ZOOM ACCESORII CU TOP TRANSPARENT 27X16X9CM

cz7908

Livrare 48-72 ore

89,36Lei

Spinnertail Predator Z Metal Viber Red Head 3.4cm 20g

Spinnertail Predator Z Metal Viber Red Head 3.4cm 20g

cz8219

Livrare 48-72 ore

38,51Lei

Montura Carp Zoom Ronnie Rig Nr.6, 3buc/pac

Montura Carp Zoom Ronnie Rig Nr.6, 3buc/pac

cz0335

Livrare imediată!

23,37Lei

Fir Textil Carp Zoom Serious 8x Green, 23.75kg, 0.30mm, 120m

Fir Textil Carp Zoom Serious 8x Green, 23.75kg, 0.30mm, 120m

cz0441

Livrare 48-72 ore

96,49Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4.7kg, 0.28mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4.7kg, 0.28mm, 800m

cz2575

Livrare 48-72 ore

36,49Lei

Wafter CARP ZOOM Superb, Grass Carp, 15mm, 50g

Wafter CARP ZOOM Superb, Grass Carp, 15mm, 50g

cz4556

Livrare imediată!

23,00Lei(-21%) 18,22Lei

Fir Monofilament CARP ZOOM Pitbull High UV Carp, Grey, 1000m, 0.29mm, 10.83kg

Fir Monofilament CARP ZOOM Pitbull High UV Carp, Grey, 1000m, 0.29mm, 10.83kg

cz4944

Livrare 48-72 ore

45,64Lei

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

1 (0.119)

SELECT data
FROM `oc_session`
WHERE session_id = '40ad58c2e7e328e29f682fe10f'

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

2 (0.140)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.133)

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

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

4 (0.167)

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

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

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

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

7 (0.151)

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