Uh Oh! ...

This is an exam question and can be seen only after taking the exam here

To see more, click for the full list of questions or popular tags.

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	4.0	20%	2.6	12%	72	1.7	8%	2	0.0	0%	569k	62%
Control	12.7	63%	1.2	5%	5	11.8	59%	13	0.0	0%	265k	28%
View	0.9	4%	0.5	2%	6	0.5	2%	2	0.0	0%	0k	0%
Theme	2.3	11%	2.3	11%	13	0.0	0%	0	0.0	0%	192k	21%
Total	19.9	100%	6.6	32%	96	13.9	69%	17	0.0	0%	915k	100%

html/qadb/index.php
qadb/qa-include/qa-index.php
qadb/qa-include/qa-base.php
html/qadb/qa-config.php
qa-include/vendor/password_compat.php
Q2A/Util/Usage.php
Q2A/Plugin/PluginManager.php
Q2A/Util/Metadata.php
qa-plugin/Donut-admin/qa-plugin.php
qa-plugin/Donut-admin/functions.php
Donut-admin/admin/options.php
Donut-admin/admin/admin-routing.php
qa-plugin/event-logger/qa-plugin.php
qa-plugin/home/qa-plugin.php
qa-plugin/show-online-user-count/qa-plugin.php
qa-plugin/wysiwyg9/qa-plugin.php
qadb/qa-include/qa-db.php
qadb/qa-include/qa-page.php
qa-include/app/page.php
qa-include/app/cookies.php
qa-include/app/format.php
qa-include/app/users.php
qa-include/app/options.php
qa-include/db/options.php
qa-include/db/selects.php
qa-include/db/maxima.php
qa-plugin/category-description/qa-plugin.php
qa-plugin/exam-creator/qa-plugin.php
exam-creator/utils/autoload.php
exam-creator/utils/autoload_17.php
qa-include/db/admin.php
qa-include/db/recalc.php
qa-include/db/post-create.php
qa-include/db/points.php
qa-include/db/hotness.php
qa-include/db/metas.php
qa-include/db/post-update.php
qa-include/app/updates.php
qa-include/db/install.php
qa-include/db/users.php
qa-include/db/votes.php
qa-include/db/favorites.php
qa-include/app/posts.php
qa-include/app/post-create.php
qa-include/util/string.php
qa-include/app/post-update.php
qa-include/app/admin.php
qa-include/app/recalc.php
qa-include/app/votes.php
qa-include/app/limits.php
qa-include/app/favorites.php
qa-include/app/emails.php
qa-include/app/q-list.php
qa-include/app/captcha.php
qa-include/pages/question-view.php
qa-include/util/sort.php
qa-include/pages/question-submit.php
exam-creator/utils/autoload_exam_files.php
exam-creator/libs/util.php
exam-creator/db/admin.php
exam-creator/db/selects.php
exam-creator/db/recalc.php
exam-creator/db/exam-create.php
exam-creator/db/exam-update.php
exam-creator/app/options.php
exam-creator/app/app.php
exam-creator/app/exam-create.php
exam-creator/app/exam-update.php
exam-creator/app/format.php
exam-creator/app/recalc.php
exam-creator/app/favorites.php
exam-creator/app/admin.php
exam-creator/app/exam-list.php
exam-creator/pages/exam-view.php
exam-creator/pages/exam-submit.php
exam-creator/utils/functions.php
qa-plugin/opensearch-support/qa-plugin.php
qa-plugin/recaptcha-captcha/qa-plugin.php
qa-include/pages/question.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/MemcachedDriver.php
Q2A/Storage/CacheDriver.php
qa-include/lang/qa-lang-admin.php
qa-include/lang/qa-lang-main.php
qa-lang/custom/qa-lang-main.php
qa-include/plugins/qa-widget-category-list.php
qa-plugin/exam-creator/qa-ec-answer-input-widget.php
qa-include/plugins/qa-widget-related-qs.php
qa-include/plugins/qa-widget-activity-count.php
qadb/qa-include/qa-theme-base.php
qa-theme/Polaris/qa-theme.php
Polaris/options/options-social.php
Polaris/inc/og-metas.php
Polaris/options/options.php
Polaris/inc/preconnect.php
Polaris/lang/lang-default.php
qa-include/lang/qa-lang-misc.php
Polaris/inc/svg-nav-main.php
Polaris/inc/profile-banner.php
Polaris/inc/widget-favorite-tags.php
Polaris/inc/social-share.php
qa-include/lang/qa-lang-users.php

