API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 18th, 2017
250
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.99 KB | None | 0 0
raw download clone embed print report
  1. MyBB Debug Information
  2.  
  3. Page Generation
  4.  
  5. Page Generation Statistics
  6. Page Generation Time: 779 ms No. DB Queries: 16
  7. PHP Processing Time: 716 ms (91.93%) DB Processing Time: 63 ms (8.07%)
  8. Extensions Used: mysqli, xml Global.php Processing Time: 262 ms
  9. PHP Version: 5.6.31 Server Load: 7.99
  10. GZip Encoding Status: Enabled No. Templates Used: 100 (100 Cached / 1 Manually Loaded)
  11. Memory Usage: 49.75 MB (52166656 bytes) Memory Limit: 128M
  12. Database Connections (1 Total)
  13.  
  14. [READ] crawwng2_crackingking@localhost (Connected in 3 ms)
  15.  
  16. Database Queries (16 Total)
  17.  
  18. #1 - Select Query
  19. SELECT * FROM mybb_sessions WHERE sid='e9a84794c73353e8ec746ba24de0d667' AND ip=X'50d88a47'
  20. Table Type Possible Keys Key Key Length Ref Rows Extra
  21. mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
  22. Query Time: 704 μs
  23.  
  24. #2 - Select Query
  25. SELECT title,cache FROM mybb_datacache WHERE title='banned'
  26. Table Type Possible Keys Key Key Length Ref Rows Extra
  27. mybb_datacache const PRIMARY PRIMARY 152 const 1
  28. Query Time: 18 ms
  29.  
  30. #3 - Select Query
  31. SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='23972' LIMIT 1
  32. Table Type Possible Keys Key Key Length Ref Rows Extra
  33. u const PRIMARY PRIMARY 4 const 1
  34. f const PRIMARY PRIMARY 4 const 1
  35. Query Time: 1 ms
  36.  
  37. #4 - Write Query
  38. UPDATE mybb_sessions SET `uid`='23972', `time`=1511048195, `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', `location1`=0, `location2`=0, `nopermission`=0 WHERE sid='e9a84794c73353e8ec746ba24de0d667'
  39. Query Time: 3 ms
  40.  
  41. (Plugin Hook: global_start)
  42. #5 - Select Query
  43. SELECT mybb2fa_block FROM mybb_sessions WHERE sid='e9a84794c73353e8ec746ba24de0d667'
  44. Table Type Possible Keys Key Key Length Ref Rows Extra
  45. mybb_sessions const PRIMARY PRIMARY 98 const 1
  46. Query Time: 549 μs
  47.  
  48. #6 - Select Query
  49. SELECT name, tid, properties, stylesheets, allowedgroups FROM mybb_themes WHERE tid = '10' LIMIT 1
  50. Table Type Possible Keys Key Key Length Ref Rows Extra
  51. mybb_themes const PRIMARY PRIMARY 2 const 1
  52. Query Time: 584 μs
  53.  
  54. #7 - Select Query
  55. SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_logoutlink' ,'index_statspage' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'forumbit_depth2_forum_lastpost_never' ,'forumbit_depth2_forum_viewers' ,'forumbit_moderators_group' ,'forumbit_moderators_user' ,'forumbit_depth2_forum_lastpost_hidden' ,'forumbit_subforums' ,'forumbit_depth2_forum_unapproved_posts' ,'forumbit_depth2_forum_unapproved_threads' ,'viewgroups_index' ,'' ,'dvz_shoutbox' ,'dvz_shoutbox_panel' ,'dvz_stream_entry' ,'dvz_stream_widget' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_member_user' ,'header_welcomeblock_member_moderator' ,'header_welcomeblock_member_admin' ,'error' ,'global_pending_joinrequests' ,'global_awaiting_activation' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'footer_themeselect' ,'global_unreadreports' ,'footer_contactus' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission' ,'global_pm_alert' ,'header_menu_search' ,'header_menu_portal' ,'redirect' ,'footer_languageselect_option' ,'video_dailymotion_embed' ,'video_facebook_embed' ,'video_liveleak_embed' ,'video_metacafe_embed' ,'video_myspacetv_embed' ,'video_veoh_embed' ,'video_vimeo_embed' ,'video_yahoo_embed' ,'video_youtube_embed' ,'debug_summary' ,'smilieinsert_row' ,'smilieinsert_row_empty' ,'smilieinsert' ,'smilieinsert_getmore' ,'smilieinsert_smilie' ,'global_board_offline_modal' ,'footer_themeselector' ,'task_image' ,'usercp_themeselector_option' ,'mycode_code' ,'mycode_email' ,'mycode_img' ,'mycode_php' ,'mycode_quote_post' ,'mycode_size_int' ,'mycode_url' ,'global_no_permission_modal' ,'global_boardclosed_reason' ,'nav_dropdown' ,'global_remote_avatar_notice' ,'header_welcomeblock_member_pms' ,'header_welcomeblock_member_search' ,'header_welcomeblock_guest' ,'header_menu_calendar' ,'header_menu_memberlist' ,'global_dst_detection' ,'header_quicksearch' ,'smilie') AND sid IN ('-2','-1','8') ORDER BY sid ASC
  56. Table Type Possible Keys Key Key Length Ref Rows Extra
  57. mybb_templates range sid sid 364 305 Using index condition
  58. Query Time: 11 ms
  59.  
  60. (Plugin Hook: index_start)
  61. #8 - Select Query
  62. SELECT gid,title,namestyle FROM mybb_usergroups WHERE gid NOT IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','')
  63. Table Type Possible Keys Key Key Length Ref Rows Extra
  64. mybb_usergroups ALL PRIMARY 28 Using where
  65. Query Time: 757 μs
  66.  
  67. #9 - Select Query
  68. SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1511044595' ORDER BY u.username ASC, s.time DESC
  69. Table Type Possible Keys Key Key Length Ref Rows Extra
  70. s range time time 4 501 Using index condition; Using temporary; Using filesort
  71. u eq_ref PRIMARY PRIMARY 4 crawwng2_crackingm1805.s.uid 1
  72. Query Time: 7 ms
  73.  
  74. #10 - Select Query
  75. SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid = f.fid AND fr.uid = '23972') WHERE f.active != 0 ORDER BY pid, disporder
  76. Table Type Possible Keys Key Key Length Ref Rows Extra
  77. f ALL 104 Using where; Using filesort
  78. fr eq_ref fid fid 8 crawwng2_crackingm1805.f.fid,const 1 Using where
  79. Query Time: 2 ms
  80.  
  81. #11 - Select Query
  82. SELECT title,cache FROM mybb_datacache WHERE title='forumpermissions'
  83. Table Type Possible Keys Key Key Length Ref Rows Extra
  84. mybb_datacache const PRIMARY PRIMARY 152 const 1
  85. Query Time: 9 ms
  86.  
  87. #12 - Select Query
  88. SELECT template FROM mybb_templates WHERE title='forumbit_depth1_forum' AND sid IN ('-2','-1','8') ORDER BY sid DESC LIMIT 1
  89. Table Type Possible Keys Key Key Length Ref Rows Extra
  90. mybb_templates range sid sid 364 3 Using where
  91. Query Time: 852 μs
  92.  
  93. #13 - Select Query
  94. SELECT uid, username, username AS userusername, avatar, avatartype, usergroup, displaygroup FROM mybb_users WHERE uid IN (198241,251672,119021,53178,218900,250874,103371,120465,57931,92997,251382,240820,175352,85053,195970,189436,134920,251561,251647,38008,198310,251291,251665,172970,122448,195272,155202,161018,112764,128280,104663,59895,176443,88289,167379,125794,250928,125392,237215,207467,169879,250494,251249,251303,152616,193143,96509,251482,238016,118756,155120,128566,251618,42423,248819,132832,206548,94433,154334,251505,251443,250702,104244,85126,23972,168979,250174,251133,90943,251626)
  95. Table Type Possible Keys Key Key Length Ref Rows Extra
  96. mybb_users range PRIMARY PRIMARY 4 70 Using where
  97. Query Time: 1 ms
  98.  
  99. (Plugin Hook: index_end)
  100. #14 - Select Query
  101. SELECT s.*, u.username, u.usergroup, u.displaygroup, u.avatar FROM mybb_dvz_shoutbox s LEFT JOIN mybb_users u ON u.uid = s.uid WHERE s.text IS NOT NULL ORDER BY s.id DESC LIMIT 25
  102. Table Type Possible Keys Key Key Length Ref Rows Extra
  103. s index PRIMARY 4 25 Using where
  104. u eq_ref PRIMARY PRIMARY 4 crawwng2_crackingm1805.s.uid 1 Using where
  105. Query Time: 984 μs
  106.  
  107. #15 - Select Query
  108. SELECT t.tid, t.subject, t.fid, t.dateline, u.uid, u.username, f.name FROM mybb_threads t LEFT JOIN mybb_users u ON t.uid = u.uid LEFT JOIN mybb_forums f ON t.fid = f.fid WHERE t.tid > 0 AND t.visible = 1 AND t.firstpost != 0 AND f.password = '' AND f.fid NOT IN (5,4,6,7,148) ORDER BY t.tid DESC LIMIT 6
  109. Table Type Possible Keys Key Key Length Ref Rows Extra
  110. t range PRIMARY,fid,firstpost PRIMARY 4 76044 Using where
  111. f eq_ref PRIMARY PRIMARY 2 crawwng2_crackingm1805.t.fid 1 Using where
  112. u eq_ref PRIMARY PRIMARY 4 crawwng2_crackingm1805.t.uid 1
  113. Query Time: 1 ms
  114.  
  115. (Plugin Hook: pre_output_page)
  116. #16 - Select Query
  117. SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (92997,198241,207467,0,85053,251505,251443,195970,169879,250494,189436,251672,248819,251661,134920,251561,251249,251303,251647,132832,206548,38008,152616,193143,23972,119021,85126,53178,218900,155202,161018,172970,112764,198310,251291,251665,96509,251482,238016,118756,250874,155120,128566,251618,122448,195272,103371,250702,167379,104244,128280,104663,59895,176443,88289,120465,125794,154334,250928,125392,57931,94433,237215,250174,90943,251382,251133,251626,168979,240820,175352,42423)
  118. Table Type Possible Keys Key Key Length Ref Rows Extra
  119. mybb_users range PRIMARY PRIMARY 4 72 Using where
  120. Query Time: 1 ms
  121.  
  122. Cache Calls (23 Total, 191 ms)
  123.  
  124. #23 - Read Call
  125. (memcache) [HIT] tabmenu
  126. Call Time: 343 μs
  127.  
  128. Template Statistics
  129.  
  130. Templates Used (Loaded for this Page) - 100 Total
  131. debug_summary, error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, forumbit_depth1_cat, forumbit_depth1_forum_lastpost, forumbit_depth2_cat, forumbit_depth2_forum, forumbit_depth2_forum_lastpost, forumbit_depth2_forum_lastpost_hidden, forumbit_depth2_forum_lastpost_never, forumbit_depth2_forum_unapproved_posts, forumbit_depth2_forum_unapproved_threads, forumbit_depth2_forum_viewers, forumbit_depth3, forumbit_depth3_statusicon, forumbit_moderators, forumbit_moderators_group, forumbit_moderators_user, forumbit_subforums, global_awaiting_activation, global_bannedwarning, global_boardclosed_reason, global_boardclosed_warning, global_board_offline_modal, global_dst_detection, global_no_permission_modal, global_pending_joinrequests, global_pm_alert, global_remote_avatar_notice, global_unreadreports, gobutton, header, headerinclude, header_menu_calendar, header_menu_memberlist, header_menu_portal, header_menu_search, header_quicksearch, header_welcomeblock_guest, header_welcomeblock_member, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_user, htmldoctype, index, index_birthdays, index_birthdays_birthday, index_boardstats, index_logoutlink, index_stats, index_statspage, index_whosonline, index_whosonline_memberbit, mycode_code, mycode_email, mycode_img, mycode_php, mycode_quote_post, mycode_size_int, mycode_url, nav, nav_bit, nav_bit_active, nav_dropdown, nav_sep, nav_sep_active, redirect, smilie, smilieinsert, smilieinsert_getmore, smilieinsert_row, smilieinsert_row_empty, smilieinsert_smilie, task_image, usercp_themeselector_option, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_metacafe_embed, video_myspacetv_embed, video_veoh_embed, video_vimeo_embed, video_yahoo_embed, video_youtube_embed, dvz_shoutbox, dvz_shoutbox_panel, dvz_stream_entry, dvz_stream_widget, viewgroups_index, forumbit_depth1_forum
  132.  
  133. Templates Requiring Additional Calls (Not Cached at Startup) - 1 Total
  134. forumbit_depth1_forum
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!