$a = array();
for($i=1;$i<=100000;$i++){
$a[] = "(".$i.",".rand(1000,9999).")";
}
$a = array_chunk($a, 100, TRUE);
$query = "";
foreach($a as $k => $v){
$query .= "INSERT INTO `test` VALUE ".implode(", ", $v).";\n";
}
$db->query($query);
INSERT INTO `tab1` (`pid`, `price`) VALUE (1,1000), (2,2000), ......, (100000, 3000)
//for test
$test = file_get_contents('1.txt');
$stmt = $db->query($test); //и ничего, пусто