Daiwa

Daiwa

Sortare după:

Lanseta DAIWA EXCELER CATFISH BOJE 3.00M 200-600G 2seg

Lanseta DAIWA EXCELER CATFISH BOJE 3.00M 200-600G 2seg

d.11818.306

Livrare imediată!

434,03Lei

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

d.ccs2235scw5000qdr

Livrare imediată!

797,10Lei

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg

d.11333.360

Livrare imediată!

467,88Lei(-22%) 366,90Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

d.11160.330

Livrare 24-48 ore

387,17Lei

Lanseta Daiwa Crossfire JiggerSpin 2.40m, 5-25g, 2seg

Lanseta Daiwa Crossfire JiggerSpin 2.40m, 5-25g, 2seg

d.11439.240

Livrare 24-48 ore

188,97Lei

Mulineta Daiwa Caldia SW 8000-H, 0.40mm/200m, 5.7:1, 6rul

Mulineta Daiwa Caldia SW 8000-H, 0.40mm/200m, 5.7:1, 6rul

d.10320.805

Livrare 24-48 ore

1.647,36Lei

Lanseta Spinning Daiwa WILDERNESS ST 2.00m, 2-10g, 2seg

Lanseta Spinning Daiwa WILDERNESS ST 2.00m, 2-10g, 2seg

d.11873.200

Livrare 24-48 ore

465,59Lei

Lanseta Daiwa Crosscast Carp Z 2334 3.66m, 3.5lbs, 2seg

Lanseta Daiwa Crosscast Carp Z 2334 3.66m, 3.5lbs, 2seg

d.cccz2334ax

Livrare imediată!

672,70Lei

Lanseta Spinning Daiwa Prorex XR Spin 2.25m, 10-30g, 2seg

Lanseta Spinning Daiwa Prorex XR Spin 2.25m, 10-30g, 2seg

d.11332.225

Livrare 24-48 ore

886,17Lei

Method Feeder Daiwa Nzon Weight Change L, 50g, 1buc/pac

Method Feeder Daiwa Nzon Weight Change L, 50g, 1buc/pac

a3.13345.950

Livrare 24-48 ore

21,21Lei

Lanseta DAIWA Triforce Feeder 3.60m, 120g, 3+2seg

Lanseta DAIWA Triforce Feeder 3.60m, 120g, 3+2seg

d.11770.360

Livrare imediată!

213,05Lei(-11%) 190,00Lei

Jacheta DAIWA D-Vec Wading Grey-Camo, Marime XXL

Jacheta DAIWA D-Vec Wading Grey-Camo, Marime XXL

d.18869.040

Livrare 24-48 ore

461,70Lei

Mulineta DAIWA 24 Crosscast Surf 45SCW 5000C QD, 4.9:1, 0.35mm/300m, 3rul

Mulineta DAIWA 24 Crosscast Surf 45SCW 5000C QD, 4.9:1, 0.35mm/300m, 3rul

d.10255.500

Livrare imediată!

863,15Lei

Shad DAIWA Prorex Real Slim Live, Color Mix, 13.5cm, 13.5g, 5buc/pac

Shad DAIWA Prorex Real Slim Live, Color Mix, 13.5cm, 13.5g, 5buc/pac

d.15100.815

Livrare 24-48 ore

43,53Lei

GEANTA DAIWA PROREX TACKLE 38X18X24CM

GEANTA DAIWA PROREX TACKLE 38X18X24CM

d.15810.500

Livrare imediată!

307,67Lei(-20%) 246,14Lei

Lanseta DAIWA Prorex S Finesse Spin, 3-14g, 2.15g, 2seg

Lanseta DAIWA Prorex S Finesse Spin, 3-14g, 2.15g, 2seg

d.11282.215

Livrare 24-48 ore

314,70Lei

Lanseta DAIWA Airity Hybrid Spin Ultra Fast, 2.15m, 3-10g, 2seg

Lanseta DAIWA Airity Hybrid Spin Ultra Fast, 2.15m, 3-10g, 2seg

d.11930.210

Livrare 24-48 ore

1.397,25Lei(-14%) 1.199,98Lei

Lanseta DAIWA Prorex XR Spin 2.40m, 18-84g, 2seg

Lanseta DAIWA Prorex XR Spin 2.40m, 18-84g, 2seg

d.11332.242

Livrare 24-48 ore

869,99Lei

Tricou DAIWA D Old Shirt Short Sleeve 31, Dark Gray, Marime S

Tricou DAIWA D Old Shirt Short Sleeve 31, Dark Gray, Marime S

d.21sshirt31dgs

Livrare 24-48 ore

115,61Lei

Lanseta Spinning SENSAS Ginki Overtake Fight Rod ED-S 270XH F 2.70m, 14-55g, 2seg

Lanseta Spinning SENSAS Ginki Overtake Fight Rod ED-S 270XH F 2.70m, 14-55g, 2seg

spm.66889

Livrare 24-48 ore

491,91Lei

Afişare 401 - 420 din 1638 (82 pagini)

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

1 (0.116)

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

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

2 (0.111)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.143)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.134)

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

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

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

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

7 (0.109)

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