Fast Strike


Shad FAST STRIKE Takeda, Baby Perch, 8cm, 3.2g. 10buc/pac

Shad FAST STRIKE Takeda, Baby Perch, 8cm, 3.2g. 10buc/pac

749672946871
Livrare 48-72 ore

24,28Lei

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, Chatreuse Blue Back, 5buc/pac

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, Chatreuse Blue Back, 5buc/pac

4001420009327
Livrare 48-72 ore

22,16Lei

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Deep Fish, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Deep Fish, 10buc/pac

4002424209249
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Silver Red Head, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Silver Red Head, 1buc/pac

4003935244460
Livrare 48-72 ore

19,00Lei

Cicada FAST STRIKE Intruder Deep Vib, Limetreuse 003, 5.3cm, 14.9g

Cicada FAST STRIKE Intruder Deep Vib, Limetreuse 003, 5.3cm, 14.9g

749672946383
Livrare 48-72 ore

25,30Lei

Vobler Fast Striker Sinking Panicked Vibe, Baby Bass G, 5.5cm, 10g, 1buc/pac

Vobler Fast Striker Sinking Panicked Vibe, Baby Bass G, 5.5cm, 10g, 1buc/pac

5941944264552
Livrare 48-72 ore

25,30Lei

Shad FAST STRIKE Huky Kuky, Arborella Ghost, 7.5cm, 2.7g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Arborella Ghost, 7.5cm, 2.7g, 10buc/pac

749672946512
Livrare imediată!

28,35Lei

Shad FAST STRIKE Takeda, Chartreuse Pepper, 8cm, 3.2g. 10buc/pac

Shad FAST STRIKE Takeda, Chartreuse Pepper, 8cm, 3.2g. 10buc/pac

749672946741
Livrare 48-72 ore

24,28Lei

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, Pink Ice Pearl, 5buc/pac

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, Pink Ice Pearl, 5buc/pac

4001176203208
Livrare 48-72 ore

22,16Lei

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Neon Lime, 10buc/pac

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Neon Lime, 10buc/pac

4002218678510
Livrare 48-72 ore

26,32Lei

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Pearl Yellow Back, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Pearl Yellow Back, 1buc/pac

4003699036721
Livrare 48-72 ore

18,69Lei

Shad Fast Strike Roach, RWN Roach Wounded Natural, 8cm, 5g

Shad Fast Strike Roach, RWN Roach Wounded Natural, 8cm, 5g

5941944263777
Livrare imediată!

9,64Lei

Vobler Fast Strike Top Water, Baby Perch 003, 7.5cm, 17g, 1buc/pac

Vobler Fast Strike Top Water, Baby Perch 003, 7.5cm, 17g, 1buc/pac

749672946444
Livrare imediată!

36,49Lei

Shad FAST STRIKE Huky Kuky, Motor Oil, 11.5cm, 4.3g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Motor Oil, 11.5cm, 4.3g, 10buc/pac

749672946666
Livrare imediată!

30,49Lei

Shad FAST STRIKE Bionic Soft Pike-Zander 10cm, 6g, White Lightening, 5buc/pac

Shad FAST STRIKE Bionic Soft Pike-Zander 10cm, 6g, White Lightening, 5buc/pac

4000360671854
Livrare 48-72 ore

30,40Lei

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Ice Chartreuse, 10buc/pac

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Ice Chartreuse, 10buc/pac

4001761428511
Livrare 48-72 ore

26,32Lei

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Pearl Back Red Pepper, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Pearl Back Red Pepper, 10buc/pac

4002740009257
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 4cm, 7.5g, Fire Tiger, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 4cm, 7.5g, Fire Tiger, 1buc/pac

4003559461847
Livrare 48-72 ore

15,03Lei

Cicada FAST STRIKE Cyborgstone Vibe 6cm, 22g, Silver Red Head, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 6cm, 22g, Silver Red Head, 1buc/pac

4004438839672
Livrare 48-72 ore

21,74Lei

Shad Fast Strike Roach, RGR Roach Gold Red, 8cm, 5g

Shad Fast Strike Roach, RGR Roach Gold Red, 8cm, 5g

5941944263708
Livrare imediată!

9,64Lei

Afişare 1 - 20 din 273 (14 pagini)
Queries: 7, Total time: 64.260 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = 'a579de1126c94f1c2cd7596c91'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fast-strike.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '745' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.449)
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 = '745'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (33.299)
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 = '745' 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.144)
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