Fast Strike


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

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

749672946888
Livrare 48-72 ore

24,28Lei

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

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

4001423311328
Livrare 48-72 ore

22,16Lei

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Electric Chicken, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Electric Chicken, 10buc/pac

4002472647635
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 18g, Blue Deep Flash, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 18g, Blue Deep Flash, 1buc/pac

4003987908433
Livrare 48-72 ore

20,12Lei

Shad Fast Strike Roach, RWN Roach Wounded Natural, 10cm, 9g

Shad Fast Strike Roach, RWN Roach Wounded Natural, 10cm, 9g

5941944263845
Livrare imediată!

10,87Lei

Vobler Fast Strike Top Water, Baby Bass 001, 7.5cm, 17g, 1buc/pac

Vobler Fast Strike Top Water, Baby Bass 001, 7.5cm, 17g, 1buc/pac

749672946437
Livrare 48-72 ore

36,49Lei

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

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

749672946758
Livrare 48-72 ore

24,28Lei

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

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

4001216788450
Livrare 48-72 ore

22,16Lei

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

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

4002223084290
Livrare 48-72 ore

26,32Lei

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Prey Fish, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Prey Fish, 1buc/pac

4003700538596
Livrare 48-72 ore

18,69Lei

Shad Fast Strike Roach, RGR Roach Gold Red, 10cm, 9g

Shad Fast Strike Roach, RGR Roach Gold Red, 10cm, 9g

5941944263791
Livrare imediată!

10,87Lei

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

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

5941944264330
Livrare 48-72 ore

26,32Lei

Shad FAST STRIKE Huky Kuky, Orange Green, 11.5cm, 4.3g, 10buc/pac

Shad FAST STRIKE Huky Kuky, Orange Green, 11.5cm, 4.3g, 10buc/pac

749672946673
Livrare 48-72 ore

31,40Lei

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

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

4000392659219
Livrare 48-72 ore

30,40Lei

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

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

4001767694132
Livrare 48-72 ore

26,32Lei

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Neon Lime, 10buc/pac

Shad FAST STRIKE Mama's Jocker 10cm, 7.4g, Neon Lime, 10buc/pac

4002744910955
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 4cm, 7.5g, Ice Chartreuse, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 4cm, 7.5g, Ice Chartreuse, 1buc/pac

4003574908693
Livrare 48-72 ore

15,03Lei

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

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

4002864277020
Livrare 48-72 ore

26,32Lei

Shad Fast Strike Perch, PGW Perch Gold White, 9cm, 8.5g, 1buc/pac

Shad Fast Strike Perch, PGW Perch Gold White, 9cm, 8.5g, 1buc/pac

5941944263920
Livrare imediată!

10,35Lei

Vobler Fast Striker Sinking Atraktus ASP Vibe, Red Head, 6.2cm, 10.4g, 1buc/pac

Vobler Fast Striker Sinking Atraktus ASP Vibe, Red Head, 6.2cm, 10.4g, 1buc/pac

5941944264439
Livrare 48-72 ore

28,35Lei

Afişare 81 - 100 din 273 (14 pagini)
Queries: 7, Total time: 63.617 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '61d9027ce61f90190b785f48d0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
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.083)
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 (29.916)
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.198)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.143)
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