--------------------------------------------------------------- [2023-11-09T10:07:29+08:00] 112.1.56.137 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.000893s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.038157s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000934s ] --------------------------------------------------------------- [2023-11-09T10:07:31+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.000820s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.053588s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031118s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.032539s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036178s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000661s ] --------------------------------------------------------------- [2023-11-09T10:14:25+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001363s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.039379s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000653s ] [ 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.000660s ] --------------------------------------------------------------- [2023-11-09T10:14:26+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.000808s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037424s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001039s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.032912s ] [ 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.014159s ] [ 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.007944s ] --------------------------------------------------------------- [2023-11-09T10:14:30+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Item/index.html?id=260&spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000809s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.037219s ] [ 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` WHERE `hospital_id` = 260 [ RunTime:0.000652s ] [ 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` WHERE `hospital_id` = 260 ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.030697s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000732s ] --------------------------------------------------------------- [2023-11-09T10:14:32+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.005057s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.043803s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.034236s ] [ 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.014407s ] [ 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.008130s ] --------------------------------------------------------------- [2023-11-09T10:14:34+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/hospital/edit.html?id=2&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000789s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.039568s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 2 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.028136s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000573s ] --------------------------------------------------------------- [2023-11-09T11:17:25+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000882s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037085s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028081s ] [ 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.012397s ] [ 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 15,15 [ RunTime:0.007881s ] --------------------------------------------------------------- [2023-11-09T11:17:28+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Item/index.html?id=265&spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000857s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.040447s ] [ 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` WHERE `hospital_id` = 265 [ RunTime:0.000875s ] [ 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` WHERE `hospital_id` = 265 ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027208s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000598s ] --------------------------------------------------------------- [2023-11-09T11:17:30+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.004949s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.056448s ] [ 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.000805s ] [ 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.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.037195s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000666s ] --------------------------------------------------------------- [2023-11-09T11:17:32+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/contacts/edit.html?id=31&spm=m-2-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.000850s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.058319s ] [ sql ] [ SQL ] SELECT `c`.*,h.name as hospital_name FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 31 AND `c`.`status` = 0 AND `c`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.030890s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000578s ] --------------------------------------------------------------- [2023-11-09T11:56:32+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.009032s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.042158s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000635s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000540s ] --------------------------------------------------------------- [2023-11-09T11:56:33+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.013638s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.031449s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000666s ] [ 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.000673s ] --------------------------------------------------------------- [2023-11-09T11:56:34+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.000788s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.041174s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.041394s ] [ 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.013105s ] [ 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.008762s ] --------------------------------------------------------------- [2023-11-09T11:56:35+08:00] 112.1.56.137 GET 101.132.37.87:9001/admin/hospital/contacts.html?id=3&spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.005535s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.045254s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital` WHERE `id` = 3 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.034529s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000638s ]