--------------------------------------------------------------- [2023-11-06T08:57:54+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.012472s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.040963s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [2023-11-06T08:57:56+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000782s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.037505s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006904s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.030082s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035703s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030245s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000541s ] --------------------------------------------------------------- [2023-11-06T09:06:20+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005343s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048707s ] [ 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.001326s ] [ 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.000977s ] --------------------------------------------------------------- [2023-11-06T09:06:59+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046423s ] [ 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.001027s ] [ 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 10,10 [ RunTime:0.001052s ] --------------------------------------------------------------- [2023-11-06T09:07:03+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.016244s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045114s ] [ 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.001457s ] [ 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 20,10 [ RunTime:0.001259s ] --------------------------------------------------------------- [2023-11-06T09:29:53+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000882s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040933s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 41 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004207s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028300s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.030501s ] --------------------------------------------------------------- [2023-11-06T09:29:59+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ 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_action` [ RunTime:0.038925s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 41 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001262s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030548s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.031410s ] --------------------------------------------------------------- [2023-11-06T09:30:04+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.013744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042938s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 41 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001010s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030508s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.031852s ] --------------------------------------------------------------- [2023-11-06T09:30:09+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000784s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.049323s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 41 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001181s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030612s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.030958s ] --------------------------------------------------------------- [2023-11-06T09:30:50+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005665s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.042740s ] [ 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.000997s ] [ 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.000878s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.032995s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000633s ] --------------------------------------------------------------- [2023-11-06T09:30:56+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005740s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.041651s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001086s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000887s ] [ 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.001029s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000462s ] --------------------------------------------------------------- [2023-11-06T09:43:05+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1&page=6 [ sql ] [ DB ] CONNECT:[ UseTime:0.015048s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037360s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001019s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000592s ] [ 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 75,15 [ RunTime:0.000946s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (47,69) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000565s ] --------------------------------------------------------------- [2023-11-06T10:11:41+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000909s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.041108s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001045s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030282s ] [ 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.012519s ] [ 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.007995s ] --------------------------------------------------------------- [2023-11-06T10:11:51+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/hospital/edit.html?id=256&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000801s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.038720s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 256 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.030817s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000638s ] --------------------------------------------------------------- [2023-11-06T16:00:24+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001010s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.042583s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001088s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001058s ] [ 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.000798s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000467s ] --------------------------------------------------------------- [2023-11-06T16:00:25+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.012108s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.034344s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000589s ] --------------------------------------------------------------- [2023-11-06T16:00:27+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Contacts/index.html?spm=m-2-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.056268s ] [ 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.000927s ] [ 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.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.029777s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000744s ] --------------------------------------------------------------- [2023-11-06T17:00:58+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000903s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.038276s ] [ 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.000963s ] [ 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.000915s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027310s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000556s ] --------------------------------------------------------------- [2023-11-06T17:01:00+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000781s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.041598s ] [ 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.001580s ] [ 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.001036s ] --------------------------------------------------------------- [2023-11-06T17:01:02+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000832s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041697s ] [ 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.001294s ] [ 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.000929s ] --------------------------------------------------------------- [2023-11-06T17:01:16+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.039073s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000569s ] --------------------------------------------------------------- [2023-11-06T17:01:18+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/sector/position.html?spm=m-4-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.014497s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.041979s ] [ 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.000705s ] [ 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.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.032486s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000602s ] --------------------------------------------------------------- [2023-11-06T17:01:58+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.039986s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000502s ] --------------------------------------------------------------- [2023-11-06T17:02:00+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Dough/index.html?spm=m-4-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.013773s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.042696s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 [ RunTime:0.000774s ] [ sql ] [ SQL ] SELECT `d`.*,t.name as task_name,s.name as staff_name FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 ORDER BY `is_submit` DESC,`d`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000876s ] --------------------------------------------------------------- [2023-11-06T17:02:04+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/dough/details.html?id=25&spm=m-4-4&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.047346s ] [ sql ] [ SQL ] SELECT * FROM `v_dough_staff` WHERE `id` = 25 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.045084s ] [ 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` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` = 25 AND `d`.`status` = 0 AND `d`.`is_delete` = 0 [ RunTime:0.000967s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_img` [ RunTime:0.043565s ] [ sql ] [ SQL ] SELECT `id`,`img_url`,`dough_id` FROM `v_dough_img` WHERE `dough_id` = 22 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000733s ] --------------------------------------------------------------- [2023-11-06T21:13:08+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/sector/position.html?spm=m-4-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000908s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.044031s ] [ 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.001549s ] [ 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.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.033536s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000701s ] --------------------------------------------------------------- [2023-11-06T21:13:10+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.015385s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.042359s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000639s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000555s ] --------------------------------------------------------------- [2023-11-06T21:13:14+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.006940s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042653s ] [ 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.001128s ] [ 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.000939s ]