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 afterRenderComponent com_jbusinessdirectory (2.1MB) (21.87%) | 1.72s |
| 1 x afterRenderRawModule mod_easybloglatestblogs (Latest Blogs) (3.91MB) (18.82%) | 1.48s |
| 1 x afterRenderRawModule mod_easysocial_stream (Site Activity) (7.63MB) (16.88%) | 1.33s |
| 1 x afterRenderRawModule mod_easysocial_pages (Business Pages) (465.31KB) (6.24%) | 491ms |
| 1 x afterRenderRawModule mod_djclassifieds_search (Search Classifieds) (600KB) (5.03%) | 396ms |
| 1 x afterRenderRawModule mod_easysocial_albums (Photos) (649.63KB) (4.42%) | 348ms |
| 1 x afterInitialise (2.28MB) (4.25%) | 334ms |
| 1 x afterDispatch (4.13MB) (4.04%) | 318ms |
| 1 x afterRender (600.91KB) (3.1%) | 244ms |
| 1 x Before Access::preloadComponents (all components) (171.16KB) (2.4%) | 189ms |
| 1 x afterRenderRawModule mod_easysocial_groups (Groups) (418.53KB) (2.21%) | 174ms |
| 1 x afterRenderRawModule mod_finder (Smart Search) (83.93KB) (2.17%) | 171ms |
| 1 x afterRenderRawModule mod_menu (Main Menu) (1.23MB) (2.15%) | 169ms |
| 1 x afterRenderRawModule mod_easysocial_videos (Latest Videos) (220.91KB) (1.9%) | 149ms |
| 1 x afterRenderRawModule mod_djclassifieds_items (Classifieds) (110.09KB) (1.08%) | 85.04ms |
| 1 x afterRenderRawModule mod_easysocial_dating_search (Member Search) (29.95KB) (1.04%) | 82.01ms |
| 1 x afterRoute (342.07KB) (0.7%) | 54.96ms |
| 1 x afterRenderRawModule mod_easysocial_login (Member Login) (83.91KB) (0.5%) | 39.43ms |
| 1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.95KB) (0.46%) | 36.17ms |
| 1 x beforeRenderModule mod_easysocial_login (Member Login) (21.22KB) (0.23%) | 18.01ms |
| 1 x beforeRenderModule mod_menu (Footer-a) (5.09KB) (0.23%) | 17.90ms |
| 1 x beforeRenderModule mod_menu (Main Menu) (21.08KB) (0.07%) | 5.50ms |
| 1 x afterRenderRawModule mod_menu (Footer-a) (62.84KB) (0.03%) | 2.36ms |
| 1 x After Access::preloadComponents (all components) (141.95KB) (0.02%) | 1.79ms |
| 1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.65KB) (0.02%) | 1.36ms |
| 1 x beforeRenderRawModule mod_finder (Smart Search) (22.19KB) (0.02%) | 1.36ms |
| 1 x beforeRenderRawModule mod_easysocial_login (Member Login) (30.26KB) (0.02%) | 1.19ms |
| 1 x beforeRenderComponent com_jbusinessdirectory (17.82KB) (0.02%) | 1.18ms |
| 1 x beforeRenderModule mod_finder (Smart Search) (21.58KB) (0.01%) | 875μs |
| 1 x beforeRenderRawModule mod_menu (Main Menu) (22.45KB) (0.01%) | 824μs |
| 1 x beforeRenderRawModule mod_djclassifieds_items (Classifieds) (19.92KB) (0.01%) | 742μs |
| 1 x afterLoad (93.68KB) (0.01%) | 697μs |
| 1 x beforeRenderRawModule mod_menu (Footer-a) (22.63KB) (0.01%) | 493μs |
| 1 x afterRenderModule mod_easysocial_videos (Latest Videos) (10.41KB) (0.01%) | 462μs |
| 1 x afterRenderModule mod_menu (Footer-a) (3.77KB) (0.01%) | 461μs |
| 1 x afterRenderModule mod_easysocial_login (Member Login) (6.92KB) (0%) | 343μs |
| 1 x afterRenderModule mod_easysocial_stream (Site Activity) (30.41KB) (0%) | 243μs |
| 1 x afterRenderModule mod_easybloglatestblogs (Latest Blogs) (6.42KB) (0%) | 239μs |
| 1 x afterRenderModule mod_menu (Main Menu) (12.92KB) (0%) | 235μs |
| 1 x afterRenderModule mod_djclassifieds_search (Search Classifieds) (10.42KB) (0%) | 228μs |
| 1 x afterRenderModule mod_djclassifieds_items (Classifieds) (1.82KB) (0%) | 199μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0%) | 188μs |
| 1 x beforeRenderModule mod_easysocial_pages (Business Pages) (2.31KB) (0%) | 180μs |
| 1 x afterRenderModule mod_finder (Smart Search) (2.94KB) (0%) | 176μs |
| 1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.8KB) (0%) | 170μs |
| 1 x beforeRenderRawModule mod_djclassifieds_search (Search Classifieds) (1016B) (0%) | 161μs |
| 1 x afterRenderModule mod_easysocial_pages (Business Pages) (6.44KB) (0%) | 135μs |
| 1 x afterRenderModule mod_easysocial_dating_search (Member Search) (5.45KB) (0%) | 124μs |
| 1 x beforeRenderRawModule mod_easysocial_videos (Latest Videos) (4.59KB) (0%) | 119μs |
| 1 x afterRenderModule mod_easysocial_groups (Groups) (6.44KB) (0%) | 115μs |
| 1 x afterRenderModule mod_easysocial_albums (Photos) (11.69KB) (0%) | 113μs |
| 1 x beforeRenderRawModule mod_easybloglatestblogs (Latest Blogs) (7.38KB) (0%) | 82μs |
| 1 x beforeRenderRawModule mod_easysocial_groups (Groups) (720B) (0%) | 72μs |
| 1 x beforeRenderRawModule mod_easysocial_albums (Photos) (400B) (0%) | 71μs |
| 1 x beforeRenderRawModule mod_easysocial_pages (Business Pages) (2.86KB) (0%) | 66μs |
| 1 x beforeRenderRawModule mod_easysocial_dating_search (Member Search) (416B) (0%) | 60μs |
| 1 x beforeRenderRawModule mod_easysocial_stream (Site Activity) (6.81KB) (0%) | 55μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%) | 43μs |
| 1 x beforeRenderModule mod_easysocial_groups (Groups) (4.84KB) (0%) | 41μs |
| 1 x beforeRenderModule mod_easysocial_dating_search (Member Search) (1.14KB) (0%) | 40μs |
| 1 x beforeRenderModule mod_easysocial_albums (Photos) (2.84KB) (0%) | 33μs |
| 1 x beforeRenderModule mod_easybloglatestblogs (Latest Blogs) (736B) (0%) | 20μs |
| 1 x beforeRenderModule mod_easysocial_stream (Site Activity) (736B) (0%) | 19μs |
| 1 x beforeRenderModule mod_djclassifieds_search (Search Classifieds) (736B) (0%) | 18μs |
| 1 x beforeRenderModule mod_djclassifieds_items (Classifieds) (736B) (0%) | 18μs |
| 1 x beforeRenderModule mod_easysocial_videos (Latest Videos) (736B) (0%) | 17μs |
| 1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 17μs |
SELECT @@SESSION.sql_mode;143μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `p8hb4_session`
WHERE `session_id` = ?227μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = :session_id LIMIT 1175μ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)45.12ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `p8hb4_viewlevels`273μ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` = :guest388μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `p8hb4_admintools_storage`
WHERE `key` = 'cparams'1.01ms520B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `p8hb4_admintools_wafexceptions`251μs640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'3.33ms1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT * FROM `p8hb4_social_config` WHERE `type` = 'site'35.67ms40.64KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT sampleData
FROM p8hb4_kunena_version
ORDER BY id DESC LIMIT 12.17ms536B/libraries/kunena/src/Forum/KunenaForum.php:374CopySELECT config_value FROM p8hb4_hikashop_config WHERE config_namekey = 'version'1.51ms536B/plugins/system/hikamarketoverrides/hikamarketoverrides.php:31CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_application_settings fas4.32ms40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'6.12ms768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM p8hb4_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'196μs704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shoes' LIMIT 1432μs2.72KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM p8hb4_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shoes' LIMIT 117.45ms3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM p8hb4_jbusinessdirectory_mobile_app_config10.88ms1.63KB/components/com_jbusinessdirectory/helpers/utils.php:9380CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_default_attributes`10.88ms1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM p8hb4_jbusinessdirectory_default_attributes2.46ms1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_companies`8.19ms2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_categories`1.43ms1.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=38980μ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, name32.86ms19.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','38','0')92.12ms0B/components/com_jbusinessdirectory/helpers/utils.php:7609Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=38583μ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, name58.18ms19.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=176μ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 (38,38)
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 111.28ms704B/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000193μ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 (38,38)
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 2035.28ms1.47KB/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 (32)
group by cp.id
) as slec
where 1
order by featured desc13.92ms9.13KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_providers`1ms3.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 = 32 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday19.74ms1.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.weekday58.67ms1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_company_attributes`792μs1.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=32
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering540μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect * from p8hb4_jbusinessdirectory_categories c
where c.id=387.08ms2.72KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `p8hb4_jbusinessdirectory_attributes`791μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM p8hb4_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter670μ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`1.4ms18.19KBParams/libraries/src/Cache/Controller/CallbackController.php:120CopySELECT * FROM `p8hb4_social_access_rules` WHERE `group` = 'user' AND `state` = '1'2.74ms18.58KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `params` FROM `p8hb4_social_access` WHERE `uid` = NULL AND `type` = 'profiles'182μs520B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_themes` WHERE `element` = 'wireframe'594μs640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_backgrounds` WHERE `state`='1'1.35ms832B/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)832μs7.94KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'1.78ms2.56KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_workflows` WHERE `type` = 'user'264μs704B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_workflows_maps`
WHERE `uid` = '1' AND `type` = 'user'1.22ms704B/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` ASC1.37ms19.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` ASC348μs880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_apps`5.52ms26.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT id,placeholder
FROM `p8hb4_gdpr_checkbox`258μs576B/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.3ms2.98KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'365μ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 = 1469μ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')3.82ms752B/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 12921μs2.55KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '3'298μs2.53KB/libraries/src/Table/Table.php:780CopySET SQL_BIG_SELECTS=168μ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`956μs5.44KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_default_avatars` WHERE `uid` IN (1) AND `type`='profiles'224μ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)386μs656B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (835)2.77ms2.41KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT `session_id`, `userid` FROM `p8hb4_session` WHERE `userid` IN(835) AND `time` >= '1745692648' AND `client_id` <> '1'368μs11.56KB/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,3661μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '18' AND `group` = 'exif'601μs768B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '17' AND `group` = 'exif'1.24ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '16' AND `group` = 'exif'4.73ms880B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (18,17,16)458μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos_meta` where `photo_id` IN (18,17,16)3.32ms1.48KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_albums`
WHERE `id` = '2'2.14ms2.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,3644μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '8'1.24ms1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '7'657μs1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '6'1.33ms1008B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_photos` where `id` IN (8,7,6)392μs2.53KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_profiles`
WHERE `id` = '1'13.44ms2.56KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=835-administrator&view=profile'582μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'layout=all&view=albums'353μ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 zcount419μs536B/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, 5292μ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'85.76ms4.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'576μ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'468μ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'6.46ms4.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'2.31ms1.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'492μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '37'717μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '37'393μ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'406μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '8'276μs1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=8:brand&layout=category&view=pages'447μ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'974μ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'334μ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'2.74ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '35'8.2ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '35'480μ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'7.28ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '9'5.43ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=9:business-2&layout=category&view=pages'414μ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'635μ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'596μ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'448μs1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=pages'407μ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.71ms536B/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 52.35ms552B/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'4.35ms4.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'3.06ms1.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'3.12ms1.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.36ms4.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'4.38ms1.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.46ms1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '32'4.17ms2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '32'4.09ms848B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=4:automobile-agents&layout=item&view=groups'469μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '2'7.83ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=2:automobile&layout=category&view=groups'3.38ms768B/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'5.83ms536B/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'466μ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'1.5ms1.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_photos`
WHERE `id` = '31'605μs2.5KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_social_photos_meta` WHERE `photo_id` = '31'1.21ms944B/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'4.3ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_clusters_categories`
WHERE `id` = '14'8.61ms1.63KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=14:real-estate&layout=category&view=groups'587μs768B/libraries/src/Table/Table.php:780Copyselect count(1) from `p8hb4_social_clusters_nodes` as a INNER JOIN `p8hb4_users` as u on a.`uid` = u.`id` INNER JOIN `p8hb4_social_profiles_maps` as upm on a.`uid` = upm.`user_id` INNER JOIN `p8hb4_social_profiles` as up on upm.`profile_id` = up.id WHERE a.`cluster_id` = '3' AND a.`state` = '1' AND u.`block` = '0'1.17ms536B/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'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` = '3'1.61ms9.33KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=groups'5.29ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=dashboard'481μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=events'1.3ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=pages'1.52ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=groups'1.84ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=marketplaces'926μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=users'2.92ms768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'filter=all&view=videos'3.47ms800B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_configs`
WHERE `name` = 'config'2.34ms64.58KB/libraries/src/Table/Table.php:780CopySELECT * FROM p8hb4_hikashop_config612μs24.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));143μs0B/administrator/components/com_hikashop/helpers/helper.php:3357CopySELECT * FROM p8hb4_hikamarket_config598μs2.13KB/administrator/components/com_hikamarket/classes/config.php:16CopySELECT `name`,`element`
FROM `p8hb4_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 110.48ms896B/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)412μ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 zcount20.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, 31.21ms3.09KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '9'5.3ms1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=9:travel&view=videos'4.94ms784B/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 a387μ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` DESC305μ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'231μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_videos_categories`
WHERE `id` = '1'339μs1.28KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'categoryId=1:general&view=videos'3.62ms784B/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 a429μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect a.* from `p8hb4_social_likes` as a INNER JOIN `p8hb4_users` as b on a.`created_by` = b.`id` WHERE a.`uid` = '3' AND a.`type` = 'videos.user.create' AND b.`block` = 0 ORDER BY a.`id` DESC1.4ms1.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'247μ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 a754μ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` DESC5.21ms1.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'418μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'view=videos'443μs768B/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') )491μ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 2467ms133.42KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC14.83ms1.73KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'45.7ms2.48KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'5.98ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'27.77ms137.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='8' AND `type`='post'34.92ms536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'10.46ms928B/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'13.22ms2.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` asc503μs704B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'1.92ms2.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` = 8354.54ms3.06KB/administrator/components/com_easyblog/includes/utils.php:298CopySHOW FULL COLUMNS FROM `p8hb4_users`889μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_users`
WHERE `id` = :userid337μ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` = :muserid10.64ms1.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 )41.93ms520B/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` ASC6.21ms1.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` ASC23.01ms640B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'1.92ms21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'9.76ms1.28KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `p8hb4_easyblog_featured` WHERE `content_id`='7' AND `type`='post'274μs536B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'368μ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'412μ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` asc350μ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` ASC313μ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)19.18ms536B/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)2.88ms536B/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.58ms2.86KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '8'1.39ms133.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '9'433μs137.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='8'8.66ms928B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `p8hb4_easyblog_category`
WHERE `id` = '1'11.38ms2.72KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_post`
WHERE `id` = '7'1.44ms21.34KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_easyblog_revisions`
WHERE `id` = '8'452μs1.28KB/libraries/src/Table/Table.php:780CopySELECT * FROM `p8hb4_easyblog_meta` WHERE `type`='post' AND `content_id`='7'1.38ms928B/administrator/components/com_easyblog/includes/utils.php:298Copyselect `element` from `p8hb4_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'7.02ms520B/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' )941μ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' )1.06ms2.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'589μ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` = 'group' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )725μ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` = 'group' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )947μs2.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'622μ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` = 'event' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )2.18ms536B/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.07ms2.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'597μ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' )995μ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` = 'page' OR ( `a`.`state` = '1' AND `a`.`default` = '1' )1.02ms2.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,42.23ms22.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (68,66) AND `context_type`='badges' UNION SELECT * FROM `p8hb4_social_stream_item` as a WHERE `uid` IN (65) AND `context_type`='profiles'1.82ms1.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`1.78ms5.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)264μs672B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_users` where `user_id` IN (855,857)451μ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` >= '1745692652' AND `client_id` <> '1'428μ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` DESC415μ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'333μs1.33KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (68) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (66) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `p8hb4_social_shares` where `uid` IN (65) and `element` = 'stream.user'1.89ms640B/administrator/components/com_easysocial/includes/db/helpers/base.php:46Copyselect * from `p8hb4_social_shares` where id IN (26,855)218μs912B/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`233μs688B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '68'306μs1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'288μ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 a340μs912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=857-danieloriff&view=profile'424μs768B/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=26:newbie&layout=item&view=badges'422μs768B/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'203μ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'196μs536B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM `p8hb4_social_emoticons` AS `a` WHERE `a`.`state` = '1' ORDER BY `a`.`title` asc374μs1.11KB/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_stream_item`
WHERE `uid` = '66'334μs1.47KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `p8hb4_social_badges`
WHERE `id` = '26'285μ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 a15.46ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT *
FROM `p8hb4_social_urls`
WHERE `rawurl` = 'id=855-ronaldakfuh&view=profile'5ms768B/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'510μ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'190μ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` ASC1.82ms2.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` ASC1ms1.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.96ms2.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` ASC9.84ms912B/administrator/components/com_easysocial/includes/db/helpers/base.php:46CopySELECT * FROM p8hb4_djcf_categories WHERE published=1 ORDER BY parent_id, ordering33.48ms20.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.2ms20.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 18:00:00' ) v GROUP BY cat_id57.58ms576B/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 ASC54.15ms2.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 18:00:00' GROUP BY i.region_id483μs576B/administrator/components/com_djclassifieds/lib/djregion.php:362CopySELECT * FROM p8hb4_djcf_regions WHERE published=1 ORDER BY parent_id, ordering,name4.98ms42.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 18:52:27' ORDER BY i.date_sort DESC LIMIT 91.13ms24.92KB/modules/mod_djclassifieds_items/helper.php:295CopySELECT *
FROM `p8hb4_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'600μs2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `p8hb4_gsd_config`985μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `p8hb4_gsd_config`
WHERE `name` = 'config'273μs592B/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 desc372μs1.42KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM p8hb4_jmap_metainfo
WHERE `linkurl` = 'https://thepakistanlink.com/category/shoes'
AND `published` = 11.92ms912B/plugins/system/jmap/jmap.php:817CopySELECT *
FROM p8hb4_jmap_canonicals
WHERE `linkurl` = 'https://thepakistanlink.com/category/shoes'218μ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` = 11.08ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT *
FROM p8hb4_jmap_headings
WHERE `linkurl` = 'https://thepakistanlink.com/category/shoes'458μs752B/plugins/system/jmap/jmap.php:1134CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`p8hb4_jmap_text_replacements`
WHERE
`published` = 1249μs688B/plugins/system/jmap/jmap.php:509CopySELECT `session_id`
FROM `p8hb4_session`
WHERE `session_id` = ?316μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `p8hb4_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?160ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy