BDD + php éviter d'effectuer 300 requêtes

var players = [];

foreach (DB->getAllPlayers() as dbPlayer){
    players[dbPlayer->id] = new Player(dbPlayer);
}

foreach (API->getInfos as info){
    $newValue = info->newValue;

    if (array_key_exists (info->id, players){
       $newValue += players[id]->value;
    }

    fwrite (monDocument.csv,$newValue);
}

DB->InsertData(monDocument.csv);

TRUNCATE TABLE lolheroes;
DROP TABLE IF EXISTS lolheroes_wrk;
CREATE TABLE lolheroes_wrk AS SELECT * FROM lolheroes WHERE 1=0;
LOAD DATA LOCAL INFILE 'compteur.csv'
INTO TABLE lolheroes_wrk
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
LINES TERMINATED BY '\n' 
(championId, indicea, indicen, wina, winn, assistsa, assistsn, championsKilleda,
championsKilledn, numDeathsa, numDeathsn, minionsKilleda, minionsKilledn, goldEarneda,
goldEarnedn, timePlayeda, timePlayedn, tripleKillsa, tripleKillsn, quadraKillsa,
quadraKillsn, pentaKillsa, pentaKillsn);
INSERT INTO lolheroes SELECT * FROM lolheroes_wrk ON DUPLICATE KEY UPDATE
indicea=lolheroes.indicea+lolheroes_wrk.indicea, indicen=lolheroes.indicen+lolheroes_wrk.indicen,
wina=lolheroes.wina+lolheroes_wrk.wina, winn=lolheroes.winn+lolheroes_wrk.winn, assistsa=lolheroes.assistsa+lolheroes_wrk.assistsa, assistsn=lolheroes.assistsn+lolheroes_wrk.assistsn, 
championsKilleda=lolheroes.championsKilleda+lolheroes_wrk.championsKilleda, 
championsKilledn=lolheroes.championsKilledn+lolheroes_wrk.championsKilledn, numDeathsa=lolheroes.numDeathsa+lolheroes_wrk.numDeathsa, 
numDeathsn=lolheroes.numDeathsn+lolheroes_wrk.numDeathsn, minionsKilleda=lolheroes.minionsKilleda+lolheroes_wrk.minionsKilleda, 
minionsKilledn=lolheroes.minionsKilledn+lolheroes_wrk.minionsKilledn, goldEarneda=lolheroes.goldEarneda+lolheroes_wrk.goldEarneda, 
goldEarnedn=lolheroes.goldEarnedn+lolheroes_wrk.goldEarnedn, timePlayeda=lolheroes.timePlayeda+lolheroes_wrk.timePlayeda, 
timePlayedn=lolheroes.timePlayedn+lolheroes_wrk.timePlayedn, tripleKillsa=lolheroes.tripleKillsa+lolheroes_wrk.tripleKillsa, 
tripleKillsn=lolheroes.tripleKillsn+lolheroes_wrk.tripleKillsn, quadraKillsa=lolheroes.quadraKillsa+lolheroes_wrk.quadraKillsa, 
quadraKillsn=lolheroes.quadraKillsn+lolheroes_wrk.quadraKillsn, pentaKillsa=lolheroes.pentaKillsa+lolheroes_wrk.pentaKillsa, pentaKillsn=lolheroes.pentaKillsn+lolheroes_wrk.pentaKillsn

$query1 = 'LOAD DATA LOCAL INFILE \'/chemin/de/traverse/compteur.csv'
INTO TABLE lolheroes_wrk
FIELDS TERMINATED BY \';\'
ENCLOSED BY \'"\'
LINES TERMINATED BY \'\n\' 
(championId, indicea, indicen, wina, winn)';

LOAD DATA LOCAL INFILE '/chemin/de/traverse/compteur.csv\' INTO TABLE lolheroes_wrk FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n' (championId, indicea, indicen, wina, winn)

LOAD DATA LOCAL INFILE '/blabla/compteur.csv' INTO TABLE `lolheroes_wrk` FIELDS TERMINATED BY ';' LINES TERMINATED BY '%n' (championId, indicea)

$query1 = 'LOAD DATA LOCAL INFILE \'/blabla/compteur.csv\'
INTO TABLE `lolheroes_wrk`
FIELDS TERMINATED BY \';\'
LINES TERMINATED BY \'%n\' 
(championId, indicea)';