SQL Report


Page generated in 0.0397 seconds with 10 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.01011s | Time spent on PHP: 0.02962s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const24 

Before: 0.01754s | After: 0.01774s | Elapsed: 0.00020s



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

Before: 0.02030s | After: 0.02048s | Elapsed: 0.00018s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.02147s | After: 0.02163s | Elapsed: 0.00017s



Query results obtained from the cache

Before: 0.02192s | After: 0.02219s | Elapsed [cache]: 0.00028s | Elapsed [db]: 0.00021s



Query #5

Affected rows: 0 | Before: 0.02252s | After: 0.02267s | Elapsed: 0.00015s



Query #6

Before: 0.02277s | After: 0.02298s | Elapsed: 0.00021s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 2148Using index condition; Using where

Before: 0.02332s | After: 0.03119s | Elapsed: 0.00787s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.03172s | After: 0.03186s | Elapsed: 0.00014s



Query results obtained from the cache

Before: 0.03344s | After: 0.03358s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00017s



Query results obtained from the cache

Before: 0.03419s | After: 0.03469s | Elapsed [cache]: 0.00050s | Elapsed [db]: 0.00051s



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

Before: 0.03535s | After: 0.03605s | Elapsed: 0.00071s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,forum_appr_last,fid_time_movedforum_id_type4 4Using index condition; Using filesort

Before: 0.03711s | After: 0.03730s | Elapsed: 0.00019s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_movedforum_id3const8Using where; Using filesort

Before: 0.03759s | After: 0.03789s | Elapsed: 0.00030s