Debian unstable x86, trunk 6.5 at r7690.

this is the --d_sql output. it appears to request a resultset ordered by TITLESORT and iterate over a resultset ordered by ID.

-------------------------------
$VAR1 = {
          'playlist' => 'playlisttrack'
        };
$VAR1 = {};
$VAR1 = {};
working on level: [Playlist]
$self->result_class: [Slim::Schema::Playlist]
$self->result_source->schema->source($level)->result_class: [Slim::Schema::Playlist]
Calling method: [browse]
2006-05-30 21:27:07.3565 find:
2006-05-30 21:27:07.3570 running resultset on: playlist
2006-05-30 21:27:07.3590 SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( content_type IN ( ? ) ) (`ssp')
2006-05-30 21:27:07.3615 SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( content_type IN ( ? ) ) (`ssp')
2006-05-30 21:27:07.3642 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.tag, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( content_type IN ( ? ) ) GROUP BY me.id ORDER BY titlesort LIMIT 40 (`ssp')
2006-05-30 21:27:07.3842 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4041')
2006-05-30 21:27:07.3880 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4042')
2006-05-30 21:27:07.3916 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4043')
2006-05-30 21:27:07.3954 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4044')
2006-05-30 21:27:07.3990 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4046')
2006-05-30 21:27:07.4027 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4048')
2006-05-30 21:27:07.4064 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4050')
2006-05-30 21:27:07.4100 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4052')
2006-05-30 21:27:07.4137 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4057')
2006-05-30 21:27:07.4174 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4058')
2006-05-30 21:27:07.4214 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4059')
2006-05-30 21:27:07.4250 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4165')
2006-05-30 21:27:07.4287 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4166')
2006-05-30 21:27:07.4324 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4167')
2006-05-30 21:27:07.4360 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4168')
2006-05-30 21:27:07.4397 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4173')
2006-05-30 21:27:07.4434 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4174')
2006-05-30 21:27:07.4470 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4176')
2006-05-30 21:27:07.4507 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4177')
2006-05-30 21:27:07.4544 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4178')
2006-05-30 21:27:07.4581 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4179')
2006-05-30 21:27:07.4618 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4180')
2006-05-30 21:27:07.4655 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4182')
2006-05-30 21:27:07.4692 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4183')
2006-05-30 21:27:07.4728 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4185')
2006-05-30 21:27:07.4765 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4191')
2006-05-30 21:27:07.4802 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4192')
2006-05-30 21:27:07.4839 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4193')
2006-05-30 21:27:07.4876 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4195')
2006-05-30 21:27:07.4913 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4196')
2006-05-30 21:27:07.4950 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4198')
2006-05-30 21:27:07.4987 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4201')
2006-05-30 21:27:07.5024 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4202')
2006-05-30 21:27:07.5061 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4205')
2006-05-30 21:27:07.5098 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4207')
2006-05-30 21:27:07.5135 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4208')
2006-05-30 21:27:07.5172 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4209')
2006-05-30 21:27:07.5209 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4211')
2006-05-30 21:27:07.5246 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4214')
2006-05-30 21:27:07.5283 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( role = ? AND track = ? ) (`1', `4215')
-------------------------------