Total SQL queries executed by:
54
Before application load usage:
8.25MB
After application load usage:
14.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'
-
DELETE FROM `sls_social_registrations` WHERE `created`
-
SELECT *
FROM sls_social_registrations
WHERE `session_id` = 'nngd8rt9jg2rvjq1dvgvj9us62'
-
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='nngd8rt9jg2rvjq1dvgvj9us62'
-
INSERT INTO `sls_social_registrations`
(`session_id`,`created`) VALUES
('nngd8rt9jg2rvjq1dvgvj9us62','2021-10-19 15:15:34')
-
SELECT a.* , COUNT(b.`id`) AS `count` FROM `sls_social_profiles` AS a LEFT JOIN `sls_social_profiles_maps` AS b ON a.`id` = b.`profile_id` LEFT JOIN `sls_users` AS c ON c.`id`= b.`user_id` AND c.`block`='0' WHERE 1 AND a.`state`='1' AND a.`registration`='1' GROUP BY a.`id` ORDER BY a.`ordering` ASC
-
SELECT b.`id` FROM `sls_social_profiles_maps` AS a INNER JOIN `sls_users` AS b ON b.`id` = a.`user_id` WHERE a.`profile_id`='1' AND b.`block` = '0' ORDER BY RAND() LIMIT 0,10
-
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` IN ('1260', '1321', '842', '1248', '206', '1364', '1243', '209', '1818', '1392') GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '206'
-
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` = '206'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '209'
-
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` = '209'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '842'
-
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` = '842'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1243'
-
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` = '1243'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1248'
-
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` = '1248'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1260'
-
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` = '1260'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1321'
-
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` = '1321'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1364'
-
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` = '1364'
-
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 COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1818'
-
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` = '1818'
-
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='nngd8rt9jg2rvjq1dvgvj9us62'
-
UPDATE `sls_social_registrations` SET `profile_id`='1',`created`='2021-10-19 15:15:34',`step`='1',`step_access`=',1' WHERE `session_id` = 'nngd8rt9jg2rvjq1dvgvj9us62'
-
SELECT *
FROM sls_social_registrations
WHERE `session_id` = 'nngd8rt9jg2rvjq1dvgvj9us62'
-
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'
-
SELECT * FROM `sls_social_fields_steps` WHERE `uid` = '1' AND `type` = 'profiles' AND `visible_registration` = '1' ORDER BY `sequence` ASC
-
SELECT * FROM `sls_social_fields_steps` WHERE `uid` = '1' AND `type` = 'profiles' AND `state` = '1' AND `sequence` = '1' AND `visible_registration` = '1'
-
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='nngd8rt9jg2rvjq1dvgvj9us62'
-
UPDATE `sls_social_registrations` SET `profile_id`='1',`created`='2021-10-19 15:15:34',`values`='',`step`='1',`step_access`=',1',`errors`='' WHERE `session_id` = 'nngd8rt9jg2rvjq1dvgvj9us62'
-
SELECT *
FROM sls_social_fields_steps
WHERE `uid` = '1' AND `type` = 'profiles' AND `sequence` = '1'
-
SELECT COUNT(1) FROM `sls_social_fields_steps` WHERE `uid` = '1' AND `type` = 'profiles' AND `state` = '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`.`visible_registration` = '1' AND `a`.`step_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
-
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` IN ('1', '2', '3', '4', '5', '7', '8', '9', '10', '11', '12', '13', '165', '167') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
-
SELECT * FROM `sls_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%'
-
SELECT * FROM `sls_social_apps`
-
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_profiles` WHERE `state`='1' AND `registration`='1'
-
SELECT * FROM `sls_social_fields_steps` WHERE `uid` = '1' AND `type` = 'profiles' AND `visible_registration` = '1' ORDER BY `sequence` ASC
-
SELECT COUNT(1) FROM `sls_social_fields_steps` WHERE `uid` = '1' AND `type` = 'profiles' AND `state` = '1' AND `visible_registration` = '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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sls_modules AS m
LEFT JOIN sls_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN sls_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up = '2021-10-19 15:15:34') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 197 OR mm.menuid