SQL Report
Page generated in 0.0942 seconds with 25 queries + 6 queries returning data from cache
Time spent on mysqli queries: 0.03145s | Time spent on PHP: 0.06277s
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.00487s | After: 0.00497s | Elapsed: 0.00010s
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.00930s | After: 0.00941s | Elapsed: 0.00011s
Query results obtained from the cache |
---|
|
Before: 0.00968s | After: 0.01013s | Elapsed [cache]: 0.00045s | Elapsed [db]: 0.00013s
Before: 0.01232s | After: 0.01420s | Elapsed: 0.00188s
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 | | 2014 | Using index condition; Using where |
Before: 0.01448s | After: 0.02092s | Elapsed: 0.00644s
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.02113s | After: 0.02129s | Elapsed: 0.00016s
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.02217s | After: 0.02245s | Elapsed: 0.00028s
Query results obtained from the cache |
---|
|
Before: 0.02397s | After: 0.02416s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00004s
Query results obtained from the cache |
---|
|
Before: 0.04759s | After: 0.04780s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00026s
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 | 184 | Using where; Using index |
Before: 0.05156s | After: 0.05184s | Elapsed: 0.00028s
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.05229s | After: 0.07061s | Elapsed: 0.01832s
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.07480s | After: 0.07485s | Elapsed: 0.00005s
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.07511s | After: 0.07521s | Elapsed: 0.00010s
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.07555s | After: 0.07559s | Elapsed: 0.00004s
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.07587s | After: 0.07592s | Elapsed: 0.00004s
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.07618s | After: 0.07622s | Elapsed: 0.00004s
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.07653s | After: 0.07659s | Elapsed: 0.00006s
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.07684s | After: 0.07687s | Elapsed: 0.00004s
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.08201s | After: 0.08345s | Elapsed: 0.00144s
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.08437s | After: 0.08455s | Elapsed: 0.00018s
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.08494s | After: 0.08588s | Elapsed: 0.00094s
Query results obtained from the cache |
---|
|
Before: 0.08877s | After: 0.08904s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00008s
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 | 174 (0%) | Using where; Using rowid filter |
Before: 0.08991s | After: 0.09028s | Elapsed: 0.00037s
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 | 174 (0%) | Using where; Using rowid filter |
Before: 0.09047s | After: 0.09066s | Elapsed: 0.00019s
Query results obtained from the cache |
---|
|
Before: 0.09090s | After: 0.09111s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00006s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_colors | ALL | | | | | 5 | |
Before: 0.09199s | After: 0.09207s | 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.09223s | After: 0.09230s | Elapsed: 0.00006s
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.09252s | After: 0.09257s | 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.09272s | After: 0.09277s | 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.09296s | After: 0.09308s | Elapsed: 0.00012s
Query results obtained from the cache |
---|
|
Before: 0.09333s | After: 0.09360s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00009s