[ 2019-12-27T11:45:32+08:00 ] 127.0.0.1 127.0.0.1 GET / [ log ] 127.0.0.1:8023/ [运行时间：0.342783s][吞吐率：2.92req/s] [内存消耗：2,549.16kb] [文件加载：49] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-site', 'sec-fetch-mode' => 'navigate', 'referer' => 'http://127.0.0.1:8007/total/info', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] Method [ public method index ] { @@ D:\wwwroot\patrol\application\index\controller\Index.php 8 - 11 } [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2019-12-27T11:45:33+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/index/index.html [ log ] 127.0.0.1:8023/admin/index/index.html [运行时间：0.132002s][吞吐率：7.58req/s] [内存消耗：3,677.18kb] [文件加载：55] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-site', 'sec-fetch-mode' => 'navigate', 'referer' => 'http://127.0.0.1:8007/total/info', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000974s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.009046s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = null LIMIT 1 [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2019-12-27T11:45:33+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/index/index.html?token=6fd45f416a4df4798f8a2d13f5a8e0f0 [ log ] 127.0.0.1:8023/admin/index/index.html?token=6fd45f416a4df4798f8a2d13f5a8e0f0 [运行时间：0.167583s][吞吐率：5.97req/s] [内存消耗：3,829.62kb] [文件加载：59] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-site', 'sec-fetch-mode' => 'navigate', 'referer' => 'http://127.0.0.1:8007/total/info', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( 'token' => '6fd45f416a4df4798f8a2d13f5a8e0f0', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000943s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007739s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = null LIMIT 1 [ RunTime:0.000463s ] --------------------------------------------------------------- [ 2019-12-27T11:45:33+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/index/index.html [ log ] 127.0.0.1:8023/admin/index/index.html [运行时间：0.299110s][吞吐率：3.34req/s] [内存消耗：4,500.39kb] [文件加载：62] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-site', 'sec-fetch-mode' => 'navigate', 'referer' => 'http://127.0.0.1:8007/total/info', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\Index.php 9 - 16 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\index\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'person_url', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.011770s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007615s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000877s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.012709s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000757s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000705s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008340s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000565s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012116s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.008204s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2019-12-27T11:45:34+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_grade/index.html [ log ] 127.0.0.1:8023/admin/class_grade/index.html [运行时间：0.410225s][吞吐率：2.44req/s] [内存消耗：4,618.44kb] [文件加载：63] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_grade', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 班级巡课 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassGrade.php 16 - 32 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_grade\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'subjectList', 10 => 'tearchList', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.001175s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.017492s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007082s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000691s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000895s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007062s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000298s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.013396s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.009883s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.009655s ] [ sql ] [ SQL ] SELECT * FROM `bp_campus` WHERE ( cp_status=1 ) [ RunTime:0.000334s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_subject` [ RunTime:0.008152s ] [ sql ] [ SQL ] SELECT `sj_id`,`sj_name` FROM `bp_subject` WHERE ( sj_status=1 ) [ RunTime:0.000298s ] [ sql ] [ SQL ] SELECT `ad_uid`,`ad_sname` FROM `bp_admin` WHERE ( og_id = 2 ) [ RunTime:0.001442s ] --------------------------------------------------------------- [ 2019-12-27T11:45:36+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.384433s][吞吐率：2.60req/s] [内存消耗：4,869.45kb] [文件加载：68] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000934s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.009837s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.010948s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000801s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.009115s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000474s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012878s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007488s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000880s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.008561s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000362s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.008877s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.001046s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000856s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007481s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000457s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000446s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000417s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000412s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000395s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000421s ] --------------------------------------------------------------- [ 2019-12-27T11:45:37+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/other_monitor/index.html [ log ] 127.0.0.1:8023/admin/other_monitor/index.html [运行时间：0.292883s][吞吐率：3.41req/s] [内存消耗：4,791.80kb] [文件加载：68] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'other_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 其他监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\OtherMonitor.php 13 - 43 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\other_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'list', 10 => 'page', 11 => 'campus_search', 12 => 'position_search', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.011118s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.008897s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007187s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000744s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000699s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008344s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000429s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.011585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007574s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.001437s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.007255s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000456s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_pat_monitor` [ RunTime:0.007533s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM bp_pat_monitor om LEFT JOIN bpf.bp_campus c ON om.cp_id = c.cp_id WHERE om.type = 1 ORDER BY om.id DESC LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] SELECT om.*,c.* FROM bp_pat_monitor om LEFT JOIN bpf.bp_campus c ON om.cp_id = c.cp_id WHERE om.type = 1 ORDER BY om.id DESC LIMIT 0,15 [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2019-12-27T11:45:40+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.274990s][吞吐率：3.64req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.011295s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007606s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007151s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000766s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000709s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007462s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000474s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.011434s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007198s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000912s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.007204s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000411s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.007959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000882s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.001090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.008159s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000446s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000442s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000366s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000465s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000420s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000419s ] --------------------------------------------------------------- [ 2019-12-27T11:45:42+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/getMonitorList?cs_id=75 [ log ] 127.0.0.1:8023/admin/class_monitor/getMonitorList?cs_id=75 [运行时间：0.266363s][吞吐率：3.75req/s] [内存消耗：4,265.66kb] [文件加载：60] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'getMonitorList', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'cors', 'referer' => 'http://127.0.0.1:8023/admin/class_monitor/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( 'cs_id' => '75', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] Method [ public method getMonitorList ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 63 - 76 } [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000849s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.008626s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.008949s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000800s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000711s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008196s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000470s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012408s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.008187s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_pat_monitor` [ RunTime:0.007327s ] [ sql ] [ SQL ] SELECT * FROM `bp_pat_monitor` WHERE `cs_id` = 75 AND `type` = 2 ORDER BY id DESC [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2019-12-27T11:45:55+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/getMonitorList?cs_id=73 [ log ] 127.0.0.1:8023/admin/class_monitor/getMonitorList?cs_id=73 [运行时间：0.235480s][吞吐率：4.25req/s] [内存消耗：4,265.66kb] [文件加载：60] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'getMonitorList', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'cors', 'referer' => 'http://127.0.0.1:8023/admin/class_monitor/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( 'cs_id' => '73', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] Method [ public method getMonitorList ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 63 - 76 } [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000906s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.012382s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007585s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000729s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000725s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008544s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000473s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007532s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_pat_monitor` [ RunTime:0.007043s ] [ sql ] [ SQL ] SELECT * FROM `bp_pat_monitor` WHERE `cs_id` = 73 AND `type` = 2 ORDER BY id DESC [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2019-12-27T11:45:58+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.256310s][吞吐率：3.90req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000905s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007843s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007521s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000780s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.001319s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007191s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000472s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.011600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007060s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.007468s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000418s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.008660s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000445s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000429s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000501s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000444s ] --------------------------------------------------------------- [ 2019-12-27T11:45:59+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.265071s][吞吐率：3.77req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000930s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.014164s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.009919s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000633s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007743s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000508s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.011580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007334s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.010441s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.008929s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000823s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.011021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000411s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000544s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000421s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000406s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000300s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000337s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000449s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000374s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000410s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000340s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000348s ] --------------------------------------------------------------- [ 2019-12-27T11:45:59+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.266660s][吞吐率：3.75req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000859s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007504s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000338s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.006898s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000763s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008250s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000409s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.009155s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.010375s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000435s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.007054s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007812s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000439s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000365s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000229s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000207s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000249s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000210s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000224s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000239s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000264s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000234s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000254s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000212s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000209s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000326s ] --------------------------------------------------------------- [ 2019-12-27T11:45:59+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.283984s][吞吐率：3.52req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000676s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007920s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000370s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.008770s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000772s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.001046s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.002394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.009223s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000457s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.013615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007874s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.007676s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000259s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.006987s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007174s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000298s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000520s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000333s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000226s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000213s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000198s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000219s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000204s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000195s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000219s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000204s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000223s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000199s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000244s ] --------------------------------------------------------------- [ 2019-12-27T11:46:00+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/index.html [ log ] 127.0.0.1:8023/admin/class_monitor/index.html [运行时间：0.313826s][吞吐率：3.19req/s] [内存消耗：4,618.35kb] [文件加载：66] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-user' => '?1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'nested-navigate', 'referer' => 'http://127.0.0.1:8023/admin/index/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] /** * 教室监控列表 * @return [type] [description] */ Method [ public method index ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 13 - 58 } [ info ] [ VIEW ] D:\wwwroot\patrol\public/../application/admin\view\class_monitor\index.html [ array ( 0 => 'skin', 1 => 'super', 2 => 'menu_list', 3 => 'auth', 4 => 'sysmodule', 5 => 'head', 6 => 'title', 7 => 'con_str', 8 => 'campusList', 9 => 'campus_search', 10 => 'items', 11 => 'list', 12 => 'page', 13 => 'cs_stype', 14 => 'cs_name', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000707s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.007943s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000364s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.008146s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000669s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.008181s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000472s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.019319s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.008867s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_campus` [ RunTime:0.009330s ] [ sql ] [ SQL ] SELECT `cp_id`,`cp_name` FROM `bp_campus` [ RunTime:0.000307s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_classset` [ RunTime:0.007513s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] SELECT * FROM ( SELECT c.cs_id,c.cp_id,c.cs_name,c.cs_stype,ca.cp_name,count(cm.id) monitor_num,b.cl_name,g.gd_name FROM bp_classset c LEFT JOIN bp_campus ca ON c.cp_id = ca.cp_id LEFT JOIN bp_pat_monitor cm ON c.cs_id = cm.cs_id AND cm.type = 2 LEFT JOIN bp_bclass b ON c.cs_id = b.cs_id LEFT JOIN bp_grade g ON g.gd_id = b.gd_id GROUP BY c.cs_id ORDER BY count(cm.id) DESC,c.cs_id DESC ) bs LIMIT 0,15 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_bclass` [ RunTime:0.007339s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 86 LIMIT 1 [ RunTime:0.000402s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 75 LIMIT 1 [ RunTime:0.000273s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 73 LIMIT 1 [ RunTime:0.000230s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 66 LIMIT 1 [ RunTime:0.000205s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 85 LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 84 LIMIT 1 [ RunTime:0.000351s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 83 LIMIT 1 [ RunTime:0.000234s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 82 LIMIT 1 [ RunTime:0.000249s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 81 LIMIT 1 [ RunTime:0.000204s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 80 LIMIT 1 [ RunTime:0.000248s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 79 LIMIT 1 [ RunTime:0.000213s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 78 LIMIT 1 [ RunTime:0.000199s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 77 LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 76 LIMIT 1 [ RunTime:0.000330s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bp_bclass` WHERE `cs_id` = 74 LIMIT 1 [ RunTime:0.000404s ] --------------------------------------------------------------- [ 2019-12-27T11:46:06+08:00 ] 127.0.0.1 127.0.0.1 GET /admin/class_monitor/getMonitorList?cs_id=75 [ log ] 127.0.0.1:8023/admin/class_monitor/getMonitorList?cs_id=75 [运行时间：0.237132s][吞吐率：4.22req/s] [内存消耗：4,265.66kb] [文件加载：60] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'class_monitor', 2 => 'getMonitorList', ), ) [ info ] [ HEADER ] array ( 'host' => '127.0.0.1:8023', 'connection' => 'keep-alive', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36', 'sec-fetch-site' => 'same-origin', 'sec-fetch-mode' => 'cors', 'referer' => 'http://127.0.0.1:8023/admin/class_monitor/index.html', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => 'PHPSESSID=n999r16lbq57cvlf192dh7sk61; prep=false; token=6fd45f416a4df4798f8a2d13f5a8e0f0; KEXUN=b5f98b78d31553099fe065a7fc6d258cdf7c78ae; XSRF-TOKEN=eyJpdiI6IjAwbW5nUVQzSUVEY0thTWl3QjBuZEE9PSIsInZhbHVlIjoidE03VjUwZzFMMVNsYUowWXRxVnJwZU1oSzNcL2xVRDJQSEw4TCtHaUZyTG1UUDlPU2YySTVNTGNGZEVcL0szb3UzV3hPWTgwazhlTHFPbXRjNEd3andkdz09IiwibWFjIjoiNmFlNjM4ZmU4MTJlOTc5NWNmMmI3NzVkNjhjMTA0YTMxMmQ2MGNkZmEzZTliM2JhYmVjZWFhNDc4MDIwMWU4ZSJ9', ) [ info ] [ PARAM ] array ( 'cs_id' => '75', ) [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] Method [ public method getMonitorList ] { @@ D:\wwwroot\patrol\application\admin\controller\ClassMonitor.php 63 - 76 } [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.009946s ] mysql:dbname=bpf;host=127.0.0.1;port=3306;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_admin` [ RunTime:0.014544s ] [ sql ] [ SQL ] SELECT `skin` FROM `bp_admin` WHERE `ad_uid` = 1 LIMIT 1 [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_auth` [ RunTime:0.007365s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 0 AND `au_son` = 020 [ RunTime:0.000738s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1034 [ RunTime:0.000744s ] [ sql ] [ SQL ] SELECT * FROM `bp_auth` WHERE `au_pid` = 1041 [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_roles` [ RunTime:0.007847s ] [ sql ] [ SQL ] SELECT `rs_auth` FROM `bp_roles` WHERE `rs_id` = 1 [ RunTime:0.000484s ] [ 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,1075,1077,1076,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,1074,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,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,1088,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,889,233,242,243,244,285,286,287,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,1091,1092,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,1090,1089,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,1022,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,1025,1024,1026,1027,1028,893,1093,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,1029,1030,1031,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,1034,1035,1036,1038,1039,1049,1041,1042,1047,1048,1044,1045,1046,1050,1052,1053,1054,1055,1051,1056,1057,1058,1059,1062,1060,1063,1064,1065,1066,1067,1068,1069,1070,1071,1061,1072,1073) GROUP BY module_id [ RunTime:0.012535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_sysmodule` [ RunTime:0.007604s ] [ sql ] [ SQL ] SELECT * FROM `bp_sysmodule` WHERE `sd_type` = 1 AND `sd_pid` = 0 AND `sd_id` IN (,2,3,4,5,7,8,9,10,11,16,20,25,31,66) ORDER BY sd_sort asc,sd_id ASC [ RunTime:0.000735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bp_pat_monitor` [ RunTime:0.007665s ] [ sql ] [ SQL ] SELECT * FROM `bp_pat_monitor` WHERE `cs_id` = 75 AND `type` = 2 ORDER BY id DESC [ RunTime:0.000886s ] ---------------------------------------------------------------