Wizard


Plumb Cheburashka Strong Wizard 10g

Plumb Cheburashka Strong Wizard 10g

59307010
Livrare imediată!

8,52Lei

Cantar Digital Wizard

Cantar Digital Wizard

80213126
Livrare 24-48 ore

92,41Lei

Carlige Energo Team Wizard Cheburashka Jig Nr.1/0, 6buc/pac

Carlige Energo Team Wizard Cheburashka Jig Nr.1/0, 6buc/pac

46536100
Livrare 24-48 ore

13,10Lei

Lanseta Wizard Fine Spinning Rod UL, 1.5-5g, 1.85m, 2seg

Lanseta Wizard Fine Spinning Rod UL, 1.5-5g, 1.85m, 2seg

12147185
Livrare 24-48 ore

122,92Lei

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

Carlige Somn Wizard Catfish Allround Nr.5/0, 3buc/pac

Carlige Somn Wizard Catfish Allround Nr.5/0, 3buc/pac

47892500
Livrare 24-48 ore

13,10Lei

Carlige Wizard Catfish Worm Pro, Nr.2/0, 3 buc/plic

Carlige Wizard Catfish Worm Pro, Nr.2/0, 3 buc/plic

47897200
Livrare 24-48 ore

18,51Lei

Afişare 1 - 20 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: 78.066 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '39d5bd41c89ba8faf19a593de9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.069)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'wizard.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
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 (30.917)
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 (46.613)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.184)
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