Advertisement
Guest User

Untitled

a guest
Feb 26th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.94 KB | None | 0 0
  1. 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%)
  2.  
  3. 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%)
  4. 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%)
  5. 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%)
  6. 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%)
  7.  
  8. SELECT title, content FROM qa_options
  9.  
  10. 4367.29 ms - 95073 rows - 2 columns
  11.  
  12. SELECT 'db_time' AS title, UNIX_TIMESTAMP(NOW()) AS content
  13.  
  14. 0.21 ms - 1 row - 2 columns
  15.  
  16. 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
  17.  
  18. 1.54 ms - 20 rows - 35 columns
  19.  
  20. 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
  21.  
  22. 0.63 ms - 15 rows - 9 columns
  23.  
  24. 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'
  25.  
  26. 0.20 ms - 1 row - 20 columns
  27.  
  28. SELECT noticeid, content, format, tags, UNIX_TIMESTAMP(created) AS created FROM qa_usernotices WHERE userid='3' ORDER BY created
  29.  
  30. 117.05 ms - 0 rows - 5 columns
  31.  
  32. 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'
  33.  
  34. 4.60 ms - 518 rows - 4 columns
  35.  
  36. SELECT action, period, count FROM qa_userlimits WHERE userid='3'
  37.  
  38. 0.57 ms - 8 rows - 3 columns
  39.  
  40. SELECT entityid, entitytype, level FROM qa_userlevels WHERE userid='3'
  41.  
  42. 0.25 ms - 0 rows - 3 columns
  43.  
  44. SELECT action, period, count FROM qa_iplimits WHERE ip=COALESCE(INET_ATON('186.251.85.159'), 0)
  45.  
  46. 0.31 ms - 6 rows - 3 columns
  47.  
  48. 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
  49.  
  50. 3.64 ms - 6 rows - 8 columns
  51.  
  52. SELECT widgetid, place, position, tags, title FROM qa_widgets ORDER BY position
  53.  
  54. 161.42 ms - 2 rows - 5 columns
  55.  
  56. SELECT UNIX_TIMESTAMP(meta_value) FROM qa_usermeta WHERE user_id=3 AND meta_key='visited_profile'
  57.  
  58. 0.57 ms - 1 row - 1 column
  59.  
  60. SELECT COUNT(event) FROM qa_eventlog
  61. WHERE FROM_UNIXTIME(1456485767) <= datetime
  62. AND DATE_SUB(CURDATE(),INTERVAL 365 DAY) <= datetime
  63. AND (
  64. (userid=3 AND event LIKE "in_%")
  65. OR ((event LIKE "u_message" OR event LIKE "u_wall_post") AND params LIKE "userid=3\t%")
  66. )
  67.  
  68.  
  69. 0.78 ms - 1 row - 1 column
  70.  
  71. SELECT * FROM qa_widgetanyw ORDER BY ordering
  72.  
  73. 5.47 ms - 9 rows - 6 columns
  74.  
  75. 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))
  76.  
  77. 2.62 ms - 40 rows - 4 columns
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement