SHARE
TWEET

Untitled

a guest Nov 15th, 2019 73 in 3 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MyBB Debug Information
  2. Page Generation
  3. Page Generation Statistics
  4. Page Generation Time:   130 ms  No. DB Queries: 53
  5. PHP Processing Time:    52 ms (40.03%)  DB Processing Time: 78 ms (59.97%)
  6. Extensions Used:    mysqli, xml Global.php Processing Time: 72 ms
  7. PHP Version:    7.3.7   Server Load:    0.88
  8. GZip Encoding Status:   Enabled No. Templates Used: 191 (241 Cached / 6 Manually Loaded)
  9. Memory Usage:   2 MB (2097152 bytes)    Memory Limit:   256M
  10. Database Connections (1 Total)
  11. [READ] carcassonne@innodb.endora.cz (Connected in 3 ms)
  12.  
  13. Database Queries (53 Total)
  14. #1 - Select Query
  15. SELECT title,cache FROM mybb_datacache
  16. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  17. mybb_datacache  ALL                 53 
  18. Query Time: 21 ms
  19.  
  20. #2 - Select Query
  21. SELECT * FROM mybb_sessions WHERE sid='c95f9388573c51876b7bb2d9f38177c9' AND ip=X'2e216030'
  22. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  23. mybb_sessions   const   PRIMARY,ip  PRIMARY 130 const   1  
  24. Query Time: 393 μs
  25.  
  26. #3 - Select Query
  27. SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
  28. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  29. u   const   PRIMARY PRIMARY 4   const   1  
  30. f   const   PRIMARY PRIMARY 4   const   1  
  31. Query Time: 865 μs
  32.  
  33. #4 - Write Query
  34. UPDATE mybb_sessions SET `uid`='1', `time`=1573852192, `location`='/forumdisplay.php?fid=5&prefix=8&debug=1', `useragent`='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36', `location1`=5, `location2`=0, `nopermission`=0 WHERE sid='c95f9388573c51876b7bb2d9f38177c9'
  35. Query Time: 853 μs
  36.  
  37. (Plugin Hook: global_start)
  38. #5 - Select Query
  39. SELECT COUNT(*) AS count FROM mybb_alerts a INNER JOIN mybb_alert_types t ON (a.alert_type_id = t.id) WHERE (a.alert_type_id IN (1,2,3,4,5,6,7,8,9,10) OR a.forced = 1 OR t.can_be_user_disabled = 0) AND t.enabled = 1 AND a.uid = 1 AND a.unread = 1;
  40. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  41. a   ref uid_index   uid_index   4   const   1   Using where
  42. t   eq_ref  PRIMARY PRIMARY 4   carcassonneforum.a.alert_type_id    1   Using where
  43. Query Time: 686 μs
  44.  
  45. (Plugin Hook: global_start)
  46. #6 - Select Query
  47. SELECT VERSION() as version
  48. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  49. No tables used
  50. Query Time: 185 μs
  51.  
  52. (Plugin Hook: global_start)
  53. #7 - Write Query
  54. SHOW FULL TABLES FROM `carcassonneforum` WHERE table_type = 'BASE TABLE' AND `Tables_in_carcassonneforum` = 'mybb_alerts'
  55. Query Time: 1 ms
  56.  
  57. (Plugin Hook: global_start)
  58. #8 - Select Query
  59. SELECT * FROM mybb_bam ORDER BY pinned DESC, disporder ASC, PID ASC
  60. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  61. mybb_bam    ALL                 6   Using filesort
  62. Query Time: 484 μs
  63.  
  64. #9 - Select Query
  65. SELECT template FROM mybb_templates WHERE title='smilie' AND sid IN ('-2','-1') ORDER BY sid DESC LIMIT 1
  66. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  67. mybb_templates  range   sid sid 484     2   Using index condition
  68. Query Time: 520 μs
  69.  
  70. #10 - Select Query
  71. SELECT template FROM mybb_templates WHERE title='bam_announcement_container' AND sid IN ('-2','-1') ORDER BY sid DESC LIMIT 1
  72. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  73. mybb_templates  range   sid sid 484     2   Using index condition
  74. Query Time: 522 μs
  75.  
  76. #11 - Select Query
  77. SELECT name, tid, properties, stylesheets, allowedgroups FROM mybb_themes WHERE tid = '10' LIMIT 1
  78. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  79. mybb_themes const   PRIMARY PRIMARY 2   const   1  
  80. Query Time: 431 μs
  81.  
  82. #12 - Select Query
  83. SELECT title,template FROM mybb_templates WHERE title IN ('' ,'forumdisplay' ,'forumdisplay_thread' ,'forumbit_depth1_cat' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumdisplay_subforums' ,'forumdisplay_threadlist' ,'forumdisplay_moderatedby' ,'forumdisplay_searchforum' ,'forumdisplay_thread_rating' ,'forumdisplay_threadlist_rating' ,'forumbit_depth1_forum_lastpost' ,'forumdisplay_thread_multipage_page' ,'forumdisplay_thread_multipage' ,'forumdisplay_thread_multipage_more' ,'forumdisplay_thread_gotounread' ,'forumbit_depth2_forum_lastpost' ,'forumdisplay_rules_link' ,'forumdisplay_orderarrow' ,'forumdisplay_newthread' ,'multipage' ,'multipage_breadcrumb' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'forumdisplay_thread_unapproved_posts' ,'forumdisplay_nothreads' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'forumdisplay_password_wrongpass' ,'forumdisplay_password' ,'forumdisplay_inlinemoderation_custom_tool' ,'forumbit_subforums' ,'forumbit_moderators' ,'forumbit_depth2_forum_lastpost_never' ,'forumbit_depth2_forum_lastpost_hidden' ,'forumdisplay_usersbrowsing_user' ,'forumdisplay_usersbrowsing' ,'forumdisplay_inlinemoderation' ,'forumdisplay_thread_modbit' ,'forumdisplay_inlinemoderation_col' ,'forumdisplay_inlinemoderation_selectall' ,'forumdisplay_threadlist_clearpass' ,'forumdisplay_thread_rating_moved' ,'forumdisplay_announcements_announcement' ,'forumdisplay_announcements' ,'forumdisplay_threads_sep' ,'forumbit_depth3_statusicon' ,'forumbit_depth3' ,'forumdisplay_sticky_sep' ,'forumdisplay_thread_attachment_count' ,'forumdisplay_rssdiscovery' ,'forumbit_moderators_group' ,'forumdisplay_inlinemoderation_openclose' ,'forumdisplay_inlinemoderation_stickunstick' ,'forumdisplay_inlinemoderation_softdelete' ,'forumdisplay_inlinemoderation_restore' ,'forumdisplay_inlinemoderation_delete' ,'forumdisplay_inlinemoderation_manage' ,'forumdisplay_nopermission' ,'forumbit_depth2_forum_unapproved_posts' ,'forumbit_depth2_forum_unapproved_threads' ,'forumbit_moderators_user' ,'forumdisplay_inlinemoderation_standard' ,'forumdisplay_threadlist_prefixes_prefix' ,'forumdisplay_threadlist_prefixes' ,'forumdisplay_thread_icon' ,'forumdisplay_rules' ,'forumdisplay_thread_deleted' ,'forumdisplay_announcements_announcement_modbit' ,'forumbit_depth2_forum_viewers' ,'forumdisplay_threadlist_sortrating' ,'forumdisplay_inlinemoderation_custom' ,'forumdisplay_announcement_rating' ,'forumdisplay_inlinemoderation_approveunapprove' ,'forumdisplay_threadlist_subscription' ,'gotofull_reply' ,'returntotop' ,'forumdisplay_inlinemoderation_applyprefix' ,'aamessage' ,'unreadPosts_link' ,'unreadPosts_counter' ,'unreadPosts_linkCounter' ,'unreadPosts_noData' ,'asb_begin' ,'asb_end' ,'asb_sidebox_column' ,'asb_wrapped_sidebox' ,'asb_toggle_icon' ,'asb_content_pad' ,'asb_expander' ,'newthreadmarker_searchlink' ,'newthreadmarker_mark' ,'mentionme_popup' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'pf_forumbit_depth1_cat' ,'pf_forumbit_depth1_cat_subforum' ,'pf_forumbit_depth1_forum_lastpost' ,'pf_forumbit_depth2_cat' ,'pf_forumbit_depth2_forum' ,'pf_forumbit_depth2_forum_lastpost' ,'pf_forumbit_depth3' ,'pf_forumbit_depth3_statusicon' ,'pf_forumbit_moderators' ,'pf_forumbit_subforums' ,'mp_forumbit_depth1_cat' ,'mp_forumbit_depth1_cat_subforum' ,'mp_forumbit_depth1_forum_lastpost' ,'mp_forumbit_depth2_cat' ,'mp_forumbit_depth2_forum' ,'mp_forumbit_depth2_forum_lastpost' ,'mp_forumbit_depth3' ,'mp_forumbit_depth3_statusicon' ,'mp_forumbit_moderators' ,'mp_forumbit_subforums' ,'sp_forumbit_depth1_cat' ,'sp_forumbit_depth1_cat_subforum' ,'sp_forumbit_depth1_forum_lastpost' ,'sp_forumbit_depth2_cat' ,'sp_forumbit_depth2_forum' ,'sp_forumbit_depth2_forum_lastpost' ,'sp_forumbit_depth3' ,'sp_forumbit_depth3_statusicon' ,'sp_forumbit_moderators' ,'sp_forumbit_subforums' ,'startpedie_forumbit_depth1_cat' ,'startpedie_forumbit_depth1_cat_subforum' ,'startpedie_forumbit_depth1_forum_lastpost' ,'startpedie_forumbit_depth2_cat' ,'startpedie_forumbit_depth2_forum' ,'startpedie_forumbit_depth2_forum_lastpost' ,'startpedie_forumbit_depth3' ,'startpedie_forumbit_depth3_statusicon' ,'startpedie_forumbit_moderators' ,'startpedie_forumbit_subforums' ,'me_forumbit_depth1_cat' ,'me_forumbit_depth1_cat_subforum' ,'me_forumbit_depth1_forum_lastpost' ,'me_forumbit_depth2_cat' ,'me_forumbit_depth2_forum' ,'me_forumbit_depth2_forum_lastpost' ,'me_forumbit_depth3' ,'me_forumbit_depth3_statusicon' ,'me_forumbit_moderators' ,'me_forumbit_subforums' ,'myfbconnect_login_button' ,'global_remote_profile_picture_notice' ,'mytwconnect_login_button' ,'global_usernameapproval' ,'' ,'thankyoulike_tyl_counter_forumdisplay_thread' ,'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_inline_item' ,'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_mixer_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_showteamlink' ,'footer_themeselector' ,'task_image' ,'usercp_themeselector_option' ,'php_warnings' ,'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' ,'global_modqueue' ,'global_modqueue_notice' ,'header_welcomeblock_member_buddy' ,'header_welcomeblock_member_pms' ,'header_welcomeblock_member_search' ,'header_welcomeblock_guest' ,'header_welcomeblock_guest_login_modal' ,'header_welcomeblock_guest_login_modal_lockout' ,'header_menu_calendar' ,'header_menu_memberlist' ,'global_dst_detection' ,'header_quicksearch' ,'smilie' ,'modal' ,'modal_button') AND sid IN ('-2','-1','1') ORDER BY sid ASC
  84. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  85. mybb_templates  ALL sid             1338    Using where; Using filesort
  86. Query Time: 7 ms
  87.  
  88. (Plugin Hook: global_intermediate)
  89. #13 - Select Query
  90. SELECT template FROM mybb_templates WHERE title='myfbconnect_login_button' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
  91. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  92. mybb_templates  range   sid sid 484     3   Using index condition
  93. Query Time: 504 μs
  94.  
  95. (Plugin Hook: global_intermediate)
  96. #14 - Select Query
  97. SELECT template FROM mybb_templates WHERE title='abpumap_toplink' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
  98. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  99. mybb_templates  range   sid sid 484     3   Using index condition
  100. Query Time: 405 μs
  101.  
  102. #15 - Select Query
  103. SELECT replyto FROM mybb_posts WHERE visible = 0
  104. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  105. mybb_posts  ref visible visible 1   const   1  
  106. Query Time: 323 μs
  107.  
  108. #16 - Select Query
  109. SELECT COUNT(aid) AS unapprovedattachments FROM mybb_attachments WHERE visible=0
  110. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  111. mybb_attachments    index       pid 5       6006    Using where; Using index
  112. Query Time: 3 ms
  113.  
  114. #17 - Select Query
  115. SELECT tid, name, pid, allowedgroups FROM mybb_themes WHERE pid!='0'
  116. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  117. mybb_themes ALL                 3   Using where
  118. Query Time: 627 μs
  119.  
  120. #18 - Select Query
  121. SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
  122. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  123. f   ALL                 91  Using where; Using filesort
  124. fr  eq_ref  fid fid 8   carcassonneforum.f.fid,const    1   Using where
  125. Query Time: 3 ms
  126.  
  127. #19 - Select Query
  128. SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1573848592' AND location1='5' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
  129. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  130. s   range   time,location   time    4       16  Using index condition; Using where; Using temporary; Using filesort
  131. u   eq_ref  PRIMARY PRIMARY 4   carcassonneforum.s.uid  1  
  132. Query Time: 776 μs
  133.  
  134. #20 - Select Query
  135. SELECT COUNT(tid) AS threads FROM mybb_threads WHERE fid = '5' AND visible IN (-1,0,1) AND prefix = 8
  136. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  137. mybb_threads    range   fid,xthreads_prefix fid 3       138 Using index condition; Using where
  138. Query Time: 1 ms
  139.  
  140. #21 - Select Query
  141. SELECT t.*, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='5' AND t.visible IN (-1,0,1) OR (t.fid='5' AND t.uid=1) AND t.prefix = 8 ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20
  142. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  143. t   ref fid,uid,xthreads_prefix fid 2   const   137 Using where; Using filesort
  144. u   eq_ref  PRIMARY PRIMARY 4   carcassonneforum.t.uid  1  
  145. Query Time: 1 ms
  146.  
  147. #22 - Select Query
  148. SELECT DISTINCT tid,uid FROM mybb_posts WHERE uid='1' AND tid IN (109,3567,3551,3532,3553,3527,666,3515,3498,3504,3378,3491,3485,3481,3475,3469,3396,3320,3390,3365) AND visible IN (-1,0,1)
  149. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  150. mybb_posts  range   tid,uid,visible,tid_2   tid 8       20  Using index condition; Using where; Using temporary
  151. Query Time: 1 ms
  152.  
  153. #23 - Select Query
  154. SELECT * FROM mybb_threadsread WHERE uid='1' AND tid IN (109,3567,3551,3532,3553,3527,666,3515,3498,3504,3378,3491,3485,3481,3475,3469,3396,3320,3390,3365)
  155. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  156. mybb_threadsread    range   tid tid 8       20  Using where
  157. Query Time: 561 μs
  158.  
  159. #24 - Select Query
  160. SELECT dateline FROM mybb_forumsread WHERE fid='5' AND uid='1'
  161. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  162. mybb_forumsread const   fid fid 8   const,const 1  
  163. Query Time: 287 μs
  164.  
  165. (Plugin Hook: forumdisplay_thread)
  166. #25 - Select Query
  167. SELECT uid, username, username AS userusername, avatar, avatardimensions FROM mybb_users WHERE uid IN ('1','1','97','97','97','97','97','1','97','97','97','97','97','97','417','97','97','1','92','97','97','97','417','97','97','97','856','97','97','97','97','627','417','97','97','97','627','627','97','97')
  168. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  169. mybb_users  range   PRIMARY PRIMARY 4       6   Using where
  170. Query Time: 528 μs
  171.  
  172. (Plugin Hook: forumdisplay_thread_end)
  173. #26 - Select Query
  174. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  175. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  176. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  177. Query Time: 440 μs
  178.  
  179. (Plugin Hook: forumdisplay_thread_end)
  180. #27 - Select Query
  181. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  182. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  183. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  184. Query Time: 362 μs
  185.  
  186. (Plugin Hook: forumdisplay_thread_end)
  187. #28 - Select Query
  188. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  189. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  190. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  191. Query Time: 392 μs
  192.  
  193. (Plugin Hook: forumdisplay_thread_end)
  194. #29 - Select Query
  195. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  196. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  197. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  198. Query Time: 340 μs
  199.  
  200. (Plugin Hook: forumdisplay_thread_end)
  201. #30 - Select Query
  202. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  203. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  204. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  205. Query Time: 373 μs
  206.  
  207. (Plugin Hook: forumdisplay_thread_end)
  208. #31 - Select Query
  209. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  210. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  211. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  212. Query Time: 302 μs
  213.  
  214. (Plugin Hook: forumdisplay_thread_end)
  215. #32 - Select Query
  216. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  217. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  218. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  219. Query Time: 359 μs
  220.  
  221. (Plugin Hook: forumdisplay_thread_end)
  222. #33 - Select Query
  223. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  224. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  225. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  226. Query Time: 322 μs
  227.  
  228. (Plugin Hook: forumdisplay_thread_end)
  229. #34 - Select Query
  230. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  231. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  232. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  233. Query Time: 461 μs
  234.  
  235. (Plugin Hook: forumdisplay_thread_end)
  236. #35 - Select Query
  237. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  238. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  239. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  240. Query Time: 399 μs
  241.  
  242. (Plugin Hook: forumdisplay_thread_end)
  243. #36 - Select Query
  244. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  245. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  246. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  247. Query Time: 322 μs
  248.  
  249. (Plugin Hook: forumdisplay_thread_end)
  250. #37 - Select Query
  251. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  252. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  253. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  254. Query Time: 341 μs
  255.  
  256. (Plugin Hook: forumdisplay_thread_end)
  257. #38 - Select Query
  258. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  259. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  260. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  261. Query Time: 322 μs
  262.  
  263. (Plugin Hook: forumdisplay_thread_end)
  264. #39 - Select Query
  265. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  266. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  267. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  268. Query Time: 317 μs
  269.  
  270. (Plugin Hook: forumdisplay_thread_end)
  271. #40 - Select Query
  272. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  273. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  274. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  275. Query Time: 2 ms
  276.  
  277. (Plugin Hook: forumdisplay_thread_end)
  278. #41 - Select Query
  279. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  280. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  281. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  282. Query Time: 2 ms
  283.  
  284. (Plugin Hook: forumdisplay_thread_end)
  285. #42 - Select Query
  286. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  287. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  288. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  289. Query Time: 804 μs
  290.  
  291. (Plugin Hook: forumdisplay_thread_end)
  292. #43 - Select Query
  293. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  294. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  295. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  296. Query Time: 1 ms
  297.  
  298. (Plugin Hook: forumdisplay_thread_end)
  299. #44 - Select Query
  300. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  301. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  302. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  303. Query Time: 494 μs
  304.  
  305. (Plugin Hook: forumdisplay_thread_end)
  306. #45 - Select Query
  307. SELECT tid,tyl_pnumtyls FROM mybb_posts WHERE pid IN (263,18658,18503,18347,18548,18306,3344,18218,18060,18103,17122,17973,17945,17893,17861,17804,17305,16585,17250,17024)
  308. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  309. mybb_posts  range   PRIMARY PRIMARY 4       20  Using where
  310. Query Time: 357 μs
  311.  
  312. #46 - Select Query
  313. SELECT COUNT(t.tid) AS unread_count FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forumsread fr ON (fr.fid=t.fid AND fr.uid='1') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (5) AND t.lastpost > IFNULL(tr.dateline,1559064702) AND t.lastpost > IFNULL(fr.dateline,1559064702) AND t.lastpost>1559064702
  314. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  315. t   ref fid,lastpost    fid 3   const,const 136 Using where
  316. tr  eq_ref  tid tid 8   carcassonneforum.t.tid,const    1   Using where
  317. fr  const   fid fid 8   const,const 1   Using where
  318. Query Time: 1 ms
  319.  
  320. #47 - Select Query
  321. SELECT COUNT(t.tid) AS unread_count FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forumsread fr ON (fr.fid=t.fid AND fr.uid='1') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (4) AND t.lastpost > IFNULL(tr.dateline,1559064702) AND t.lastpost > IFNULL(fr.dateline,1559064702) AND t.lastpost>1559064702
  322. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  323. t   ref fid,lastpost    fid 3   const,const 1   Using where
  324. tr  eq_ref  tid tid 8   carcassonneforum.t.tid,const    1   Using where
  325. fr  const   fid fid 8   const,const 1   Using where
  326. Query Time: 738 μs
  327.  
  328. #48 - Write Query
  329. DELETE TTR.* FROM mybb_threadsread AS TTR INNER JOIN mybb_threads AS TT ON TT.tid = TTR.tid WHERE TTR.uid = '1' AND TT.fid IN (4,5)
  330. Query Time: 2 ms
  331.  
  332. #49 - Select Query
  333. SELECT fid FROM mybb_forumsubscriptions WHERE fid='5' AND uid='1' LIMIT 1
  334. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  335. mybb_forumsubscriptions ref uid uid 4   const   1   Using where
  336. Query Time: 625 μs
  337.  
  338. (Plugin Hook: pre_output_page)
  339. #50 - Select Query
  340. SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (1,97,417,92,856,627)
  341. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  342. mybb_users  range   PRIMARY PRIMARY 4       6   Using where
  343. Query Time: 551 μs
  344.  
  345. (Plugin Hook: pre_output_page)
  346. #51 - Select Query
  347. SELECT template FROM mybb_templates WHERE title='usercp_themeselector' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
  348. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  349. mybb_templates  range   sid sid 484     3   Using index condition
  350. Query Time: 524 μs
  351.  
  352. (Plugin Hook: pre_output_page)
  353. #52 - Select Query
  354. SELECT 1 FROM mybb_posts p INNER JOIN mybb_threads t ON (p.tid = t.tid) LEFT JOIN mybb_threadsread tr ON (tr.uid = 1 AND t.tid = tr.tid) LEFT JOIN mybb_forumsread fr ON (fr.uid = 1 AND t.fid = fr.fid) WHERE p.visible = 1 AND t.visible = 1 AND t.fid NOT IN (35,31,32,21) AND t.fid NOT IN ('15','36',36) AND p.dateline > IFNULL(tr.dateline,1559064702) AND p.dateline > IFNULL(fr.dateline,1559064702) AND p.dateline > 1559064702 LIMIT 501
  355. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  356. p   range   tid,visible,dateline,tid_2  dateline    4       902 Using index condition; Using where
  357. t   eq_ref  PRIMARY,fid PRIMARY 4   carcassonneforum.p.tid  1   Using where
  358. tr  eq_ref  tid tid 8   carcassonneforum.p.tid,const    1   Using where
  359. fr  eq_ref  fid fid 8   carcassonneforum.t.fid,const    1   Using where
  360. Query Time: 11 ms
  361.  
  362. (Plugin Hook: pre_output_page)
  363. #53 - Select Query
  364. SELECT template FROM mybb_templates WHERE title='codebuttons' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
  365. Table   Type    Possible Keys   Key Key Length  Ref Rows    Extra
  366. mybb_templates  range   sid sid 484     3   Using index condition
  367. Query Time: 447 μs
  368.  
  369. Template Statistics
  370. Templates Used (Loaded for this Page) - 191 Total
  371. smilie, bam_announcement_container, forumdisplay_threadlist_prefixes_prefix, forumdisplay_threadlist, forumdisplay_threadlist_sortrating, forumdisplay_subforums, global_awaiting_activation, global_boardclosed_warning, forumdisplay_threadlist_rating, header_menu_calendar, global_pm_alert, forumdisplay_thread, header_menu_memberlist, forumdisplay_orderarrow, header_menu_portal, mycode_code, header_menu_search, mycode_email, header_quicksearch, mycode_img, mycode_php, mycode_quote_post, mycode_size_int, mycode_url, forumdisplay_announcements_announcement_modbit, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost, error_inline_item, footer_showteamlink, header_welcomeblock_member, video_mixer_embed, forumdisplay_threadlist_subscription, header_welcomeblock_member_moderator, global_modqueue, smilieinsert_row, global_modqueue_notice, smilieinsert_row_empty, modal, modal_button, forumjump_advanced, forumdisplay_searchforum, forumdisplay_nothreads, header_welcomeblock_member_admin, forumdisplay_newthread, forumdisplay_inlinemoderation_custom, forumdisplay_inlinemoderation_custom_tool, forumdisplay_inlinemoderation, forumdisplay_inlinemoderation_selectall, redirect, gobutton, forumbit_moderators, forumdisplay_thread_rating, forumdisplay_announcement_rating, forumdisplay_password, video_metacafe_embed, forumbit_depth2_forum, smilieinsert_getmore, video_dailymotion_embed, forumbit_depth3, video_myspacetv_embed, forumbit_depth3_statusicon, video_youtube_embed, forumbit_subforums, video_vimeo_embed, video_yahoo_embed, newthreadmarker_mark, newthreadmarker_searchlink, footer, asb_begin, asb_end, forumdisplay_thread_multipage, asb_sidebox_column, forumdisplay_thread_multipage_page, asb_wrapped_sidebox, forumdisplay_thread_multipage_more, asb_toggle_icon, forumdisplay_rules, asb_content_pad, forumdisplay_rules_link, asb_expander, forumdisplay, forumdisplay_usersbrowsing_user, forumdisplay_usersbrowsing, header_welcomeblock_member_buddy, multipage_jump_page, nav_dropdown, headerinclude, thankyoulike_tyl_counter_forumdisplay_thread, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumdisplay_inlinemoderation_col, error_nopermission, error_nopermission_loggedin, forumjump_bit, forumjump_special, myalerts_headericon, myalerts_alert_row_no_alerts, smilieinsert, myalerts_js_popup, forumbit_depth1_cat, error, forumdisplay_moderatedby, forumbit_depth2_cat, header_welcomeblock_guest_login_modal, header_welcomeblock_guest_login_modal_lockout, forumdisplay_password_wrongpass, nav, nav_bit, nav_bit_active, forumdisplay_thread_deleted, global_remote_avatar_notice, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_user, forumdisplay_thread_modbit, forumdisplay_thread_gotounread, forumdisplay_nopermission, smilieinsert_smilie, error_inline, global_board_offline_modal, global_bannedwarning, htmldoctype, forumdisplay_thread_attachment_count, forumdisplay_announcements_announcement, forumdisplay_rssdiscovery, forumdisplay_announcements, forumdisplay_sticky_sep, forumdisplay_threads_sep, forumdisplay_threadlist_clearpass, php_warnings, mentionme_popup, footer_languageselect, mytwconnect_login_button, usercp_themeselector_option, global_unreadreports, footer_contactus, global_pending_joinrequests, footer_languageselect_option, video_facebook_embed, footer_themeselect, video_liveleak_embed, footer_themeselector, forumbit_depth2_forum_lastpost_hidden, forumbit_depth2_forum_lastpost_never, forumbit_depth2_forum_unapproved_posts, forumbit_depth2_forum_unapproved_threads, global_boardclosed_reason, forumbit_depth2_forum_viewers, debug_summary, global_dst_detection, forumbit_moderators_group, global_no_permission_modal, forumbit_moderators_user, multipage_breadcrumb, forumdisplay_inlinemoderation_approveunapprove, task_image, multipage, forumdisplay_inlinemoderation_delete, multipage_end, forumdisplay_inlinemoderation_manage, multipage_nextpage, forumdisplay_inlinemoderation_openclose, multipage_page, forumdisplay_inlinemoderation_restore, multipage_page_current, forumdisplay_inlinemoderation_softdelete, multipage_page_link_current, forumdisplay_inlinemoderation_standard, multipage_prevpage, forumdisplay_inlinemoderation_stickunstick, multipage_start, forumdisplay_thread_icon, forumdisplay_thread_rating_moved, forumdisplay_thread_unapproved_posts, forumdisplay_threadlist_prefixes, forumdisplay_inlinemoderation_applyprefix, unreadPosts_link, unreadPosts_linkCounter, unreadPosts_noData, unreadPosts_counter, global_remote_profile_picture_notice, aamessage, gotofull_reply, returntotop, global_usernameapproval, myfbconnect_login_button, abpumap_toplink, usercp_themeselector, codebuttons
  372.  
  373. Templates Requiring Additional Calls (Not Cached at Startup) - 6 Total
  374. smilie, bam_announcement_container, myfbconnect_login_button, abpumap_toplink, usercp_themeselector, codebuttons
RAW Paste Data
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
 
Top