The second little time-consuming
The first so far not out the results
Instead, the wider check faster

One day data has hundreds of thousands to

And don't understand why different type

CodePudding user response:

I can only post a grow almost
SELECT
Userid,
` change `,
Inc_dec,
Cur_val,
` comment `,
Ctime
The FROM
Operate_currency_flows
WHERE
Type='m_stone'
AND ctime BETWEEN '2019-10-23 01:00:00'
AND '2019-10-23 s 23:00:00'
LIMIT 0,
15

CodePudding user response:

More strange things
2019-10-23 00:00:00 'AND' 2019-10-23 s 23:00:00 'with 2019-10-23 00:00:00' AND 'the 2019-10-23 2:00:00 speed almost
But
2019-10-23 00:00:00 'AND' 2019-10-23 s 03:00:00 'will slowly die
Now it seems this is the type is different

CodePudding user response:

I'm really head ache