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 ( Verb / Multiplechoice )  0.0396
Total Execution Time  0.0401
  GET DATA  
No GET data exists
  MEMORY USAGE  
597,536 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/multiplechoice/139
  CLASS/METHOD  
verb/multiplechoice
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 2 (0.0134 seconds)  (Hide)
0.0125  
            SELECT
                JSON_ARRAYAGG(TRIM(conjugation)) as answers,
                tenses.id as tense_id,
                pronouns.id as pronoun_id,
                infinitive_translations.infinitive_id as infinitive_id,
                infinitive_translations.id as translation_id
            FROM conjugations
                JOIN activity_translations ON conjugations.translation_id = activity_translations.translation_id
                JOIN pronouns ON pronouns.id = conjugations.pronoun_id
                JOIN tenses ON tenses.id = conjugations.tense_id
                JOIN activity_tenses ON conjugations.tense_id = activity_tenses.tense_id
                JOIN infinitive_translations ON infinitive_translations.id = activity_translations.translation_id
                                                AND tenses.language_id = infinitive_translations.language_id
            WHERE
                    activity_tenses.activity_id = '139'
                AND infinitive_translations.verified = 1
                AND activity_translations.activity_id = '139'
                AND activity_tenses.activity_id = '139'
            GROUP BY tenses.id, pronouns.id, infinitive_translations.infinitive_id
         
0.0009   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '139' 
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 6 (0.0063 seconds)  (Hide)
0.0006   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` = '139' 
0.0003   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '139' 
0.0003   SELECT `tenses`.`id`, `tenses`.`text`
FROM `activity_tenses`
JOIN `tenses` ON `activity_tenses`.`tense_id` = `tenses`.`id`
WHERE `activity_tenses`.`activity_id` = '139' 
0.0003   SELECT `pronouns`.`id`, `pronouns`.`text`, `pronouns`.`weight`, `pronouns`.`order_chart`
FROM `pronouns`
WHERE `pronouns`.`language_id` = '5'
AND `pronouns`.`imperative` != "negative"
ORDER BY `pronouns`.`order` ASC 
0.0003   SELECT `s`.`text` as `substitute`, `p`.`text` as `pronoun`, `p`.`id`, `order`, `order_chart`
FROM `pronoun_substitutes` as `s`
JOIN `pronouns` as `p` ON `p`.`id`=`s`.`pronoun_id`
WHERE `p`.`language_id` = '5' 
0.0045   SELECT `infinitives`.`id`, IF(ISNULL(infinitive_alternates.text), infinitives.text, infinitive_alternates.text) AS text, `infinitive_translations`.`id` AS `translation_id`, `infinitive_translations`.`text` AS `translation`
FROM `activity_translations`
JOIN `infinitive_translations` ON `infinitive_translations`.`id` = `activity_translations`.`translation_id`
LEFT JOIN `infinitive_alternates` ON `infinitive_alternates`.`translation_id` = `infinitive_translations`.`id` and `infinitive_alternates`.`teacher_id` = 0
LEFT JOIN `infinitives` ON `infinitive_translations`.`infinitive_id` = `infinitives`.`id`
WHERE `activity_translations`.`activity_id` = '139'
AND `infinitive_translations`.`language_id` = '5'
GROUP BY `infinitive_translations`.`text`
ORDER BY `infinitive_translations`.`text` ASC 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)