Affix Amp Music Network Band Profile Website

Profile Information

Memory Usage

61 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1713503806' )
2. SELECT *
     FROM jos_session
     WHERE session_id = '4465115ed29b002e046006a5df2d23a9'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '4465115ed29b002e046006a5df2d23a9','1713504706','','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&option=com\_charts&Itemid=76&task=all&limitstart=20%' OR sefurl LIKE 'do=all&option=com\_charts&Itemid=76&task=all&limitstart=20%'
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 = 76)
     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 20, 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 = '310'
13. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 310
      ORDER BY RAND()
      LIMIT 1
14. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '311'
15. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 311
      ORDER BY RAND()
      LIMIT 1
16. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '312'
17. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 312
      ORDER BY RAND()
      LIMIT 1
18. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '313'
19. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 313
      ORDER BY RAND()
      LIMIT 1
20. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '315'
21. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 315
      ORDER BY RAND()
      LIMIT 1
22. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '316'
23. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 316
      ORDER BY RAND()
      LIMIT 1
24. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '317'
25. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 317
      ORDER BY RAND()
      LIMIT 1
26. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '318'
27. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 318
      ORDER BY RAND()
      LIMIT 1
28. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '319'
29. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 319
      ORDER BY RAND()
      LIMIT 1
30. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '323'
31. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 323
      ORDER BY RAND()
      LIMIT 1
32. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '324'
33. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 324
      ORDER BY RAND()
      LIMIT 1
34. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '325'
35. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 325
      ORDER BY RAND()
      LIMIT 1
36. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '326'
37. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 326
      ORDER BY RAND()
      LIMIT 1
38. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '328'
39. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 328
      ORDER BY RAND()
      LIMIT 1
40. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '329'
41. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 329
      ORDER BY RAND()
      LIMIT 1
42. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '330'
43. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 330
      ORDER BY RAND()
      LIMIT 1
44. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '331'
45. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 331
      ORDER BY RAND()
      LIMIT 1
46. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '332'
47. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 332
      ORDER BY RAND()
      LIMIT 1
48. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '333'
49. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 333
      ORDER BY RAND()
      LIMIT 1
50. SELECT id,user_id,genre1,genre2,country 
      FROM `jos_profile`
      WHERE user_id = '334'
51. SELECT id,user_id,track_name,album_id,file
      FROM jos_tracks
      WHERE user_id = 334
      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 = 76 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 19'
                                      
      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 19'
      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