The problem comes from bugs in actual development. After investigation, it is simplified in the following table.

The following symptoms occur during the query:

Table structure field type

source int

Mysql Automatic transformation

Mysql implicitly converts the string parameter to 0, and then queries the database source=0 data, resulting in the query data does not meet expectations, future development students need to pay special attention to.