use testdb;
select count(1) from qa_log;
select count(1) from qa_log where rest='ok' and status='200' and code='0';
select count(1) from qa_log where rest!='ok' or status!='200' or code!='0';


select count(1) from qa_log where status='200';
select count(1) from qa_log where status!='200';



select count(1) from qa_log where code='0';
select count(1) from qa_log where code!='0';