Owner

Owner

Sortare după:

Fir Owner Broad Fluorine Treated 0.14mm 150m

Fir Owner Broad Fluorine Treated 0.14mm 150m

11070256045-014

Livrare 48-72 ore

46,90Lei

Carlig Owner 50057 Negru Semirotund Nr 7 - 17buc/plic

Carlig Owner 50057 Negru Semirotund Nr 7 - 17buc/plic

5005712

Livrare 48-72 ore

13,60Lei

Shad Owner Getnet Juster Fish 89mm 51 Noebi Blue

Shad Owner Getnet Juster Fish 89mm 51 Noebi Blue

13013782919-51

Livrare 48-72 ore

34,59Lei

Carlig Owner 50286 Rosu Tija Lunga Nr10 - 15buc/plic

Carlig Owner 50286 Rosu Tija Lunga Nr10 - 15buc/plic

5028608

Livrare imediată!

11,58Lei

Jig Lestat Owner JH-31 No.3/0 3/8Oz Stand Up Type 5buc/plic

Jig Lestat Owner JH-31 No.3/0 3/8Oz Stand Up Type 5buc/plic

1209025144068

Livrare imediată!

28,04Lei

Carlige Owner Chinu With Eye 50355, Nr.4, 11buc/plic

Carlige Owner Chinu With Eye 50355, Nr.4, 11buc/plic

5035507

Livrare imediată!

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

Ancore Owner Cultiva ST-36TN Nichel No.18 8buc

Ancore Owner Cultiva ST-36TN Nichel No.18 8buc

1399501

Livrare 48-72 ore

41,48Lei

Carlig Owner Cp 50674 Argintiu Patrat Nr 4 - 15buc/pac

Carlig Owner Cp 50674 Argintiu Patrat Nr 4 - 15buc/pac

5067402

Livrare 48-72 ore

14,10Lei

Jig Owner Lestat 56978 No.3/0 15gr Round Jig Head 4buc/plic

Jig Owner Lestat 56978 No.3/0 15gr Round Jig Head 4buc/plic

56978315

Livrare 48-72 ore

32,57Lei

Carlig Owner Crap Iseama CT-5 nr 4 - 10buc/plic

Carlig Owner Crap Iseama CT-5 nr 4 - 10buc/plic

5000042

Livrare 48-72 ore

19,48Lei

Manusi Game Owner 9918 Jigging Casting Black L

Manusi Game Owner 9918 Jigging Casting Black L

810029918-430

Livrare 48-72 ore

186,98Lei

Carlige Owner 50001 Albastru Tija Lunga Nr 12 - 18buc/plic

Carlige Owner 50001 Albastru Tija Lunga Nr 12 - 18buc/plic

5000112

Livrare imediată!

10,90Lei(-19%) 8,87Lei

Carlige Owner Chinu 50345, Nr.2, 9buc/plic

Carlige Owner Chinu 50345, Nr.2, 9buc/plic

5034505

Livrare imediată!

11,89Lei(-39%) 7,27Lei

Vobler Owner Mira Vibe 5288 MV-83S, 06 Shiner, 8.3cm, 19g

Vobler Owner Mira Vibe 5288 MV-83S, 06 Shiner, 8.3cm, 19g

804020076

Livrare 48-72 ore

51,00Lei

Carlige Owner Cut Gure 50330 Aurii nr 2/0 - 8buc/plic

Carlige Owner Cut Gure 50330 Aurii nr 2/0 - 8buc/plic

5033005

Livrare imediată!

14,10Lei

CARLIG OWNER 50335 Nr.3-Auriu Semirotund

CARLIG OWNER 50335 Nr.3-Auriu Semirotund

5033502

Livrare imediată!

10,74Lei(-16%) 9,03Lei

Carlig OWNER 56537 Worm BH-Round, Nr.10, 10buc/pac

Carlig OWNER 56537 Worm BH-Round, Nr.10, 10buc/pac

12010256537-10

Livrare 48-72 ore

11,11Lei

Jig Owner Rig'n Hook Negru Crom 5137 Nr.4 - 6buc/plic

Jig Owner Rig'n Hook Negru Crom 5137 Nr.4 - 6buc/plic

5137008

Livrare imediată!

19,36Lei

Carlige OWNER 5173 K-Hook, No.5/0, 5buc/pac

Carlige OWNER 5173 K-Hook, No.5/0, 5buc/pac

1210025173-151

Livrare 48-72 ore

17,67Lei

VOBLER OWNER MIRA VIBE 5288 8.3CM / 21.3GR RED HEAD

VOBLER OWNER MIRA VIBE 5288 8.3CM / 21.3GR RED HEAD

804020053

Livrare imediată!

51,00Lei

Afişare 1461 - 1480 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: 95.308 ms [By time] [By id] [By file]

1 (0.081)

SELECT data
FROM `oc_session`
WHERE session_id = '4e19f4e081452b731eb413293f'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.072)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.087)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.098)

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.136)

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 (54.728)

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 1460,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.106)

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