SQL Report


Page generated in 0.1007 seconds with 16 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.0267s | Time spent on PHP: 0.07401s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02586s | After: 0.02607s | Elapsed: 0.00020s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03103s | After: 0.03112s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.03172s | After: 0.03282s | Elapsed [cache]: 0.00110s | Elapsed [db]: 0.00071s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03605s | After: 0.03640s | Elapsed: 0.00035s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.03675s | After: 0.03685s | Elapsed: 0.00010s



Query #6

Before: 0.03698s | After: 0.05753s | Elapsed: 0.02054s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrefsession_time,session_user_idsession_user_id3const874Using where

Before: 0.05819s | After: 0.06075s | Elapsed: 0.00256s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.06221s | After: 0.06232s | Elapsed: 0.00010s



Query results obtained from the cache

Before: 0.06570s | After: 0.06586s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.00006s



Query results obtained from the cache

Before: 0.06670s | After: 0.06712s | Elapsed [cache]: 0.00042s | Elapsed [db]: 0.00027s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfasystemPRIMARY    const row not found
1SIMPLEfrangeleft_right_idleft_right_id3 1Using where

Before: 0.06828s | After: 0.06846s | Elapsed: 0.00018s



Query results obtained from the cache

Before: 0.06901s | After: 0.06973s | Elapsed [cache]: 0.00072s | Elapsed [db]: 0.00062s



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

Before: 0.07123s | After: 0.07162s | Elapsed: 0.00039s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const23Using where

Before: 0.07718s | After: 0.07765s | Elapsed: 0.00047s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_user_id3 5Using where

Before: 0.07815s | After: 0.07847s | Elapsed: 0.00031s



Query results obtained from the cache

Before: 0.07909s | After: 0.07927s | Elapsed [cache]: 0.00018s | Elapsed [db]: 0.00006s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_fsfALL    30Using where; Using filesort

Before: 0.08049s | After: 0.08058s | Elapsed: 0.00009s



Query results obtained from the cache

Before: 0.08535s | After: 0.08588s | Elapsed [cache]: 0.00053s | Elapsed [db]: 0.00033s



Query #19
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangeforum_id,forum_id_type,forum_appr_last,fid_time_movedforum_id_type4 5Using where; Using filesort

Before: 0.09104s | After: 0.09138s | Elapsed: 0.00034s



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

Before: 0.09203s | After: 0.09259s | Elapsed: 0.00056s



Query #21
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrangePRIMARYPRIMARY3 15Using where

Before: 0.09311s | After: 0.09338s | Elapsed: 0.00026s



Query #22
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_topicsconstPRIMARYPRIMARY3const1 

Before: 0.09411s | After: 0.09425s | Elapsed: 0.00014s