Tubertini


Carlige cu Vartej TUBERTINI Serie 177-BB Offshore, Nr.7/0, 20buc/pac -15%

Carlige cu Vartej TUBERTINI Serie 177-BB Offshore, Nr.7/0, 20buc/pac

43386/7
Livrare 7-14 zile

526,00Lei(-15%) 447,09Lei

Fir Monofilament TUBERTINI Predator, 18.70kg, 0.40mm, 150m

Fir Monofilament TUBERTINI Predator, 18.70kg, 0.40mm, 150m

28840
Livrare imediată!

18,68Lei

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.6/0, 20buc/pac -15%

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.6/0, 20buc/pac

4339106
Livrare 7-14 zile

473,50Lei(-15%) 402,47Lei

Lanseta TUBERTINI Akemi 7.8ft/2.38m, 1.8-3.5g, 2seg -15%

Lanseta TUBERTINI Akemi 7.8ft/2.38m, 1.8-3.5g, 2seg

04015xx
Livrare 7-14 zile

378,00Lei(-15%) 321,30Lei

Brat Suport TUBERTINI Accessory Tele Support Arm Long -15%

Brat Suport TUBERTINI Accessory Tele Support Arm Long

85066xx
Livrare 7-14 zile

260,00Lei(-15%) 220,99Lei

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.7/0, 20buc/pac -15%

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.7/0, 20buc/pac

4339107
Livrare 7-14 zile

473,50Lei(-15%) 402,47Lei

Lanseta TUBERTINI Akemi 8.6ft/2.62m, 2.0-4.0g, 2seg -15%

Lanseta TUBERTINI Akemi 8.6ft/2.62m, 2.0-4.0g, 2seg

04016xx
Livrare 7-14 zile

409,50Lei(-15%) 348,08Lei

Brat Suport TUBERTINI Accessory Tele Support Arm Short -15%

Brat Suport TUBERTINI Accessory Tele Support Arm Short

85065xx
Livrare 7-14 zile

235,00Lei(-15%) 199,75Lei

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.8/0, 20buc/pac -15%

Carlige cu Vartej TUBERTINI Serie 288 BB, Nr.8/0, 20buc/pac

4339108
Livrare 7-14 zile

473,50Lei(-15%) 402,47Lei

Carlige cu Vartej TUBERTINI Serie 177-BB Offshore, Nr.6/0, 20buc/pac -15%

Carlige cu Vartej TUBERTINI Serie 177-BB Offshore, Nr.6/0, 20buc/pac

43386/6
Livrare 7-14 zile

526,00Lei(-15%) 447,09Lei

Dop Protectie TUBERTINI Aerstop/N Cn/20, 20x26mm, 10buc/pac -15%

Dop Protectie TUBERTINI Aerstop/N Cn/20, 20x26mm, 10buc/pac

94053xx
Livrare 7-14 zile

75,01Lei(-15%) 63,75Lei

Carlige TUBERTINI Serie 2 GL, Nr.5, 25buc/pac -15%

Carlige TUBERTINI Serie 2 GL, Nr.5, 25buc/pac

4129005
Livrare 7-14 zile

39,50Lei(-15%) 33,57Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.2, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.2, 25buc/pac

4002602
Livrare 7-14 zile

36,00Lei(-15%) 30,59Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.12, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.12, 25buc/pac

4002512
Livrare 7-14 zile

24,50Lei(-15%) 20,83Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.22, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.22, 25buc/pac

4002522
Livrare 7-14 zile

24,50Lei(-15%) 20,83Lei

Carlige TUBERTINI Serie 2 GL, Nr.0, 25buc/pac -15%

Carlige TUBERTINI Serie 2 GL, Nr.0, 25buc/pac

4129000
Livrare 7-14 zile

39,50Lei(-15%) 33,57Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.3/0, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.3/0, 25buc/pac

40027/3
Livrare 7-14 zile

60,00Lei(-15%) 51,00Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.6, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.6, 25buc/pac

4002506
Livrare 7-14 zile

24,50Lei(-15%) 20,83Lei

Carlige TUBERTINI Serie 2 Special Opaco, Nr.16, 25buc/pac -15%

Carlige TUBERTINI Serie 2 Special Opaco, Nr.16, 25buc/pac

4002516
Livrare 7-14 zile

24,50Lei(-15%) 20,83Lei

Dop Protectie TUBERTINI Aerstop/N Cn/20, 20x36mm, 10buc/pac -15%

Dop Protectie TUBERTINI Aerstop/N Cn/20, 20x36mm, 10buc/pac

94055xx
Livrare 7-14 zile

117,50Lei(-15%) 99,88Lei

Afişare 1 - 20 din 49 (3 pagini)
Queries: 7, Total time: 2.491 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = 'e44f44395b7695eb72a2ede6e5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.143)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.173)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Tubertini'
/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 = '170' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.496)
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 = '3' AND p.manufacturer_id = '170'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (1.244)
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 = '3' AND p.manufacturer_id = '170' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.155)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37