Sensas


ATRACTANT SENSAS BOMBIX STIUCA 75ML

ATRACTANT SENSAS BOMBIX STIUCA 75ML

a0.s03623
Livrare imediată!

38,58Lei

NADA, SENSAS, 3000, BLACK, LAKE, 1KG, a0.s26112, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, BLACK, LAKE, 1KG, a0.s26112, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s26112
Livrare imediată!

26,00Lei

FIR, MONOFILAMENT, SENSAS, FEEDERTECH, MONO, 0.225MM, 4.97KG, 150M, s.04967, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Sensas, Sensas
MULINETA SENSAS P&M TITAN TRACK FV 650 5RUL 250MX0.50MM 4.5:1

MULINETA SENSAS P&M TITAN TRACK FV 650 5RUL 250MX0.50MM 4.5:1

spm.61329
Livrare imediată!

305,37Lei

Geanta Sensas P&M Eaux Source S, 25x13x23cm

Geanta Sensas P&M Eaux Source S, 25x13x23cm

a8.spm.32361
Livrare 24-48 ore

162,63Lei

NADA, SENSAS, 3000, READY, LAKE, 1,25KG, a0.s10981, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, READY, LAKE, 1,25KG, a0.s10981, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s10981
Livrare imediată!

40,92Lei

NADA, SENSAS, 3000, CLUB, ABLETTES, 1KG, a0.s10891, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, CLUB, ABLETTES, 1KG, a0.s10891, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s10891
Livrare imediată!

18,22Lei

Nada, Sensas, 3000, Method, Super, Carp, 1, Kg, a0.s71391, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
COSULET, Sensas, Fedeer, Rotund, XL, 40g, a.s66639, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

COSULET, Sensas, Fedeer, Rotund, XL, 40g, a.s66639, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

a.s66639
Livrare 24-48 ore

11,52Lei

Mulineta Sensas Specialist Gold Medal Match FV 30 7.1:1, 0.16mm/ 170m, 5+1rul

Mulineta Sensas Specialist Gold Medal Match FV 30 7.1:1, 0.16mm/ 170m, 5+1rul

spm.61401
Livrare 24-48 ore

243,49Lei

NADA SENSAS 3000 GIALLA 1KG

NADA SENSAS 3000 GIALLA 1KG

a0.s09481
Livrare 24-48 ore

26,00Lei

Apicale Sensas Ptfe Bush External Diam 2.0mm

Apicale Sensas Ptfe Bush External Diam 2.0mm

se23984
Livrare 24-48 ore

9,50Lei

Momitor, SENSAS, METHOD, FEEDER, M, 25G, a.s62677, Momitoare Method Feeder, Momitoare Method Feeder Sensas, Sensas
MOMITOR, SENSAS, METHOD, FEEDER, , S, 25G, , a.s62675, Momitoare Method Feeder, Momitoare Method Feeder Sensas, Sensas
Sensas Soft Bait Gunki Tipsy-SXL 7.6cm, Pure White, 4.1g, 6buc/plic

Sensas Soft Bait Gunki Tipsy-SXL 7.6cm, Pure White, 4.1g, 6buc/plic

f1.spm.65512
Livrare 24-48 ore

19,64Lei

ADITIV SENSAS CONCENTRAT AROMIX VANILIE 500ML

ADITIV SENSAS CONCENTRAT AROMIX VANILIE 500ML

a0.s27422
Livrare imediată!

37,11Lei

ATRACTANT SENSAS BOMBIX BIBAN 75ML

ATRACTANT SENSAS BOMBIX BIBAN 75ML

a0.s03628
Livrare imediată!

38,58Lei

VESTA SENSAS P&M PESCAR RAPITOR 50x30cm

VESTA SENSAS P&M PESCAR RAPITOR 50x30cm

a8.spm.32803
Livrare 24-48 ore

243,74Lei

AROMA SENSAS CONCENTRATA AROMIX BRASEM BELGE 500ML

AROMA SENSAS CONCENTRATA AROMIX BRASEM BELGE 500ML

a0.s27426
Livrare imediată!

37,11Lei

NADA SENSAS 3000 CLUB GROS GARDONS 1KG

NADA SENSAS 3000 CLUB GROS GARDONS 1KG

a0.s11322
Livrare imediată!

18,22Lei

Afişare 121 - 140 din 176 (9 pagini)
Queries: 7, Total time: 56.592 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '2097885ddcd260500194a3d866'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sensas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '62' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (26.540)
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 = '62'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (29.565)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '62' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38