Owner


Carlig Owner Sirahae 50243 Nr 12

Carlig Owner Sirahae 50243 Nr 12

5024302
Livrare 48-72 ore

12,08Lei

Carlig Owner Chinta 50319 Nr 16

Carlig Owner Chinta 50319 Nr 16

5031916
Livrare 48-72 ore

11,58Lei

Carlig Owner Funa 50563 Nr 8

Carlig Owner Funa 50563 Nr 8

5056301
Livrare imediată!

12,08Lei

Carlig Owner Kiwami 53104 Nr 14

Carlig Owner Kiwami 53104 Nr 14

5310404
Livrare 48-72 ore

11,58Lei

Shad Owner Juster JRS82 82mm Watermelon

Shad Owner Juster JRS82 82mm Watermelon

801025586040
Livrare imediată!

28,06Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

804020044
Livrare 48-72 ore

54,07Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

804020211
Livrare imediată!

61,66Lei

Carlig Owner 50120 Nr.12 Kappa Style 3 16buc/plic

Carlig Owner 50120 Nr.12 Kappa Style 3 16buc/plic

5012012
Livrare imediată!

11,41Lei

Grub Single Tail Owner RB-3 15 Pearl Blue Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 15 Pearl Blue Ring Single Tail 82914 3.8cm

8291415
Livrare imediată!

16,55Lei

Carlig Owner Mosquito Hook 5177 Nr.14 12buc/plic

Carlig Owner Mosquito Hook 5177 Nr.14 12buc/plic

5177013
Livrare imediată!

12,26Lei

Shad Owner Shirasu 82585 Bait Clear

Shad Owner Shirasu 82585 Bait Clear

8258505
Livrare 48-72 ore

19,19Lei

Rig Feeder Owner 56930 No.14 0.18 FD 03 Q.Stop

Rig Feeder Owner 56930 No.14 0.18 FD 03 Q.Stop

5693214
Livrare 48-72 ore

19,64Lei

Carlig Owner 50152 Nr.12 Amano Tenkara Eye

Carlig Owner 50152 Nr.12 Amano Tenkara Eye

5015212
Livrare 48-72 ore

11,58Lei

Rig Feeder Owner 56931 Nr.12 0.20 FD-52 P.Band BL

Rig Feeder Owner 56931 Nr.12 0.20 FD-52 P.Band BL

5693412
Livrare imediată!

19,14Lei

Rig Feeder Owner 56933 No.6 0.22 FD-61 Spear BL

Rig Feeder Owner 56933 No.6 0.22 FD-61 Spear BL

12030256933-06
Livrare 48-72 ore

20,82Lei

Fir Textil Owner Kizuna X8 Broad, 5.40kg, 0.12mm, Chartreuse, 135m

Fir Textil Owner Kizuna X8 Broad, 5.40kg, 0.12mm, Chartreuse, 135m

11060256117-012
Livrare imediată!

99,60Lei

Carlig Owner 50057 Negru Semirotund Nr 1/0 - 11buc/plic

Carlig Owner 50057 Negru Semirotund Nr 1/0 - 11buc/plic

5005705
Livrare 48-72 ore

13,60Lei

Shad Owner Getnet Juster Fish 89mm 14 Purple Winnei

Shad Owner Getnet Juster Fish 89mm 14 Purple Winnei

13013782919-14
Livrare 48-72 ore

34,59Lei

Carlig Owner 50175 Albastru Rotund Nr 8 - 18buc/pac

Carlig Owner 50175 Albastru Rotund Nr 8 - 18buc/pac

5017505
Livrare imediată!

12,08Lei

Fir monofilament Owner Broad Carp SP 0.26mm 300m

Fir monofilament Owner Broad Carp SP 0.26mm 300m

11010256023-026
Livrare imediată!

73,14Lei

Afişare 181 - 200 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: 128.791 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '308311149d9cdcc46de928b41d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
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 (65.312)
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 (62.778)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.171)
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