Affix Amp Music Network Band Profile Website

Profile Information

Memory Usage

40 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1575955148' )
2. SELECT *
     FROM jos_session
     WHERE session_id = '87a4f9345ee6f1c8895f916aa89923e7'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '87a4f9345ee6f1c8895f916aa89923e7','1575956048','','0','1','0' )
4. SELECT *
     FROM jos_components
     WHERE parent = 0
5. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
6. SELECT *
     FROM jos_migration_backlinks
     WHERE url LIKE 'view=display&option=com\_music&id=101%' OR sefurl LIKE 'view=display&option=com\_music&id=101%'
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 0)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT  id,user_id,name
     FROM `jos_albums`
     WHERE id = 101
     AND user_id=0
10. SELECT id
      FROM `jos_album_views`
      WHERE album_id = 101
11. SELECT id,update_date
      FROM `jos_album_views`
      WHERE album_id = 101
12. UPDATE `jos_album_views`
      SET `update_date` = "2019 12 10" ,`today_views` = 1
      WHERE album_id = 101
13. UPDATE `jos_album_views`
      SET `total_views` = `total_views` + 1
      WHERE album_id = 101
14. SELECT id,user_id,name,alias,file,release_date,itune_link,amazon_link,published,description,ordering,is_feature,created
      FROM jos_albums
      WHERE id=101
15. SELECT id,today_views,total_views,album_id,update_date
      FROM `jos_album_views`
      WHERE album_id =101
16. SELECT SQL_CALC_FOUND_ROWS t.id,t.user_id,t.album_id,t.file,t.published,t.ordering,t.created,t.track_name,t.is_downloadable
      FROM jos_tracks AS t
      WHERE t.published=1
      AND t.album_id = 101
      AND t.is_downloadable = 1
17. SELECT t.id,t.is_downloadable,t.track_name,a.description,t.album_id,t.file,a.name,a.file AS album_file
      FROM jos_albums AS a, jos_tracks AS t
      WHERE a.id = t.album_id
      AND a.published=1
      AND  t.published=1
      AND t.album_id=101
18. SELECT SQL_CALC_FOUND_ROWS ac.id,u.username,u.usertype,u.name,ac.album_id,ac.user_id,ac.comment,ac.posted_on,ac.is_allow
      FROM jos_album_comments AS ac,jos_users AS u
      WHERE ac.album_id = 101
      AND ac.user_id=u.id
      AND is_allow = 1
19. SELECT FOUND_ROWS();
20. SELECT FOUND_ROWS();
21. SELECT SQL_CALC_FOUND_ROWS id,user_id,name,alias,file,release_date,itune_link,description,amazon_link,published,description,ordering,is_feature,created
      FROM jos_albums
      WHERE  published=1
      AND user_id=328
      AND id!=101
      ORDER BY RAND()
      LIMIT 0, 4
22. SELECT FOUND_ROWS();
23. SELECT u.id,u.name,u.email,u.usertype,u.username
      FROM jos_users AS u
      WHERE u.id =328
24. SELECT id,today_downloads,total_downloads,track_id,update_date
      FROM `jos_track_downloads`
      WHERE track_id =501
25. SELECT id,today_downloads,total_downloads,track_id,update_date
      FROM `jos_track_downloads`
      WHERE track_id =504
26. SELECT id,today_downloads,total_downloads,track_id,update_date
      FROM `jos_track_downloads`
      WHERE track_id =505
27. SELECT id,today_views,total_views,album_id,update_date
      FROM `jos_album_views`
      WHERE album_id =106
28. SELECT id,today_views,total_views,album_id,update_date
      FROM `jos_album_views`
      WHERE album_id =102
29. SELECT id,today_views,total_views,album_id,update_date
      FROM `jos_album_views`
      WHERE album_id =103
30. SELECT id,today_views,total_views,album_id,update_date
      FROM `jos_album_views`
      WHERE album_id =114
31. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 0 OR mm.menuid = 0 )
      ORDER BY position, ordering
32. SELECT p.id,p.user_id,p.title,p.file,p.description,p.created,u.name,u.username,u.usertype
      FROM jos_photos AS p,jos_users AS u
      WHERE p.published=1
      AND u.block=0
      AND u.id = p.user_id
      ORDER BY p.created DESC
      LIMIT 0, 4
33. SELECT SQL_CALC_FOUND_ROWS v.id,v.title,v.video_type,v.user_id,v.description, v.created,
                                              v.published, v.ordering,yv.youtube_id,yv.feed_user_name, yv.image , vv.today_views, dv.id AS desktopid,dv.image AS desktopimage,dv.user_image,dv.video_id
                                      
      FROM
                                              jos_videos AS v
                                      
      LEFT JOIN jos_youtube_videos AS yv
                                      
      ON v.id = yv.video_id
                                              
      LEFT JOIN jos_video_views AS vv
                                      
      ON vv.video_id=v.id
                                         
      LEFT JOIN jos_desktop_videos AS dv
                                      
      ON v.id = dv.video_id
                                      
      WHERE
                                              v.published=1
                                              
      AND vv.update_date='2019 12 10'
                                      
      ORDER BY vv.today_views DESC
      LIMIT 0, 10
34. SELECT a.id,a.user_id,a.name,a.alias,a.file,a.release_date,a.description,a.created,av.today_views
      FROM jos_albums AS a,jos_album_views AS av
      WHERE av.album_id = a.id
      AND av.update_date='2019 12 10'
      ORDER BY av.today_views DESC
      LIMIT 0, 10
35. SELECT v.id,v.user_id,v.title,v.description,
                                              yv.image,yv.youtube_id 
      FROM jos_videos AS v, jos_youtube_videos AS yv
      WHERE v.id = yv.video_id
      AND v.published=1
      LIMIT 0, 5
36. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
37. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
38. SELECT id,name,username,email
      FROM jos_users
      WHERE id=298
39. SELECT id,name,username,email
      FROM jos_users
      WHERE id=301
40. SELECT id,name,username,email
      FROM jos_users
      WHERE id=303

0 legacy queries logged

Language Files Loaded

• /home/www/affixamp.com/language/en-GB/en-GB.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.com_music.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.tpl_beatz_blue.ini
• /home/www/affixamp.com/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_footer.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_recent_photos.ini
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_top_videos.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_top_albums.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_login.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_listener_navigation.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_artist_navigation.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_recent_videos.ini 1
• /home/www/affixamp.com/language/en-GB/en-GB.mod_beatz_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None