[ SQL ] SHOW COLUMNS FROM `cmf_ktp_userinfo` [ RunTime:0.001517s ]
[ SQL ] SELECT `user_id` FROM `cmf_ktp_userinfo` WHERE `status` = 1 AND `province_id` IS NULL AND `city_id` IS NULL AND ( ktp_grade='市级' OR ktp_grade='省级' ) AND `user_id` IN (13,14,15,17,19,22,24,25,27,29,32,34,35,41,47,50,53,55,56,57,58,60,66,73,78,79,80,85,90,95,101,104,105,107,108,109,110,112,114,115,116,123,129,136,138,140,145,147,151,152,161,162,163,166,167,171,175,177,184,185,199,214,237,238,239,240,242,243,244,246,247,248,266,267,269,270,271,274,275,276,278,279,280,281,282,285,286,287,289,290,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,311,313,314,316,317,318,319,320,322,324,325,329,330,331,332,333,334,335,336,337,338,339,340,343,344,350,353,355,356,357,358,359,360,361,362,363,368,369,370,371,372,373,374,375,376,378,379,380,381,382,383,387,388,389,390,391,394,395,396,403,409,411,412,413,414,416,417,418,419,420,421,423,432,433,434,435,437,438,439,440,441,442,443) [ RunTime:0.001748s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_ktp_userinfo` WHERE `status` = 1 AND `province_id` IS NULL AND `city_id` IS NULL AND ( ktp_grade='市级' OR ktp_grade='省级' ) AND `user_id` IN (13,14,15,17,19,22,24,25,27,29,32,34,35,41,47,50,53,55,56,57,58,60,66,73,78,79,80,85,90,95,101,104,105,107,108,109,110,112,114,115,116,123,129,136,138,140,145,147,151,152,161,162,163,166,167,171,175,177,184,185,199,214,237,238,239,240,242,243,244,246,247,248,266,267,269,270,271,274,275,276,278,279,280,281,282,285,286,287,289,290,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,311,313,314,316,317,318,319,320,322,324,325,329,330,331,332,333,334,335,336,337,338,339,340,343,344,350,353,355,356,357,358,359,360,361,362,363,368,369,370,371,372,373,374,375,376,378,379,380,381,382,383,387,388,389,390,391,394,395,396,403,409,411,412,413,414,416,417,418,419,420,421,423,432,433,434,435,437,438,439,440,441,442,443) [ RunTime:0.001647s ]
[ SQL ] SELECT * FROM `cmf_ktp_userinfo` WHERE `status` = 1 AND `province_id` IS NULL AND `city_id` IS NULL AND ( ktp_grade='市级' OR ktp_grade='省级' ) AND `user_id` IN (13,14,15,17,19,22,24,25,27,29,32,34,35,41,47,50,53,55,56,57,58,60,66,73,78,79,80,85,90,95,101,104,105,107,108,109,110,112,114,115,116,123,129,136,138,140,145,147,151,152,161,162,163,166,167,171,175,177,184,185,199,214,237,238,239,240,242,243,244,246,247,248,266,267,269,270,271,274,275,276,278,279,280,281,282,285,286,287,289,290,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,311,313,314,316,317,318,319,320,322,324,325,329,330,331,332,333,334,335,336,337,338,339,340,343,344,350,353,355,356,357,358,359,360,361,362,363,368,369,370,371,372,373,374,375,376,378,379,380,381,382,383,387,388,389,390,391,394,395,396,403,409,411,412,413,414,416,417,418,419,420,421,423,432,433,434,435,437,438,439,440,441,442,443) ORDER BY `is_zuzhang` DESC,`art_nums` DESC LIMIT 0,20 [ RunTime:0.001673s ]