Sert


Stoper Sert Float Stick Noirs M

Stoper Sert Float Stick Noirs M

40501sevaf1613m
Livrare imediată!

8,13Lei

Fir SERT SRT Fluorocarbon 100%, Transparent, 50m, 0.99kg, 0.12mm

Fir SERT SRT Fluorocarbon 100%, Transparent, 50m, 0.99kg, 0.12mm

111001sevfn003501250m
Livrare 48-72 ore

20,80Lei

Fir Monofilament Sert SRT Universal Invisible, 0.20mm, 2.6kg, 250m

Fir Monofilament Sert SRT Universal Invisible, 0.20mm, 2.6kg, 250m

110701sevam0103020250m
Livrare 48-72 ore

17,62Lei

Varga SERT Fish Instinct Primary Telepole, 6.00m, 6seg

Varga SERT Fish Instinct Primary Telepole, 6.00m, 6seg

10101semrn8060600-6
Livrare 48-72 ore

91,42Lei

Mulineta Sert Aka FI 601 FD, 5.2:1, 0,45 mm/135m, 1rul

Mulineta Sert Aka FI 601 FD, 5.2:1, 0,45 mm/135m, 1rul

30101seprj7708601fd
Livrare imediată!

83,84Lei

Cizme Sold Sert PVC, Marime 40-41

Cizme Sold Sert PVC, Marime 40-41

81430sevbe212440/41
Livrare 48-72 ore

148,90Lei

Fir SERT SRT Fluorocarbon 100%, Transparent, 50m, 3.53kg, 0.22mm

Fir SERT SRT Fluorocarbon 100%, Transparent, 50m, 3.53kg, 0.22mm

111001sevfn003502250m
Livrare 48-72 ore

30,94Lei

Stoper Sert Float Stick Noirs S

Stoper Sert Float Stick Noirs S

40501sevaf1613s
Livrare imediată!

8,13Lei

Mulineta Sert Cu Fir AKA Efi 401FD

Mulineta Sert Cu Fir AKA Efi 401FD

30101seprl7708401fd
Livrare imediată!

79,26Lei

Agrafa Sert Americana Dubla, Nr.00, 9kg, 10buc/plic

Agrafa Sert Americana Dubla, Nr.00, 9kg, 10buc/plic

401sevaf1654000
Livrare 48-72 ore

10,09Lei

Fir Textil Sert Srt 4X, Moss Green, 10kg, 0.18mm, 135m

Fir Textil Sert Srt 4X, Moss Green, 10kg, 0.18mm, 135m

110801sevam0119018135m
Livrare imediată!

25,60Lei

Cutie Momeala Sert 85, Green

Cutie Momeala Sert 85, Green

90901sevaf064785
Livrare 48-72 ore

7,76Lei

Fir Textil Sert Srt 8X, Fluo Yellow, 11.36kg, 0.20mm, 135m

Fir Textil Sert Srt 8X, Fluo Yellow, 11.36kg, 0.20mm, 135m

110801sevam0122020135m
Livrare imediată!

39,43Lei

Lanseta Sert Fish Instinct FW20 Telespin 2.40m 20-50gr 6seg

Lanseta Sert Fish Instinct FW20 Telespin 2.40m 20-50gr 6seg

20401seprh8018240-6
Livrare imediată!

60,95Lei

Fir Textil Sert Srt 4X, Fluo Yellow, 9.09kg, 0.16mm, 135m

Fir Textil Sert Srt 4X, Fluo Yellow, 9.09kg, 0.16mm, 135m

110801sevam0120016135m
Livrare imediată!

25,60Lei

Fir Textil Sert Srt 4X, Moss Green, 5.45kg, 0.10mm, 135m

Fir Textil Sert Srt 4X, Moss Green, 5.45kg, 0.10mm, 135m

110801sevam0119010135m
Livrare imediată!

25,60Lei

Minciog Telescopic Sert Promo, 1.50m, 40x40cm

Minciog Telescopic Sert Promo, 1.50m, 40x40cm

50101epst0240152
Livrare 48-72 ore

52,70Lei

Mulineta Sert Aka FI 401 FD

Mulineta Sert Aka FI 401 FD

30201seprj7708401fd
Livrare imediată!

74,71Lei

Fir Textil Sert Srt 8X, Fluo Yellow, 7.27kg, 0.12mm, 135m

Fir Textil Sert Srt 8X, Fluo Yellow, 7.27kg, 0.12mm, 135m

110801sevam0122012135m
Livrare imediată!

39,43Lei

Fir Monofilament SERT SRT Special Feeder Black, 3.60kg, 0.25mm, 150m

Fir Monofilament SERT SRT Special Feeder Black, 3.60kg, 0.25mm, 150m

110701sevam0752025150m
Livrare imediată!

18,27Lei

Afişare 41 - 60 din 103 (6 pagini)
Queries: 7, Total time: 76.350 ms [By time] [By id] [By file]
1 (0.198)
SELECT data
FROM `oc_session`
WHERE session_id = '1c89f3792aac2f34be51ed1b5c'
/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.142)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sert'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.138)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '18' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.781)
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 = '18'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (38.800)
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 = '18' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.181)
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