FL.


Undita Chinezeasca FL Create Miracles 5.4m

Undita Chinezeasca FL Create Miracles 5.4m

7962380654064
Livrare imediată!

295,91Lei

METHOD DURA FEEDER INLINE PRO FL X-LARGE 50G

METHOD DURA FEEDER INLINE PRO FL X-LARGE 50G

64-19767
Livrare imediată!

11,90Lei

MULINETA, PRO, FL, FEEDER, ZONE, 5000, fz-5000, Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., FL.
CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 4/0 10BUC

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 4/0 10BUC

64-26376
Livrare imediată!

10,90Lei

Cap Minciog FL, Plasa Naylon, 40x50cm

Cap Minciog FL, Plasa Naylon, 40x50cm

8177206687648
Livrare imediată!

55,20Lei

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

64-23382
Livrare imediată!

225,90Lei

UNDITA PRO FL STRATEGIST FORCE 7MT 40-100G UP TO 4.5KG

UNDITA PRO FL STRATEGIST FORCE 7MT 40-100G UP TO 4.5KG

64-4073
Livrare imediată!

469,00Lei

Momeala Chinezeasca Mix Seminte Special Crap 800g

Momeala Chinezeasca Mix Seminte Special Crap 800g

x782
Livrare imediată!

21,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 05, 64-80453, Lingurite Pastrav, Lingurite Pastrav FL., FL.
MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 40CM CU FLOATOARE

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 40CM CU FLOATOARE

6427559061025
Livrare imediată!

69,00Lei

Mulineta FL SF 2000

Mulineta FL SF 2000

3262199005946
Livrare imediată!

89,90Lei

Lanseta FL Eternity Tele Carp 3.90M

Lanseta FL Eternity Tele Carp 3.90M

5153171225965
Livrare imediată!

149,90Lei

LANSETA SPINNING PRO FL MURROW 2.08M 0.2-6G

LANSETA SPINNING PRO FL MURROW 2.08M 0.2-6G

64-4104
Livrare imediată!

143,89Lei

Maner Minciog FL Strategist 180K 1 Segment 1.80M

Maner Minciog FL Strategist 180K 1 Segment 1.80M

3153211821333
Livrare imediată!

132,90Lei

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 266

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 266

fl504-floating-1.5m-40mm-5.5g-266
Livrare imediată!

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.23MM, 150M, 34KG, 64-4540, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder FL., Fire FL., Textile FL., Monofilament FL., Feeder FL., FL.
Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 18

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 18

fl601-sinking-deepwater-70mm-16.0g-18
Livrare imediată!

17,10Lei

Montura, FL, Leadcore, Plumb, Pierdut, Long, Cast, Plumb, 100, Gr, Carlig, YN, Nr, 6, 64-0161, Monturi Crap, Monturi Crap FL., FL.
Mulineta FL Sparkler Feeder 2021 1000

Mulineta FL Sparkler Feeder 2021 1000

64-0963
Livrare imediată!

77,60Lei

CILINDRi PENTRU SPUMA ZIG RIG PRO FL LIQUID BOOSTER ORANGE/TRANSPARENT

CILINDRi PENTRU SPUMA ZIG RIG PRO FL LIQUID BOOSTER ORANGE/TRANSPARENT

64-65955
Livrare imediată!

11,90Lei

Afişare 141 - 160 din 1618 (81 pagini)
Queries: 7, Total time: 91.039 ms [By time] [By id] [By file]
1 (0.169)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7d1609e5b92f6bf712da29501'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.132)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.494)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (54.853)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.143)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38