Owner


Ancora Tipla Owner ST-36RD, Red, Nr.4, 7buc/plic -24%

Ancora Tipla Owner ST-36RD, Red, Nr.4, 7buc/plic

5636023
Livrare imediată!

39,81Lei(-24%) 30,40Lei

Jig Lestat Owner Mebaru Dama 11606 JH-83 Nr.6 3gr

Jig Lestat Owner Mebaru Dama 11606 JH-83 Nr.6 3gr

1160602
Livrare 48-72 ore

27,87Lei

Carlig Owner Seigo BH 51440 Nr. 6

Carlig Owner Seigo BH 51440 Nr. 6

5144007
Livrare 48-72 ore

11,58Lei

Carlig Owner Aji-B 50015 Nr 9

Carlig Owner Aji-B 50015 Nr 9

5001505
Livrare imediată!

11,17Lei

Carlig Owner Sode 50257 Nr 12

Carlig Owner Sode 50257 Nr 12

5025704
Livrare imediată!

11,58Lei

Carlig Owner Chika 50354 Nr 10

Carlig Owner Chika 50354 Nr 10

5035402
Livrare 48-72 ore

11,58Lei

Carlige Owner Yamame Paleta 50702, Nr.3, 14buc/plic -12%

Carlige Owner Yamame Paleta 50702, Nr.3, 14buc/plic

5070201
Livrare imediată!

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

Carlig Owner Chika 53938 Nr 18 -12%

Carlig Owner Chika 53938 Nr 18

5393806
Livrare imediată!

8,29Lei(-12%) 7,32Lei

Shad Owner Jr Minnow JRM88 88mm Koayu

Shad Owner Jr Minnow JRM88 88mm Koayu

801025587130
Livrare 48-72 ore

25,88Lei

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 15 Blue Back

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 15 Blue Back

804020103
Livrare 48-72 ore

48,51Lei

CARLIG OWNER 50355 Nr.3/0 Negru Crom cu Anou

CARLIG OWNER 50355 Nr.3/0 Negru Crom cu Anou

5035501
Livrare imediată!

12,41Lei

Carlig Owner C-5X Nr.1 Carp Iseama X With Eye 6buc/plic

Carlig Owner C-5X Nr.1 Carp Iseama X With Eye 6buc/plic

532691
Livrare 48-72 ore

16,12Lei

Carlig Owner Nr.4 Carp DRig

Carlig Owner Nr.4 Carp DRig

565594
Livrare 48-72 ore

24,32Lei

Agrafa Snap Owner 1 P-02 4183

Agrafa Snap Owner 1 P-02 4183

4024183106
Livrare 48-72 ore

12,51Lei

Ancora Owner STX 38ZN Numarul 8

Ancora Owner STX 38ZN Numarul 8

5638035
Livrare 48-72 ore

47,69Lei

Jig Owner Nelestat 5304 No.4/0 Deep Throat Wide Gap

Jig Owner Nelestat 5304 No.4/0 Deep Throat Wide Gap

1530440
Livrare 48-72 ore

25,13Lei

Carlige Owner 50152 Nr.6 Amano Tenkara Eye

Carlige Owner 50152 Nr.6 Amano Tenkara Eye

5015206
Livrare imediată!

11,58Lei

Rig Feeder Owner 56932 No.14 0.18 FD-11 Spear

Rig Feeder Owner 56932 No.14 0.18 FD-11 Spear

12030256932-14
Livrare imediată!

23,84Lei

Jig Lestat Owner JH-82R No.10 1.8gr Mebaru Shot

Jig Lestat Owner JH-82R No.10 1.8gr Mebaru Shot

1156607
Livrare imediată!

27,87Lei

Carlig Owner 50044 Negru Semirotund Nr 3- 14buc/plic

Carlig Owner 50044 Negru Semirotund Nr 3- 14buc/plic

5004408
Livrare 48-72 ore

11,41Lei

Afişare 501 - 520 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: 108.979 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'dcacbe17dfcd6929248d5d5ab6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.123)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
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 (52.258)
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 (56.144)
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 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.144)
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