Owner


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

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

1399502
Livrare 48-72 ore

41,48Lei

Carlig Owner 53883 Negru Crom Rotund Nr 3 - 11buc/plic

Carlig Owner 53883 Negru Crom Rotund Nr 3 - 11buc/plic

5388308
Livrare imediată!

12,08Lei

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

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

56978318
Livrare 48-72 ore

32,57Lei

Carlig Owner Cps 5106 Negru Nr 1 - 7buc/plic

Carlig Owner Cps 5106 Negru Nr 1 - 7buc/plic

5106002
Livrare 48-72 ore

17,23Lei

Manusi Game Owner 9918 Jigging Casting Black XL

Manusi Game Owner 9918 Jigging Casting Black XL

810029918-440
Livrare 48-72 ore

186,98Lei

Carlige Crap Owner Tsuyoshi CT-3 Teflonate nr 6 8buc/plic

Carlige Crap Owner Tsuyoshi CT-3 Teflonate nr 6 8buc/plic

5000035
Livrare imediată!

19,48Lei

Carlige Owner 50284 Auriu Nr 14 - 17Buc/pac

Carlige Owner 50284 Auriu Nr 14 - 17Buc/pac

5028411
Livrare imediată!

12,08Lei

Fir Textil Owner Kizuna X8 Broad, Green In the Dark, 0.19mm, 11.9kg, 135m

Fir Textil Owner Kizuna X8 Broad, Green In the Dark, 0.19mm, 11.9kg, 135m

11080256118-019
Livrare 48-72 ore

105,67Lei

Carlige Owner Cut Gure 50330, Auriu, Nr.1, 8buc/plic -39%

Carlige Owner Cut Gure 50330, Auriu, Nr.1, 8buc/plic

5033007
Livrare imediată!

12,87Lei(-39%) 7,79Lei

Carlige Crap Owner AYA CT-4 nr 8 9buc/plic

Carlige Crap Owner AYA CT-4 nr 8 9buc/plic

5000050
Livrare imediată!

20,90Lei

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

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

12010256537-08
Livrare 48-72 ore

11,11Lei

BUG EYE BAIT FLOATING 50mm 6,5gr ORANGE TIGER

BUG EYE BAIT FLOATING 50mm 6,5gr ORANGE TIGER

804020203
Livrare imediată!

39,33Lei

Vartej Owner Rolling Dublu W Crane 52457, No.22, 5.2kg, 12buc/plic -22%

Vartej Owner Rolling Dublu W Crane 52457, No.22, 5.2kg, 12buc/plic

410020006
Livrare imediată!

23,40Lei(-22%) 18,17Lei

Carlige OWNER CM-10 Carp Master Zigrig Magic Fusso, Nr.2, 8buc/pac

Carlige OWNER CM-10 Carp Master Zigrig Magic Fusso, Nr.2, 8buc/pac

120502567182
Livrare 48-72 ore

19,59Lei

Vartej Owner 52481 Nr 10 Crane Swivel

Vartej Owner 52481 Nr 10 Crane Swivel

410020021
Livrare 48-72 ore

18,27Lei

Inele Despicate Owner 52811 Nr 1 Split Ring Regular

Inele Despicate Owner 52811 Nr 1 Split Ring Regular

410020060
Livrare imediată!

18,27Lei

Carlige Legate Owner S-560 No.14, 65cm, 0.16mm

Carlige Legate Owner S-560 No.14, 65cm, 0.16mm

5691614
Livrare imediată!

13,43Lei

Carlige Legate Owner RL340 53816 Nr.10 Fir 0.12mm

Carlige Legate Owner RL340 53816 Nr.10 Fir 0.12mm

5381610
Livrare imediată!

16,95Lei

Carlig Owner C-4 Carp Aya Nr.8

Carlig Owner C-4 Carp Aya Nr.8

5000045
Livrare 48-72 ore

14,77Lei

CARLIG OWNER MINNOW S-55M cod 51770 Nr.6

CARLIG OWNER MINNOW S-55M cod 51770 Nr.6

5177002
Livrare imediată!

11,92Lei

Afişare 1421 - 1440 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: 88.317 ms [By time] [By id] [By file]
1 (0.168)
SELECT data
FROM `oc_session`
WHERE session_id = '708cd0c9e97e6d1331700dfe30'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 (35.720)
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.937)
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 1420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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