Carp Zoom

Carp Zoom

Sortare după:

CUTIE CARP ZOOM PENTRU ACCESORII CRAP 3 COMPARTIMENTE 10x7x2cm

CUTIE CARP ZOOM PENTRU ACCESORII CRAP 3 COMPARTIMENTE 10x7x2cm

cz7243

Livrare imediată!

9,53Lei

SHRINK TUB CARP ZOOM VERDE 2.4/2.6MM 5Cm

SHRINK TUB CARP ZOOM VERDE 2.4/2.6MM 5Cm

cz2141

Livrare imediată!

8,02Lei

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

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

cz8523

Livrare 48-72 ore

31,40Lei

CARLIGE CARP ZOOM CARP CLASSIC BARBLESS nr.2

CARLIGE CARP ZOOM CARP CLASSIC BARBLESS nr.2

cz4718

Livrare imediată!

9,53Lei

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 60GR

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 60GR

cz1251

Livrare imediată!

11,57Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.25mm, 8.8kg

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.25mm, 8.8kg

cz3483

Livrare 48-72 ore

50,72Lei

CARLIGE CARP ZOOM PREDATOR Z WORM nr.3/0

CARLIGE CARP ZOOM PREDATOR Z WORM nr.3/0

cz5296

Livrare imediată!

17,68Lei

Surub Momeala Carp Zoom 2 Side Pop Up Pegs, 10buc/plic

Surub Momeala Carp Zoom 2 Side Pop Up Pegs, 10buc/plic

cz2520

Livrare 48-72 ore

15,65Lei

VOBLER CARP ZOOM PREDATOR -Z ASP SHAD 10cm 11.0gr FLOATING 0849

VOBLER CARP ZOOM PREDATOR -Z ASP SHAD 10cm 11.0gr FLOATING 0849

cz0849

Livrare imediată!

12,00Lei(-14%) 10,31Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.22mm 6.35kg Verde

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.22mm 6.35kg Verde

cz2069

Livrare 48-72 ore

22,25Lei

Agrafa cu Vartej si Margea Culisanta CARP ZOOM Feeder Bead Swivel, Marime L, 5buc/pac

Agrafa cu Vartej si Margea Culisanta CARP ZOOM Feeder Bead Swivel, Marime L, 5buc/pac

cz6153

Livrare imediată!

11,68Lei

Minciog Carp Zoom Beta N 2 Sec. 50x50x180cm

Minciog Carp Zoom Beta N 2 Sec. 50x50x180cm

cz0054

Livrare 48-72 ore

92,41Lei

Combo Lanseta + Mulineta + Accesorii CARP ZOOM Kid 1.60m

Combo Lanseta + Mulineta + Accesorii CARP ZOOM Kid 1.60m

cz3954

Livrare 48-72 ore

63,94Lei

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 20gr

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 20gr

cz9563

Livrare imediată!

9,53Lei

PLUMB PICATURA CARP ZOOM CU VARTEJ 80gr

PLUMB PICATURA CARP ZOOM CU VARTEJ 80gr

cz9709

Livrare 48-72 ore

16,15Lei

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

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

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

cz2690

Livrare imediată!

9,64Lei

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

MINCIOG CARP ZOOM PREDATOR-Z OPLUS TELE 40x50/134cm

MINCIOG CARP ZOOM PREDATOR-Z OPLUS TELE 40x50/134cm

cz3864

Livrare imediată!

167,00Lei(-20%) 134,10Lei

CARP ZOOM COCTAIL COLOUR FEEDER COMPETITION METHOD 75ml Garlic

CARP ZOOM COCTAIL COLOUR FEEDER COMPETITION METHOD 75ml Garlic

cz5646

Livrare imediată!

21,50Lei(-11%) 19,23Lei

Afişare 1001 - 1020 din 1746 (88 pagini)

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

1 (0.154)

SELECT data
FROM `oc_session`
WHERE session_id = 'a56a0eca2cf15668fb523996f9'

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

2 (0.089)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.112)

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

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

5 (45.762)

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

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

6 (62.041)

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 = '2' 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.147)

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

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