Carp Zoom

Carp Zoom

Sortare după:

Saci PVA 100X125 Carp Zoom 10Buc/plic

Saci PVA 100X125 Carp Zoom 10Buc/plic

cz8900

Livrare imediată!

12,18Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.28mm 9.4kg Fluo Green

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.28mm 9.4kg Fluo Green

cz6512

Livrare 48-72 ore

20,22Lei

PELETE GAURITE CARP ZOOM BLACK HALIBUT 8MM 120GR

PELETE GAURITE CARP ZOOM BLACK HALIBUT 8MM 120GR

cz9363

Livrare imediată!

17,19Lei

BAC NADA CARP ZOOM AVIX PLIABIL 31x25cm

BAC NADA CARP ZOOM AVIX PLIABIL 31x25cm

cz6215

Livrare 48-72 ore

78,18Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION 250m 0.15MM 2.9KG

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION 250m 0.15MM 2.9KG

cz5327

Livrare imediată!

16,20Lei(-17%) 13,52Lei

BORSETA PLUMBI CARP ZOOM 24x16x7.5cm

BORSETA PLUMBI CARP ZOOM 24x16x7.5cm

cz3446

Livrare imediată!

78,27Lei

CAP MINCIOG CARP ZOOM BASIC 65x45cm

CAP MINCIOG CARP ZOOM BASIC 65x45cm

cz2968

Livrare imediată!

57,00Lei(-20%) 45,64Lei

LOOP TYER CARP ZOOM

LOOP TYER CARP ZOOM

cz4221

Livrare imediată!

26,41Lei

Set Marker Carp Zoom Sondare Marshal Origo 80g

Set Marker Carp Zoom Sondare Marshal Origo 80g

cz7748

Livrare 48-72 ore

78,18Lei

CARLIGE CARP ZOOM D-RIG nr. 2

CARLIGE CARP ZOOM D-RIG nr. 2

cz7801

Livrare 48-72 ore

11,70Lei(-23%) 9,03Lei

CICADA CARP ZOOM PREDATOR Z BLADE SHAKER 5cm 13.5gr A03

CICADA CARP ZOOM PREDATOR Z BLADE SHAKER 5cm 13.5gr A03

cz8547

Livrare 48-72 ore

31,40Lei

Carlige Carp Zoom Amur-Grass Carp, Nr.2/0, 10buc/pac

Carlige Carp Zoom Amur-Grass Carp, Nr.2/0, 10buc/pac

cz4756

Livrare imediată!

8,00Lei(-12%) 7,01Lei

Aroma Lichida Carp Zoom Favourite Pellet Plus, Porumb Dulce, 200ml

Aroma Lichida Carp Zoom Favourite Pellet Plus, Porumb Dulce, 200ml

cz0717

Livrare imediată!

20,35Lei

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 120GR

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 120GR

cz1282

Livrare imediată!

16,15Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.35mm, 15.45kg

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.35mm, 15.45kg

cz2981

Livrare imediată!

52,76Lei

Momitor Inline Carp Zoom Method Feeder FC Exact-X, 40g

Momitor Inline Carp Zoom Method Feeder FC Exact-X, 40g

cz2193

Livrare imediată!

14,73Lei

CARLIGE CARP ZOOM PREDATOR Z WORM nr.2

CARLIGE CARP ZOOM PREDATOR Z WORM nr.2

cz5333

Livrare imediată!

14,12Lei

VOBLER CARP ZOOM PREDATOR -Z CHUB 4.5cm 3.4gr FLOATING 1075

VOBLER CARP ZOOM PREDATOR -Z CHUB 4.5cm 3.4gr FLOATING 1075

cz1075

Livrare imediată!

12,00Lei(-10%) 10,76Lei

Minciog Aluminiu Carp Zoom Big Catch-n Cauciucat, 75x65x110/103cm

Minciog Aluminiu Carp Zoom Big Catch-n Cauciucat, 75x65x110/103cm

cz3008

Livrare 48-72 ore

179,85Lei

FIR MONOFILAMENT CARP ZOOM PREDATOR Z OPLUS CATFISH 100m 0.80mm 46.2kg

FIR MONOFILAMENT CARP ZOOM PREDATOR Z OPLUS CATFISH 100m 0.80mm 46.2kg

cz2199

Livrare imediată!

31,00Lei(-18%) 25,30Lei

Afişare 601 - 620 din 1748 (88 pagini)

Queries: 7, Total time: 122.549 ms [By time] [By id] [By file]

1 (0.105)

SELECT data
FROM `oc_session`
WHERE session_id = '49be300b222c84c082fd2f5b2c'

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

2 (0.091)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.127)

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

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

4 (0.121)

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

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

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

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

7 (0.195)

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