FL.


10,90Lei

Momitor METHOD FL IN-LINE DURA FLAT XL 40G

ak-xl40
Livrare imediată!

9,90Lei

143,89Lei

23,90Lei

MULINETA PRO FL STRATEGIST FEEDER PRO RED 6000

6183244945147
Livrare imediată!

267,90Lei

UNDITA CHINEZEASCA PRO FL PATRIOT 4.5M

1253245810692
Livrare imediată!

229,90Lei

11,90Lei

Mulineta FL SF 5000

6262198935616
Livrare 48-72 ore

105,90Lei

Maner Minciog Carbon FL Toreador Telescopic 2.5M

8153219062788
Livrare 48-72 ore

100,90Lei

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

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

17,10Lei

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

fl512-floating-0.6-1.8m-33mm-4.7g-338
Livrare 48-72 ore

18,10Lei

Lanseta FL FLX30 B 3.96M 4.00Lbs 2Seg

1185213565450
Livrare 48-72 ore

467,50Lei

UNDITA PRO FL PRADO 115CM 300G 7.00M

5224246695201
Livrare imediată!

216,90Lei

Mulineta FL Team Feeder TF 5000

64-0974
Livrare 48-72 ore

140,90Lei

70,90Lei

15,51Lei

9,90Lei

SET PRO FL PVA CU TUB SI PLUNGER 37MM 7M

64-66839
Livrare imediată!

55,89Lei

8,90Lei

16,90Lei

Afişare 161 - 180 din 1960 (98 pagini)
Queries: 7, Total time: 120.065 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = 'd080c6dc4bbb352388c4622ad4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.134)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.158)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.144)
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 (49.061)
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 (70.253)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.155)
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