SELECT title, content FROM qa_options

1.56 ms - 2411 rows - 2 columns

SELECT 'db_time' AS `title`, UNIX_TIMESTAMP(NOW()) AS `content`

0.11 ms - 1 row - 2 columns

SELECT qa_posts.postid, qa_posts.categoryid, qa_posts.type, LEFT(qa_posts.type, 1) AS `basetype`, INSTR(qa_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qa_posts.type, '_QUEUED')>0 AS `queued`, qa_posts.acount, qa_posts.amaxvote, qa_posts.selchildid, qa_posts.closedbyid, qa_posts.upvotes, qa_posts.downvotes, qa_posts.netvotes, qa_posts.views, qa_posts.hotness, qa_posts.flagcount, qa_posts.title, qa_posts.tags, UNIX_TIMESTAMP(qa_posts.created) AS `created`, qa_posts.name, qa_categories.title AS `categoryname`, qa_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qa_posts.catidpath1, qa_posts.catidpath2, qa_posts.catidpath3, qa_posts.categoryid) AS `categoryids`, qa_posts.content AS `content`, qa_posts.notify AS `notify`, UNIX_TIMESTAMP(qa_posts.updated) AS `updated`, qa_posts.updatetype AS `updatetype`, qa_posts.format, qa_posts.lastuserid, qa_posts.lastip AS `lastip`, qa_posts.parentid, qa_posts.lastviewip AS `lastviewip`, qa_posts.userid, qa_posts.cookieid, qa_posts.createip AS `createip`, qa_userpoints.points, qa_users.flags, qa_users.level, qa_users.email AS `email`, qa_users.handle AS `handle`, BINARY qa_users.avatarblobid AS `avatarblobid`, qa_users.avatarwidth, qa_users.avatarheight, lastusers.handle AS `lasthandle` FROM qa_posts LEFT JOIN qa_categories ON qa_categories.categoryid=qa_posts.categoryid LEFT JOIN qa_users ON qa_posts.userid=qa_users.userid LEFT JOIN qa_users AS lastusers ON qa_posts.lastuserid=lastusers.userid LEFT JOIN qa_userpoints ON qa_posts.userid=qa_userpoints.userid join qa_posts ef on qa_posts.postid = ef.postid and ef.postid not in(select postid  from qa_posttags pt where pt.wordid  in (select wordid from qa_words wd where wd.word in ('goclasses_wq15','goclasses_wq','goclasses2024-dm-1','goclasses2024-programming-1','goclasses2024-dm-2','goclasses2024-programming-2','goclasses2024-dm-3','goclasses2024-programming-3','goclasses2024-dm-4','goclasses2024-ds-1','goclasses2024-dm-5','goclasses2024-dm-05','goclasses2024-ds-2','goclasses_wq11','goclasses2024-dl-1','goclasses2024-ds-3','goclasses2024-dl-2','goclasses2024-ds-4','goclasses2024-dl-3','go2024-quantitative-aptitude-1','go2024-verbal-aptitude-1','go2024-spatial-and-analytical-aptitude-1','go2024-digital-logic-1','go2024-programming-1','go2024-algorithms-1','go2024-probability-1','go2024-linear-algebra-1','go2024-calculus-1','go2024-dbms-1','go2024-toc-1','go2024-cd-1','go2024-os-1','go2024-os-2','go2024-cn-1','go2024-coa-1','go2024-ds-1','go2024-dm-1','go2024-dm-2','go2024-dm-3','go2024-dm-4','go2024-mix-1','go2024-mix-2','go2024-algorithms-2','go2024-mix-3','go2024-mix-4','go2024-mockgate-1','go2024-mockgate-2','go2024-mockgate-3','go2024-mockgate-4','go2024-mockgate-5','go2024-mockgate-6','goclasses2024-ds-5','goclasses2024-toc-1','goclasses2024-algo-1','goclasses2024-algo-2','goclasses2024-toc-2','goclasses2024-algo-3','goclasses2024-toc-3','goclasses_wq14','goclasses2024-toc-4','goclasses2024-toc-5','goclasses2024-la','goclasses2024-coa-1','goclasses2024-algo-4','goclasses_wq16','goclasses2024-probability','goclasses2024-calculus','goclasses2024-coa-2','goclasses2024-coa-3','goclasses2024-dbms-1','goclasses2024-dbms-2','goclasses2024-mix-1','goclasses2024-os-1','goclasses2024-os-2','goclasses2024-os-3','goclasses2024-dbms-3','goclasses2024-os-4','goclasses2024-dbms-4','goclasses2024-dbms-5','goclasses2024-mix-2','goclasses2024-cd-1','goclasses2024-cd-3','goclasses2024-cd-2','goclasses2024-coa-4','goclasses2024-mockgate-1','goclasses2024-mockgate-2','goclasses2024-mockgate-3','goclasses2024-cn-2','go2024-topictest-1','goclasses2024-mockgate-4','goclasses2024-cn-1','goclasses2024-cn-3','go2024-topictest-2','goclasses2024-mix-3','goclasses2024-mockgate-5','goclasses2024-mix-4','goclasses2024-mockgate-6','goclasses2024-mockgate-7','goclasses2024-mockgate-8','goclasses2024-cn-4','goclasses2024-mockgate-9','goclasses2024-iiith-mock-3','dm_test_2','dm_test_2_new','goclasses2024_wq9','goclasses2024-probability-1','goclasses2024_wq10','testsbyankitg-dm-3','goclasses2024-la-1','goclasses2023-iiith-mock-4','goclasses2024_wq11','testsbyankitg-dm-4','testsbyankitg_dm-4','testsbyankitg_dm_4','testsbyankitg-dm_4','dm-test-4','dm-logic-test-4','dm_logic_test_4','testsbyankitg-dm-logic-4','logic_dm_test_4','logic-test-4','testsbyankitg-logic-dm-4','goclasses2023-iiith-mock-5','goclasses2024_wq12','goclasses2024_wq13','goclasses2024_wq14','goclasses2024_wq15','goclasses2023-nielit-mock-1','goclasses2024_wq16','goclasses2023-nielit-mock-2','goclasses2024_wq17','goclasses2024_wq18','','goclasses2023-nielit-mock-3','goclasses2024_wq19','goclasses2023-nielit-mock-4','goclasses2024_wq20','goclasses2024-toc-4-weekly-quiz','goclasses2023-nielit-mock-5','goclasses2024-dm-6','goclasses2024-toc-6','goclasses2024-ds-4-weekly-quiz','goclasses2024_wq21','goclasses2023-nielit-mock-6','goclasses2024_wq22','goclasses2024-mix-1-weekly-quiz','goclasses2024-dl-1-weekly-quiz','goclasses2024_wq23','goclasses2024_wq24','goclasses2023-scholarship-test','goclasses2024_wq25','goclasses2023-nielit-mock-7','goclasses2024_wq26','goclasses2024_wq27','goclasses2024_wq28','goclasses2024-toc-7','goclasses2024_wq29','goclasses2024_wq30','goclasses2023-nielit-mock-8','goclasses2024_wq31','goclasses2024-ds-5-weekly-quiz','goclasses2023-nielit-mock-9','goclasses2024_wq32','goclasses2024_wq33','goclasses2023-nielit-mock-10','goclasses2024_wq34','goclasses2024-mockgate-10','goclasses2024-mockgate-da-1','goclasses2024-mockgate-da-2','goclasses2023-iiith-mock-2','goclasses2023-iiith-mock-3','goclasses2025_wq1','goclasses2025_wq2','goclasses2025_wq3','goclasses2025_wq4','goclasses2024-iiith-mock-2','goclasses2025_wq5','test123','testq','goclasses_wq41'))

) WHERE qa_posts.postid=392954

