User swapnil1 / GATE Overflow for GATE CSE

Activity by swapnil1

Score:	15 points (ranked #10,655)
Exams Created:	0
Exams Taken:	0
Questions:	0
Answers:	0
Comments:	1
Voted on:	0 questions, 0 answers
Gave out:	0 up votes, 0 down votes
Received:	1 up vote, 0 down votes

Wall for swapnil1

Please log in or register to post on this wall.

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	5.0	24%	3.2	15%	72	2.1	10%	2	0.0	0%	569k	63%
Control	5.8	28%	0.9	4%	4	5.2	25%	11	0.0	0%	105k	11%
View	0.6	3%	0.6	2%	7	0.1	0%	1	0.0	0%	38k	4%
Theme	8.7	43%	2.7	13%	13	6.4	31%	14	0.0	0%	185k	20%
Total	20.2	100%	7.3	36%	96	13.8	68%	28	0.0	0%	900k	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/user.php
qa-include/pages/user-profile.php
qa-include/app/messages.php
qa-include/lang/qa-lang-profile.php
qa-include/lang/qa-lang-main.php
qa-lang/custom/qa-lang-main.php
qa-include/plugins/qa-widget-category-list.php
qa-include/plugins/qa-widget-activity-count.php
qa-include/util/image.php
qa-include/lang/qa-lang-users.php
qa-include/lang/qa-lang-misc.php
qadb/qa-include/qa-theme-base.php
qa-theme/Polaris/qa-theme.php
exam-creator/lang/exam-lang-default.php
Polaris/options/options-social.php
Polaris/inc/og-metas.php
Polaris/options/options.php
Polaris/inc/preconnect.php
Polaris/lang/lang-default.php
Polaris/inc/svg-nav-main.php
Polaris/inc/profile-banner.php
qa-include/lang/qa-lang-admin.php
qa-include/lang/qa-lang-question.php
qa-lang/custom/qa-lang-question.php

SELECT title, content FROM qa_options

1.95 ms - 2411 rows - 2 columns

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

0.10 ms - 1 row - 2 columns

SELECT qa_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qa_users LEFT JOIN qa_userpoints ON qa_userpoints.userid=qa_users.userid WHERE qa_users.handle='swapnil1'

0.40 ms - 1 row - 21 columns

SELECT title, content FROM qa_userprofile WHERE userid='37174'

0.68 ms - 1 row - 2 columns

SELECT fieldid, title, content, flags, permit, position FROM qa_userfields

0.14 ms - 17 rows - 6 columns

SELECT messageid, fromuserid, touserid, content, format, UNIX_TIMESTAMP(qa_messages.created) AS `created`, ufrom.flags AS `fromflags`, ufrom.level AS `fromlevel`, ufrom.email AS `fromemail`, ufrom.handle AS `fromhandle`, BINARY ufrom.avatarblobid AS `fromavatarblobid`, ufrom.avatarwidth AS `fromavatarwidth`, ufrom.avatarheight AS `fromavatarheight`, uto.flags AS `toflags`, uto.level AS `tolevel`, uto.email AS `toemail`, uto.handle AS `tohandle`, BINARY uto.avatarblobid AS `toavatarblobid`, uto.avatarwidth AS `toavatarwidth`, uto.avatarheight AS `toavatarheight` FROM qa_messages LEFT JOIN qa_users ufrom ON fromuserid=ufrom.userid LEFT JOIN qa_users uto ON touserid=uto.userid WHERE type='PUBLIC' AND touserid='37174' ORDER BY qa_messages.created DESC LIMIT 0,10

0.31 ms - 0 rows - 20 columns

SELECT points, qposts, aposts, cposts, aselects, aselecteds, qupvotes, qdownvotes, aupvotes, adownvotes, qvoteds, avoteds, upvoteds, downvoteds, bonus FROM qa_userpoints WHERE userid='37174'

0.15 ms - 1 row - 15 columns

SELECT entityid, entitytype, level, title, backpath FROM qa_userlevels LEFT JOIN qa_categories ON qa_userlevels.entitytype='C' AND qa_userlevels.entityid=qa_categories.categoryid WHERE userid='37174'

0.15 ms - 0 rows - 5 columns

SELECT qa_categories.categoryid, qa_categories.parentid AS `parentid`, qa_categories.title AS `title`, qa_categories.tags AS `tags`, qa_categories.qcount AS `qcount`, qa_categories.position AS `position` 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=NULL UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.categoryid=NULL UNION SELECT parentid FROM qa_categories WHERE categoryid=NULL UNION SELECT categoryid FROM qa_categories WHERE categoryid=NULL) y ON qa_categories.parentid<=>parentkey ORDER BY qa_categories.position

0.42 ms - 22 rows - 6 columns

SELECT 1+COUNT(*) AS `rank` FROM qa_userpoints WHERE points>COALESCE((SELECT points FROM qa_userpoints WHERE userid='37174'), 0)

2.47 ms - 1 row - 1 column

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

0.15 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.21 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

0.25 ms - 1 row - 21 columns

SELECT handle, userid FROM qa_users WHERE handle IN ('swapnil1')

0.20 ms - 1 row - 2 columns

SELECT count(distinct examid) FROM qa_exam_results WHERE userid=37174

0.24 ms - 1 row - 1 column

SELECT postid , type FROM qa_exams WHERE userid=37174 AND type IN ('E','C', 'E_QUEUED', 'C_QUEUED')

0.62 ms - 0 rows - 2 columns

SELECT handle, userid FROM qa_users WHERE handle IN ('swapnil1')

0.15 ms - 1 row - 2 columns

SELECT count(distinct examid) FROM qa_exam_results WHERE userid=37174

0.18 ms - 1 row - 1 column

SELECT content FROM qa_usermetas WHERE userid='37174' AND title='accesslists'

1.11 ms - 0 rows - 1 column

0.27 ms - 1 row - 21 columns

SELECT title, content FROM qa_userprofile WHERE userid=(SELECT userid FROM qa_users WHERE handle='swapnil1' LIMIT 1)

0.21 ms - 1 row - 2 columns

0.26 ms - 1 row - 21 columns

0.28 ms - 1 row - 21 columns

SELECT title, content FROM qa_userprofile WHERE userid=(SELECT userid FROM qa_users WHERE handle='swapnil1' LIMIT 1)

0.18 ms - 1 row - 2 columns

SELECT MAX(points) AS max FROM qa_userpoints

0.09 ms - 1 row - 1 column

SELECT 1+COUNT(*) AS `rank` FROM qa_userpoints WHERE points>COALESCE((SELECT points FROM qa_userpoints WHERE userid=(SELECT userid FROM qa_users WHERE handle='swapnil1' LIMIT 1)), 0)

2.35 ms - 1 row - 1 column

Member for:	6 years (since Dec 1, 2017)
Type:	Registered user
Extra privileges:	Asking questions Flagging posts
Full name:
GATE Year:
GATE Rank:
About:
Resume:
GitHub Profile Link:
DBLP Link:
Following standard books?:
Home State:
Donate Me Link:
Messages from only those in my circle:
Access Lists

swapnil1

About@swapnil1

Activity by swapnil1

Wall for swapnil1