Berkley

Berkley

Sortare după:

Pasta, Berkley, Power, Bait, Trout, Sunshine, Yellow, 1004828, Atractanti Rapitori, Atractanti Rapitori Berkley, Berkley

Pasta, Berkley, Power, Bait, Trout, Sunshine, Yellow, 1004828, Atractanti Rapitori, Atractanti Rapitori Berkley, Berkley

1004828

Livrare imediată!

29,21Lei

Fir Monofilament Berkley Trilene Big Game Rosu 32.5kg 0.70MM 600M

Fir Monofilament Berkley Trilene Big Game Rosu 32.5kg 0.70MM 600M

1342729

Livrare imediată!

103,05Lei(-38%) 63,90Lei

Vobler Berkley Choppo, MF Frog 7.5cm, 14g

Vobler Berkley Choppo, MF Frog 7.5cm, 14g

1542709

Livrare imediată!

50,96Lei

Fir, Textil, Berkley, Sick, Braid,, HV, Yellow,, 150m,, 0.06mm,, 5.4kg, 1558743, Fire Textile Rapitori, Fire Textile Rapitori Berkley, Berkley

Fir, Textil, Berkley, Sick, Braid,, HV, Yellow,, 150m,, 0.06mm,, 5.4kg, 1558743, Fire Textile Rapitori, Fire Textile Rapitori Berkley, Berkley

1558743

Livrare imediată!

90,00Lei(-9%) 82,00Lei

Pasta Flotanta Berkley PowerBait Natural Trout Bait Fruits, Plum

Pasta Flotanta Berkley PowerBait Natural Trout Bait Fruits, Plum

1525278

Livrare imediată!

31,46Lei

Fir, Fluorocarbon, Berkley, Sick, FC, Leader,, Clear,, 50m,, 0.22mm,, 3.7kg, 1558785, Fire Monofilament Rapitori, Fire Monofilament Rapitori Berkley, Berkley

Fir, Fluorocarbon, Berkley, Sick, FC, Leader,, Clear,, 50m,, 0.22mm,, 3.7kg, 1558785, Fire Monofilament Rapitori, Fire Monofilament Rapitori Berkley, Berkley

1558785

Livrare imediată!

42,49Lei(-20%) 34,00Lei

Vobler, Berkley, Pulse, Fry, Shallow,, Frog,, 3.8cm,, 4.5g, 1571666, Voblere Floating, Voblere Floating Berkley, Berkley

Vobler, Berkley, Pulse, Fry, Shallow,, Frog,, 3.8cm,, 4.5g, 1571666, Voblere Floating, Voblere Floating Berkley, Berkley

1571666

Livrare imediată!

31,46Lei

Vobler, Berkley, DEX, Bullet, Jerk, TSR,, Golden, Trout,, 5cm,, 5g, 1572695, Voblere Sinking, Voblere Sinking Berkley, Berkley

Vobler, Berkley, DEX, Bullet, Jerk, TSR,, Golden, Trout,, 5cm,, 5g, 1572695, Voblere Sinking, Voblere Sinking Berkley, Berkley

1572695

Livrare imediată!

63,96Lei

Swimbait, Berkley, PowerBait, Power, Sardine,, White, Chart,, 12cm,, 20g,, 3buc/pac, 1571010, Swimbaits, Swimbaits Berkley, Berkley

Swimbait, Berkley, PowerBait, Power, Sardine,, White, Chart,, 12cm,, 20g,, 3buc/pac, 1571010, Swimbaits, Swimbaits Berkley, Berkley

1571010

Livrare 7-14 zile

35,96Lei

Fir Monofilament Berkley Nautil, Turquoise, 6.6kg, 0.30mm, 600m

Fir Monofilament Berkley Nautil, Turquoise, 6.6kg, 0.30mm, 600m

1560532

Livrare imediată!

89,21Lei

Vobler, Berkley, Pulse, Biggie,, Red, Head,, 6cm,, 15g, 1577401, Voblere Floating, Voblere Floating Berkley, Berkley