1.81 ms - 0 rows - 44 columns

) WHERE qa_posts.parentid=392954

1.68 ms - 2 rows - 44 columns

) JOIN qa_posts AS parents ON qa_posts.parentid=parents.postid WHERE parents.parentid=392954 AND LEFT(parents.type, 1)='A'

1.88 ms - 7 rows - 44 columns

SELECT qa_posts.postid, qa_posts.categoryid, qa_posts.type, LEFT(qa_posts.type, 1) AS `basetype`, INSTR(qa_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qa_posts.type, '_QUEUED')>0 AS `queued`, qa_posts.acount, qa_posts.amaxvote, qa_posts.selchildid, qa_posts.closedbyid, qa_posts.upvotes, qa_posts.downvotes, qa_posts.netvotes, qa_posts.views, qa_posts.hotness, qa_posts.flagcount, qa_posts.title, qa_posts.tags, UNIX_TIMESTAMP(qa_posts.created) AS `created`, qa_posts.name, qa_categories.title AS `categoryname`, qa_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qa_posts.catidpath1, qa_posts.catidpath2, qa_posts.catidpath3, qa_posts.categoryid) AS `categoryids`, qa_posts.userid, qa_posts.cookieid, qa_posts.createip AS `createip`, qa_userpoints.points, qa_users.flags, qa_users.level, qa_users.email AS `email`, qa_users.handle AS `handle`, BINARY qa_users.avatarblobid AS `avatarblobid`, qa_users.avatarwidth, qa_users.avatarheight FROM qa_posts LEFT JOIN qa_categories ON qa_categories.categoryid=qa_posts.categoryid LEFT JOIN qa_users ON qa_posts.userid=qa_users.userid LEFT JOIN qa_userpoints ON qa_posts.userid=qa_userpoints.userid join qa_posts ef on qa_posts.postid = ef.postid and ef.postid not in(select postid  from qa_posttags pt where pt.wordid  in (select wordid from qa_words wd where wd.word in ('goclasses_wq15','goclasses_wq','goclasses2024-dm-1','goclasses2024-programming-1','goclasses2024-dm-2','goclasses2024-programming-2','goclasses2024-dm-3','goclasses2024-programming-3','goclasses2024-dm-4','goclasses2024-ds-1','goclasses2024-dm-5','goclasses2024-dm-05','goclasses2024-ds-2','goclasses_wq11','goclasses2024-dl-1','goclasses2024-ds-3','goclasses2024-dl-2','goclasses2024-ds-4','goclasses2024-dl-3','go2024-quantitative-aptitude-1','go2024-verbal-aptitude-1','go2024-spatial-and-analytical-aptitude-1','go2024-digital-logic-1','go2024-programming-1','go2024-algorithms-1','go2024-probability-1','go2024-linear-algebra-1','go2024-calculus-1','go2024-dbms-1','go2024-toc-1','go2024-cd-1','go2024-os-1','go2024-os-2','go2024-cn-1','go2024-coa-1','go2024-ds-1','go2024-dm-1','go2024-dm-2','go2024-dm-3','go2024-dm-4','go2024-mix-1','go2024-mix-2','go2024-algorithms-2','go2024-mix-3','go2024-mix-4','go2024-mockgate-1','go2024-mockgate-2','go2024-mockgate-3','go2024-mockgate-4','go2024-mockgate-5','go2024-mockgate-6','goclasses2024-ds-5','goclasses2024-toc-1','goclasses2024-algo-1','goclasses2024-algo-2','goclasses2024-toc-2','goclasses2024-algo-3','goclasses2024-toc-3','goclasses_wq14','goclasses2024-toc-4','goclasses2024-toc-5','goclasses2024-la','goclasses2024-coa-1','goclasses2024-algo-4','goclasses_wq16','goclasses2024-probability','goclasses2024-calculus','goclasses2024-coa-2','goclasses2024-coa-3','goclasses2024-dbms-1','goclasses2024-dbms-2','goclasses2024-mix-1','goclasses2024-os-1','goclasses2024-os-2','goclasses2024-os-3','goclasses2024-dbms-3','goclasses2024-os-4','goclasses2024-dbms-4','goclasses2024-dbms-5','goclasses2024-mix-2','goclasses2024-cd-1','goclasses2024-cd-3','goclasses2024-cd-2','goclasses2024-coa-4','goclasses2024-mockgate-1','goclasses2024-mockgate-2','goclasses2024-mockgate-3','goclasses2024-cn-2','go2024-topictest-1','goclasses2024-mockgate-4','goclasses2024-cn-1','goclasses2024-cn-3','go2024-topictest-2','goclasses2024-mix-3','goclasses2024-mockgate-5','goclasses2024-mix-4','goclasses2024-mockgate-6','goclasses2024-mockgate-7','goclasses2024-mockgate-8','goclasses2024-cn-4','goclasses2024-mockgate-9','goclasses2024-iiith-mock-3','dm_test_2','dm_test_2_new','goclasses2024_wq9','goclasses2024-probability-1','goclasses2024_wq10','testsbyankitg-dm-3','goclasses2024-la-1','goclasses2023-iiith-mock-4','goclasses2024_wq11','testsbyankitg-dm-4','testsbyankitg_dm-4','testsbyankitg_dm_4','testsbyankitg-dm_4','dm-test-4','dm-logic-test-4','dm_logic_test_4','testsbyankitg-dm-logic-4','logic_dm_test_4','logic-test-4','testsbyankitg-logic-dm-4','goclasses2023-iiith-mock-5','goclasses2024_wq12','goclasses2024_wq13','goclasses2024_wq14','goclasses2024_wq15','goclasses2023-nielit-mock-1','goclasses2024_wq16','goclasses2023-nielit-mock-2','goclasses2024_wq17','goclasses2024_wq18','','goclasses2023-nielit-mock-3','goclasses2024_wq19','goclasses2023-nielit-mock-4','goclasses2024_wq20','goclasses2024-toc-4-weekly-quiz','goclasses2023-nielit-mock-5','goclasses2024-dm-6','goclasses2024-toc-6','goclasses2024-ds-4-weekly-quiz','goclasses2024_wq21','goclasses2023-nielit-mock-6','goclasses2024_wq22','goclasses2024-mix-1-weekly-quiz','goclasses2024-dl-1-weekly-quiz','goclasses2024_wq23','goclasses2024_wq24','goclasses2023-scholarship-test','goclasses2024_wq25','goclasses2023-nielit-mock-7','goclasses2024_wq26','goclasses2024_wq27','goclasses2024_wq28','goclasses2024-toc-7','goclasses2024_wq29','goclasses2024_wq30','goclasses2023-nielit-mock-8','goclasses2024_wq31','goclasses2024-ds-5-weekly-quiz','goclasses2023-nielit-mock-9','goclasses2024_wq32','goclasses2024_wq33','goclasses2023-nielit-mock-10','goclasses2024_wq34','goclasses2024-mockgate-10','goclasses2024-mockgate-da-1','goclasses2024-mockgate-da-2','goclasses2023-iiith-mock-2','goclasses2023-iiith-mock-3','goclasses2025_wq1','goclasses2025_wq2','goclasses2025_wq3','goclasses2025_wq4','goclasses2024-iiith-mock-2','goclasses2025_wq5','test123','testq','goclasses_wq41'))

) WHERE qa_posts.postid=(SELECT IF(LEFT(parent.type, 1)='A', parent.parentid, parent.postid) FROM qa_posts AS child LEFT JOIN qa_posts AS parent ON parent.postid=child.parentid WHERE child.postid=392954 AND parent.type IN('Q','A'))

