Fast Strike


Cicada FAST STRIKE Intruder Deep Vib, Quiet 001, 5.3cm, 14.9g

Cicada FAST STRIKE Intruder Deep Vib, Quiet 001, 5.3cm, 14.9g

749672946338
Livrare 48-72 ore

25,30Lei

Vobler Fast Striker Sinking Panicked Vibe, Fire Tiger H, 5.5cm, 10g, 1buc/pac

Vobler Fast Striker Sinking Panicked Vibe, Fire Tiger H, 5.5cm, 10g, 1buc/pac

5941944264569
Livrare 48-72 ore

25,30Lei

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

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

749672946857
Livrare 48-72 ore

24,28Lei

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

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

4001405397364
Livrare 48-72 ore

22,16Lei

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

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

4002304334108
Livrare 48-72 ore

37,50Lei

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Pearl Yellow Back, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5.5cm, 13.5g, Pearl Yellow Back, 1buc/pac

4003897743780
Livrare 48-72 ore

19,00Lei

Shad FAST STRIKE Down Shad 9cm, White Phantom, 10buc/pac

Shad FAST STRIKE Down Shad 9cm, White Phantom, 10buc/pac

4004634543878
Livrare 48-72 ore

26,90Lei

Vobler FAST STRIKE Ilusion Slider, 9cm, 20g, Culoare RYB, 1buc/pac

Vobler FAST STRIKE Ilusion Slider, 9cm, 20g, Culoare RYB, 1buc/pac

4006406388892
Livrare 48-72 ore

35,90Lei

Shad FAST STRIKE Turbo Zander, 10cm, Orange Green, 10buc/pac

Shad FAST STRIKE Turbo Zander, 10cm, Orange Green, 10buc/pac

4007435202425
Livrare 48-72 ore

28,89Lei

Shad Fast Strike Roach, RRT Roach Red Tail, 10cm, 9g

Shad Fast Strike Roach, RRT Roach Red Tail, 10cm, 9g

5941944263807
Livrare imediată!

9,64Lei

Vobler Fast Strike Top Water, Fast Attak 014, 7.5cm, 17g, 1buc/pac

Vobler Fast Strike Top Water, Fast Attak 014, 7.5cm, 17g, 1buc/pac

749672946505
Livrare 48-72 ore

36,49Lei

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

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

749672946734
Livrare 48-72 ore

24,28Lei

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

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

4001125594524
Livrare 48-72 ore

22,16Lei

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

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

4002092119109
Livrare 48-72 ore

26,32Lei

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Fire Tiger, 1buc/pac

Cicada FAST STRIKE Cyborgstone Vibe 5cm, 10g, Fire Tiger, 1buc/pac

4003679054318
Livrare 48-72 ore

18,69Lei

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

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

4003034621698
Livrare 48-72 ore

26,32Lei

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

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

4007222731374
Livrare 48-72 ore

35,90Lei

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

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

4007836668806
Livrare 48-72 ore

28,89Lei

Shad Fast Strike Perch, PNW Perch Natural White, 9cm, 8.5g, 1buc/pac

Shad Fast Strike Perch, PNW Perch Natural White, 9cm, 8.5g, 1buc/pac

5941944263913
Livrare imediată!

10,35Lei

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

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

5941944264354
Livrare 48-72 ore

26,32Lei

Afişare 121 - 140 din 386 (20 pagini)
Queries: 7, Total time: 139.385 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '694588fd90d5c28979daa4ceb3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.698)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.883)
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.946)
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 (67.392)
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 (69.205)
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 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.152)
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