--------------------------------------------------------------- [2021-12-02T09:06:41+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007844s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.032531s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ] --------------------------------------------------------------- [2021-12-02T09:06:43+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000705s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.033611s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021019s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018792s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019300s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000460s ] --------------------------------------------------------------- [2021-12-02T09:06:46+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.004913s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022688s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000880s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ 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.000696s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000386s ] --------------------------------------------------------------- [2021-12-02T09:06:48+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000689s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024532s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001020s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018046s ] [ 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.012754s ] [ 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.008222s ] --------------------------------------------------------------- [2021-12-02T09:06:51+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023807s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018965s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021717s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000614s ] --------------------------------------------------------------- [2021-12-02T09:06:55+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023187s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000995s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ 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.000698s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000382s ] --------------------------------------------------------------- [2021-12-02T09:07:05+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.003661s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029331s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001035s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017141s ] [ 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.012422s ] [ 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.007922s ] --------------------------------------------------------------- [2021-12-02T09:07:08+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000678s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024283s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000561s ] [ 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.000725s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000397s ] --------------------------------------------------------------- [2021-12-02T09:24:20+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010473s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.033490s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [2021-12-02T09:24:22+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023930s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006409s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017475s ] [ 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.019981s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018722s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000436s ] --------------------------------------------------------------- [2021-12-02T09:24:24+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.012953s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024472s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001030s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ 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.000702s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000393s ] --------------------------------------------------------------- [2021-12-02T09:24:26+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000850s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024046s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000903s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016554s ] [ 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.012330s ] [ 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.007839s ] --------------------------------------------------------------- [2021-12-02T09:24:27+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.012728s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023806s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001024s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000554s ] [ 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.000707s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000388s ] --------------------------------------------------------------- [2021-12-02T09:24:28+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.012023s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023136s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000534s ] [ 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.000567s ] --------------------------------------------------------------- [2021-12-02T09:24:29+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.006956s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023568s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001003s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ 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.000496s ] --------------------------------------------------------------- [2021-12-02T09:24:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1&name=&province_id=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001930s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024039s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000984s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT `id`,`name`,`create_time`,`level`,`parent_id` FROM `v_city` WHERE `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 ORDER BY `parent_id` LIMIT 0,15 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000507s ] --------------------------------------------------------------- [2021-12-02T09:24:36+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.006278s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023628s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018881s ] [ 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.012188s ] [ 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.007887s ] --------------------------------------------------------------- [2021-12-02T09:24:38+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.003908s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023256s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000651s ] --------------------------------------------------------------- [2021-12-02T09:24:39+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=3&city_id= [ sql ] [ DB ] CONNECT:[ UseTime:0.002331s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025798s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001033s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018855s ] [ 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`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.007286s ] [ 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 `province_id` = 3 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000514s ] --------------------------------------------------------------- [2021-12-02T09:35:37+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000790s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.027593s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000559s ] [ 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.000703s ] [ 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-12-02T09:35:38+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000690s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023166s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000993s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017768s ] [ 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.012062s ] [ 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.008071s ] --------------------------------------------------------------- [2021-12-02T09:35:41+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023098s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ 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.000542s ] --------------------------------------------------------------- [2021-12-02T09:35:43+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.003711s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024694s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020111s ] [ 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.012215s ] [ 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.007865s ] --------------------------------------------------------------- [2021-12-02T09:36:17+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000691s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025229s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000724s ] --------------------------------------------------------------- [2021-12-02T09:36:18+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=3&city_id= [ sql ] [ DB ] CONNECT:[ UseTime:0.000664s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024445s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001017s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016968s ] [ 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`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.007635s ] [ 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 `province_id` = 3 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000528s ] --------------------------------------------------------------- [2021-12-02T10:01:25+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023760s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000557s ] [ 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.000561s ] --------------------------------------------------------------- [2021-12-02T10:01:27+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000709s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023509s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000988s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017741s ] [ 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.011954s ] [ 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.007645s ]