Salmo


Vobler SALMO New Butcher Colours, 5cm, 7g, White Flash Yellow, Sinking,1buc/pac

Vobler SALMO New Butcher Colours, 5cm, 7g, White Flash Yellow, Sinking,1buc/pac

QBU043
Livrare 7-14 zile

46,76Lei

Vobler Perch 12 Floating Yellow Red Tiger 12cm, 36g

Vobler Perch 12 Floating Yellow Red Tiger 12cm, 36g

qph137
Livrare 7-14 zile

81,86Lei

Vobler SALMO Fatso, Sinking, Silver Halo, 10cm, 52g

Vobler SALMO Fatso, Sinking, Silver Halo, 10cm, 52g

qfa120
Livrare 7-14 zile

72,86Lei

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

qfa113
Livrare imediată!

63,86Lei

Vobler Salmo Rattlin Slider Sinking Red Wake 8cm 20g

Vobler Salmo Rattlin Slider Sinking Red Wake 8cm 20g

qrn019
Livrare imediată!

74,21Lei

Vobler Salmo Fatso Floating, Spotted Brown Perch, 8cm, 52g

Vobler Salmo Fatso Floating, Spotted Brown Perch, 8cm, 52g

qfa088
Livrare imediată!

63,86Lei

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Browny, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Browny, 1buc/pac

QEX176
Livrare 7-14 zile

55,93Lei

Jacheta Salmo Soft Shell Marime XL

Jacheta Salmo Soft Shell Marime XL

qpr030
Livrare imediată!

351,85Lei

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 12cm

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 12cm

qfa114
Livrare imediată!

81,86Lei

Vobler Salmo Perch 8 Floating, Holo Dark Green Head, 8cm, 12g

Vobler Salmo Perch 8 Floating, Holo Dark Green Head, 8cm, 12g

qph132
Livrare 7-14 zile

54,86Lei

Vobler SALMO Fatso, Floating, Silver Halo, 8cm, 21g

Vobler SALMO Fatso, Floating, Silver Halo, 8cm, 21g

qfa125
Livrare imediată!

63,86Lei

Vobler Salmo Hornet 9 Floating, Holo Smelt, 9cm, 36g

Vobler Salmo Hornet 9 Floating, Holo Smelt, 9cm, 36g

qht1116
Livrare imediată!

80,96Lei

Vobler SALMO Fatso, Sinking, Holo Tiger, 8cm, 25g

Vobler SALMO Fatso, Sinking, Holo Tiger, 8cm, 25g

qfa116
Livrare 7-14 zile

63,86Lei

Vobler SALMO Fatso, Sinking, Emerald Perch, 12cm, 71g

Vobler SALMO Fatso, Sinking, Emerald Perch, 12cm, 71g

qfa110
Livrare 7-14 zile

81,86Lei

Vobler SALMO New Executor Shallow Runner Colours, 12cm, 33g, Chartreuse, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 12cm, 33g, Chartreuse, 1buc/pac

QEX181
Livrare 7-14 zile

72,00Lei

Vobler Salmo Executor Shallow Runner Holographic Golden Back 7cm 8g

Vobler Salmo Executor Shallow Runner Holographic Golden Back 7cm 8g

qex102
Livrare 7-14 zile

54,86Lei

Vobler Salmo Fatso Floating, Bleeding Blue Shad, 8cm, 52g

Vobler Salmo Fatso Floating, Bleeding Blue Shad, 8cm, 52g

qfa090
Livrare imediată!

62,96Lei

Vobler SALMO Tiny, Sinking, White Bait, 3cm, 2.5g

Vobler SALMO Tiny, Sinking, White Bait, 3cm, 2.5g

qit046
Livrare 7-14 zile

45,86Lei

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, Mad Pike, 1buc/pac

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, Mad Pike, 1buc/pac

QIF012
Livrare 7-14 zile

55,93Lei

Mulineta Salmo S2000

Mulineta Salmo S2000

qrl001
Livrare imediată!

360,86Lei

Afişare 1 - 20 din 812 (41 pagini)
Queries: 7, Total time: 89.002 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = 'bdb32c47dc95b784a0a7045796'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.605)
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 = '3' AND p.manufacturer_id = '185'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (46.791)
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 = '3' AND p.manufacturer_id = '185' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.103)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37