Raspberry Pi Products Category on Adafruit Industries

Your answer

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	21.8	14%	15.2	10%	19	6.9	4%	2	0.0	0%	111k	55%
Control	70.2	47%	22.9	15%	10	54.3	36%	12	0.0	0%	32k	16%
View	15.8	10%	14.5	9%	18	1.9	1%	1	0.0	0%	37k	18%
Theme	20.9	14%	21.0	14%	3	0.0	0%	0	0.0	0%	15k	7%
Stats	19.0	12%	2.2	1%	0	17.7	11%	2	0.0	0%	4k	2%
Total	147.9	100%	76.0	51%	50	80.7	54%	17	0.0	0%	202k	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/question.php
qa-include/util/sort.php
qa-include/util/string.php
qa-include/app/captcha.php
qa-include/pages/question-view.php
qa-include/app/updates.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/FileCacheDriver.php
Q2A/Storage/CacheDriver.php
qa-include/app/limits.php
qa-include/lang/qa-lang-main.php
qa-plugin/basic-adsense/qa-basic-adsense.php
qa-include/plugins/qa-widget-activity-count.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/app/post-update.php
qa-include/db/post-update.php
qa-include/plugins/qa-viewer-basic.php
qa-include/vendor/htmLawed.php
qa-include/lang/qa-lang-question.php
qa-plugin/wysiwyg-editor/qa-wysiwyg-editor.php
qa-include/lang/qa-lang-misc.php
q2a-recaptcha-v3-master/src/qa-recaptcha-captcha.php
q2a-recaptcha-v3-master/src/admin-form.php
q2a-recaptcha-v3-master/src/user-verifier.php
html/qa-include/qa-theme-base.php
qa-theme/SnowFlat/qa-theme.php
qa-include/lang/qa-lang-users.php

SELECT title, content FROM qa_options

5.39 ms - 340 rows - 2 columns

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

1.48 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.content AS `content`, qa_posts.notify AS `notify`, UNIX_TIMESTAMP(qa_posts.updated) AS `updated`, qa_posts.updatetype AS `updatetype`, qa_posts.format, qa_posts.lastuserid, qa_posts.lastip AS `lastip`, qa_posts.parentid, qa_posts.lastviewip AS `lastviewip`, 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, lastusers.handle AS `lasthandle` 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_users AS lastusers ON qa_posts.lastuserid=lastusers.userid LEFT JOIN qa_userpoints ON qa_posts.userid=qa_userpoints.userid WHERE qa_posts.postid=70

5.72 ms - 1 row - 44 columns

5.57 ms - 0 rows - 44 columns

6.00 ms - 0 rows - 44 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 WHERE qa_posts.postid=(SELECT IF(LEFT(parent.type, 1)='A', parent.parentid, parent.postid) FROM qa_posts AS child LEFT JOIN qa_posts AS parent ON parent.postid=child.parentid WHERE child.postid=70 AND parent.type IN('Q','A'))

5.52 ms - 0 rows - 34 columns

5.48 ms - 0 rows - 44 columns

5.45 ms - 0 rows - 44 columns

SELECT title, content FROM qa_postmetas WHERE postid=70 AND title='qa_q_extra'

2.03 ms - 1 row - 2 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=(SELECT categoryid FROM qa_posts WHERE postid=70) UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.categoryid=(SELECT categoryid FROM qa_posts WHERE postid=70) UNION SELECT parentid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=70) UNION SELECT categoryid FROM qa_categories WHERE categoryid=(SELECT categoryid FROM qa_posts WHERE postid=70)) 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

10.35 ms - 3 rows - 9 columns

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

2.33 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.29 ms - 0 rows - 8 columns

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

1.98 ms - 4 rows - 5 columns

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

1.58 ms - 0 rows - 3 columns

SELECT action, period, count FROM qa_userlimits WHERE userid=NULL

1.90 ms - 0 rows - 3 columns

UPDATE qa_posts SET views=views+1, lastviewip=UNHEX('12e2e2a4') WHERE postid=70 AND (lastviewip IS NULL OR lastviewip!=UNHEX('12e2e2a4'))

6.63 ms

UPDATE qa_posts AS x, (SELECT parents.postid, MAX(parents.created) AS qcreated, COALESCE(MAX(children.created), MAX(parents.created)) as acreated, COUNT(children.postid) AS acount, MAX(parents.netvotes) AS netvotes, MAX(parents.views) AS views FROM qa_posts AS parents LEFT JOIN qa_posts AS children ON parents.postid=children.parentid AND children.type='A' WHERE parents.postid BETWEEN 70 AND 70 GROUP BY postid) AS a SET x.hotness=(((TO_DAYS(a.qcreated)-734138)*86400.0+TIME_TO_SEC(a.qcreated))*100 + ((TO_DAYS(a.acreated)-734138)*86400.0+TIME_TO_SEC(a.acreated))*100 + (a.acount+0.0)*16000000 + (a.netvotes+0.0)*16000000 + (a.views+0.0)*400000) WHERE x.postid=a.postid

11.03 ms

Raspberry Pi Products Category on Adafruit Industries

Your answer

0 Answers