Owner


Ancora Owner ST31 Nr.8

Ancora Owner ST31 Nr.8

5631006
Livrare 48-72 ore

30,79Lei

JIG OWNER DOWN SHOT OFFSET HOOK cod 5133 NR.2/0

JIG OWNER DOWN SHOT OFFSET HOOK cod 5133 NR.2/0

5133002
Livrare 48-72 ore

15,78Lei

Jig Owner Bila 11751 Nr. 4/0 21 gr -13%

Jig Owner Bila 11751 Nr. 4/0 21 gr

117514021
Livrare imediată!

15,00Lei(-13%) 13,10Lei

Carlige Owner OH SSW 5115, Nr.4, 9buc/plic -20%

Carlige Owner OH SSW 5115, Nr.4, 9buc/plic

5115009
Livrare imediată!

12,87Lei(-20%) 10,30Lei

Carlig Owner Sirahae 50243 Nr 10

Carlig Owner Sirahae 50243 Nr 10

5024301
Livrare 48-72 ore

11,41Lei

Carlig Owner Chinta 50319 Nr 14

Carlig Owner Chinta 50319 Nr 14

5031914
Livrare imediată!

11,58Lei

Carlig Owner Funa 50563 Nr 6

Carlig Owner Funa 50563 Nr 6

5056300
Livrare 48-72 ore

12,08Lei

Carlig Owner Kiwami 53104 Nr 12

Carlig Owner Kiwami 53104 Nr 12

5310403
Livrare 48-72 ore

11,58Lei

Shad Owner Juster JRS105 105mm Koayu

Shad Owner Juster JRS105 105mm Koayu

801025589130
Livrare imediată!

28,06Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 52 Small Mouth

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 52 Small Mouth

804020083
Livrare 48-72 ore

56,56Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 01 Auriu holo

Vobler Owner Bug Eye Bait 50mm 6.5gr 01 Auriu holo

804020201
Livrare 48-72 ore

61,66Lei

Carlig Owner C-5X Nr.12 Carp Iseama X With Eye 14buc/plic

Carlig Owner C-5X Nr.12 Carp Iseama X With Eye 14buc/plic

5326912
Livrare imediată!

16,12Lei

Rig Crap Owner 56993 Nr.2 25Lb Snag Rig -40%

Rig Crap Owner 56993 Nr.2 25Lb Snag Rig

5699302
Livrare imediată!

13,87Lei(-40%) 8,31Lei

Agrafa Owner Amaz No.00 Quick Snap

Agrafa Owner Amaz No.00 Quick Snap

410260040
Livrare imediată!

9,98Lei

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Motor Oil

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Motor Oil

8290519
Livrare 48-72 ore

16,55Lei

Fir Owner Broad Silver Eye 0.18 mm 150 m

Fir Owner Broad Silver Eye 0.18 mm 150 m

6025611318
Livrare 48-72 ore

42,08Lei

Carlig Owner 50571 Nr.8 Hera Buna BL

Carlig Owner 50571 Nr.8 Hera Buna BL

5057108
Livrare imediată!

11,41Lei

JIG Owner Nelestat No.5/0 Jig-57 253987 White 8buc

JIG Owner Nelestat No.5/0 Jig-57 253987 White 8buc

122539870050
Livrare imediată!

21,50Lei

Rig Feeder Owner 56933 No.6 0.22 FD-63 Quick Stop BL

Rig Feeder Owner 56933 No.6 0.22 FD-63 Quick Stop BL

12030256933-106
Livrare 48-72 ore

23,34Lei

Carlig Owner 50281 No.12 Sode Light

Carlig Owner 50281 No.12 Sode Light

5000704
Livrare 48-72 ore

11,58Lei

Afişare 1021 - 1040 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: 104.316 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '63201fcecf170bd00f7399c88a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 (45.791)
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 (57.878)
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 1020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.139)
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