我有一个 MySQL 8 数据库，我向其授予了如下所有权限的用户：
GRANT ALL ON test_db.* TO 'test_user'@'%';
当我以该用户身份登录 mysql 并运行以下命令时，出现错误提示ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
FLUSH TABLES;
我认为 GRANT ALL 权限已经给了这个用户 RELOAD 或 FLUSH_TABLES 权限？
我该如何解决？
我有以下查询与多个多对多联结表的联接：
profile_language
profile_industry
profile_contract_type
profile_contract_hour
profile_qualification
执行大约需要 3-4 秒。当我尝试排除多对多联结表时，查询在 0.4 秒内执行。
select distinct `profiles`.*
, `locations`.`name` as `location_name`
, `candidate_view`.`last_viewed`
, CASE WHEN candidate_shortlist.profile_id IS NOT NULL THEN true ELSE false END AS shortlisted
, CASE WHEN unlocked_profiles.profile_id IS NOT NULL THEN true ELSE false END AS unlocked
from `profiles`
inner join `jobseekers` on `jobseekers`.`id` = `profiles`.`jobseeker_id`
inner join `locations` on `locations`.`id` = `profiles`.`location_id`
inner join `profile_language` on `profile_language`.`profile_id` = `profiles`.`id`
inner join `profile_industry` on `profile_industry`.`profile_id` = `profiles`.`id`
left join `profile_contract_type` on `profile_contract_type`.`profile_id` = `profiles`.`id`
left join `profile_contract_hour` on `profile_contract_hour`.`profile_id` = `profiles`.`id`
left join `profile_qualification` on `profile_qualification`.`profile_id` = `profiles`.`id`
left join (SELECT MAX(created_at) AS last_viewed
, profile_id
FROM candidate_views
WHERE recruiter_id = 43
GROUP BY profile_id ) AS candidate_view on `candidate_view`.`profile_id` = `profiles`.`id`
left JOIN (SELECT order_items.purchaseable_id as profile_id
FROM orders
INNER JOIN order_items on order_items.order_id = orders.id
INNER JOIN recruiters on recruiters.id = orders.recruiter_id
WHERE recruiters.company_id = 37
AND order_items.purchaseable_type = "App\\Profile" ) AS unlocked_profiles on `unlocked_profiles`.`profile_id` = `profiles`.`id`
left join `candidate_shortlist` on `candidate_shortlist`.`profile_id` = `profiles`.`id` and `candidate_shortlist`.`recruiter_id` = 43
where `profiles`.`searchable` = 1
and `profiles`.`deleted_at` is NULL
order by `profiles`.`id` desc limit 25 offset 0
这是解释信息：
+----+-------------+-----------------------+------------+--------+-------------------------------------------------------------------+-------------+---------+----------------------------------+------+----------+----------------------------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-----------------------+------------+--------+-------------------------------------------------------------------+-------------+---------+----------------------------------+------+----------+----------------------------------------------+
| 1 | PRIMARY | profiles | NULL | ALL | PRIMARY,profiles_jobseeker_id_unique,profiles_location_id_foreign | NULL | NULL | NULL | 2826 | 1.00 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | jobseekers | NULL | eq_ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.jobseeker_id | 1 | 100.00 | Using index |
| 1 | PRIMARY | locations | NULL | eq_ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.location_id | 1 | 100.00 | NULL |
| 1 | PRIMARY | profile_contract_type | NULL | ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.id | 1 | 100.00 | Using index |
| 1 | PRIMARY | profile_contract_hour | NULL | ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.id | 1 | 100.00 | Using index |
| 1 | PRIMARY | profile_qualification | NULL | ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.id | 1 | 100.00 | Using index |
| 1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | testjobsdb.profiles.id | 2 | 100.00 | NULL |
| 1 | PRIMARY | profile_language | NULL | ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.id | 2 | 100.00 | Using index |
| 1 | PRIMARY | order_items | NULL | ALL | order_items_order_id_foreign | NULL | NULL | NULL | 9 | 100.00 | Using where |
| 1 | PRIMARY | orders | NULL | eq_ref | PRIMARY,orders_recruiter_id_foreign | PRIMARY | 4 | testjobsdb.order_items.order_id | 1 | 100.00 | NULL |
| 1 | PRIMARY | recruiters | NULL | eq_ref | PRIMARY,recruiters_company_id_foreign | PRIMARY | 4 | testjobsdb.orders.recruiter_id | 1 | 100.00 | Using where |
| 1 | PRIMARY | candidate_shortlist | NULL | eq_ref | PRIMARY,candidate_shortlist_profile_id_foreign | PRIMARY | 8 | const,testjobsdb.profiles.id | 1 | 100.00 | Using index |
| 1 | PRIMARY | profile_industry | NULL | ref | PRIMARY | PRIMARY | 4 | testjobsdb.profiles.id | 4 | 100.00 | Using index; Distinct |
| 2 | DERIVED | candidate_views | NULL | ref | candidate_views_profile_id_foreign,Index 4 | Index 4 | 4 | const | 21 | 100.00 | Using where; Using index |
+----+-------------+-----------------------+------------+--------+-------------------------------------------------------------------+-------------+---------+----------------------------------+------+----------+----------------------------------------------+
请注意，联结表是在 php 中构建动态搜索查询所必需的，并且在上面的示例中没有显示，但是如果输入了搜索参数，它们将被添加到 where 子句中，例如：
and `profile_contract_type`.`contract_type_id` in (1,2,3,4)
此外，当我更改查询以进行计数时，它甚至需要更长的时间，大约 4-5 秒，例如
select count(distinct `profiles`.`id`) as aggregate from `profiles`...
如何优化此查询。任何帮助表示赞赏。