--------------------------------------------------------------- [ 2020-03-24T18:39:26+08:00 ] 127.0.0.1 GET / [ info ] 127.0.0.1:8012/ [运行时间：0.358157s][吞吐率：2.79req/s] [内存消耗：2,785.06kb] [文件加载：44] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8004/home/index/index.html?token=f8018676ac2a2f4e49ff7969a291ea1d', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2020-03-24T18:39:27+08:00 ] 127.0.0.1 GET /?token=f8018676ac2a2f4e49ff7969a291ea1d [ info ] 127.0.0.1:8012/?token=f8018676ac2a2f4e49ff7969a291ea1d [运行时间：0.301182s][吞吐率：3.32req/s] [内存消耗：2,965.63kb] [文件加载：49] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8004/home/index/index.html?token=f8018676ac2a2f4e49ff7969a291ea1d', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( 'token' => 'f8018676ac2a2f4e49ff7969a291ea1d', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2020-03-24T18:39:27+08:00 ] 127.0.0.1 GET /admin/index/index.html [ info ] 127.0.0.1:8012/admin/index/index.html [运行时间：0.417209s][吞吐率：2.40req/s] [内存消耗：4,953.11kb] [文件加载：58] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8004/home/index/index.html?token=f8018676ac2a2f4e49ff7969a291ea1d', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Index->index[ D:\wwwroot\stumange\application\admin\controller\Index.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\index\index.html [ array ( 0 => 'sysmodule', 1 => 'admin_user', 2 => 'super', 3 => 'menu_list', 4 => 'title', 5 => 'con_str', 6 => 'skin', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.014568s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.006878s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.006974s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.010771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007538s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000788s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_son` = 7 [ RunTime:0.001015s ] [ sql ] [ SQL ] SELECT * FROM `bp_roles` WHERE `rs_id` = 2 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_id` IN (161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692) [ RunTime:0.001790s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007411s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1729 LIMIT 1 [ RunTime:0.000523s ] --------------------------------------------------------------- [ 2020-03-24T18:39:28+08:00 ] 127.0.0.1 GET /admin/schoolinformation/xueji.html [ info ] 127.0.0.1:8012/admin/schoolinformation/xueji.html [运行时间：0.642398s][吞吐率：1.56req/s] [内存消耗：5,437.01kb] [文件加载：60] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'schoolinformation', 2 => 'xueji', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8012/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Schoolinformation->xueji[ D:\wwwroot\stumange\application\admin\controller\Schoolinformation.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\schoolinformation\xueji.html [ array ( 0 => 'sysmodule', 1 => 'menu_list', 2 => 'admin_user', 3 => 'super', 4 => 'title', 5 => 'con_str', 6 => 'page', 7 => 'campus', 8 => 'glist', 9 => 'polity', 10 => 'idcardtype', 11 => 'school_status', 12 => 'list', 13 => 'name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.001272s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008234s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000335s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.006296s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.011538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007454s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_transferinfo` [ RunTime:0.024529s ] [ sql ] [ SQL ] SELECT `tr_uid` FROM `bp_sxd_transferinfo` WHERE ( tr_status = 1 ) [ RunTime:0.000385s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007172s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_admin` `a` LEFT JOIN `bp_sxd_student_info` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_bclass` `c` ON `a`.`cl_id`=`c`.`cl_id` LEFT JOIN `bp_grade` `d` ON `a`.`gd_id`=`d`.`gd_id` WHERE `a`.`ad_uid` NOT IN ('55') AND `a`.`rs_id` = 3 AND `b`.`is_del` = 0 LIMIT 1 [ RunTime:0.141024s ] [ sql ] [ SQL ] SELECT `a`.`ad_uid`,`a`.`ad_num`,`a`.`ad_sname`,`c`.`cl_name`,`a`.`ad_sex`,`a`.`ad_identify`,`b`.`s_mingzu`,`b`.`s_ruxuenianfen`,`d`.`gd_name` FROM `bp_admin` `a` LEFT JOIN `bp_sxd_student_info` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_bclass` `c` ON `a`.`cl_id`=`c`.`cl_id` LEFT JOIN `bp_grade` `d` ON `a`.`gd_id`=`d`.`gd_id` WHERE `a`.`ad_uid` NOT IN ('55') AND `a`.`rs_id` = 3 AND `b`.`is_del` = 0 LIMIT 0,10 [ RunTime:0.023932s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.026996s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_grade` [ RunTime:0.009345s ] [ sql ] [ SQL ] SELECT * FROM `bp_grade` WHERE `gd_status` = 1 [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_transfer` [ RunTime:0.022564s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_transfer` [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2020-03-24T18:39:30+08:00 ] 127.0.0.1 GET /admin/leave/management [ info ] 127.0.0.1:8012/admin/leave/management [运行时间：0.409507s][吞吐率：2.44req/s] [内存消耗：5,350.42kb] [文件加载：60] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'management', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8012/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->management[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\leave\management.html [ array ( 0 => 'sysmodule', 1 => 'menu_list', 2 => 'admin_user', 3 => 'super', 4 => 'title', 5 => 'con_str', 6 => 'nianji', 7 => 'banji', 8 => 'xingming', 9 => 'p_leavetype', 10 => 'clist', 11 => 'glist', 12 => 'form_data', 13 => 'page', 14 => 'role_id', 15 => 'session_id', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000813s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007235s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.006904s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.011325s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007401s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.008655s ] [ sql ] [ SQL ] SELECT * FROM `bp_bclass` WHERE `cl_bid` = 1729 [ RunTime:0.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_process` [ RunTime:0.040118s ] [ sql ] [ SQL ] SELECT `id`,`grade` FROM `bp_sxd_leave_process` WHERE ( FIND_IN_SET(17,grade) ) AND `status` = 2 LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_auditor` [ RunTime:0.022712s ] [ sql ] [ SQL ] SELECT `auditor_level` FROM `bp_sxd_leave_auditor` WHERE `process_id` = 2 AND `auditor_id` = -1 LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_auditor` WHERE `auditor_id` = 1729 [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_form` [ RunTime:0.011960s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 1 [ RunTime:0.001080s ] [ sql ] [ SQL ] SELECT `a`.*,`b`.`ad_sname`,`c`.`gd_name`,`d`.`cl_name` FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 0,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_grade` [ RunTime:0.010320s ] [ sql ] [ SQL ] SELECT * FROM `bp_grade` WHERE `gd_status` = 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name` FROM `bp_bclass` WHERE `gd_id` = 0 [ RunTime:0.000469s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_record` [ RunTime:0.019830s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `create_id` = 1729 AND `form_id` = 47 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `create_id` = 1729 AND `form_id` = 46 LIMIT 1 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `create_id` = 1729 AND `form_id` = 41 LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `create_id` = 1729 AND `form_id` = 40 LIMIT 1 [ RunTime:0.002077s ] --------------------------------------------------------------- [ 2020-03-24T18:39:35+08:00 ] 127.0.0.1 GET /admin/leave/management?page=2 [ info ] 127.0.0.1:8012/admin/leave/management?page=2 [运行时间：0.269788s][吞吐率：3.71req/s] [内存消耗：5,311.75kb] [文件加载：60] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'management', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8012/admin/leave/management', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( 'page' => '2', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->management[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\leave\management.html [ array ( 0 => 'sysmodule', 1 => 'menu_list', 2 => 'admin_user', 3 => 'super', 4 => 'title', 5 => 'con_str', 6 => 'nianji', 7 => 'banji', 8 => 'xingming', 9 => 'p_leavetype', 10 => 'clist', 11 => 'glist', 12 => 'form_data', 13 => 'page', 14 => 'role_id', 15 => 'session_id', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000892s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.006562s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.009357s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.011960s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007569s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000823s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007076s ] [ sql ] [ SQL ] SELECT * FROM `bp_bclass` WHERE `cl_bid` = 1729 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_process` [ RunTime:0.007641s ] [ sql ] [ SQL ] SELECT `id`,`grade` FROM `bp_sxd_leave_process` WHERE ( FIND_IN_SET(17,grade) ) AND `status` = 2 LIMIT 1 [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_auditor` [ RunTime:0.007351s ] [ sql ] [ SQL ] SELECT `auditor_level` FROM `bp_sxd_leave_auditor` WHERE `process_id` = 2 AND `auditor_id` = -1 LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_auditor` WHERE `auditor_id` = 1729 [ RunTime:0.000507s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_form` [ RunTime:0.008000s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] SELECT `a`.*,`b`.`ad_sname`,`c`.`gd_name`,`d`.`cl_name` FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 10,10 [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_grade` [ RunTime:0.007262s ] [ sql ] [ SQL ] SELECT * FROM `bp_grade` WHERE `gd_status` = 1 [ RunTime:0.000579s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name` FROM `bp_bclass` WHERE `gd_id` = 0 [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_record` [ RunTime:0.007564s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `create_id` = 1729 AND `form_id` = 38 LIMIT 1 [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2020-03-24T18:39:42+08:00 ] 127.0.0.1 POST /admin/leave/batchaudit.html [ info ] 127.0.0.1:8012/admin/leave/batchaudit.html [运行时间：0.315759s][吞吐率：3.17req/s] [内存消耗：5,114.02kb] [文件加载：59] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'batchaudit', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'content-length' => '42', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://127.0.0.1:8012', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'referer' => 'http://127.0.0.1:8012/admin/leave/management?page=2', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( 'check_data' => array ( 0 => '38', ), 'sh_status' => '1', 'sh_remark' => '', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->batchAudit[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ CACHE ] INIT File [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000835s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.006772s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.006671s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.010845s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.006979s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_form` [ RunTime:0.006851s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_form` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_record` [ RunTime:0.007263s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_record` WHERE `form_id` = 38 AND `create_id` = 1729 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_form` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000566s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_auditor` [ RunTime:0.006575s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_auditor` `a` LEFT JOIN `bp_sxd_leave_form` `b` ON `a`.`process_id`=`b`.`id` WHERE `a`.`auditor_id` = 1729 AND `a`.`process_id` = 2 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007093s ] [ sql ] [ SQL ] SELECT * FROM `bp_bclass` WHERE `cl_bid` = 1729 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_auditor` `a` LEFT JOIN `bp_sxd_leave_form` `b` ON `a`.`process_id`=`b`.`process_id` WHERE `a`.`auditor_id` = -1 AND `a`.`process_id` = 2 AND `b`.`bclass_id` = 93 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] UPDATE `bp_sxd_leave_form` SET `leave_status`=1,`check_status`=2 WHERE `id` = 38 [ RunTime:0.000661s ] [ sql ] [ SQL ] INSERT INTO `bp_sxd_leave_record` (`form_id` , `status` , `remark` , `create_time` , `create_id`) VALUES (38 , 1 , '' , 1585046382 , 1729) [ RunTime:0.010545s ] --------------------------------------------------------------- [ 2020-03-24T18:39:44+08:00 ] 127.0.0.1 GET /admin/leave/management?page=2 [ info ] 127.0.0.1:8012/admin/leave/management?page=2 [运行时间：0.313978s][吞吐率：3.18req/s] [内存消耗：5,298.99kb] [文件加载：60] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'management', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'cache-control' => 'max-age=0', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8012/admin/leave/management?page=2', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( 'page' => '2', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->management[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\leave\management.html [ array ( 0 => 'sysmodule', 1 => 'menu_list', 2 => 'admin_user', 3 => 'super', 4 => 'title', 5 => 'con_str', 6 => 'nianji', 7 => 'banji', 8 => 'xingming', 9 => 'p_leavetype', 10 => 'clist', 11 => 'glist', 12 => 'form_data', 13 => 'page', 14 => 'role_id', 15 => 'session_id', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000839s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008841s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007428s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.014698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007126s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000913s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007056s ] [ sql ] [ SQL ] SELECT * FROM `bp_bclass` WHERE `cl_bid` = 1729 [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_process` [ RunTime:0.007416s ] [ sql ] [ SQL ] SELECT `id`,`grade` FROM `bp_sxd_leave_process` WHERE ( FIND_IN_SET(17,grade) ) AND `status` = 2 LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_auditor` [ RunTime:0.006654s ] [ sql ] [ SQL ] SELECT `auditor_level` FROM `bp_sxd_leave_auditor` WHERE `process_id` = 2 AND `auditor_id` = -1 LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `bp_sxd_leave_auditor` WHERE `auditor_id` = 1729 [ RunTime:0.000502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_form` [ RunTime:0.006789s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] SELECT `a`.*,`b`.`ad_sname`,`c`.`gd_name`,`d`.`cl_name` FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` WHERE ( (a.grade_id=7 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=17 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=18 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=19 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=20 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=21 AND a.check_status >=1 AND a.bclass_id =93) OR(a.grade_id=22 AND a.check_status >=1 AND a.bclass_id =93) ) AND `a`.`grade_id` IN ('7','17','18','19','20','21','22') LIMIT 10,10 [ RunTime:0.000751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_grade` [ RunTime:0.007452s ] [ sql ] [ SQL ] SELECT * FROM `bp_grade` WHERE `gd_status` = 1 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name` FROM `bp_bclass` WHERE `gd_id` = 0 [ RunTime:0.000518s ] --------------------------------------------------------------- [ 2020-03-24T19:25:44+08:00 ] 127.0.0.1 GET /admin/leave/statistics [ info ] 127.0.0.1:8012/admin/leave/statistics [运行时间：0.348271s][吞吐率：2.87req/s] [内存消耗：5,504.16kb] [文件加载：62] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'statistics', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://127.0.0.1:8012/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->statistics[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ VIEW ] D:\wwwroot\stumange\public/../application/admin\view\leave\statistics.html [ array ( 0 => 'sysmodule', 1 => 'menu_list', 2 => 'admin_user', 3 => 'super', 4 => 'title', 5 => 'con_str', 6 => 'count_day', 7 => 'page', 8 => 'form_data', 9 => 'p_leavetype', 10 => 'bclass_val', 11 => 'gc_id', 12 => 'name', 13 => 'datatime', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000875s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007302s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.010343s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.014103s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007065s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000924s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sxd_leave_form` [ RunTime:0.007138s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` LIMIT 1 [ RunTime:0.000570s ] [ sql ] [ SQL ] SELECT `a`.*,`b`.`ad_sname`,`c`.`gd_name`,`d`.`cl_name` FROM `bp_sxd_leave_form` `a` LEFT JOIN `bp_admin` `b` ON `a`.`ad_uid`=`b`.`ad_uid` LEFT JOIN `bp_grade` `c` ON `c`.`gd_id`=`a`.`grade_id` LEFT JOIN `bp_bclass` `d` ON `d`.`cl_id`=`a`.`bclass_id` LIMIT 0,10 [ RunTime:0.000688s ] [ sql ] [ SQL ] SELECT SUM(leave_days) AS tp_sum FROM `bp_sxd_leave_form` LIMIT 1 [ RunTime:0.025530s ] --------------------------------------------------------------- [ 2020-03-24T19:25:45+08:00 ] 127.0.0.1 POST /admin/leave/getgradeclass.html [ info ] 127.0.0.1:8012/admin/leave/getgradeclass.html [运行时间：0.290996s][吞吐率：3.44req/s] [内存消耗：5,189.45kb] [文件加载：60] [ info ] [ LANG ] D:\wwwroot\stumange\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'leave', 2 => 'getgradeclass', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8012', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://127.0.0.1:8012', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 'referer' => 'http://127.0.0.1:8012/admin/leave/statistics', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=vgf9f0hei692dkq96tflvpd8k1; token=f8018676ac2a2f4e49ff7969a291ea1d; prep=false', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\Leave->getGradeClass[ D:\wwwroot\stumange\application\admin\controller\Leave.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000687s ] mysql:host=127.0.0.1;port=3306;dbname=bpf;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007474s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 2 [ RunTime:0.000448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.010058s ] [ sql ] [ SQL ] SELECT `module_id` FROM `bp_auth` WHERE `au_id` IN (1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,101,29,30,31,32,33,34,35,98,91,104,36,37,38,39,40,41,42,93,94,99,100,43,44,45,46,2,47,48,49,50,51,53,54,105,55,56,57,58,3,59,60,61,62,63,1006,1007,1008,1009,4,64,65,66,67,68,69,70,71,72,73,74,95,96,97,81,86,87,88,89,509,535,536,537,538,539,540,541,542,543,544,545,546,547,976,977,978,979,980,981,982,983,984,985,986,987,988,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,106,110,111,112,129,113,130,131,132,133,114,134,135,136,137,138,139,115,140,141,142,143,107,116,144,145,146,227,117,147,148,149,150,228,229,1032,118,151,152,153,154,155,156,157,230,108,120,121,122,123,124,125,126,109,127,158,128,159,161,168,170,574,623,626,627,628,629,631,632,633,634,635,636,637,638,162,179,639,180,640,181,641,642,643,182,644,645,646,647,648,183,649,650,651,652,653,654,655,656,163,209,575,576,577,164,386,578,579,580,581,582,583,584,387,585,586,587,588,589,590,591,388,592,593,594,595,596,597,598,599,389,600,601,602,603,604,605,606,607,608,609,165,385,610,611,612,613,614,615,166,548,616,617,618,619,620,167,549,550,171,231,555,556,232,554,557,172,377,173,378,558,559,560,379,561,562,563,174,380,564,565,175,381,621,382,566,567,568,569,630,176,383,570,571,572,573,622,624,625,684,685,688,689,690,691,686,693,694,695,687,692,184,190,668,191,192,193,210,669,185,194,211,212,213,672,673,195,214,215,657,186,196,670,197,225,658,659,671,198,199,660,661,662,663,187,200,674,201,675,202,664,665,188,203,204,205,206,207,208,189,226,666,667,676,678,679,680,681,682,683,886,888,216,217,218,219,220,222,224,696,697,698,699,700,701,233,242,243,245,290,293,294,296,297,298,246,302,300,307,310,311,299,301,234,247,312,313,235,252,253,254,255,315,314,236,260,316,317,318,261,320,321,322,237,256,324,325,327,257,328,329,330,258,332,333,334,259,336,337,338,238,248,340,341,342,343,344,249,345,346,347,348,349,250,350,351,352,353,354,251,355,356,357,358,359,239,267,268,269,270,271,360,361,362,363,272,364,365,273,367,368,274,370,371,275,276,277,278,282,283,279,280,373,281,374,240,284,375,241,264,828,834,835,832,833,829,831,830,814,827,826,822,825,824,823,815,821,820,819,818,817,816,808,811,813,812,810,809,789,799,805,804,803,800,802,801,798,795,797,796,790,794,793,792,791,777,783,788,787,786,785,784,779,782,781,780,778,760,771,776,773,775,774,772,764,767,770,769,768,766,765,1087,761,763,762,750,758,759,1081,1082,1078,1079,1080,756,757,1083,1084,1085,1086,751,752,755,754,753,890,896,897,898,891,899,900,901,892,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,893,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,894,961,962,963,964,965,966,967,968,895,969,970,971,972,973,974,975,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005) GROUP BY `module_id` [ RunTime:0.013581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.008361s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_id` IN (2,3,4,5,7,8,9,10,11,25,31) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_grade` [ RunTime:0.008910s ] [ sql ] [ SQL ] SELECT `gd_id`,`gd_name` FROM `bp_grade` WHERE `gd_status` = 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.009856s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` IN (7,17,18,19,20,21,22) [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 7 [ RunTime:0.001600s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 17 [ RunTime:0.001137s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 18 [ RunTime:0.001334s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 19 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 20 [ RunTime:0.000341s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 21 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT `cl_id`,`cl_name`,`gd_id` FROM `bp_bclass` WHERE `gd_id` = 22 [ RunTime:0.000449s ]