Daiwa

Daiwa

Sortare după:

INELE DESPICATE DAIWA TOURNAMENT D=10.4MM/64.9KG/10BUC/PL

INELE DESPICATE DAIWA TOURNAMENT D=10.4MM/64.9KG/10BUC/PL

a7.16520.006

Livrare 24-48 ore

34,32Lei

Lanseta Daiwa Legalis Spin, 2.10m, 10-30g, 2buc

Lanseta Daiwa Legalis Spin, 2.10m, 10-30g, 2buc

d.11768.212

Livrare imediată!

251,37Lei

AGRAFA+VARTEJ DAIWA NR.2/18,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA NR.2/18,0KG/10BUC/PL

a7.14905.402

Livrare 24-48 ore

10,16Lei

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

f3.dfc12

Livrare 24-48 ore

71,54Lei

LANSETA DAIWA 2BUC. NINJA X CARP 3,00M/3LBS

LANSETA DAIWA 2BUC. NINJA X CARP 3,00M/3LBS

d.11595.315

Livrare imediată!

304,24Lei(-18%) 249,41Lei

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.10, 8kg, 20buc/pac

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.10, 8kg, 20buc/pac

a7.em258098

Livrare 24-48 ore

12,52Lei

VARTEJ DAIWA N ZON NR.8

VARTEJ DAIWA N ZON NR.8

a7.13312.008

Livrare 24-48 ore

11,62Lei

MULINETA DAIWA FUEGO LT 1000, 6RUL, 150M/0.14MM

MULINETA DAIWA FUEGO LT 1000, 6RUL, 150M/0.14MM

d.10223.100

Livrare imediată!

611,32Lei(-29%) 436,11Lei

Lanseta Daiwa Aqualite Power Match 4.20m 7-30g 3seg

Lanseta Daiwa Aqualite Power Match 4.20m 7-30g 3seg

d.11400.420

Livrare 24-48 ore

348,29Lei

Fir monofilament Daiwa Tournament Red 0.33mm 8.10kg 1200m

Fir monofilament Daiwa Tournament Red 0.33mm 8.10kg 1200m

d.tn120033r

Livrare 24-48 ore

122,09Lei

LANSETA DAIWA NINJA X FEEDER 3.30M 120G 3+3SEG

LANSETA DAIWA NINJA X FEEDER 3.30M 120G 3+3SEG

d.11605.335

Livrare 24-48 ore

349,24Lei(-18%) 285,09Lei

Lanseta DAIWA Steez AGS Baitcast 2.08m, 7-28g, 1seg

Lanseta DAIWA Steez AGS Baitcast 2.08m, 7-28g, 1seg

d.stzags6101mhfbcf

Livrare imediată!

1.694,48Lei(-19%) 1.380,30Lei

JACHETA DAIWA ULTRA CARP XXL

JACHETA DAIWA ULTRA CARP XXL

d.18865.250

Livrare imediată!

429,89Lei

Lanseta Spinning Daiwa 2seg Airity Spin, 2.40m/14-42g

Lanseta Spinning Daiwa 2seg Airity Spin, 2.40m/14-42g

d.11926.240

Livrare imediată!

1.007,78Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.14mm, 135m, 10.2kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.14mm, 135m, 10.2kg

d.12760.014

Livrare imediată!

125,27Lei

Shad Daiwa Steez Stirring 11.0cm, Magic Shad, 6buc/pac

Shad Daiwa Steez Stirring 11.0cm, Magic Shad, 6buc/pac

d.17513.400

Livrare 24-48 ore

32,13Lei

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

d.11128.236

Livrare imediată!

2.102,41Lei

Cutie pentru Momeala Daiwa D-Box MD Smoke, 26.7x16.7x9.0cm

Cutie pentru Momeala Daiwa D-Box MD Smoke, 26.7x16.7x9.0cm

d.14311.010

Livrare 24-48 ore

58,52Lei

Shad Daiwa Prorex Slim Shady, Color Mix 2, 7.5cm, 3.3g, 5buc/pac

Shad Daiwa Prorex Slim Shady, Color Mix 2, 7.5cm, 3.3g, 5buc/pac

d.15100.601

Livrare imediată!

42,45Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 790m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 790m

d.12765.137

Livrare imediată!

100,47Lei

Afişare 1401 - 1420 din 1555 (78 pagini)

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

1 (0.172)

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

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

2 (0.130)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.178)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.118)

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

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

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

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

7 (0.159)

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