Affix Amp Music Network Band Profile Website

Profile Information

Memory Usage

44 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1714186651' )
2. SELECT *
     FROM jos_session
     WHERE session_id = 'd3e57a8302c6ee651be0bd5b22636a55'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'd3e57a8302c6ee651be0bd5b22636a55','1714187551','','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=artist&name=mississippisipp&option=com\_profile%' OR sefurl LIKE 'view=artist&name=mississippisipp&option=com\_profile%'
7. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 0)
     ORDER BY menuid DESC
     LIMIT 0, 1
8. SELECT SQL_CALC_FOUND_ROWS u.id,u.name,u.username,u.email,u.usertype,u.username,u.block
     FROM jos_users AS u
     WHERE u.username ="mississippisipp"
9. SELECT id,user_id
     FROM `jos_profile`
     WHERE user_id = 0
10. SELECT id
      FROM `jos_profile_views`
      WHERE user_id = 339
11. SELECT id,update_date
      FROM `jos_profile_views`
      WHERE user_id = 339
12. UPDATE `jos_profile_views`
      SET `update_date` = "2024 04 27" ,`today_views` = 1
      WHERE user_id = 339
13. UPDATE `jos_profile_views`
      SET `total_views` = `total_views` + 1
      WHERE user_id = 339
14. SELECT SQL_CALC_FOUND_ROWS content
      FROM jos_board
      WHERE user_id=339
      AND published = 1
15. SELECT SQL_CALC_FOUND_ROWS id,user_id,title,file,description,created
      FROM jos_photos 
      WHERE published=1
      AND user_id=339
      ORDER BY created DESC
      LIMIT 0, 9
16. SELECT FOUND_ROWS();
17. SELECT id,today_views,total_views,user_id,update_date
      FROM `jos_profile_views`
      WHERE user_id = 339
18. SELECT  SQL_CALC_FOUND_ROWS id
      FROM jos_favorites
      WHERE (listener_id=0
      AND artist_id=339)
      LIMIT 0,1
19. SELECT SQL_CALC_FOUND_ROWS id,user_id,profile_id,is_pending,created 
      FROM jos_friends
      WHERE (user_id=0
      AND profile_id=339) OR (user_id=339
      AND profile_id=0)
      LIMIT 0,1
20. 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 , 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_desktop_videos AS dv
                                      
      ON v.id = dv.video_id
                                      
      WHERE
                                              v.published=1
                                              
      AND v.user_id = 339 
                                      
      ORDER BY v.created DESC
      LIMIT 0, 9
21. SELECT FOUND_ROWS();
22. SELECT SQL_CALC_FOUND_ROWS id,user_id,title,date,summary,content,created
      FROM jos_blog
      WHERE published=1
      AND user_id=339
      ORDER BY created DESC
      LIMIT 0, 9
23. SELECT FOUND_ROWS();
24. SELECT SQL_CALC_FOUND_ROWS p.id,p.user_id,p.gender,p.dob,p.country,p.zipcode,p.genre1,p.genre2,u.id,u.name,u.name,u.registerDate,u.usertype,p.website_url,p.    merch_url,p.contact_email,p.booking_contact
      FROM jos_profile AS p, jos_users AS u
      WHERE u.id = p.user_id
      AND p.user_id=339
25. SELECT SQL_CALC_FOUND_ROWS website_url,merch_url,contact_email,booking_contact
      FROM jos_profile
      WHERE user_id=339
26. SELECT SQL_CALC_FOUND_ROWS id,user_id,country,city,cost,description,venue,show_date,show_time,cost,created,image
      FROM jos_shows
      WHERE user_id=339
      LIMIT 0, 9
27. SELECT FOUND_ROWS();
28. SELECT SQL_CALC_FOUND_ROWS pc.id,u.id AS uid,u.username,u.name,u.usertype,pc.profile_id,pc.user_id,pc.comment,pc.posted_on,pc.is_allow
      FROM jos_user_comments AS pc,jos_users AS u
      WHERE pc.profile_id = 339
      AND pc.user_id=u.id
      AND pc.is_allow=1
      ORDER BY pc.posted_on DESC
      LIMIT 0, 9
29. SELECT FOUND_ROWS();
30. SELECT SQL_CALC_FOUND_ROWS id,user_id,name,alias,file,release_date,created
      FROM jos_albums
      WHERE published=1
      AND user_id =339
      LIMIT 0, 9
31. SELECT FOUND_ROWS();
32. SELECT SQL_CALC_FOUND_ROWS f.id,f.artist_id,f.listener_id,f.submitted_date,u.id AS uid,u.username,u.name,u.usertype,u.registerDate
      FROM jos_favorites AS f ,jos_users AS u
      WHERE f.listener_id = u.id
      AND f.artist_id=339
      AND u.block=0 
      ORDER BY f.submitted_date DESC
      LIMIT 0, 9
33. SELECT FOUND_ROWS();
34. SELECT SQL_CALC_FOUND_ROWS f.id,f.user_id,f.profile_id,f.is_pending,f.created
      FROM jos_friends AS f,jos_users AS u
      WHERE (f.profile_id = 339 OR f.user_id=339)
      AND f.is_pending = 0
      AND f.profile_id = u.id
      AND u.block=0
      ORDER BY f.created DESC
      LIMIT 0, 9
35. SELECT FOUND_ROWS();
36. SELECT  id,user_id,updated_date,allow_photo_comments,allow_album_comments,allow_profile_comments,allow_blog_comments,allow_friends,message_notification,comments_notification,friend_notification,allow_video_comments,profile_background_content,profile_background_type,profile_theme
      FROM jos_user_settings
      WHERE user_id =339
37. SELECT FOUND_ROWS();
38. 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
39. 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
40. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
41. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
42. SELECT id,name,username,email
      FROM jos_users
      WHERE id=298
43. SELECT id,name,username,email
      FROM jos_users
      WHERE id=301
44. 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_profile.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_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

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None