feat: enhance session management and event processing

[iPromKnight]

• Added asyncio support for asynchronous operations in scraping sessions.
• Improved session management with additional checks for item existence.
• Enhanced event manager to handle cancelled futures and improve logging.
• Updated state transition logic to handle NoneType for existing items.
• Introduced joinedload to always ensure we get a mediaitem and its parent id.