Cralusso


Pluta Cralusso 6 gr bolo

Pluta Cralusso 6 gr bolo

61905006
Livrare imediată!

34,45Lei

Tub Antinod Cralusso fluo 55mm 3buc 3101

Tub Antinod Cralusso fluo 55mm 3buc 3101

82075805
Livrare imediată!

10,06Lei

Fir Cralusso Match Sinking Prestige 0.18mm 150m

Fir Cralusso Match Sinking Prestige 0.18mm 150m

33903018
Livrare imediată!

30,49Lei

Carlige Cralusso Chinu Bronz Nr 12

Carlige Cralusso Chinu Bronz Nr 12

46608012
Livrare imediată!

10,06Lei

Pluta CRALUSSO ARROW WAGGLER 8g

Pluta CRALUSSO ARROW WAGGLER 8g

61921008
Livrare imediată!

47,67Lei

Carlige Cralusso Koaji Round Nr. 8

Carlige Cralusso Koaji Round Nr. 8

46602008
Livrare imediată!

11,07Lei

Carlige Teflonate Cralusso Maruseigo Ochet Nr.10 11Buc/Plic

Carlige Teflonate Cralusso Maruseigo Ochet Nr.10 11Buc/Plic

46609010
Livrare imediată!

12,08Lei

PLUTA CRALUSSO CONTROL MATCH 6GR

PLUTA CRALUSSO CONTROL MATCH 6GR

61977060
Livrare 24-48 ore

21,24Lei

Pluta Cralusso UFO 18g

Pluta Cralusso UFO 18g

61920018
Livrare 24-48 ore

31,40Lei

VARTEJE CU AGRAFA CRALUSSO ROLLING NICE 2127 nr.3 (6buc)

VARTEJE CU AGRAFA CRALUSSO ROLLING NICE 2127 nr.3 (6buc)

82075430
Livrare 24-48 ore

14,12Lei

Pluta Cralusso Bubble 3Gr

Pluta Cralusso Bubble 3Gr

61906003
Livrare 24-48 ore

26,32Lei

Varteje Cralusso Aurii 3 10buc/plic 2110

Varteje Cralusso Aurii 3 10buc/plic 2110

82075103
Livrare 24-48 ore

8,52Lei

Fir Monofilament Cralusso Feeder pentru Forfac 0.22mm 50m

Fir Monofilament Cralusso Feeder pentru Forfac 0.22mm 50m

33901322
Livrare 24-48 ore

23,27Lei

Carlige Cralusso Umi Tango Nr 12

Carlige Cralusso Umi Tango Nr 12

46604012
Livrare 24-48 ore

10,06Lei

Pluta Cralusso Torpedo 1.5g

Pluta Cralusso Torpedo 1.5g

61910001
Livrare 24-48 ore

29,87Lei

PLUTA CRALUSSO PRO MATCH 6GR

PLUTA CRALUSSO PRO MATCH 6GR

61987060
Livrare 24-48 ore

22,25Lei

Carlige Cralusso Delta Chinu Nr.6 8Buc/Plic

Carlige Cralusso Delta Chinu Nr.6 8Buc/Plic

46606006
Livrare 24-48 ore

13,10Lei

AGRAFA CLIPS CRALUSSO CU VARTEJ Nr.10 12BUC/PLIC 2116

AGRAFA CLIPS CRALUSSO CU VARTEJ Nr.10 12BUC/PLIC 2116

82161410
Livrare imediată!

12,08Lei

Carlige Cralusso Anti Snag TF 8buc 2465 nr 8

Carlige Cralusso Anti Snag TF 8buc 2465 nr 8

46609408
Livrare 24-48 ore

13,10Lei

Carlige Cralusso Chika 16buc 2405 nr 15

Carlige Cralusso Chika 16buc 2405 nr 15

46601015
Livrare 24-48 ore

10,56Lei

Afişare 241 - 260 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: 100.211 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = '75d6e5797b98c74fc70ed4a981'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
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 (38.980)
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 (60.593)
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 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.164)
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