Half Duplex and Full Duplex

Vishal0807 asked Oct 14, 2018

449 views

See all

Please log in or register to answer this question.

Related questions

1.5k

views

1 answers

1 votes

Nils asked Jul 11, 2016

1,501 views

Effiiency in half & full Duplex

In stop & wait protocol Bandwidth is 2.1 Mbps,packet size 1000 bits then what will its efficiency if in half duplex mode & full duplex mode ?Solve & Explain..

Nils

Nils asked Jul 11, 2016

4.3k

views

1 answers

0 votes

navi asked Jul 5, 2016

4,348 views

Half Duplex communication

Which of the following statements is correct with respect to Half duplex communications?a. Error correction is not possibleb. Always a pair of physical links is necessary...

navi

navi asked Jul 5, 2016

1.1k

views

1 answers

1 votes

debanjan sarkar asked Nov 4, 2015

1,148 views

relation between full duplex and baseband transmission

if a link is using baseband transmission for e.g Ethernet....thats means one signal can pass through the link at a time.....that means a baseband transmission can never b...

debanjan sarkar

debanjan sarkar asked Nov 4, 2015

1.3k

views

0 answers

0 votes

tamnna asked May 14, 2016

1,287 views

no of full adder and half adder required to add 16 bit no

tamnna

tamnna asked May 14, 2016

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	4.2	7%	2.7	4%	72	1.6	2%	2	0.0	0%	569k	56%
Control	12.9	22%	1.2	2%	5	11.9	20%	12	0.0	0%	151k	14%
View	2.0	3%	2.0	3%	11	0.0	0%	0	0.0	0%	63k	6%
Theme	33.4	57%	3.8	6%	15	29.6	51%	3	0.0	0%	230k	22%
Stats	5.3	9%	0.1	0%	0	5.2	9%	1	0.0	0%	0k	0%
Total	57.7	100%	9.8	16%	103	48.3	83%	18	0.0	0%	1015k	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/util/image.php
qa-include/lang/qa-lang-question.php
qa-lang/custom/qa-lang-question.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.47 ms - 2411 rows - 2 columns

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

0.09 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=253026

2.11 ms - 1 row - 44 columns

) WHERE qa_posts.parentid=253026

1.58 ms - 0 rows - 44 columns

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

1.63 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=253026 AND parent.type IN('Q','A'))

1.59 ms - 0 rows - 34 columns

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

1.49 ms - 0 rows - 44 columns

) WHERE qa_posts.closedbyid=253026

1.57 ms - 0 rows - 44 columns

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

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

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

0.21 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.27 ms - 42 rows - 8 columns

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

0.18 ms - 25 rows - 5 columns

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

0.13 ms - 0 rows - 3 columns

SELECT answer_str from qa_ec_answers where postid=253026

0.88 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=253026 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=253026 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=253026) AND qa_categories.qcount<10000)) x WHERE postid!=253026 GROUP BY postid ORDER BY score DESC LIMIT 4) y ON qa_posts.postid=y.postid

28.52 ms - 4 rows - 35 columns

SELECT postid, content, format FROM qa_posts WHERE postid IN (57338,55961,25452,45751)

0.21 ms - 4 rows - 3 columns

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

5.23 ms

Half Duplex and Full Duplex

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

0