No answers by JeffereyDick - Catholic Questions

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	5.1	37%	2.1	15%	17	1.8	12%	2	1.2	9%	127k	65%
Control	5.6	41%	0.8	6%	3	5.0	37%	6	0.0	0%	13k	6%
View	1.4	10%	1.1	8%	6	0.3	2%	1	0.0	0%	18k	9%
Theme	1.4	10%	1.0	7%	2	0.0	0%	0	0.4	2%	34k	17%
Total	13.6	100%	5.1	37%	28	7.1	52%	9	1.3	9%	193k	100%

wiringht/catholicquestions.ca/index.php
catholicquestions.ca/qa-include/qa-index.php
catholicquestions.ca/qa-include/qa-base.php
wiringht/catholicquestions.ca/qa-config.php
qa-include/vendor/password_compat.php
Q2A/Util/Usage.php
Q2A/Plugin/PluginManager.php
Q2A/Util/Metadata.php
qa-plugin/event-logger/qa-plugin.php
qa-plugin/wysiwyg-editor/qa-plugin.php
catholicquestions.ca/qa-include/qa-db.php
catholicquestions.ca/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/example-page/qa-plugin.php
qa-plugin/mouseover-layer/qa-plugin.php
qa-plugin/xml-sitemap/qa-plugin.php
qa-include/pages/user.php
qa-include/pages/user-answers.php
qa-include/util/sort.php
qa-include/lang/qa-lang-main.php
qa-include/app/updates.php
qa-include/app/limits.php
qa-include/util/string.php
qa-include/lang/qa-lang-profile.php
qa-include/lang/qa-lang-misc.php
catholicquestions.ca/qa-include/qa-theme-base.php
qa-theme/Classic/qa-theme.php

SELECT title, content FROM qa_options

0.67 ms - 338 rows - 2 columns

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

1.09 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='JeffereyDick'

2.16 ms - 1 row - 21 columns

SELECT points, qposts, aposts, cposts, aselects, aselecteds, qupvotes, qdownvotes, aupvotes, adownvotes, qvoteds, avoteds, upvoteds, downvoteds, bonus FROM qa_userpoints WHERE userid=(SELECT userid FROM qa_users WHERE handle='JeffereyDick' LIMIT 1)

0.29 ms - 1 row - 15 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.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, LEFT(aposts.type, 1) AS `obasetype`, INSTR(aposts.type, '_HIDDEN')>0 AS `ohidden`, aposts.postid AS `opostid`, aposts.userid AS `ouserid`, aposts.cookieid AS `ocookieid`, aposts.name AS `oname`, aposts.createip AS `oip`, UNIX_TIMESTAMP(aposts.created) AS `otime`, aposts.flagcount AS `oflagcount`, aposts.upvotes AS `oupvotes`, aposts.downvotes AS `odownvotes`, aposts.netvotes AS `onetvotes` 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 AS aposts ON qa_posts.postid=aposts.parentid JOIN (SELECT postid FROM qa_posts WHERE  userid=(SELECT userid FROM qa_users WHERE handle='JeffereyDick' LIMIT 1) AND type='A' ORDER BY created DESC LIMIT 0,20) y ON aposts.postid=y.postid WHERE qa_posts.type='Q'

1.49 ms - 0 rows - 45 columns

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

0.33 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.43 ms - 2 rows - 8 columns

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

0.33 ms - 0 rows - 5 columns

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

0.32 ms - 0 rows - 3 columns