SQL Report


Page generated in 0.2019 seconds with 117 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.05766s | Time spent on PHP: 0.14422s



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

Before: 0.00478s | After: 0.00551s | Elapsed: 0.00073s



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

Before: 0.01836s | After: 0.01987s | Elapsed: 0.00151s



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

Before: 0.02079s | After: 0.02144s | Elapsed: 0.00065s



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

Affected rows: 1 | Before: 0.02251s | After: 0.02355s | Elapsed: 0.00104s



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

Before: 0.02487s | After: 0.02562s | Elapsed: 0.00075s



Query results obtained from the cache

Before: 0.03200s | After: 0.03207s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00045s



Query results obtained from the cache

Before: 0.06456s | After: 0.06464s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00056s



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

Affected rows: 1 | Before: 0.06557s | After: 0.06650s | Elapsed: 0.00093s



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

Before: 0.06735s | After: 0.06786s | Elapsed: 0.00052s



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

Before: 0.06850s | After: 0.06899s | Elapsed: 0.00049s



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

Before: 0.06968s | After: 0.07012s | Elapsed: 0.00044s



Query results obtained from the cache

Before: 0.07118s | After: 0.07125s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00044s



Query results obtained from the cache

Before: 0.07298s | After: 0.07310s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00079s



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 16100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.07759s | After: 0.08086s | Elapsed: 0.00327s



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

Before: 0.08195s | After: 0.08267s | Elapsed: 0.00072s



Query #16
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_priorityPRIMARY4 25100.00Using where; 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 
1SIMPLEslp rangesession_time,session_user_idsession_time4 16100.00Using where; Using join buffer (Block Nested Loop)

Before: 0.08432s | After: 0.08708s | Elapsed: 0.00276s



Query #17
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEt rangePRIMARYPRIMARY4 2590.00Using where
1SIMPLEu eq_refPRIMARYPRIMARY4db0rm_app_phpbb_2.t.topic_attr_user1100.00Using where

Before: 0.08871s | After: 0.08932s | Elapsed: 0.00061s



Query #18
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEewaa_topics rangePRIMARYPRIMARY4 25100.00Using where

Before: 0.08999s | After: 0.09057s | Elapsed: 0.00058s



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

Before: 0.09201s | After: 0.09230s | Elapsed: 0.00029s



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

Before: 0.09279s | After: 0.09313s | Elapsed: 0.00034s



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

Before: 0.09369s | After: 0.09395s | Elapsed: 0.00026s



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.09472s | After: 0.09525s | Elapsed: 0.00053s



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

Before: 0.09626s | After: 0.09659s | Elapsed: 0.00033s



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

Before: 0.09714s | After: 0.09742s | Elapsed: 0.00028s



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

Before: 0.09788s | After: 0.09817s | Elapsed: 0.00029s



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

Before: 0.09871s | After: 0.09904s | Elapsed: 0.00033s



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

Before: 0.10001s | After: 0.10027s | Elapsed: 0.00026s



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

Before: 0.10065s | After: 0.10092s | Elapsed: 0.00026s



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

Before: 0.10148s | After: 0.10191s | Elapsed: 0.00042s



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

Before: 0.10271s | After: 0.10311s | Elapsed: 0.00040s



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

Before: 0.10402s | After: 0.10429s | Elapsed: 0.00027s



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

Before: 0.10474s | After: 0.10509s | Elapsed: 0.00035s



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

Before: 0.10551s | After: 0.10585s | Elapsed: 0.00034s



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

Before: 0.10633s | After: 0.10676s | Elapsed: 0.00042s



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

Before: 0.10769s | After: 0.10799s | Elapsed: 0.00031s



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

Before: 0.10843s | After: 0.10890s | Elapsed: 0.00047s



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

Before: 0.10934s | After: 0.10975s | Elapsed: 0.00041s



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

Before: 0.11033s | After: 0.11072s | Elapsed: 0.00039s



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

Before: 0.11168s | After: 0.11206s | Elapsed: 0.00038s



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

Before: 0.11244s | After: 0.11270s | Elapsed: 0.00026s



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

Before: 0.11315s | After: 0.11348s | Elapsed: 0.00032s



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

Before: 0.11398s | After: 0.11447s | Elapsed: 0.00048s



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

Before: 0.11546s | After: 0.11575s | Elapsed: 0.00028s



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

Before: 0.11622s | After: 0.11673s | Elapsed: 0.00051s



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

Before: 0.11728s | After: 0.11769s | Elapsed: 0.00041s



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

Before: 0.11819s | After: 0.11850s | Elapsed: 0.00032s



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

Before: 0.11946s | After: 0.11982s | Elapsed: 0.00036s



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

Before: 0.12030s | After: 0.12071s | Elapsed: 0.00041s



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

Before: 0.12133s | After: 0.12184s | Elapsed: 0.00051s



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

Before: 0.12252s | After: 0.12292s | Elapsed: 0.00040s



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

Before: 0.12371s | After: 0.12409s | Elapsed: 0.00038s



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

Before: 0.12452s | After: 0.12488s | Elapsed: 0.00036s



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

Before: 0.12532s | After: 0.12562s | Elapsed: 0.00030s



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

Before: 0.12611s | After: 0.12655s | Elapsed: 0.00044s



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

Before: 0.12754s | After: 0.12790s | Elapsed: 0.00036s



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

Before: 0.12840s | After: 0.12880s | Elapsed: 0.00040s



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

Before: 0.12926s | After: 0.12968s | Elapsed: 0.00041s



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

