SQL Report


Page generated in 0.2755 seconds with 37 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.04319s | Time spent on PHP: 0.23228s



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.08940s | After: 0.09097s | Elapsed: 0.00156s



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

Before: 0.09169s | After: 0.09241s | Elapsed: 0.00073s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_usersconstPRIMARYPRIMARY4const1 

Affected rows: 1 | Before: 0.09434s | After: 0.09541s | Elapsed: 0.00107s



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

Before: 0.09826s | After: 0.10008s | Elapsed: 0.00182s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprangePRIMARY,topic_id,tid_post_timetid_post_time12 2Using where; Using index

Before: 0.10106s | After: 0.10173s | Elapsed: 0.00067s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_chris1278_cookierefis_dynamicis_dynamic1const1 

Before: 0.11490s | After: 0.11518s | Elapsed: 0.00029s



Query results obtained from the cache

Before: 0.13457s | After: 0.13464s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00039s



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

Before: 0.14585s | After: 0.14654s | Elapsed: 0.00069s



Query #10
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.14731s | After: 0.14803s | Elapsed: 0.00072s



Query #11
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.14907s | After: 0.15015s | Elapsed: 0.00107s



Query #12
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.15124s | After: 0.16380s | Elapsed: 0.01256s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_forumsconstPRIMARYPRIMARY3const1 

Before: 0.17728s | After: 0.17757s | Elapsed: 0.00030s



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

Before: 0.17813s | After: 0.17850s | Elapsed: 0.00038s



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

Before: 0.17925s | After: 0.17963s | Elapsed: 0.00038s



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

Before: 0.18081s | After: 0.18205s | Elapsed: 0.00124s



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.18723s | After: 0.18775s | Elapsed: 0.00052s



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

Before: 0.18825s | After: 0.18880s | Elapsed: 0.00055s



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

Before: 0.19236s | After: 0.19259s | Elapsed: 0.00023s



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

Before: 0.19316s | After: 0.19397s | Elapsed: 0.00081s



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

Before: 0.19446s | After: 0.19499s | Elapsed: 0.00053s



Query #22
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsrangesession_user_idsession_user_id4 2Using index condition

Before: 0.19562s | After: 0.19610s | Elapsed: 0.00047s



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

Before: 0.19677s | After: 0.19737s | Elapsed: 0.00060s



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 (30%)Using where; Using rowid filter

Before: 0.19807s | After: 0.19876s | Elapsed: 0.00069s



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.19963s | After: 0.20057s | Elapsed: 0.00094s



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.20154s | After: 0.20845s | Elapsed: 0.00691s



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

Before: 0.20892s | After: 0.20931s | Elapsed: 0.00039s



Query #28
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.21102s | After: 0.21146s | Elapsed: 0.00044s



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

Before: 0.21383s | After: 0.21427s | Elapsed: 0.00043s



Query #30
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.24337s | After: 0.24373s | Elapsed: 0.00036s



Query #31
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.24654s | After: 0.24695s | Elapsed: 0.00041s



Query #32
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_postsconstPRIMARYPRIMARY4const1 

Before: 0.25071s | After: 0.25116s | Elapsed: 0.00046s



Query #33
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_config_textconstPRIMARYPRIMARY767const1 

Before: 0.25326s | After: 0.25356s | Elapsed: 0.00030s



Query #34
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_topicsconstPRIMARYPRIMARY4const1 

Before: 0.25416s | After: 0.25465s | Elapsed: 0.00049s



Query results obtained from the cache

Before: 0.25895s | After: 0.25903s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00029s



Query results obtained from the cache

Before: 0.26108s | After: 0.26120s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00049s



Query #37
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEewaa_sessionsconstPRIMARYPRIMARY96const1 

Affected rows: 1 | Before: 0.26289s | After: 0.26393s | Elapsed: 0.00104s



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

Before: 0.26516s | After: 0.26621s | Elapsed: 0.00105s



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

Before: 0.26699s | After: 0.26795s | Elapsed: 0.00096s



Query #40
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuconstPRIMARYPRIMARY4const1 

Before: 0.26915s | After: 0.26979s | Elapsed: 0.00064s



Query results obtained from the cache

Before: 0.27053s | After: 0.27061s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00027s



Query results obtained from the cache

Before: 0.27374s | After: 0.27390s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.00094s