JSON Request (movies: title, art, file), limits: 0:35 00:21:25 25125.871094 T:2845832272 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "params": {"sort": {"order": "ascending", "method": "title"}, "properties": ["title", "art", "file"], "limits": {"start": 0, "end": 35}}, "method": "VideoLibrary.GetMovies", "id": "libMovies"} MySQL Queries: 140224 0:22:30 92838 Connect xbmc@192.168.0.8 on 92838 Query SET NAMES utf8 92838 Query show databases like 'MyVideos78' 92838 Query show tables 92838 Init DB MyVideos78 92838 Query show databases like 'MyVideos78' 92838 Query show tables 92838 Query select * from movieview 140224 0:22:31 92839 Connect xbmc@192.168.0.8 on 92839 Query SET NAMES utf8 92839 Query show databases like 'MyVideos78' 92839 Query show tables 92839 Init DB MyVideos78 92839 Query show databases like 'MyVideos78' 92839 Query show tables 92839 Query SELECT type,url FROM art WHERE media_id=1 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=358 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=295 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=635 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=2 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=3 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=428 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=4 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=5 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=6 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=7 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=8 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=9 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=10 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=636 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=637 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=725 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=611 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=12 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=413 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=621 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=467 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=638 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=622 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=671 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=721 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=13 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=313 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=315 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=316 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=314 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=341 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=429 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=332 AND media_type='movie' 92839 Query SELECT type,url FROM art WHERE media_id=14 AND media_type='movie' 92839 Quit 92838 Quit JSON Request (movies: title, art, file), limits: 35:70 00:21:27 25128.041016 T:2845832272 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "params": {"sort": {"order": "ascending", "method": "title"}, "properties": ["title", "art", "file"], "limits": {"start": 35, "end": 70}}, "method": "VideoLibrary.GetMovies", "id": "libMovies"} MySQL Queries: 92840 Connect xbmc@192.168.0.8 on 92840 Query SET NAMES utf8 92840 Query show databases like 'MyVideos78' 92840 Query show tables 92840 Init DB MyVideos78 92840 Query show databases like 'MyVideos78' 92840 Query show tables 92840 Query select * from movieview 140224 0:22:32 92841 Connect xbmc@192.168.0.8 on 92841 Query SET NAMES utf8 92841 Query show databases like 'MyVideos78' 92841 Query show tables 92841 Init DB MyVideos78 92841 Query show databases like 'MyVideos78' 92841 Query show tables 92841 Query SELECT type,url FROM art WHERE media_id=15 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=16 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=639 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=17 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=18 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=19 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=20 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=21 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=741 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=23 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=526 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=527 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=318 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=319 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=320 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=24 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=414 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=322 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=321 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=323 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=324 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=325 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=519 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=25 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=26 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=633 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=640 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=663 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=520 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=28 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=328 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=329 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=330 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=331 AND media_type='movie' 92841 Query SELECT type,url FROM art WHERE media_id=333 AND media_type='movie' 92841 Quit 92840 Quit