Fast Strike


Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Chartreuse Blue Back, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Chartreuse Blue Back, 10buc/pac

4002260745383
Livrare 48-72 ore

35,90Lei

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Ice Chartreuse, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Ice Chartreuse, 1buc/pac

4003892201582
Livrare 48-72 ore

17,70Lei

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

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

5941944263715
Livrare imediată!

9,70Lei

Vobler Fast Strike Top Water, Frog 012, 7.5cm, 17g, 1buc/pac

Vobler Fast Strike Top Water, Frog 012, 7.5cm, 17g, 1buc/pac

749672946499
Livrare 48-72 ore

34,90Lei

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

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

749672946826
Livrare 48-72 ore

22,90Lei

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

20,80Lei

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

24,89Lei

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

17,40Lei

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

24,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ă!

7,90Lei

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

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

5941944264361
Livrare 48-72 ore

24,89Lei

Shad FAST STRIKE Huky Kuky, Blue Pepper, 11.5cm, 4.3g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Blue Pepper, 11.5cm, 4.3g, 10buc/pac

749672946628
Livrare imediată!

29,00Lei

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

28,91Lei

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

24,89Lei

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

35,90Lei

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

20,40Lei

Cicada FAST STRIKE Intruder Deep Vib, Silver Gold 005, 5.3cm, 14.9g

Cicada FAST STRIKE Intruder Deep Vib, Silver Gold 005, 5.3cm, 14.9g

749672946376
Livrare 48-72 ore

23,90Lei

Vobler Fast Striker Sinking Panicked Vibe, Blue Black E, 5.5cm, 10g, 1buc/pac

Vobler Fast Striker Sinking Panicked Vibe, Blue Black E, 5.5cm, 10g, 1buc/pac

5941944264538
Livrare 48-72 ore

23,90Lei

Shad FAST STRIKE Huky Kuky, Blue Pepper, 7.5cm, 2.7g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Blue Pepper, 7.5cm, 2.7g, 10buc/pac

749672946529
Livrare imediată!

26,00Lei

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

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

4000073774279
Livrare 48-72 ore

28,91Lei

Afişare 181 - 200 din 273 (14 pagini)
Queries: 7, Total time: 82.957 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'a86271294b3a4f79d570a32ca1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.117)
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.117)
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 (48.486)
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.937)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
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