FL.


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.
Baterie Pentru Pluta Chinezeasca cu Led

Baterie Pentru Pluta Chinezeasca cu Led

6218206327461
Livrare imediată!

3,80Lei

VARGA PRO FL SUPREME POLE 7.00M 40G

VARGA PRO FL SUPREME POLE 7.00M 40G

64-4093
Livrare imediată!

215,90Lei

Lanseta FL FLX10 3.96M 3.75Lbs 3Seg

Lanseta FL FLX10 3.96M 3.75Lbs 3Seg

1153210103890
Livrare imediată!

358,20Lei

Vobler, FL, FL147, Floating, 40mm, 2.1g, Depth, 0.5m, Colour, 411, fl147-floating-0.5m-40mm-2.1g-411, Voblere Floating, Voblere Floating FL., FL.
FIR, TEXTIL, SPINNING, PRO, FL, UPGRADE, PE, X8, 150M, 0.16MM, 19KG, , 64-4632, Fire Textile Rapitori, Fire Textile Rapitori FL., Fire FL., Textile FL., Rapitori FL., FL.
Vobler FL FL512 Floating 33mm 4.7g Depth 0.6-1.8m Colour 203-1

Vobler FL FL512 Floating 33mm 4.7g Depth 0.6-1.8m Colour 203-1

fl512-floating-0.6-1.8m-33mm-4.7g-203-1
Livrare imediată!

17,10Lei

CARLIGE PRO FL CURVE SHANK 10BUC TEFLONATE NR 4

CARLIGE PRO FL CURVE SHANK 10BUC TEFLONATE NR 4

64-66143
Livrare imediată!

14,90Lei

Lanseta FL FLX 1 K 3.96M 4.00Lbs 2Seg

Lanseta FL FLX 1 K 3.96M 4.00Lbs 2Seg

1315217919816
Livrare imediată!

533,10Lei

LANSETA CRAP PRO FL CARP ATTACK 3SEGMENTE 3.60M 3.5LBS

LANSETA CRAP PRO FL CARP ATTACK 3SEGMENTE 3.60M 3.5LBS

3105249471257
Livrare imediată!

94,90Lei

PULLER TOOL 3 IN 1 PRO FL TACKLE

PULLER TOOL 3 IN 1 PRO FL TACKLE

64-65740
Livrare imediată!

10,90Lei

LANSETA SPINNING PRO FL VORTEX 2 VARFURI 10-45G/10-30G 2.70M

LANSETA SPINNING PRO FL VORTEX 2 VARFURI 10-45G/10-30G 2.70M

64-198
Livrare imediată!

155,90Lei

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Specimen Nr 14 6Buc/Set

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Specimen Nr 14 6Buc/Set

64-0826
Livrare imediată!

12,38Lei

HUSA FL 2022 4 COMPARTIMENTE 135CM

HUSA FL 2022 4 COMPARTIMENTE 135CM

6552262850618
Livrare imediată!

129,90Lei

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 6

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 6

64-2806
Livrare imediată!

13,90Lei

Sac Pastrare FL Cu Catarama Material Gros 75 x 100 cm

Sac Pastrare FL Cu Catarama Material Gros 75 x 100 cm

64-2061
Livrare imediată!

69,90Lei

MONTURA, FEEDER, FL, METHOD, FARA, TIJA, 40G, CARLIG, NR, 6, SPIN, 10MM, CU, PORUMB, FLOTANT, E, M, 64-1968-40-6, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
Prastie FL Catapult Large

Prastie FL Catapult Large

4262194358756
Livrare imediată!

22,40Lei

HUSA FL 2COMPARTIMENTE 600D 1.45MT

HUSA FL 2COMPARTIMENTE 600D 1.45MT

2241022550496
Livrare imediată!

99,00Lei

Afişare 161 - 180 din 1618 (81 pagini)
Queries: 7, Total time: 91.242 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = 'b42585ee412da475a217e4854e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
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.127)
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 (35.548)
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:1667
6 (55.024)
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 = '0' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.163)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38