Catholic Questions

This site is meant for anyone with questions concerning any aspect of Catholic faith, practice or outlook. It does NOT claim to be authoritative in any way, but is rather a place for people to express their own points of view through the questions or answers or comments on the answers of others they wish to share. Feel free to ask and answer your own question or one you find interesting so that others may reflect and perhaps contribute their own alternate answer or opinion. Every question could be answered in various ways. See Why this site.

We welcome any comments or suggestions on this site and how we might improve it. Please Send feedback.

Please familiarize yourself with our 'privacy policy' and 'terms of service'.

BOARD RULES:

Be respectful of other points of views even if those opinions differ from your own.

No foul language allowed.

No advertising for your own gain though links that serve a purpose in an answer may be allowed.

No spam posts.

Copyright 2023 • Catholic Questions • All Rights Reserved • Last updated 9 Jan 2023.

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	3.4	27%	2.3	18%	17	0.6	4%	2	0.5	4%	127k	66%
Control	7.0	56%	1.4	11%	2	6.0	48%	6	0.0	0%	248k	130%
View	1.0	8%	0.8	6%	4	0.2	1%	1	0.0	0%	0k	0%
Theme	1.1	8%	1.1	8%	2	0.0	0%	0	0.0	0%	32k	17%
Total	12.5	100%	5.6	44%	25	6.9	54%	9	0.1	0%	190k	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/default.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
catholicquestions.ca/qa-include/qa-theme-base.php
qa-theme/Classic/qa-theme.php

SELECT title, content FROM qa_options

0.53 ms - 338 rows - 2 columns

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

0.10 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.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 (SELECT postid FROM qa_posts WHERE type='Q' ORDER BY qa_posts.created DESC LIMIT 0,20) y ON qa_posts.postid=y.postid

1.22 ms - 20 rows - 33 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`, ausers.flags AS `oflags`, ausers.level AS `olevel`, ausers.email AS `oemail`, ausers.handle AS `ohandle`, BINARY ausers.avatarblobid AS `oavatarblobid`, ausers.avatarwidth AS `oavatarwidth`, ausers.avatarheight AS `oavatarheight`, auserpoints.points AS `opoints` 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 LEFT JOIN qa_users AS ausers ON aposts.userid=ausers.userid LEFT JOIN qa_userpoints AS auserpoints ON aposts.userid=auserpoints.userid JOIN (SELECT postid FROM qa_posts WHERE type='A' ORDER BY qa_posts.created DESC LIMIT 0,50) y ON aposts.postid=y.postid WHERE qa_posts.type='Q'

1.67 ms - 46 rows - 50 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.backpath='' UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.backpath='' UNION SELECT parentid FROM qa_categories WHERE backpath='' UNION SELECT categoryid FROM qa_categories WHERE backpath='') 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

1.25 ms - 18 rows - 9 columns

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

1.39 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.33 ms - 2 rows - 8 columns

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

0.18 ms - 0 rows - 5 columns

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

0.22 ms - 0 rows - 3 columns