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.0538
Total Execution Time  0.0542
  GET DATA  
No GET data exists
  MEMORY USAGE  
614,112 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/multiplechoice/127
  CLASS/METHOD  
verb/multiplechoice
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 2 (0.0201 seconds)  (Hide)
0.0192  
            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 = '127'
                AND infinitive_translations.verified = 1
                AND activity_translations.activity_id = '127'
                AND activity_tenses.activity_id = '127'
            GROUP BY tenses.id, pronouns.id, infinitive_translations.infinitive_id
         
0.0009   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '127' 
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 6 (0.0115 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` = '127' 
0.0003   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '127' 
0.0003   SELECT `tenses`.`id`, `tenses`.`text`
FROM `activity_tenses`
JOIN `tenses` ON `activity_tenses`.`tense_id` = `tenses`.`id`
WHERE `activity_tenses`.`activity_id` = '127' 
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.0098   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` = '127'
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)