The log file being so huge it to do with millions of entries that are all like -
Code:
17:07:57 T:107827200 DEBUG: RunQuery took 39 ms for 40 items query: select * from episodeview where idShow IN (154,227,342) and (c12=2 or (c12=0 and (c15=0 or c15=2)))
17:07:57 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:57 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:57 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=154) order by idShow
17:07:57 T:107827200 DEBUG: RunQuery took 43 ms for 52 items query: select * from episodeview where idShow IN (154,227,342) and (c12=3 or (c12=0 and (c15=0 or c15=3)))
17:07:58 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:58 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:58 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow
17:07:58 T:107827200 DEBUG: RunQuery took 5 ms for 3 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow IN (155,228,343) group by episode.c12
17:07:58 T:107827200 DEBUG: RunQuery took 4 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow IN (155,228,343)
17:07:58 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:58 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow
17:07:58 T:107827200 DEBUG: RunQuery took 5 ms for 0 items query: select * from episodeview where idShow IN (155,228,343) and c12=0
17:07:58 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:58 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:58 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow
17:07:58 T:107827200 DEBUG: RunQuery took 8 ms for 12 items query: select * from episodeview where idShow IN (155,228,343) and (c12=1 or (c12=0 and (c15=0 or c15=1)))
17:07:59 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:59 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:59 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow
17:07:59 T:107827200 DEBUG: RunQuery took 29 ms for 14 items query: select * from episodeview where idShow IN (155,228,343) and (c12=2 or (c12=0 and (c15=0 or c15=2)))
17:07:59 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:59 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:59 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow
17:07:59 T:107827200 DEBUG: RunQuery took 6 ms for 1 items query: select * from episodeview where idShow IN (155,228,343) and (c12=3 or (c12=0 and (c15=0 or c15=3)))
17:07:59 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:59 T:107827200 DEBUG: Previous line repeats 1 times.
17:07:59 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow
17:07:59 T:107827200 DEBUG: RunQuery took 7 ms for 3 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = 296 group by episode.c12
17:07:59 T:107827200 DEBUG: RunQuery took 2 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow = 296
17:07:59 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:07:59 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow
17:07:59 T:107827200 DEBUG: RunQuery took 25 ms for 0 items query: select * from episodeview where idShow = 296 and c12=0
17:07:59 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:00 T:107827200 DEBUG: Previous line repeats 1 times.
17:08:00 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow
17:08:00 T:107827200 DEBUG: RunQuery took 30 ms for 24 items query: select * from episodeview where idShow = 296 and (c12=1 or (c12=0 and (c15=0 or c15=1)))
17:08:00 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:00 T:107827200 DEBUG: Previous line repeats 1 times.
17:08:00 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow
17:08:00 T:107827200 DEBUG: RunQuery took 11 ms for 24 items query: select * from episodeview where idShow = 296 and (c12=2 or (c12=0 and (c15=0 or c15=2)))
17:08:00 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:01 T:107827200 DEBUG: Previous line repeats 1 times.
17:08:01 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow
17:08:01 T:107827200 DEBUG: RunQuery took 8 ms for 7 items query: select * from episodeview where idShow = 296 and (c12=3 or (c12=0 and (c15=0 or c15=3)))
17:08:01 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:01 T:107827200 DEBUG: Previous line repeats 1 times.
17:08:01 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow
17:08:01 T:107827200 DEBUG: RunQuery took 35 ms for 8 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = 297 group by episode.c12
17:08:01 T:107827200 DEBUG: RunQuery took 22 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow = 297
17:08:01 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:01 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow
17:08:01 T:107827200 DEBUG: RunQuery took 6 ms for 0 items query: select * from episodeview where idShow = 297 and c12=0
17:08:01 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:01 T:107827200 DEBUG: Previous line repeats 1 times.
17:08:01 T:107827200 DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow
17:08:01 T:107827200 DEBUG: RunQuery took 31 ms for 11 items query: select * from episodeview where idShow = 297 and (c12=1 or (c12=0 and (c15=0 or c15=1)))
17:08:01 T:107827200 DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db
17:08:01 T:107827200 DEBUG: Previous line repeats 1 times.