Abu Garcia

Abu Garcia

Sortare după:

Swimbait ABU GARCIA Svartzonker McPike, Real Roach, 25cm, 131g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Real Roach, 25cm, 131g, 2buc/pac

1590310

Livrare 7-14 zile

72,00Lei

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

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

1130093

Livrare 7-14 zile

52,00Lei

VARGA ABU GARCIA SIESTA 3.00 M

VARGA ABU GARCIA SIESTA 3.00 M

1096325

Livrare imediată!

30,00Lei

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

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

1514212

Livrare 7-14 zile

47,97Lei

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

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

1070800

Livrare 7-14 zile

60,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

Set Voblere Abu Garcia Tormentor Jointed, 7.8g, 11cm, 3buc/pac

Set Voblere Abu Garcia Tormentor Jointed, 7.8g, 11cm, 3buc/pac

1550271

Livrare 7-14 zile

128,00Lei

Pilker ABU GARCIA Sillen, Holo Silver Red, 13cm, 150g, 1buc/pac

Pilker ABU GARCIA Sillen, Holo Silver Red, 13cm, 150g, 1buc/pac

1056559

Livrare 7-14 zile

43,99Lei

Ancora Deriva Abu Garcia Beast Pro Drogue 80x80cm

Ancora Deriva Abu Garcia Beast Pro Drogue 80x80cm

1537278

Livrare imediată!

158,87Lei(-32%) 107,90Lei

Lingurita Oscilanta Abu Garcia Toby 9cm 40g LF Sardine

Lingurita Oscilanta Abu Garcia Toby 9cm 40g LF Sardine

1550247

Livrare imediată!

30,00Lei

Husa Individuala Abu Garcia Beast Pro Rod Sleeve 4FT 120cm

Husa Individuala Abu Garcia Beast Pro Rod Sleeve 4FT 120cm

1528420

Livrare imediată!

149,81Lei

Combo Lanseta + Mulineta Abu Garcia Cardinal Classic Vildmark 7ft/2.13m Tele

Combo Lanseta + Mulineta Abu Garcia Cardinal Classic Vildmark 7ft/2.13m Tele

1344990

Livrare 7-14 zile

238,00Lei

LINGURITA OSCILANTA ABU GARCIA TOBY, ASSORTED, 9CM, 18G, 3BUC/PLIC

LINGURITA OSCILANTA ABU GARCIA TOBY, ASSORTED, 9CM, 18G, 3BUC/PLIC

1550266

Livrare 7-14 zile

76,01Lei

Shad Abu Garcia Svartzonker McPrey Kit, Gold Shiner, 11.5g, 12cm, 4buc/plic

Shad Abu Garcia Svartzonker McPrey Kit, Gold Shiner, 11.5g, 12cm, 4buc/plic

1522323

Livrare imediată!

54,00Lei(-56%) 24,00Lei

Combo Abu Garcia Revo X3 Casting 662MH, 15-45g, 1.98m, 2seg

Combo Abu Garcia Revo X3 Casting 662MH, 15-45g, 1.98m, 2seg

1579556

Livrare 7-14 zile

791,00Lei

Lanseta Pastrav ABU GARCIA Aion Ains 602 ULS+ E Spinning Rod, 1.83m, 0.3-3.0g, 2seg

Lanseta Pastrav ABU GARCIA Aion Ains 602 ULS+ E Spinning Rod, 1.83m, 0.3-3.0g, 2seg

1623085

Livrare 7-14 zile

802,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Fire Bass, 17cm, 48g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Fire Bass, 17cm, 48g, 2buc/pac

1590297

Livrare 7-14 zile

48,00Lei

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

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

1248323

Livrare 7-14 zile

40,00Lei

Manusi Abu Garcia Stretch Gloves M

Manusi Abu Garcia Stretch Gloves M

1202021

Livrare imediată!

118,96Lei(-24%) 90,90Lei

Rucsac Abu Garcia Backpack

Rucsac Abu Garcia Backpack

1530848

Livrare imediată!

317,00Lei

Afişare 941 - 960 din 1078 (54 pagini)

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

1 (0.071)

SELECT data
FROM `oc_session`
WHERE session_id = '53e040a5fb8f6b8bcd28f919d9'

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

2 (0.070)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.088)

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

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

4 (0.088)

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

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

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

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

7 (0.137)

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