SQL Report


Page generated in 0.2556 seconds with 34 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.0451s | Time spent on PHP: 0.21047s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_configrefis_dynamicis_dynamic1const38 

Before: 0.05903s | After: 0.05954s | Elapsed: 0.00051s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 
1SIMPLEsrefsession_user_idsession_user_id4const1 

Before: 0.09501s | After: 0.09659s | Elapsed: 0.00157s



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

Before: 0.09730s | After: 0.09798s | Elapsed: 0.00067s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_usersconstPRIMARYPRIMARY4const1 

Affected rows: 1 | Before: 0.09962s | After: 0.10062s | Elapsed: 0.00100s



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

Before: 0.10343s | After: 0.10517s | Elapsed: 0.00175s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_chris1278_cookierefis_dynamicis_dynamic1const1 

Before: 0.11881s | After: 0.11909s | Elapsed: 0.00028s



Query results obtained from the cache

Before: 0.13661s | After: 0.13667s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00037s



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

Before: 0.14693s | After: 0.14764s | 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.14848s | After: 0.14926s | Elapsed: 0.00078s



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.15040s | After: 0.15157s | Elapsed: 0.00117s



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.15272s | After: 0.16581s | Elapsed: 0.01309s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.17882s | After: 0.17926s | Elapsed: 0.00044s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_forumsconstPRIMARYPRIMARY3const1 

Before: 0.18067s | After: 0.18097s | Elapsed: 0.00030s



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

Before: 0.18149s | After: 0.18182s | Elapsed: 0.00033s



Query #15
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpreftopic_id,tid_post_timetid_post_time4const1Using where; Using index

Before: 0.18263s | After: 0.18303s | Elapsed: 0.00040s



Query #16
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,poster_idPRIMARY4const1 
1SIMPLEzconstPRIMARYPRIMARY8const,const Unique row not found
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.18409s | After: 0.18539s | Elapsed: 0.00130s



Query #17
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.19021s | After: 0.19080s | Elapsed: 0.00059s



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

Before: 0.19136s | After: 0.19194s | Elapsed: 0.00058s



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

Before: 0.19522s | After: 0.19570s | Elapsed: 0.00048s



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

Before: 0.19637s | After: 0.19721s | Elapsed: 0.00084s



Query #21
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_profile_fields_dataconstPRIMARYPRIMARY4const1 

Before: 0.19778s | After: 0.19841s | Elapsed: 0.00063s



Query #22
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsrefsession_user_idsession_user_id4const26 

Before: 0.19908s | After: 0.19987s | Elapsed: 0.00079s



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

Before: 0.20081s | After: 0.20155s | Elapsed: 0.00074s



Query #24
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.20243s | After: 0.20326s | Elapsed: 0.00083s



Query #25
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.20428s | After: 0.20530s | Elapsed: 0.00103s



Query #26
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.20635s | After: 0.21156s | Elapsed: 0.00521s



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

Before: 0.21210s | After: 0.21250s | Elapsed: 0.00039s



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

Before: 0.21466s | After: 0.21536s | Elapsed: 0.00070s



Query #29
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.23166s | After: 0.23218s | Elapsed: 0.00052s



Query #30
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_config_textconstPRIMARYPRIMARY767const1 

Before: 0.23436s | After: 0.23495s | Elapsed: 0.00059s



Query #31
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_topicsconstPRIMARYPRIMARY4const1 

Before: 0.23587s | After: 0.23640s | Elapsed: 0.00053s



Query results obtained from the cache

Before: 0.23914s | After: 0.23919s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00038s



Query results obtained from the cache

Before: 0.24075s | After: 0.24080s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00042s



Query #34
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsconstPRIMARYPRIMARY96const1 

Affected rows: 1 | Before: 0.24190s | After: 0.24305s | Elapsed: 0.00115s



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

Before: 0.24410s | After: 0.24654s | Elapsed: 0.00244s



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

Before: 0.24732s | After: 0.24953s | Elapsed: 0.00221s



Query #37
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.25047s | After: 0.25102s | Elapsed: 0.00056s



Query results obtained from the cache

Before: 0.25166s | After: 0.25171s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00027s



Query results obtained from the cache

Before: 0.25423s | After: 0.25442s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00132s