Wizard


Lanseta Wizard Perch Spinning Rod UL, 0.5-3g, 2.10m, 2seg

Lanseta Wizard Perch Spinning Rod UL, 0.5-3g, 2.10m, 2seg

13036212
Livrare 24-48 ore

200,19Lei

Mulineta Wizard XLR Spin Reel, 5+1, 2000

Mulineta Wizard XLR Spin Reel, 5+1, 2000

20631200
Livrare 24-48 ore

150,37Lei

Vobler WIZARD Chubby Crank, Culoare 005, 4cm, 4.3g

Vobler WIZARD Chubby Crank, Culoare 005, 4cm, 4.3g

82751105
Livrare 24-48 ore

32,42Lei

Vobler WIZARD Magnet Popper, Culoare 005, 5cm, 3.8g

Vobler WIZARD Magnet Popper, Culoare 005, 5cm, 3.8g

82751505
Livrare 24-48 ore

32,42Lei

Lingurita Oscilanta WIZARD Chubby Spoon Long UL, Culoare 010, 3.3cm, 4.6g

Lingurita Oscilanta WIZARD Chubby Spoon Long UL, Culoare 010, 3.3cm, 4.6g

84100210
Livrare 24-48 ore

21,24Lei

Foarfeca Fir Textil plus Cleste Inele Despicate Wizard 125mm

Foarfeca Fir Textil plus Cleste Inele Despicate Wizard 125mm

80899550
Livrare imediată!

22,25Lei

Carlige Energo Team Wizard Zander Live Bait Light Nr.6, 8buc/pac

Carlige Energo Team Wizard Zander Live Bait Light Nr.6, 8buc/pac

46530006
Livrare imediată!

11,98Lei

Lanseta Wizard Phanton Catfish, 200-500g, 2.40m, 2seg

Lanseta Wizard Phanton Catfish, 200-500g, 2.40m, 2seg

14176241
Livrare 24-48 ore

231,93Lei

Lanseta Wizard Active Skill Spinning Rod, 5-23g, 2.40m, 2seg

Lanseta Wizard Active Skill Spinning Rod, 5-23g, 2.40m, 2seg

13161240
Livrare 24-48 ore

129,02Lei

Lanseta Wizard Senso Feel Spinning Rod, 5-28g, 2.25m, 2seg

Lanseta Wizard Senso Feel Spinning Rod, 5-28g, 2.25m, 2seg

13225225
Livrare 24-48 ore

230,70Lei

Lanseta WIZARD Bokor Spin 2.312m, 10-30g, 2seg

Lanseta WIZARD Bokor Spin 2.312m, 10-30g, 2seg

13170233
Livrare 24-48 ore

235,78Lei

Vobler WIZARD Viper Bug Crank, Culoare 004, 3cm, 1.2g

Vobler WIZARD Viper Bug Crank, Culoare 004, 3cm, 1.2g

82751404
Livrare 24-48 ore

32,42Lei

Lingurita Oscilanta WIZARD Chubby Spoon Long UL, Culoare 001, 3.3cm, 4.6g

Lingurita Oscilanta WIZARD Chubby Spoon Long UL, Culoare 001, 3.3cm, 4.6g

84100201
Livrare 24-48 ore

21,24Lei

Forfac Montura Somn WIZARD Cu Zornaitoare, Nr.6/0+8/0 Specimen

Forfac Montura Somn WIZARD Cu Zornaitoare, Nr.6/0+8/0 Specimen

79327801
Livrare 24-48 ore

34,32Lei

ANCORE WIZARD GRIZZLY EC 774 NR4 4X BRONZE

ANCORE WIZARD GRIZZLY EC 774 NR4 4X BRONZE

49774804
Livrare imediată!

12,58Lei

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.90mm, 56.4kg

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.90mm, 56.4kg

33300090
Livrare 24-48 ore

80,21Lei

Vobler Wizard Vertix Fat Fluo Yellow BB 9.5cm 100g

Vobler Wizard Vertix Fat Fluo Yellow BB 9.5cm 100g

82720002
Livrare 24-48 ore

38,28Lei

Fir Textil Wizard Pink Braid 150m, 0.10mm, 6.95kg

Fir Textil Wizard Pink Braid 150m, 0.10mm, 6.95kg

30908010
Livrare 24-48 ore

57,84Lei

Fir Textil WIZARD Edge Pro 8x Braid, Violet, 0.23mm, 22.15kg, 150m

Fir Textil WIZARD Edge Pro 8x Braid, Violet, 0.23mm, 22.15kg, 150m

30903323
Livrare 24-48 ore

63,94Lei

Vobler WIZARD Lipless Vertix Blade, S Silver, 6cm, 16g

Vobler WIZARD Lipless Vertix Blade, S Silver, 6cm, 16g

82750204
Livrare 24-48 ore

22,25Lei

Afişare 221 - 240 din 433 (22 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: 200.711 ms [By time] [By id] [By file]
1 (0.182)
SELECT data
FROM `oc_session`
WHERE session_id = 'f1c51c85281032cc2d7826fcf3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (1.190)
SELECT *
FROM oc_url_alias
WHERE keyword = 'wizard.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.354)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '401' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (110.833)
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 = '401'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (87.864)
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 = '401' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 220,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