Berkley

Berkley

Sortare după:

Chatterbait BERKLEY Hard Bait DEX TG, Matt Kinkuro, 8cm, 11g

Chatterbait BERKLEY Hard Bait DEX TG, Matt Kinkuro, 8cm, 11g

1560584

Livrare 7-14 zile

72,18Lei

Vobler BERKLEY Dex Mullet Popper, 14.5cm, 69g, Mahi Mahi, 1buc/pac

Vobler BERKLEY Dex Mullet Popper, 14.5cm, 69g, Mahi Mahi, 1buc/pac

1550603

Livrare 7-14 zile

82,34Lei

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

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

1570819

Livrare 7-14 zile

68,11Lei

Vobler BERKLEY DEX Bullet Jerk, 8cm, 7.5g, Brown Trout, 1buc/pac

Vobler BERKLEY DEX Bullet Jerk, 8cm, 7.5g, Brown Trout, 1buc/pac

1550632

Livrare 7-14 zile

74,21Lei

Fir Berkley Nautil Boat Shockleader, 29kg, 0.80mm, 30m

Fir Berkley Nautil Boat Shockleader, 29kg, 0.80mm, 30m

1560570

Livrare 7-14 zile

118,96Lei

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

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

1553698

Livrare 7-14 zile

150,48Lei

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Banana Fluo Orange, 50g

Pasta BERKLEY PowerBait Trout Dough Fruits Floating, Banana Fluo Orange, 50g

1633556

Livrare imediată!

37,61Lei

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Cheese, Sherbet Glitter, 50g

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Cheese, Sherbet Glitter, 50g

1633589

Livrare 7-14 zile

37,61Lei

Larva BERKLEY PowerBait Power Larvae, Orng / Snsne Yellow, 5.5cm, 10buc/pac

Larva BERKLEY PowerBait Power Larvae, Orng / Snsne Yellow, 5.5cm, 10buc/pac

1621123

Livrare 7-14 zile

38,62Lei

Grub BERKLEY PowerBait Power Leech, Fluorescent Orange / Sunshine Yellow, 6cm, 10buc/pac

Grub BERKLEY PowerBait Power Leech, Fluorescent Orange / Sunshine Yellow, 6cm, 10buc/pac

1621155

Livrare 7-14 zile

38,62Lei

Vobler BERKLEY Dex Stunna 100 Plus1, Kinkuro, 10cm, 10.3g

Vobler BERKLEY Dex Stunna 100 Plus1, Kinkuro, 10cm, 10.3g

1621026

Livrare 7-14 zile

78,27Lei

Vobler BERKLEY Dex Thumper, Ayu, 7cm, 27.6g

Vobler BERKLEY Dex Thumper, Ayu, 7cm, 27.6g

1621009

Livrare 7-14 zile

78,27Lei

Fir Textil BERKLEY Whiplash 8, Crystal, 0.14mm, 19.2kg, 300m

Fir Textil BERKLEY Whiplash 8, Crystal, 0.14mm, 19.2kg, 300m

1579665

Livrare imediată!

190,13Lei

Jig BERKLEY Fusion19 Bismuth Ned Heads, 7g, 3buc/pac

Jig BERKLEY Fusion19 Bismuth Ned Heads, 7g, 3buc/pac

1571061

Livrare imediată!

37,61Lei

MOMEALA BERKLEY ARTIF. GULP RAMA ROSU

MOMEALA BERKLEY ARTIF. GULP RAMA ROSU

1092973

Livrare imediată!

39,64Lei

Jig BERKELY URBN Tungsten Jigheads, Nr.1, 3g, 3buc/pac

Jig BERKELY URBN Tungsten Jigheads, Nr.1, 3g, 3buc/pac

1525651

Livrare 7-14 zile

33,54Lei

Fir Textil BERKLEY X5 FLURO VERDE 0.08MM/7.6KG/150M

Fir Textil BERKLEY X5 FLURO VERDE 0.08MM/7.6KG/150M

p.1486744

Livrare 24-48 ore

113,35Lei

Fir Textil BERKLEY Whiplash 8, Yellow, 300m, 0.16mm, 20.8kg

Fir Textil BERKLEY Whiplash 8, Yellow, 300m, 0.16mm, 20.8kg

1579728

Livrare 7-14 zile

190,13Lei

Fir Textil Berkley x5 Braid Flame Green 0.17mm 17kg 150m

Fir Textil Berkley x5 Braid Flame Green 0.17mm 17kg 150m

1486748

Livrare imediată!

87,43Lei

Cleste Berkley Long Reach Plier 11in

Cleste Berkley Long Reach Plier 11in

1402789

Livrare imediată!

164,71Lei

Afişare 1781 - 1800 din 2155 (108 pagini)

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

1 (0.075)

SELECT data
FROM `oc_session`
WHERE session_id = 'dac67061e77594fd04f9a3c836'

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.096)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'

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

4 (0.090)

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

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

5 (41.667)

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

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

6 (66.820)

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 = '54' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1780,20

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

7 (0.177)

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