Daiwa

Daiwa

Sortare după:

Agrafe Daiwa cu Vartej Tournament W-SNAP 7buc/plic

Agrafe Daiwa cu Vartej Tournament W-SNAP 7buc/plic

a7.16513.201

Livrare 24-48 ore

27,45Lei

TRICOU DAIWA POLO D-VEC BLACK MARIME L

TRICOU DAIWA POLO D-VEC BLACK MARIME L

d.18292.130

Livrare imediată!

95,17Lei(-20%) 76,15Lei

Mulienta DAIWA BG 6500, 5.3:1, 0.45mm/340m, 6rul

Mulienta DAIWA BG 6500, 5.3:1, 0.45mm/340m, 6rul

d.10460.650

Livrare 24-48 ore

860,71Lei(-22%) 670,44Lei

Vartej Rapid Daiwa N Zon + Vartej NR.12

Vartej Rapid Daiwa N Zon + Vartej NR.12

a7.13316.012

Livrare imediată!

16,98Lei

LANSETA SPINNING DAIWA PROCYON SPIN 2.10M 3-15G 2seg

LANSETA SPINNING DAIWA PROCYON SPIN 2.10M 3-15G 2seg

d.11210.210

Livrare imediată!

511,58Lei(-29%) 365,12Lei

SAPCA DAIWA CLASSIQUE MESH BLACK

SAPCA DAIWA CLASSIQUE MESH BLACK

d.ca402446

Livrare 24-48 ore

46,69Lei

SAPCA DAIWA NOIRE

SAPCA DAIWA NOIRE

d.ca258579

Livrare 24-48 ore

43,34Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm ROSU 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm ROSU 30g/borcan

a0.13300.107

Livrare imediată!

31,07Lei

CACIULA DAIWA KNITTED GREEN BEANIE

CACIULA DAIWA KNITTED GREEN BEANIE

d.dkbh1

Livrare 24-48 ore

59,40Lei

GEANTA DAIWA TOURNAMENT PRO CARRYALL COOLBAG 46X32X32CM

GEANTA DAIWA TOURNAMENT PRO CARRYALL COOLBAG 46X32X32CM

d.tnpccb2

Livrare 24-48 ore

608,51Lei(-20%) 487,81Lei

Lanseta Spinning Daiwa 2seg Prorex S, 2,10m/3-14g

Lanseta Spinning Daiwa 2seg Prorex S, 2,10m/3-14g

d.11280.210

Livrare imediată!

346,07Lei(-18%) 282,51Lei

Mulineta Daiwa Exist LT2500D 12rul, 0.28mm/150m, 5.2:1

Mulineta Daiwa Exist LT2500D 12rul, 0.28mm/150m, 5.2:1

d.10102.252

Livrare 24-48 ore

4.638,51Lei

Maner Minciog Daiwa Telescopic Carbon, 3.60m

Maner Minciog Daiwa Telescopic Carbon, 3.60m

a2.11920.360

Livrare imediată!

409,75Lei

Lanseta Daiwa Super Spod, 3.90m, 5lbs, 2seg

Lanseta Daiwa Super Spod, 3.90m, 5lbs, 2seg

d.11915.395

Livrare imediată!

585,87Lei

Fir Textil DAIWA Superspod 4XBraid, Galben, 0.25mm, 14.50kg, 300m

Fir Textil DAIWA Superspod 4XBraid, Galben, 0.25mm, 14.50kg, 300m

d.12742.325

Livrare imediată!

69,45Lei

AGARAFA RAPIDA DAIWA TOURNAMENT D-SNAP S 10BUC/PLIC

AGARAFA RAPIDA DAIWA TOURNAMENT D-SNAP S 10BUC/PLIC

d.16512.000

Livrare imediată!

28,56Lei(-22%) 22,25Lei

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 016MM/9,0KG/150M

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 016MM/9,0KG/150M

d.12750.016

Livrare imediată!

66,42Lei

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 130cm

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 130cm

a8.15843.130

Livrare 24-48 ore

151,78Lei

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT VERDE

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT VERDE

d.12741.019

Livrare imediată!

46,04Lei

MULINETA DAIWA PROREX LT 2500D 6RUL/150MX028MM

MULINETA DAIWA PROREX LT 2500D 6RUL/150MX028MM

d.10604.256

Livrare 24-48 ore

1.411,79Lei(-29%) 1.005,86Lei

Afişare 1421 - 1440 din 1555 (78 pagini)

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

1 (0.189)

SELECT data
FROM `oc_session`
WHERE session_id = '273621d275ba095409d68e9efb'

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

2 (0.102)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.129)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.124)

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

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

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

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

7 (0.125)

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