mysqli를 사용하여 MySQL 데이터베이스에서 단일 레코드를 효율적으로 검색하는 방법은 무엇입니까?

$row = $result->fetch_assoc();

// PHP >= 8.1
$value = $result->fetch_column();

// Legacy PHP versions
$value = $result->fetch_row()[0] ?? false;

// PHP >= 8.2
$row = $conn->execute_query($query, [$id])->fetch_assoc();

// Legacy PHP versions
$stmt = $conn->prepare($query);
$stmt->bind_param("s", $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

// Array
$user = $conn->query("SELECT * FROM users LIMIT 1")->fetch_assoc();

// Value
$count = $conn->query("SELECT count(*) FROM users")->fetch_column();

// Value < 8.1
$count = $conn->query("SELECT count(*) FROM users")->fetch_row()[0];