[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'user' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.read_at AS read_at_2, n0_.public_id AS public_id_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.username AS username_8, u1_.password AS password_9, u1_.display_name AS display_name_10, u1_.bio AS bio_11, u1_.pinned_quote AS pinned_quote_12, u1_.avatar_path AS avatar_path_13, u1_.roles AS roles_14, u1_.email_verified_at AS email_verified_at_15, u1_.last_login_at AS last_login_at_16, u1_.is_active AS is_active_17, u1_.locale AS locale_18, u1_.deleted_at AS deleted_at_19, u1_.onboarded_at AS onboarded_at_20, u1_.public_id AS public_id_21, u1_.created_at AS created_at_22, u1_.updated_at AS updated_at_23, r2_.id AS id_24, r2_.body AS body_25, r2_.contains_spoilers AS contains_spoilers_26, r2_.is_pinned AS is_pinned_27, r2_.likes_count AS likes_count_28, r2_.comments_count AS comments_count_29, r2_.public_id AS public_id_30, r2_.created_at AS created_at_31, r2_.updated_at AS updated_at_32, r3_.id AS id_33, r3_.score AS score_34, r3_.read_at AS read_at_35, r3_.public_id AS public_id_36, r3_.created_at AS created_at_37, r3_.updated_at AS updated_at_38, w4_.id AS id_39, w4_.bnf_ark AS bnf_ark_40, w4_.wikidata_qid AS wikidata_qid_41, w4_.open_library_work_id AS open_library_work_id_42, w4_.canonical_key AS canonical_key_43, w4_.title AS title_44, w4_.original_title AS original_title_45, w4_.description AS description_46, w4_.first_published_year AS first_published_year_47, w4_.year_source AS year_source_48, w4_.original_language AS original_language_49, w4_.default_cover_url AS default_cover_url_50, w4_.local_cover_path AS local_cover_path_51, w4_.ratings_count AS ratings_count_52, w4_.ratings_avg AS ratings_avg_53, w4_.last_synced_at AS last_synced_at_54, w4_.awards AS awards_55, w4_.adaptations AS adaptations_56, w4_.facets AS facets_57, w4_.public_id AS public_id_58, w4_.created_at AS created_at_59, w4_.updated_at AS updated_at_60, n0_.recipient_id AS recipient_id_61, n0_.actor_id AS actor_id_62, n0_.target_review_id AS target_review_id_63, n0_.target_comment_id AS target_comment_id_64, r2_.rating_id AS rating_id_65, r3_.user_id AS user_id_66, r3_.work_id AS work_id_67, r3_.edition_id AS edition_id_68, w4_.canonical_edition_id AS canonical_edition_id_69 FROM notifications n0_ INNER JOIN users u1_ ON n0_.actor_id = u1_.id LEFT JOIN reviews r2_ ON n0_.target_review_id = r2_.id LEFT JOIN ratings r3_ ON r2_.rating_id = r3_.id LEFT JOIN works w4_ ON r3_.work_id = w4_.id WHERE n0_.recipient_id = ? ORDER BY n0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'n' => 'App\\Entity\\Notification', 'a' => 'App\\Entity\\User', 'tr' => 'App\\Entity\\Review', 'rt' => 'App\\Entity\\Rating', 'w' => 'App\\Entity\\Work', ], ], 'relationMap' => [ 2 => [ 'a' => 'actor', 'tr' => 'targetReview', 'rt' => 'rating', 'w' => 'work', ], ], 'parentAliasMap' => [ 2 => [ 'a' => 'n', 'tr' => 'n', 'rt' => 'tr', 'w' => 'rt', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'type_1' => 'type', 'read_at_2' => 'readAt', 'public_id_3' => 'publicId', 'created_at_4' => 'createdAt', 'updated_at_5' => 'updatedAt', 'id_6' => 'id', 'email_7' => 'email', 'username_8' => 'username', 'password_9' => 'password', 'display_name_10' => 'displayName', 'bio_11' => 'bio', 'pinned_quote_12' => 'pinnedQuote', 'avatar_path_13' => 'avatarPath', 'roles_14' => 'roles', 'email_verified_at_15' => 'emailVerifiedAt', 'last_login_at_16' => 'lastLoginAt', 'is_active_17' => 'isActive', 'locale_18' => 'locale', 'deleted_at_19' => 'deletedAt', 'onboarded_at_20' => 'onboardedAt', 'public_id_21' => 'publicId', 'created_at_22' => 'createdAt', 'updated_at_23' => 'updatedAt', 'id_24' => 'id', 'body_25' => 'body', 'contains_spoilers_26' => 'containsSpoilers', 'is_pinned_27' => 'isPinned', 'likes_count_28' => 'likesCount', 'comments_count_29' => 'commentsCount', 'public_id_30' => 'publicId', 'created_at_31' => 'createdAt', 'updated_at_32' => 'updatedAt', 'id_33' => 'id', 'score_34' => 'score', 'read_at_35' => 'readAt', 'public_id_36' => 'publicId', 'created_at_37' => 'createdAt', 'updated_at_38' => 'updatedAt', 'id_39' => 'id', 'bnf_ark_40' => 'bnfArk', 'wikidata_qid_41' => 'wikidataQid', 'open_library_work_id_42' => 'openLibraryWorkId', 'canonical_key_43' => 'canonicalKey', 'title_44' => 'title', 'original_title_45' => 'originalTitle', 'description_46' => 'description', 'first_published_year_47' => 'firstPublishedYear', 'year_source_48' => 'yearSource', 'original_language_49' => 'originalLanguage', 'default_cover_url_50' => 'defaultCoverUrl', 'local_cover_path_51' => 'localCoverPath', 'ratings_count_52' => 'ratingsCount', 'ratings_avg_53' => 'ratingsAvg', 'last_synced_at_54' => 'lastSyncedAt', 'awards_55' => 'awards', 'adaptations_56' => 'adaptations', 'facets_57' => 'facets', 'public_id_58' => 'publicId', 'created_at_59' => 'createdAt', 'updated_at_60' => 'updatedAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Notification' => [ 'n' => [ 'id' => 'id_0', 'type' => 'type_1', 'readAt' => 'read_at_2', 'publicId' => 'public_id_3', 'createdAt' => 'created_at_4', 'updatedAt' => 'updated_at_5', ], ], 'App\\Entity\\User' => [ 'a' => [ 'id' => 'id_6', 'email' => 'email_7', 'username' => 'username_8', 'password' => 'password_9', 'displayName' => 'display_name_10', 'bio' => 'bio_11', 'pinnedQuote' => 'pinned_quote_12', 'avatarPath' => 'avatar_path_13', 'roles' => 'roles_14', 'emailVerifiedAt' => 'email_verified_at_15', 'lastLoginAt' => 'last_login_at_16', 'isActive' => 'is_active_17', 'locale' => 'locale_18', 'deletedAt' => 'deleted_at_19', 'onboardedAt' => 'onboarded_at_20', 'publicId' => 'public_id_21', 'createdAt' => 'created_at_22', 'updatedAt' => 'updated_at_23', ], ], 'App\\Entity\\Review' => [ 'tr' => [ 'id' => 'id_24', 'body' => 'body_25', 'containsSpoilers' => 'contains_spoilers_26', 'isPinned' => 'is_pinned_27', 'likesCount' => 'likes_count_28', 'commentsCount' => 'comments_count_29', 'publicId' => 'public_id_30', 'createdAt' => 'created_at_31', 'updatedAt' => 'updated_at_32', ], ], 'App\\Entity\\Rating' => [ 'rt' => [ 'id' => 'id_33', 'score' => 'score_34', 'readAt' => 'read_at_35', 'publicId' => 'public_id_36', 'createdAt' => 'created_at_37', 'updatedAt' => 'updated_at_38', ], ], 'App\\Entity\\Work' => [ 'w' => [ 'id' => 'id_39', 'bnfArk' => 'bnf_ark_40', 'wikidataQid' => 'wikidata_qid_41', 'openLibraryWorkId' => 'open_library_work_id_42', 'canonicalKey' => 'canonical_key_43', 'title' => 'title_44', 'originalTitle' => 'original_title_45', 'description' => 'description_46', 'firstPublishedYear' => 'first_published_year_47', 'yearSource' => 'year_source_48', 'originalLanguage' => 'original_language_49', 'defaultCoverUrl' => 'default_cover_url_50', 'localCoverPath' => 'local_cover_path_51', 'ratingsCount' => 'ratings_count_52', 'ratingsAvg' => 'ratings_avg_53', 'lastSyncedAt' => 'last_synced_at_54', 'awards' => 'awards_55', 'adaptations' => 'adaptations_56', 'facets' => 'facets_57', 'publicId' => 'public_id_58', 'createdAt' => 'created_at_59', 'updatedAt' => 'updated_at_60', ], ], ], ], 'enumMappings' => [ 2 => [ 'type_1' => 'App\\Enum\\NotificationType', 'year_source_48' => 'App\\Entity\\Enum\\YearSource', ], ], 'typeMappings' => [ 2 => [ 'recipient_id_61' => 'bigint', 'actor_id_62' => 'bigint', 'target_review_id_63' => 'bigint', 'target_comment_id_64' => 'bigint', 'rating_id_65' => 'bigint', 'user_id_66' => 'bigint', 'work_id_67' => 'bigint', 'edition_id_68' => 'bigint', 'canonical_edition_id_69' => 'bigint', ], ], 'entityMappings' => [ 2 => [ 'n' => null, ], ], 'metaMappings' => [ 2 => [ 'recipient_id_61' => 'recipient_id', 'actor_id_62' => 'actor_id', 'target_review_id_63' => 'target_review_id', 'target_comment_id_64' => 'target_comment_id', 'rating_id_65' => 'rating_id', 'user_id_66' => 'user_id', 'work_id_67' => 'work_id', 'edition_id_68' => 'edition_id', 'canonical_edition_id_69' => 'canonical_edition_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'n', 'type_1' => 'n', 'read_at_2' => 'n', 'public_id_3' => 'n', 'created_at_4' => 'n', 'updated_at_5' => 'n', 'id_6' => 'a', 'email_7' => 'a', 'username_8' => 'a', 'password_9' => 'a', 'display_name_10' => 'a', 'bio_11' => 'a', 'pinned_quote_12' => 'a', 'avatar_path_13' => 'a', 'roles_14' => 'a', 'email_verified_at_15' => 'a', 'last_login_at_16' => 'a', 'is_active_17' => 'a', 'locale_18' => 'a', 'deleted_at_19' => 'a', 'onboarded_at_20' => 'a', 'public_id_21' => 'a', 'created_at_22' => 'a', 'updated_at_23' => 'a', 'id_24' => 'tr', 'body_25' => 'tr', 'contains_spoilers_26' => 'tr', 'is_pinned_27' => 'tr', 'likes_count_28' => 'tr', 'comments_count_29' => 'tr', 'public_id_30' => 'tr', 'created_at_31' => 'tr', 'updated_at_32' => 'tr', 'id_33' => 'rt', 'score_34' => 'rt', 'read_at_35' => 'rt', 'public_id_36' => 'rt', 'created_at_37' => 'rt', 'updated_at_38' => 'rt', 'id_39' => 'w', 'bnf_ark_40' => 'w', 'wikidata_qid_41' => 'w', 'open_library_work_id_42' => 'w', 'canonical_key_43' => 'w', 'title_44' => 'w', 'original_title_45' => 'w', 'description_46' => 'w', 'first_published_year_47' => 'w', 'year_source_48' => 'w', 'original_language_49' => 'w', 'default_cover_url_50' => 'w', 'local_cover_path_51' => 'w', 'ratings_count_52' => 'w', 'ratings_avg_53' => 'w', 'last_synced_at_54' => 'w', 'awards_55' => 'w', 'adaptations_56' => 'w', 'facets_57' => 'w', 'public_id_58' => 'w', 'created_at_59' => 'w', 'updated_at_60' => 'w', 'recipient_id_61' => 'n', 'actor_id_62' => 'n', 'target_review_id_63' => 'n', 'target_comment_id_64' => 'n', 'rating_id_65' => 'tr', 'user_id_66' => 'rt', 'work_id_67' => 'rt', 'edition_id_68' => 'rt', 'canonical_edition_id_69' => 'w', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Notification', 'type_1' => 'App\\Entity\\Notification', 'read_at_2' => 'App\\Entity\\Notification', 'public_id_3' => 'App\\Entity\\Notification', 'created_at_4' => 'App\\Entity\\Notification', 'updated_at_5' => 'App\\Entity\\Notification', 'id_6' => 'App\\Entity\\User', 'email_7' => 'App\\Entity\\User', 'username_8' => 'App\\Entity\\User', 'password_9' => 'App\\Entity\\User', 'display_name_10' => 'App\\Entity\\User', 'bio_11' => 'App\\Entity\\User', 'pinned_quote_12' => 'App\\Entity\\User', 'avatar_path_13' => 'App\\Entity\\User', 'roles_14' => 'App\\Entity\\User', 'email_verified_at_15' => 'App\\Entity\\User', 'last_login_at_16' => 'App\\Entity\\User', 'is_active_17' => 'App\\Entity\\User', 'locale_18' => 'App\\Entity\\User', 'deleted_at_19' => 'App\\Entity\\User', 'onboarded_at_20' => 'App\\Entity\\User', 'public_id_21' => 'App\\Entity\\User', 'created_at_22' => 'App\\Entity\\User', 'updated_at_23' => 'App\\Entity\\User', 'id_24' => 'App\\Entity\\Review', 'body_25' => 'App\\Entity\\Review', 'contains_spoilers_26' => 'App\\Entity\\Review', 'is_pinned_27' => 'App\\Entity\\Review', 'likes_count_28' => 'App\\Entity\\Review', 'comments_count_29' => 'App\\Entity\\Review', 'public_id_30' => 'App\\Entity\\Review', 'created_at_31' => 'App\\Entity\\Review', 'updated_at_32' => 'App\\Entity\\Review', 'id_33' => 'App\\Entity\\Rating', 'score_34' => 'App\\Entity\\Rating', 'read_at_35' => 'App\\Entity\\Rating', 'public_id_36' => 'App\\Entity\\Rating', 'created_at_37' => 'App\\Entity\\Rating', 'updated_at_38' => 'App\\Entity\\Rating', 'id_39' => 'App\\Entity\\Work', 'bnf_ark_40' => 'App\\Entity\\Work', 'wikidata_qid_41' => 'App\\Entity\\Work', 'open_library_work_id_42' => 'App\\Entity\\Work', 'canonical_key_43' => 'App\\Entity\\Work', 'title_44' => 'App\\Entity\\Work', 'original_title_45' => 'App\\Entity\\Work', 'description_46' => 'App\\Entity\\Work', 'first_published_year_47' => 'App\\Entity\\Work', 'year_source_48' => 'App\\Entity\\Work', 'original_language_49' => 'App\\Entity\\Work', 'default_cover_url_50' => 'App\\Entity\\Work', 'local_cover_path_51' => 'App\\Entity\\Work', 'ratings_count_52' => 'App\\Entity\\Work', 'ratings_avg_53' => 'App\\Entity\\Work', 'last_synced_at_54' => 'App\\Entity\\Work', 'awards_55' => 'App\\Entity\\Work', 'adaptations_56' => 'App\\Entity\\Work', 'facets_57' => 'App\\Entity\\Work', 'public_id_58' => 'App\\Entity\\Work', 'created_at_59' => 'App\\Entity\\Work', 'updated_at_60' => 'App\\Entity\\Work', ], ], ], ], $o[0], [] ); } }];