Owner


Carlig Owner Furansu 50560 Nr 18

Carlig Owner Furansu 50560 Nr 18

5056013
Livrare 48-72 ore

11,58Lei

Carlig Owner Kiwami 53104 Nr 10

Carlig Owner Kiwami 53104 Nr 10

5310402
Livrare 48-72 ore

11,58Lei

Shad Owner Juster JRS105 105mm Watermelon

Shad Owner Juster JRS105 105mm Watermelon

801025589040
Livrare imediată!

28,06Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 53 Frog

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 53 Frog

804020084
Livrare 48-72 ore

56,56Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

804020202
Livrare imediată!

61,66Lei

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

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

8291413
Livrare imediată!

16,55Lei

Jig Lestat Owner 56978, Nr.5/0, 5g, 4buc/plic

Jig Lestat Owner 56978, Nr.5/0, 5g, 4buc/plic

56978550
Livrare 48-72 ore

26,20Lei

Shad Owner Shirasu 82585 Bait Pearl

Shad Owner Shirasu 82585 Bait Pearl

8258502
Livrare 48-72 ore

19,19Lei

Rig Feeder Owner 56930 No.8 0.22 FD 03 Q.Stop

Rig Feeder Owner 56930 No.8 0.22 FD 03 Q.Stop

5693208
Livrare 48-72 ore

19,64Lei

Offset-Jig Owner 5164 Nr.10/0-1/2 Flashy Swimmer Blade

Offset-Jig Owner 5164 Nr.10/0-1/2 Flashy Swimmer Blade

5164080
Livrare 48-72 ore

38,33Lei

Rig Feeder Owner 56931 Nr.16 0.16 FD-52 P.Band BL -21%

Rig Feeder Owner 56931 Nr.16 0.16 FD-52 P.Band BL

5693416
Livrare imediată!

14,99Lei(-21%) 11,83Lei

Rig Feeder Owner 56933 No.10 0.20 FD-61 Spear BL

Rig Feeder Owner 56933 No.10 0.20 FD-61 Spear BL

12030256933-10
Livrare 48-72 ore

20,82Lei

Carlig Owner CF-2 No.10/0

Carlig Owner CF-2 No.10/0

12100256965-100
Livrare imediată!

39,63Lei

Carlige Owner Iseama 50046, Nr.8, 12buc/plic

Carlige Owner Iseama 50046, Nr.8, 12buc/plic

5004612
Livrare 48-72 ore

11,41Lei

Shad Owner Getnet Juster Fish 89mm 12 Pro Blue

Shad Owner Getnet Juster Fish 89mm 12 Pro Blue

13013782919-12
Livrare 48-72 ore

34,59Lei

Carlig Owner 50175 Albastru Rotund Nr.6, 17buc/pac

Carlig Owner 50175 Albastru Rotund Nr.6, 17buc/pac

5017503
Livrare 48-72 ore

12,08Lei

Fir monofilament Owner Broad Carp SP 0.20mm 300m

Fir monofilament Owner Broad Carp SP 0.20mm 300m

11010256023-020
Livrare 48-72 ore

57,92Lei

Carlig Owner 50344 Negru Semirotund Nr 5 - 17buc/plic

Carlig Owner 50344 Negru Semirotund Nr 5 - 17buc/plic

5034408
Livrare imediată!

14,10Lei

Jig Lestat Owner JH-61 No.3/0 12gr Shizuka Head 3buc/plic

Jig Lestat Owner JH-61 No.3/0 12gr Shizuka Head 3buc/plic

1209371168204
Livrare 48-72 ore

26,20Lei

CARLIG OWNER 50922 Crom Patrat Nr 12 - 11buc/plic

CARLIG OWNER 50922 Crom Patrat Nr 12 - 11buc/plic

5092205
Livrare imediată!

11,58Lei

Afişare 1361 - 1380 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: 109.267 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '13a3bd16a9af0521a2647a41ce'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
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.119)
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 (40.077)
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 (68.621)
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 1360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.146)
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