Press Ctrl+Enter to execute queryPress Enter to execute query
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: mysql Queried time: During current session
SELECT * FROM `collectionrulesitems`Statements | # | ø per hour | % |
---|---|---|---|
select | 20,718 k | 83.1 k | 71.25 |
delete | 1,643 k | 6,589.3 | 5.65 |
show keys | 1,231 k | 4,938.5 | 4.23 |
show fields | 1,087 k | 4,359.6 | 3.74 |
insert | 823 k | 3,301.5 | 2.83 |
update | 822 k | 3,295.3 | 2.83 |
change db | 797 k | 3,197.7 | 2.74 |
show create table | 496 k | 1,987.9 | 1.70 |
set option | 414 k | 1,658.5 | 1.42 |
show tables | 397 k | 1,591.6 | 1.36 |
flush | 206 k | 824.2 | 0.71 |
show variables | 82,286 | 330 | 0.28 |
show slave status | 75,634 | 303.3 | 0.26 |
show master status | 74,701 | 299.6 | 0.26 |
show grants | 70,771 | 283.8 | 0.24 |
replace | 47,949 | 192.3 | 0.16 |
show create proc | 35,784 | 143.5 | 0.12 |
show binlogs | 25,185 | 101 | 0.09 |
show create func | 11,076 | 44.4 | 0.04 |
show plugins | 9,592 | 38.5 | 0.03 |
show storage engines | 6,397 | 25.7 | 0.02 |
call procedure | 1,201 | 4.8 | <0.01 |
show status | 1,060 | 4.3 | <0.01 |
stmt prepare | 895 | 3.6 | <0.01 |
stmt execute | 894 | 3.6 | <0.01 |
stmt close | 860 | 3.4 | <0.01 |
show table status | 807 | 3.2 | <0.01 |
show processlist | 152 | 0.6 | <0.01 |
drop table | 108 | 0.4 | <0.01 |
create temporary table | 108 | 0.4 | <0.01 |
insert select | 108 | 0.4 | <0.01 |