--------------------------------------------------------------- [2021-11-17T09:53:33+08:00] 180.111.250.232 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.000790s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.033101s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000716s ] --------------------------------------------------------------- [2021-11-17T09:53:35+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.032744s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.009895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021148s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019261s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000494s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018583s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000447s ] --------------------------------------------------------------- [2021-11-17T09:54:16+08:00] 180.111.250.232 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013763s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.024764s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [2021-11-17T09:54:17+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.012447s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024589s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018474s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.017615s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016869s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000494s ] --------------------------------------------------------------- [2021-11-17T10:00:37+08:00] 180.111.250.232 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012813s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.026560s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [2021-11-17T10:00:38+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005457s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024727s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006307s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018229s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019671s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017064s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000459s ] --------------------------------------------------------------- [2021-11-17T10:00:40+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000701s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026311s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 [ RunTime:0.001064s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 0,10 [ RunTime:0.000697s ] --------------------------------------------------------------- [2021-11-17T10:04:37+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/staff/edit.html?id=44&spm=m-4-1&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000693s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026803s ] [ sql ] [ SQL ] SELECT * FROM `v_staff` WHERE `id` = 44 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.019519s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000567s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.019473s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_position` WHERE `sector_id` = 9 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] --------------------------------------------------------------- [2021-11-17T10:04:43+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6 [ sql ] [ DB ] CONNECT:[ UseTime:0.000667s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.031000s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.000746s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 0,10 [ RunTime:0.000651s ] --------------------------------------------------------------- [2021-11-17T10:04:47+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000668s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.032367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.000771s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 10,10 [ RunTime:0.000896s ] --------------------------------------------------------------- [2021-11-17T10:04:49+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.009722s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030299s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 20,10 [ RunTime:0.001000s ] --------------------------------------------------------------- [2021-11-17T10:06:11+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.031751s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.001065s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 10,10 [ RunTime:0.000764s ] --------------------------------------------------------------- [2021-11-17T10:06:15+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.004217s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030246s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.001087s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 20,10 [ RunTime:0.000998s ] --------------------------------------------------------------- [2021-11-17T10:06:23+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028477s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 [ RunTime:0.000858s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 0,10 [ RunTime:0.000763s ] --------------------------------------------------------------- [2021-11-17T10:07:47+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/staff/edit.html?id=40&spm=m-4-1&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000853s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026395s ] [ sql ] [ SQL ] SELECT * FROM `v_staff` WHERE `id` = 40 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.019871s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.017562s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_position` WHERE `sector_id` = 7 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000526s ] --------------------------------------------------------------- [2021-11-17T10:10:19+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.011485s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026118s ] [ 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_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` [ RunTime:0.000743s ] [ sql ] [ SQL ] SELECT `i`.*,d.name as department_name,h.name as hospital_name,s.name as staff_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.017362s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000494s ] --------------------------------------------------------------- [2021-11-17T10:10:21+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000637s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.021751s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001041s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT `id`,`name`,`create_time`,`level`,`parent_id` FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 ORDER BY `parent_id` LIMIT 0,15 [ RunTime:0.000704s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000385s ] --------------------------------------------------------------- [2021-11-17T10:10:24+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.016089s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023366s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000938s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016641s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.015182s ] [ sql ] [ SQL ] SELECT `h`.`id`,`city`,`h`.`name`,`addess`,`phone`,g.name as grade_name,`h`.`create_time` FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.007968s ] --------------------------------------------------------------- [2021-11-17T10:10:25+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.009770s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025106s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000610s ] [ sql ] [ SQL ] SELECT `id`,`letter`,`name`,`create_time` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 ORDER BY `letter` LIMIT 0,15 [ RunTime:0.000617s ] --------------------------------------------------------------- [2021-11-17T10:10:26+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000634s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.026641s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000582s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000539s ] --------------------------------------------------------------- [2021-11-17T10:10:29+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Contacts/index.html?spm=m-2-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.010616s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.038745s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`c`.`department_id` WHERE `c`.`status` = 0 AND `c`.`is_delete` = 0 [ RunTime:0.000766s ] [ sql ] [ SQL ] SELECT `c`.*,d.name as department_name,h.name as hospital_name FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`c`.`department_id` WHERE `c`.`status` = 0 AND `c`.`is_delete` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.017325s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000938s ] --------------------------------------------------------------- [2021-11-17T10:10:29+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000824s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021767s ] [ 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_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` [ RunTime:0.000689s ] [ sql ] [ SQL ] SELECT `i`.*,d.name as department_name,h.name as hospital_name,s.name as staff_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.014721s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000626s ] --------------------------------------------------------------- [2021-11-17T10:10:30+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.010671s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.028013s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.001314s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 0,5 [ RunTime:0.000872s ] --------------------------------------------------------------- [2021-11-17T10:10:31+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Item/taskLevel.html?spm=m-3-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.006215s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_level` [ RunTime:0.019929s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000503s ] --------------------------------------------------------------- [2021-11-17T10:10:31+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Item/nature.html?spm=m-3-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.010689s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.026897s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 [ RunTime:0.000790s ] [ sql ] [ SQL ] SELECT `n`.*,l.name as level_name,`l`.`colour` FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000599s ] --------------------------------------------------------------- [2021-11-17T10:10:32+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Item/taskType.html?spm=m-3-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.011175s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.025811s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_type` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000518s ] [ sql ] [ SQL ] SELECT * FROM `v_task_type` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000455s ] --------------------------------------------------------------- [2021-11-17T10:10:36+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002849s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028018s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 [ RunTime:0.001005s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 0,10 [ RunTime:0.000693s ] --------------------------------------------------------------- [2021-11-17T10:10:37+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.027071s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000590s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000689s ] --------------------------------------------------------------- [2021-11-17T10:10:37+08:00] 180.111.250.232 GET 101.132.37.87:9001/admin/sector/position.html?spm=m-4-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.010382s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.022392s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 [ RunTime:0.000992s ] [ sql ] [ SQL ] SELECT `p`.*,s.name as sector_name FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.020896s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000630s ]