Berkley

Berkley

Sortare după:

Shad BERKLEY Pulse Realistic Perch, Gold Perch, 15cm, 32buc/pac

Shad BERKLEY Pulse Realistic Perch, Gold Perch, 15cm, 32buc/pac

1543315

Livrare 7-14 zile

489,03Lei

Chatterbait BERKLEY Hard Bait DEX TG, Pearl White, 11cm, 21g

Chatterbait BERKLEY Hard Bait DEX TG, Pearl White, 11cm, 21g

1560593

Livrare 7-14 zile

83,07Lei

Vobler BERKLEY DEX Fat Bullet, 13cm, 27g, Ayu, 1buc/pac

Vobler BERKLEY DEX Fat Bullet, 13cm, 27g, Ayu, 1buc/pac

1550621

Livrare 7-14 zile

78,27Lei

Fir Fluorocarbon Berkley Trilene, Clear, 7kg, 0.30mm, 150m

Fir Fluorocarbon Berkley Trilene, Clear, 7kg, 0.30mm, 150m

1580042

Livrare 7-14 zile

80,31Lei

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

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

1553695

Livrare 7-14 zile

169,79Lei

Pasta BERKLEY PowerBait Sinking Glitter Trout Dough, White Glitter, 50g

Pasta BERKLEY PowerBait Sinking Glitter Trout Dough, White Glitter, 50g

1633562

Livrare 7-14 zile

37,61Lei

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.39mm, 29.10kg, 1800m

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.39mm, 29.10kg, 1800m

1553735

Livrare 7-14 zile

1.135,75Lei

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

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

1633590

Livrare 7-14 zile

37,61Lei

Larva BERKLEY PowerBait Power Larvae, Spring Green / White, 4cm, 12buc/pac

Larva BERKLEY PowerBait Power Larvae, Spring Green / White, 4cm, 12buc/pac

1621116

Livrare 7-14 zile

38,62Lei

Grub BERKLEY PowerBait Power Leech, Green / White, 5cm, 12buc/pac

Grub BERKLEY PowerBait Power Leech, Green / White, 5cm, 12buc/pac

1621148

Livrare 7-14 zile

38,62Lei

Vobler BERKLEY Dex Stunna 100, Fire, 10cm, 10.2g

Vobler BERKLEY Dex Stunna 100, Fire, 10cm, 10.2g

1621014

Livrare 7-14 zile

78,27Lei

Vobler BERKLEY Dex Thumper, Matte Perch, 4cm, 3.7g

Vobler BERKLEY Dex Thumper, Matte Perch, 4cm, 3.7g

1600357

Livrare imediată!

62,01Lei

Fir Textil BERKLEY Sick Two In One & Fluorocarbon Duo Spool System, 0.10mm/0.35mm 150/40m, Moss Green-Fluo Clear

Fir Textil BERKLEY Sick Two In One & Fluorocarbon Duo Spool System, 0.10mm/0.35mm 150/40m, Moss Green-Fluo Clear

1572765

Livrare 7-14 zile

138,23Lei

SPRAY ATTRACTANT BERKLEY GULP MINNOW PENTRU RAPITORI

SPRAY ATTRACTANT BERKLEY GULP MINNOW PENTRU RAPITORI

1156584

Livrare imediată!

62,01Lei

Fir Textil BERKLEY X5 FLURO VERDE 0.12mm 12.00kg 150m

Fir Textil BERKLEY X5 FLURO VERDE 0.12mm 12.00kg 150m

1486746

Livrare imediată!

87,43Lei

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

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

1579741

Livrare 7-14 zile

1.317,76Lei

Grub BERKLEY PowerBait Power Naiad, Trout Pellet, 3cm, 6buc/pac

Grub BERKLEY PowerBait Power Naiad, Trout Pellet, 3cm, 6buc/pac

1621187

Livrare 7-14 zile

38,62Lei

Spinnertail Berkley Pulse Perch 7.5cm 21g

Spinnertail Berkley Pulse Perch 7.5cm 21g

1543300

Livrare imediată!

41,67Lei

Cap Jig BERKLEY Fusion19 Round Jigheads, Nr.6/0, 28g, 3buc/pac

Cap Jig BERKLEY Fusion19 Round Jigheads, Nr.6/0, 28g, 3buc/pac

1571070

Livrare 7-14 zile

23,37Lei

Fir Fluorocarbon Berkley Trilene TRLN 100FL LDR 0.45mm 25M

Fir Fluorocarbon Berkley Trilene TRLN 100FL LDR 0.45mm 25M

1324141

Livrare imediată!

36,59Lei

Afişare 2041 - 2060 din 2126 (107 pagini)

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

1 (0.159)

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

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

2 (0.125)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.135)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'

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

4 (0.146)

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

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

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

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

7 (0.133)

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