{"msg":"运行时异常:\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by field(\n layout_id,\n \n )' at line 21\n### The error may exist in URL [jar:file:/home/tomcat/apache-tomcat-9.0.41-yw16888.com/webapps/guanwang/WEB-INF/lib/lgxf-system-4.0.0.jar!/mapper/house/THousingLayoutMapper.xml]\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: SELECT t_housing_layout.layout_id as layoutId, t_housing_resources.housing_address as housingAddress, t_room_type.room_sum as roomSum, t_housing_layout.room_type_id as roomTypeId, t_housing_layout.housing_layout_total_price as housingLayoutTotalPrice, t_housing_layout.housing_layout_floorage as housingLayoutFloorage, t_housing_layout.housing_layout_orientation as housingLayoutOrientation, t_housing_layout.housing_id as housingId, t_housing_layout.cover_picture as houseSurfacePlot, t_housing_layout.whether_sale as whetherSale, t_housing_layout.layout_name as layoutName, t_room_type.`room_type` as roomType FROM t_housing_layout, t_room_type, t_housing_resources WHERE t_housing_layout.`room_type_id` = t_room_type.`room_type_id` and t_housing_layout.housing_id = t_housing_resources.housing_id and layout_id IN order by field( layout_id, )\n### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by field(\n layout_id,\n \n )' at line 21\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by field(\n layout_id,\n \n )' at line 21","code":500}