Owner


Ancora Owner STX58 TN Nr.6 -26%

Ancora Owner STX58 TN Nr.6

5658059
Livrare imediată!

58,64Lei(-26%) 43,60Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.1/0, 12buc/plic -19%

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

1175110
Livrare imediată!

15,51Lei(-19%) 12,61Lei

Carlig Owner Seigo 50610 Nr.3/0

Carlig Owner Seigo 50610 Nr.3/0

5061001
Livrare 48-72 ore

12,41Lei

Carlig Owner Umi-Tanago 50061 Nr 9

Carlig Owner Umi-Tanago 50061 Nr 9

5006106
Livrare 48-72 ore

12,41Lei

Carlig Owner Sode 50282 Nr 8

Carlig Owner Sode 50282 Nr 8

5028210
Livrare 48-72 ore

11,17Lei

Carlig Owner Chika 50354 Nr 17

Carlig Owner Chika 50354 Nr 17

5035407
Livrare 48-72 ore

11,58Lei

Carlige Owner Yamame Paleta 50702, Nr.8, 17buc/plic

Carlige Owner Yamame Paleta 50702, Nr.8, 17buc/plic

5070206
Livrare 48-72 ore

11,41Lei

Carlig Owner Keiryu 56807 Nr 6

Carlig Owner Keiryu 56807 Nr 6

5680706
Livrare imediată!

11,58Lei

Shad Owner Wounded Minnow WM90 90mm Ayu

Shad Owner Wounded Minnow WM90 90mm Ayu

801025593240
Livrare 48-72 ore

24,48Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 32 Golden shiner

Vobler Owner Rip n Minnow 65mm 6.0gr 32 Golden shiner

804020307
Livrare imediată!

49,67Lei

Carlig Owner 50116 Nr.8 Kaizu

Carlig Owner 50116 Nr.8 Kaizu

5011615
Livrare imediată!

13,09Lei

Carlige Legate OWNER S363 56915 Nr.16 Fir 0.10mm Rosu

Carlige Legate OWNER S363 56915 Nr.16 Fir 0.10mm Rosu

5691503
Livrare imediată!

13,93Lei

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

56978280
Livrare imediată!

32,57Lei

Carlig Owner 5123 No 6 Baitholder Hook Red

Carlig Owner 5123 No 6 Baitholder Hook Red

5123053
Livrare imediată!

19,97Lei

Rig Feeder Owner 56930 No.14 0.18 FD 01 Spear

Rig Feeder Owner 56930 No.14 0.18 FD 01 Spear

5693014
Livrare imediată!

20,82Lei

Jig Owner Offset Beast Twistlock 5130, Nr. 8/0, 3buc/plic

Jig Owner Offset Beast Twistlock 5130, Nr. 8/0, 3buc/plic

5130181
Livrare 48-72 ore

36,83Lei

Rig Feeder Owner 56931 Nr.16 0.16 FD-51 Spear BL

Rig Feeder Owner 56931 Nr.16 0.16 FD-51 Spear BL

5693316
Livrare 48-72 ore

24,84Lei

Rig Feeder Owner 56932 No.14 0.18 FD-13 Quick Stop

Rig Feeder Owner 56932 No.14 0.18 FD-13 Quick Stop

12030256932-114
Livrare imediată!

19,64Lei

Carlig Owner CF-1 No.9/0

Carlig Owner CF-1 No.9/0

12100256964-90
Livrare 48-72 ore

42,14Lei

Carlig Owner 50044 Negru Semirotund Nr 7 - 17buc/plic

Carlig Owner 50044 Negru Semirotund Nr 7 - 17buc/plic

5004412
Livrare 48-72 ore

13,09Lei

Afişare 1221 - 1240 din 1544 (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: 98.561 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '2d0aeb5abc4180be96caca2688'
/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 = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
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 (36.103)
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 (61.867)
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 1220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.114)
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