Owner


Carlig Owner Seigo, BH 51440, Nr. 2/0, 5buc/plic

Carlig Owner Seigo, BH 51440, Nr. 2/0, 5buc/plic

5144002
Livrare imediată!

10,25Lei

Carlig Owner Aji-B 50015 Nr 5 -28%

Carlig Owner Aji-B 50015 Nr 5

5001501
Livrare imediată!

9,53Lei(-28%) 6,90Lei

Carlig, Owner, Sirahae, 50243, Nr20, 5024306, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, Sirahae, 50243, Nr20, 5024306, Carlige Stationar, Carlige Stationar Owner, Owner

5024306
Livrare 48-72 ore

10,90Lei

Carlig, Owner, Chinta, 50340, Nr, 11, 5034011, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, Chinta, 50340, Nr, 11, 5034011, Carlige Stationar, Carlige Stationar Owner, Owner

5034011
Livrare 48-72 ore

11,89Lei

Carlig, Owner, Funa, 50563, Nr, 12, 5056303, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, Funa, 50563, Nr, 12, 5056303, Carlige Stationar, Carlige Stationar Owner, Owner

5056303
Livrare imediată!

10,90Lei

Carlig, Owner, Kiwami, 53104, Nr, 18, 5310406, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, Kiwami, 53104, Nr, 18, 5310406, Carlige Stationar, Carlige Stationar Owner, Owner

5310406
Livrare 48-72 ore

10,41Lei

Shad Owner Juster JRS105 105mm Watermelon

Shad Owner Juster JRS105 105mm Watermelon

801025589040
Livrare imediată!

26,61Lei

Vobler, Owner, Shallow, Runner, 5227, TWO-38SR, 38mm, 3.5gr, 02, Silver, And, Black, 804020020, Voblere Floating, Voblere Floating Owner, Owner
Vobler Owner Rip n Minnow 65mm 6.0gr 33 Blue ghost

Vobler Owner Rip n Minnow 65mm 6.0gr 33 Blue ghost

804020308
Livrare 48-72 ore

47,87Lei

Carlig, Owner, 50116, Nr.8, Kaizu, 5011615, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, 50116, Nr.8, Kaizu, 5011615, Carlige Stationar, Carlige Stationar Owner, Owner

5011615
Livrare imediată!

11,89Lei

Carlige Legate OWNER S363 56915 Nr.16 Fir 0.10mm Rosu

Carlige Legate OWNER S363 56915 Nr.16 Fir 0.10mm Rosu

5691503
Livrare imediată!

12,72Lei

Jig Owner Lestat 56978 Nr.2/0 5.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.2/0 5.00gr Round Jig Head

56978250
Livrare 48-72 ore

31,05Lei

Carlig Owner4105 No.8 Mosquito Light

Carlig Owner4105 No.8 Mosquito Light

410504
Livrare imediată!

12,22Lei

Ancora, Owner, STX, 38ZN, Numarul, 12, 5638985, Ancore, Ancore Owner, Owner

Ancora, Owner, STX, 38ZN, Numarul, 12, 5638985, Ancore, Ancore Owner, Owner

5638985
Livrare imediată!

45,92Lei

Jig Owner Nelestat 5304 No.3/0 Deep Throat Wide Gap

Jig Owner Nelestat 5304 No.3/0 Deep Throat Wide Gap

1530430
Livrare 48-72 ore

19,87Lei

Carlig, Owner, 50168, Nr.14, Iseama, BL, Eye, 5016814, Carlige Crap, Carlige Crap Owner, Owner

Carlig, Owner, 50168, Nr.14, Iseama, BL, Eye, 5016814, Carlige Crap, Carlige Crap Owner, Owner

5016814
Livrare imediată!

10,90Lei

Rig, Feeder, Owner, 56932, No.12, 0.20, FD-11, Spear, 12030256932-12, Carlige Legate Feeder, Carlige Legate Feeder Owner, Owner
Carlig Owner 50044 Negru Semirotund Nr 6 - 14buc/plic

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

5004411
Livrare imediată!

11,89Lei

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

1156608
Livrare imediată!

26,43Lei

Carlige Owner Maruseigo-BH 50137, Nr.1/0, 8buc/plic -29%

Carlige Owner Maruseigo-BH 50137, Nr.1/0, 8buc/plic

5017304
Livrare imediată!

10,41Lei(-29%) 7,39Lei

Afişare 881 - 900 din 1473 (74 pagini)
Queries: 7, Total time: 96.674 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = '382cca76248a695a3227d31c50'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.108)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.094)
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 (38.007)
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:1667
6 (58.112)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' 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:438
7 (0.152)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38