Daiwa

Daiwa

Sortare după:

Lanseta Spinning Daiwa Preso Trout Spin 2.10m, 1-6g, 2seg

Lanseta Spinning Daiwa Preso Trout Spin 2.10m, 1-6g, 2seg

d.11718.211

Livrare 24-48 ore

628,15Lei

Fir Textil DAIWA J-Braid Expedition X8 PE 0.06mm, 5.20kg, 150m, Orange

Fir Textil DAIWA J-Braid Expedition X8 PE 0.06mm, 5.20kg, 150m, Orange

d.12550.006

Livrare imediată!

82,11Lei

Cosulet Daiwa Nzon Window Feeder PB, 45g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder PB, 45g, 1buc/pac

a3.13358.045

Livrare 24-48 ore

20,12Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Firetiger, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Firetiger, 4.1cm, 6.5g, 1buc/pac

f3.d15263.403

Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, White Ghost, 8.5cm, 4g, 4buc/pac

Shad DAIWA Prorex Belly, White Ghost, 8.5cm, 4g, 4buc/pac

d.15320.207

Livrare 24-48 ore

28,89Lei

Vobler DAIWA Prorex Swift Crank Floating, Ghost Purple Wakasagi, 7cm, 12.9g, 1buc/pac

Vobler DAIWA Prorex Swift Crank Floating, Ghost Purple Wakasagi, 7cm, 12.9g, 1buc/pac

f3.d15264.710

Livrare 24-48 ore

53,03Lei

Fir Inaintas DAIWA Double Tapered Mono, Olive Green, 6.35kg-14Lbs, 0.30mm, 320m

Fir Inaintas DAIWA Double Tapered Mono, Olive Green, 6.35kg-14Lbs, 0.30mm, 320m

d.12958.014

Livrare 24-48 ore

41,10Lei(-18%) 33,88Lei

Mulineta Daiwa 23 Ninja LT 4000C, 5.2:1, 0.28mm/150m, 4rul

Mulineta Daiwa 23 Ninja LT 4000C, 5.2:1, 0.28mm/150m, 4rul

d.10005.400

Livrare imediată!

385,16Lei(-11%) 343,65Lei

BUFF DAIWA ALBASTRU/ALB

BUFF DAIWA ALBASTRU/ALB

d.tdcbw

Livrare 24-48 ore

34,71Lei(-17%) 28,79Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Gray, Marime 2XL

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Gray, Marime 2XL

d.21lshirt30lg2xl

Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Ninja SP 802 MHFSE 2.44m, 7-28g, 2seg

Lanseta Spinning DAIWA Ninja SP 802 MHFSE 2.44m, 7-28g, 2seg

d.njsp802mhfsecf

Livrare 24-48 ore

251,20Lei

Fir DAIWA Justron DPLS Yellow, 500m, 0.260mm, 4.8kg/10.58lbs

Fir DAIWA Justron DPLS Yellow, 500m, 0.260mm, 4.8kg/10.58lbs

d.07300460

Livrare 24-48 ore

53,72Lei

Mulineta Daiwa Emeraldas X 20 LT 3000 SH

Mulineta Daiwa Emeraldas X 20 LT 3000 SH

d.emex20lt3000sh

Livrare imediată!

645,52Lei(-3%) 629,08Lei

VARF DAIWA PENTRU NINJA X FEEDER GREEN 50-150g

VARF DAIWA PENTRU NINJA X FEEDER GREEN 50-150g

d.11606.001g

Livrare imediată!

40,16Lei

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

d.18850.010

Livrare imediată!

183,90Lei

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G PEARL GHOST

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G PEARL GHOST

f3.d16711.205

Livrare 24-48 ore

67,65Lei

BAC DAIWA N ZON EVA WATER BUCKET 16X16X20CM

BAC DAIWA N ZON EVA WATER BUCKET 16X16X20CM

d.13305.105

Livrare imediată!

81,13Lei

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

d.11562.395

Livrare imediată!

678,04Lei

METHOD FEEDER DAIWA NZON METHOD 30G MAR. S

METHOD FEEDER DAIWA NZON METHOD 30G MAR. S

a3.13345.030

Livrare imediată!

21,30Lei

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

d.11990.396

Livrare 24-48 ore

3.776,30Lei

Afişare 281 - 300 din 1568 (79 pagini)

Queries: 7, Total time: 109.773 ms [By time] [By id] [By file]

1 (0.125)

SELECT data
FROM `oc_session`
WHERE session_id = 'd5f742cecc36ccb45af71c29e6'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.111)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.139)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.126)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '11' AND m2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (46.930)

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 = '11'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (62.212)

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 = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 280,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.130)

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