Fast Strike


Shad Fast Strike Roach, RRT Roach Red Tail, 8cm, 5g

Shad Fast Strike Roach, RRT Roach Red Tail, 8cm, 5g

5941944263715
Livrare imediată!

10,87Lei

Vobler Fast Strike Top Water, Fire Tiger 011, 7.5cm, 17g, 1buc/pac

Vobler Fast Strike Top Water, Fire Tiger 011, 7.5cm, 17g, 1buc/pac

749672946482
Livrare 48-72 ore

36,49Lei

Shad FAST STRIKE Takeda, White Force, 8cm, 3.2g. 10buc/pac

Shad FAST STRIKE Takeda, White Force, 8cm, 3.2g. 10buc/pac

749672946727
Livrare 48-72 ore

24,28Lei

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, White Phanthom, 5buc/pac

Shad FAST STRIKE Huky Kuky 13.5cm, 8.4g, White Phanthom, 5buc/pac

4001083296362
Livrare 48-72 ore

22,16Lei

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

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

4001939847090
Livrare 48-72 ore

26,32Lei

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Deep Red Head Flash, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Deep Red Head Flash, 1buc/pac

4003668913336
Livrare 48-72 ore

18,69Lei

Vobler FAST STRIKE Kenshin Sinking Vib, 5.5cm, 18g, Ice Chartreuse, 1buc/pac

Vobler FAST STRIKE Kenshin Sinking Vib, 5.5cm, 18g, Ice Chartreuse, 1buc/pac

4003003981426
Livrare 48-72 ore

26,32Lei

Vobler FAST STRIKE Ilusion Slider, 9cm, 25g, Culoare YWR, 1buc/pac

Vobler FAST STRIKE Ilusion Slider, 9cm, 25g, Culoare YWR, 1buc/pac

4007207010500
Livrare 48-72 ore

35,90Lei

Shad FAST STRIKE Turbo Zander, 10cm, White Neon Back, 10buc/pac

Shad FAST STRIKE Turbo Zander, 10cm, White Neon Back, 10buc/pac

4007813686731
Livrare 48-72 ore

28,89Lei

Shad Fast Strike Perch, PNW Perch Natural White, 7cm, 3.5g, 1buc/pac

Shad Fast Strike Perch, PNW Perch Natural White, 7cm, 3.5g, 1buc/pac

5941944263876
Livrare imediată!

9,03Lei

Shad Fast Strike Bionic Soft Perch, Ayu, 5cm, 1g, 10buc/pac

Shad Fast Strike Bionic Soft Perch, Ayu, 5cm, 1g, 10buc/pac

5941944264316
Livrare 48-72 ore

26,32Lei

Shad FAST STRIKE Huky Kuky, Chartreuse White, 11.5cm, 4.3g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Chartreuse White, 11.5cm, 4.3g, 10buc/pac

749672946635
Livrare 48-72 ore

31,40Lei

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

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

4000260678250
Livrare 48-72 ore

30,40Lei

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Fire Tiger, 10buc/pac

Shad FAST STRIKE Baby Jocker 8cm, 3.2g, Fire Tiger, 10buc/pac

4001569226470
Livrare 48-72 ore

26,32Lei

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Pink Ice, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Pink Ice, 10buc/pac

4002683083154
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 6cm, 22g, Ice Chartreuse, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 6cm, 22g, Ice Chartreuse, 1buc/pac

4004354037404
Livrare 48-72 ore

21,74Lei

Shad FAST STRIKE Down Shad 9cm, Avocado, 10buc/pac

Shad FAST STRIKE Down Shad 9cm, Avocado, 10buc/pac

4004990184098
Livrare 48-72 ore

26,90Lei

Vobler FAST STRIKE Ilusion Slider, 9cm, 25g, Culoare PRB, 1buc/pac

Vobler FAST STRIKE Ilusion Slider, 9cm, 25g, Culoare PRB, 1buc/pac

4006906672989
Livrare 48-72 ore

35,90Lei

Shad FAST STRIKE Turbo Zander, 10cm, Ice Fire, 10buc/pac

Shad FAST STRIKE Turbo Zander, 10cm, Ice Fire, 10buc/pac

4007695534588
Livrare 48-72 ore

28,89Lei

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

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

749672946352
Livrare imediată!

25,30Lei

Afişare 101 - 120 din 386 (20 pagini)
Queries: 7, Total time: 111.706 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = '96728bd6642202b5ff3b7e72ef'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.118)
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.128)
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 (62.088)
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 (49.046)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.107)
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