SQL Report
Page generated in 3.7647 seconds with 11 queries + 4 queries returning data from cache
Time spent on mysqli queries: 0.09446s | Time spent on PHP: 3.67023s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_config | | ref | is_dynamic | is_dynamic | 1 | const | 25 | 100.00 | |
Before: 0.04040s | After: 0.04274s | Elapsed: 0.00234s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | 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 | 100.00 | |
Before: 3.26244s | After: 3.27128s | Elapsed: 0.00884s
Query results obtained from the cache |
---|
|
Before: 3.27275s | After: 3.27298s | Elapsed [cache]: 0.00024s | Elapsed [db]: 0.00362s
Before: 3.27788s | After: 3.29761s | Elapsed: 0.01973s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_sessions | | ref | session_time,session_user_id | session_user_id | 4 | const | 6295 | 50.00 | Using where |
Before: 3.30518s | After: 3.35415s | Elapsed: 0.04896s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | 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 | 100.00 | |
Affected rows: 1 | Before: 3.36121s | After: 3.36332s | Elapsed: 0.00211s
Query results obtained from the cache |
---|
|
Before: 3.37545s | After: 3.37553s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.07371s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | 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 | 100.00 | |
Before: 3.38836s | After: 3.39488s | Elapsed: 0.00652s
Query results obtained from the cache |
---|
|
Before: 3.42578s | After: 3.42704s | Elapsed [cache]: 0.00127s | Elapsed [db]: 0.00050s
Query results obtained from the cache |
---|
|
Before: 3.53427s | After: 3.53434s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00789s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_menu_colors | | ALL | | | | | 5 | 100.00 | |
Before: 3.75026s | After: 3.75301s | Elapsed: 0.00275s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_menu_buttons | | ALL | | | | | 11 | 9.09 | Using where; Using filesort |
Before: 3.75331s | After: 3.75600s | Elapsed: 0.00269s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_menu_buttons | | ALL | | | | | 11 | 9.09 | Using where; Using filesort |
Before: 3.75810s | After: 3.75824s | Elapsed: 0.00013s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_menu_buttons | | ALL | | | | | 11 | 9.09 | Using where; Using filesort |
Before: 3.76002s | After: 3.76027s | Elapsed: 0.00025s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_menu_buttons | | ALL | | | | | 11 | 9.09 | Using where; Using filesort |
Before: 3.76207s | After: 3.76219s | Elapsed: 0.00012s