Profiler information for a page

Ik maak gebruik van Redis.

• 0.000 114µs

  fs

  Opening profiler sock
• 0.000 297.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054824-H4qtPeDu"}
• 0.000 114µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054824-H4qtPeDu"}
• 0.016 1.308ms

  db

  (Re)initializing SQL
• 0.017 354.8µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.018 97.04µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054824-H4qtPeDu"}
• 0.018 119µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-054824-H4qtPeDu"}
• 0.018 923.2µs

  db

  Called from: content/album.php:33

  SELECT DISTINCT album FROM sweatypants.imageId WHERE album NOT IN ('Dennis','Ace','Daan','Jan','Beug','Crew') AND root = 'de Band' ORDER BY `datetime`

  OK. Rows = 2
• 0.020 71.59ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.020 641.1µs
    Begin section Songs::extra(0)...
    • 0.020 400.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.021 1.374ms
    Begin section Songs::top2000(0)...
    • 0.021 1.17ms

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.022 1.79ms
    Begin section Songs::mp3(0, )...
    • 0.022 1.481ms

      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.024 63.24ms

    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.092 41.87ms
  Begin section showPics( Oefenen, , 1050, thumbs )...
  • 0.092 41.01ms
    Begin section imageInfo([])...
    • 0.092 3.082ms

      db

      Called from: lib/include.inc:861

      SELECT i.imgId, i.image, i.size, i.width, i.height, i.`datetime`, i.root, i.album, i.filename, i.descr, IFNULL(i.descr,'') AS `desc`, t.tags, CONCAT(i.root,'/',i.album,'/tn_',i.filename) AS tn,CONCAT(i.root,'/',i.album,'/') AS path_to, CONCAT(i.root,'/',i.album,'/',i.filename) AS full_path, CONCAT('/var/www/vhosts/sweatypants.com/httpdocs/albums/content/',i.root,'/',i.album,'/descr.txt') AS descriptfile FROM sweatypants.imageId AS i LEFT JOIN sweatypants.imagetags AS t USING( imgId ) WHERE ( i.imgId IN( 0 ) OR i.image IN( '0' ) OR i.filename IN( '0' ) ) OR imgId > 0 ORDER BY `datetime` DESC

      OK. Rows = 575
    • 0.098 464.2µs

      db

      Called from: lib/include.inc:877

      SET @rank = 0

      OK. Rows = 0
    • 0.099 5.898ms

      db

      Called from: lib/include.inc:878

      SELECT imgId, average, sumvotes, numvotes, weight, root, album, filename, round( average, 1 ) AS average_rounded, @rank:=@rank+1 AS `position` FROM sweatypants.v_imagevotes ORDER BY weight DESC,filename

      OK. Rows = 333
    End section imageInfo([])
  End section showPics( Oefenen, , 1050, thumbs )