[root@drive-mgmt1 sessions]# cat top10.1181 Top 10 longest running queries in session. ========================================== Time (sec) | Query -----------+------------------------------------------------------------ 0.078 | SELECT `oc_share`.`id`, `item_type`, `item_source`, `item_target`,`oc_share`.`parent`, `share_type`, `share_with`, `uid_owner`,`file_source`, `path`, `file_target`, `oc_share`.`permissions`,`stime`, `expiration`, `token`, `storage`, `mail_send`,`oc_storages`.`id` AS `storage_id`, `oc_filecache`.`parent` as `file_parent` FROM `oc_share` INNER JOIN `oc_filecache` ON `file_source` = ` 0.040 | INSERT INTO `oc_preferences` (`userid`, `appid`, `configkey`, `configvalue`) VALUES('username@switch.ch', 'user_ldap', 'homePath', '') 0.018 | COMMIT 0.013 | START TRANSACTION 0.012 | SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`, storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum` FROM `oc_filecache` WHERE `storage` = '4231' AND `path_hash` = [...] -----------+------------------------------------------------------------ Session started Wed Aug 30 06:14:49 2017 Connection from localhost_from_socket Username owncloud Total of 14349 statements executed. Total statement execution time 13.645 seconds Average statement execution time 0.001 seconds Total connection time 79.461 seconds