| 1 | SHOW FULL COLUMNS FROM `groups` | | 20 | 20 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `users` | | 19 | 19 | 1 |
| 4 | SHOW FULL COLUMNS FROM `groupshots` | | 4 | 4 | 1 |
| 5 | SHOW FULL COLUMNS FROM `best_groupshots` | | 5 | 5 | 1 |
| 6 | SHOW FULL COLUMNS FROM `assets` | | 27 | 27 | 1 |
| 7 | SHOW FULL COLUMNS FROM `provider_accounts` | | 9 | 9 | 1 |
| 8 | SHOW FULL COLUMNS FROM `groups_provider_accounts` | | 4 | 4 | 1 |
| 9 | SHOW FULL COLUMNS FROM `shared_edits` | | 6 | 6 | 1 |
| 10 | SHOW FULL COLUMNS FROM `user_edits` | | 21 | 21 | 1 |
| 11 | SHOW FULL COLUMNS FROM `best_usershots` | | 5 | 5 | 1 |
| 12 | SHOW FULL COLUMNS FROM `usershots` | | 4 | 4 | 1 |
| 13 | SHOW FULL COLUMNS FROM `assets_usershots` | | 3 | 3 | 1 |
| 14 | SHOW FULL COLUMNS FROM `collections` | | 14 | 14 | 1 |
| 15 | SHOW FULL COLUMNS FROM `assets_collections` | | 5 | 5 | 1 |
| 16 | SHOW FULL COLUMNS FROM `collections_groups` | | 6 | 6 | 1 |
| 17 | SHOW FULL COLUMNS FROM `tags` | | 9 | 9 | 1 |
| 18 | SHOW FULL COLUMNS FROM `tagged` | | 8 | 8 | 1 |
| 19 | SHOW FULL COLUMNS FROM `assets_groups` | | 7 | 7 | 1 |
| 20 | SHOW FULL COLUMNS FROM `assets_groupshots` | | 3 | 3 | 1 |
| 21 | SHOW FULL COLUMNS FROM `profiles` | | 27 | 27 | 1 |
| 22 | SHOW FULL COLUMNS FROM `auth_accounts` | | 19 | 19 | 1 |
| 23 | SHOW FULL COLUMNS FROM `groups_users` | | 11 | 11 | 1 |
| 24 | SHOW FULL COLUMNS FROM `metadata` | | 10 | 10 | 1 |
| 25 | SHOW FULL COLUMNS FROM `comments` | | 19 | 19 | 1 |
| 26 | SHOW FULL COLUMNS FROM `permissions` | | 6 | 6 | 1 |
| 27 | SELECT SQL_CALC_FOUND_ROWS (null), `Asset`.*, `AssetPermission`.*, `Asset`.`id` FROM `assets` AS `Asset` LEFT JOIN `provider_accounts` AS `ProviderAccount` ON (`Asset`.`provider_account_id` = `ProviderAccount`.`id`) INNER JOIN `users` AS `Owner` ON (`Asset`.`owner_id` = `Owner`.`id`) LEFT JOIN `shared_edits` AS `SharedEdit` ON (`Asset`.`asset_hash` = `SharedEdit`.`asset_hash`) 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 1=0 LIMIT 24 | | 0 | 0 | 0 |
| 28 | /* paginateCount for Asset @1337570960 */ SELECT FOUND_ROWS(); | | 1 | 1 | 0 |
| 29 | SELECT `User`.`id`, `User`.`username` FROM `users` AS `User` WHERE `id` IS NULL | | 0 | 0 | 0 |
| 30 | SELECT `Group`.*, `GroupPermission`.* FROM `groups` AS `Group` INNER JOIN `users` AS `Owner` ON (`Group`.`owner_id` = `Owner`.`id`) INNER JOIN `permissions` AS `GroupPermission` ON (`GroupPermission`.`foreignId` = `Group`.`id` AND `GroupPermission`.`perms` & 512 <> 0 AND `GroupPermission`.`model` = 'Group' AND `GroupPermission`.`foreignId` = `Group`.`id`) WHERE `Group`.`id` = 'member---0123-4567-89ab-000000000004' LIMIT 1 | | 1 | 1 | 0 |
