Warning: SLOW QUERY detected
---------------------------------------------------
SELECT
f.ID,f.WebUserID
FROM tblFile f JOIN tblContent c ON (f.ID=c.DID AND c.DocumentTable="tblFile") LEFT JOIN tblContent cc0 ON (cc0.DID=f.ID AND cc0.DocumentTable="tblFile" AND cc0.nHash=x'438be0a3237d9c39f12763670f4a73e3')
WHERE f.IsFolder=0 AND f.IsPublished=1 AND f.IsSearchable=1 AND f.DocType IN(3) AND (f.ParentID IN (382)) GROUP BY f.ID ORDER BY COALESCE(cc0.Dat,cc0.BDID) LIMIT 0,100000000
---------------------------------------------------
Array
(
[time] => 1.2262160778046
[trigger] => 0
[errno] => 0
[error] =>
[affected] => 131
[rows] => 131
[explain] => Array
(
[0] => id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra
[1] => 1 | SIMPLE | f | ref | PRIMARY,ParentID,searchable,IsFolder,IsPublished | searchable | 7 | const,const,const | 129 | Using where; Using temporary; Using filesort
[2] => 1 | SIMPLE | cc0 | eq_ref in /home/clients/f74b5caf129d0174e8565372c95d7258/web/unit_ch/webEdition/we/include/we_global.inc.php on line 306