| 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 | 0 |
| 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 | 0 |
| 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 | 0 |
| 13 | SHOW FULL COLUMNS FROM `assets_usershots` | | 3 | 3 | 0 |
| 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 | 0 |
| 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 `Group`.*, `Owner`.`id`, `Owner`.`username`, `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 |
