Sensas


NADA, SENSAS, 3000, SUPER, FEEDER, LAKE, 1KG, a0.s10541, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
AROMA SENSAS CONC.AROMIX Plum 500ML

AROMA SENSAS CONC.AROMIX Plum 500ML

a0.s34703
Livrare imediată!

32,32Lei

VOPSEA SENSAS FLUO YELLOW

VOPSEA SENSAS FLUO YELLOW

a.s24631
Livrare 24-48 ore

40,06Lei

CUTIE SENSAS SOFT BAIT GUNKI TIPSY DARK WATER 6 CUL. 7.6CM/120BUC

CUTIE SENSAS SOFT BAIT GUNKI TIPSY DARK WATER 6 CUL. 7.6CM/120BUC

f1.spm31561
Livrare 24-48 ore

312,52Lei

NADA SENSAS 3000 GROS GARDONS NOIRE 1KG

NADA SENSAS 3000 GROS GARDONS NOIRE 1KG

a0.s00232
Livrare imediată!

26,00Lei

NADA SENSAS SUPER PRIMA FEEDER 1KG

NADA SENSAS SUPER PRIMA FEEDER 1KG

a0.s02381
Livrare 24-48 ore

13,81Lei

APICALE SENSAS MICRO ELITE YELLOW

APICALE SENSAS MICRO ELITE YELLOW

a.s23611
Livrare 24-48 ore

13,97Lei

Borseta Sensas P&M Eaux Source S, 35x18x16cm

Borseta Sensas P&M Eaux Source S, 35x18x16cm

a8.spm.32722
Livrare 24-48 ore

146,10Lei

Atractant Sensas Atractix 75ML

Atractant Sensas Atractix 75ML

a0.s14971
Livrare imediată!

32,32Lei

AROMA SENSAS CONC.AROMIX BREMES 500ML

AROMA SENSAS CONC.AROMIX BREMES 500ML

a0.s00571
Livrare imediată!

32,32Lei

NADA SENSAS 3000 ATTRACTIVE FEEDER 1KG

NADA SENSAS 3000 ATTRACTIVE FEEDER 1KG

a0.s11622
Livrare imediată!

23,23Lei

Lanseta Feeder Sensas White Arrow 3.60m 40-120g 3+3Seg

Lanseta Feeder Sensas White Arrow 3.60m 40-120g 3+3Seg

s.25057
Livrare 24-48 ore

533,07Lei

Conector Garbolino Con pentru Elastic + Extractor

Conector Garbolino Con pentru Elastic + Extractor

40330bung1
Livrare imediată!

12,88Lei

NADA SENSAS SUPER PRIMA CARP 6.5KG

NADA SENSAS SUPER PRIMA CARP 6.5KG

a0.s10506
Livrare 24-48 ore

71,51Lei

NADA SENSAS 3000 CLUB FEEDER 1KG

NADA SENSAS 3000 CLUB FEEDER 1KG

a0.s10881
Livrare 24-48 ore

18,22Lei

Nada, Sensas, 3000, Method, Feeder, River, 1, Kg, a0.s70801, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
COSULET, Sensas, Fedeer, Rotund, L, 60g, a.s66637, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

COSULET, Sensas, Fedeer, Rotund, L, 60g, a.s66637, Cosulete Feeder, Cosulete Feeder Sensas, Sensas

a.s66637
Livrare imediată!

12,45Lei

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

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

f1.spm.65510
Livrare 24-48 ore

20,11Lei

NADA, SENSAS, 3000, CARP, EXTRA, GROSSE, 1KG, a0.s03931, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
NADA, SENSAS, 3000, BIG, ROACH, BROWN, 1KG, a0.s10071, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
Afişare 121 - 140 din 176 (9 pagini)
Queries: 7, Total time: 56.064 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = 'a59485a1ed929437457e92af23'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sensas'
/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 = '62' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (26.527)
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 (28.907)
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.129)
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