Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Total – 29175.1ms (100%) – PHP 689.9ms (2%), MySQL 4667.2ms (15%), Other 23818.0ms (81%) – 43 PHP files, 16 DB queries, 25442k RAM (100%)
- Setup – 22973.3ms (78%) – PHP 540.9ms (1%), MySQL 4367.5ms (14%), Other 18064.9ms (61%) – 25 PHP files, 2 DB queries, 21766k RAM (85%)
- Control – 673.6ms (2%) – PHP 13.0ms (0%), MySQL 290.2ms (0%), Other 370.4ms (1%) – 6 PHP files, 10 DB queries, 1235k RAM (4%)
- View – 3961.0ms (13%) – PHP 100.0ms (0%), MySQL 0.0ms (0%), Other 3861.0ms (13%) – 5 PHP files, 0 DB queries, 371k RAM (1%)
- Theme – 1567.1ms (5%) – PHP 36.0ms (0%), MySQL 9.4ms (0%), Other 1521.6ms (5%) – 7 PHP files, 4 DB queries, 2066k RAM (8%)
- SELECT title, content FROM qa_options
- 4367.29 ms - 95073 rows - 2 columns
- SELECT 'db_time' AS title, UNIX_TIMESTAMP(NOW()) AS content
- 0.21 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, 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_uservotes.vote AS uservote, qa_uservotes.flag AS userflag, qa_userfavorites.entityid<=>qa_posts.postid AS userfavoriteq, qa_posts.userid, qa_posts.cookieid, INET_NTOA(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_uservotes ON qa_posts.postid=qa_uservotes.postid AND qa_uservotes.userid='3' LEFT JOIN qa_userfavorites ON qa_posts.postid=qa_userfavorites.entityid AND qa_userfavorites.userid='3' AND qa_userfavorites.entitytype='Q' 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.54 ms - 20 rows - 35 columns
- SELECT qa_categories.categoryid, qa_categories.parentid, qa_categories.title AS title, qa_categories.tags AS tags, qa_categories.qcount, qa_categories.position, COUNT(child.categoryid) AS childcount, qa_categories.content AS content, 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
- 0.63 ms - 15 rows - 9 columns
- SELECT qa_users.userid, passsalt, HEX(passcheck) AS passcheck, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS created, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS loggedin, INET_NTOA(loginip) AS loginip, UNIX_TIMESTAMP(written) AS written, INET_NTOA(writeip) AS writeip, BINARY avatarblobid AS avatarblobid, avatarwidth, avatarheight, points, wallposts FROM qa_users LEFT JOIN qa_userpoints ON qa_userpoints.userid=qa_users.userid WHERE qa_users.userid='3'
- 0.20 ms - 1 row - 20 columns
- SELECT noticeid, content, format, tags, UNIX_TIMESTAMP(created) AS created FROM qa_usernotices WHERE userid='3' ORDER BY created
- 117.05 ms - 0 rows - 5 columns
- SELECT entitytype AS type, IF (entitytype='U', entityid, NULL) AS userid, qa_categories.backpath AS categorybackpath, qa_words.word AS tags FROM qa_userfavorites LEFT JOIN qa_words ON entitytype='T' AND wordid=entityid LEFT JOIN qa_categories ON entitytype='C' AND categoryid=entityid WHERE userid='3' AND entitytype!='Q'
- 4.60 ms - 518 rows - 4 columns
- SELECT action, period, count FROM qa_userlimits WHERE userid='3'
- 0.57 ms - 8 rows - 3 columns
- SELECT entityid, entitytype, level FROM qa_userlevels WHERE userid='3'
- 0.25 ms - 0 rows - 3 columns
- SELECT action, period, count FROM qa_iplimits WHERE ip=COALESCE(INET_ATON('186.251.85.159'), 0)
- 0.31 ms - 6 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
- 3.64 ms - 6 rows - 8 columns
- SELECT widgetid, place, position, tags, title FROM qa_widgets ORDER BY position
- 161.42 ms - 2 rows - 5 columns
- SELECT UNIX_TIMESTAMP(meta_value) FROM qa_usermeta WHERE user_id=3 AND meta_key='visited_profile'
- 0.57 ms - 1 row - 1 column
- SELECT COUNT(event) FROM qa_eventlog
- WHERE FROM_UNIXTIME(1456485767) <= datetime
- AND DATE_SUB(CURDATE(),INTERVAL 365 DAY) <= datetime
- AND (
- (userid=3 AND event LIKE "in_%")
- OR ((event LIKE "u_message" OR event LIKE "u_wall_post") AND params LIKE "userid=3\t%")
- )
- 0.78 ms - 1 row - 1 column
- SELECT * FROM qa_widgetanyw ORDER BY ordering
- 5.47 ms - 9 rows - 6 columns
- SELECT postid, handle, vote, flag FROM qa_uservotes LEFT JOIN qa_users ON qa_uservotes.userid=qa_users.userid WHERE postid IN (764577,764546,764534,764535,764569,764542,764537,764508,764505,764483,764453,764427,764419,764393,764386,764375,764370,764345,764332,764313) AND ((vote!=0) OR (flag!=0))
- 2.62 ms - 40 rows - 4 columns
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement