| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `comments` | 19 | 19 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `permissions` | 6 | 6 | 1 | |
| 4 | SELECT SQL_CALC_FOUND_ROWS (null), `Asset`.*, `AssetPermission`.*, `Shot`.id AS `shot_id`, `Shot`.assets_usershot_count AS `shot_count`, SharedEdit.score, SharedEdit.votes, coalesce(UserEdit.rating, SharedEdit.score) AS rating, coalesce(UserEdit.rotate, SharedEdit.rotate) AS rotate, `Asset`.`id` FROM `assets` AS `Asset` LEFT JOIN `assets_usershots` AS `AssetsUsershot` ON (`AssetsUsershot`.`asset_id` = `Asset`.`id`) LEFT JOIN `usershots` AS `Shot` ON (`Shot`.`id` = `AssetsUsershot`.`usershot_id` AND `Shot`.`owner_id` = `Asset`.`owner_id`) LEFT JOIN `best_usershots` AS `BestShotSystem` ON (`BestShotSystem`.`usershot_id` = `Shot`.`id` AND `BestShotSystem`.`user_id` IS NULL) LEFT JOIN `best_usershots` AS `BestShotOwner` ON (`BestShotOwner`.`usershot_id` = `Shot`.`id` AND `BestShotOwner`.`user_id` = `Asset`.`owner_id`) LEFT JOIN `best_usershots` AS `BestShotMember` ON (`BestShotMember`.`usershot_id` = `Shot`.`id` AND `BestShotMember`.user_id IS NULL) LEFT JOIN `shared_edits` AS `SharedEdit` ON (`SharedEdit`.`asset_hash` = `Asset`.`asset_hash`) LEFT JOIN `user_edits` AS `UserEdit` ON (`UserEdit`.`asset_hash`=`Asset`.`asset_hash` AND `UserEdit`.`owner_id` IS NULL) LEFT JOIN `provider_accounts` AS `ProviderAccount` ON (`Asset`.`provider_account_id` = `ProviderAccount`.`id`) INNER JOIN `users` AS `Owner` ON (`Asset`.`owner_id` = `Owner`.`id`) INNER JOIN `permissions` AS `AssetPermission` ON (`AssetPermission`.`foreignId` = `Asset`.`id` AND `AssetPermission`.`perms` & 512 <> 0 AND `AssetPermission`.`model` = 'Asset' AND `AssetPermission`.`foreignId` = `Asset`.`id`) WHERE ((`Shot`.`id` IS NULL) OR (COALESCE(`BestShotMember`.`asset_id`, `BestShotOwner`.`asset_id`, `BestShotSystem`.`asset_id`) = `Asset`.`id`)) ORDER BY `SharedEdit`.`score` DESC, `Asset`.`modified` DESC, `Asset`.dateTaken ASC LIMIT 24 | 24 | 24 | 0 | |
| 5 | /* paginateCount for Asset @1337571292 */ SELECT FOUND_ROWS(); | 1 | 1 | 0 | |
| 6 | SELECT `User`.`id`, `User`.`username` FROM `users` AS `User` WHERE id IN ('4f279575-29bc-4c87-9d86-094b0afc480d', '12345678-1111-0000-0000-venice------') | 2 | 2 | 0 | |
| 7 | SELECT COUNT(*) AS `count` FROM `assets` AS `Asset` WHERE 1 = 1 | 1 | 1 | 0 |