Salmo


Vobler Salmo Slider 10,0cm/36gr 1,0/0,5m - SD10F RPH

Vobler Salmo Slider 10,0cm/36gr 1,0/0,5m - SD10F RPH

84570150
Livrare 24-48 ore

64,96Lei

Vobler Salmo Bullhead BD6S, Bullhead, 6cm, 8g -29%

Vobler Salmo Bullhead BD6S, Bullhead, 6cm, 8g

qbd007
Livrare imediată!

44,06Lei(-29%) 31,40Lei

Vobler Salmo Rattlin Sting Suspending 9cm 11g GREEN TIGER

Vobler Salmo Rattlin Sting Suspending 9cm 11g GREEN TIGER

qrs009
Livrare 7-14 zile

65,93Lei

VOBLER SALMO PERCH FLOATING, REAL ROACH, 12CM, 36G -31%

VOBLER SALMO PERCH FLOATING, REAL ROACH, 12CM, 36G

qph025
Livrare imediată!

71,96Lei(-31%) 49,71Lei

VOBLER SALMO MINNOW M7F M

VOBLER SALMO MINNOW M7F M

84427126
Livrare 24-48 ore

44,62Lei

VOBLER SALMO HORNET H3F RIP, 3.5CM, 2.2G

VOBLER SALMO HORNET H3F RIP, 3.5CM, 2.2G

84413194
Livrare 24-48 ore

42,59Lei

VOBLER SALMO TINY IT3S HGS, 3CM, 2.5G

VOBLER SALMO TINY IT3S HGS, 3CM, 2.5G

84503533
Livrare 24-48 ore

40,90Lei

Vobler Salmo Lil'Bug BG2F BBG

Vobler Salmo Lil'Bug BG2F BBG

84608202
Livrare 24-48 ore

39,54Lei

Vobler Salmo Minnow M7SDR 7G 7CM CMD

Vobler Salmo Minnow M7SDR 7G 7CM CMD

84427902
Livrare imediată!

43,71Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Silver Blue

Vobler Salmo Freediver Super Deep Runner 7cm culoare Silver Blue

qfd094
Livrare imediată!

59,07Lei

Vobler Salmo Minnow M7F RR 7cm 6g

Vobler Salmo Minnow M7F RR 7cm 6g

84427130
Livrare 24-48 ore

44,62Lei

Vobler Salmo Slider SD5S RR Real Roach 5cm 8.5g

Vobler Salmo Slider SD5S RR Real Roach 5cm 8.5g

qsd005
Livrare imediată!

61,36Lei

Vobler Salmo Minnow Floating 7cm 6g Olive Bleak

Vobler Salmo Minnow Floating 7cm 6g Olive Bleak

qmw161
Livrare imediată!

52,21Lei

Vobler Salmo Hornet Floating 6cm 14g Olive Hot Spot

Vobler Salmo Hornet Floating 6cm 14g Olive Hot Spot

qht948
Livrare imediată!

56,79Lei

Vobler Salmo Hornet Floating Holo Super Bleak 3.5cm, 2.2g

Vobler Salmo Hornet Floating Holo Super Bleak 3.5cm, 2.2g

qht1009
Livrare 7-14 zile

47,63Lei

Vobler Salmo Rattlin' Hornet Floating - Green Tiger, 4.5cm, 3g

Vobler Salmo Rattlin' Hornet Floating - Green Tiger, 4.5cm, 3g

qrh446
Livrare 7-14 zile

56,79Lei

Tambur de Rezerva Mulineta Salmo s3000

Tambur de Rezerva Mulineta Salmo s3000

qrl005
Livrare imediată!

70,51Lei

Vobler SALMO Hornet H9F, SMI, 9cm, 36g

Vobler SALMO Hornet H9F, SMI, 9cm, 36g

844191a2
Livrare 24-48 ore

68,11Lei

Vobler SALMO Rattlin Hornet Floating, Clear Ayu, 6.5cm, 20g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Clear Ayu, 6.5cm, 20g, 1buc/pac

qrh632
Livrare imediată!

65,03Lei

Vobler SALMO Hornet New Color, Dace Blue, 6cm, 10g

Vobler SALMO Hornet New Color, Dace Blue, 6cm, 10g

qht301
Livrare 7-14 zile

52,21Lei

Afişare 241 - 260 din 780 (39 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 88.463 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '47d2a813a242727f0a01372826'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
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
5 (38.852)
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:1699
6 (49.040)
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 = '0' AND p.manufacturer_id = '185' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.145)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37