About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()

[无 无]

In the past two days, I have been testing the performance of Mysql using the AES_DECRYPT() and AES_ENCRYPT() functions. It is very slow when using Mysql for batch insertion. It takes 7 seconds for 100 entries. The log configuration has been modified, and the speed has been improved. When using encrypted fields for conditional retrieval, the query speed is very fast, and the speed is comparable to that without encryption.

Here is my question:

- Why is it so slow when inserting in batches?
- Why is decryption by calling the AES_DECRYPT() function? When a single index of encrypted data is so fast, how is the bottom layer implemented? Is there an index?
- How are the two functions AES_DECRYPT() and AES_ENCRYPT() implemented, and are there any configurable items to configure the encryption index?

Hope to get an answer, thanks a lot