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  
593,408 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/multiplechoice/1958161
  CLASS/METHOD  
verb/multiplechoice
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 2 (0.0144 seconds)  (Hide)
0.0135  
            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 = '1958161'
                AND infinitive_translations.verified = 1
                AND activity_translations.activity_id = '1958161'
                AND activity_tenses.activity_id = '1958161'
            GROUP BY tenses.id, pronouns.id, infinitive_translations.infinitive_id
         
0.0010   SELECT `favorite`
FROM `favorites`
WHERE `user_id` IS NULL
AND `activity_id` = '1958161' 
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 6 (0.0072 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` = '1958161' 
0.0004   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '1958161' 
0.0003   SELECT `tenses`.`id`, `tenses`.`text`
FROM `activity_tenses`
JOIN `tenses` ON `activity_tenses`.`tense_id` = `tenses`.`id`
WHERE `activity_tenses`.`activity_id` = '1958161' 
0.0004   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.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.0053   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` = '1'
LEFT JOIN `infinitives` ON `infinitive_translations`.`infinitive_id` = `infinitives`.`id`
WHERE `activity_translations`.`activity_id` = '1958161'
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)