SQL Report
Page generated in 0.203 seconds with 26 queries + 7 queries returning data from cache
Time spent on mysqli queries: 0.05503s | Time spent on PHP: 0.14796s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_config | ref | is_dynamic | is_dynamic | 1 | const | 25 | |
Before: 0.00412s | After: 0.00424s | Elapsed: 0.00012s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_users | const | PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id | PRIMARY | 4 | const | 1 | |
Before: 0.00711s | After: 0.00737s | Elapsed: 0.00026s
Query results obtained from the cache |
---|
|
Before: 0.00767s | After: 0.00802s | Elapsed [cache]: 0.00035s | Elapsed [db]: 0.00015s
Before: 0.00850s | After: 0.02268s | Elapsed: 0.01418s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_sessions | range | session_time,session_user_id | session_time | 4 | | 1537 | Using index condition; Using where |
Before: 0.02345s | After: 0.02909s | Elapsed: 0.00564s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_users | const | PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id | PRIMARY | 4 | const | 1 | |
Affected rows: 1 | Before: 0.02951s | After: 0.03010s | Elapsed: 0.00059s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | p | const | PRIMARY,topic_id,tid_post_time,idx_bb_posts_post_id_topic_id_time,idx_bb_posts_topic_visibility_time_id,idx_posts_topic_id,idx_posts_post_id,idx_posts_topic_time,idx_posts_topic_visibility,idx_posts_id_topic,idx_topic_id_post_time,idx_posts_post_id_visibility_topic_id,idx_bb_posts_topic_id_post_id,bb_posts_topic_id_forum_id | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | t | const | PRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topics,idx_bb_topics_forum_id_last_post_time_id,idx_bb_topics_topic_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_topic_id,idx_topics_forum_lastpost,idx_topics_forum,idx_topics_moved_time,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id,bb_topics_forum_id_topic_id | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | f | const | PRIMARY,idx_bb_forums_forum_id,idx_bb_forums_forum_id_password_flags_type,idx_bb_forums_forum_id_password,idx_bb_forums_forum_id_type,bb_forums_forum_id | PRIMARY | 3 | const | 1 | |
Before: 0.03681s | After: 0.03745s | Elapsed: 0.00065s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | p | range | PRIMARY,topic_id,tid_post_time,post_visibility,idx_bb_posts_post_id_topic_id_time,idx_bb_posts_topic_visibility_time_id,idx_posts_topic_id,idx_posts_post_id,idx_posts_topic_time,idx_posts_topic_visibility,idx_posts_id_topic,idx_posts_time,idx_topic_id_post_time,idx_posts_post_id_visibility_topic_id,idx_bb_posts_topic_id_post_id,idx_bb_posts_post_time_forum_id,bb_posts_topic_id_forum_id | idx_posts_topic_visibility | 13 | | 304 | Using where; Using index |
Before: 0.11466s | After: 0.11557s | Elapsed: 0.00091s
Query results obtained from the cache |
---|
|
Before: 0.11714s | After: 0.11740s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00010s
Query results obtained from the cache |
---|
|
Before: 0.14073s | After: 0.14096s | Elapsed [cache]: 0.00023s | Elapsed [db]: 0.00031s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | p | ref | topic_id,tid_post_time,post_visibility,idx_bb_posts_topic_visibility_time_id,idx_posts_topic_id,idx_posts_topic_time,idx_posts_topic_visibility,idx_topic_id_post_time,idx_bb_posts_topic_id_post_id,bb_posts_topic_id_forum_id | idx_posts_topic_visibility | 5 | const,const | 992 | Using where; Using index |
Before: 0.15056s | After: 0.15112s | Elapsed: 0.00056s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | p | range | PRIMARY,poster_id,idx_bb_posts_post_id_topic_id_time,idx_posts_post_id,idx_posts_id_topic,idx_poster_id,idx_posts_post_id_visibility_topic_id,bb_posts_poster_id | idx_posts_post_id | 4 | | 10 | Using index condition |
1 | SIMPLE | u | eq_ref | PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id | PRIMARY | 4 | orthohin_minorhockeytalks.p.poster_id | 1 | |
1 | SIMPLE | z | eq_ref | PRIMARY,idx_user_id_zebra_id,bb_zebra_user_id | PRIMARY | 8 | const,orthohin_minorhockeytalks.p.poster_id | 1 | |
Before: 0.15197s | After: 0.16574s | Elapsed: 0.01378s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_lang | ref | lang_iso | lang_iso | 92 | const | 1 | Using where; Using index |
Before: 0.16659s | After: 0.16667s | Elapsed: 0.00007s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | | | | 10 | Using where; Using filesort |
1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 6 | orthohin_minorhockeytalks.f.field_id,const | 1 | |
Before: 0.16690s | After: 0.16699s | Elapsed: 0.00009s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | ao | const | PRIMARY,auth_option | auth_option | 152 | const | 1 | Using index |
1 | SIMPLE | a | ref | user_id,auth_option_id,auth_role_id | auth_option_id | 3 | const | 1 | Using where |
Before: 0.16728s | After: 0.16742s | Elapsed: 0.00013s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | ao | const | PRIMARY,auth_option | auth_option | 152 | const | 1 | Using index |
1 | SIMPLE | a | ref | user_id,auth_role_id | user_id | 4 | const | 1 | |
1 | SIMPLE | r | eq_ref | PRIMARY,ath_op_id | PRIMARY | 6 | orthohin_minorhockeytalks.a.auth_role_id,const | 1 | |
Before: 0.16766s | After: 0.16775s | Elapsed: 0.00009s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | ao | const | PRIMARY,auth_option | auth_option | 152 | const | 1 | Using index |
1 | SIMPLE | a | ref | group_id,auth_opt_id,auth_role_id | auth_opt_id | 3 | const | 1 | Using where |
1 | SIMPLE | ug | ref | group_id,user_id,group_leader,idx_usergroup_user_pending | idx_usergroup_user_pending | 8 | const,orthohin_minorhockeytalks.a.group_id,const | 1 | |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 3 | orthohin_minorhockeytalks.a.group_id | 1 | Using where |
Before: 0.16811s | After: 0.16818s | Elapsed: 0.00007s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | ao | const | PRIMARY,auth_option | auth_option | 152 | const | 1 | Using index |
1 | SIMPLE | ug | ref | group_id,user_id,group_leader,idx_usergroup_user_pending | user_id | 4 | const | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 3 | orthohin_minorhockeytalks.ug.group_id | 1 | Using where |
1 | SIMPLE | a | ref | group_id,auth_role_id | group_id | 3 | orthohin_minorhockeytalks.ug.group_id | 49 | |
1 | SIMPLE | r | eq_ref | PRIMARY,ath_op_id | PRIMARY | 6 | orthohin_minorhockeytalks.a.auth_role_id,const | 1 | |
Before: 0.16850s | After: 0.16860s | Elapsed: 0.00010s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_banlist | range | ban_end,ban_user,idx_banlist_user_exclude | ban_user | 5 | | 2 | Using index condition; Using where |
Before: 0.16891s | After: 0.16900s | Elapsed: 0.00008s
Query results obtained from the cache |
---|
|
Before: 0.16930s | After: 0.16955s | Elapsed [cache]: 0.00025s | Elapsed [db]: 0.00009s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_topics | const | PRIMARY,idx_bb_topics_topic_id,idx_topics_topic_id,idx_topics_forum,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id | PRIMARY | 4 | const | 1 | |
Affected rows: 1 | Before: 0.17578s | After: 0.17658s | Elapsed: 0.00080s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | f | index | | idx_bb_forums_forum_id_password | 770 | | 41 | Using where; Using index |
1 | SIMPLE | fa | range | PRIMARY,idx_bb_forums_access_forum_id_session_id,idx_bb_forums_access_session_id_forum_id | idx_bb_forums_access_session_id_forum_id | 96 | | 1 | Using where; Using index; Using join buffer (flat, BNL join) |
Before: 0.17753s | After: 0.17776s | Elapsed: 0.00023s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | t | fulltext | PRIMARY,forum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_last,latest_topics,idx_bb_topics_forum_id_last_post_time_id,idx_bb_topics_topic_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_topic_id,idx_topics_forum_lastpost,idx_topics_forum,idx_topics_moved_time,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id,bb_topics_forum_id_topic_id,topic_title | topic_title | | | 1 | Using where |
1 | SIMPLE | f | eq_ref | PRIMARY,idx_bb_forums_forum_id,idx_bb_forums_forum_id_password_flags_type,idx_bb_forums_forum_id_password,idx_bb_forums_forum_id_type,bb_forums_forum_id | PRIMARY | 3 | orthohin_minorhockeytalks.t.forum_id | 1 | Using where |
Before: 0.17813s | After: 0.19371s | Elapsed: 0.01558s
Query results obtained from the cache |
---|
|
Before: 0.19705s | After: 0.19734s | Elapsed [cache]: 0.00029s | Elapsed [db]: 0.00012s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | s | ref|filter | session_time,session_user_id,session_fid | session_fid|session_time | 3|4 | const | 94 (0%) | Using where; Using rowid filter |
Before: 0.19847s | After: 0.19895s | Elapsed: 0.00049s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | s | ref|filter | session_time,session_user_id,session_fid | session_fid|session_user_id | 3|4 | const | 94 (0%) | Using where; Using rowid filter |
Before: 0.19924s | After: 0.19950s | Elapsed: 0.00026s
Query results obtained from the cache |
---|
|
Before: 0.19978s | After: 0.20005s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00008s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_colors | ALL | | | | | 5 | |
Before: 0.20099s | After: 0.20107s | Elapsed: 0.00008s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_buttons | ALL | | | | | 11 | Using where; Using filesort |
Before: 0.20134s | After: 0.20142s | Elapsed: 0.00009s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_buttons | ALL | | | | | 11 | Using where; Using filesort |
Before: 0.20162s | After: 0.20167s | Elapsed: 0.00005s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_buttons | ALL | | | | | 11 | Using where; Using filesort |
Before: 0.20180s | After: 0.20185s | Elapsed: 0.00005s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_buttons | ALL | | | | | 11 | Using where; Using filesort |
Before: 0.20204s | After: 0.20213s | Elapsed: 0.00009s
Query results obtained from the cache |
---|
|
Before: 0.20237s | After: 0.20263s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00008s