Owner

Owner

Sortare după:

Ancora Owner STX 38ZN Numarul 8

Ancora Owner STX 38ZN Numarul 8

5638035

Livrare 48-72 ore

47,69Lei

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

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

1530440

Livrare 48-72 ore

25,13Lei

Carlige Owner 50152 Nr.6 Amano Tenkara Eye

Carlige Owner 50152 Nr.6 Amano Tenkara Eye

5015206

Livrare imediată!

11,58Lei

Rig Feeder Owner 56932 No.14 0.18 FD-11 Spear

Rig Feeder Owner 56932 No.14 0.18 FD-11 Spear

12030256932-14

Livrare imediată!

23,84Lei

Jig Lestat Owner JH-82R No.10 1.8gr Mebaru Shot

Jig Lestat Owner JH-82R No.10 1.8gr Mebaru Shot

1156607

Livrare imediată!

27,87Lei

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

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

5004408

Livrare 48-72 ore

11,41Lei

Creatura Owner Yuki Bug 85mm 18 Chartreuse Yellow

Creatura Owner Yuki Bug 85mm 18 Chartreuse Yellow

1301375594-18

Livrare 48-72 ore

28,83Lei

Carlige Owner Okiami Chinu 50097, Nr.3, 7buc/plic

Carlige Owner Okiami Chinu 50097, Nr.3, 7buc/plic

5009705

Livrare imediată!

11,41Lei

Carlig Owner CF-3 No.7/0

Carlig Owner CF-3 No.7/0

12100256966-70

Livrare imediată!

34,59Lei

Carlig Owner 50286 Rosu Tija Lunga Nr 9 - 15buc/plic

Carlig Owner 50286 Rosu Tija Lunga Nr 9 - 15buc/plic

5028607

Livrare imediată!

11,58Lei

Jig Lestat Owner JH-83G No.10 1gr Mebaru Dama Phospho 4buc/plic

Jig Lestat Owner JH-83G No.10 1gr Mebaru Dama Phospho 4buc/plic

1209371160602

Livrare 48-72 ore

24,01Lei

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 8 - 15buc/pac

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 8 - 15buc/pac

5048202

Livrare 48-72 ore

12,08Lei

Carlig Owner 50360 No.3 Sokko Gure 8buc/plic

Carlig Owner 50360 No.3 Sokko Gure 8buc/plic

5036003

Livrare 48-72 ore

11,41Lei

Carlig Owner Cps 5100 Negru Tija Lunga Spin Nr 1/0 - 6buc/plic

Carlig Owner Cps 5100 Negru Tija Lunga Spin Nr 1/0 - 6buc/plic

5100005

Livrare imediată!

20,07Lei

Ancore Owner ST-36MF Magic Fusso No.8 8buc/plic

Ancore Owner ST-36MF Magic Fusso No.8 8buc/plic

1231002

Livrare 48-72 ore

41,97Lei

Carlige Crap Owner Carp Liner C-1 nr 1/0 - 4buc/plic

Carlige Crap Owner Carp Liner C-1 nr 1/0 - 4buc/plic

5000001

Livrare imediată!

11,18Lei(-16%) 9,39Lei

Carlige Owner Black Ebi Baitholder BC 5123-091 Nr.2, 7buc/plic

Carlige Owner Black Ebi Baitholder BC 5123-091 Nr.2, 7buc/plic

5123091

Livrare 48-72 ore

19,97Lei

Carlige Owner K-Chinu 50098, Nr.3, 9buc/plic

Carlige Owner K-Chinu 50098, Nr.3, 9buc/plic

5009805

Livrare imediată!

10,24Lei(-12%) 9,03Lei

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.6/0

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.6/0

1210021077160

Livrare 48-72 ore

35,22Lei

Carlig Owner CUT CHINU Auriu 50328 nr 1 - 12buc/plic

Carlig Owner CUT CHINU Auriu 50328 nr 1 - 12buc/plic

5032804

Livrare imediată!

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

Afişare 1141 - 1160 din 1550 (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: 97.141 ms [By time] [By id] [By file]

1 (0.148)

SELECT data
FROM `oc_session`
WHERE session_id = '06d8e7715ef8d08f0720eebcd5'

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

2 (0.102)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.133)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'

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

4 (0.125)

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

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

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

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

7 (0.147)

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