[2022-01-09T09:33:50+08:00][sql] CONNECT:[ UseTime:0.003221s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:50+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.005546s ]
[2022-01-09T09:33:50+08:00][sql] SELECT `id` FROM `t_doc_user` WHERE  `name` = 'admin' LIMIT 1 [ RunTime:0.000328s ]
[2022-01-09T09:33:50+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005553s ]
[2022-01-09T09:33:50+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE  `user_id` = 4  AND `role_id` = 8 LIMIT 1 [ RunTime:0.000273s ]
[2022-01-09T09:33:50+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.084347s ]
[2022-01-09T09:33:50+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE  `role_id` = '8' [ RunTime:0.000512s ]
[2022-01-09T09:33:51+08:00][sql] CONNECT:[ UseTime:0.014166s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:51+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.006123s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000571s ]
[2022-01-09T09:33:51+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.004786s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '53' [ RunTime:0.000348s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '53' ORDER BY `sort` ASC [ RunTime:0.000263s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '54' [ RunTime:0.000353s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '54' ORDER BY `sort` ASC [ RunTime:0.000258s ]
[2022-01-09T09:33:51+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.004414s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000205s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000229s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '55' [ RunTime:0.000345s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '55' ORDER BY `sort` ASC [ RunTime:0.000240s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '57' [ RunTime:0.000308s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '57' ORDER BY `sort` ASC [ RunTime:0.000216s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000128s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000144s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '96' [ RunTime:0.000296s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '96' ORDER BY `sort` ASC [ RunTime:0.000192s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '97' [ RunTime:0.000271s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '97' ORDER BY `sort` ASC [ RunTime:0.000187s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000157s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000148s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '56' [ RunTime:0.000305s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '56' ORDER BY `sort` ASC [ RunTime:0.000223s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '59' [ RunTime:0.000339s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '59' ORDER BY `sort` ASC [ RunTime:0.000201s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '73' [ RunTime:0.000283s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '73' ORDER BY `sort` ASC [ RunTime:0.000190s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000185s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '74' [ RunTime:0.000319s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '74' ORDER BY `sort` ASC [ RunTime:0.000222s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000187s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '75' [ RunTime:0.000374s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '75' ORDER BY `sort` ASC [ RunTime:0.000201s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000191s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000182s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '77' [ RunTime:0.000326s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '77' ORDER BY `sort` ASC [ RunTime:0.000247s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '80' [ RunTime:0.000328s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '80' ORDER BY `sort` ASC [ RunTime:0.000226s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000209s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '83' [ RunTime:0.000284s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '83' ORDER BY `sort` ASC [ RunTime:0.000280s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000189s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '84' [ RunTime:0.000379s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '84' ORDER BY `sort` ASC [ RunTime:0.000246s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000204s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000191s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '66' [ RunTime:0.000340s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '66' ORDER BY `sort` ASC [ RunTime:0.000255s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '67' [ RunTime:0.000320s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '67' ORDER BY `sort` ASC [ RunTime:0.000232s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000189s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '68' [ RunTime:0.000359s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '68' ORDER BY `sort` ASC [ RunTime:0.000243s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000205s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '69' [ RunTime:0.000344s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '69' ORDER BY `sort` ASC [ RunTime:0.000235s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000190s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '95' [ RunTime:0.000343s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '95' ORDER BY `sort` ASC [ RunTime:0.000232s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000165s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000185s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '78' [ RunTime:0.000336s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '78' ORDER BY `sort` ASC [ RunTime:0.000241s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '81' [ RunTime:0.000318s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '81' ORDER BY `sort` ASC [ RunTime:0.000230s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000167s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '85' [ RunTime:0.000328s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '85' ORDER BY `sort` ASC [ RunTime:0.000243s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000186s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000201s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '79' [ RunTime:0.000391s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '79' ORDER BY `sort` ASC [ RunTime:0.000318s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '82' [ RunTime:0.000355s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '82' ORDER BY `sort` ASC [ RunTime:0.000228s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000183s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '87' [ RunTime:0.000321s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '87' ORDER BY `sort` ASC [ RunTime:0.000218s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000185s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '86' [ RunTime:0.000341s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '86' ORDER BY `sort` ASC [ RunTime:0.000256s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000205s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000178s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '71' [ RunTime:0.000314s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '71' ORDER BY `sort` ASC [ RunTime:0.000197s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '72' [ RunTime:0.000274s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '72' ORDER BY `sort` ASC [ RunTime:0.000197s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000148s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '88' [ RunTime:0.000276s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '88' ORDER BY `sort` ASC [ RunTime:0.000205s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000151s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '89' [ RunTime:0.000274s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '89' ORDER BY `sort` ASC [ RunTime:0.000194s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000171s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '76' [ RunTime:0.000297s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '76' ORDER BY `sort` ASC [ RunTime:0.000199s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000156s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000148s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000180s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '14' [ RunTime:0.000317s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '14' ORDER BY `sort` ASC [ RunTime:0.000252s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '17' [ RunTime:0.000332s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '17' ORDER BY `sort` ASC [ RunTime:0.000229s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000200s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '60' [ RunTime:0.000294s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '60' ORDER BY `sort` ASC [ RunTime:0.000230s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '61' [ RunTime:0.000410s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '61' ORDER BY `sort` ASC [ RunTime:0.000255s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000176s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '62' [ RunTime:0.000291s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '62' ORDER BY `sort` ASC [ RunTime:0.000230s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000175s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000178s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '63' [ RunTime:0.000281s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '63' ORDER BY `sort` ASC [ RunTime:0.000233s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '64' [ RunTime:0.000300s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '64' ORDER BY `sort` ASC [ RunTime:0.000215s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000162s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '65' [ RunTime:0.000302s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '65' ORDER BY `sort` ASC [ RunTime:0.000230s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000173s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '70' [ RunTime:0.000307s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '70' ORDER BY `sort` ASC [ RunTime:0.000224s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000183s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000173s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '19' [ RunTime:0.000310s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '19' ORDER BY `sort` ASC [ RunTime:0.000218s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000174s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000170s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '24' [ RunTime:0.000346s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '24' ORDER BY `sort` ASC [ RunTime:0.000277s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '38' [ RunTime:0.000308s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '38' ORDER BY `sort` ASC [ RunTime:0.000221s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000184s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '25' [ RunTime:0.000358s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '25' ORDER BY `sort` ASC [ RunTime:0.000240s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000157s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '37' [ RunTime:0.000370s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '37' ORDER BY `sort` ASC [ RunTime:0.000225s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000138s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000174s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '90' [ RunTime:0.000292s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '90' ORDER BY `sort` ASC [ RunTime:0.000204s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '91' [ RunTime:0.000255s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '91' ORDER BY `sort` ASC [ RunTime:0.000163s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000123s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '92' [ RunTime:0.000242s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '92' ORDER BY `sort` ASC [ RunTime:0.000160s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '93' [ RunTime:0.000240s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '93' ORDER BY `sort` ASC [ RunTime:0.000160s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '94' [ RunTime:0.000247s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '94' ORDER BY `sort` ASC [ RunTime:0.000167s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000177s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000178s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '98' [ RunTime:0.000299s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '98' ORDER BY `sort` ASC [ RunTime:0.000225s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '99' [ RunTime:0.000324s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '99' ORDER BY `sort` ASC [ RunTime:0.000256s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000212s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000218s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '43' [ RunTime:0.000336s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '43' ORDER BY `sort` ASC [ RunTime:0.000263s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '44' [ RunTime:0.000335s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '44' ORDER BY `sort` ASC [ RunTime:0.000251s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000215s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '45' [ RunTime:0.000337s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '45' ORDER BY `sort` ASC [ RunTime:0.000253s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000221s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000213s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '46' [ RunTime:0.000336s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '46' ORDER BY `sort` ASC [ RunTime:0.000267s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '47' [ RunTime:0.000323s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '47' ORDER BY `sort` ASC [ RunTime:0.000248s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000239s ]
[2022-01-09T09:33:51+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE  `menu_id` = '48' [ RunTime:0.000358s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu` WHERE  `pid` = '48' ORDER BY `sort` ASC [ RunTime:0.000270s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 2 LIMIT 1 [ RunTime:0.000188s ]
[2022-01-09T09:33:51+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE  `type_id` = 1 LIMIT 1 [ RunTime:0.000176s ]
[2022-01-09T09:33:53+08:00][sql] CONNECT:[ UseTime:0.003338s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:53+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.006768s ]
[2022-01-09T09:33:53+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE  `role_id` = '8' [ RunTime:0.000599s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003810s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.007334s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE  `user_id` = 4 [ RunTime:0.004942s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003791s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.020333s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_imm_buget` [ RunTime:0.001670s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.004063s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.015361s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_imm_buget` [ RunTime:0.001225s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.028435s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 1 [ RunTime:0.011729s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.023922s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 1 [ RunTime:0.000601s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 2 [ RunTime:0.000238s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 2 [ RunTime:0.000239s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 3 [ RunTime:0.000159s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 3 [ RunTime:0.000203s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 4 [ RunTime:0.000232s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 4 [ RunTime:0.000188s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 6 [ RunTime:0.000212s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 6 [ RunTime:0.000249s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 7 [ RunTime:0.000232s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 7 [ RunTime:0.000188s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 8 [ RunTime:0.000206s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 8 [ RunTime:0.000218s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 9 [ RunTime:0.000228s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 9 [ RunTime:0.000168s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 10 [ RunTime:0.000212s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 10 [ RunTime:0.000210s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 11 [ RunTime:0.000204s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 11 [ RunTime:0.000156s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 12 [ RunTime:0.000187s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 12 [ RunTime:0.000207s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 13 [ RunTime:0.000215s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 13 [ RunTime:0.000158s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 14 [ RunTime:0.000226s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 14 [ RunTime:0.000198s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 15 [ RunTime:0.000250s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 15 [ RunTime:0.000171s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 16 [ RunTime:0.000222s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 16 [ RunTime:0.000165s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 17 [ RunTime:0.000203s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 17 [ RunTime:0.000210s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 18 [ RunTime:0.000237s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 18 [ RunTime:0.000195s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 19 [ RunTime:0.000217s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 19 [ RunTime:0.000178s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 20 [ RunTime:0.000181s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 20 [ RunTime:0.000175s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.004885s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005041s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_imm_buget` [ RunTime:0.000241s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.011910s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 1 [ RunTime:0.011463s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.024422s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 1 [ RunTime:0.000197s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 2 [ RunTime:0.000228s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 2 [ RunTime:0.000204s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 3 [ RunTime:0.000205s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 3 [ RunTime:0.000245s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 4 [ RunTime:0.000181s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 4 [ RunTime:0.000193s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 6 [ RunTime:0.000242s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 6 [ RunTime:0.000168s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 7 [ RunTime:0.000217s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 7 [ RunTime:0.000160s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 8 [ RunTime:0.000182s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 8 [ RunTime:0.000161s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 9 [ RunTime:0.000174s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 9 [ RunTime:0.000197s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 10 [ RunTime:0.000175s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 10 [ RunTime:0.000266s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 11 [ RunTime:0.000204s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 11 [ RunTime:0.000171s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 12 [ RunTime:0.000190s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 12 [ RunTime:0.000220s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 13 [ RunTime:0.000194s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 13 [ RunTime:0.000235s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 14 [ RunTime:0.000218s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 14 [ RunTime:0.000147s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 15 [ RunTime:0.000173s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 15 [ RunTime:0.000150s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 16 [ RunTime:0.000254s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 16 [ RunTime:0.000177s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 17 [ RunTime:0.000207s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 17 [ RunTime:0.000202s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 18 [ RunTime:0.000183s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 18 [ RunTime:0.000187s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 19 [ RunTime:0.000163s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 19 [ RunTime:0.000174s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 20 [ RunTime:0.000224s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 20 [ RunTime:0.000160s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003872s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.019793s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_imm_buget` [ RunTime:0.002276s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.028094s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 1 [ RunTime:0.011912s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.024296s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 1 [ RunTime:0.000259s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 2 [ RunTime:0.000184s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 2 [ RunTime:0.000194s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 3 [ RunTime:0.000214s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 3 [ RunTime:0.000215s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 4 [ RunTime:0.000205s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 4 [ RunTime:0.000173s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 6 [ RunTime:0.000160s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 6 [ RunTime:0.000197s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 7 [ RunTime:0.000211s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 7 [ RunTime:0.000183s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 8 [ RunTime:0.000234s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 8 [ RunTime:0.000211s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 9 [ RunTime:0.000224s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 9 [ RunTime:0.000148s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 10 [ RunTime:0.000195s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 10 [ RunTime:0.000192s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 11 [ RunTime:0.000259s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 11 [ RunTime:0.000184s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 12 [ RunTime:0.000191s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 12 [ RunTime:0.000239s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 13 [ RunTime:0.000176s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 13 [ RunTime:0.000202s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 14 [ RunTime:0.000199s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 14 [ RunTime:0.000178s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 15 [ RunTime:0.000254s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 15 [ RunTime:0.000206s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 16 [ RunTime:0.000190s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 16 [ RunTime:0.000218s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 17 [ RunTime:0.000223s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 17 [ RunTime:0.000202s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 18 [ RunTime:0.000203s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 18 [ RunTime:0.000200s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 19 [ RunTime:0.000190s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 19 [ RunTime:0.000176s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `buget_number` = 20 [ RunTime:0.000179s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` IS NULL  AND `buget_number` = 20 [ RunTime:0.000206s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.013324s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005105s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `buget_estimate` FROM `t_imm_buget` [ RunTime:0.000312s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.004491s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `bugetinfo_approriation` FROM `t_imm_bugetinfo` [ RunTime:0.000247s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.026065s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `pay_amount` FROM `t_imm_usedetail` WHERE  `project_no` = 9089 [ RunTime:0.000284s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_schedule_plan_land` [ RunTime:0.097478s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE  `project_no` = 9089 [ RunTime:0.000493s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE  `project_no` = 9089  AND `percent` = 1 [ RunTime:0.000414s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_imm_schedule_plan_land` WHERE  `project_no` = 9089  AND `percent` <> 1 [ RunTime:0.000498s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_archive_file` [ RunTime:0.006367s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_archive_file` WHERE  `project_no` = '9089' [ RunTime:0.000259s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_template_contract_file` [ RunTime:0.046279s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_template_contract_file` WHERE  `project_no` = '9089' [ RunTime:0.000314s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_change_name` [ RunTime:0.008608s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_change_name` WHERE  `change_type` = '一般设计变更'  AND `project_no` = '9089' [ RunTime:0.011701s ]
[2022-01-09T09:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_change_name` WHERE  `change_type` = '重大设计变更'  AND `project_no` = '9089' [ RunTime:0.000280s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_county_inspect` [ RunTime:0.045471s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_county_inspect` WHERE  `project_no` = 9089 [ RunTime:0.000364s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_city_inspect` [ RunTime:0.048636s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_city_inspect` WHERE  `project_no` = 9089 [ RunTime:0.000382s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `v_imm_province_inspect` [ RunTime:0.041699s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `grade`,`check_date` FROM `v_imm_province_inspect` WHERE  `project_no` = 9089 [ RunTime:0.000346s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.025436s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_doc_project` WHERE  `project_no` = '9089' [ RunTime:0.000391s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003833s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.005349s ]
[2022-01-09T09:33:54+08:00][sql] SELECT DISTINCT  `project_no`,`project_name_easy`,`project_name` FROM `t_doc_project` WHERE  `project_no` = '9089' [ RunTime:0.000634s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003449s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.013462s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000482s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003935s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.006159s ]
[2022-01-09T09:33:54+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000354s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003091s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.005569s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000238s ]
[2022-01-09T09:33:54+08:00][sql] CONNECT:[ UseTime:0.003813s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005593s ]
[2022-01-09T09:33:54+08:00][sql] SELECT * FROM `t_imm_projectlist` WHERE  `gov_no` = 12920 [ RunTime:0.000267s ]
[2022-01-09T09:33:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005788s ]
[2022-01-09T09:33:54+08:00][sql] SELECT SUM(`buget_estimate`) AS think_sum FROM `t_imm_buget` WHERE  `district_id` = 18 [ RunTime:0.000260s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.003621s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005496s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000382s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.003604s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.005205s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `project`,`project_id` FROM `t_imm_projectlist` GROUP BY `project` [ RunTime:0.000383s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.014151s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.008160s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `t_imm_projectlist` WHERE  `gov_no` = 12920 [ RunTime:0.000211s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.003381s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.005528s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `path` = 'money'  AND `role_id` = '8' [ RunTime:0.000472s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '59'  AND `role_id` = '8' [ RunTime:0.000424s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '74'  AND `role_id` = '8' [ RunTime:0.000401s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '75'  AND `role_id` = '8' [ RunTime:0.000454s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '74'  AND `role_id` = '8' [ RunTime:0.000395s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '75'  AND `role_id` = '8' [ RunTime:0.000382s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '74'  AND `role_id` = '8' [ RunTime:0.000383s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '75'  AND `role_id` = '8' [ RunTime:0.000410s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '74'  AND `role_id` = '8' [ RunTime:0.000402s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `v_doc_permission` WHERE  `pid` = '75'  AND `role_id` = '8' [ RunTime:0.000387s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.003170s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_projectlist` [ RunTime:0.004940s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `t_imm_projectlist` WHERE  `project_id` = 9089  AND `gov_no` = 12920 [ RunTime:0.000245s ]
[2022-01-09T09:33:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_projectlist` WHERE  `project_id` = 9089  AND `gov_no` = 12920 [ RunTime:0.000208s ]
[2022-01-09T09:33:55+08:00][sql] CONNECT:[ UseTime:0.012799s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005822s ]
[2022-01-09T09:33:55+08:00][sql] SELECT * FROM `t_imm_buget` WHERE  `district` = '牟平区' [ RunTime:0.000266s ]
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.005030s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000354s ]
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.004697s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000250s ]
[2022-01-09T09:33:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.005082s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '801' [ RunTime:0.000274s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '802' [ RunTime:0.000215s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '803' [ RunTime:0.000207s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000221s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000216s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '901' [ RunTime:0.000206s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '902' [ RunTime:0.000196s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000287s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000181s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '301' [ RunTime:0.000163s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000247s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000233s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '5' [ RunTime:0.000226s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000213s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000230s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '6' [ RunTime:0.000220s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000201s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000198s ]
[2022-01-09T09:33:55+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000227s ]
[2022-01-09T09:33:55+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000225s ]
[2022-01-09T09:33:56+08:00][sql] CONNECT:[ UseTime:0.011863s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005180s ]
[2022-01-09T09:33:56+08:00][sql] SELECT * FROM `t_imm_buget` WHERE  `district` = '牟平区' [ RunTime:0.000191s ]
[2022-01-09T09:33:56+08:00][sql] CONNECT:[ UseTime:0.013092s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005380s ]
[2022-01-09T09:33:56+08:00][sql] SELECT * FROM `t_imm_buget` WHERE  `district` = '牟平区' [ RunTime:0.000273s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.005424s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000296s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.004870s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000236s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.005942s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '801' [ RunTime:0.000217s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '802' [ RunTime:0.000190s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '803' [ RunTime:0.000188s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000208s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000193s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '901' [ RunTime:0.000181s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '902' [ RunTime:0.000182s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000202s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000188s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '301' [ RunTime:0.000155s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000217s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000194s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '5' [ RunTime:0.000183s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000174s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000149s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '6' [ RunTime:0.000145s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000162s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000142s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000211s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000195s ]
[2022-01-09T09:33:56+08:00][sql] CONNECT:[ UseTime:0.003390s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_buget` [ RunTime:0.005415s ]
[2022-01-09T09:33:56+08:00][sql] SELECT * FROM `t_imm_buget` WHERE  `district` = '牟平区' [ RunTime:0.000235s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_bugetinfo` [ RunTime:0.005664s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000278s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_useinfo` [ RunTime:0.004363s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 1 [ RunTime:0.000166s ]
[2022-01-09T09:33:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_usedetail` [ RunTime:0.004697s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '801' [ RunTime:0.000259s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '802' [ RunTime:0.000185s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '803' [ RunTime:0.000139s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000195s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 2 [ RunTime:0.000204s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '901' [ RunTime:0.000216s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '902' [ RunTime:0.000190s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000188s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 3 [ RunTime:0.000151s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '301' [ RunTime:0.000136s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000150s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 4 [ RunTime:0.000134s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '5' [ RunTime:0.000130s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000147s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 10 [ RunTime:0.000133s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`pay_amount`) AS think_sum FROM `t_imm_usedetail` WHERE  `useinfo_number` = '6' [ RunTime:0.000129s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000147s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 11 [ RunTime:0.000131s ]
[2022-01-09T09:33:56+08:00][sql] SELECT SUM(`bugetinfo_approriation`) AS think_sum FROM `t_imm_bugetinfo` WHERE  `district` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000149s ]
[2022-01-09T09:33:56+08:00][sql] SELECT `useinfo_number` FROM `t_imm_useinfo` WHERE  `district_name` = '牟平区'  AND `buget_number` = 18 [ RunTime:0.000131s ]
[2022-01-09T09:34:59+08:00][sql] CONNECT:[ UseTime:0.003821s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T09:34:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.005589s ]
[2022-01-09T09:34:59+08:00][sql] SELECT DISTINCT  `project_no`,`project_name_easy`,`project_name` FROM `t_doc_project` WHERE  `project_no` = '9089' [ RunTime:0.000421s ]
[2022-01-09T10:42:59+08:00][sql] CONNECT:[ UseTime:0.004166s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:42:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_village` [ RunTime:0.005573s ]
[2022-01-09T10:42:59+08:00][sql] SELECT DISTINCT  `county_name` FROM `t_imm_village` WHERE  `project_no` = 9089  AND `county_no` = 12920 [ RunTime:0.000481s ]
[2022-01-09T10:42:59+08:00][sql] SELECT DISTINCT  `town_name` FROM `t_imm_village` WHERE  `project_no` = 9089  AND `county_no` = 12920 [ RunTime:0.000393s ]
[2022-01-09T10:42:59+08:00][sql] SELECT DISTINCT  `village_name` FROM `t_imm_village` WHERE  `project_no` = 9089  AND `county_no` = 12920 [ RunTime:0.000381s ]
[2022-01-09T10:42:59+08:00][sql] SELECT DISTINCT  `group_name` FROM `t_imm_village` WHERE  `project_no` = 9089  AND `county_no` = 12920 [ RunTime:0.000374s ]
[2022-01-09T10:47:22+08:00][sql] CONNECT:[ UseTime:0.004298s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:47:22+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005359s ]
[2022-01-09T10:47:22+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '测试' LIMIT 1 [ RunTime:0.027676s ]
[2022-01-09T10:47:22+08:00][error] [8]Trying to access array offset on value of type null[D:\wamp\www\szym\app\controller\Investigation.php:210]
[2022-01-09T10:51:02+08:00][sql] CONNECT:[ UseTime:0.013373s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:51:02+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005524s ]
[2022-01-09T10:51:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '山东省' LIMIT 1 [ RunTime:0.000312s ]
[2022-01-09T10:51:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '烟台市' LIMIT 1 [ RunTime:0.002652s ]
[2022-01-09T10:51:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '牟平区' LIMIT 1 [ RunTime:0.002767s ]
[2022-01-09T10:51:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '观水镇' LIMIT 1 [ RunTime:0.004111s ]
[2022-01-09T10:51:02+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005335s ]
[2022-01-09T10:51:02+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000340s ]
[2022-01-09T10:51:53+08:00][sql] CONNECT:[ UseTime:0.012254s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:51:53+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005474s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '山东省' LIMIT 1 [ RunTime:0.000256s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '烟台市' LIMIT 1 [ RunTime:0.002578s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '牟平区' LIMIT 1 [ RunTime:0.002595s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '观水镇' LIMIT 1 [ RunTime:0.002624s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '山东省' LIMIT 1 [ RunTime:0.000239s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '烟台市' LIMIT 1 [ RunTime:0.002748s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '牟平区' LIMIT 1 [ RunTime:0.002897s ]
[2022-01-09T10:51:53+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '观水镇' LIMIT 1 [ RunTime:0.002712s ]
[2022-01-09T10:51:53+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005051s ]
[2022-01-09T10:51:53+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000305s ]
[2022-01-09T10:53:19+08:00][sql] CONNECT:[ UseTime:0.005704s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:53:19+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.007074s ]
[2022-01-09T10:53:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` = '山东' LIMIT 1 [ RunTime:0.009587s ]
[2022-01-09T10:53:19+08:00][error] [8]Trying to access array offset on value of type null[D:\wamp\www\szym\app\controller\Investigation.php:211]
[2022-01-09T10:56:35+08:00][sql] CONNECT:[ UseTime:0.003236s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T10:56:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005245s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000297s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002486s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003264s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003278s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000249s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002435s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003335s ]
[2022-01-09T10:56:35+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003352s ]
[2022-01-09T10:56:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005083s ]
[2022-01-09T10:56:35+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000312s ]
[2022-01-09T11:00:12+08:00][sql] CONNECT:[ UseTime:0.013528s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:00:12+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005505s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000243s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002618s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003693s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003298s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000261s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002576s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003265s ]
[2022-01-09T11:00:12+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003376s ]
[2022-01-09T11:00:12+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005258s ]
[2022-01-09T11:00:12+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000343s ]
[2022-01-09T11:00:12+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,测试,2,2,'农业户','是','是','9089','2022-01-09 11:00:12' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,测试,2,2,'农业户','是','是','9089','2022-01-09 11:00:12' ) [ RunTime:0.000397s ]
[2022-01-09T11:00:55+08:00][sql] CONNECT:[ UseTime:0.003360s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:00:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005456s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000319s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002574s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003323s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003279s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000221s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002495s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003405s ]
[2022-01-09T11:00:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003423s ]
[2022-01-09T11:00:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005087s ]
[2022-01-09T11:00:55+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000298s ]
[2022-01-09T11:00:55+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,测试,2,2,'农业户','是','是','9089','2022-01-09 11:00:54' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,测试,2,2,'农业户','是','是','9089','2022-01-09 11:00:54' ) [ RunTime:0.000325s ]
[2022-01-09T11:03:18+08:00][sql] CONNECT:[ UseTime:0.015615s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:03:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005844s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000250s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002462s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003312s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003338s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000299s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002813s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003334s ]
[2022-01-09T11:03:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003289s ]
[2022-01-09T11:03:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005436s ]
[2022-01-09T11:03:18+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000360s ]
[2022-01-09T11:03:18+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,2,2,'农业户','是','是','9089','2022-01-09 11:03:17' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,2,2,'农业户','是','是','9089','2022-01-09 11:03:17' ) [ RunTime:0.000337s ]
[2022-01-09T11:04:40+08:00][sql] CONNECT:[ UseTime:0.004448s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:04:40+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005203s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000300s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002662s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003485s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003337s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000253s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002436s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003220s ]
[2022-01-09T11:04:40+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003459s ]
[2022-01-09T11:04:40+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005393s ]
[2022-01-09T11:04:40+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000295s ]
[2022-01-09T11:04:40+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,410122199808299836,2,2,'农业户','是','是','9089','2022-01-09 11:04:40' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,410122199808299835,2,2,'农业户','是','是','9089','2022-01-09 11:04:40' ) [ RunTime:0.000323s ]
[2022-01-09T11:05:54+08:00][sql] CONNECT:[ UseTime:0.013454s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005485s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000316s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002575s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003285s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003167s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000209s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002582s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003430s ]
[2022-01-09T11:05:54+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003347s ]
[2022-01-09T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005373s ]
[2022-01-09T11:05:54+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000304s ]
[2022-01-09T11:05:54+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,'410122199808299836',2,2,'农业户','是','是','9089','2022-01-09 11:05:54' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,'410122199808299835',2,2,'农业户','是','是','9089','2022-01-09 11:05:54' ) [ RunTime:0.000311s ]
[2022-01-09T11:06:14+08:00][sql] CONNECT:[ UseTime:0.003999s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:06:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005660s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000270s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002595s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003872s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.004454s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000301s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002547s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003307s ]
[2022-01-09T11:06:14+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003269s ]
[2022-01-09T11:06:14+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005341s ]
[2022-01-09T11:06:14+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000329s ]
[2022-01-09T11:06:14+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,'410122199808299836',2,2,'农业户','是','是','9089','2022-01-09 11:06:13' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,'410122199808299835',2,2,'农业户','是','是','9089','2022-01-09 11:06:13' ) [ RunTime:0.000328s ]
[2022-01-09T11:06:55+08:00][sql] CONNECT:[ UseTime:0.014025s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:06:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005759s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000311s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002528s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003267s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003314s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000249s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002740s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003313s ]
[2022-01-09T11:06:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003301s ]
[2022-01-09T11:06:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005149s ]
[2022-01-09T11:06:55+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000316s ]
[2022-01-09T11:07:36+08:00][sql] CONNECT:[ UseTime:0.003759s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005187s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000297s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002510s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003359s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003332s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000319s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002485s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003239s ]
[2022-01-09T11:07:36+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003275s ]
[2022-01-09T11:07:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005558s ]
[2022-01-09T11:07:36+08:00][sql] SELECT `province_name`,`province_no`,`city_name`,`city_no`,`county_name`,`county_no`,`town_name`,`town_no`,`village_name`,`group_name`,`area`,`householder_name`,`altitude`,`nation`,`account_number`,`id_number`,`population_number`,`permanent_residents`,`nature`,`house_occupy`,`land_occupy`,`view_sheet`,`project_no` FROM `t_imm_householder` [ RunTime:0.000351s ]
[2022-01-09T11:14:55+08:00][sql] CONNECT:[ UseTime:0.003644s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:14:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005302s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000234s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002542s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003274s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003393s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000271s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002518s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003265s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003211s ]
[2022-01-09T11:14:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005605s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000315s ]
[2022-01-09T11:14:55+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 1 , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:14:54'  WHERE  `id` = 23 [ RunTime:0.030424s ]
[2022-01-09T11:14:55+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000332s ]
[2022-01-09T11:14:55+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 2 , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:14:54'  WHERE  `id` = 24 [ RunTime:0.023681s ]
[2022-01-09T11:15:17+08:00][sql] CONNECT:[ UseTime:0.013840s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:15:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005368s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000294s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002528s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003277s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003260s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000210s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002527s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003238s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003223s ]
[2022-01-09T11:15:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005320s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000331s ]
[2022-01-09T11:15:17+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000250s ]
[2022-01-09T11:15:17+08:00][sql] REPLACE INTO `t_imm_householder` (`province_name` , `province_no` , `city_name` , `city_no` , `county_name` , `county_no` , `town_name` , `town_no` , `village_name` , `group_name` , `area` , `householder_name` , `altitude` , `nation` , `account_number` , `id_number` , `population_number` , `permanent_residents` , `nature` , `house_occupy` , `land_occupy` , `project_no` , `create_date`) VALUES ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',1,'410122199808299836',2,2,'农业户','是','是','9089','2022-01-09 11:15:16' ) , ( '山东',11,'烟台市',12844,'牟平区',12920,'观水镇',12922,'后富村','测试','淹没区','测试',40,'测试',2,'410122199808299835',2,2,'农业户','是','是','9089','2022-01-09 11:15:16' ) [ RunTime:0.000499s ]
[2022-01-09T11:15:34+08:00][sql] CONNECT:[ UseTime:0.003650s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:15:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005666s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000278s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002855s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003293s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003264s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000246s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002509s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003693s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003312s ]
[2022-01-09T11:15:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005911s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000324s ]
[2022-01-09T11:15:34+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:15:33'  WHERE  `id` = 27 [ RunTime:0.030284s ]
[2022-01-09T11:15:34+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000320s ]
[2022-01-09T11:15:34+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:15:33'  WHERE  `id` = 28 [ RunTime:0.023753s ]
[2022-01-09T11:16:15+08:00][sql] CONNECT:[ UseTime:0.004039s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:16:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005555s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000348s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002579s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003405s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003305s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000211s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002455s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.004049s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.004587s ]
[2022-01-09T11:16:15+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005193s ]
[2022-01-09T11:16:15+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000297s ]
[2022-01-09T11:17:02+08:00][sql] CONNECT:[ UseTime:0.003897s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:17:02+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005358s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000267s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002459s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003350s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003424s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000256s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002576s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003285s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003291s ]
[2022-01-09T11:17:02+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005332s ]
[2022-01-09T11:17:02+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000322s ]
[2022-01-09T11:17:02+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:17:01'  WHERE  `id` = 27 [ RunTime:0.064209s ]
[2022-01-09T11:17:19+08:00][sql] CONNECT:[ UseTime:0.003429s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:17:19+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005149s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000239s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002474s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003237s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003372s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000307s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002509s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003310s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003267s ]
[2022-01-09T11:17:19+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005270s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000406s ]
[2022-01-09T11:17:19+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:17:19'  WHERE  `id` = 27 [ RunTime:0.040117s ]
[2022-01-09T11:17:19+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000357s ]
[2022-01-09T11:17:19+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:17:19'  WHERE  `id` = 28 [ RunTime:0.015377s ]
[2022-01-09T11:18:42+08:00][sql] CONNECT:[ UseTime:0.013457s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T11:18:42+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005505s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000329s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002490s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003381s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003310s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000210s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002460s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003451s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003337s ]
[2022-01-09T11:18:42+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005254s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000259s ]
[2022-01-09T11:18:42+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:18:42'  WHERE  `id` = 27 [ RunTime:0.031153s ]
[2022-01-09T11:18:42+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000287s ]
[2022-01-09T11:18:42+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 11:18:42'  WHERE  `id` = 28 [ RunTime:0.023779s ]
[2022-01-09T15:23:24+08:00][sql] CONNECT:[ UseTime:0.003755s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T15:23:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005354s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000293s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002514s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003223s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003250s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000225s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002490s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003300s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003273s ]
[2022-01-09T15:23:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005157s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000305s ]
[2022-01-09T15:23:24+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:23:24'  WHERE  `id` = 27 [ RunTime:0.035839s ]
[2022-01-09T15:23:24+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000317s ]
[2022-01-09T15:23:24+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:23:24'  WHERE  `id` = 28 [ RunTime:0.031993s ]
[2022-01-09T15:23:24+08:00][error] [8]未定义数组下标: 19[D:\wamp\www\szym\app\controller\Investigation.php:339]
[2022-01-09T15:24:37+08:00][sql] CONNECT:[ UseTime:0.013626s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T15:24:37+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005642s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000317s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002507s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003223s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003194s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000243s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002577s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003309s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003261s ]
[2022-01-09T15:24:37+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005293s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000301s ]
[2022-01-09T15:24:37+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:24:37'  WHERE  `id` = 27 [ RunTime:0.023719s ]
[2022-01-09T15:24:37+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000305s ]
[2022-01-09T15:24:37+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:24:37'  WHERE  `id` = 28 [ RunTime:0.023882s ]
[2022-01-09T15:24:37+08:00][error] [8]未定义数组下标: 19[D:\wamp\www\szym\app\controller\Investigation.php:336]
[2022-01-09T15:25:18+08:00][sql] CONNECT:[ UseTime:0.003306s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T15:25:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.005255s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000292s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002452s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003237s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003263s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000248s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002457s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003236s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003214s ]
[2022-01-09T15:25:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005187s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000300s ]
[2022-01-09T15:25:18+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:25:17'  WHERE  `id` = 27 [ RunTime:0.030242s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000346s ]
[2022-01-09T15:25:18+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:25:17'  WHERE  `id` = 28 [ RunTime:0.024066s ]
[2022-01-09T15:25:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.005962s ]
[2022-01-09T15:25:18+08:00][sql] SELECT * FROM `t_imm_population` WHERE  `id_number` = '410122199808299834' LIMIT 1 [ RunTime:0.000283s ]
[2022-01-09T15:25:18+08:00][sql] REPLACE INTO `t_imm_population` (`area` , `householder_id` , `name` , `relation_householder` , `sex` , `nation` , `age` , `education` , `job` , `registered_residence` , `id_number` , `single` , `project_no` , `create_date`) VALUES ( '淹没区',m1,'测试','父子','男','汉',20,'初中','无','无','410122199808299834','否','9089','2022-01-09 15:25:18' ) [ RunTime:0.000242s ]
[2022-01-09T15:25:59+08:00][sql] CONNECT:[ UseTime:0.013887s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T15:25:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_regions` [ RunTime:0.006361s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000297s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002504s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003251s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003232s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%山东%' LIMIT 1 [ RunTime:0.000214s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `parent_id` = 11  AND `name` LIKE '%烟台市%' LIMIT 1 [ RunTime:0.002445s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%牟平区%' LIMIT 1 [ RunTime:0.003283s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_regions` WHERE  `name` LIKE '%观水镇%' LIMIT 1 [ RunTime:0.003236s ]
[2022-01-09T15:25:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.004933s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299836' LIMIT 1 [ RunTime:0.000273s ]
[2022-01-09T15:25:59+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm1' , `id_number` = '410122199808299836' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:25:59'  WHERE  `id` = 27 [ RunTime:0.030475s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_householder` WHERE  `id_number` = '410122199808299835' LIMIT 1 [ RunTime:0.000361s ]
[2022-01-09T15:25:59+08:00][sql] UPDATE `t_imm_householder`  SET `province_name` = '山东' , `province_no` = 11 , `city_name` = '烟台市' , `city_no` = 12844 , `county_name` = '牟平区' , `county_no` = 12920 , `town_name` = '观水镇' , `town_no` = 12922 , `village_name` = '后富村' , `group_name` = '测试' , `area` = '淹没区' , `householder_name` = '测试' , `altitude` = 40 , `nation` = '测试' , `account_number` = 'm2' , `id_number` = '410122199808299835' , `population_number` = 2 , `permanent_residents` = 2 , `nature` = '农业户' , `house_occupy` = '是' , `land_occupy` = '是' , `project_no` = '9089' , `create_date` = '2022-01-09 15:25:59'  WHERE  `id` = 28 [ RunTime:0.024168s ]
[2022-01-09T15:25:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.005590s ]
[2022-01-09T15:25:59+08:00][sql] SELECT * FROM `t_imm_population` WHERE  `id_number` = '410122199808299834' LIMIT 1 [ RunTime:0.000271s ]
[2022-01-09T15:25:59+08:00][sql] REPLACE INTO `t_imm_population` (`area` , `householder_id` , `name` , `relation_householder` , `sex` , `nation` , `age` , `education` , `job` , `registered_residence` , `id_number` , `single` , `project_no` , `create_date`) VALUES ( '淹没区','m1','测试','父子','男','汉',20,'初中','无','无','410122199808299834','否','9089','2022-01-09 15:25:59' ) [ RunTime:0.000326s ]
[2022-01-09T16:25:34+08:00][error] [8]未定义数组索引: householder_id[D:\wamp\www\szym\app\controller\Investigation.php:409]
[2022-01-09T16:32:38+08:00][error] [8]未定义数组索引: householder_id[D:\wamp\www\szym\app\controller\Investigation.php:439]
[2022-01-09T17:12:54+08:00][sql] CONNECT:[ UseTime:0.013894s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T17:12:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_land` [ RunTime:0.006349s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-1' [ RunTime:0.000257s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积刚','F-T-3-1','9089','园地','苹果',81.26,'0.12 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000194s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-2' [ RunTime:0.000226s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙耿善','F-T-3-2','9089','园地','苹果',85.88,'0.13 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000188s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-3' [ RunTime:0.000252s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积才','F-T-3-3','9089','园地','苹果',28.65,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000206s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-4' [ RunTime:0.000280s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙庆树','F-T-3-4','9089','园地','苹果',100.17,'0.15 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000250s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-5' [ RunTime:0.000226s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙浩善','F-T-3-5','9089','园地','苹果',59.86,'0.09 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000163s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-6' [ RunTime:0.000336s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙鲁敏','F-T-3-6','9089','园地','苹果',64.9,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000258s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-7' [ RunTime:0.000248s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙伟珉','F-T-3-7','9089','园地','苹果',56.57,'0.08 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000215s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-8' [ RunTime:0.000301s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙卫杰','F-T-3-8','9089','园地','苹果',68,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000253s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-9' [ RunTime:0.000295s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积荣','F-T-3-9','9089','园地','苹果',27.86,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000243s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-10' [ RunTime:0.000292s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积江','F-T-3-10','9089','园地','苹果',64.48,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000223s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-11' [ RunTime:0.000268s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积龙','F-T-3-11','9089','园地','苹果',31.15,'0.05 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000277s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-13' [ RunTime:0.000233s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙鄂善','F-T-3-13','9089','园地','苹果',64.87,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000170s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-14' [ RunTime:0.000235s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积东','F-T-3-14','9089','园地','苹果',69.99,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000166s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-15' [ RunTime:0.000269s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积录','F-T-3-15','9089','园地','苹果',79.79,'0.12 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000205s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-16' [ RunTime:0.000228s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙夫善','F-T-3-16','9089','园地','苹果',27.21,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000164s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-17' [ RunTime:0.000856s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙钦善','F-T-3-17','9089','园地','苹果',29.04,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000758s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-18' [ RunTime:0.000240s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙臣善','F-T-3-18','9089','园地','苹果',21.15,'0.03 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000217s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-19' [ RunTime:0.000381s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙君善','F-T-3-19','9089','园地','苹果',23.76,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000246s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-20' [ RunTime:0.000227s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙忠杰','F-T-3-20','9089','园地','苹果',75.84,'0.11 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000182s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-21' [ RunTime:0.000242s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙恺善','F-T-3-21','9089','园地','苹果',26.25,'0.04 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000159s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-22' [ RunTime:0.000271s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积全','F-T-3-22','9089','园地','苹果',66.54,'0.10 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000202s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-23' [ RunTime:0.000238s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙善波','F-T-3-23','9089','园地','苹果',75.52,'0.11 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000163s ]
[2022-01-09T17:12:54+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-24' [ RunTime:0.000251s ]
[2022-01-09T17:12:54+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `drip_irrigation` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙伟珉','F-T-3-24','是','9089','园地','樱桃',164.85,'0.25 ','盛果期','2022-01-09 17:12:54' ) [ RunTime:0.000189s ]
[2022-01-09T17:13:48+08:00][sql] CONNECT:[ UseTime:0.013266s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T17:13:48+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_land` [ RunTime:0.005959s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-1' [ RunTime:0.018084s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积刚','F-T-3-1','9089','园地','苹果',81.26,'0.12 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000225s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-2' [ RunTime:0.015676s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙耿善','F-T-3-2','9089','园地','苹果',85.88,'0.13 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000215s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-3' [ RunTime:0.016478s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积才','F-T-3-3','9089','园地','苹果',28.65,'0.04 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000280s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-4' [ RunTime:0.032982s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙庆树','F-T-3-4','9089','园地','苹果',100.17,'0.15 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000210s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-5' [ RunTime:0.016347s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙浩善','F-T-3-5','9089','园地','苹果',59.86,'0.09 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000200s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-6' [ RunTime:0.016373s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙鲁敏','F-T-3-6','9089','园地','苹果',64.9,'0.10 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000217s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-7' [ RunTime:0.016315s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙伟珉','F-T-3-7','9089','园地','苹果',56.57,'0.08 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000280s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-8' [ RunTime:0.016889s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙卫杰','F-T-3-8','9089','园地','苹果',68,'0.10 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000243s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-9' [ RunTime:0.016583s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积荣','F-T-3-9','9089','园地','苹果',27.86,'0.04 ','盛果期','2022-01-09 17:13:47' ) [ RunTime:0.000330s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-10' [ RunTime:0.016123s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积江','F-T-3-10','9089','园地','苹果',64.48,'0.10 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000251s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-11' [ RunTime:0.025127s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积龙','F-T-3-11','9089','园地','苹果',31.15,'0.05 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.001140s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-13' [ RunTime:0.072340s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙鄂善','F-T-3-13','9089','园地','苹果',64.87,'0.10 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000268s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-14' [ RunTime:0.038075s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积东','F-T-3-14','9089','园地','苹果',69.99,'0.10 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000286s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-15' [ RunTime:0.034746s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积录','F-T-3-15','9089','园地','苹果',79.79,'0.12 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000205s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-16' [ RunTime:0.048334s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙夫善','F-T-3-16','9089','园地','苹果',27.21,'0.04 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000291s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-17' [ RunTime:0.016379s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙钦善','F-T-3-17','9089','园地','苹果',29.04,'0.04 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000278s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-18' [ RunTime:0.016387s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙臣善','F-T-3-18','9089','园地','苹果',21.15,'0.03 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000197s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-19' [ RunTime:0.016821s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙君善','F-T-3-19','9089','园地','苹果',23.76,'0.04 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.001009s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-20' [ RunTime:0.015366s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙忠杰','F-T-3-20','9089','园地','苹果',75.84,'0.11 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000279s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-21' [ RunTime:0.016368s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙恺善','F-T-3-21','9089','园地','苹果',26.25,'0.04 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000315s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-22' [ RunTime:0.016442s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙积全','F-T-3-22','9089','园地','苹果',66.54,'0.10 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000273s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-23' [ RunTime:0.014802s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙善波','F-T-3-23','9089','园地','苹果',75.52,'0.11 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000255s ]
[2022-01-09T17:13:48+08:00][sql] DELETE FROM `t_imm_land` WHERE  `Land_id` = 'F-T-3-24' [ RunTime:0.016252s ]
[2022-01-09T17:13:48+08:00][sql] REPLACE INTO `t_imm_land` (`area` , `owner` , `Land_id` , `drip_irrigation` , `project_no` , `type` , `purpose` , `measure` , `number` , `period` , `create_date`) VALUES ( '枢纽区','孙伟珉','F-T-3-24','是','9089','园地','樱桃',164.85,'0.25 ','盛果期','2022-01-09 17:13:48' ) [ RunTime:0.000289s ]
[2022-01-09T20:49:32+08:00][sql] CONNECT:[ UseTime:0.003382s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T20:49:32+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005943s ]
[2022-01-09T20:49:32+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.000251s ]
[2022-01-09T20:49:32+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 20:49:31' ) [ RunTime:0.000231s ]
[2022-01-09T22:27:49+08:00][sql] CONNECT:[ UseTime:0.013612s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T22:27:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005316s ]
[2022-01-09T22:27:49+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.191487s ]
[2022-01-09T22:27:49+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 22:27:49' ) [ RunTime:0.000196s ]
[2022-01-09T22:27:49+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 22:27:49' LIMIT 1 [ RunTime:0.000478s ]
[2022-01-09T22:57:32+08:00][sql] CONNECT:[ UseTime:0.003140s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T22:57:32+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005461s ]
[2022-01-09T22:57:32+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.032268s ]
[2022-01-09T22:57:32+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 22:57:32' ) [ RunTime:0.000240s ]
[2022-01-09T22:57:32+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 22:57:32' LIMIT 1 [ RunTime:0.000439s ]
[2022-01-09T22:57:32+08:00][error] [8]未定义数组下标: 74[D:\wamp\www\szym\app\controller\Investigation.php:1585]
[2022-01-09T23:00:07+08:00][sql] CONNECT:[ UseTime:0.013202s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:00:07+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005545s ]
[2022-01-09T23:00:07+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.015979s ]
[2022-01-09T23:00:07+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:00:07' ) [ RunTime:0.000320s ]
[2022-01-09T23:00:07+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:00:07' LIMIT 1 [ RunTime:0.000326s ]
[2022-01-09T23:00:26+08:00][sql] CONNECT:[ UseTime:0.013074s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:00:26+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005750s ]
[2022-01-09T23:00:26+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.050452s ]
[2022-01-09T23:00:26+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:00:26' ) [ RunTime:0.000266s ]
[2022-01-09T23:00:26+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:00:26' LIMIT 1 [ RunTime:0.000374s ]
[2022-01-09T23:01:18+08:00][sql] CONNECT:[ UseTime:0.003922s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:01:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005988s ]
[2022-01-09T23:01:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.035724s ]
[2022-01-09T23:01:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.000214s ]
[2022-01-09T23:01:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.000172s ]
[2022-01-09T23:01:18+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:01:18' ) , ( 2,'9089','2022-01-09 23:01:18' ) , ( 3,'9089','2022-01-09 23:01:18' ) [ RunTime:0.000219s ]
[2022-01-09T23:01:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:18' LIMIT 1 [ RunTime:0.000366s ]
[2022-01-09T23:01:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:18' LIMIT 1 [ RunTime:0.000276s ]
[2022-01-09T23:01:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:18' LIMIT 1 [ RunTime:0.000248s ]
[2022-01-09T23:01:44+08:00][sql] CONNECT:[ UseTime:0.013714s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:01:44+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005354s ]
[2022-01-09T23:01:44+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.022994s ]
[2022-01-09T23:01:44+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016297s ]
[2022-01-09T23:01:44+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016497s ]
[2022-01-09T23:01:44+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:01:44' ) , ( 2,'9089','2022-01-09 23:01:44' ) , ( 3,'9089','2022-01-09 23:01:44' ) [ RunTime:0.000288s ]
[2022-01-09T23:01:44+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:44' LIMIT 1 [ RunTime:0.000438s ]
[2022-01-09T23:01:44+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:44' LIMIT 1 [ RunTime:0.000325s ]
[2022-01-09T23:01:44+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:01:44' LIMIT 1 [ RunTime:0.000288s ]
[2022-01-09T23:02:05+08:00][sql] CONNECT:[ UseTime:0.003450s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:02:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005444s ]
[2022-01-09T23:02:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.036522s ]
[2022-01-09T23:02:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016235s ]
[2022-01-09T23:02:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016383s ]
[2022-01-09T23:02:05+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:02:05' ) , ( 2,'9089','2022-01-09 23:02:05' ) , ( 3,'9089','2022-01-09 23:02:05' ) [ RunTime:0.000227s ]
[2022-01-09T23:02:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:02:05' LIMIT 1 [ RunTime:0.000356s ]
[2022-01-09T23:02:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:02:05' LIMIT 1 [ RunTime:0.000236s ]
[2022-01-09T23:02:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:02:05' LIMIT 1 [ RunTime:0.000203s ]
[2022-01-09T23:04:41+08:00][error] [8]未定义变量: data1[D:\wamp\www\szym\app\controller\Investigation.php:1588]
[2022-01-09T23:05:32+08:00][sql] CONNECT:[ UseTime:0.012320s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:05:32+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005696s ]
[2022-01-09T23:05:32+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.020385s ]
[2022-01-09T23:05:32+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016414s ]
[2022-01-09T23:05:32+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016234s ]
[2022-01-09T23:05:32+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:05:32' ) , ( 2,'9089','2022-01-09 23:05:32' ) , ( 3,'9089','2022-01-09 23:05:32' ) [ RunTime:0.000224s ]
[2022-01-09T23:05:32+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:05:32' LIMIT 1 [ RunTime:0.000377s ]
[2022-01-09T23:05:32+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:05:32' LIMIT 1 [ RunTime:0.000269s ]
[2022-01-09T23:05:32+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:05:32' LIMIT 1 [ RunTime:0.000286s ]
[2022-01-09T23:05:32+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005960s ]
[2022-01-09T23:05:32+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 38 [ RunTime:0.000327s ]
[2022-01-09T23:05:32+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 40 [ RunTime:0.000277s ]
[2022-01-09T23:05:32+08:00][error] [10501]SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768]
[2022-01-09T23:07:05+08:00][sql] CONNECT:[ UseTime:0.003163s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:07:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005649s ]
[2022-01-09T23:07:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.031726s ]
[2022-01-09T23:07:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.015312s ]
[2022-01-09T23:07:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016252s ]
[2022-01-09T23:07:05+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:07:05' ) , ( 2,'9089','2022-01-09 23:07:05' ) , ( 3,'9089','2022-01-09 23:07:05' ) [ RunTime:0.000265s ]
[2022-01-09T23:07:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:07:05' LIMIT 1 [ RunTime:0.000325s ]
[2022-01-09T23:07:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:07:05' LIMIT 1 [ RunTime:0.000257s ]
[2022-01-09T23:07:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:07:05' LIMIT 1 [ RunTime:0.000240s ]
[2022-01-09T23:07:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005280s ]
[2022-01-09T23:07:05+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 41 [ RunTime:0.000271s ]
[2022-01-09T23:07:05+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 43 [ RunTime:0.000217s ]
[2022-01-09T23:07:05+08:00][sql] REPLACE INTO `t_imm_ancillary_facilities` (`house_id` , `area` , `name` , `nature` , `numbers` , `size` , `unit`) VALUES ( 41,NULL,'热水器','燃气',1,1,'个' ) , ( 43,NULL,'空调','',1,1,'个' ) [ RunTime:0.000233s ]
[2022-01-09T23:09:05+08:00][sql] CONNECT:[ UseTime:0.013038s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:09:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.008232s ]
[2022-01-09T23:09:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.027549s ]
[2022-01-09T23:09:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016263s ]
[2022-01-09T23:09:05+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016438s ]
[2022-01-09T23:09:05+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:09:05' ) , ( 2,'9089','2022-01-09 23:09:05' ) , ( 3,'9089','2022-01-09 23:09:05' ) [ RunTime:0.000278s ]
[2022-01-09T23:09:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:09:05' LIMIT 1 [ RunTime:0.000329s ]
[2022-01-09T23:09:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:09:05' LIMIT 1 [ RunTime:0.000250s ]
[2022-01-09T23:09:05+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:09:05' LIMIT 1 [ RunTime:0.000223s ]
[2022-01-09T23:09:05+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005164s ]
[2022-01-09T23:09:05+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 44 [ RunTime:0.000285s ]
[2022-01-09T23:09:05+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `house_id` = 46 [ RunTime:0.000237s ]
[2022-01-09T23:09:05+08:00][sql] REPLACE INTO `t_imm_ancillary_facilities` (`house_id` , `householder_id` , `create_date` , `area` , `name` , `nature` , `numbers` , `size` , `unit`) VALUES ( 44,1,'2022-01-09 23:09:05',NULL,'热水器','燃气',1,1,'个' ) , ( 46,3,'2022-01-09 23:09:05',NULL,'空调','',1,1,'个' ) [ RunTime:0.000276s ]
[2022-01-09T23:14:56+08:00][sql] CONNECT:[ UseTime:0.003943s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:14:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005604s ]
[2022-01-09T23:14:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.027595s ]
[2022-01-09T23:14:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016370s ]
[2022-01-09T23:14:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016321s ]
[2022-01-09T23:14:56+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:14:55' ) , ( 2,'9089','2022-01-09 23:14:55' ) , ( 3,'9089','2022-01-09 23:14:55' ) [ RunTime:0.000302s ]
[2022-01-09T23:14:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:14:55' LIMIT 1 [ RunTime:0.000528s ]
[2022-01-09T23:14:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:14:55' LIMIT 1 [ RunTime:0.000342s ]
[2022-01-09T23:14:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:14:55' LIMIT 1 [ RunTime:0.000303s ]
[2022-01-09T23:14:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005684s ]
[2022-01-09T23:14:56+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 1 [ RunTime:0.032969s ]
[2022-01-09T23:14:56+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 3 [ RunTime:0.016370s ]
[2022-01-09T23:14:56+08:00][sql] REPLACE INTO `t_imm_ancillary_facilities` (`house_id` , `householder_id` , `area` , `name` , `nature` , `numbers` , `size` , `unit` , `create_date` , `project_no`) VALUES ( 47,1,NULL,'热水器','燃气',1,1,'个','2022-01-09 23:14:55','9089' ) , ( 49,3,NULL,'空调','',1,1,'个','2022-01-09 23:14:56','9089' ) [ RunTime:0.000388s ]
[2022-01-09T23:16:18+08:00][sql] CONNECT:[ UseTime:0.013483s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:16:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005490s ]
[2022-01-09T23:16:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.028282s ]
[2022-01-09T23:16:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.016313s ]
[2022-01-09T23:16:18+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.016411s ]
[2022-01-09T23:16:18+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:16:17' ) , ( 2,'9089','2022-01-09 23:16:17' ) , ( 3,'9089','2022-01-09 23:16:17' ) [ RunTime:0.000307s ]
[2022-01-09T23:16:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:17' LIMIT 1 [ RunTime:0.000384s ]
[2022-01-09T23:16:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:17' LIMIT 1 [ RunTime:0.000300s ]
[2022-01-09T23:16:18+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:17' LIMIT 1 [ RunTime:0.000265s ]
[2022-01-09T23:16:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005347s ]
[2022-01-09T23:16:18+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 1  AND `project_no` = '9089' [ RunTime:0.025515s ]
[2022-01-09T23:16:18+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 3  AND `project_no` = '9089' [ RunTime:0.016294s ]
[2022-01-09T23:16:18+08:00][sql] REPLACE INTO `t_imm_ancillary_facilities` (`house_id` , `householder_id` , `area` , `name` , `nature` , `numbers` , `size` , `unit` , `create_date` , `project_no`) VALUES ( 50,1,NULL,'热水器','燃气',1,1,'个','2022-01-09 23:16:18','9089' ) , ( 52,3,NULL,'空调','',1,1,'个','2022-01-09 23:16:18','9089' ) [ RunTime:0.000310s ]
[2022-01-09T23:16:56+08:00][sql] CONNECT:[ UseTime:0.012450s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4
[2022-01-09T23:16:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005608s ]
[2022-01-09T23:16:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 1 [ RunTime:0.019425s ]
[2022-01-09T23:16:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 2 [ RunTime:0.033026s ]
[2022-01-09T23:16:56+08:00][sql] DELETE FROM `t_imm_house` WHERE  `householder_id` = 3 [ RunTime:0.024682s ]
[2022-01-09T23:16:56+08:00][sql] REPLACE INTO `t_imm_house` (`householder_id` , `project_no` , `create_date`) VALUES ( 1,'9089','2022-01-09 23:16:55' ) , ( 2,'9089','2022-01-09 23:16:55' ) , ( 3,'9089','2022-01-09 23:16:55' ) [ RunTime:0.000331s ]
[2022-01-09T23:16:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 1  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:55' LIMIT 1 [ RunTime:0.000363s ]
[2022-01-09T23:16:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 2  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:55' LIMIT 1 [ RunTime:0.000310s ]
[2022-01-09T23:16:56+08:00][sql] SELECT * FROM `t_imm_house` WHERE  `householder_id` = 3  AND `project_no` = '9089'  AND `create_date` = '2022-01-09 23:16:55' LIMIT 1 [ RunTime:0.000288s ]
[2022-01-09T23:16:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005922s ]
[2022-01-09T23:16:56+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 1  AND `project_no` = '9089' [ RunTime:0.024179s ]
[2022-01-09T23:16:56+08:00][sql] DELETE FROM `t_imm_ancillary_facilities` WHERE  `householder_id` = 3  AND `project_no` = '9089' [ RunTime:0.016356s ]
[2022-01-09T23:16:56+08:00][sql] REPLACE INTO `t_imm_ancillary_facilities` (`house_id` , `householder_id` , `area` , `name` , `nature` , `numbers` , `size` , `unit` , `create_date` , `project_no`) VALUES ( 53,1,NULL,'热水器','燃气',1,1,'个','2022-01-09 23:16:56','9089' ) , ( 55,3,NULL,'空调','',1,1,'个','2022-01-09 23:16:56','9089' ) [ RunTime:0.000432s ]