Berkley


Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.25mm, 4.90kg

Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.25mm, 4.90kg

1391572
Livrare imediată!

39,00Lei

Fir Monofilament Berkley Flex Boat Transparent, 200m, 0.45mm, 13.1kg

Fir Monofilament Berkley Flex Boat Transparent, 200m, 0.45mm, 13.1kg

1561407
Livrare imediată!

32,00Lei

Fir Monofilament Conic BERKLEY Nautil Surf Tapered, Clear, 200m, 0.28mm-0.57mm, 4.7-16.1kg

Fir Monofilament Conic BERKLEY Nautil Surf Tapered, Clear, 200m, 0.28mm-0.57mm, 4.7-16.1kg

1561411
Livrare 7-14 zile

60,00Lei

Shad Berkley PowerBait Ice Snake Tongue Minnow, Black Gold, 3.8cm, 14buc/pac -28%

Shad Berkley PowerBait Ice Snake Tongue Minnow, Black Gold, 3.8cm, 14buc/pac

1398979
Livrare imediată!

14,14Lei(-28%) 10,12Lei

Shad Berkley Sick Vibe, Salt & Pepper, 9cm

Shad Berkley Sick Vibe, Salt & Pepper, 9cm

1531829
Livrare imediată!

6,55Lei

Spinnertail Berkley Pulse, Jailbird, 14g, 7cm

Spinnertail Berkley Pulse, Jailbird, 14g, 7cm

1543295
Livrare imediată!

38,00Lei

Larve Power Bait Pupa, Milky White, 3.5cm, 10buc/cutie

Larve Power Bait Pupa, Milky White, 3.5cm, 10buc/cutie

1594924
Livrare imediată!

37,00Lei

Chatterbait BERKLEY Hard Bait DEX TG, Firetiger, 7.5cm, 7g

Chatterbait BERKLEY Hard Bait DEX TG, Firetiger, 7.5cm, 7g

1570818
Livrare 7-14 zile

66,00Lei

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Chunky Cherry, 50g

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Chunky Cherry, 50g

1633552
Livrare 7-14 zile

36,00Lei

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Garlic, Chartreuse Glitter, 50g

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Garlic, Chartreuse Glitter, 50g

1633594
Livrare 7-14 zile

36,00Lei

Larva BERKLEY PowerBait Power Curly, Salmon Egg Red / Black, 4cm, 12buc/pac

Larva BERKLEY PowerBait Power Curly, Salmon Egg Red / Black, 4cm, 12buc/pac

1621136
Livrare 7-14 zile

37,00Lei

Larva BERKLEY PowerBait Power Pillar, Salmon Egg Red / Black, 4cm, 12buc/pac

Larva BERKLEY PowerBait Power Pillar, Salmon Egg Red / Black, 4cm, 12buc/pac

1621168
Livrare 7-14 zile

37,00Lei

Vobler BERKLEY Dex Stunna 112 Plus2, Ayu, 11.2cm, 15g

Vobler BERKLEY Dex Stunna 112 Plus2, Ayu, 11.2cm, 15g

1621033
Livrare 7-14 zile

84,00Lei

Vobler BERKLEY Dex Thumper, Rainbow Trout, 7cm, 27.6g

Vobler BERKLEY Dex Thumper, Rainbow Trout, 7cm, 27.6g

1621010
Livrare 7-14 zile

76,01Lei

Fir Textil BERKLEY Whiplash8, Yellow, 150m, 0.25mm, 40.0kg

Fir Textil BERKLEY Whiplash8, Yellow, 150m, 0.25mm, 40.0kg

1579721
Livrare 7-14 zile

105,01Lei

MOMEALA BERKLEY ARTIF. GULP RAMA ROSU

MOMEALA BERKLEY ARTIF. GULP RAMA ROSU

1092973
Livrare imediată!

38,00Lei

Fir Textil BERKLEY X5 FLURO VERDE 0.14MM/14.0KG/150M

Fir Textil BERKLEY X5 FLURO VERDE 0.14MM/14.0KG/150M

p.1486747
Livrare 24-48 ore

78,69Lei

Cap Jig BERKLEY Fusion19 Screw-In Head, 50g, 2buc/pac

Cap Jig BERKLEY Fusion19 Screw-In Head, 50g, 2buc/pac

1571091
Livrare 7-14 zile

22,00Lei

Fir fluorocarbon Berkley Big Game Fluorocarbon Leader 0.74mm 25kg 91m

Fir fluorocarbon Berkley Big Game Fluorocarbon Leader 0.74mm 25kg 91m

1248509
Livrare imediată!

131,99Lei

Cicada BERKLEY Rattlin Powerblade, Bleak, 4.5cm, 10g, 1buc/pac

Cicada BERKLEY Rattlin Powerblade, Bleak, 4.5cm, 10g, 1buc/pac

1550671
Livrare 7-14 zile

40,00Lei

Afişare 721 - 740 din 1483 (75 pagini)
Queries: 7, Total time: 95.607 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '58e00234af175f9cc8a019a01a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '54' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (38.669)
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 = '54'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (56.324)
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 = '54' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 720,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.107)
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