rbutt67@gmail.com

J! Info Request Session Profile Queries239

26.635MB8.61s

Joomla! Version	5.2.1
PHP Version	8.2.24
Identity	guest
Response	200
Template	cassiopeia
Database	Server mysql Version 10.11.6-MariaDB-0+deb12u1 Collation utf8mb4_general_ci Conn Collation utf8mb4_general_ci

$_GET: []
$_POST: []
$_SESSION: array:2 [ "fb_1449592648992497_state" => "e0ac9f3b0f38f40df121ab4ca40b5799" "joomla" => "***reda...
$_COOKIE: []
$_SERVER: array:68 [ "USER" => "thepakistanlink" "HOME" => "/home/thepakistanlink" "SCRIPT_NAME" => "/in...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744443476 "last" => 1744443476...
registry: array:3 [ "data" => array:1 [ "com_kunena" => array:1 [ "user0_read" => array:2 [ ...
user: array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_easysocial: array:2 [ "easysocial" => array:1 [ "before_registration" => "L2NvbW11bml0eS84Mzgtcml6d2FuLWJ1...

afterLoad (93.87KB) (12.67ms)
afterInitialise (2.28MB) (417ms)
afterRoute (2.39MB) (580ms)
beforeRenderComponent com_easysocial (12.18KB) (32.55ms)
Before Access::preloadComponents (all components) (19.88KB) (926μs)
After Access::preloadComponents (all components) (139.81KB) (25.22ms)
Before Access::getAssetRules (id:1 name:root.1) (104B) (74μs)
After Access::getAssetRules (id:1 name:root.1) (7.2KB) (378μs)
Before Access::getAssetRules (id:289 name:com_kunena) (10.14MB) (3.32s)
After Access::getAssetRules (id:289 name:com_kunena) (1.75KB) (26μs)
Before Access::getAssetRules (id:1 name:root.1) (4.76MB) (1.92s)
After Access::getAssetRules (id:1 name:root.1) (1.28KB) (34μs)
beforeRenderRawModule mod_easysocial_sidebar (EasySocial Sidebar) (280.37KB) (254ms)
afterRenderRawModule mod_easysocial_sidebar (EasySocial Sidebar) (919.47KB) (488ms)
beforeRenderModule mod_easysocial_sidebar (EasySocial Sidebar) (736B) (24μs)
afterRenderModule mod_easysocial_sidebar (EasySocial Sidebar) (1.92KB) (515μs)
beforeRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (141.93KB) (13.14ms)
afterRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (2.41MB) (607ms)
beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (736B) (18μs)
afterRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (1.84KB) (244μs)
afterRenderComponent com_easysocial (68.31KB) (2.38ms)
afterDispatch (19.96KB) (35.98ms)
beforeRenderRawModule mod_easysocial_login (Member Login) (29.52KB) (3.04ms)
afterRenderRawModule mod_easysocial_login (Member Login) (36.25KB) (61.87ms)
beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (69μs)
afterRenderRawModule mod_easysocial_dating_search (Member Search) (30.35KB) (30.48ms)
beforeRenderRawModule mod_menu (Main Menu) (24.48KB) (986μs)
afterRenderRawModule mod_menu (Main Menu) (1.03MB) (196ms)
beforeRenderRawModule mod_finder (Smart Search) (22.19KB) (37.76ms)
afterRenderRawModule mod_finder (Smart Search) (84.98KB) (218ms)
beforeRenderRawModule mod_menu (Footer-a) (22.63KB) (8.99ms)
afterRenderRawModule mod_menu (Footer-a) (63.16KB) (2.82ms)
beforeRenderModule mod_menu (Footer-a) (416B) (5.12ms)
afterRenderModule mod_menu (Footer-a) (4.98KB) (312μs)
beforeRenderModule mod_easysocial_login (Member Login) (21.22KB) (943μs)
afterRenderModule mod_easysocial_login (Member Login) (6.92KB) (285μs)
beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (40μs)
afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (151μs)
beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (22.79KB) (601μs)
afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (98.25KB) (31.87ms)
beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (35μs)
afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.36KB) (274μs)
beforeRenderModule mod_finder (Smart Search) (21.8KB) (812μs)
afterRenderModule mod_finder (Smart Search) (2.94KB) (23.86ms)
beforeRenderModule mod_menu (Main Menu) (21.08KB) (5.51ms)
afterRenderModule mod_menu (Main Menu) (10.42KB) (329μs)
afterRender (539.15KB) (271ms)

1 x Before Access::getAssetRules (id:289 name:com_kunena) (10.14MB) (38.57%)	3.32s
1 x Before Access::getAssetRules (id:1 name:root.1) (4.76MB) (22.27%)	1.92s
1 x afterRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (2.41MB) (7.05%)	607ms
1 x afterRoute (2.39MB) (6.74%)	580ms
1 x afterRenderRawModule mod_easysocial_sidebar (EasySocial Sidebar) (919.47KB) (5.66%)	488ms
1 x afterInitialise (2.28MB) (4.84%)	417ms
1 x afterRender (539.15KB) (3.15%)	271ms
1 x beforeRenderRawModule mod_easysocial_sidebar (EasySocial Sidebar) (280.37KB) (2.95%)	254ms
1 x afterRenderRawModule mod_finder (Smart Search) (84.98KB) (2.53%)	218ms
1 x afterRenderRawModule mod_menu (Main Menu) (1.03MB) (2.27%)	196ms
1 x afterRenderRawModule mod_easysocial_login (Member Login) (36.25KB) (0.72%)	61.87ms
1 x beforeRenderRawModule mod_finder (Smart Search) (22.19KB) (0.44%)	37.76ms
1 x afterDispatch (19.96KB) (0.42%)	35.98ms
1 x beforeRenderComponent com_easysocial (12.18KB) (0.38%)	32.55ms
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (98.25KB) (0.37%)	31.87ms
1 x afterRenderRawModule mod_easysocial_dating_search (Member Search) (30.35KB) (0.35%)	30.48ms
1 x After Access::preloadComponents (all components) (139.81KB) (0.29%)	25.22ms
1 x afterRenderModule mod_finder (Smart Search) (2.94KB) (0.28%)	23.86ms
1 x beforeRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (141.93KB) (0.15%)	13.14ms
1 x afterLoad (93.87KB) (0.15%)	12.67ms
1 x beforeRenderRawModule mod_menu (Footer-a) (22.63KB) (0.1%)	8.99ms
1 x beforeRenderModule mod_menu (Main Menu) (21.08KB) (0.06%)	5.51ms
1 x beforeRenderModule mod_menu (Footer-a) (416B) (0.06%)	5.12ms
1 x beforeRenderRawModule mod_easysocial_login (Member Login) (29.52KB) (0.04%)	3.04ms
1 x afterRenderRawModule mod_menu (Footer-a) (63.16KB) (0.03%)	2.82ms
1 x afterRenderComponent com_easysocial (68.31KB) (0.03%)	2.38ms
1 x beforeRenderRawModule mod_menu (Main Menu) (24.48KB) (0.01%)	986μs
1 x beforeRenderModule mod_easysocial_login (Member Login) (21.22KB) (0.01%)	943μs
1 x Before Access::preloadComponents (all components) (19.88KB) (0.01%)	926μs
1 x beforeRenderModule mod_finder (Smart Search) (21.8KB) (0.01%)	812μs
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (22.79KB) (0.01%)	601μs
1 x afterRenderModule mod_easysocial_sidebar (EasySocial Sidebar) (1.92KB) (0.01%)	515μs
1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0%)	378μs
1 x afterRenderModule mod_menu (Main Menu) (10.42KB) (0%)	329μs
1 x afterRenderModule mod_menu (Footer-a) (4.98KB) (0%)	312μs
1 x afterRenderModule mod_easysocial_login (Member Login) (6.92KB) (0%)	285μs
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.36KB) (0%)	274μs
1 x afterRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (1.84KB) (0%)	244μs
1 x afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (0%)	151μs
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%)	74μs
1 x beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (0%)	69μs
1 x beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (0%)	40μs
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)	35μs
1 x After Access::getAssetRules (id:1 name:root.1) (1.28KB) (0%)	34μs
1 x After Access::getAssetRules (id:289 name:com_kunena) (1.75KB) (0%)	26μs
1 x beforeRenderModule mod_easysocial_sidebar (EasySocial Sidebar) (736B) (0%)	24μs
1 x beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (736B) (0%)	18μs

239 statements were executed, 15 of which were duplicates, 224 unique2.04s661.76KB

SELECT @@SESSION.sql_mode;152μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
SELECT `data` FROM `p8hb4_session` WHERE `session_id` = ?39.58ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
SELECT `session_id` FROM `p8hb4_session` WHERE `session_id` = :session_id LIMIT 1810μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
INSERT INTO `p8hb4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)53.55ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
SELECT `id`,`rules` FROM `p8hb4_viewlevels`4.9ms976B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM `p8hb4_usergroups` AS `a` LEFT JOIN `p8hb4_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest507μs1.33KBParams/libraries/src/Access/Access.php:868Copy
SELECT `value` FROM `p8hb4_admintools_storage` WHERE `key` = 'cparams'9.08ms520B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
SELECT `option`,`view`,`query` FROM `p8hb4_admintools_wafexceptions`1.1ms640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
SELECT `params` FROM `p8hb4_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'685μs1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
SELECT * FROM `p8hb4_social_config` WHERE `type` = 'site'3.68ms40.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT sampleData FROM p8hb4_kunena_version ORDER BY id DESC LIMIT 119.91ms536B/libraries/kunena/src/Forum/KunenaForum.php:374Copy
SELECT config_value FROM p8hb4_hikashop_config WHERE config_namekey = 'version'302μs536B/plugins/system/hikamarketoverrides/hikamarketoverrides.php:31Copy
SET SQL_BIG_SELECTS=1594μs0B/administrator/components/com_easysocial/includes/db/helpers/joomla40.php:25Copy
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`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`robots`,`e`.`auth`,`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 `p8hb4_users` AS `a` LEFT JOIN `p8hb4_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `p8hb4_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `p8hb4_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `p8hb4_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `p8hb4_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '838' GROUP BY `a`.`id`104ms5.44KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_default_avatars` WHERE `uid` IN (1) AND `type`='profiles'349μs1.42KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` FROM `p8hb4_usergroups` AS a INNER JOIN `p8hb4_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` IN (838)89.82ms656B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_users` where `user_id` IN (838)289μs3.66KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(838) AND `time` >= '1744442577' AND `client_id` <> '1'8.36ms576B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `sefurl` = 'community/838-rizwan-butt'618μs768B/libraries/src/Table/Table.php:780Copy
SELECT fas.* FROM p8hb4_jbusinessdirectory_application_settings fas5.62ms40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
SELECT fas.* FROM p8hb4_jbusinessdirectory_date_formats fas WHERE fas.id ='2'330μs768B/components/com_jbusinessdirectory/helpers/utils.php:78Copy
SELECT fas.* FROM p8hb4_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'298μs704B/components/com_jbusinessdirectory/helpers/utils.php:87Copy
SELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = '838-rizwan-butt.html' LIMIT 1469μs2.7KB/plugins/system/urltranslator/jbdrouter.php:225Copy
SELECT * FROM `p8hb4_jbusinessdirectory_companies` c where c.alias = '838-rizwan-butt.html' LIMIT 1682μs9.67KB/plugins/system/urltranslator/jbdrouter.php:181Copy
SELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = '838-rizwan-butt.html' LIMIT 117.3ms2.7KB/plugins/system/urltranslator/jbdrouter.php:225Copy
SELECT * FROM `p8hb4_jbusinessdirectory_companies` c where c.alias = '838-rizwan-butt.html' LIMIT 1754μs9.67KB/plugins/system/urltranslator/jbdrouter.php:181Copy
SELECT * FROM `p8hb4_languages` WHERE `published` = 1 ORDER BY `ordering` ASC16.27ms1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `p8hb4_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52)23.87ms7.94KBParams/libraries/src/Access/Access.php:357Copy
SELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'user' AND `state` = '1'1.18ms18.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `params` FROM `p8hb4_social_access` WHERE `uid` = NULL AND `type` = 'profiles'351μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )3.42ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.* FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.17ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_themes` WHERE `element` = 'wireframe'4.9ms3.13KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_apps`7.68ms26.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_easyblog_configs` WHERE `name` = 'config'36.44ms64.58KB/libraries/src/Table/Table.php:780Copy
SELECT COUNT(1) FROM `p8hb4_social_block_users` WHERE ( `user_id` = '838' AND `target_id` = '0' OR `target_id` = '838' AND `user_id` = '0' )330μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_profiles` WHERE `id` = '1'403μs2.56KB/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_workflows` WHERE `type` = 'user'372μs704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_workflows_maps` WHERE `uid` = '1' AND `type` = 'user'16.36ms704B/libraries/src/Table/Table.php:780Copy
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `p8hb4_social_fields` AS `a` LEFT JOIN `p8hb4_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `p8hb4_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE `a`.`unique_key` = 'HEADLINE' AND `d`.`type` = 'profiles' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC11.96ms2.8KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%' AND `client_id` = '0'297ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=838-rizwan-butt&view=profile'13.74ms768B/libraries/src/Table/Table.php:780Copy
select `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'752μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'group'5.47ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'group' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.05ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.* FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'group' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )2.58ms2.73KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'event'530μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'event' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.23ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.* FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'event' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )3.19ms2.7KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'page'532μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'page' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )3.9ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.* FROM `p8hb4_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'page' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.1ms2.73KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT a.*, l.`id` as `loc_id`, l.`uid` as `loc_uid`, l.`type` as `loc_type`, l.`user_id` as `loc_user_id`, l.`created` as `loc_created`, l.`short_address` as `loc_short_address`, l.`address` as `loc_address`, l.`longitude` as `loc_longitude`, l.`latitude` as `loc_latitude`, l.`params` as `loc_params`, md.`id` as `md_id`, md.`namespace` as `md_namespace`, md.`namespace_uid` as `md_namespace_uid`, md.`icon` as `md_icon`, md.`verb` as `md_verb`, md.`subject` as `md_subject`, md.`custom` as `md_custom`, md.`text` as `md_text`, md.`user_id` as `md_user_id`, md.`created` as `md_created`, a.`sticky_id` as `sticky`, a.`background_id`, 0 as bookmarked, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60) AS `min`, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60) AS `hour`, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60 / 24) AS `day` FROM ( select a1.* from `p8hb4_social_stream` as a1 where `actor_type` = 'user' and `actor_id` = '838' and `post_as` = 'user' UNION select a6.* from `p8hb4_social_stream` as a6 inner join `p8hb4_social_stream_tags` as st on a6.`id` = st.`stream_id` where st.`uid` = '838' and st.`utype` = 'user') as a LEFT JOIN `p8hb4_social_events_meta` AS em ON a.`cluster_id` = em.`cluster_id` LEFT JOIN `p8hb4_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `p8hb4_social_moods` AS md ON a.`mood_id` = md.`id` INNER JOIN `p8hb4_users` AS uu ON a.`actor_id` = uu.`id` AND uu.`block` = 0 INNER JOIN `p8hb4_social_stream_sticky` AS ssk ON a.`sticky_id` = ssk.`id` WHERE a.`state` IN('1','2') AND a.`cluster_id`= 0 AND a.`actor_type`='user' AND NOT (a.`context_type` IN ('users') and a.`cluster_type` is null) AND NOT (a.`context_type` = 'events' and a.`verb` IN ('update','makeadmin','notgoing') and a.`cluster_type` <=> 'event') AND NOT (a.`context_type` = 'guests' and a.`verb` IN ('feature','update','makeadmin','notgoing') and a.`cluster_type` <=> 'event') AND NOT (a.`context_type` = 'groups' and a.`verb` IN ('leave','makeadmin','update') and a.`cluster_type` <=> 'group') AND NOT (a.`context_type` = 'marketplaces' and a.`verb` IN ('update') and a.`cluster_type` <=> 'marketplace') AND NOT (a.`context_type` = 'pages' and a.`verb` IN ('update','makeAdmin') and a.`cluster_type` <=> 'page') AND NOT (a.`context_type` = 'discussions' and a.`verb` IN ('create','reply','answered','lock') and a.`cluster_type` <=> 'page') AND NOT (a.`context_type` = 'news' and a.`verb` IN ('create') and a.`cluster_type` <=> 'page') AND a.`access` = '0' ORDER BY a.`sticky_id` DESC4.23ms6.05KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT a.*, l.`id` as `loc_id`, l.`uid` as `loc_uid`, l.`type` as `loc_type`, l.`user_id` as `loc_user_id`, l.`created` as `loc_created`, l.`short_address` as `loc_short_address`, l.`address` as `loc_address`, l.`longitude` as `loc_longitude`, l.`latitude` as `loc_latitude`, l.`params` as `loc_params`, md.`id` as `md_id`, md.`namespace` as `md_namespace`, md.`namespace_uid` as `md_namespace_uid`, md.`icon` as `md_icon`, md.`verb` as `md_verb`, md.`subject` as `md_subject`, md.`custom` as `md_custom`, md.`text` as `md_text`, md.`user_id` as `md_user_id`, md.`created` as `md_created`, a.`sticky_id` as `sticky`, a.`background_id`, 0 as bookmarked, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60) AS `min`, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60) AS `hour`, FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60 / 24) AS `day` FROM ( select a1.* from `p8hb4_social_stream` as a1 where `actor_type` = 'user' and `actor_id` = '838' and `post_as` = 'user' UNION select a2.* from `p8hb4_social_stream` as a2 inner join `p8hb4_social_stream_item` as ai2 on a2.`id` = ai2.`uid` where a2.`actor_type` = 'user' and a2.`target_id` = '838' and a2.`context_type` IN ('friends','story','photos','links','files','videos','reviews') and ((ai2.`context_type` = 'friends' and ai2.`verb` = 'add') or (ai2.`context_type` = 'story' and ai2.`verb` = 'create') or (ai2.`context_type` = 'photos' and ai2.`verb` = 'share') or (ai2.`context_type` = 'links' and ai2.`verb` = 'create') or (ai2.`context_type` = 'files' and ai2.`verb` = 'create') or (ai2.`context_type` = 'videos' and ai2.`verb` = 'create') or (ai2.`context_type` = 'reviews' and ai2.`verb` = 'create') ) UNION select a6.* from `p8hb4_social_stream` as a6 inner join `p8hb4_social_stream_tags` as st on a6.`id` = st.`stream_id` where st.`uid` = '838' and st.`utype` = 'user') as a LEFT JOIN `p8hb4_social_events_meta` AS em ON a.`cluster_id` = em.`cluster_id` LEFT JOIN `p8hb4_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `p8hb4_social_moods` AS md ON a.`mood_id` = md.`id` INNER JOIN `p8hb4_users` AS uu ON a.`actor_id` = uu.`id` AND uu.`block` = 0 WHERE a.`state` IN('1','2') AND ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 and a.`cluster_access` IN (1, 4)) ) AND a.`actor_type`='user' AND NOT (a.`context_type` IN ('users') and a.`cluster_type` is null) AND NOT (a.`context_type` = 'events' and a.`verb` IN ('update','makeadmin','notgoing') and a.`cluster_type` <=> 'event') AND NOT (a.`context_type` = 'guests' and a.`verb` IN ('feature','update','makeadmin','notgoing') and a.`cluster_type` <=> 'event') AND NOT (a.`context_type` = 'groups' and a.`verb` IN ('leave','makeadmin','update') and a.`cluster_type` <=> 'group') AND NOT (a.`context_type` = 'marketplaces' and a.`verb` IN ('update') and a.`cluster_type` <=> 'marketplace') AND NOT (a.`context_type` = 'pages' and a.`verb` IN ('update','makeAdmin') and a.`cluster_type` <=> 'page') AND NOT (a.`context_type` = 'discussions' and a.`verb` IN ('create','reply','answered','lock') and a.`cluster_type` <=> 'page') AND NOT (a.`context_type` = 'news' and a.`verb` IN ('create') and a.`cluster_type` <=> 'page') AND a.`access` = '0' AND a.`sticky_id` = 0 ORDER BY a.`modified` DESC LIMIT 0,11216ms70.23KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (58) AND `context_type`='kunena' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (55) AND `context_type`='links' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (54) AND `context_type`='pages' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (49,48,47,46,41) AND `context_type`='photos' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (39,38) AND `context_type`='photos'56.22ms1.61KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_clusters` where id in (1,4,3)493μs2.78KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_clusters_categories` where id in (9,14,2)387μs1.66KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
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`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`robots`,`e`.`auth`,`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 `p8hb4_users` AS `a` LEFT JOIN `p8hb4_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `p8hb4_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `p8hb4_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `p8hb4_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `p8hb4_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` IN ('9', '10', '12', '11') GROUP BY `a`.`id`790μs5.42KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_photos` where `id` IN (33,32,31,30,28) UNION select * from `p8hb4_social_photos` where `id` IN (26,25)8.19ms2.61KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_photos_meta` where `photo_id` IN (33,32,31,30,28) UNION select * from `p8hb4_social_photos_meta` where `photo_id` IN (26,25)3.4ms1.73KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_albums` where `id` IN (12,11,10,9)606μs2.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_stream_tags` WHERE `stream_id` IN('58','55','54','49','48','47','46','41','39','38') ORDER BY `stream_id`, `offset` DESC139ms1.27KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT a.* FROM `p8hb4_social_likes` AS a INNER JOIN `p8hb4_users` AS b ON a.`created_by` = b.`id` WHERE a.stream_id IN (58,55,54,49,48,47,46,41,39,38) AND b.`block` = '0'423μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (58) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (55) and `element` = 'stream.page' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (54) and `element` = 'stream.page' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (49) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (48) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (47) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (46) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (41) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (39) and `element` = 'stream.group' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (38) and `element` = 'stream.group'753μs640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select * from `p8hb4_social_shares` where id IN (1,33,32,31,30,28,26,25)413μs11.89KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) as `cnt`, x.`uid`, x.`element`, x.`stream_id` from `p8hb4_social_comments` as x where stream_id IN (58,55,54,49,48,47,46,41,39,38) AND x.`parent` = '0' group by x.`element`, x.`uid`, x.`stream_id`311μs688B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SHOW FULL COLUMNS FROM `p8hb4_kunena_topics`1.15ms1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT * FROM `p8hb4_kunena_topics` WHERE `id` = '1'6.47ms2.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT * FROM `p8hb4_kunena_categories` ORDER BY `ordering`,`name`5.74ms4.77KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:109Copy
SHOW FULL COLUMNS FROM `p8hb4_kunena_categories`1.66ms1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '4'442μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '3'546μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '6'11.88ms4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '5'462μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '1'878μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '2'600μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT * FROM `p8hb4_kunena_categories` WHERE `id` = '7'428μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SHOW FULL COLUMNS FROM `p8hb4_kunena_users`1.24ms2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT DISTINCT(user_id) FROM `p8hb4_usergroups` AS `ug1` INNER JOIN `p8hb4_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `p8hb4_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 8)401μs536B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECT DISTINCT(user_id) FROM `p8hb4_usergroups` AS `ug1` INNER JOIN `p8hb4_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `p8hb4_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 7)323μs520B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECT `user_id`,`category_id`,`role` FROM `p8hb4_kunena_user_categories` WHERE `role` IN (1,2)3.85ms640B/libraries/kunena/src/Access/KunenaAccess.php:184Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='58' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a457μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SHOW FULL COLUMNS FROM `p8hb4_kunena_messages`1.12ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT m.*,t.message FROM `p8hb4_kunena_messages` AS `m` INNER JOIN `p8hb4_kunena_messages_text` AS `t` ON `m`.`id` = `t`.`mesid` WHERE `m`.`id` = 138.37ms2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
SELECT * FROM `p8hb4_kunena_attachments` WHERE `mesid` IN (1)2.41ms1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
SELECT `code`,`location` FROM `p8hb4_kunena_smileys`8.09ms576B/libraries/kunena/src/BBCode/KunenaBBCode.php:1130Copy
SELECT * FROM `p8hb4_social_emoticons` AS `a` WHERE `a`.`state` = '1' ORDER BY `a`.`title` asc508μs1.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`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` FROM `p8hb4_social_clusters` AS `a` LEFT JOIN `p8hb4_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = `a`.`cluster_type` LEFT JOIN `p8hb4_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = `a`.`cluster_type` WHERE `a`.`id` = '1' AND `a`.`cluster_type` = 'page'2.85ms4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE u.`block` = 0 AND a.`cluster_id` = '1' AND a.`state` = '1' AND a.`admin` = '1'669μs1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE u.`block` = 0 AND a.`cluster_id` = '1' AND a.`state` = '2'509μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '1' AND `owner` = '1'1.04ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='55' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a311μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_stream_assets` WHERE `stream_id` = '55' AND `type` = 'links'13.38ms704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'page' AND `state` = '1'757μs1.83KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `params` FROM `p8hb4_social_access` WHERE `uid` = '9' AND `type` = 'clusters'345μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_links` WHERE `hash` = '3a9b786a829c6bddd16d2098468c682e'21.77ms704B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=1:pines-dairy&layout=item&view=pages'352μs768B/libraries/src/Table/Table.php:780Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '55' AND a.`element` = 'links.page.create' AND a.`uid` = '55' AND a.`parent` = '0'8.82ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '55' AND a.`element` = 'links.page.create' AND a.`uid` = '55'243μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '1' AND `state` = '1'2.5ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`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` FROM `p8hb4_social_clusters` AS `a` LEFT JOIN `p8hb4_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = `a`.`cluster_type` LEFT JOIN `p8hb4_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = `a`.`cluster_type` WHERE `a`.`id` = '4' AND `a`.`cluster_type` = 'group'922μs4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id and up.community_access = 1 WHERE a.`cluster_id` = '4' AND u.`block` = 0 AND a.`state` = '1' AND a.`admin` = '1'2.43ms1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id and up.community_access = 1 WHERE a.`cluster_id` = '4' AND u.`block` = 0 AND a.`state` = '2'651μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'group' AND `state` = '1'703μs1.95KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `params` FROM `p8hb4_social_access` WHERE `uid` = '2' AND `type` = 'clusters'332μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=4:automobile-agents&layout=item&view=groups'517μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=33:car-insurance-icon-1&layout=item&type=group&uid=4:automobile-agents&view=photos'540μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='49' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a778μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '4' AND `state` = '1'2.17ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '49' AND a.`element` = 'photos.group.uploadAvatar' AND a.`uid` = '33' AND a.`parent` = '0'417μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '49' AND a.`element` = 'photos.group.uploadAvatar' AND a.`uid` = '33'308μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=32:cars-banner&layout=item&type=group&uid=4:automobile-agents&view=photos'925μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='48' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a1.38ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '48' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '32' AND a.`parent` = '0'1.57ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '48' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '32'251μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`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` FROM `p8hb4_social_clusters` AS `a` LEFT JOIN `p8hb4_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = `a`.`cluster_type` LEFT JOIN `p8hb4_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = `a`.`cluster_type` WHERE `a`.`id` = '3' AND `a`.`cluster_type` = 'group'25.29ms4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id and up.community_access = 1 WHERE a.`cluster_id` = '3' AND u.`block` = 0 AND a.`state` = '1' AND a.`admin` = '1'835μs1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.* from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on u.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id and up.community_access = 1 WHERE a.`cluster_id` = '3' AND u.`block` = 0 AND a.`state` = '2'2.12ms1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `params` FROM `p8hb4_social_access` WHERE `uid` = '14' AND `type` = 'clusters'845μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=3:real-estate-agents&layout=item&view=groups'649μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=31:house-size&layout=item&type=group&uid=3:real-estate-agents&view=photos'737μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='47' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a449μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '3' AND `state` = '1'739μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '47' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '31' AND a.`parent` = '0'222μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '47' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '31'1.65ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=30:rem-icon-256x256-1&layout=item&type=group&uid=3:real-estate-agents&view=photos'402μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='46' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a423μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '46' AND a.`element` = 'photos.group.uploadAvatar' AND a.`uid` = '30' AND a.`parent` = '0'323μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '46' AND a.`element` = 'photos.group.uploadAvatar' AND a.`uid` = '30'441μs8.52KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=28:house&layout=item&type=group&uid=3:real-estate-agents&view=photos'789μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='41' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a1.07ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '41' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '28' AND a.`parent` = '0'208μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '41' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '28'198μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=26:cars-banner&layout=item&type=group&uid=4:automobile-agents&view=photos'452μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='39' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a5.1ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '39' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '26' AND a.`parent` = '0'377μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '39' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '26'1.92ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=25:cars-banner&layout=item&type=group&uid=4:automobile-agents&view=photos'551μs768B/libraries/src/Table/Table.php:780Copy
SELECT a.*, (SELECT count(1) from `p8hb4_social_likes` AS b INNER JOIN `p8hb4_users` AS u ON b.`created_by` = u.`id` WHERE a.`action` = b.`reaction` AND b.`stream_id`='38' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a2.3ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '38' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '25' AND a.`parent` = '0'274μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '38' AND a.`element` = 'photos.group.updateCover' AND a.`uid` = '25'270μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `p8hb4_modules` AS `m` LEFT JOIN `p8hb4_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `p8hb4_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`2.07ms18.13KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
SELECT `a`.* FROM `p8hb4_social_apps` AS a LEFT JOIN `p8hb4_social_apps_map` as b ON b.`app_id` = a.`id` AND b.`uid` = '838' AND b.`type` = 'user' WHERE a.`state` = '1' AND a.`type` = 'apps' AND a.`group` = 'user' AND a.`widget` = '1' AND (`a`.`default` = 1 OR `b`.`id` IS NOT NULL OR `a`.`system` = 1) ORDER BY a.`ordering` asc2.39ms2.55KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_apps_access` WHERE `app_id` = '6'2.4ms640B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_apps_access` WHERE `app_id` = '9'1.25ms640B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_apps_access` WHERE `app_id` = '14'1.85ms640B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_apps_access` WHERE `app_id` = '19'995μs640B/libraries/src/Table/Table.php:780Copy
SELECT `b`.* FROM `p8hb4_social_avatars` AS `a` INNER JOIN `p8hb4_social_photos` AS `b` ON `a`.`photo_id` = `b`.`id` WHERE `a`.`uid` = '838' AND `a`.`type` = 'user'1.67ms2.5KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '19'2.16ms848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_albums` WHERE `id` = '4'453μs2.53KB/libraries/src/Table/Table.php:780Copy
SELECT a.*, b.`custom_message`, b.`created` AS achieved_date FROM `p8hb4_social_badges` AS a INNER JOIN `p8hb4_social_badges_maps` AS b ON a.`id` = b.`badge_id` WHERE b.`user_id` = '838' AND a.`state` = '1'4.16ms2.38KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=838-rizwan-butt&layout=about&view=profile'7.46ms768B/libraries/src/Table/Table.php:780Copy
SELECT a.* FROM `p8hb4_social_apps` AS a INNER JOIN `p8hb4_social_apps_map` AS b ON b.`app_id` = a.`id` AND b.`uid`='838' AND b.`type`='user' INNER JOIN `p8hb4_social_apps_views` AS `c` ON c.`app_id` = a.`id` AND ( c.`view` = 'profile' OR c.`view` = 'dashboard' ) WHERE a.`state`='1' AND a.`type`='apps' AND a.`group`='user' UNION ALL SELECT a.* FROM `p8hb4_social_apps` AS a INNER JOIN `p8hb4_social_apps_views` AS `c` ON c.`app_id` = a.`id` AND ( c.`view` = 'profile' OR c.`view` = 'dashboard' ) WHERE a.`state`='1' AND a.`type`='apps' AND a.`group`='user' AND (a.`core` = 1 OR a.`default` = 1)1.93ms2.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=friends'4.48ms768B/libraries/src/Table/Table.php:780Copy
SELECT `params` FROM `p8hb4_social_access` WHERE `uid` = '1' AND `type` = 'profiles'5.72ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'type=user&uid=838-rizwan-butt&view=albums'1.24ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'type=user&uid=838-rizwan-butt&view=videos'434μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'type=user&uid=838-rizwan-butt&view=audios'760μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=followers'595μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=pages'347μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=events'3.29ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=groups'545μs768B/libraries/src/Table/Table.php:780Copy
SELECT `b`.`id` FROM `p8hb4_user_usergroup_map` AS `map` LEFT JOIN `p8hb4_usergroups` AS `a` ON `a`.`id` = `map`.`group_id` LEFT JOIN `p8hb4_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `map`.`user_id` = :userId549μs1.33KBParams/libraries/src/Access/Access.php:868Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'userid=838-rizwan-butt&view=polls'1.68ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'type=user&uid=838-rizwan-butt&view=marketplaces'469μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=1:registered-users&layout=item&view=profiles'551μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'id=26:newbie&layout=item&view=badges'71ms768B/libraries/src/Table/Table.php:780Copy
SELECT COUNT(1) FROM `p8hb4_social_block_users` WHERE `user_id` = '0' AND `target_id` = '838'3.41ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_friends` WHERE ( `actor_id`='838' AND `target_id`='0' ) OR ( `target_id`='838' AND `actor_id`='0' )2.27ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'layout=edit&view=profile'12.93ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_backgrounds` WHERE `state`='1'3.76ms832B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'layout=achievements&userid=838-rizwan-butt&view=badges'6.22ms768B/libraries/src/Table/Table.php:780Copy
SELECT COUNT(DISTINCT(a.`badge_id`)) FROM `p8hb4_social_badges_maps` AS a INNER JOIN `p8hb4_social_badges` AS b ON a.`badge_id` = b.`id` WHERE a.`user_id`='838' AND b.`state`='1'3.89ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'layout=history&userid=838-rizwan-butt&view=points'5.86ms768B/libraries/src/Table/Table.php:780Copy
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `p8hb4_social_fields` AS `a` LEFT JOIN `p8hb4_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `p8hb4_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE `a`.`unique_key` = 'GENDER' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC3.95ms2.81KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_fields_data` WHERE `uid` = '838' AND `type` = 'user' ORDER BY `field_id` ASC,`datakey` ASC2.42ms992B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_fields_options` WHERE `parent_id` IN ('10') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC6.92ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `p8hb4_social_fields` AS `a` LEFT JOIN `p8hb4_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `p8hb4_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE `a`.`unique_key` = 'BIRTHDAY' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC3.99ms2.81KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_fields_options` WHERE `parent_id` IN ('11') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC254μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `p8hb4_social_fields` AS `a` LEFT JOIN `p8hb4_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `p8hb4_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE `a`.`unique_key` = 'ADDRESS' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC7.14ms2.81KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_fields_options` WHERE `parent_id` IN ('12') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC462μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`creator_uid` = '838' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03')) ORDER BY `b`.`start` asc) AS zcount4.27ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`creator_uid` = '838' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03')) ORDER BY `b`.`start` asc LIMIT 0, 51.04ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(distinct(a.id)) as id FROM `p8hb4_social_clusters` as a INNER JOIN `p8hb4_social_events_meta` as b ON a.`id` = b.`cluster_id` WHERE a.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`creator_uid` = '838' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03'))2.34ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` LEFT JOIN `p8hb4_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`state` = '1' AND `c`.`uid` = '838' AND `c`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03')) ORDER BY `b`.`start` asc) AS zcount6.21ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` LEFT JOIN `p8hb4_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`state` = '1' AND `c`.`uid` = '838' AND `c`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03')) ORDER BY `b`.`start` asc LIMIT 0, 523.37ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select count(distinct(a.id)) as id FROM `p8hb4_social_clusters` as a INNER JOIN `p8hb4_social_events_meta` as b ON a.`id` = b.`cluster_id` LEFT JOIN `p8hb4_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE a.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND (b.`group_id` = 0 OR b.`group_id` = ( select distinct(g.`id`) from `p8hb4_social_clusters` as g where g.`id` = b.`group_id` and g.`cluster_type` = 'group' and g.`type` IN ('1','4') ) ) AND (b.`page_id` = 0 OR b.page_id = ( select distinct(pp.`id`) from `p8hb4_social_clusters` as pp where pp.`id` = b.`page_id` and pp.`cluster_type` = 'page' and pp.`type` = '1' ) ) AND `a`.`state` = '1' AND `c`.`uid` = '838' AND `c`.`state` = '1' AND (`b`.`start` >= '2025-04-12 07:38:03' OR (`b`.`start` <= '2025-04-12 07:38:03' AND `b`.`end` >= '2025-04-12 07:38:03'))15.15ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` LEFT JOIN `p8hb4_social_clusters_nodes` AS `nodes` ON a.`id` = nodes.`cluster_id` WHERE a.`cluster_type`='group' AND nodes.`uid` = '838' AND nodes.`state`='1' AND ( (a.`type` IN ('2','1')) OR (a.`type` > 1 and (select count(*) from `p8hb4_social_clusters_nodes` as aa where aa.`cluster_id` = a.`id` and aa.`uid` = 0) > 0) ) AND a.`state`= '1') AS zcount30.32ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` LEFT JOIN `p8hb4_social_clusters_nodes` AS `nodes` ON a.`id` = nodes.`cluster_id` WHERE a.`cluster_type`='group' AND nodes.`uid` = '838' AND nodes.`state`='1' AND ( (a.`type` IN ('2','1')) OR (a.`type` > 1 and (select count(*) from `p8hb4_social_clusters_nodes` as aa where aa.`cluster_id` = a.`id` and aa.`uid` = 0) > 0) ) AND a.`state`= '1' ORDER BY a.`created` DESC LIMIT 568.4ms552B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT COUNT(1) FROM (SELECT DISTINCT(a.id) FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_clusters_nodes` AS `b` ON `b`.`cluster_id` = `a`.`id` WHERE `a`.`cluster_type` = 'page' AND `b`.`state` = '1' AND `b`.`uid` = '838' AND `a`.`type` IN ('2', '1') AND `a`.`state` = '1') AS zcount2.24ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT DISTINCT(a.id) FROM `p8hb4_social_clusters` AS `a` INNER JOIN `p8hb4_social_clusters_nodes` AS `b` ON `b`.`cluster_id` = `a`.`id` WHERE `a`.`cluster_type` = 'page' AND `b`.`state` = '1' AND `b`.`uid` = '838' AND `a`.`type` IN ('2', '1') AND `a`.`state` = '1' ORDER BY `a`.`created` DESC LIMIT 0, 5547μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=pages'1.56ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=groups'5.19ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=events'1.2ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=videos'3.66ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=audios'3.34ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'layout=all&view=albums'6.14ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=polls'2.13ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=marketplaces'1.27ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'view=dashboard'6.33ms768B/libraries/src/Table/Table.php:780Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'1.9ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'2.79ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
select distinct a.* from `p8hb4_finder_taxonomy` as a inner join `p8hb4_finder_taxonomy_map` as b on a.`id` = b.`node_id` inner join `p8hb4_finder_links` as c on c.`link_id` = b.`link_id` where a.`access` IN ( 1,5 ) and a.`state` = 1 and a.`parent_id` = ( select id from `p8hb4_finder_taxonomy` where `parent_id` = 1 and `title` = 'Type' ) AND a.`title` IN (select `title` FROM `p8hb4_finder_types`)5ms1.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'6.03ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'5.93ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'13.38ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'8.84ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'format=html&id=838-rizwan-butt&view=profile'6.1ms752B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_profiles` WHERE `id` = '1'3.67ms2.56KB/libraries/src/Table/Table.php:780Copy
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `p8hb4_social_fields` AS `a` LEFT JOIN `p8hb4_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `p8hb4_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE ( `a`.`core` = '1' OR `a`.`state` = '1' ) AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC7.14ms19.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_fields_options` WHERE `parent_id` IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '13', '14', '15', '16', '17') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC14.91ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT `template` FROM `p8hb4_template_styles` WHERE `home` = '1' AND `client_id` ='0'4.27ms536B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
SELECT * FROM `p8hb4_social_profiles` WHERE `id` = '1'10.84ms2.56KB/libraries/src/Table/Table.php:780Copy
SELECT id,placeholder FROM `p8hb4_gdpr_checkbox`255μs576B/plugins/system/gdpr/gdpr.php:1912Copy
SELECT * FROM `p8hb4_social_profiles` WHERE `id` = '1'689μs2.56KB/libraries/src/Table/Table.php:780Copy
SELECT template FROM `p8hb4_template_styles` AS s LEFT JOIN `p8hb4_extensions` AS e ON e.type = `template` AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = '1' AND home = 11.26ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
select a.`unique_key`, a.`title`, b.`element`, a.`params` from `p8hb4_social_fields` as a inner join `p8hb4_social_fields_steps` as fs on a.`step_id` = fs.`id` and fs.`type` = 'profiles' inner join `p8hb4_social_workflows_maps` as wm on wm.`workflow_id` = fs.`workflow_id` and wm.`type` = 'user' inner join `p8hb4_social_profiles` as p on wm.`uid` = p.`id` inner join `p8hb4_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' and b.`element` IN ('address','birthday','gender','joomla_fullname','joomla_username','relationship')7.63ms752B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=events'942μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=pages'9.41ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=groups'5.13ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=marketplaces'478μs768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=users'1.02ms768B/libraries/src/Table/Table.php:780Copy
SELECT * FROM `p8hb4_social_urls` WHERE `rawurl` = 'filter=all&view=videos'442μs800B/libraries/src/Table/Table.php:780Copy
SELECT * FROM p8hb4_hikashop_config4.52ms24.63KB/administrator/components/com_hikashop/classes/config.php:16Copy
SET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));6.06ms0B/administrator/components/com_hikashop/helpers/helper.php:3357Copy
SELECT * FROM p8hb4_hikamarket_config5.14ms2.13KB/administrator/components/com_hikamarket/classes/config.php:16Copy
SELECT `name`,`element` FROM `p8hb4_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 18.35ms896B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
SELECT `title` FROM `p8hb4_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)420μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
SELECT * FROM `p8hb4_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'4.38ms2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
SHOW FULL COLUMNS FROM `p8hb4_gsd_config`722μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT * FROM `p8hb4_gsd_config` WHERE `name` = 'config'208μs592B/libraries/src/Table/Table.php:780Copy
SELECT a.* FROM p8hb4_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc871μs1.42KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT * FROM p8hb4_jmap_metainfo WHERE `linkurl` = 'https://thepakistanlink.com/community/838-rizwan-butt.html' AND `published` = 11.78ms912B/plugins/system/jmap/jmap.php:817Copy
SELECT * FROM p8hb4_jmap_canonicals WHERE `linkurl` = 'https://thepakistanlink.com/community/838-rizwan-butt.html'2.6ms640B/plugins/system/jmap/jmap.php:919Copy
SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `p8hb4_scheduler_tasks` AS `a` WHERE `a`.`state` = 14.16ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
SELECT * FROM p8hb4_jmap_headings WHERE `linkurl` = 'https://thepakistanlink.com/community/838-rizwan-butt.html'881μs752B/plugins/system/jmap/jmap.php:1134Copy
SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `p8hb4_jmap_text_replacements` WHERE `published` = 1465μs688B/plugins/system/jmap/jmap.php:509Copy
SELECT `session_id` FROM `p8hb4_session` WHERE `session_id` = ?42.88ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
UPDATE `p8hb4_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?11.87ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy

Member Login

Member Search