--------------------------------------------------------------- [2019-12-01T15:26:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.023283s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050212s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007073s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.032881s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.007144s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.057999s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.007340s ] --------------------------------------------------------------- [2019-12-01T15:26:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.005732s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031995s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.059957s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.003461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.037799s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.003055s ] --------------------------------------------------------------- [2019-12-01T15:26:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.007218s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044601s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.063940s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005353s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.045781s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005286s ] --------------------------------------------------------------- [2019-12-01T15:26:38+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/doughType [ sql ] [ DB ] CONNECT:[ UseTime:0.007963s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032522s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_type` [ RunTime:0.023503s ] [ sql ] [ SQL ] SELECT `id`,`name`,`type` FROM `v_dough_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.003701s ] --------------------------------------------------------------- [2019-12-01T15:26:38+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/verifyDough [ sql ] [ DB ] CONNECT:[ UseTime:0.006916s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042424s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004967s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.034055s ] [ sql ] [ SQL ] SELECT `id` FROM `v_dough_staff` WHERE `task_id` = 61 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004812s ] --------------------------------------------------------------- [2019-12-01T15:26:38+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/doughInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009430s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021620s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006364s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021814s ] [ sql ] [ SQL ] SELECT `id`,`user_name`,`money_type`,`money`,`staff_id`,`status` FROM `v_dough_staff` WHERE `id` = 11 AND `staff_id` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006353s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.034723s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`start_date`,`d`.`end_date`,`d`.`money`,`d`.`remark`,`t`.`name`,`dough_staff_id`,`start_city`,`end_city`,`money_use`,`t`.`type` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` = 11 AND `d`.`status` = 0 AND `d`.`is_delete` = 0 [ RunTime:0.006472s ] --------------------------------------------------------------- [2019-12-01T15:30:13+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003572s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025666s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002510s ] [ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`id` = 1 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.090189s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 1 LIMIT 1 [ RunTime:0.002762s ] --------------------------------------------------------------- [2019-12-01T15:30:14+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.017705s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034039s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029151s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005135s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035589s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.027428s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.023576s ] --------------------------------------------------------------- [2019-12-01T15:30:14+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013251s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039409s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.025188s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.051810s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006012s ] --------------------------------------------------------------- [2019-12-01T15:30:14+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.020210s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050326s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.054005s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005271s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019377s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.019718s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.017253s ] --------------------------------------------------------------- [2019-12-01T15:30:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.025032s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037751s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006162s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045021s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.006332s ] --------------------------------------------------------------- [2019-12-01T15:30:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.019467s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042071s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005379s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.052439s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.005918s ] --------------------------------------------------------------- [2019-12-01T15:30:22+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.007360s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035900s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005098s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.049813s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.005310s ] --------------------------------------------------------------- [2019-12-01T15:30:26+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.015022s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046846s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005288s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.038251s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005307s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.055428s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005505s ] --------------------------------------------------------------- [2019-12-01T15:30:26+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.010511s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056444s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005020s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.051138s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005161s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.064055s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005323s ] --------------------------------------------------------------- [2019-12-01T15:30:26+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.005172s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034044s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003318s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.044597s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.003398s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.077008s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.003437s ] --------------------------------------------------------------- [2019-12-01T15:30:28+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/doughInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007035s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031643s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.022050s ] [ sql ] [ SQL ] SELECT `id`,`user_name`,`money_type`,`money`,`staff_id`,`status` FROM `v_dough_staff` WHERE `id` = 1 AND `staff_id` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.030942s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`start_date`,`d`.`end_date`,`d`.`money`,`d`.`remark`,`t`.`name`,`dough_staff_id`,`start_city`,`end_city`,`money_use`,`t`.`type` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` = 1 AND `d`.`status` = 0 AND `d`.`is_delete` = 0 [ RunTime:0.004919s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_img` [ RunTime:0.035302s ] [ sql ] [ SQL ] SELECT `id`,`img_url`,`dough_id` FROM `v_dough_img` WHERE `dough_id` IN (2,4) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004932s ] --------------------------------------------------------------- [2019-12-01T15:30:35+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.018267s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026519s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005119s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.053535s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005140s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.060761s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005343s ] --------------------------------------------------------------- [2019-12-01T15:30:35+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.020537s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035406s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005324s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.057846s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.067785s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005719s ] --------------------------------------------------------------- [2019-12-01T15:30:35+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.012395s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049615s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006179s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.059364s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.006349s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.075047s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.006340s ] --------------------------------------------------------------- [2019-12-01T15:30:37+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/doughInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008417s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027744s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.023215s ] [ sql ] [ SQL ] SELECT `id`,`user_name`,`money_type`,`money`,`staff_id`,`status` FROM `v_dough_staff` WHERE `id` = 2 AND `staff_id` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.031415s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`start_date`,`d`.`end_date`,`d`.`money`,`d`.`remark`,`t`.`name`,`dough_staff_id`,`start_city`,`end_city`,`money_use`,`t`.`type` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` = 2 AND `d`.`status` = 0 AND `d`.`is_delete` = 0 [ RunTime:0.005740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_img` [ RunTime:0.029610s ] [ sql ] [ SQL ] SELECT `id`,`img_url`,`dough_id` FROM `v_dough_img` WHERE `dough_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005693s ] --------------------------------------------------------------- [2019-12-01T15:30:41+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.009047s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035861s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005091s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.048138s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005239s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.060146s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005745s ] --------------------------------------------------------------- [2019-12-01T15:30:42+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.006404s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025077s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.058849s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.003620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.033928s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.003646s ] --------------------------------------------------------------- [2019-12-01T15:30:42+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.016677s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056051s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.055734s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 1 AND `d`.`is_delete` = 0 [ RunTime:0.005250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.049423s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (1,2,5,7,11,18) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005543s ] --------------------------------------------------------------- [2019-12-01T15:30:43+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.008671s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.061495s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002433s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.055601s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003359s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.046062s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.023236s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.022810s ] --------------------------------------------------------------- [2019-12-01T15:30:44+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008868s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038725s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004897s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029601s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004890s ] --------------------------------------------------------------- [2019-12-01T15:30:45+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.010720s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029435s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007328s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026572s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035715s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.027663s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.032692s ] --------------------------------------------------------------- [2019-12-01T15:30:53+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009737s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028230s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006546s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023058s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`id` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023952s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `item_id` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.006824s ] --------------------------------------------------------------- [2019-12-01T15:30:53+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005124s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018184s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020110s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003500s ] --------------------------------------------------------------- [2019-12-01T15:30:56+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005932s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024140s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004048s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020292s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 16 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.024132s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 16 AND `remind_date` >= '2019-12-01' [ RunTime:0.004047s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.020416s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 16 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003861s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.033564s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 16 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017910s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 16 AND `t`.`type` = 2 [ RunTime:0.003944s ] --------------------------------------------------------------- [2019-12-01T15:30:58+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007949s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025111s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005338s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021150s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`id` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005410s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022631s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `item_id` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.005604s ] --------------------------------------------------------------- [2019-12-01T15:30:58+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006717s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021173s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019519s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004533s ] --------------------------------------------------------------- [2019-12-01T15:31:02+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009145s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028069s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006133s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022785s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 16 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006460s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.024878s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 16 AND `remind_date` >= '2019-12-01' [ RunTime:0.006090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.031644s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 16 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005904s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.050706s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 16 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.006032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.022099s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 16 AND `t`.`type` = 2 [ RunTime:0.006001s ] --------------------------------------------------------------- [2019-12-01T15:31:05+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005544s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024574s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003829s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019893s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`id` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023574s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `item_id` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.004048s ] --------------------------------------------------------------- [2019-12-01T15:31:06+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006434s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024947s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019493s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004347s ] --------------------------------------------------------------- [2019-12-01T15:31:07+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.007748s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.072259s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005333s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.039089s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.006231s ] --------------------------------------------------------------- [2019-12-01T15:31:07+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.007022s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025717s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004073s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045140s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.004365s ] --------------------------------------------------------------- [2019-12-01T15:31:07+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.007053s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037589s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030859s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 1 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.005141s ] --------------------------------------------------------------- [2019-12-01T15:31:12+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007215s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025947s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022109s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 94 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005209s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.020958s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 94 AND `remind_date` >= '2019-12-01' [ RunTime:0.004795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.022425s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 94 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030391s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 94 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020609s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 94 AND `t`.`type` = 2 [ RunTime:0.004743s ] --------------------------------------------------------------- [2019-12-01T15:31:17+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/doughType [ sql ] [ DB ] CONNECT:[ UseTime:0.010952s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032875s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004264s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_type` [ RunTime:0.025056s ] [ sql ] [ SQL ] SELECT `id`,`name`,`type` FROM `v_dough_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.004192s ] --------------------------------------------------------------- [2019-12-01T15:31:17+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/verifyDough [ sql ] [ DB ] CONNECT:[ UseTime:0.005387s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035812s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021906s ] [ sql ] [ SQL ] SELECT `id` FROM `v_dough_staff` WHERE `task_id` = 94 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003602s ] --------------------------------------------------------------- [2019-12-01T15:31:19+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008020s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026595s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022160s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 94 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005770s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.021626s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 94 AND `remind_date` >= '2019-12-01' [ RunTime:0.005358s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.022079s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 94 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030603s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 94 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.019992s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 94 AND `t`.`type` = 2 [ RunTime:0.005300s ] --------------------------------------------------------------- [2019-12-01T17:00:37+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.017187s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037870s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005139s ] [ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`id` = 1 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.033772s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 1 LIMIT 1 [ RunTime:0.004996s ] --------------------------------------------------------------- [2019-12-01T17:00:37+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009786s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062973s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.060686s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007516s ] --------------------------------------------------------------- [2019-12-01T17:00:37+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.009126s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047023s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006408s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.064690s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006381s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.030102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.030086s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.028092s ] --------------------------------------------------------------- [2019-12-01T17:00:37+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.010016s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044347s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.008314s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043856s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024802s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.019371s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.025307s ] --------------------------------------------------------------- [2019-12-01T17:00:38+08:00] 115.60.51.84 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.007353s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '1|7e400df7f9ff814e43aad33846392224' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018411s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 1 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005102s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018887s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) [ RunTime:0.019287s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,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,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684) ORDER BY `i`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.017124s ]