FL.


Sistem Balama Pentru Plute, Marime M, 10buc/pac -30%

Sistem Balama Pentru Plute, Marime M, 10buc/pac

1452158358189
Livrare imediată!

9,99Lei(-30%) 7,01Lei

Varga FL Fine Special 4M

Varga FL Fine Special 4M

3176157138754
Livrare imediată!

102,58Lei

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME L 40G

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME L 40G

64-71017-l-40
Livrare imediată!

23,27Lei

MONTURA FL FEEDER MFD CU SPIN 30G CARLIG NR 8 SPIN 7MM

MONTURA FL FEEDER MFD CU SPIN 30G CARLIG NR 8 SPIN 7MM

ak-mfd30/8
Livrare imediată!

15,13Lei

MULINETA PRO FL PIONER LAC 2000

MULINETA PRO FL PIONER LAC 2000

1183240915774
Livrare imediată!

91,39Lei

LANSETA PRO FL FALCONS FEEDER 3.60M 180G

LANSETA PRO FL FALCONS FEEDER 3.60M 180G

5253249033215
Livrare 24-48 ore

161,55Lei

Mulineta FL TB12 6000

Mulineta FL TB12 6000

4262195805990
Livrare 24-48 ore

171,90Lei

LINGURITA PRO FL PASTRAV 3CM 3G CULOARE N001

LINGURITA PRO FL PASTRAV 3CM 3G CULOARE N001

64-80361
Livrare imediată!

13,10Lei

Lanseta Telescopica FL Eternity Tele Carp, Up To 150g, 3.90m

Lanseta Telescopica FL Eternity Tele Carp, Up To 150g, 3.90m

5153171225965
Livrare imediată!

153,42Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 11

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 11

fl115-floating-0.6-1.2m-100mm-15.5g-11
Livrare imediată!

18,39Lei

Lanseta Telescopica PRO FL Eternity Tele Carp, Up To 150g, 3.60m

Lanseta Telescopica PRO FL Eternity Tele Carp, Up To 150g, 3.60m

1224247816630
Livrare imediată!

153,42Lei

Vobler FL FL505 Floating 50mm 9.8g Depth 2.5m Colour 93

Vobler FL FL505 Floating 50mm 9.8g Depth 2.5m Colour 93

fl505-floating-2.5m-50mm-9.8g-93
Livrare imediată!

18,39Lei

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 113

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 113

fl602-sinking-allround-55mm-10.5g-113
Livrare imediată!

18,39Lei

CARLIGE PRO FL KRANK 10BUC TEFLONATE NR 4

CARLIGE PRO FL KRANK 10BUC TEFLONATE NR 4

64-66310
Livrare imediată!

16,15Lei

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 2

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 2

64-3506
Livrare imediată!

16,76Lei

SISTEM ANTITANGLE FEEDER PRO FL 3BUC -40%

SISTEM ANTITANGLE FEEDER PRO FL 3BUC

64-65986
Livrare imediată!

15,00Lei(-40%) 9,03Lei

Momitor Feeder In-Line FL Hybrid M 40 g 1Buc/Plic

Momitor Feeder In-Line FL Hybrid M 40 g 1Buc/Plic

ak-wm40
Livrare imediată!

8,75Lei

LANSETA PRO FL X POWER FEEDER 60-180G 4.50M

LANSETA PRO FL X POWER FEEDER 60-180G 4.50M

65-46272
Livrare imediată!

244,93Lei

Momitor Feeder In-Line FL Hybrid 30 g 1Buc/Plic

Momitor Feeder In-Line FL Hybrid 30 g 1Buc/Plic

64-2431
Livrare imediată!

8,63Lei

CARLIGE LEGATE CU SPIN PRO FL PRO FEEDER RIGS 8BUC NR 12

CARLIGE LEGATE CU SPIN PRO FL PRO FEEDER RIGS 8BUC NR 12

64-26857
Livrare imediată!

21,24Lei

Afişare 221 - 240 din 2160 (108 pagini)
Queries: 7, Total time: 126.074 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '9178d82b4eee2a25a87c74eb84'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.157)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '13' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.192)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (84.258)
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 = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.120)
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