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.0356
Total Execution Time  0.0360
  GET DATA  
No GET data exists
  MEMORY USAGE  
589,216 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/multiplechoice/65
  CLASS/METHOD  
verb/multiplechoice
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 2 (0.0084 seconds)  (Hide)
0.0076  
            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 = '65'
                AND infinitive_translations.verified = 1
                AND activity_translations.activity_id = '65'
                AND activity_tenses.activity_id = '65'
            GROUP BY tenses.id, pronouns.id, infinitive_translations.infinitive_id
         
0.0009   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '65' 
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 6 (0.0035 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` = '65' 
0.0004   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '65' 
0.0003   SELECT `tenses`.`id`, `tenses`.`text`
FROM `activity_tenses`
JOIN `tenses` ON `activity_tenses`.`tense_id` = `tenses`.`id`
WHERE `activity_tenses`.`activity_id` = '65' 
0.0004   SELECT `pronouns`.`id`, `pronouns`.`text`, `pronouns`.`weight`, `pronouns`.`order_chart`
FROM `pronouns`
WHERE `pronouns`.`language_id` = '4'
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` = '4' 
0.0013   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` = '65'
AND `infinitive_translations`.`language_id` = '4'
GROUP BY `infinitive_translations`.`text`
ORDER BY `infinitive_translations`.`text` ASC 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)