Sakura


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

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

80234saplb503922blb
Livrare imediată!

43,99Lei

Inele Despicate SAKURA X-Strong, No.7, 27kg, 10buc/pac

Inele Despicate SAKURA X-Strong, No.7, 27kg, 10buc/pac

41634sapal10117-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 Albino Trout 1Buc/Plic -49%

Shad Sakura Jackax 140mm Albino Trout 1Buc/Plic

130134saplf5005140-at
Livrare imediată!

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

Lanseta Sakura Shukan Spin SHUS 762 M 2.29m 10-45gr Topwater Special

Lanseta Sakura Shukan Spin SHUS 762 M 2.29m 10-45gr Topwater Special

20434saprj803276-2m
Livrare 48-72 ore

723,73Lei

Shad Sakura Slit Evo, Ayu 048, 8.5cm, 6buc

Shad Sakura Slit Evo, Ayu 048, 8.5cm, 6buc

130134saple501085-048
Livrare 48-72 ore

26,91Lei

Vobler Sakura Notobug 22F 22mm 1.4gr 10

Vobler Sakura Notobug 22F 22mm 1.4gr 10

80234saplb50392210
Livrare imediată!

51,22Lei

Compleu Sakura Combinaison Respirante Gros Temps V2 M

Compleu Sakura Combinaison Respirante Gros Temps V2 M

80134sapce2001m-gr/or
Livrare 48-72 ore

925,87Lei

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, 101 Crayfish, 4cm, 14g, 1buc/pac

Spinnertail SAKURA, 101 Crayfish, 4cm, 14g, 1buc/pac

131634sapll500614-101
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.20mm 150m Chartreuse -30%

Fir Sakura Sensibraid 8X 0.20mm 150m Chartreuse

110634saple40030.20-cha
Livrare 48-72 ore

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

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr T07 Ghost Natural Trout

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr T07 Ghost Natural Trout

130234saplh500950-t07
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

Vobler Sakura Notobug 22F, GB Alb, 3.5g, 3cm

Vobler Sakura Notobug 22F, GB Alb, 3.5g, 3cm

80234saplb503930gb
Livrare imediată!

47,99Lei

Inele Despicate Sakura 4mm 4kg

Inele Despicate Sakura 4mm 4kg

410340001
Livrare imediată!

7,50Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Bronze Perch

Cicada Sakura Micro Soukouss Blade 35mm 7g Bronze Perch

130634saplg501435-016
Livrare 48-72 ore

31,34Lei

Shad Sakura Slit Evo, Glow White, 2.2g, 5cm, 8buc

Shad Sakura Slit Evo, Glow White, 2.2g, 5cm, 8buc

130134saple501050-006
Livrare 48-72 ore

22,15Lei

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

Afişare 181 - 200 din 231 (12 pagini)
Queries: 7, Total time: 72.222 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = 'f0e898c9fa859158940fd25030'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
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 (31.624)
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 (40.127)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.115)
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