Cormoran


CUTIT CORMORAN PENTRU FILETAT MODEL 005 L=16CM

CUTIT CORMORAN PENTRU FILETAT MODEL 005 L=16CM

h.c.82.13005
Livrare imediată!

27,70Lei

SET 4 AVERTIZOARE CORMORAN ELECTRONIC PRO CARP F4000 -19%

SET 4 AVERTIZOARE CORMORAN ELECTRONIC PRO CARP F4000

a.11.80452
Livrare 24-48 ore

768,96Lei(-19%) 626,51Lei

Vobler Cormoran Cor F16 Yellow Pellet, 2.7cm, 2.5g, 1buc/pac

Vobler Cormoran Cor F16 Yellow Pellet, 2.7cm, 2.5g, 1buc/pac

f3.53.04441
Livrare imediată!

27,07Lei

VARTEJ CORMORAN NR.6 / 37KG / 6BUC/PLIC

VARTEJ CORMORAN NR.6 / 37KG / 6BUC/PLIC

a7.80.07006
Livrare imediată!

5,32Lei

RUCSAC CORMORAN VERDE 2039 35X55X20CM -21%

RUCSAC CORMORAN VERDE 2039 35X55X20CM

a8.65.03039
Livrare imediată!

180,21Lei(-21%) 142,24Lei

VARF CORMORAN PT.FEEDER SHORT TRACK RED 3,05OZ Model 2 -18%

VARF CORMORAN PT.FEEDER SHORT TRACK RED 3,05OZ Model 2

c.25.2170300r
Livrare 24-48 ore

47,55Lei(-18%) 39,03Lei

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow, 42cm

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow, 42cm

a6.63.10007
Livrare imediată!

14,96Lei

Opritoare Cormoran Silicon Verde pentru Pluta M-L

Opritoare Cormoran Silicon Verde pentru Pluta M-L

a.49.09102
Livrare imediată!

12,71Lei

Lingura Rotativa Cormoran Bullet Nr.1/3g Culoare Silver -17%

Lingura Rotativa Cormoran Bullet Nr.1/3g Culoare Silver

f.50.84001
Livrare imediată!

9,30Lei(-17%) 7,74Lei

Mulineta Cormoran Seacor Pilk 5PIF 4000 -18%

Mulineta Cormoran Seacor Pilk 5PIF 4000

c.14.55400
Livrare 24-48 ore

188,48Lei(-18%) 154,31Lei

ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL -12%

ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL

a.49.53125
Livrare imediată!

5,63Lei(-12%) 4,94Lei

MONTURA CORMORAN CLASIC BOILIE RIG COVER ST NR.6/2BUC -21%

MONTURA CORMORAN CLASIC BOILIE RIG COVER ST NR.6/2BUC

a.11.02322.6
Livrare imediată!

16,19Lei(-21%) 12,77Lei

STRUNA CORMORAN TITANIUM 20CM/8KG 2BUC/PL

STRUNA CORMORAN TITANIUM 20CM/8KG 2BUC/PL

a7.75.84308
Livrare imediată!

18,44Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 016MM/11,4KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 016MM/11,4KG/135M

c.32.8013516
Livrare 24-48 ore

33,08Lei

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/30-100G

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/30-100G

c.24.0100365
Livrare imediată!

170,86Lei

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 13 -33%

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 13

f.50.88513
Livrare 24-48 ore

16,14Lei(-33%) 10,84Lei

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

a6.11.09060
Livrare imediată!

48,09Lei

CIORAPI NEOPREN CORMORAN MARIME 45-47

CIORAPI NEOPREN CORMORAN MARIME 45-47

a8.94.25003
Livrare 24-48 ore

98,19Lei

STARLITA CORMORAN GALBENA 4,5X37MM 2BUC/PL

STARLITA CORMORAN GALBENA 4,5X37MM 2BUC/PL

a.49.08005
Livrare imediată!

2,67Lei

VOBLER CORMORAN COR F1 3,5CM/2G WATERMELON SEED

VOBLER CORMORAN COR F1 3,5CM/2G WATERMELON SEED

f3.53.04354
Livrare imediată!

26,37Lei

Afişare 161 - 180 din 251 (13 pagini)
Queries: 7, Total time: 68.430 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '3f09012b265719ac534de9c1f7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.119)
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 (33.165)
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 (34.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 = '0' AND p.manufacturer_id = '12' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.106)
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