Owner


Carlig Owner Worm 5100 Nr.1

Carlig Owner Worm 5100 Nr.1

5100006
Livrare imediată!

20,07Lei

Ancora Owner STBL-36 Nr.18, 8buc/pac

Ancora Owner STBL-36 Nr.18, 8buc/pac

1163404
Livrare 48-72 ore

29,98Lei

Jig Lestat Owner Mebaru Shot 11566 JH-82G Nr.10 1.8gr

Jig Lestat Owner Mebaru Shot 11566 JH-82G Nr.10 1.8gr

1156601
Livrare imediată!

27,03Lei

Carlig Owner Seigo BH 51440 Nr. 2

Carlig Owner Seigo BH 51440 Nr. 2

5144005
Livrare 48-72 ore

11,37Lei

Carlig Owner Aji-B 50015 Nr 8

Carlig Owner Aji-B 50015 Nr 8

5001504
Livrare imediată!

11,17Lei

Carlig Owner Sode 50257 Nr 10

Carlig Owner Sode 50257 Nr 10

5025703
Livrare 48-72 ore

11,41Lei

Carlig Owner Chika 50354 Nr 8

Carlig Owner Chika 50354 Nr 8

5035401
Livrare 48-72 ore

11,58Lei

Carlig Owner Izu Mezina 50673 Nr 12

Carlig Owner Izu Mezina 50673 Nr 12

5067312
Livrare 48-72 ore

13,76Lei

Carlig Owner Chika 53938 Nr 16 -12%

Carlig Owner Chika 53938 Nr 16

5393805
Livrare imediată!

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

Shad Owner Jr Minnow JRM88 88mm Blue Gill

Shad Owner Jr Minnow JRM88 88mm Blue Gill

801025587110
Livrare 48-72 ore

25,88Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 53 Frog

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 53 Frog

804020084
Livrare 48-72 ore

56,56Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

804020202
Livrare imediată!

61,66Lei

Struna Owner Nr.3 30lb 50cm Nr.8 Pro Wire Rig 50QS

Struna Owner Nr.3 30lb 50cm Nr.8 Pro Wire Rig 50QS

402538293
Livrare imediată!

20,03Lei

Rig Crap Owner 56992 Nr.2 25Lb Linealigner Rig -21%

Rig Crap Owner 56992 Nr.2 25Lb Linealigner Rig

5699202
Livrare imediată!

12,02Lei(-21%) 9,53Lei

Jig Owner Lestat 11751 Nr. 4 4 gr. Jig 28 BC -13%

Jig Owner Lestat 11751 Nr. 4 4 gr. Jig 28 BC

117510404
Livrare imediată!

15,00Lei(-13%) 13,10Lei

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Smoke Ring

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Smoke Ring

8290516
Livrare 48-72 ore

16,55Lei

Fir Owner Broad Silver Eye 0.18 mm 150 m

Fir Owner Broad Silver Eye 0.18 mm 150 m

6025611318
Livrare 48-72 ore

42,08Lei

Carlig Owner 50571 Nr.8 Hera Buna BL

Carlig Owner 50571 Nr.8 Hera Buna BL

5057108
Livrare imediată!

11,41Lei

JIG Owner Nelestat No.5/0 Jig-57 253987 White 8buc

JIG Owner Nelestat No.5/0 Jig-57 253987 White 8buc

122539870050
Livrare imediată!

21,50Lei

Rig Feeder Owner 56933 No.6 0.22 FD-63 Quick Stop BL

Rig Feeder Owner 56933 No.6 0.22 FD-63 Quick Stop BL

12030256933-106
Livrare 48-72 ore

23,34Lei

Afişare 1081 - 1100 din 1548 (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: 124.096 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = '07ba6e166e66b6223548926839'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.143)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (62.589)
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 = '3' AND p.manufacturer_id = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (60.941)
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 = '3' AND p.manufacturer_id = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1080,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.128)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37