FL.


SUPORT FEEDER PRO FL REAPER 23 cm

64-26505
Livrare imediată!

49,90Lei

18,90Lei

MULINETA PRO FL ULTIMATE FEEDER FD 4000

8183248367875
Livrare imediată!

175,91Lei

UNDITA CHINEZEASCA PRO FL PATRIOT 8M

4253243742695
Livrare imediată!

356,90Lei

146,70Lei

JUVELNIC ROTUND PRO FL 2.0M 7 INELE

yh40206h
Livrare imediată!

60,90Lei

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

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

17,10Lei

BRIDE PRO FL CRIMP 0.6MM 50buc/pac

64-65719
Livrare imediată!

9,90Lei

Vobler FL FL509 Floating 45mm 6.5g Depth 0.5m Colour 640

fl509-floating-0.5m-45mm-6.5g-640
Livrare imediată!

17,10Lei

TRIPOD FEEDER PRO FL 50-140CM

fl-ro129
Livrare imediată!

129,90Lei

Lanseta Spinning FL Strategist 2.40M 150G 2Segmente

4311219805000
Livrare imediată!

349,90Lei

8,90Lei

Mulineta FL Excence 2000 S

64-8057
Livrare imediată!

158,75Lei

CAP SUPORT PRO FL BUTT GRIPPER Rosu

64-25010
Livrare imediată!

17,90Lei

CARLIGE FL OCTOPUS BEAK 10BUC/PLIC MARIME 1/0

6101200501299
Livrare imediată!

7,98Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 92.017 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'a905e47415e7e26f9a1c79450a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
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.968)
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 (55.528)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.132)
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