Owner


Palarie Owner Cultiva Polyester, Maro

Palarie Owner Cultiva Polyester, Maro

811379799-9
Livrare 48-72 ore

256,94Lei

Carlig OWNER 5105 Cut Gorilla Live Bait Hook Cutting Point, Nr.7/0, 2buc/pac

Carlig OWNER 5105 Cut Gorilla Live Bait Hook Cutting Point, Nr.7/0, 2buc/pac

1210025105-171
Livrare 48-72 ore

28,46Lei

Carlig OWNER 51652 MH-11 Split Shotter Dark Green, Nr.12, 14buc/pac

Carlig OWNER 51652 MH-11 Split Shotter Dark Green, Nr.12, 14buc/pac

5165212
Livrare 48-72 ore

12,00Lei

Fir Textil OWNER Kizuna EX X8 Broad, Super Chartreuse, 0.15mm, 9.10kg, 150m

Fir Textil OWNER Kizuna EX X8 Broad, Super Chartreuse, 0.15mm, 9.10kg, 150m

1106025613215
Livrare imediată!

119,82Lei

Ancore OWNER 16625 Strong Fourth, Marimea XL, 5buc/pac

Ancore OWNER 16625 Strong Fourth, Marimea XL, 5buc/pac

12080216625-ll
Livrare 48-72 ore

32,88Lei

Protectie Deget Owner Casting Finger Guard L

Protectie Deget Owner Casting Finger Guard L

4220296493
Livrare imediată!

64,11Lei

Carlige Legate Feeder Owner FDB-03 Quick Stop Braided Nr.14, 6buc/pac

Carlige Legate Feeder Owner FDB-03 Quick Stop Braided Nr.14, 6buc/pac

12030256935-314
Livrare 48-72 ore

22,30Lei

Carlig OWNER 13189 Genki Gure, Nr.7, 19buc/pac

Carlig OWNER 13189 Genki Gure, Nr.7, 19buc/pac

12010213189-07
Livrare 48-72 ore

14,99Lei

Fir Textil OWNER Kizuna EX X8 Broad, Super Chartreuse, 0.17mm, 9.90kg, 150m

Fir Textil OWNER Kizuna EX X8 Broad, Super Chartreuse, 0.17mm, 9.90kg, 150m

1106025613217
Livrare 48-72 ore

119,82Lei

Rig Feeder Owner 56930 No.16 0.16 FD 03 Q.Stop

Rig Feeder Owner 56930 No.16 0.16 FD 03 Q.Stop

5693216
Livrare 48-72 ore

18,33Lei

Carlig Owner 50168 Nr.10 Iseama BL Eye

Carlig Owner 50168 Nr.10 Iseama BL Eye

5016810
Livrare imediată!

10,90Lei

Rig Feeder Owner 56931 Nr.8 0.22 FD-52 P.Band BL

Rig Feeder Owner 56931 Nr.8 0.22 FD-52 P.Band BL

5693408
Livrare imediată!

17,84Lei

Rig Feeder Owner 56933 No.10 0.20 FD-62 Pellet Band BL

Rig Feeder Owner 56933 No.10 0.20 FD-62 Pellet Band BL

12030256933-010
Livrare 48-72 ore

17,84Lei

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

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

5004411
Livrare imediată!

11,89Lei

Fir Textil Owner Kizuna X8 Broad, 9.20kg, 0.17mm, Chartreuse, 135m

Fir Textil Owner Kizuna X8 Broad, 9.20kg, 0.17mm, Chartreuse, 135m

11060256117-017
Livrare imediată!

96,97Lei

Carlig Owner 50173 Negru Rotund cu Spin Nr 1 - 9buc/plic

Carlig Owner 50173 Negru Rotund cu Spin Nr 1 - 9buc/plic

5017305
Livrare imediată!

11,89Lei

Shad Owner Getnet Juster Fish 89mm 31 Sakura Blue

Shad Owner Getnet Juster Fish 89mm 31 Sakura Blue

13013782919-31
Livrare 48-72 ore

33,03Lei

Carlig Owner 50340 Negru Crom Semirotund Nr 5 - 16buc/plic -29%

Carlig Owner 50340 Negru Crom Semirotund Nr 5 - 16buc/plic

5034004
Livrare imediată!

10,25Lei(-29%) 7,27Lei

Fir monofilament Owner Broad Carp SP 0.30mm 300m

Fir monofilament Owner Broad Carp SP 0.30mm 300m

11010256023-030
Livrare imediată!

72,34Lei

Carlig Owner 50560 Argintiu Tija Lunga Nr 2 - 10buc/plic

Carlig Owner 50560 Argintiu Tija Lunga Nr 2 - 10buc/plic

5056002
Livrare imediată!

10,41Lei

Afişare 81 - 100 din 1529 (77 pagini)
Queries: 7, Total time: 104.707 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'ffe90e06e2ef6a317e9511b86a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.101)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (44.619)
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 = '0' AND p.manufacturer_id = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (59.515)
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 = '0' AND p.manufacturer_id = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37