Before: 0.13023s | After: 0.13067s | Elapsed: 0.00044s



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

Before: 0.13139s | After: 0.13164s | Elapsed: 0.00025s



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

Before: 0.13206s | After: 0.13230s | Elapsed: 0.00025s



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

Before: 0.13274s | After: 0.13302s | Elapsed: 0.00028s



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

Before: 0.13352s | After: 0.13392s | Elapsed: 0.00040s



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

Before: 0.13473s | After: 0.13522s | Elapsed: 0.00048s



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

Before: 0.13565s | After: 0.13602s | Elapsed: 0.00037s



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

Before: 0.13638s | After: 0.13663s | Elapsed: 0.00024s



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

Before: 0.13734s | After: 0.13774s | Elapsed: 0.00040s



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

Before: 0.13847s | After: 0.13877s | Elapsed: 0.00031s



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

Before: 0.13918s | After: 0.13945s | Elapsed: 0.00028s



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

Before: 0.13979s | After: 0.14004s | Elapsed: 0.00025s



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

Before: 0.14053s | After: 0.14094s | Elapsed: 0.00041s



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

Before: 0.14178s | After: 0.14206s | Elapsed: 0.00028s



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

Before: 0.14247s | After: 0.14282s | Elapsed: 0.00034s



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

Before: 0.14323s | After: 0.14362s | Elapsed: 0.00039s



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

Before: 0.14410s | After: 0.14457s | Elapsed: 0.00047s



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

Before: 0.14577s | After: 0.14620s | Elapsed: 0.00043s



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

Before: 0.14672s | After: 0.14700s | Elapsed: 0.00028s



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

Before: 0.14740s | After: 0.14777s | Elapsed: 0.00037s



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

Before: 0.14827s | After: 0.14855s | Elapsed: 0.00028s



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

Before: 0.14930s | After: 0.14969s | Elapsed: 0.00039s



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

Before: 0.15009s | After: 0.15037s | Elapsed: 0.00028s



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

Before: 0.15076s | After: 0.15102s | Elapsed: 0.00026s



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

Before: 0.15160s | After: 0.15195s | Elapsed: 0.00035s



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

Before: 0.15269s | After: 0.15296s | Elapsed: 0.00026s



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

Before: 0.15336s | After: 0.15380s | Elapsed: 0.00044s



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

Before: 0.15424s | After: 0.15451s | Elapsed: 0.00027s



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

Before: 0.15500s | After: 0.15537s | Elapsed: 0.00036s



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

Before: 0.15613s | After: 0.15643s | Elapsed: 0.00030s



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

Before: 0.15684s | After: 0.15719s | Elapsed: 0.00035s



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

Before: 0.15774s | After: 0.15814s | Elapsed: 0.00040s



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

Before: 0.15875s | After: 0.15917s | Elapsed: 0.00042s



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

Before: 0.15993s | After: 0.16021s | Elapsed: 0.00028s



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

Before: 0.16063s | After: 0.16099s | Elapsed: 0.00037s



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

Before: 0.16139s | After: 0.16175s | Elapsed: 0.00036s



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

Before: 0.16243s | After: 0.16290s | Elapsed: 0.00046s



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

Before: 0.16389s | After: 0.16430s | Elapsed: 0.00041s



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

Before: 0.16474s | After: 0.16498s | Elapsed: 0.00024s



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

Before: 0.16539s | After: 0.16576s | Elapsed: 0.00037s



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

Before: 0.16637s | After: 0.16673s | Elapsed: 0.00036s



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

Before: 0.16749s | After: 0.16780s | Elapsed: 0.00031s



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

Before: 0.16815s | After: 0.16854s | Elapsed: 0.00039s



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

Before: 0.16905s | After: 0.16939s | Elapsed: 0.00034s



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

Before: 0.16991s | After: 0.17031s | Elapsed: 0.00040s



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

Before: 0.17117s | After: 0.17160s | Elapsed: 0.00044s



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

Before: 0.17205s | After: 0.17240s | Elapsed: 0.00036s



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

Before: 0.17285s | After: 0.17310s | Elapsed: 0.00025s



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

Before: 0.17381s | After: 0.17422s | Elapsed: 0.00041s



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

Before: 0.17500s | After: 0.17527s | Elapsed: 0.00027s



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

Before: 0.17578s | After: 0.17607s | Elapsed: 0.00029s



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

Before: 0.17654s | After: 0.17696s | Elapsed: 0.00042s



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

Before: 0.17750s | After: 0.17791s | Elapsed: 0.00041s



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

Before: 0.17891s | After: 0.17929s | Elapsed: 0.00038s



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

Before: 0.17973s | After: 0.18011s | Elapsed: 0.00038s



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

Before: 0.18059s | After: 0.18087s | Elapsed: 0.00028s



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

Before: 0.18138s | After: 0.18184s | Elapsed: 0.00046s



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

Before: 0.18273s | After: 0.18311s | Elapsed: 0.00039s



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

Before: 0.18358s | After: 0.18403s | Elapsed: 0.00045s



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

Before: 0.18456s | After: 0.18491s | Elapsed: 0.00035s



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

Before: 0.18550s | After: 0.18602s | Elapsed: 0.00052s



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

Before: 0.18770s | After: 0.19081s | Elapsed: 0.00311s



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

Before: 0.19265s | After: 0.19346s | Elapsed: 0.00081s



Query #121
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.19796s | After: 0.20084s | Elapsed: 0.00288s