Cookie tracking notice
Are we allowed to crumble with cookies and anonymous tracking?

We use cookies on our website. Some of them are essential for the operation of the site (so called session cookies), while others help us to improve this site and the user experience (tracking cookies). We use the application Matomo and the external service etracker to analyze your behavior on our website anonymously. Because we value your privacy, we are here with asking your permission to use the following technologies. You can change your settings any time via this link or the menu item in footer menu. For more information visit our Data Policy

Jack Sim Specialist in Water and Health

World Toilet Organization, Singapore


After founding 16 companies and gaining financial independence at 40, Prof Jack Sim retired from business to devote the rest of his life on social development. He founded the World Toilet Organisation in 2001, made its founding day, 19 November, the official UN World Toilet Day, endorsed by all 193 countries at the UN General Assembly, and broke the taboo on sanitation worldwide. He is affectionately known by the world's media as Mr Toilet.

Articles written by Jack Sim


World Toilet Day Interview with Jack Sim

  564        10. October 2023

On this special occasion of World Toilet Day, we are honoured to have Jack Sim, founder of the World Toilet Organisation, join us for an enlightening conversation. After founding 16 companies and gaining financial independence at 40, Prof Jack Sim retired from business to devote the rest of his life to social development. He founded the World Toilet Organization in 2001, made the 19th November the official UN World Toilet Day approved by all 193 countries at the UN General Assembly, and broke the taboo on Sanitation globally. He is fondly known as Mr Toilet by the global media and is a founding member of SuSanA since 2008. In this interview, Mr Sim shares his insights on a range of critical issues, from his pioneering efforts to shift global media attention from water to sanitation, to the profound impact of the lack of toilets and proper sanitation on women. He also sheds light on the urgent need to break the taboo surrounding toilets and sanitation, and the steps needed to ensure that sanitation takes its rightful place on the global agenda.

 Read more

Share this page on

Share your experience in an own blog article

Do you have valuable insights or a unique perspective on WASH? We welcome article submissions from experts, researchers, practitioners, and anyone passionate about the field.

Make an impact and reach our global audience by contributing your article. Whether it's an innovative project, best practices, or personal stories, we value diverse perspectives. Join us in advancing the conversation and driving positive change in sustainable sanitation.

To submit your article or learn more about the process, contact us at info@susana.org

