--------------------------------------------------------------- [2024-11-23T14:36:24+08:00] 180.102.196.188 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.000913s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.014200s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [2024-11-23T14:36:25+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000742s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.012660s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006253s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.010864s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000393s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.011244s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000407s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.011517s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000518s ] --------------------------------------------------------------- [2024-11-23T14:36:26+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.012217s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000810s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000589s ] [ 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.000850s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000457s ] --------------------------------------------------------------- [2024-11-23T14:36:28+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.031849s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.011885s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006021s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.011042s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.011232s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.011572s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000395s ] --------------------------------------------------------------- [2024-11-23T14:36:54+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000742s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.011818s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000736s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000583s ] [ 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.000744s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000404s ] --------------------------------------------------------------- [2024-11-23T14:36:56+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000737s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.012135s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.011114s ] [ 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.012369s ] [ 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.008554s ] --------------------------------------------------------------- [2024-11-23T14:37:12+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.012492s ] [ 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.000930s ] [ 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.000719s ] --------------------------------------------------------------- [2024-11-23T14:49:53+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.009754s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.011715s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000436s ] --------------------------------------------------------------- [2024-11-23T14:49:54+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000778s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.012070s ] [ 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.000814s ] [ 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.000718s ] --------------------------------------------------------------- [2024-11-23T14:51:51+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.004580s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.012442s ] [ 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.001237s ] [ 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.000902s ] --------------------------------------------------------------- [2024-11-23T14:51:51+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.012288s ] [ 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.000696s ] [ 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.000810s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.011223s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000438s ] --------------------------------------------------------------- [2024-11-23T14:51:53+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.006153s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.012594s ] [ 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.000917s ] [ 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.000934s ] --------------------------------------------------------------- [2024-11-23T17:09:39+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Item/taskLevel.html?spm=m-3-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.013800s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_level` [ RunTime:0.011747s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000436s ] --------------------------------------------------------------- [2024-11-23T17:09:40+08:00] 180.102.196.188 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.004415s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.012269s ] [ 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.000881s ] [ 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.000739s ]