Asso


18,23Lei

Fir Asso Mainline Master Green 0.30mm 1000m

110108fnasdi274bm10006e0310
Livrare 48-72 ore

63,28Lei

Fir Asso Knight Fluorescent Chartreuse, 300m, 0.218mm, 3.2kg

110708fnasdi291bm0300610218
Livrare imediată!

27,87Lei

57,64Lei

90,07Lei

21,11Lei

Fir ASSO Ultra Cast Galben Fluo 0.28mm 1000m

607080034
Livrare imediată!

70,69Lei

Fir ASSO Ultra Cast Verde Fluo 0.18mm 150m

603080004
Livrare imediată!

17,10Lei

Fir ASSO Ultra Low Stretch Smoke 0.18mm 50m

604080045
Livrare imediată!

14,12Lei

Fir Asso Invisilk Yellow 0.20mm 300m

602080090
Livrare 48-72 ore

32,49Lei

62,81Lei

Fir Asso Fluorocarbon Hooklink 20m 0.306mm 6.8kg Clear

110108ffasdi138bm0020000306
Livrare 48-72 ore

33,71Lei

Fir ASSO Ultra Cast Galben Fluo 0.24mm

602080001
Livrare imediată!

33,21Lei

ASSO HARD SKIN Solid Red 0.30mm 12 Lb 1430m

607080054
Livrare imediată!

61,08Lei(-25%) 45,73Lei

Fir ASSO Ultra Transparent 0.12mm 100m

604080003
Livrare 48-72 ore

22,28Lei

Fir Asso Invisilk Pink 0.16 mm 150 m

603080032
Livrare imediată!

17,46Lei

Fir Asso Ultra Cast Orange 0.20mm 1000m

110108100020
Livrare 48-72 ore

54,50Lei

Fir ASSO Ultra Cast Galben Fluo 0.22mm 150m

603080015
Livrare 48-72 ore

22,43Lei

158,45Lei

Fir ASSO Ultra Transparent 1.40kg 0.08mm 25m

604080060
Livrare 48-72 ore

13,24Lei

Afişare 101 - 120 din 302 (16 pagini)
Queries: 10, Total time: 57.663 ms [By time] [By id] [By file]
1 (0.166)
SELECT data
FROM `oc_session`
WHERE session_id = 'b49939201cb5a3463be2af60fa'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.104)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (26.429)
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 (30.262)
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 (0.155)
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.133)
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 (0.122)
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
10 (0.106)
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