immich [BUG] Viewing images from main page results in multiple duplicate database queries

Describe the bug When loading an image from the main viewer page some queries are being executed multiple times, but viewing same image from album page does not have (as many) duplicate queries.

To Reproduce

Turn on query logging in postgres (see below)
Add an image to immich
Add the image to an album
From the main page select an image. 11 database queries are executed
- AssetEntity query executed 6x (3x as normal query, 3x again but looking for the distinct version of the same query)
- UserEntity query executed 4x
- AlbumEntity query executed 1x
From the album main page select the same image. 5 database queries are executed
- AssetEntity query executed 2x (1x as normal query, 1x again but looking for the distinct version of the same query)
- UserEntity query executed 2x
- AlbumEntity query executed 1x

Expected behavior Expect selecting image from main page to follow same behavior as selecting from album page. Not sure why these should be different.

System Running latest main branch fb3b36a and viewing from web. Only changes are mounting modified postgresql.confand the db logs directory in docker-compose.dev.yml.

Additional context The network calls in chrome dev tools shows that the same url is being called 2x when selecting image from main view (api/asset/assetById/<assetId>)

Turning on logging

I mounted a config file to /var/lib/postgresql/data/postgresql.conf with these settings:

log_destination = 'csvlog'
logging_collector = on
log_min_messages = info
log_min_error_statement = info
debug_pretty_print = on
log_statement = 'all'

I also mounted /var/lib/postgresql/data/logs to make them visible outside of the container

Relevant portion of resulting logs When clicking on image from main page:

2022-11-27 03:35:54.352 UTC,"postgres","immich",43,"172.31.0.5:33072",6382db1a.2b,1,"SELECT",2022-11-27 03:35:54 UTC,3/24,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.357 UTC,"postgres","immich",43,"172.31.0.5:33072",6382db1a.2b,2,"SELECT",2022-11-27 03:35:54 UTC,3/25,0,LOG,00000,"execute <unnamed>: SELECT DISTINCT ""distinctAlias"".""AssetEntity_id"" AS ""ids_AssetEntity_id"" FROM (SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE (""AssetEntity"".""id"" = $1)) ""distinctAlias"" ORDER BY ""AssetEntity_id"" ASC LIMIT 1","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.359 UTC,"postgres","immich",43,"172.31.0.5:33072",6382db1a.2b,3,"SELECT",2022-11-27 03:35:54 UTC,3/26,0,LOG,00000,"execute <unnamed>: SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE ( (""AssetEntity"".""id"" = $1) ) AND ( ""AssetEntity"".""id"" IN ($2) )","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.386 UTC,"postgres","immich",43,"172.31.0.5:33072",6382db1a.2b,4,"SELECT",2022-11-27 03:35:54 UTC,3/27,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.394 UTC,"postgres","immich",43,"172.31.0.5:33072",6382db1a.2b,5,"SELECT",2022-11-27 03:35:54 UTC,3/28,0,LOG,00000,"execute <unnamed>: SELECT ""album"".""id"" AS ""album_id"", ""album"".""ownerId"" AS ""album_ownerId"", ""album"".""albumName"" AS ""album_albumName"", ""album"".""createdAt"" AS ""album_createdAt"", ""album"".""albumThumbnailAssetId"" AS ""album_albumThumbnailAssetId"", ""assets"".""id"" AS ""assets_id"", ""assets"".""albumId"" AS ""assets_albumId"", ""assets"".""assetId"" AS ""assets_assetId"", ""assetInfo"".""id"" AS ""assetInfo_id"", ""assetInfo"".""deviceAssetId"" AS ""assetInfo_deviceAssetId"", ""assetInfo"".""userId"" AS ""assetInfo_userId"", ""assetInfo"".""deviceId"" AS ""assetInfo_deviceId"", ""assetInfo"".""type"" AS ""assetInfo_type"", ""assetInfo"".""originalPath"" AS ""assetInfo_originalPath"", ""assetInfo"".""resizePath"" AS ""assetInfo_resizePath"", ""assetInfo"".""webpPath"" AS ""assetInfo_webpPath"", ""assetInfo"".""encodedVideoPath"" AS ""assetInfo_encodedVideoPath"", ""assetInfo"".""createdAt"" AS ""assetInfo_createdAt"", ""assetInfo"".""modifiedAt"" AS ""assetInfo_modifiedAt"", ""assetInfo"".""isFavorite"" AS ""assetInfo_isFavorite"", ""assetInfo"".""mimeType"" AS ""assetInfo_mimeType"", ""assetInfo"".""duration"" AS ""assetInfo_duration"", ""assetInfo"".""isVisible"" AS ""assetInfo_isVisible"", ""assetInfo"".""livePhotoVideoId"" AS ""assetInfo_livePhotoVideoId"", ""sharedUser"".""id"" AS ""sharedUser_id"", ""sharedUser"".""albumId"" AS ""sharedUser_albumId"", ""sharedUser"".""sharedUserId"" AS ""sharedUser_sharedUserId"", ""userInfo"".""id"" AS ""userInfo_id"", ""userInfo"".""firstName"" AS ""userInfo_firstName"", ""userInfo"".""lastName"" AS ""userInfo_lastName"", ""userInfo"".""isAdmin"" AS ""userInfo_isAdmin"", ""userInfo"".""email"" AS ""userInfo_email"", ""userInfo"".""profileImagePath"" AS ""userInfo_profileImagePath"", ""userInfo"".""shouldChangePassword"" AS ""userInfo_shouldChangePassword"", ""userInfo"".""createdAt"" AS ""userInfo_createdAt"", ""userInfo"".""deletedAt"" AS ""userInfo_deletedAt"" FROM ""albums"" ""album"" LEFT JOIN ""asset_album"" ""assets"" ON ""assets"".""albumId""=""album"".""id""  LEFT JOIN ""assets"" ""assetInfo"" ON ""assetInfo"".""id""=""assets"".""assetId""  LEFT JOIN ""user_shared_album"" ""sharedUser"" ON ""sharedUser"".""albumId""=""album"".""id""  LEFT JOIN ""users"" ""userInfo"" ON ""userInfo"".""id""=""sharedUser"".""sharedUserId"" AND (""userInfo"".""deletedAt"" IS NULL) WHERE ""album"".""ownerId"" = $1 AND ""album"".""id"" IN (SELECT ""assetAlbum"".""albumId"" AS ""assetAlbum_albumId"" FROM ""asset_album"" ""assetAlbum"" WHERE ""assetAlbum"".""assetId"" = $2) ORDER BY ""assetInfo"".""createdAt""::timestamptz ASC","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.482 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,1,"SELECT",2022-11-27 03:35:54 UTC,4/11,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.487 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,2,"SELECT",2022-11-27 03:35:54 UTC,4/12,0,LOG,00000,"execute <unnamed>: SELECT DISTINCT ""distinctAlias"".""AssetEntity_id"" AS ""ids_AssetEntity_id"" FROM (SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE (""AssetEntity"".""id"" = $1)) ""distinctAlias"" ORDER BY ""AssetEntity_id"" ASC LIMIT 1","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.489 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,3,"SELECT",2022-11-27 03:35:54 UTC,4/13,0,LOG,00000,"execute <unnamed>: SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE ( (""AssetEntity"".""id"" = $1) ) AND ( ""AssetEntity"".""id"" IN ($2) )","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.503 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,4,"SELECT",2022-11-27 03:35:54 UTC,4/14,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.507 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,5,"SELECT",2022-11-27 03:35:54 UTC,4/15,0,LOG,00000,"execute <unnamed>: SELECT DISTINCT ""distinctAlias"".""AssetEntity_id"" AS ""ids_AssetEntity_id"" FROM (SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE (""AssetEntity"".""id"" = $1)) ""distinctAlias"" ORDER BY ""AssetEntity_id"" ASC LIMIT 1","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:35:54.509 UTC,"postgres","immich",44,"172.31.0.5:33076",6382db1a.2c,6,"SELECT",2022-11-27 03:35:54 UTC,4/16,0,LOG,00000,"execute <unnamed>: SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE ( (""AssetEntity"".""id"" = $1) ) AND ( ""AssetEntity"".""id"" IN ($2) )","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0

Selecting image from Album view:

