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



Query #1
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_config refis_dynamicis_dynamic1const25100.00 

Before: 0.04040s | After: 0.04274s | Elapsed: 0.00234s



Query #2
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_users constPRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_idPRIMARY4const1100.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



Query #4

Before: 3.27788s | After: 3.29761s | Elapsed: 0.01973s



Query #5
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_sessions refsession_time,session_user_idsession_user_id4const629550.00Using where

Before: 3.30518s | After: 3.35415s | Elapsed: 0.04896s



Query #6
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_users constPRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_idPRIMARY4const1100.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



Query #8
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_topics constPRIMARY,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_idPRIMARY4const1100.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



Query #11
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_menu_colors ALL    5100.00 

Before: 3.75026s | After: 3.75301s | Elapsed: 0.00275s



Query #12
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_menu_buttons ALL    119.09Using where; Using filesort

Before: 3.75331s | After: 3.75600s | Elapsed: 0.00269s



Query #13
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_menu_buttons ALL    119.09Using where; Using filesort

Before: 3.75810s | After: 3.75824s | Elapsed: 0.00013s



Query #14
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_menu_buttons ALL    119.09Using where; Using filesort

Before: 3.76002s | After: 3.76027s | Elapsed: 0.00025s



Query #15
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEbb_menu_buttons ALL    119.09Using where; Using filesort

Before: 3.76207s | After: 3.76219s | Elapsed: 0.00012s