[ SQL ] SHOW COLUMNS FROM `cmf_ktp_userinfo` [ RunTime:0.000779s ]
[ 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,59,60,62,66,73,79,80,85,90,95,101,104,105,106,107,108,109,110,111,112,114,115,116,123,129,131,136,138,140,144,145,147,151,152,156,159,161,162,163,167,171,174,175,177,183,184,185,189,199,214,235,236,237,238,239,240,242,243,244,245,246,247,248,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,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) [ RunTime:0.001425s ]
[ 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,59,60,62,66,73,79,80,85,90,95,101,104,105,106,107,108,109,110,111,112,114,115,116,123,129,131,136,138,140,144,145,147,151,152,156,159,161,162,163,167,171,174,175,177,183,184,185,189,199,214,235,236,237,238,239,240,242,243,244,245,246,247,248,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,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) [ RunTime:0.001224s ]
[ 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,59,60,62,66,73,79,80,85,90,95,101,104,105,106,107,108,109,110,111,112,114,115,116,123,129,131,136,138,140,144,145,147,151,152,156,159,161,162,163,167,171,174,175,177,183,184,185,189,199,214,235,236,237,238,239,240,242,243,244,245,246,247,248,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,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) ORDER BY `is_zuzhang` DESC,`art_nums` DESC LIMIT 40,20 [ RunTime:0.001261s ]