Profiler

View last 10 Profile for: GET https://dev.bofamaths.co.uk/tests/adaptive/demos by 216.73.216.4 at Wed, 16 Jul 2025 12:21:04 +0100

Queries

Group similar statements


SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.is_default AS is_default4, t0.has_quicktests AS has_quicktests5, t0.is_active AS is_active6, t0.sort_order AS sort_order7, t0.has_demos AS has_demos8, t0.description AS description9, t0.short_description AS short_description10 FROM test_program t0 WHERE t0.id = ?
"START TRANSACTION"
INSERT INTO users (uid, status, usertype, user_category, roles, parentid, tutorid, schoolid, safeguarding_officer_comments, dateregistered, title, forename, surname, username, email, password, salt, address1, address2, address3, address4, postcode, country, phone, sch_name, sch_address1, sch_address2, sch_address3, sch_address4, sch_postcode, sch_country, sch_phone, sch_fax, optin, dob, gender, notifications, source, groupid, version, pwd_version, nextstep, admin, token, tokendate, setup_done, email_verification_token, updated, disable_pretest_structure, disable_pretest_order, extra_test_time, logo_enabled, logo_filepath, archived_username, archived_email, archived, archived_schoolid, archived_tutorid, archived_groupid, archived_parentid, test_date, auto_reschedule_enabled, auto_reschedule_until, exam_board, test_wait_time, ability_maths, ability_english, adaptive_tests_disabled, timezone, demo_lessons_taken, guest_firstname, guest_surname, guest_email, sgo_id, subscriptionid, gcse_program_id, target_gcse_maths_level_id, current_gcse_maths_level_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1
SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1
SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.test_type = 'demo' AND t0_.program_id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1
SELECT t0_.id AS id0, t0_.pupilid AS pupilid1, t0_.datestarted AS datestarted2, t0_.datefinished AS datefinished3, t0_.dateupdated AS dateupdated4, t0_.status AS status5, t0_.adaptive_test_num AS adaptive_test_num6, t0_.timestatus AS timestatus7, t0_.score1 AS score18, t0_.score2 AS score29, t0_.score3 AS score310, t0_.clockstart AS clockstart11, t0_.allowedtime1 AS allowedtime112, t0_.duration1 AS duration113, t0_.allowedtime2 AS allowedtime214, t0_.duration2 AS duration215, t0_.testtype AS testtype16, t0_.typeid AS typeid17, t0_.levelid AS levelid18, t0_.testnum AS testnum19, t0_.version AS version20, t0_.showScore AS showScore21, t0_.paused_at AS paused_at22, t0_.has_completed_pause AS has_completed_pause23, t0_.can_retake AS can_retake24, t0_.pupilid AS pupilid25, t0_.testdef_id AS testdef_id26 FROM tests t0_ INNER JOIN test_def t1_ ON t0_.testdef_id = t1_.id WHERE t0_.pupilid = ? AND t1_.program_id = ? AND t0_.testtype = 'demo' AND t0_.status >= 2 ORDER BY t0_.id DESC
SELECT id
                FROM content
				WHERE section = :section
                AND urlname = :urlname
                AND COALESCE(parentid, 0) = :parentid AND published = 1
SELECT t0.id AS id1, t0.title AS title2, t0.description AS description3, t0.keywords AS keywords4, t0.summary AS summary5, t0.content AS content6, t0.published AS published7, t0.urlname AS urlname8, t0.section AS section9, t0.weight AS weight10, t0.tags AS tags11, t0.contexts AS contexts12, t0.parentid AS parentid13 FROM content t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?
SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ?

#▲	Time	Info
1	0.38 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.is_default AS is_default4, t0.has_quicktests AS has_quicktests5, t0.is_active AS is_active6, t0.sort_order AS sort_order7, t0.has_demos AS has_demos8, t0.description AS description9, t0.short_description AS short_description10 FROM test_program t0 WHERE t0.id = ? Parameters: [0 => 15] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.is_default AS is_default4, t0.has_quicktests AS has_quicktests5, t0.is_active AS is_active6, t0.sort_order AS sort_order7, t0.has_demos AS has_demos8, t0.description AS description9, t0.short_description AS short_description10 FROM test_program t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.is_default AS is_default4, t0.has_quicktests AS has_quicktests5, t0.is_active AS is_active6, t0.sort_order AS sort_order7, t0.has_demos AS has_demos8, t0.description AS description9, t0.short_description AS short_description10 FROM test_program t0 WHERE t0.id = 15;
2	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.91 ms	INSERT INTO users (uid, status, usertype, user_category, roles, parentid, tutorid, schoolid, safeguarding_officer_comments, dateregistered, title, forename, surname, username, email, password, salt, address1, address2, address3, address4, postcode, country, phone, sch_name, sch_address1, sch_address2, sch_address3, sch_address4, sch_postcode, sch_country, sch_phone, sch_fax, optin, dob, gender, notifications, source, groupid, version, pwd_version, nextstep, admin, token, tokendate, setup_done, email_verification_token, updated, disable_pretest_structure, disable_pretest_order, extra_test_time, logo_enabled, logo_filepath, archived_username, archived_email, archived, archived_schoolid, archived_tutorid, archived_groupid, archived_parentid, test_date, auto_reschedule_enabled, auto_reschedule_until, exam_board, test_wait_time, ability_maths, ability_english, adaptive_tests_disabled, timezone, demo_lessons_taken, guest_firstname, guest_surname, guest_email, sgo_id, subscriptionid, gcse_program_id, target_gcse_maths_level_id, current_gcse_maths_level_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [1 => 0b8d5105ba7416a190ce5aafc3eef656, 2 => null, 3 => 50, 4 => null, 5 => ROLE_PUPIL_GUEST, 6 => null, 7 => null, 8 => null, 9 => null, 10 => 2025-07-16 12:21:04, 11 => , 12 => , 13 => , 14 => Guest732ec332383d, 15 => Guest732ec332383d, 16 => null, 17 => null, 18 => null, 19 => null, 20 => null, 21 => null, 22 => null, 23 => null, 24 => , 25 => , 26 => null, 27 => null, 28 => null, 29 => null, 30 => null, 31 => null, 32 => , 33 => null, 34 => 0, 35 => null, 36 => null, 37 => 0, 38 => null, 39 => null, 40 => 3, 41 => 3, 42 => null, 43 => false, 44 => null, 45 => null, 46 => null, 47 => 2oA46LZSvc, 48 => 2025-07-16 12:21:04, 49 => null, 50 => null, 51 => null, 52 => null, 53 => null, 54 => null, 55 => null, 56 => null, 57 => null, 58 => null, 59 => null, 60 => null, 61 => null, 62 => 1, 63 => null, 64 => null, 65 => null, 66 => null, 67 => null, 68 => null, 69 => Europe/London, 70 => null, 71 => null, 72 => null, 73 => null, 74 => null, 75 => null, 76 => 15, 77 => null, 78 => null] View formatted query View runnable query Explain query INSERT INTO users ( uid, status, usertype, user_category, roles, parentid, tutorid, schoolid, safeguarding_officer_comments, dateregistered, title, forename, surname, username, email, password, salt, address1, address2, address3, address4, postcode, country, phone, sch_name, sch_address1, sch_address2, sch_address3, sch_address4, sch_postcode, sch_country, sch_phone, sch_fax, optin, dob, gender, notifications, source, groupid, version, pwd_version, nextstep, admin, token, tokendate, setup_done, email_verification_token, updated, disable_pretest_structure, disable_pretest_order, extra_test_time, logo_enabled, logo_filepath, archived_username, archived_email, archived, archived_schoolid, archived_tutorid, archived_groupid, archived_parentid, test_date, auto_reschedule_enabled, auto_reschedule_until, exam_board, test_wait_time, ability_maths, ability_english, adaptive_tests_disabled, timezone, demo_lessons_taken, guest_firstname, guest_surname, guest_email, sgo_id, subscriptionid, gcse_program_id, target_gcse_maths_level_id, current_gcse_maths_level_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO users (uid, status, usertype, user_category, roles, parentid, tutorid, schoolid, safeguarding_officer_comments, dateregistered, title, forename, surname, username, email, password, salt, address1, address2, address3, address4, postcode, country, phone, sch_name, sch_address1, sch_address2, sch_address3, sch_address4, sch_postcode, sch_country, sch_phone, sch_fax, optin, dob, gender, notifications, source, groupid, version, pwd_version, nextstep, admin, token, tokendate, setup_done, email_verification_token, updated, disable_pretest_structure, disable_pretest_order, extra_test_time, logo_enabled, logo_filepath, archived_username, archived_email, archived, archived_schoolid, archived_tutorid, archived_groupid, archived_parentid, test_date, auto_reschedule_enabled, auto_reschedule_until, exam_board, test_wait_time, ability_maths, ability_english, adaptive_tests_disabled, timezone, demo_lessons_taken, guest_firstname, guest_surname, guest_email, sgo_id, subscriptionid, gcse_program_id, target_gcse_maths_level_id, current_gcse_maths_level_id) VALUES ('0b8d5105ba7416a190ce5aafc3eef656', NULL, 50, NULL, 'ROLE_PUPIL_GUEST', NULL, NULL, NULL, NULL, '2025-07-16 12:21:04', '', '', '', 'Guest732ec332383d', 'Guest732ec332383d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, 0, NULL, NULL, 0, NULL, NULL, 3, 3, NULL, 0, NULL, NULL, NULL, '2oA46LZSvc', '2025-07-16 12:21:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'Europe/London', NULL, NULL, NULL, NULL, NULL, NULL, 15, NULL, NULL);
4	1.28 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	1.09 ms	SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1 Parameters: [0 => 0b8d5105ba7416a190ce5aafc3eef656] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1 SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = '0b8d5105ba7416a190ce5aafc3eef656' LIMIT 1;
6	0.47 ms	SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1 Parameters: [0 => 0b8d5105ba7416a190ce5aafc3eef656] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = ? LIMIT 1 SELECT t0.id AS id1, t0.uid AS uid2, t0.status AS status3, t0.usertype AS usertype4, t0.user_category AS user_category5, t0.roles AS roles6, t0.parentid AS parentid7, t0.tutorid AS tutorid8, t0.schoolid AS schoolid9, t0.safeguarding_officer_comments AS safeguarding_officer_comments10, t0.dateregistered AS dateregistered11, t0.title AS title12, t0.forename AS forename13, t0.surname AS surname14, t0.username AS username15, t0.email AS email16, t0.password AS password17, t0.salt AS salt18, t0.address1 AS address119, t0.address2 AS address220, t0.address3 AS address321, t0.address4 AS address422, t0.postcode AS postcode23, t0.country AS country24, t0.phone AS phone25, t0.sch_name AS sch_name26, t0.sch_address1 AS sch_address127, t0.sch_address2 AS sch_address228, t0.sch_address3 AS sch_address329, t0.sch_address4 AS sch_address430, t0.sch_postcode AS sch_postcode31, t0.sch_country AS sch_country32, t0.sch_phone AS sch_phone33, t0.sch_fax AS sch_fax34, t0.optin AS optin35, t0.dob AS dob36, t0.gender AS gender37, t0.notifications AS notifications38, t0.source AS source39, t0.groupid AS groupid40, t0.version AS version41, t0.pwd_version AS pwd_version42, t0.nextstep AS nextstep43, t0.admin AS admin44, t0.token AS token45, t0.tokendate AS tokendate46, t0.setup_done AS setup_done47, t0.email_verification_token AS email_verification_token48, t0.updated AS updated49, t0.disable_pretest_structure AS disable_pretest_structure50, t0.disable_pretest_order AS disable_pretest_order51, t0.extra_test_time AS extra_test_time52, t0.logo_enabled AS logo_enabled53, t0.logo_filepath AS logo_filepath54, t0.archived_username AS archived_username55, t0.archived_email AS archived_email56, t0.archived AS archived57, t0.archived_schoolid AS archived_schoolid58, t0.archived_tutorid AS archived_tutorid59, t0.archived_groupid AS archived_groupid60, t0.archived_parentid AS archived_parentid61, t0.test_date AS test_date62, t0.auto_reschedule_enabled AS auto_reschedule_enabled63, t0.auto_reschedule_until AS auto_reschedule_until64, t0.exam_board AS exam_board65, t0.test_wait_time AS test_wait_time66, t0.ability_maths AS ability_maths67, t0.ability_english AS ability_english68, t0.adaptive_tests_disabled AS adaptive_tests_disabled69, t0.timezone AS timezone70, t0.demo_lessons_taken AS demo_lessons_taken71, t0.guest_firstname AS guest_firstname72, t0.guest_surname AS guest_surname73, t0.guest_email AS guest_email74, t0.sgo_id AS sgo_id75, t0.subscriptionid AS subscriptionid76, t0.groupid AS groupid77, t0.gcse_program_id AS gcse_program_id78, t0.target_gcse_maths_level_id AS target_gcse_maths_level_id79, t0.current_gcse_maths_level_id AS current_gcse_maths_level_id80 FROM users t0 WHERE t0.uid = '0b8d5105ba7416a190ce5aafc3eef656' LIMIT 1;
7	1.11 ms	SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.test_type = 'demo' AND t0_.program_id = ? Parameters: [0 => 15] View formatted query View runnable query Explain query SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.test_type = 'demo' AND t0_.program_id = ? SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.test_type = 'demo' AND t0_.program_id = 15;
8	0.50 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26712] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26712 LIMIT 1;
9	0.19 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 31] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '31';
10	0.25 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26713] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26713 LIMIT 1;
11	0.19 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26714] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26714 LIMIT 1;
12	0.14 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 38] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '38';
13	0.25 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26715] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26715 LIMIT 1;
14	0.18 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26716] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26716 LIMIT 1;
15	0.12 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 34] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '34';
16	0.18 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26717] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26717 LIMIT 1;
17	0.16 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26718] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26718 LIMIT 1;
18	0.12 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 39] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '39';
19	0.33 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26719] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26719 LIMIT 1;
20	0.24 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26720] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26720 LIMIT 1;
21	0.13 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 36] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '36';
22	0.18 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26721] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26721 LIMIT 1;
23	0.18 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26722] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26722 LIMIT 1;
24	0.15 ms	SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? Parameters: [0 => 40] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = '40';
25	0.21 ms	SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 Parameters: [0 => 2341844, 1 => 26723] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = ? AND t0.testdef_id = ? LIMIT 1 SELECT t0.id AS id1, t0.pupilid AS pupilid2, t0.datestarted AS datestarted3, t0.datefinished AS datefinished4, t0.dateupdated AS dateupdated5, t0.status AS status6, t0.adaptive_test_num AS adaptive_test_num7, t0.timestatus AS timestatus8, t0.score1 AS score19, t0.score2 AS score210, t0.score3 AS score311, t0.clockstart AS clockstart12, t0.allowedtime1 AS allowedtime113, t0.duration1 AS duration114, t0.allowedtime2 AS allowedtime215, t0.duration2 AS duration216, t0.testtype AS testtype17, t0.typeid AS typeid18, t0.levelid AS levelid19, t0.testnum AS testnum20, t0.version AS version21, t0.showScore AS showScore22, t0.paused_at AS paused_at23, t0.has_completed_pause AS has_completed_pause24, t0.can_retake AS can_retake25, t0.pupilid AS pupilid26, t0.testdef_id AS testdef_id27 FROM tests t0 WHERE t0.pupilid = 2341844 AND t0.testdef_id = 26723 LIMIT 1;
26	0.41 ms	SELECT t0_.id AS id0, t0_.pupilid AS pupilid1, t0_.datestarted AS datestarted2, t0_.datefinished AS datefinished3, t0_.dateupdated AS dateupdated4, t0_.status AS status5, t0_.adaptive_test_num AS adaptive_test_num6, t0_.timestatus AS timestatus7, t0_.score1 AS score18, t0_.score2 AS score29, t0_.score3 AS score310, t0_.clockstart AS clockstart11, t0_.allowedtime1 AS allowedtime112, t0_.duration1 AS duration113, t0_.allowedtime2 AS allowedtime214, t0_.duration2 AS duration215, t0_.testtype AS testtype16, t0_.typeid AS typeid17, t0_.levelid AS levelid18, t0_.testnum AS testnum19, t0_.version AS version20, t0_.showScore AS showScore21, t0_.paused_at AS paused_at22, t0_.has_completed_pause AS has_completed_pause23, t0_.can_retake AS can_retake24, t0_.pupilid AS pupilid25, t0_.testdef_id AS testdef_id26 FROM tests t0_ INNER JOIN test_def t1_ ON t0_.testdef_id = t1_.id WHERE t0_.pupilid = ? AND t1_.program_id = ? AND t0_.testtype = 'demo' AND t0_.status >= 2 ORDER BY t0_.id DESC Parameters: [0 => 2341844, 1 => 15] View formatted query View runnable query Explain query SELECT t0_.id AS id0, t0_.pupilid AS pupilid1, t0_.datestarted AS datestarted2, t0_.datefinished AS datefinished3, t0_.dateupdated AS dateupdated4, t0_.status AS status5, t0_.adaptive_test_num AS adaptive_test_num6, t0_.timestatus AS timestatus7, t0_.score1 AS score18, t0_.score2 AS score29, t0_.score3 AS score310, t0_.clockstart AS clockstart11, t0_.allowedtime1 AS allowedtime112, t0_.duration1 AS duration113, t0_.allowedtime2 AS allowedtime214, t0_.duration2 AS duration215, t0_.testtype AS testtype16, t0_.typeid AS typeid17, t0_.levelid AS levelid18, t0_.testnum AS testnum19, t0_.version AS version20, t0_.showScore AS showScore21, t0_.paused_at AS paused_at22, t0_.has_completed_pause AS has_completed_pause23, t0_.can_retake AS can_retake24, t0_.pupilid AS pupilid25, t0_.testdef_id AS testdef_id26 FROM tests t0_ INNER JOIN test_def t1_ ON t0_.testdef_id = t1_.id WHERE t0_.pupilid = ? AND t1_.program_id = ? AND t0_.testtype = 'demo' AND t0_.status >= 2 ORDER BY t0_.id DESC SELECT t0_.id AS id0, t0_.pupilid AS pupilid1, t0_.datestarted AS datestarted2, t0_.datefinished AS datefinished3, t0_.dateupdated AS dateupdated4, t0_.status AS status5, t0_.adaptive_test_num AS adaptive_test_num6, t0_.timestatus AS timestatus7, t0_.score1 AS score18, t0_.score2 AS score29, t0_.score3 AS score310, t0_.clockstart AS clockstart11, t0_.allowedtime1 AS allowedtime112, t0_.duration1 AS duration113, t0_.allowedtime2 AS allowedtime214, t0_.duration2 AS duration215, t0_.testtype AS testtype16, t0_.typeid AS typeid17, t0_.levelid AS levelid18, t0_.testnum AS testnum19, t0_.version AS version20, t0_.showScore AS showScore21, t0_.paused_at AS paused_at22, t0_.has_completed_pause AS has_completed_pause23, t0_.can_retake AS can_retake24, t0_.pupilid AS pupilid25, t0_.testdef_id AS testdef_id26 FROM tests t0_ INNER JOIN test_def t1_ ON t0_.testdef_id = t1_.id WHERE t0_.pupilid = 2341844 AND t1_.program_id = 15 AND t0_.testtype = 'demo' AND t0_.status >= 2 ORDER BY t0_.id DESC;
27	0.77 ms	SELECT id FROM content WHERE section = :section AND urlname = :urlname AND COALESCE(parentid, 0) = :parentid AND published = 1 Parameters: [section => information, parentid => 0, urlname => gcse-maths-demo-info] View formatted query View runnable query Explain query SELECT id FROM content WHERE section = : section AND urlname = : urlname AND COALESCE(parentid, 0) = : parentid AND published = 1 SELECT id FROM content WHERE section = 'information' AND urlname = 'gcse-maths-demo-info' AND COALESCE(parentid, 0) = 0 AND published = 1;
28	0.19 ms	SELECT t0.id AS id1, t0.title AS title2, t0.description AS description3, t0.keywords AS keywords4, t0.summary AS summary5, t0.content AS content6, t0.published AS published7, t0.urlname AS urlname8, t0.section AS section9, t0.weight AS weight10, t0.tags AS tags11, t0.contexts AS contexts12, t0.parentid AS parentid13 FROM content t0 WHERE t0.id = ? Parameters: [0 => 524] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.title AS title2, t0.description AS description3, t0.keywords AS keywords4, t0.summary AS summary5, t0.content AS content6, t0.published AS published7, t0.urlname AS urlname8, t0.section AS section9, t0.weight AS weight10, t0.tags AS tags11, t0.contexts AS contexts12, t0.parentid AS parentid13 FROM content t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.title AS title2, t0.description AS description3, t0.keywords AS keywords4, t0.summary AS summary5, t0.content AS content6, t0.published AS published7, t0.urlname AS urlname8, t0.section AS section9, t0.weight AS weight10, t0.tags AS tags11, t0.contexts AS contexts12, t0.parentid AS parentid13 FROM content t0 WHERE t0.id = '524';
29	0.48 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 24] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '24';
30	0.23 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 25] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '25';
31	0.20 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 26] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '26';
32	0.12 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 27] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '27';
33	0.15 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 28] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '28';
34	0.13 ms	SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? Parameters: [0 => 29] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = ? SELECT t0.id AS id1, t0.name AS name2, t0.displayName AS displayName3, t0.is_demo AS is_demo4, t0.sort_order AS sort_order5 FROM test_level t0 WHERE t0.id = '29';

