SQL Report


Page generated in 0.347 seconds with 13 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.12996s | Time spent on PHP: 0.21706s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01826s | After: 0.01848s | Elapsed: 0.00022s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04936s | After: 0.05030s | Elapsed: 0.00094s



Query results obtained from the cache

Before: 0.05157s | After: 0.05201s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00024s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.05352s | After: 0.09350s | Elapsed: 0.03998s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.09556s | After: 0.12719s | Elapsed: 0.03163s



Query #6

Before: 0.12825s | After: 0.16093s | Elapsed: 0.03268s



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

Before: 0.16419s | After: 0.17814s | Elapsed: 0.01395s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.18984s | After: 0.19032s | Elapsed: 0.00048s



Query results obtained from the cache

Before: 0.19531s | After: 0.19569s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00026s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrangeleft_right_idleft_right_id3 1Using where
1SIMPLEfarefPRIMARYPRIMARY3forum_fedegnv3.f.forum_id1Using index

Before: 0.19929s | After: 0.20052s | Elapsed: 0.00122s



Query results obtained from the cache

Before: 0.20324s | After: 0.20373s | Elapsed [cache]: 0.00049s | Elapsed [db]: 0.00084s



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

Before: 0.21025s | After: 0.21167s | Elapsed: 0.00142s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_time4 33Using where

Before: 0.21304s | After: 0.21431s | Elapsed: 0.00126s



Query results obtained from the cache

Before: 0.21706s | After: 0.21753s | Elapsed [cache]: 0.00047s | Elapsed [db]: 0.00026s



Query results obtained from the cache

Before: 0.23123s | After: 0.23222s | Elapsed [cache]: 0.00099s | Elapsed [db]: 0.00065s



Query #16
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.25895s | After: 0.25927s | Elapsed: 0.00033s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_lastforum_vis_last4const,const31Using where; Using filesort

Before: 0.26099s | After: 0.26393s | Elapsed: 0.00294s



Query #18
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangePRIMARYPRIMARY3 25Using where

Before: 0.26692s | After: 0.26981s | Elapsed: 0.00289s