[08-01-06 21:17:59.2973] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM albums me: 
[08-01-06 21:17:59.7728] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ): 
[08-01-06 21:18:00.3917] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:00.4127] Slim::Schema::Debug::query_start (26) SELECT me.id, me.artwork, me.title, contributor.name FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name ORDER BY concat('0', me.titlesort), me.disc LIMIT 1584: 
[08-01-06 21:18:05.7348] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me: 
[08-01-06 21:18:06.3754] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM tracks me WHERE ( me.audio = ? ): '1'
[08-01-06 21:18:08.8521] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, 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.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 ( url = ? ): 'clientplaylist://00:04:20:06:df:46'
[08-01-06 21:18:08.9215] Slim::Schema::Debug::query_start (26) SELECT track.id, track.url, track.content_type, track.title, track.titlesort, track.titlesearch, track.album, track.tracknum, track.timestamp, track.filesize, track.disc, track.remote, track.audio, track.audio_size, track.audio_offset, track.year, track.secs, track.cover, track.vbr_scale, track.bitrate, track.samplerate, track.samplesize, track.channels, track.block_alignment, track.endian, track.bpm, track.tagversion, track.drm, track.musicmagic_mixable, track.musicbrainz_id, track.playcount, track.lastplayed, track.lossless, track.lyrics, track.rating, track.replay_gain, track.replay_peak FROM playlist_track me  JOIN tracks track ON ( track.id = me.track ) WHERE ( me.playlist = ? ) ORDER BY me.position: '21095'
[08-01-06 21:18:09.1759] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, 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.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 ( url = ? ): 'clientplaylist://00:04:20:10:02:77'
[08-01-06 21:18:09.1896] Slim::Schema::Debug::query_start (26) SELECT track.id, track.url, track.content_type, track.title, track.titlesort, track.titlesearch, track.album, track.tracknum, track.timestamp, track.filesize, track.disc, track.remote, track.audio, track.audio_size, track.audio_offset, track.year, track.secs, track.cover, track.vbr_scale, track.bitrate, track.samplerate, track.samplesize, track.channels, track.block_alignment, track.endian, track.bpm, track.tagversion, track.drm, track.musicmagic_mixable, track.musicbrainz_id, track.playcount, track.lastplayed, track.lossless, track.lyrics, track.rating, track.replay_gain, track.replay_peak FROM playlist_track me  JOIN tracks track ON ( track.id = me.track ) WHERE ( me.playlist = ? ) ORDER BY me.position: '21094'
[08-01-06 21:18:09.2349] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, 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.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 ( url = ? ): 'loop://www.squeezenetwork.com:3000/static/sounds/natural/hard_rain_thunder.mp3'
[08-01-06 21:18:09.9824] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, 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.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 ( url = ? ): 'clientplaylist://00:04:20:10:02:77'
[08-01-06 21:18:10.0523] Slim::Schema::Debug::query_start (26) DELETE FROM playlist_track WHERE ( playlist = ? ): '21094'
[08-01-06 21:18:10.1083] Slim::Schema::Debug::query_start (26) INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?): '21094', '0', '21114'
[08-01-06 21:18:10.3852] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, 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.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 ( url = ? ): 'clientplaylist://00:04:20:10:02:77'
[08-01-06 21:18:10.3973] Slim::Schema::Debug::query_start (26) DELETE FROM playlist_track WHERE ( playlist = ? ): '21094'
[08-01-06 21:18:10.4025] Slim::Schema::Debug::query_start (26) INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?): '21094', '0', '21114'
[08-01-06 21:18:10.4379] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:15.0005] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:17.1410] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (142) levelMap: { album => "track", contributor => "album", genre => "contributor" }
[08-01-06 21:18:17.1423] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (143) filters : {}
[08-01-06 21:18:17.1436] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (189) find: {}
[08-01-06 21:18:17.1448] Slim::Schema::ResultSet::Base::descend (202) $self->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:17.1459] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Genre]
[08-01-06 21:18:17.1470] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:17.1482] Slim::Schema::ResultSet::Base::descend (235) Calling method: [browse]
[08-01-06 21:18:17.1515] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM genres me: 
[08-01-06 21:18:17.1569] Slim::Schema::Debug::query_start (26) SELECT LEFT(me.namesort, 1), COUNT( DISTINCT(me.id) ) FROM genres me GROUP BY LEFT(me.namesort, 1) ORDER BY me.namesort: 
[08-01-06 21:18:17.5786] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me GROUP BY me.id ORDER BY me.namesort LIMIT 51: 
[08-01-06 21:18:17.8458] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:17.8576] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1'
[08-01-06 21:18:17.9897] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM albums me: 
[08-01-06 21:18:18.0015] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
[08-01-06 21:18:18.2504] Slim::Web::Pages::addLibraryStats (192) Found 21065 songs, 1584 albums & 674 artists
[08-01-06 21:18:22.9948] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:23.2735] Slim::Networking::SqueezeNetwork::PrefSync::_syncDown_error (260) Sync Down failed: No such player: 00:04:20:10:02:77, will retry in 11010
[08-01-06 21:18:23.2853] Slim::Networking::SqueezeNetwork::PrefSync::_syncDown_error (260) Sync Down failed: No such player: 00:04:20:06:df:46, will retry in 11130
[08-01-06 21:18:25.5317] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:27.9355] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me WHERE ( me.id = ? ): '8'
[08-01-06 21:18:27.9553] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (142) levelMap: { album => "track", contributor => "album", genre => "contributor" }
[08-01-06 21:18:27.9569] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (143) filters : { "genre.id" => 8 }
[08-01-06 21:18:27.9580] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (175) Working on levelname: [genre]
[08-01-06 21:18:27.9599] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (189) find: { contributor => { "me.id" => 8 } }
[08-01-06 21:18:27.9611] Slim::Schema::ResultSet::Base::descend (202) $self->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:27.9622] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Genre]
[08-01-06 21:18:27.9633] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:27.9644] Slim::Schema::ResultSet::Base::descend (235) Calling method: [browse]
[08-01-06 21:18:27.9659] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Contributor]
[08-01-06 21:18:27.9670] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Contributor]
[08-01-06 21:18:27.9681] Slim::Schema::ResultSet::Base::descend (243) Calling method: [descendContributor]
[08-01-06 21:18:27.9816] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( contributor.id ) ) FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ): '1', '5', '0', '8'
[08-01-06 21:18:29.9380] Slim::Schema::Debug::query_start (26) SELECT LEFT(contributor.namesort, 1), COUNT( DISTINCT(contributor.id) ) FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ) GROUP BY LEFT(contributor.namesort, 1) ORDER BY contributor.namesort: '1', '5', '0', '8'
[08-01-06 21:18:30.1106] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) WHERE ( genreTracks.genre = ? AND me.compilation = ? ): '8', '1'
[08-01-06 21:18:30.3452] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'VARIOUS ARTISTS'
[08-01-06 21:18:30.5569] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ) GROUP BY contributor.id ORDER BY contributor.namesort LIMIT 57: '1', '5', '0', '8'
[08-01-06 21:18:30.7069] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:30.9598] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( track_2.id ) ) FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) LEFT JOIN contributor_track contributorTracks_2 ON ( contributorTracks_2.contributor = contributor.id )  JOIN tracks track_2 ON ( track_2.id = contributorTracks_2.track ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ): '1', '5', '0', '8'
[08-01-06 21:18:32.3911] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( album_2.id ) ) FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = contributor.id )  JOIN albums album_2 ON ( album_2.id = contributorAlbums.album ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ): '1', '5', '0', '8'
[08-01-06 21:18:34.5317] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( contributor.id ) ) FROM genres me LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  JOIN tracks track ON ( track.id = genreTracks.track )  JOIN albums album ON ( album.id = track.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( ( ( ( ( contributorTracks.role IN ( ?, ? ) ) AND ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AND ( me.id = ? ) ) ) ) ) ) ): '1', '5', '0', '8'
[08-01-06 21:18:35.0942] Slim::Web::Pages::addLibraryStats (192) Found 1604 songs, 192 albums & 60 artists
[08-01-06 21:18:39.0768] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:39.2329] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:41.7551] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:44.5578] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me WHERE ( me.id = ? ): '8'
[08-01-06 21:18:44.5641] Slim::Schema::Debug::query_start (26) SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( me.id = ? ): '29'
[08-01-06 21:18:44.5824] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (142) levelMap: { album => "track", contributor => "album", genre => "contributor" }
[08-01-06 21:18:44.5840] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (143) filters : { "album.compilation" => 1, "genre.id" => 8 }
[08-01-06 21:18:44.5852] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (175) Working on levelname: [genre]
[08-01-06 21:18:44.5863] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (175) Working on levelname: [album]
[08-01-06 21:18:44.5884] Slim::Schema::ResultSet::Base::generateConditionsFromFilters (189) find: { contributor => { "me.id" => 8 }, track => { "me.compilation" => 1 } }
[08-01-06 21:18:44.5896] Slim::Schema::ResultSet::Base::descend (202) $self->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:44.5907] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Genre]
[08-01-06 21:18:44.5919] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Genre]
[08-01-06 21:18:44.5930] Slim::Schema::ResultSet::Base::descend (235) Calling method: [browse]
[08-01-06 21:18:44.5945] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Contributor]
[08-01-06 21:18:44.5956] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Contributor]
[08-01-06 21:18:44.5967] Slim::Schema::ResultSet::Base::descend (243) Calling method: [descendContributor]
[08-01-06 21:18:44.6023] Slim::Schema::ResultSet::Base::descend (225) Working on level: [Album]
[08-01-06 21:18:44.6034] Slim::Schema::ResultSet::Base::descend (227) $self->result_source->schema->source($level)->result_class: [Slim::Schema::Album]
[08-01-06 21:18:44.6046] Slim::Schema::ResultSet::Base::descend (243) Calling method: [descendAlbum]
[08-01-06 21:18:44.6060] Slim::Schema::ResultSet::Base::fixupSortKeys (91) fixupSortKeys: fixed: [album.titlesort]
[08-01-06 21:18:44.6072] Slim::Schema::ResultSet::Base::fixupSortKeys (92) fixupSortKeys  into : [concat('0', album.titlesort)]
[08-01-06 21:18:44.6153] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ): '1', '8', '1', '5', '6'
[08-01-06 21:18:46.0161] Slim::Schema::Debug::query_start (26) SELECT LEFT(album.titlesort, 1), COUNT( DISTINCT(album.id) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY LEFT(album.titlesort, 1) ORDER BY concat('0', album.titlesort): '1', '8', '1', '5', '6'
[08-01-06 21:18:47.4903] Slim::Schema::Debug::query_start (26) SELECT album.id, album.titlesort, album.contributor, album.compilation, album.year, album.artwork, album.disc, album.discc, album.musicmagic_mixable, album.titlesearch, album.replay_gain, album.replay_peak, album.musicbrainz_id, album.title FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY album.id ORDER BY concat('0', album.titlesort) LIMIT 27: '1', '8', '1', '5', '6'
[08-01-06 21:18:49.1539] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1456'
[08-01-06 21:18:49.3596] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1458'
[08-01-06 21:18:49.5769] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1126'
[08-01-06 21:18:49.7948] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1476'
[08-01-06 21:18:49.9964] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1477'
[08-01-06 21:18:50.1976] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1478'
[08-01-06 21:18:50.4008] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1479'
[08-01-06 21:18:50.6035] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1480'
[08-01-06 21:18:50.8028] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1481'
[08-01-06 21:18:51.0073] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1490'
[08-01-06 21:18:51.2115] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1539'
[08-01-06 21:18:51.2420] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '108'
[08-01-06 21:18:51.3713] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1128'
[08-01-06 21:18:51.3993] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1500'
[08-01-06 21:18:51.4250] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1501'
[08-01-06 21:18:51.4502] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1502'
[08-01-06 21:18:51.4697] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1504'
[08-01-06 21:18:51.5156] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1505'
[08-01-06 21:18:51.5315] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1506'
[08-01-06 21:18:51.5485] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1507'
[08-01-06 21:18:51.5668] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '988'
[08-01-06 21:18:51.5876] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '989'
[08-01-06 21:18:51.6044] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '986'
[08-01-06 21:18:51.6250] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1513'
[08-01-06 21:18:51.6470] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1509'
[08-01-06 21:18:51.6649] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1532'
[08-01-06 21:18:51.6890] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me  JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '5', '1536'
[08-01-06 21:18:51.7002] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:18:51.7143] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( tracks_2.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) LEFT JOIN tracks tracks_2 ON ( tracks_2.album = album.id ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ): '1', '8', '1', '5', '6'
[08-01-06 21:18:53.1880] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ): '1', '8', '1', '5', '6'
[08-01-06 21:18:54.9692] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( contributor.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) LEFT JOIN tracks tracks ON ( tracks.album = album.id ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = tracks.id ) LEFT JOIN contributor_album contributorAlbums_2 ON ( contributorAlbums_2.album = album.id )  JOIN contributors contributor ON ( contributor.id = contributorAlbums_2.contributor ) WHERE ( ( ( album.compilation = ? AND genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ?, ? ) ) ) ): '1', '8', '1', '5', '6'
[08-01-06 21:20:47.2500] Slim::Web::Pages::addLibraryStats (192) Found 252 songs, 27 albums & 152 artists
[08-01-06 21:20:49.4203] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:49.5419] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:49.5777] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:49.6152] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:50.2323] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:50.2375] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM albums me: 
[08-01-06 21:20:50.2489] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
[08-01-06 21:20:50.2776] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM genres me: 
[08-01-06 21:20:50.2838] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1'
[08-01-06 21:20:50.7196] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:54.2192] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:20:59.3189] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:04.3361] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:09.3634] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:14.3731] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:19.1711] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:19.1765] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM albums me: 
[08-01-06 21:21:19.1848] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
[08-01-06 21:21:19.2097] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM genres me: 
[08-01-06 21:21:19.2154] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1'
[08-01-06 21:21:19.4164] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:24.3754] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:29.3911] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:34.4067] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:39.4067] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:44.4223] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:49.1846] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:49.1898] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM albums me: 
[08-01-06 21:21:49.1984] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
[08-01-06 21:21:49.2227] Slim::Schema::Debug::query_start (26) SELECT COUNT( * ) FROM genres me: 
[08-01-06 21:21:49.2285] Slim::Schema::Debug::query_start (26) SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1'
[08-01-06 21:21:54.4379] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:21:59.4379] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:22:04.4464] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:22:09.4504] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:22:16.3515] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
[08-01-06 21:22:21.3575] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'