我有两张桌子:id community_id from to registered message seen acceptedtags registered updated$query = sprintf("SELECT x_commmunities.* FROM x_commmunities, x_community_invitesWHERE x_community_invites.to = '%s'
下面的查询每次运行需花费200-300 my,这与我对每个country_id循环的时间相加,因此从我的JavaScript代码中可能调用了50次: c.community_id, join community_location cl on cl.community_id = c.community_id
join location l onon community c (cost=0.14..0.56 rows=1