Owner

Owner

Sortare după:

Jig Lestat Cultiva JH-90 No.5 6gr Power Jig Head 4buc/plic

Jig Lestat Cultiva JH-90 No.5 6gr Power Jig Head 4buc/plic

1209371171904

Livrare 48-72 ore

27,87Lei

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.2/0 18gr Round Jig Head 4buc/plic

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

56978218

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

Jig Lestat Owner 5151 No.4/0 3/32Oz Ultra Head Shanky Type

Jig Lestat Owner 5151 No.4/0 3/32Oz Ultra Head Shanky Type

1209025151704

Livrare 48-72 ore

26,87Lei

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

Agrafa Rapida Owner Cultiva Amaz P-155 72815 Micro Silent, Nr.00, 8.9kg,15buc/pac

Agrafa Rapida Owner Cultiva Amaz P-155 72815 Micro Silent, Nr.00, 8.9kg,15buc/pac

414027281500

Livrare 48-72 ore

14,73Lei

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

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

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

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

804020203

Livrare imediată!

39,33Lei

Taparina Sabiki OWNER 5523 Silver Rainbow, Nr.12, 0.28mm, 32cm, 6buc/pac

Taparina Sabiki OWNER 5523 Silver Rainbow, Nr.12, 0.28mm, 32cm, 6buc/pac

1214025523-984

Livrare 48-72 ore

18,40Lei

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

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

410020006

Livrare imediată!

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

Carlige OWNER CM-09 Carp Master Curve Shank Magic Fusso, Nr.8, 9buc/pac

Carlige OWNER CM-09 Carp Master Curve Shank Magic Fusso, Nr.8, 9buc/pac

120502567168

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.12, 65cm, 0.12mm

Carlige Legate Owner S-560 No.12, 65cm, 0.12mm

5691612

Livrare imediată!

13,43Lei

Carlige Legate Owner RL340 53816 Nr.9 Fir 0.16mm

Carlige Legate Owner RL340 53816 Nr.9 Fir 0.16mm

5381609

Livrare imediată!

21,82Lei

Carlig Owner C-4 Carp Aya Nr.6

Carlig Owner C-4 Carp Aya Nr.6

5000044

Livrare 48-72 ore

14,77Lei

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

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

5177001

Livrare 48-72 ore

11,92Lei

Afişare 341 - 360 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: 111.259 ms [By time] [By id] [By file]

1 (0.126)

SELECT data
FROM `oc_session`
WHERE session_id = '27ce6b42e83d2e738a3a8b97d8'

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

2 (0.077)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.095)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'

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

4 (0.086)

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

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

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

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

7 (0.096)

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