Page Generation Statistics | |||
Page Generation Time: | 46 ms | No. DB Queries: | 31 |
PHP Processing Time: | 31 ms (68.86%) | DB Processing Time: | 14 ms (31.14%) |
Extensions Used: | mysqli, xml | Global.php Processing Time: | 25 ms |
PHP Version: | 7.1.33 | Server Load: | 0.15 |
GZip Encoding Status: | Enabled | No. Templates Used: | 210 (211 Cached / 1 Manually Loaded) |
Memory Usage: | 2 MB (2097152 bytes) | Memory Limit: | 128M |
[READ] us_db_agexpl@localhost (Connected in 284 μs) |
#1 - Select Query |
|||||||
SELECT title,cache FROM mybb_datacache | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_datacache | ALL | 40 | |||||
Query Time: 361 μs |
#2 - Select Query |
|||||||
SELECT uid FROM mybb_users WHERE username = 'test' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
Impossible WHERE noticed after reading const tables | |||||||
Query Time: 89 μs |
#3 - Select Query |
|||||||
SELECT * FROM mybb_threads WHERE tid = '203' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_threads | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Query Time: 138 μs |
#4 - Write Query |
DELETE FROM mybb_sessions WHERE ip=X'03ead671' |
Query Time: 153 μs |
#5 - Write Query |
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='97f2a83f663d595887aad58ac40f1d03',`time`=1575675055,`ip`=X'03ead671',`location`='/showthread.php?tid=203&debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=34,`location2`=203,`nopermission`=0 |
Query Time: 80 μs |
(Plugin Hook: global_start) #6 - Select Query |
|||||||
SELECT VERSION() as version | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
No tables used | |||||||
Query Time: 60 μs |
(Plugin Hook: global_start) #7 - Write Query |
SHOW FULL TABLES FROM `db_agexpl` WHERE table_type = 'BASE TABLE' AND `Tables_in_db_agexpl` = 'mybb_alerts' |
Query Time: 441 μs |
#8 - Select Query |
|||||||
SELECT fid FROM mybb_threads WHERE tid = '203' LIMIT 1 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_threads | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Query Time: 93 μs |
#9 - Select Query |
|||||||
SELECT name FROM mybb_themestylesheets WHERE sid=330 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_themestylesheets | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Query Time: 98 μs |
#10 - Select Query |
|||||||
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'showthread' ,'postbit' ,'postbit_author_user' ,'postbit_author_guest' ,'showthread_newthread' ,'showthread_newreply' ,'showthread_newreply_closed' ,'postbit_avatar' ,'postbit_find' ,'postbit_pm' ,'postbit_www' ,'postbit_email' ,'postbit_edit' ,'postbit_quote' ,'postbit_report' ,'multipage' ,'multipage_breadcrumb' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'showthread_inlinemoderation_softdelete' ,'showthread_poll_editpoll' ,'postbit_editedby' ,'showthread_similarthreads' ,'showthread_similarthreads_bit' ,'postbit_iplogged_show' ,'postbit_iplogged_hiden' ,'postbit_profilefield' ,'showthread_quickreply' ,'showthread_add_poll' ,'showthread_send_thread' ,'showthread_inlinemoderation_restore' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'postbit_attachments' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images_image' ,'postbit_attachments_images' ,'showthread_quickreply_options_stick' ,'postbit_status' ,'postbit_inlinecheck' ,'showthread_inlinemoderation' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_ignored' ,'postbit_multiquote' ,'showthread_moderationoptions_custom_tool' ,'showthread_moderationoptions_custom' ,'showthread_inlinemoderation_custom_tool' ,'showthread_usersbrowsing' ,'showthread_usersbrowsing_user' ,'showthread_poll_option' ,'showthread_poll' ,'showthread_quickreply_options_signature' ,'showthread_threaded_bitactive' ,'showthread_threaded_bit' ,'postbit_attachments_attachment_unapproved' ,'showthread_moderationoptions_openclose' ,'showthread_moderationoptions_stickunstick' ,'showthread_moderationoptions_delete' ,'showthread_moderationoptions_threadnotes' ,'showthread_moderationoptions_manage' ,'showthread_moderationoptions_deletepoll' ,'postbit_userstar' ,'postbit_reputation_formatted_link' ,'postbit_warninglevel_formatted' ,'postbit_quickrestore' ,'forumdisplay_password' ,'forumdisplay_password_wrongpass' ,'postbit_purgespammer' ,'showthread_inlinemoderation_approve' ,'forumdisplay_thread_icon' ,'showthread_moderationoptions_softdelete' ,'showthread_moderationoptions_restore' ,'post_captcha' ,'post_captcha_recaptcha_invisible' ,'post_captcha_nocaptcha' ,'showthread_moderationoptions' ,'showthread_inlinemoderation_standard' ,'showthread_inlinemoderation_manage' ,'showthread_ratethread' ,'postbit_posturl' ,'postbit_icon' ,'postbit_editedby_editreason' ,'attachment_icon' ,'global_moderation_notice' ,'showthread_poll_option_multiple' ,'postbit_gotopost' ,'postbit_rep_button' ,'postbit_warninglevel' ,'showthread_threadnoteslink' ,'showthread_moderationoptions_approve' ,'showthread_moderationoptions_unapprove' ,'showthread_inlinemoderation_delete' ,'showthread_moderationoptions_standard' ,'showthread_quickreply_options_close' ,'showthread_inlinemoderation_custom' ,'showthread_search' ,'postbit_profilefield_multiselect_value' ,'postbit_profilefield_multiselect' ,'showthread_subscription' ,'postbit_deleted_member' ,'postbit_away' ,'postbit_warn' ,'postbit_classic' ,'postbit_reputation' ,'postbit_deleted' ,'postbit_offline' ,'postbit_online' ,'postbit_signature' ,'postbit_editreason' ,'postbit_quickdelete' ,'showthread_threadnotes_viewnotes' ,'showthread_threadedbox' ,'showthread_poll_resultbit' ,'showthread_poll_results' ,'showthread_threadnotes' ,'showthread_classic_header' ,'showthread_poll_undovote' ,'postbit_groupimage' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'thankyoulike_users' ,'thankyoulike_postbit_author_user' ,'thankyoulike_postbit' ,'thankyoulike_postbit_classic' ,'thankyoulike_expcollapse' ,'thankyoulike_button_add' ,'thankyoulike_button_del' ,'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_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' ,'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') AND sid IN ('-2','-1','20') ORDER BY sid ASC | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_templates | ALL | sid | 2382 | Using where; Using filesort | |||
Query Time: 9 ms |
#11 - Select Query |
|||||||
SELECT tid, name, pid, allowedgroups FROM mybb_themes WHERE pid!='0' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_themes | ALL | 6 | Using where | ||||
Query Time: 125 μs |
#12 - Select Query |
|||||||
SELECT threads, unapprovedthreads, deletedthreads FROM mybb_forums WHERE fid = '34' LIMIT 1 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_forums | const | PRIMARY | PRIMARY | 2 | const | 1 | |
Query Time: 92 μs |
#13 - Select Query |
|||||||
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '34' AND (lastpost >= '1479223558' OR sticky=1) AND visible=1 ORDER BY lastpost DESC | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_threads | ref | fid,lastpost | fid | 3 | const,const | 20 | Using where |
Query Time: 225 μs |
#14 - Select Query |
|||||||
SELECT lastpost, tid, fid FROM mybb_threads WHERE visible=1 AND closed NOT LIKE 'moved|%' AND fid IN (34) AND lastpost > '1575070255' LIMIT 100 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_threads | range | fid,lastpost | lastpost | 4 | 11 | Using index condition; Using where | |
Query Time: 131 μs |
#15 - Select Query |
|||||||
SELECT uid FROM mybb_threadratings WHERE tid='203' AND uid='0' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_threadratings | ref | tid | tid | 8 | const,const | 1 | Using index |
Query Time: 69 μs |
#16 - Select Query |
|||||||
SELECT p.pid FROM mybb_posts p WHERE p.tid='203' AND p.visible='1' ORDER BY p.dateline LIMIT 0, 10 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
p | ref | tid,visible,tiddate | tiddate | 4 | const | 21 | Using where |
Query Time: 156 μs |
#17 - Select Query |
|||||||
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername FROM mybb_posts p LEFT JOIN mybb_users u ON (u.uid=p.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_users eu ON (eu.uid=p.edituid) WHERE pid IN('10667','11129','11133','11134','11135','11136','11137','11138','11139','11140') ORDER BY p.dateline | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
p | range | PRIMARY | PRIMARY | 4 | 10 | Using index condition; Using filesort | |
u | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.p.uid | 1 | |
f | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.u.uid | 1 | Using where |
eu | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.p.edituid | 1 | |
Query Time: 456 μs |
(Plugin Hook: postbit) #18 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='10667' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 106 μs |
(Plugin Hook: postbit) #19 - Select Query |
|||||||
SELECT u.username, u.usergroup, u.displaygroup, tyl.* FROM mybb_g33k_thankyoulike_thankyoulike tyl LEFT JOIN mybb_users u ON (u.uid=tyl.uid) WHERE tyl.pid IN('10667','11129','11133','11134','11135','11136','11137','11138','11139','11140') ORDER BY username ASC | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
tyl | range | pid | pid | 4 | 10 | Using index condition; Using temporary; Using filesort | |
u | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.tyl.uid | 1 | |
Query Time: 166 μs |
(Plugin Hook: postbit) #20 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11129' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 113 μs |
(Plugin Hook: postbit) #21 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11133' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 113 μs |
(Plugin Hook: postbit) #22 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11134' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 114 μs |
(Plugin Hook: postbit) #23 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11135' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 95 μs |
(Plugin Hook: postbit) #24 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11136' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 90 μs |
(Plugin Hook: postbit) #25 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11137' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 91 μs |
(Plugin Hook: postbit) #26 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11138' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 88 μs |
(Plugin Hook: postbit) #27 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11139' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 89 μs |
(Plugin Hook: postbit) #28 - Select Query |
|||||||
SELECT * FROM mybb_warnings WHERE `pid`='11140' | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_warnings | ALL | 48 | Using where | ||||
Query Time: 88 μs |
#29 - Select Query |
|||||||
SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Patch 1.19 w open becie') AS relevance FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='34' AND t.tid!='203' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Patch 1.19 w open becie') >= '1' ORDER BY t.lastpost DESC LIMIT 0, 10 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
t | fulltext | PRIMARY,fid,subject | subject | 0 | 1 | Using where; Using filesort | |
u | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.t.uid | 1 | |
Query Time: 246 μs |
#30 - Select Query |
|||||||
SELECT template FROM mybb_templates WHERE title='showthread_printthread' AND sid IN ('-2','-1','20') ORDER BY sid DESC LIMIT 1 | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
mybb_templates | range | sid | sid | 364 | 4 | Using where | |
Query Time: 194 μs |
#31 - Select Query |
|||||||
SELECT s.ip, s.uid, s.time, 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 > '1575674155' AND location2='203' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC | |||||||
Table | Type | Possible Keys | Key | Key Length | Ref | Rows | Extra |
s | range | time | time | 4 | 23 | Using index condition; Using where; Using temporary; Using filesort | |
u | eq_ref | PRIMARY | PRIMARY | 4 | db_agexpl.s.uid | 1 | |
Query Time: 283 μs |
Templates Used (Loaded for this Page) - 210 Total |
error_inline_item, error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, forumdisplay_password, forumdisplay_password_wrongpass, forumdisplay_thread_icon, forumjump_advanced, forumjump_bit, forumjump_special, global_bannedwarning, global_boardclosed_warning, global_pending_joinrequests, global_pm_alert, global_unreadreports, global_moderation_notice, global_awaiting_activation, header, header_menu_calendar, header_menu_memberlist, header_menu_portal, header_menu_search, header_quicksearch, header_welcomeblock_guest, header_welcomeblock_guest_login_modal, header_welcomeblock_member, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, multipage, multipage_breadcrumb, multipage_end, multipage_jump_page, multipage_nextpage, multipage_page, multipage_page_current, multipage_page_link_current, multipage_prevpage, multipage_start, nav, nav_bit, nav_bit_active, nav_dropdown, nav_sep, nav_sep_active, php_warnings, post_captcha, post_captcha_nocaptcha, postbit, postbit_attachments, postbit_attachments_attachment, postbit_attachments_attachment_unapproved, postbit_attachments_images, postbit_attachments_images_image, postbit_attachments_thumbnails, postbit_attachments_thumbnails_thumbnail, postbit_author_guest, postbit_author_user, postbit_avatar, postbit_away, postbit_classic, postbit_edit, postbit_editedby, postbit_editedby_editreason, postbit_email, postbit_find, postbit_purgespammer, postbit_gotopost, postbit_groupimage, postbit_icon, postbit_ignored, postbit_inlinecheck, postbit_iplogged_hiden, postbit_iplogged_show, postbit_multiquote, postbit_offline, postbit_online, postbit_pm, postbit_posturl, postbit_profilefield, postbit_profilefield_multiselect, postbit_profilefield_multiselect_value, postbit_quickdelete, postbit_quickrestore, postbit_quote, postbit_rep_button, postbit_report, postbit_reputation, postbit_reputation_formatted_link, postbit_signature, postbit_userstar, postbit_warn, postbit_warninglevel, postbit_warninglevel_formatted, postbit_www, showthread, showthread_add_poll, showthread_classic_header, showthread_inlinemoderation, showthread_inlinemoderation_approve, showthread_inlinemoderation_custom, showthread_inlinemoderation_custom_tool, showthread_inlinemoderation_delete, showthread_inlinemoderation_manage, showthread_inlinemoderation_restore, showthread_inlinemoderation_standard, showthread_inlinemoderation_softdelete, showthread_moderationoptions, showthread_moderationoptions_custom, showthread_moderationoptions_custom_tool, showthread_moderationoptions_delete, showthread_moderationoptions_deletepoll, showthread_moderationoptions_manage, showthread_moderationoptions_openclose, showthread_moderationoptions_restore, showthread_moderationoptions_softdelete, showthread_moderationoptions_standard, showthread_moderationoptions_stickunstick, showthread_moderationoptions_threadnotes, showthread_newreply, showthread_newreply_closed, showthread_newthread, showthread_poll, showthread_poll_editpoll, showthread_poll_option, showthread_poll_option_multiple, showthread_poll_resultbit, showthread_poll_results, showthread_poll_undovote, showthread_quickreply, showthread_quickreply_options_close, showthread_quickreply_options_signature, showthread_quickreply_options_stick, showthread_ratethread, showthread_search, showthread_send_thread, showthread_similarthreads, showthread_similarthreads_bit, showthread_threaded_bit, showthread_threaded_bitactive, showthread_threadedbox, showthread_threadnotes, showthread_threadnotes_viewnotes, showthread_threadnoteslink, showthread_usersbrowsing, showthread_usersbrowsing_user, smilieinsert, smilieinsert_getmore, smilieinsert_smilie, usercp_themeselector_option, video_metacafe_embed, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_myspacetv_embed, video_youtube_embed, video_vimeo_embed, video_yahoo_embed, attachment_icon, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, global_board_offline_modal, showthread_moderationoptions_unapprove, smilieinsert_row, smilieinsert_row_empty, showthread_moderationoptions_approve, mycode_size_int, mycode_url, mycode_quote_post, mycode_php, mycode_img, mycode_code, mycode_email, global_boardclosed_reason, global_dst_detection, global_no_permission_modal, thankyoulike_users, thankyoulike_postbit, global_remote_avatar_notice, header_welcomeblock_member_user, post_captcha_recaptcha_invisible, postbit_deleted, postbit_deleted_member, postbit_editreason, postbit_status, showthread_subscription, thankyoulike_expcollapse, header_welcomeblock_guest_login_modal_lockout, myalerts_js_popup, myalerts_alert_row_no_alerts, myalerts_headericon, thankyoulike_postbit_author_user, video_mixer_embed, thankyoulike_postbit_classic, thankyoulike_button_del, thankyoulike_button_add, showthread_printthread |
Templates Requiring Additional Calls (Not Cached at Startup) - 1 Total |
showthread_printthread |