Fix WordPress Hierarchical Post Performance Issue

gistfile1.txt

	add_action( 'pre_get_posts', array( $this, 'fix_hierarchy_performance_issue' ) );

	function fix_hierarchy_performance_issue( $query ) {
		if ( $query->query['post_type']=='hotspot' && $query->query['orderby']=='menu_order title' ) {
			$query->set( 'orderby', 'menu_order title post_name' );
		}
	}