Owner

Owner

Sortare după:

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

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

1175304

Livrare 48-72 ore

27,87Lei

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Motor Oil

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Motor Oil

8290619

Livrare imediată!

16,55Lei

Carlig Owner 5123 No.2 Baitholder Hook Red

Carlig Owner 5123 No.2 Baitholder Hook Red

5123093

Livrare 48-72 ore

19,97Lei

Carlige Offset Owner 5139 Nr.7/0 Wide Gap Plus

Carlige Offset Owner 5139 Nr.7/0 Wide Gap Plus

5139171

Livrare imediată!

26,37Lei

JIG Owner Lestat No.1/0 2gr Jig-57 253987 White

JIG Owner Lestat No.1/0 2gr Jig-57 253987 White

122539871002

Livrare imediată!

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

Ancora Owner CF-66 No.3/0

Ancora Owner CF-66 No.3/0

12070256967-30

Livrare 48-72 ore

94,21Lei

Carlig Owner 50010 Negru Patrat cu Spin Nr 1/0 - 8buc/plic

Carlig Owner 50010 Negru Patrat cu Spin Nr 1/0 - 8buc/plic

5001002

Livrare 48-72 ore

11,58Lei

Creatura Owner Yuki Bug 85mm 08 Black Blue

Creatura Owner Yuki Bug 85mm 08 Black Blue

1301375594-08

Livrare 48-72 ore

28,83Lei

Carlig Owner 50061 Auriu Semirotund Nr 6 - 12buc/plic

Carlig Owner 50061 Auriu Semirotund Nr 6 - 12buc/plic

5006103

Livrare 48-72 ore

12,41Lei

Manusi Owner M Meshy Glove 3 Finger Cut

Manusi Owner M Meshy Glove 3 Finger Cut

810029642-m

Livrare imediată!

79,07Lei(-42%) 45,48Lei

Carlig Owner 50286 Rosu Tija Lunga Nr.16, 17buc/pac

Carlig Owner 50286 Rosu Tija Lunga Nr.16, 17buc/pac

5028613

Livrare imediată!

11,58Lei

Jig Lestat Owner 5149 No.1 1/32Oz Ultra Head Finesse Type 0.89g 5buc/plic

Jig Lestat Owner 5149 No.1 1/32Oz Ultra Head Finesse Type 0.89g 5buc/plic

1209025149901

Livrare 48-72 ore

28,37Lei

Carlig Owner 50404 Auriu Rotund Tija Scurta Nr 3 - 6buc/plic

Carlig Owner 50404 Auriu Rotund Tija Scurta Nr 3 - 6buc/plic

5040413

Livrare imediată!

11,41Lei

Ancore Owner Cultiva ST-36TN Nichel No.5 8buc

Ancore Owner Cultiva ST-36TN Nichel No.5 8buc

1399508

Livrare 48-72 ore

41,48Lei

Carlig Owner Cp 51481 Negru Rotund Nr 1/0 - 11buc/plic

Carlig Owner Cp 51481 Negru Rotund Nr 1/0 - 11buc/plic

5148103

Livrare imediată!

11,40Lei(-17%) 9,47Lei

Jig Owner Lestat 56978 No.5/0 10gr Round Jig Head 4buc/plic

Jig Owner Lestat 56978 No.5/0 10gr Round Jig Head 4buc/plic

56978510

Livrare 48-72 ore

32,57Lei

Carlige Crap Owner Carp AYA C-4 nr 4 - 7buc/plic

Carlige Crap Owner Carp AYA C-4 nr 4 - 7buc/plic

5000011

Livrare imediată!

14,77Lei

Sapca Owner Waterproof 9824 Black/Silver

Sapca Owner Waterproof 9824 Black/Silver

813029824-2

Livrare 48-72 ore

285,77Lei

Carlige Owner 50001 Albastru Tija Lunga Nr 4 - 16buc/plic

Carlige Owner 50001 Albastru Tija Lunga Nr 4 - 16buc/plic

5000104

Livrare imediată!

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

Jig Owner Amaz Nelestat 16827 JIG-827 Bend 90° Fine Wire Nr.3/0, 10buc/pac

Jig Owner Amaz Nelestat 16827 JIG-827 Bend 90° Fine Wire Nr.3/0, 10buc/pac

1209021682730

Livrare imediată!

15,65Lei

Afişare 881 - 900 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: 102.648 ms [By time] [By id] [By file]

1 (0.085)

SELECT data
FROM `oc_session`
WHERE session_id = '91a490cf1f65b55d480a29f0be'

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

2 (0.081)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.099)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'

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

4 (0.093)

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

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

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

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

7 (0.103)

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