Home > Q&A > body text
PHP中文网2017-04-17 16:44:31
// acc_id 加索引 SELECT accinfo_id FROM acc_accinfo acc WHERE acc.`is_delete` = 1 AND acc_id NOT in ( SELECT acc_id FROM acc_circulate_setting where area_id = 1 AND is_delete = 1 ); // 或者分2步查
阿神2017-04-17 16:44:31
Is the accinfo_id of acc_accinfo not indexed