Biwaa

Biwaa

Sortare după:

Vobler Biwaa Seven Section S4 10cm 17gr 12 Carassin

Vobler Biwaa Seven Section S4 10cm 17gr 12 Carassin

b000289

Livrare 48-72 ore

113,76Lei

Swimbait Biwaa Spinjet 13cm, 30g, culoare 23 Northern Pike

Swimbait Biwaa Spinjet 13cm, 30g, culoare 23 Northern Pike

b001606

Livrare imediată!

49,01Lei(-17%) 40,55Lei

SHAD Biwaa DEUS 7.5cm 202 Limetreuse 10buc/plic

SHAD Biwaa DEUS 7.5cm 202 Limetreuse 10buc/plic

b001507

Livrare 48-72 ore

31,40Lei

Swimbait Biwaa Spinjet 5 Rainbow 13cm 30g 1buc

Swimbait Biwaa Spinjet 5 Rainbow 13cm 30g 1buc

b001618

Livrare 48-72 ore

57,84Lei

Vobler Biwaa Glider Raffal Blue Chrom 13cm 75g

Vobler Biwaa Glider Raffal Blue Chrom 13cm 75g

b001711

Livrare 48-72 ore

84,28Lei

Shad BIWAA TailGunR Swimbait 4.5", 313 Smallie Party, 11.50cm, 5buc/pac

Shad BIWAA TailGunR Swimbait 4.5", 313 Smallie Party, 11.50cm, 5buc/pac

b002007

Livrare imediată!

29,00Lei(-13%) 25,30Lei

Spinnertail Biwaa Divinator, Aurora Gold, 14cm, 22g

Spinnertail Biwaa Divinator, Aurora Gold, 14cm, 22g

b000728

Livrare 48-72 ore

58,85Lei

Shad Bait Biwaa Armored Craw 10cm culoare 01 Cola

Shad Bait Biwaa Armored Craw 10cm culoare 01 Cola

b000395

Livrare 48-72 ore

31,40Lei

Shad Biwaa Divinator S 13cm culoare Pearl White

Shad Biwaa Divinator S 13cm culoare Pearl White

b000232

Livrare 48-72 ore

43,60Lei

Vobler Biwaa Seven Section 10cm/17g culoare Sunfish

Vobler Biwaa Seven Section 10cm/17g culoare Sunfish

b000516

Livrare imediată!

99,00Lei(-19%) 80,21Lei

SHAD BIWAA VENUM TAIL SMOKE PURPLE 10CM 10BUC/PLIC

SHAD BIWAA VENUM TAIL SMOKE PURPLE 10CM 10BUC/PLIC

b001094

Livrare 48-72 ore

31,40Lei

Vobler Biwaa Swimbait Srout 9cm 8gr Yamame

Vobler Biwaa Swimbait Srout 9cm 8gr Yamame

b001304

Livrare imediată!

65,00Lei(-20%) 51,74Lei

Shad Biwaa Deus 10cm 301 Apple Mint 7/plic

Shad Biwaa Deus 10cm 301 Apple Mint 7/plic

b001196

Livrare imediată!

26,00Lei(-18%) 21,24Lei

Spinnerbait Biwaa Dogon 14g 07 Sexy Shad-Silver Blades

Spinnerbait Biwaa Dogon 14g 07 Sexy Shad-Silver Blades

b001561

Livrare 48-72 ore

61,92Lei

Shad Biwaa Kapsiz 10cm, culoare 305 Levander

Shad Biwaa Kapsiz 10cm, culoare 305 Levander

b001578

Livrare imediată!

26,00Lei(-18%) 21,24Lei

SHAD Biwaa TAILGUNR SWIMBAIT 3.5" 9cm Mix Color 7buc/plic

SHAD Biwaa TAILGUNR SWIMBAIT 3.5" 9cm Mix Color 7buc/plic

b001537

Livrare 48-72 ore

31,40Lei

SWIMBAIT Biwaa SPINJET 10cm 18gr 12 Fire Tiger

SWIMBAIT Biwaa SPINJET 10cm 18gr 12 Fire Tiger

b001655

Livrare imediată!

54,79Lei

Vobler Biwaa Glider Raffal Zander Chart 7.5cm 17g

Vobler Biwaa Glider Raffal Zander Chart 7.5cm 17g

b001789

Livrare 48-72 ore

68,01Lei

Vobler Biwaa Swimpike Ruby Tiger 18cm 26g

Vobler Biwaa Swimpike Ruby Tiger 18cm 26g

b001543

Livrare 48-72 ore

129,02Lei

VOBLER BIWAA SWIMBASS SLOW SINKING BRAZINO 15CM 65G

VOBLER BIWAA SWIMBASS SLOW SINKING BRAZINO 15CM 65G

b001831

Livrare imediată!

125,01Lei(-20%) 100,55Lei

Afişare 401 - 420 din 491 (25 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

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

1 (0.110)

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

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

2 (0.135)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.116)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Biwaa'

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

4 (0.094)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '279' AND m2s.store_id = '3'

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

5 (35.994)

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

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

6 (31.795)

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

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

7 (0.109)

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