Multiple Choice

00:00

0

Game Settings

Which Words do you want to use?

Please select at least one word

Here is how you did

Stopwatch
Checkmark
Cap

You must be logged in as student to record your score

  BENCHMARKS  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Vocabulary / Multiplechoice )  0.0215
Total Execution Time  0.0220
  GET DATA  
No GET data exists
  MEMORY USAGE  
572,320 bytes
  POST DATA  
No POST data exists
  URI STRING  
vocabulary/multiplechoice/17882
  CLASS/METHOD  
vocabulary/multiplechoice
  DATABASE:  conjuguemos-prod (Vocabulary:$db)   QUERIES: 2 (0.0025 seconds)  (Hide)
0.0016  
            SELECT v.text text, v.id id, JSON_ARRAYAGG(vt.text) as translations
            FROM activities av
                JOIN vocabulary_translations vt ON av.id = vt.activity_id
                JOIN vocabulary v ON vt.vocabulary_id = v.id
            WHERE av.id = '17882'
            GROUP BY v.text
            ORDER BY vt.id ASC
         
0.0009   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '17882' 
  DATABASE:  conjuguemos-prod (Vocabulary:$reader)   QUERIES: 2 (0.0011 seconds)  (Hide)
0.0008   SELECT `activities`.`id`, `activities`.`title`, `activity_types`.`description` as `type`, `languages`.`text` as `language`, `languages`.`id` as `language_id`, `public`, `active`, `instructions`, `command`, `teacher_id`, IF(ISNULL(verb_activity_settings.settings), "{}", verb_activity_settings.settings) as settings, IF(ISNULL(verb_activity_settings.pronouns), "{}", verb_activity_settings.pronouns) as selected_pronouns
FROM `activities`
JOIN `activity_types` ON `activities`.`type_id` = `activity_types`.`id`
JOIN `languages` ON `activities`.`language_id` = `languages`.`id`
LEFT JOIN `verb_activity_settings` ON `verb_activity_settings`.`activity_id` = `activities`.`id`
WHERE `activities`.`id` = '17882' 
0.0003   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '17882' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)