| 1 | DESCRIBE `requests` | | 20 | 20 | 1 |
| 2 | DESCRIBE `users` | | 7 | 7 | 1 |
| 3 | DESCRIBE `factories` | | 9 | 9 | 1 |
| 4 | DESCRIBE `operatingsystems` | | 7 | 7 | 0 |
| 5 | DESCRIBE `platforms` | | 5 | 5 | 0 |
| 6 | DESCRIBE `jobs` | | 13 | 13 | 1 |
| 7 | DESCRIBE `applications` | | 5 | 5 | 0 |
| 8 | DESCRIBE `workers` | | 8 | 8 | 1 |
| 9 | DESCRIBE `doctypes` | | 4 | 4 | 0 |
| 10 | DESCRIBE `mimetypes` | | 6 | 6 | 0 |
| 11 | DESCRIBE `formats` | | 4 | 4 | 0 |
| 12 | DESCRIBE `formats_workers` | | 3 | 3 | 0 |
| 13 | DESCRIBE `applications_doctypes` | | 3 | 3 | 0 |
| 14 | DESCRIBE `doctypes_workers` | | 3 | 3 | 0 |
| 15 | DESCRIBE `results` | | 13 | 13 | 1 |
| 16 | DESCRIBE `validators` | | 7 | 7 | 0 |
| 17 | DESCRIBE `groups` | | 7 | 7 | 1 |
| 18 | DESCRIBE `permissions` | | 5 | 5 | 0 |
| 19 | DESCRIBE `groups_users` | | 3 | 3 | 0 |
| 20 | DESCRIBE `galleries` | | 12 | 12 | 1 |
| 21 | DESCRIBE `testsuites` | | 7 | 7 | 0 |
| 22 | DESCRIBE `galleries_requests` | | 3 | 3 | 0 |
| 23 | SELECT DISTINCT
`Worker`.`version`,
`Worker`.`development`,
`Platform`.`id`,
`Platform`.`name`,
`Doctype`.`id`,
`Doctype`.`name`,
`Doctype`.`code`,
`Application`.`id`,
`Application`.`name`
FROM `workers` AS `Worker`
LEFT JOIN `factories` AS `Factory` ON (`Worker`.`factory_id` = `Factory`.`id`)
LEFT JOIN `operatingsystems` AS `Operatingsystem` ON (`Factory`.`operatingsystem_id` = `Operatingsystem`.`id`)
LEFT JOIN `platforms` AS `Platform` ON (`Operatingsystem`.`platform_id` = `Platform`.`id`)
LEFT JOIN `applications` AS `Application` ON (`Worker`.`application_id` = `Application`.`id`)
LEFT JOIN `doctypes_workers` AS `DoctypesWorker` ON `Worker`.`id` = `DoctypesWorker`.`worker_id`
LEFT JOIN `doctypes` AS `Doctype` ON (`DoctypesWorker`.`doctype_id` = `Doctype`.`id`)
WHERE `Factory`.`last_poll` > '2013-05-21 20:02:05'
ORDER BY `Platform`.`name` ASC, `Application`.`name` ASC, `Worker`.`version`, `Worker`.`development` ASC | | 0 | 0 | 1 |
| 24 | SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`order`, `Platform`.`created`, `Platform`.`modified` FROM `platforms` AS `Platform` WHERE 1 = 1 ORDER BY `Platform`.`order` ASC | | 4 | 4 | 0 |
| 25 | SELECT `Operatingsystem`.`id`, `Operatingsystem`.`platform_id`, `Operatingsystem`.`name`, `Operatingsystem`.`version`, `Operatingsystem`.`codename`, `Operatingsystem`.`created`, `Operatingsystem`.`modified` FROM `operatingsystems` AS `Operatingsystem` WHERE `Operatingsystem`.`platform_id` IN ('496cb533-ab70-431f-92cc-36a5c0a80105', '496cb547-0ad8-43e2-9b66-36a5c0a80105', '496cb541-ddf0-4539-a5a8-36a5c0a80105', '49981c7e-de78-4f11-8cf3-1fcbc0a80105') | | 26 | 26 | 0 |
| 26 | SELECT `Job`.`id`, `Job`.`request_id`, `Job`.`platform_id`, `Job`.`application_id`, `Job`.`version`, `Job`.`result_id`, `Job`.`factory_id`, `Job`.`locked`, `Job`.`created`, `Job`.`updated`, `Job`.`format_id`, `Job`.`state`, `Job`.`failures` FROM `jobs` AS `Job` WHERE `Job`.`platform_id` IN ('496cb533-ab70-431f-92cc-36a5c0a80105', '496cb547-0ad8-43e2-9b66-36a5c0a80105', '496cb541-ddf0-4539-a5a8-36a5c0a80105', '49981c7e-de78-4f11-8cf3-1fcbc0a80105') | | 223 | 223 | 0 |
| 27 | SELECT `Doctype`.`id`, `Doctype`.`name`, `Doctype`.`code`, `Doctype`.`order` FROM `doctypes` AS `Doctype` WHERE 1 = 1 ORDER BY `Doctype`.`order` ASC | | 3 | 3 | 0 |
| 28 | SELECT `Mimetype`.`id`, `Mimetype`.`name`, `Mimetype`.`icon`, `Mimetype`.`doctype_id`, `Mimetype`.`format_id`, `Mimetype`.`extension` FROM `mimetypes` AS `Mimetype` WHERE `Mimetype`.`doctype_id` IN ('4970527f-d0a0-4206-b718-7900c0a80105', '49705294-bfa8-4ee2-9cec-7900c0a80105', '497052a9-0090-4c06-a483-7900c0a80105') | | 6 | 6 | 0 |
| 29 | SELECT `Application`.`id`, `Application`.`name`, `Application`.`created`, `Application`.`modified`, `Application`.`icon`, `ApplicationsDoctype`.`id`, `ApplicationsDoctype`.`application_id`, `ApplicationsDoctype`.`doctype_id` FROM `applications` AS `Application` JOIN `applications_doctypes` AS `ApplicationsDoctype` ON (`ApplicationsDoctype`.`doctype_id` IN ('4970527f-d0a0-4206-b718-7900c0a80105', '49705294-bfa8-4ee2-9cec-7900c0a80105', '497052a9-0090-4c06-a483-7900c0a80105') AND `ApplicationsDoctype`.`application_id` = `Application`.`id`) WHERE 1 = 1 | | 80 | 80 | 0 |
| 30 | SELECT `Worker`.`id`, `Worker`.`factory_id`, `Worker`.`application_id`, `Worker`.`version`, `Worker`.`development`, `Worker`.`created`, `Worker`.`modified`, `Worker`.`testsuite`, `DoctypesWorker`.`id`, `DoctypesWorker`.`doctype_id`, `DoctypesWorker`.`worker_id` FROM `workers` AS `Worker` JOIN `doctypes_workers` AS `DoctypesWorker` ON (`DoctypesWorker`.`doctype_id` IN ('4970527f-d0a0-4206-b718-7900c0a80105', '49705294-bfa8-4ee2-9cec-7900c0a80105', '497052a9-0090-4c06-a483-7900c0a80105') AND `DoctypesWorker`.`worker_id` = `Worker`.`id`) WHERE 1 = 1 | | 95 | 95 | 0 |
| 31 | SELECT `Format`.`id`, `Format`.`name` FROM `formats` AS `Format` WHERE 1 = 1 | | 3 | 3 | 0 |
| 32 | SELECT `Mimetype`.`id`, `Mimetype`.`name`, `Mimetype`.`icon`, `Mimetype`.`doctype_id`, `Mimetype`.`format_id`, `Mimetype`.`extension`, `Doctype`.`id`, `Doctype`.`name`, `Doctype`.`code`, `Doctype`.`order`, `Format`.`id`, `Format`.`name`, `Format`.`code`, `Format`.`icon` FROM `mimetypes` AS `Mimetype` LEFT JOIN `doctypes` AS `Doctype` ON (`Mimetype`.`doctype_id` = `Doctype`.`id`) LEFT JOIN `formats` AS `Format` ON (`Mimetype`.`format_id` = `Format`.`id`) WHERE 1 = 1 | | 8 | 8 | 0 |
