Trakker

Trakker

Sortare după:

Geanta TRAKKER NXG Chilla Bag Large, 45x35x26cm

Geanta TRAKKER NXG Chilla Bag Large, 45x35x26cm

204192

Livrare 7-14 zile

382,25Lei

Vesta TRAKKER CR Thermal Body Warmer, Marime 3XL

Vesta TRAKKER CR Thermal Body Warmer, Marime 3XL

206638

Livrare 7-14 zile

397,50Lei

Costum TRAKKER CR3 3-Piece Winter Fishing Suit, Marime S

Costum TRAKKER CR3 3-Piece Winter Fishing Suit, Marime S

206339

Livrare 7-14 zile

899,95Lei(-13%) 778,82Lei

Pichet Trakker Quickstick 36 Inch, 90cm

Pichet Trakker Quickstick 36 Inch, 90cm

203801

Livrare 7-14 zile

112,80Lei

Cort Trakker Tempest RS 200 Aquatexx, 170x380x290cm

Cort Trakker Tempest RS 200 Aquatexx, 170x380x290cm

201430

Livrare imediată!

6.908,89Lei

Lanseta Trakker Propel Rod, 3.00lbs, 3.00m, 2seg

Lanseta Trakker Propel Rod, 3.00lbs, 3.00m, 2seg

223122

Livrare 7-14 zile

1.271,96Lei

Hanorac Trakker CR Logo Camo Hoody Black, Marime M

207860

Livrare imediată!

234,95Lei(-13%) 204,07Lei

Carlige Trakker Clinga BP Hooks Micro Barbed, Nr.6, 10buc/pac

Carlige Trakker Clinga BP Hooks Micro Barbed, Nr.6, 10buc/pac

227226

Livrare imediată!

27,89Lei

Tricou Trakker Tempest, Marime M

Tricou Trakker Tempest, Marime M

207149

Livrare 7-14 zile

114,95Lei(-13%) 100,35Lei

Carlige Trakker Clinga SP XS Hooks Micro Barbed, Nr.4, 10buc/pac

Carlige Trakker Clinga SP XS Hooks Micro Barbed, Nr.4, 10buc/pac

227214

Livrare imediată!

27,89Lei

Plumb Trakker Distance Swivel Lead, 56.70g / 2.0oz

Plumb Trakker Distance Swivel Lead, 56.70g / 2.0oz

227701

Livrare 7-14 zile

11,12Lei

Carlige Trakker Short Shank Hooks Barbless, Nr.2, 10buc/pac

Carlige Trakker Short Shank Hooks Barbless, Nr.2, 10buc/pac

227136

Livrare 7-14 zile

27,89Lei

Fir Textil Trakker Stiff Coated Hooklink, 11.3kg/25lb, 20m

Fir Textil Trakker Stiff Coated Hooklink, 11.3kg/25lb, 20m

227417

Livrare 7-14 zile

82,29Lei

Vartej Rapid Cu Anou Trakker Ronnie Swivel, Size 11, 10buc/plic

Vartej Rapid Cu Anou Trakker Ronnie Swivel, Size 11, 10buc/plic

228209

Livrare 7-14 zile

24,35Lei

Vesta TRAKKER CR Thermal Body Warmer, Marime L

Vesta TRAKKER CR Thermal Body Warmer, Marime L

206635

Livrare imediată!

389,95Lei(-13%) 338,03Lei

Carlige Legate TRAKKER Blowback Ready Rigs, Barbless, Nr.4, 25lbs, 2buc/pac

Carlige Legate TRAKKER Blowback Ready Rigs, Barbless, Nr.4, 25lbs, 2buc/pac

228739

Livrare 7-14 zile

29,37Lei

Pat TRAKKER RLX 8 Leg Bed v2 Wide, 205x90cm

Pat TRAKKER RLX 8 Leg Bed v2 Wide, 205x90cm

217122

Livrare 7-14 zile

1.729,53Lei

Opritoare TRAKKER Supa-Grip Hook Beads TPx5, 20buc/pac

Opritoare TRAKKER Supa-Grip Hook Beads TPx5, 20buc/pac

228245

Livrare 7-14 zile

20,78Lei

Geaca TRAKKER CR Thermal Jacket, Marime S

Geaca TRAKKER CR Thermal Jacket, Marime S

206627

Livrare 7-14 zile

483,93Lei

Tricou TRAKKER Tech Pro T Shirt, Marime S

Tricou TRAKKER Tech Pro T Shirt, Marime S

207274

Livrare 7-14 zile

153,46Lei

Afişare 261 - 280 din 884 (45 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: 81.617 ms [By time] [By id] [By file]

1 (0.091)

SELECT data
FROM `oc_session`
WHERE session_id = '0d9e836bcea2b4d249a4e7d88f'

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

2 (0.096)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.126)

SELECT *
FROM oc_url_alias
WHERE keyword = 'trakker.html'

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

4 (0.108)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '476' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (37.506)

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 = '476'

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

6 (43.561)

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 = '476' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 260,20

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

7 (0.129)

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