Profiler information for a page

Ik maak gebruik van Redis.

• 0.000 107µs

  fs

  Opening profiler sock
• 0.000 366.9µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054738-HvyKM4Q3"}
• 0.000 112.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054738-HvyKM4Q3"}
• 0.022 1.571ms

  db

  (Re)initializing SQL
• 0.023 476.8µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.025 151.9µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054738-HvyKM4Q3"}
• 0.025 57.94µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054738-HvyKM4Q3"}
• 0.026 76.7ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.027 980.1µs
    Begin section Songs::extra(0)...
    • 0.027 652.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.028 5.319ms
    Begin section Songs::top2000(0)...
    • 0.028 874µs

      cache read

      Key: top2000-11111111-0207
    • 0.028 1.061ms

      db

      Called from: lib/sweepee.inc:1666

      SELECT DISTINCT songId, `year`, `rank` FROM sweatypants.song_top2000 WHERE songId > 0

      OK. Rows = 1154
    • 0.032 1.273ms

      cache write

      Key: [top2000-11111111-0207]; timeout: 3600s

      'top2000-11111111-0207': storing string '{"1":{"songId":1,"year":"2015","rank":370},"5":{"songId":5,"year":"2015","rank":1067},"7":{"songId":7,"year":"2015","rank":1046},"8":{"songId":8,"year":"2015","rank":1489},"9":{"songId":9,"year":"2015","rank":1028},"10":{"songId":10,"year":"2015","rank":676},"11":{"songId":11,"year":"2015","rank":1651},"12":{"songId":12,"year":"2015","rank":306},"14":{"songId":14,"year":"2015","rank":564},"25":{"songId":25,"year":"2015","rank":1096},"26":{"songId":26,"year":"2015","rank":1984},"29":{"songId":29,"year":"2015","rank":758},"30":{"songId":30,"year":"2015","rank":202},"31":{"songId":31,"year":"2013","rank":1911},"33":{"songId":33,"year":"2015","rank":16},"34":{"songId":34,"year":"2006","rank":1974},"35":{"songId":35,"year":"2015","rank":178},"36":{"songId":36,"year":"2015","rank":140},"37":{"songId":37,"year":"2015","rank":61},"38":{"songId":38,"year":"2015","rank":195},"39":{"songId":39,"year":"2015","rank":1414},"40":{"songId":40,"year":"2015","rank":665},"41":{"songId":41,"year":"2015","rank":927},"42":{"songId":42,"year":"2015","rank":112},"43":{"songId":43,"year":"2015","rank":117},"44":{"songId":44,"year":"2015","rank":1073},"45":{"songId":45,"year":"2015","rank":157},"46":{"songId":46,"year":"2015","rank":1012},"48":{"songId":48,"year":"2015","rank":522},"49":{"songId":49,"year":"2015","rank":66},"51":{"songId":51,"year":"2015","rank":217},"53":{"songId":53,"year":"2013","rank":1996},"54":{"songId":54,"year":"2015","rank":1318},"56":{"songId":56,"year":"2013","rank":1643},"57":{"songId":57,"year":"2015","rank":1928},"58":{"songId":58,"year":"2015","rank":1157},"61":{"songId":61,"year":"2004","rank":1970},"62":{"songId":62,"year":"2015","rank":180},"64":{"songId":64,"year":"2010","rank":1875},"68":{"songId":68,"year":"2015","rank":86},"70":{"songId":70,"year":"2015","rank":1546},"72":{"songId":72,"year":"2015","rank":1459},"74":{"songId":74,"year":"2015","rank":474},"80":{"songId":80,"year":"2015","rank":1449},"85":{"songId":85,"year":"2015","rank":250},"86":{"songId":86,"year":"2015","rank":172},"87":{"songId":87,"year":"2015","rank":219},"88":{"songId":88,"year":"2015","rank":1966},"90":{"songId":90,"year":"2015","rank":656},"91":{"songId":91,"year":"2015","rank":64},"96":{"songId":96,"year":"2015","rank":940},"97":{"songId":97,"year":"2015","rank":24},"100":{"songId":100,"year":"2015","rank":371},"102":{"songId":102,"year":"2015","rank":1626},"104":{"songId":104,"year":"2015","rank":635},"214":{"songId":214,"year":"2015","rank":132},"215":{"songId":215,"year":"2015","rank":119},"217":{"songId":217,"year":"2015","rank":1289},"218":{"songId":218,"year":"2015","rank":1933},"219":{"songId":219,"year":"2015","rank":1877},"220":{"songId":220,"year":"2015","rank":1268},"221":{"songId":221,"year":"2015","rank":735},"222":{"songId":222,"year":"2015","rank":1896},"224":{"songId":224,"year":"2015","rank":681},"231":{"songId":231,"year":"2007","rank":1984},"237":{"songId":237,"year":"2015","rank":640},"241":{"songId":241,"year":"2015","rank":318},"243":{"songId":243,"year":"2004","rank":1966},"245":{"songId":245,"year":"2015","rank":1398},"246":{"songId":246,"year":"2015","rank":397},"249":{"songId":249,"year":"2015","rank":803},"250":{"songId":250,"year":"2015","rank":503},"251":{"songId":251,"year":"2015","rank":819},"253":{"songId":253,"year":"2013","rank":1631},"254":{"songId":254,"year":"2015","rank":105},"258":{"songId":258,"year":"2015","rank":1999},"259":{"songId":259,"year":"2012","rank":1957},"260":{"songId":260,"year":"2015","rank":1192},"266":{"songId":266,"year":"2015","rank":805},"269":{"songId":269,"year":"2015","rank":604},"270":{"songId":270,"year":"2015","rank":1919},"271":{"songId":271,"year":"2015","rank":724},"273":{"songId":273,"year":"2015","rank":783},"274":{"songId":274,"year":"2015","rank":875},"276":{"songId":276,"year":"2015","rank":158},"278":{"songId":278,"year":"2015","rank":116},"280":{"songId":280,"year":"2015","rank":419},"281":{"songId":281,"year":"2015","rank":449},"285":{"songId":285,"year":"2015","rank":971},"287":{"songId":287,"year":"2015","rank":315},"289":{"songId":289,"year":"2015","rank":499},"290":{"songId":290,"year":"2015","rank":108},"291":{"songId":291,"year":"2015","rank":244},"292":{"songId":292,"year":"2015","rank":386},"300":{"songId":300,"year":"2015","rank":12},"301":{"songId":301,"year":"2015","rank":1529},"302":{"songId":302,"year":"2015","rank":1259},"311":{"songId":311,"year":"2013","rank":1708},"313":{"songId":313,"year":"2015","rank":1806},"314":{"songId":314,"year":"2015","rank":1052},"317":{"songId":317,"year":"2015","rank":1060},"325":{"songId":325,"year":"2015","rank":685},"326":{"songId":326,"year":"2015","rank":1082},"331":{"songId":331,"year":"2015","rank":1898},"340":{"songId":340,"year":"2015","rank":93},"344":{"songId":344,"year":"2015","rank":336},"348":{"songId":348,"year":"2015","rank":605},"349":{"songId":349,"year":"2015","rank":453},"351":{"songId":351,"year":"2015","rank":197},"353":{"songId":353,"year":"2015","rank":534},"354":{"songId":354,"year":"2015","rank":1693},"355":{"songId":355,"year":"2015","rank":601},"356":{"songId":356,"year":"2015","rank":1322},"359":{"songId":359,"year":"2015","rank":320},"361":{"songId":361,"year":"2015","rank":161},"362":{"songId":362,"year":"2009","rank":1737},"366":{"songId":366,"year":"2001","rank":1923},"368":{"songId":368,"year":"2015","rank":1029},"374":{"songId":374,"year":"2015","rank":164},"375":{"songId":375,"year":"2010","rank":1475},"381":{"songId":381,"year":"2015","rank":1207},"384":{"songId":384,"year":"2015","rank":150},"385":{"songId":385,"year":"2015","rank":1361},"386":{"songId":386,"year":"2015","rank":168},"387":{"songId":387,"year":"2015","rank":1288},"389":{"songId":389,"year":"2015","rank":1512},"390":{"songId":390,"year":"2015","rank":1102},"391":{"songId":391,"year":"2015","rank":1784},"396":{"songId":396,"year":"2013","rank":1923},"398":{"songId":398,"year":"2015","rank":1190},"399":{"songId":399,"year":"2015","rank":1964},"402":{"songId":402,"year":"2015","rank":684},"404":{"songId":404,"year":"2015","rank":1617},"410":{"songId":410,"year":"2015","rank":282},"420":{"songId":420,"year":"2015","rank":612},"421":{"songId":421,"year":"2015","rank":868}}' in cache
    End section Songs::top2000(0)
  • 0.033 2.194ms
    Begin section Songs::mp3(0, )...
    • 0.033 1.735ms

      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.035 62.58ms

    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.103 72.55ms
  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.104 2.094ms
    Begin section Songs::mp3(0, )...
    • 0.104 1.713ms

      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.106 65.2ms

    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.176 860.9µs

  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