Sakura


Lanseta Sakura Fresh Sniper Spinning FSNS 782 Mh 2.33m 10-35gr

Lanseta Sakura Fresh Sniper Spinning FSNS 782 Mh 2.33m 10-35gr

20434saprk802278-2mh
Livrare 48-72 ore

320,65Lei

Mulineta Sakura Ginaka 2.0 2007 FD

Mulineta Sakura Ginaka 2.0 2007 FD

30234saprf70252007
Livrare imediată!

215,38Lei

Lanseta Sakura Fresh Sniper FSNS L, 2-7g, 1.83m, 2seg

Lanseta Sakura Fresh Sniper FSNS L, 2-7g, 1.83m, 2seg

20434saprk802260-2l
Livrare imediată!

235,18Lei

Lanseta Sakura Tsubarea TSA 662 L, 1.98m, 0.5-7g, 2seg

Lanseta Sakura Tsubarea TSA 662 L, 1.98m, 0.5-7g, 2seg

20434satrh800166-2l
Livrare 48-72 ore

397,13Lei

Sapca SAKURA Classic Cap Blue Navy

Sapca SAKURA Classic Cap Blue Navy

81334sapcn2002nv
Livrare 48-72 ore

74,32Lei

Jig Streamer Sakura R Bucktail 14gr Pink Shad

Jig Streamer Sakura R Bucktail 14gr Pink Shad

130734saplh500314-ps
Livrare 48-72 ore

32,12Lei

Lanseta Sakura Trinis Explora Spin Travel TRXS 704H, 10-40g, 2.13m , 4seg

Lanseta Sakura Trinis Explora Spin Travel TRXS 704H, 10-40g, 2.13m , 4seg

20434saprl801370-4h
Livrare imediată!

935,94Lei

Lanseta SAKURA Beltza Spin Bels 702ML, 2.13m, 3-10.5g, 2seg

Lanseta SAKURA Beltza Spin Bels 702ML, 2.13m, 3-10.5g, 2seg

20434saprn806170-2ml
Livrare 48-72 ore

496,69Lei

Lanseta Sakura Almara ALMS 802MH, 10-35g, 2.44m, 2seg

Lanseta Sakura Almara ALMS 802MH, 10-35g, 2.44m, 2seg

20434saprm806980-2mh
Livrare imediată!

250,72Lei

Mulineta Sakura Tsubaki 2.0 1007 FD, 5.4:1, 0,16mm/160m, 6+1rul

Mulineta Sakura Tsubaki 2.0 1007 FD, 5.4:1, 0,16mm/160m, 6+1rul

30234satrj70221007
Livrare imediată!

348,71Lei

Mulineta SAKURA Tory Reel Baitcast SBC 201

Mulineta SAKURA Tory Reel Baitcast SBC 201

30234saprn7029726
Livrare 48-72 ore

377,00Lei

Lanseta SAKURA Ryokan SW Spin RSWS 742XH, 14-70g, 2.24m, 2seg

Lanseta SAKURA Ryokan SW Spin RSWS 742XH, 14-70g, 2.24m, 2seg

20434saprn802274-2xh
Livrare 48-72 ore

440,76Lei

Creatura Sakura Zarigani Craw, 117 Green Pumpkin Pepper, 78mm, 6.3g, 6buc/pac

Creatura Sakura Zarigani Craw, 117 Green Pumpkin Pepper, 78mm, 6.3g, 6buc/pac

131934sapll500778-117
Livrare 48-72 ore

29,46Lei

Cicada Sakura Soukouss Blade, Sexy Shad, 14g, 5cm, 1buc/pac

Cicada Sakura Soukouss Blade, Sexy Shad, 14g, 5cm, 1buc/pac

sapld500150-046
Livrare 48-72 ore

48,18Lei

Lanseta Sakura Fresh Sniper Spinning FSNS 782 Mh 2.44m 15-50gr

Lanseta Sakura Fresh Sniper Spinning FSNS 782 Mh 2.44m 15-50gr

20434saprk802280-2mh
Livrare 48-72 ore

335,93Lei

Cutie Accesorii Spinning Sakura Nano Box 2, 9.5x6.5x3cm

Cutie Accesorii Spinning Sakura Nano Box 2, 9.5x6.5x3cm

40734baet0950023
Livrare imediată!

11,61Lei

Mulineta Sakura Ginaka 2.0 4007 FD

Mulineta Sakura Ginaka 2.0 4007 FD

30234saprf70254007
Livrare imediată!

236,74Lei

Lanseta Sakura Fresh Sniper FSNS M, 5-20g, 1.90m, 2seg

Lanseta Sakura Fresh Sniper FSNS M, 5-20g, 1.90m, 2seg

20434saprk802263-2m
Livrare imediată!

247,34Lei

Agrafa Sakura Nice Snap, Nr.3, 30kg, 10buc/plic

Agrafa Sakura Nice Snap, Nr.3, 30kg, 10buc/plic

40334acsk3150030
Livrare imediată!

9,09Lei

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

30234saprg70234004
Livrare imediată!

199,31Lei

Afişare 41 - 60 din 230 (12 pagini)
Queries: 7, Total time: 64.287 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '225ad9c4524260c696a642a8f2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.124)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.610)
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 = '2' AND p.manufacturer_id = '123'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (33.013)
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 = '2' AND p.manufacturer_id = '123' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.161)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37