Biwaa

Biwaa

Sortare după:

Shad BIWAA TailGunR Swimbait 4.5", 301 Applet Min, 11.50cm, 5buc/pac

Shad BIWAA TailGunR Swimbait 4.5", 301 Applet Min, 11.50cm, 5buc/pac

b001446

Livrare imediată!

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

Spinnerbait Biwaa Dogon 14g, White Chart-Silver Blades

Spinnerbait Biwaa Dogon 14g, White Chart-Silver Blades

b001555

Livrare 48-72 ore

61,92Lei

SWIMBAIT BIWAA SPINJET 10CM 18G AYU

SWIMBAIT BIWAA SPINJET 10CM 18G AYU

b001659

Livrare imediată!

53,87Lei

SHAD Biwaa DEUS 15cm 307 Blue Back Chart 4buc/plic

SHAD Biwaa DEUS 15cm 307 Blue Back Chart 4buc/plic

b001376

Livrare 48-72 ore

31,40Lei

Spinnertail BiWAA Divinator Junior, 65 Rainbow Smelt, 14cm, 22g, 1buc/pac

Spinnertail BiWAA Divinator Junior, 65 Rainbow Smelt, 14cm, 22g, 1buc/pac

b001671

Livrare 48-72 ore

58,85Lei

Vobler Biwaa Glider Raffal Pike 15cm 105g

Vobler Biwaa Glider Raffal Pike 15cm 105g

b001595

Livrare 48-72 ore

92,41Lei

Vobler Biwaa Raffal Glider Sunfis, 7.5cm, 17g

Vobler Biwaa Raffal Glider Sunfis, 7.5cm, 17g

b001792

Livrare 48-72 ore

68,01Lei

Shad BiWAA Divinator S Evo 4", 305 Lavander, 10cm, 4buc/pac

Shad BiWAA Divinator S Evo 4", 305 Lavander, 10cm, 4buc/pac

b002024

Livrare 48-72 ore

42,59Lei

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE AURORA GOLD

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE AURORA GOLD

b000969

Livrare 48-72 ore

43,60Lei

Shad Biwaa Deus 7.5cm culoare 310 Kaleido Star

Shad Biwaa Deus 7.5cm culoare 310 Kaleido Star

b001180

Livrare imediată!

30,49Lei

Shad Biwaa Divinator S 15cm culoare Chart Red Back

Shad Biwaa Divinator S 15cm culoare Chart Red Back

b000590

Livrare 48-72 ore

44,62Lei

Vobler Biwaa Swimpike SS 18cm/26g culoare Northern

Vobler Biwaa Swimpike SS 18cm/26g culoare Northern

b000773

Livrare 48-72 ore

129,02Lei

Shad Biwaa Warax 7.5cm culoare Cola

Shad Biwaa Warax 7.5cm culoare Cola

b001129

Livrare 48-72 ore

31,40Lei

VOBLER SWIMBAIT BIWAA STROUT AYU 16CM 52G

VOBLER SWIMBAIT BIWAA STROUT AYU 16CM 52G

b000811

Livrare 48-72 ore

143,25Lei

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 013 Lemon 10/plic

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 013 Lemon 10/plic

b001406

Livrare imediată!

30,49Lei

Vobler Biwaa Seven Section S5 13cm 34gr 04 Fire Tiger

Vobler Biwaa Seven Section S5 13cm 34gr 04 Fire Tiger

b000214

Livrare 48-72 ore

123,93Lei

Swimbait Biwaa Spinjet 13cm, 30g, culoare 12 Fire Tiger

Swimbait Biwaa Spinjet 13cm, 30g, culoare 12 Fire Tiger

b001605

Livrare imediată!

57,84Lei

SHAD Biwaa DEUS 7.5cm 201 Fire Tiger 10buc/plic

SHAD Biwaa DEUS 7.5cm 201 Fire Tiger 10buc/plic

b001506

Livrare 48-72 ore

31,40Lei

Swimbait Biwaa Spinjet 5 Ayu 13cm 30g 1buc

Swimbait Biwaa Spinjet 5 Ayu 13cm 30g 1buc

b001617

Livrare 48-72 ore

57,84Lei

Vobler Biwaa Glider Raffal Hi Viz 13cm 75g

Vobler Biwaa Glider Raffal Hi Viz 13cm 75g

b001710

Livrare 48-72 ore

84,28Lei

Afişare 261 - 280 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: 59.835 ms [By time] [By id] [By file]

1 (0.152)

SELECT data
FROM `oc_session`
WHERE session_id = '68fbdb4f83e9113ad53a3b6853'

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

2 (0.115)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.130)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Biwaa'

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

4 (0.086)

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

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

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

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

7 (0.120)

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