PaiShouBa

 SELECT SN FROM book_table WHERE ParkID = 1006 AND Plate = '江A12345' AND StartTime <= NOW() AND EndTime >= NOW()AND `Status` = '已确认' LIMIT 1;


select * from book_table;


OPTIMIZE TABLE book_table;
show table status like 'book_table';

show global status like '%buffer_pool%';


set global innodb_buffer_pool_size=8589934592;
show variables like '%buffer_pool%';

show variables like 'default_storage_engine';


select ifnull(SN,0),ExpiredTime,CarType,Permission,GroupID   from whitelist_table where Plate='江A12345' and (  (StartTime<=NOW() and NOW()<=ExpiredTime and CarType <> '单位车') or (CarType='单位车' and Balance >=300)) LIMIT 1;





select ifnull(id,0) from p_preregistration where Plate='江A12345' and  start_time<=NOW() and end_time >= NOW() LIMIT 1


select digest_text,sum_timer_wait/1000000000 total_time_ms,sum_cost,execution_count,first_seen,last_seen from `performance_schema`.events_statements_summary_by_digest limit 1;


select * from `performance_schema`.events_statements_summary_by_digest limit 10

select * from `performance_schema`.events_statements_summary_by_digest  where digest_text like '%吉AF13989%' limit 1;