Owner


CARLIG OWNER 50922 Crom Patrat, Nr.8, 9buc/pac

CARLIG OWNER 50922 Crom Patrat, Nr.8, 9buc/pac

5092203
Livrare imediată!

11,58Lei

Carlig Owner 56535 No.18 Match Tournament 15buc/plic

Carlig Owner 56535 No.18 Match Tournament 15buc/plic

5653518
Livrare imediată!

13,09Lei

Carlige Owner Mutu Light Wire 5114, Nr.4, 9buc/plic -19%

Carlige Owner Mutu Light Wire 5114, Nr.4, 9buc/plic

5114005
Livrare imediată!

18,76Lei(-19%) 15,13Lei

Jig Lestat Owner 5151 No.4/0 1/16Oz Ultra Head Shanky Type

Jig Lestat Owner 5151 No.4/0 1/16Oz Ultra Head Shanky Type

1209025151014
Livrare 48-72 ore

26,87Lei

Carlige Crap Owner Iseama with Eye C-5 nr 4 10buc/pac

Carlige Crap Owner Iseama with Eye C-5 nr 4 10buc/pac

5000015
Livrare imediată!

16,12Lei

Carlige Owner 50284 Auriu Nr 6 - 13Buc/pac

Carlige Owner 50284 Auriu Nr 6 - 13Buc/pac

5028404
Livrare imediată!

12,08Lei

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.9/0, 5buc/pac

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.9/0, 5buc/pac

1210025174-191
Livrare imediată!

41,10Lei

Carlige Owner Cut Chinu 50339 Negru nr 4 - 14buc/plic

Carlige Owner Cut Chinu 50339 Negru nr 4 - 14buc/plic

5033907
Livrare imediată!

14,10Lei

Carlige Owner Sode 50286 Auriu, Nr.8, 14buc/plic -12%

Carlige Owner Sode 50286 Auriu, Nr.8, 14buc/plic

5028406
Livrare imediată!

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

SHAKY WORM 160mm (7 Buc/Pac)-01 - GREEN PUMPKIN

SHAKY WORM 160mm (7 Buc/Pac)-01 - GREEN PUMPKIN

801020010
Livrare 48-72 ore

29,29Lei

CARLIG OWNER SPOON SPINNER S-59 51580 NR10

CARLIG OWNER SPOON SPINNER S-59 51580 NR10

5158005
Livrare imediată!

11,92Lei

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

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

120502532798
Livrare 48-72 ore

19,59Lei

Vartej Agrafa Owner 52459 Nr 14 Sinker Hook W Crane

Vartej Agrafa Owner 52459 Nr 14 Sinker Hook W Crane

410020011
Livrare imediată!

29,46Lei

Carlige Legate Owner S340 Nr.10 65cm 0.14mm 56912

Carlige Legate Owner S340 Nr.10 65cm 0.14mm 56912

5691202
Livrare imediată!

13,93Lei

Carlige Legate Owner RL282 53810 Nr.14 Fir 0.14mm

Carlige Legate Owner RL282 53810 Nr.14 Fir 0.14mm

5381014
Livrare imediată!

20,82Lei

Carlig Owner 50188 Iseama With Eye Nr.8

Carlig Owner 50188 Iseama With Eye Nr.8

5018806
Livrare imediată!

12,08Lei

Carlig Owner 5180 SSW Straight Eye Nr.4

Carlig Owner 5180 SSW Straight Eye Nr.4

5180005
Livrare 48-72 ore

20,07Lei

Ancora Owner ST11 Nr.8

Ancora Owner ST11 Nr.8

5611001
Livrare imediată!

39,46Lei

Ancora Owner ST36 RD Nr.14

Ancora Owner ST36 RD Nr.14

5636028
Livrare imediată!

46,36Lei

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/16 Oz 1.8gr -22%

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/16 Oz 1.8gr

1168303
Livrare imediată!

18,90Lei(-22%) 14,65Lei

Afişare 441 - 460 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: 91.089 ms [By time] [By id] [By file]
1 (0.187)
SELECT data
FROM `oc_session`
WHERE session_id = '03026d7e524e1e72b606bc17e4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.142)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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.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 = '2' AND p.manufacturer_id = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (55.228)
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 440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.151)
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