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_easybloglatestblogs (Latest Blogs) (3.91MB) (19.4%) | 2.25s |
| 1 x afterRenderRawModule mod_easysocial_stream (Site Activity) (7.63MB) (17.34%) | 2.01s |
| 1 x afterRenderComponent com_jbusinessdirectory (2.16MB) (14.34%) | 1.67s |
| 1 x afterInitialise (2.28MB) (9.99%) | 1.16s |
| 1 x afterRender (617.02KB) (5.2%) | 604ms |
| 1 x afterRenderRawModule mod_finder (Smart Search) (83.93KB) (4.94%) | 573ms |
| 1 x afterDispatch (4.13MB) (4.91%) | 571ms |
| 1 x afterRenderRawModule mod_djclassifieds_search (Search Classifieds) (600KB) (4.91%) | 570ms |
| 1 x afterRenderRawModule mod_easysocial_videos (Latest Videos) (220.91KB) (3.18%) | 369ms |
| 1 x afterRenderRawModule mod_menu (Main Menu) (1.23MB) (2.11%) | 245ms |
| 1 x afterRenderRawModule mod_easysocial_albums (Photos) (638.31KB) (2.1%) | 244ms |
| 1 x afterRenderRawModule mod_easysocial_pages (Business Pages) (465.31KB) (1.95%) | 226ms |
| 1 x afterRenderRawModule mod_easysocial_login (Member Login) (84.16KB) (1.91%) | 222ms |
| 1 x Before Access::preloadComponents (all components) (171.16KB) (1.72%) | 200ms |
| 1 x afterRenderRawModule mod_easysocial_groups (Groups) (418.53KB) (1.35%) | 157ms |
| 1 x After Access::preloadComponents (all components) (141.95KB) (1.27%) | 148ms |
| 1 x afterRenderRawModule mod_djclassifieds_items (Classifieds) (110.09KB) (0.95%) | 111ms |
| 1 x afterRoute (342.38KB) (0.6%) | 69.92ms |
| 1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.95KB) (0.31%) | 36.17ms |
| 1 x afterLoad (93.93KB) (0.29%) | 33.46ms |
| 1 x beforeRenderComponent com_jbusinessdirectory (17.82KB) (0.2%) | 23.14ms |
| 1 x beforeRenderModule mod_menu (Main Menu) (21.08KB) (0.15%) | 17.05ms |
| 1 x beforeRenderModule mod_easysocial_login (Member Login) (21.22KB) (0.09%) | 10.90ms |
| 1 x afterRenderRawModule mod_easysocial_dating_search (Member Search) (29.95KB) (0.08%) | 9.63ms |
| 1 x afterRenderRawModule mod_menu (Footer-a) (62.84KB) (0.05%) | 6.17ms |
| 1 x afterRenderModule mod_menu (Main Menu) (12.92KB) (0.05%) | 5.85ms |
| 1 x beforeRenderModule mod_menu (Footer-a) (5.09KB) (0.04%) | 4.46ms |
| 1 x beforeRenderRawModule mod_easysocial_login (Member Login) (30.26KB) (0.02%) | 1.87ms |
| 1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.65KB) (0.01%) | 1.61ms |
| 1 x beforeRenderRawModule mod_menu (Main Menu) (22.45KB) (0.01%) | 1.14ms |
| 1 x beforeRenderRawModule mod_finder (Smart Search) (22.19KB) (0.01%) | 1.06ms |
| 1 x beforeRenderModule mod_finder (Smart Search) (21.58KB) (0.01%) | 932μs |
| 1 x beforeRenderRawModule mod_djclassifieds_items (Classifieds) (19.92KB) (0.01%) | 807μs |
| 1 x beforeRenderRawModule mod_menu (Footer-a) (22.63KB) (0.01%) | 804μs |
| 1 x afterRenderModule mod_menu (Footer-a) (3.77KB) (0%) | 464μs |
| 1 x afterRenderModule mod_easysocial_login (Member Login) (6.92KB) (0%) | 450μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0%) | 328μs |
| 1 x afterRenderModule mod_easybloglatestblogs (Latest Blogs) (6.42KB) (0%) | 324μs |
| 1 x afterRenderModule mod_easysocial_videos (Latest Videos) (10.41KB) (0%) | 270μs |
| 1 x afterRenderModule mod_easysocial_stream (Site Activity) (30.41KB) (0%) | 266μs |
| 1 x afterRenderModule mod_djclassifieds_items (Classifieds) (1.82KB) (0%) | 264μs |
| 1 x afterRenderModule mod_djclassifieds_search (Search Classifieds) (10.42KB) (0%) | 250μs |
| 1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.8KB) (0%) | 220μs |
| 1 x afterRenderModule mod_finder (Smart Search) (2.94KB) (0%) | 202μs |
| 1 x beforeRenderRawModule mod_djclassifieds_search (Search Classifieds) (1016B) (0%) | 171μs |
| 1 x afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (0%) | 134μs |
| 1 x afterRenderModule mod_easysocial_pages (Business Pages) (6.44KB) (0%) | 128μs |
| 1 x afterRenderModule mod_easysocial_albums (Photos) (11.69KB) (0%) | 113μs |
| 1 x afterRenderModule mod_easysocial_groups (Groups) (6.44KB) (0%) | 112μs |
| 1 x beforeRenderRawModule mod_easysocial_videos (Latest Videos) (4.59KB) (0%) | 106μs |
| 1 x beforeRenderRawModule mod_easybloglatestblogs (Latest Blogs) (7.38KB) (0%) | 98μs |
| 1 x beforeRenderRawModule mod_easysocial_groups (Groups) (720B) (0%) | 97μs |
| 1 x beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (0%) | 85μs |
| 1 x beforeRenderRawModule mod_easysocial_stream (Site Activity) (6.81KB) (0%) | 73μs |
| 1 x beforeRenderRawModule mod_easysocial_pages (Business Pages) (2.86KB) (0%) | 71μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%) | 69μs |
| 1 x beforeRenderRawModule mod_easysocial_albums (Photos) (400B) (0%) | 63μs |
| 1 x beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (0%) | 45μs |
| 1 x beforeRenderModule mod_easysocial_groups (Groups) (4.84KB) (0%) | 41μs |
| 1 x beforeRenderModule mod_easysocial_pages (Business Pages) (2.31KB) (0%) | 39μs |
| 1 x beforeRenderModule mod_easysocial_albums (Photos) (2.84KB) (0%) | 35μs |
| 1 x beforeRenderModule mod_easybloglatestblogs (Latest Blogs) (736B) (0%) | 26μs |
| 1 x beforeRenderModule mod_djclassifieds_items (Classifieds) (736B) (0%) | 26μs |
| 1 x beforeRenderModule mod_easysocial_videos (Latest Videos) (736B) (0%) | 24μs |
| 1 x beforeRenderModule mod_djclassifieds_search (Search Classifieds) (736B) (0%) | 23μs |
| 1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 22μs |
| 1 x beforeRenderModule mod_easysocial_stream (Site Activity) (736B) (0%) | 22μs |
SELECT @@SESSION.sql_mode;31.94ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `p8hb4_session`
WHERE `session_id` = ?32.02ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = :session_id LIMIT 1470μ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)75.05ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `p8hb4_viewlevels`30.43ms976B/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` = :guest49.41ms1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `p8hb4_admintools_storage`
WHERE `key` = 'cparams'5.9ms520B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `p8hb4_admintools_wafexceptions`25.15ms640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'92ms1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT * FROM `p8hb4_social_config` WHERE `type` = 'site'392μs40.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT sampleData
FROM p8hb4_kunena_version
ORDER BY id DESC LIMIT 1642μs536B/libraries/kunena/src/Forum/KunenaForum.php:374CopySELECT config_value FROM p8hb4_hikashop_config WHERE config_namekey = 'version'314μs536B/plugins/system/hikamarketoverrides/hikamarketoverrides.php:31CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_application_settings fas12.05ms40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'310μs768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'250μs704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'grocery-health-beauty-1' LIMIT 11.66ms2.72KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'grocery-health-beauty-1' LIMIT 1622μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM p8hb4_jbusinessdirectory_mobile_app_config2.77ms1.63KB/components/com_jbusinessdirectory/helpers/utils.php:9380CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_default_attributes`1.46ms1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM p8hb4_jbusinessdirectory_default_attributes330μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_companies`10.1ms2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_categories`2.17ms1.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=29668μ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, name1.05ms19.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-26','29','0')898μs0B/components/com_jbusinessdirectory/helpers/utils.php:7609Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=29367μ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.61ms19.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=1105μ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 (39,42,41,40,29)
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.6ms720B/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000103μ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 (39,42,41,40,29)
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 202.11ms1.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 (5,12)
group by cp.id
) as slec
where 1
order by featured desc34.7ms9.14KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_providers`2.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 = 5 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday4.07ms1.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 = 5 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday606μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_attributes`3.17ms1.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=5
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering2.79ms2.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 = 12 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday509μ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 = 12 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday470μ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=12
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering4.48ms2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=29373μs2.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_attributes`3.47ms1.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 letter471μs648B/administrator/components/com_jbusinessdirectory/tables/company.php:1523CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `p8hb4_modules` AS `m`
LEFT JOIN `p8hb4_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `p8hb4_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`569ms18.19KBParams/libraries/src/Cache/Controller/CallbackController.php:120CopySELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'user' AND `state` = '1'2.77ms18.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `params` FROM `p8hb4_social_access` WHERE `uid` = NULL AND `type` = 'profiles'11.2ms520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_themes` WHERE `element` = 'wireframe'252μs640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_backgrounds` WHERE `state`='1'294μ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)52.13ms7.94KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'6.22ms2.56KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_workflows` WHERE `type` = 'user'432μs704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_workflows_maps`
WHERE `uid` = '1' AND `type` = 'user'447μ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` ASC2.16ms19.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` ASC1.39ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_apps`13.91ms26.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT id,placeholder
FROM `p8hb4_gdpr_checkbox`4.34ms576B/plugins/system/gdpr/gdpr.php:1912CopySELECT * FROM `p8hb4_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%' AND `client_id` = '0'79.72ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'391μ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 = 123.84ms536B/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')2.23ms752B/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.16ms2.55KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '3'2.82ms2.53KB/libraries/src/Table/Table.php:780CopySET SQL_BIG_SELECTS=198μ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`2.64ms5.44KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_default_avatars` WHERE `uid` IN (1) AND `type`='profiles'545μs12.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)10.16ms656B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (835)338μs2.41KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(835) AND `time` >= '1745684672' AND `client_id` <> '1'7.8ms576B/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,3721μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '18' AND `group` = 'exif'656μs768B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '17' AND `group` = 'exif'539μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '16' AND `group` = 'exif'655μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (18,17,16)451μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos_meta` where `photo_id` IN (18,17,16)931μs1.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '2'2.31ms2.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,3705μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '8'1.35ms1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '7'522μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '6'514μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (8,7,6)724μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'1.27ms2.56KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=835-administrator&view=profile'1.9ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'layout=all&view=albums'428μ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 zcount1.87ms536B/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, 510.53ms552B/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'995μ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'15.98ms1.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'540μ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'893μ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'753μ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'564μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '37'1.98ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '37'1.99ms848B/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'2.47ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '8'3.12ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=8:brand&layout=category&view=pages'1.39ms768B/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'8.43ms536B/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'1.39ms536B/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.73ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '35'1.51ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '35'515μ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'4.17ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '9'1.24ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=9:business-2&layout=category&view=pages'461μ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'1.31ms536B/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'5.23ms536B/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'613μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=pages'463μ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 zcount555μ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 5387μ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'1.1ms4.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'752μ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'780μ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'784μ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'889μ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'534μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '32'414μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '32'528μ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'465μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '2'401μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:automobile&layout=category&view=groups'511μ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.02ms536B/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'363μ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'541μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '31'429μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '31'474μ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'484μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '14'382μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=14:real-estate&layout=category&view=groups'525μs8.75KB/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'612μ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'1.18ms536B/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'383μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=groups'7.6ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=dashboard'836μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=events'679μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=pages'466μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=groups'427μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=marketplaces'6.89ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=users'509μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=videos'442μs800B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_configs`
WHERE `name` = 'config'24.15ms64.58KB/libraries/src/Table/Table.php:780CopySELECT * FROM p8hb4_hikashop_config743μs24.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));171μs0B/administrator/components/com_hikashop/helpers/helper.php:3357CopySELECT * FROM p8hb4_hikamarket_config1.94ms2.13KB/administrator/components/com_hikamarket/classes/config.php:16CopySELECT `name`,`element`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1252ms896B/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)36.03ms584B/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 zcount3.73ms536B/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, 3988μs3.09KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '9'1.48ms1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=9:travel&view=videos'514μ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 a368μ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` DESC773μ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` = '4'3.44ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '1'6.59ms1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=1:general&view=videos'394μ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 a35.92ms912B/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` DESC5.74ms1.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'502μ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 a580μ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` DESC38.59ms1.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'285μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=videos'14.02ms768B/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') )399μs912B/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 2974ms133.42KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC118ms1.73KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'138ms2.48KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'861μs133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'51.84ms137.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='8' AND `type`='post'8.63ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'19.38ms928B/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'15.62ms2.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` asc7.54ms704B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'2.61ms2.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` = 83511.45ms3.06KB/administrator/components/com_easyblog/includes/utils.php:298CopySHOW FULL COLUMNS FROM `p8hb4_users`1.04ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_users`
WHERE `id` = :userid407μ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` = :muserid495μ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 )22.23ms520B/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` ASC2.39ms1.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` ASC42.89ms640B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'1.1ms21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'7.23ms1.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='7' AND `type`='post'2.32ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'427μ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'572μ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` asc509μ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` ASC513μ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)10.88ms536B/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)490μ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`1.35ms2.86KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'1.04ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'731μs137.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'513μs928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'559μs2.72KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'605μs21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'315μs1.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'401μs928B/administrator/components/com_easyblog/includes/utils.php:298Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'595μ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` = 'user' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.64ms536B/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' )4.14ms2.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'59.99ms520B/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' )7.91ms536B/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.91ms2.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'6ms520B/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' )1.89ms536B/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' )1.48ms2.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'1.83ms520B/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' )2.29ms536B/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' )8.87ms2.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,43.36ms22.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'73.58ms1.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`21.54ms5.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)412μs672B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (855,857)991μ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` >= '1745684678' AND `client_id` <> '1'2.86ms576B/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` DESC775μ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'1.57ms1.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.19ms640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_shares` where id IN (26,855)2.91ms912B/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`3.72ms688B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '68'6.3ms1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'4.62ms1.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 a981μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=857-danieloriff&view=profile'3.92ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=26:newbie&layout=item&view=badges'3.1ms768B/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'487μ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'4.86ms536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_emoticons` AS `a` WHERE `a`.`state` = '1' ORDER BY `a`.`title` asc1.49ms1.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '66'3.65ms1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'4.36ms1.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 a1.72ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=855-ronaldakfuh&view=profile'3.57ms768B/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'6.6ms536B/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'639μs536B/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` ASC6.41ms2.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` ASC6.02ms1.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` ASC11.15ms2.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` ASC1.59ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM p8hb4_djcf_categories WHERE published=1 ORDER BY parent_id, ordering24.79ms20.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.15ms20.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-26 16:00:00' ) v GROUP BY cat_id18.23ms576B/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 ASC29.07ms2.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-26 16:00:00' GROUP BY i.region_id443μs576B/administrator/components/com_djclassifieds/lib/djregion.php:362CopySELECT * FROM p8hb4_djcf_regions WHERE published=1 ORDER BY parent_id, ordering,name118ms42.36KB/modules/mod_djclassifieds_search/helper.php:29CopySELECT i.*, c.id c_id, c.name c_name, c.alias c_alias, r.id r_id, r.name r_name, r.alias r_alias, p.verified p_verified FROM p8hb4_djcf_items i JOIN p8hb4_djcf_categories c ON c.id=i.cat_id LEFT JOIN p8hb4_djcf_regions r ON r.id=i.region_id LEFT JOIN p8hb4_djcf_profiles p ON i.user_id=p.user_id WHERE i.blocked=0 AND c.published!=0 AND c.access_view IN (0,1,5) AND c.restriction_18=0 AND i.published=1 AND i.date_exp > '2025-04-26 16:39:30' ORDER BY i.date_sort DESC LIMIT 91.72ms24.92KB/modules/mod_djclassifieds_items/helper.php:295CopySELECT *
FROM `p8hb4_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'878μs2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `p8hb4_gsd_config`2.72ms1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_gsd_config`
WHERE `name` = 'config'3.71ms592B/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 desc345ms1.42KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM p8hb4_jmap_metainfo
WHERE `linkurl` = 'https://thepakistanlink.com/category/grocery-health-beauty-1'
AND `published` = 15.3ms912B/plugins/system/jmap/jmap.php:817CopySELECT *
FROM p8hb4_jmap_canonicals
WHERE `linkurl` = 'https://thepakistanlink.com/category/grocery-health-beauty-1'4.74ms640B/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` = 16.88ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT *
FROM p8hb4_jmap_headings
WHERE `linkurl` = 'https://thepakistanlink.com/category/grocery-health-beauty-1'5.03ms752B/plugins/system/jmap/jmap.php:1134CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`p8hb4_jmap_text_replacements`
WHERE
`published` = 13.71ms688B/plugins/system/jmap/jmap.php:509CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = ?256μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `p8hb4_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?60.63ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy