perf(api): Lookup subscriber preferences with a single database query #9644

Job	Run time
Dependency review	7s
Spell check	27s
Find LaunchDarkly feature flags in diff	41s
Get Affected Packages	1m 35s
Unit test @novu public NPM packages (except providers)	2m 26s
Unit test @novu internal packages	0s
E2E test Web app	0s
Unit test @novu/providers	0s
Unit test backend services (@novu/worker)	2m 32s
Validate OpenAPI	2m 39s
Unit test backend services (@novu/api)	3m 45s
E2E test Dashboard app	0s
Unit test backend services (@novu/inbound-mail)	2m 16s
Unit test backend services (@novu/ws)	2m 14s
E2E test Widget / e2e_widget	11m 53s
E2E test API (novu/api-ee) / Check if the secret exists or not.	1s
E2E test API (novu/api) / Check if the secret exists or not.	1s
E2E test API (novu/api) / Test E2E	12m 5s
E2E test API (novu/api-ee) / Test E2E	12m 16s
	54m 58s

Provide feedback