SQL Report
Page generated in 0.8629 seconds with 9 queries + 5 queries returning data from cache
Time spent on mysqli queries: 0.06139s | Time spent on PHP: 0.80148s
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.22107s | After: 0.22235s | Elapsed: 0.00128s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | s | | const | PRIMARY,session_user_id | PRIMARY | 96 | const | 1 | 100.00 | |
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 | 100.00 | |
Before: 0.46297s | After: 0.46462s | Elapsed: 0.00165s
Query results obtained from the cache |
---|
|
Before: 0.49463s | After: 0.49481s | Elapsed [cache]: 0.00018s | Elapsed [db]: 1.09284s
Query results obtained from the cache |
---|
|
Before: 0.59977s | After: 0.59984s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00506s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | f | | ALL | | | | | 41 | 100.00 | Using filesort |
1 | SIMPLE | fa | | ref | 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 | 99 | const,xuya89hi_phpbb_minorhockeytalks.f.forum_id | 1 | 100.00 | Using index |
Before: 0.61080s | After: 0.61591s | Elapsed: 0.00511s
Query results obtained from the cache |
---|
|
Before: 0.65607s | After: 0.65615s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.01382s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | bb_sessions | | const | PRIMARY | PRIMARY | 96 | const | 1 | 100.00 | |
Affected rows: 1 | Before: 0.73489s | After: 0.76685s | Elapsed: 0.03196s
Query results obtained from the cache |
---|
|
Before: 0.76745s | After: 0.76750s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.01143s
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: 0.83453s | After: 0.83950s | Elapsed: 0.00497s
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: 0.83983s | After: 0.84442s | Elapsed: 0.00458s
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: 0.84461s | After: 0.84762s | Elapsed: 0.00301s
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: 0.84942s | After: 0.85143s | Elapsed: 0.00201s
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: 0.85366s | After: 0.86049s | Elapsed: 0.00683s
Query results obtained from the cache |
---|
|
Before: 0.86245s | After: 0.86255s | Elapsed [cache]: 0.00009s | Elapsed [db]: 0.00202s