--------------------------------------------------------------- [2021-11-30T08:52:27+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.000942s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.032872s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [2021-11-30T08:52:28+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.009716s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.033587s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006403s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020305s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020309s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019642s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000606s ] --------------------------------------------------------------- [2021-11-30T08:52:53+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Contacts/index.html?spm=m-2-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.011865s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.036597s ] [ 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.000764s ] [ 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.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.015680s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000461s ] --------------------------------------------------------------- [2021-11-30T08:52:59+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.006640s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.026550s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000502s ] --------------------------------------------------------------- [2021-11-30T08:53:15+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.005924s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.027910s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 15,15 [ RunTime:0.000488s ] --------------------------------------------------------------- [2021-11-30T08:53:17+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001720s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023770s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000551s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000483s ] --------------------------------------------------------------- [2021-11-30T08:56:22+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.001526s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023894s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000941s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016588s ] [ 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.012193s ] [ 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.007868s ] --------------------------------------------------------------- [2021-11-30T08:56: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.004884s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023732s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001008s ] [ 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.000714s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000452s ] --------------------------------------------------------------- [2021-11-30T08:56:47+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.000635s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022302s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018122s ] [ 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.012149s ] [ 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.007693s ] --------------------------------------------------------------- [2021-11-30T08:57:13+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.012454s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023935s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000686s ] --------------------------------------------------------------- [2021-11-30T08:57:36+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=209&city_id=213 [ sql ] [ DB ] CONNECT:[ UseTime:0.010604s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.021672s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000958s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029154s ] [ 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` = 209 AND `city_id` = 213 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001241s ] [ 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` = 209 AND `city_id` = 213 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000590s ] --------------------------------------------------------------- [2021-11-30T10:39:49+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004911s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.023182s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ] --------------------------------------------------------------- [2021-11-30T10:39: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.011282s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006353s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018191s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000432s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019650s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000433s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019086s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000484s ] --------------------------------------------------------------- [2021-11-30T10:39:52+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.000682s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023933s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000956s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ 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.000699s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000383s ] --------------------------------------------------------------- [2021-11-30T10:39:53+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.000694s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024896s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000526s ] [ 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.000573s ] --------------------------------------------------------------- [2021-11-30T10:39:53+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.006295s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025120s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000979s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017874s ] [ 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.014572s ] [ 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.014142s ] --------------------------------------------------------------- [2021-11-30T10:39:53+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.017573s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [2021-11-30T10:39:56+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.012007s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023590s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006257s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019087s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020235s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022286s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000439s ] --------------------------------------------------------------- [2021-11-30T10:40:00+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.000658s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024441s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000946s ] [ 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.000713s ] [ 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-11-30T10:40:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/City/index.html?spm=m-2-1&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000675s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022067s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000925s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000550s ] [ 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 15,15 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (1,3) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000426s ] --------------------------------------------------------------- [2021-11-30T10:40:22+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.006472s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023197s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000944s ] [ 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.000468s ] [ 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.000462s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000380s ] --------------------------------------------------------------- [2021-11-30T10:40: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.000857s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023868s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000982s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018832s ] [ 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.013237s ] [ 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.008104s ] --------------------------------------------------------------- [2021-11-30T10:40:30+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.014767s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022399s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000667s ] --------------------------------------------------------------- [2021-11-30T10:40:31+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.006855s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023652s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000998s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021541s ] [ 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.007426s ] [ 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.000541s ] --------------------------------------------------------------- [2021-11-30T10:41:57+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=&page=2 [ 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.023207s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000957s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025633s ] [ 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.007629s ] [ 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 15,15 [ RunTime:0.000537s ] --------------------------------------------------------------- [2021-11-30T11:02:05+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.011927s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024213s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000568s ] [ 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.000565s ] --------------------------------------------------------------- [2021-11-30T11:02:13+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000674s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022863s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000571s ] [ sql ] [ SQL ] SELECT `id`,`letter`,`name`,`create_time` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 ORDER BY `letter` LIMIT 15,15 [ RunTime:0.000591s ] --------------------------------------------------------------- [2021-11-30T11:02:21+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000689s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.022512s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000500s ] --------------------------------------------------------------- [2021-11-30T11:02:23+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.000718s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023824s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000948s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017367s ] [ 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.012426s ] [ 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.008183s ] --------------------------------------------------------------- [2021-11-30T11:02:34+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000685s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024529s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000660s ] --------------------------------------------------------------- [2021-11-30T11:02:51+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=209&city_id=214 [ sql ] [ DB ] CONNECT:[ UseTime:0.007456s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028889s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000981s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015756s ] [ 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` = 209 AND `city_id` = 214 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000791s ] [ 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` = 209 AND `city_id` = 214 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000684s ] --------------------------------------------------------------- [2021-11-30T13:44:51+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.003231s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029132s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001019s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017293s ] [ 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.012344s ] [ 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.007847s ] --------------------------------------------------------------- [2021-11-30T13:44:55+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.011509s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023449s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000520s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000482s ] --------------------------------------------------------------- [2021-11-30T13:44:57+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.011316s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.041482s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000547s ] [ 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.000560s ] --------------------------------------------------------------- [2021-11-30T13:44:59+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/grade.html?spm=m-2-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000967s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.024990s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000487s ] --------------------------------------------------------------- [2021-11-30T13:45:03+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.002594s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023946s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000642s ] [ 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.000612s ] --------------------------------------------------------------- [2021-11-30T13:45:07+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Contacts/index.html?spm=m-2-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.010831s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.037762s ] [ 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.000686s ] [ 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.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.018837s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.001185s ] --------------------------------------------------------------- [2021-11-30T13:45:09+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.011921s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023666s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000547s ] [ 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.000380s ] --------------------------------------------------------------- [2021-11-30T14:18:10+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.000786s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.024449s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [2021-11-30T14:18:12+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.000709s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024159s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006169s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018271s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019621s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019854s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000549s ]