Abu Garcia

Abu Garcia

Sortare după:

Geanta Abu Garcia All-Round Game Bag

Geanta Abu Garcia All-Round Game Bag

1207934

Livrare imediată!

134,96Lei(-21%) 106,90Lei

Rucsac Abu Garcia Basic

Rucsac Abu Garcia Basic

1200623

Livrare imediată!

224,96Lei(-21%) 176,91Lei

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, OR Black, 300g, 19cm

Pilker Abu Garcia Lucas, OR Black, 300g, 19cm

1134626

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

Combo Abu Garcia Max Pro Casting M, 10-40g, 1.98m, 2seg

Combo Abu Garcia Max Pro Casting M, 10-40g, 1.98m, 2seg

1548577

Livrare 7-14 zile

554,00Lei

Rotativa Abu Garcia Salmon Seeker Pack, Assorted, 24g, 13cm, 3buc/pac

Rotativa Abu Garcia Salmon Seeker Pack, Assorted, 24g, 13cm, 3buc/pac

1549955

Livrare 7-14 zile

120,00Lei

Pilker ABU GARCIA Sillen, Holo White Blue, 13cm, 150g, 1buc/pac

Pilker ABU GARCIA Sillen, Holo White Blue, 13cm, 150g, 1buc/pac

1096780

Livrare 7-14 zile

43,99Lei

Lingurita Oscilanta Abu Garcia Atom Green Flash 7.5cm 20g

Lingurita Oscilanta Abu Garcia Atom Green Flash 7.5cm 20g

1312813

Livrare 7-14 zile

28,00Lei

Husa Individuala Abu Garcia Beast Pro Rod Sleeve 4.5FT

Husa Individuala Abu Garcia Beast Pro Rod Sleeve 4.5FT

1528421

Livrare imediată!

153,86Lei

LINGURITA OSCILANTA ABU GARCIA TOBY, ASSORTED, 7.5CM, 20G, 3BUC/PLIC

LINGURITA OSCILANTA ABU GARCIA TOBY, ASSORTED, 7.5CM, 20G, 3BUC/PLIC

1550267

Livrare 7-14 zile

80,00Lei

Shad Abu Garcia Svartzonker McPrey Kit, Sunrise Herring, 11.5g, 12cm, 4buc/plic

Shad Abu Garcia Svartzonker McPrey Kit, Sunrise Herring, 11.5g, 12cm, 4buc/plic

1522325

Livrare 7-14 zile

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

Cizme Piept Abu Garcia Vadarbyxor Waders, Marime 40/41

Cizme Piept Abu Garcia Vadarbyxor Waders, Marime 40/41

1433015

Livrare imediată!

369,00Lei

Ochelari de Soare Polarizati Abu Garcia Eyewear Spike Glass Green

Ochelari de Soare Polarizati Abu Garcia Eyewear Spike Glass Green

1561294

Livrare 7-14 zile

211,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Miltona Walleye, 17cm, 48g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Miltona Walleye, 17cm, 48g, 2buc/pac

1590299

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

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

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

1530645

Livrare 7-14 zile

40,00Lei

LANSETA ABU GARCIA VENDETTA V3 802ML SPINNING 2.44M 5-20G 2seg

LANSETA ABU GARCIA VENDETTA V3 802ML SPINNING 2.44M 5-20G 2seg

1544428

Livrare imediată!

382,45Lei(-21%) 300,90Lei

PILKER ABU GARCIA SILLEN, HOLOGRAPHIC BLUE, 350G

PILKER ABU GARCIA SILLEN, HOLOGRAPHIC BLUE, 350G

1127031

Livrare 7-14 zile

68,00Lei

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

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

1056562

Livrare 7-14 zile

52,00Lei

Afişare 1221 - 1240 din 1277 (64 pagini)

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

1 (0.166)

SELECT data
FROM `oc_session`
WHERE session_id = '3fc0c8d82f87d2e34a4768db7b'

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

2 (0.152)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.153)

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

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

4 (0.209)

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

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

5 (44.270)

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 = '0' AND p.manufacturer_id = '122'

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

6 (46.347)

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

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

7 (0.117)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37