[2022-01-18T23:38:52+08:00][sql] CONNECT:[ UseTime:0.003996s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:38:52+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_village` [ RunTime:0.005554s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `province_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000531s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `city_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000597s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000453s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `town_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000399s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `village_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000476s ] [2022-01-18T23:38:52+08:00][sql] SELECT DISTINCT `group_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000421s ] [2022-01-18T23:40:21+08:00][sql] CONNECT:[ UseTime:0.013066s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:21+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006458s ] [2022-01-18T23:40:21+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `account_number` = 'M-3-002' LIMIT 1 [ RunTime:0.000385s ] [2022-01-18T23:40:21+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.005424s ] [2022-01-18T23:40:21+08:00][sql] SELECT * FROM `t_imm_population` WHERE `householder_id` = 'M-3-002' [ RunTime:0.002310s ] [2022-01-18T23:40:21+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_investigation_attachment` [ RunTime:0.009534s ] [2022-01-18T23:40:21+08:00][sql] INSERT INTO `t_imm_investigation_attachment` SET `file_url` = 'doc/系统管理员_4_农村家庭调查表.docx' , `file_name` = '王翠刚农村家庭调查表.docx' [ RunTime:0.020886s ] [2022-01-18T23:40:22+08:00][sql] CONNECT:[ UseTime:0.003645s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:22+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_investigation_attachment` [ RunTime:0.005439s ] [2022-01-18T23:40:22+08:00][sql] SELECT * FROM `t_imm_investigation_attachment` WHERE `id` = 215 [ RunTime:0.000247s ] [2022-01-18T23:40:29+08:00][sql] CONNECT:[ UseTime:0.003418s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006044s ] [2022-01-18T23:40:29+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `account_number` = 'M-3-002' LIMIT 1 [ RunTime:0.000337s ] [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.005619s ] [2022-01-18T23:40:29+08:00][sql] SELECT * FROM `t_imm_population` WHERE `householder_id` = 'M-3-002' [ RunTime:0.002195s ] [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_investigation_attachment` [ RunTime:0.010627s ] [2022-01-18T23:40:29+08:00][sql] INSERT INTO `t_imm_investigation_attachment` SET `file_url` = 'doc/系统管理员_4_农村家庭调查表.pdf' , `file_name` = '王翠刚农村家庭调查表.pdf' [ RunTime:0.045113s ] [2022-01-18T23:40:29+08:00][sql] CONNECT:[ UseTime:0.004154s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006955s ] [2022-01-18T23:40:29+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `account_number` = 'M-3-002' LIMIT 1 [ RunTime:0.000387s ] [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.006189s ] [2022-01-18T23:40:29+08:00][sql] SELECT * FROM `t_imm_population` WHERE `householder_id` = 'M-3-002' [ RunTime:0.002328s ] [2022-01-18T23:40:29+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_investigation_attachment` [ RunTime:0.010182s ] [2022-01-18T23:40:29+08:00][sql] INSERT INTO `t_imm_investigation_attachment` SET `file_url` = 'doc/系统管理员_4_农村家庭调查表.pdf' , `file_name` = '王翠刚农村家庭调查表.pdf' [ RunTime:0.027348s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.004479s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillarynature_dict` [ RunTime:0.006561s ] [2022-01-18T23:40:34+08:00][sql] SELECT `nature` FROM `t_imm_ancillarynature_dict` [ RunTime:0.000289s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.004371s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryname_dict` [ RunTime:0.006995s ] [2022-01-18T23:40:34+08:00][sql] SELECT `name` FROM `t_imm_ancillaryname_dict` [ RunTime:0.000207s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.004591s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.006925s ] [2022-01-18T23:40:34+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000457s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.003586s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006235s ] [2022-01-18T23:40:34+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000231s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.005008s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005611s ] [2022-01-18T23:40:34+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000376s ] [2022-01-18T23:40:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000332s ] [2022-01-18T23:40:34+08:00][sql] CONNECT:[ UseTime:0.028379s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:34+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryunit_dict` [ RunTime:0.005583s ] [2022-01-18T23:40:34+08:00][sql] SELECT `unit` FROM `t_imm_ancillaryunit_dict` [ RunTime:0.000235s ] [2022-01-18T23:40:35+08:00][sql] CONNECT:[ UseTime:0.003445s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.006828s ] [2022-01-18T23:40:35+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%%' [ RunTime:0.000411s ] [2022-01-18T23:40:35+08:00][sql] CONNECT:[ UseTime:0.003415s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006417s ] [2022-01-18T23:40:35+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000200s ] [2022-01-18T23:40:35+08:00][sql] CONNECT:[ UseTime:0.003707s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.005663s ] [2022-01-18T23:40:35+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000176s ] [2022-01-18T23:40:35+08:00][sql] CONNECT:[ UseTime:0.003558s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_decoration_dict` [ RunTime:0.005870s ] [2022-01-18T23:40:35+08:00][sql] SELECT DISTINCT `name` FROM `t_imm_decoration_dict` [ RunTime:0.000363s ] [2022-01-18T23:40:35+08:00][sql] CONNECT:[ UseTime:0.003333s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.004562s ] [2022-01-18T23:40:35+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000168s ] [2022-01-18T23:40:37+08:00][sql] CONNECT:[ UseTime:0.013583s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:37+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006285s ] [2022-01-18T23:40:37+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001858s ] [2022-01-18T23:40:39+08:00][sql] CONNECT:[ UseTime:0.003206s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:40:39+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_decoration` [ RunTime:0.005959s ] [2022-01-18T23:40:39+08:00][sql] SELECT * FROM `t_imm_decoration` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.000253s ] [2022-01-18T23:40:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_decoration` WHERE `householder_id` = 'M-3-002' [ RunTime:0.000343s ] [2022-01-18T23:41:43+08:00][sql] CONNECT:[ UseTime:0.004324s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:41:43+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005726s ] [2022-01-18T23:41:43+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001681s ] [2022-01-18T23:45:06+08:00][sql] CONNECT:[ UseTime:0.013452s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:06+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005911s ] [2022-01-18T23:45:06+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.001734s ] [2022-01-18T23:45:35+08:00][sql] CONNECT:[ UseTime:0.013969s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.007424s ] [2022-01-18T23:45:35+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001656s ] [2022-01-18T23:45:45+08:00][sql] CONNECT:[ UseTime:0.003170s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006998s ] [2022-01-18T23:45:45+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-004' LIMIT 0,10 [ RunTime:0.001738s ] [2022-01-18T23:45:48+08:00][sql] CONNECT:[ UseTime:0.004737s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:48+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006658s ] [2022-01-18T23:45:48+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001821s ] [2022-01-18T23:45:54+08:00][sql] CONNECT:[ UseTime:0.003496s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.005966s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000657s ] [2022-01-18T23:45:54+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.006032s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '53' [ RunTime:0.000415s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '53' ORDER BY `sort` ASC [ RunTime:0.000229s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '54' [ RunTime:0.000320s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '54' ORDER BY `sort` ASC [ RunTime:0.000211s ] [2022-01-18T23:45:54+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.005590s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000212s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000143s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '55' [ RunTime:0.000334s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '55' ORDER BY `sort` ASC [ RunTime:0.000219s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '57' [ RunTime:0.000284s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '57' ORDER BY `sort` ASC [ RunTime:0.000188s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000134s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000124s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '96' [ RunTime:0.000299s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '96' ORDER BY `sort` ASC [ RunTime:0.000221s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '107' [ RunTime:0.000306s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '107' ORDER BY `sort` ASC [ RunTime:0.000286s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '108' [ RunTime:0.000346s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '108' ORDER BY `sort` ASC [ RunTime:0.000211s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000162s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '109' [ RunTime:0.000345s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '109' ORDER BY `sort` ASC [ RunTime:0.000189s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000136s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '110' [ RunTime:0.000304s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '110' ORDER BY `sort` ASC [ RunTime:0.000180s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000130s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '114' [ RunTime:0.000327s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '114' ORDER BY `sort` ASC [ RunTime:0.000217s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000163s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '115' [ RunTime:0.000339s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '115' ORDER BY `sort` ASC [ RunTime:0.000225s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000152s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '116' [ RunTime:0.000349s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '116' ORDER BY `sort` ASC [ RunTime:0.000218s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000149s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '119' [ RunTime:0.000328s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '119' ORDER BY `sort` ASC [ RunTime:0.000198s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000134s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '120' [ RunTime:0.000324s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '120' ORDER BY `sort` ASC [ RunTime:0.000196s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000148s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '121' [ RunTime:0.000327s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '121' ORDER BY `sort` ASC [ RunTime:0.000196s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000134s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '122' [ RunTime:0.000304s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '122' ORDER BY `sort` ASC [ RunTime:0.000210s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000139s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000124s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '111' [ RunTime:0.000302s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '111' ORDER BY `sort` ASC [ RunTime:0.000259s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '112' [ RunTime:0.000314s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '112' ORDER BY `sort` ASC [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000139s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '113' [ RunTime:0.000325s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '113' ORDER BY `sort` ASC [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000126s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '117' [ RunTime:0.000318s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '117' ORDER BY `sort` ASC [ RunTime:0.000215s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000143s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '118' [ RunTime:0.000331s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '118' ORDER BY `sort` ASC [ RunTime:0.000235s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000157s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000166s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '101' [ RunTime:0.000361s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '101' ORDER BY `sort` ASC [ RunTime:0.000246s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '102' [ RunTime:0.000349s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '102' ORDER BY `sort` ASC [ RunTime:0.000199s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000131s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '103' [ RunTime:0.000306s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '103' ORDER BY `sort` ASC [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000127s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '104' [ RunTime:0.000307s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '104' ORDER BY `sort` ASC [ RunTime:0.000190s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000169s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '105' [ RunTime:0.000345s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '105' ORDER BY `sort` ASC [ RunTime:0.000206s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000141s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '106' [ RunTime:0.000364s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '106' ORDER BY `sort` ASC [ RunTime:0.000198s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000159s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000146s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '100' [ RunTime:0.000325s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '100' ORDER BY `sort` ASC [ RunTime:0.000244s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000166s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '97' [ RunTime:0.000347s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '97' ORDER BY `sort` ASC [ RunTime:0.000213s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000143s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000134s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '56' [ RunTime:0.000387s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '56' ORDER BY `sort` ASC [ RunTime:0.000306s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '59' [ RunTime:0.000446s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '59' ORDER BY `sort` ASC [ RunTime:0.000278s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '73' [ RunTime:0.000373s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '73' ORDER BY `sort` ASC [ RunTime:0.000228s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000180s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '74' [ RunTime:0.000373s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '74' ORDER BY `sort` ASC [ RunTime:0.000245s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000167s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '75' [ RunTime:0.000423s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '75' ORDER BY `sort` ASC [ RunTime:0.000233s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000161s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000186s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '77' [ RunTime:0.000392s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '77' ORDER BY `sort` ASC [ RunTime:0.000270s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '80' [ RunTime:0.000355s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '80' ORDER BY `sort` ASC [ RunTime:0.000217s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '83' [ RunTime:0.000310s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '83' ORDER BY `sort` ASC [ RunTime:0.000198s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000138s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '84' [ RunTime:0.000347s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '84' ORDER BY `sort` ASC [ RunTime:0.000259s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000210s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000162s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '66' [ RunTime:0.000379s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '66' ORDER BY `sort` ASC [ RunTime:0.000303s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '67' [ RunTime:0.000333s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '67' ORDER BY `sort` ASC [ RunTime:0.000220s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000213s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '68' [ RunTime:0.000344s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '68' ORDER BY `sort` ASC [ RunTime:0.000207s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000159s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '69' [ RunTime:0.000334s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '69' ORDER BY `sort` ASC [ RunTime:0.000200s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000138s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '95' [ RunTime:0.000315s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '95' ORDER BY `sort` ASC [ RunTime:0.000226s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000191s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '78' [ RunTime:0.000365s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '78' ORDER BY `sort` ASC [ RunTime:0.000255s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '81' [ RunTime:0.000326s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '81' ORDER BY `sort` ASC [ RunTime:0.000211s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000149s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '85' [ RunTime:0.000372s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '85' ORDER BY `sort` ASC [ RunTime:0.000207s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000147s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000153s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '79' [ RunTime:0.000364s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '79' ORDER BY `sort` ASC [ RunTime:0.000214s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '82' [ RunTime:0.000311s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '82' ORDER BY `sort` ASC [ RunTime:0.000196s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000174s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '87' [ RunTime:0.000419s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '87' ORDER BY `sort` ASC [ RunTime:0.000245s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000168s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '86' [ RunTime:0.000333s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '86' ORDER BY `sort` ASC [ RunTime:0.000205s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000135s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000149s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '71' [ RunTime:0.000369s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '71' ORDER BY `sort` ASC [ RunTime:0.000250s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '72' [ RunTime:0.000324s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '72' ORDER BY `sort` ASC [ RunTime:0.000213s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000148s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '88' [ RunTime:0.000320s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '88' ORDER BY `sort` ASC [ RunTime:0.000207s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000152s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '89' [ RunTime:0.000355s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '89' ORDER BY `sort` ASC [ RunTime:0.000222s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000166s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '76' [ RunTime:0.000380s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '76' ORDER BY `sort` ASC [ RunTime:0.000204s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000135s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000148s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000138s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '14' [ RunTime:0.000352s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '14' ORDER BY `sort` ASC [ RunTime:0.000230s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '17' [ RunTime:0.000320s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '17' ORDER BY `sort` ASC [ RunTime:0.000207s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000152s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '60' [ RunTime:0.000319s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '60' ORDER BY `sort` ASC [ RunTime:0.000215s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '61' [ RunTime:0.000365s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '61' ORDER BY `sort` ASC [ RunTime:0.000225s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000186s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '62' [ RunTime:0.000359s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '62' ORDER BY `sort` ASC [ RunTime:0.000223s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000153s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000155s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '63' [ RunTime:0.000322s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '63' ORDER BY `sort` ASC [ RunTime:0.000234s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '64' [ RunTime:0.000346s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '64' ORDER BY `sort` ASC [ RunTime:0.000194s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000161s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '65' [ RunTime:0.000319s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '65' ORDER BY `sort` ASC [ RunTime:0.000200s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000133s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '70' [ RunTime:0.000333s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '70' ORDER BY `sort` ASC [ RunTime:0.000218s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000151s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000133s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '19' [ RunTime:0.000328s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '19' ORDER BY `sort` ASC [ RunTime:0.000201s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000155s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000127s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '24' [ RunTime:0.000432s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '24' ORDER BY `sort` ASC [ RunTime:0.000227s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '38' [ RunTime:0.000308s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '38' ORDER BY `sort` ASC [ RunTime:0.000201s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000162s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '25' [ RunTime:0.000416s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '25' ORDER BY `sort` ASC [ RunTime:0.000256s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000152s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '37' [ RunTime:0.000536s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '37' ORDER BY `sort` ASC [ RunTime:0.000212s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000143s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000129s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '90' [ RunTime:0.000338s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '90' ORDER BY `sort` ASC [ RunTime:0.000241s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '91' [ RunTime:0.000324s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '91' ORDER BY `sort` ASC [ RunTime:0.000189s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000133s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '92' [ RunTime:0.000309s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '92' ORDER BY `sort` ASC [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000169s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '93' [ RunTime:0.000344s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '93' ORDER BY `sort` ASC [ RunTime:0.000286s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000183s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '94' [ RunTime:0.000541s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '94' ORDER BY `sort` ASC [ RunTime:0.000379s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000211s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000196s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '98' [ RunTime:0.000421s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '98' ORDER BY `sort` ASC [ RunTime:0.000372s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '99' [ RunTime:0.000520s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '99' ORDER BY `sort` ASC [ RunTime:0.000283s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000221s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000178s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '43' [ RunTime:0.000468s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '43' ORDER BY `sort` ASC [ RunTime:0.000255s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '44' [ RunTime:0.000323s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '44' ORDER BY `sort` ASC [ RunTime:0.000189s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000130s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '45' [ RunTime:0.000327s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '45' ORDER BY `sort` ASC [ RunTime:0.000205s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000140s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000129s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '46' [ RunTime:0.000286s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '46' ORDER BY `sort` ASC [ RunTime:0.000236s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '47' [ RunTime:0.000334s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '47' ORDER BY `sort` ASC [ RunTime:0.000221s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000212s ] [2022-01-18T23:45:54+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = '48' [ RunTime:0.000386s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = '48' ORDER BY `sort` ASC [ RunTime:0.000289s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000179s ] [2022-01-18T23:45:54+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000149s ] [2022-01-18T23:45:55+08:00][sql] CONNECT:[ UseTime:0.004213s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:55+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.007043s ] [2022-01-18T23:45:55+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE `role_id` = '8' [ RunTime:0.000567s ] [2022-01-18T23:45:55+08:00][sql] CONNECT:[ UseTime:0.003455s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:55+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.006226s ] [2022-01-18T23:45:55+08:00][sql] SELECT DISTINCT `project_no`,`project_name_easy`,`project_name` FROM `t_doc_project` WHERE `project_no` = '9089' [ RunTime:0.000446s ] [2022-01-18T23:45:55+08:00][sql] CONNECT:[ UseTime:0.003315s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:55+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_population` [ RunTime:0.006098s ] [2022-01-18T23:45:55+08:00][sql] SELECT * FROM `t_imm_population` LIMIT 0,20 [ RunTime:0.000321s ] [2022-01-18T23:45:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_population` [ RunTime:0.000576s ] [2022-01-18T23:45:55+08:00][sql] CONNECT:[ UseTime:0.014161s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:45:55+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.005996s ] [2022-01-18T23:45:55+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000463s ] [2022-01-18T23:46:42+08:00][sql] CONNECT:[ UseTime:0.003083s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:42+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_village` [ RunTime:0.006925s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `province_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000444s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `city_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000345s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000336s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `town_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000349s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `village_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000358s ] [2022-01-18T23:46:42+08:00][sql] SELECT DISTINCT `group_name` FROM `t_imm_village` WHERE `project_no` = 9089 AND `county_no` = 12920 [ RunTime:0.000312s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.004259s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.007600s ] [2022-01-18T23:46:45+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000463s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.004631s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryname_dict` [ RunTime:0.006822s ] [2022-01-18T23:46:45+08:00][sql] SELECT `name` FROM `t_imm_ancillaryname_dict` [ RunTime:0.000311s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.004745s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006914s ] [2022-01-18T23:46:45+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000459s ] [2022-01-18T23:46:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000340s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.004177s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.005179s ] [2022-01-18T23:46:45+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000201s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.003530s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryunit_dict` [ RunTime:0.006181s ] [2022-01-18T23:46:45+08:00][sql] SELECT `unit` FROM `t_imm_ancillaryunit_dict` [ RunTime:0.000192s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.003894s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillarynature_dict` [ RunTime:0.005003s ] [2022-01-18T23:46:45+08:00][sql] SELECT `nature` FROM `t_imm_ancillarynature_dict` [ RunTime:0.000269s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.003483s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.007014s ] [2022-01-18T23:46:45+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000290s ] [2022-01-18T23:46:45+08:00][sql] CONNECT:[ UseTime:0.003366s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:45+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.006772s ] [2022-01-18T23:46:45+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%%' [ RunTime:0.000453s ] [2022-01-18T23:46:46+08:00][sql] CONNECT:[ UseTime:0.003902s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:46+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.005896s ] [2022-01-18T23:46:46+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000233s ] [2022-01-18T23:46:46+08:00][sql] CONNECT:[ UseTime:0.003266s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:46+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006473s ] [2022-01-18T23:46:46+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000212s ] [2022-01-18T23:46:46+08:00][sql] CONNECT:[ UseTime:0.003434s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:46+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_decoration_dict` [ RunTime:0.005039s ] [2022-01-18T23:46:46+08:00][sql] SELECT DISTINCT `name` FROM `t_imm_decoration_dict` [ RunTime:0.000408s ] [2022-01-18T23:46:47+08:00][sql] CONNECT:[ UseTime:0.003772s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:47+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006206s ] [2022-01-18T23:46:47+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001699s ] [2022-01-18T23:46:54+08:00][sql] CONNECT:[ UseTime:0.013691s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006017s ] [2022-01-18T23:46:54+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.001654s ] [2022-01-18T23:46:59+08:00][sql] CONNECT:[ UseTime:0.013848s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:46:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006128s ] [2022-01-18T23:46:59+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-007' LIMIT 0,10 [ RunTime:0.001854s ] [2022-01-18T23:47:13+08:00][sql] CONNECT:[ UseTime:0.004586s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:47:13+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006063s ] [2022-01-18T23:47:13+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001658s ] [2022-01-18T23:47:17+08:00][sql] CONNECT:[ UseTime:0.003543s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:47:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006326s ] [2022-01-18T23:47:17+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.001759s ] [2022-01-18T23:47:25+08:00][sql] CONNECT:[ UseTime:0.003432s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:47:25+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.006012s ] [2022-01-18T23:47:25+08:00][sql] SELECT * FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 LIMIT 0,10 [ RunTime:0.003204s ] [2022-01-18T23:47:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 [ RunTime:0.001331s ] [2022-01-18T23:47:35+08:00][sql] CONNECT:[ UseTime:0.003126s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:47:35+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.007267s ] [2022-01-18T23:47:35+08:00][sql] SELECT * FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 LIMIT 0,10 [ RunTime:0.003153s ] [2022-01-18T23:47:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 [ RunTime:0.001335s ] [2022-01-18T23:49:13+08:00][sql] CONNECT:[ UseTime:0.013897s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:49:13+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.005856s ] [2022-01-18T23:49:13+08:00][sql] SELECT * FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 LIMIT 0,10 [ RunTime:0.004344s ] [2022-01-18T23:49:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 [ RunTime:0.001367s ] [2022-01-18T23:49:20+08:00][sql] CONNECT:[ UseTime:0.013520s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:49:20+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006025s ] [2022-01-18T23:49:20+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001719s ] [2022-01-18T23:49:48+08:00][sql] CONNECT:[ UseTime:0.003287s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:49:48+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006331s ] [2022-01-18T23:49:48+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001745s ] [2022-01-18T23:49:50+08:00][sql] CONNECT:[ UseTime:0.013670s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:49:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006365s ] [2022-01-18T23:49:50+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.001702s ] [2022-01-18T23:49:53+08:00][sql] CONNECT:[ UseTime:0.014217s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:49:53+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillary_facilities` [ RunTime:0.006150s ] [2022-01-18T23:49:53+08:00][sql] SELECT * FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 LIMIT 0,10 [ RunTime:0.008002s ] [2022-01-18T23:49:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_ancillary_facilities` WHERE `house_id` = 17 [ RunTime:0.001446s ] [2022-01-18T23:50:00+08:00][sql] CONNECT:[ UseTime:0.013152s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:50:00+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005415s ] [2022-01-18T23:50:00+08:00][sql] SELECT * FROM `t_imm_house` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000270s ] [2022-01-18T23:50:04+08:00][sql] CONNECT:[ UseTime:0.013843s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:50:04+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006328s ] [2022-01-18T23:50:04+08:00][sql] SELECT * FROM `t_imm_house` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000333s ] [2022-01-18T23:50:04+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.005429s ] [2022-01-18T23:50:04+08:00][error] [2]copy(D:\wamp\www\szym\public/uploads/template/Sample_02_House.doc): failed to open stream: No such file or directory[D:\wamp\www\szym\vendor\phpoffice\phpword\src\PhpWord\TemplateProcessor.php:112] [2022-01-18T23:50:11+08:00][sql] CONNECT:[ UseTime:0.013278s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:50:11+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_decoration` [ RunTime:0.006094s ] [2022-01-18T23:50:11+08:00][sql] SELECT * FROM `t_imm_decoration` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.000256s ] [2022-01-18T23:50:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_decoration` WHERE `householder_id` = 'M-3-003' [ RunTime:0.000216s ] [2022-01-18T23:51:36+08:00][sql] CONNECT:[ UseTime:0.013522s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:51:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006556s ] [2022-01-18T23:51:36+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-003' LIMIT 0,10 [ RunTime:0.001690s ] [2022-01-18T23:51:37+08:00][sql] CONNECT:[ UseTime:0.003256s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:51:37+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006126s ] [2022-01-18T23:51:37+08:00][sql] SELECT * FROM `t_imm_house` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000290s ] [2022-01-18T23:51:37+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.005328s ] [2022-01-18T23:51:37+08:00][error] [2]copy(D:\wamp\www\szym\public/uploads/template/Sample_02_House.doc): failed to open stream: No such file or directory[D:\wamp\www\szym\vendor\phpoffice\phpword\src\PhpWord\TemplateProcessor.php:112] [2022-01-18T23:51:43+08:00][sql] CONNECT:[ UseTime:0.013812s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:51:43+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.005826s ] [2022-01-18T23:51:43+08:00][sql] SELECT * FROM `t_imm_house` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000314s ] [2022-01-18T23:51:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.006540s ] [2022-01-18T23:51:43+08:00][error] [2]copy(D:\wamp\www\szym\public/uploads/template/Sample_02_House.doc): failed to open stream: No such file or directory[D:\wamp\www\szym\vendor\phpoffice\phpword\src\PhpWord\TemplateProcessor.php:112] [2022-01-18T23:52:54+08:00][sql] CONNECT:[ UseTime:0.004746s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.008664s ] [2022-01-18T23:52:54+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000654s ] [2022-01-18T23:52:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000435s ] [2022-01-18T23:52:54+08:00][sql] CONNECT:[ UseTime:0.004283s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_landperiod_dict` [ RunTime:0.011683s ] [2022-01-18T23:52:54+08:00][sql] SELECT `period` FROM `t_imm_landperiod_dict` [ RunTime:0.000303s ] [2022-01-18T23:52:54+08:00][sql] CONNECT:[ UseTime:0.006123s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_type_dict` [ RunTime:0.007672s ] [2022-01-18T23:52:54+08:00][sql] SELECT `type` FROM `t_imm_type_dict` [ RunTime:0.000272s ] [2022-01-18T23:52:54+08:00][sql] CONNECT:[ UseTime:0.005230s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006199s ] [2022-01-18T23:52:54+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000208s ] [2022-01-18T23:52:54+08:00][sql] CONNECT:[ UseTime:0.003257s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:54+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.006518s ] [2022-01-18T23:52:54+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000434s ] [2022-01-18T23:52:58+08:00][sql] CONNECT:[ UseTime:0.003139s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:52:58+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_land` [ RunTime:0.006060s ] [2022-01-18T23:52:58+08:00][sql] SELECT * FROM `t_imm_land` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.007430s ] [2022-01-18T23:53:01+08:00][sql] CONNECT:[ UseTime:0.003105s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_land` [ RunTime:0.006431s ] [2022-01-18T23:53:01+08:00][sql] SELECT * FROM `t_imm_land` WHERE `householder_id` = 'M-3-003' LIMIT 0,20 [ RunTime:0.007061s ] [2022-01-18T23:53:07+08:00][sql] CONNECT:[ UseTime:0.004346s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:07+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.008260s ] [2022-01-18T23:53:07+08:00][sql] SELECT DISTINCT `type` FROM `t_imm_tree_dict` [ RunTime:0.000704s ] [2022-01-18T23:53:07+08:00][sql] CONNECT:[ UseTime:0.004632s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:07+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006726s ] [2022-01-18T23:53:07+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000229s ] [2022-01-18T23:53:07+08:00][sql] CONNECT:[ UseTime:0.005311s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:07+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.007400s ] [2022-01-18T23:53:07+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000516s ] [2022-01-18T23:53:08+08:00][sql] CONNECT:[ UseTime:0.004170s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:08+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006329s ] [2022-01-18T23:53:08+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000410s ] [2022-01-18T23:53:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000341s ] [2022-01-18T23:53:09+08:00][sql] CONNECT:[ UseTime:0.003126s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:09+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006091s ] [2022-01-18T23:53:09+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.001274s ] [2022-01-18T23:53:12+08:00][sql] CONNECT:[ UseTime:0.003297s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:53:12+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006214s ] [2022-01-18T23:53:12+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-003' LIMIT 0,20 [ RunTime:0.001539s ] [2022-01-18T23:54:47+08:00][sql] CONNECT:[ UseTime:0.004222s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:54:47+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006044s ] [2022-01-18T23:54:47+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 20,20 [ RunTime:0.000471s ] [2022-01-18T23:54:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000401s ] [2022-01-18T23:54:49+08:00][sql] CONNECT:[ UseTime:0.003150s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:54:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005622s ] [2022-01-18T23:54:49+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 40,20 [ RunTime:0.000438s ] [2022-01-18T23:54:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000362s ] [2022-01-18T23:54:50+08:00][sql] CONNECT:[ UseTime:0.013951s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:54:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.006162s ] [2022-01-18T23:54:50+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 60,20 [ RunTime:0.000466s ] [2022-01-18T23:54:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000351s ] [2022-01-18T23:54:57+08:00][sql] CONNECT:[ UseTime:0.013029s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:54:57+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005957s ] [2022-01-18T23:54:57+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001469s ] [2022-01-18T23:56:26+08:00][sql] CONNECT:[ UseTime:0.003404s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:56:26+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005823s ] [2022-01-18T23:56:26+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001338s ] [2022-01-18T23:56:31+08:00][sql] CONNECT:[ UseTime:0.013875s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:56:31+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006246s ] [2022-01-18T23:56:31+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001421s ] [2022-01-18T23:58:24+08:00][sql] CONNECT:[ UseTime:0.003144s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006614s ] [2022-01-18T23:58:24+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001399s ] [2022-01-18T23:58:27+08:00][sql] CONNECT:[ UseTime:0.003812s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:27+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005440s ] [2022-01-18T23:58:27+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000294s ] [2022-01-18T23:58:30+08:00][sql] CONNECT:[ UseTime:0.003005s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:30+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006462s ] [2022-01-18T23:58:30+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001312s ] [2022-01-18T23:58:32+08:00][sql] CONNECT:[ UseTime:0.003943s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:32+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005457s ] [2022-01-18T23:58:32+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-080' LIMIT 0,20 [ RunTime:0.001331s ] [2022-01-18T23:58:36+08:00][sql] CONNECT:[ UseTime:0.013048s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:36+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005927s ] [2022-01-18T23:58:36+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000428s ] [2022-01-18T23:58:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000383s ] [2022-01-18T23:58:41+08:00][sql] CONNECT:[ UseTime:0.013531s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:41+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006314s ] [2022-01-18T23:58:41+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.001287s ] [2022-01-18T23:58:47+08:00][sql] CONNECT:[ UseTime:0.003398s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:47+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.006072s ] [2022-01-18T23:58:47+08:00][sql] SELECT DISTINCT `varieties` FROM `t_imm_tree_dict` WHERE `type` = '用材树' [ RunTime:0.000600s ] [2022-01-18T23:58:47+08:00][sql] CONNECT:[ UseTime:0.003991s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:58:47+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.006253s ] [2022-01-18T23:58:47+08:00][sql] SELECT DISTINCT `specifications` FROM `t_imm_tree_dict` WHERE `type` = '用材树' [ RunTime:0.000547s ] [2022-01-18T23:59:02+08:00][sql] CONNECT:[ UseTime:0.003427s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.005847s ] [2022-01-18T23:59:02+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `user_name` = '系统管理员' , `account` = 'admin' , `method` = 'add_tree' , `platform` = 'PC' , `action` = '添加零星树木' , `url` = '/szym/api/index.php/investigation1/add_tree' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1642521542 , `update_time` = 1642521542 , `delete_time` = 0 [ RunTime:0.000257s ] [2022-01-18T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005399s ] [2022-01-18T23:59:02+08:00][sql] INSERT INTO `t_imm_tree` SET `householder_id` = 'M-3-002' , `area` = '淹没区' , `type` = '用材树' , `varieties` = '白果树' , `specifications` = '幼树' , `number` = 1 , `create_date` = '2022-01-18 23:59:02' , `project_no` = '9089' [ RunTime:0.026869s ] [2022-01-18T23:59:03+08:00][sql] CONNECT:[ UseTime:0.014455s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:03+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005849s ] [2022-01-18T23:59:03+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.001297s ] [2022-01-18T23:59:11+08:00][sql] CONNECT:[ UseTime:0.004109s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:11+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.005917s ] [2022-01-18T23:59:11+08:00][sql] SELECT DISTINCT `varieties` FROM `t_imm_tree_dict` WHERE `type` = '果木树' [ RunTime:0.000683s ] [2022-01-18T23:59:11+08:00][sql] CONNECT:[ UseTime:0.013901s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:11+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.006539s ] [2022-01-18T23:59:11+08:00][sql] SELECT DISTINCT `specifications` FROM `t_imm_tree_dict` WHERE `type` = '果木树' [ RunTime:0.000635s ] [2022-01-18T23:59:17+08:00][sql] CONNECT:[ UseTime:0.003736s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:17+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.006109s ] [2022-01-18T23:59:17+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `user_name` = '系统管理员' , `account` = 'admin' , `method` = 'add_tree' , `platform` = 'PC' , `action` = '添加零星树木' , `url` = '/szym/api/index.php/investigation1/add_tree' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1642521557 , `update_time` = 1642521557 , `delete_time` = 0 [ RunTime:0.000289s ] [2022-01-18T23:59:17+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005763s ] [2022-01-18T23:59:17+08:00][sql] INSERT INTO `t_imm_tree` SET `number` = 1 , `householder_id` = 'M-3-002' , `area` = '淹没区' , `type` = '果木树' , `varieties` = '桑树' , `specifications` = '幼龄期' , `create_date` = '2022-01-18 23:59:17' , `project_no` = '9089' [ RunTime:0.026364s ] [2022-01-18T23:59:18+08:00][sql] CONNECT:[ UseTime:0.003693s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:18+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.006087s ] [2022-01-18T23:59:18+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.001318s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.004301s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.007730s ] [2022-01-18T23:59:23+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000579s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.004532s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.007575s ] [2022-01-18T23:59:23+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000611s ] [2022-01-18T23:59:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000670s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.004603s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillarynature_dict` [ RunTime:0.007496s ] [2022-01-18T23:59:23+08:00][sql] SELECT `nature` FROM `t_imm_ancillarynature_dict` [ RunTime:0.000268s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.003621s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryname_dict` [ RunTime:0.007737s ] [2022-01-18T23:59:23+08:00][sql] SELECT `name` FROM `t_imm_ancillaryname_dict` [ RunTime:0.000285s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.003610s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.007733s ] [2022-01-18T23:59:23+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000245s ] [2022-01-18T23:59:23+08:00][sql] CONNECT:[ UseTime:0.003923s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:23+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_ancillaryunit_dict` [ RunTime:0.007987s ] [2022-01-18T23:59:23+08:00][sql] SELECT `unit` FROM `t_imm_ancillaryunit_dict` [ RunTime:0.000213s ] [2022-01-18T23:59:24+08:00][sql] CONNECT:[ UseTime:0.003746s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.006693s ] [2022-01-18T23:59:24+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%%' [ RunTime:0.000611s ] [2022-01-18T23:59:24+08:00][sql] CONNECT:[ UseTime:0.003732s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006094s ] [2022-01-18T23:59:24+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000220s ] [2022-01-18T23:59:24+08:00][sql] CONNECT:[ UseTime:0.004259s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.005617s ] [2022-01-18T23:59:24+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000389s ] [2022-01-18T23:59:24+08:00][sql] CONNECT:[ UseTime:0.003353s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.006064s ] [2022-01-18T23:59:24+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000230s ] [2022-01-18T23:59:24+08:00][sql] CONNECT:[ UseTime:0.003010s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:24+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_decoration_dict` [ RunTime:0.005080s ] [2022-01-18T23:59:24+08:00][sql] SELECT DISTINCT `name` FROM `t_imm_decoration_dict` [ RunTime:0.000356s ] [2022-01-18T23:59:33+08:00][sql] CONNECT:[ UseTime:0.014178s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:33+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.007071s ] [2022-01-18T23:59:33+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.001759s ] [2022-01-18T23:59:43+08:00][sql] CONNECT:[ UseTime:0.004210s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:43+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_house` [ RunTime:0.006109s ] [2022-01-18T23:59:43+08:00][sql] SELECT * FROM `t_imm_house` WHERE `householder_id` = 'M-3-002' LIMIT 0,10 [ RunTime:0.003351s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.004354s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.008205s ] [2022-01-18T23:59:49+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000338s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.004306s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.009105s ] [2022-01-18T23:59:49+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000552s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.004779s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_purpose_dict` [ RunTime:0.007837s ] [2022-01-18T23:59:49+08:00][sql] SELECT `purpose` FROM `t_imm_purpose_dict` [ RunTime:0.000314s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.005545s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_landperiod_dict` [ RunTime:0.007715s ] [2022-01-18T23:59:49+08:00][sql] SELECT `period` FROM `t_imm_landperiod_dict` [ RunTime:0.000243s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.015639s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_type_dict` [ RunTime:0.005186s ] [2022-01-18T23:59:49+08:00][sql] SELECT `type` FROM `t_imm_type_dict` [ RunTime:0.000252s ] [2022-01-18T23:59:49+08:00][sql] CONNECT:[ UseTime:0.003743s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:49+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005914s ] [2022-01-18T23:59:49+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000355s ] [2022-01-18T23:59:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000300s ] [2022-01-18T23:59:50+08:00][sql] CONNECT:[ UseTime:0.003782s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.028118s ] [2022-01-18T23:59:50+08:00][sql] SELECT DISTINCT `type` FROM `t_imm_tree_dict` [ RunTime:0.000556s ] [2022-01-18T23:59:50+08:00][sql] CONNECT:[ UseTime:0.013714s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_area_dict` [ RunTime:0.019419s ] [2022-01-18T23:59:50+08:00][sql] SELECT `area` FROM `t_imm_area_dict` [ RunTime:0.000167s ] [2022-01-18T23:59:50+08:00][sql] CONNECT:[ UseTime:0.003903s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_add_dict` [ RunTime:0.029901s ] [2022-01-18T23:59:50+08:00][sql] SELECT DISTINCT `county_name` FROM `t_imm_add_dict` WHERE `county_name` LIKE '%牟平区%' [ RunTime:0.000372s ] [2022-01-18T23:59:50+08:00][sql] CONNECT:[ UseTime:0.004182s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:50+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_householder` [ RunTime:0.005526s ] [2022-01-18T23:59:50+08:00][sql] SELECT * FROM `t_imm_householder` WHERE `county_name` LIKE '%牟平区%' LIMIT 0,20 [ RunTime:0.000381s ] [2022-01-18T23:59:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_imm_householder` [ RunTime:0.000315s ] [2022-01-18T23:59:53+08:00][sql] CONNECT:[ UseTime:0.013896s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:53+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree` [ RunTime:0.005535s ] [2022-01-18T23:59:53+08:00][sql] SELECT * FROM `t_imm_tree` WHERE `householder_id` = 'M-3-002' LIMIT 0,20 [ RunTime:0.001316s ] [2022-01-18T23:59:56+08:00][sql] CONNECT:[ UseTime:0.013479s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.005254s ] [2022-01-18T23:59:56+08:00][sql] SELECT DISTINCT `varieties` FROM `t_imm_tree_dict` WHERE `type` = '用材树' [ RunTime:0.000563s ] [2022-01-18T23:59:56+08:00][sql] CONNECT:[ UseTime:0.004754s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:56+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.005961s ] [2022-01-18T23:59:56+08:00][sql] SELECT DISTINCT `specifications` FROM `t_imm_tree_dict` WHERE `type` = '用材树' [ RunTime:0.000627s ] [2022-01-18T23:59:58+08:00][sql] CONNECT:[ UseTime:0.015424s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:58+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.006685s ] [2022-01-18T23:59:58+08:00][sql] SELECT DISTINCT `varieties` FROM `t_imm_tree_dict` WHERE `type` = '果木树' [ RunTime:0.000536s ] [2022-01-18T23:59:59+08:00][sql] CONNECT:[ UseTime:0.004042s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2022-01-18T23:59:59+08:00][sql] SHOW FULL COLUMNS FROM `t_imm_tree_dict` [ RunTime:0.005458s ] [2022-01-18T23:59:59+08:00][sql] SELECT DISTINCT `specifications` FROM `t_imm_tree_dict` WHERE `type` = '果木树' [ RunTime:0.000682s ]