Asso


33,28Lei

65,72Lei

Fir Asso Mainline Abrasion Multicolor 0.35mm 1000m

110108fnasdi276bm1000a60350
Livrare 48-72 ore

71,80Lei

18,84Lei

18,23Lei

39,62Lei

46,04Lei

Fir ASSO Ultra Soft Copper 0.20mm

604080012
Livrare 48-72 ore

21,84Lei

Fir ASSO Ultra Low Stretch Smoke 0.22mm 150m

607080015
Livrare imediată!

35,11Lei

Fir ASSO Evergreen PE 8X Verde 0.15mm 130m

608080002
Livrare 48-72 ore

100,43Lei

38,71Lei(-24%) 29,37Lei

Fir ASSO Ultra Cast Galben Fluo 0.22mm 1000m

607080031
Livrare imediată!

58,00Lei

Fir ASSO Evergreen PE 8X Verde 0.43mm 130m

608080010
Livrare imediată!

100,43Lei

Fir ASSO Ultra Low Stretch Smoke 0.12mm 50m

604080042
Livrare imediată!

13,69Lei

Fir Asso Invisilk Pink 0.18 mm 150 m

603080033
Livrare 48-72 ore

17,58Lei

62,81Lei

Fir Asso Fluorocarbon Hooklink 20m 0.306mm 6.8kg Clear

110108ffasdi138bm0020000306
Livrare 48-72 ore

33,71Lei

35,78Lei

ASSO HARD SKIN Solid Red 0.22mm 7 Lb 2650m

607080050
Livrare imediată!

84,24Lei(-25%) 62,92Lei

Fir ASSO Ultra Transparent 8.20kg 0.20mm 25g

604080066
Livrare 48-72 ore

13,54Lei

Afişare 101 - 120 din 299 (15 pagini)
Queries: 9, Total time: 142.631 ms [By time] [By id] [By file]
1 (0.158)
SELECT data
FROM `oc_session`
WHERE session_id = 'ea155d33e36c7f9665ddd3adeb'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.184)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.164)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.166)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '129' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (72.655)
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 = '129'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (61.739)
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 = '129' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (4.642)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.660)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (2.263)
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