2022-11-27 03:37:15.941 UTC,"postgres","immich",49,"172.31.0.5:45606",6382db4d.31,17,"SELECT",2022-11-27 03:36:45 UTC,3/64,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:37:15.942 UTC,"postgres","immich",48,"172.31.0.5:35588",6382db37.30,34,"SELECT",2022-11-27 03:36:23 UTC,5/44,0,LOG,00000,"execute <unnamed>: SELECT ""UserEntity"".""id"" AS ""UserEntity_id"", ""UserEntity"".""firstName"" AS ""UserEntity_firstName"", ""UserEntity"".""lastName"" AS ""UserEntity_lastName"", ""UserEntity"".""isAdmin"" AS ""UserEntity_isAdmin"", ""UserEntity"".""email"" AS ""UserEntity_email"", ""UserEntity"".""profileImagePath"" AS ""UserEntity_profileImagePath"", ""UserEntity"".""shouldChangePassword"" AS ""UserEntity_shouldChangePassword"", ""UserEntity"".""createdAt"" AS ""UserEntity_createdAt"", ""UserEntity"".""deletedAt"" AS ""UserEntity_deletedAt"" FROM ""users"" ""UserEntity"" WHERE ( (""UserEntity"".""id"" = $1) ) AND ( ""UserEntity"".""deletedAt"" IS NULL ) LIMIT 1","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1'",,,,,,,,"","client backend",,0
2022-11-27 03:37:15.945 UTC,"postgres","immich",49,"172.31.0.5:45606",6382db4d.31,18,"SELECT",2022-11-27 03:36:45 UTC,3/65,0,LOG,00000,"execute <unnamed>: SELECT ""album"".""id"" AS ""album_id"", ""album"".""ownerId"" AS ""album_ownerId"", ""album"".""albumName"" AS ""album_albumName"", ""album"".""createdAt"" AS ""album_createdAt"", ""album"".""albumThumbnailAssetId"" AS ""album_albumThumbnailAssetId"", ""assets"".""id"" AS ""assets_id"", ""assets"".""albumId"" AS ""assets_albumId"", ""assets"".""assetId"" AS ""assets_assetId"", ""assetInfo"".""id"" AS ""assetInfo_id"", ""assetInfo"".""deviceAssetId"" AS ""assetInfo_deviceAssetId"", ""assetInfo"".""userId"" AS ""assetInfo_userId"", ""assetInfo"".""deviceId"" AS ""assetInfo_deviceId"", ""assetInfo"".""type"" AS ""assetInfo_type"", ""assetInfo"".""originalPath"" AS ""assetInfo_originalPath"", ""assetInfo"".""resizePath"" AS ""assetInfo_resizePath"", ""assetInfo"".""webpPath"" AS ""assetInfo_webpPath"", ""assetInfo"".""encodedVideoPath"" AS ""assetInfo_encodedVideoPath"", ""assetInfo"".""createdAt"" AS ""assetInfo_createdAt"", ""assetInfo"".""modifiedAt"" AS ""assetInfo_modifiedAt"", ""assetInfo"".""isFavorite"" AS ""assetInfo_isFavorite"", ""assetInfo"".""mimeType"" AS ""assetInfo_mimeType"", ""assetInfo"".""duration"" AS ""assetInfo_duration"", ""assetInfo"".""isVisible"" AS ""assetInfo_isVisible"", ""assetInfo"".""livePhotoVideoId"" AS ""assetInfo_livePhotoVideoId"", ""sharedUser"".""id"" AS ""sharedUser_id"", ""sharedUser"".""albumId"" AS ""sharedUser_albumId"", ""sharedUser"".""sharedUserId"" AS ""sharedUser_sharedUserId"", ""userInfo"".""id"" AS ""userInfo_id"", ""userInfo"".""firstName"" AS ""userInfo_firstName"", ""userInfo"".""lastName"" AS ""userInfo_lastName"", ""userInfo"".""isAdmin"" AS ""userInfo_isAdmin"", ""userInfo"".""email"" AS ""userInfo_email"", ""userInfo"".""profileImagePath"" AS ""userInfo_profileImagePath"", ""userInfo"".""shouldChangePassword"" AS ""userInfo_shouldChangePassword"", ""userInfo"".""createdAt"" AS ""userInfo_createdAt"", ""userInfo"".""deletedAt"" AS ""userInfo_deletedAt"" FROM ""albums"" ""album"" LEFT JOIN ""asset_album"" ""assets"" ON ""assets"".""albumId""=""album"".""id""  LEFT JOIN ""assets"" ""assetInfo"" ON ""assetInfo"".""id""=""assets"".""assetId""  LEFT JOIN ""user_shared_album"" ""sharedUser"" ON ""sharedUser"".""albumId""=""album"".""id""  LEFT JOIN ""users"" ""userInfo"" ON ""userInfo"".""id""=""sharedUser"".""sharedUserId"" AND (""userInfo"".""deletedAt"" IS NULL) WHERE ""album"".""ownerId"" = $1 AND ""album"".""id"" IN (SELECT ""assetAlbum"".""albumId"" AS ""assetAlbum_albumId"" FROM ""asset_album"" ""assetAlbum"" WHERE ""assetAlbum"".""assetId"" = $2) ORDER BY ""assetInfo"".""createdAt""::timestamptz ASC","parameters: $1 = '45388fcd-b929-43aa-a971-9acb777cfce1', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:37:15.946 UTC,"postgres","immich",48,"172.31.0.5:35588",6382db37.30,35,"SELECT",2022-11-27 03:36:23 UTC,5/45,0,LOG,00000,"execute <unnamed>: SELECT DISTINCT ""distinctAlias"".""AssetEntity_id"" AS ""ids_AssetEntity_id"" FROM (SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE (""AssetEntity"".""id"" = $1)) ""distinctAlias"" ORDER BY ""AssetEntity_id"" ASC LIMIT 1","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0
2022-11-27 03:37:15.949 UTC,"postgres","immich",48,"172.31.0.5:35588",6382db37.30,36,"SELECT",2022-11-27 03:36:23 UTC,5/46,0,LOG,00000,"execute <unnamed>: SELECT ""AssetEntity"".""id"" AS ""AssetEntity_id"", ""AssetEntity"".""deviceAssetId"" AS ""AssetEntity_deviceAssetId"", ""AssetEntity"".""userId"" AS ""AssetEntity_userId"", ""AssetEntity"".""deviceId"" AS ""AssetEntity_deviceId"", ""AssetEntity"".""type"" AS ""AssetEntity_type"", ""AssetEntity"".""originalPath"" AS ""AssetEntity_originalPath"", ""AssetEntity"".""resizePath"" AS ""AssetEntity_resizePath"", ""AssetEntity"".""webpPath"" AS ""AssetEntity_webpPath"", ""AssetEntity"".""encodedVideoPath"" AS ""AssetEntity_encodedVideoPath"", ""AssetEntity"".""createdAt"" AS ""AssetEntity_createdAt"", ""AssetEntity"".""modifiedAt"" AS ""AssetEntity_modifiedAt"", ""AssetEntity"".""isFavorite"" AS ""AssetEntity_isFavorite"", ""AssetEntity"".""mimeType"" AS ""AssetEntity_mimeType"", ""AssetEntity"".""duration"" AS ""AssetEntity_duration"", ""AssetEntity"".""isVisible"" AS ""AssetEntity_isVisible"", ""AssetEntity"".""livePhotoVideoId"" AS ""AssetEntity_livePhotoVideoId"", ""AssetEntity__AssetEntity_exifInfo"".""id"" AS ""AssetEntity__AssetEntity_exifInfo_id"", ""AssetEntity__AssetEntity_exifInfo"".""assetId"" AS ""AssetEntity__AssetEntity_exifInfo_assetId"", ""AssetEntity__AssetEntity_exifInfo"".""description"" AS ""AssetEntity__AssetEntity_exifInfo_description"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageWidth"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageWidth"", ""AssetEntity__AssetEntity_exifInfo"".""exifImageHeight"" AS ""AssetEntity__AssetEntity_exifInfo_exifImageHeight"", ""AssetEntity__AssetEntity_exifInfo"".""fileSizeInByte"" AS ""AssetEntity__AssetEntity_exifInfo_fileSizeInByte"", ""AssetEntity__AssetEntity_exifInfo"".""orientation"" AS ""AssetEntity__AssetEntity_exifInfo_orientation"", ""AssetEntity__AssetEntity_exifInfo"".""dateTimeOriginal"" AS ""AssetEntity__AssetEntity_exifInfo_dateTimeOriginal"", ""AssetEntity__AssetEntity_exifInfo"".""modifyDate"" AS ""AssetEntity__AssetEntity_exifInfo_modifyDate"", ""AssetEntity__AssetEntity_exifInfo"".""latitude"" AS ""AssetEntity__AssetEntity_exifInfo_latitude"", ""AssetEntity__AssetEntity_exifInfo"".""longitude"" AS ""AssetEntity__AssetEntity_exifInfo_longitude"", ""AssetEntity__AssetEntity_exifInfo"".""city"" AS ""AssetEntity__AssetEntity_exifInfo_city"", ""AssetEntity__AssetEntity_exifInfo"".""state"" AS ""AssetEntity__AssetEntity_exifInfo_state"", ""AssetEntity__AssetEntity_exifInfo"".""country"" AS ""AssetEntity__AssetEntity_exifInfo_country"", ""AssetEntity__AssetEntity_exifInfo"".""make"" AS ""AssetEntity__AssetEntity_exifInfo_make"", ""AssetEntity__AssetEntity_exifInfo"".""model"" AS ""AssetEntity__AssetEntity_exifInfo_model"", ""AssetEntity__AssetEntity_exifInfo"".""imageName"" AS ""AssetEntity__AssetEntity_exifInfo_imageName"", ""AssetEntity__AssetEntity_exifInfo"".""lensModel"" AS ""AssetEntity__AssetEntity_exifInfo_lensModel"", ""AssetEntity__AssetEntity_exifInfo"".""fNumber"" AS ""AssetEntity__AssetEntity_exifInfo_fNumber"", ""AssetEntity__AssetEntity_exifInfo"".""focalLength"" AS ""AssetEntity__AssetEntity_exifInfo_focalLength"", ""AssetEntity__AssetEntity_exifInfo"".""iso"" AS ""AssetEntity__AssetEntity_exifInfo_iso"", ""AssetEntity__AssetEntity_exifInfo"".""exposureTime"" AS ""AssetEntity__AssetEntity_exifInfo_exposureTime"", ""AssetEntity__AssetEntity_exifInfo"".""fps"" AS ""AssetEntity__AssetEntity_exifInfo_fps"", ""AssetEntity__AssetEntity_exifInfo"".""exifTextSearchableColumn"" AS ""AssetEntity__AssetEntity_exifInfo_exifTextSearchableColumn"" FROM ""assets"" ""AssetEntity"" LEFT JOIN ""exif"" ""AssetEntity__AssetEntity_exifInfo"" ON ""AssetEntity__AssetEntity_exifInfo"".""assetId""=""AssetEntity"".""id"" WHERE ( (""AssetEntity"".""id"" = $1) ) AND ( ""AssetEntity"".""id"" IN ($2) )","parameters: $1 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9', $2 = 'cae1f24f-896e-47da-b24a-9ea7d62483d9'",,,,,,,,"","client backend",,0

Nov 27 '22 04:11 denck007

Good report, thank you!

Nov 27 '22 05:11 alextran1502

~~Which browser did you use to test? Is it reproducible on different browsers?~~

edit: nvm I saw you use Chrome dev tool

Nov 27 '22 05:11 alextran1502

I also checked in Firefox and got the same result. Ubuntu 18.04.6 Firefox 107.0 Chrome 107.0.5304.110 (official build)

Nov 27 '22 15:11 denck007

@alextran1502 @jrasm91 do you know how things stand on this front nowadays? Should we still keep this issue open?

Apr 09 '23 23:04 bo0tzz

Not sure. Can probably be re-tested though

Apr 09 '23 23:04 jrasm91

Closing stale issue. Can be reopened if still a problem.

Aug 06 '23 19:08 jrasm91

immich immich copied to clipboard

[BUG] Viewing images from main page results in multiple duplicate database queries

immich
immich copied to clipboard