Abu Garcia


Set Voblere ABU GARCIA Tormentor Floating, BRPS, 12g, 9cm, 1buc/pac

Set Voblere ABU GARCIA Tormentor Floating, BRPS, 12g, 9cm, 1buc/pac

1082759
Livrare 7-14 zile

41,67Lei

Pilker ABU GARCIA Fast Cast, Coal, 4.5cm, 7g, 1buc/pac

Pilker ABU GARCIA Fast Cast, Coal, 4.5cm, 7g, 1buc/pac

1530621
Livrare 7-14 zile

27,44Lei

Mulineta Abu Garcia Revo SX Spin 30

Mulineta Abu Garcia Revo SX Spin 30

1365349
Livrare imediată!

454,75Lei

Pilker ABU GARCIA Lucas, HS Red, 200g, 1buc/pac

Pilker ABU GARCIA Lucas, HS Red, 200g, 1buc/pac

1070798
Livrare 7-14 zile

45,74Lei

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

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

1549925
Livrare 7-14 zile

70,14Lei

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

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

1056564
Livrare 7-14 zile

53,87Lei

Rotativa Abu Garcia Droppen 3 Pack, Assorted, 4g, 4cm, 3buc/plic

Rotativa Abu Garcia Droppen 3 Pack, Assorted, 4g, 4cm, 3buc/plic

1549760
Livrare 7-14 zile

45,74Lei

Set Pilker ABU GARCIA Kystsilda, Multicolor, 28g, 3buc/pac

Set Pilker ABU GARCIA Kystsilda, Multicolor, 28g, 3buc/pac

1278669
Livrare 7-14 zile

37,61Lei

Lingurita Oscilanta Abu Garcia, White Flash, 40g, 9cm

Lingurita Oscilanta Abu Garcia, White Flash, 40g, 9cm

1550245
Livrare imediată!

31,50Lei

Pilker ABU GARCIA Solv Rull, Sunrise, 7cm, 12g

Pilker ABU GARCIA Solv Rull, Sunrise, 7cm, 12g

1550021
Livrare 7-14 zile

27,44Lei

Lanseta Abu Garcia SPIKE S Rod Finesse Jig Spinning Rod 762 ML, 5-18g, 2.29m, 2seg

Lanseta Abu Garcia SPIKE S Rod Finesse Jig Spinning Rod 762 ML, 5-18g, 2.29m, 2seg

1580862
Livrare imediată!

430,09Lei

Pilker ABU GARCIA Solv Piil, Green Tobis, 8cm, 12g

Pilker ABU GARCIA Solv Piil, Green Tobis, 8cm, 12g

1550053
Livrare 7-14 zile

27,44Lei

Pilker ABU GARCIA Solv Blixx, 13g, 7cm, Chili Red, 1buc/pac

Pilker ABU GARCIA Solv Blixx, 13g, 7cm, Chili Red, 1buc/pac

1550085
Livrare 7-14 zile

37,61Lei

Ochelari de Soare Polarizati Abu Garcia Eyewear Revo Silver

Ochelari de Soare Polarizati Abu Garcia Eyewear Revo Silver

1561288
Livrare 7-14 zile

215,55Lei

Afumatoare Abu Garcia Stainless Steel Smoker With 2 Burners

Afumatoare Abu Garcia Stainless Steel Smoker With 2 Burners

1203514
Livrare 7-14 zile

376,20Lei

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

74,21Lei

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

53,87Lei

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

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

1115247
Livrare 7-14 zile

45,74Lei

Lingurita Abu Garcia oscilanta Atom Vass 20g S

Lingurita Abu Garcia oscilanta Atom Vass 20g S

1312858
Livrare imediată!

33,54Lei

Pilker ABU GARCIA Fast Cast, Minnow, 7cm, 28g, 1buc/pac

Pilker ABU GARCIA Fast Cast, Minnow, 7cm, 28g, 1buc/pac

1530648
Livrare 7-14 zile

41,67Lei

Afişare 1501 - 1520 din 1578 (79 pagini)
Queries: 7, Total time: 103.860 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = '03d6f79efc28d56f1919107083'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.083)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.788)
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 = '3' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (60.648)
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 = '3' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.104)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37