SQL Report
Page generated in 0.0913 seconds with 25 queries + 6 queries returning data from cache
Time spent on mysqli queries: 0.02316s | Time spent on PHP: 0.0681s
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.00600s | After: 0.00611s | Elapsed: 0.00011s
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.01292s | After: 0.01327s | Elapsed: 0.00034s
Query results obtained from the cache |
---|
|
Before: 0.01362s | After: 0.01424s | Elapsed [cache]: 0.00062s | Elapsed [db]: 0.00014s
Before: 0.01636s | After: 0.01705s | Elapsed: 0.00069s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_sessions | ALL | session_time,session_user_id | | | | 2348 | Using where |
Before: 0.01737s | After: 0.01836s | Elapsed: 0.00099s
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.01868s | After: 0.01938s | Elapsed: 0.00071s
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.02058s | After: 0.02097s | Elapsed: 0.00039s
Query results obtained from the cache |
---|
|
Before: 0.02269s | After: 0.02290s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00008s
Query results obtained from the cache |
---|
|
Before: 0.04844s | After: 0.04873s | Elapsed [cache]: 0.00029s | 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_bb_posts_topic_visibility_time_id | 5 | const,const | 1 | Using where; Using index |
Before: 0.05187s | After: 0.05224s | Elapsed: 0.00037s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | p | const | 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 | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | z | const | PRIMARY,idx_user_id_zebra_id,bb_zebra_user_id | PRIMARY | 8 | const,const | | Unique row not found |
1 | SIMPLE | u | const | PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id | PRIMARY | 4 | const | 1 | |
Before: 0.05278s | After: 0.05338s | Elapsed: 0.00059s
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.05487s | After: 0.05498s | Elapsed: 0.00011s
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.05529s | After: 0.05540s | Elapsed: 0.00012s
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.05580s | After: 0.05604s | Elapsed: 0.00024s
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.05638s | After: 0.05648s | 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 | 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.05692s | After: 0.05703s | Elapsed: 0.00012s
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.05740s | After: 0.05748s | Elapsed: 0.00008s
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.05779s | After: 0.05789s | Elapsed: 0.00010s
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.06143s | After: 0.06208s | Elapsed: 0.00065s
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.06321s | After: 0.06358s | Elapsed: 0.00037s
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.06396s | After: 0.07926s | Elapsed: 0.01530s
Query results obtained from the cache |
---|
|
Before: 0.08261s | After: 0.08290s | Elapsed [cache]: 0.00029s | Elapsed [db]: 0.00044s
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 | 12 (2%) | Using where; Using rowid filter |
Before: 0.08402s | After: 0.08481s | Elapsed: 0.00079s
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 | 12 (0%) | Using where; Using rowid filter |
Before: 0.08559s | After: 0.08594s | Elapsed: 0.00035s
Query results obtained from the cache |
---|
|
Before: 0.08640s | After: 0.08674s | Elapsed [cache]: 0.00033s | Elapsed [db]: 0.00014s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_colors | ALL | | | | | 5 | |
Before: 0.08820s | After: 0.08832s | 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.08865s | After: 0.08876s | 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.08906s | After: 0.08922s | Elapsed: 0.00016s
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.08946s | After: 0.08956s | Elapsed: 0.00010s
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.08977s | After: 0.08992s | Elapsed: 0.00015s
Query results obtained from the cache |
---|
|
Before: 0.09038s | After: 0.09067s | Elapsed [cache]: 0.00030s | Elapsed [db]: 0.00016s