Settings3.209MBMemory Usage50.34msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.3.14
Identityguest
Response200
Templatesusanablog
Database
Server
mysql
Version
8.0.41-32
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:65 [ "MAGICK_C0DER_MODULE_PATH" => "/usr/local/php/lib64/ImageMagick-7.1.1/modules-Q16HDRI/c...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746815729 "last" => 1746815729...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (90.85KB) (339μs)
  • afterInitialise (1.1MB) (7.33ms)
  • afterRoute (98.12KB) (1.98ms)
  • beforeRenderComponent com_contact (106.6KB) (1.04ms)
  • Before Access::preloadComponents (all components) (37.02KB) (365μs)
  • After Access::preloadComponents (all components) (113.48KB) (618μs)
  • Before Access::getAssetRules (id:7 name:com_contact) (1.1KB) (16μs)
  • After Access::getAssetRules (id:7 name:com_contact) (7.31KB) (40μs)
  • Before Access::getAssetRules (id:1 name:root.1) (51.7KB) (2.89ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (22μs)
  • afterRenderComponent com_contact (497.98KB) (12.5ms)
  • afterDispatch (2.59KB) (53μs)
  • beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (362.15KB) (2.16ms)
  • afterRenderRawModule mod_tags_popular (Popular Topic Tags) (44.41KB) (5.24ms)
  • beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (22μs)
  • afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.15KB) (4.18ms)
  • beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (21μs)
  • afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.82KB) (4.72ms)
  • beforeRenderRawModule mod_menu (Footer SuSanA Menu) (376B) (63μs)
  • afterRenderRawModule mod_menu (Footer SuSanA Menu) (41.29KB) (422μs)
  • beforeRenderModule mod_menu (Footer SuSanA Menu) (2.48KB) (102μs)
  • afterRenderModule mod_menu (Footer SuSanA Menu) (4.49KB) (133μs)
  • beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (35μs)
  • afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (112μs)
  • beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (2μs)
  • afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (27μs)
  • beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (22μs)
  • afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (17μs)
  • beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (16μs)
  • afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (14μs)
  • beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (15μs)
  • afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (12μs)
  • afterRender (194.07KB) (5.66ms)
  • 1 x afterRenderComponent com_contact (497.98KB) (24.82%)
    12.50ms
    1 x afterInitialise (1.1MB) (14.55%)
    7.33ms
    1 x afterRender (194.07KB) (11.25%)
    5.66ms
    1 x afterRenderRawModule mod_tags_popular (Popular Topic Tags) (44.41KB) (10.4%)
    5.24ms
    1 x afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.82KB) (9.38%)
    4.72ms
    1 x afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.15KB) (8.31%)
    4.18ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (51.7KB) (5.73%)
    2.89ms
    1 x beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (362.15KB) (4.29%)
    2.16ms
    1 x afterRoute (98.12KB) (3.93%)
    1.98ms
    1 x beforeRenderComponent com_contact (106.6KB) (2.06%)
    1.04ms
    1 x After Access::preloadComponents (all components) (113.48KB) (1.23%)
    618μs
    1 x afterRenderRawModule mod_menu (Footer SuSanA Menu) (41.29KB) (0.84%)
    422μs
    1 x Before Access::preloadComponents (all components) (37.02KB) (0.73%)
    365μs
    1 x afterLoad (90.85KB) (0.67%)
    339μs
    1 x afterRenderModule mod_menu (Footer SuSanA Menu) (4.49KB) (0.26%)
    133μs
    1 x afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (0.22%)
    112μs
    1 x beforeRenderModule mod_menu (Footer SuSanA Menu) (2.48KB) (0.2%)
    102μs
    1 x beforeRenderRawModule mod_menu (Footer SuSanA Menu) (376B) (0.13%)
    63μs
    1 x afterDispatch (2.59KB) (0.11%)
    53μs
    1 x After Access::getAssetRules (id:7 name:com_contact) (7.31KB) (0.08%)
    40μs
    1 x beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (0.07%)
    35μs
    1 x afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (0.05%)
    27μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (0.04%)
    22μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.04%)
    22μs
    1 x beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (0.04%)
    22μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (0.04%)
    21μs
    1 x afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (0.03%)
    17μs
    1 x Before Access::getAssetRules (id:7 name:com_contact) (1.1KB) (0.03%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (0.03%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (0.03%)
    15μs
    1 x afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (0.03%)
    14μs
    1 x afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (0.02%)
    12μs
    1 x beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (0%)
    2μs
46 statements were executed, 16 of which were duplicates, 30 unique20.84ms140.98KB
  • SELECT @@SESSION.sql_mode;75μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ssblg_session` WHERE `session_id` = ?139μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = :session_id LIMIT 193μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ssblg_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (:session_id, :guest, :time, :user_id, :username)139μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ssblg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1236μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ssblg_viewlevels`87μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ssblg_usergroups` AS `a` LEFT JOIN `ssblg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest164μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ssblg_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`500μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `ssblg_menu` AS `m` LEFT JOIN `ssblg_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`304μs4.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ssblg_categories` AS `s` INNER JOIN `ssblg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`243μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `ssblg_contact_details` WHERE `alias` = :segment AND `catid` = :id185μs1.34KBParams/components/com_contact/src/Service/Router.php:269Copy
  • SELECT * FROM `ssblg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC126μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ssblg_template_styles` AS `s` LEFT JOIN `ssblg_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1169μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ssblg_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)369μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT a.*,CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias FROM `ssblg_contact_details` AS `a` LEFT JOIN `ssblg_categories` AS `c` ON c.id = a.catid LEFT JOIN `ssblg_categories` AS `parent` ON parent.id = c.parent_id WHERE `a`.`id` = :id AND (`a`.`published` = :published OR `a`.`published` = :archived) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publish_up) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publish_down)253μs6.39KBParams/components/com_contact/src/Model/ContactModel.php:224Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)299μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SHOW FULL COLUMNS FROM `ssblg_users`536μs2.83KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM ssblg_fields AS a LEFT JOIN `ssblg_languages` AS l ON l.lang_code = a.language LEFT JOIN ssblg_users AS uc ON uc.id=a.checked_out LEFT JOIN ssblg_viewlevels AS ag ON ag.id = a.access LEFT JOIN ssblg_users AS ua ON ua.id = a.created_user_id LEFT JOIN ssblg_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC312μs12.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId103μs1.32KBParams/plugins/user/token/src/Extension/Token.php:475Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId111μs1.32KBParams/plugins/user/token/src/Extension/Token.php:475Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM ssblg_fields AS a LEFT JOIN `ssblg_languages` AS l ON l.lang_code = a.language LEFT JOIN ssblg_users AS uc ON uc.id=a.checked_out LEFT JOIN ssblg_viewlevels AS ag ON ag.id = a.access LEFT JOIN ssblg_users AS ua ON ua.id = a.created_user_id LEFT JOIN ssblg_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC276μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId118μs1.32KBParams/plugins/user/token/src/Extension/Token.php:475Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ssblg_categories` AS `s` INNER JOIN `ssblg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`329μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM ssblg_fields AS a LEFT JOIN `ssblg_languages` AS l ON l.lang_code = a.language LEFT JOIN ssblg_users AS uc ON uc.id=a.checked_out LEFT JOIN ssblg_viewlevels AS ag ON ag.id = a.access LEFT JOIN ssblg_users AS ua ON ua.id = a.created_user_id LEFT JOIN ssblg_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ssblg_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC393μs4.77KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `ssblg_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid166μs1.39KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SHOW FULL COLUMNS FROM `ssblg_contact_details`545μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ssblg_contact_details` SET `hits` = (`hits` + 1) WHERE `id` = '1'130μs48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ssblg_categories` AS `s` INNER JOIN `ssblg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`314μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `item_id` FROM `ssblg_fields_values` WHERE `field_id` = 48 AND FIND_IN_SET (1, `value`)181μs536B/components/com_newsbox/src/Helper/SusanaHelper.php:150Copy
  • SELECT * FROM `ssblg_content` WHERE `id` IN (18) AND `state` = 1 ORDER BY `hits` DESC143μs19.09KB/components/com_newsbox/src/Helper/SusanaHelper.php:162Copy
  • SELECT `alias`,`catid` FROM ssblg_content WHERE `id` = :key124μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ssblg_categories` AS `s` INNER JOIN `ssblg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`312μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ssblg_modules` AS `m` LEFT JOIN `ssblg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ssblg_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`398μs4.47KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 52.21ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 52.04ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.75ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.75ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.86ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 52.23ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT * FROM `ssblg_schemaorg` WHERE `itemId` = :itemId AND `context` = :context140μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • SELECT a.*,CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias FROM `ssblg_contact_details` AS `a` LEFT JOIN `ssblg_categories` AS `c` ON c.id = a.catid LEFT JOIN `ssblg_categories` AS `parent` ON parent.id = c.parent_id WHERE `a`.`id` = :id AND (`a`.`published` = :published OR `a`.`published` = :archived) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publish_up) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publish_down)218μs6.39KBParams/components/com_contact/src/Model/ContactModel.php:224Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)259μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId105μs1.32KBParams/plugins/user/token/src/Extension/Token.php:475Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `ssblg_scheduler_tasks` AS `a` WHERE `a`.`state` = 1154μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = ?112μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ssblg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?140μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy