用戶好友的助力點(diǎn)擊事件里 后臺(tái)需要查詢最近1分鐘內(nèi)該助力成功的條數(shù),如果大于1,說明頻率過快,有違規(guī)操作嫌疑,我對這個(gè)框架實(shí)在是不熟,比如php取得了當(dāng)前的時(shí)分秒以后,下面的代碼:
$make = app()->make(ProductAssistUserRepository::class);
$make->getSearch(['product_assist_id' => 2228)->count();
要怎么改造,到達(dá)這樣的效果:
SELECT DATE_FORMAT(create_time, '%Y-%m-%d %H:%i') AS minute, COUNT(*) AS count FROM eb_store_product_assist_user
where product_assist_set_id=2228 GROUP BY minute HAVING count >0;