Cralusso


Fir inaintas Cralusso Prestige 0.123mm 50m

Fir inaintas Cralusso Prestige 0.123mm 50m

33901123
Livrare imediată!

22,35Lei

Fir Inaintas Cralusso Prestige 0.088mm 50m

Fir Inaintas Cralusso Prestige 0.088mm 50m

33901088
Livrare 24-48 ore

23,27Lei

Carlige Cralusso CHIKA Nr 12

Carlige Cralusso CHIKA Nr 12

46601012
Livrare imediată!

10,56Lei

Pluta Cralusso Bubble 6g

Pluta Cralusso Bubble 6g

61906006
Livrare 24-48 ore

25,30Lei

Stopper cauciuc Cralusso XL 9buc 2008

Stopper cauciuc Cralusso XL 9buc 2008

79014040
Livrare 24-48 ore

10,06Lei

Fir Monofilament CRALUSSO Prestige, Galben Fluo, 350m, 0.20mm, 5.5kg

Fir Monofilament CRALUSSO Prestige, Galben Fluo, 350m, 0.20mm, 5.5kg

33907020
Livrare imediată!

45,64Lei

Agrafa Culisanta CRALUSSO Match Alama, Marime M, 6buc/pac

Agrafa Culisanta CRALUSSO Match Alama, Marime M, 6buc/pac

79008304
Livrare imediată!

10,06Lei

Fir Fluorocarbon Cralusso 0.50mm 30+10m 20.24kg

Fir Fluorocarbon Cralusso 0.50mm 30+10m 20.24kg

33901550
Livrare 24-48 ore

86,31Lei

Momitor Cralusso Method Feeder Plat 40g 2buc

Momitor Cralusso Method Feeder Plat 40g 2buc

58271040
Livrare imediată!

18,17Lei

Vartej Rapid Cralusso Feeder Match Nr.14 4kg 6buc

Vartej Rapid Cralusso Feeder Match Nr.14 4kg 6buc

82075014
Livrare imediată!

18,17Lei

Cralusso Varteje Duble Nr.10 12buc/plic

Cralusso Varteje Duble Nr.10 12buc/plic

82161010
Livrare imediată!

20,22Lei

Vartej Rapid Cralusso Nr.6 12buc 2119

Vartej Rapid Cralusso Nr.6 12buc 2119

82161706
Livrare 24-48 ore

17,17Lei

FIR TEXTIL CRALUSSO XTREME 15M 0.12MM

FIR TEXTIL CRALUSSO XTREME 15M 0.12MM

33908012
Livrare imediată!

38,62Lei

Pluta Cralusso CAPRI FIBER GLASS 0.5g

Pluta Cralusso CAPRI FIBER GLASS 0.5g

60919005
Livrare imediată!

12,08Lei

Pluta Cralusso Culisanta Antena Interschimbabila Calibrata 8g

Pluta Cralusso Culisanta Antena Interschimbabila Calibrata 8g

61923008
Livrare imediată!

14,12Lei

PLUTA CRALUSSO CONTROL MATCH 3GR

PLUTA CRALUSSO CONTROL MATCH 3GR

61977030
Livrare 24-48 ore

21,24Lei

Carlige Teflonate Cralusso Carp Boilie Nr 6

Carlige Teflonate Cralusso Carp Boilie Nr 6

46609206
Livrare 24-48 ore

13,10Lei

PLUTE CRALUSSO DART 16GR

PLUTE CRALUSSO DART 16GR

61951016
Livrare imediată!

34,45Lei

Carlige Cralusso Carp Power TF 12buc 2470 nr 12

Carlige Cralusso Carp Power TF 12buc 2470 nr 12

46610012
Livrare imediată!

12,08Lei

Carlige Crap Teflonate Cralusso Gripper Carp nr.8 8buc

Carlige Crap Teflonate Cralusso Gripper Carp nr.8 8buc

46609108
Livrare 24-48 ore

13,10Lei

Afişare 321 - 340 din 350 (18 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 67.340 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '5acd1a2d05317a39005c96f01b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.189)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.155)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.164)
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
5 (29.368)
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:1699
6 (37.167)
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 = '187' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.195)
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