Cormoran


FIR METALIC CORMORAN PENTRU STRUNA 7X7 5MT 9KG -8%

FIR METALIC CORMORAN PENTRU STRUNA 7X7 5MT 9KG

a7.75.40090
Livrare imediată!

58,00Lei(-8%) 53,09Lei

VOBLER CORMORAN COR F1 3,5CM/2G CARP

VOBLER CORMORAN COR F1 3,5CM/2G CARP

f3.53.04352
Livrare 24-48 ore

30,55Lei

Starlite Cormoran, 37x4.5mm, 2buc/plic Albastru

Starlite Cormoran, 37x4.5mm, 2buc/plic Albastru

a.49.08007
Livrare 24-48 ore

1,83Lei

Lingura Rotativa Cormoran Bullet Nr.1/3g Culoare Silver Red Dots -40%

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

f.50.84051
Livrare imediată!

9,31Lei(-40%) 5,58Lei

Lanseta Cormoran GF Feeder Pro Short Track 3.00M 40-120g 2+2SEG

Lanseta Cormoran GF Feeder Pro Short Track 3.00M 40-120g 2+2SEG

c.25.2120307
Livrare imediată!

282,20Lei

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

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 13

f.50.88513
Livrare 24-48 ore

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

Vobler Cormoran Cor SLS2 Pale Ayu, 3.5cm, 2.0g, 1buc/pac

Vobler Cormoran Cor SLS2 Pale Ayu, 3.5cm, 2.0g, 1buc/pac

f3.53.04463
Livrare 24-48 ore

25,78Lei

ANTI TANGLE CORMORAN 5CM PT.FEEDER 3BUC/PLIC

ANTI TANGLE CORMORAN 5CM PT.FEEDER 3BUC/PLIC

a.49.53105
Livrare imediată!

5,37Lei

MONTURA CORMORAN CLASIC RIG T4 NR.6/2BUC -30%

MONTURA CORMORAN CLASIC RIG T4 NR.6/2BUC

a.11.02303.6
Livrare 24-48 ore

21,87Lei(-30%) 15,32Lei

FIR STRUNA CORMORAN 1X9 10M 9KG 40 BRIDE

FIR STRUNA CORMORAN 1X9 10M 9KG 40 BRIDE

a7.75.30090
Livrare imediată!

41,63Lei

LANSETA CORMORAN 3VARFURI 3SEG SPECILAND ULTRA FEEDER 3.90M 300G 3SEG

LANSETA CORMORAN 3VARFURI 3SEG SPECILAND ULTRA FEEDER 3.90M 300G 3SEG

c.25.5300399
Livrare imediată!

412,57Lei

Opritoare Cormoran Silicon Verde pentru Pluta M-L

Opritoare Cormoran Silicon Verde pentru Pluta M-L

a.49.09102
Livrare imediată!

11,52Lei

OSCILANTA CORMORAN CORA-Z 35MM/6G SILVER/GOLD -40%

OSCILANTA CORMORAN CORA-Z 35MM/6G SILVER/GOLD

f.50.860206
Livrare imediată!

9,69Lei(-40%) 5,81Lei

VARF CORMORAN SPORTLINE FEEDER YELLOW M

VARF CORMORAN SPORTLINE FEEDER YELLOW M

c.24.9105y
Livrare imediată!

18,99Lei

Lingura oscilanta Cormoran Toro 09 UL3 2.8cm 2.5g -40%

Lingura oscilanta Cormoran Toro 09 UL3 2.8cm 2.5g

f.50.88309
Livrare 24-48 ore

18,25Lei(-40%) 10,95Lei

Mulineta Cormoran I-Cor 2500 2Pif -10%

Mulineta Cormoran I-Cor 2500 2Pif

c.12.25250
Livrare imediată!

133,52Lei(-10%) 120,17Lei

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME XL

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME XL

a.49.02014
Livrare imediată!

2,36Lei

CIORAPI NEOPRENE CORMORAN MARIME 38-41 -20%

CIORAPI NEOPRENE CORMORAN MARIME 38-41

a8.94.25001
Livrare imediată!

105,18Lei(-20%) 84,14Lei

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

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

a.11.02302.6
Livrare imediată!

15,98Lei

UMBRELA CORMORAN PARASOLAR XXL D=3.0M

UMBRELA CORMORAN PARASOLAR XXL D=3.0M

a8.68.35300
Livrare imediată!

359,33Lei

Afişare 261 - 280 din 305 (16 pagini)
Queries: 7, Total time: 80.207 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '7caf1647732d37e5a124acf552'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.089)
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 (37.979)
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 (41.709)
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 260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.178)
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