you should not use order by urls_title_sort.title asc，because this will lead to use temporary table and scan all the rows.