sardinia
last visit: on 10/2/12
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 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 | 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 | 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 | SELECT SQL_CALC_FOUND_ROWS (null), `Member`.* FROM `users` AS `Member` INNER JOIN `groups` AS `GroupOwner` ON (`GroupOwner`.`id` = 'member---0123-4567-89ab-000000000004') LEFT JOIN `groups_users` AS `HABTM` ON (`HABTM`.`user_id` = `Member`.`id` AND `HABTM`.`group_id`= 'member---0123-4567-89ab-000000000004') WHERE ((`Member`.`id` = `GroupOwner`.`owner_id`) OR (`HABTM`.`user_id` IS NOT NULL)) ORDER BY `Member`.`lastVisit` DESC LIMIT 24 | 2 | 2 | 0 | |
| 27 | /* paginateCount for Member @1337570935 */ SELECT FOUND_ROWS(); | 1 | 1 | 0 | |
| 28 | SHOW FULL COLUMNS FROM `permissions` | 6 | 6 | 1 | |
| 29 | SELECT `Group`.*, `GroupPermission`.* FROM `groups` AS `Group` 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 |
