Owner


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

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

1210025105-161
Livrare 48-72 ore

28,46Lei

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

Carlig OWNER 13189 Genki Gure, Nr.3, 22buc/pac

Carlig OWNER 13189 Genki Gure, Nr.3, 22buc/pac

12010213189-03
Livrare 48-72 ore

14,99Lei

Rig Feeder Owner 56935 No.14 0.12 FDB-01 Spear Braided, 6buc/pac

Rig Feeder Owner 56935 No.14 0.12 FDB-01 Spear Braided, 6buc/pac

12030256935-114
Livrare 48-72 ore

27,42Lei

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

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

1210025105-111
Livrare 48-72 ore

27,89Lei

Carlig Owner C-4 Carp Aya Nr.8

Carlig Owner C-4 Carp Aya Nr.8

5000045
Livrare imediată!

13,54Lei

CARLIG OWNER MINNOW S-55M cod 51770 Nr.6

CARLIG OWNER MINNOW S-55M cod 51770 Nr.6

5177002
Livrare imediată!

10,75Lei

Ancora Owner ST31 Nr.2 -27%

Ancora Owner ST31 Nr.2

5631003
Livrare imediată!

40,96Lei(-27%) 29,90Lei

Ancora Owner ST66 TN Nr.4

Ancora Owner ST66 TN Nr.4

5666079
Livrare imediată!

59,96Lei

JIG OWNER BILA 11528 NR.1 7 Gr -22%

JIG OWNER BILA 11528 NR.1 7 Gr

5281133
Livrare imediată!

12,74Lei(-22%) 9,90Lei

Carlig Owner OH SSW 5115 Nr.1/0

Carlig Owner OH SSW 5115 Nr.1/0

5115006
Livrare imediată!

14,04Lei

Carlig Owner Kisu-K 50145 Nr 18

Carlig Owner Kisu-K 50145 Nr 18

5014508
Livrare 48-72 ore

11,23Lei

Carlig Owner Chinta 50319 Nr 10

Carlig Owner Chinta 50319 Nr 10

5031910
Livrare 48-72 ore

8,29Lei

Carlig Owner Furansu 50560 Nr 10

Carlig Owner Furansu 50560 Nr 10

5056009
Livrare 48-72 ore

6,22Lei

Carlig Owner Pint-S 53135 Nr 10

Carlig Owner Pint-S 53135 Nr 10

5313504
Livrare imediată!

10,25Lei

Shad Owner Juster JRS82 82mm Flash Bass

Shad Owner Juster JRS82 82mm Flash Bass

801025586270
Livrare imediată!

26,61Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 32 Golden Shiner

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 32 Golden Shiner

804020043
Livrare 48-72 ore

52,19Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 76 Argintiu holo

Vobler Owner Bug Eye Bait 50mm 6.5gr 76 Argintiu holo

804020212
Livrare imediată!

59,65Lei

Carlig Owner Chinta 50335 Nr.10 16buc/plic

Carlig Owner Chinta 50335 Nr.10 16buc/plic

5033508
Livrare imediată!

11,89Lei

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

Afişare 81 - 100 din 1521 (77 pagini)
Queries: 7, Total time: 88.395 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = '492d37d9b8bd9de45f6460fa2a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
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 (36.031)
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.815)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.113)
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