[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