Daiwa

Daiwa

Sortare după:

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

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

f3.d16711.206

Livrare imediată!

74,72Lei

LANSETA DAIWA CROSSCAST XT CARP 3.60M 3.5LBS 2SEG

LANSETA DAIWA CROSSCAST XT CARP 3.60M 3.5LBS 2SEG

d.11562.365

Livrare imediată!

673,14Lei

Lanseta Daiwa Infinity X45 Carp 3.00m 4.00lbs 2seg

Lanseta Daiwa Infinity X45 Carp 3.00m 4.00lbs 2seg

d.11990.305

Livrare 24-48 ore

2.228,59Lei(-13%) 1.932,91Lei

Lanseta Spinning Daiwa Silver Creek UL Spin 1.80m, 3-14g, 2seg

Lanseta Spinning Daiwa Silver Creek UL Spin 1.80m, 3-14g, 2seg

d.11441.180

Livrare imediată!

281,89Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.60m, 20-60g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.60m, 20-60g, 3seg

d.11554.360

Livrare 24-48 ore

287,00Lei

Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

d.11605.240r

Livrare 24-48 ore

32,49Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

d.11161.360

Livrare imediată!

562,15Lei(-18%) 458,28Lei

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

a6.13406.000

Livrare 24-48 ore

26,54Lei

Mulineta Daiwa Fuego LT2500, 0.20mm/150m, 5.3:1, 6rul

Mulineta Daiwa Fuego LT2500, 0.20mm/150m, 5.3:1, 6rul

d.10333.250

Livrare 24-48 ore

573,81Lei

Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 8.1:1, 7rul

Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 8.1:1, 7rul

d.10714.112

Livrare 24-48 ore

1.069,53Lei

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.45m, 15-50g, 9+1seg

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.45m, 15-50g, 9+1seg

d.11208.240

Livrare 24-48 ore

415,96Lei

Fir Textil DAIWA J-Braid Expedition X8 PE 0.16mm, 9.80kg, 150m, Green

Fir Textil DAIWA J-Braid Expedition X8 PE 0.16mm, 9.80kg, 150m, Green

d.12551.016

Livrare 24-48 ore

82,11Lei

Plumb Daiwa N Zone Bomb Inline, 60g, 2buc/pac

Plumb Daiwa N Zone Bomb Inline, 60g, 2buc/pac

a.13361.060

Livrare 24-48 ore

36,38Lei

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

d.10131.500

Livrare imediată!

646,29Lei(-10%) 582,66Lei

Costum DAIWA D-Vec Winter, Marime L

Costum DAIWA D-Vec Winter, Marime L

d.18868.020

Livrare 24-48 ore

1.063,74Lei

Shad DAIWA Prorex Belly, Golden Shiner, 11cm, 12g, 4buc/pac

Shad DAIWA Prorex Belly, Golden Shiner, 11cm, 12g, 4buc/pac

d.15320.301

Livrare 24-48 ore

28,89Lei

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

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

f3.d15264.702

Livrare 24-48 ore

53,03Lei

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

d.10317.600

Livrare 24-48 ore

1.224,08Lei

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul

d.10005.200

Livrare imediată!

352,76Lei(-8%) 323,82Lei

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

Afişare 381 - 400 din 1555 (78 pagini)

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

1 (0.137)

SELECT data
FROM `oc_session`
WHERE session_id = '3e3a1f8a90e9f2de07b4f701c0'

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

2 (0.112)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.104)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.141)

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

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

5 (50.704)

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 = '2' AND p.manufacturer_id = '11'

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

6 (77.994)

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

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

7 (0.117)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37