SQL Report


Page generated in 9.2207 seconds with 12 queries + 5 queries returning data from cache

Time spent on mysqli queries: 7.55757s | Time spent on PHP: 1.66313s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00797s | After: 0.00818s | Elapsed: 0.00021s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 1.54847s | After: 1.54943s | Elapsed: 0.00096s



Query results obtained from the cache

Before: 1.55066s | After: 1.55105s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 1.55248s | After: 3.28526s | Elapsed: 1.73278s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 3.28693s | After: 5.50596s | Elapsed: 2.21903s



Query #6

Before: 5.50653s | After: 9.07928s | Elapsed: 3.57274s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 939Using where

Before: 9.08362s | After: 9.09698s | Elapsed: 0.01336s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 9.10510s | After: 9.10622s | Elapsed: 0.00112s



Query results obtained from the cache

Before: 9.11135s | After: 9.11181s | Elapsed [cache]: 0.00046s | Elapsed [db]: 0.00029s



Query results obtained from the cache

Before: 9.11643s | After: 9.11702s | Elapsed [cache]: 0.00060s | Elapsed [db]: 0.00092s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 63Using where

Before: 9.12038s | After: 9.12236s | Elapsed: 0.00198s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 55Using where

Before: 9.12408s | After: 9.12579s | Elapsed: 0.00171s



Query results obtained from the cache

Before: 9.12882s | After: 9.12927s | Elapsed [cache]: 0.00045s | Elapsed [db]: 0.00028s



Query results obtained from the cache

Before: 9.14513s | After: 9.14644s | Elapsed [cache]: 0.00132s | Elapsed [db]: 0.00106s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,fid_time_moved,forum_vis_lastforum_id_type4 44Using where; Using filesort
1SIMPLEfeq_refPRIMARYPRIMARY3forum_fedegnv3.t.forum_id1 

Before: 9.17842s | After: 9.18796s | Elapsed: 0.00954s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_lastforum_id3const25Using where; Using filesort

Before: 9.19031s | After: 9.19314s | Elapsed: 0.00283s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangePRIMARYPRIMARY3 5Using where

Before: 9.19497s | After: 9.19628s | Elapsed: 0.00131s