| Aggregate (cost=179.22..179.23 rows=1 width=8) |
| -> Unique (cost=179.15..179.21 rows=1 width=380) |
| -> Sort (cost=179.15..179.15 rows=1 width=380) |
| Sort Key: s.updated_at DESC, s.id, s.name, s.abbr, s.pinyin_shortcut, s.main_products, s.company_nature, s.website, s.established_at, s.capital, s.corp_rep, s.reg_address, s.telephone, s.fax, s.description, s.main_contact, s.created_by, s.created_at, s.working_address, s.capital_currency, s.payment_cycle, s.account_number |
| -> Group (cost=179.13..179.14 rows=1 width=380) |
| Group Key: s.id |
| -> Sort (cost=179.13..179.14 rows=1 width=380) |
| Sort Key: s.id |
| -> Hash Right Join (cost=37.31..179.12 rows=1 width=380) |
| Hash Cond: (c.supplier_id = s.id) |
| Filter: ((lower((s.name)::text) ~~ '%淘宝网%'::text) OR (s.pinyin_shortcut ~~ '%淘宝网%'::text) OR (lower(s.description) ~~ '%淘宝网%'::text) OR (lower((s.main_products)::text) ~~ '%淘宝网%'::text) OR (lower((c.name)::text) ~~ '%淘宝网%'::text)) |
| -> Seq Scan on tbl_contacts c (cost=0.00..138.24 rows=1348 width=13) |
| Filter: (supplier_id IS NOT NULL) |
| -> Hash (cost=29.36..29.36 rows=636 width=380) |
| -> Seq Scan on tbl_suppliers s (cost=0.00..29.36 rows=636 width=380) |