Salmo


VOBLER SALMO THRILL TH5 OB 5CM/6.5G

VOBLER SALMO THRILL TH5 OB 5CM/6.5G

84535522
Livrare 24-48 ore

43,99Lei

Vobler Salmo Lil'Bug BG3F MBG

Vobler Salmo Lil'Bug BG3F MBG

84608305
Livrare imediată!

39,00Lei

VOBLER SALMO MINNOW M6F RR 6CM/4G

VOBLER SALMO MINNOW M6F RR 6CM/4G

84426130
Livrare 24-48 ore

40,00Lei

VOBLER SALMO EXECUTOR IEX7SR HSH 7CM 8G

VOBLER SALMO EXECUTOR IEX7SR HSH 7CM 8G

84597690
Livrare 24-48 ore

43,99Lei

Vobler Salmo Slider Floating 7cm/17g culoare Tench -10%

Vobler Salmo Slider Floating 7cm/17g culoare Tench

qsd346
Livrare imediată!

42,20Lei(-10%) 37,90Lei

Vobler, Salmo, Minnow, M5F, HBL, 5cm, 3g, qmw002, Voblere Floating, Voblere Floating Salmo, Salmo

Vobler, Salmo, Minnow, M5F, HBL, 5cm, 3g, qmw002, Voblere Floating, Voblere Floating Salmo, Salmo

qmw002
Livrare 7-14 zile

42,71Lei

Vobler Salmo Pike PE9SDR RPE Real Pike 9cm 10g

Vobler Salmo Pike PE9SDR RPE Real Pike 9cm 10g

84499999
Livrare 24-48 ore

45,01Lei

Vobler Salmo Executor IEX7SRF RHP 7cm 8gr

Vobler Salmo Executor IEX7SRF RHP 7cm 8gr

qex009
Livrare 7-14 zile

47,21Lei

Vobler, Salmo, Rattlin, Hornet, Floating, Ghost, Perch, 3.5cm, 3.1g, qrh512, Voblere Floating, Voblere Floating Salmo, Voblere Salmo, Floating Salmo, Salmo
Vobler, Salmo, Hornet, Floating, Holo, Super, Bleak, 4cm,, 3g, qht1015, Voblere Floating, Voblere Floating Salmo, Salmo
Vobler, Salmo, Slider, Floating, , Super, Natural, Tench, 12cm, 60g, qsd343, Voblere Floating, Voblere Floating Salmo, Salmo -20%
Vobler Slamo Slider Floating, Red Wake, 10cm, 46g

Vobler Slamo Slider Floating, Red Wake, 10cm, 46g

qsd442
Livrare imediată!

67,46Lei

Vobler, Salmo, Thrill, TH7, RBL, 84537568, Voblere Sinking, Voblere Sinking Salmo, Salmo

Vobler, Salmo, Thrill, TH7, RBL, 84537568, Voblere Sinking, Voblere Sinking Salmo, Salmo

84537568
Livrare imediată!

46,01Lei

Vobler Salmo Slider SD7S, RHPH Real Hot Perch, 7cm, 21g

Vobler Salmo Slider SD7S, RHPH Real Hot Perch, 7cm, 21g

qsd014
Livrare imediată!

60,71Lei

VOBLER, SALMO, FRISKY, 7CM, 8G, FR7SR, GT, 84347616, Voblere Floating, Voblere Floating Salmo, Salmo

VOBLER, SALMO, FRISKY, 7CM, 8G, FR7SR, GT, 84347616, Voblere Floating, Voblere Floating Salmo, Salmo

84347616
Livrare imediată!

46,01Lei

VOBLER, SALMO, MINNOW, FLOATING,, MINNOW,, 7CM,, 6G, qmw026, Voblere Floating, Voblere Floating Salmo, Salmo -38%

VOBLER, SALMO, MINNOW, FLOATING,, MINNOW,, 7CM,, 6G, qmw026, Voblere Floating, Voblere Floating Salmo, Salmo

qmw026
Livrare 7-14 zile

44,95Lei(-38%) 28,00Lei

VOBLER, SALMO, HORNET, FLOATING,, TROUT,, 5CM,, 7G, qht042, Voblere Floating, Voblere Floating Salmo, Salmo -33%

VOBLER, SALMO, HORNET, FLOATING,, TROUT,, 5CM,, 7G, qht042, Voblere Floating, Voblere Floating Salmo, Salmo

qht042
Livrare imediată!

46,31Lei(-33%) 30,90Lei

VOBLER SALMO BULLHEAD BD4F HBD 4.5CM/3.5G

VOBLER SALMO BULLHEAD BD4F HBD 4.5CM/3.5G

84434159
Livrare 24-48 ore

36,00Lei

VOBLER, SALMO, HORNET, H3S, D, 3.5CM/2.6G, 84413506, Voblere Floating, Voblere Floating Salmo, Salmo

VOBLER, SALMO, HORNET, H3S, D, 3.5CM/2.6G, 84413506, Voblere Floating, Voblere Floating Salmo, Salmo

84413506
Livrare 24-48 ore

40,00Lei

VOBLER SALMO TINY IT3S HBS, 3CM, 2.5G

VOBLER SALMO TINY IT3S HBS, 3CM, 2.5G

84503543
Livrare imediată!

38,00Lei

Afişare 101 - 120 din 724 (37 pagini)
Queries: 9, Total time: 77.516 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '4e4e540fbda88ef6e39bb3e726'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.064)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.094)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '185' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (33.675)
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 = '185'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (43.174)
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 = '185' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.103)
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