I think this is the log you asked for?
Code:
--------------------
[16-07-05 17:13:24.5619] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:29.4370] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:30.5766] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:35.4528] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:36.5933] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:38.8880] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me ORDER
BY namesort COLLATE en_US :
[16-07-05 17:13:41.1733] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:42.6245] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:46.2184] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:48.6557] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:50.4295] Slim::Schema::Debug::query_start (23) SELECT COUNT(
* ) FROM (SELECT me.id FROM tracks me LEFT JOIN genre_track genreTracks ON
genreTracks.track = me.id WHERE ( ( genre NOT IN ( SELECT me.id FROM genres me
WHERE ( me.namesearch LIKE ? ) ) AND me.audio = ? ) ) GROUP BY me.id)
count_subq: '%KERSTMIS%', '1'
[16-07-05 17:13:51.2744] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.urlmd5, me.url, me.content_type, me.title, me.titlesort, me.titlesearch,
me.album, me.primary_artist, me.tracknum, me.timestamp, me.added_time,
me.updated_time, me.filesize, me.disc, me.remote, me.audio, me.audio_size,
me.audio_offset, me.year, me.secs, me.cover, me.cover_cached, 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.dlna_profile, me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain,
me.replay_peak, me.extid, me.virtual, me.coverid FROM tracks me LEFT JOIN
genre_track genreTracks ON genreTracks.track = me.id WHERE ( ( genre NOT IN (
SELECT me.id FROM genres me WHERE ( me.namesearch LIKE ? ) ) AND me.audio = ? )
) GROUP BY me.id ORDER BY me.disc, me.titlesort COLLATE en_US LIMIT 50:
'%KERSTMIS%', '1'
[16-07-05 17:13:56.2434] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me ORDER
BY namesort COLLATE en_US :
[16-07-05 17:13:57.0939] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:13:57.1266] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:01.3120] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:02.6870] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:06.4214] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:08.7027] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:12.4187] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:14.7182] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:18.4340] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
[16-07-05 17:14:20.7623] Slim::Control::Queries::_getTagDataForTracks (5562)
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN
(214019) / []
--------------------
I am using Lazysearch. Other plugins I expect don't use the database too
much.
> > - if I get this to work, how do I exclude multiple genres? Seperate
> > with comma and space?
>
> This currently is not supported.
Is there a way to enter some raw SQL instead of the form? I could
probably manage that. If not I'll just have to add an additional 'avoid'
tag to all special tracks.
Thanks for your efforts. I went from 7.7 over 7.8 to 7.9 in the last few
months and the improvements in speed and usability are quite remarkable!
------------------------------------------------------------------------
nenu's Profile: http://forums.slimdevices.com/member.php?userid=65867
View this thread: http://forums.slimdevices.com/showthread.php?t=105835
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
