Owner


Carlig Owner Chinta 50319 Nr 6

Carlig Owner Chinta 50319 Nr 6

5031906
Livrare imediată!

11,58Lei

Carlige Owner Furansu Paleta 50560, Nr.8, 16buc/plic

Carlige Owner Furansu Paleta 50560, Nr.8, 16buc/plic

5056008
Livrare 48-72 ore

11,58Lei

Carlig Owner Pint-S 53135 Nr 8

Carlig Owner Pint-S 53135 Nr 8

5313503
Livrare 48-72 ore

11,41Lei

Shad Owner Juster JRS82 82mm Flash Bass

Shad Owner Juster JRS82 82mm Flash Bass

801025586270
Livrare imediată!

28,06Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 18 Red Head

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 18 Red Head

804020041
Livrare 48-72 ore

54,07Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 64 Alb spate auriu

Vobler Owner Bug Eye Bait 50mm 6.5gr 64 Alb spate auriu

804020209
Livrare 48-72 ore

61,66Lei

Carlig Owner 50120 Nr.10 Kappa Style 3 15buc/plic

Carlig Owner 50120 Nr.10 Kappa Style 3 15buc/plic

5012010
Livrare 48-72 ore

11,41Lei

Grub Single Tail Owner RB-3 17 Brown Blue Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 17 Brown Blue Ring Single Tail 82914 3.8cm

8291417
Livrare imediată!

16,55Lei

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

56978280
Livrare imediată!

32,57Lei

Carlig Owner 5123 No 6 Baitholder Hook Red

Carlig Owner 5123 No 6 Baitholder Hook Red

5123053
Livrare imediată!

19,97Lei

Rig Feeder Owner 56930 No.14 0.18 FD 01 Spear

Rig Feeder Owner 56930 No.14 0.18 FD 01 Spear

5693014
Livrare imediată!

20,82Lei

Jig Owner Offset Beast Twistlock 5130, Nr. 8/0, 3buc/plic

Jig Owner Offset Beast Twistlock 5130, Nr. 8/0, 3buc/plic

5130181
Livrare 48-72 ore

36,83Lei

Rig Feeder Owner 56931 Nr.16 0.16 FD-51 Spear BL

Rig Feeder Owner 56931 Nr.16 0.16 FD-51 Spear BL

5693316
Livrare 48-72 ore

24,84Lei

Rig Feeder Owner 56932 No.14 0.18 FD-13 Quick Stop

Rig Feeder Owner 56932 No.14 0.18 FD-13 Quick Stop

12030256932-114
Livrare imediată!

19,64Lei

Carlig Owner CF-1 No.9/0

Carlig Owner CF-1 No.9/0

12100256964-90
Livrare 48-72 ore

42,14Lei

Carlige Owner Iseama 50046, Nr.3, 9buc/plic -12%

Carlige Owner Iseama 50046, Nr.3, 9buc/plic

5004607
Livrare imediată!

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

Creatura Owner Getnet Juster Hog 58mm 11 Blue Gill

Creatura Owner Getnet Juster Hog 58mm 11 Blue Gill

13013782916-11
Livrare 48-72 ore

34,59Lei

Carlig Owner 50173 Negru Rotund cu Spin Nr 4 - 12buc/plic

Carlig Owner 50173 Negru Rotund cu Spin Nr 4 - 12buc/plic

5017307
Livrare imediată!

13,09Lei

Creatura Owner Getnet Juster Hog 58mm 31 Sakura Blue

Creatura Owner Getnet Juster Hog 58mm 31 Sakura Blue

13013782916-31
Livrare 48-72 ore

34,59Lei

Carlig Owner 50344 Negru Semirotund Nr 2 - 15buc/plic

Carlig Owner 50344 Negru Semirotund Nr 2 - 15buc/plic

5034405
Livrare imediată!

14,10Lei

Afişare 1401 - 1420 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: 116.019 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '9fe00ecbc06b0c1f7a9b3c3a4b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
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 (52.228)
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 (63.251)
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 1400,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.126)
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