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.0004
Controller Execution Time ( Vocabulary / Multiplechoice )  0.0297
Total Execution Time  0.0301
  GET DATA  
No GET data exists
  MEMORY USAGE  
560,032 bytes
  POST DATA  
No POST data exists
  URI STRING  
vocabulary/multiplechoice/17842
  CLASS/METHOD  
vocabulary/multiplechoice
  DATABASE:  conjuguemos-prod (Vocabulary:$db)   QUERIES: 2 (0.0024 seconds)  (Hide)
0.0015  
            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 = '17842'
            GROUP BY v.text
            ORDER BY vt.id ASC
         
0.0010   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '17842' 
  DATABASE:  conjuguemos-prod (Vocabulary:$reader)   QUERIES: 2 (0.0011 seconds)  (Hide)
0.0007   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` = '17842' 
0.0004   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '17842' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)