Manns


Grub Twister Manns CTG CGB 30buc 2.5cm

Grub Twister Manns CTG CGB 30buc 2.5cm

88001121
Livrare imediată!

12,18Lei

Twister Manns Mannipulator Grub 4cm Chartreuse Silver Glitter 8Buc

Twister Manns Mannipulator Grub 4cm Chartreuse Silver Glitter 8Buc

88003428
Livrare imediată!

10,66Lei

Shad Manns 12Cm culoare BFT 5buc/plic

Shad Manns 12Cm culoare BFT 5buc/plic

88015643
Livrare imediată!

14,12Lei

Twister Manns CTG 12.5cm culoare HY 5buc/plic

Twister Manns CTG 12.5cm culoare HY 5buc/plic

88001582
Livrare imediată!

13,10Lei

Shad Mann's Soft 10cm Chartreuse Silver Glitter 4 Buc

Shad Mann's Soft 10cm Chartreuse Silver Glitter 4 Buc

88010428
Livrare 24-48 ore

13,10Lei

SHAD MANNS 10CM Culoare P 4BUC/PLIC

SHAD MANNS 10CM Culoare P 4BUC/PLIC

88010405
Livrare imediată!

13,10Lei

Twister Manns CTG 10cm culoare FCH 10buc/plic

Twister Manns CTG 10cm culoare FCH 10buc/plic

88001403
Livrare 24-48 ore

13,10Lei

Shad Mann s Q-Paddler 7g 10cm Proper Baitfish -55%

Shad Mann s Q-Paddler 7g 10cm Proper Baitfish

3281007
Livrare imediată!

8,78Lei(-55%) 3,94Lei

Shad Mann's Three For All Silver Shiner, 10cm, 1buc/pac

Shad Mann's Three For All Silver Shiner, 10cm, 1buc/pac

88030403
Livrare imediată!

44,72Lei

Shad Manns 10 cm Alb W

Shad Manns 10 cm Alb W

88010401
Livrare imediată!

13,10Lei

Twister Manns CTG 5cm culoare CGMF 20buc/plic

Twister Manns CTG 5cm culoare CGMF 20buc/plic

88001222
Livrare imediată!

13,10Lei

Shad Manns Soft 8cm FluoYellow 5 buc

Shad Manns Soft 8cm FluoYellow 5 buc

88010383
Livrare imediată!

13,10Lei

Shad Mann s Q-Paddler 8g 12cm Red Shad

Shad Mann s Q-Paddler 8g 12cm Red Shad

3281121
Livrare imediată!

9,93Lei

SHAD Mann s 6cm Shad W 10buc/PLIC

SHAD Mann s 6cm Shad W 10buc/PLIC

88010201
Livrare imediată!

13,10Lei

Grub Manns Swimmin Grub 11cm Culoare Y 5buc/plic

Grub Manns Swimmin Grub 11cm Culoare Y 5buc/plic

88020404
Livrare imediată!

13,10Lei

TWISTER MANNS TWINTAIL CULOARE JR 4CM 8BUC/PLIC

TWISTER MANNS TWINTAIL CULOARE JR 4CM 8BUC/PLIC

88002499
Livrare imediată!

13,10Lei

Shad Mann s Q-Paddler 8g 12cm Golden Shiner

Shad Mann s Q-Paddler 8g 12cm Golden Shiner

3281106
Livrare imediată!

9,93Lei

Shad Mann's Soft 8cm Pearl Black Back 5 buc

Shad Mann's Soft 8cm Pearl Black Back 5 buc

88010362
Livrare imediată!

14,12Lei

SHAD MANNS 15CM Culoare W 2BUC/PLIC

SHAD MANNS 15CM Culoare W 2BUC/PLIC

88010601
Livrare 24-48 ore

13,10Lei

Twister Manns CTG 10cm culoare HY 10buc/plic

Twister Manns CTG 10cm culoare HY 10buc/plic

88001482
Livrare 24-48 ore

13,10Lei

Afişare 1 - 20 din 133 (7 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: 50.214 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = 'b3a41f442d5101b8e3ef61d598'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'manns.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.083)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '41' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (25.353)
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 = '3' AND p.manufacturer_id = '41'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (24.378)
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 = '3' AND p.manufacturer_id = '41' 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.125)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37