QUERY PLAN
Group (cost=195.43..201.68 rows=227 width=52)
Group Key: u.pinyin1, u.namecut1, u.pinyin2, u.namecut2, u.pinyin3, u.namecut3, u.pinyin4, u.namecut4, rvr.user_id, u.name
-> Sort (cost=195.43..196.00 rows=227 width=44)
Sort Key: u.pinyin1 NULLS FIRST, u.namecut1 NULLS FIRST, u.pinyin2 NULLS FIRST, u.namecut2 NULLS FIRST, u.pinyin3 NULLS FIRST, u.namecut3 NULLS FIRST, u.pinyin4 NULLS FIRST, u.namecut4 NULLS FIRST, rvr.user_id, u.name
-> Hash Left Join (cost=18.24..186.55 rows=227 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_punch_repair_verify_rels rvr (cost=0.00..167.69 rows=227 width=4)
Filter: (punch_repair_id = ANY ('{25,11,26,14,16,3,27,15,5,17,18,6,42,19,7,4,28,20,29,21,10,30,22,13,12,53,23,40,46,24,39,38,56,33,41,35,34,57,37,45,58,44,49,36,48,52,43,55,51,54,47,50,59,60,61,62,63,64,65,99,94,93,98,92,80,91,79,90,78,89,77,104,76,88,75,87,86,74,85,113,84,73,83,82,72,81,71,114,70,69,68,67,115,66,97,103,96,102,116,108,101,107,95,112,106,111,100,110,105,109,117,118,119,120,121,122,123,124,125,128,152,127,126,129,151,150,149,162,148,177,146,161,145,140,160,144,166,159,172,158,167,139,157,138,143,147,156,137,136,142,135,170,134,141,133,132,168,131,130,155,154,183,153,163,176,164,169,171,173,179,178,174,181,175,187,180,184,185,186,188,189,190,191,192,193,194,236,221,196,210,195,197,230,211,198,222,212,199,201,241,200,223,215,214,231,207,213,206,205,224,204,203,216,202,208,237,225,209,217,232,218,226,219,245,220,227,233,228,238,229,234,242,235,239,248,243,240,246,250,244,249,247,252,251,253,254,255,256,257,258,259,260,261,282,263,281,262,280,288,266,279,278,269,277,268,267,276,300,270,275,265,264,274,295,271,273,272,310,304,299,283,284,298,285,286,297,303,287,309,320,302,294,301,315,307,296,308,293,305,292,291,290,289,313,317,312,306,311,316,314,321,318,319,322,323,324,325,326,327,328,348,358,353,339,359,338,352,337,336,351,335,334,346,333,332,347,331,330,329,360,345,341,344,340,361,362,343,342,350,349,363,355,356,364,354,357,365,366,368}'::integer[]))
-> Hash (cost=16.44..16.44 rows=144 width=44)
-> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=44)