php - Laravel 数据表 skipTotalRecords() 不起作用。仍在获取计数行

Question

我正在使用 Laravel 和 Laravel DataTable ^8.0 版本。在 DataTable eloquent builder 中添加 Dataable skipTotalRecords() 不起作用。计数查询仍在结果中。这里附上我的截图

从发条调试栏

SELECT count(*) as aggregate FROM (SELECT id, row_no, customer_id, income, posting_date, (SELECT posting_dateFROM final_invoiceWHERE job_id= job. idand final_invoice. deleted_atIS NULL and final_invoice. company_id= '1' ORDER BY idDESC LIMIT 1) as invoice_date, (SELECT SUM(local_amount) as income FROM financeWHERE account= '7035500' and job_no= job. row_noand finance. deleted_atIS NULL and finance. company_id= '1' LIMIT 1) as posted_incomeFROM jobWHERE income> '0' and posting_datebetween '2021-03-01' and '2021-03-29' and job. deleted_atIS NULL and job. company_id= '1') count_row_table

SELECT id, row_no, customer_id, income, posting_date, (SELECT posting_dateFROM final_invoiceWHERE job_id= job. idand final_invoice. deleted_atIS NULL and final_invoice. company_id= '1' ORDER BY idDESC LIMIT 1) as invoice_date, (SELECT SUM(local_amount) as income FROM financeWHERE account= '7035500' and job_no= job. row_noand finance. deleted_atIS NULL and finance. company_id= '1' LIMIT 1) as posted_incomeFROM jobWHERE income> '0' 和posting_date'2021-03-01' 和 '2021-03-29' 和job. deleted_at是 NULL 和job. company_id= '1' ORDER BY idDESC LIMIT 25 偏移量 0

代码

->skipTotalRecords()
->toJson();

作曲家 JSON

"itsgoingd/clockwork": "^4.0",
"laravel/cashier": "^12.1",
"laravel/framework": "^8.0",
"yajra/laravel-datatables-oracle": "^9.0",

请帮我弄清楚为什么计数查询仍在运行。提前致谢。

标签： phplaraveldatatablesyajra-datatable