我正在尝试以下方法

global $wpdb;
$sum = $wpdb->get_var("select sum(first), sum(second) from table where id > 1");

我无法从每个请求中获取值。我试过了

echo $test->sum(first);

我尝试将sql语句更改为包含为

 $sum = $wpdb->get_var("select sum(first) as firstRequest, sum(second) as secondRequestfrom table where id > 1");

echo $test[\'firstRequest\'];

我试过foreach 陈述

foreach($test as $tester){
  echo $tester[\'sum(first\')];
}

以及

foreach($test as $tester){
  echo $tester[\'firstRequest\'];
}

如何从单个get_var 陈述如果不可能，并且我需要5个不同行的总和，我是否必须创建5个单独的get_var 声明？这会降低查询速度吗？如果会的话，这是否很明显？

$sum = $wpdb->get_var("select sum(first), sum(second) from sums_test where id > 1");
var_dump($sum);

$sum = $wpdb->get_row("select sum(first) as first_sum, sum(second) as second_sum from sums_test where id > 1");
var_dump($sum);

foreach ($sum as $k=>$v) {
  echo $k.\' -> \'.$v.\'<br>\';
}