Berkley

Berkley

Sortare după:

Shad BERKLEY Soft Bait Sick Vibe, Bream, 12cm, 40buc/pac

Shad BERKLEY Soft Bait Sick Vibe, Bream, 12cm, 40buc/pac

1536455

Livrare 7-14 zile

366,03Lei

Ruleta Berkley URBN Measure Mat, 100cm

Ruleta Berkley URBN Measure Mat, 100cm

1532103

Livrare imediată!

74,21Lei

Spinnertail BERKLEY Pulse Spintail, Brown Chartreuse, 6cm, 9g

Spinnertail BERKLEY Pulse Spintail, Brown Chartreuse, 6cm, 9g

1543277

Livrare 7-14 zile

37,61Lei

Suport Sonar Berkley Fish Finder Holder Small

Suport Sonar Berkley Fish Finder Holder Small

1601095

Livrare imediată!

70,14Lei

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

Cicada Berkley Powerblade, Tiger Prawn, 5.9cm, 18g

Cicada Berkley Powerblade, Tiger Prawn, 5.9cm, 18g

1595296

Livrare imediată!

49,82Lei

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.10mm, 6.20kg, 150m

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.10mm, 6.20kg, 150m

1553680

Livrare 7-14 zile

87,43Lei

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.12mm, 1800m

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.12mm, 1800m

1553721

Livrare 7-14 zile

999,50Lei

Chatterbait BERKLEY Hard Bait DEX TG, Wagasaki, 11cm, 21g

Chatterbait BERKLEY Hard Bait DEX TG, Wagasaki, 11cm, 21g

1570835

Livrare 7-14 zile

86,41Lei

Pasta BERKLEY PowerBait EU Glitter Trout Dough, Black Orange Glitter, 50g

Pasta BERKLEY PowerBait EU Glitter Trout Dough, Black Orange Glitter, 50g

1633566

Livrare 7-14 zile

37,61Lei

Shad BERKLEY Sick Vamper, Wagasaki, 18cm, 16buc/pac

Shad BERKLEY Sick Vamper, Wagasaki, 18cm, 16buc/pac

1570911

Livrare 7-14 zile

265,37Lei

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Garlic, Fluo Orange Glitter, 50g

Pasta BERKLEY PowerBait Natural Glitter Trout Dough, Garlic, Fluo Orange Glitter, 50g

1633597

Livrare 7-14 zile

37,61Lei

Shad BERKLEY Soft Bait Sick Vibe, Bloody Burbot, 15cm, 20buc/pac

Shad BERKLEY Soft Bait Sick Vibe, Bloody Burbot, 15cm, 20buc/pac

1570975

Livrare 7-14 zile

245,03Lei

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

38,62Lei

Vobler BERKLEY Dex Stunna Plus1, T-Bone, 11cm, 14g

Vobler BERKLEY Dex Stunna Plus1, T-Bone, 11cm, 14g

1572721

Livrare 7-14 zile

82,34Lei

Larva BERKLEY PowerBait Power Pillar, Fluorescent Orange / Sunshine Yellow, 5.5cm, 10buc/pac

Larva BERKLEY PowerBait Power Pillar, Fluorescent Orange / Sunshine Yellow, 5.5cm, 10buc/pac

1621171

Livrare 7-14 zile

38,62Lei

Fir Monofilament BERKLEY Trilene Sensation Mono, Clear, 2.20kg, 0.16mm, 300m

Fir Monofilament BERKLEY Trilene Sensation Mono, Clear, 2.20kg, 0.16mm, 300m

1579629

Livrare 7-14 zile

49,82Lei

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

Vobler BERKLEY DEX Strider, 12cm, 20g, Green Mackerel, 1buc/pac

Vobler BERKLEY DEX Strider, 12cm, 20g, Green Mackerel, 1buc/pac

1591037

Livrare 7-14 zile

74,21Lei

Afişare 1121 - 1140 din 2323 (117 pagini)

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

1 (0.150)

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

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

2 (0.095)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.123)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'

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

4 (0.116)

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

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

5 (75.549)

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 = '2' AND p.manufacturer_id = '54'

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

6 (76.634)

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

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

7 (0.236)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37