Profiler information for a page

Ik maak gebruik van Redis.

info in database gevonden voor '69'.

• 0.000 116.1µs

  fs

  Opening profiler sock
• 0.000 283µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055519-g5MEAJhc"}
• 0.000 56.03µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055519-g5MEAJhc"}
• 0.025 3.942ms

  db

  (Re)initializing SQL
• 0.029 531µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.030 162.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055519-g5MEAJhc"}
• 0.030 51.98µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055519-g5MEAJhc"}
• 0.030 44.48ms
  Begin section imageInfo([])...
  • 0.030 3.881ms

    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.037 340µs

    db

    Called from: lib/include.inc:877

    SET @rank = 0

    OK. Rows = 0
  • 0.038 8.535ms

    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([])
• 0.076 1.534ms
  Begin section commentData(69...
  • 0.076 843µs

    db

    Called from: lib/include.inc:105

    SELECT commentId,id,naam,bericht,datum,type FROM sweatypants.comments WHERE type != 'comment' AND `type` = 'image' ORDER BY type,datum DESC

    OK. Rows = 51
  • 0.077 502.1µs

    db

    Called from: lib/include.inc:106

    SELECT commentId,id,naam,bericht,datum,type FROM sweatypants.comments WHERE type = 'comment' ORDER BY type,datum DESC

    OK. Rows = 2
  End section commentData(69
• 0.078 97.5ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.078 623.9µs
    Begin section Songs::extra(0)...
    • 0.078 396µ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.079 1.2ms
    Begin section Songs::top2000(0)...
    • 0.079 1.035ms

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.080 2.05ms
    Begin section Songs::mp3(0, )...
    • 0.080 1.681ms

      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.082 87.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.176 1.23ms

  db

  Called from: content/image.php:163

  SELECT imgId, filename FROM sweatypants.imageId WHERE album='Koninginnedag Delft 2004' AND root='Gigs' ORDER BY datetime

  OK. Rows = 11
• 0.177 11.33ms
  Begin section imageInfo("69")...
  • 0.177 1.043ms

    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( 69 ) OR i.image IN( '69' ) OR i.filename IN( '69' ) ) ORDER BY `datetime` DESC

    OK. Rows = 1
  • 0.179 191.9µs

    db

    Called from: lib/include.inc:877

    SET @rank = 0

    OK. Rows = 0
  • 0.179 8.969ms

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