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
