Varivas


PORTOFEL FLY LEADER VARIVAS

PORTOFEL FLY LEADER VARIVAS

v5001
Livrare 48-72 ore

35,00Lei

ANCORA VARIVAS NOGALES ZERO FRICTION NR.4

ANCORA VARIVAS NOGALES ZERO FRICTION NR.4

vca11zf04
Livrare imediată!

31,00Lei

Inaintas Conic Varivas Fly Tapered Leader Standard St Fluorocarbon 0X 9ft/2.74m 0.285mm-0.56mm

Inaintas Conic Varivas Fly Tapered Leader Standard St Fluorocarbon 0X 9ft/2.74m 0.285mm-0.56mm

v53490x
Livrare 48-72 ore

41,00Lei

Carlige Varivas Offset Master Heavy Wide Nr.1/0

Carlige Varivas Offset Master Heavy Wide Nr.1/0

v704311/0
Livrare 48-72 ore

17,01Lei

Fir Monofilament Varivas Super Trout Area SVG, Natural, 0.098mm, 2lbs, 150m

Fir Monofilament Varivas Super Trout Area SVG, Natural, 0.098mm, 2lbs, 150m

v6015003
Livrare 48-72 ore

69,00Lei

CARLIGE VARIVAS FLY IWI F-2000 2X FINE NR 16 MICRO BARB

CARLIGE VARIVAS FLY IWI F-2000 2X FINE NR 16 MICRO BARB

vcf200016
Livrare imediată!

26,00Lei

CARLIGE VARIVAS FLY 2200BL-B 2X-3X FINE NR 20 F/BARB

CARLIGE VARIVAS FLY 2200BL-B 2X-3X FINE NR 20 F/BARB

vcblb220020
Livrare imediată!

24,00Lei

CARLIGE VARIVAS FLY 2200BL 2x-3x FINE NR.10 100BUC/CUTIE

CARLIGE VARIVAS FLY 2200BL 2x-3x FINE NR.10 100BUC/CUTIE

vcpbl220010
Livrare 48-72 ore

57,00Lei

CARLIGE VARIVAS OFFSET NOGALES NEKORING HEAVY CLASS NR.1

CARLIGE VARIVAS OFFSET NOGALES NEKORING HEAVY CLASS NR.1

vc92hmw01
Livrare 48-72 ore

13,99Lei

BANDA Varivas ROLE FIR A 33.5cmx23cm Light Green/Red

BANDA Varivas ROLE FIR A 33.5cmx23cm Light Green/Red

vaac33b
Livrare 48-72 ore

45,01Lei

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 30m 0.370mm 10.3kg

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 30m 0.370mm 10.3kg

v2825050
Livrare 48-72 ore

79,00Lei

Carlige Varivas Offset Master Monster Class Nr.1

Carlige Varivas Offset Master Monster Class Nr.1

v7042001
Livrare 48-72 ore

17,01Lei

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.165mm, 5lbs, 30m

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.165mm, 5lbs, 30m

v45703010
Livrare 48-72 ore

72,99Lei

Carlig Offset Varivas Nogales Maji Revival, Nr.6/0, 5buc/pac

Carlig Offset Varivas Nogales Maji Revival, Nr.6/0, 5buc/pac

vc7056/0
Livrare 48-72 ore

19,00Lei

Fir Textil Varivas Avani Sea Bass Max Power PE X9, White Purple, 33lbs, 1.5mm, 150m

Fir Textil Varivas Avani Sea Bass Max Power PE X9, White Purple, 33lbs, 1.5mm, 150m

v129437
Livrare 48-72 ore

259,00Lei

INAINTAS MONOFILAMENT VARIVAS FLY LAKE RETRIEVE FLUORO 14FT/4.27m 2X

INAINTAS MONOFILAMENT VARIVAS FLY LAKE RETRIEVE FLUORO 14FT/4.27m 2X

v357142x
Livrare 48-72 ore

31,00Lei

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 10 F/BARB

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 10 F/BARB

vcbl220010
Livrare 48-72 ore

24,00Lei

CARLIGE VARIVAS FLY KELL STREAMER 2510WB NR 4 F/BARB

CARLIGE VARIVAS FLY KELL STREAMER 2510WB NR 4 F/BARB

vcwb251004
Livrare 48-72 ore

28,00Lei

FIR VARIVAS AVANI JIGGING POWER BRAID PE X4 200m 43lb 10m 5 Culori

FIR VARIVAS AVANI JIGGING POWER BRAID PE X4 200m 43lb 10m 5 Culori

v29320030
Livrare 48-72 ore

164,01Lei

Fir textil Varivas Avani Eging Suspend PE 4X Marking Tropical Pink 17.5lb/160m

Fir textil Varivas Avani Eging Suspend PE 4X Marking Tropical Pink 17.5lb/160m

v16416010
Livrare 48-72 ore

166,01Lei

Afişare 441 - 460 din 485 (25 pagini)
Queries: 7, Total time: 94.917 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'bdbfba1c7766804263d1e058f7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '50' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (44.338)
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 = '0' AND p.manufacturer_id = '50'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (50.098)
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 = '0' AND p.manufacturer_id = '50' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.115)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37