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.0205
Total Execution Time  0.0210
  GET DATA  
No GET data exists
  MEMORY USAGE  
564,096 bytes
  POST DATA  
No POST data exists
  URI STRING  
vocabulary/multiplechoice/17794
  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 = '17794'
            GROUP BY v.text
            ORDER BY vt.id ASC
         
0.0009   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '17794' 
  DATABASE:  conjuguemos-prod (Vocabulary:$reader)   QUERIES: 2 (0.0008 seconds)  (Hide)
0.0005   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` = '17794' 
0.0003   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '17794' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)