Berkley

Berkley

Sortare după:

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.39mm, 300m

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.39mm, 300m

1553703

Livrare 7-14 zile

169,79Lei

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Banana SS Yellow, 50g

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Banana SS Yellow, 50g

1633555

Livrare 7-14 zile

37,61Lei

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Fish Pellet Glitter, 50g

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Fish Pellet Glitter, 50g

1633607

Livrare 7-14 zile

37,61Lei

Larva BERKLEY PowerBait Power Larvae, Slmn Egg Red / Black, 4cm, 10buc/pac

Larva BERKLEY PowerBait Power Larvae, Slmn Egg Red / Black, 4cm, 10buc/pac

1621128

Livrare 7-14 zile

38,62Lei

Grub BERKLEY PowerBait Power Leech, Salmon Egg Red / Black, 6cm, 10buc/pac

Grub BERKLEY PowerBait Power Leech, Salmon Egg Red / Black, 6cm, 10buc/pac

1621160

Livrare 7-14 zile

38,62Lei

Larva BERKLEY PowerBait Power Pillar, Fluorescent Orange / Sunshine Yellow, 4cm, 12buc/pac

Larva BERKLEY PowerBait Power Pillar, Fluorescent Orange / Sunshine Yellow, 4cm, 12buc/pac

1621163

Livrare 7-14 zile

38,62Lei

Vobler BERKLEY Dex Stunna 100 Plus1, Stone Cold, 10cm, 10.3g

Vobler BERKLEY Dex Stunna 100 Plus1, Stone Cold, 10cm, 10.3g

1621027

Livrare 7-14 zile

78,27Lei

Vobler BERKLEY Dex Thumper, Matte Bone, 7cm, 27.6g

Vobler BERKLEY Dex Thumper, Matte Bone, 7cm, 27.6g

1590332

Livrare 7-14 zile

78,27Lei

Lanseta BERKLEY Cherrywood Spinning Rod Original H, 30-60g, 2.70m, 2seg

Lanseta BERKLEY Cherrywood Spinning Rod Original H, 30-60g, 2.70m, 2seg

1531543

Livrare 7-14 zile

207,41Lei

Fir Textil BERKLEY Whiplash 8, Moss Green, 0.08mm, 12.9kg, 300m

Fir Textil BERKLEY Whiplash 8, Moss Green, 0.08mm, 12.9kg, 300m

1579691

Livrare imediată!

190,13Lei

Atractant Berkley Powerbait Sandre

Atractant Berkley Powerbait Sandre

1011028

Livrare imediată!

34,55Lei

Fir Textil Berkley X9 Fluo Galben 0.06mm 150m 6.4kg

Fir Textil Berkley X9 Fluo Galben 0.06mm 150m 6.4kg

p.1486845

Livrare 24-48 ore

139,13Lei

Fir Textil BERKLEY Whiplash 8, Yellow, 300m, 0.25mm, 40.0kg

Fir Textil BERKLEY Whiplash 8, Yellow, 300m, 0.25mm, 40.0kg

1579731

Livrare 7-14 zile

190,13Lei

Cleste Berkley Split Ring Pliers

Cleste Berkley Split Ring Pliers

1402792

Livrare imediată!

95,57Lei

Fir Textil BERKLEY Flex Braid, Moss Green, 0.20mm, 6.8kg, 275m

Fir Textil BERKLEY Flex Braid, Moss Green, 0.20mm, 6.8kg, 275m

1579834

Livrare 7-14 zile

87,43Lei

Cicada BERKLEY Rattlin Powerblade, Firetiger, 5.5cm, 17g, 1buc/pac

Cicada BERKLEY Rattlin Powerblade, Firetiger, 5.5cm, 17g, 1buc/pac

1550666

Livrare 7-14 zile

41,67Lei

Creatura Berkley PowerBait Power Nymph Green Chartreuse, 2.5cm

Creatura Berkley PowerBait Power Nymph Green Chartreuse, 2.5cm

1307573

Livrare imediată!

34,55Lei

Fir Monofilament Inaintas BERKLEY Trilene Big Game, 130lbs/58.9kg, 100m

Fir Monofilament Inaintas BERKLEY Trilene Big Game, 130lbs/58.9kg, 100m

1116697

Livrare 7-14 zile

174,87Lei

Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.28mm, 5.90kg

Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.28mm, 5.90kg

1391573

Livrare 7-14 zile

40,66Lei

Viermi Berkley Powerbait Honey Orange Pearl, 2.5cm

Viermi Berkley Powerbait Honey Orange Pearl, 2.5cm

1546774

Livrare imediată!

29,48Lei

Afişare 981 - 1000 din 2126 (107 pagini)

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

1 (0.085)

SELECT data
FROM `oc_session`
WHERE session_id = '4a07599b7c544d355632d5132c'

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

2 (0.097)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.098)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'

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

4 (0.141)

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

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

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

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

7 (0.139)

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