[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'public' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT p0_.id AS id_0, p0_.category_slug AS category_slug_1, p0_.title AS title_2, p0_.description AS description_3, p0_.body AS body_4, p0_.tags AS tags_5, p0_.visibility AS visibility_6, p0_.uses_count AS uses_count_7, p0_.is_draft AS is_draft_8, p0_.ai_model AS ai_model_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.uuid AS uuid_13, u1_.email AS email_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.date_of_birth AS date_of_birth_17, u1_.recruited_at AS recruited_at_18, u1_.referral_code AS referral_code_19, u1_.referral_reward_granted_at AS referral_reward_granted_at_20, u1_.referral_source AS referral_source_21, u1_.referral_source_detail AS referral_source_detail_22, u1_.roles AS roles_23, u1_.password AS password_24, u1_.password_reset_token AS password_reset_token_25, u1_.password_reset_requested_at AS password_reset_requested_at_26, u1_.created_at AS created_at_27, u1_.updated_at AS updated_at_28, u1_.status AS status_29, u1_.email_verification_token AS email_verification_token_30, u1_.email_verification_token_sent_at AS email_verification_token_sent_at_31, u1_.email_verified_at AS email_verified_at_32, u1_.cga_accepted_at AS cga_accepted_at_33, u1_.login_streak AS login_streak_34, u1_.pending_email AS pending_email_35, u1_.pending_email_token AS pending_email_token_36, u1_.pending_email_token_sent_at AS pending_email_token_sent_at_37, u1_.google_id AS google_id_38, p0_.user_id AS user_id_39, p0_.folder_id AS folder_id_40, u1_.company_id AS company_id_41, u1_.recruited_by_id AS recruited_by_id_42, u1_.recruited_by_user_id AS recruited_by_user_id_43 FROM promptly_prompt p0_ LEFT JOIN `user` u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility = ? AND p0_.is_draft = 0 ORDER BY p0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'a' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'a' => 'author', ], ], 'parentAliasMap' => [ 2 => [ 'a' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'category_slug_1' => 'categorySlug', 'title_2' => 'title', 'description_3' => 'description', 'body_4' => 'body', 'tags_5' => 'tags', 'visibility_6' => 'visibility', 'uses_count_7' => 'usesCount', 'is_draft_8' => 'isDraft', 'ai_model_9' => 'aiModel', 'created_at_10' => 'createdAt', 'updated_at_11' => 'updatedAt', 'id_12' => 'id', 'uuid_13' => 'uuid', 'email_14' => 'email', 'first_name_15' => 'firstName', 'last_name_16' => 'lastName', 'date_of_birth_17' => 'dateOfBirth', 'recruited_at_18' => 'recruitedAt', 'referral_code_19' => 'referralCode', 'referral_reward_granted_at_20' => 'referralRewardGrantedAt', 'referral_source_21' => 'referralSource', 'referral_source_detail_22' => 'referralSourceDetail', 'roles_23' => 'roles', 'password_24' => 'password', 'password_reset_token_25' => 'passwordResetToken', 'password_reset_requested_at_26' => 'passwordResetRequestedAt', 'created_at_27' => 'createdAt', 'updated_at_28' => 'updatedAt', 'status_29' => 'status', 'email_verification_token_30' => 'emailVerificationToken', 'email_verification_token_sent_at_31' => 'emailVerificationTokenSentAt', 'email_verified_at_32' => 'emailVerifiedAt', 'cga_accepted_at_33' => 'cgaAcceptedAt', 'login_streak_34' => 'loginStreak', 'pending_email_35' => 'pendingEmail', 'pending_email_token_36' => 'pendingEmailToken', 'pending_email_token_sent_at_37' => 'pendingEmailTokenSentAt', 'google_id_38' => 'googleId', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Promptly\\PromptlyPrompt' => [ 'p' => [ 'id' => 'id_0', 'categorySlug' => 'category_slug_1', 'title' => 'title_2', 'description' => 'description_3', 'body' => 'body_4', 'tags' => 'tags_5', 'visibility' => 'visibility_6', 'usesCount' => 'uses_count_7', 'isDraft' => 'is_draft_8', 'aiModel' => 'ai_model_9', 'createdAt' => 'created_at_10', 'updatedAt' => 'updated_at_11', ], ], 'App\\Entity\\User' => [ 'a' => [ 'id' => 'id_12', 'uuid' => 'uuid_13', 'email' => 'email_14', 'firstName' => 'first_name_15', 'lastName' => 'last_name_16', 'dateOfBirth' => 'date_of_birth_17', 'recruitedAt' => 'recruited_at_18', 'referralCode' => 'referral_code_19', 'referralRewardGrantedAt' => 'referral_reward_granted_at_20', 'referralSource' => 'referral_source_21', 'referralSourceDetail' => 'referral_source_detail_22', 'roles' => 'roles_23', 'password' => 'password_24', 'passwordResetToken' => 'password_reset_token_25', 'passwordResetRequestedAt' => 'password_reset_requested_at_26', 'createdAt' => 'created_at_27', 'updatedAt' => 'updated_at_28', 'status' => 'status_29', 'emailVerificationToken' => 'email_verification_token_30', 'emailVerificationTokenSentAt' => 'email_verification_token_sent_at_31', 'emailVerifiedAt' => 'email_verified_at_32', 'cgaAcceptedAt' => 'cga_accepted_at_33', 'loginStreak' => 'login_streak_34', 'pendingEmail' => 'pending_email_35', 'pendingEmailToken' => 'pending_email_token_36', 'pendingEmailTokenSentAt' => 'pending_email_token_sent_at_37', 'googleId' => 'google_id_38', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_id_39' => 'integer', 'folder_id_40' => 'integer', 'company_id_41' => 'integer', 'recruited_by_id_42' => 'integer', 'recruited_by_user_id_43' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'user_id_39' => 'user_id', 'folder_id_40' => 'folder_id', 'company_id_41' => 'company_id', 'recruited_by_id_42' => 'recruited_by_id', 'recruited_by_user_id_43' => 'recruited_by_user_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'p', 'category_slug_1' => 'p', 'title_2' => 'p', 'description_3' => 'p', 'body_4' => 'p', 'tags_5' => 'p', 'visibility_6' => 'p', 'uses_count_7' => 'p', 'is_draft_8' => 'p', 'ai_model_9' => 'p', 'created_at_10' => 'p', 'updated_at_11' => 'p', 'id_12' => 'a', 'uuid_13' => 'a', 'email_14' => 'a', 'first_name_15' => 'a', 'last_name_16' => 'a', 'date_of_birth_17' => 'a', 'recruited_at_18' => 'a', 'referral_code_19' => 'a', 'referral_reward_granted_at_20' => 'a', 'referral_source_21' => 'a', 'referral_source_detail_22' => 'a', 'roles_23' => 'a', 'password_24' => 'a', 'password_reset_token_25' => 'a', 'password_reset_requested_at_26' => 'a', 'created_at_27' => 'a', 'updated_at_28' => 'a', 'status_29' => 'a', 'email_verification_token_30' => 'a', 'email_verification_token_sent_at_31' => 'a', 'email_verified_at_32' => 'a', 'cga_accepted_at_33' => 'a', 'login_streak_34' => 'a', 'pending_email_35' => 'a', 'pending_email_token_36' => 'a', 'pending_email_token_sent_at_37' => 'a', 'google_id_38' => 'a', 'user_id_39' => 'p', 'folder_id_40' => 'p', 'company_id_41' => 'a', 'recruited_by_id_42' => 'a', 'recruited_by_user_id_43' => 'a', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'category_slug_1' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'title_2' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'description_3' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'body_4' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'tags_5' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'visibility_6' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'uses_count_7' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'is_draft_8' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'ai_model_9' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'created_at_10' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'updated_at_11' => 'App\\Entity\\Promptly\\PromptlyPrompt', 'id_12' => 'App\\Entity\\User', 'uuid_13' => 'App\\Entity\\User', 'email_14' => 'App\\Entity\\User', 'first_name_15' => 'App\\Entity\\User', 'last_name_16' => 'App\\Entity\\User', 'date_of_birth_17' => 'App\\Entity\\User', 'recruited_at_18' => 'App\\Entity\\User', 'referral_code_19' => 'App\\Entity\\User', 'referral_reward_granted_at_20' => 'App\\Entity\\User', 'referral_source_21' => 'App\\Entity\\User', 'referral_source_detail_22' => 'App\\Entity\\User', 'roles_23' => 'App\\Entity\\User', 'password_24' => 'App\\Entity\\User', 'password_reset_token_25' => 'App\\Entity\\User', 'password_reset_requested_at_26' => 'App\\Entity\\User', 'created_at_27' => 'App\\Entity\\User', 'updated_at_28' => 'App\\Entity\\User', 'status_29' => 'App\\Entity\\User', 'email_verification_token_30' => 'App\\Entity\\User', 'email_verification_token_sent_at_31' => 'App\\Entity\\User', 'email_verified_at_32' => 'App\\Entity\\User', 'cga_accepted_at_33' => 'App\\Entity\\User', 'login_streak_34' => 'App\\Entity\\User', 'pending_email_35' => 'App\\Entity\\User', 'pending_email_token_36' => 'App\\Entity\\User', 'pending_email_token_sent_at_37' => 'App\\Entity\\User', 'google_id_38' => 'App\\Entity\\User', ], ], ], ], $o[0], [] ); } }];