Total SQL queries executed by:
107
Before application load usage:
8.25MB
After application load usage:
18.25MB
-
SELECT COUNT(1) FROM `sls_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
-
SELECT `a`.* FROM `sls_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
-
SELECT * FROM `sls_social_access_rules` WHERE `group` = 'user' AND `state` = '1'
-
SELECT `params` FROM `sls_social_access` WHERE `uid` = NULL AND `type` = 'profiles'
-
SELECT * FROM `sls_social_themes` WHERE `element` = 'wireframe'
-
select count(1) as `CNT` from `sls_users` as u inner join ( select * from ((select a.`uid` from `sls_social_fields_data` as a inner join `sls_social_fields` as b on a.`field_id` = b.`id` left join `sls_social_privacy_items` as pi on a.`field_id` = pi.`uid` and a.`uid` = pi.`user_id` and pi.`type` = 'field' where a.`type` = 'user' AND ( (pi.`value` = '0') OR (pi.`value` IS NULL) OR ( (pi.`value` = '10') AND (0 > 0 ) ) OR ( (pi.`value` = '20') AND ( (select count(1) from ( select af1.`actor_id` as `fid` from `sls_social_friends` as af1 where af1.`target_id` = 0 and af1.`state` = 1 union select af2.`target_id` as `fid` from `sls_social_friends` as af2 where af2.`actor_id` = 0 and af2.`state` = 1 ) as x where exists ( select bf1.`actor_id` from `sls_social_friends` as bf1 where bf1.`target_id` = pi.`user_id` and bf1.`actor_id` = x.`fid` and bf1.`state` = 1 union select bf2.`target_id` from sls_social_friends as bf2 where bf2.`actor_id` = pi.`user_id` and bf2.`target_id` = x.`fid` and bf2.`state` = 1 )) > 0 ) ) OR ( (pi.`value` = '20') AND ( (select count(1) from `sls_social_friends` where ( `actor_id` = pi.`user_id` and `target_id` = 0) OR (`target_id` = pi.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (pi.`value` = '30') AND ( (select count(1) from `sls_social_friends` where ( `actor_id` = pi.`user_id` and `target_id` = 0) OR (`target_id` = pi.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (pi.`value` = '40') AND ( pi.`user_id` = 0 ) ) OR (pi.`user_id` = 0)) AND ( b.`unique_key` = 'GENDER' and a.`raw` = '2'))) as x group by x.`uid` having ( count(x.`uid`) > 0 ) ) as xf ON xf.uid = u.id WHERE u.`block` = 0
-
select u.`id` from `sls_users` as u inner join ( select * from ((select a.`uid` from `sls_social_fields_data` as a inner join `sls_social_fields` as b on a.`field_id` = b.`id` left join `sls_social_privacy_items` as pi on a.`field_id` = pi.`uid` and a.`uid` = pi.`user_id` and pi.`type` = 'field' where a.`type` = 'user' AND ( (pi.`value` = '0') OR (pi.`value` IS NULL) OR ( (pi.`value` = '10') AND (0 > 0 ) ) OR ( (pi.`value` = '20') AND ( (select count(1) from ( select af1.`actor_id` as `fid` from `sls_social_friends` as af1 where af1.`target_id` = 0 and af1.`state` = 1 union select af2.`target_id` as `fid` from `sls_social_friends` as af2 where af2.`actor_id` = 0 and af2.`state` = 1 ) as x where exists ( select bf1.`actor_id` from `sls_social_friends` as bf1 where bf1.`target_id` = pi.`user_id` and bf1.`actor_id` = x.`fid` and bf1.`state` = 1 union select bf2.`target_id` from sls_social_friends as bf2 where bf2.`actor_id` = pi.`user_id` and bf2.`target_id` = x.`fid` and bf2.`state` = 1 )) > 0 ) ) OR ( (pi.`value` = '20') AND ( (select count(1) from `sls_social_friends` where ( `actor_id` = pi.`user_id` and `target_id` = 0) OR (`target_id` = pi.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (pi.`value` = '30') AND ( (select count(1) from `sls_social_friends` where ( `actor_id` = pi.`user_id` and `target_id` = 0) OR (`target_id` = pi.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (pi.`value` = '40') AND ( pi.`user_id` = 0 ) ) OR (pi.`user_id` = 0)) AND ( b.`unique_key` = 'GENDER' and a.`raw` = '2'))) as x group by x.`uid` having ( count(x.`uid`) > 0 ) ) as xf ON xf.uid = u.id WHERE u.`block` = 0 LIMIT 0,10
-
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sls_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_easyblog','com_easydiscuss','com_easysocial','com_fields','com_finder','com_gantry','com_gsd','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_route66','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '44' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '44'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '44'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '44' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1083' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1083'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1083'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1083' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1304' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1304'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1304'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1304' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1352' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1352'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1352'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1352' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1355' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1355'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1355'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1355' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1380' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1380'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1380'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1380' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1381' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1381'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1381'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1381' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1385' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1385'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1385'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1385' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1392' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1392'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1392'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1392' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '1397' GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1397'
-
SELECT b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` = '1397'
-
select a.`id`, a.`type`, a.`rule`, a.`options`, b.`value` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1' order by a.`type`
-
select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b on a.`id` = b.`privacy_id` where b.`uid` = '1397' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
-
select a.`unique_key`, a.`title`, b.`element` from `sls_social_fields` as a inner join `sls_social_fields_steps` as fs on a.`step_id` = fs.`id` and fs.`type` = 'profiles' inner join `sls_social_profiles` as p on fs.`uid` = p.`id` inner join `sls_social_apps` as b on a.`app_id` = b.`id` and b.`group` = 'user' where a.`searchable` = '1' and a.`state` = '1' and a.`unique_key` != '' and p.`state` = '1' order by fs.`sequence`, a.`ordering`
-
SELECT template FROM `sls_template_styles` AS s LEFT JOIN `sls_extensions` AS e ON e.type = `template` AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = '0' AND home = 1
-
SELECT COUNT(1) FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '0' AND `b`.`type` = 'user' WHERE `a`.`state` = '1' AND `a`.`group` = 'user' AND `a`.`widget` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL OR `a`.`system` = '1' )
-
SELECT `a`.* FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '0' AND `b`.`type` = 'user' WHERE `a`.`state` = '1' AND `a`.`group` = 'user' AND `a`.`widget` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL OR `a`.`system` = '1' )
-
SELECT * FROM `sls_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%'
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='44' AND `target_id`='0' ) OR ( `target_id`='44' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='44' AND `target_id`='0' ) OR ( `target_id`='44' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '44', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='44' AND a.`state` = '1' ) OR ( a.`actor_id`='44' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1083' AND `target_id`='0' ) OR ( `target_id`='1083' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1083' AND `target_id`='0' ) OR ( `target_id`='1083' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1083', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1083' AND a.`state` = '1' ) OR ( a.`actor_id`='1083' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1304' AND `target_id`='0' ) OR ( `target_id`='1304' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1304' AND `target_id`='0' ) OR ( `target_id`='1304' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1304', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1304' AND a.`state` = '1' ) OR ( a.`actor_id`='1304' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1352' AND `target_id`='0' ) OR ( `target_id`='1352' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1352' AND `target_id`='0' ) OR ( `target_id`='1352' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1352', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1352' AND a.`state` = '1' ) OR ( a.`actor_id`='1352' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1355' AND `target_id`='0' ) OR ( `target_id`='1355' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1355' AND `target_id`='0' ) OR ( `target_id`='1355' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1355', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1355' AND a.`state` = '1' ) OR ( a.`actor_id`='1355' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1380' AND `target_id`='0' ) OR ( `target_id`='1380' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1380' AND `target_id`='0' ) OR ( `target_id`='1380' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1380', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1380' AND a.`state` = '1' ) OR ( a.`actor_id`='1380' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1381' AND `target_id`='0' ) OR ( `target_id`='1381' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1381' AND `target_id`='0' ) OR ( `target_id`='1381' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1381', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1381' AND a.`state` = '1' ) OR ( a.`actor_id`='1381' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1385' AND `target_id`='0' ) OR ( `target_id`='1385' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1385' AND `target_id`='0' ) OR ( `target_id`='1385' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1385', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1385' AND a.`state` = '1' ) OR ( a.`actor_id`='1385' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1392' AND `target_id`='0' ) OR ( `target_id`='1392' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1392' AND `target_id`='0' ) OR ( `target_id`='1392' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1392', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1392' AND a.`state` = '1' ) OR ( a.`actor_id`='1392' AND a.`state` = '1' ) )
-
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1397' AND `target_id`='0' ) OR ( `target_id`='1397' AND `actor_id`='0' )
-
SELECT * FROM `sls_social_friends` WHERE ( `actor_id`='1397' AND `target_id`='0' ) OR ( `target_id`='1397' AND `actor_id`='0' )
-
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1397', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1397' AND a.`state` = '1' ) OR ( a.`actor_id`='1397' AND a.`state` = '1' ) )
-
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'
-
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `sls_social_fields` AS `a` LEFT JOIN `sls_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `sls_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE ( `a`.`core` = '1' OR `a`.`state` = '1' ) AND `d`.`uid` = '1' AND `d`.`type` = 'profiles' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
-
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '165', '167', '14', '15', '16', '17', '18', '19') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
-
SELECT * FROM `sls_social_apps`