SQL Report


Page generated in 0.2866 seconds with 40 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.04322s | Time spent on PHP: 0.24338s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_configrefis_dynamicis_dynamic1const38 

Before: 0.05911s | After: 0.05967s | Elapsed: 0.00056s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 
1SIMPLEsrefsession_user_idsession_user_id4const1 

Before: 0.09221s | After: 0.09396s | Elapsed: 0.00175s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_banlistALLban_user,ban_email,ban_ip   8Using where

Before: 0.09472s | After: 0.09541s | Elapsed: 0.00070s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_usersconstPRIMARYPRIMARY4const1 

Affected rows: 1 | Before: 0.09728s | After: 0.09832s | Elapsed: 0.00104s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicsPRIMARY4const1 
1SIMPLEfconstPRIMARYPRIMARY3const1 

Before: 0.10263s | After: 0.10441s | Elapsed: 0.00178s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_chris1278_cookierefis_dynamicis_dynamic1const1 

Before: 0.12626s | After: 0.12663s | Elapsed: 0.00037s



Query results obtained from the cache

Before: 0.15155s | After: 0.15163s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00043s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefauth_option_id,auth_role_idauth_option_id3const1Using where

Before: 0.16365s | After: 0.16437s | Elapsed: 0.00072s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLErrefPRIMARY,ath_op_idath_op_id3const5 
1SIMPLEarefauth_role_idauth_role_id3db0rm_app_phpbb_2.r.role_id25Using where

Before: 0.16525s | After: 0.16595s | Elapsed: 0.00070s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefgroup_id,auth_opt_id,auth_role_idauth_opt_id3const41Using where
1SIMPLEgeq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.a.group_id1 
1SIMPLEugrefgroup_id,group_leadergroup_id3db0rm_app_phpbb_2.a.group_id28Using where

Before: 0.16682s | After: 0.16772s | Elapsed: 0.00090s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEgALLPRIMARY   18 
1SIMPLEarefgroup_id,auth_role_idgroup_id3db0rm_app_phpbb_2.g.group_id216Using where
1SIMPLEreq_refPRIMARY,ath_op_idPRIMARY6db0rm_app_phpbb_2.a.auth_role_id,const1 
1SIMPLEugrefgroup_id,group_leadergroup_id3db0rm_app_phpbb_2.g.group_id28Using where

Before: 0.16861s | After: 0.17996s | Elapsed: 0.01135s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.19557s | After: 0.19600s | Elapsed: 0.00043s



Query #13

Before: 0.19672s | After: 0.19703s | Elapsed: 0.00031s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_forumsconstPRIMARYPRIMARY3const1 

Before: 0.19745s | After: 0.19774s | Elapsed: 0.00028s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEttrefidx_topic,idx_tagidx_topic3const1 
1SIMPLEteq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1 

Before: 0.19834s | After: 0.19874s | Elapsed: 0.00040s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpreftopic_id,tid_post_timetid_post_time4const6Using where; Using index

Before: 0.19956s | After: 0.19996s | Elapsed: 0.00041s



Query #17
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprangePRIMARY,poster_idPRIMARY4 6Using where
1SIMPLEzeq_refPRIMARYPRIMARY8const,db0rm_app_phpbb_2.p.poster_id1 
1SIMPLEueq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.p.poster_id1 

Before: 0.20111s | After: 0.20315s | Elapsed: 0.00204s



Query #18
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEwALL    1Using where
1SIMPLEleq_refPRIMARY,user_idPRIMARY4db0rm_app_phpbb_2.w.log_id1 
1SIMPLEueq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.l.user_id1 

Before: 0.20838s | After: 0.20886s | Elapsed: 0.00048s



Query #19
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEbALLban_end,ban_user   8Using where
1SIMPLEueq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.b.ban_userid1Using index

Before: 0.20939s | After: 0.20988s | Elapsed: 0.00049s



Query #20
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_langreflang_isolang_iso92const3Using where; Using index

Before: 0.21390s | After: 0.21417s | Elapsed: 0.00028s



Query #21
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALLPRIMARY   13Using where; Using filesort
1SIMPLEleq_refPRIMARYPRIMARY6db0rm_app_phpbb_2.f.field_id,const1 

