Complete Message Here
END URL here
(default) 43 queries took 157 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`882
2DESCRIBE `acos`882
3DESCRIBE `aros_acos`882
4DESCRIBE `surveys`14142
5DESCRIBE `users`22222
6DESCRIBE `groups`552
7DESCRIBE `result_states`993
8DESCRIBE `assignments`14142
9DESCRIBE `assignment_links`552
10DESCRIBE `assignment_groups`552
11DESCRIBE `assignment_users`552
12DESCRIBE `dashboards`441
13DESCRIBE `widgets`882
14DESCRIBE `sections`992
15DESCRIBE `questions`16162
16DESCRIBE `question_types`882
17DESCRIBE `model_answers`882
18DESCRIBE `questions_sections`552
19DESCRIBE `input_elements`13132
20DESCRIBE `resources`882
21DESCRIBE `settings`552
22SELECT `Assignment`.`id`, `Assignment`.`message`, `Assignment`.`title`, `Assignment`.`resumable`, `Assignment`.`public`, `Assignment`.`start_datetime`, `Assignment`.`end_datetime`, `Assignment`.`owner_id`, `Assignment`.`results_access_type_id`, `Assignment`.`response_type_id`, `Assignment`.`retake_strategy_type_id`, `Assignment`.`created`, `Assignment`.`modified`, `Assignment`.`survey_id`, `Survey`.`id`, `Survey`.`name`, `Survey`.`description`, `Survey`.`description_link`, `Survey`.`complete_message`, `Survey`.`version`, `Survey`.`prev_id`, `Survey`.`baselanguage`, `Survey`.`owner_id`, `Survey`.`fancyname`, `Survey`.`uniqueid`, `Survey`.`template`, `Survey`.`created`, `Survey`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`middle_name`, `User`.`street_address`, `User`.`address_line_2`, `User`.`city`, `User`.`state_province_region`, `User`.`county`, `User`.`country`, `User`.`zip`, `User`.`primary_phone`, `User`.`secondary_phone`, `User`.`fax`, `User`.`language`, `User`.`canlogin`, `User`.`group_id`, `User`.`created`, `User`.`modified` FROM `assignments` AS `Assignment` LEFT JOIN `surveys` AS `Survey` ON (`Assignment`.`survey_id` = `Survey`.`id`) LEFT JOIN `users` AS `User` ON (`Assignment`.`owner_id` = `User`.`id`) WHERE `Assignment`.`survey_id` = 16 110
23SELECT `ResultState`.`id`, `ResultState`.`finished`, `ResultState`.`saved_section_id`, `ResultState`.`assignment_id`, `ResultState`.`save_id`, `ResultState`.`user_id`, `ResultState`.`created`, `ResultState`.`modified`, `ResultState`.`survey_id` FROM `result_states` AS `ResultState` WHERE `ResultState`.`assignment_id` = (6) 000
24SELECT `AssignmentLink`.`id`, `AssignmentLink`.`assignment_id`, `AssignmentLink`.`group_id`, `AssignmentLink`.`created`, `AssignmentLink`.`modified` FROM `assignment_links` AS `AssignmentLink` WHERE `AssignmentLink`.`assignment_id` = (6) 000
25SELECT `Assignment`.`id`, `Assignment`.`message`, `Assignment`.`title`, `Assignment`.`resumable`, `Assignment`.`public`, `Assignment`.`start_datetime`, `Assignment`.`end_datetime`, `Assignment`.`owner_id`, `Assignment`.`results_access_type_id`, `Assignment`.`response_type_id`, `Assignment`.`retake_strategy_type_id`, `Assignment`.`created`, `Assignment`.`modified`, `Assignment`.`survey_id` FROM `assignments` AS `Assignment` LEFT JOIN `surveys` AS `Survey` ON (`Assignment`.`survey_id` = `Survey`.`id`) LEFT JOIN `users` AS `User` ON (`Assignment`.`owner_id` = `User`.`id`) WHERE `Assignment`.`id` = 6 LIMIT 1110
26SELECT `ResultState`.`id`, `ResultState`.`finished`, `ResultState`.`saved_section_id`, `ResultState`.`assignment_id`, `ResultState`.`save_id`, `ResultState`.`user_id`, `ResultState`.`created`, `ResultState`.`modified`, `ResultState`.`survey_id` FROM `result_states` AS `ResultState` WHERE `ResultState`.`assignment_id` = (6) 000
27SELECT `AssignmentLink`.`id`, `AssignmentLink`.`assignment_id`, `AssignmentLink`.`group_id`, `AssignmentLink`.`created`, `AssignmentLink`.`modified` FROM `assignment_links` AS `AssignmentLink` WHERE `AssignmentLink`.`assignment_id` = (6) 000
28SELECT `Section`.`id`, `Section`.`code`, `Section`.`description`, `Section`.`parent_id`, `Section`.`position`, `Section`.`section_type`, `Section`.`created`, `Section`.`modified`, `Section`.`survey_id`, `Survey`.`id`, `Survey`.`name`, `Survey`.`description`, `Survey`.`description_link`, `Survey`.`complete_message`, `Survey`.`version`, `Survey`.`prev_id`, `Survey`.`baselanguage`, `Survey`.`owner_id`, `Survey`.`fancyname`, `Survey`.`uniqueid`, `Survey`.`template`, `Survey`.`created`, `Survey`.`modified` FROM `sections` AS `Section` LEFT JOIN `surveys` AS `Survey` ON (`Section`.`survey_id` = `Survey`.`id`) WHERE `Section`.`survey_id` = 16 AND `Section`.`section_type` = 'page' ORDER BY `Section`.`position` ASC 110
29SELECT `Survey`.`id`, `Survey`.`name`, `Survey`.`description`, `Survey`.`description_link`, `Survey`.`complete_message`, `Survey`.`version`, `Survey`.`prev_id`, `Survey`.`baselanguage`, `Survey`.`owner_id`, `Survey`.`fancyname`, `Survey`.`uniqueid`, `Survey`.`template`, `Survey`.`created`, `Survey`.`modified` FROM `surveys` AS `Survey` WHERE `Survey`.`id` = 16 110
30SELECT `Question`.`id`, `Question`.`questiontext`, `Question`.`questionhelp`, `Question`.`questionhelpvisible`, `Question`.`mandatory`, `Question`.`randomize`, `Question`.`attributes`, `Question`.`specialclass`, `Question`.`language`, `Question`.`position`, `Question`.`code`, `Question`.`template_params`, `Question`.`created`, `Question`.`modified`, `Question`.`question_type_id`, `Question`.`survey_id`, `QuestionsSection`.`id`, `QuestionsSection`.`created`, `QuestionsSection`.`modified`, `QuestionsSection`.`question_id`, `QuestionsSection`.`section_id` FROM `questions` AS `Question` JOIN `questions_sections` AS `QuestionsSection` ON (`QuestionsSection`.`section_id` = 56 AND `QuestionsSection`.`question_id` = `Question`.`id`) WHERE 1 = 1 ORDER BY `Question`.`position` ASC 000
31SELECT `Section`.`id`, `Section`.`code`, `Section`.`description`, `Section`.`parent_id`, `Section`.`position`, `Section`.`section_type`, `Section`.`created`, `Section`.`modified`, `Section`.`survey_id`, `Survey`.`id`, `Survey`.`name`, `Survey`.`description`, `Survey`.`description_link`, `Survey`.`complete_message`, `Survey`.`version`, `Survey`.`prev_id`, `Survey`.`baselanguage`, `Survey`.`owner_id`, `Survey`.`fancyname`, `Survey`.`uniqueid`, `Survey`.`template`, `Survey`.`created`, `Survey`.`modified`, `Parent`.`id`, `Parent`.`code`, `Parent`.`description`, `Parent`.`parent_id`, `Parent`.`position`, `Parent`.`section_type`, `Parent`.`created`, `Parent`.`modified`, `Parent`.`survey_id` FROM `sections` AS `Section` LEFT JOIN `surveys` AS `Survey` ON (`Section`.`survey_id` = `Survey`.`id`) LEFT JOIN `sections` AS `Parent` ON (`Parent`.`parent_id` = `Section`.`id`) WHERE `Section`.`parent_id` = 56 ORDER BY `Section`.`position` ASC 000
32DESCRIBE `results_16`13132
33START TRANSACTION01
34INSERT INTO `results_16` (`save_id`, `value_text`, `assignment_id`, `special_type`) VALUES ('4a7fe4c9-87d4-4c42-acb1-155c52d40771', '127.0.0.1', 6, 'ipaddress')10
35SELECT LAST_INSERT_ID() AS insertID110
36INSERT INTO `results_16` (`save_id`, `value_datetime`, `assignment_id`, `special_type`) VALUES ('4a7fe4c9-87d4-4c42-acb1-155c52d40771', '2009-08-10 11:13:45', 6, 'starttime')10
37SELECT LAST_INSERT_ID() AS insertID110
38INSERT INTO `results_16` (`save_id`, `value_datetime`, `assignment_id`, `special_type`) VALUES ('4a7fe4c9-87d4-4c42-acb1-155c52d40771', '2009-08-10 11:13:45', 6, 'finishtime')10
39SELECT LAST_INSERT_ID() AS insertID110
40COMMIT0110
41SELECT `Survey`.`id`, `Survey`.`name`, `Survey`.`description`, `Survey`.`description_link`, `Survey`.`complete_message`, `Survey`.`version`, `Survey`.`prev_id`, `Survey`.`baselanguage`, `Survey`.`owner_id`, `Survey`.`fancyname`, `Survey`.`uniqueid`, `Survey`.`template`, `Survey`.`created`, `Survey`.`modified` FROM `surveys` AS `Survey` LEFT JOIN `users` AS `User` ON (`Survey`.`owner_id` = `User`.`id`) WHERE `Survey`.`id` = 16 LIMIT 1111
42SELECT `Section`.`id`, `Section`.`code`, `Section`.`description`, `Section`.`parent_id`, `Section`.`position`, `Section`.`section_type`, `Section`.`created`, `Section`.`modified`, `Section`.`survey_id` FROM `sections` AS `Section` WHERE `Section`.`survey_id` = (16) ORDER BY `Section`.`position` ASC 110
43SELECT `Assignment`.`id`, `Assignment`.`message`, `Assignment`.`title`, `Assignment`.`resumable`, `Assignment`.`public`, `Assignment`.`start_datetime`, `Assignment`.`end_datetime`, `Assignment`.`owner_id`, `Assignment`.`results_access_type_id`, `Assignment`.`response_type_id`, `Assignment`.`retake_strategy_type_id`, `Assignment`.`created`, `Assignment`.`modified`, `Assignment`.`survey_id` FROM `assignments` AS `Assignment` WHERE `Assignment`.`survey_id` = (16) 111