Abu Garcia

Abu Garcia

Sortare după:

Gafa Telescopica Abu Garcia, 88-150cm

Gafa Telescopica Abu Garcia, 88-150cm

1096848

Livrare 7-14 zile

161,00Lei

LINGURITA ROTATIVA ABU GARCIA REFLEX, ASSORTED, 12G, 3BUC/PLIC

LINGURITA ROTATIVA ABU GARCIA REFLEX, ASSORTED, 12G, 3BUC/PLIC

1532137

Livrare 7-14 zile

76,01Lei

Pilker Abu Garcia Hard Bait Sillen, Holo Silver, 250g, 15cm

Pilker Abu Garcia Hard Bait Sillen, Holo Silver, 250g, 15cm

1127028

Livrare 7-14 zile

52,00Lei

Kit Cozi De Schimb Abu Garcia Svartzonker McHybrid Spare Tail, Silver, 8g, 9cm, 2buc/plic

Kit Cozi De Schimb Abu Garcia Svartzonker McHybrid Spare Tail, Silver, 8g, 9cm, 2buc/plic

1531937

Livrare 7-14 zile

48,00Lei

Combo Abu Garcia Fast Attack Casting Combo MH, 10-40g, 2.13m, 2seg

Combo Abu Garcia Fast Attack Casting Combo MH, 10-40g, 2.13m, 2seg

1562827

Livrare 7-14 zile

455,00Lei

Swimbait ABU GARCIA Svartzonker McPike, UV Black Back Shad, 17cm, 48g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, UV Black Back Shad, 17cm, 48g, 2buc/pac

1590298

Livrare 7-14 zile

48,00Lei

Set Pilker ABU GARCIA Coast Lures, Multicolor, 40g, 3buc/set

Set Pilker ABU GARCIA Coast Lures, Multicolor, 40g, 3buc/set

1115246

Livrare 7-14 zile

36,00Lei

Geanta Abu Garcia Compact Game Bag

Geanta Abu Garcia Compact Game Bag

1207933

Livrare imediată!

127,00Lei

Rucsac Abu Garcia Standard with Backrest

Rucsac Abu Garcia Standard with Backrest

1200625

Livrare imediată!

317,00Lei

Spinnerhead Abu Garcia Svartzonker, Mr. Black, 45g

Spinnerhead Abu Garcia Svartzonker, Mr. Black, 45g

1550166

Livrare 7-14 zile

60,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Red Tiger, 21cm, 87g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Red Tiger, 21cm, 87g, 2buc/pac

1590300

Livrare 7-14 zile

56,00Lei

Set Voblere ABU GARCIA Tormentor Floating, SKB, 3g, 5cm, 1buc/pac

Set Voblere ABU GARCIA Tormentor Floating, SKB, 3g, 5cm, 1buc/pac

1070759

Livrare 7-14 zile

30,00Lei

Lingurita oscilanta Abu Garcia Hammer 20g Silver Blue

Lingurita oscilanta Abu Garcia Hammer 20g Silver Blue

1312894

Livrare imediată!

24,00Lei

ULEI MULINETE ABU GARCIA 30ml

ULEI MULINETE ABU GARCIA 30ml

1368792

Livrare imediată!

51,00Lei

Shad Abu Garcia Svartzonker McPrech, Real Perch SVZ PDQ, 3.7g, 7.5cm, 8buc/plic

Shad Abu Garcia Svartzonker McPrech, Real Perch SVZ PDQ, 3.7g, 7.5cm, 8buc/plic

1514213

Livrare 7-14 zile

47,97Lei

Pilker Abu Garcia Lucas, Holo Silver Red, 300g, 19cm

Pilker Abu Garcia Lucas, Holo Silver Red, 300g, 19cm

1070801

Livrare 7-14 zile

60,00Lei

Rotativa Abu Garcia Reflex 3 Pack , Assorted, 7g, 4.5cm, 3buc/plic

Rotativa Abu Garcia Reflex 3 Pack , Assorted, 7g, 4.5cm, 3buc/plic

1532136

Livrare 7-14 zile

64,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Miltona Walleye, 25cm, 131g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Miltona Walleye, 25cm, 131g, 2buc/pac

1590315

Livrare 7-14 zile

72,00Lei

Vobler ABU GARCIA Tormentor Jointed Floating, Blue Mackerel, 20g, 11cm, 1buc/pac

Vobler ABU GARCIA Tormentor Jointed Floating, Blue Mackerel, 20g, 11cm, 1buc/pac

1130094

Livrare 7-14 zile

52,00Lei

Multiplicator Abu Garcia Zenon MG-LTX Low Profile Reel, Left

1552845

Livrare 7-14 zile

1.813,00Lei

Afişare 961 - 980 din 1141 (58 pagini)

Queries: 7, Total time: 108.713 ms [By time] [By id] [By file]

1 (0.162)

SELECT data
FROM `oc_session`
WHERE session_id = 'f88f0b3b2ab15d4082ff15899a'

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

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.120)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'

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

4 (0.117)

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

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

5 (58.179)

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

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

6 (49.874)

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

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

7 (0.174)

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