MIM TEAM

MIM TEAM

Sortare după:

Lanseta DAM Yagi Light Spoon 2.10m 2-5gr

Lanseta DAM Yagi Light Spoon 2.10m 2-5gr

2040970665

Livrare imediată!

235,32Lei

Cosulet Naditor DAM Detek Groundbait Feeder Inline 15gr

Cosulet Naditor DAM Detek Groundbait Feeder Inline 15gr

4200466040

Livrare imediată!

13,75Lei

Bocanci DAM WP Boot 43-8 Grey Black

Bocanci DAM WP Boot 43-8 Grey Black

8140965342

Livrare imediată!

515,27Lei

Cosulet Naditor DAM Detek Flex Feeder Inline M 15gr

Cosulet Naditor DAM Detek Flex Feeder Inline M 15gr

a.dam.66012

Livrare 24-48 ore

12,16Lei(-41%) 7,18Lei

Cosulet Naditor DAM Detek Groundbait Feeder cu Vartej 80gr

Cosulet Naditor DAM Detek Groundbait Feeder cu Vartej 80gr

4200466044

Livrare 48-72 ore

21,05Lei

Lanseta DAM Shadow Tele 2.40m 25-40g

Lanseta DAM Shadow Tele 2.40m 25-40g

2040970350

Livrare imediată!

243,46Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 80gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 80gr

a.dam.66037

Livrare imediată!

22,03Lei(-24%) 16,69Lei

Cosulet Naditor DAM Detek River Feeder cu Vartej 120gr

Cosulet Naditor DAM Detek River Feeder cu Vartej 120gr

4200466048

Livrare imediată!

26,60Lei

Matrita DAM Detek Feeder Mold M

Matrita DAM Detek Feeder Mold M

svs66026

Livrare imediată!

20,95Lei(-48%) 10,89Lei

Cosulet Naditor DAM Detek Groundbait Feeder cu Vartej 50gr

Cosulet Naditor DAM Detek Groundbait Feeder cu Vartej 50gr

4200466043

Livrare imediată!

18,30Lei(-22%) 14,21Lei

Kit 4 Lansete Prowess Scorpium, 3.00Lbs, 3.60m, 3seg

Kit 4 Lansete Prowess Scorpium, 3.00Lbs, 3.60m, 3seg

995010072

Livrare imediată!

1.466,65Lei(-43%) 839,27Lei

Cosulet Naditor DAM Detek Flex Feeder Inline L 50gr

Cosulet Naditor DAM Detek Flex Feeder Inline L 50gr

a.dam.66015

Livrare 24-48 ore

15,86Lei(-43%) 9,06Lei

Cosulet Naditor DAM Detek River Feeder cu Vartej 100gr

Cosulet Naditor DAM Detek River Feeder cu Vartej 100gr

4200466047

Livrare imediată!

24,55Lei

Agrafa Vartej Rolling DAM Detek Swivel Bead cu Margea Culisanta

Agrafa Vartej Rolling DAM Detek Swivel Bead cu Margea Culisanta

svs66004

Livrare 7-14 zile

17,45Lei

Cosulet Naditor DAM Detek Groundbait Feeder Inline 35gr

Cosulet Naditor DAM Detek Groundbait Feeder Inline 35gr

a.dam.66042

Livrare imediată!

7,90Lei

Kit 4 Lansete Prowess Scorpium, 3.50Lbs, 3.90m, 3seg

Kit 4 Lansete Prowess Scorpium, 3.50Lbs, 3.90m, 3seg

995010073

Livrare imediată!

1.621,18Lei

Cosulet Naditor DAM Detek Flex Feeder Inline L 35gr

Cosulet Naditor DAM Detek Flex Feeder Inline L 35gr

a.dam.66014

Livrare 24-48 ore

14,33Lei(-42%) 8,28Lei

Cosulet Naditor DAM Detek River Feeder cu Vartej 80gr

Cosulet Naditor DAM Detek River Feeder cu Vartej 80gr

4200466046

Livrare 48-72 ore

21,26Lei

Agrafa Vartej DAM Detek Double Link Swivel Nr.12

Agrafa Vartej DAM Detek Double Link Swivel Nr.12

4030466001

Livrare imediată!

14,48Lei

Cosulet Naditor DAM Detek Groundbait Feeder Inline 25gr

Cosulet Naditor DAM Detek Groundbait Feeder Inline 25gr

4200466041

Livrare 48-72 ore

14,42Lei

1
2
>
>|

Afişare 1 - 20 din 27 (2 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: 2.142 ms [By time] [By id] [By file]

1 (0.171)

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

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

2 (0.113)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.141)

SELECT *
FROM oc_url_alias
WHERE keyword = 'mim-team.html'

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

4 (0.140)

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

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

5 (0.417)

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

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

6 (1.025)

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

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

7 (0.135)

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