mysql 乐观锁（有效解决中小型项目，大型项目还是用 redis吧)

public function get_only_sql_id()
{

    $id_only = Db::table('article_category')->where('hit_num=1')->limit(1)->value('id');
    if(!$id_only){
        return $id_only;
    }
    $bb = Db::table('article_category')->where('id', $id_only)->setField('hit_num', 10);
    if ($bb > 0) {
        return $id_only;
    }else{
        return $this->get_only_sql_id();
    }
}


public function test()
{
   
    halt($this->get_only_sql_id());

}

//商品下单
UPDATE goods SET num=num-1 WHERE goodsid=2 AND num>0 ;

if(受影响行数<=0){
抛异常，商品秒完了，回滚…
}