Profiler information for a page

Ik maak gebruik van Redis.

• 0.000 176.9µs

  fs

  Opening profiler sock
• 0.000 411µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060546-aMiPf8M_"}
• 0.001 121.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060546-aMiPf8M_"}
• 0.024 1.666ms

  db

  (Re)initializing SQL
• 0.025 494µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.027 185µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060546-aMiPf8M_"}
• 0.027 66.04µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060546-aMiPf8M_"}
• 0.029 78.44ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.029 993µs
    Begin section Songs::extra(0)...
    • 0.029 638µs

      db

      Called from: lib/sweepee.inc:942

      SELECT * FROM song_extra WHERE `admin-only` = 0

      OK. Rows = 13
    End section Songs::extra(0)
  • 0.030 1.291ms
    Begin section Songs::top2000(0)...
    • 0.030 966.8µs

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.031 2.54ms
    Begin section Songs::mp3(0, )...
    • 0.031 1.939ms

      db

      Called from: lib/sweepee.inc:1845

      SELECT mp3.mp3id, mp3.filesize, mp3.songid, mp3.sweepeesong, mp3.albumid, mp3.track, mp3.url, mp3.info, mp3.gepubliceerd, mp3.hash, s.id, s.title, s.artist, s.orgartist, s.writtenby,s. album, s.active, s.year, s.addDate, s.idee, s.slug, a.info AS albuminfo, IFNULL(a.title, '') AS albumtitle, IFNULL(a.mp3albumid,0) AS mp3albumid, IFNULL(a.year,0) AS albumyear, a.fsname FROM sweatypants.mp3 LEFT JOIN sweatypants.songinfo s ON( s.id = mp3.songid) LEFT JOIN sweatypants.mp3album a ON(a.mp3albumid = mp3.albumid) ORDER BY IFNULL(a.year, YEAR(NOW())) DESC, a.title, track, s.addDate DESC /* 0 */

      OK. Rows = 60
    End section Songs::mp3(0, )
  • 0.034 69.18ms

    db

    Called from: lib/sweepee.inc:1585

    SELECT s.id, s.id AS songId, s.title, s.artist, s.orgartist, s.writtenby, s.album, s.lyrics, s.`active`, s.`type`, s.`year`, s.addDate, IFNULL(s.toonsoort,'') AS toonsoort, s.idee, s.user, s.deleted, s.slug, COALESCE(`user`.`firstname`, ou.first_name) AS user_firstname, COUNT(ideevote.vote) AS votes, AVG(ideevote.vote) AS avg, COUNT(ideevote.vote)+avg(ideevote.vote) as weight, IFNULL(GROUP_CONCAT( song_top2000.year,':',song_top2000.rank ),'') AS top2000 FROM songinfo s LEFT JOIN sweatypants.`user` ON (`user`.`username` = s.user) LEFT JOIN sweatypants.oauth_users ou ON (ou.email = s.user) LEFT JOIN sweatypants.song_top2000 ON ( song_top2000.songId = s.id ) LEFT JOIN sweatypants.ideevote ON s.id = ideevote.songId WHERE s.id > 0 GROUP BY s.id ORDER BY s.artist,s.title

    OK. Rows = 383
  End section Songs::info()
• 0.107 112.4ms
  Begin section Songs::info()...

  options: {"orderBy":"s.year,s.title,s.artist","excludeExtras":1,"excludeIdee":1}

  options: {"orderBy":"s.year,s.title,s.artist","excludeExtras":1,"excludeIdee":1}

  • 0.107 2.275ms
    Begin section Songs::mp3(0, )...
    • 0.107 1.962ms

      db

      Called from: lib/sweepee.inc:1845

      SELECT mp3.mp3id, mp3.filesize, mp3.songid, mp3.sweepeesong, mp3.albumid, mp3.track, mp3.url, mp3.info, mp3.gepubliceerd, mp3.hash, s.id, s.title, s.artist, s.orgartist, s.writtenby,s. album, s.active, s.year, s.addDate, s.idee, s.slug, a.info AS albuminfo, IFNULL(a.title, '') AS albumtitle, IFNULL(a.mp3albumid,0) AS mp3albumid, IFNULL(a.year,0) AS albumyear, a.fsname FROM sweatypants.mp3 LEFT JOIN sweatypants.songinfo s ON( s.id = mp3.songid) LEFT JOIN sweatypants.mp3album a ON(a.mp3albumid = mp3.albumid) ORDER BY IFNULL(a.year, YEAR(NOW())) DESC, a.title, track, s.addDate DESC /* 0 */

      OK. Rows = 60
    End section Songs::mp3(0, )
  • 0.110 106.6ms

    db

    Called from: lib/sweepee.inc:1585

    SELECT s.id, s.id AS songId, s.title, s.artist, s.orgartist, s.writtenby, s.album, s.lyrics, s.`active`, s.`type`, s.`year`, s.addDate, IFNULL(s.toonsoort,'') AS toonsoort, s.idee, s.user, s.deleted, s.slug, COALESCE(`user`.`firstname`, ou.first_name) AS user_firstname, COUNT(ideevote.vote) AS votes, AVG(ideevote.vote) AS avg, COUNT(ideevote.vote)+avg(ideevote.vote) as weight, IFNULL(GROUP_CONCAT( song_top2000.year,':',song_top2000.rank ),'') AS top2000 FROM songinfo s LEFT JOIN sweatypants.`user` ON (`user`.`username` = s.user) LEFT JOIN sweatypants.oauth_users ou ON (ou.email = s.user) LEFT JOIN sweatypants.song_top2000 ON ( song_top2000.songId = s.id ) LEFT JOIN sweatypants.ideevote ON s.id = ideevote.songId WHERE s.id > 0 GROUP BY s.id ORDER BY s.year,s.title,s.artist

    OK. Rows = 383
  End section Songs::info()
• 0.220 1.205ms

  db

  Called from: pages/timeline.inc:6

  SELECT `year`,COUNT(`year`) AS aantal FROM sweatypants.songinfo WHERE idee=0 AND IFNULL(`year`,0) > 0 GROUP BY `year`

  OK. Rows = 54