Append (cost=0.00..233.12 rows=1387 width=121) |
-> Seq Scan on tbl_clients (cost=0.00..187.97 rows=918 width=121) |
Filter: ((NOT deleted) AND (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text))) |
-> Seq Scan on tbl_suppliers (cost=0.00..31.29 rows=469 width=120) |
Filter: (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text)) |