Sensas


AGRAFA SENSAS CULISANTA NR.20 PT MONTURI 6BUC/PLIC

AGRAFA SENSAS CULISANTA NR.20 PT MONTURI 6BUC/PLIC

a.s36935
Livrare 24-48 ore

8,27Lei

Sensas Soft Bait Gunki Tipsy-SXL 7.6cm, Ghost Stripe Perch, 4.1g, 6buc/plic

Sensas Soft Bait Gunki Tipsy-SXL 7.6cm, Ghost Stripe Perch, 4.1g, 6buc/plic

f1.spm.72838
Livrare 24-48 ore

28,01Lei

ADITIV SENSAS CONCENTRAT AROMIX CARAMEL 500ML

ADITIV SENSAS CONCENTRAT AROMIX CARAMEL 500ML

a0.s27424
Livrare imediată!

37,11Lei

Libelule Deshidratate Sensas Fouillix 33g

Libelule Deshidratate Sensas Fouillix 33g

a0.s09731
Livrare imediată!

61,28Lei

SURUB SENSAS POP-UP SCREWS CARLIG YELLOW 15BUC/PLIC

SURUB SENSAS POP-UP SCREWS CARLIG YELLOW 15BUC/PLIC

a.s48944
Livrare 24-48 ore

43,33Lei

AROMA SENSAS CONCENTRATA AROMIX TUTTI 500ML

AROMA SENSAS CONCENTRATA AROMIX TUTTI 500ML

a0.s27427
Livrare imediată!

37,11Lei

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

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

a0.s71351
Livrare imediată!

26,00Lei

CARLIG SENSAS 3311 NR.14 Nickel, 15buc/plic

CARLIG SENSAS 3311 NR.14 Nickel, 15buc/plic

a.s54521
Livrare 24-48 ore

16,33Lei

Fir Elastic Sensas Power Gum, 05mm, 10m

Fir Elastic Sensas Power Gum, 05mm, 10m

a.s37690
Livrare 24-48 ore

38,07Lei

Atractant, Spray, Sensas, Bombix, Carp, Tasty, Scopex,, 75ml, a0.s81032, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri Sensas, Sensas
AROMA SENSAS CONCENTRATA AROMIX CARP 500ML

AROMA SENSAS CONCENTRATA AROMIX CARP 500ML

a0.s00171
Livrare imediată!

32,32Lei

NADA, SENSAS, 3000, CLUB, BREMES, 1KG, a0.s10851, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, CLUB, BREMES, 1KG, a0.s10851, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s10851
Livrare imediată!

18,22Lei

Nada Sensas 3000 Method Carp Pellets 1 Kg

Nada Sensas 3000 Method Carp Pellets 1 Kg

a0.s70721
Livrare imediată!

26,00Lei

COSULET, Sensas, Fedeer, Rotund, L, 30g, a.s66634, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

COSULET, Sensas, Fedeer, Rotund, L, 30g, a.s66634, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

a.s66634
Livrare imediată!

11,20Lei

Sensas Soft Bait Gunki Tipsy-SXL 10cm, 8.7g, Marshmallow, 4buc/plic

Sensas Soft Bait Gunki Tipsy-SXL 10cm, 8.7g, Marshmallow, 4buc/plic

f1.spm.79874
Livrare 24-48 ore

25,24Lei

NADA, SENSAS, 3000, ETANG, 1KG, a0.s00701, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, ETANG, 1KG, a0.s00701, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s00701
Livrare 24-48 ore

26,00Lei

NADA, SENSAS, 3000, MREANA, 1KG, a0.s03591, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

NADA, SENSAS, 3000, MREANA, 1KG, a0.s03591, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s03591
Livrare 24-48 ore

26,00Lei

SOFT, BAIT, SENSAS, GUNKI, PEPS, DARK, WATER, KIT, II, 9CM, 4BUC/PLIC, f1.spm.32871, Shad-uri, Shad-uri Sensas, Shad-uri Sensas, Sensas
APICALE SENSAS MICRO ELITE PINK

APICALE SENSAS MICRO ELITE PINK

a.s23615
Livrare 24-48 ore

13,97Lei

Sensas Soft Bait Gunki Tipsy-S 3.8cm, Brown Paradise, 15buc/plic

Sensas Soft Bait Gunki Tipsy-S 3.8cm, Brown Paradise, 15buc/plic

f1.spm.37960
Livrare 24-48 ore

28,37Lei

Afişare 141 - 160 din 176 (9 pagini)
Queries: 7, Total time: 85.387 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '0319b8c92abcf0f8af31e723b9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.113)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sensas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (51.784)
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 = '2' AND p.manufacturer_id = '62'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (33.065)
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 = '2' AND p.manufacturer_id = '62' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.127)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38