def _get_urls_by_user_and_page(user_id): total = Url.count_all() page = Page(total, _get_page_index()) urls = Url.find_by( "where user_id = ?and `status` != 2 order by create_time desc limit ?,?", user_id, page.offset, page.limit) return urls, page