Owner


Carlige Legate Owner S284 56911 Nr.16 Fir 0.09mm

Carlige Legate Owner S284 56911 Nr.16 Fir 0.09mm

5691105
Livrare imediată!

13,93Lei

Carlige Legate Owner RL282 53810 Nr.8 Fir 0.22mm

Carlige Legate Owner RL282 53810 Nr.8 Fir 0.22mm

5381008
Livrare imediată!

20,82Lei

Carlig Owner 50116 Kaizu nr.7

Carlig Owner 50116 Kaizu nr.7

5011613
Livrare imediată!

13,09Lei

Carlige Owner Mutu Light Wire 5114, Nr.8, 11buc/plic

Carlige Owner Mutu Light Wire 5114, Nr.8, 11buc/plic

5114011
Livrare imediată!

20,07Lei

Carlig Owner MINNOW S-75M cod 51542 Nr.2 -19%

Carlig Owner MINNOW S-75M cod 51542 Nr.2

5164204
Livrare imediată!

11,23Lei(-19%) 9,10Lei

Ancora Owner ST36 Nr.2

Ancora Owner ST36 Nr.2

5636005
Livrare 48-72 ore

41,97Lei

Jig Owner J Hook cod 5140 Nr.5/0

Jig Owner J Hook cod 5140 Nr.5/0

5140001
Livrare imediată!

28,21Lei

Jig Owner Bila 11751 Nr. 1/0 7 gr -13%

Jig Owner Bila 11751 Nr. 1/0 7 gr

117511007
Livrare imediată!

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

Carlig Owner OH SSW 5115 Nr.8

Carlig Owner OH SSW 5115 Nr.8

5115012
Livrare 48-72 ore

14,10Lei

Carlig Owner Sirahae 50243 Nr14

Carlig Owner Sirahae 50243 Nr14

5024303
Livrare imediată!

12,08Lei

Carlig Owner Chinta 50340 Nr 2 -18%

Carlig Owner Chinta 50340 Nr 2

5034001
Livrare imediată!

10,24Lei(-18%) 8,39Lei

Carlig Owner Funa 50563 Nr 10

Carlig Owner Funa 50563 Nr 10

5056302
Livrare imediată!

12,08Lei

Carlig Owner Kiwami 53104 Nr 16

Carlig Owner Kiwami 53104 Nr 16

5310405
Livrare 48-72 ore

11,58Lei

Shad Owner Juster JRS105 105mm Flash Bass

Shad Owner Juster JRS105 105mm Flash Bass

801025589270
Livrare imediată!

28,06Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 13 Baby Bass

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 13 Baby Bass

804020081
Livrare 48-72 ore

56,56Lei

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou

5106001
Livrare 48-72 ore

20,07Lei

Carlig Owner C-5X Nr.9 Carp Iseama X With Eye 12buc/plic

Carlig Owner C-5X Nr.9 Carp Iseama X With Eye 12buc/plic

532699
Livrare imediată!

16,12Lei

Rig Crap Owner 56994 Nr.4 25Lb Bungee Rig -23%

Rig Crap Owner 56994 Nr.4 25Lb Bungee Rig

5699404
Livrare imediată!

28,91Lei(-23%) 22,25Lei

Jig Lestat Owner JH-88 No.11 0.2gr Balancer Head

Jig Lestat Owner JH-88 No.11 0.2gr Balancer Head

1175300
Livrare imediată!

27,87Lei

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Brown Blue

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Brown Blue

8290617
Livrare 48-72 ore

16,55Lei

Afişare 1181 - 1200 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: 87.080 ms [By time] [By id] [By file]
1 (0.172)
SELECT data
FROM `oc_session`
WHERE session_id = '46ce67ec7fd65586c835e684f5'
/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.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
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 (34.949)
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 (51.440)
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 1180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.143)
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