Cormoran


LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G -30%

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G

c.27.8003524
Livrare 24-48 ore

214,03Lei(-30%) 149,82Lei

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

162,19Lei

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

a.55.65012
Livrare imediată!

6,71Lei

SALOPETA CORMORAN NEOPREN XL MAR.42/43

SALOPETA CORMORAN NEOPREN XL MAR.42/43

a8.94.03243.xl
Livrare 24-48 ore

692,39Lei

Lanseta Cormoran Seacor Pilk Power 2.70m, 10-200g, 2seg

Lanseta Cormoran Seacor Pilk Power 2.70m, 10-200g, 2seg

c.29.852027
Livrare imediată!

238,94Lei

LANTERNA CAP CORMORAN COR 1

LANTERNA CAP CORMORAN COR 1

a8.85.45201
Livrare imediată!

60,43Lei

LANSETA CORMORAN 3SEG PLUS 2VARFURI BULL FIGHTER E-HEAVY FEEDER 3.90M 50-150G -20%

LANSETA CORMORAN 3SEG PLUS 2VARFURI BULL FIGHTER E-HEAVY FEEDER 3.90M 50-150G

c.25.9150397
Livrare imediată!

282,11Lei(-20%) 225,70Lei

Lingurita Rotativa Cormoran Spinner Single UL2 Chartreuse & Black, 2.8g, Carlig Nr.2/0

Lingurita Rotativa Cormoran Spinner Single UL2 Chartreuse & Black, 2.8g, Carlig Nr.2/0

a.50.87220
Livrare imediată!

23,31Lei

Cap Cormoran Suport Lanseta Longnose Feeder

Cap Cormoran Suport Lanseta Longnose Feeder

a6.63.67001
Livrare imediată!

10,75Lei

Mulineta Cormoran Veycor BR 4PIF 4000

Mulineta Cormoran Veycor BR 4PIF 4000

c.19.46400
Livrare imediată!

178,39Lei

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 30 -40%

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 30

f.50.88630
Livrare 24-48 ore

16,14Lei(-40%) 9,67Lei

SALOPETA CORMORAN NEOPREN MAR.44/45

SALOPETA CORMORAN NEOPREN MAR.44/45

a8.94.03445
Livrare 24-48 ore

692,39Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 016MM/8,5KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 016MM/8,5KG/135M

c.32.013516
Livrare 24-48 ore

20,96Lei

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2

c.25.2180390g
Livrare 24-48 ore

51,31Lei

SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

a.49.67050
Livrare imediată!

25,59Lei

Vartej Cormoran Corlock NR.4/30KG/6BUC/PL

Vartej Cormoran Corlock NR.4/30KG/6BUC/PL

a7.80.70004
Livrare imediată!

7,20Lei

Lingura Rotativa Cormoran Bullet Nr.3/7g Culoare Gold -40%

Lingura Rotativa Cormoran Bullet Nr.3/7g Culoare Gold

f.50.84013
Livrare imediată!

10,75Lei(-40%) 6,44Lei

Mulineta Cormoran i-COR 2000 -10%

Mulineta Cormoran i-COR 2000

c.12.25200
Livrare imediată!

126,71Lei(-10%) 114,04Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35 -40%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35

f.50.88435
Livrare 24-48 ore

16,14Lei(-40%) 9,67Lei

Vobler Cormoran Cor SLS2 Black Head, 3.5cm, 2.0g, 1buc/pac

Vobler Cormoran Cor SLS2 Black Head, 3.5cm, 2.0g, 1buc/pac

f3.53.04461
Livrare 24-48 ore

26,63Lei

Afişare 21 - 40 din 305 (16 pagini)
Queries: 7, Total time: 102.205 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '3cb00740f9efd7e41877b9a282'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
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 = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.988)
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 = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (59.711)
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 = '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.111)
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