Recomendación para hacer un sistema de notificaciones

[salbatore]

Buenas Libras,

El query que estoy usando es:

Consulta 5 tablas y luego extraigo la info del usuario que ha clicado en el like o ha comentado. El id_profile_affected es el ID del usuario que solicita las notificaciones.

¿No es muy bruto?

Código MySQL:

SELECT 
 
(SELECT title FROM profiles WHERE id=id_profile_creator LIMIT 1) as title,(SELECT code FROM profiles WHERE id=id_profile_creator LIMIT 1) as code ,(SELECT path_avatar FROM profiles WHERE id=id_profile_creator LIMIT 1) as path_avatar 
 
FROM (
SELECT id,id_profile_creator,id_profile_affected FROM contents_comments 
UNION 
SELECT id,id_profile_creator,id_profile_affected FROM contents_likes 
UNION 
SELECT id,id_profile_creator,id_profile_affected FROM contents_mentions 
UNION 
SELECT id,id_profile_creator,id_profile_affected FROM contents_collections
UNION 
SELECT id,id_profile_creator,id_profile_affected FROM contents_comments_likes ) AS T1
 
WHERE id_profile_affected=79 limit 0, 20