Guest

Log in Sign up

Confirm

Are you sure you want to save your score and stop the game?

Game Settings

×
  BENCHMARKS  
Loading Time: Base Classes  0.0004
Controller Execution Time ( Verb / Galapago )  0.0992
Total Execution Time  0.0996
  GET DATA  
No GET data exists
  MEMORY USAGE  
863,232 bytes
  POST DATA  
No POST data exists
  URI STRING  
verb/galapago/79
  CLASS/METHOD  
verb/galapago
  DATABASE:  conjuguemos-prod (Verb:$db)   QUERIES: 0 (0.0000 seconds)  (Hide)
No queries were run
  DATABASE:  conjuguemos-prod (Verb:$reader)   QUERIES: 8 (0.0374 seconds)  (Hide)
0.0006   SELECT `activities`.*, `teachers`.`school_id`, `teachers`.`user_id` `teacher_user_id`, `teachers`.`receive_email` `receive_email`, `activities`.`language_id`, `users`.`email` `teacher_email`, `languages`.`text` as `language_text`, `activity_types`.`description` as `type`, `verb_activity_settings`.`settings` as `settings`, `verb_activity_settings`.`pronouns` as `selected_pronouns`, `activity_types`.`description` as `type`, `users`.`last_name` `creator`
FROM `activities`
LEFT JOIN `activity_typesON `type_id`=`activity_types`.`id`
LEFT JOIN `teachersON `activities`.`teacher_id` = `teachers`.`id`
LEFT JOIN `usersON `teachers`.`user_id` = `users`.`id`
JOIN `languagesON `activities`.`language_id` = `languages`.`id`
LEFT JOIN `verb_activity_settingsON `verb_activity_settings`.`activity_id` = `activities`.`id`
WHERE `activities`.`id` = '79' 
0.0003   SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classesON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '79' 
0.0003   SELECT `tenses`.`id`, `tenses`.`text`, `tenses`.`etre`, `tenses`.`imperative`
FROM `activities`
JOIN `activity_tensesON `activity_tenses`.`activity_id` = `activities`.`id`
JOIN `tensesON `tenses`.`id` = `activity_tenses`.`tense_id`
WHERE `activities`.`id` = '79' 
0.0018   SELECT `activity_translations`.`id` as `translation_id`, `infinitives`.`id`, `infinitive_translations`.`id` as `translation_id`, if(isnull(infinitive_alternates.text)infinitives.textinfinitive_alternates.text) as original, `infinitive_alternates`.`text` `alternate`, `infinitive_translations`.`text`, `infinitive_translations`.`language_id`, `infinitive_translations`.`latin` as `latin`
FROM `activity_translations`
JOIN `infinitive_translationsON `infinitive_translations`.`id` = `activity_translations`.`translation_id`
LEFT JOIN `infinitive_alternatesON `infinitive_alternates`.`translation_id` = `infinitive_translations`.`id` and `infinitive_alternates`.`teacher_id` = 0
LEFT JOIN 
`infinitivesON `infinitive_translations`.`infinitive_id` = `infinitives`.`id`
WHERE `activity_translations`.`activity_id` = '79'
AND `infinitive_translations`.`language_id` = '4'
GROUP BY `infinitive_translations`.`text`
ORDER BY `infinitive_translations`.`textAS
0.0003   SELECT *
FROM `languages`
WHERE `id` = '4' 
0.0002   SELECT *
FROM `activity_tenses`
WHERE `activity_id` = '79' 
0.0335   SELECT TRIM(conjugation) as text, `conjugations`.`id` as `conjugation_id`, `conjugations`.`pronoun_id`, `conjugations`.`translation_id`, `conjugations`.`tense_id`, `conjugations`.`infinitive_id`, `pronouns`.`text` as `pronoun`, `order_chart`, `pronouns`.`order`, `tenses`.`etre`
FROM `conjugations`
JOIN `activity_translationsON `conjugations`.`translation_id` = `activity_translations`.`translation_id`
JOIN `pronounsON `pronouns`.`id` = `conjugations`.`pronoun_id`
JOIN `tensesON `tenses`.`id` = `conjugations`.`tense_id`
JOIN `activity_tensesON `conjugations`.`tense_id` = `activity_tenses`.`tense_id`
JOIN `activitiesON `activities`.`id` = `activity_translations`.`activity_id`
WHERE `activity_translations`.`activity_id` = '79'
AND `activity_tenses`.`activity_id` = '79'
GROUP BY `tenses`.`id`, `pronouns`.`id`, `conjugations`.`translation_id`, `conjugation`
ORDER BY `pronouns`.`orderAS
0.0004   SELECT `letter`, `prompt`, `alphabet`, `prompt_redesign`
FROM `special_characters`
WHERE `language` = 'italian' 
  DATABASE:  conjuguemos-prod (Pronoun:$reader)   QUERIES: 1 (0.0339 seconds)  (Hide)
0.0339   SELECT `p`.*
FROM `activities` `a`
JOIN `activity_translations` `atON `a`.`id`=`at`.`activity_id`
JOIN `conjugations` `cON `at`.`translation_id` = `c`.`translation_id`
JOIN `pronouns` `pON `p`.`id` = `c`.`pronoun_id`
WHERE `a`.`id` = '79'
AND `c`.`verified` = 1
AND `tense_idIN('90')
GROUP BY `c`.`pronoun_id
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)