[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'ROLE_HELLOASSO_MEMBER' => [ 0, ], 'ROLE_USER' => [ 1, ], 'ROLE_PRESCRIBER' => [ 2, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT u0_.id AS id_0, u0_.lastname AS lastname_1, u0_.firstname AS firstname_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.last_login_at AS last_login_at_6, u0_.is_verified AS is_verified_7, u0_.locale AS locale_8, u0_.token AS token_9, u0_.token_expires_at AS token_expires_at_10, u0_.membership_claimed AS membership_claimed_11, u0_.membership_checked_at AS membership_checked_at_12, u0_.membership_expires_at AS membership_expires_at_13, u0_.membership_status AS membership_status_14, u0_.helloasso_member_id AS helloasso_member_id_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.deleted_at AS deleted_at_18, u0_.is_active AS is_active_19, u0_.profile_id AS profile_id_20, u0_.helloasso_membership_campaign_id AS helloasso_membership_campaign_id_21, u0_.helloasso_membership_id AS helloasso_membership_id_22 FROM `user` u0_ WHERE JSON_CONTAINS(u0_.roles, ?) = 1 OR JSON_CONTAINS(u0_.roles, ?) = 1 OR JSON_CONTAINS(u0_.roles, ?) = 1 ORDER BY u0_.id DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'u' => 'App\\UserBundle\\Entity\\User', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'lastname_1' => 'lastname', 'firstname_2' => 'firstname', 'email_3' => 'email', 'roles_4' => 'roles', 'password_5' => 'password', 'last_login_at_6' => 'lastLoginAt', 'is_verified_7' => 'isVerified', 'locale_8' => 'locale', 'token_9' => 'token', 'token_expires_at_10' => 'tokenExpiresAt', 'membership_claimed_11' => 'membershipClaimed', 'membership_checked_at_12' => 'membershipCheckedAt', 'membership_expires_at_13' => 'membershipExpiresAt', 'membership_status_14' => 'membershipStatus', 'helloasso_member_id_15' => 'helloassoMemberId', 'created_at_16' => 'createdAt', 'updated_at_17' => 'updatedAt', 'deleted_at_18' => 'deletedAt', 'is_active_19' => 'isActive', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\UserBundle\\Entity\\User' => [ 'u' => [ 'id' => 'id_0', 'lastname' => 'lastname_1', 'firstname' => 'firstname_2', 'email' => 'email_3', 'roles' => 'roles_4', 'password' => 'password_5', 'lastLoginAt' => 'last_login_at_6', 'isVerified' => 'is_verified_7', 'locale' => 'locale_8', 'token' => 'token_9', 'tokenExpiresAt' => 'token_expires_at_10', 'membershipClaimed' => 'membership_claimed_11', 'membershipCheckedAt' => 'membership_checked_at_12', 'membershipExpiresAt' => 'membership_expires_at_13', 'membershipStatus' => 'membership_status_14', 'helloassoMemberId' => 'helloasso_member_id_15', 'createdAt' => 'created_at_16', 'updatedAt' => 'updated_at_17', 'deletedAt' => 'deleted_at_18', 'isActive' => 'is_active_19', ], ], ], ], 'typeMappings' => [ 2 => [ 'profile_id_20' => 'integer', 'helloasso_membership_campaign_id_21' => 'integer', 'helloasso_membership_id_22' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'u' => null, ], ], 'metaMappings' => [ 2 => [ 'profile_id_20' => 'profile_id', 'helloasso_membership_campaign_id_21' => 'helloasso_membership_campaign_id', 'helloasso_membership_id_22' => 'helloasso_membership_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'u', 'lastname_1' => 'u', 'firstname_2' => 'u', 'email_3' => 'u', 'roles_4' => 'u', 'password_5' => 'u', 'last_login_at_6' => 'u', 'is_verified_7' => 'u', 'locale_8' => 'u', 'token_9' => 'u', 'token_expires_at_10' => 'u', 'membership_claimed_11' => 'u', 'membership_checked_at_12' => 'u', 'membership_expires_at_13' => 'u', 'membership_status_14' => 'u', 'helloasso_member_id_15' => 'u', 'created_at_16' => 'u', 'updated_at_17' => 'u', 'deleted_at_18' => 'u', 'is_active_19' => 'u', 'profile_id_20' => 'u', 'helloasso_membership_campaign_id_21' => 'u', 'helloasso_membership_id_22' => 'u', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\UserBundle\\Entity\\User', 'lastname_1' => 'App\\UserBundle\\Entity\\User', 'firstname_2' => 'App\\UserBundle\\Entity\\User', 'email_3' => 'App\\UserBundle\\Entity\\User', 'roles_4' => 'App\\UserBundle\\Entity\\User', 'password_5' => 'App\\UserBundle\\Entity\\User', 'last_login_at_6' => 'App\\UserBundle\\Entity\\User', 'is_verified_7' => 'App\\UserBundle\\Entity\\User', 'locale_8' => 'App\\UserBundle\\Entity\\User', 'token_9' => 'App\\UserBundle\\Entity\\User', 'token_expires_at_10' => 'App\\UserBundle\\Entity\\User', 'membership_claimed_11' => 'App\\UserBundle\\Entity\\User', 'membership_checked_at_12' => 'App\\UserBundle\\Entity\\User', 'membership_expires_at_13' => 'App\\UserBundle\\Entity\\User', 'membership_status_14' => 'App\\UserBundle\\Entity\\User', 'helloasso_member_id_15' => 'App\\UserBundle\\Entity\\User', 'created_at_16' => 'App\\UserBundle\\Entity\\User', 'updated_at_17' => 'App\\UserBundle\\Entity\\User', 'deleted_at_18' => 'App\\UserBundle\\Entity\\User', 'is_active_19' => 'App\\UserBundle\\Entity\\User', ], ], ], ], $o[0], [] ); } }];