chore: Improve LB Session tracking to include sec

Lucas Charlesrequested to merge
fix-lb-session-tracking-to-include-sec into master

What does this MR do and why?

chore: Improve LB Session tracking to include sec

Follow-up to gitlab-com/gl-infra/observability/team#3834 (closed) which missed SecApplicationRecord connection handling

Also fixes a few references to inside_transaction handling which was limited main and sec base classes

References

https://gitlab.slack.com/archives/C070XM3U0MV/p1753690092931129

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports