Affix Amp Music Network Band Profile Website

Profile Information

Memory Usage

61 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1713259975' )
2. SELECT *
     FROM jos_session
     WHERE session_id = '058cd28610247fb678a18c3666298acd'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '058cd28610247fb678a18c3666298acd','1713260875','','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 'do=all&keyword=&option=com\_charts&Itemid=62%' OR sefurl LIKE 'do=all&keyword=&option=com\_charts&Itemid=62%'
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 = 62)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT SQL_CALC_FOUND_ROWS  u.id,u.name,u.username,u.usertype,u.registerDate
     FROM jos_users AS u,jos_profile AS p
     WHERE u.block=0
     AND u.usertype='Artist'
     AND u.id=p.user_id
     AND  (p.genre1 LIKE '%%'OR p.genre2 LIKE '%%')
     LIMIT 0, 20
10. SELECT FOUND_ROWS();
11. SELECT id, genre
      FROM jos_genre
12. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '290'
13. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 290
      ORDER BY RAND()
      LIMIT 1
14. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '291'
15. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 291
      ORDER BY RAND()
      LIMIT 1
16. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '206'
17. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 206
      ORDER BY RAND()
      LIMIT 1
18. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '307'
19. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 307
      ORDER BY RAND()
      LIMIT 1
20. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '305'
21. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 305
      ORDER BY RAND()
      LIMIT 1
22. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '308'
23. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 308
      ORDER BY RAND()
      LIMIT 1
24. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '289'
25. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 289
      ORDER BY RAND()
      LIMIT 1
26. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '288'
27. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 288
      ORDER BY RAND()
      LIMIT 1
28. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '297'
29. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 297
      ORDER BY RAND()
      LIMIT 1
30. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '298'
31. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 298
      ORDER BY RAND()
      LIMIT 1
32. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '299'
33. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 299
      ORDER BY RAND()
      LIMIT 1
34. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '294'
35. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 294
      ORDER BY RAND()
      LIMIT 1
36. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '295'
37. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 295
      ORDER BY RAND()
      LIMIT 1
38. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '296'
39. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 296
      ORDER BY RAND()
      LIMIT 1
40. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '300'
41. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 300
      ORDER BY RAND()
      LIMIT 1
42. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '301'
43. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 301
      ORDER BY RAND()
      LIMIT 1
44. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '302'
45. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 302
      ORDER BY RAND()
      LIMIT 1
46. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '303'
47. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 303
      ORDER BY RAND()
      LIMIT 1
48. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '304'
49. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 304
      ORDER BY RAND()
      LIMIT 1
50. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '309'
51. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 309
      ORDER BY RAND()
      LIMIT 1
52. 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 = 62 OR mm.menuid = 0 )
      ORDER BY position, ordering
53. 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
54. 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='2024 04 16'
                                      
      ORDER BY vv.today_views DESC
      LIMIT 0, 10
55. 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='2024 04 16'
      ORDER BY av.today_views DESC
      LIMIT 0, 10
56. 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
57. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
58. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
59. SELECT id,name,username,email
      FROM jos_users
      WHERE id=298
60. SELECT id,name,username,email
      FROM jos_users
      WHERE id=301
61. 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_charts.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