Why is it that when String type asks for SUM, the query speed with round, is very fast, and the query speed without round, is very slow?

Why is it that when executing a SUM query in the code, the query with round (), is fast, the query without round (), is slow, and the execution speed is fast in Navicat?
1, xml file, add round ()
clipboard.png

clipboard.png

sql:
clipboard.png

2xmlround

clipboard.png

clipboard.png

sql:

clipboard.png

Feb.21,2022

explain sql. What's the difference between taking a look at the execution plan?

Menu