Daiwa

Daiwa

Sortare după:

Fir Monofilament Daiwa Infinity Carp, Camo Green, 11.6kg, 0.41mm, 710m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 11.6kg, 0.41mm, 710m

d.12767.141

Livrare 24-48 ore

120,41Lei

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT VERDE

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT VERDE

d.12741.013

Livrare imediată!

46,05Lei

TRICOU DAIWA POLO NEGRU MARIMEA L

TRICOU DAIWA POLO NEGRU MARIMEA L

d.pn.l

Livrare 24-48 ore

127,95Lei

FIR DAIWA PROREX FC LEADER 0,80MM/29,2KG/15M

FIR DAIWA PROREX FC LEADER 0,80MM/29,2KG/15M

d.12995.080

Livrare 24-48 ore

43,56Lei

TRICOU DAIWA POLO NEGRU MARIMEA M

TRICOU DAIWA POLO NEGRU MARIMEA M

d.18292.120

Livrare imediată!

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

MULINETA DAIWA FREAMS LT 1000S

MULINETA DAIWA FREAMS LT 1000S

d.10224.100

Livrare imediată!

695,39Lei

NALUCA DAIWA PROREX BOTH CRAW GREEN PUMPKIN PURPLE 7.5CM

NALUCA DAIWA PROREX BOTH CRAW GREEN PUMPKIN PURPLE 7.5CM

f.d.15429.805

Livrare 24-48 ore

55,45Lei(-27%) 40,47Lei

Lanseta Pastrav DAIWA Presso Imprimi 602UL, 1.80m, 0.5-5g, 2seg

Lanseta Pastrav DAIWA Presso Imprimi 602UL, 1.80m, 0.5-5g, 2seg

d.pso602ulcf

Livrare 24-48 ore

312,95Lei

Lanseta DAIWA Ninja Tele Surf 150-AI, 4.30m, 200g, 6seg

Lanseta DAIWA Ninja Tele Surf 150-AI, 4.30m, 200g, 6seg

d.njtsrf200ai

Livrare 24-48 ore

735,27Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Ciocolata Portocaliu 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Ciocolata Portocaliu 30g/borcan

a0.13300.100

Livrare imediată!

35,09Lei(-19%) 28,49Lei

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.12

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.12

a7.13315.012

Livrare 24-48 ore

20,90Lei

Agrafa Culisanta Daiwa Feeder N Zon Bead With Safety Snap 6buc

Agrafa Culisanta Daiwa Feeder N Zon Bead With Safety Snap 6buc

a.13310.010

Livrare imediată!

13,83Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.20MM 2.90KG 50M

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.20MM 2.90KG 50M

d.12940.020

Livrare imediată!

29,02Lei

Sapca Daiwa D-Vec Black

Sapca Daiwa D-Vec Black

d.18205.504

Livrare imediată!

98,72Lei

Mulineta Daiwa BG Monocoque 2500-H

Mulineta Daiwa BG Monocoque 2500-H

d.10465.250

Livrare 24-48 ore

1.085,39Lei(-11%) 965,80Lei

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

d.shc35r

Livrare imediată!

82,61Lei

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

d.11789.275

Livrare 24-48 ore

260,00Lei

Fir Fluorocarbon Daiwa J, 0.33mm, 6.8kg, 100m

Fir Fluorocarbon Daiwa J, 0.33mm, 6.8kg, 100m

d.12220.033

Livrare 24-48 ore

54,50Lei

Lanseta Spinning Daiwa 2seg Triforce Target Pike Spin, 2.40m, 30-70g

Lanseta Spinning Daiwa 2seg Triforce Target Pike Spin, 2.40m, 30-70g

d.11400.247

Livrare 24-48 ore

203,10Lei

Ochelari Polarizati Daiwa Sport, Lentila Galbena

Ochelari Polarizati Daiwa Sport, Lentila Galbena

d.df005y

Livrare 24-48 ore

128,62Lei

Afişare 841 - 860 din 1583 (80 pagini)

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

1 (0.090)

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

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

2 (0.121)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.142)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.171)

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

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

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

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

7 (0.182)

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