[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'status' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.reference AS reference_2, s0_.subject AS subject_3, s0_.category AS category_4, s0_.status AS status_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.last_message_at AS last_message_at_8, s0_.has_unread_for_admin AS has_unread_for_admin_9, s0_.has_unread_for_user AS has_unread_for_user_10, u1_.id AS id_11, u1_.uuid AS uuid_12, u1_.email AS email_13, u1_.first_name AS first_name_14, u1_.last_name AS last_name_15, u1_.date_of_birth AS date_of_birth_16, u1_.recruited_at AS recruited_at_17, u1_.referral_code AS referral_code_18, u1_.referral_reward_granted_at AS referral_reward_granted_at_19, u1_.referral_source AS referral_source_20, u1_.referral_source_detail AS referral_source_detail_21, u1_.roles AS roles_22, u1_.password AS password_23, u1_.password_reset_token AS password_reset_token_24, u1_.password_reset_requested_at AS password_reset_requested_at_25, u1_.created_at AS created_at_26, u1_.updated_at AS updated_at_27, u1_.status AS status_28, u1_.email_verification_token AS email_verification_token_29, u1_.email_verification_token_sent_at AS email_verification_token_sent_at_30, u1_.email_verified_at AS email_verified_at_31, u1_.cga_accepted_at AS cga_accepted_at_32, u1_.login_streak AS login_streak_33, u1_.pending_email AS pending_email_34, u1_.pending_email_token AS pending_email_token_35, u1_.pending_email_token_sent_at AS pending_email_token_sent_at_36, u1_.google_id AS google_id_37, s0_.user_id AS user_id_38, u1_.company_id AS company_id_39, u1_.recruited_by_id AS recruited_by_id_40, u1_.recruited_by_user_id AS recruited_by_user_id_41 FROM support_ticket s0_ LEFT JOIN `user` u1_ ON s0_.user_id = u1_.id WHERE s0_.status = ? ORDER BY s0_.last_message_at DESC, s0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\Entity\\SupportTicket', 'u' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'u' => 'user', ], ], 'parentAliasMap' => [ 2 => [ 'u' => 't', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'uuid_1' => 'uuid', 'reference_2' => 'reference', 'subject_3' => 'subject', 'category_4' => 'category', 'status_5' => 'status', 'created_at_6' => 'createdAt', 'updated_at_7' => 'updatedAt', 'last_message_at_8' => 'lastMessageAt', 'has_unread_for_admin_9' => 'hasUnreadForAdmin', 'has_unread_for_user_10' => 'hasUnreadForUser', 'id_11' => 'id', 'uuid_12' => 'uuid', 'email_13' => 'email', 'first_name_14' => 'firstName', 'last_name_15' => 'lastName', 'date_of_birth_16' => 'dateOfBirth', 'recruited_at_17' => 'recruitedAt', 'referral_code_18' => 'referralCode', 'referral_reward_granted_at_19' => 'referralRewardGrantedAt', 'referral_source_20' => 'referralSource', 'referral_source_detail_21' => 'referralSourceDetail', 'roles_22' => 'roles', 'password_23' => 'password', 'password_reset_token_24' => 'passwordResetToken', 'password_reset_requested_at_25' => 'passwordResetRequestedAt', 'created_at_26' => 'createdAt', 'updated_at_27' => 'updatedAt', 'status_28' => 'status', 'email_verification_token_29' => 'emailVerificationToken', 'email_verification_token_sent_at_30' => 'emailVerificationTokenSentAt', 'email_verified_at_31' => 'emailVerifiedAt', 'cga_accepted_at_32' => 'cgaAcceptedAt', 'login_streak_33' => 'loginStreak', 'pending_email_34' => 'pendingEmail', 'pending_email_token_35' => 'pendingEmailToken', 'pending_email_token_sent_at_36' => 'pendingEmailTokenSentAt', 'google_id_37' => 'googleId', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\SupportTicket' => [ 't' => [ 'id' => 'id_0', 'uuid' => 'uuid_1', 'reference' => 'reference_2', 'subject' => 'subject_3', 'category' => 'category_4', 'status' => 'status_5', 'createdAt' => 'created_at_6', 'updatedAt' => 'updated_at_7', 'lastMessageAt' => 'last_message_at_8', 'hasUnreadForAdmin' => 'has_unread_for_admin_9', 'hasUnreadForUser' => 'has_unread_for_user_10', ], ], 'App\\Entity\\User' => [ 'u' => [ 'id' => 'id_11', 'uuid' => 'uuid_12', 'email' => 'email_13', 'firstName' => 'first_name_14', 'lastName' => 'last_name_15', 'dateOfBirth' => 'date_of_birth_16', 'recruitedAt' => 'recruited_at_17', 'referralCode' => 'referral_code_18', 'referralRewardGrantedAt' => 'referral_reward_granted_at_19', 'referralSource' => 'referral_source_20', 'referralSourceDetail' => 'referral_source_detail_21', 'roles' => 'roles_22', 'password' => 'password_23', 'passwordResetToken' => 'password_reset_token_24', 'passwordResetRequestedAt' => 'password_reset_requested_at_25', 'createdAt' => 'created_at_26', 'updatedAt' => 'updated_at_27', 'status' => 'status_28', 'emailVerificationToken' => 'email_verification_token_29', 'emailVerificationTokenSentAt' => 'email_verification_token_sent_at_30', 'emailVerifiedAt' => 'email_verified_at_31', 'cgaAcceptedAt' => 'cga_accepted_at_32', 'loginStreak' => 'login_streak_33', 'pendingEmail' => 'pending_email_34', 'pendingEmailToken' => 'pending_email_token_35', 'pendingEmailTokenSentAt' => 'pending_email_token_sent_at_36', 'googleId' => 'google_id_37', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_id_38' => 'integer', 'company_id_39' => 'integer', 'recruited_by_id_40' => 'integer', 'recruited_by_user_id_41' => 'integer', ], ], 'entityMappings' => [ 2 => [ 't' => null, ], ], 'metaMappings' => [ 2 => [ 'user_id_38' => 'user_id', 'company_id_39' => 'company_id', 'recruited_by_id_40' => 'recruited_by_id', 'recruited_by_user_id_41' => 'recruited_by_user_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 't', 'uuid_1' => 't', 'reference_2' => 't', 'subject_3' => 't', 'category_4' => 't', 'status_5' => 't', 'created_at_6' => 't', 'updated_at_7' => 't', 'last_message_at_8' => 't', 'has_unread_for_admin_9' => 't', 'has_unread_for_user_10' => 't', 'id_11' => 'u', 'uuid_12' => 'u', 'email_13' => 'u', 'first_name_14' => 'u', 'last_name_15' => 'u', 'date_of_birth_16' => 'u', 'recruited_at_17' => 'u', 'referral_code_18' => 'u', 'referral_reward_granted_at_19' => 'u', 'referral_source_20' => 'u', 'referral_source_detail_21' => 'u', 'roles_22' => 'u', 'password_23' => 'u', 'password_reset_token_24' => 'u', 'password_reset_requested_at_25' => 'u', 'created_at_26' => 'u', 'updated_at_27' => 'u', 'status_28' => 'u', 'email_verification_token_29' => 'u', 'email_verification_token_sent_at_30' => 'u', 'email_verified_at_31' => 'u', 'cga_accepted_at_32' => 'u', 'login_streak_33' => 'u', 'pending_email_34' => 'u', 'pending_email_token_35' => 'u', 'pending_email_token_sent_at_36' => 'u', 'google_id_37' => 'u', 'user_id_38' => 't', 'company_id_39' => 'u', 'recruited_by_id_40' => 'u', 'recruited_by_user_id_41' => 'u', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\SupportTicket', 'uuid_1' => 'App\\Entity\\SupportTicket', 'reference_2' => 'App\\Entity\\SupportTicket', 'subject_3' => 'App\\Entity\\SupportTicket', 'category_4' => 'App\\Entity\\SupportTicket', 'status_5' => 'App\\Entity\\SupportTicket', 'created_at_6' => 'App\\Entity\\SupportTicket', 'updated_at_7' => 'App\\Entity\\SupportTicket', 'last_message_at_8' => 'App\\Entity\\SupportTicket', 'has_unread_for_admin_9' => 'App\\Entity\\SupportTicket', 'has_unread_for_user_10' => 'App\\Entity\\SupportTicket', 'id_11' => 'App\\Entity\\User', 'uuid_12' => 'App\\Entity\\User', 'email_13' => 'App\\Entity\\User', 'first_name_14' => 'App\\Entity\\User', 'last_name_15' => 'App\\Entity\\User', 'date_of_birth_16' => 'App\\Entity\\User', 'recruited_at_17' => 'App\\Entity\\User', 'referral_code_18' => 'App\\Entity\\User', 'referral_reward_granted_at_19' => 'App\\Entity\\User', 'referral_source_20' => 'App\\Entity\\User', 'referral_source_detail_21' => 'App\\Entity\\User', 'roles_22' => 'App\\Entity\\User', 'password_23' => 'App\\Entity\\User', 'password_reset_token_24' => 'App\\Entity\\User', 'password_reset_requested_at_25' => 'App\\Entity\\User', 'created_at_26' => 'App\\Entity\\User', 'updated_at_27' => 'App\\Entity\\User', 'status_28' => 'App\\Entity\\User', 'email_verification_token_29' => 'App\\Entity\\User', 'email_verification_token_sent_at_30' => 'App\\Entity\\User', 'email_verified_at_31' => 'App\\Entity\\User', 'cga_accepted_at_32' => 'App\\Entity\\User', 'login_streak_33' => 'App\\Entity\\User', 'pending_email_34' => 'App\\Entity\\User', 'pending_email_token_35' => 'App\\Entity\\User', 'pending_email_token_sent_at_36' => 'App\\Entity\\User', 'google_id_37' => 'App\\Entity\\User', ], ], ], ], $o[0], [] ); } }];