FL.


103,60Lei

MINCIOG BARCA PRO FL CU FLOTOR SI SNUR XL

hb705595
Livrare imediată!

102,58Lei

CANTAR ELECTRONIC PRO FL 40KG

64-66979
Livrare imediată!

37,50Lei

PENAR RIGURI FEEDER PRO FL A028B

fl-a028b
Livrare imediată!

27,35Lei

25,30Lei

9,64Lei

Lanseta Pokee Strategist Carp 3.00M/3.75lbs/2Seg

4192146053708
Livrare imediată!

224,61Lei

TEASER PRO FL 180G CULOARE 04

6427559069212
Livrare imediată!

55,81Lei

VOBLER PRO FL WORM 3G 3.5CM CULOARE Yellow

64-80354
Livrare imediată!

18,17Lei

PLUMB PRO FL DISTANCE 2.5OZ 113G

64-66464
Livrare imediată!

10,06Lei

27,35Lei

94,44Lei

SET 4 SUPORTI SPATE PRO FL CULOARE FLUOROSCENTA

4732515191176
Livrare imediată!

26,32Lei

MULINETA FL SWIFT 5000 CU TOT CU FIR

3241022857945
Livrare 48-72 ore

51,74Lei

LANSETA DUNARE PRO FL AQUA RIVER 280G 2.70M

64-0183
Livrare imediată!

81,23Lei

98,51Lei

Lanseta Crap Strategist 3.90M 3.75Lbs 3Seg

8231156907208
Livrare imediată!

356,78Lei

TEASER PRO FL 180G CULOARE 02

3212242977386
Livrare imediată!

55,81Lei

Lanseta FL Aqua Tele Spin 3.6m, 15-45g

3255196901090
Livrare imediată!

200,00Lei(-39%) 122,92Lei

PLUMB PRO FL Flat Pear SWIVEL 85G

64-66495
Livrare imediată!

8,63Lei

Afişare 1661 - 1680 din 2137 (107 pagini)
Queries: 7, Total time: 170.652 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '581474dd8183e4d072c2aab306'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
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 (77.605)
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 (92.415)
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 1660,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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