--------------------------------------------------------------- [2021-11-29T08:58:54+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.000797s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.033607s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [2021-11-29T08:58:55+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.000712s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.035849s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.007102s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.025572s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020403s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027908s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000561s ] --------------------------------------------------------------- [2021-11-29T08:58:58+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.000689s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.023551s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [2021-11-29T08:59:00+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.002843s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.039635s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.011803s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032216s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045877s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039387s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000485s ] --------------------------------------------------------------- [2021-11-29T08:59:00+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.001457s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.030486s ] [ 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.036366s ] [ 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.022974s ] [ 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.014322s ] --------------------------------------------------------------- [2021-11-29T08:59:04+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.000648s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.027331s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018647s ] [ 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.012383s ] [ 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.007978s ] --------------------------------------------------------------- [2021-11-29T08:59:09+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.006238s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022699s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000553s ] [ 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.000547s ] --------------------------------------------------------------- [2021-11-29T08:59:15+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/department/edit.html?id=13&spm=m-2-3&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.011005s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024074s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `id` = 13 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000557s ] --------------------------------------------------------------- [2021-11-29T09:02:13+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.004178s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.029162s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000616s ] [ 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.000620s ] --------------------------------------------------------------- [2021-11-29T09:13:58+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.000829s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026810s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000981s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018079s ] [ 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.012170s ] [ 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.008085s ] --------------------------------------------------------------- [2021-11-29T09:13: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.000718s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.024317s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000524s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000478s ] --------------------------------------------------------------- [2021-11-29T09:14:04+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.006047s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.022708s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 15,15 [ RunTime:0.000447s ] --------------------------------------------------------------- [2021-11-29T09:14:09+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.024595s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000554s ] [ 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.000562s ] --------------------------------------------------------------- [2021-11-29T09:14:11+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.023565s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001010s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016887s ] [ 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.012111s ] [ 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.007804s ] --------------------------------------------------------------- [2021-11-29T09:14:24+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000665s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024364s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000654s ] --------------------------------------------------------------- [2021-11-29T09:14:28+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=4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000710s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024668s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000960s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018542s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001127s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000678s ] --------------------------------------------------------------- [2021-11-29T09:14:35+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=4&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024102s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000985s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018240s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001042s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000729s ] --------------------------------------------------------------- [2021-11-29T09:14:40+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=4&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000676s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022654s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000942s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018946s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001007s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 30,15 [ RunTime:0.000649s ] --------------------------------------------------------------- [2021-11-29T09:14:51+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=4&page=4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000644s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022676s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000972s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017329s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000922s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 45,15 [ RunTime:0.000760s ] --------------------------------------------------------------- [2021-11-29T09:14:53+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=4&page=5 [ sql ] [ DB ] CONNECT:[ UseTime:0.000650s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022675s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000945s ] [ 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.016789s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000968s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 60,15 [ RunTime:0.000721s ] --------------------------------------------------------------- [2021-11-29T09:14:59+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=4&page=6 [ 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.025359s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018494s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001053s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 75,15 [ RunTime:0.000888s ] --------------------------------------------------------------- [2021-11-29T09:15:04+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=4&page=7 [ sql ] [ DB ] CONNECT:[ UseTime:0.004532s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023375s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015865s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000935s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 90,15 [ RunTime:0.000964s ] --------------------------------------------------------------- [2021-11-29T09:15:08+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=4&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023548s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000961s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017457s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000977s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.000987s ] --------------------------------------------------------------- [2021-11-29T09:21:36+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=350&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.011630s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025971s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 350 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016985s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000596s ] --------------------------------------------------------------- [2021-11-29T09:21:54+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.005101s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.045020s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '安徽省精神卫生防治中心' , `phone` = '0551-3616124' , `addess` = '合肥市黄山路316号' WHERE `id` = 350 [ RunTime:0.004165s ] --------------------------------------------------------------- [2021-11-29T09:21:56+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=4&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.011671s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023678s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016428s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000992s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.001042s ] --------------------------------------------------------------- [2021-11-29T09:25:34+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=352&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000733s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028616s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 352 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.018610s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000601s ] --------------------------------------------------------------- [2021-11-29T09:26:05+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000758s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025992s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '安徽中医药大学第二附属医院' , `phone` = '0551-62668870' , `addess` = '安徽合肥市六安路205号' WHERE `id` = 352 [ RunTime:0.003191s ] --------------------------------------------------------------- [2021-11-29T09:26:07+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=4&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.000828s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024861s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.042800s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001529s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.001154s ] --------------------------------------------------------------- [2021-11-29T09:27:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=353&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.004340s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027389s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 353 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016080s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000528s ] --------------------------------------------------------------- [2021-11-29T09:27:45+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.010121s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025129s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '安徽医科大学第一附属医院(绩溪路)' , `phone` = '0551-62922800' , `addess` = '安徽省合肥市蜀山区绩溪路218号' WHERE `id` = 353 [ RunTime:0.003309s ] --------------------------------------------------------------- [2021-11-29T09:27:47+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=4&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024138s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000988s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019102s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000976s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.000909s ] --------------------------------------------------------------- [2021-11-29T09:29:25+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=354&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000691s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025465s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 354 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015572s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] --------------------------------------------------------------- [2021-11-29T09:29:32+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.009851s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024332s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '中国人民解放军第一Ｏ五医院' , `phone` = '0551-5141123' , `addess` = '安徽省合肥市蜀山区长江西路424号' WHERE `id` = 354 [ RunTime:0.002391s ] --------------------------------------------------------------- [2021-11-29T09:29:35+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=4&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.000687s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024068s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000956s ] [ 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.016718s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000952s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.000859s ] --------------------------------------------------------------- [2021-11-29T09:31:09+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=4&page=9 [ 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.025606s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017618s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000997s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 120,15 [ RunTime:0.000995s ] --------------------------------------------------------------- [2021-11-29T09:32:03+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=357&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.014781s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029588s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 357 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.018164s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000524s ] --------------------------------------------------------------- [2021-11-29T09:32:11+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024076s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '合肥市第二人民医院' , `phone` = '0551-2203500' , `addess` = '安徽省合肥市瑶海区和平路246号' WHERE `id` = 357 [ RunTime:0.002282s ] --------------------------------------------------------------- [2021-11-29T09:32:13+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=4&page=9 [ sql ] [ DB ] CONNECT:[ UseTime:0.004352s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025284s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000980s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018921s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001097s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 120,15 [ RunTime:0.001042s ] --------------------------------------------------------------- [2021-11-29T09:38:06+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=360&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000770s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026552s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 360 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015720s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000484s ] --------------------------------------------------------------- [2021-11-29T09:38:35+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000684s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023111s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '合肥市妇幼保健院' , `phone` = '0551-69118199' , `addess` = '安徽省合肥市庐阳区益民街15号' WHERE `id` = 360 [ RunTime:0.002515s ] --------------------------------------------------------------- [2021-11-29T09:38:37+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=4&page=9 [ sql ] [ DB ] CONNECT:[ UseTime:0.000722s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026176s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001002s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 3 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021671s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001092s ] [ 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 `city_id` = 4 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 120,15 [ RunTime:0.000986s ] --------------------------------------------------------------- [2021-11-29T09:42:19+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000703s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025494s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 20 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000588s ] --------------------------------------------------------------- [2021-11-29T09:42:42+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000672s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023087s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000685s ] --------------------------------------------------------------- [2021-11-29T09:43:20+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000693s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026984s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 388 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000659s ] --------------------------------------------------------------- [2021-11-29T09:43:26+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=388&city_id=389 [ sql ] [ DB ] CONNECT:[ UseTime:0.000687s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024399s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000973s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 388 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018436s ] [ 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` = 388 AND `city_id` = 389 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000819s ] [ 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` = 388 AND `city_id` = 389 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000564s ] --------------------------------------------------------------- [2021-11-29T10:03:42+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.000688s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028876s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000718s ] --------------------------------------------------------------- [2021-11-29T10:03:48+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.007292s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023396s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000965s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018751s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000569s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000558s ] --------------------------------------------------------------- [2021-11-29T10:04:15+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=19603&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.013867s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023740s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 19603 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017364s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000525s ] --------------------------------------------------------------- [2021-11-29T10:05:04+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027095s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '山东省立医院' , `phone` = '0531-96717120' , `addess` = '山东省济南市槐荫区经五纬七路324号' WHERE `id` = 19603 [ RunTime:0.003868s ] --------------------------------------------------------------- [2021-11-29T10:05:06+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.003188s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024631s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001024s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017586s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000592s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000566s ] --------------------------------------------------------------- [2021-11-29T10:05:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=19604&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000710s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026977s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 19604 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017460s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000639s ] --------------------------------------------------------------- [2021-11-29T10:06:03+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.011559s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025849s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 22 , `name` = '山东省千佛山医院' , `phone` = '0531-89268763' , `addess` = '山东省济南市历下区经十路16766号' WHERE `id` = 19604 [ RunTime:0.002405s ] --------------------------------------------------------------- [2021-11-29T10:06:05+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.002544s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023056s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000972s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017466s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000604s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000554s ] --------------------------------------------------------------- [2021-11-29T10:06:18+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=19604&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.004251s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024305s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 19604 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016797s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000514s ] --------------------------------------------------------------- [2021-11-29T10:06:22+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.011020s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026678s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 10 , `name` = '山东省千佛山医院' , `phone` = '0531-89268763' , `addess` = '山东省济南市历下区经十路16766号' WHERE `id` = 19604 [ RunTime:0.002627s ] --------------------------------------------------------------- [2021-11-29T10:06:25+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.015520s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023192s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000951s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017550s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000613s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000550s ] --------------------------------------------------------------- [2021-11-29T10:08:55+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000687s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024518s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001012s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016151s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000481s ] --------------------------------------------------------------- [2021-11-29T10:10:47+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000717s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028514s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016391s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市中医院' , '0531-86921476' , '济南市共青团路76号' , '济南' , '山东省' , 0 , 0 , 1638151847 , '2021-11-29 10:10:47') [ RunTime:0.004192s ] --------------------------------------------------------------- [2021-11-29T10:10:49+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.008906s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023294s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016694s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000646s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000575s ] --------------------------------------------------------------- [2021-11-29T10:10:52+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.007324s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023899s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000984s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015704s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000515s ] --------------------------------------------------------------- [2021-11-29T10:13:13+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028614s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016936s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东省中西医结合医院' , '0531-82436024' , '山东省济南市经八路1号' , '济南' , '山东省' , 0 , 0 , 1638151993 , '2021-11-29 10:13:13') [ RunTime:0.003451s ] --------------------------------------------------------------- [2021-11-29T10:13:15+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.013901s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023885s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000985s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017679s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000766s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000594s ] --------------------------------------------------------------- [2021-11-29T10:13:42+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.002410s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023902s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000960s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015566s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000482s ] --------------------------------------------------------------- [2021-11-29T10:16:10+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000704s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025348s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016696s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东中医药大学附属眼科医院' , '0531-82862666' , '济南英雄山路48号' , '济南' , '山东省' , 0 , 0 , 1638152170 , '2021-11-29 10:16:10') [ RunTime:0.003494s ] --------------------------------------------------------------- [2021-11-29T10:16:13+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.010638s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023104s ] [ 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` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017892s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000647s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000600s ] --------------------------------------------------------------- [2021-11-29T10:16:17+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.005249s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024132s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000969s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015863s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000548s ] --------------------------------------------------------------- [2021-11-29T10:17:27+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.011791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025113s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000471s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016338s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '枣庄市立医院' , '0632-3288037' , '山东省枣庄市龙头路41号' , '济南' , '山东省' , 0 , 0 , 1638152247 , '2021-11-29 10:17:27') [ RunTime:0.004269s ] --------------------------------------------------------------- [2021-11-29T10:17:29+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.015636s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024404s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000985s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017344s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000616s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000624s ] --------------------------------------------------------------- [2021-11-29T10:19:00+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.008910s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024903s ] [ 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` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015848s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000525s ] --------------------------------------------------------------- [2021-11-29T10:19:35+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.003619s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023520s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017740s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东大学齐鲁医院' , '0531-82169114' , '济南市历下区文化西路107号' , '济南' , '山东省' , 0 , 0 , 1638152375 , '2021-11-29 10:19:35') [ RunTime:0.004084s ] --------------------------------------------------------------- [2021-11-29T10:19:37+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.009567s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024699s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000945s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018263s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000650s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000616s ] --------------------------------------------------------------- [2021-11-29T10:19:56+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.021516s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.027247s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000937s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015815s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000475s ] --------------------------------------------------------------- [2021-11-29T10:20:55+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.014322s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022650s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017214s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东中医药大学附属医院' , '0531-82950414' , '济南市文化西路42号' , '济南' , '山东省' , 0 , 0 , 1638152455 , '2021-11-29 10:20:55') [ RunTime:0.003962s ] --------------------------------------------------------------- [2021-11-29T10:20:57+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.005065s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029108s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001080s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017890s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000698s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000677s ] --------------------------------------------------------------- [2021-11-29T10:21:02+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.010548s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024295s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000950s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017859s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000593s ] --------------------------------------------------------------- [2021-11-29T10:22:25+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.013989s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028854s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017646s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东手足外科医院' , '0531-86120120' , '济南市经十西路1266号宋庄立交桥下' , '济南' , '山东省' , 0 , 0 , 1638152545 , '2021-11-29 10:22:25') [ RunTime:0.003089s ] --------------------------------------------------------------- [2021-11-29T10:22:28+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.009906s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023077s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000975s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016727s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000690s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000623s ] --------------------------------------------------------------- [2021-11-29T10:22:31+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000832s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023515s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000939s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016735s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] --------------------------------------------------------------- [2021-11-29T10:23:39+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.009217s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029510s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017405s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市中心医院' , '0531-85695114' , '济南市解放路105号' , '济南' , '山东省' , 0 , 0 , 1638152619 , '2021-11-29 10:23:39') [ RunTime:0.003903s ] --------------------------------------------------------------- [2021-11-29T10:23:41+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.008565s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024827s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000994s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020354s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000727s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000683s ] --------------------------------------------------------------- [2021-11-29T10:25:03+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.006589s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024137s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000925s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016418s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000474s ] --------------------------------------------------------------- [2021-11-29T10:26:11+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.005089s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024729s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017050s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南军区总医院' , '0531-51666114' , '山东省济南市天桥区师范路25号' , '济南' , '山东省' , 0 , 0 , 1638152771 , '2021-11-29 10:26:11') [ RunTime:0.004169s ] --------------------------------------------------------------- [2021-11-29T10:26:13+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.011798s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023917s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000967s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017733s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000612s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000666s ] --------------------------------------------------------------- [2021-11-29T10:26:15+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.006647s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037124s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016212s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000586s ] --------------------------------------------------------------- [2021-11-29T10:27:12+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000676s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023555s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016038s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济宁市第一人民医院' , '0537-6056666' , '山东省济宁市任城区健康路6号' , '济南' , '山东省' , 0 , 0 , 1638152832 , '2021-11-29 10:27:12') [ RunTime:0.003990s ] --------------------------------------------------------------- [2021-11-29T10:27:14+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022948s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000935s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015721s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000625s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000745s ] --------------------------------------------------------------- [2021-11-29T10:27:24+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.013080s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023353s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000936s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015030s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000494s ] --------------------------------------------------------------- [2021-11-29T10:28:41+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.009519s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023365s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017643s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东大学附属济南市中心医院' , '0531-85695114' , '山东省济南市历下区解放路105号' , '济南' , '山东省' , 0 , 0 , 1638152921 , '2021-11-29 10:28:41') [ RunTime:0.004493s ] --------------------------------------------------------------- [2021-11-29T10:28:43+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023947s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000984s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000567s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016678s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000659s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000710s ] --------------------------------------------------------------- [2021-11-29T10:28:45+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.010667s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023648s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000950s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017719s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] --------------------------------------------------------------- [2021-11-29T10:30:07+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.009678s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026399s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000471s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016293s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东大学第二医院 ' , '0531-88197777' , '山东省济南市天桥区北园大街247号' , '济南' , '山东省' , 0 , 0 , 1638153007 , '2021-11-29 10:30:07') [ RunTime:0.002726s ] --------------------------------------------------------------- [2021-11-29T10:30:10+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.013975s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023507s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018899s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000710s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000729s ] --------------------------------------------------------------- [2021-11-29T10:30:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000863s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024489s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001025s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017868s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000605s ] --------------------------------------------------------------- [2021-11-29T10:31:02+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.001202s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037173s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001050s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.028580s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000572s ] --------------------------------------------------------------- [2021-11-29T10:32:15+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.007966s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024872s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016435s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市妇幼保健院 ' , '0531-89029000' , '山东省济南市市中区建国小经三路2号' , '济南' , '山东省' , 0 , 0 , 1638153135 , '2021-11-29 10:32:15') [ RunTime:0.004105s ] --------------------------------------------------------------- [2021-11-29T10:32:17+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.005672s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026105s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000966s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.033477s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000745s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000675s ] --------------------------------------------------------------- [2021-11-29T10:43:50+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024239s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000983s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017374s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] --------------------------------------------------------------- [2021-11-29T10:44:23+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000665s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023138s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001048s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017183s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000593s ] --------------------------------------------------------------- [2021-11-29T10:45:37+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ 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.023124s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018334s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东中医药大学附属第二医院' , '0531-82436474' , '山东省济南市市中区经八路1号' , '济南' , '山东省' , 0 , 0 , 1638153937 , '2021-11-29 10:45:37') [ RunTime:0.004000s ] --------------------------------------------------------------- [2021-11-29T10:45:39+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.000787s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028404s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001046s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021599s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000912s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000788s ] --------------------------------------------------------------- [2021-11-29T10:45:44+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000692s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024964s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000991s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000556s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017784s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000603s ] --------------------------------------------------------------- [2021-11-29T10:46:32+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.004933s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024034s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017492s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东大学齐鲁儿童医院 ' , '0531-87964990' , '山东省济南市槐荫区经十路430号' , '济南' , '山东省' , 0 , 0 , 1638153992 , '2021-11-29 10:46:32') [ RunTime:0.007152s ] --------------------------------------------------------------- [2021-11-29T10:46:34+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.003726s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023430s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000971s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016737s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000872s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000689s ] --------------------------------------------------------------- [2021-11-29T10:46:36+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000666s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023841s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015844s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000853s ] --------------------------------------------------------------- [2021-11-29T10:47:22+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000661s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024602s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016630s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东大学附属口腔医院 ' , '0531-88382843' , '山东省济南市历下区文化西路44之1号' , '济南' , '山东省' , 0 , 0 , 1638154042 , '2021-11-29 10:47:22') [ RunTime:0.003908s ] --------------------------------------------------------------- [2021-11-29T10:47:24+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ 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.023662s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017091s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000696s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000744s ] --------------------------------------------------------------- [2021-11-29T10:47:30+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023875s ] [ 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` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018302s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000686s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000583s ] --------------------------------------------------------------- [2021-11-29T10:47:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000661s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026556s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017838s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000708s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000705s ] --------------------------------------------------------------- [2021-11-29T10:47:42+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.013464s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023706s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001020s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000556s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017884s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000577s ] --------------------------------------------------------------- [2021-11-29T10:49:27+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026028s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018101s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市第四人民医院' , '0531-81313114' , '山东省济南市天桥区师范路50号' , '济南' , '山东省' , 0 , 0 , 1638154167 , '2021-11-29 10:49:27') [ RunTime:0.002923s ] --------------------------------------------------------------- [2021-11-29T10:49:29+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000727s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024796s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018400s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000806s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000757s ] --------------------------------------------------------------- [2021-11-29T10:49:32+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023236s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001036s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015955s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000516s ] --------------------------------------------------------------- [2021-11-29T10:50:18+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000722s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.030181s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000774s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017812s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '山东省妇产医院' , '0531-68795888' , '山东省济南市历下区经十东路238号' , '济南' , '山东省' , 0 , 0 , 1638154218 , '2021-11-29 10:50:18') [ RunTime:0.004547s ] --------------------------------------------------------------- [2021-11-29T10:50:21+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005741s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024555s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000956s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018353s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000770s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000733s ] --------------------------------------------------------------- [2021-11-29T10:50:24+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000702s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026748s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000975s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.018444s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000620s ] --------------------------------------------------------------- [2021-11-29T10:51:10+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ 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.023995s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018204s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '枣庄市立医院' , '0632-3227305' , '山东省枣庄市市中区龙头路41号' , '济南' , '山东省' , 0 , 0 , 1638154270 , '2021-11-29 10:51:10') [ RunTime:0.006303s ] --------------------------------------------------------------- [2021-11-29T10:51:13+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000775s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025505s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001061s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018711s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000858s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000787s ] --------------------------------------------------------------- [2021-11-29T10:51:29+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ 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.030932s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001029s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018666s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000743s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000668s ] --------------------------------------------------------------- [2021-11-29T10:51:33+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=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.023382s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001085s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018160s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000729s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000662s ] --------------------------------------------------------------- [2021-11-29T10:51:38+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/remove.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000700s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026868s ] [ sql ] [ SQL ] SELECT `id` FROM `v_item` WHERE `hospital_id` = 19637 AND `status` = 0 LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020075s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 19637 AND `status` = 0 [ RunTime:0.004139s ] --------------------------------------------------------------- [2021-11-29T10:51:41+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024081s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018022s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000595s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000868s ] --------------------------------------------------------------- [2021-11-29T10:51:44+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&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.023655s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000986s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016613s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000660s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000676s ] --------------------------------------------------------------- [2021-11-29T10:51:47+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ 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.025869s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017921s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000590s ] --------------------------------------------------------------- [2021-11-29T10:53:09+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000784s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.224859s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.043958s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '章丘区中医院' , '0531-83265034' , '章丘市明水镇秀水大街175号' , '济南' , '山东省' , 0 , 0 , 1638154389 , '2021-11-29 10:53:09') [ RunTime:0.003620s ] --------------------------------------------------------------- [2021-11-29T10:53:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001370s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029394s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000980s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.035020s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000806s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000681s ] --------------------------------------------------------------- [2021-11-29T10:53:47+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.218639s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001038s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.035387s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000694s ] --------------------------------------------------------------- [2021-11-29T10:54:35+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.014117s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.028046s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017897s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '枣庄市立第三医院' , '0632-3699307' , '枣庄市市中区文化东路25号' , '济南' , '山东省' , 0 , 0 , 1638154475 , '2021-11-29 10:54:35') [ RunTime:0.004005s ] --------------------------------------------------------------- [2021-11-29T10:54:37+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000716s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025961s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017785s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000783s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000687s ] --------------------------------------------------------------- [2021-11-29T10:54:42+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000683s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023998s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000947s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016834s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000486s ] --------------------------------------------------------------- [2021-11-29T10:55:35+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025288s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000442s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.036048s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '枣庄市中医医院' , '0632－3068213' , '山东省枣庄市市中区公胜街24号' , '济南' , '山东省' , 0 , 0 , 1638154535 , '2021-11-29 10:55:35') [ RunTime:0.004263s ] --------------------------------------------------------------- [2021-11-29T10:55:37+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000673s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.027379s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000980s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000546s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017898s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000818s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000698s ] --------------------------------------------------------------- [2021-11-29T10:55:59+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000701s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023951s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016795s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000493s ] --------------------------------------------------------------- [2021-11-29T10:56:28+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000670s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022948s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.022330s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市明水眼科医院' , '0531-83778120' , '山东省章丘市明水赭山工业园' , '济南' , '山东省' , 0 , 0 , 1638154588 , '2021-11-29 10:56:28') [ RunTime:0.003963s ] --------------------------------------------------------------- [2021-11-29T10:56:30+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023694s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000924s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017614s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000760s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000720s ] --------------------------------------------------------------- [2021-11-29T10:56:33+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000636s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023859s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000948s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017321s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000496s ] --------------------------------------------------------------- [2021-11-29T11:04:50+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.000809s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025781s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001028s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.017496s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000584s ] --------------------------------------------------------------- [2021-11-29T11:30:06+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.007000s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.030480s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001020s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018478s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000841s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000674s ] --------------------------------------------------------------- [2021-11-29T11:30:38+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.010698s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023986s ] [ 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` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018104s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000733s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000719s ] --------------------------------------------------------------- [2021-11-29T11:31:26+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=%E6%B5%8E%E5%8D%97%E5%B8%82%E7%AC%AC%E5%9B%9B%E4%BA%BA%E6%B0%91%E5%8C%BB%E9%99%A2+&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.009032s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.027428s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000925s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016640s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`name` LIKE '%济南市第四人民医院 %' AND `province_id` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000658s ] [ 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`.`name` LIKE '%济南市第四人民医院 %' AND `province_id` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000605s ] --------------------------------------------------------------- [2021-11-29T11:31:32+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/add.html?province_id=278&city_id=283&spm=m-2-2&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023562s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000925s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.015804s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000505s ] --------------------------------------------------------------- [2021-11-29T11:32:07+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/add.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023482s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 1 AND `id` = 283 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SELECT * FROM `v_city` WHERE `level` = 0 AND `id` = 278 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016968s ] [ sql ] [ SQL ] INSERT INTO `v_hospital` (`province_id` , `city_id` , `grade_id` , `name` , `phone` , `addess` , `city` , `province` , `status` , `is_delete` , `create_time` , `create_date`) VALUES (278 , 283 , 10 , '济南市第四人民医院 ' , '0531-81313114' , '山东省济南市天桥区师范路50号' , '济南' , '山东省' , 0 , 0 , 1638156727 , '2021-11-29 11:32:07') [ RunTime:0.005471s ] --------------------------------------------------------------- [2021-11-29T11:32:10+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=%E6%B5%8E%E5%8D%97%E5%B8%82%E7%AC%AC%E5%9B%9B%E4%BA%BA%E6%B0%91%E5%8C%BB%E9%99%A2+&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.007133s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023208s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000922s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017477s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`name` LIKE '%济南市第四人民医院 %' AND `province_id` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000771s ] [ 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`.`name` LIKE '%济南市第四人民医院 %' AND `province_id` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000712s ] --------------------------------------------------------------- [2021-11-29T11:32:20+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283 [ sql ] [ DB ] CONNECT:[ UseTime:0.006012s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024451s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000954s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016130s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000881s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000702s ] --------------------------------------------------------------- [2021-11-29T11:32:23+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Hospital/index.html?spm=m-2-2&name=&province_id=278&city_id=283&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.004000s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023232s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000908s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 278 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017504s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000740s ] [ 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` = 278 AND `city_id` = 283 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000689s ] --------------------------------------------------------------- [2021-11-29T11:33:19+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/Hospital/city [ sql ] [ DB ] CONNECT:[ UseTime:0.008559s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025790s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000674s ] --------------------------------------------------------------- [2021-11-29T11:33:33+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.014534s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024380s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018790s ] [ 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.001282s ] [ 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.000713s ] --------------------------------------------------------------- [2021-11-29T11:33:52+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=215 [ sql ] [ DB ] CONNECT:[ UseTime:0.013104s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023006s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000934s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015575s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002200s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 0,15 [ RunTime:0.000580s ] --------------------------------------------------------------- [2021-11-29T11:34:00+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=215&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.011582s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026014s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001040s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019224s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002047s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000630s ] --------------------------------------------------------------- [2021-11-29T11:37:32+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/hospital/edit.html?id=17730&spm=m-2-2&open_type=modal [ 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.027264s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital` WHERE `id` = 17730 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.016465s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_hospital_grade` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000489s ] --------------------------------------------------------------- [2021-11-29T11:37:49+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/hospital/edit.html?spm=m-2-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.006011s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030130s ] [ sql ] [ SQL ] UPDATE `v_hospital` SET `grade_id` = 6 , `name` = '苏州市吴中人民医院' , `phone` = '0512-33333600' , `addess` = '苏州市东吴北路61号' WHERE `id` = 17730 [ RunTime:0.003599s ] --------------------------------------------------------------- [2021-11-29T11:37: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=215&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.008406s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023210s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018025s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001884s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 15,15 [ RunTime:0.000620s ] --------------------------------------------------------------- [2021-11-29T11:38:16+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=215&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000700s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024115s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000947s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019225s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001901s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 30,15 [ RunTime:0.000654s ] --------------------------------------------------------------- [2021-11-29T11:39:44+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012019s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.024310s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'hospital' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [2021-11-29T11:39:46+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.008296s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.006921s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018936s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018165s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017981s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000430s ] --------------------------------------------------------------- [2021-11-29T11:39: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.015460s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023919s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001011s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017288s ] [ 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.012633s ] [ 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.007861s ] --------------------------------------------------------------- [2021-11-29T11:39:59+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.013839s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.026511s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000586s ] [ 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.000549s ] --------------------------------------------------------------- [2021-11-29T11:40:00+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=215&page=4 [ sql ] [ DB ] CONNECT:[ UseTime:0.014516s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024245s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000961s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018271s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001932s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 45,15 [ RunTime:0.000696s ] --------------------------------------------------------------- [2021-11-29T11:40:01+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.007543s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.022666s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000548s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000488s ] --------------------------------------------------------------- [2021-11-29T11:40:04+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.000704s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023354s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000543s ] [ 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.000555s ] --------------------------------------------------------------- [2021-11-29T11:40:12+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=215&page=5 [ sql ] [ DB ] CONNECT:[ UseTime:0.014975s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023794s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001007s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019883s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002009s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 60,15 [ RunTime:0.000740s ] --------------------------------------------------------------- [2021-11-29T11:40:34+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=215&page=6 [ sql ] [ DB ] CONNECT:[ UseTime:0.014415s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022889s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000973s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017063s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002007s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 75,15 [ RunTime:0.000751s ] --------------------------------------------------------------- [2021-11-29T11:40:39+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=215&page=7 [ sql ] [ DB ] CONNECT:[ UseTime:0.003638s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025185s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001042s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018902s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002011s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 90,15 [ RunTime:0.000789s ] --------------------------------------------------------------- [2021-11-29T11:40:43+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=215&page=8 [ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024495s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019048s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001970s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 105,15 [ RunTime:0.000835s ] --------------------------------------------------------------- [2021-11-29T11:40:46+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=215&page=9 [ sql ] [ DB ] CONNECT:[ UseTime:0.011138s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024475s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001002s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017704s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001959s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 120,15 [ RunTime:0.000951s ] --------------------------------------------------------------- [2021-11-29T11:40:53+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=215&page=31 [ sql ] [ DB ] CONNECT:[ UseTime:0.000847s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023024s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000960s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017447s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001898s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 450,15 [ RunTime:0.001366s ] --------------------------------------------------------------- [2021-11-29T13:19:07+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.000991s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.029163s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000492s ] --------------------------------------------------------------- [2021-11-29T13:19:23+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.011955s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023718s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 15,15 [ RunTime:0.000485s ] --------------------------------------------------------------- [2021-11-29T13:19:25+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.009717s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023210s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000565s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000534s ] --------------------------------------------------------------- [2021-11-29T13:19:32+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.000632s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000515s ] [ 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.000562s ] --------------------------------------------------------------- [2021-11-29T13:19: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.000695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.026794s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018222s ] [ 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.012167s ] [ 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.007851s ] --------------------------------------------------------------- [2021-11-29T13:19:38+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.000695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023861s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000588s ] [ 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-29T13:19:40+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.000692s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025028s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000933s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000579s ] [ 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.000724s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000401s ] --------------------------------------------------------------- [2021-11-29T13:19:42+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.003166s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023651s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021331s ] [ 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.011989s ] [ 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.007741s ] --------------------------------------------------------------- [2021-11-29T13:33:14+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=215&page=23 [ sql ] [ DB ] CONNECT:[ UseTime:0.013452s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024281s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000995s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000471s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016512s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001863s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 330,15 [ RunTime:0.001183s ] --------------------------------------------------------------- [2021-11-29T13:33:17+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=215&page=24 [ sql ] [ DB ] CONNECT:[ UseTime:0.007044s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023009s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000470s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017037s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001922s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 345,15 [ RunTime:0.001191s ] --------------------------------------------------------------- [2021-11-29T13:33:21+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=215&page=25 [ sql ] [ DB ] CONNECT:[ UseTime:0.000667s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022933s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001041s ] [ 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.017138s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001906s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 360,15 [ RunTime:0.001227s ] --------------------------------------------------------------- [2021-11-29T13:33:23+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=215&page=27 [ sql ] [ DB ] CONNECT:[ UseTime:0.008081s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023511s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000984s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017624s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001959s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 390,15 [ RunTime:0.001277s ] --------------------------------------------------------------- [2021-11-29T13:33:28+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=215&page=29 [ sql ] [ DB ] CONNECT:[ UseTime:0.000683s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024105s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000928s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 1 AND `parent_id` = 209 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.016602s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001895s ] [ 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` = 215 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 ORDER BY `province_id` LIMIT 420,15 [ RunTime:0.001322s ] --------------------------------------------------------------- [2021-11-29T13:33:46+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.010095s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023737s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000522s ] [ 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-29T13:37:09+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000710s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024643s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('男科' , 'N' , 0 , 0 , 1638164229 , '2021-11-29 13:37:09') [ RunTime:0.003265s ] --------------------------------------------------------------- [2021-11-29T13:37:12+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.013096s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024151s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000579s ] [ 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.000577s ] --------------------------------------------------------------- [2021-11-29T13:37:16+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.008001s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024664s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000598s ] [ 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.000580s ] --------------------------------------------------------------- [2021-11-29T13:37:19+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.014959s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023371s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000552s ] [ 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.000562s ] --------------------------------------------------------------- [2021-11-29T13:37:52+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.004427s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.029074s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('妇产科' , 'F' , 0 , 0 , 1638164272 , '2021-11-29 13:37:52') [ RunTime:0.004039s ] --------------------------------------------------------------- [2021-11-29T13:37:54+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.008120s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024096s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000561s ] [ 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.000572s ] --------------------------------------------------------------- [2021-11-29T13:38:24+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.001444s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024100s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000598s ] [ 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.000570s ] --------------------------------------------------------------- [2021-11-29T13:38:26+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005486s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023534s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000531s ] [ 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.000574s ] --------------------------------------------------------------- [2021-11-29T13:38:40+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000684s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024100s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('皮肤性病科' , 'P' , 0 , 0 , 1638164319 , '2021-11-29 13:38:39') [ RunTime:0.002744s ] --------------------------------------------------------------- [2021-11-29T13:38:42+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.007597s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024153s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000600s ] [ 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.000619s ] --------------------------------------------------------------- [2021-11-29T13:39:16+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.000957s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.028272s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000570s ] [ 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.000670s ] --------------------------------------------------------------- [2021-11-29T13:39:22+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.012227s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023014s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000570s ] [ 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.000616s ] --------------------------------------------------------------- [2021-11-29T13:39:38+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.006557s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023175s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('中医科' , 'Z' , 0 , 0 , 1638164378 , '2021-11-29 13:39:38') [ RunTime:0.002404s ] --------------------------------------------------------------- [2021-11-29T13:39:40+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001227s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022514s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000504s ] [ 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.000569s ] --------------------------------------------------------------- [2021-11-29T13:39:59+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.008927s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.026942s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000552s ] [ 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.000579s ] --------------------------------------------------------------- [2021-11-29T13:40:09+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023429s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('口腔科' , 'K' , 0 , 0 , 1638164409 , '2021-11-29 13:40:09') [ RunTime:0.002110s ] --------------------------------------------------------------- [2021-11-29T13:40:11+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.010753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023757s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000577s ] [ 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.000631s ] --------------------------------------------------------------- [2021-11-29T13:40:33+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025303s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('耳鼻喉科' , 'E' , 0 , 0 , 1638164433 , '2021-11-29 13:40:33') [ RunTime:0.002351s ] --------------------------------------------------------------- [2021-11-29T13:40:36+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.015016s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023947s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000575s ] [ 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.000643s ] --------------------------------------------------------------- [2021-11-29T13:41:01+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.005277s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027099s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('医学影像科' , 'Y' , 0 , 0 , 1638164461 , '2021-11-29 13:41:01') [ RunTime:0.002131s ] --------------------------------------------------------------- [2021-11-29T13:41:03+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.008969s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025045s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000553s ] [ 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.000612s ] --------------------------------------------------------------- [2021-11-29T13:41:04+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000577s ] [ 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.000583s ] --------------------------------------------------------------- [2021-11-29T13:41:09+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.002173s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023832s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000536s ] [ 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.000589s ] --------------------------------------------------------------- [2021-11-29T13:41:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=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_department` [ RunTime:0.023231s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000585s ] [ 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.000610s ] --------------------------------------------------------------- [2021-11-29T13:41:26+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.002525s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023676s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000535s ] [ 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.000616s ] --------------------------------------------------------------- [2021-11-29T13:41:48+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.004814s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023558s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('麻醉医学科' , 'M' , 0 , 0 , 1638164508 , '2021-11-29 13:41:48') [ RunTime:0.002294s ] --------------------------------------------------------------- [2021-11-29T13:41:50+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.010441s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024057s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000566s ] [ 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.000619s ] --------------------------------------------------------------- [2021-11-29T13:42:02+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001456s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.028942s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('传染病科' , 'C' , 0 , 0 , 1638164522 , '2021-11-29 13:42:02') [ RunTime:0.002350s ] --------------------------------------------------------------- [2021-11-29T13:42:04+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.000671s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023254s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] [ 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.000619s ] --------------------------------------------------------------- [2021-11-29T13:42:29+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000671s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024100s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000611s ] [ 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.000620s ] --------------------------------------------------------------- [2021-11-29T13:42:57+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000773s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024680s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('眼科' , 'Y' , 0 , 0 , 1638164577 , '2021-11-29 13:42:57') [ RunTime:0.002315s ] --------------------------------------------------------------- [2021-11-29T13:43:00+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.003840s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023242s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000607s ] [ 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.000643s ] --------------------------------------------------------------- [2021-11-29T13:43:16+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.010143s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027060s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000548s ] [ 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.000623s ] --------------------------------------------------------------- [2021-11-29T13:43:34+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.015884s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024487s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 8 AND `status` = 0 [ RunTime:0.002366s ] --------------------------------------------------------------- [2021-11-29T13:43:37+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.015821s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024399s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000581s ] [ 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.000610s ] --------------------------------------------------------------- [2021-11-29T13:44:08+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.006899s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027856s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 1 AND `status` = 0 [ RunTime:0.002478s ] --------------------------------------------------------------- [2021-11-29T13:44:10+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.010349s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023287s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000591s ] [ 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.000637s ] --------------------------------------------------------------- [2021-11-29T13:44:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023176s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000516s ] [ 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.000568s ] --------------------------------------------------------------- [2021-11-29T13:44:17+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.011995s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.030018s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 16 AND `status` = 0 [ RunTime:0.002142s ] --------------------------------------------------------------- [2021-11-29T13:44:19+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.007874s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023556s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000541s ] [ 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.000577s ] --------------------------------------------------------------- [2021-11-29T13:44:30+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.014838s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023858s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] [ 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.000590s ] --------------------------------------------------------------- [2021-11-29T13:44:39+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.035532s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024218s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 15 AND `status` = 0 [ RunTime:0.003259s ] --------------------------------------------------------------- [2021-11-29T13:44:41+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.010393s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024551s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000592s ] [ 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.000572s ] --------------------------------------------------------------- [2021-11-29T13:44:46+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.012345s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023596s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 10 AND `status` = 0 [ RunTime:0.002065s ] --------------------------------------------------------------- [2021-11-29T13:44:49+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.006257s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024161s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000592s ] [ 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.000596s ] --------------------------------------------------------------- [2021-11-29T13:45:24+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.008213s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.028458s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000583s ] [ 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.000670s ] --------------------------------------------------------------- [2021-11-29T13:45:31+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.002726s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023641s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000558s ] [ 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.000561s ] --------------------------------------------------------------- [2021-11-29T13:45:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.011431s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023154s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] [ 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.000579s ] --------------------------------------------------------------- [2021-11-29T13:45:53+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.014735s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025248s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000596s ] [ 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.000563s ] --------------------------------------------------------------- [2021-11-29T13:46:06+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=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_department` [ RunTime:0.024261s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000621s ] [ 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.000614s ] --------------------------------------------------------------- [2021-11-29T13:46:40+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.011087s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.028892s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000575s ] [ 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.000558s ] --------------------------------------------------------------- [2021-11-29T13:46:44+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.008411s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023419s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000583s ] [ 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.000616s ] --------------------------------------------------------------- [2021-11-29T13:47:10+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.009871s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022978s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 14 AND `status` = 0 [ RunTime:0.002636s ] --------------------------------------------------------------- [2021-11-29T13:47:12+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.003416s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023423s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000550s ] [ 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.000576s ] --------------------------------------------------------------- [2021-11-29T13:47:16+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.013702s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023451s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 12 AND `status` = 0 [ RunTime:0.002271s ] --------------------------------------------------------------- [2021-11-29T13:47:18+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.014637s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024787s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000586s ] [ 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.000569s ] --------------------------------------------------------------- [2021-11-29T13:47:24+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.005139s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024063s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 17 AND `status` = 0 [ RunTime:0.004325s ] --------------------------------------------------------------- [2021-11-29T13:47:26+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001940s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022644s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000540s ] [ 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.000576s ] --------------------------------------------------------------- [2021-11-29T13:47:32+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.010592s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024285s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000630s ] [ 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-29T13:47:45+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/add.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000644s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027215s ] [ sql ] [ SQL ] INSERT INTO `v_department` (`name` , `letter` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('精神心理科' , 'J' , 0 , 0 , 1638164865 , '2021-11-29 13:47:45') [ RunTime:0.002228s ] --------------------------------------------------------------- [2021-11-29T13:47:48+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.014337s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023881s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000549s ] [ 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.000578s ] --------------------------------------------------------------- [2021-11-29T13:47:52+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.000663s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.025090s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000497s ] --------------------------------------------------------------- [2021-11-29T13:47:54+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.015083s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.036657s ] [ 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.000792s ] [ 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.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.017221s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000465s ] --------------------------------------------------------------- [2021-11-29T13:48:14+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.015010s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000574s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000539s ] --------------------------------------------------------------- [2021-11-29T13:48:48+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.009373s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.028816s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000556s ] [ 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.000579s ] --------------------------------------------------------------- [2021-11-29T13:49:30+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.010345s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.024686s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001033s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000579s ] [ 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.000953s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000406s ] --------------------------------------------------------------- [2021-11-29T13:49:31+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.010109s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.014394s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001005s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017985s ] [ 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.012959s ] [ 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.007792s ] --------------------------------------------------------------- [2021-11-29T13:49:32+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.001990s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022823s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000537s ] [ 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.000566s ] --------------------------------------------------------------- [2021-11-29T13:49:35+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/department/edit.html?id=23&spm=m-2-3&open_type=modal [ sql ] [ DB ] CONNECT:[ UseTime:0.003845s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025638s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [2021-11-29T13:49:56+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/edit.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.004290s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027628s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] UPDATE `v_department` SET `name` = '耳鼻喉头颈外科' , `letter` = 'E' WHERE `id` = 23 [ RunTime:0.002682s ] --------------------------------------------------------------- [2021-11-29T13:49:58+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.000692s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024834s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000599s ] [ 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.000620s ] --------------------------------------------------------------- [2021-11-29T13:50:04+08:00] 117.62.197.82 POST 101.132.37.87:9001/admin/department/remove.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.007800s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022662s ] [ sql ] [ SQL ] UPDATE `v_department` SET `status` = 1 , `is_delete` = 1 WHERE `id` = 13 AND `status` = 0 [ RunTime:0.004462s ] --------------------------------------------------------------- [2021-11-29T13:50:06+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.002956s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023473s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000612s ] [ 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.000614s ] --------------------------------------------------------------- [2021-11-29T13:50:14+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.014639s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.022777s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000556s ] [ 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.000563s ] --------------------------------------------------------------- [2021-11-29T13:51:33+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005105s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024927s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000576s ] [ 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.000579s ] --------------------------------------------------------------- [2021-11-29T13:51:46+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.002997s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025388s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000593s ] [ 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.000577s ] --------------------------------------------------------------- [2021-11-29T13:51:49+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.014681s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.024594s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000566s ] [ 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.000597s ] --------------------------------------------------------------- [2021-11-29T13:51: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.013321s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.027846s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000591s ] [ 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.000626s ] --------------------------------------------------------------- [2021-11-29T13:52:58+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.011589s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.029750s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000798s ] [ 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.000587s ] --------------------------------------------------------------- [2021-11-29T13:53:14+08:00] 117.62.197.82 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.012751s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.023856s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000609s ] [ 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.000610s ] --------------------------------------------------------------- [2021-11-29T13:53:40+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.003858s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital_grade` [ RunTime:0.023865s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `v_hospital_grade` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000498s ] --------------------------------------------------------------- [2021-11-29T13:53:41+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.014780s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022734s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000959s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017617s ] [ 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.012255s ] [ 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.008116s ] --------------------------------------------------------------- [2021-11-29T13:53:43+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.003806s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.023867s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000924s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_city` WHERE `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000555s ] [ 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.000718s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 1 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000388s ]