Abu Garcia


Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Gold Black Or, 12cm, 47g

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Gold Black Or, 12cm, 47g

1621247
Livrare 7-14 zile

62,01Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Black Back Minnow, 18g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Toby Jointed, Black Back Minnow, 18g, 1buc/pac

1609474
Livrare 7-14 zile

41,67Lei

Agrafa ABU GARCIA Snap Swivels Gold, Nr.12, 10buc/pac

Agrafa ABU GARCIA Snap Swivels Gold, Nr.12, 10buc/pac

1376739
Livrare 7-14 zile

13,20Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Orange Cooper Holo, 40g, 9cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Orange Cooper Holo, 40g, 9cm, 1buc/pac

1550249
Livrare 7-14 zile

31,50Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, White Flash, 20g, 7.5cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, White Flash, 20g, 7.5cm, 1buc/pac

1550221
Livrare 7-14 zile

25,40Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Silver, 15g, 7.5cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Silver, 15g, 7.5cm, 1buc/pac

1550191
Livrare 7-14 zile

21,34Lei

Lanseta ABU GARCIA Spike PRO Tech Rig Rod ML, 3-18g, 2.59, 2seg

Lanseta ABU GARCIA Spike PRO Tech Rig Rod ML, 3-18g, 2.59, 2seg

1539764
Livrare 7-14 zile

1.159,14Lei

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 11cm, 55g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 11cm, 55g, 1buc/pac

1446003
Livrare 7-14 zile

53,87Lei

Lingurita Roativa ABU GARCIA Fast Attack Stickle Spinner, Spawn Stickle, 5g, 4.5cm, 1buc/pac

Lingurita Roativa ABU GARCIA Fast Attack Stickle Spinner, Spawn Stickle, 5g, 4.5cm, 1buc/pac

1595276
Livrare 7-14 zile

33,54Lei

VOBLER ABU GARCIA SVARTZONKER MCMIO FEGIS 14cm 21g

VOBLER ABU GARCIA SVARTZONKER MCMIO FEGIS 14cm 21g

1550121
Livrare imediată!

94,55Lei

Lingurtia Oscilanta ABU GARCIA Lill Zigge, Glitter RBT, 5cm, 14g, 1buc/pac

Lingurtia Oscilanta ABU GARCIA Lill Zigge, Glitter RBT, 5cm, 14g, 1buc/pac

1579810
Livrare 7-14 zile

17,27Lei

MULINETA ABU GARCIA MAX STX 1000

MULINETA ABU GARCIA MAX STX 1000

1532489
Livrare imediată!

260,25Lei

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 4.4cm, 6g

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 4.4cm, 6g

1549727
Livrare 7-14 zile

19,30Lei

Lanseta Abu Garcia Veritas Sensi-S 762ML Spin, 2.29m, 3-15g, 2seg

Lanseta Abu Garcia Veritas Sensi-S 762ML Spin, 2.29m, 3-15g, 2seg

1558830
Livrare imediată!

580,58Lei

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Roach, 5.3cm, 12g

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Roach, 5.3cm, 12g

1549759
Livrare 7-14 zile

25,40Lei

Lingurita Rotativa ABU GARCIA Droppen Bugga LF, Culoare Firetiger, 10g, 5cm

Lingurita Rotativa ABU GARCIA Droppen Bugga LF, Culoare Firetiger, 10g, 5cm

1549797
Livrare 7-14 zile

23,37Lei

VOBLER ABU GARCIA SVARTZONKER MCCELLY, BURBOT MOTOROIL, 14CM, 64G

VOBLER ABU GARCIA SVARTZONKER MCCELLY, BURBOT MOTOROIL, 14CM, 64G

1550101
Livrare 7-14 zile

86,37Lei

Lingurita Rotativa ABU GARCIA Droppen Vide LF, Holo Roach, 14g, 6cm

Lingurita Rotativa ABU GARCIA Droppen Vide LF, Holo Roach, 14g, 6cm

1549839
Livrare 7-14 zile

33,54Lei

Lingurita Rattling Abu Garcia Atom, Perch, 12cm, 45g

Lingurita Rattling Abu Garcia Atom, Perch, 12cm, 45g

1525553
Livrare imediată!

41,67Lei

Lingurita Rotativa ABU GARCIA Fast Attack Spinner LF, Gold/Black Dot, 10g, 5cm

Lingurita Rotativa ABU GARCIA Fast Attack Spinner LF, Gold/Black Dot, 10g, 5cm

1549874
Livrare 7-14 zile

25,40Lei

Afişare 41 - 60 din 1578 (79 pagini)
Queries: 7, Total time: 96.300 ms [By time] [By id] [By file]
1 (0.351)
SELECT data
FROM `oc_session`
WHERE session_id = 'caba3e47130d5cdfe86e0a63ee'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.192)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.307)
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 (56.090)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.127)
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