Owner


Ancora OWNER ST56 TN Nr.4

Ancora OWNER ST56 TN Nr.4

5656079
Livrare imediată!

58,77Lei

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

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

1175150
Livrare 48-72 ore

15,58Lei

Carlige Owner Seigo 50610, Nr.6, 11buc/plic

Carlige Owner Seigo 50610, Nr.6, 11buc/plic

5061007
Livrare 48-72 ore

12,41Lei

Carlig Owner So-Chinu 50081 Nr 5

Carlig Owner So-Chinu 50081 Nr 5

5008105
Livrare 48-72 ore

11,41Lei

Carlig Owner Sode 50282 Nr 14

Carlig Owner Sode 50282 Nr 14

5028207
Livrare imediată!

11,58Lei

Carlig Owner Chika 50363 Nr 14

Carlig Owner Chika 50363 Nr 14

5036304
Livrare imediată!

11,17Lei

Carlig Owner Pint-S 50922 NR 16

Carlig Owner Pint-S 50922 NR 16

5092207
Livrare imediată!

11,58Lei

Carlig Owner Keiryu 56807 Nr 7

Carlig Owner Keiryu 56807 Nr 7

5680707
Livrare 48-72 ore

11,58Lei

Vobler Owner Shallow Runner 5227 TWO-38SR 38mm 3.5gr 22 Light Green

Vobler Owner Shallow Runner 5227 TWO-38SR 38mm 3.5gr 22 Light Green

804020023
Livrare 48-72 ore

101,86Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 16 Cooper scales

Vobler Owner Rip n Minnow 65mm 6.0gr 16 Cooper scales

804020305
Livrare 48-72 ore

49,67Lei

Carlige Owner Iseama With Eye 50188, Nr.3, 6buc/plic

Carlige Owner Iseama With Eye 50188, Nr.3, 6buc/plic

5018803
Livrare imediată!

12,08Lei

Carlige Legate OWNER S363 56915 Nr.12 Fir 0.12mm Rosu

Carlige Legate OWNER S363 56915 Nr.12 Fir 0.12mm Rosu

5691501
Livrare 48-72 ore

13,93Lei

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

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

56978380
Livrare 48-72 ore

32,57Lei

Agrafa Snap Owner 1.5 P-02 4183

Agrafa Snap Owner 1.5 P-02 4183

4024183156
Livrare imediată!

12,51Lei

Ancora Owner STX 38ZN Numarul 6

Ancora Owner STX 38ZN Numarul 6

5638055
Livrare 48-72 ore

47,69Lei

Jig Owner Nelestat 5304 No.1/0 Deep Throat Wide Gap -12%

Jig Owner Nelestat 5304 No.1/0 Deep Throat Wide Gap

1530410
Livrare 48-72 ore

15,66Lei(-12%) 13,75Lei

Carlig Owner 50168 Nr.16 Iseama BL Eye

Carlig Owner 50168 Nr.16 Iseama BL Eye

5016816
Livrare 48-72 ore

12,08Lei

Rig Feeder Owner 56932 No.12 0.20 FD-11 Spear

Rig Feeder Owner 56932 No.12 0.20 FD-11 Spear

12030256932-12
Livrare 48-72 ore

23,84Lei

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

1156608
Livrare imediată!

27,87Lei

Carlig Owner 50044 Negru Semirotund Nr 4 - 13buc/plic -32%

Carlig Owner 50044 Negru Semirotund Nr 4 - 13buc/plic

5004409
Livrare imediată!

10,24Lei(-32%) 7,01Lei

Afişare 1441 - 1460 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: 95.266 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'c1211425552edf68431139b7e8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.082)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.098)
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 = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (59.714)
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 = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.098)
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