static/upload/log/20210918_142715.txt

-------------创建查询语句----------------
程序运行时间： 0ms
----每条sql查询时间----:SELECT * FROM daily_record_foodbasicinfolocates where 1=1
程序运行时间： 44ms
----每条sql查询时间----:SELECT * FROM house_keeper where grainId = '5'
程序运行时间： 5ms
----每条sql查询时间----:SELECT * FROM house_keeper_house where keeperId in (select kp.id from house_keeper kp where kp.grainId = '5')
程序运行时间： 3ms
----每条sql查询时间----:SELECT * FROM daily_record_foodbasicinfo where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 14ms
----每条sql查询时间----:SELECT * FROM daily_record_foodcheckinfo where house_id in (select hi.id from house_info hi where hi.grain_id= '5') AND type = 1  AND content is null
程序运行时间： 563ms
----每条sql查询时间----:SELECT * FROM daily_record_payment where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 569ms
----每条sql查询时间----:SELECT * FROM sys_user where grainId = '5' AND status=0
程序运行时间： 5ms
----每条sql查询时间----:SELECT * FROM sys_dic_data 
程序运行时间： 2ms
----每条sql查询时间----:SELECT * FROM sys_role 
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM daily_record_supercheck where grainId = '5' and c_time > '2021-8-18'
程序运行时间： 1479ms
----每条sql查询时间----:SELECT * FROM daily_record_transfer where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 59ms
----每条sql查询时间----:SELECT * FROM sys_user_role 
程序运行时间： 12ms
----每条sql查询时间----:SELECT * FROM house_keeper_education where keeper_id in (select kp.id from house_keeper kp where kp.grainId = '5')
程序运行时间： 67ms
----每条sql查询时间----:SELECT * FROM dm_device_model where grain_id in(select id from sys_grain where parentid='8')
程序运行时间： 151ms
----每条sql查询时间----:SELECT * FROM dm_device where model_uuid in (select uuid from dm_device_model where grain_id in (select id from sys_grain where parentId ='8'))
程序运行时间： 67ms
----每条sql查询时间----:SELECT * FROM record_device_get where grain_id in (select id from sys_grain where parentId ='8')
程序运行时间： 192ms
----每条sql查询时间----:SELECT * FROM record_device_back WHERE get_uuid IN (SELECT uuid FROM record_device_get WHERE grain_id IN (SELECT id FROM sys_grain WHERE parentId ='8'))
程序运行时间： 893ms
----每条sql查询时间----:SELECT * FROM sys_grain where  parentId = '8' or parentId in ('83')
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM house_info where  grain_id = '5'
程序运行时间： 11ms
----每条sql查询时间----:SELECT * FROM device_check where grain_id = '5'
程序运行时间： 103ms
----每条sql查询时间----:SELECT * FROM device_check_item where grain_id = '5'
程序运行时间： 278ms
----每条sql查询时间----:SELECT * FROM daily_record_foodbasicinfochecks where houseId in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 145ms
----每条sql查询时间----:SELECT * FROM sys_module where 1=1
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM sys_role_module where 1=1
程序运行时间： 2ms
----每条sql查询时间----:SELECT * FROM daily_record_task where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 128ms
----每条sql查询时间----:SELECT * FROM daily_record_inoutput where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 172ms
----每条sql查询时间----:SELECT * FROM daily_record_qualitycheck where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 154ms
----每条sql查询时间----:SELECT * FROM daily_record_basicdevice where house_id in (select hi.id from house_info hi where hi.grain_id in (select id from sys_grain where parentId='8'or parentId in ('83')))
程序运行时间： 571ms
----每条sql查询时间----:SELECT * FROM windrainsnow_check where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 369ms
----每条sql查询时间----:SELECT * FROM device_get_log WHERE get_uuid IN (SELECT uuid FROM record_device_get WHERE grain_id IN (SELECT id FROM sys_grain WHERE parentId ='8'))
程序运行时间： 173ms
----每条sql查询时间----:SELECT * FROM device_unit 
程序运行时间： 39ms
----每条sql查询时间----:SELECT * FROM daily_record_lsjg_new where house_id in (select hi.id from house_info hi where hi.grain_id= '5')
程序运行时间： 35ms
----每条sql查询时间----:SELECT * FROM outstore_weekreport where  grain_id in (select id from sys_grain where parentId='8'or parentId in ('83'))
程序运行时间： 164ms
----每条sql查询时间----:SELECT * FROM outstore_check where  grain_id in (select id from sys_grain where parentId='8'or parentId in ('83'))
程序运行时间： 259ms
----每条sql查询时间----:SELECT * FROM record_medicine_inoutput where  grain_id in (select id from sys_grain where parentId='8'or parentId in ('83'))
程序运行时间： 234ms
----每条sql查询时间----:SELECT * FROM dm_medicine_store where  grain_id in (select id from sys_grain where parentId='8'or parentId in ('83'))
程序运行时间： 21ms
----每条sql查询时间----:SELECT * FROM record_medicine_check_new where  grain_id in (select id from sys_grain where parentId='8'or parentId in ('83'))
程序运行时间： 257ms
----每条sql查询时间----:SELECT * FROM sys_city where id in(8)
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM daily_record_aeration_new where grain_id = '5'
程序运行时间： 103ms
----每条sql查询时间----:SELECT * FROM daily_record_ammonia_new where grain_id = '5'
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM daily_record_concentration_new where grain_id = '5'
程序运行时间： 278ms
----每条sql查询时间----:SELECT * FROM daily_record_conditioner_new where grain_id = '5'
程序运行时间： 22ms
----每条sql查询时间----:SELECT * FROM daily_record_cool_new where grain_id = '5'
程序运行时间： 1ms
----每条sql查询时间----:SELECT * FROM daily_record_events_new where grain_id = '5'
程序运行时间： 57ms
----每条sql查询时间----:SELECT * FROM daily_record_foodsafe_new where grain_id = '5'
程序运行时间： 44ms
----每条sql查询时间----:SELECT * FROM daily_record_fumigation_circle_new where grain_id = '5'
程序运行时间： 78ms
----每条sql查询时间----:SELECT * FROM daily_record_fumigation_new where grain_id = '5'
程序运行时间： 86ms
----每条sql查询时间----:SELECT * FROM daily_record_gland_new where grain_id = '5'
程序运行时间： 2ms
----每条sql查询时间----:SELECT * FROM daily_record_house_check_new where grain_id = '5'
程序运行时间： 52ms
----每条sql查询时间----:SELECT * FROM daily_record_inform_new where grain_id = '5'
程序运行时间： 172ms
----每条sql查询时间----:SELECT * FROM daily_record_inner_new where grain_id = '5'
程序运行时间： 50ms
----每条sql查询时间----:SELECT * FROM daily_record_maintain where house_id in ( SELECT id FROM house_info WHERE grain_id = '5') 
程序运行时间： 72ms
----每条sql查询时间----:SELECT * FROM device_application where grain_id = '5'
程序运行时间： 20ms
----每条sql查询时间----:SELECT * FROM daily_record_tonic where 1=1
程序运行时间： 37ms
----每条sql查询时间----:SELECT * FROM daily_record_lsxzfa_new where grain_id = '5'
程序运行时间： 37ms
----每条sql查询时间----:SELECT * FROM daily_record_xzsqfa_new where grain_id = '5'
程序运行时间： 43ms
-------------执行sql并拼装----------------
程序运行时间： 9490ms
-------------拷贝图片时间----------------
程序运行时间： 12ms
-------------创建文件----------------
程序运行时间： 104ms
-------------压缩文件----------------
程序运行时间： 3473ms
-------------总用时----------------
总用时： 13079ms