Owner


Carlig Owner 50188 Iseama With Eye Nr.9

Carlig Owner 50188 Iseama With Eye Nr.9

5018808
Livrare imediată!

12,08Lei

Carlig Owner Spoon Spinner S-21 51572 Nr.6

Carlig Owner Spoon Spinner S-21 51572 Nr.6

5157201
Livrare 48-72 ore

12,41Lei

Ancora Owner ST11 Nr.10

Ancora Owner ST11 Nr.10

5611002
Livrare imediată!

39,46Lei

Ancora OWNER ST56 TN Nr.3/0

Ancora OWNER ST56 TN Nr.3/0

5656139
Livrare 48-72 ore

61,96Lei

Jig Lestat Owner Balancer Head 11753 JH 88 Nr.11 0.4gr

Jig Lestat Owner Balancer Head 11753 JH 88 Nr.11 0.4gr

1175301
Livrare 48-72 ore

27,87Lei

Carlig Owner Seigo BH 51440 Nr. 1

Carlig Owner Seigo BH 51440 Nr. 1

5144004
Livrare 48-72 ore

11,41Lei

Carlig Owner Aji-B 50015 Nr 6

Carlig Owner Aji-B 50015 Nr 6

5001502
Livrare 48-72 ore

11,17Lei

Carlig Owner Sode 50257 Nr 6 -12%

Carlig Owner Sode 50257 Nr 6

5025701
Livrare imediată!

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

Carlig Owner Chinta 50340 Nr 14

Carlig Owner Chinta 50340 Nr 14

5034009
Livrare imediată!

13,09Lei

Carlig Owner Izu Mezina 50673 Nr 9

Carlig Owner Izu Mezina 50673 Nr 9

5067309
Livrare imediată!

13,76Lei

Carlig Owner Spring CCN With Eye 53125 Nr 12

Carlig Owner Spring CCN With Eye 53125 Nr 12

5312506
Livrare imediată!

15,44Lei

Shad Owner Jr Minnow JRM88 88mm Purple Weenie

Shad Owner Jr Minnow JRM88 88mm Purple Weenie

801025587140
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

Afişare 1401 - 1420 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: 102.345 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = 'c1baee8fa857046aa948889a89'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.141)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.132)
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 (38.260)
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 (63.405)
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 1400,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