--------------------------------------------------------------- [2023-04-18T19:23:15+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000893s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.053645s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '13398446186' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.033465s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('13398446186' , 0 , 634397 , 1681816995 , '2023-04-18 19:23:15') [ RunTime:0.004923s ] --------------------------------------------------------------- [2023-04-18T19:23:31+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.035548s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '13398446186' AND `phone_code` = '634397' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.032690s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0133' , 1 , 0 , 0 , 1681817011 , '2023-04-18 19:23:31') [ RunTime:0.004920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032274s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('13398446186' , '76df341c6fdafe3f1f3b76f09c1e31f9' , '0133' , 0 , 0 , 1681817011 , '2023-04-18 19:23:31' , 1681817011 , 50) [ RunTime:0.002523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032325s ] [ sql ] [ SQL ] INSERT INTO `v_staff_action` (`status` , `is_delete` , `create_time` , `create_date` , `is_create_item` , `is_create_task` , `staff_id`) VALUES (0 , 0 , 1681817011 , '2023-04-18 19:23:31' , 1 , 1 , 60) [ RunTime:0.004962s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.048433s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1681817011 , '2023-04-18 19:23:31' , 60) [ RunTime:0.002145s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' WHERE `id` = 60 [ RunTime:0.003525s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 32 [ RunTime:0.003342s ] --------------------------------------------------------------- [2023-04-18T19:23:41+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037834s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '张华涛' , `sex` = 1 WHERE `id` = 60 [ RunTime:0.000902s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042415s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 60 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.047947s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 60,1,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,2,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,3,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,4,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,5,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,6,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,7,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,8,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,9,0,1681817021,'2023-04-18 19:23:41' ) , ( 60,10,0,1681817021,'2023-04-18 19:23:41' ) [ RunTime:0.002127s ] --------------------------------------------------------------- [2023-04-18T19:23:41+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000874s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043754s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001203s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043335s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.056120s ] [ 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 `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 60 [ RunTime:0.003409s ] --------------------------------------------------------------- [2023-04-18T19:23:41+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038587s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.079289s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000603s ] --------------------------------------------------------------- [2023-04-18T19:23:44+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003191s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050713s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038234s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.068611s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000811s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.047355s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] --------------------------------------------------------------- [2023-04-18T19:23:44+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.015282s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062562s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.065572s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001303s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030222s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002442s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000787s ] --------------------------------------------------------------- [2023-04-18T19:23:48+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000825s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.091463s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.062155s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.058681s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 3 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000755s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 3 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000763s ] --------------------------------------------------------------- [2023-04-18T19:23:48+08:00] 171.210.63.83 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000555s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.070427s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '60|4eb3189e1b0808578ce092282c9cb1a5' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.056166s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 60 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.062214s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.050185s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 5 AND `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000504s ]