Pellentesque convallis est vel velit luctus, in consequat tortor rutrum. In lectus quam, tempor eu diam efficitur, fringilla aliquet sapien. Praesent quis tellus id enim imperdiet tempor. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices po
Pellentesque convallis est vel velit luctus, in consequat tortor rutrum. In lectus quam, tempor eu diam efficitur, fringilla aliquet sapien. Praesent quis tellus id enim imperdiet tempor. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices po
LessIn order to perform this action you have to login
In order to perform this action you have to login
Joomla! Version | 5.2.1 |
PHP Version | 8.2.24 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterRenderRawModule mod_easysocial_stream (Site Activity) (6.32MB) (23.1%) | 1.21s |
1 x afterRenderRawModule mod_easybloglatestblogs (Latest Blogs) (4.07MB) (15.63%) | 816ms |
1 x afterRenderRawModule mod_djclassifieds_search (Search Classifieds) (710.02KB) (9.79%) | 511ms |
1 x afterInitialise (2.28MB) (7.83%) | 409ms |
1 x afterRenderComponent com_jbusinessdirectory (2.26MB) (7.14%) | 373ms |
1 x afterDispatch (4.13MB) (7.12%) | 372ms |
1 x afterRenderRawModule mod_easysocial_pages (Business Pages) (465.31KB) (5.54%) | 289ms |
1 x afterRender (574.55KB) (4.5%) | 235ms |
1 x afterRenderRawModule mod_finder (Smart Search) (91.18KB) (4.3%) | 225ms |
1 x afterRenderRawModule mod_easysocial_groups (Groups) (450.53KB) (3.32%) | 174ms |
1 x afterRenderRawModule mod_easysocial_videos (Latest Videos) (221.85KB) (2.7%) | 141ms |
1 x afterRenderRawModule mod_easysocial_albums (Photos) (667.8KB) (2.32%) | 121ms |
1 x afterRoute (342.66KB) (2.11%) | 110ms |
1 x Before Access::preloadComponents (all components) (108.82KB) (1.9%) | 99.20ms |
1 x afterRenderRawModule mod_easysocial_login (Member Login) (84.14KB) (1.48%) | 77.46ms |
1 x afterRenderRawModule mod_easysocial_dating_search (Member Search) (29.95KB) (0.63%) | 32.67ms |
1 x After Access::preloadComponents (all components) (141.95KB) (0.21%) | 11.06ms |
1 x afterLoad (93.87KB) (0.09%) | 4.53ms |
1 x afterRenderModule mod_finder (Smart Search) (3.41KB) (0.06%) | 3.30ms |
1 x beforeRenderModule mod_finder (Smart Search) (1.41KB) (0.04%) | 2.24ms |
1 x beforeRenderModule mod_easysocial_login (Member Login) (5.02KB) (0.04%) | 1.97ms |
1 x beforeRenderRawModule mod_easysocial_login (Member Login) (30.57KB) (0.02%) | 1.26ms |
1 x beforeRenderComponent com_jbusinessdirectory (17.82KB) (0.02%) | 1.15ms |
1 x beforeRenderRawModule mod_finder (Smart Search) (27.52KB) (0.02%) | 958μs |
1 x afterRenderModule mod_easysocial_login (Member Login) (6.95KB) (0.01%) | 440μs |
1 x afterRenderModule mod_easybloglatestblogs (Latest Blogs) (6.42KB) (0%) | 228μs |
1 x afterRenderModule mod_easysocial_stream (Site Activity) (30.41KB) (0%) | 227μs |
1 x afterRenderModule mod_easysocial_videos (Latest Videos) (10.41KB) (0%) | 217μs |
1 x afterRenderModule mod_djclassifieds_search (Search Classifieds) (10.42KB) (0%) | 198μs |
1 x beforeRenderRawModule mod_djclassifieds_search (Search Classifieds) (1016B) (0%) | 192μs |
1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0%) | 170μs |
1 x afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (0%) | 145μs |
1 x afterRenderModule mod_easysocial_albums (Photos) (10.44KB) (0%) | 108μs |
1 x afterRenderModule mod_easysocial_pages (Business Pages) (6.44KB) (0%) | 93μs |
1 x afterRenderModule mod_easysocial_groups (Groups) (6.44KB) (0%) | 83μs |
1 x beforeRenderRawModule mod_easysocial_pages (Business Pages) (2.86KB) (0%) | 80μs |
1 x beforeRenderRawModule mod_easysocial_groups (Groups) (720B) (0%) | 78μs |
1 x beforeRenderRawModule mod_easysocial_stream (Site Activity) (6.81KB) (0%) | 75μs |
1 x beforeRenderRawModule mod_easysocial_videos (Latest Videos) (4.59KB) (0%) | 70μs |
1 x beforeRenderRawModule mod_easybloglatestblogs (Latest Blogs) (7.38KB) (0%) | 69μs |
1 x beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (0%) | 65μs |
1 x beforeRenderRawModule mod_easysocial_albums (Photos) (400B) (0%) | 59μs |
1 x beforeRenderModule mod_easysocial_groups (Groups) (4.84KB) (0%) | 44μs |
1 x beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (0%) | 41μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%) | 40μs |
1 x beforeRenderModule mod_djclassifieds_search (Search Classifieds) (736B) (0%) | 34μs |
1 x beforeRenderModule mod_easysocial_pages (Business Pages) (2.31KB) (0%) | 31μs |
1 x beforeRenderModule mod_easysocial_albums (Photos) (2.84KB) (0%) | 30μs |
1 x beforeRenderModule mod_easybloglatestblogs (Latest Blogs) (736B) (0%) | 30μs |
1 x beforeRenderModule mod_easysocial_stream (Site Activity) (736B) (0%) | 20μs |
1 x beforeRenderModule mod_easysocial_videos (Latest Videos) (736B) (0%) | 18μs |
SELECT @@SESSION.sql_mode;
144μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `p8hb4_session`
WHERE `session_id` = ?
1.13ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = :session_id LIMIT 1
302μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `p8hb4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
19.84ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `p8hb4_viewlevels`
351μs976B/libraries/src/Access/Access.php:955CopySELECT `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` = :guest
394μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `p8hb4_admintools_storage`
WHERE `key` = 'cparams'
15.9ms520B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `p8hb4_admintools_wafexceptions`
602μs640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
3.7ms1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT * FROM `p8hb4_social_config` WHERE `type` = 'site'
1.07ms40.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT sampleData
FROM p8hb4_kunena_version
ORDER BY id DESC LIMIT 1
39.51ms536B/libraries/kunena/src/Forum/KunenaForum.php:374CopySELECT config_value FROM p8hb4_hikashop_config WHERE config_namekey = 'version'
13.21ms536B/plugins/system/hikamarketoverrides/hikamarketoverrides.php:31CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_application_settings fas
38.86ms40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'
2.72ms768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'
298μs704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'camera-photography-1' LIMIT 1
542μs2.72KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'camera-photography-1' LIMIT 1
3.27ms3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM p8hb4_jbusinessdirectory_mobile_app_config
4.82ms1.63KB/components/com_jbusinessdirectory/helpers/utils.php:9380CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_default_attributes`
967μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM p8hb4_jbusinessdirectory_default_attributes
310μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_companies`
1.35ms2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_categories`
12.57ms1.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=13
338μs18.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from p8hb4_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name
1.16ms19.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copyinsert into p8hb4_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values
('2','1','2025-04-25','13','0')
553μs0B/components/com_jbusinessdirectory/helpers/utils.php:7609Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=13
668μs2.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from p8hb4_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name
896μs19.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=1
73μs0B/components/com_jbusinessdirectory/helpers/utils.php:6864Copyselect * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from p8hb4_jbusinessdirectory_companies cp
left join p8hb4_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p8hb4_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
where 1 and cc.categoryId in (23,24,13)
and cp.state=1 and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
having 1
) s
where 1
36.15ms720B/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000
3.85ms0B/components/com_jbusinessdirectory/helpers/utils.php:6845Copyselect slec.* , companyName , featured
from (
select
cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
from p8hb4_jbusinessdirectory_companies cp
left join p8hb4_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p8hb4_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join p8hb4_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join p8hb4_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join p8hb4_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join p8hb4_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join p8hb4_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.state=1 and cc.categoryId in (23,24,13)
and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
) as slec
where 1
having 1
order by featured desc LIMIT 20
4.04ms1.48KB/administrator/components/com_jbusinessdirectory/tables/company.php:1121Copyselect slec.* , companyName , featured
from (
select
cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,
cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile,
cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,
cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,
cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,
cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,
cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.lft separator '#|') as categories,
GROUP_CONCAT( DISTINCT cg.id) as categoryIds,
bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker,bcm.icon as mainCategoryIcon, bcm.iconImgLocation as categoryIconImage, bcm.id as mainCategoryId,
GROUP_CONCAT(DISTINCT ct.name) as typeName,
bk.id as bookmark,
count(distinct cr.id) as nr_reviews,
cn.country_name as countryName
from p8hb4_jbusinessdirectory_companies cp
left join p8hb4_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p8hb4_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join p8hb4_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join p8hb4_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join p8hb4_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join p8hb4_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join p8hb4_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.id in (7,8)
group by cp.id
) as slec
where 1
order by featured desc
17.24ms9.14KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_providers`
7.9ms3.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from p8hb4_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
987μs1.61KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from p8hb4_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
4.47ms1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_attributes`
1.09ms1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from p8hb4_jbusinessdirectory_attributes a
left join p8hb4_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join p8hb4_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join p8hb4_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
2.34ms2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from p8hb4_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
888μs1.61KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from p8hb4_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
1.33ms1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from p8hb4_jbusinessdirectory_attributes a
left join p8hb4_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join p8hb4_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join p8hb4_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
570μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=13
513μs2.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_attributes`
783μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM p8hb4_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter
827μs648B/administrator/components/com_jbusinessdirectory/tables/company.php:1523CopySELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'user' AND `state` = '1'
724μs18.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `params` FROM `p8hb4_social_access` WHERE `uid` = NULL AND `type` = 'profiles'
251μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_themes` WHERE `element` = 'wireframe'
11.65ms640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_backgrounds` WHERE `state`='1'
612μs832B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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)
3.46ms7.94KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'
337μs2.56KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_workflows` WHERE `type` = 'user'
703μs704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_workflows_maps`
WHERE `uid` = '1' AND `type` = 'user'
1.63ms704B/libraries/src/Table/Table.php:780CopySELECT `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` ASC
6.78ms19.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_fields_options` WHERE `parent_id` IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
245μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_apps`
9.23ms26.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT id,placeholder
FROM `p8hb4_gdpr_checkbox`
6.87ms576B/plugins/system/gdpr/gdpr.php:1912CopySELECT * FROM `p8hb4_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%' AND `client_id` = '0'
6.89ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'
539μs2.56KB/libraries/src/Table/Table.php:780CopySELECT 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 = 1
1.1ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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')
6.18ms752B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect DISTINCT a.* from `p8hb4_social_albums` as a where a.`core` = '0' and a.`type` != 'marketplace' and ( a.`uid` NOT IN( select sc.`id` from `p8hb4_social_clusters` as sc WHERE ( sc.`type` NOT IN('1', '4') AND '0' NOT IN( select scn.`uid` from `p8hb4_social_clusters_nodes` as scn where scn.`cluster_id` = sc.`id` and scn.`state` = '1')))) order by created desc LIMIT 12
7.14ms2.55KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '3'
504μs2.53KB/libraries/src/Table/Table.php:780CopySET SQL_BIG_SELECTS=1
130μs0B/administrator/components/com_easysocial/includes/db/helpers/joomla40.php:25CopySELECT `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` = '835' GROUP BY `a`.`id`
7.84ms5.44KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_default_avatars` WHERE `uid` IN (1) AND `type`='profiles'
264μs1.42KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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 (835)
387μs11.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (835)
287μs2.41KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(835) AND `time` >= '1745563649' AND `client_id` <> '1'
477μs576B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect a.* from `p8hb4_social_photos` as a inner join `p8hb4_social_albums` as b on a.album_id = b.id where a.`state` = '1' and a.`album_id` = '3' order by a.`created` desc limit 0,3
587μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '18' AND `group` = 'exif'
493μs768B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '17' AND `group` = 'exif'
617μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '16' AND `group` = 'exif'
544μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (18,17,16)
371μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos_meta` where `photo_id` IN (18,17,16)
910μs1.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '2'
324μs2.53KB/libraries/src/Table/Table.php:780Copyselect a.* from `p8hb4_social_photos` as a inner join `p8hb4_social_albums` as b on a.album_id = b.id where a.`state` = '1' and a.`album_id` = '2' order by a.`created` desc limit 0,3
1.16ms2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '8'
539μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '7'
906μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '6'
1.24ms1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (8,7,6)
1.2ms2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'
5ms2.56KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=835-administrator&view=profile'
503μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'layout=all&view=albums'
319μs768B/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM (SELECT DISTINCT(a.id) FROM `p8hb4_social_clusters` AS `a` WHERE `a`.`cluster_type` = 'page' AND `a`.`type` IN ('2', '1') AND `a`.`state` = '1') AS zcount
4.55ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT DISTINCT(a.id) FROM `p8hb4_social_clusters` AS `a` WHERE `a`.`cluster_type` = 'page' AND `a`.`type` IN ('2', '1') AND `a`.`state` = '1' ORDER BY `a`.`created` DESC LIMIT 0, 5
514μs552B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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` = '2' AND `a`.`cluster_type` = 'page'
703μs4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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` = '2' AND a.`state` = '1' AND a.`admin` = '1'
876μs1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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` = '2' AND a.`state` = '2'
497μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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'
641μs4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
1.19ms1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
1.3ms1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '37'
293μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '37'
343μs848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:weal-industries-lahore&layout=item&view=pages'
1.22ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '8'
2.65ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=8:brand&layout=category&view=pages'
3.76ms768B/libraries/src/Table/Table.php:780Copyselect count(1) 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 a.`uid` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id WHERE a.`cluster_id` = '2' AND a.`state` = '1' AND u.`block` = '0' AND a.`admin` = '0'
4.45ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '2' AND `state` = '1'
3.61ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_clusters_nodes`
WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '2'
4.41ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '35'
941μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '35'
816μs848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=1:pines-dairy&layout=item&view=pages'
353μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '9'
3.11ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=9:business-2&layout=category&view=pages'
608μs768B/libraries/src/Table/Table.php:780Copyselect count(1) 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 a.`uid` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id WHERE a.`cluster_id` = '1' AND a.`state` = '1' AND u.`block` = '0' AND a.`admin` = '0'
5.8ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '1' AND `state` = '1'
2.42ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_clusters_nodes`
WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '1'
5.59ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=pages'
1.27ms768B/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` WHERE a.`cluster_type`='group' AND a.`type` IN ('2','1','4') AND a.`state`= '1') AS zcount
388μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT DISTINCT `a`.`id` AS `id` FROM `p8hb4_social_clusters` AS `a` WHERE a.`cluster_type`='group' AND a.`type` IN ('2','1','4') AND a.`state`= '1' ORDER BY a.`created` DESC LIMIT 5
241μs552B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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'
792μs4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
472μs1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
346μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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'
662μs4.84KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
520μs1.34KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect 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'
589μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '32'
426μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '32'
2.74ms848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=4:automobile-agents&layout=item&view=groups'
251μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '2'
249μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:automobile&layout=category&view=groups'
309μs768B/libraries/src/Table/Table.php:780Copyselect count(1) 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 a.`uid` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id WHERE a.`cluster_id` = '4' AND a.`state` = '1' AND u.`block` = '0'
437μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '4' AND `state` = '1'
275μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_clusters_nodes`
WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '4'
317μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '31'
1.39ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '31'
411μs944B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=3:real-estate-agents&layout=item&view=groups'
1.28ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '14'
364μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=14:real-estate&layout=category&view=groups'
301μs768B/libraries/src/Table/Table.php:780Copyselect count(1) 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 a.`uid` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id WHERE a.`cluster_id` = '3' AND a.`state` = '1' AND u.`block` = '0'
566μs8.52KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT COUNT(1) FROM `p8hb4_social_clusters_nodes` WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '3' AND `state` = '1'
492μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_clusters_nodes`
WHERE `uid` = '0' AND `type` = 'user' AND `cluster_id` = '3'
527μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=groups'
433μs768B/libraries/src/Table/Table.php:780CopySELECT `name`,`element`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
17.14ms896B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `p8hb4_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)
4.95ms584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325CopySELECT COUNT(1) FROM (SELECT a.* FROM `p8hb4_social_videos` AS a LEFT JOIN `p8hb4_social_videos_categories` as cat ON a.`category_id` = cat.`id` LEFT JOIN `p8hb4_social_clusters` AS `cls` ON a.`uid` = cls.`id` AND a.`type` = cls.`cluster_type` WHERE a.`state` = '1' and a.`scheduled` = '0' and cat.`state` = '1' AND ( (a.`type` = 'user') OR (cls.`type` IN(1, 4)) OR ( (cls.`type` > 1) AND '0' IN( SELECT scn.`uid` FROM `p8hb4_social_clusters_nodes` AS `scn` WHERE scn.`cluster_id` = a.`uid` AND scn.`type` = 'user' AND scn.`state` = '1' ) ) )) AS zcount
4.11ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT a.* FROM `p8hb4_social_videos` AS a LEFT JOIN `p8hb4_social_videos_categories` as cat ON a.`category_id` = cat.`id` LEFT JOIN `p8hb4_social_clusters` AS `cls` ON a.`uid` = cls.`id` AND a.`type` = cls.`cluster_type` WHERE a.`state` = '1' and a.`scheduled` = '0' and cat.`state` = '1' AND ( (a.`type` = 'user') OR (cls.`type` IN(1, 4)) OR ( (cls.`type` > 1) AND '0' IN( SELECT scn.`uid` FROM `p8hb4_social_clusters_nodes` AS `scn` WHERE scn.`cluster_id` = a.`uid` AND scn.`type` = 'user' AND scn.`state` = '1' ) ) ) order by a.`created` desc limit 0, 3
1.01ms3.09KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '9'
2.94ms1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=9:travel&view=videos'
361μs784B/libraries/src/Table/Table.php:780CopySELECT 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.`uid`='4' AND b.`type`='videos.user.create' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a
423μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect a.* from `p8hb4_social_likes` as a INNER JOIN `p8hb4_users` as b on a.`created_by` = b.`id` WHERE a.`uid` = '4' AND a.`type` = 'videos.user.create' AND b.`block` = 0 ORDER BY a.`id` DESC
14.98ms1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`element` = 'videos.user.create' AND a.`uid` = '4'
238μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '1'
264μs1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=1:general&view=videos'
420μs784B/libraries/src/Table/Table.php:780CopySELECT 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.`uid`='3' AND b.`type`='videos.user.create' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a
373μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect a.* from `p8hb4_social_likes` as a INNER JOIN `p8hb4_users` as b on a.`created_by` = b.`id` WHERE a.`uid` = '3' AND a.`type` = 'videos.user.create' AND b.`block` = 0 ORDER BY a.`id` DESC
259μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`element` = 'videos.user.create' AND a.`uid` = '3'
184μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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.`uid`='2' AND b.`type`='videos.user.create' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a
501μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect a.* from `p8hb4_social_likes` as a INNER JOIN `p8hb4_users` as b on a.`created_by` = b.`id` WHERE a.`uid` = '2' AND a.`type` = 'videos.user.create' AND b.`block` = 0 ORDER BY a.`id` DESC
299μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`element` = 'videos.user.create' AND a.`uid` = '2'
10.06ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=videos'
447μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_configs`
WHERE `name` = 'config'
10.74ms64.58KB/libraries/src/Table/Table.php:780CopySELECT a.*, if(a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `p8hb4_social_friends` AS a INNER JOIN `p8hb4_users` AS uu ON uu.`id` = if(a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `p8hb4_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND ( (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1') )
1.49ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `p8hb4_easyblog_post` AS a INNER JOIN `p8hb4_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `p8hb4_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`access`= 0) OR ((a.`access` = 1) AND ('0' > 0)) OR ((a.`access` = 10) AND ('0' > 0)) OR ((a.`access` = 30) AND (1 = 2)) OR ((a.`access` = 40) AND (a.`created_by`=0)) OR (a.`created_by`=0)) AND ( NOT EXISTS ( select acp.post_id from `p8hb4_easyblog_post_category` as acp inner join `p8hb4_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `p8hb4_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `p8hb4_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `p8hb4_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0))))) ORDER BY a.`created` DESC LIMIT 2
166ms133.42KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
35.34ms1.73KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'
19.67ms2.48KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'
1.63ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'
49.91ms137.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='8' AND `type`='post'
6.19ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'
2.5ms928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT b.* FROM `p8hb4_easyblog_post_category` AS a INNER JOIN `p8hb4_easyblog_category` AS b ON a.`category_id` = b.`id` WHERE a.`primary`='1' AND a.`post_id`='8'
5.85ms2.72KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.* FROM `p8hb4_easyblog_post_category`as a INNER JOIN `p8hb4_easyblog_category`as b on a.`category_id` = b.`id` WHERE a.`post_id`='8' ORDER BY b.`lft` asc
4.9ms704B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'
2.63ms2.72KB/libraries/src/Table/Table.php:780Copyselect u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `p8hb4_users` as u left join `p8hb4_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 835
5.3ms3.06KB/administrator/components/com_easyblog/includes/utils.php:298CopySHOW FULL COLUMNS FROM `p8hb4_users`
1.78ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_users`
WHERE `id` = :userid
1.42ms3.16KBParams/libraries/src/Table/User.php:106CopySELECT `g`.`id`,`g`.`title`
FROM `p8hb4_usergroups` AS `g`
INNER JOIN `p8hb4_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
3.49ms1.37KBParams/libraries/src/Table/User.php:134CopySELECT a.`group_id` FROM `p8hb4_easyblog_category_fields_groups` AS a INNER JOIN `p8hb4_easyblog_fields_groups` AS c ON a.`group_id` = c.`id` LEFT JOIN `p8hb4_easyblog_fields_groups_acl` AS acl ON c.`id` = acl.`group_id` WHERE `category_id`='1' AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
10.47ms520B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.* FROM `p8hb4_easyblog_fields` AS a INNER JOIN `p8hb4_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` INNER JOIN `p8hb4_easyblog_fields_groups` AS c ON b.`group_id` = c.`id` LEFT JOIN `p8hb4_easyblog_fields_groups_acl` AS acl ON c.`id` = acl.`group_id` WHERE b.`category_id`='1' AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL ) AND a.`state`='1' GROUP BY a.`id` ORDER BY a.`ordering` ASC
1.49ms1.42KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id`, a.`title`, a.`alias` FROM `p8hb4_easyblog_tag` AS a LEFT JOIN `p8hb4_easyblog_post_tag` AS b ON a.`id`= b.`tag_id` WHERE b.`post_id`='8' AND b.`isrevision` IS NULL AND a.`published`='1' ORDER BY b.`id` ASC
9.83ms640B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'
1.87ms21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'
10.46ms1.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='7' AND `type`='post'
1.57ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'
425μs928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT b.* FROM `p8hb4_easyblog_post_category` AS a INNER JOIN `p8hb4_easyblog_category` AS b ON a.`category_id` = b.`id` WHERE a.`primary`='1' AND a.`post_id`='7'
2ms2.72KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.* FROM `p8hb4_easyblog_post_category`as a INNER JOIN `p8hb4_easyblog_category`as b on a.`category_id` = b.`id` WHERE a.`post_id`='7' ORDER BY b.`lft` asc
783μs704B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id`, a.`title`, a.`alias` FROM `p8hb4_easyblog_tag` AS a LEFT JOIN `p8hb4_easyblog_post_tag` AS b ON a.`id`= b.`tag_id` WHERE b.`post_id`='7' AND b.`isrevision` IS NULL AND a.`published`='1' ORDER BY b.`id` ASC
2.06ms640B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) FROM `p8hb4_easyblog_comment` as a LEFT JOIN `p8hb4_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id`='8' AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL)
19.39ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) FROM `p8hb4_easyblog_comment` as a LEFT JOIN `p8hb4_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id`='7' AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL)
1.31ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `client_id` = '0' ORDER BY `id`
3.37ms2.86KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'
7.42ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'
2.55ms137.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'
841μs928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'
2.94ms2.72KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'
2.25ms21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'
330μs1.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'
388μs928B/administrator/components/com_easyblog/includes/utils.php:298Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'
2.28ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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' )
6.2ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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.7ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'group'
33.24ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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' )
10.55ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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' )
1.35ms2.73KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'event'
3.11ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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' )
5.85ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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' )
2.73ms2.7KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'page'
12.28ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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.66ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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.63ms2.73KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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 `p8hb4_social_stream` 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 a.`access` = '0' ORDER BY a.`modified` DESC LIMIT 0,4
3.47ms22.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (68,66) AND `context_type`='badges' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (65) AND `context_type`='profiles'
1.88ms1.5KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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 ('857', '855') GROUP BY `a`.`id`
947μs5.45KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT 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 (855,857)
711μs672B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (855,857)
765μs2.42KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(855,857) AND `time` >= '1745563652' AND `client_id` <> '1'
11.27ms576B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_stream_tags` WHERE `stream_id` IN('68','66','65') ORDER BY `stream_id`, `offset` DESC
254μs1.27KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT a.* FROM `p8hb4_social_likes` AS a INNER JOIN `p8hb4_users` AS b ON a.`created_by` = b.`id` WHERE a.stream_id IN (68,66,65) AND b.`block` = '0'
365μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (68) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (66) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (65) and `element` = 'stream.user'
1.1ms640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_shares` where id IN (26,855)
1.51ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) as `cnt`, x.`uid`, x.`element`, x.`stream_id` from `p8hb4_social_comments` as x where stream_id IN (68,66,65) AND x.`parent` = '0' group by x.`element`, x.`uid`, x.`stream_id`
529μs688B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '68'
655μs1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'
462μs1.63KB/libraries/src/Table/Table.php:780CopySELECT 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`='68' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a
1.76ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=857-danieloriff&view=profile'
856μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=26:newbie&layout=item&view=badges'
2.05ms768B/libraries/src/Table/Table.php:780Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '68' AND a.`element` = 'badges.user.unlocked.857' AND a.`uid` = '26' AND a.`parent` = '0'
886μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '68' AND a.`element` = 'badges.user.unlocked.857' AND a.`uid` = '26'
684μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_emoticons` AS `a` WHERE `a`.`state` = '1' ORDER BY `a`.`title` asc
775μs1.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '66'
842μs1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'
1.25ms1.63KB/libraries/src/Table/Table.php:780CopySELECT 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`='66' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a
404μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=855-ronaldakfuh&view=profile'
1.34ms768B/libraries/src/Table/Table.php:780Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '66' AND a.`element` = 'badges.user.unlocked.855' AND a.`uid` = '26' AND a.`parent` = '0'
13.29ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect count(1) from `p8hb4_social_comments` as a WHERE a.`stream_id` = '66' AND a.`element` = 'badges.user.unlocked.855' AND a.`uid` = '26'
1.88ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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`.`type` = 'profiles' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
1.69ms2.81KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_fields_data` WHERE `uid` = '855' AND `type` = 'user' ORDER BY `field_id` ASC,`datakey` ASC
1.69ms1.2KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `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` = 'JOOMLA_FULLNAME' AND `d`.`type` = 'profiles' AND `d`.`workflow_id` = '1' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
1.76ms2.81KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_fields_data` WHERE `uid` = '857' AND `type` = 'user' ORDER BY `field_id` ASC,`datakey` ASC
21.42ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM p8hb4_djcf_categories WHERE published=1 ORDER BY parent_id, ordering
13.05ms20.55KB/modules/mod_djclassifieds_search/helper.php:19CopySELECT * FROM p8hb4_djcf_categories WHERE published=1 AND access_view IN (1,5) ORDER BY parent_id, ordering ASC
9.76ms20.55KB/administrator/components/com_djclassifieds/lib/djcategory.php:538CopySELECT cat_id, count(*) as items_count FROM (SELECT i.cat_id FROM p8hb4_djcf_items i WHERE i.published=1 AND i.blocked=0 AND i.date_exp > '2025-04-25 07:00:00' ) v GROUP BY cat_id
16.86ms576B/administrator/components/com_djclassifieds/lib/djcategory.php:518CopySELECT r.* FROM p8hb4_djcf_regions r WHERE r.parent_id=0 AND published=1 ORDER BY r.parent_id, ordering,name ASC
51.7ms2.45KB/administrator/components/com_djclassifieds/lib/djregion.php:400CopySELECT i.region_id, count(i.id) as items_count FROM p8hb4_djcf_items i WHERE i.published=1 AND i.blocked=0 AND i.date_exp > '2025-04-25 07:00:00' GROUP BY i.region_id
428μs576B/administrator/components/com_djclassifieds/lib/djregion.php:362CopySELECT * FROM p8hb4_djcf_regions WHERE published=1 ORDER BY parent_id, ordering,name
31.93ms42.36KB/modules/mod_djclassifieds_search/helper.php:29CopySELECT *
FROM `p8hb4_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'
823μs2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `p8hb4_gsd_config`
1.4ms1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_gsd_config`
WHERE `name` = 'config'
3.32ms592B/libraries/src/Table/Table.php:780CopySELECT a.*
FROM p8hb4_gsd a
WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*')
ORDER BY a.id desc
3.37ms1.42KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM p8hb4_jmap_metainfo
WHERE `linkurl` = 'https://thepakistanlink.com/category/camera-photography-1'
AND `published` = 1
2.77ms912B/plugins/system/jmap/jmap.php:817CopySELECT *
FROM p8hb4_jmap_canonicals
WHERE `linkurl` = 'https://thepakistanlink.com/category/camera-photography-1'
2.15ms640B/plugins/system/jmap/jmap.php:919CopySELECT 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` = 1
2.55ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT *
FROM p8hb4_jmap_headings
WHERE `linkurl` = 'https://thepakistanlink.com/category/camera-photography-1'
893μs752B/plugins/system/jmap/jmap.php:1134CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`p8hb4_jmap_text_replacements`
WHERE
`published` = 1
5.83ms688B/plugins/system/jmap/jmap.php:509CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = ?
1.51ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `p8hb4_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
22.83ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy