Biwaa

Biwaa

Sortare după:

Shad Biwaa Warax 10 cm culoare Biwaa Blast

Shad Biwaa Warax 10 cm culoare Biwaa Blast

b001495

Livrare 48-72 ore

31,40Lei

Shad Armored Craw 3 7.5cm 05 Green Pumpkin 8/plic

Shad Armored Craw 3 7.5cm 05 Green Pumpkin 8/plic

b000675

Livrare 48-72 ore

31,40Lei

Shad Biwaa Tailgunr Swimbait 3.5 9cm 302 Alburno 7/plic

Shad Biwaa Tailgunr Swimbait 3.5 9cm 302 Alburno 7/plic

b001430

Livrare imediată!

30,49Lei

Shad Biwaa Deus 4 10cm culoare 106 Wakasagi 7/plic

Shad Biwaa Deus 4 10cm culoare 106 Wakasagi 7/plic

b000870

Livrare imediată!

30,49Lei

SWIMBAIT BIWAA SPINJET 10CM 18G PEARL WHITE

SWIMBAIT BIWAA SPINJET 10CM 18G PEARL WHITE

b001654

Livrare imediată!

54,79Lei

SHAD Biwaa DEUS 15cm 303 Pro Blue 4buc/plic

SHAD Biwaa DEUS 15cm 303 Pro Blue 4buc/plic

b001373

Livrare 48-72 ore

31,40Lei

Spinnertail Biwaa Divinator Kompact 90 Gold Perch 9cm 55g 1buc

Spinnertail Biwaa Divinator Kompact 90 Gold Perch 9cm 55g 1buc

b001359

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

Shad BiWAA Divinator S Evo 4", 315 Neon Scale Minnow, 10cm, 4buc/pac

Shad BiWAA Divinator S Evo 4", 315 Neon Scale Minnow, 10cm, 4buc/pac

b002027

Livrare 48-72 ore

42,59Lei

SHAD BIWAA SUBMISSION 13cm CULOARE FIRE TIGER 3BUC

SHAD BIWAA SUBMISSION 13cm CULOARE FIRE TIGER 3BUC

b000845

Livrare imediată!

57,93Lei

Shad Biwaa Deus 10cm culoare 310 Kaleido Star

Shad Biwaa Deus 10cm culoare 310 Kaleido Star

b001203

Livrare 48-72 ore

31,40Lei

Biwaa Seven Section 15cm/60g culoare Real Perch

Biwaa Seven Section 15cm/60g culoare Real Perch

b000066

Livrare 48-72 ore

143,25Lei

Shad Biwaa Warax 7.5cm culoare Pearl White

Shad Biwaa Warax 7.5cm culoare Pearl White

b001137

Livrare 48-72 ore

31,40Lei

VOBLER SWIMBAIT BIWAA STROUT US SHAD 16CM 52G

VOBLER SWIMBAIT BIWAA STROUT US SHAD 16CM 52G

b000531

Livrare 48-72 ore

143,25Lei

SHAD BIWAA DIVINATOR KOMPACT 50 5cm 20gr 23 Northern Pike

SHAD BIWAA DIVINATOR KOMPACT 50 5cm 20gr 23 Northern Pike

b001354

Livrare imediată!

50,72Lei

Vobler Biwaa Seven Section S5 13cm 34gr 03 Real Shad

Vobler Biwaa Seven Section S5 13cm 34gr 03 Real Shad

b000064

Livrare 48-72 ore

123,93Lei

Shad Biwaa Kapsiz 12,7cm, culoare 202 Limetreuse

Shad Biwaa Kapsiz 12,7cm, culoare 202 Limetreuse

b001588

Livrare 48-72 ore

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

SHAD Biwaa DEUS 2" 5.1cm 008 Pearl White 14buc/plic

SHAD Biwaa DEUS 2" 5.1cm 008 Pearl White 14buc/plic

b001496

Livrare 48-72 ore

31,40Lei

Naluca Biwaa Warax PBNJ 10cm 6buc/plic

Naluca Biwaa Warax PBNJ 10cm 6buc/plic

b001519

Livrare 48-72 ore

31,40Lei

Vobler Biwaa Glider Raffal Yellow Perch 13cm 75g

Vobler Biwaa Glider Raffal Yellow Perch 13cm 75g

b001707

Livrare 48-72 ore

84,28Lei

Afişare 281 - 300 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: 69.238 ms [By time] [By id] [By file]

1 (0.094)

SELECT data
FROM `oc_session`
WHERE session_id = '2c9fbd71ffb6f9b8ecf9edabe7'

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

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.144)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Biwaa'

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

4 (0.098)

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.079)

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

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

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

7 (0.113)

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