索引字段

SELECT
	b.id,
	pack_type AS packType,
	logistics_template AS logisticsTemplate,
	is_print AS isPrint,
	print_user AS printUser,
	DATE_FORMAT(
		create_tm,
		'%Y-%m-%d %H:%i:%s'
	) AS createTm,
	is_check AS isCheck,
	is_cancel AS isCancel,
	print_index AS printIndex,
	boxCode AS boxCode,
	shipmentPort AS shipmentPort,
	IFNULL(uploadState, 0) AS uploadState
FROM
	(
		SELECT
			id
		FROM
			tb_order
		WHERE
			(
				uploadState = '1'
				AND is_cancel = '0'
				AND order_status = '0'
			)
		ORDER BY
			modify_tm DESC
		LIMIT 0,
		100
	) tb_order2
LEFT JOIN tb_order b ON tb_order2.id = b.id