Recent activity

0 answers

Operating system images – Raspberry Pi

edited in Raspberry Pi OS by administrator

0 answers

Raspberry Pi OS – Raspberry Pi

asked in Raspberry Pi OS by anonymous

0 answers

Raspberry Pi Products Category on Adafruit Industries

asked in Raspberry Pi by anonymous

0 answers

How to run a webserver on Raspberry Pi Pico W?

asked in Raspberry Pi by administrator

0 answers

How to use Raspberry pi for VPN?

edited in Raspberry Pi by administrator

0 answers

How to use Raspberry Pi Zero W P4wnP1 A.L.O.A?

asked in Raspberry Pi by administrator

0 answers

How to Install MariaDB on Raspberry Pi?

asked in Raspberry Pi by administrator

0 answers

Web server on any Raspberry Pi?

asked in Raspberry Pi by administrator

0 answers

How to install phpmyadmin in Raspberry Pi?

asked in Raspberry Pi by administrator

To see more, click for the full list of questions or popular tags.

Recent activity

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	21.2	14%	14.5	10%	19	6.6	4%	2	0.0	0%	111k	48%
Control	71.7	50%	19.7	13%	13	57.7	40%	8	0.0	0%	86k	37%
View	24.2	17%	17.0	11%	4	7.8	5%	1	0.0	0%	0k	0%
Theme	25.1	17%	25.1	17%	2	0.0	0%	0	0.0	0%	31k	13%
Total	142.4	100%	76.5	53%	38	72.2	50%	11	0.0	0%	229k	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/activity.php
qa-include/app/q-list.php
qa-include/util/sort.php
qa-include/lang/qa-lang-main.php
qa-include/app/updates.php
qa-include/app/posts.php
qa-include/app/post-create.php
qa-include/db/post-create.php
qa-include/db/points.php
qa-include/db/hotness.php
qa-include/util/string.php
qa-include/app/post-update.php
qa-include/db/post-update.php
qa-include/app/limits.php
qa-plugin/basic-adsense/qa-basic-adsense.php
qa-include/plugins/qa-widget-activity-count.php
qa-include/lang/qa-lang-users.php
html/qa-include/qa-theme-base.php
qa-theme/SnowFlat/qa-theme.php

SELECT title, content FROM qa_options

5.42 ms - 340 rows - 2 columns

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

1.22 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.amaxvote, 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

8.20 ms - 9 rows - 34 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.amaxvote, 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'

8.79 ms - 0 rows - 51 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.amaxvote, 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(cposts.type, 1) AS `obasetype`, INSTR(cposts.type, '_HIDDEN')>0 AS `ohidden`, cposts.postid AS `opostid`, cposts.userid AS `ouserid`, cposts.cookieid AS `ocookieid`, cposts.name AS `oname`, cposts.createip AS `oip`, UNIX_TIMESTAMP(cposts.created) AS `otime`, cposts.flagcount AS `oflagcount`, cusers.flags AS `oflags`, cusers.level AS `olevel`, cusers.email AS `oemail`, cusers.handle AS `ohandle`, BINARY cusers.avatarblobid AS `oavatarblobid`, cusers.avatarwidth AS `oavatarwidth`, cusers.avatarheight AS `oavatarheight`, cuserpoints.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 parentposts ON qa_posts.postid=(CASE LEFT(parentposts.type, 1) WHEN 'A' THEN parentposts.parentid ELSE parentposts.postid END) JOIN qa_posts AS cposts ON parentposts.postid=cposts.parentid LEFT JOIN qa_users AS cusers ON cposts.userid=cusers.userid LEFT JOIN qa_userpoints AS cuserpoints ON cposts.userid=cuserpoints.userid JOIN (SELECT postid FROM qa_posts WHERE type='C' ORDER BY qa_posts.created DESC LIMIT 0,50) y ON cposts.postid=y.postid WHERE qa_posts.type='Q' AND ((parentposts.type='Q') OR (parentposts.type='A'))

10.33 ms - 0 rows - 51 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.amaxvote, 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(editposts.type, 1) AS `obasetype`, INSTR(editposts.type, '_HIDDEN')>0 AS `ohidden`, editposts.postid AS `opostid`, editposts.lastuserid AS `ouserid`, editposts.cookieid AS `ocookieid`, editposts.name AS `oname`, editposts.lastip AS `oip`, UNIX_TIMESTAMP(editposts.updated) AS `otime`, editposts.flagcount AS `oflagcount`, editposts.updatetype AS `oupdatetype`, UNIX_TIMESTAMP(editposts.updated) AS `oupdated`, editusers.flags AS `oflags`, editusers.level AS `olevel`, editusers.email AS `oemail`, editusers.handle AS `ohandle`, BINARY editusers.avatarblobid AS `oavatarblobid`, editusers.avatarwidth AS `oavatarwidth`, editusers.avatarheight AS `oavatarheight`, edituserpoints.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 parentposts ON qa_posts.postid=IF(LEFT(parentposts.type, 1)='Q', parentposts.postid, parentposts.parentid) JOIN qa_posts AS editposts ON parentposts.postid=IF(LEFT(editposts.type, 1)='Q', editposts.postid, editposts.parentid) LEFT JOIN qa_users AS editusers ON editposts.lastuserid=editusers.userid LEFT JOIN qa_userpoints AS edituserpoints ON editposts.lastuserid=edituserpoints.userid JOIN (SELECT postid FROM qa_posts WHERE type IN ('Q', 'A', 'C') ORDER BY qa_posts.updated DESC LIMIT 0,50) y ON editposts.postid=y.postid WHERE parentposts.type IN ('Q', 'A', 'C') AND qa_posts.type IN ('Q', 'A', 'C')

15.30 ms - 9 rows - 53 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

8.30 ms - 3 rows - 9 columns

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

2.34 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

2.17 ms - 0 rows - 8 columns

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

2.26 ms - 4 rows - 5 columns

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

7.82 ms - 0 rows - 3 columns