SQL Report


Page generated in 0.0612 seconds with 10 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.01725s | Time spent on PHP: 0.04399s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb3_configrefis_dynamicis_dynamic1const25 

Before: 0.01020s | After: 0.01034s | Elapsed: 0.00014s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb3_usersconstPRIMARYPRIMARY4const1 

Before: 0.02019s | After: 0.02042s | Elapsed: 0.00023s



Query results obtained from the cache

Before: 0.02088s | After: 0.02104s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00014s



Query #4

Before: 0.02131s | After: 0.02190s | Elapsed: 0.00059s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb3_sessionsrefsession_time,session_user_idsession_user_id4const2248Using where

Before: 0.02246s | After: 0.03478s | Elapsed: 0.01232s



Query results obtained from the cache

Before: 0.03589s | After: 0.03601s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00009s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALL    102Using filesort

Before: 0.04173s | After: 0.04300s | Elapsed: 0.00127s



Query results obtained from the cache

Before: 0.04582s | After: 0.04597s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.00041s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgALLgroup_legend_name   8Using where; Using filesort
1SIMPLEugrefgroup_id,user_iduser_id4const2Using where

Before: 0.05298s | After: 0.05308s | Elapsed: 0.00010s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeuser_birthday,user_typeuser_birthday32 1Using index condition; Using where
1SIMPLEbrefban_userban_user4db336364850.u.user_id2Using where; Using index

Before: 0.05379s | After: 0.05420s | Elapsed: 0.00041s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 265Using index condition; Using where

Before: 0.05530s | After: 0.05664s | Elapsed: 0.00134s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_user_id4 36Using index condition; Using where

Before: 0.05697s | After: 0.05743s | Elapsed: 0.00045s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARYPRIMARY4 5Using where; Using filesort

Before: 0.05785s | After: 0.05826s | Elapsed: 0.00041s



Query results obtained from the cache

Before: 0.05877s | After: 0.05889s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00010s