[2021-12-18T10:38:02+08:00][sql] CONNECT:[ UseTime:0.013103s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:02+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.005664s ] [2021-12-18T10:38:02+08:00][sql] SELECT `id` FROM `t_doc_user` WHERE `name` = 'admin' LIMIT 1 [ RunTime:0.000283s ] [2021-12-18T10:38:02+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005368s ] [2021-12-18T10:38:02+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 AND `role_id` = 9 LIMIT 1 [ RunTime:0.000394s ] [2021-12-18T10:38:02+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.005106s ] [2021-12-18T10:38:02+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE `role_id` = '9' [ RunTime:0.000514s ] [2021-12-18T10:38:04+08:00][sql] CONNECT:[ UseTime:0.003356s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:04+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.005319s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000529s ] [2021-12-18T10:38:04+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.005773s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '53' [ RunTime:0.000437s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '53' ORDER BY `sort` ASC [ RunTime:0.000303s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '54' [ RunTime:0.000356s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '54' ORDER BY `sort` ASC [ RunTime:0.000270s ] [2021-12-18T10:38:04+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.004803s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000219s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000227s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '55' [ RunTime:0.000351s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '55' ORDER BY `sort` ASC [ RunTime:0.000289s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '57' [ RunTime:0.000357s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '57' ORDER BY `sort` ASC [ RunTime:0.000259s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000221s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000258s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '56' [ RunTime:0.000378s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '56' ORDER BY `sort` ASC [ RunTime:0.000320s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '59' [ RunTime:0.000379s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '59' ORDER BY `sort` ASC [ RunTime:0.000288s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '73' [ RunTime:0.000385s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '73' ORDER BY `sort` ASC [ RunTime:0.000219s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000192s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '74' [ RunTime:0.000313s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '74' ORDER BY `sort` ASC [ RunTime:0.000208s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000159s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '75' [ RunTime:0.000325s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '75' ORDER BY `sort` ASC [ RunTime:0.000192s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000177s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000165s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '77' [ RunTime:0.000301s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '77' ORDER BY `sort` ASC [ RunTime:0.000214s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '80' [ RunTime:0.000352s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '80' ORDER BY `sort` ASC [ RunTime:0.000195s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000165s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '83' [ RunTime:0.000310s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '83' ORDER BY `sort` ASC [ RunTime:0.000251s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000206s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '84' [ RunTime:0.000323s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '84' ORDER BY `sort` ASC [ RunTime:0.000316s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000215s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000197s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '66' [ RunTime:0.000387s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '66' ORDER BY `sort` ASC [ RunTime:0.000265s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '67' [ RunTime:0.000352s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '67' ORDER BY `sort` ASC [ RunTime:0.000259s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000205s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '68' [ RunTime:0.000459s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '68' ORDER BY `sort` ASC [ RunTime:0.000250s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000196s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '69' [ RunTime:0.000365s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '69' ORDER BY `sort` ASC [ RunTime:0.000239s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000194s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '95' [ RunTime:0.000342s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '95' ORDER BY `sort` ASC [ RunTime:0.000228s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000203s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000184s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '78' [ RunTime:0.000318s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '78' ORDER BY `sort` ASC [ RunTime:0.000223s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '81' [ RunTime:0.000330s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '81' ORDER BY `sort` ASC [ RunTime:0.000196s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000155s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '85' [ RunTime:0.000389s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '85' ORDER BY `sort` ASC [ RunTime:0.000199s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000192s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000169s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '79' [ RunTime:0.000302s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '79' ORDER BY `sort` ASC [ RunTime:0.000207s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '82' [ RunTime:0.000286s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '82' ORDER BY `sort` ASC [ RunTime:0.000231s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000194s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '87' [ RunTime:0.000348s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '87' ORDER BY `sort` ASC [ RunTime:0.000234s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000195s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '86' [ RunTime:0.000344s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '86' ORDER BY `sort` ASC [ RunTime:0.000237s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000191s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000200s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '71' [ RunTime:0.000379s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '71' ORDER BY `sort` ASC [ RunTime:0.000304s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '72' [ RunTime:0.000359s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '72' ORDER BY `sort` ASC [ RunTime:0.000205s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000188s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '88' [ RunTime:0.000288s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '88' ORDER BY `sort` ASC [ RunTime:0.000190s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000140s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '89' [ RunTime:0.000299s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '89' ORDER BY `sort` ASC [ RunTime:0.000173s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000136s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '76' [ RunTime:0.000286s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '76' ORDER BY `sort` ASC [ RunTime:0.000193s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000126s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000123s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000151s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '14' [ RunTime:0.000276s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '14' ORDER BY `sort` ASC [ RunTime:0.000233s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '17' [ RunTime:0.000264s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '17' ORDER BY `sort` ASC [ RunTime:0.000167s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000124s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '60' [ RunTime:0.000323s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '60' ORDER BY `sort` ASC [ RunTime:0.000274s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '61' [ RunTime:0.000385s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '61' ORDER BY `sort` ASC [ RunTime:0.000256s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000216s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '62' [ RunTime:0.000355s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '62' ORDER BY `sort` ASC [ RunTime:0.000253s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000215s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000213s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '63' [ RunTime:0.000353s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '63' ORDER BY `sort` ASC [ RunTime:0.000292s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '64' [ RunTime:0.000356s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '64' ORDER BY `sort` ASC [ RunTime:0.000277s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000200s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '65' [ RunTime:0.000354s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '65' ORDER BY `sort` ASC [ RunTime:0.000225s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000171s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '70' [ RunTime:0.000306s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '70' ORDER BY `sort` ASC [ RunTime:0.000217s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000161s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000182s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '19' [ RunTime:0.000401s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '19' ORDER BY `sort` ASC [ RunTime:0.000196s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000199s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000180s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '24' [ RunTime:0.000342s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '24' ORDER BY `sort` ASC [ RunTime:0.000213s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '38' [ RunTime:0.000313s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '38' ORDER BY `sort` ASC [ RunTime:0.000232s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000218s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '25' [ RunTime:0.000352s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '25' ORDER BY `sort` ASC [ RunTime:0.000236s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000194s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '37' [ RunTime:0.000346s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '37' ORDER BY `sort` ASC [ RunTime:0.000242s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000195s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000196s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '90' [ RunTime:0.000336s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '90' ORDER BY `sort` ASC [ RunTime:0.000243s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '91' [ RunTime:0.000337s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '91' ORDER BY `sort` ASC [ RunTime:0.000274s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000190s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '92' [ RunTime:0.000336s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '92' ORDER BY `sort` ASC [ RunTime:0.000230s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000208s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '93' [ RunTime:0.000333s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '93' ORDER BY `sort` ASC [ RunTime:0.000232s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000188s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '94' [ RunTime:0.000560s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '94' ORDER BY `sort` ASC [ RunTime:0.000355s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000368s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000228s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '43' [ RunTime:0.000415s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '43' ORDER BY `sort` ASC [ RunTime:0.000296s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '44' [ RunTime:0.000362s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '44' ORDER BY `sort` ASC [ RunTime:0.000294s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000248s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '45' [ RunTime:0.000334s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '45' ORDER BY `sort` ASC [ RunTime:0.000245s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000197s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000189s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '46' [ RunTime:0.000377s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '46' ORDER BY `sort` ASC [ RunTime:0.000254s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '47' [ RunTime:0.000326s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '47' ORDER BY `sort` ASC [ RunTime:0.000241s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000196s ] [2021-12-18T10:38:04+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '48' [ RunTime:0.000319s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '48' ORDER BY `sort` ASC [ RunTime:0.000238s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000191s ] [2021-12-18T10:38:04+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000232s ] [2021-12-18T10:38:05+08:00][sql] CONNECT:[ UseTime:0.013570s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005355s ] [2021-12-18T10:38:05+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000242s ] [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005076s ] [2021-12-18T10:38:05+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000484s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000248s ] [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.005804s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000328s ] [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.004808s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000284s ] [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.006024s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000270s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000221s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000240s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000189s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000189s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000187s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000181s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000177s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000231s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000201s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000201s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000189s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000256s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000221s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000214s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000213s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000199s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000195s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000188s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000186s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000173s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000225s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000222s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000203s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000222s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000221s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000197s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000228s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000211s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000221s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000259s ] [2021-12-18T10:38:05+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000299s ] [2021-12-18T10:38:05+08:00][sql] CONNECT:[ UseTime:0.003981s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005956s ] [2021-12-18T10:38:05+08:00][sql] SELECT * FROM `t_imm_householder` ORDER BY `id` DESC [ RunTime:0.000324s ] [2021-12-18T10:38:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000159s ] [2021-12-18T10:38:14+08:00][sql] CONNECT:[ UseTime:0.004241s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.007170s ] [2021-12-18T10:38:14+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE `role_id` = '9' [ RunTime:0.000636s ] [2021-12-18T10:38:14+08:00][sql] CONNECT:[ UseTime:0.003893s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.006499s ] [2021-12-18T10:38:14+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000215s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.006918s ] [2021-12-18T10:38:14+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000623s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000258s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.007058s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000258s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.006384s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000241s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.007055s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000294s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000183s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000234s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000211s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000178s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000172s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000312s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000246s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000220s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000282s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000212s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000212s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000255s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000250s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000202s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000254s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000199s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000248s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000222s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000175s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000161s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000260s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000239s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000256s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000284s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000290s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000236s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000198s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000249s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000222s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000185s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000172s ] [2021-12-18T10:38:14+08:00][sql] CONNECT:[ UseTime:0.004165s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.006796s ] [2021-12-18T10:38:14+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000142s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.007363s ] [2021-12-18T10:38:14+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000425s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000199s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.006305s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000366s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.006328s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000275s ] [2021-12-18T10:38:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.006655s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000279s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000197s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000204s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000241s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000197s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000168s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000191s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000233s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000212s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000165s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000192s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000193s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000188s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000295s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000260s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000220s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000225s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000221s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000276s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000241s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000200s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000208s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000245s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000255s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000216s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000281s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000189s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000173s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000246s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000195s ] [2021-12-18T10:38:14+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000173s ] [2021-12-18T10:38:14+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000196s ] [2021-12-18T10:38:15+08:00][sql] CONNECT:[ UseTime:0.005721s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.009369s ] [2021-12-18T10:38:15+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000176s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.006419s ] [2021-12-18T10:38:15+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000521s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000251s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000246s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000231s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000261s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000339s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000315s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000397s ] [2021-12-18T10:38:15+08:00][sql] CONNECT:[ UseTime:0.006345s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007296s ] [2021-12-18T10:38:15+08:00][sql] SELECT `id`,`district` FROM `t_imm_projectlist` [ RunTime:0.000313s ] [2021-12-18T10:38:15+08:00][sql] SELECT `district` FROM `t_imm_projectlist` [ RunTime:0.000263s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.008024s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 18 [ RunTime:0.000242s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.006240s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 18 [ RunTime:0.000325s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.006387s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' [ RunTime:0.000239s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 12 [ RunTime:0.000212s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 12 [ RunTime:0.000216s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' [ RunTime:0.000220s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 17 [ RunTime:0.000180s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 17 [ RunTime:0.000212s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' [ RunTime:0.000213s ] [2021-12-18T10:38:15+08:00][sql] CONNECT:[ UseTime:0.004206s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.008614s ] [2021-12-18T10:38:15+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000291s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.006734s ] [2021-12-18T10:38:15+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000498s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000256s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.008478s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000390s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.007427s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000587s ] [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.007765s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000282s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000287s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000269s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000257s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000229s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000252s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000282s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000333s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000226s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000307s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000265s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000213s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000231s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000306s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000278s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000264s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000247s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000212s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000207s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000201s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000197s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000238s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000374s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000243s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000251s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000252s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000231s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000217s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000230s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000223s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000186s ] [2021-12-18T10:38:15+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000245s ] [2021-12-18T10:38:15+08:00][sql] CONNECT:[ UseTime:0.004284s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.008656s ] [2021-12-18T10:38:15+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000538s ] [2021-12-18T10:38:15+08:00][sql] CONNECT:[ UseTime:0.005039s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.007039s ] [2021-12-18T10:38:15+08:00][sql] SELECT DISTINCT `project_no`,`project_name_easy`,`project_name` FROM `t_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000572s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.006748s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.007145s ] [2021-12-18T10:38:16+08:00][sql] SELECT `buget_estimate` FROM `t_imm_buget` [ RunTime:0.000312s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.007060s ] [2021-12-18T10:38:16+08:00][sql] SELECT `bugetinfo_approriation` FROM `t_imm_bugetinfo` [ RunTime:0.000475s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.006442s ] [2021-12-18T10:38:16+08:00][sql] SELECT `pay_amount` FROM `t_imm_usedetail` WHERE `project_no` = 9089 [ RunTime:0.000308s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_schedule_plan_land` [ RunTime:0.005719s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE `project_no` = 9089 [ RunTime:0.000878s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE `project_no` = 9089 AND `percent` = 1 [ RunTime:0.000793s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE `project_no` = 9089 AND `percent` <> 1 [ RunTime:0.000978s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006356s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.000273s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_template_contract_file` [ RunTime:0.006653s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_template_contract_file` WHERE `project_no` = '9089' [ RunTime:0.000401s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_change_name` [ RunTime:0.007994s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_change_name` WHERE `change_type` = '一般设计变更' AND `project_no` = '9089' [ RunTime:0.000257s ] [2021-12-18T10:38:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_change_name` WHERE `change_type` = '重大设计变更' AND `project_no` = '9089' [ RunTime:0.000160s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_county_inspect` [ RunTime:0.005733s ] [2021-12-18T10:38:16+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_county_inspect` WHERE `project_no` = 9089 [ RunTime:0.000488s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_city_inspect` [ RunTime:0.005880s ] [2021-12-18T10:38:16+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_city_inspect` WHERE `project_no` = 9089 [ RunTime:0.000374s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_province_inspect` [ RunTime:0.005627s ] [2021-12-18T10:38:16+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_province_inspect` WHERE `project_no` = 9089 [ RunTime:0.000402s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.006748s ] [2021-12-18T10:38:16+08:00][sql] SELECT * FROM `t_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000268s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.003646s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007745s ] [2021-12-18T10:38:16+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000609s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.007038s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.005709s ] [2021-12-18T10:38:16+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000298s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.003548s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007200s ] [2021-12-18T10:38:16+08:00][sql] SELECT * FROM `t_imm_projectlist` [ RunTime:0.000228s ] [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005081s ] [2021-12-18T10:38:16+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 18 [ RunTime:0.000327s ] [2021-12-18T10:38:16+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 12 [ RunTime:0.000266s ] [2021-12-18T10:38:16+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 17 [ RunTime:0.000304s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.014541s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007661s ] [2021-12-18T10:38:16+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000464s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.005398s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.006178s ] [2021-12-18T10:38:16+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000548s ] [2021-12-18T10:38:16+08:00][sql] CONNECT:[ UseTime:0.004966s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:16+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005776s ] [2021-12-18T10:38:16+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000499s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.005062s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.008690s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_projectlist` WHERE `project_id` = 9089 [ RunTime:0.000299s ] [2021-12-18T10:38:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_projectlist` WHERE `project_id` = 9089 [ RunTime:0.000282s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.007402s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007249s ] [2021-12-18T10:38:17+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000251s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.008080s ] [2021-12-18T10:38:17+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000711s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000350s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.008618s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000517s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.008332s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000408s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.008799s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000342s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000235s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000240s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000224s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000246s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000297s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000238s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000317s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000474s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000245s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000288s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000225s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000301s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000337s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000327s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000316s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000315s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000275s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000258s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000245s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000233s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000318s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000295s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000279s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000265s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000248s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000243s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000241s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000276s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000366s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000358s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000353s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.005261s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.007720s ] [2021-12-18T10:38:17+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000284s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.007366s ] [2021-12-18T10:38:17+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000618s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000236s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.006736s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000328s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.008043s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000306s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.008576s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000364s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000332s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000323s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000232s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000215s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000240s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000287s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000269s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000248s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000196s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000179s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000178s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000164s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000211s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000213s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000340s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000350s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000332s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000306s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000288s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000315s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000290s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000307s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000262s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000289s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000251s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000212s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000211s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000228s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000205s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000196s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000258s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.005515s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.006635s ] [2021-12-18T10:38:17+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000218s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005318s ] [2021-12-18T10:38:17+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000415s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000238s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.006943s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000266s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.005160s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000262s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.005868s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '121' [ RunTime:0.000390s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '301' [ RunTime:0.000315s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000230s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000209s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000200s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000173s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000183s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000192s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '1' [ RunTime:0.000167s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '2' [ RunTime:0.000153s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '801' [ RunTime:0.000154s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '802' [ RunTime:0.000203s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '803' [ RunTime:0.000176s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000177s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000176s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000193s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' AND `useinfo_number` = '3' [ RunTime:0.000154s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '901' [ RunTime:0.000168s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '701' [ RunTime:0.000168s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' AND `useinfo_number` = '702' [ RunTime:0.000213s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '902' [ RunTime:0.000177s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000246s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000215s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000270s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '6' [ RunTime:0.000413s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000282s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000223s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000205s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000177s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000206s ] [2021-12-18T10:38:17+08:00][sql] SELECT * FROM `t_imm_useinfo` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000213s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' AND `useinfo_number` = '5' [ RunTime:0.000191s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.003555s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005577s ] [2021-12-18T10:38:17+08:00][sql] SELECT `id` FROM `t_imm_projectlist` [ RunTime:0.000139s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.004904s ] [2021-12-18T10:38:17+08:00][sql] SELECT `buget_name` FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) GROUP BY `buget_name` [ RunTime:0.000402s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '专业项目费' [ RunTime:0.000200s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '其他费用' [ RunTime:0.000163s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '农村移民安置补偿费' [ RunTime:0.000158s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '单位及工业企业补偿费' [ RunTime:0.000169s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '库底清理费' [ RunTime:0.000157s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '有关税费' [ RunTime:0.000187s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` IN (12,17,18) AND `buget_name` = '防护工程费' [ RunTime:0.000192s ] [2021-12-18T10:38:17+08:00][sql] CONNECT:[ UseTime:0.013535s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005025s ] [2021-12-18T10:38:17+08:00][sql] SELECT `id`,`district` FROM `t_imm_projectlist` [ RunTime:0.000183s ] [2021-12-18T10:38:17+08:00][sql] SELECT `district` FROM `t_imm_projectlist` [ RunTime:0.000175s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.004689s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 18 [ RunTime:0.000219s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.005181s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 18 [ RunTime:0.000286s ] [2021-12-18T10:38:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.005182s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '牟平区' [ RunTime:0.000264s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 12 [ RunTime:0.000180s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 12 [ RunTime:0.000168s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '福山区' [ RunTime:0.000206s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE `district_id` = 17 [ RunTime:0.000170s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE `district_id` = 17 [ RunTime:0.000182s ] [2021-12-18T10:38:17+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE `district` = '栖霞市' [ RunTime:0.000175s ] [2021-12-18T10:38:20+08:00][sql] CONNECT:[ UseTime:0.003757s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:20+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.005630s ] [2021-12-18T10:38:20+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000623s ] [2021-12-18T10:38:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000298s ] [2021-12-18T10:38:20+08:00][sql] CONNECT:[ UseTime:0.004436s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:38:20+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005379s ] [2021-12-18T10:38:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` [ RunTime:0.000189s ] [2021-12-18T10:58:38+08:00][sql] CONNECT:[ UseTime:0.003504s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T10:58:38+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.006327s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000507s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000431s ] [2021-12-18T10:58:38+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005349s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000238s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000214s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000183s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000213s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000188s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000145s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000167s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000175s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000132s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000205s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000163s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000195s ] [2021-12-18T10:58:38+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000138s ] [2021-12-18T11:02:35+08:00][sql] CONNECT:[ UseTime:0.014251s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:02:35+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006053s ] [2021-12-18T11:02:35+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.000970s ] [2021-12-18T11:02:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000627s ] [2021-12-18T11:02:43+08:00][sql] CONNECT:[ UseTime:0.004394s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:02:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_file_type` [ RunTime:0.005410s ] [2021-12-18T11:02:43+08:00][sql] SELECT * FROM `t_doc_dict_file_type` [ RunTime:0.000286s ] [2021-12-18T11:02:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_duration_type` [ RunTime:0.004878s ] [2021-12-18T11:02:43+08:00][sql] SELECT * FROM `t_doc_dict_duration_type` [ RunTime:0.000213s ] [2021-12-18T11:02:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.005284s ] [2021-12-18T11:02:43+08:00][sql] SELECT * FROM `t_doc_dict_security_classification` [ RunTime:0.000218s ] [2021-12-18T11:02:44+08:00][sql] CONNECT:[ UseTime:0.003834s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:02:44+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_flow` [ RunTime:0.005970s ] [2021-12-18T11:02:44+08:00][sql] SELECT * FROM `v_doc_flow` WHERE `pre_node_id` = '1' AND `flow_no` = '2' [ RunTime:0.000448s ] [2021-12-18T11:02:44+08:00][sql] CONNECT:[ UseTime:0.003318s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:02:44+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.006147s ] [2021-12-18T11:02:44+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 13 [ RunTime:0.000341s ] [2021-12-18T11:04:01+08:00][sql] CONNECT:[ UseTime:0.005395s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:04:01+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005652s ] [2021-12-18T11:04:01+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '上传文件' , `url` = '/szym/api/index.php/Document/upload_file' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796641 , `update_time` = 1639796641 , `delete_time` = 0 [ RunTime:0.031416s ] [2021-12-18T11:04:03+08:00][sql] CONNECT:[ UseTime:0.003288s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:04:03+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005473s ] [2021-12-18T11:04:03+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '添加文件' , `url` = '/szym/api/index.php/Document/addFile' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796642 , `update_time` = 1639796642 , `delete_time` = 0 [ RunTime:0.000265s ] [2021-12-18T11:04:03+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.005382s ] [2021-12-18T11:04:03+08:00][sql] INSERT INTO `t_doc_archive_file` SET `retention_id` = '1' , `duration_type_id` = '2' , `duration_time` = '永久' , `security_classification_id` = 1 , `file_name` = 'F01高天财.调查表.pdf' , `file_dec` = '高天财调查表' , `file_no` = 'F01' , `note` = '' , `edition` = '1' , `owner_name` = '高天财' , `create_user_id` = '4' , `modify_user_id` = '4' , `file_menu_id` = '2' , `file_menu_pid` = '0' , `profession_id` = '2' , `project_no` = '9089' , `file_guid` = '4aa91d52f56f380c6ed8a3794af6b39b.pdf' , `file_type` = 'pdf' , `file_url` = '/uploads/project/20211218/4aa91d52f56f380c6ed8a3794af6b39b.pdf' , `status` = '2' , `create_time` = '2021-12-18 11:04:02' , `modify_time` = '2021-12-18 11:04:02' , `retention_time` = '2021-12-18 11:04:02' [ RunTime:0.026391s ] [2021-12-18T11:04:03+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.028049s ] [2021-12-18T11:04:03+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '新增' , `operate_time` = '2021-12-18 11:04:02' , `operate_user_id` = 4 [ RunTime:0.046246s ] [2021-12-18T11:04:03+08:00][sql] CONNECT:[ UseTime:0.004260s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:04:03+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.005883s ] [2021-12-18T11:04:03+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001160s ] [2021-12-18T11:04:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000737s ] [2021-12-18T11:05:26+08:00][sql] CONNECT:[ UseTime:0.013620s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:26+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.005502s ] [2021-12-18T11:05:26+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 130 [ RunTime:0.000330s ] [2021-12-18T11:05:26+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005560s ] [2021-12-18T11:05:26+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '删除' , `operate_time` = '2021-12-18 11:05:26' , `operate_user_id` = 4 [ RunTime:0.039364s ] [2021-12-18T11:05:26+08:00][sql] DELETE FROM `t_doc_archive_file` WHERE `id` = 130 [ RunTime:0.073072s ] [2021-12-18T11:05:26+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005326s ] [2021-12-18T11:05:26+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '删除文件' , `url` = '/szym/api/index.php/Document/deleteFile' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796726 , `update_time` = 1639796726 , `delete_time` = 0 [ RunTime:0.028310s ] [2021-12-18T11:05:26+08:00][sql] CONNECT:[ UseTime:0.014188s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:26+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006330s ] [2021-12-18T11:05:26+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.000928s ] [2021-12-18T11:05:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000637s ] [2021-12-18T11:05:47+08:00][sql] CONNECT:[ UseTime:0.004783s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.006106s ] [2021-12-18T11:05:47+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000717s ] [2021-12-18T11:05:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000309s ] [2021-12-18T11:05:47+08:00][sql] CONNECT:[ UseTime:0.005022s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005588s ] [2021-12-18T11:05:47+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` [ RunTime:0.000219s ] [2021-12-18T11:05:49+08:00][sql] CONNECT:[ UseTime:0.004773s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.005192s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000313s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000271s ] [2021-12-18T11:05:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.004863s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000293s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000266s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000228s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000243s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000237s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000201s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000221s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000244s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000225s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000253s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000212s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000243s ] [2021-12-18T11:05:49+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000211s ] [2021-12-18T11:05:53+08:00][sql] CONNECT:[ UseTime:0.006690s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:53+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006595s ] [2021-12-18T11:05:53+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001023s ] [2021-12-18T11:05:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000730s ] [2021-12-18T11:05:55+08:00][sql] CONNECT:[ UseTime:0.013566s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:55+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_file_type` [ RunTime:0.006303s ] [2021-12-18T11:05:55+08:00][sql] SELECT * FROM `t_doc_dict_file_type` [ RunTime:0.000439s ] [2021-12-18T11:05:55+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_duration_type` [ RunTime:0.005287s ] [2021-12-18T11:05:55+08:00][sql] SELECT * FROM `t_doc_dict_duration_type` [ RunTime:0.000264s ] [2021-12-18T11:05:55+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.005198s ] [2021-12-18T11:05:55+08:00][sql] SELECT * FROM `t_doc_dict_security_classification` [ RunTime:0.000267s ] [2021-12-18T11:05:56+08:00][sql] CONNECT:[ UseTime:0.004602s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_flow` [ RunTime:0.007899s ] [2021-12-18T11:05:56+08:00][sql] SELECT * FROM `v_doc_flow` WHERE `pre_node_id` = '1' AND `flow_no` = '2' [ RunTime:0.000829s ] [2021-12-18T11:05:56+08:00][sql] CONNECT:[ UseTime:0.013814s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:05:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005936s ] [2021-12-18T11:05:56+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 13 [ RunTime:0.000329s ] [2021-12-18T11:06:17+08:00][sql] CONNECT:[ UseTime:0.005063s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:17+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.005817s ] [2021-12-18T11:06:17+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000613s ] [2021-12-18T11:06:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000316s ] [2021-12-18T11:06:17+08:00][sql] CONNECT:[ UseTime:0.003724s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:17+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.006303s ] [2021-12-18T11:06:17+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` [ RunTime:0.000333s ] [2021-12-18T11:06:19+08:00][sql] CONNECT:[ UseTime:0.014981s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:19+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.005423s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000344s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000265s ] [2021-12-18T11:06:19+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.007815s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000262s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000235s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000180s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000204s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000215s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000173s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000154s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000178s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000163s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000173s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000149s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000188s ] [2021-12-18T11:06:19+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000149s ] [2021-12-18T11:06:22+08:00][sql] CONNECT:[ UseTime:0.003312s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:22+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006475s ] [2021-12-18T11:06:22+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.000935s ] [2021-12-18T11:06:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000668s ] [2021-12-18T11:06:23+08:00][sql] CONNECT:[ UseTime:0.014956s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:23+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_file_type` [ RunTime:0.005196s ] [2021-12-18T11:06:23+08:00][sql] SELECT * FROM `t_doc_dict_file_type` [ RunTime:0.000272s ] [2021-12-18T11:06:23+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_duration_type` [ RunTime:0.005575s ] [2021-12-18T11:06:23+08:00][sql] SELECT * FROM `t_doc_dict_duration_type` [ RunTime:0.000318s ] [2021-12-18T11:06:23+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.006056s ] [2021-12-18T11:06:23+08:00][sql] SELECT * FROM `t_doc_dict_security_classification` [ RunTime:0.000260s ] [2021-12-18T11:06:24+08:00][sql] CONNECT:[ UseTime:0.012685s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:24+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_flow` [ RunTime:0.006018s ] [2021-12-18T11:06:24+08:00][sql] SELECT * FROM `v_doc_flow` WHERE `pre_node_id` = '1' AND `flow_no` = '2' [ RunTime:0.000360s ] [2021-12-18T11:06:24+08:00][sql] CONNECT:[ UseTime:0.004894s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:24+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005855s ] [2021-12-18T11:06:24+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 13 [ RunTime:0.000382s ] [2021-12-18T11:06:46+08:00][sql] CONNECT:[ UseTime:0.003335s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:46+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.006046s ] [2021-12-18T11:06:46+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` [ RunTime:0.000221s ] [2021-12-18T11:06:46+08:00][sql] CONNECT:[ UseTime:0.013389s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:46+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.005723s ] [2021-12-18T11:06:46+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000544s ] [2021-12-18T11:06:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000258s ] [2021-12-18T11:06:48+08:00][sql] CONNECT:[ UseTime:0.014454s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:48+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.005335s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000302s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000257s ] [2021-12-18T11:06:48+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005081s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000221s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000244s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000221s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000247s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000238s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000218s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000220s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000241s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000230s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000240s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000215s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000249s ] [2021-12-18T11:06:48+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000198s ] [2021-12-18T11:06:50+08:00][sql] CONNECT:[ UseTime:0.003631s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:50+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006118s ] [2021-12-18T11:06:50+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001135s ] [2021-12-18T11:06:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000774s ] [2021-12-18T11:06:51+08:00][sql] CONNECT:[ UseTime:0.003916s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:51+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_file_type` [ RunTime:0.006239s ] [2021-12-18T11:06:51+08:00][sql] SELECT * FROM `t_doc_dict_file_type` [ RunTime:0.000225s ] [2021-12-18T11:06:51+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_duration_type` [ RunTime:0.005619s ] [2021-12-18T11:06:51+08:00][sql] SELECT * FROM `t_doc_dict_duration_type` [ RunTime:0.000241s ] [2021-12-18T11:06:51+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.005758s ] [2021-12-18T11:06:51+08:00][sql] SELECT * FROM `t_doc_dict_security_classification` [ RunTime:0.000288s ] [2021-12-18T11:06:52+08:00][sql] CONNECT:[ UseTime:0.014517s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:52+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_flow` [ RunTime:0.006609s ] [2021-12-18T11:06:52+08:00][sql] SELECT * FROM `v_doc_flow` WHERE `pre_node_id` = '1' AND `flow_no` = '2' [ RunTime:0.000446s ] [2021-12-18T11:06:53+08:00][sql] CONNECT:[ UseTime:0.012969s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:06:53+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009740s ] [2021-12-18T11:06:53+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 13 [ RunTime:0.000308s ] [2021-12-18T11:07:14+08:00][sql] CONNECT:[ UseTime:0.004862s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:14+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.006971s ] [2021-12-18T11:07:14+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '上传文件' , `url` = '/szym/api/index.php/Document/upload_file' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796834 , `update_time` = 1639796834 , `delete_time` = 0 [ RunTime:0.024534s ] [2021-12-18T11:07:15+08:00][sql] CONNECT:[ UseTime:0.014399s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005467s ] [2021-12-18T11:07:15+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '添加文件' , `url` = '/szym/api/index.php/Document/addFile' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796835 , `update_time` = 1639796835 , `delete_time` = 0 [ RunTime:0.000274s ] [2021-12-18T11:07:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.005524s ] [2021-12-18T11:07:15+08:00][sql] INSERT INTO `t_doc_archive_file` SET `retention_id` = '1' , `duration_type_id` = '2' , `duration_time` = '永久' , `security_classification_id` = 1 , `file_name` = 'F01高天财.调查表.pdf' , `file_dec` = '高天财调查表' , `file_no` = 'F01' , `note` = '' , `edition` = '1' , `owner_name` = '高天财' , `create_user_id` = '4' , `modify_user_id` = '4' , `file_menu_id` = '2' , `file_menu_pid` = '0' , `profession_id` = '2' , `project_no` = '9089' , `file_guid` = 'c7c67cc0d465ea5a588568a08d00ae1a.pdf' , `file_type` = 'pdf' , `file_url` = '/uploads/project/20211218/c7c67cc0d465ea5a588568a08d00ae1a.pdf' , `status` = '2' , `create_time` = '2021-12-18 11:07:15' , `modify_time` = '2021-12-18 11:07:15' , `retention_time` = '2021-12-18 11:07:15' [ RunTime:0.026431s ] [2021-12-18T11:07:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005228s ] [2021-12-18T11:07:15+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '新增' , `operate_time` = '2021-12-18 11:07:15' , `operate_user_id` = 4 [ RunTime:0.027936s ] [2021-12-18T11:07:16+08:00][sql] CONNECT:[ UseTime:0.015088s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:16+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006520s ] [2021-12-18T11:07:16+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001023s ] [2021-12-18T11:07:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000684s ] [2021-12-18T11:07:20+08:00][sql] CONNECT:[ UseTime:0.015542s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:20+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.006996s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000359s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000369s ] [2021-12-18T11:07:20+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.006926s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000254s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000229s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000208s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000206s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000176s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000178s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000180s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000209s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000175s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000221s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000205s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000221s ] [2021-12-18T11:07:20+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000169s ] [2021-12-18T11:07:25+08:00][sql] CONNECT:[ UseTime:0.013509s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:25+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005611s ] [2021-12-18T11:07:25+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '移卷' , `operate_time` = '2021-12-18 11:07:25' , `operate_user_id` = 4 [ RunTime:0.033443s ] [2021-12-18T11:07:25+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005670s ] [2021-12-18T11:07:25+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '移卷' , `url` = '/szym/api/index.php/Document/fileMove' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796845 , `update_time` = 1639796845 , `delete_time` = 0 [ RunTime:0.023748s ] [2021-12-18T11:07:25+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006082s ] [2021-12-18T11:07:25+08:00][sql] UPDATE `t_doc_archive_file` SET `file_menu_id` = '3.1' , `file_menu_pid` = '3' , `retention_time` = '2021-12-18 11:07:25' WHERE `id` = 131 [ RunTime:0.027484s ] [2021-12-18T11:07:26+08:00][sql] CONNECT:[ UseTime:0.004362s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:26+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006608s ] [2021-12-18T11:07:26+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001046s ] [2021-12-18T11:07:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '2' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000705s ] [2021-12-18T11:07:28+08:00][sql] CONNECT:[ UseTime:0.003260s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:28+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006234s ] [2021-12-18T11:07:28+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '3.1' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.002163s ] [2021-12-18T11:07:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '3.1' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.001609s ] [2021-12-18T11:07:30+08:00][sql] CONNECT:[ UseTime:0.003252s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006478s ] [2021-12-18T11:07:30+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000321s ] [2021-12-18T11:07:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005372s ] [2021-12-18T11:07:30+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796850 , `update_time` = 1639796850 , `delete_time` = 0 [ RunTime:0.000831s ] [2021-12-18T11:07:30+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005669s ] [2021-12-18T11:07:30+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:30' , `operate_user_id` = 4 [ RunTime:0.025983s ] [2021-12-18T11:07:34+08:00][sql] CONNECT:[ UseTime:0.004428s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:34+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006325s ] [2021-12-18T11:07:34+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000340s ] [2021-12-18T11:07:34+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.006283s ] [2021-12-18T11:07:34+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796853 , `update_time` = 1639796853 , `delete_time` = 0 [ RunTime:0.000288s ] [2021-12-18T11:07:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005353s ] [2021-12-18T11:07:34+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:33' , `operate_user_id` = 4 [ RunTime:0.027434s ] [2021-12-18T11:07:35+08:00][sql] CONNECT:[ UseTime:0.004641s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.008108s ] [2021-12-18T11:07:35+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000471s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.007258s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796854 , `update_time` = 1639796854 , `delete_time` = 0 [ RunTime:0.000315s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.009730s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.156031s ] [2021-12-18T11:07:35+08:00][sql] CONNECT:[ UseTime:0.007502s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.009514s ] [2021-12-18T11:07:35+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000608s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.007988s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.000393s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.006438s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.210494s ] [2021-12-18T11:07:35+08:00][sql] CONNECT:[ UseTime:0.005688s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.011036s ] [2021-12-18T11:07:35+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000390s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.007892s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.000342s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.297186s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.160818s ] [2021-12-18T11:07:35+08:00][sql] CONNECT:[ UseTime:0.005531s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.008134s ] [2021-12-18T11:07:35+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000416s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.008008s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.072949s ] [2021-12-18T11:07:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.105869s ] [2021-12-18T11:07:35+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.278503s ] [2021-12-18T11:07:36+08:00][sql] CONNECT:[ UseTime:0.006162s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006796s ] [2021-12-18T11:07:36+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000365s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.299282s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.187035s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.010553s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.249256s ] [2021-12-18T11:07:36+08:00][sql] CONNECT:[ UseTime:0.005765s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.009974s ] [2021-12-18T11:07:36+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000415s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.311467s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.186877s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.010403s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.249277s ] [2021-12-18T11:07:36+08:00][sql] CONNECT:[ UseTime:0.004681s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.008597s ] [2021-12-18T11:07:36+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000301s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.311517s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.085629s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.007630s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.506939s ] [2021-12-18T11:07:36+08:00][sql] CONNECT:[ UseTime:0.007235s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.010143s ] [2021-12-18T11:07:36+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000369s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.311118s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.186832s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.010669s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.430294s ] [2021-12-18T11:07:36+08:00][sql] CONNECT:[ UseTime:0.017216s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.005615s ] [2021-12-18T11:07:36+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 131 [ RunTime:0.000249s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.297565s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=131&user_id=4' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639796855 , `update_time` = 1639796855 , `delete_time` = 0 [ RunTime:0.077328s ] [2021-12-18T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.007808s ] [2021-12-18T11:07:36+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '高天财调查表' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:07:35' , `operate_user_id` = 4 [ RunTime:0.506816s ] [2021-12-18T11:07:57+08:00][sql] CONNECT:[ UseTime:0.005223s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:57+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.007227s ] [2021-12-18T11:07:57+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000868s ] [2021-12-18T11:07:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000360s ] [2021-12-18T11:07:58+08:00][sql] CONNECT:[ UseTime:0.014240s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:07:58+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.006907s ] [2021-12-18T11:07:58+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 AND `role_id` = 9 [ RunTime:0.000553s ] [2021-12-18T11:07:58+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006084s ] [2021-12-18T11:07:58+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001622s ] [2021-12-18T11:07:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005596s ] [2021-12-18T11:07:58+08:00][sql] SELECT `profession_type` FROM `t_doc_dict_profession_type` [ RunTime:0.000265s ] [2021-12-18T11:07:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.005623s ] [2021-12-18T11:07:58+08:00][sql] SELECT `project_name` FROM `t_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000314s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.006471s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009430s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' LIMIT 0,10 [ RunTime:0.003250s ] [2021-12-18T11:08:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002290s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.006360s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009453s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002028s ] [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.010880s ] [2021-12-18T11:08:00+08:00][sql] SELECT `security_classification` FROM `t_doc_dict_security_classification` [ RunTime:0.000291s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.006665s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.007869s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_name` LIKE '%%' AND `project_no` = '9089' [ RunTime:0.000368s ] [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010716s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002622s ] [2021-12-18T11:08:00+08:00][sql] SELECT `tep_menu_name`,`tep_menu_id` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000404s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.006139s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009333s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002816s ] [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.009046s ] [2021-12-18T11:08:00+08:00][sql] SELECT `tep_menu_name` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000357s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.006427s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.007797s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' [ RunTime:0.000438s ] [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010306s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.003460s ] [2021-12-18T11:08:00+08:00][sql] SELECT `tep_menu_name`,`tep_menu_id` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000345s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' AND `status` = '0' [ RunTime:0.002078s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' AND `status` = '1' [ RunTime:0.001373s ] [2021-12-18T11:08:00+08:00][sql] CONNECT:[ UseTime:0.007179s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.007383s ] [2021-12-18T11:08:00+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001924s ] [2021-12-18T11:08:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.006099s ] [2021-12-18T11:08:00+08:00][sql] SELECT `tep_menu_name` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000288s ] [2021-12-18T11:19:21+08:00][sql] CONNECT:[ UseTime:0.004014s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:21+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.006185s ] [2021-12-18T11:19:21+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000637s ] [2021-12-18T11:19:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000459s ] [2021-12-18T11:19:21+08:00][sql] CONNECT:[ UseTime:0.003264s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:21+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005141s ] [2021-12-18T11:19:21+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` [ RunTime:0.000208s ] [2021-12-18T11:19:23+08:00][sql] CONNECT:[ UseTime:0.014131s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:23+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.005119s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '9089' [ RunTime:0.000352s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000248s ] [2021-12-18T11:19:23+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005027s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000198s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000222s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000182s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000194s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000187s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000157s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000165s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '4' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000157s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000136s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '5' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000158s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000124s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '6' AND `project_no` = '9089' AND `status` = 1 [ RunTime:0.000152s ] [2021-12-18T11:19:23+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 2 LIMIT 1 [ RunTime:0.000124s ] [2021-12-18T11:19:25+08:00][sql] CONNECT:[ UseTime:0.014271s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:25+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006916s ] [2021-12-18T11:19:25+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '3.1' AND `project_no` = '9089' AND `status` <> '3' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001218s ] [2021-12-18T11:19:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '3.1' AND `project_no` = '9089' AND `status` <> '3' [ RunTime:0.000902s ] [2021-12-18T11:19:46+08:00][sql] CONNECT:[ UseTime:0.004565s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:46+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.007591s ] [2021-12-18T11:19:46+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '9089' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000815s ] [2021-12-18T11:19:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000343s ] [2021-12-18T11:19:47+08:00][sql] CONNECT:[ UseTime:0.003424s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005341s ] [2021-12-18T11:19:47+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 AND `role_id` = 9 [ RunTime:0.000364s ] [2021-12-18T11:19:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.005486s ] [2021-12-18T11:19:47+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001491s ] [2021-12-18T11:19:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.005237s ] [2021-12-18T11:19:47+08:00][sql] SELECT `profession_type` FROM `t_doc_dict_profession_type` [ RunTime:0.000173s ] [2021-12-18T11:19:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.005264s ] [2021-12-18T11:19:47+08:00][sql] SELECT `project_name` FROM `t_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000351s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.006376s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.007565s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' [ RunTime:0.000313s ] [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.008523s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002240s ] [2021-12-18T11:19:49+08:00][sql] SELECT `tep_menu_name`,`tep_menu_id` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000392s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' AND `status` = '0' [ RunTime:0.000974s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' AND `status` = '1' [ RunTime:0.000954s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.005908s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.007910s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001789s ] [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.007083s ] [2021-12-18T11:19:49+08:00][sql] SELECT `tep_menu_name` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000302s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.004750s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.008499s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_name` LIKE '%%' AND `project_no` = '9089' [ RunTime:0.000359s ] [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.006724s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001965s ] [2021-12-18T11:19:49+08:00][sql] SELECT `tep_menu_name`,`tep_menu_id` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000336s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.004038s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.008326s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' LIMIT 0,10 [ RunTime:0.001844s ] [2021-12-18T11:19:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002208s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.004098s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.008337s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.001595s ] [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.008307s ] [2021-12-18T11:19:49+08:00][sql] SELECT `security_classification` FROM `t_doc_dict_security_classification` [ RunTime:0.000389s ] [2021-12-18T11:19:49+08:00][sql] CONNECT:[ UseTime:0.003910s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.007689s ] [2021-12-18T11:19:49+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '9089' [ RunTime:0.002653s ] [2021-12-18T11:19:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.007519s ] [2021-12-18T11:19:49+08:00][sql] SELECT `tep_menu_name` FROM `t_doc_template_project_menu` WHERE `project_no` = '9089' AND `tep_menu_pid` = 0 [ RunTime:0.000266s ] [2021-12-18T11:20:01+08:00][sql] CONNECT:[ UseTime:0.004083s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:20:01+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.007156s ] [2021-12-18T11:20:01+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `tep_menu_name` LIKE '%前期工作文件%' AND `project_no` = '9089' LIMIT 0,10 [ RunTime:0.001515s ] [2021-12-18T11:20:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `tep_menu_name` LIKE '%前期工作文件%' AND `project_no` = '9089' [ RunTime:0.024690s ] [2021-12-18T11:20:05+08:00][sql] CONNECT:[ UseTime:0.003743s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-18T11:20:05+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.005845s ] [2021-12-18T11:20:05+08:00][sql] SELECT * FROM `t_doc_archive_file` WHERE `id` = 124 [ RunTime:0.000297s ] [2021-12-18T11:20:05+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005247s ] [2021-12-18T11:20:05+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '下载文件' , `url` = '/szym/api/index.php/Document/download?id=124' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639797604 , `update_time` = 1639797604 , `delete_time` = 0 [ RunTime:0.000358s ] [2021-12-18T11:20:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_document_log` [ RunTime:0.005705s ] [2021-12-18T11:20:05+08:00][sql] INSERT INTO `t_imm_document_log` SET `file_name` = '工程项目信息' , `operate_name` = '下载' , `operate_time` = '2021-12-18 11:20:04' , `operate_user_id` = NULL [ RunTime:0.078080s ]