Как увеличить производительность при запросе к БД?

$query = "SELECT id, title FROM videos WHERE id > 0";
$result = mysqli_query($link, $query) or die(mysqli_error($link));

$query = "SELECT thumbnail, id FROM videos WHERE id > 0";
$result = mysqli_query($link, $query) or die(mysqli_error($link));
 
for ($data = []; $row = mysqli_fetch_assoc($result); $data[] = $row);
$count = count($data);
 
 for ($i = 0; $i < $count; $i++ ) { 
    
    //проверяем наличие обложки
    $headers = get_headers($data[$i]['thumbnail']); 
    if(preg_match("/404/", $headers[0])) {
        $query = "DELETE FROM videos WHERE id= " .$data[$i]['id'];
        $result = mysqli_query($link, $query) or die(mysqli_error($link));
        if($result) echo 'Success deleted!<br>';             
    }   
    
}

$deleteIds = [];
 
while ($row = mysqli_fetch_assoc($result));
    //проверяем наличие обложки
    $headers = get_headers($row['thumbnail']); 
    if(preg_match("/404/", $headers[0])) {
        $deleteIds = $row['id'];
    }   
}
 
if (!empty($deleteIds)) {
    $query = "DELETE FROM videos WHERE  id IN (" . implode(',', $deleteIds) . ")";
    $result = mysqli_query($link, $query) or die(mysqli_error($link));
    if($result) echo 'Success deleted!<br>'; 
}

while ($row = mysqli_fetch_assoc($result)) ..................