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.0846
Total Execution Time  0.0850
  GET DATA  
No GET data exists
  MEMORY USAGE  
602,016 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/multiplechoice/141
  CLASS/METHOD  
verb/multiplechoice
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 2 (0.0416 seconds)  (Hide)
0.0404  
            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 = '141'
                AND infinitive_translations.verified = 1
                AND activity_translations.activity_id = '141'
                AND activity_tenses.activity_id = '141'
            GROUP BY tenses.id, pronouns.id, infinitive_translations.infinitive_id
         
0.0011   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '141' 
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 6 (0.0217 seconds)  (Hide)
0.0009   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` = '141' 
0.0004   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '141' 
0.0004   SELECT `tenses`.`id`, `tenses`.`text`
FROM `activity_tenses`
JOIN `tenses` ON `activity_tenses`.`tense_id` = `tenses`.`id`
WHERE `activity_tenses`.`activity_id` = '141' 
0.0005   SELECT `pronouns`.`id`, `pronouns`.`text`, `pronouns`.`imperative`, `pronouns`.`weight`, `pronouns`.`order_chart`
FROM `tense_imperative_pronouns`
JOIN `pronouns` ON `tense_imperative_pronouns`.`pronoun_id` = `pronouns`.`id`
WHERE `tense_id` IN('18')
AND `pronouns`.`language_id` = '5' 
0.0004   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.0191   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` = '141'
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)