Owner


Carlig Owner Chinta 50319 Nr 16

Carlig Owner Chinta 50319 Nr 16

5031916
Livrare 48-72 ore

10,41Lei

Carlig, Owner, Furansu, 50560, Nr, 18, 5056013, Carlige Stationar, Carlige Stationar Owner, Owner

Carlig, Owner, Furansu, 50560, Nr, 18, 5056013, Carlige Stationar, Carlige Stationar Owner, Owner

5056013
Livrare 48-72 ore

10,41Lei

Carlig Owner Kiwami 53104 Nr 10

Carlig Owner Kiwami 53104 Nr 10

5310402
Livrare 48-72 ore

10,41Lei

Shad Owner Juster JRS82 82mm Sakura Blue

Shad Owner Juster JRS82 82mm Sakura Blue

801025586310
Livrare 48-72 ore

26,61Lei

Vobler Owner Bite Marker 28mm 1.7gr 28 Green Gold Berry Eye 5224 TMT-28SP

Vobler Owner Bite Marker 28mm 1.7gr 28 Green Gold Berry Eye 5224 TMT-28SP

804020031
Livrare imediată!

98,35Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 13 Baby bass

Vobler Owner Rip n Minnow 65mm 6.0gr 13 Baby bass

804020303
Livrare 48-72 ore

47,87Lei

Carlig, Owner, Chinta, 50335, Nr.10, 16buc/plic, 5033508, Carlige Stationar, Carlige Stationar Owner, Owner
Grub Single Tail Owner RB-3 13 Pearl Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 13 Pearl Ring Single Tail 82914 3.8cm

8291413
Livrare imediată!

15,29Lei

Jig Lestat Owner 56978, Nr. 4/0, 8g, 4buc/plic -28%

Jig Lestat Owner 56978, Nr. 4/0, 8g, 4buc/plic

56978480
Livrare imediată!

24,78Lei(-28%) 17,90Lei

Carlig Owner 5123 No 1 Baitholder Hook Red

Carlig Owner 5123 No 1 Baitholder Hook Red

5123103
Livrare imediată!

18,66Lei

Rig, Feeder, Owner, 56930, No.12, 0.20, FD, 01, Spear, 5693012, Carlige Legate Feeder, Carlige Legate Feeder Owner, Owner
Jig Owner Offset Beast Twistlock 5130, Nr. 6/0, 2buc/plic

Jig Owner Offset Beast Twistlock 5130, Nr. 6/0, 2buc/plic

5130161
Livrare 48-72 ore

35,24Lei

Rig Feeder Owner 56932 No.10 0.20 FD-12 Pellet Band

Rig Feeder Owner 56932 No.10 0.20 FD-12 Pellet Band

12030256932-010
Livrare 48-72 ore

20,65Lei

Carlig, Owner, 50046, Simplu, Auriu, Nr, 2, -, 8buc/plic, 5004606, Carlige Crap, Carlige Crap Owner, Owner
Carlig Owner CF-1 No.5/0

Carlig Owner CF-1 No.5/0

12100256964-50
Livrare imediată!

40,47Lei

Carlig Owner 50173 Negru Rotund cu Spin Nr 4 - 12buc/plic

Carlig Owner 50173 Negru Rotund cu Spin Nr 4 - 12buc/plic

5017307
Livrare imediată!

11,89Lei

Creatura Owner Getnet Juster Hog 58mm 08 Solid Pink

Creatura Owner Getnet Juster Hog 58mm 08 Solid Pink

13013782916-08
Livrare 48-72 ore

33,03Lei

Carlig Owner 50344 Negru Semirotund Nr 1/0 - 13buc/plic -29%

Carlig Owner 50344 Negru Semirotund Nr 1/0 - 13buc/plic

5034403
Livrare imediată!

9,40Lei(-29%) 6,68Lei

Carlig Owner CF-3 No.12/0

Carlig Owner CF-3 No.12/0

12100256966-120
Livrare 48-72 ore

27,91Lei

Carlig Owner 50599 Negru Tija Lunga Nr 3 - 16buc/plic -29%

Carlig Owner 50599 Negru Tija Lunga Nr 3 - 16buc/plic

5059904
Livrare imediată!

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

Afişare 361 - 380 din 1472 (74 pagini)
Queries: 9, Total time: 114.611 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = 'a62c16441c601692a8e6403dc0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.146)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.134)
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
6 (52.632)
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:1661
7 (61.092)
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 360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.097)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.092)
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