Owner


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

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

410020032
Livrare imediată!

14,83Lei

Carlige Legate Owner S-560 No.10, 65cm, 0.14mm

Carlige Legate Owner S-560 No.10, 65cm, 0.14mm

5691610
Livrare imediată!

13,43Lei

Carlige Legate Owner RL340 53816 Nr.8 Fir 0.18mm

Carlige Legate Owner RL340 53816 Nr.8 Fir 0.18mm

5381608
Livrare imediată!

16,95Lei

Carlig Owner C-3 Carp Tsuyoshi Nr.8

Carlig Owner C-3 Carp Tsuyoshi Nr.8

5000027
Livrare imediată!

14,77Lei

Carlig Owner Minnow S-55BLM 51611 Nr.12 -16%

Carlig Owner Minnow S-55BLM 51611 Nr.12

5161105
Livrare imediată!

10,74Lei(-16%) 9,03Lei

ANCORA OWNER ST26 BC Nr.12

ANCORA OWNER ST26 BC Nr.12

5626003
Livrare imediată!

39,46Lei

Ancora Owner ST66 TN Nr.3/0

Ancora Owner ST66 TN Nr.3/0

5666159
Livrare 48-72 ore

84,13Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.4, 16buc/plic

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.4, 16buc/plic

1175104
Livrare 48-72 ore

19,63Lei

Carlig Owner OH SSW 5115 Nr.3/0

Carlig Owner OH SSW 5115 Nr.3/0

5115004
Livrare imediată!

15,28Lei

Carlig Owner Iseama 50057 Nr 12

Carlig Owner Iseama 50057 Nr 12

5005715
Livrare 48-72 ore

11,57Lei

Carlig Owner Chinta 50319 Nr 8 -18%

Carlig Owner Chinta 50319 Nr 8

5031908
Livrare imediată!

10,24Lei(-18%) 8,39Lei

Carlig Owner Furansu 50560 Nr 10

Carlig Owner Furansu 50560 Nr 10

5056009
Livrare 48-72 ore

7,32Lei

Carlig Owner Pint-S 53135 Nr 10

Carlig Owner Pint-S 53135 Nr 10

5313504
Livrare imediată!

11,41Lei

Shad Owner Juster JRS82 82mm Pro Blue

Shad Owner Juster JRS82 82mm Pro Blue

801025586290
Livrare imediată!

28,06Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 06 Shiner

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 06 Shiner

804020040
Livrare 48-72 ore

54,07Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 63 Alb sidef roz

Vobler Owner Bug Eye Bait 50mm 6.5gr 63 Alb sidef roz

804020208
Livrare 48-72 ore

61,66Lei

CARLIG OWNER 50098 Nr.1 Auriu Semirotund -12%

CARLIG OWNER 50098 Nr.1 Auriu Semirotund

5009803
Livrare imediată!

10,24Lei(-12%) 9,03Lei

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

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

5691502
Livrare 48-72 ore

13,93Lei

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

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

56978350
Livrare 48-72 ore

32,57Lei

Carlig Owner 5123 No 1 Baitholder Hook Red

Carlig Owner 5123 No 1 Baitholder Hook Red

5123103
Livrare imediată!

19,97Lei

Afişare 1121 - 1140 din 1548 (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: 106.857 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '07ba6e166e66b6223548926839'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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 (47.442)
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 (58.857)
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 1120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.178)
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