1.49 ms - 0 rows - 34 columns

) WHERE qa_posts.postid=(SELECT closedbyid FROM qa_posts WHERE postid=392954)

1.49 ms - 0 rows - 44 columns

) WHERE qa_posts.closedbyid=392954

1.51 ms - 0 rows - 44 columns

SELECT title, content FROM qa_postmetas WHERE postid=392954 AND title='qa_q_extra'

0.19 ms - 0 rows - 2 columns

SELECT qa_categories.categoryid, MAX(qa_categories.parentid) AS `parentid`, MAX(qa_categories.title) AS `title`, MAX(qa_categories.tags) AS `tags`, MAX(qa_categories.qcount) AS `qcount`, MAX(qa_categories.position) AS `position`, COUNT(child.categoryid) AS `childcount`, MAX(qa_categories.content) AS `content`, MAX(qa_categories.backpath) AS `backpath` FROM qa_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid JOIN qa_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE qa_categories.categoryid=(SELECT categoryid FROM qa_posts WHERE postid=392954) UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.categoryid=(SELECT categoryid FROM qa_posts WHERE postid=392954) UNION SELECT parentid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=392954) UNION SELECT categoryid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=392954)) y ON qa_categories.parentid<=>parentkey LEFT JOIN qa_categories AS child ON child.parentid=qa_categories.categoryid GROUP BY qa_categories.categoryid ORDER BY qa_categories.position

0.73 ms - 27 rows - 9 columns

SELECT action, period, count FROM qa_iplimits WHERE ip=UNHEX('ac45073e')

0.14 ms - 0 rows - 3 columns

SELECT pageid, title, flags, permit+0 AS `permit`, nav, tags, position, heading FROM qa_pages WHERE nav IN ('B','M','O','F') ORDER BY position

0.19 ms - 42 rows - 8 columns

SELECT widgetid, place, position, tags, title FROM qa_widgets ORDER BY position

0.12 ms - 25 rows - 5 columns

select tags from qa_posts where postid = 392954

0.09 ms - 1 row - 1 column

select tag from qa_exams

0.46 ms - 559 rows - 1 column

SELECT entityid, entitytype, level FROM qa_userlevels WHERE userid=NULL

0.13 ms - 0 rows - 3 columns

select postid from qa_exams where tag = 'goclasses2024-mockgate-5'

0.35 ms - 1 row - 1 column