Vobler, Berkley, Pulse, Biggie,, Red, Head,, 6cm,, 15g, 1577401, Voblere Floating, Voblere Floating Berkley, Berkley

1577401

Livrare imediată!

33,96Lei

Vobler, Berkley, Flatt, Shad,, Ayu,, 20g,, 6.6cm, , 1532668, Voblere Sinking, Voblere Sinking Berkley, Berkley

Vobler, Berkley, Flatt, Shad,, Ayu,, 20g,, 6.6cm, , 1532668, Voblere Sinking, Voblere Sinking Berkley, Berkley

1532668

Livrare imediată!

46,71Lei

Montura Mikado Cu Vartej Si Ancora Dubla, 25cm, 10kg, Brown, 2buc/plic

Montura Mikado Cu Vartej Si Ancora Dubla, 25cm, 10kg, Brown, 2buc/plic

zg11-011

Livrare 48-72 ore

3,00Lei

Vobler, Berkley, Dredger, Crank, Floating,, Perch,, 5cm,, 9g,, 1buc/pac, 1550560, Voblere Floating, Voblere Floating Berkley, Voblere Berkley, Floating Berkley, Berkley

Vobler, Berkley, Dredger, Crank, Floating,, Perch,, 5cm,, 9g,, 1buc/pac, 1550560, Voblere Floating, Voblere Floating Berkley, Voblere Berkley, Floating Berkley, Berkley

1550560

Livrare 7-14 zile

55,21Lei

Fir Monofilament Berkley Trilene Big Game Verde15.0kg 0.48mm 600m

Fir Monofilament Berkley Trilene Big Game Verde15.0kg 0.48mm 600m

1342708

Livrare imediată!

110,46Lei

Fir Monofilament Berkley Trilene Big Game Verde 25kg 0.60MM 600M

Fir Monofilament Berkley Trilene Big Game Verde 25kg 0.60MM 600M

1342710

Livrare imediată!

110,46Lei(-22%) 85,89Lei

Montura Berkley Fusion19 Softbait Stingers, Nr.8, 6cm, 3buc/plic

Montura Berkley Fusion19 Softbait Stingers, Nr.8, 6cm, 3buc/plic

1571052

Livrare imediată!

25,45Lei

Vobler, Berkley, DEX, Ripper,, Wagasaki,, 5cm,, 9.8g, 1572672, Voblere Sinking, Voblere Sinking Berkley, Berkley

Vobler, Berkley, DEX, Ripper,, Wagasaki,, 5cm,, 9.8g, 1572672, Voblere Sinking, Voblere Sinking Berkley, Berkley

1572672

Livrare imediată!

59,96Lei

Fir Berkley Whiplash8, Yellow, 17.6kg, 0.12mm, 150m

Fir Berkley Whiplash8, Yellow, 17.6kg, 0.12mm, 150m

1579716

Livrare imediată!

112,46Lei

Vobler, Berkley, DEX, Trencher, Floating,, White, Chartreuse,, 4cm,, 5g, 1572650, Voblere Floating, Voblere Floating Berkley, Voblere Berkley, Floating Berkley, Berkley

Vobler, Berkley, DEX, Trencher, Floating,, White, Chartreuse,, 4cm,, 5g, 1572650, Voblere Floating, Voblere Floating Berkley, Voblere Berkley, Floating Berkley, Berkley

1572650

Livrare 7-14 zile

59,96Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 819 (41 pagini)

Queries: 9, Total time: 73.121 ms [By time] [By id] [By file]

1 (0.067)

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

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

2 (0.064)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.125)

SELECT `trigger`, `action`
FROM oc_event

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

4 (0.132)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'

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

5 (0.127)

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

6 (31.301)

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:1650

7 (41.074)

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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20

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

8 (0.115)

SELECT *
FROM oc_platforma_promovari

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

9 (0.116)

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

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