Salmo

Salmo

Sortare după:

Vobler Salmo Minnow Floating 5cm 3g Olive Bleak

Vobler Salmo Minnow Floating 5cm 3g Olive Bleak

qmw155

Livrare 7-14 zile

47,63Lei

Vobler Salmo Hornet Sinking 5cm 8g UV Purple

Vobler Salmo Hornet Sinking 5cm 8g UV Purple

qht943

Livrare imediată!

52,21Lei

Vobler Salmo Frisky Shallow Runner Floating 7cm 7g Muted Minnow

Vobler Salmo Frisky Shallow Runner Floating 7cm 7g Muted Minnow

qfy041

Livrare 7-14 zile

56,79Lei

Vobler Salmo Rattlin' Hornet Floating Hot Gill Clear 6.5cm, 20g

Vobler Salmo Rattlin' Hornet Floating Hot Gill Clear 6.5cm, 20g

qrh543

Livrare 7-14 zile

70,51Lei

Vobler Salmo Minnow 7 Floating Holo Stickleback 7cm, 6g

Vobler Salmo Minnow 7 Floating Holo Stickleback 7cm, 6g

qmw208

Livrare 7-14 zile

52,21Lei

Vobler Salmo Rattlin Hornet Shallow, Clear Holo Smelt, 4.5cm, 5.5g

Vobler Salmo Rattlin Hornet Shallow, Clear Holo Smelt, 4.5cm, 5.5g

qrh555

Livrare 7-14 zile

56,79Lei

Vobler SALMO Hornet H2S, GT, 2.5cm, 1.5g

Vobler SALMO Hornet H2S, GT, 2.5cm, 1.5g

84412516

Livrare 24-48 ore

43,60Lei

Vobler Salmo Slider Sinking, Chart, 10cm, 46g, 1buc/pac

Vobler Salmo Slider Sinking, Chart, 10cm, 46g, 1buc/pac

qsd467

Livrare imediată!

78,75Lei

Vobler SALMO Hornet New Color, Real Identity Perch, 4cm, 4g

Vobler SALMO Hornet New Color, Real Identity Perch, 4cm, 4g

qht227

Livrare 7-14 zile

47,63Lei

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

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

qmw224

Livrare 7-14 zile

49,92Lei

VOBLER SALMO HORNET 2CM S RD

VOBLER SALMO HORNET 2CM S RD

84412591

Livrare 24-48 ore

45,64Lei

Vobler Salmo Slider 5,0cm/8,5gr sink 1,0/0,5m - SD5S RHP

Vobler Salmo Slider 5,0cm/8,5gr sink 1,0/0,5m - SD5S RHP

84575589

Livrare 24-48 ore

46,65Lei

VOBLER SALMO TH5S REAL BLEAK Thrill 050MM Sinking

VOBLER SALMO TH5S REAL BLEAK Thrill 050MM Sinking

qth003

Livrare imediată!

51,29Lei

VOBLER SALMO HORNET SINKING, HGS, 5CM, 8G

VOBLER SALMO HORNET SINKING, HGS, 5CM, 8G

qht055

Livrare imediată!

51,29Lei

VOBLER SALMO SLIDER FLOATING 7CM WRPH

VOBLER SALMO SLIDER FLOATING 7CM WRPH

84577122

Livrare imediată!

59,97Lei

VOBLER SALMO FANATIC IF7F HBL, 7CM, 5G

VOBLER SALMO FANATIC IF7F HBL, 7CM, 5G

84387175

Livrare 24-48 ore

53,77Lei

VOBLER SALMO HORNET RATTLIN H4.5F GFP, 4.5CM, 6G

VOBLER SALMO HORNET RATTLIN H4.5F GFP, 4.5CM, 6G

84415041

Livrare 24-48 ore

50,72Lei

VOBLER SALMO SLIDER SD5S PA 5CM/8.5G

VOBLER SALMO SLIDER SD5S PA 5CM/8.5G

84575583

Livrare 24-48 ore

45,64Lei

VOBLER SALMO HORNET H9F GT 9CM/12G

VOBLER SALMO HORNET H9F GT 9CM/12G

84419116

Livrare 24-48 ore

77,16Lei

VOBLER SALMO EXECUTOR IEX5SR FLOATING HSH 5CM 5G

VOBLER SALMO EXECUTOR IEX5SR FLOATING HSH 5CM 5G

84595690

Livrare 24-48 ore

47,67Lei

Afişare 441 - 460 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: 91.245 ms [By time] [By id] [By file]

1 (0.097)

SELECT data
FROM `oc_session`
WHERE session_id = '5f8a15ee83ca052e980801721e'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.105)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.097)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.101)

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 (48.959)

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 (41.749)

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 440,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.137)

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