Carp Zoom

Carp Zoom

Sortare după:

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 2.5kg, 0.20mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 2.5kg, 0.20mm, 800m

cz2582

Livrare 48-72 ore

28,00Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 2.5kg, 0.20mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 2.5kg, 0.20mm, 800m

cz2544

Livrare 48-72 ore

28,00Lei

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

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

cz2612

Livrare 48-72 ore

34,00Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 3.2kg, 0.23mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 3.2kg, 0.23mm, 800m

cz2551

Livrare 48-72 ore

30,00Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 4kg, 0.26mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 4kg, 0.26mm, 800m

cz2605

Livrare 48-72 ore

32,00Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4kg, 0.26mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4kg, 0.26mm, 800m

cz2568

Livrare 48-72 ore

32,00Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 3.2kg, 0.23mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Fluo Orange, 3.2kg, 0.23mm, 800m

cz2599

Livrare 48-72 ore

30,00Lei

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

34,00Lei

Fir Textil Carp Zoom Serious 8x Green, 28.41kg, 0.33mm, 120m

Fir Textil Carp Zoom Serious 8x Green, 28.41kg, 0.33mm, 120m

cz0458

Livrare 48-72 ore

93,00Lei

Boilies, Carp, Zoom, Critic, Echilibrat, Wafters, Solubile,, Pineapple, NBC,, 18mm,, 100g, CZ3305, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Carp Zoom, Critic Carp Zoom, Echilibrate Carp Zoom, Wafters Carp Zoom, Carp Zoom

Boilies, Carp, Zoom, Critic, Echilibrat, Wafters, Solubile,, Pineapple, NBC,, 18mm,, 100g, CZ3305, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Carp Zoom, Critic Carp Zoom, Echilibrate Carp Zoom, Wafters Carp Zoom, Carp Zoom

cz3305

Livrare 48-72 ore

27,00Lei

Carlige, Legate, Carp, Zoom, Power, Feeder, Barbless,, 10cm,, Nr.10,, 0.18mm,, 5buc/plic, CZ1776, Carlige Legate Feeder, Carlige Legate Feeder Carp Zoom, Carlige Carp Zoom, Legate Carp Zoom, Feeder Carp Zoom, Carp Zoom

Carlige, Legate, Carp, Zoom, Power, Feeder, Barbless,, 10cm,, Nr.10,, 0.18mm,, 5buc/plic, CZ1776, Carlige Legate Feeder, Carlige Legate Feeder Carp Zoom, Carlige Carp Zoom, Legate Carp Zoom, Feeder Carp Zoom, Carp Zoom

cz1776

Livrare 48-72 ore

13,99Lei

Lanseta, Carp, Zoom, Osmium, No, Limit, Feeder,, 100-300g,, 3.60m,, 3+3seg, CZ3060, Lansete Feeder, Lansete Feeder Carp Zoom, Lansete Carp Zoom, Feeder Carp Zoom, Carp Zoom

Lanseta, Carp, Zoom, Osmium, No, Limit, Feeder,, 100-300g,, 3.60m,, 3+3seg, CZ3060, Lansete Feeder, Lansete Feeder Carp Zoom, Lansete Carp Zoom, Feeder Carp Zoom, Carp Zoom

cz3060

Livrare 48-72 ore

385,00Lei

Set Suport Lansete Carp Zoom Wall Rod Holder, 20.7x17.2x2.4cm

Set Suport Lansete Carp Zoom Wall Rod Holder, 20.7x17.2x2.4cm

cz1912

Livrare imediată!

59,00Lei

Carp Zoom PELETE TURBO 2 IN 1 3mm 500gr Chocolate-Orange

Carp Zoom PELETE TURBO 2 IN 1 3mm 500gr Chocolate-Orange

cz4822

Livrare 48-72 ore

18,00Lei

Carp Zoom VIERMI ARTIFICIALE ART-X BALANCE 6gr

Carp Zoom VIERMI ARTIFICIALE ART-X BALANCE 6gr

cz3856

Livrare imediată!

15,50Lei

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

15,00Lei

JUVELNIC CARPZOOM BASIC-N 40x120cm

JUVELNIC CARPZOOM BASIC-N 40x120cm

cz5676

Livrare imediată!

26,00Lei

SET STRUNA CARPZOOM FLUOROCARBON PREDATOR-Z 12kg 15 20 25cm

SET STRUNA CARPZOOM FLUOROCARBON PREDATOR-Z 12kg 15 20 25cm

cz5331

Livrare imediată!

36,00Lei

POP UP CARP ZOOM MINI FANATI-X 10mm 25gr Vanilla

POP UP CARP ZOOM MINI FANATI-X 10mm 25gr Vanilla

cz8936

Livrare 48-72 ore

16,00Lei

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.35mm 15.1kg Fluo Yellow

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.35mm 15.1kg Fluo Yellow

cz7786

Livrare 48-72 ore

60,00Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 1905 (96 pagini)

Queries: 9, Total time: 101.726 ms [By time] [By id] [By file]

1 (0.128)

SELECT data
FROM `oc_session`
WHERE session_id = '8ccbcb4894f51447eff9d3566a'

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

2 (0.114)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

4 (0.145)

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

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

5 (0.136)

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

6 (38.880)

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:1661

7 (61.983)

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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20

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

8 (0.116)

SELECT *
FROM oc_platforma_promovari

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

9 (0.117)

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

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