技术文章路径记录

RabbitMQ
https://www.cnblogs.com/haixiang/p/10199754.html

RabbitMQ概念
https://www.cnblogs.com/williamjie/p/9481774.html

RabbitMQ消息队列：介绍
https://blog.csdn.net/anzhsoft/article/details/19563091

RabbitMQ实现延时队列的两种方式
https://blog.csdn.net/zhangyuxuan2/article/details/82986802

引入Elasticsearch的系统架构实战
cnblogs.com/skychen1218/p/15720522.html

SQL优化
https://www.cnblogs.com/chenhh-for-java/articles/13432301.html#%E4%BA%94%E3%80%81%E5%87%80%E5%8C%96%E5%BF%83%E7%81%B5%E5%B0%8F%E6%95%85%E4%BA%8B

IF判断
IF(status IS NULL, 0, 1) AS status

根据字段自定义排序
FIELD(status, 0, 10, 20, 1) ASC

sql索引

1）查看表索引

SHOW INDEX FROM bus_books

2)创建单列索引

CREATE INDEX book_index ON bus_books (Book)

2)创建组合索引

CREATE INDEX book_index ON bus_books (Book,BookDate)

3）删除指定索引

DROP INDEX book_index ON bus_books