---------------------------------------------------------------

[2023-04-26T03:11:28+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.004108s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.113464s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.075980s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 28  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000624s ]
---------------------------------------------------------------

[2023-04-26T03:11:28+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000636s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.078304s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000697s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.078961s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 28  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.058287s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item  i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE  `i`.`is_delete` = 0  AND `i`.`status` IN (0,1)  AND `hospital_id` IN (18751,18752,18753,18754,18755,18756,18757,18758,18759,18760,18761,18762,18763,18764,18765,18766,18767,18768,18769,18770,18771,18772,18773,18774,18775,18776,18777,18778,18779,18780,18781,18782,18783,18784,18785,18786,18787,18788,18789,18790,18791,18792,18793,18794,18795,18796,18797,18798,18799,18800,18801,18802,18803,18804,18805,18806,18807,18808,18809,18810,18811,18812,18813,18814,18815,18816,18817,18818,18819,18820,18821,18822,18823,18824,18825,18826,18827,18828,18829,18830,18831,18832,18833,18834,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,18849,18850,18851,18852,18853,18854,18855,18856,18857,18858,18859,18860,18861,18862,18863,18864,18865,18866,18867,18868,18869,18870,18871,18872,18873,18874,18875,18876,18877,18878,18879,18880,18881,18882,18883,18884,18885,18886,18887,18888,18889,18890,18891,18892,18893,18894,18895,18896,18897,18898,18899,18900,18901,18902,18903,18904,18905,18906,18907,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18922,18923,18924,18925,18926,18927,18928,18929,18930,18931,18932,18933,18934,18935,18936,18937,18938,18939,18940,18941,18942,18943,18944,18945,18946,18947,18948,18949,18950,18951,18952,18953,18954,18955,18956,18957,18958,18959,18960,18961,18962,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,18973,18974,18975,18976,18977,18978,18979,18980,18981,18982,18983,18984,18985,18986,18987,18988,18989,18990,18991,18992,18993,18994,18995,18996,18997,18998,18999,19000,19001,19002,19003,19004,19005,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19021,19022,19023,19024,19025,19026,19027,19028,19029,19030,19031,19032,19033,19034,19035,19036,19037,19038,19039,19040,19041,19042,19043,19044,19045,19046,19047,19048,19049,19050,19051,19052,19053,19054,19055,19056,19057,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19108,19109,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19132,19133,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19172,19173,19174,19175,19176,19177,19178,19179,19180,19181,19182,19183,19184,19185,19186,19187,19188,19189,19190,19191,19192,19193,19194,19195,19196,19197,19198,19199,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19336,19337,19338,19339,19340,19341,19342,19343,19344,19345,19346,19347,19348,19349,19350,19351,19352,19353,19354,19355,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19415,19416,19417,19418,19419,19420,19421,19422,19423,19424,19425,19426,19427,19428,19429,19430,19431,19432,19433,19434,19435,19436,19437,19438,19439,19440,19441,19442,19443,19444,19445,19446,19447,19448,19449,19450,19451,19452,19453,19454,19455,19456,19457,19458,19459,19460,19461,19462,19463,19464,19465,19466,19467,19468,19469,19470,19471,19472,19473,19474,19475,19476,19477,19478,19479,19480,19481,19482,19483,19484,19485,19486,19487,19488,19489,19490,19491,19492,19493,19494,19495,19496,19497,19498,19499,19500,19501,19502,19503,19504,19505,19506,19612,19613,19614,19615,19616,19617,19618,19619,19620,19621,19622,19623,19624,19625,19626,19632,19633)  AND `i`.`staff_id` = 28 [ RunTime:0.019583s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item  i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE  `i`.`is_delete` = 0  AND `i`.`status` IN (0,1)  AND `hospital_id` IN (18751,18752,18753,18754,18755,18756,18757,18758,18759,18760,18761,18762,18763,18764,18765,18766,18767,18768,18769,18770,18771,18772,18773,18774,18775,18776,18777,18778,18779,18780,18781,18782,18783,18784,18785,18786,18787,18788,18789,18790,18791,18792,18793,18794,18795,18796,18797,18798,18799,18800,18801,18802,18803,18804,18805,18806,18807,18808,18809,18810,18811,18812,18813,18814,18815,18816,18817,18818,18819,18820,18821,18822,18823,18824,18825,18826,18827,18828,18829,18830,18831,18832,18833,18834,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,18849,18850,18851,18852,18853,18854,18855,18856,18857,18858,18859,18860,18861,18862,18863,18864,18865,18866,18867,18868,18869,18870,18871,18872,18873,18874,18875,18876,18877,18878,18879,18880,18881,18882,18883,18884,18885,18886,18887,18888,18889,18890,18891,18892,18893,18894,18895,18896,18897,18898,18899,18900,18901,18902,18903,18904,18905,18906,18907,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18922,18923,18924,18925,18926,18927,18928,18929,18930,18931,18932,18933,18934,18935,18936,18937,18938,18939,18940,18941,18942,18943,18944,18945,18946,18947,18948,18949,18950,18951,18952,18953,18954,18955,18956,18957,18958,18959,18960,18961,18962,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,18973,18974,18975,18976,18977,18978,18979,18980,18981,18982,18983,18984,18985,18986,18987,18988,18989,18990,18991,18992,18993,18994,18995,18996,18997,18998,18999,19000,19001,19002,19003,19004,19005,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19021,19022,19023,19024,19025,19026,19027,19028,19029,19030,19031,19032,19033,19034,19035,19036,19037,19038,19039,19040,19041,19042,19043,19044,19045,19046,19047,19048,19049,19050,19051,19052,19053,19054,19055,19056,19057,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19108,19109,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19132,19133,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19172,19173,19174,19175,19176,19177,19178,19179,19180,19181,19182,19183,19184,19185,19186,19187,19188,19189,19190,19191,19192,19193,19194,19195,19196,19197,19198,19199,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19336,19337,19338,19339,19340,19341,19342,19343,19344,19345,19346,19347,19348,19349,19350,19351,19352,19353,19354,19355,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19415,19416,19417,19418,19419,19420,19421,19422,19423,19424,19425,19426,19427,19428,19429,19430,19431,19432,19433,19434,19435,19436,19437,19438,19439,19440,19441,19442,19443,19444,19445,19446,19447,19448,19449,19450,19451,19452,19453,19454,19455,19456,19457,19458,19459,19460,19461,19462,19463,19464,19465,19466,19467,19468,19469,19470,19471,19472,19473,19474,19475,19476,19477,19478,19479,19480,19481,19482,19483,19484,19485,19486,19487,19488,19489,19490,19491,19492,19493,19494,19495,19496,19497,19498,19499,19500,19501,19502,19503,19504,19505,19506,19612,19613,19614,19615,19616,19617,19618,19619,19620,19621,19622,19623,19624,19625,19626,19632,19633)  AND `i`.`staff_id` = 28 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.019095s ]
---------------------------------------------------------------

[2023-04-26T03:11:30+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/Item/itemInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.001171s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044792s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000710s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.037526s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` FROM v_item  i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE  `i`.`id` = 44  AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000810s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.038194s ]
[ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE  `item_id` = 44  AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000938s ]
---------------------------------------------------------------

[2023-04-26T03:11:32+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/My/myTaskNotSee
[ sql ] [ DB ] CONNECT:[ UseTime:0.000668s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040594s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001057s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.062734s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE  `staff_id` = 28  AND `status` = 0 [ RunTime:0.000708s ]
---------------------------------------------------------------

[2023-04-26T03:11:33+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.033113s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059954s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001668s ]
[ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE  `s`.`id` = 28  AND `s`.`status` = 0  AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000935s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.075566s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE  `staff_id` = 28 LIMIT 1 [ RunTime:0.000758s ]
---------------------------------------------------------------

[2023-04-26T03:11:36+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/My/myDataEdit
[ sql ] [ DB ] CONNECT:[ UseTime:0.000754s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038418s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000768s ]
[ sql ] [ SQL ] UPDATE `v_staff`  SET `name` = '曹煜桐' , `sex` = 1 , `phone` = '17715036016'  WHERE  `id` = 28 [ RunTime:0.004060s ]
---------------------------------------------------------------

[2023-04-26T03:11:50+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.013376s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047892s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.068223s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 28  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.055800s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE  `h`.`id` IN ('18751','18752','18753','18754','18755','18756','18757','18758','18759','18760','18761','18762','18763','18764','18765','18766','18767','18768','18769','18770','18771','18772','18773','18774','18775','18776','18777','18778','18779','18780','18781','18782','18783','18784','18785','18786','18787','18788','18789','18790','18791','18792','18793','18794','18795','18796','18797','18798','18799','18800','18801','18802','18803','18804','18805','18806','18807','18808','18809','18810','18811','18812','18813','18814','18815','18816','18817','18818','18819','18820','18821','18822','18823','18824','18825','18826','18827','18828','18829','18830','18831','18832','18833','18834','18835','18836','18837','18838','18839','18840','18841','18842','18843','18844','18845','18846','18847','18848','18849','18850','18851','18852','18853','18854','18855','18856','18857','18858','18859','18860','18861','18862','18863','18864','18865','18866','18867','18868','18869','18870','18871','18872','18873','18874','18875','18876','18877','18878','18879','18880','18881','18882','18883','18884','18885','18886','18887','18888','18889','18890','18891','18892','18893','18894','18895','18896','18897','18898','18899','18900','18901','18902','18903','18904','18905','18906','18907','18908','18909','18910','18911','18912','18913','18914','18915','18916','18917','18918','18919','18920','18921','18922','18923','18924','18925','18926','18927','18928','18929','18930','18931','18932','18933','18934','18935','18936','18937','18938','18939','18940','18941','18942','18943','18944','18945','18946','18947','18948','18949','18950','18951','18952','18953','18954','18955','18956','18957','18958','18959','18960','18961','18962','18963','18964','18965','18966','18967','18968','18969','18970','18971','18972','18973','18974','18975','18976','18977','18978','18979','18980','18981','18982','18983','18984','18985','18986','18987','18988','18989','18990','18991','18992','18993','18994','18995','18996','18997','18998','18999','19000','19001','19002','19003','19004','19005','19006','19007','19008','19009','19010','19011','19012','19013','19014','19015','19016','19017','19018','19019','19020','19021','19022','19023','19024','19025','19026','19027','19028','19029','19030','19031','19032','19033','19034','19035','19036','19037','19038','19039','19040','19041','19042','19043','19044','19045','19046','19047','19048','19049','19050','19051','19052','19053','19054','19055','19056','19057','19058','19059','19060','19061','19062','19063','19064','19065','19066','19067','19068','19069','19070','19071','19072','19073','19074','19075','19076','19077','19078','19079','19080','19081','19082','19083','19084','19085','19086','19087','19088','19089','19090','19091','19092','19093','19094','19095','19096','19097','19098','19099','19100','19101','19102','19103','19104','19105','19106','19107','19108','19109','19110','19111','19112','19113','19114','19115','19116','19117','19118','19119','19120','19121','19122','19123','19124','19125','19126','19127','19128','19129','19130','19131','19132','19133','19134','19135','19136','19137','19138','19139','19140','19141','19142','19143','19144','19145','19146','19147','19148','19149','19150','19151','19152','19153','19154','19155','19156','19157','19158','19159','19160','19161','19162','19163','19164','19165','19166','19167','19168','19169','19170','19171','19172','19173','19174','19175','19176','19177','19178','19179','19180','19181','19182','19183','19184','19185','19186','19187','19188','19189','19190','19191','19192','19193','19194','19195','19196','19197','19198','19199','19200','19201','19202','19203','19204','19205','19206','19207','19208','19209','19210','19211','19212','19213','19214','19215','19216','19217','19218','19219','19220','19221','19222','19223','19224','19225','19226','19227','19228','19229','19230','19231','19232','19233','19234','19235','19236','19237','19238','19239','19240','19241','19242','19243','19244','19245','19246','19247','19248','19249','19250','19251','19252','19253','19254','19255','19256','19257','19258','19259','19260','19261','19262','19263','19264','19265','19266','19267','19268','19269','19270','19271','19272','19273','19274','19275','19276','19277','19278','19279','19280','19281','19282','19283','19284','19285','19286','19287','19288','19289','19290','19291','19292','19293','19294','19295','19296','19297','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19318','19319','19320','19321','19322','19323','19324','19325','19326','19327','19328','19329','19330','19331','19332','19333','19334','19335','19336','19337','19338','19339','19340','19341','19342','19343','19344','19345','19346','19347','19348','19349','19350','19351','19352','19353','19354','19355','19356','19357','19358','19359','19360','19361','19362','19363','19364','19365','19366','19367','19368','19369','19370','19371','19372','19373','19374','19375','19376','19377','19378','19379','19380','19381','19382','19383','19384','19385','19386','19387','19388','19389','19390','19391','19392','19393','19394','19395','19396','19397','19398','19399','19400','19401','19402','19403','19404','19405','19406','19407','19408','19409','19410','19411','19412','19413','19414','19415','19416','19417','19418','19419','19420','19421','19422','19423','19424','19425','19426','19427','19428','19429','19430','19431','19432','19433','19434','19435','19436','19437','19438','19439','19440','19441','19442','19443','19444','19445','19446','19447','19448','19449','19450','19451','19452','19453','19454','19455','19456','19457','19458','19459','19460','19461','19462','19463','19464','19465','19466','19467','19468','19469','19470','19471','19472','19473','19474','19475','19476','19477','19478','19479','19480','19481','19482','19483','19484','19485','19486','19487','19488','19489','19490','19491','19492','19493','19494','19495','19496','19497','19498','19499','19500','19501','19502','19503','19504','19505','19506','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19632','19633')  AND `h`.`status` = 0  AND `h`.`is_delete` = 0 [ RunTime:0.017369s ]
[ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE  `h`.`id` IN ('18751','18752','18753','18754','18755','18756','18757','18758','18759','18760','18761','18762','18763','18764','18765','18766','18767','18768','18769','18770','18771','18772','18773','18774','18775','18776','18777','18778','18779','18780','18781','18782','18783','18784','18785','18786','18787','18788','18789','18790','18791','18792','18793','18794','18795','18796','18797','18798','18799','18800','18801','18802','18803','18804','18805','18806','18807','18808','18809','18810','18811','18812','18813','18814','18815','18816','18817','18818','18819','18820','18821','18822','18823','18824','18825','18826','18827','18828','18829','18830','18831','18832','18833','18834','18835','18836','18837','18838','18839','18840','18841','18842','18843','18844','18845','18846','18847','18848','18849','18850','18851','18852','18853','18854','18855','18856','18857','18858','18859','18860','18861','18862','18863','18864','18865','18866','18867','18868','18869','18870','18871','18872','18873','18874','18875','18876','18877','18878','18879','18880','18881','18882','18883','18884','18885','18886','18887','18888','18889','18890','18891','18892','18893','18894','18895','18896','18897','18898','18899','18900','18901','18902','18903','18904','18905','18906','18907','18908','18909','18910','18911','18912','18913','18914','18915','18916','18917','18918','18919','18920','18921','18922','18923','18924','18925','18926','18927','18928','18929','18930','18931','18932','18933','18934','18935','18936','18937','18938','18939','18940','18941','18942','18943','18944','18945','18946','18947','18948','18949','18950','18951','18952','18953','18954','18955','18956','18957','18958','18959','18960','18961','18962','18963','18964','18965','18966','18967','18968','18969','18970','18971','18972','18973','18974','18975','18976','18977','18978','18979','18980','18981','18982','18983','18984','18985','18986','18987','18988','18989','18990','18991','18992','18993','18994','18995','18996','18997','18998','18999','19000','19001','19002','19003','19004','19005','19006','19007','19008','19009','19010','19011','19012','19013','19014','19015','19016','19017','19018','19019','19020','19021','19022','19023','19024','19025','19026','19027','19028','19029','19030','19031','19032','19033','19034','19035','19036','19037','19038','19039','19040','19041','19042','19043','19044','19045','19046','19047','19048','19049','19050','19051','19052','19053','19054','19055','19056','19057','19058','19059','19060','19061','19062','19063','19064','19065','19066','19067','19068','19069','19070','19071','19072','19073','19074','19075','19076','19077','19078','19079','19080','19081','19082','19083','19084','19085','19086','19087','19088','19089','19090','19091','19092','19093','19094','19095','19096','19097','19098','19099','19100','19101','19102','19103','19104','19105','19106','19107','19108','19109','19110','19111','19112','19113','19114','19115','19116','19117','19118','19119','19120','19121','19122','19123','19124','19125','19126','19127','19128','19129','19130','19131','19132','19133','19134','19135','19136','19137','19138','19139','19140','19141','19142','19143','19144','19145','19146','19147','19148','19149','19150','19151','19152','19153','19154','19155','19156','19157','19158','19159','19160','19161','19162','19163','19164','19165','19166','19167','19168','19169','19170','19171','19172','19173','19174','19175','19176','19177','19178','19179','19180','19181','19182','19183','19184','19185','19186','19187','19188','19189','19190','19191','19192','19193','19194','19195','19196','19197','19198','19199','19200','19201','19202','19203','19204','19205','19206','19207','19208','19209','19210','19211','19212','19213','19214','19215','19216','19217','19218','19219','19220','19221','19222','19223','19224','19225','19226','19227','19228','19229','19230','19231','19232','19233','19234','19235','19236','19237','19238','19239','19240','19241','19242','19243','19244','19245','19246','19247','19248','19249','19250','19251','19252','19253','19254','19255','19256','19257','19258','19259','19260','19261','19262','19263','19264','19265','19266','19267','19268','19269','19270','19271','19272','19273','19274','19275','19276','19277','19278','19279','19280','19281','19282','19283','19284','19285','19286','19287','19288','19289','19290','19291','19292','19293','19294','19295','19296','19297','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19318','19319','19320','19321','19322','19323','19324','19325','19326','19327','19328','19329','19330','19331','19332','19333','19334','19335','19336','19337','19338','19339','19340','19341','19342','19343','19344','19345','19346','19347','19348','19349','19350','19351','19352','19353','19354','19355','19356','19357','19358','19359','19360','19361','19362','19363','19364','19365','19366','19367','19368','19369','19370','19371','19372','19373','19374','19375','19376','19377','19378','19379','19380','19381','19382','19383','19384','19385','19386','19387','19388','19389','19390','19391','19392','19393','19394','19395','19396','19397','19398','19399','19400','19401','19402','19403','19404','19405','19406','19407','19408','19409','19410','19411','19412','19413','19414','19415','19416','19417','19418','19419','19420','19421','19422','19423','19424','19425','19426','19427','19428','19429','19430','19431','19432','19433','19434','19435','19436','19437','19438','19439','19440','19441','19442','19443','19444','19445','19446','19447','19448','19449','19450','19451','19452','19453','19454','19455','19456','19457','19458','19459','19460','19461','19462','19463','19464','19465','19466','19467','19468','19469','19470','19471','19472','19473','19474','19475','19476','19477','19478','19479','19480','19481','19482','19483','19484','19485','19486','19487','19488','19489','19490','19491','19492','19493','19494','19495','19496','19497','19498','19499','19500','19501','19502','19503','19504','19505','19506','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19632','19633')  AND `h`.`status` = 0  AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.017410s ]
---------------------------------------------------------------

[2023-04-26T03:11:50+08:00] 180.98.18.187 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.000881s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047842s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '28|71d382861ac2d82c87665785a4ffc7c2'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000825s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.072076s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 28  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000793s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.067999s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE  `id` IN (18751,18752,18753,18754,18755,18756,18757,18758,18759,18760,18761,18762,18763,18764,18765,18766,18767,18768,18769,18770,18771,18772,18773,18774,18775,18776,18777,18778,18779,18780,18781,18782,18783,18784,18785,18786,18787,18788,18789,18790,18791,18792,18793,18794,18795,18796,18797,18798,18799,18800,18801,18802,18803,18804,18805,18806,18807,18808,18809,18810,18811,18812,18813,18814,18815,18816,18817,18818,18819,18820,18821,18822,18823,18824,18825,18826,18827,18828,18829,18830,18831,18832,18833,18834,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,18849,18850,18851,18852,18853,18854,18855,18856,18857,18858,18859,18860,18861,18862,18863,18864,18865,18866,18867,18868,18869,18870,18871,18872,18873,18874,18875,18876,18877,18878,18879,18880,18881,18882,18883,18884,18885,18886,18887,18888,18889,18890,18891,18892,18893,18894,18895,18896,18897,18898,18899,18900,18901,18902,18903,18904,18905,18906,18907,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18922,18923,18924,18925,18926,18927,18928,18929,18930,18931,18932,18933,18934,18935,18936,18937,18938,18939,18940,18941,18942,18943,18944,18945,18946,18947,18948,18949,18950,18951,18952,18953,18954,18955,18956,18957,18958,18959,18960,18961,18962,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,18973,18974,18975,18976,18977,18978,18979,18980,18981,18982,18983,18984,18985,18986,18987,18988,18989,18990,18991,18992,18993,18994,18995,18996,18997,18998,18999,19000,19001,19002,19003,19004,19005,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19021,19022,19023,19024,19025,19026,19027,19028,19029,19030,19031,19032,19033,19034,19035,19036,19037,19038,19039,19040,19041,19042,19043,19044,19045,19046,19047,19048,19049,19050,19051,19052,19053,19054,19055,19056,19057,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19108,19109,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19132,19133,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19172,19173,19174,19175,19176,19177,19178,19179,19180,19181,19182,19183,19184,19185,19186,19187,19188,19189,19190,19191,19192,19193,19194,19195,19196,19197,19198,19199,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19336,19337,19338,19339,19340,19341,19342,19343,19344,19345,19346,19347,19348,19349,19350,19351,19352,19353,19354,19355,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19415,19416,19417,19418,19419,19420,19421,19422,19423,19424,19425,19426,19427,19428,19429,19430,19431,19432,19433,19434,19435,19436,19437,19438,19439,19440,19441,19442,19443,19444,19445,19446,19447,19448,19449,19450,19451,19452,19453,19454,19455,19456,19457,19458,19459,19460,19461,19462,19463,19464,19465,19466,19467,19468,19469,19470,19471,19472,19473,19474,19475,19476,19477,19478,19479,19480,19481,19482,19483,19484,19485,19486,19487,19488,19489,19490,19491,19492,19493,19494,19495,19496,19497,19498,19499,19500,19501,19502,19503,19504,19505,19506,19612,19613,19614,19615,19616,19617,19618,19619,19620,19621,19622,19623,19624,19625,19626,19632,19633)  AND `status` = 0  AND `is_delete` = 0 [ RunTime:0.017997s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.085819s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE  `id` = 320  AND `level` = 0  AND `status` = 0  AND `is_delete` = 0 [ RunTime:0.000649s ]