API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 6th, 2013
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.61 KB | None | 0 0
raw download clone embed print report
  1. 12:23:16 T:2941252672 DEBUG: RunQuery took 1849 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
  2. 12:23:24 T:2941252672 DEBUG: RunQuery took 6823 ms for 12644 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
  3. 12:23:30 T:2941252672 DEBUG: RunQuery took 4 ms for 0 items query: select * from musicvideoview
  4. 12:23:31 T:2941252672 DEBUG: RunQuery took 54 ms for 14 items query: select * from movieview WHERE (movieview.idFile IN (select idFile from bookmark where type = 1))
  5. 12:23:47 T:2941252672 DEBUG: RunQuery took 14483 ms for 83 items query: SELECT * FROM tvshowview WHERE (tvshowview.idShow IN (select tvshowview.idShow from tvshowview where (watchedcount > 0 AND watchedcount < totalCount) OR (watchedcount = 0 AND tvshowview.idShow IN (select episodeview.idShow from episodeview WHERE episodeview.idShow = tvshowview.idShow AND episodeview.resumeTimeInSeconds > 0))))
  6. 12:23:47 T:2941252672 DEBUG: RunQuery took 8 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 342) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  7. 12:23:47 T:2941252672 DEBUG: RunQuery took 15 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 295) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  8. 12:23:47 T:2941252672 DEBUG: RunQuery took 46 ms for 104 items query: select * from episodeview WHERE (episodeview.idShow = 144) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  9. 12:23:48 T:2941252672 DEBUG: RunQuery took 16 ms for 7 items query: select * from episodeview WHERE (episodeview.idShow = 376) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  10. 12:23:48 T:2941252672 DEBUG: RunQuery took 8 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 210) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  11. 12:23:48 T:2941252672 DEBUG: RunQuery took 14 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 350) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  12. 12:23:49 T:2941252672 DEBUG: RunQuery took 15 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 319) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  13. 12:23:49 T:2941252672 DEBUG: RunQuery took 11 ms for 6 items query: select * from episodeview WHERE (episodeview.idShow = 180) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  14. 12:23:49 T:2941252672 DEBUG: RunQuery took 8 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 153) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  15. 12:23:49 T:2941252672 DEBUG: RunQuery took 6 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 80) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  16. 12:23:49 T:2941252672 DEBUG: RunQuery took 10 ms for 2 items query: select * from episodeview WHERE (episodeview.idShow = 105) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  17. 12:23:49 T:2941252672 DEBUG: RunQuery took 5 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 375) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  18. 12:23:50 T:2941252672 DEBUG: RunQuery took 44 ms for 59 items query: select * from episodeview WHERE (episodeview.idShow = 225) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  19. 12:23:50 T:2941252672 DEBUG: RunQuery took 12 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 254) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  20. 12:23:50 T:2941252672 DEBUG: RunQuery took 15 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 218) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  21. 12:23:50 T:2941252672 DEBUG: RunQuery took 14 ms for 4 items query: select * from episodeview WHERE (episodeview.idShow = 162) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  22. 12:23:50 T:2941252672 DEBUG: RunQuery took 12 ms for 2 items query: select * from episodeview WHERE (episodeview.idShow = 316) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  23. 12:23:51 T:2941252672 DEBUG: RunQuery took 13 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 379) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  24. 12:23:51 T:2941252672 DEBUG: RunQuery took 14 ms for 4 items query: select * from episodeview WHERE (episodeview.idShow = 353) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  25. 12:23:51 T:2941252672 DEBUG: RunQuery took 38 ms for 72 items query: select * from episodeview WHERE (episodeview.idShow = 244) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  26. 12:23:51 T:2941252672 DEBUG: RunQuery took 5 ms for 0 items query: select * from musicvideoview
  27. 12:23:53 T:2941252672 DEBUG: RunQuery took 1829 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount = 0))
  28. 12:24:03 T:2941252672 DEBUG: RunQuery took 6970 ms for 12644 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
  29. 12:24:17 T:2941252672 DEBUG: RunQuery took 6 ms for 0 items query: select * from musicvideoview
  30. 12:24:21 T:2924209216 DEBUG: RunQuery took 83 ms for 10 items query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
  31. 12:24:21 T:2941252672 DEBUG: RunQuery took 2102 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
  32. 12:24:22 T:2924209216 DEBUG: RunQuery took 300 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
  33. 12:24:22 T:2924209216 DEBUG: RunQuery took 9 ms for 0 items query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
  34. 12:24:23 T:2969039936 DEBUG: RunQuery took 68 ms for 10 items query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
  35. 12:24:23 T:2969039936 DEBUG: RunQuery took 367 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
  36. 12:24:28 T:2969039936 DEBUG: RunQuery took 52 ms for 0 items query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
  37. 12:24:32 T:2941252672 DEBUG: RunQuery took 8957 ms for 12644 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!