SQL Report


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

Time spent on mysqli queries: 0.13706s | Time spent on PHP: 0.16613s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.00872s | After: 0.00893s | Elapsed: 0.00021s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03583s | After: 0.03675s | Elapsed: 0.00092s



Query results obtained from the cache

Before: 0.03796s | After: 0.03833s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00021s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03977s | After: 0.09026s | Elapsed: 0.05049s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.09234s | After: 0.12394s | Elapsed: 0.03160s



Query #6

Before: 0.12489s | After: 0.15767s | Elapsed: 0.03278s



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

Before: 0.16082s | After: 0.16941s | Elapsed: 0.00859s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.17561s | After: 0.17593s | Elapsed: 0.00032s



Query results obtained from the cache

Before: 0.17973s | After: 0.18009s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00023s



Query results obtained from the cache

Before: 0.18371s | After: 0.18408s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00074s



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

Before: 0.18614s | After: 0.18740s | Elapsed: 0.00126s



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

Before: 0.18861s | After: 0.18968s | Elapsed: 0.00107s



Query results obtained from the cache

Before: 0.19249s | After: 0.19296s | Elapsed [cache]: 0.00047s | Elapsed [db]: 0.00028s



Query results obtained from the cache

Before: 0.20626s | After: 0.20717s | Elapsed [cache]: 0.00091s | Elapsed [db]: 0.00066s



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: 0.23266s | After: 0.23887s | Elapsed: 0.00621s



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

Before: 0.24054s | After: 0.24257s | Elapsed: 0.00203s



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

Before: 0.24427s | After: 0.24584s | Elapsed: 0.00157s