Profiler information for a page

Ik maak gebruik van Redis.

info in database gevonden voor '134'.

• 0.000 141.1µs

  fs

  Opening profiler sock
• 0.000 369.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055631-agt2YgW6"}
• 0.001 88.93µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055631-agt2YgW6"}
• 0.018 1.444ms

  db

  (Re)initializing SQL
• 0.019 413.9µs

  db

  Called from: lib/include.inc:43

  use sweatypants

  OK. Rows = 0
• 0.021 292.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055631-agt2YgW6"}
• 0.021 111.1µs

  net

  Requesting file name

  Got: {"Filename":"/tmp/profiler-data/PR-20250208-055631-agt2YgW6"}
• 0.021 46.91ms
  Begin section imageInfo([])...
  • 0.021 3.383ms

    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.028 335µs

    db

    Called from: lib/include.inc:877

    SET @rank = 0

    OK. Rows = 0
  • 0.028 6.273ms

    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.069 1.387ms
  Begin section commentData(134...
  • 0.069 927µ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.070 293µ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(134
• 0.071 72.35ms
  Begin section Songs::info()...

  options: []

  options: []

  • 0.071 659.9µs
    Begin section Songs::extra(0)...
    • 0.071 378.8µ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.072 1.121ms
    Begin section Songs::top2000(0)...
    • 0.072 977µs

      cache read

      Key: top2000-11111111-0207
    End section Songs::top2000(0)
  • 0.073 2.026ms
    Begin section Songs::mp3(0, )...
    • 0.073 1.673ms

      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.075 64.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.144 1.093ms

  db

  Called from: content/image.php:163

  SELECT imgId, filename FROM sweatypants.imageId WHERE album='Het BarBiertje - augustus 2005' AND root='Gigs' ORDER BY datetime

  OK. Rows = 40
• 0.145 10.93ms
  Begin section imageInfo("134")...
  • 0.145 901µs

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

    OK. Rows = 1
  • 0.146 145.9µs

    db

    Called from: lib/include.inc:877

    SET @rank = 0

    OK. Rows = 0
  • 0.146 8.47ms

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