SQL Report


Page generated in 0.0776 seconds with 21 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.0196s | Time spent on PHP: 0.05797s



Query #1
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_config refis_dynamicis_dynamic1const36100.00 

Before: 0.00514s | After: 0.00600s | Elapsed: 0.00085s



Query #2
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARYPRIMARY4const1100.00 
1SIMPLEs refsession_user_idsession_user_id4const1100.00 

Before: 0.01279s | After: 0.01455s | Elapsed: 0.00175s



Query #3
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_banlist ALLban_user,ban_email,ban_ip   572.00Using where

Before: 0.01550s | After: 0.01614s | Elapsed: 0.00064s



Query #4
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_users constPRIMARYPRIMARY4const1100.00 

Affected rows: 1 | Before: 0.01756s | After: 0.01888s | Elapsed: 0.00132s



Query #5
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEf constPRIMARYPRIMARY3const1100.00 

Before: 0.02028s | After: 0.02117s | Elapsed: 0.00089s



Query results obtained from the cache

Before: 0.02709s | After: 0.02717s | Elapsed [cache]: 0.00009s | Elapsed [db]: 0.00047s



Query results obtained from the cache

Before: 0.03664s | After: 0.03672s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00069s



Query #8
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_sessions constPRIMARYPRIMARY96const1100.00 

Affected rows: 1 | Before: 0.03782s | After: 0.03882s | Elapsed: 0.00100s



Query #9
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_id,session_fidsession_time4 110.45Using index condition; Using where

Before: 0.03982s | After: 0.04050s | Elapsed: 0.00068s



Query #10
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEs rangesession_time,session_user_id,session_fidsession_time4 110.45Using index condition; Using where

Before: 0.04119s | After: 0.04183s | Elapsed: 0.00064s



Query #11
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARYPRIMARY4const1100.00 

Before: 0.04262s | After: 0.04309s | Elapsed: 0.00047s



Query results obtained from the cache

Before: 0.04416s | After: 0.04423s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00041s



Query results obtained from the cache

Before: 0.04612s | After: 0.04627s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.00089s



Query #14
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt rangePRIMARY,forum_id,forum_id_type,last_post_time,fid_time_moved,topic_visibility,forum_vis_last,latest_topics,topic_priorityforum_id_type4 55100.00Using index condition; Using temporary; Using filesort
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_last_poster_id1100.00 
1SIMPLEuf eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_poster1100.00 
1SIMPLEf eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.t.forum_id1100.00 
1SIMPLEslp rangesession_time,session_user_idsession_time4 11100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.05155s | After: 0.05390s | Elapsed: 0.00235s



Query #15
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt refforum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicsforum_id3const120.00Using index condition; Using where; Using filesort

Before: 0.05520s | After: 0.05579s | Elapsed: 0.00058s



Query #16
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt constPRIMARYPRIMARY4const1100.00 
1SIMPLEu constPRIMARYPRIMARY4const1100.00 
1SIMPLEuf constPRIMARYPRIMARY4const1100.00 
1SIMPLEslp refsession_time,session_user_idsession_user_id4const12100.00Using where

Before: 0.05690s | After: 0.05793s | Elapsed: 0.00104s



Query #17
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLE         no matching row in const table

Before: 0.05942s | After: 0.05997s | Elapsed: 0.00055s



Query #18
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_topics constPRIMARYPRIMARY4const1100.00 

Before: 0.06062s | After: 0.06095s | Elapsed: 0.00033s



Query #19
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.06240s | After: 0.06268s | Elapsed: 0.00028s



Query #20
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_posts constPRIMARYPRIMARY4const1100.00 

Before: 0.06308s | After: 0.06336s | Elapsed: 0.00029s



Query #21
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums constPRIMARYPRIMARY3const1100.00 

Before: 0.06382s | After: 0.06407s | Elapsed: 0.00025s



Query #22
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEtt refidx_topic,idx_tagidx_topic3const1100.00 
1SIMPLEt eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.tt.tag_id1100.00 

Before: 0.06476s | After: 0.06507s | Elapsed: 0.00031s



Query #23
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums ALL    64100.00Using filesort

Before: 0.06664s | After: 0.06910s | Elapsed: 0.00245s



Query #24
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_forums indexPRIMARYforum_lastpost_id4 64100.00Using where; Using index

Before: 0.07062s | After: 0.07127s | Elapsed: 0.00065s



Query #25
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt indexforum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicslast_post_time4 570.05Using where
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_last_poster_id1100.00 
1SIMPLEf eq_refPRIMARYPRIMARY3db0rm_app_phpbb_2.t.forum_id1100.00 

Before: 0.07420s | After: 0.07646s | Elapsed: 0.00225s