如何优化PHP后端功能开发中的数据库查询？

// 创建索引
CREATE INDEX idx_name ON table_name (column_name);

// 查询时使用索引
SELECT * FROM table_name WHERE column_name = value;

// 查询前10条记录
SELECT * FROM table_name LIMIT 10;

// 查询名字以'A'开头的记录
SELECT * FROM table_name WHERE name LIKE 'A%';

// 连接数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// 复用连接进行多次查询
$query1 = mysqli_query($connection, 'SELECT * FROM table_name');
$query2 = mysqli_query($connection, 'SELECT * FROM table_name');

// 批量查询
SELECT * FROM table_name WHERE id IN (1, 2, 3, 4, 5);

// 批量插入
INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4), (value5, value6);

// 避免使用通配符查询
SELECT * FROM table_name WHERE name LIKE '%abc%';

// 查询结果缓存一小时
$redis = new Redis();
$redis->connect('localhost');
$cacheKey = 'query_result_key';

if ($redis->exists($cacheKey)) {
    // 从缓存中获取结果
    $result = $redis->get($cacheKey);
} else {
    // 从数据库查询结果
    $result = mysqli_query($connection, 'SELECT * FROM table_name');

    // 将结果存入缓存
    $redis->setex($cacheKey, 3600, $result);
}