EnergoTeam


Juvelnic EnergoTeam 4 inele diam 30cm PT-34

72100004
Livrare imediată!

20,90Lei

8,40Lei

19,90Lei

10,39Lei

142,90Lei

21,90Lei

Momitor Feeder Patrat 25Gr

58073025
Livrare imediată!

6,90Lei

COADA NADIRE CARP HUNTER 1.00 MT

79650700
Livrare imediată!

31,90Lei

MOMITOR ENERGO CU TUB PLASTIC 45GR

58063945
Livrare 24-48 ore

8,90Lei

208,90Lei

19,00Lei

8,90Lei

8,90Lei

8,90Lei

8,90Lei

PLUMB ENERGO TEAM TIP TIGARA CU TUB 100G

52728100
Livrare imediată!

12,90Lei

Suport feeder EnergoTeam Feeder-Match Rest 17

xs613014
Livrare imediată!

36,90Lei

Minciog Energo Team Basic 2.00m Negru

71300201
Livrare imediată!

61,00Lei

Perna Energo Team NEMO

74016170
Livrare 24-48 ore

136,90Lei

Sita Energo Team Patrata 17x17CM 2MM

75629173
Livrare imediată!

24,00Lei

Afişare 441 - 460 din 1208 (61 pagini)
Queries: 7, Total time: 105.154 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '2659672aef484b61307809c1de'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'energoteam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.093)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '24' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (48.117)
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 = '24'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (56.519)
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 = '24' 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.110)
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