SQL Report
Page generated in 0.0793 seconds with 29 queries + 7 queries returning data from cache
Time spent on mysqli queries: 0.02169s | Time spent on PHP: 0.0576s
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.00374s | After: 0.00386s | 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.00653s | After: 0.00674s | Elapsed: 0.00022s
Query results obtained from the cache |
---|
|
Before: 0.00703s | After: 0.00738s | Elapsed [cache]: 0.00035s | Elapsed [db]: 0.00014s
Before: 0.00786s | After: 0.00859s | Elapsed: 0.00073s
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 | | 2524 | Using index condition; Using where |
Before: 0.00902s | After: 0.01451s | Elapsed: 0.00549s
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.01481s | After: 0.01536s | Elapsed: 0.00055s
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.02143s | After: 0.02181s | Elapsed: 0.00038s
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 | | 1329 | Using where; Using index |
Before: 0.02248s | After: 0.02323s | Elapsed: 0.00075s
Query results obtained from the cache |
---|
|
Before: 0.02456s | After: 0.02480s | Elapsed [cache]: 0.00024s | Elapsed [db]: 0.00007s
Query results obtained from the cache |
---|
|
Before: 0.04594s | After: 0.04621s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00027s
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 | 2091 | Using where; Using index |
Before: 0.04750s | After: 0.04791s | Elapsed: 0.00042s
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.04842s | After: 0.05594s | Elapsed: 0.00752s
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.05720s | After: 0.05728s | Elapsed: 0.00009s
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.05755s | After: 0.05769s | Elapsed: 0.00014s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
Before: 0.05800s | After: 0.05814s | Elapsed: 0.00014s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_sessions | ref | session_user_id | session_user_id | 4 | const | 1 | |
Before: 0.05840s | After: 0.05857s | Elapsed: 0.00017s
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|filter | user_id,auth_option_id,auth_role_id | auth_option_id|user_id | 3|4 | const | 1 (2%) | Using where; Using rowid filter |
Before: 0.05887s | After: 0.05910s | Elapsed: 0.00023s
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 | range | user_id,auth_role_id | user_id | 4 | | 2 | Using index condition |
1 | SIMPLE | r | eq_ref | PRIMARY,ath_op_id | PRIMARY | 6 | orthohin_minorhockeytalks.a.auth_role_id,const | 1 | |
Before: 0.05936s | After: 0.05961s | Elapsed: 0.00025s
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 | g | eq_ref | PRIMARY | PRIMARY | 3 | orthohin_minorhockeytalks.a.group_id | 1 | |
1 | SIMPLE | ug | range | group_id,user_id,group_leader,idx_usergroup_user_pending | user_id | 4 | | 2 | Using index condition; Using where; Using join buffer (flat, BNL join) |
Before: 0.06002s | After: 0.06052s | Elapsed: 0.00050s
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 | range | group_id,user_id,group_leader,idx_usergroup_user_pending | user_id | 4 | | 2 | Using index condition; 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.06084s | After: 0.06128s | Elapsed: 0.00045s
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 | | 4 | Using index condition; Using where |
Before: 0.06151s | After: 0.06172s | Elapsed: 0.00021s
Query results obtained from the cache |
---|
|
Before: 0.06204s | After: 0.06230s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00007s
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.06869s | After: 0.06960s | Elapsed: 0.00092s
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.07047s | After: 0.07067s | Elapsed: 0.00020s
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.07097s | After: 0.07213s | Elapsed: 0.00117s
Query results obtained from the cache |
---|
|
Before: 0.07434s | After: 0.07454s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00007s
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 | 6 (0%) | Using where; Using rowid filter |
Before: 0.07523s | After: 0.07563s | Elapsed: 0.00040s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | s | range|filter | session_time,session_user_id,session_fid | session_user_id|session_fid | 4|3 | | 4 (0%) | Using index condition; Using where; Using rowid filter |
Before: 0.07588s | After: 0.07611s | Elapsed: 0.00023s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
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.07631s | After: 0.07645s | Elapsed: 0.00013s
Query results obtained from the cache |
---|
|
Before: 0.07666s | After: 0.07686s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00009s
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | bb_menu_colors | ALL | | | | | 5 | |
Before: 0.07769s | After: 0.07778s | 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.07792s | After: 0.07798s | 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.07811s | After: 0.07816s | 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.07828s | After: 0.07833s | 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.07846s | After: 0.07851s | Elapsed: 0.00005s
Query results obtained from the cache |
---|
|
Before: 0.07871s | After: 0.07894s | Elapsed [cache]: 0.00023s | Elapsed [db]: 0.00007s