Symfony Profiler

SELECT 
  n.id, 
  n.notificationSubject, 
  n.notificationBody, 
  n.notificationDate, 
  n.isFromSystem, 
  nt.typeName, 
  np.priorityName, 
  np.priorityLabel, 
  np.isFlashable, 
  u.realName as author, 
  IF(
    (
      SELECT 
        count(nv.id) 
      FROM 
        notifications_viewed as nv 
      WHERE 
        nv.notification_id = n.id 
        AND nv.user_id = : userId
    ) > 0, 
    1, 
    0
  ) as viewed -- Check which is unread
FROM 
  notifications as n 
  LEFT JOIN users as u ON u.id = n.author_id 
  LEFT JOIN notifications_type as nt ON nt.id = n.notification_type_id 
  LEFT JOIN notifications_priority as np ON np.id = n.notification_priority_id 
WHERE 
  (
    (
      n.notification_type_id = 3 
      AND FIND_IN_SET(: userId, n.targetId)
    ) -- Get User (type id: 3) notifications
    OR (
      n.notification_type_id = 2 
      AND FIND_IN_SET(: departmentId, n.targetId)
    ) -- Get Department (type id: 2) notifications
    OR (n.notification_type_id = 1)
  ) -- And all System (type id: 1) notifications
  AND (
    (n.startFrom <= : dateNow) 
    AND (n.isEnabled = 1)
  ) 
  AND n.id LIKE : notificationId 
ORDER BY 
  n.id DESC, 
  n.startFrom

SELECT n.id, n.notificationSubject, n.notificationBody, n.notificationDate, n.isFromSystem, nt.typeName, np.priorityName, np.priorityLabel, np.isFlashable, u.realName as author,
				IF((SELECT count(nv.id) FROM notifications_viewed as nv WHERE nv.notification_id = n.id AND nv.user_id = NULL) > 0, 1, 0) as viewed -- Check which is unread
				FROM notifications as n
				LEFT JOIN users as u ON u.id = n.author_id
				LEFT JOIN notifications_type as nt ON nt.id = n.notification_type_id
				LEFT JOIN notifications_priority as np ON np.id = n.notification_priority_id
				WHERE ((n.notification_type_id = 3 AND FIND_IN_SET(NULL, n.targetId)) -- Get User (type id: 3) notifications
				OR (n.notification_type_id = 2 AND FIND_IN_SET(NULL, n.targetId)) -- Get Department (type id: 2) notifications
				OR (n.notification_type_id = 1)) -- And all System (type id: 1) notifications
				AND ((n.startFrom <= '2026-02-13 04:45:22') AND (n.isEnabled = 1))
				AND n.id LIKE '%'
				ORDER BY n.id DESC, n.startFrom;

SELECT 
  count(qc.id) as unseenChats 
FROM 
  qa_chats as qc 
  JOIN qa_chat_participants as qcp ON qcp.chatId = qc.chatId 
WHERE 
  qcp.agentId = : userId 
  AND qcp.seenByAgent = '0' 
  AND qc.toUserFeedback = '1'

SELECT count(qc.id) as unseenChats FROM qa_chats as qc 
				JOIN qa_chat_participants as qcp ON qcp.chatId = qc.chatId 
				WHERE qcp.agentId = NULL AND qcp.seenByAgent = '0' AND qc.toUserFeedback = '1';

SELECT 
  count(qttf.id) as unseenTickets 
FROM 
  qa_tickets_to_feedbacks as qttf 
WHERE 
  qttf.user_id = : userId 
  AND qttf.isSeen = 0

SELECT count(qttf.id) as unseenTickets FROM qa_tickets_to_feedbacks as qttf 
				WHERE qttf.user_id = NULL AND qttf.isSeen = 0;

SELECT 
  count(qc.id) as unseenChats 
FROM 
  qa_chats as qc 
WHERE 
  qc.assign_to_id = : userId 
  AND qc.chatSeen = '0'

SELECT count(qc.id) as unseenChats FROM qa_chats as qc
				WHERE qc.assign_to_id = NULL AND qc.chatSeen = '0';

SELECT 
  count(qt.id) as unseenTickets 
FROM 
  qa_tickets as qt 
WHERE 
  qt.assign_to_id = : userId 
  AND qt.ticketSeen = '0'

SELECT count(qt.id) as unseenTickets FROM qa_tickets as qt
				WHERE qt.assign_to_id = NULL AND qt.ticketSeen = '0';