SQL Report
Page generated in 0.0904 seconds with 25 queries + 7 queries returning data from cache
Time spent on mysqli queries: 0.01739s | Time spent on PHP: 0.07301s
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.00498s | After: 0.00507s | Elapsed: 0.00009s
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.01023s | After: 0.01051s | Elapsed: 0.00028s
Query results obtained from the cache |
---|
|
Before: 0.01081s | After: 0.01115s | Elapsed [cache]: 0.00034s | Elapsed [db]: 0.00016s
Before: 0.01167s | After: 0.01227s | Elapsed: 0.00061s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_sessions | ALL | session_time,session_user_id | | | | 1290 | Using where |
Before: 0.01252s | After: 0.01303s | Elapsed: 0.00051s
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.01326s | After: 0.01611s | Elapsed: 0.00285s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
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.01702s | After: 0.01734s | Elapsed: 0.00031s
Query results obtained from the cache |
---|
|
Before: 0.01895s | After: 0.01918s | Elapsed [cache]: 0.00023s | Elapsed [db]: 0.00008s
Query results obtained from the cache |
---|
|
Before: 0.04320s | After: 0.04358s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00030s
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 | 3558 | Using where; Using index |
Before: 0.04513s | After: 0.04564s | Elapsed: 0.00051s
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.05472s | After: 0.06218s | Elapsed: 0.00746s
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.06340s | After: 0.06357s | Elapsed: 0.00017s
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.06386s | After: 0.06394s | Elapsed: 0.00008s
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.06422s | After: 0.06430s | Elapsed: 0.00008s
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.06467s | After: 0.06478s | Elapsed: 0.00011s
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.06514s | After: 0.06520s | Elapsed: 0.00005s
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.06544s | After: 0.06551s | Elapsed: 0.00007s
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.06572s | After: 0.06579s | Elapsed: 0.00007s
Query results obtained from the cache |
---|
|
Before: 0.06617s | After: 0.06642s | Elapsed [cache]: 0.00024s | Elapsed [db]: 0.00011s
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.07434s | After: 0.07521s | Elapsed: 0.00087s
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.07654s | After: 0.07686s | Elapsed: 0.00032s
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.07738s | After: 0.07892s | Elapsed: 0.00154s
Query results obtained from the cache |
---|
|
Before: 0.08282s | After: 0.08313s | Elapsed [cache]: 0.00032s | Elapsed [db]: 0.00013s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | s | ref | session_time,session_user_id,session_fid | session_fid | 3 | const | 1 | Using where |
Before: 0.08402s | After: 0.08443s | Elapsed: 0.00041s
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 | 1 (0%) | Using where; Using rowid filter |
Before: 0.08467s | After: 0.08490s | Elapsed: 0.00023s
Query results obtained from the cache |
---|
|
Before: 0.08539s | After: 0.08578s | Elapsed [cache]: 0.00039s | Elapsed [db]: 0.00017s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_colors | ALL | | | | | 5 | |
Before: 0.08703s | After: 0.08711s | 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.08738s | After: 0.08750s | Elapsed: 0.00012s
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.08774s | After: 0.08786s | Elapsed: 0.00011s
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.08813s | After: 0.08848s | Elapsed: 0.00035s
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.08882s | After: 0.08893s | Elapsed: 0.00011s
Query results obtained from the cache |
---|
|
Before: 0.08936s | After: 0.08974s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00013s