使用两个表更新查询效率

I wrote the following update

我写了以下更新

update menus_pages
set parent_page_id = (select pages.page_id from tb_pages pages where pages.name = 'ADM')
where page_id = (select pages.page_id from tb_pages pages where pages.name = 'CAL')
update