Asky Q&A

Please log in or register to ask a question.

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	18.3	29%	11.0	17%	19	5.0	8%	2	2.2	3%	111k	70%
Control	20.1	32%	7.1	11%	4	15.7	25%	6	0.0	0%	12k	7%
View	3.1	4%	2.9	4%	6	0.0	0%	0	0.2	0%	10k	6%
Theme	20.3	32%	15.2	24%	6	5.4	8%	1	0.0	0%	22k	14%
Total	62.0	100%	36.3	58%	35	26.2	42%	9	0.0	0%	158k	100%

www/html/index.php
html/qa-include/qa-index.php
html/qa-include/qa-base.php
www/html/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/qa-auto-post/qa-plugin.php
qa-plugin/wysiwyg-editor/qa-plugin.php
html/qa-include/qa-db.php
html/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/basic-adsense/qa-plugin.php
qa-plugin/mouseover-layer/qa-plugin.php
qa-plugin/q2a-recaptcha-v3-master/qa-plugin.php
qa-plugin/xml-sitemap/qa-plugin.php
qa-include/pages/ask.php
qa-include/app/limits.php
qa-include/util/sort.php
qa-include/app/updates.php
qa-include/lang/qa-lang-main.php
qa-include/plugins/qa-widget-category-list.php
qa-plugin/basic-adsense/qa-basic-adsense.php
qa-include/plugins/qa-widget-activity-count.php
qa-include/util/string.php
qa-include/lang/qa-lang-question.php
html/qa-include/qa-theme-base.php
qa-theme/SnowFlat/qa-theme.php
qa-include/lang/qa-lang-users.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/FileCacheDriver.php
Q2A/Storage/CacheDriver.php

SELECT title, content FROM qa_options

4.05 ms - 340 rows - 2 columns

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

0.99 ms - 1 row - 2 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=26 UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.categoryid=26 UNION SELECT parentid FROM qa_categories WHERE categoryid=26 UNION SELECT categoryid FROM qa_categories WHERE categoryid=26) y ON qa_categories.parentid<=>parentkey ORDER BY qa_categories.position

4.48 ms - 3 rows - 6 columns

SELECT word, tagcount FROM qa_words JOIN (SELECT wordid FROM qa_words WHERE tagcount>0 ORDER BY tagcount DESC LIMIT 0,1000) y ON qa_words.wordid=y.wordid

3.70 ms - 20 rows - 2 columns

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

2.22 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

1.97 ms - 0 rows - 8 columns

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

1.84 ms - 5 rows - 5 columns

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

1.52 ms - 0 rows - 3 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=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 LEFT JOIN qa_categories AS child ON child.parentid=qa_categories.categoryid GROUP BY qa_categories.categoryid ORDER BY qa_categories.position

5.41 ms - 3 rows - 9 columns

Categories