SQL Report


Page generated in 0.1157 seconds with 12 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.03466s | Time spent on PHP: 0.08108s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const24 

Before: 0.04767s | After: 0.04828s | Elapsed: 0.00062s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Before: 0.05535s | After: 0.05584s | Elapsed: 0.00049s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.05836s | After: 0.05882s | Elapsed: 0.00046s



Query results obtained from the cache

Before: 0.05960s | After: 0.06037s | Elapsed [cache]: 0.00077s | Elapsed [db]: 0.00063s



Query #5

Affected rows: 0 | Before: 0.06116s | After: 0.06150s | Elapsed: 0.00034s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.06211s | After: 0.06251s | Elapsed: 0.00040s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.06304s | After: 0.06348s | Elapsed: 0.00044s



Query #8

Before: 0.06370s | After: 0.06431s | Elapsed: 0.00061s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 2581Using index condition; Using where

Before: 0.06512s | After: 0.09117s | Elapsed: 0.02605s



Query results obtained from the cache

Before: 0.09640s | After: 0.09683s | Elapsed [cache]: 0.00043s | Elapsed [db]: 0.00058s



Query results obtained from the cache

Before: 0.09860s | After: 0.09988s | Elapsed [cache]: 0.00127s | Elapsed [db]: 0.00126s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALL    22Using filesort

Before: 0.10102s | After: 0.10187s | Elapsed: 0.00086s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrefgroup_legendgroup_legend1const3Using where; Using filesort
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 0.10681s | After: 0.10749s | Elapsed: 0.00068s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersrangeuser_birthday,user_typeuser_birthday32 1Using index condition; Using where

Before: 0.10859s | After: 0.10919s | Elapsed: 0.00061s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 75Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARYPRIMARY3cattibri1.s.session_user_id1 

Before: 0.11046s | After: 0.11357s | Elapsed: 0.00311s