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` = 'a6hvgd1iaubppp58omlp6q99b7'
-
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='a6hvgd1iaubppp58omlp6q99b7'
-
INSERT INTO `sls_social_registrations`
(`session_id`,`created`) VALUES
('a6hvgd1iaubppp58omlp6q99b7','2022-06-28 12:25:03')
-
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 ('1200', '583', '1389', '1429', '1774', '1544', '258', '1148', '1744', '1321') GROUP BY `a`.`id`
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '258'
-
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` = '258'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '583'
-
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` = '583'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1148'
-
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` = '1148'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1200'
-
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` = '1200'
-
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` = '1389'
-
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` = '1389'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1429'
-
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` = '1429'
-
SELECT *
FROM sls_social_default_avatars
WHERE `id` = '1'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1544'
-
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` = '1544'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1744'
-
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` = '1744'
-
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1774'
-
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` = '1774'
-
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='a6hvgd1iaubppp58omlp6q99b7'
-
UPDATE `sls_social_registrations` SET `profile_id`='1',`created`='2022-06-28 12:25:03',`step`='1',`step_access`=',1' WHERE `session_id` = 'a6hvgd1iaubppp58omlp6q99b7'
-
SELECT *
FROM sls_social_registrations
WHERE `session_id` = 'a6hvgd1iaubppp58omlp6q99b7'
-
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`='a6hvgd1iaubppp58omlp6q99b7'
-
UPDATE `sls_social_registrations` SET `profile_id`='1',`created`='2022-06-28 12:25:03',`values`='',`step`='1',`step_access`=',1',`errors`='' WHERE `session_id` = 'a6hvgd1iaubppp58omlp6q99b7'
-
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