取长补短

Database igx-read:

5 queries executed

1. SET character_set_connection=utf8, character_set_results=utf8, character_set_client=utf8/* m.iguoxue.top in */ => 0.000149s

---

2. SELECT * FROM `igx_chengyu` WHERE id='25041'/* m.iguoxue.top in */ => 0.000263s

---

3. SELECT `id`,'' as `key`,`name` FROM `igx_chengyu` where 1 AND `name` like '扬长避短' ORDER BY quanpin asc LIMIT 0, 10/* m.iguoxue.top in */ => 0.000279s

---

4. SELECT `id`,'' as `key`,`name` FROM `igx_chengyu` where 1 AND `name` like 'ersiweifanyici' ORDER BY quanpin asc LIMIT 0, 10/* m.iguoxue.top in */ => 0.000244s

---

5. SELECT `id`,'' as `key`,`name` FROM `igx_chengyu` where 1 and `name` like '短%' ORDER BY quanpin asc LIMIT 0, 10/* m.iguoxue.top in */ => 0.000313s

---