SQL Report


Page generated in 0.0934 seconds with 18 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.01s | Time spent on PHP: 0.08341s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const42 

Before: 0.02702s | After: 0.02726s | Elapsed: 0.00023s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.04071s | After: 0.04083s | Elapsed: 0.00012s



Query results obtained from the cache

Before: 0.04150s | After: 0.04254s | Elapsed [cache]: 0.00104s | Elapsed [db]: 0.00067s



Query #4

Before: 0.04529s | After: 0.04570s | Elapsed: 0.00041s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrefsession_time,session_user_idsession_user_id3const1156Using where

Before: 0.04627s | After: 0.05240s | Elapsed: 0.00614s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,topic_id,tid_post_timePRIMARY3const1 
1SIMPLEtconstPRIMARY,forum_id,forum_id_type,forum_appr_last,fid_time_movedPRIMARY3const1 
1SIMPLEfrangePRIMARYPRIMARY3 1Using where

Before: 0.05480s | After: 0.05505s | Elapsed: 0.00025s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprangePRIMARY,topic_id,post_approved,tid_post_timetid_post_time7 3Using where

Before: 0.05561s | After: 0.05575s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.06220s | After: 0.06250s | Elapsed [cache]: 0.00030s | Elapsed [db]: 0.00013s



Query results obtained from the cache

Before: 0.06357s | After: 0.06394s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00025s



Query results obtained from the cache

Before: 0.06561s | After: 0.06624s | Elapsed [cache]: 0.00064s | Elapsed [db]: 0.00065s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpreftopic_id,post_approved,tid_post_timetid_post_time3const5Using where

Before: 0.06771s | After: 0.06776s | Elapsed: 0.00005s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprangePRIMARY,poster_idPRIMARY3 3Using where
1SIMPLEzeq_refPRIMARYPRIMARY6const,forogolf_phpbb306.p.poster_id1 
1SIMPLEueq_refPRIMARYPRIMARY3forogolf_phpbb306.p.poster_id1 

Before: 0.06842s | After: 0.06907s | Elapsed: 0.00065s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_langreflang_isolang_iso92const1Using where

Before: 0.07182s | After: 0.07187s | Elapsed: 0.00005s



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

Before: 0.07224s | After: 0.07229s | Elapsed: 0.00006s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_profile_fields_datarangePRIMARYPRIMARY3 2Using where

Before: 0.07262s | After: 0.07266s | Elapsed: 0.00005s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_user_idsession_user_id3 2Using where

Before: 0.07299s | After: 0.07309s | Elapsed: 0.00010s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_topicsconstPRIMARYPRIMARY3const1 

Affected rows: 1 | Before: 0.07469s | After: 0.07480s | Elapsed: 0.00010s



Query #18
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrefforum_id,forum_id_type,last_post_time,topic_approved,forum_appr_last,fid_time_movedforum_id_type3const193Using where

Before: 0.07527s | After: 0.07618s | Elapsed: 0.00091s



Query #19
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_time,session_user_id,session_fidsession_fid3const10Using where

Before: 0.07746s | After: 0.07778s | Elapsed: 0.00032s



Query #20
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrangesession_time,session_user_id,session_fidsession_user_id3 4Using where

Before: 0.07831s | After: 0.07861s | Elapsed: 0.00030s



Query results obtained from the cache

Before: 0.07904s | After: 0.07914s | Elapsed [cache]: 0.00010s | Elapsed [db]: 0.00005s



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

Before: 0.07953s | After: 0.07959s | Elapsed: 0.00006s



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

Before: 0.08363s | After: 0.08370s | Elapsed: 0.00006s



Query results obtained from the cache

Before: 0.09003s | After: 0.09042s | Elapsed [cache]: 0.00040s | Elapsed [db]: 0.00025s