ailian_f的博客

多张表联合查询，分页时，查询慢解决方案两张表联合查询，表1数据量7.5万，表2数据量400，联合查询时，当查询尾页的时候，查询时间是第一页的千倍注意：本方案不考虑排序问题最初的做法select * from goods as gleft join goods_class as c on c.class_code = g.class_code limit 0, 10调整后的方案select * from goods as gleft join goods_class as c on

explainselect count(base.code)from order_base_info as baseinner join order_logistics_info as logisticsInfo on logisticsInfo.order_code = base.codeleft join order_logistics_cost_info as costInfo on costInfo.order_code = base.codewhere base.logistics_st