Carp Zoom

Carp Zoom

Sortare după:

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

SET STRUNA CARPZOOM OTEL 1x7 PREDATOR-Z 14kg 15 20 25cm

SET STRUNA CARPZOOM OTEL 1x7 PREDATOR-Z 14kg 15 20 25cm

cz5324

Livrare 48-72 ore

31,00Lei

BOILIES CARP ZOOM PREMIUM NATURAL CLASSIC 18mm 120gr Spice Essence

BOILIES CARP ZOOM PREMIUM NATURAL CLASSIC 18mm 120gr Spice Essence

cz9292

Livrare 48-72 ore

20,00Lei

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

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

cz9377

Livrare 48-72 ore

40,00Lei

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.31mm 12.2kg Fluo Yellow

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.31mm 12.2kg Fluo Yellow

cz7779

Livrare 48-72 ore

52,00Lei

Spinnertail Predator Z Metal Viber Black Blue 3.4cm 20g

Spinnertail Predator Z Metal Viber Black Blue 3.4cm 20g

cz8226

Livrare 48-72 ore

36,00Lei

Fir Textil Carp Zoom Serious 8x Green, 40.23kg, 0.41mm, 120m

Fir Textil Carp Zoom Serious 8x Green, 40.23kg, 0.41mm, 120m

cz0465

Livrare 48-72 ore

97,00Lei

Boilies Carp Zoom Critic Echilibrat Wafters Solubile, Spicy Sausage, 18mm, 100g

Boilies Carp Zoom Critic Echilibrat Wafters Solubile, Spicy Sausage, 18mm, 100g

cz3299

Livrare 48-72 ore

27,00Lei

Carlige, Legate, Carp, Zoom, Power, Feeder, Barbless,, 10cm,, Nr.12,, 0.18mm,, 5buc/plic, CZ1783, 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.12,, 0.18mm,, 5buc/plic, CZ1783, Carlige Legate Feeder, Carlige Legate Feeder Carp Zoom, Carlige Carp Zoom, Legate Carp Zoom, Feeder Carp Zoom, Carp Zoom

cz1783

Livrare 48-72 ore

13,99Lei

Lanseta, Carp, Zoom, Osmium, No, Limit, Feeder,, 100-350g,, 3.90m,, 3+3seg, CZ3053, Lansete Feeder, Lansete Feeder Carp Zoom, Lansete Carp Zoom, Feeder Carp Zoom, Carp Zoom

Lanseta, Carp, Zoom, Osmium, No, Limit, Feeder,, 100-350g,, 3.90m,, 3+3seg, CZ3053, Lansete Feeder, Lansete Feeder Carp Zoom, Lansete Carp Zoom, Feeder Carp Zoom, Carp Zoom

cz3053

Livrare 48-72 ore

399,00Lei

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Orange

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Orange

cz4013

Livrare 48-72 ore

11,00Lei

Carp Zoom PELETE SOFT 12mm 30gr NBC

Carp Zoom PELETE SOFT 12mm 30gr NBC

cz3948

Livrare imediată!

12,50Lei

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Chocolate-Orange

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Chocolate-Orange

cz6901

Livrare 48-72 ore

15,00Lei

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

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

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

1 (0.066)

SELECT data
FROM `oc_session`
WHERE session_id = '858c5097071fc21564ba7d0b2a'

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

2 (0.063)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.072)

SELECT `trigger`, `action`
FROM oc_event

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

4 (0.131)

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

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

5 (0.123)

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 = '3'

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

6 (36.949)

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

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

7 (66.151)

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 = '3' 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:432

8 (0.141)

SELECT *
FROM oc_platforma_promovari

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

9 (0.120)

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

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