`smartschool3`.`dispatch_receive` `smartschool3`.`teacher_subjects` `smartschool3`.`feetype` `smartschool3`.`student_fees` `smartschool3`.`student_applyleave` `smartschool3`.`exam_group_class_batch_exam_subjects` `smartschool3`.`feemasters` `smartschool3`.`libarary_members` `smartschool3`.`fee_receipt_no` `smartschool3`.`student_fees_master`
Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 7,101 k | 110.3 k | 83.83 |
| show fields | 338 k | 5,254.1 | 3.99 |
| set option | 260 k | 4,033.2 | 3.07 |
| change db | 169 k | 2,625.8 | 2.00 |
| show variables | 167 k | 2,600.2 | 1.98 |
| show keys | 86,646 | 1,345.4 | 1.02 |
| show tables | 85,530 | 1,328.1 | 1.01 |
| show create table | 84,865 | 1,317.8 | 1.00 |
| show grants | 84,334 | 1,309.5 | 1.00 |
| show warnings | 83,594 | 1,298 | 0.99 |
| insert | 2,183 | 33.9 | 0.03 |
| stmt prepare | 1,409 | 21.9 | 0.02 |
| stmt execute | 1,409 | 21.9 | 0.02 |
| stmt close | 1,409 | 21.9 | 0.02 |
| begin | 1,123 | 17.4 | 0.01 |
| commit | 1,123 | 17.4 | 0.01 |
| replace | 1,002 | 15.6 | 0.01 |
| show storage engines | 114 | 1.8 | <0.01 |
| delete | 97 | 1.5 | <0.01 |
| show slave status | 38 | 0.6 | <0.01 |
| show binlogs | 38 | 0.6 | <0.01 |
| show master status | 36 | 0.6 | <0.01 |
| show table status | 30 | 0.5 | <0.01 |
| update | 13 | 0.2 | <0.01 |
| show status | 3 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
