Profiler information for a page

Ik maak gebruik van Redis.

• 0.000 118µs

  fs

  Opening profiler sock
• 0.000 361.2µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055053-cW_VAN1M"}
• 0.001 109µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055053-cW_VAN1M"}
• 0.024 1.795ms

  db

  (Re)initializing SQL
• 0.026 612µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.028 180µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055053-cW_VAN1M"}
• 0.029 87.98µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055053-cW_VAN1M"}
• 0.030 117.2ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.030 1.169ms
    Begin section Songs::extra(0)...
    • 0.030 756µ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.032 1.997ms
    Begin section Songs::top2000(0)...
    • 0.032 1.674ms

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.034 3.204ms
    Begin section Songs::mp3(0, )...
    • 0.034 2.611ms

      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.037 104.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.artist,s.title

    OK. Rows = 383
  End section Songs::info()
• 0.148 1.218ms
  Begin section Songs::totals()...
  • 0.148 1.154ms

    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.149 105.4ms
  Begin section Songs::info()...

  options: {"term":"Rage+against+the+machine","excludeExtras":false}

  options: {"term":"Rage+against+the+machine","excludeExtras":false}

  • 0.149 2.322ms
    Begin section Songs::mp3(0, )...
    • 0.149 1.781ms

      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.151 96.86ms

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