BUG REPORT INFORMATION

Centreon Web version: 2.7.6

Steps to reproduce the issue:

1. Go to the log page

Describe the results you received:
It does following request (a full scan):
SELECT SQL_CALC_FOUND_ROWS DISTINCT logs.* FROM logs WHERE logs.ctime > '1466936710' AND (( (msg_type = '2' AND status IN ('0','1','2','3'))) OR ( ((msg_type IN ('0', '10', '11') AND status IN ('0','1','2','3')) ) )) AND msg_type NOT IN ('4','5') ORDER BY ctime DESC, host_name ASC, log_id DESC, service_description ASC LIMIT 0, 30;

Describe the results you expected:
I think we can removed following order by 'host_name ASC, log_id DESC, service_description ASC'. time is enough.
The DISTINCT could be removed when we don't use ACL. DISTINCT has a purpose only with ACL stuffs.

Additional information you think important (e.g. issue happens only occasionally):