Cormoran


Lingura, oscilanta, Cormoran, Toro, UL6, 2.8cm, 1.8g, Fabre, 30, , f.50.88630, Lingurite Pastrav, Lingurite Pastrav Cormoran, Cormoran -20%
BOCANCI CORMORAN ASTRO-THERMO 46/47

BOCANCI CORMORAN ASTRO-THERMO 46/47

a8.91.77647
Livrare 24-48 ore

279,90Lei

Cleste Sertizor Cormoran pentru Monturi Rapitor 15cm

Cleste Sertizor Cormoran pentru Monturi Rapitor 15cm

a.84.12013
Livrare imediată!

42,44Lei

MANUSI CORMORAN NEOPREN MARIME XL

MANUSI CORMORAN NEOPREN MARIME XL

a8.94.10004
Livrare 24-48 ore

91,46Lei

VOBLER, CORMORAN, ME-RA, ROACH, 11CM, 18G, MOTOR, OIL, ROACH, f3.53.59311, Voblere Sinking, Voblere Sinking Cormoran, Cormoran
STRUNA CORMORAN TITANIUM 20CM/8KG 2BUC/PL

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

a7.75.84308
Livrare imediată!

17,15Lei

LANSETA, CORMORAN, SPINNING, 2BUC.BLACK, MASTER, SPIN, 1,80M/5-25G, c.27.2025180, Lansete Rapitori, Lansete Rapitori Cormoran, Cormoran
Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

c.32.8013518
Livrare imediată!

35,14Lei

SILICON SLEEVES CORMORAN PRO CARP 3MM/2,5CM 20BUC/PL.

SILICON SLEEVES CORMORAN PRO CARP 3MM/2,5CM 20BUC/PL.

a.11.00313
Livrare 24-48 ore

9,72Lei

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

c.24.0120365
Livrare imediată!

175,35Lei

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

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

f.50.84011
Livrare imediată!

9,31Lei

SHAD CORMORAN CRAZY FIN 10CM Golden Seed 6G 2BUC/PLIC

SHAD CORMORAN CRAZY FIN 10CM Golden Seed 6G 2BUC/PLIC

f1.51.870410
Livrare 24-48 ore

8,87Lei

Juvelnic, Cormoran, Eco, 1.50m, a2.j62.60150, Juvelnice, Juvelnice Cormoran, Cormoran

Juvelnic, Cormoran, Eco, 1.50m, a2.j62.60150, Juvelnice, Juvelnice Cormoran, Cormoran

a2.j62.60150
Livrare imediată!

43,20Lei

LANSETA, SPINNING, CORMORAN, RAYCOR, X, 2.05M,, 3-10G,, 2SEG, c.27.8001020, Lansete Rapitori, Lansete Rapitori Cormoran, Lansete Cormoran, Rapitori Cormoran, Cormoran -23%
Lingura, oscilanta, Cormoran, Toro, UL4, 2.5cm, 1.6g, Farbe, 35, , f.50.88435, Lingurite Pastrav, Lingurite Pastrav Cormoran, Cormoran -20%
LANSETA CORMORAN POWER CREEK 2.70M 10-40G 2SEG -10%

LANSETA CORMORAN POWER CREEK 2.70M 10-40G 2SEG

c.27.8540270
Livrare 24-48 ore

189,57Lei(-10%) 170,61Lei

Vobler, Cormoran, Cor, SLS2, Pale, Ayu,, 3.5cm,, 2.0g,, 1buc/pac, f3.53.04463, Voblere Sinking, Voblere Sinking Cormoran, Cormoran
VARTEJ CORMORAN NR.6 / 37KG / 6BUC/PLIC

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

a7.80.07006
Livrare imediată!

4,25Lei

OPRITOR CORMORAN STICLA ROSU BILA DIV.MARIMI

OPRITOR CORMORAN STICLA ROSU BILA DIV.MARIMI

a.49.09300
Livrare imediată!

11,52Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 023MM/13,5KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 023MM/13,5KG/135M

c.32.013523
Livrare imediată!

33,18Lei

Afişare 81 - 100 din 508 (26 pagini)
Queries: 7, Total time: 70.692 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = 'e5798150dd0f401ef1d426251f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
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 (31.622)
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:1667
6 (38.586)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.109)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38