WLC


Boilies WLC Red Squid TARE 24mm 1kg

Boilies WLC Red Squid TARE 24mm 1kg

w8896
Livrare imediată!

60,06Lei

Wafters WLC Cocoon, Tutti Frutti, 6mm, 30g

Wafters WLC Cocoon, Tutti Frutti, 6mm, 30g

w13333
Livrare imediată!

28,50Lei

Pelete WLC Krill X 4mm 800g

Pelete WLC Krill X 4mm 800g

w1026
Livrare imediată!

23,40Lei

Wafters WLC Duo Balls, Mulberry Banana, 11mm, 30g

Wafters WLC Duo Balls, Mulberry Banana, 11mm, 30g

w14002
Livrare imediată!

23,40Lei

Boilies Carlig WLC Carp Critics, SPP, 16mm, 120g

Boilies Carlig WLC Carp Critics, SPP, 16mm, 120g

w11964
Livrare imediată!

23,40Lei

Pop Up Wlc Fluo Strawberry Jam Roz Fluo 11mm

Pop Up Wlc Fluo Strawberry Jam Roz Fluo 11mm

w13821
Livrare imediată!

25,44Lei

Nada WLC Feeder Pro Green Fishmeal, 800g

Nada WLC Feeder Pro Green Fishmeal, 800g

w12640
Livrare imediată!

29,51Lei

Mix PVA WLC Bagzz Ready Mix Red Squid 800g

Mix PVA WLC Bagzz Ready Mix Red Squid 800g

w1194
Livrare imediată!

24,42Lei

Wafters iBaits Magic Bands, Frisca Vanilie, 5-7mm, 40ml -16%

Wafters iBaits Magic Bands, Frisca Vanilie, 5-7mm, 40ml

0634474068886
Livrare imediată!

31,90Lei(-16%) 26,90Lei

Wafters WLC Mix Round & Dumbell, Capsuna, 11mm, 30g

Wafters WLC Mix Round & Dumbell, Capsuna, 11mm, 30g

w13722
Livrare imediată!

21,37Lei

Pop UP Wlc Scopex Portocaliu Fluo 14mm

Pop UP Wlc Scopex Portocaliu Fluo 14mm

w13906
Livrare imediată!

25,44Lei

Dumbells WLC Red Squid ( Squid & Strawberry ) 20 MM

Dumbells WLC Red Squid ( Squid & Strawberry ) 20 MM

w7905
Livrare imediată!

23,40Lei

Pelete WLC, Halibut, 4mm, 800g

Pelete WLC, Halibut, 4mm, 800g

w12893
Livrare imediată!

26,46Lei

Micropelete WLC Method Mix 2mm 800g

Micropelete WLC Method Mix 2mm 800g

w1088
Livrare imediată!

26,46Lei

Wafters WLC Duo Balls, SPP, 11mm, 30g

Wafters WLC Duo Balls, SPP, 11mm, 30g

w14019
Livrare imediată!

23,40Lei

Boilies Carlig WLC Carp Critics, Red Squid, 16mm, 120g

Boilies Carlig WLC Carp Critics, Red Squid, 16mm, 120g

w11971
Livrare imediată!

23,40Lei

Pop Up Wlc Fluo Strawberry Jam Roz Fluo 14mm

Pop Up Wlc Fluo Strawberry Jam Roz Fluo 14mm

w13883
Livrare imediată!

25,44Lei

Nada WLC Feeder Pro Brown Fishmeal, 800g

Nada WLC Feeder Pro Brown Fishmeal, 800g

w12633
Livrare imediată!

29,51Lei

Pop-up WLC Duo Airballs SPP 11mm 30g

Pop-up WLC Duo Airballs SPP 11mm 30g

w1484
Livrare imediată!

26,45Lei

Wafters WLC Cocoon, Artar, 6mm, 30g

Wafters WLC Cocoon, Artar, 6mm, 30g

w13357
Livrare imediată!

28,50Lei

Afişare 21 - 40 din 57 (3 pagini)
Queries: 7, Total time: 68.768 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'ecd2e6b5f7b31db422521a6e2b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.104)
SELECT *
FROM oc_url_alias
WHERE keyword = 'WLC'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.119)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '200' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (40.270)
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 = '0' AND p.manufacturer_id = '200'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (27.956)
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 = '0' AND p.manufacturer_id = '200' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.105)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37