In 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.35MB) (24.94%) | 1.35s |
| 1 x afterRenderRawModule mod_easybloglatestblogs (Latest Blogs) (4.03MB) (11.8%) | 641ms |
| 1 x afterDispatch (4.13MB) (11.24%) | 610ms |
| 1 x afterRenderComponent com_jbusinessdirectory (2.14MB) (9.44%) | 512ms |
| 1 x afterRenderRawModule mod_djclassifieds_search (Search Classifieds) (692.55KB) (5.54%) | 301ms |
| 1 x afterInitialise (2.28MB) (5.5%) | 299ms |
| 1 x afterRenderRawModule mod_easysocial_albums (Photos) (912.2KB) (5.18%) | 281ms |
| 1 x afterRender (594.47KB) (4.61%) | 250ms |
| 1 x afterRenderRawModule mod_easysocial_pages (Business Pages) (465.31KB) (4.52%) | 246ms |
| 1 x afterRenderRawModule mod_finder (Smart Search) (83.18KB) (3.61%) | 196ms |
| 1 x Before Access::preloadComponents (all components) (172.82KB) (2.73%) | 148ms |
| 1 x afterRenderRawModule mod_easysocial_groups (Groups) (418.84KB) (2.72%) | 148ms |
| 1 x afterRenderRawModule mod_easysocial_videos (Latest Videos) (332.75KB) (2.24%) | 121ms |
| 1 x afterRenderRawModule mod_easysocial_login (Member Login) (83.91KB) (1.73%) | 94.12ms |
| 1 x afterRenderRawModule mod_easysocial_dating_search (Member Search) (29.95KB) (1.32%) | 71.70ms |
| 1 x afterRoute (342.07KB) (1.1%) | 59.45ms |
| 1 x beforeRenderRawModule mod_easysocial_login (Member Login) (30.26KB) (0.63%) | 33.96ms |
| 1 x afterRenderModule mod_finder (Smart Search) (3.41KB) (0.47%) | 25.46ms |
| 1 x afterRenderModule mod_easysocial_login (Member Login) (7.05KB) (0.37%) | 19.94ms |
| 1 x After Access::preloadComponents (all components) (141.95KB) (0.11%) | 6.23ms |
| 1 x beforeRenderModule mod_easysocial_login (Member Login) (5.36KB) (0.03%) | 1.86ms |
| 1 x beforeRenderComponent com_jbusinessdirectory (17.82KB) (0.02%) | 1.20ms |
| 1 x beforeRenderModule mod_finder (Smart Search) (1.55KB) (0.02%) | 1.08ms |
| 1 x beforeRenderRawModule mod_djclassifieds_search (Search Classifieds) (1016B) (0.02%) | 894μs |
| 1 x afterLoad (93.68KB) (0.01%) | 795μs |
| 1 x beforeRenderRawModule mod_finder (Smart Search) (27.03KB) (0.01%) | 774μs |
| 1 x afterRenderModule mod_easysocial_stream (Site Activity) (30.41KB) (0%) | 268μs |
| 1 x afterRenderModule mod_easysocial_videos (Latest Videos) (10.41KB) (0%) | 262μs |
| 1 x afterRenderModule mod_djclassifieds_search (Search Classifieds) (10.42KB) (0%) | 229μs |
| 1 x afterRenderModule mod_easybloglatestblogs (Latest Blogs) (6.42KB) (0%) | 196μs |
| 1 x afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (0%) | 171μs |
| 1 x afterRenderModule mod_easysocial_albums (Photos) (10.44KB) (0%) | 164μs |
| 1 x afterRenderModule mod_easysocial_pages (Business Pages) (6.44KB) (0%) | 138μs |
| 1 x afterRenderModule mod_easysocial_groups (Groups) (38.44KB) (0%) | 120μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0%) | 119μs |
| 1 x beforeRenderRawModule mod_easysocial_videos (Latest Videos) (4.59KB) (0%) | 115μs |
| 1 x beforeRenderRawModule mod_easybloglatestblogs (Latest Blogs) (7.38KB) (0%) | 82μs |
| 1 x beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (0%) | 71μs |
| 1 x beforeRenderRawModule mod_easysocial_groups (Groups) (720B) (0%) | 69μs |
| 1 x beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (0%) | 67μs |
| 1 x beforeRenderRawModule mod_easysocial_pages (Business Pages) (2.86KB) (0%) | 62μs |
| 1 x beforeRenderRawModule mod_easysocial_stream (Site Activity) (6.81KB) (0%) | 58μs |
| 1 x beforeRenderRawModule mod_easysocial_albums (Photos) (400B) (0%) | 56μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%) | 45μs |
| 1 x beforeRenderModule mod_easysocial_groups (Groups) (4.84KB) (0%) | 43μs |
| 1 x beforeRenderModule mod_easysocial_pages (Business Pages) (2.31KB) (0%) | 42μs |
| 1 x beforeRenderModule mod_easysocial_albums (Photos) (2.84KB) (0%) | 36μs |
| 1 x beforeRenderModule mod_djclassifieds_search (Search Classifieds) (736B) (0%) | 22μs |
| 1 x beforeRenderModule mod_easysocial_stream (Site Activity) (736B) (0%) | 21μs |
| 1 x beforeRenderModule mod_easysocial_videos (Latest Videos) (736B) (0%) | 18μs |
| 1 x beforeRenderModule mod_easybloglatestblogs (Latest Blogs) (736B) (0%) | 17μs |
SELECT @@SESSION.sql_mode;251μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `p8hb4_session`
WHERE `session_id` = ?4.89ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = :session_id LIMIT 15.61ms1.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)67.29ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `p8hb4_viewlevels`606μ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` = :guest524μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `p8hb4_admintools_storage`
WHERE `key` = 'cparams'314μs520B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `p8hb4_admintools_wafexceptions`993μs640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'4.28ms1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT * FROM `p8hb4_social_config` WHERE `type` = 'site'5.94ms40.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT sampleData
FROM p8hb4_kunena_version
ORDER BY id DESC LIMIT 11.29ms536B/libraries/kunena/src/Forum/KunenaForum.php:374CopySELECT config_value FROM p8hb4_hikashop_config WHERE config_namekey = 'version'684μs536B/plugins/system/hikamarketoverrides/hikamarketoverrides.php:31CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_application_settings fas2.24ms40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'550μs768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'7.24ms704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'women' LIMIT 11.19ms2.72KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'women' LIMIT 13.6ms3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM p8hb4_jbusinessdirectory_mobile_app_config559μs1.63KB/components/com_jbusinessdirectory/helpers/utils.php:9380CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_default_attributes`901μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM p8hb4_jbusinessdirectory_default_attributes294μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_companies`7.86ms2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_categories`66.23ms1.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=356.7ms18.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from p8hb4_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name9.64ms19.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-23','35','0')744μs0B/components/com_jbusinessdirectory/helpers/utils.php:7609Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=35791μ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, name1.1ms19.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=1161μ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 (35,35)
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 11.51ms720B/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000134μs0B/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 (35,35)
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 203.84ms1.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 (1,32)
group by cp.id
) as slec
where 1
order by featured desc13.48ms9.14KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_providers`1.62ms3.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 = 1 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday690μs1.48KB/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 = 1 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday542μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_attributes`1.32ms1.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=1
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering1.7ms2.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 = 32 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday5.78ms1.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 = 32 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday544μs1.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=32
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering473μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=35363μs2.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_attributes`2.04ms1.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 letter1.77ms648B/administrator/components/com_jbusinessdirectory/tables/company.php:1523CopySELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'user' AND `state` = '1'957μs18.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `params` FROM `p8hb4_social_access` WHERE `uid` = NULL AND `type` = 'profiles'257μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_themes` WHERE `element` = 'wireframe'219μs640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_backgrounds` WHERE `state`='1'881μ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)981μs7.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'423μs704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_workflows_maps`
WHERE `uid` = '1' AND `type` = 'user'975μs704B/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` ASC4.72ms19.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` ASC344μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_apps`826μs26.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT id,placeholder
FROM `p8hb4_gdpr_checkbox`1.69ms576B/plugins/system/gdpr/gdpr.php:1912CopySELECT * FROM `p8hb4_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%' AND `client_id` = '0'1.19ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'396μ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 = 1378μs536B/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')2ms752B/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 121.58ms2.55KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '3'3.46ms2.53KB/libraries/src/Table/Table.php:780CopySET SQL_BIG_SELECTS=1110μ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`1.23ms5.44KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_default_avatars` WHERE `uid` IN (1) AND `type`='profiles'219μ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)2.63ms11.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (835)314μs2.41KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(835) AND `time` >= '1745439927' AND `client_id` <> '1'349μ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,3597μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '18' AND `group` = 'exif'511μs768B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '17' AND `group` = 'exif'9.38ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '16' AND `group` = 'exif'1.85ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (18,17,16)647μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos_meta` where `photo_id` IN (18,17,16)893μs1.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '2'448μ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,31.56ms2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '8'598μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '7'569μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '6'472μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (8,7,6)572μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=18:travel-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'1.6ms752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/18-travel-pakistan-2023-01-06'2.07ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=17:travel-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'6.05ms752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/17-travel-pakistan-2023-01-06'2ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=16:travel-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'416μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/16-travel-pakistan-2023-01-06'447μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=3:travel-pakistan&layout=item&type=user&uid=835-administrator&view=albums'502μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/3-travel-pakistan'442μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'408μs2.56KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=835-administrator&view=profile'3.17ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=8:heritage-sites-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'438μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/8-heritage-sites-pakistan-2023-01-06'422μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=7:heritage-sites-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'5.01ms752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/7-heritage-sites-pakistan-2023-01-06'1.37ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=6:heritage-sites-pakistan-2023-01-06&layout=item&type=user&uid=835-administrator&view=photos'306μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/photos/6-heritage-sites-pakistan-2023-01-06'1.95ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:heritage-sites-pakistan&layout=item&type=user&uid=835-administrator&view=albums'1.49ms752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'albums/2-heritage-sites-pakistan'372μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'layout=all&view=albums'464μ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 zcount3.14ms536B/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, 5516μ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'581μ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'600μ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'388μ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'668μ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'768μ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` = '1' AND a.`state` = '2'518μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '37'331μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '37'342μ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'921μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '8'329μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=8:brand&layout=category&view=pages'815μ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` = '2' AND a.`state` = '1' AND u.`block` = '0' AND a.`admin` = '0'909μ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` = '2' AND `state` = '1'512μ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` = '2'446μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '35'1.34ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '35'1.09ms848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=1:pines-dairy&layout=item&view=pages'1.8ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '9'479μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=9:business-2&layout=category&view=pages'675μ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'743μ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` = '1' AND `state` = '1'325μ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` = '1'2.47ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=pages'430μs768B/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 zcount1.19ms536B/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 51.42ms552B/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'1.68ms4.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'706μ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'517μ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'1.25ms12.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'1.54ms1.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'1.1ms1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '32'500μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '32'461μs848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=4:automobile-agents&layout=item&view=groups'384μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '2'285μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:automobile&layout=category&view=groups'364μ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'1.42ms536B/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'4.75ms536B/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'1.26ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '31'354μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '31'1.65ms944B/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'427μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '14'10.17ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=14:real-estate&layout=category&view=groups'1.41ms768B/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'661μ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` = '3' AND `state` = '1'863μ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'303μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=groups'380μs768B/libraries/src/Table/Table.php:780CopySELECT `name`,`element`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 17.03ms896B/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)530μs584B/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 zcount1.41ms536B/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, 32.21ms3.09KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=4:travel-through-pakistan&layout=item&type=user&uid=835-administrator&view=videos'395μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'videos/4-travel-through-pakistan'1.13ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '9'1.41ms1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=9:travel&view=videos'2.22ms784B/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 a1.74ms912B/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` DESC4.77ms1.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'304μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=3:why-textile-industry-of-pakistan-is-on-a-decline&layout=item&type=user&uid=835-administrator&view=videos'284μs752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'videos/3-why-textile-industry-of-pakistan-is-on-a-decline'313μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '1'286μs1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=1:general&view=videos'505μ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 a6.46ms912B/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` DESC1.31ms1.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'187μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:panel-discussion-on-revival-of-pakistans-economy&layout=item&type=user&uid=835-administrator&view=videos'2.71ms752B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `sefurl` = 'videos/2-panel-discussion-on-revival-of-pakistans-economy'5.82ms768B/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`='2' AND b.`type`='videos.user.create' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a609μ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` DESC321μ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'2.56ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=videos'328μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_configs`
WHERE `name` = 'config'432μs64.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') )2.09ms912B/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 24.61ms133.42KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC399μs1.73KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'609μs2.48KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'2.48ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'1.29ms137.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='8' AND `type`='post'4.81ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'367μ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`='8'5.82ms2.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` asc435μs704B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'19.87ms2.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` = 835495μs3.06KB/administrator/components/com_easyblog/includes/utils.php:298CopySHOW FULL COLUMNS FROM `p8hb4_users`1.1ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_users`
WHERE `id` = :userid437μs3.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` = :muserid499μs1.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 )8.55ms520B/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` ASC1.11ms1.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` ASC550μs640B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'627μs21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'271μs1.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='7' AND `type`='post'708μs536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'4.39ms928B/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'590μs2.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` asc401μ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` ASC401μs640B/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)426μs536B/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)413μs536B/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`6.5ms2.86KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'1.07ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'676μs137.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'4.9ms928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'1.24ms2.72KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'533μs21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'3.45ms1.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'507μs928B/administrator/components/com_easyblog/includes/utils.php:298Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'1.07ms520B/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' )986μs536B/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' )2.55ms2.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'1.16ms520B/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' )1.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` = 'group' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.99ms2.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'1.8ms520B/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' )4.62ms536B/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.19ms2.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'731μs520B/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' )1.13ms536B/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' )3.67ms2.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,44.39ms22.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'7.12ms1.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`14.44ms5.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)1.41ms672B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (855,857)127ms2.42KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(855,857) AND `time` >= '1745439929' AND `client_id` <> '1'649μs576B/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` DESC314μ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'342μ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'7.08ms640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_shares` where id IN (26,855)1ms912B/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`5.82ms688B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '68'1.69ms1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'552μ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 a504μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=857-danieloriff&view=profile'530μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=26:newbie&layout=item&view=badges'1.15ms768B/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'344μ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'8.64ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_emoticons` AS `a` WHERE `a`.`state` = '1' ORDER BY `a`.`title` asc544μs1.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '66'3.57ms1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'441μ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`='66' AND u.`block` = 0 ) as `total` FROM `p8hb4_social_reactions` AS a488μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=855-ronaldakfuh&view=profile'4.15ms768B/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'313μs536B/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'5.97ms536B/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` ASC1.65ms2.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` ASC989μs1.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` ASC1.91ms2.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` ASC7.65ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM p8hb4_djcf_categories WHERE published=1 ORDER BY parent_id, ordering1.22ms20.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 ASC1.52ms20.55KB/administrator/components/com_djclassifieds/lib/djcategory.php:538CopySELECT r.* FROM p8hb4_djcf_regions r WHERE r.parent_id=0 AND published=1 ORDER BY r.parent_id, ordering,name ASC712μs2.45KB/administrator/components/com_djclassifieds/lib/djregion.php:400CopySELECT * FROM p8hb4_djcf_regions WHERE published=1 ORDER BY parent_id, ordering,name7.07ms42.36KB/modules/mod_djclassifieds_search/helper.php:29CopySELECT *
FROM `p8hb4_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'614μs2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `p8hb4_gsd_config`1.26ms1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_gsd_config`
WHERE `name` = 'config'1.04ms592B/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 desc698μs17.42KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM p8hb4_jmap_metainfo
WHERE `linkurl` = 'https://thepakistanlink.com/category/women'
AND `published` = 1475μs912B/plugins/system/jmap/jmap.php:817CopySELECT *
FROM p8hb4_jmap_canonicals
WHERE `linkurl` = 'https://thepakistanlink.com/category/women'307μs640B/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` = 1566μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT *
FROM p8hb4_jmap_headings
WHERE `linkurl` = 'https://thepakistanlink.com/category/women'1.29ms752B/plugins/system/jmap/jmap.php:1134CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`p8hb4_jmap_text_replacements`
WHERE
`published` = 1445μs688B/plugins/system/jmap/jmap.php:509CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = ?711μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `p8hb4_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?8.58ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy