Cormoran


LANSETA CORMORAN 3SEG PLUS 3VARFURI SPORTLINE FEEDER 3.60M 50-150G 3+3seg

LANSETA CORMORAN 3SEG PLUS 3VARFURI SPORTLINE FEEDER 3.60M 50-150G 3+3seg

c.24.0150365
Livrare 24-48 ore

165,92Lei

Lanseta CORMORAN 2BUC BC V SHORT RANGE 2.80M, 100-400G -18%

Lanseta CORMORAN 2BUC BC V SHORT RANGE 2.80M, 100-400G

c.20.1400285
Livrare imediată!

312,26Lei(-18%) 255,02Lei

Lanseta Spinning Cormoran TopFish 2.10m, 50-100g, 2seg -34%

Lanseta Spinning Cormoran TopFish 2.10m, 50-100g, 2seg

c.26.1010210
Livrare imediată!

149,57Lei(-34%) 98,51Lei

SALOPETA CORMORAN NEOPREN MAR.42/43 -10%

SALOPETA CORMORAN NEOPREN MAR.42/43

a8.94.03243
Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 014MM/7,4KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 014MM/7,4KG/135M

c.32.013514
Livrare 24-48 ore

21,95Lei

CORMORAN MONTURA HIGH ABRASION BOILIE RIG T4 NR.2/2BUC

CORMORAN MONTURA HIGH ABRASION BOILIE RIG T4 NR.2/2BUC

a.11.02302.2
Livrare 24-48 ore

16,98Lei

SUPORT FATA CORMORAN FLEXI PT FEEDER 28CM -26%

SUPORT FATA CORMORAN FLEXI PT FEEDER 28CM

a6.63.80104
Livrare 24-48 ore

34,90Lei(-26%) 25,85Lei

Kit Cormoran Pro Carp Tub and Leadcore Mud -58%

Kit Cormoran Pro Carp Tub and Leadcore Mud

a.11.00416
Livrare 24-48 ore

58,72Lei(-58%) 24,89Lei

CUTIT CORMORAN PENTRU FILETAT MODEL 002 L=10CM

CUTIT CORMORAN PENTRU FILETAT MODEL 002 L=10CM

h.c.82.13002
Livrare imediată!

30,65Lei

LANSETA SPINNING CORMORAN RAYCOR X 2.05M, 3-10G, 2SEG

LANSETA SPINNING CORMORAN RAYCOR X 2.05M, 3-10G, 2SEG

c.27.8001020
Livrare 24-48 ore

269,25Lei

Mulineta Cormoran I-Cor 2500 2Pif -8%

Mulineta Cormoran I-Cor 2500 2Pif

c.12.25250
Livrare imediată!

133,52Lei(-8%) 123,19Lei

AGRAFA+VARTEJ CORMORAN NR.8 / 30KG / 7BUC/PLIC

AGRAFA+VARTEJ CORMORAN NR.8 / 30KG / 7BUC/PLIC

a7.80.00008
Livrare imediată!

7,25Lei

HUSA CORMORAN 5082 PT.LANSETE L=125CM

HUSA CORMORAN 5082 PT.LANSETE L=125CM

a8.65.09220
Livrare imediată!

149,87Lei

MULINETA CORMORAN I-COR 2000 2PIF

MULINETA CORMORAN I-COR 2000 2PIF

c.16.21200
Livrare imediată!

96,75Lei

SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

a.49.67050
Livrare imediată!

27,01Lei

VOBLER CORMORAN COR F2 CARP 3.5CM 2.5G

VOBLER CORMORAN COR F2 CARP 3.5CM 2.5G

f3.53.04361
Livrare imediată!

32,98Lei

Vobler Cormoran Cor F14 Crank Culoare Chocolate 4.5cm 7.1g

Vobler Cormoran Cor F14 Crank Culoare Chocolate 4.5cm 7.1g

f3.53.04421
Livrare 24-48 ore

24,97Lei

Lanseta Cormoran GF Feeder Pro H 3.60m, 50-150g, 3+3SEG -18%

Lanseta Cormoran GF Feeder Pro H 3.60m, 50-150g, 3+3SEG

c.25.2150367
Livrare imediată!

366,25Lei(-18%) 298,92Lei

Set linguri oscilante Cormoran Toro UL Trout Spoon Set 2 -38%

Set linguri oscilante Cormoran Toro UL Trout Spoon Set 2

f.50.88902
Livrare 24-48 ore

109,07Lei(-38%) 67,54Lei

ANTI TANGLE CORMORAN 12CM FLEXIBIL PT.FEEDER 2BUC/PLIC

ANTI TANGLE CORMORAN 12CM FLEXIBIL PT.FEEDER 2BUC/PLIC

a.49.52013
Livrare imediată!

6,88Lei

Afişare 21 - 40 din 251 (13 pagini)
Queries: 7, Total time: 73.631 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '8791b13ed4317b7b0162582b70'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.127)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '12' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (37.406)
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 = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (35.433)
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 = '12' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.260)
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