API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 6th, 2013
146
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.56 KB | None | 0 0
raw download clone embed print report
  1. 12:14:32 T:2941801536 DEBUG: RunQuery took 2027 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
  2. 12:14:40 T:2941801536 DEBUG: RunQuery took 6865 ms for 12644 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
  3. 12:14:47 T:2941801536 DEBUG: RunQuery took 5 ms for 0 items query: select * from musicvideoview
  4. 12:14:51 T:2941801536 DEBUG: RunQuery took 46 ms for 14 items query: select * from movieview WHERE (movieview.idFile IN (SELECT DISTINCT idFile FROM bookmark WHERE type = 1))
  5. 12:14:52 T:2941801536 DEBUG: RunQuery took 166 ms for 83 items query: SELECT * FROM tvshowview WHERE ( ((tvshowview.watchedcount > 0 AND tvshowview.watchedcount < tvshowview.totalCount) OR (tvshowview.watchedcount = 0 AND EXISTS (SELECT 1 FROM episodeview WHERE episodeview.idShow = tvshowview.idShow AND episodeview.resumeTimeInSeconds > 0))))
  6. 12:14:53 T:2941801536 DEBUG: RunQuery took 7 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 342) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  7. 12:14:53 T:2941801536 DEBUG: RunQuery took 10 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 295) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  8. 12:14:53 T:2941801536 DEBUG: RunQuery took 60 ms for 104 items query: select * from episodeview WHERE (episodeview.idShow = 144) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  9. 12:14:53 T:2941801536 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:14:53 T:2941801536 DEBUG: RunQuery took 9 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 210) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  11. 12:14:54 T:2941801536 DEBUG: RunQuery took 11 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 350) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  12. 12:14:54 T:2941801536 DEBUG: RunQuery took 16 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 319) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  13. 12:14:54 T:2941801536 DEBUG: RunQuery took 9 ms for 6 items query: select * from episodeview WHERE (episodeview.idShow = 180) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  14. 12:14:54 T:2941801536 DEBUG: RunQuery took 10 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 153) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  15. 12:14:54 T:2941801536 DEBUG: RunQuery took 9 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 80) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  16. 12:14:55 T:2941801536 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:14:55 T:2941801536 DEBUG: RunQuery took 7 ms for 1 items query: select * from episodeview WHERE (episodeview.idShow = 375) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  18. 12:14:55 T:2941801536 DEBUG: RunQuery took 45 ms for 59 items query: select * from episodeview WHERE (episodeview.idShow = 225) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  19. 12:14:55 T:2941801536 DEBUG: RunQuery took 15 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 254) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  20. 12:14:55 T:2941801536 DEBUG: RunQuery took 12 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 218) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  21. 12:14:56 T:2941801536 DEBUG: RunQuery took 9 ms for 4 items query: select * from episodeview WHERE (episodeview.idShow = 162) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  22. 12:14:56 T:2941801536 DEBUG: RunQuery took 11 ms for 2 items query: select * from episodeview WHERE (episodeview.idShow = 316) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  23. 12:14:56 T:2941801536 DEBUG: RunQuery took 8 ms for 5 items query: select * from episodeview WHERE (episodeview.idShow = 379) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  24. 12:14:56 T:2941801536 DEBUG: RunQuery took 12 ms for 4 items query: select * from episodeview WHERE (episodeview.idShow = 353) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  25. 12:14:56 T:2941801536 DEBUG: RunQuery took 35 ms for 72 items query: select * from episodeview WHERE (episodeview.idShow = 244) AND (((episodeview.playCount IS NULL OR episodeview.playCount = 0)))
  26. 12:14:56 T:2941801536 DEBUG: RunQuery took 4 ms for 0 items query: select * from musicvideoview
  27. 12:15:00 T:2941801536 DEBUG: RunQuery took 3320 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount = 0))
  28. 12:15:11 T:2941801536 DEBUG: RunQuery took 7146 ms for 12644 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
  29. 12:17:02 T:2941801536 DEBUG: RunQuery took 5 ms for 0 items query: select * from musicvideoview
  30. 12:17:07 T:2941801536 DEBUG: RunQuery took 2351 ms for 1357 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
  31. 12:17:07 T:2924491840 DEBUG: RunQuery took 64 ms for 10 items query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
  32. 12:17:07 T:2924491840 DEBUG: RunQuery took 304 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
  33. 12:17:07 T:2924491840 DEBUG: RunQuery took 9 ms for 0 items query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
  34. 12:17:08 T:2924491840 DEBUG: RunQuery took 94 ms for 10 items query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
  35. 12:17:09 T:2924491840 DEBUG: RunQuery took 318 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
  36. 12:17:14 T:2924491840 DEBUG: RunQuery took 75 ms for 0 items query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
  37. 12:17:15 T:2941801536 DEBUG: RunQuery took 6575 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!