Database Connections

Key	Value
default	doctrine.dbal.default_connection

Entity Managers

Key	Value
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Bofa\CoreBundle\Entity\User	No errors.
Bofa\TestBundle\Entity\Program	No errors.
Bofa\TestBundle\Entity\TestDef	No errors.
Bofa\TestBundle\Entity\Subject	No errors.
Bofa\CoreBundle\Entity\SubscriptionProduct	No errors.
Bofa\CoreBundle\Entity\ServiceUser	No errors.
Bofa\CoreBundle\Entity\Group	No errors.
Bofa\CoreBundle\Entity\Lesson	No errors.
Bofa\CoreBundle\Entity\UserCookie	No errors.
Bofa\CoreBundle\Entity\PupilTestDefAccess	No errors.
Bofa\PretestBundle\Entity\UserPack	No errors.
Bofa\CoreBundle\Entity\UserConsortiumTests	No errors.
Bofa\CoreBundle\Entity\UserOption	No errors.
Bofa\CoreBundle\Entity\SchoolOption	No errors.
Bofa\CoreBundle\Entity\TeachingClass	No errors.
Bofa\CoreBundle\Entity\LessonResource	No errors.
Bofa\TestBundle\Entity\RescheduleStatus	No errors.
Bofa\CoreBundle\Entity\AccountJoinRequest	No errors.
Bofa\TestBundle\Entity\Test	No errors.
Bofa\CoreBundle\Entity\PupilImprovedTest	No errors.
Bofa\CoreBundle\Entity\PupilSubjectAdaptiveLevel	No errors.
Bofa\CoreBundle\Entity\UserLoginToken	No errors.
Bofa\CoreBundle\Entity\HomeworkSubmission	No errors.
Bofa\CoreBundle\Entity\Subscription	No errors.
Bofa\TestBundle\Entity\Level	No errors.
Bofa\TestBundle\Entity\TestQuestion	No errors.
Bofa\PretestBundle\Entity\Pack	No errors.
Bofa\TestBundle\Entity\TestDefVersion	No errors.
Bofa\CoreBundle\Entity\Content	No errors.

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Search

Admin