EXPLAIN SELECT saved.email FROM saved INNER JOIN finished ON finished.email = saved.email;
1 SIMPLE saved ref email email 383 func 1 Using where; Using index
EXPLAIN SELECTsaved.email FROM saved LEFT JOIN finished ON finished.emai
我将搜索功能栏添加到现有的应用程序中。现在,基于用户输入构建查询。它从平面表返回项,并根据表中的parentID和ID字段在前端构建对象的层次结构数组。select foo.* from ... AND foo.name like "%$potato%" AND ...我如何返回ID与土豆的parentID匹配<