Cormoran


CUTIT CORMORAN PENTRU FILETAT MODEL 003 L=20CM -17%

CUTIT CORMORAN PENTRU FILETAT MODEL 003 L=20CM

h.c.82.13003
Livrare 24-48 ore

33,96Lei(-17%) 28,17Lei

LANSETA SPINNING CORMORAN RAYCOR X 1.95M 1-6G 2SEG

LANSETA SPINNING CORMORAN RAYCOR X 1.95M 1-6G 2SEG

c.27.8000619
Livrare 24-48 ore

260,98Lei

CLOPOTEL CORMORAN SIMPLU CU CLESTE

CLOPOTEL CORMORAN SIMPLU CU CLESTE

a.49.80006
Livrare imediată!

2,86Lei

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME XL

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME XL

a.49.02014
Livrare imediată!

3,40Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 025MM/14,3KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 025MM/14,3KG/135M

c.32.013525
Livrare 24-48 ore

21,95Lei

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ă!

16,98Lei

AVERTIZOR ELECTRONIC CORMORAN PRO CARP X3000 -18%

AVERTIZOR ELECTRONIC CORMORAN PRO CARP X3000

a.11.80350
Livrare imediată!

89,31Lei(-18%) 73,65Lei

Prindere Plumb Cormoran Helicopter Culisant 5buc/plic -56%

Prindere Plumb Cormoran Helicopter Culisant 5buc/plic

a.11.00219
Livrare 24-48 ore

27,53Lei(-56%) 12,20Lei

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

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

f.50.860406
Stoc epuizat

9,69Lei(-19%) 7,82Lei

Lanseta Cormoran GF Feeder Pro MH 3.90m, 40-120g, 3+3SEG -18%

Lanseta Cormoran GF Feeder Pro MH 3.90m, 40-120g, 3+3SEG

c.25.2120397
Livrare imediată!

308,88Lei(-18%) 252,25Lei

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 11 -33%

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 11

f.50.88611
Livrare 24-48 ore

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

Varnis Silicon CORMORAN pentru Pluta, Verde, 5 Compartimente

Varnis Silicon CORMORAN pentru Pluta, Verde, 5 Compartimente

a.49.09010
Livrare 24-48 ore

14,98Lei

SALOPETA CORMORAN NEOPREN MAR.40/41 -10%

SALOPETA CORMORAN NEOPREN MAR.40/41

a8.94.03041
Livrare 24-48 ore

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

VARGA CORMORAN TELE EUROCOR 5,00M

VARGA CORMORAN TELE EUROCOR 5,00M

c.26.00501
Livrare imediată!

74,55Lei

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ -18%

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ

c.25.2150r
Livrare 24-48 ore

43,78Lei(-18%) 36,02Lei

Momitor Cormoran Feeder Lestat 55MM D41MM 60G -53%

Momitor Cormoran Feeder Lestat 55MM D41MM 60G

a.49.63060
Livrare 24-48 ore

16,64Lei(-53%) 7,77Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 035MM/37,5KG/300M

Fir Cormoran Textil CoraStrong 8Braid, Green, 035MM/37,5KG/300M

c.32.8030035
Livrare imediată!

65,17Lei

Lanseta Cormoran Corman GTS Zander Lure 2.40M 10-50g 2SEG -29%

Lanseta Cormoran Corman GTS Zander Lure 2.40M 10-50g 2SEG

c.27.9050241
Livrare 24-48 ore

318,35Lei(-29%) 227,60Lei

VARF CORMORAN SPORTLINE FEEDER YELLOW M

VARF CORMORAN SPORTLINE FEEDER YELLOW M

c.24.9105y
Livrare imediată!

19,99Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 14 -33%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 14

f.50.88414
Livrare 24-48 ore

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

Afişare 61 - 80 din 279 (14 pagini)
Queries: 7, Total time: 73.796 ms [By time] [By id] [By file]
1 (0.171)
SELECT data
FROM `oc_session`
WHERE session_id = '3c0279b76cfed0a83d80c6e2e0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.151)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.146)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.105)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.222)
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 = '3' AND p.manufacturer_id = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (37.881)
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 = '3' AND p.manufacturer_id = '12' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37