| Group (cost=93.71..93.72 rows=1 width=150) |
| Group Key: c.id |
| -> Sort (cost=93.71..93.71 rows=1 width=150) |
| Sort Key: c.id |
| -> Nested Loop (cost=0.28..93.70 rows=1 width=150) |
| -> Seq Scan on tbl_contact_mobiles cm (cost=0.00..85.38 rows=1 width=4) |
| Filter: ((mobile)::text = '13333333333'::text) |
| -> Index Scan using tbl_contacts_pkey on tbl_contacts c (cost=0.28..8.31 rows=1 width=150) |
| Index Cond: (id = cm.contact_id) |
| Filter: ((client_id IS NULL) AND (client_id IS NOT NULL) AND (id <> 6126) AND (user_status <> 1)) |