Owner


Vartej Agrafa Owner 52459 Nr 16 Sinker Hook W Crane

Vartej Agrafa Owner 52459 Nr 16 Sinker Hook W Crane

410020012
Livrare imediată!

29,46Lei

Bride Simple Owner 52484, 2.3mm, 28buc/plic

Bride Simple Owner 52484, 2.3mm, 28buc/plic

410020030
Livrare imediată!

14,83Lei

Carlige Legate Owner S175 56920 Nr.10 fir 0.14mm

Carlige Legate Owner S175 56920 Nr.10 fir 0.14mm

5692003
Livrare imediată!

10,74Lei

Carlige Legate Owner RL328 53819 Nr.7 Fir 0.22mm

Carlige Legate Owner RL328 53819 Nr.7 Fir 0.22mm

5381907
Livrare 48-72 ore

19,48Lei

Carlig Owner 50367 Cut Chinu Nr.2

Carlig Owner 50367 Cut Chinu Nr.2

5036705
Livrare 48-72 ore

14,10Lei

Carlig Owner Minnow S-55BLM 51611 Nr.8

Carlig Owner Minnow S-55BLM 51611 Nr.8

5161103
Livrare imediată!

12,41Lei

ANCORA OWNER ST26 BC Nr.8

ANCORA OWNER ST26 BC Nr.8

5626001
Livrare 48-72 ore

35,27Lei

Ancora Owner ST66 TN Nr.5/0

Ancora Owner ST66 TN Nr.5/0

5666139
Livrare imediată!

99,60Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.1, 15buc/plic -20%

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.1, 15buc/plic

1175101
Livrare imediată!

20,09Lei(-20%) 16,15Lei

Carlig Owner OH SSW 5115 Nr.6/0

Carlig Owner OH SSW 5115 Nr.6/0

5115001
Livrare imediată!

16,27Lei

Carlig Owner Iseama 50046 Nr 12

Carlig Owner Iseama 50046 Nr 12

5004614
Livrare imediată!

12,41Lei

Carlig Owner Chinta 50319 Nr 4 -12%

Carlig Owner Chinta 50319 Nr 4

5031904
Livrare imediată!

8,29Lei(-12%) 7,32Lei

Carlig Owner Furansu 50560 Nr 6

Carlig Owner Furansu 50560 Nr 6

5056006
Livrare 48-72 ore

11,58Lei

Carlig Owner Pint-S 53135 Nr 4

Carlig Owner Pint-S 53135 Nr 4

5313501
Livrare 48-72 ore

11,37Lei

Shad Owner Juster JRS82 82mm Watermelon

Shad Owner Juster JRS82 82mm Watermelon

801025586040
Livrare imediată!

28,06Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

804020044
Livrare 48-72 ore

54,07Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

804020211
Livrare imediată!

61,66Lei

Carlig Owner 50120 Nr.12 Kappa Style 3 16buc/plic

Carlig Owner 50120 Nr.12 Kappa Style 3 16buc/plic

5012012
Livrare imediată!

11,41Lei

Carlige Legate Owner RL-282 Nr.18 70cm 0.12mm

Carlige Legate Owner RL-282 Nr.18 70cm 0.12mm

5381018
Livrare 48-72 ore

20,82Lei

Jig Owner Lestat 56978 Nr.1 5.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.1 5.00gr Round Jig Head

56978150
Livrare imediată!

32,57Lei

Afişare 301 - 320 din 1550 (78 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: 90.213 ms [By time] [By id] [By file]
1 (0.191)
SELECT data
FROM `oc_session`
WHERE session_id = 'de6379f381b9ca5ef64f59607d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
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 = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.092)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '15' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.812)
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 = '2' AND p.manufacturer_id = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (53.839)
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 = '2' AND p.manufacturer_id = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 300,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.102)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37