Sakura


Lanseta Sakura Salt Sniper Finesse SALSS 802M, 5-20g, 2.44m, 2seg

Lanseta Sakura Salt Sniper Finesse SALSS 802M, 5-20g, 2.44m, 2seg

20434saprj802280-2m
Livrare 48-72 ore

327,15Lei

Lanseta SAKURA Beltza Spin Bels 702MH, 2.13m, 10-35g, 2seg

Lanseta SAKURA Beltza Spin Bels 702MH, 2.13m, 10-35g, 2seg

20434saprn806170-2mh
Livrare 48-72 ore

565,00Lei

Lanseta Sakura Shukan Spin SHUS 732 M Egi, 2.20m, 10-55g, 2seg

Lanseta Sakura Shukan Spin SHUS 732 M Egi, 2.20m, 10-55g, 2seg

20434saprj803273-2m-egi
Livrare 48-72 ore

684,74Lei

Vobler Sakura Notobug 30F 30mm 3.5gr 10

Vobler Sakura Notobug 30F 30mm 3.5gr 10

80434saplb50393010
Livrare imediată!

55,86Lei

Chatterbait Sakura Cajun 10.5gr Kicker Pink

Chatterbait Sakura Cajun 10.5gr Kicker Pink

131134saplg50163/8-jc10
Livrare 48-72 ore

32,50Lei

Crank Sakura SCB Micro 39mm 4.10gr M06 Mat Tiger

Crank Sakura SCB Micro 39mm 4.10gr M06 Mat Tiger

131234saplg501539-m06
Livrare 48-72 ore

48,18Lei

Vobler Sakura Pop'N Dog 40F, 106 D7216 Tucunare, 4cm, 3.3g

Vobler Sakura Pop'N Dog 40F, 106 D7216 Tucunare, 4cm, 3.3g

131534sapla500140-106
Livrare 48-72 ore

57,36Lei

Inele Despicate Sakura 6mm 12kg

Inele Despicate Sakura 6mm 12kg

410340020
Livrare imediată!

9,31Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Metal Copper -29%

Cicada Sakura Micro Soukouss Blade 35mm 7g Metal Copper

130634saplg501435-mc
Livrare 48-72 ore

31,34Lei(-29%) 22,16Lei

Shad Sakura Slit Evo, Ayu, 2.2g, 5cm, 8buc

Shad Sakura Slit Evo, Ayu, 2.2g, 5cm, 8buc

130134saple501050-048
Livrare 48-72 ore

22,15Lei

Vobler Crank Sakura SCB Micro 39mm 4.10gr 075 Electric Shad

Vobler Crank Sakura SCB Micro 39mm 4.10gr 075 Electric Shad

131234saplg501539-075
Livrare 48-72 ore

48,18Lei

Turbotail Sakura Slash Blade 082 Red Tiger, 7.5cm, 13.7g

Turbotail Sakura Slash Blade 082 Red Tiger, 7.5cm, 13.7g

131634saplj500275-082
Livrare 48-72 ore

31,73Lei

Vobler SAKURA Gemibug 30F, FF Fur Finish, 30mm, 2g

Vobler SAKURA Gemibug 30F, FF Fur Finish, 30mm, 2g

130234saplg502630-ff
Livrare imediată!

39,97Lei

Agrafa Sakura Nice Snap, Nr.1, 18kg, 10buc/plic

Agrafa Sakura Nice Snap, Nr.1, 18kg, 10buc/plic

410340012
Livrare imediată!

9,09Lei

Shad Sakura Jackax 140mm Perch 1Buc/Plic -49%

Shad Sakura Jackax 140mm Perch 1Buc/Plic

130134saplf5005140-pe
Livrare imediată!

22,72Lei(-49%) 11,60Lei

Lanseta Sakura Salt Sniper Spinning SALSS 732 M+ 2.20m 10-30gr Topwater Special -22%

Lanseta Sakura Salt Sniper Spinning SALSS 732 M+ 2.20m 10-30gr Topwater Special

20434saprj802273-2m+
Livrare 48-72 ore

324,23Lei(-22%) 252,18Lei

Vobler Sakura Swimy Bug Crank C2026 2.8cm 2.00gr -29%

Vobler Sakura Swimy Bug Crank C2026 2.8cm 2.00gr

130235swplg500528-c2026
Livrare 48-72 ore

29,95Lei(-29%) 21,17Lei

Shad Sakura Slit Evo, Pepper Mint 051, 8.5cm, 6buc

Shad Sakura Slit Evo, Pepper Mint 051, 8.5cm, 6buc

130134saple501085-051
Livrare 48-72 ore

26,91Lei

Cicada SAKURA Salty Blade, 147 Glow Chart, 90mm, 25g

Cicada SAKURA Salty Blade, 147 Glow Chart, 90mm, 25g

130634sasln500990-147
Livrare 48-72 ore

35,72Lei

Vobler Sakura Notobug 22F 22mm 1.4gr 06

Vobler Sakura Notobug 22F 22mm 1.4gr 06

80234saplb50392206
Livrare imediată!

47,95Lei

Afişare 61 - 80 din 232 (12 pagini)
Queries: 7, Total time: 69.214 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '6eb7d05c737eec2e85730f1e62'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '123' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.407)
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 = '3' AND p.manufacturer_id = '123'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (38.138)
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 = '3' AND p.manufacturer_id = '123' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.157)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37