Cralusso


Carlige Cralusso Carp Power TF 12buc 2470 nr 6

Carlige Cralusso Carp Power TF 12buc 2470 nr 6

46610006
Livrare 24-48 ore

12,08Lei

Carlige Crap Cralusso Teflonat Chinu Ochet Nr.10 14buc/plic

Carlige Crap Cralusso Teflonat Chinu Ochet Nr.10 14buc/plic

46607010
Livrare 24-48 ore

13,10Lei

VARTEJ TRIPLU CRALUSSO 12BUC/PLIC NR.14

VARTEJ TRIPLU CRALUSSO 12BUC/PLIC NR.14

82161114
Livrare imediată!

23,27Lei

Pluta Cralusso 4 gr surf

Pluta Cralusso 4 gr surf

61912004
Livrare 24-48 ore

41,58Lei

Pop-Up CRALUSSO Cloudy Mini 8mm 20g Capsuni

Pop-Up CRALUSSO Cloudy Mini 8mm 20g Capsuni

98040605
Livrare 24-48 ore

20,25Lei

Fir Monofilament Cralusso Feeder pentru Forfac 0.12mm 50m

Fir Monofilament Cralusso Feeder pentru Forfac 0.12mm 50m

33901312
Livrare imediată!

23,27Lei

Carlige Cralusso CHIKA Nr 18

Carlige Cralusso CHIKA Nr 18

46601018
Livrare 24-48 ore

10,56Lei

Pluta Cralusso Torpedo Tuning 6g

Pluta Cralusso Torpedo Tuning 6g

61907006
Livrare 24-48 ore

34,45Lei

PLUTA CRALUSSO CONTROL MATCH 8GR

PLUTA CRALUSSO CONTROL MATCH 8GR

61977080
Livrare imediată!

21,24Lei

FIR TEXTIL CRALUSSO FAST SINKING 18LB 10M

FIR TEXTIL CRALUSSO FAST SINKING 18LB 10M

33909318
Livrare 24-48 ore

37,50Lei

Varteje Cralusso Triple lungi 7 (12buc) 2114

Varteje Cralusso Triple lungi 7 (12buc) 2114

82161207
Livrare imediată!

20,22Lei

Carlige Cralusso Sode Light 14buc 2401 nr 8

Carlige Cralusso Sode Light 14buc 2401 nr 8

46600008
Livrare imediată!

10,56Lei

Fir Monofilament Cralusso Fluo Line Galben Fluorescent 150m 0.25mm 8.60kg

Fir Monofilament Cralusso Fluo Line Galben Fluorescent 150m 0.25mm 8.60kg

33906025
Livrare imediată!

29,48Lei

STOPPER BOILIES SILICON CRALUSSO NATUR 2027

STOPPER BOILIES SILICON CRALUSSO NATUR 2027

79014960
Livrare imediată!

7,10Lei

Fir Cralusso General Prestige 0,22mm 150m

Fir Cralusso General Prestige 0,22mm 150m

33900022
Livrare imediată!

30,49Lei

Vartej Rapid Cralusso Nr.10 12buc 2119

Vartej Rapid Cralusso Nr.10 12buc 2119

82161710
Livrare 24-48 ore

17,17Lei

Carlige Cralusso Sode Light Nr 12

Carlige Cralusso Sode Light Nr 12

46600012
Livrare imediată!

10,56Lei

Pluta Cralusso CAPRI FIBER GLASS 3.00g

Pluta Cralusso CAPRI FIBER GLASS 3.00g

60919030
Livrare imediată!

12,08Lei

Plute Cralusso Shark 5gr

Plute Cralusso Shark 5gr

61940005
Livrare imediată!

32,42Lei

VARTEJE CRALUSSO AURII NR.7 12BUC/PLIC

VARTEJE CRALUSSO AURII NR.7 12BUC/PLIC

82075107
Livrare 24-48 ore

8,52Lei

Afişare 281 - 300 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: 65.464 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = '5acd1a2d05317a39005c96f01b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.137)
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 (28.123)
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 (36.681)
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 280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.141)
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