@Override
    public List<PhoneRecord> getRecords(int first, int last) {

    	List<PhoneRecord> records = new ArrayList<PhoneRecord>();
    	Connection connection = null;
    	PreparedStatement statement = null;
    	try {
			connection = StorageProvider.INSTANCE.getConnection();
			statement = connection.prepareStatement(GET_RECORDS_SHORT_QUERY);
			ResultSet resultSet = executeRecordsStatement(first, last,
					statement);
			parseRecordsSet(resultSet, records);
			
		} catch (SQLException e) {
			LOGGER.error("Failed to obtain connection:", e);
		} finally {
			closeResources(connection, statement);
		}
        return records;
    }