Owner


Carlige Owner S344 56913 Legate Nr.5 Fir 0.20mm

Carlige Owner S344 56913 Legate Nr.5 Fir 0.20mm

5691304
Livrare 48-72 ore

11,75Lei

Carlige Legate Owner RL284 53817 Nr.12 fir 0.12mm

Carlige Legate Owner RL284 53817 Nr.12 fir 0.12mm

5381712
Livrare imediată!

16,96Lei

Carlig Owner 53883 Iseama Nr.10

Carlig Owner 53883 Iseama Nr.10

5388314
Livrare imediată!

12,08Lei

Carlig Owner Spoon Spinner S-35BL 51607 Nr.8

Carlig Owner Spoon Spinner S-35BL 51607 Nr.8

5160708
Livrare imediată!

11,92Lei

Ancora Owner STBL-1.56BC Nr.10

Ancora Owner STBL-1.56BC Nr.10

1163710
Livrare imediată!

40,81Lei

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

Carlig Owner 5177 No10 Mosquito Red Hook

Carlig Owner 5177 No10 Mosquito Red Hook

5177023
Livrare imediată!

12,08Lei

Rig Feeder Owner 56930 No.10 0.20 FD 02 P.Band

Rig Feeder Owner 56930 No.10 0.20 FD 02 P.Band

5693110
Livrare imediată!

19,14Lei

Afişare 1241 - 1260 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: 89.592 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '5ec86c1f3c7294200a81165683'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
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.090)
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 (34.611)
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 (54.534)
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 1240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.114)
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