SQL Report
Page generated in 1.4016 seconds with 8 queries + 5 queries returning data from cache
Time spent on mysqli queries: 0.04836s | Time spent on PHP: 1.35324s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | nbb_config | ref | is_dynamic | is_dynamic | 1 | const | 23 | |
Before: 0.33400s | After: 0.33657s | Elapsed: 0.00257s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | nbb_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Before: 1.10293s | After: 1.11363s | Elapsed: 0.01071s
| Query results obtained from the cache |
|---|
|
Before: 1.11762s | After: 1.11773s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00181s
Before: 1.11799s | After: 1.12359s | Elapsed: 0.00560s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | nbb_sessions | ALL | session_time,session_user_id | | | | 48805 | Using where |
Before: 1.19662s | After: 1.22156s | Elapsed: 0.02494s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | f | const | PRIMARY | PRIMARY | 3 | const | 1 | |
Before: 1.22856s | After: 1.23015s | Elapsed: 0.00159s
| Query results obtained from the cache |
|---|
|
Before: 1.29664s | After: 1.29678s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.01091s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | f | range | left_right_id | left_right_id | 3 | | 2 | Using index condition |
Before: 1.30788s | After: 1.31012s | Elapsed: 0.00224s
| Query results obtained from the cache |
|---|
|
Before: 1.31176s | After: 1.31188s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00032s
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | session_time,session_user_id,session_fid | session_fid | 3 | const | 5 | Using where |
Before: 1.38550s | After: 1.38591s | 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 | | 2 (0%) | Using index condition; Using where; Using rowid filter |
Before: 1.38622s | After: 1.38654s | Elapsed: 0.00032s
| Query results obtained from the cache |
|---|
|
Before: 1.38704s | After: 1.38715s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00016s
| Query results obtained from the cache |
|---|
|
Before: 1.39441s | After: 1.39477s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00047s