Abu Garcia

Abu Garcia

Sortare după:

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

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

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

1134631

Livrare 7-14 zile

52,00Lei

Cizme Piept Abu Garcia Vadarbyxor Waders, Marime 42/43

Cizme Piept Abu Garcia Vadarbyxor Waders, Marime 42/43

1235901

Livrare imediată!

369,00Lei

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

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

1127027

Livrare 7-14 zile

43,99Lei

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

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

1303245

Livrare 7-14 zile

28,00Lei

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 Backpack

Rucsac Abu Garcia Backpack

1530848

Livrare imediată!

317,00Lei

PILKER ABU GARCIA SILLEN, HOLO SILVER BLACK, 350G

PILKER ABU GARCIA SILLEN, HOLO SILVER BLACK, 350G

1056567

Livrare 7-14 zile

68,00Lei

Lanseta Pastrav ABU GARCIA Aion Ains 612 UL E Spinning Rod, 1.87m, 0.3-5.0g, 2seg

Lanseta Pastrav ABU GARCIA Aion Ains 612 UL E Spinning Rod, 1.87m, 0.3-5.0g, 2seg

1623086

Livrare 7-14 zile

802,00Lei

Cap De Jig ABU GARCIA Beast Screw-In, 2.5g, 3buc/pac

Cap De Jig ABU GARCIA Beast Screw-In, 2.5g, 3buc/pac

1571094

Livrare imediată!

12,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Yellow Fin Perch, 21cm, 87g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Yellow Fin Perch, 21cm, 87g, 2buc/pac

1590301

Livrare 7-14 zile

56,00Lei

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

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

1084300

Livrare 7-14 zile

30,00Lei

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

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 7.2cm

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 7.2cm

1550134

Livrare 7-14 zile

48,00Lei

Mulineta Abu Garcia Ambassadeur Salmon Special 7000I, Right Hand

Mulineta Abu Garcia Ambassadeur Salmon Special 7000I, Right Hand

1187919

Livrare 7-14 zile

717,00Lei

Swimbait ABU GARCIA Svartzonker McPike, Fire Bass, 25cm, 131g, 2buc/pac

Swimbait ABU GARCIA Svartzonker McPike, Fire Bass, 25cm, 131g, 2buc/pac

1590313

Livrare 7-14 zile

72,00Lei

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

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

1084305

Livrare 7-14 zile

36,00Lei

Multiplicator Abu Garcia Zenon MG-X-SHS Low Profile Reel, Left

1552849

Livrare 7-14 zile

1.603,00Lei

Afişare 1101 - 1120 din 1141 (58 pagini)

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

1 (0.084)

SELECT data
FROM `oc_session`
WHERE session_id = '57d44e5b93f3279ff76798bdeb'

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

2 (0.146)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.150)

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

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

4 (0.137)

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

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

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

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

7 (0.112)

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