Salmo


VOBLER SALMO MINNOW M7F T

VOBLER SALMO MINNOW M7F T

84427124
Livrare 24-48 ore

48,69Lei

VOBLER SALMO HORNET H3F OC 3.5CM/2.2G

VOBLER SALMO HORNET H3F OC 3.5CM/2.2G

84413181
Livrare 24-48 ore

42,59Lei

VOBLER SALMO TINY IT3S EB, 3CM, 2.5G

VOBLER SALMO TINY IT3S EB, 3CM, 2.5G

84503501
Livrare imediată!

47,77Lei

Vobler Salmo Executor IEX7SRF GFP

Vobler Salmo Executor IEX7SRF GFP

84597641
Livrare 24-48 ore

52,76Lei

VOBLER SALMO MINNOW M7S HBL 7CM 8G

VOBLER SALMO MINNOW M7S HBL 7CM 8G

84427575
Livrare 24-48 ore

48,69Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Purple Rain

Vobler Salmo Freediver Super Deep Runner 7cm culoare Purple Rain

qfd093
Livrare 7-14 zile

60,33Lei

Vobler Salmo Minnow M7F PH 7cm 6g

Vobler Salmo Minnow M7F PH 7cm 6g

84427120
Livrare 24-48 ore

44,62Lei

Vobler Salmo Slider SD5F GFP Gold Fluo Perch 5cm 6.5g

Vobler Salmo Slider SD5F GFP Gold Fluo Perch 5cm 6.5g

84575141
Livrare 24-48 ore

44,62Lei

Vobler Salmo Minnow Floating 7cm 6g Spirlin

Vobler Salmo Minnow Floating 7cm 6g Spirlin

qmw160
Livrare 7-14 zile

46,90Lei

Vobler Salmo Hornet Sinking 6cm 14g Olive Hot Spot

Vobler Salmo Hornet Sinking 6cm 14g Olive Hot Spot

qht947
Livrare imediată!

56,79Lei

Vobler Salmo Hornet Floating Holo Oikawa 6cm, 10g

Vobler Salmo Hornet Floating Holo Oikawa 6cm, 10g

qht1023
Livrare imediată!

56,79Lei

Vobler Salmo Sweeper Sinking Real Roach 14cm, 50g

Vobler Salmo Sweeper Sinking Real Roach 14cm, 50g

qse042
Livrare 7-14 zile

84,24Lei

Tambur de Rezerva Mulineta Salmo s2000

Tambur de Rezerva Mulineta Salmo s2000

qrl004
Livrare 7-14 zile

75,08Lei

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

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

844191a1
Livrare 24-48 ore

69,02Lei

Vobler SALMO Rattlin Hornet Floating, Natural Perch, 6.5cm, 20g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Natural Perch, 6.5cm, 20g, 1buc/pac

qrh633
Livrare imediată!

69,59Lei

Vobler SALMO Hornet New Color, Dace Blue, 5cm, 7g

Vobler SALMO Hornet New Color, Dace Blue, 5cm, 7g

qht255
Livrare imediată!

49,01Lei

Vobler SALMO Minnow Floating, Yasame Ayu, 6cm, 4g, 1buc/pac

Vobler SALMO Minnow Floating, Yasame Ayu, 6cm, 4g, 1buc/pac

qmw230
Livrare 7-14 zile

49,92Lei

VOBLER SALMO HORNET 2CM S T

VOBLER SALMO HORNET 2CM S T

84412524
Livrare 24-48 ore

45,64Lei

VOBLER SALMO SLIDER SDFS WRGS

VOBLER SALMO SLIDER SDFS WRGS

845775b1
Livrare 24-48 ore

60,89Lei

VOBLER SALMO TH7S REAL BLEAK Thrill 070MM Sinking

VOBLER SALMO TH7S REAL BLEAK Thrill 070MM Sinking

qth007
Livrare imediată!

55,87Lei

Afişare 741 - 760 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: 98.438 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'a1948796ab1be81ea26c062d04'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
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 (49.219)
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 (48.667)
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 740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
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:37