Sakura


Mulineta Sakura Kuanza Casting 2.0

Mulineta Sakura Kuanza Casting 2.0

334saprf702962
Livrare 48-72 ore

333,95Lei

Lanseta Sakura Shukan Spin SHUS 802 M 2.44m 7-28gr EGI

Lanseta Sakura Shukan Spin SHUS 802 M 2.44m 7-28gr EGI

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

701,04Lei

Shad Sakura Slit Evo, Glow White 006, 10cm, 5buc -36%

Shad Sakura Slit Evo, Glow White 006, 10cm, 5buc

130134saple5010100-006
Livrare 48-72 ore

27,82Lei(-36%) 17,85Lei

Cicada SAKURA Salty Blade, 145 Pink Tiger, 90mm, 25g

Cicada SAKURA Salty Blade, 145 Pink Tiger, 90mm, 25g

130634sasln500990-145
Livrare 48-72 ore

37,32Lei

Sapca SAKURA neagra -26%

Sapca SAKURA neagra

sapca-sa
Livrare 48-72 ore

56,71Lei(-26%) 41,75Lei

Chatterbait Sakura Cajun 14gr Fire Tiger

Chatterbait Sakura Cajun 14gr Fire Tiger

131134saplg50161/2-jc6
Livrare imediată!

35,34Lei

Vobler Sakura Pop'N Dog 40F, 016 Bronze Perch, 4cm, 3.3g

Vobler Sakura Pop'N Dog 40F, 016 Bronze Perch, 4cm, 3.3g

131534sapla500140-016
Livrare 48-72 ore

59,31Lei

Vobler SAKURA Gemibug 30F, WHB White Bug, 30mm, 4.4g

Vobler SAKURA Gemibug 30F, WHB White Bug, 30mm, 4.4g

130234saplg502635-whb
Livrare imediată!

54,29Lei

Agrafa Sakura Diamond Snap Nickelees Nr 0 8kg

Agrafa Sakura Diamond Snap Nickelees Nr 0 8kg

41034acsk3200001
Livrare imediată!

10,85Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Tiger

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Tiger

130634saplg501435-m06
Livrare imediată!

32,88Lei

Geanta Sakura Bakkan Bag 26L

Geanta Sakura Bakkan Bag 26L

90434basa0958026
Livrare 48-72 ore

221,43Lei

Vobler Sakura Notobug 22F, BLB Rosu, 1.4g, 2.2cm

Vobler Sakura Notobug 22F, BLB Rosu, 1.4g, 2.2cm

80234saplb503922blb
Livrare imediată!

45,74Lei

Inele Despicate SAKURA X-Strong, No.9, 70kg, 10buc/pac

Inele Despicate SAKURA X-Strong, No.9, 70kg, 10buc/pac

41634sapal10119-nkl
Livrare 48-72 ore

14,18Lei

Vobler Sakura Notobug 22F 22mm 1.4gr 11

Vobler Sakura Notobug 22F 22mm 1.4gr 11

80234saplb50392211
Livrare imediată!

49,76Lei

Jig Lestat Sakura Chebu Jighead 10gr No.4/0

Jig Lestat Sakura Chebu Jighead 10gr No.4/0

120934sapag000510-4/0
Livrare 48-72 ore

20,19Lei

Shad Sakura Slit Evo, Fire Chart 059, 8.5cm, 6buc

Shad Sakura Slit Evo, Fire Chart 059, 8.5cm, 6buc

130134saple501085-059
Livrare 48-72 ore

28,36Lei

Cutie SAKURA Meiho SK-9337 Smoke, 27.5x18.7x4.3cm

Cutie SAKURA Meiho SK-9337 Smoke, 27.5x18.7x4.3cm

90934sapen3037
Livrare 48-72 ore

96,93Lei

Vobler Sakura Notobug 30F 30mm 3.5gr 10

Vobler Sakura Notobug 30F 30mm 3.5gr 10

80434saplb50393010
Livrare imediată!

57,80Lei

Vobler Sakura Pop'N Dog 70F 70mm 9G 016 Bronze Perch

Vobler Sakura Pop'N Dog 70F 70mm 9G 016 Bronze Perch

80234sapla500170-016
Livrare 48-72 ore

55,56Lei

Vobler Crank Sakura SCB Micro 39mm 4.10gr 101 Crayfish

Vobler Crank Sakura SCB Micro 39mm 4.10gr 101 Crayfish

131234saplg501539-101
Livrare 48-72 ore

49,99Lei

Afişare 141 - 160 din 197 (10 pagini)
Queries: 7, Total time: 103.307 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = 'feee2ab79a0cd2a6686360b27e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.114)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (56.413)
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 = '123'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (46.381)
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 = '123' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
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