$ids = "99406,99058,98742,94665,945112,926836,91304,867492,8468091";
$idsArr = explode(",", $ids);
$rs = $this->dbModel->setTable('test')->where('id', 'in', $idsArr)->select(); // 走bind效率低
$rs = $this->dbModel->setTable('test')->where('id', 'in', $ids)->select(); // 走bind效率低
$rs = $this->dbModel->setTable('test')->where("id in ($ids)")->select(); // 不走bind,效率高
$sql = "select * from test where id in ($ids)";
$rs2 = $this->dbModel->query($sql); // 不走bind,效率高
关于 thinkphp5 sql 绑定效率问题
最新推荐文章于 2022-12-30 15:54:33 发布