Profiler information for a page

Ik maak gebruik van Redis.

• 0.000 134µs

  fs

  Opening profiler sock
• 0.000 350µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060127-Weo9B-KX"}
• 0.001 124µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060127-Weo9B-KX"}
• 0.019 1.936ms

  db

  (Re)initializing SQL
• 0.021 505.9µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.023 154µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060127-Weo9B-KX"}
• 0.023 46.01µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-060127-Weo9B-KX"}
• 0.024 88ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.024 953.9µs
    Begin section Songs::extra(0)...
    • 0.024 672.1µ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.025 1.343ms
    Begin section Songs::top2000(0)...
    • 0.025 1.144ms

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.027 2.335ms
    Begin section Songs::mp3(0, )...
    • 0.027 1.972ms

      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.029 78.66ms

    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.112 1.11ms
  Begin section Songs::totals()...
  • 0.112 1.048ms

    db

    Called from: lib/sweepee.inc:1941

    SELECT COUNT(*) FROM songinfo WHERE id > 0 AND idee=0 GROUP BY active=0,active=1 ORDER BY active DESC /*Songs::totals*/;

    OK. Rows = 2
  End section Songs::totals()
• 0.114 75.95ms
  Begin section Songs::info()...

  options: {"term":"Cheap+Trick","excludeExtras":false}

  options: {"term":"Cheap+Trick","excludeExtras":false}

  • 0.114 1.886ms
    Begin section Songs::mp3(0, )...
    • 0.114 1.582ms

      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.116 68.23ms

    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()