SQL Report


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

Time spent on mysqli queries: 0.06547s | Time spent on PHP: 0.13028s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01083s | After: 0.01108s | Elapsed: 0.00024s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03657s | After: 0.03691s | Elapsed: 0.00034s



Query results obtained from the cache

Before: 0.03811s | After: 0.03849s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00021s



Query #4

Before: 0.03939s | After: 0.08240s | Elapsed: 0.04300s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 1219Using where

Before: 0.08552s | After: 0.10187s | Elapsed: 0.01635s



Query results obtained from the cache

Before: 0.10717s | After: 0.10758s | Elapsed [cache]: 0.00041s | Elapsed [db]: 0.00023s



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

Before: 0.10975s | After: 0.11024s | Elapsed: 0.00048s



Query results obtained from the cache

Before: 0.12791s | After: 0.12829s | Elapsed [cache]: 0.00038s | Elapsed [db]: 0.00075s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrangegroup_legend_namegroup_legend_name3 2Using where
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 0.16608s | After: 0.16637s | Elapsed: 0.00029s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangeuser_birthday,user_typeuser_birthday32 1Using where
1SIMPLEbrefban_userban_user3forum_fedegnv3.u.user_id1Using where; Using index

Before: 0.16865s | After: 0.16962s | Elapsed: 0.00097s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 47Using where

Before: 0.17327s | After: 0.17483s | Elapsed: 0.00156s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 47Using where

Before: 0.17613s | After: 0.17737s | Elapsed: 0.00124s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARYPRIMARY3 2Using where; Using filesort

Before: 0.17892s | After: 0.17990s | Elapsed: 0.00098s



Query results obtained from the cache

Before: 0.18242s | After: 0.18291s | Elapsed [cache]: 0.00049s | Elapsed [db]: 0.00028s