Owner


Carlig Owner Seigo BH 51440 Nr. 12

Carlig Owner Seigo BH 51440 Nr. 12

5144010
Livrare 48-72 ore

10,90Lei

Carlig Owner Aji-B 50015 Nr 12

Carlig Owner Aji-B 50015 Nr 12

5001508
Livrare 48-72 ore

12,08Lei

Carlig Owner Sode 50282 Nr 6

Carlig Owner Sode 50282 Nr 6

5028201
Livrare imediată!

11,58Lei

Carlig Owner Chika 50354 Nr 15

Carlig Owner Chika 50354 Nr 15

5035405
Livrare imediată!

11,17Lei

Carlige Owner Yamame Paleta 50702, Nr.6, 16buc/plic -12%

Carlige Owner Yamame Paleta 50702, Nr.6, 16buc/plic

5070204
Livrare imediată!

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

Carlig Owner Keiryu 56807 Nr 4

Carlig Owner Keiryu 56807 Nr 4

5680704
Livrare imediată!

11,58Lei

Shad Owner Wounded Minnow WM90 90mm Ghost

Shad Owner Wounded Minnow WM90 90mm Ghost

801025593200
Livrare 48-72 ore

24,48Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 34 G C Back H

Vobler Owner Rip n Minnow 65mm 6.0gr 34 G C Back H

804020309
Livrare imediată!

49,67Lei

Carlig Owner 50106 Nr.10 Kappa Style 2

Carlig Owner 50106 Nr.10 Kappa Style 2

5010610
Livrare 48-72 ore

11,41Lei

Rig Crap Owner 56996 Nr.6 15Lb Combi Rig

Rig Crap Owner 56996 Nr.6 15Lb Combi Rig

5699606
Livrare imediată!

21,49Lei

Jig Lestat Owner JH-89 No.8 0.5gr Mushi Head

Jig Lestat Owner JH-89 No.8 0.5gr Mushi Head

1178805
Livrare imediată!

27,87Lei

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Pearl Blue

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Pearl Blue

8290615
Livrare 48-72 ore

16,55Lei

Carlig Owner 5123 No.1/0 Baitholder Hook Red

Carlig Owner 5123 No.1/0 Baitholder Hook Red

5123113
Livrare imediată!

19,97Lei

Carlige Spinnerbait Trailer Hook Owner 11567 Nr.1/0

Carlige Spinnerbait Trailer Hook Owner 11567 Nr.1/0

1156710
Livrare imediată!

22,51Lei

Ancora Owner CF-66 No.4/0

Ancora Owner CF-66 No.4/0

12070256967-40
Livrare 48-72 ore

99,24Lei

Carlig Owner 50010 Negru Patrat cu Spin Nr 1 - 9buc/plic -19%

Carlig Owner 50010 Negru Patrat cu Spin Nr 1 - 9buc/plic

5001003
Livrare imediată!

11,89Lei(-19%) 9,60Lei

Creatura Owner Yuki Bug 85mm 12 Cinnamon Blue

Creatura Owner Yuki Bug 85mm 12 Cinnamon Blue

1301375594-12
Livrare 48-72 ore

28,83Lei

Carlig Owner 50061 Auriu Semirotund Nr 5 - 12buc/plic -12%

Carlig Owner 50061 Auriu Semirotund Nr 5 - 12buc/plic

5006102
Livrare imediată!

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

Manusi Owner L Meshy Glove 3 Finger Cut

Manusi Owner L Meshy Glove 3 Finger Cut

810029642-l
Livrare 48-72 ore

81,40Lei

Carlig Owner 50286 Rosu Tija Lunga Nr.15, 17buc/pac

Carlig Owner 50286 Rosu Tija Lunga Nr.15, 17buc/pac

5028612
Livrare imediată!

11,58Lei

Afişare 1441 - 1460 din 1544 (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: 86.589 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = 'c1baee8fa857046aa948889a89'
/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.100)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (34.868)
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 (51.213)
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 1440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.120)
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