Daiwa

Daiwa

Sortare după:

Vobler DAIWA Prorex Swift Crank Floating, Firetiger, 7cm, 12.9g, 1buc/pac

Vobler DAIWA Prorex Swift Crank Floating, Firetiger, 7cm, 12.9g, 1buc/pac

f3.d15264.703

Livrare 24-48 ore

53,03Lei

Shad DAIWA Prorex V-Marley Pelagic Live, Perch, 80g, 21cm, 1buc/pac

Shad DAIWA Prorex V-Marley Pelagic Live, Perch, 80g, 21cm, 1buc/pac

d.15227.010

Livrare imediată!

71,54Lei

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

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

d.10005.500

Livrare 24-48 ore

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

Juvelnic DAIWA N Zone Power Mesh Keep Net, 3.50m

Juvelnic DAIWA N Zone Power Mesh Keep Net, 3.50m

a2.13440.350

Livrare 24-48 ore

378,94Lei

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

d.tate19100hl

Livrare 24-48 ore

926,28Lei

$Pantaloni DAIWA Gore-Tex Infinium Windstopper Trousers, Marime L$

Pantaloni DAIWA Gore-Tex Infinium Windstopper Trousers, Marime L

d.dgtit.l

Livrare 24-48 ore

1.244,09Lei

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

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

d.21lshirt30lg3xl

Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Ninja SP 664 LFSE 1.98m, 3-10g, 4seg

Lanseta Spinning DAIWA Ninja SP 664 LFSE 1.98m, 3-10g, 4seg

d.njsp664lfsecf

Livrare 24-48 ore

242,23Lei

Mulineta Feeder Daiwa N Zon Plus LT 6000SS-P

Mulineta Feeder Daiwa N Zon Plus LT 6000SS-P

d.10311.600

Stoc epuizat

1.023,82Lei(-19%) 833,84Lei

Vobler DAIWA Silver Creek Minnow 44S, Forest Yamame, 4.4cm, 4.2g

Vobler DAIWA Silver Creek Minnow 44S, Forest Yamame, 4.4cm, 4.2g

f3.scm44sfym

Livrare 24-48 ore

54,73Lei

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

d.12200.316

Livrare imediată!

29,02Lei

VARF DAIWA PENTRU NINJA X METHOD FEEDER YELLOW 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER YELLOW 80g

d.11603.000y

Livrare imediată!

40,16Lei

TRICOU DAIWA POLO BLEU MARIME M

TRICOU DAIWA POLO BLEU MARIME M

d.dpsb.m

Livrare 24-48 ore

137,92Lei

Cosulet Daiwa Feeder N Zon Tunel Medium 60g

Cosulet Daiwa Feeder N Zon Tunel Medium 60g

a.13335.060

Livrare 24-48 ore

17,90Lei

JIG MUSTAD BIG EYE BUCKTAIL BLACK SILVER/BW SILVER CRYSTAL FLASH 14G

JIG MUSTAD BIG EYE BUCKTAIL BLACK SILVER/BW SILVER CRYSTAL FLASH 14G

f.m.bebbksi.1.2

Livrare imediată!

22,45Lei(-45%) 12,41Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG

d.11584.364

Livrare imediată!

271,42Lei(-10%) 244,93Lei

MATRITA DAIWA MOULD NZON METHOD MAR.M

MATRITA DAIWA MOULD NZON METHOD MAR.M

a.13345.100

Livrare imediată!

15,40Lei

Lanseta Spinning Daiwa Sweepfire Spin 2.10m, 10-40g, 2seg

Lanseta Spinning Daiwa Sweepfire Spin 2.10m, 10-40g, 2seg

d.11446.211

Livrare imediată!

180,85Lei

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul

d.10158.100

Livrare 24-48 ore

1.095,13Lei(-19%) 891,83Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

d.11165.390

Livrare 24-48 ore

569,74Lei

Afişare 641 - 660 din 1558 (78 pagini)

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

1 (0.177)

SELECT data
FROM `oc_session`
WHERE session_id = '4e25505e8469a5d9b6b9ec2eff'

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

2 (0.105)

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

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

4 (0.132)

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 (41.556)

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 (61.073)

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 640,20

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

7 (0.123)

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