Affix Amp Music Network Band Profile Website

Profile Information

Memory Usage

47 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1713919887' )
2. SELECT *
     FROM jos_session
     WHERE session_id = 'b5bba7bbe2b0680676d2aa70792dd04d'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'b5bba7bbe2b0680676d2aa70792dd04d','1713920787','','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=buxaburn&option=com\_profile%' OR sefurl LIKE 'view=artist&name=buxaburn&option=com\_profile%'
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 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 ="buxaburn"
10. SELECT id,user_id
      FROM `jos_profile`
      WHERE user_id = 0
11. SELECT id
      FROM `jos_profile_views`
      WHERE user_id = 405
12. SELECT id,update_date
      FROM `jos_profile_views`
      WHERE user_id = 405
13. UPDATE `jos_profile_views`
      SET `update_date` = "2024 04 24" ,`today_views` = 1
      WHERE user_id = 405
14. UPDATE `jos_profile_views`
      SET `total_views` = `total_views` + 1
      WHERE user_id = 405
15. SELECT SQL_CALC_FOUND_ROWS content
      FROM jos_board
      WHERE user_id=405
      AND published = 1
16. SELECT SQL_CALC_FOUND_ROWS id,user_id,title,file,description,created
      FROM jos_photos 
      WHERE published=1
      AND user_id=405
      ORDER BY created DESC
      LIMIT 0, 9
17. SELECT FOUND_ROWS();
18. SELECT id,today_views,total_views,user_id,update_date
      FROM `jos_profile_views`
      WHERE user_id = 405
19. SELECT  SQL_CALC_FOUND_ROWS id
      FROM jos_favorites
      WHERE (listener_id=0
      AND artist_id=405)
      LIMIT 0,1
20. SELECT SQL_CALC_FOUND_ROWS id,user_id,profile_id,is_pending,created 
      FROM jos_friends
      WHERE (user_id=0
      AND profile_id=405) OR (user_id=405
      AND profile_id=0)
      LIMIT 0,1
21. 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 = 405 
                                      
      ORDER BY v.created DESC
      LIMIT 0, 9
22. SELECT FOUND_ROWS();
23. SELECT SQL_CALC_FOUND_ROWS id,user_id,title,date,summary,content,created
      FROM jos_blog
      WHERE published=1
      AND user_id=405
      ORDER BY created DESC
      LIMIT 0, 9
24. SELECT FOUND_ROWS();
25. 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=405
26. SELECT SQL_CALC_FOUND_ROWS website_url,merch_url,contact_email,booking_contact
      FROM jos_profile
      WHERE user_id=405
27. 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=405
      LIMIT 0, 9
28. SELECT FOUND_ROWS();
29. 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 = 405
      AND pc.user_id=u.id
      AND pc.is_allow=1
      ORDER BY pc.posted_on DESC
      LIMIT 0, 9
30. SELECT FOUND_ROWS();
31. SELECT SQL_CALC_FOUND_ROWS id,user_id,name,alias,file,release_date,created
      FROM jos_albums
      WHERE published=1
      AND user_id =405
      LIMIT 0, 9
32. SELECT FOUND_ROWS();
33. 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=405
      AND u.block=0 
      ORDER BY f.submitted_date DESC
      LIMIT 0, 9
34. SELECT FOUND_ROWS();
35. 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 = 405 OR f.user_id=405)
      AND f.is_pending = 0
      AND f.profile_id = u.id
      AND u.block=0
      ORDER BY f.created DESC
      LIMIT 0, 9
36. SELECT FOUND_ROWS();
37. 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 =405
38. SELECT FOUND_ROWS();
39. SELECT id,today_views,total_views,video_id,update_date
      FROM `jos_video_views`
      WHERE video_id=620
40. SELECT id,today_views,total_views,video_id,update_date
      FROM `jos_video_views`
      WHERE video_id=619
41. 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
42. 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
43. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
44. SELECT id,name,username,email
      FROM jos_users
      WHERE id=289
45. SELECT id,name,username,email
      FROM jos_users
      WHERE id=298
46. SELECT id,name,username,email
      FROM jos_users
      WHERE id=301
47. 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