Before: 0.21472s | After: 0.21521s | Elapsed: 0.00049s



Query #22
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_profile_fields_datarangePRIMARYPRIMARY4 2Using where

Before: 0.21568s | After: 0.21619s | Elapsed: 0.00051s



Query #23
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsrangesession_user_idsession_user_id4 27Using index condition

Before: 0.21678s | After: 0.21745s | Elapsed: 0.00067s



Query #24
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefuser_id,auth_option_id,auth_role_idauth_option_id3const1Using where

Before: 0.21816s | After: 0.21883s | Elapsed: 0.00067s



Query #25
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLErrefPRIMARY,ath_op_idath_op_id3const6 
1SIMPLEaref|filteruser_id,auth_role_idauth_role_id|user_id3|4db0rm_app_phpbb_2.r.role_id25 (3%)Using where; Using rowid filter

Before: 0.21957s | After: 0.22028s | Elapsed: 0.00071s



Query #26
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefgroup_id,auth_opt_id,auth_role_idauth_opt_id3const9Using where
1SIMPLEugref|filtergroup_id,user_id,group_leadergroup_id|user_id3|4db0rm_app_phpbb_2.a.group_id28 (1%)Using where; Using rowid filter
1SIMPLEgeq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.a.group_id1Using where

Before: 0.22128s | After: 0.22228s | Elapsed: 0.00099s



Query #27
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEgALLPRIMARY   18 
1SIMPLEugref|filtergroup_id,user_id,group_leadergroup_id|user_id3|4db0rm_app_phpbb_2.g.group_id28 (1%)Using where; Using rowid filter
1SIMPLEarefgroup_id,auth_role_idgroup_id3db0rm_app_phpbb_2.g.group_id216 
1SIMPLEreq_refPRIMARY,ath_op_idPRIMARY6db0rm_app_phpbb_2.a.auth_role_id,const1 

Before: 0.22326s | After: 0.22961s | Elapsed: 0.00635s



Query #28
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_banlistALLban_end,ban_user   8Using where

Before: 0.23019s | After: 0.23057s | Elapsed: 0.00038s



Query #29
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_attachmentsrefpost_msg_id,is_orphanpost_msg_id4const1Using where

Before: 0.23269s | After: 0.23319s | Elapsed: 0.00051s



Query #30
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.24111s | After: 0.24147s | Elapsed: 0.00036s



Query #31
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.25690s | After: 0.25728s | Elapsed: 0.00039s



Query #32
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.25894s | After: 0.25932s | Elapsed: 0.00038s



Query #33
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.26158s | After: 0.26190s | Elapsed: 0.00032s



Query #34
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.26396s | After: 0.26427s | Elapsed: 0.00031s



Query #35
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.26632s | After: 0.26672s | Elapsed: 0.00040s



Query #36
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_config_textconstPRIMARYPRIMARY767const1 

Before: 0.26837s | After: 0.26863s | Elapsed: 0.00027s



Query #37
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_topicsconstPRIMARYPRIMARY4const1 

Before: 0.26923s | After: 0.26966s | Elapsed: 0.00042s



Query results obtained from the cache

Before: 0.27268s | After: 0.27275s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00024s



Query results obtained from the cache

Before: 0.27405s | After: 0.27410s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00041s



Query #40
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsconstPRIMARYPRIMARY96const1 

Affected rows: 1 | Before: 0.27511s | After: 0.27602s | Elapsed: 0.00091s



Query #41
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_time3|4const110 (0%)Using where; Using rowid filter

Before: 0.27727s | After: 0.27864s | Elapsed: 0.00137s



Query #42
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsref|filtersession_time,session_user_id,session_fidsession_fid|session_time3|4const110 (0%)Using where; Using rowid filter

Before: 0.27946s | After: 0.28075s | Elapsed: 0.00129s



Query #43
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.28175s | After: 0.28230s | Elapsed: 0.00055s



Query results obtained from the cache

Before: 0.28295s | After: 0.28300s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00024s



Query results obtained from the cache

Before: 0.28537s | After: 0.28550s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00075s