按 Ctrl+Enter 键执行查询按 Enter 执行查询
崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: hmis 查询时间: 在当前会话期间
SELECT * FROM `batchdetails`说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 620 k | 882.2 k | 77.15 |
show fields | 60,326 | 85.9 k | 7.51 |
show keys | 59,969 | 85.4 k | 7.46 |
show create table | 25,309 | 36 k | 3.15 |
change db | 10,900 | 15.5 k | 1.36 |
show tables | 8,090 | 11.5 k | 1.01 |
set option | 6,550 | 9,323.8 | 0.82 |
flush | 3,272 | 4,657.7 | 0.41 |
insert | 2,028 | 2,886.8 | 0.25 |
delete | 2,028 | 2,886.8 | 0.25 |
show variables | 1,212 | 1,725.3 | 0.15 |
show slave status | 986 | 1,403.6 | 0.12 |
show master status | 966 | 1,375.1 | 0.12 |
show table status | 608 | 865.5 | 0.08 |
show grants | 507 | 721.7 | 0.06 |
replace | 475 | 676.2 | 0.06 |
show binlogs | 236 | 335.9 | 0.03 |
show create proc | 46 | 65.5 | 0.01 |
show storage engines | 36 | 51.2 | <0.01 |
show status | 25 | 35.6 | <0.01 |
show plugins | 24 | 34.2 | <0.01 |
update | 11 | 15.7 | <0.01 |