Salmo


VOBLER SALMO MINNOW M9F GT 9CM/10G

VOBLER SALMO MINNOW M9F GT 9CM/10G

84429116
Livrare 24-48 ore

47,67Lei

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

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

qbd008
Livrare imediată!

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

VOBLER SALMO SLIDER SD5F GER 5cm 6.5gr

VOBLER SALMO SLIDER SD5F GER 5cm 6.5gr

84575a22
Livrare 24-48 ore

45,64Lei

Vobler Salmo Rattlin Hornet Floating Ghost Perch 3.5cm 3.1g

Vobler Salmo Rattlin Hornet Floating Ghost Perch 3.5cm 3.1g

qrh512
Livrare imediată!

56,79Lei

Vobler Salmo Hornet Floating Holo Super Bleak 5cm, 7g

Vobler Salmo Hornet Floating Holo Super Bleak 5cm, 7g

qht1021
Livrare 7-14 zile

52,21Lei

Vobler Salmo Rattlin' Hornet Floating - Real Cockchafer, 3.5cm, 5.5g

Vobler Salmo Rattlin' Hornet Floating - Real Cockchafer, 3.5cm, 5.5g

qrh450
Livrare 7-14 zile

56,79Lei

Vobler Salmo Slider 16S Limited Edition Gold Back 16cm

Vobler Salmo Slider 16S Limited Edition Gold Back 16cm

qsd426
Livrare 7-14 zile

184,90Lei

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

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

qsd442
Livrare imediată!

79,65Lei

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

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

844195l1
Livrare 24-48 ore

79,88Lei

Vobler SALMO Rattlin Hornet Floating, Natural Perch, 4.5cm, 6g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Natural Perch, 4.5cm, 6g, 1buc/pac

qrh629
Livrare imediată!

55,87Lei

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

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

qht212
Livrare 7-14 zile

47,63Lei

Vobler MIKADO Mft Jerk Sinking, Hot Perch, 7cm, 19g, 1bac/pac

Vobler MIKADO Mft Jerk Sinking, Hot Perch, 7cm, 19g, 1bac/pac

pwmj-7-hp
Livrare 48-72 ore

48,69Lei

VOBLER SALMO HORNET 3CM F GS

VOBLER SALMO HORNET 3CM F GS

84413114
Livrare 24-48 ore

42,59Lei

Vobler Salmo PE11F, HPE, 11cm, 15g

Vobler Salmo PE11F, HPE, 11cm, 15g

84491197
Livrare 24-48 ore

56,82Lei

VOBLER SALMO TH7S SILVER FLASHY FISH Thrill 070MM Sinking

VOBLER SALMO TH7S SILVER FLASHY FISH Thrill 070MM Sinking

qth010
Livrare imediată!

55,87Lei

VOBLER SALMO MINNOW FLOATING, HOLO BLEAK, 7CM, 6G

VOBLER SALMO MINNOW FLOATING, HOLO BLEAK, 7CM, 6G

qmw024
Livrare imediată!

51,29Lei

VOBLER SALMO HORNET H6F SCW 6CM/10G

VOBLER SALMO HORNET H6F SCW 6CM/10G

84416125
Livrare 24-48 ore

48,69Lei

Vobler Salmo Hornet H2S RIP, 2.5cm, 1.5g

Vobler Salmo Hornet H2S RIP, 2.5cm, 1.5g

84412594
Livrare 24-48 ore

39,54Lei

VOBLER SALMO TINY IT3F EB, 3CM, 2G

VOBLER SALMO TINY IT3F EB, 3CM, 2G

84503101
Livrare 24-48 ore

48,69Lei

VOBLER SALMO EXECUTOR IEX5SR FLOATING GFP 5CM 5G

VOBLER SALMO EXECUTOR IEX5SR FLOATING GFP 5CM 5G

84595641
Livrare 24-48 ore

44,62Lei

Afişare 381 - 400 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: 73.745 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = 'b94cbd9d8a7b8780e00b40183d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.098)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
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 (33.538)
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 (39.663)
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 380,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.112)
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