FL.


PENAR MAGNETIC PRO FL CARP RIGS BOX A125C3

fl-a125c3
Livrare imediată!

114,78Lei

204,26Lei

LEADCORE PRO FL STEEL 100M 45LB

64-2266
Livrare imediată!

163,59Lei

FLOTOR MINCIOG PRO FL

foam
Livrare 48-72 ore

16,15Lei

25,30Lei

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

4192146053708
Livrare imediată!

224,61Lei

TEASER PRO FL 150G CULOARE 04

5212245784439
Livrare imediată!

51,74Lei

PLUMB PRO FL INLINE Square 113G

64-86761
Livrare imediată!

10,06Lei

Husa Mulineta FL Cu Snur

1231118309009
Livrare imediată!

23,07Lei

TREPIED CANTARIRE PRO FL

fl-c05
Livrare imediată!

176,81Lei

234,87Lei

CUTIE MOMEALA PRO FL CU SITA INCLUSA Medium

64-67614
Livrare imediată!

20,22Lei

50,72Lei

BANDA PELETE PRO FL Medium 100BUC

64-67256
Livrare imediată!

8,02Lei

MASA PLIABILA PRO FL MARIME XL

6237256785205
Livrare imediată!

133,08Lei

8,63Lei

Lanseta Crap Strategist 3.90M 3.75Lbs 3Seg

8231156907208
Livrare imediată!

356,78Lei

TEASER PRO FL 100G CULOARE 02

8212249221265
Livrare imediată!

49,71Lei

VOBLER PRO FL WORM 3G 3.5CM CULOARE GREEN

64-80347
Livrare imediată!

17,17Lei

PLUMB PRO FL DISTANCE 2.5OZ 70G

64-66433
Livrare imediată!

8,02Lei

Afişare 1521 - 1540 din 2139 (107 pagini)
Queries: 7, Total time: 133.011 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'b9b2426fd4553720478d6d6bc9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.124)
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 (56.386)
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 (76.029)
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 1520,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