Total SQL queries executed by:
15
Before application load usage:
8.25MB
After application load usage:
13.75MB
-
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` = 'BIRTHDAY' and a.`datakey` = 'date' and a.`raw` >= '1989-06-27 00:00:00' and a.`raw` 0 ) ) as xf ON xf.uid = u.id WHERE u.`block` = 0
-
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_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`