This is the SQL debugging I see when I enable debugging on iredadmin. This is after the domain user list screen has been created when I click on a link to edit a user.
0.0 (1): SELECT * FROM sessions WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (2): SELECT * FROM sessions WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (3): UPDATE sessions SET atime = '2020-12-16T22:30:33.723669' WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.01 (1):
SELECT
mailbox.*,
sbcc.bcc_address AS sender_bcc_address,
sbcc.active AS sbcc_active,
rbcc.bcc_address AS recipient_bcc_address,
rbcc.active AS rbcc_active
FROM mailbox
LEFT JOIN sender_bcc_user AS sbcc ON (mailbox.username = sbcc.username)
LEFT JOIN recipient_bcc_user AS rbcc ON (mailbox.username = rbcc.username)
WHERE mailbox.username = 'redacted@domain.com'
LIMIT 1
0.0 (2): SELECT address FROM forwardings WHERE forwarding='redacted@domain.com' AND is_list=1 GROUP BY address
0.0 (4): SELECT * FROM sessions WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (5): UPDATE sessions SET atime = '2020-12-16T22:30:33.748189', data = 'gASVFQI0A0AAAAB9lCiMCnNlc3Npb25faWSUjCg2NjczOWU2MTYxNmFlODY1NTQ2ZWM3MWQxMzgy\nYTlhNDQ5ZDlhMzAylIwJd2VibWFzdGVylIwSanJob3BwZXJAcGFzdHkuY29tlIwIdXNlcm5hbWWU\njBJqcmhvcHBlckBwYXN0eS5jb22UjAZsb2dnZWSUiIwPaXNfZ2xvYmFsX2FkbWlulIiMD2lzX25v\ncm1hbF9hZG1pbpSJjBRhY2NvdW50X2lzX21haWxfdXNlcpSJjAxmYWlsZWRfdGltZXOUSwCMBGxh\nbmeUjAVlbl9VU5SMD3Nob3dfdXNlZF9xdW90YZSIjBlhbWF2aXNkX2VuYWJsZV9xdWFyYW50aW5l\nlIiMFmFtYXZpc2RfZW5hYmxlX2xvZ2dpbmeUiIwcYW1hdmlzZF9lbmFibGVfcG9saWN5X2xvb2t1\ncJSIjA9pcmVkYXBkX2VuYWJsZWSUiIwQZmFpbDJiYW5fZW5hYmxlZJSIjAJpcJSMCzIwOC42NS4y\nNy42lIwSYWRtaW5faXNfbWFpbF91c2VylIiMCHRpbWV6b25llIwDR01UlIwVbmV3X3ZlcnNpb25f\nYXZhaWxhYmxllE6MF25ld192ZXJzaW9uX2NoZWNrX2Vycm9ylE6MCmNzcmZfdG9rZW6UjCBTUXk5\nNnhTNzhCejM2NWtVUTRyNlVZODlmRDlXTWpSUJR1Lg==\n' WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
x.x.x.x:52264 - - [16/Dec/2020 22:30:33] "HTTP/1.1 GET /profile/user/general/redacted@domain.com" - 303 See Other
0.0 (1): SELECT * FROM sessions WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (2): SELECT * FROM sessions WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (3): UPDATE sessions SET atime = '2020-12-16T22:30:33.847091' WHERE session_id='66739e61616ae865546ec71d1382a9a449d9a302'
0.0 (1): SELECT COUNT(username) AS total FROM mailbox WHERE domain IN ('domain.com')
It ends by drawing the domain user list screen again. For safety in this post, I have altered the session id and session info.