查看log貌似是在查jsh_serial_number表,但序列号应该是存在jsh_depot_item表里的
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberList - ==> Preparing: SELECT ser.id, ser.serial_number FROM jsh_serial_number ser LEFT JOIN jsh_material m ON m.tenant_id = 63 AND m.id = ser.material_id AND ifnull(m.delete_flag, '0') != '1' LEFT JOIN jsh_material_extend me ON me.tenant_id = 63 AND me.material_id = m.id AND ifnull(me.delete_flag, '0') != '1' WHERE ser.tenant_id = 63 AND 1 = 1 AND me.default_flag = 1 AND ser.depot_id = ? AND me.bar_code = ? AND ser.is_sell = '0' AND ifnull(ser.delete_flag, '0') != '1' ORDER BY ser.id DESC LIMIT ?, ?
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberList - ==> Parameters: 14(Long), 1018(String), 0(Integer), 10(Integer)
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberList - <== Total: 0
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberCount - ==> Preparing: SELECT count(1) FROM jsh_serial_number ser LEFT JOIN jsh_material m ON m.tenant_id = 63 AND m.id = ser.material_id AND ifnull(m.delete_flag, '0') != '1' LEFT JOIN jsh_material_extend me ON me.tenant_id = 63 AND me.material_id = m.id AND ifnull(me.delete_flag, '0') != '1' WHERE ser.tenant_id = 63 AND 1 = 1 AND me.default_flag = 1 AND ser.depot_id = ? AND me.bar_code = ? AND ser.is_sell = '0' AND ifnull(ser.delete_flag, '0') != '1'
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberCount - ==> Parameters: 14(Long), 1018(String)
2022/01/14-03:13:47 DEBUG [http-nio-9999-exec-3] com.jsh.erp.datasource.mappers.SerialNumberMapperEx.getEnableSerialNumberCount - <== Total: 1