Manns


Grub Twister Manns CTG CGB 30buc 2.5cm

Grub Twister Manns CTG CGB 30buc 2.5cm

88001121
Livrare imediată!

12,18Lei

Twister Manns CTG 10cm culoare HY 10buc/plic

Twister Manns CTG 10cm culoare HY 10buc/plic

88001482
Livrare 24-48 ore

13,10Lei

Shad Mann s Q-Paddler 7g 10cm Rainbow Shad

Shad Mann s Q-Paddler 7g 10cm Rainbow Shad

801283281018
Livrare imediată!

3,29Lei

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 7.5cm culoare W 15buc/plic

Twister Manns CTG 7.5cm culoare W 15buc/plic

88001301
Livrare imediată!

13,10Lei

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

Shad Mann s Q-Paddler 7g 10cm Firetiger

3281009
Livrare imediată!

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

Shad Mann's Three-For-All Pearl-Chartreuse 10cm

Shad Mann's Three-For-All Pearl-Chartreuse 10cm

88030402
Livrare imediată!

44,72Lei

Shad Mann's Soft 6cm AS Pepper 5Buc

Shad Mann's Soft 6cm AS Pepper 5Buc

88010226
Livrare imediată!

12,18Lei

SHAD MANNS 4.5CM Culoare CMF 15BUC/PLIC

SHAD MANNS 4.5CM Culoare CMF 15BUC/PLIC

88010127
Livrare 24-48 ore

13,10Lei

TWISER MANNS MANNIPULATOR GRUB CULOARE P 10CM 8BUC/PLIC

TWISER MANNS MANNIPULATOR GRUB CULOARE P 10CM 8BUC/PLIC

88003405
Livrare 24-48 ore

13,10Lei

Shad Mann s Q-Paddler 8g 12cm Wakasagi

Shad Mann s Q-Paddler 8g 12cm Wakasagi

3281115
Livrare imediată!

9,93Lei

SHAD MANNS 12CM SHAD YFT 5D

SHAD MANNS 12CM SHAD YFT 5D

88015647
Livrare imediată!

12,18Lei

Twister Manns CTG 3cm culoare RB 30buc/plic

Twister Manns CTG 3cm culoare RB 30buc/plic

88001129
Livrare imediată!

12,18Lei

TWISTER MANNS TWINTAIL CULOARE WHITE 4CM 8BUC/PLIC

TWISTER MANNS TWINTAIL CULOARE WHITE 4CM 8BUC/PLIC

88002401
Livrare imediată!

14,12Lei

Shad Mann s Q-Paddler 8g 12cm Original Appleseed

Shad Mann s Q-Paddler 8g 12cm Original Appleseed

3281101
Livrare imediată!

9,93Lei

TWISTER MANNS 12CM CTG W 5 BUC PER PLIC

TWISTER MANNS 12CM CTG W 5 BUC PER PLIC

88001501
Livrare imediată!

13,10Lei

Shad Manns 12Cm culoare CHFT 5buc/plic

Shad Manns 12Cm culoare CHFT 5buc/plic

88015644
Livrare 24-48 ore

13,10Lei

Twister Manns CTG 10cm culoare CHYT 10buc/plic

Twister Manns CTG 10cm culoare CHYT 10buc/plic

88001441
Livrare 24-48 ore

13,10Lei

Shad Mann s Q-Paddler 7g 10cm Golden Shiner

Shad Mann s Q-Paddler 7g 10cm Golden Shiner

801283281006
Livrare imediată!

4,05Lei

Afişare 1 - 20 din 133 (7 pagini)
Queries: 7, Total time: 63.661 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '6af889c729f1b83fbade547836'
/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 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'manns.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (22.887)
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 = '41'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (40.077)
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 = '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.176)
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