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

YES – I agree to tracking cookies. No thanks – I agree to session cookies only.

Barbara Schreiner WIN Executive Director

Water Integrity Network, Germany

Barbara Schreiner is Executive Director of the Water Integrity Network. She has over 30 years’ experience in water management in developing countries, with a focus on good governance and addressing poverty, inequality, gender and other forms of social and economic marginalisation.

Articles written by Barbara Schreiner

Managing corruption risks in my sanitation programme? Not my problem…or is it?

  1173        3. December 2024

Integrity issues can undermine the work we do in sanitation and make our job harder, leaving behind rampant pollution and millions without dignified sanitation. Yet there’s a lot that we can do to prevent corruption and malpractice. People in the sector are in a good position to do something about it. 

 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

J! InfoRequestSessionProfileQueries46
Settings3.205MBMemory Usage48.88msRequest 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" => 1746738575 "last" => 1746738575...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (91.18KB) (721μs)
  • afterInitialise (1.1MB) (7.54ms)
  • afterRoute (97.85KB) (2.07ms)
  • beforeRenderComponent com_contact (106.95KB) (1.2ms)
  • Before Access::preloadComponents (all components) (36.93KB) (378μs)
  • After Access::preloadComponents (all components) (113.48KB) (547μs)
  • Before Access::getAssetRules (id:7 name:com_contact) (1.1KB) (13μs)
  • After Access::getAssetRules (id:7 name:com_contact) (7.31KB) (45μs)
  • Before Access::getAssetRules (id:1 name:root.1) (52.12KB) (2.45ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (18μs)
  • afterRenderComponent com_contact (496.13KB) (11.37ms)
  • afterDispatch (2.59KB) (67μs)
  • beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (359.51KB) (2.07ms)
  • afterRenderRawModule mod_tags_popular (Popular Topic Tags) (44.57KB) (4.91ms)
  • beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (23μs)
  • afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.3KB) (3.83ms)
  • beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (17μs)
  • afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.98KB) (4.52ms)
  • beforeRenderRawModule mod_menu (Footer SuSanA Menu) (376B) (82μs)
  • afterRenderRawModule mod_menu (Footer SuSanA Menu) (41.29KB) (452μs)
  • beforeRenderModule mod_menu (Footer SuSanA Menu) (120B) (103μs)
  • afterRenderModule mod_menu (Footer SuSanA Menu) (4.45KB) (138μs)
  • beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (35μs)
  • afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (103μ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) (19μs)
  • beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (16μs)
  • afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (13μs)
  • beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (15μs)
  • afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (12μs)
  • afterRender (194.27KB) (5.86ms)
  • 1 x afterRenderComponent com_contact (496.13KB) (23.26%)
    11.37ms
    1 x afterInitialise (1.1MB) (15.43%)
    7.54ms
    1 x afterRender (194.27KB) (12%)
    5.86ms
    1 x afterRenderRawModule mod_tags_popular (Popular Topic Tags) (44.57KB) (10.04%)
    4.91ms
    1 x afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.98KB) (9.24%)
    4.52ms
    1 x afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.3KB) (7.85%)
    3.83ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (52.12KB) (5.01%)
    2.45ms
    1 x beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (359.51KB) (4.24%)
    2.07ms
    1 x afterRoute (97.85KB) (4.24%)
    2.07ms
    1 x beforeRenderComponent com_contact (106.95KB) (2.45%)
    1.20ms
    1 x afterLoad (91.18KB) (1.47%)
    721μs
    1 x After Access::preloadComponents (all components) (113.48KB) (1.12%)
    547μs
    1 x afterRenderRawModule mod_menu (Footer SuSanA Menu) (41.29KB) (0.92%)
    452μs
    1 x Before Access::preloadComponents (all components) (36.93KB) (0.77%)
    378μs
    1 x afterRenderModule mod_menu (Footer SuSanA Menu) (4.45KB) (0.28%)
    138μs
    1 x beforeRenderModule mod_menu (Footer SuSanA Menu) (120B) (0.21%)
    103μs
    1 x afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (0.21%)
    103μs
    1 x beforeRenderRawModule mod_menu (Footer SuSanA Menu) (376B) (0.17%)
    82μs
    1 x afterDispatch (2.59KB) (0.14%)
    67μs
    1 x After Access::getAssetRules (id:7 name:com_contact) (7.31KB) (0.09%)
    45μ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.06%)
    27μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (0.05%)
    23μs
    1 x beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (0.04%)
    22μs
    1 x afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (0.04%)
    19μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.04%)
    18μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (0.03%)
    17μ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 Before Access::getAssetRules (id:7 name:com_contact) (1.1KB) (0.03%)
    13μs
    1 x afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (0.03%)
    13μ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 unique19.14ms140.96KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7
  • SELECT @@SESSION.sql_mode;70μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ssblg_session` WHERE `session_id` = ?124μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = :session_id LIMIT 175μ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)122μ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` = 1212μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ssblg_viewlevels`73μ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` = :guest140μ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`416μ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`262μ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`218μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `ssblg_contact_details` WHERE `alias` = :segment AND `catid` = :id173μs1.34KBParams/components/com_contact/src/Service/Router.php:269Copy
  • SELECT * FROM `ssblg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC153μ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` = 1160μ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)326μ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)224μ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)242μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SHOW FULL COLUMNS FROM `ssblg_users`461μ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 ASC261μs12.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId89μs1.32KBParams/plugins/user/token/src/Extension/Token.php:475Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId78μ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 ASC240μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId84μ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`271μ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 ASC289μ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` = :itemid134μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SHOW FULL COLUMNS FROM `ssblg_contact_details`536μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ssblg_contact_details` SET `hits` = (`hits` + 1) WHERE `id` = '41'120μ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`275μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `item_id` FROM `ssblg_fields_values` WHERE `field_id` = 48 AND FIND_IN_SET (41, `value`)151μs536B/components/com_newsbox/src/Helper/SusanaHelper.php:150Copy
  • SELECT * FROM `ssblg_content` WHERE `id` IN (47) AND `state` = 1 ORDER BY `hits` DESC169μs19.09KB/components/com_newsbox/src/Helper/SusanaHelper.php:162Copy
  • SELECT `alias`,`catid` FROM ssblg_content WHERE `id` = :key105μ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`277μ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`356μ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.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.91ms2.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.64ms2.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.63ms2.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.93ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT * FROM `ssblg_schemaorg` WHERE `itemId` = :itemId AND `context` = :context155μ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)217μ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)218μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `profile_value` FROM `ssblg_user_profiles` WHERE `profile_key` = :profileKey AND `user_id` = :userId123μ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` = 1149μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = ?99μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ssblg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?114μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy