SQL Report


Page generated in 0.0702 seconds with 14 queries + 5 queries returning data from cache

Time spent on mysql4 queries: 0.00319s | Time spent on PHP: 0.06697s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02631s | After: 0.02637s | Elapsed: 0.00006s



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

Before: 0.03055s | After: 0.03072s | Elapsed: 0.00017s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03189s | After: 0.03197s | Elapsed: 0.00008s



Query results obtained from the cache

Before: 0.03253s | After: 0.03370s | Elapsed [cache]: 0.00117s | Elapsed [db]: 0.00082s



Query #5

Affected rows: 0 | Before: 0.03682s | After: 0.03691s | Elapsed: 0.00009s



Query #6

Before: 0.03707s | After: 0.03746s | Elapsed: 0.00039s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsALLsession_time,session_user_id   1235Using where

Before: 0.03823s | After: 0.03941s | Elapsed: 0.00118s



Query results obtained from the cache

Before: 0.04309s | After: 0.04328s | Elapsed [cache]: 0.00018s | Elapsed [db]: 0.00005s



Query results obtained from the cache

Before: 0.04397s | After: 0.04434s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00025s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALL    77Using filesort

Before: 0.04526s | After: 0.04539s | Elapsed: 0.00013s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,last_post_time,forum_appr_last,fid_time_movedfid_time_moved3const2Using where

Before: 0.04581s | After: 0.04598s | Elapsed: 0.00017s



Query results obtained from the cache

Before: 0.05143s | After: 0.05218s | Elapsed [cache]: 0.00075s | Elapsed [db]: 0.00115s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALLPRIMARY   77Using where; Using filesort

Before: 0.05383s | After: 0.05399s | Elapsed: 0.00016s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEgrefgroup_legend_namegroup_legend_name1const11Using where
1SIMPLEugrefgroup_id,user_iduser_id3const1Using where

Before: 0.06185s | After: 0.06194s | Elapsed: 0.00009s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_time4 21Using where

Before: 0.06353s | After: 0.06386s | Elapsed: 0.00034s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_idsession_user_id3 15Using where

Before: 0.06488s | After: 0.06504s | Elapsed: 0.00016s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersrangePRIMARYPRIMARY3 2Using where; Using filesort

Before: 0.06540s | After: 0.06552s | Elapsed: 0.00012s



Query results obtained from the cache

Before: 0.06594s | After: 0.06604s | Elapsed [cache]: 0.00009s | Elapsed [db]: 0.00003s



Query #19
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_fsfALL    29Using where; Using filesort

Before: 0.06687s | After: 0.06692s | Elapsed: 0.00005s