Cralusso


Carlige Cralusso Sode Light Nr 12

Carlige Cralusso Sode Light Nr 12

46600012
Livrare imediată!

8,00Lei

Pluta, Cralusso, CAPRI, FIBER, GLASS, 1.00g, 60919010, Plute Stationar, Plute Stationar Cralusso, Cralusso
Pluta CRALUSSO ARROW WAGGLER 12g

Pluta CRALUSSO ARROW WAGGLER 12g

61921012
Livrare imediată!

40,00Lei

Pluta Cralusso Port Starlet 1206 1.5gr

Pluta Cralusso Port Starlet 1206 1.5gr

62016015
Livrare imediată!

8,00Lei

Carlige Cralusso Chinu Bronz Nr.10 14Buc/Plic

Carlige Cralusso Chinu Bronz Nr.10 14Buc/Plic

46608010
Livrare imediată!

8,00Lei

Varteje Cralusso Triple lungi 14 (12buc) 2114

Varteje Cralusso Triple lungi 14 (12buc) 2114

82161214
Livrare 24-48 ore

13,99Lei

CARLIGE TEFLONATE CRALUSSO CHINU Nr.8 12buc/plic

CARLIGE TEFLONATE CRALUSSO CHINU Nr.8 12buc/plic

46607008
Livrare 24-48 ore

10,00Lei

Fir, Textil, Cralusso, Feeder&Carp, 10m, 15lbs, 33909215, Fire Monturi Crap, Fire Monturi Crap Cralusso, Cralusso
INEL CRALUSSO SILICON PENTRU PELETE MARIME M 18BUC

INEL CRALUSSO SILICON PENTRU PELETE MARIME M 18BUC

79014120
Livrare 24-48 ore

6,50Lei

VARTEJ, TRIPLU, CRALUSSO, NR, 12, /, 12BUC, PER, PLIC, 82161112, Agrafe si Vartejuri Stationar, Agrafe si Vartejuri Stationar Cralusso, Cralusso
Tub Antinod Cralusso fluo 85mm 3buc 3101

Tub Antinod Cralusso fluo 85mm 3buc 3101

82075808
Livrare 24-48 ore

8,00Lei

Fir, Cralusso, Match, Sinking, Prestige, 0.20mm, 150m, 33903020, Fire Match (Scufundatoare), Fire Match (Scufundatoare) Cralusso, Cralusso
Carlige Cralusso Chinu Bronz Nr 12

Carlige Cralusso Chinu Bronz Nr 12

46608012
Livrare imediată!

8,00Lei

Pluta Cralusso Torpedo 0.50g

Pluta Cralusso Torpedo 0.50g

61910050
Livrare 24-48 ore

22,00Lei

PLUTA, CRALUSSO, CONTROL, MATCH, DART, 8GR, 61979080, Plute Stationar, Plute Stationar Cralusso, Cralusso
FIR TEXTIL CRALUSSO FAST SINKING 18LB 10M

FIR TEXTIL CRALUSSO FAST SINKING 18LB 10M

33909318
Livrare 24-48 ore

35,00Lei

VARTEJE CRALUSSO ROLLING, Nr.12 8buc/plic

VARTEJE CRALUSSO ROLLING, Nr.12 8buc/plic

82075122
Livrare imediată!

6,50Lei

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.20mm, 150m

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.20mm, 150m

33905120
Livrare imediată!

24,00Lei

Fir Inaintas Cralusso Monofilament Brutal 50m 0.18mm 4.77kg

Fir Inaintas Cralusso Monofilament Brutal 50m 0.18mm 4.77kg

33902180
Livrare 24-48 ore

20,80Lei

Cosulete Cralusso Feeder Nadire Masiva Aero XXL 20g 2buc

Cosulete Cralusso Feeder Nadire Masiva Aero XXL 20g 2buc

58271220
Livrare imediată!

12,99Lei

Afişare 101 - 120 din 376 (19 pagini)
Queries: 9, Total time: 68.987 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = '6d47df38dd73a3e90c73baae4a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.144)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.136)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.134)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '187' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (28.661)
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 = '187'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (39.423)
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 = '0' AND p.manufacturer_id = '187' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.111)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38