View last 10
Profile for:
GET
https://dev.bofa11plus.com/tests/nonverbal
by 3.144.31.171 at Sat, 05 Apr 2025 02:28:50 +0100
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.37 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]
|
| 2 | 0.10 ms |
"START TRANSACTION"
Parameters: []
|
| 3 | 0.89 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 => c5035e2724ad09fe65ce42c3042d373b, 2 => null, 3 => 50, 4 => null, 5 => ROLE_PUPIL_GUEST, 6 => null, 7 => null, 8 => null, 9 => null, 10 => 2025-04-05 02:28:49, 11 => , 12 => , 13 => , 14 => Guestf80d85687685, 15 => Guestf80d85687685, 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 => EVGZqr1P6X, 48 => 2025-04-05 02:28:49, 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]
|
| 4 | 0.79 ms |
"COMMIT"
Parameters: []
|
| 5 | 0.54 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 => c5035e2724ad09fe65ce42c3042d373b]
|
| 6 | 0.42 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 => c5035e2724ad09fe65ce42c3042d373b]
|
| 7 | 0.25 ms |
SELECT COUNT(0) FROM subscriptions WHERE user_id = ? AND status = 10
Parameters: [0 => 2294257]
|
| 8 | 0.49 ms |
SELECT COUNT(0) FROM users u WHERE (u.parentid = ? OR u.tutorid = ? OR u.schoolid = ?) AND (u.id != ?) AND (u.usertype = ?)
Parameters: [0 => 2294257, 1 => 2294257, 2 => 2294257, 3 => 2294257, 4 => 40]
|
| 9 | 0.25 ms |
SELECT p0_.id AS id0, p0_.type AS type1, p0_.accessor_id AS accessor_id2, p0_.program_ids AS program_ids3, p0_.default_program_id AS default_program_id4, p0_.subject_ids AS subject_ids5, 4 AS sclr6 FROM program_access p0_ WHERE p0_.type = 'default' LIMIT 1
Parameters: []
|
| 10 | 0.48 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.is_active = ? AND t0.id IN (?) ORDER BY t0.sort_order ASC
Parameters: [
0 => 1,
1 => [
0 => 1,
1 => 2,
2 => 3,
3 => 4,
4 => 5,
5 => 6,
6 => 7,
7 => 8,
8 => 9,
9 => 10,
10 => 11,
11 => 12,
12 => 13
]
]
|
| 11 | 0.45 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.testtype = ?
Parameters: [0 => 2294257, 1 => test]
|
| 12 | 0.35 ms |
SELECT t0.id AS id1, t0.status AS status2, t0.date_created AS date_created3, t0.tx_id AS tx_id4, t0.subscr_id AS subscr_id5, t0.old_subscription_id AS old_subscription_id6, t0.max AS max7, t0.date_expires AS date_expires8, t0.date_expired AS date_expired9, t0.gateway AS gateway10, t0.date_last_bill AS date_last_bill11, t0.date_next_bill AS date_next_bill12, t0.repeat_period AS repeat_period13, t0.failcount AS failcount14, t0.old_user_id AS old_user_id15, t0.user_id AS user_id16, t0.product_id AS product_id17, t18.id AS id19, t18.type AS type20, t18.category AS category21, t18.pupils AS pupils22, t18.price AS price23, t18.period AS period24, t18.duration AS duration25, t18.active AS active26, t18.isbn AS isbn27, t18.concurrent_lessons AS concurrent_lessons28 FROM subscriptions t0 LEFT JOIN subscription_products t18 ON t0.product_id = t18.id WHERE t0.user_id = ? AND t0.status = ?
Parameters: [0 => 2294257, 1 => 10]
|
| 13 | 0.18 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 => 1]
|
| 14 | 0.53 ms |
SELECT t0.id AS id1, t0.name AS name2, t0.display_name AS display_name3, t0.number AS number4, t0.test_type AS test_type5, t0.year AS year6, t0.test_count AS test_count7, t0.testsum_score1 AS testsum_score18, t0.testsum_score1squared AS testsum_score1squared9, t0.program_id AS program_id10, t0.subject_id AS subject_id11, t0.level_id AS level_id12, t0.pack_id AS pack_id13 FROM test_def t0 WHERE t0.program_id = ? AND t0.subject_id = ?
Parameters: [0 => 1, 1 => 4]
|
| 15 | 0.24 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 => 1]
|
| 16 | 0.14 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 => 2]
|
| 17 | 0.14 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 => 3]
|
| 18 | 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 => 10]
|
| 19 | 0.31 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.testtype = ?
Parameters: [0 => 2294257, 1 => quicktest]
|
| 20 | 0.51 ms |
SELECT COUNT(0) FROM test_def td WHERE td.program_id = ? AND td.subject_id = ? AND (td.test_type = '' OR td.test_type = 'test')
Parameters: [0 => 1, 1 => 4]
|
| 21 | 0.41 ms |
SELECT COUNT(0) FROM test_def td LEFT OUTER JOIN tests t ON t.testdef_id = td.id LEFT JOIN testdef_versions tdv ON tdv.testDef_id = td.id AND tdv.version = t.version WHERE td.program_id = ? AND td.subject_id = ? AND t.testtype = 'test' AND t.pupilid = ? AND t.status = ? AND ROUND(t.score1 / tdv.question_count * 100, 2) > ?
Parameters: [0 => 1, 1 => 4, 2 => 2294257, 3 => 6, 4 => 75]
|
| 22 | 0.68 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 => nonverbal]
|
| 23 | 0.22 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 => 397]
|
| 24 | 2.70 ms |
SELECT u0_.id AS id0, u0_.logo_enabled AS logo_enabled1, u0_.sch_name AS sch_name2, u0_.logo_filepath AS logo_filepath3, u0_.user_category AS user_category4 FROM users u0_ WHERE u0_.usertype = ? AND u0_.logo_enabled <> 0 AND (u0_.user_category = ? OR u0_.user_category IS NULL) ORDER BY u0_.sch_name ASC
Parameters: [0 => 10, 1 => School]
|
| 25 | 2.66 ms |
SELECT u0_.id AS id0, u0_.logo_enabled AS logo_enabled1, u0_.sch_name AS sch_name2, u0_.logo_filepath AS logo_filepath3, u0_.user_category AS user_category4 FROM users u0_ WHERE u0_.usertype = ? AND u0_.logo_enabled <> 0 AND (u0_.user_category = ? OR u0_.user_category IS NULL) ORDER BY u0_.sch_name ASC
Parameters: [0 => 10, 1 => School]
|
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\CoreBundle\Entity\ProgramAccess | 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. |
Search
Admin