token: ********************
[
{
"query": "select * from `admin_users` where `id` = ? limit 1",
"bindings": [
1
],
"time": 100.96
},
{
"query": "select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id`, `admin_role_users`.`created_at` as `pivot_created_at`, `admin_role_users`.`updated_at` as `pivot_updated_at` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = ?",
"bindings": [
1
],
"time": 17.62
},
{
"query": "select count(*) as aggregate from `s_courses` where `s_courses`.`deleted_at` is null",
"bindings": [],
"time": 18.52
},
{
"query": "select * from `s_courses` where `s_courses`.`deleted_at` is null limit 20 offset 0",
"bindings": [],
"time": 15.86
},
{
"query": "select * from `s_category` where `s_category`.`id` in (45) and `s_category`.`deleted_at` is null",
"bindings": [],
"time": 16.17
},
{
"query": "select * from `s_category` where `s_category`.`id` in (63, 64) and `s_category`.`deleted_at` is null",
"bindings": [],
"time": 16.34
},
{
"query": "select `s_files`.*, `r_file`.`data_id` as `pivot_data_id`, `r_file`.`file_id` as `pivot_file_id`, `r_file`.`refer_table_type` as `pivot_refer_table_type`, `r_file`.`file_type` as `pivot_file_type` from `s_files` inner join `r_file` on `s_files`.`id` = `r_file`.`file_id` where `r_file`.`data_id` in (1, 2) and `r_file`.`refer_table_type` = ? and `s_files`.`deleted_at` is null",
"bindings": [
2
],
"time": 72.67
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 16.91
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.88
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.86
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.33
},
{
"query": "select * from `admin_menu` order by `order` asc",
"bindings": [],
"time": 19.89
},
{
"query": "select `admin_permissions`.*, `admin_permission_menu`.`menu_id` as `pivot_menu_id`, `admin_permission_menu`.`permission_id` as `pivot_permission_id`, `admin_permission_menu`.`created_at` as `pivot_created_at`, `admin_permission_menu`.`updated_at` as `pivot_updated_at` from `admin_permissions` inner join `admin_permission_menu` on `admin_permissions`.`id` = `admin_permission_menu`.`permission_id` where `admin_permission_menu`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)",
"bindings": [],
"time": 17.79
},
{
"query": "select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id`, `admin_role_menu`.`created_at` as `pivot_created_at`, `admin_role_menu`.`updated_at` as `pivot_updated_at` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)",
"bindings": [],
"time": 18.66
}
]
curl --location --request GET 'http://cmi-api.gleg.site/api/project-plan?page=1&per_page=20&task_status=' \
--header 'Content-Type: application/json' \
--header 'token;' \
--data-raw '[
{
"query": "select * from `admin_users` where `id` = ? limit 1",
"bindings": [
1
],
"time": 100.96
},
{
"query": "select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id`, `admin_role_users`.`created_at` as `pivot_created_at`, `admin_role_users`.`updated_at` as `pivot_updated_at` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = ?",
"bindings": [
1
],
"time": 17.62
},
{
"query": "select count(*) as aggregate from `s_courses` where `s_courses`.`deleted_at` is null",
"bindings": [],
"time": 18.52
},
{
"query": "select * from `s_courses` where `s_courses`.`deleted_at` is null limit 20 offset 0",
"bindings": [],
"time": 15.86
},
{
"query": "select * from `s_category` where `s_category`.`id` in (45) and `s_category`.`deleted_at` is null",
"bindings": [],
"time": 16.17
},
{
"query": "select * from `s_category` where `s_category`.`id` in (63, 64) and `s_category`.`deleted_at` is null",
"bindings": [],
"time": 16.34
},
{
"query": "select `s_files`.*, `r_file`.`data_id` as `pivot_data_id`, `r_file`.`file_id` as `pivot_file_id`, `r_file`.`refer_table_type` as `pivot_refer_table_type`, `r_file`.`file_type` as `pivot_file_type` from `s_files` inner join `r_file` on `s_files`.`id` = `r_file`.`file_id` where `r_file`.`data_id` in (1, 2) and `r_file`.`refer_table_type` = ? and `s_files`.`deleted_at` is null",
"bindings": [
2
],
"time": 72.67
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 16.91
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.88
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.86
},
{
"query": "select `name` from `dict_region` where `id` in (?, ?, ?) order by `id` asc",
"bindings": [
"13",
"13",
13
],
"time": 14.33
},
{
"query": "select * from `admin_menu` order by `order` asc",
"bindings": [],
"time": 19.89
},
{
"query": "select `admin_permissions`.*, `admin_permission_menu`.`menu_id` as `pivot_menu_id`, `admin_permission_menu`.`permission_id` as `pivot_permission_id`, `admin_permission_menu`.`created_at` as `pivot_created_at`, `admin_permission_menu`.`updated_at` as `pivot_updated_at` from `admin_permissions` inner join `admin_permission_menu` on `admin_permissions`.`id` = `admin_permission_menu`.`permission_id` where `admin_permission_menu`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)",
"bindings": [],
"time": 17.79
},
{
"query": "select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id`, `admin_role_menu`.`created_at` as `pivot_created_at`, `admin_role_menu`.`updated_at` as `pivot_updated_at` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)",
"bindings": [],
"time": 18.66
}
]'
{
"code": 200,
"msg": "success",
"data": {
"total": 1,
"list": [
{
"id": 2,
"plan_number": "PLAN-001",
"task_status": null,
"plan_name": "长江大桥修建计划",
"budget_min": "5000000.00",
"budget_max": "10000000.00",
"bid_category_id": 10,
"bid_type_id": 10,
"handler": "李强",
"handling_department": "招标部",
"handling_date": 1718434200
}
]
}
}