[ 'sql' => [ 1 => 'SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.old_email AS old_email_2, u0_.trial AS trial_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.is_verified AS is_verified_6, u0_.is_user AS is_user_7, u0_.valid_until AS valid_until_8, u0_.is_locked AS is_locked_9, u0_.is_active AS is_active_10, u0_.first_name AS first_name_11, u0_.last_name AS last_name_12, u0_.cellphone AS cellphone_13, u0_.global_id AS global_id_14, u0_.company AS company_15, u0_.reg_by AS reg_by_16, u0_.reg_datetime AS reg_datetime_17, u0_.changed_by AS changed_by_18, u0_.changed_datetime AS changed_datetime_19, u0_.ip_address AS ip_address_20, u0_.is_main_account AS is_main_account_21, u0_.user_lang AS user_lang_22, u0_.avatar_file_name AS avatar_file_name_23, u0_.google_id AS google_id_24, u0_.auth_code AS auth_code_25, u0_.is_email_auth_enabled AS is_email_auth_enabled_26 FROM user u0_ WHERE u0_.is_active = 1 AND (u0_.id LIKE ? OR u0_.company LIKE ? OR u0_.first_name LIKE ? OR u0_.last_name LIKE ? OR u0_.email LIKE ? OR u0_.cellphone LIKE ? OR u0_.roles LIKE ?) ORDER BY u0_.email ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'u' => 'App\\Entity\\User', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'email_1' => 'email', 'old_email_2' => 'oldEmail', 'trial_3' => 'trial', 'roles_4' => 'roles', 'password_5' => 'password', 'is_verified_6' => 'isVerified', 'is_user_7' => 'isUser', 'valid_until_8' => 'validUntil', 'is_locked_9' => 'isLocked', 'is_active_10' => 'isActive', 'first_name_11' => 'firstName', 'last_name_12' => 'lastName', 'cellphone_13' => 'cellphone', 'global_id_14' => 'globalId', 'company_15' => 'company', 'reg_by_16' => 'regBy', 'reg_datetime_17' => 'regDatetime', 'changed_by_18' => 'changedBy', 'changed_datetime_19' => 'changedDatetime', 'ip_address_20' => 'ipAddress', 'is_main_account_21' => 'isMainAccount', 'user_lang_22' => 'userLang', 'avatar_file_name_23' => 'avatarFileName', 'google_id_24' => 'googleId', 'auth_code_25' => 'authCode', 'is_email_auth_enabled_26' => 'isEmailAuthEnabled', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\User' => [ 'u' => [ 'id' => 'id_0', 'email' => 'email_1', 'oldEmail' => 'old_email_2', 'trial' => 'trial_3', 'roles' => 'roles_4', 'password' => 'password_5', 'isVerified' => 'is_verified_6', 'isUser' => 'is_user_7', 'validUntil' => 'valid_until_8', 'isLocked' => 'is_locked_9', 'isActive' => 'is_active_10', 'firstName' => 'first_name_11', 'lastName' => 'last_name_12', 'cellphone' => 'cellphone_13', 'globalId' => 'global_id_14', 'company' => 'company_15', 'regBy' => 'reg_by_16', 'regDatetime' => 'reg_datetime_17', 'changedBy' => 'changed_by_18', 'changedDatetime' => 'changed_datetime_19', 'ipAddress' => 'ip_address_20', 'isMainAccount' => 'is_main_account_21', 'userLang' => 'user_lang_22', 'avatarFileName' => 'avatar_file_name_23', 'googleId' => 'google_id_24', 'authCode' => 'auth_code_25', 'isEmailAuthEnabled' => 'is_email_auth_enabled_26', ], ], ], ], 'entityMappings' => [ 2 => [ 'u' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'u', 'email_1' => 'u', 'old_email_2' => 'u', 'trial_3' => 'u', 'roles_4' => 'u', 'password_5' => 'u', 'is_verified_6' => 'u', 'is_user_7' => 'u', 'valid_until_8' => 'u', 'is_locked_9' => 'u', 'is_active_10' => 'u', 'first_name_11' => 'u', 'last_name_12' => 'u', 'cellphone_13' => 'u', 'global_id_14' => 'u', 'company_15' => 'u', 'reg_by_16' => 'u', 'reg_datetime_17' => 'u', 'changed_by_18' => 'u', 'changed_datetime_19' => 'u', 'ip_address_20' => 'u', 'is_main_account_21' => 'u', 'user_lang_22' => 'u', 'avatar_file_name_23' => 'u', 'google_id_24' => 'u', 'auth_code_25' => 'u', 'is_email_auth_enabled_26' => 'u', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\User', 'email_1' => 'App\\Entity\\User', 'old_email_2' => 'App\\Entity\\User', 'trial_3' => 'App\\Entity\\User', 'roles_4' => 'App\\Entity\\User', 'password_5' => 'App\\Entity\\User', 'is_verified_6' => 'App\\Entity\\User', 'is_user_7' => 'App\\Entity\\User', 'valid_until_8' => 'App\\Entity\\User', 'is_locked_9' => 'App\\Entity\\User', 'is_active_10' => 'App\\Entity\\User', 'first_name_11' => 'App\\Entity\\User', 'last_name_12' => 'App\\Entity\\User', 'cellphone_13' => 'App\\Entity\\User', 'global_id_14' => 'App\\Entity\\User', 'company_15' => 'App\\Entity\\User', 'reg_by_16' => 'App\\Entity\\User', 'reg_datetime_17' => 'App\\Entity\\User', 'changed_by_18' => 'App\\Entity\\User', 'changed_datetime_19' => 'App\\Entity\\User', 'ip_address_20' => 'App\\Entity\\User', 'is_main_account_21' => 'App\\Entity\\User', 'user_lang_22' => 'App\\Entity\\User', 'avatar_file_name_23' => 'App\\Entity\\User', 'google_id_24' => 'App\\Entity\\User', 'auth_code_25' => 'App\\Entity\\User', 'is_email_auth_enabled_26' => 'App\\Entity\\User', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'query_0' => [ 0, 1, 2, 3, 4, 5, 6, ], ], ], ] ); } }];