User PatrickNorma

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	4.3	36%	3.0	25%	17	0.8	6%	2	0.5	4%	127k	59%
Control	5.6	47%	1.5	12%	7	4.5	38%	11	0.0	0%	33k	15%
View	1.0	8%	0.8	6%	4	0.1	0%	1	0.0	0%	19k	9%
Theme	0.9	7%	0.8	7%	2	0.0	0%	0	0.0	0%	32k	15%
Total	11.8	100%	6.2	52%	30	5.4	46%	14	0.1	1%	214k	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-profile.php
qa-include/app/limits.php
qa-include/app/updates.php
qa-include/util/sort.php
qa-include/app/messages.php
qa-include/lang/qa-lang-profile.php
qa-include/lang/qa-lang-main.php
qa-include/util/string.php
qa-include/lang/qa-lang-users.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`

0.13 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='PatrickNorma'

0.58 ms - 1 row - 21 columns

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

0.47 ms - 0 rows - 2 columns

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

0.22 ms - 4 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=(SELECT userid FROM qa_users WHERE handle='PatrickNorma' LIMIT 1) ORDER BY qa_messages.created DESC LIMIT 0,10

0.63 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=(SELECT userid FROM qa_users WHERE handle='PatrickNorma' LIMIT 1)

0.27 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=(SELECT userid FROM qa_users WHERE handle='PatrickNorma' LIMIT 1)

0.60 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.82 ms - 18 rows - 6 columns

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='PatrickNorma' LIMIT 1)), 0)

0.40 ms - 1 row - 1 column

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

0.16 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.23 ms - 2 rows - 8 columns

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

0.15 ms - 0 rows - 5 columns

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

0.11 ms - 0 rows - 3 columns

Member for:	3 weeks (since Feb 23)
Type:	Registered user
Full name:
Location:
Website:
About:

Score:	100 points (ranked #6)
Questions:	0
Answers:	0
Comments:	0
Voted on:	0 questions, 0 answers
Gave out:	0 up votes, 0 down votes
Received:	0 up votes, 0 down votes

Activity by PatrickNorma

Wall for PatrickNorma