Sakura


Inele Despicate SAKURA X-Strong, No.8, 39kg, 10buc/pac

Inele Despicate SAKURA X-Strong, No.8, 39kg, 10buc/pac

41634sapal10118-nkl
Livrare imediată!

12,96Lei

Agrafa Sakura Nice Snap, Nr.2, 25kg, 10buc/plic

Agrafa Sakura Nice Snap, Nr.2, 25kg, 10buc/plic

410340013
Livrare 48-72 ore

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

Shad Sakura Slit Evo, Color Mix, 10cm, 5buc/blister

Shad Sakura Slit Evo, Color Mix, 10cm, 5buc/blister

130134saple5010100-mix
Livrare imediată!

27,82Lei

Vobler Sakura Notobug 22F 22mm 1.4gr 10

Vobler Sakura Notobug 22F 22mm 1.4gr 10

80234saplb50392210
Livrare imediată!

51,22Lei

Spinnerbait Sakura Cajun 14g Rainbow Shad

Spinnerbait Sakura Cajun 14g Rainbow Shad

130334saplf50041/2-jc1
Livrare 48-72 ore

37,34Lei

Chatterbait Sakura Cajun 10.5gr JC16 Electric Shad

Chatterbait Sakura Cajun 10.5gr JC16 Electric Shad

131134saplg50163/8-jc16
Livrare 48-72 ore

32,50Lei

Cutie Sakura SK-9821 Clear 23.3x12.7x3.4cm

Cutie Sakura SK-9821 Clear 23.3x12.7x3.4cm

90934btsk0098210
Livrare 48-72 ore

36,20Lei

Spinnertail SAKURA, 103 Toxic Gill, 4cm, 14g, 1buc/pac

Spinnertail SAKURA, 103 Toxic Gill, 4cm, 14g, 1buc/pac

131634sapll500614-103
Livrare 48-72 ore

47,64Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr T02 Hi Viz Chart Trout

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr T02 Hi Viz Chart Trout

80434saplc505540-t02
Livrare 48-72 ore

48,18Lei

Fir Sakura Sensibraid 8X 0.18mm 150m Chartreuse -30%

Fir Sakura Sensibraid 8X 0.18mm 150m Chartreuse

110634saple40030.18-cha
Livrare 48-72 ore

105,62Lei(-30%) 73,93Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL04 Real Life Fario Trout

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL04 Real Life Fario Trout

130234saplh500950-rl04
Livrare 48-72 ore

52,00Lei

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

57,36Lei

Inele Despicate Sakura 4mm 4kg

Inele Despicate Sakura 4mm 4kg

410340001
Livrare imediată!

7,50Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

130634saplg501435-m14
Livrare imediată!

31,34Lei

Jig Lestat Sakura Chebu Jighead 7gr No.3/0

Jig Lestat Sakura Chebu Jighead 7gr No.3/0

120934sapag00057-3/0
Livrare 48-72 ore

17,97Lei

Turbotail Sakura Slash Blade 078 Herring, 7.5cm, 13.7g

Turbotail Sakura Slash Blade 078 Herring, 7.5cm, 13.7g

131634saplj500275-078
Livrare 48-72 ore

31,73Lei

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

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

130234saplg502630-whb
Livrare imediată!

39,97Lei

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic

410340021
Livrare 48-72 ore

9,09Lei

Afişare 121 - 140 din 231 (12 pagini)
Queries: 7, Total time: 67.699 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = '7f285a515624cf82d7b4403e64'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.060)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.078)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.092)
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 (29.815)
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 (37.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 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.203)
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