Recent activity in Raspberry Pi Pico

To see more, click for all the questions in this category.

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	21.5	17%	14.4	11%	19	6.6	5%	2	0.5	0%	111k	62%
Control	74.2	59%	18.7	15%	13	61.1	49%	9	0.0	0%	31k	17%
View	8.7	7%	7.5	6%	5	1.8	1%	1	0.0	0%	14k	8%
Theme	19.3	15%	19.3	15%	2	0.0	0%	0	0.0	0%	21k	12%
Total	123.8	100%	60.1	48%	39	69.5	56%	12	0.0	0%	178k	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-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/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.37 ms - 340 rows - 2 columns

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

1.22 ms - 1 row - 2 columns

7.91 ms - 1 row - 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 catidpath1=(SELECT categoryid FROM qa_categories WHERE backpath='raspberry-pi-pico' LIMIT 1) AND type='A' ORDER BY qa_posts.created DESC LIMIT 0,50) y ON aposts.postid=y.postid WHERE qa_posts.type='Q'

10.51 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 catidpath1=(SELECT categoryid FROM qa_categories WHERE backpath='raspberry-pi-pico' LIMIT 1) AND 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'))

11.53 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 catidpath1=(SELECT categoryid FROM qa_categories WHERE backpath='raspberry-pi-pico' LIMIT 1) AND 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')

13.38 ms - 1 row - 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='raspberry-pi-pico' UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.backpath='raspberry-pi-pico' UNION SELECT parentid FROM qa_categories WHERE backpath='raspberry-pi-pico' UNION SELECT categoryid FROM qa_categories WHERE backpath='raspberry-pi-pico') 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.97 ms - 3 rows - 9 columns

SELECT categoryid FROM qa_categories WHERE backpath='raspberry-pi-pico'

2.39 ms - 1 row - 1 column

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

2.13 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.16 ms - 0 rows - 8 columns

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

2.14 ms - 5 rows - 5 columns

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

1.76 ms - 0 rows - 3 columns

Recent activity in Raspberry Pi Pico

Categories