Biwaa

Biwaa

Sortare după:

Shad Biwaa DEUS 2" 5.1cm 202 Limetreuse 14/plic

Shad Biwaa DEUS 2" 5.1cm 202 Limetreuse 14/plic

b001498

Livrare 48-72 ore

31,40Lei

Spinnerbait Biwaa Dogon 21g Gold Ayu-Gold Blades

Spinnerbait Biwaa Dogon 21g Gold Ayu-Gold Blades

b001566

Livrare imediată!

54,99Lei(-45%) 30,40Lei

VOBLER BIWAA GLIDER RAFFAL FIRE TIGER 10CM 43G

VOBLER BIWAA GLIDER RAFFAL FIRE TIGER 10CM 43G

b001723

Livrare imediată!

74,11Lei

SHAD Biwaa KAPSIZ 7.5cm 206 Golden Shiner 7buc/plic

SHAD Biwaa KAPSIZ 7.5cm 206 Golden Shiner 7buc/plic

b001639

Livrare 48-72 ore

26,00Lei(-21%) 20,42Lei

Spinnertail Biwaa Divinator Medium Rainbow 18cm 35g

Spinnertail Biwaa Divinator Medium Rainbow 18cm 35g

b001319

Livrare 48-72 ore

60,89Lei

Vobler Swimbait Biwaa Seven Section Real Bass 15cm 60g

Vobler Swimbait Biwaa Seven Section Real Bass 15cm 60g

b000065

Livrare 48-72 ore

143,25Lei

SHAD BIWAA SUBMISSION 4 10cm 75 Ghost Perch 4buc/plic

SHAD BIWAA SUBMISSION 4 10cm 75 Ghost Perch 4buc/plic

b001969

Livrare 48-72 ore

58,85Lei

Shad BIWAA TailGunR Swimbait 4.5", 311 Sexy Shad, 11.50cm, 5buc/pac

Shad BIWAA TailGunR Swimbait 4.5", 311 Sexy Shad, 11.50cm, 5buc/pac

b002008

Livrare 48-72 ore

31,40Lei

SHAD BIWAA SUBMISSION 10cm CULOARE ROACH 4BUC

SHAD BIWAA SUBMISSION 10cm CULOARE ROACH 4BUC

b000971

Livrare imediată!

45,00Lei(-35%) 29,37Lei

Shad Biwaa Deus 10cm culoare 305 Levander

Shad Biwaa Deus 10cm culoare 305 Levander

b001200

Livrare imediată!

30,49Lei

Shad Biwaa Submission 13cm culoare Watermelon Red

Shad Biwaa Submission 13cm culoare Watermelon Red

b000843

Livrare 48-72 ore

58,85Lei

Vobler Biwaa Strout 9cm, 8g, Culoare Rainbow

Vobler Biwaa Strout 9cm, 8g, Culoare Rainbow

b000802

Livrare imediată!

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

Shad Biwaa Warax 10 cm culoare Black and Blue

Shad Biwaa Warax 10 cm culoare Black and Blue

b001161

Livrare 48-72 ore

31,40Lei

Rezerva coada Biwaa Strout 16cm Red and Smoke 2 buc

Rezerva coada Biwaa Strout 16cm Red and Smoke 2 buc

b000724

Livrare 48-72 ore

30,40Lei

Shad Biwaa Tailgunr Swimbait 3.5 9cm 013 Lemon 7/plic

Shad Biwaa Tailgunr Swimbait 3.5 9cm 013 Lemon 7/plic

b001423

Livrare imediată!

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

Shad Biwaa Ultra Hog 7.5cm culoare 102 Cinnamon 10/plic

Shad Biwaa Ultra Hog 7.5cm culoare 102 Cinnamon 10/plic

b001110

Livrare 48-72 ore

30,40Lei

VOBLER BIWAA GLIDER RAFFAL BLUE GILL 10CM 43G

VOBLER BIWAA GLIDER RAFFAL BLUE GILL 10CM 43G

b001599

Livrare imediată!

74,11Lei

SHAD Biwaa DEUS 13cm 202 Limetreuse 5buc/plic

SHAD Biwaa DEUS 13cm 202 Limetreuse 5buc/plic

b001511

Livrare 48-72 ore

31,40Lei

Spinnertail Biwaa Divinator Kompact 90 Northern Pike 9cm 55g 1buc

Spinnertail Biwaa Divinator Kompact 90 Northern Pike 9cm 55g 1buc

b001358

Livrare 48-72 ore

59,87Lei

Vobler Biwaa Glider Raffal Pearl White 13cm 75g

Vobler Biwaa Glider Raffal Pearl White 13cm 75g

b001753

Livrare 48-72 ore

84,28Lei

Afişare 441 - 460 din 489 (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: 58.755 ms [By time] [By id] [By file]

1 (0.114)

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

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

2 (0.072)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.097)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Biwaa'

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

4 (0.099)

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

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

5 (25.986)

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

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

6 (32.290)

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

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

7 (0.097)

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