Type checking Grammar

reena_kandari asked Jan 2, 2017

633 views

See all

Please log in or register to answer this question.

Related questions

Deprecated: Implicit conversion from float-string "1552317781.050" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 796

Deprecated: Implicit conversion from float-string "1552317781.050" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 801

Deprecated: Implicit conversion from float-string "1552317781.050" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 802

Deprecated: Implicit conversion from float-string "1552317781.050" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 803

1.3k

views

0 answers

0 votes

s_dr_13 asked Mar 11, 2019

1,276 views

Type Checking( Compiler )

When exactly is type checking done during compilation phase ?? Some resources are saying there r during semantic analysis phase while other r saying there r done syntax a...

s_dr_13 asked Mar 11, 2019

1.1k

views

0 answers

0 votes

nishant279 asked Aug 30, 2017

1,114 views

Type Checking is normally done during:1. Parsing2. Syntax Analysis3. SDT4. Semantic Based Optimization

nishant279 asked Aug 30, 2017

1.7k

views

2 answers

3 votes

Meenakshi Sharma asked Aug 5, 2016

1,737 views

is null production allowed in all type of grammar

is null production allowed in all type of grammar

Meenakshi Sharma

Meenakshi Sharma asked Aug 5, 2016

4.9k

views

1 answers

1 votes

Pranav Kapur asked Mar 24, 2016

4,929 views

Type of Grammar

What type of grammar is this most accurately described as?S- b/ aDD- a/ aDDA. A regular grammar B. CFG C. CSG D. Type-0

Pranav Kapur asked Mar 24, 2016

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	4.3	10%	2.8	6%	72	1.7	4%	2	0.0	0%	569k	52%
Control	12.9	30%	1.6	3%	5	11.6	27%	12	0.0	0%	186k	17%
View	1.1	2%	1.1	2%	11	0.0	0%	0	0.0	0%	78k	7%
Theme	18.3	43%	3.7	8%	15	14.8	34%	3	0.0	0%	249k	22%
Stats	5.8	13%	0.1	0%	0	5.7	13%	1	0.0	0%	0k	0%
Total	42.3	100%	9.2	21%	103	33.8	79%	18	0.0	0%	1084k	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
qa-include/plugins/qa-viewer-basic.php
qa-include/lang/qa-lang-users.php
qa-include/lang/qa-lang-question.php
qa-lang/custom/qa-lang-question.php
qa-include/util/image.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/svg-vote-buttons.php
Polaris/inc/svg-form-buttons.php
qa-include/lang/qa-lang-profile.php
Polaris/inc/widget-favorite-tags.php
Polaris/inc/social-share.php

SELECT title, content FROM qa_options

1.59 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=99381

1.90 ms - 1 row - 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.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.parentid=99381

1.81 ms - 3 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.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'))

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

1.69 ms - 0 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=99381 AND parent.type IN('Q','A'))

1.56 ms - 0 rows - 34 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=(SELECT closedbyid FROM qa_posts WHERE postid=99381)

1.57 ms - 0 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.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.closedbyid=99381

1.64 ms - 0 rows - 44 columns

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

0.14 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=99381) 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=99381) UNION SELECT parentid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=99381) UNION SELECT categoryid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=99381)) 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.71 ms - 22 rows - 9 columns

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

0.17 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.20 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 entityid, entitytype, level FROM qa_userlevels WHERE userid=NULL

0.08 ms - 0 rows - 3 columns

SELECT answer_str from qa_ec_answers where postid=99381

0.17 ms - 0 rows - 1 column

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, score 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'))

) JOIN (SELECT postid, SUM(score)+LOG(postid)/1000000 AS score FROM ((SELECT qa_titlewords.postid, LOG(10000/titlecount) AS score FROM qa_titlewords JOIN qa_words ON qa_titlewords.wordid=qa_words.wordid JOIN qa_titlewords AS source ON qa_titlewords.wordid=source.wordid WHERE source.postid=99381 AND titlecount<10000) UNION ALL (SELECT qa_posttags.postid, 2*LOG(10000/tagcount) AS score FROM qa_posttags JOIN qa_words ON qa_posttags.wordid=qa_words.wordid JOIN qa_posttags AS source ON qa_posttags.wordid=source.wordid WHERE source.postid=99381 AND tagcount<10000) UNION ALL (SELECT qa_posts.postid, LOG(10000/qa_categories.qcount) FROM qa_posts JOIN qa_categories ON qa_posts.categoryid=qa_categories.categoryid AND qa_posts.type='Q' WHERE qa_categories.categoryid=(SELECT categoryid FROM qa_posts WHERE postid=99381) AND qa_categories.qcount<10000)) x WHERE postid!=99381 GROUP BY postid ORDER BY score DESC LIMIT 4) y ON qa_posts.postid=y.postid

14.33 ms - 4 rows - 35 columns

SELECT postid, content, format FROM qa_posts WHERE postid IN (305827,148552,61980,41821)

0.26 ms - 4 rows - 3 columns

UPDATE qa_posts SET views=views+1, lastviewip=UNHEX('ac47ff10') WHERE postid=99381 AND (lastviewip IS NULL OR lastviewip!=UNHEX('ac47ff10'))

5.72 ms