Wizard

Wizard

Sortare după:

Carlige Somn Wizard Catfish Classic Pro, Nr.6/0, 2buc/plic

Carlige Somn Wizard Catfish Classic Pro, Nr.6/0, 2buc/plic

47894600

Livrare 24-48 ore

18,51Lei

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.20mm, 17.67kg, 150m

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.20mm, 17.67kg, 150m

30902020

Livrare 24-48 ore

63,94Lei

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.80mm, 48.9kg

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.80mm, 48.9kg

33300080

Livrare 24-48 ore

80,21Lei

Vobler Wizard Vertix Fat Pearl Glitter BB 9.5cm 100g

Vobler Wizard Vertix Fat Pearl Glitter BB 9.5cm 100g

82720001

Livrare 24-48 ore

38,28Lei

Fir Textil WIZARD Edge Pro 8x Braid, Violet, 0.20mm, 20.23kg, 150m

Fir Textil WIZARD Edge Pro 8x Braid, Violet, 0.20mm, 20.23kg, 150m

30903320

Livrare 24-48 ore

63,94Lei

Vobler WIZARD Lipless Vertix Blade, B Blue, 6cm, 16g

Vobler WIZARD Lipless Vertix Blade, B Blue, 6cm, 16g

82750203

Livrare 24-48 ore

22,25Lei

Shad WIZARD L&K Floating Shad, Culoare W, 8cm, 3buc/pac

Shad WIZARD L&K Floating Shad, Culoare W, 8cm, 3buc/pac

87178001

Livrare imediată!

11,68Lei

Fir Textil WIZARD 8X, Dark Grey, 135m, 0.18mm, 12.06kg

Fir Textil WIZARD 8X, Dark Grey, 135m, 0.18mm, 12.06kg

30909018

Livrare 24-48 ore

57,55Lei

ANCORE WIZARD GRIZZLY EC 774 NR 2 4X BRONZE

ANCORE WIZARD GRIZZLY EC 774 NR 2 4X BRONZE

49774802

Livrare imediată!

11,68Lei

Montura Wizard Dropshot Leader Heavy 20g - 0.25mm

Montura Wizard Dropshot Leader Heavy 20g - 0.25mm

79320020

Livrare 24-48 ore

10,56Lei

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.40mm, 19.6kg

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.40mm, 19.6kg

33300040

Livrare 24-48 ore

37,50Lei

Carlige Wizard Zander Classic Pro Perch Momeala Vie, Nr.4/0, 3buc/plic

Carlige Wizard Zander Classic Pro Perch Momeala Vie, Nr.4/0, 3buc/plic

46540400

Livrare imediată!

13,10Lei

Fir Textil WIZARD Edge Pro 8x Braid, Olive, 0.20mm, 20.23kg, 150m

Fir Textil WIZARD Edge Pro 8x Braid, Olive, 0.20mm, 20.23kg, 150m

30903220

Livrare 24-48 ore

63,94Lei

Shad WIZARD L&K Floating Shad, Culoare CHR, 6cm, 5buc/pac

Shad WIZARD L&K Floating Shad, Culoare CHR, 6cm, 5buc/pac

87176020

Livrare imediată!

14,12Lei

Fir Textil WIZARD 8X, Lime Green, 135m, 0.25mm, 21.42kg

Fir Textil WIZARD 8X, Lime Green, 135m, 0.25mm, 21.42kg

30909125

Livrare 24-48 ore

57,55Lei

Broasca Alba Wizard cu Pete Wiggly Spotted White Frog 5.5cm

Broasca Alba Wizard cu Pete Wiggly Spotted White Frog 5.5cm

82700504

Livrare 24-48 ore

26,32Lei

Oscilanta Ultra Light Wizard Mini Slice Galben L 4g

Oscilanta Ultra Light Wizard Mini Slice Galben L 4g

84304101

Livrare 24-48 ore

7,01Lei

SHAD WIZARD MINNOW-X 001 5CM 2BUC/PLIC

SHAD WIZARD MINNOW-X 001 5CM 2BUC/PLIC

86963010

Livrare 24-48 ore

16,15Lei

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.40mm, 37.78kg, 150m

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.40mm, 37.78kg, 150m

30902340

Livrare 24-48 ore

80,21Lei

Fir Fluorocarbon EnergoTeam Wizard Fluorocarbon Transparent 20m 0.50mm 22.35kg

Fir Fluorocarbon EnergoTeam Wizard Fluorocarbon Transparent 20m 0.50mm 22.35kg

33750050

Livrare 24-48 ore

25,30Lei

Afişare 301 - 320 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: 148.401 ms [By time] [By id] [By file]

1 (0.170)

SELECT data
FROM `oc_session`
WHERE session_id = 'f1c51c85281032cc2d7826fcf3'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.147)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.144)

SELECT *
FROM oc_url_alias
WHERE keyword = 'wizard.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.140)

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 (75.226)

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 (72.401)

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 300,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.173)

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