Please find the attached New Fiscal Policies and Procedures for BSA Units as well as an updated notice specific to third party payment companies, like PayPal and Venmo. These documents can also be found on the Council Administration webpage. 

Updated BSA Fiscal Policies for BSA Units.

Paypal and Venmo Reporting.  It also effects other online payment vendors.

Highlighted Activities

Monday, April 11, 2022 Gilbert Armour Blog 21041
Please find the attached New Fiscal Policies and Procedures for BSA Units as well as an updated notice specific to third party payment companies, like PayPal and Venmo. These documents can also be found on the Council Administration webpage. Updated BSA Fiscal Policies for BSA Units. Paypal and Venmo Reporting . It also effects other online payment vendors.
Saturday, December 07, 2024 Laura Conner Blog 1812
Thursday, December 5th, 2024 Zoom Recording Important Documents and Job Aids - Key steps for membership renewal and unit renewal Complete information on the National website has been updated. There are updated job aids as well as a new layout to make the job aids easier to find! https://www.scouting.org/resources/unit-and-membership-renewal/
Settings5.593MBMemory Usage572msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.3.14
Identityguest
Response200
Templatert_citadel
Database
Server
mysql
Version
8.0.41-0ubuntu0.22.04.1
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "25:blog" "id" => "384:updated-fiscal-policies-bsa-and-credit-card" "view...
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:43 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate,...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746365550 "last" => 1746365550...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (83.38KB) (11.11ms)
  • afterInitialise (1.15MB) (75.3ms)
  • afterRoute (343.04KB) (72ms)
  • beforeRenderComponent com_content (41.25KB) (5.38ms)
  • Before Access::preloadComponents (all components) (61.72KB) (8.13ms)
  • After Access::preloadComponents (all components) (121.38KB) (2.93ms)
  • Before Access::preloadPermissions (com_content) (1.66KB) (52μs)
  • After Access::preloadPermissions (com_content) (222.67KB) (3.43ms)
  • Before Access::getAssetRules (id:542 name:com_content.article.384) (10.65KB) (84μs)
  • After Access::getAssetRules (id:542 name:com_content.article.384) (7.38KB) (396μs)
  • afterRenderComponent com_content (313.25KB) (71.87ms)
  • afterDispatch (3.27KB) (680μs)
  • beforeRenderRawModule mod_menu (Top Menu) (813.79KB) (81.53ms)
  • afterRenderRawModule mod_menu (Top Menu) (317.07KB) (13.59ms)
  • beforeRenderModule mod_menu (Top Menu) (704B) (21μs)
  • afterRenderModule mod_menu (Top Menu) (3.36KB) (1.77ms)
  • beforeRenderRawModule mod_finder (Search) (4.8KB) (8.9ms)
  • afterRenderRawModule mod_finder (Search) (91.12KB) (14.59ms)
  • beforeRenderModule mod_finder (Search) (704B) (21μs)
  • afterRenderModule mod_finder (Search) (3.02KB) (380μs)
  • Before Access::getAssetRules (id:8 name:com_content) (570.49KB) (49.19ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (37μs)
  • beforeRenderRawModule mod_custom (Google Map) (328.73KB) (37.78ms)
  • afterRenderRawModule mod_custom (Google Map) (4.3KB) (2.35ms)
  • beforeRenderModule mod_custom (Google Map) (720B) (18μs)
  • afterRenderModule mod_custom (Google Map) (2.97KB) (384μs)
  • afterRender (495.97KB) (109ms)
  • 1 x afterRender (495.97KB) (18.99%)
    109ms
    1 x beforeRenderRawModule mod_menu (Top Menu) (813.79KB) (14.25%)
    81.53ms
    1 x afterInitialise (1.15MB) (13.16%)
    75.30ms
    1 x afterRoute (343.04KB) (12.58%)
    72.00ms
    1 x afterRenderComponent com_content (313.25KB) (12.56%)
    71.87ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (570.49KB) (8.6%)
    49.19ms
    1 x beforeRenderRawModule mod_custom (Google Map) (328.73KB) (6.6%)
    37.78ms
    1 x afterRenderRawModule mod_finder (Search) (91.12KB) (2.55%)
    14.59ms
    1 x afterRenderRawModule mod_menu (Top Menu) (317.07KB) (2.38%)
    13.59ms
    1 x afterLoad (83.38KB) (1.94%)
    11.11ms
    1 x beforeRenderRawModule mod_finder (Search) (4.8KB) (1.56%)
    8.90ms
    1 x Before Access::preloadComponents (all components) (61.72KB) (1.42%)
    8.13ms
    1 x beforeRenderComponent com_content (41.25KB) (0.94%)
    5.38ms
    1 x After Access::preloadPermissions (com_content) (222.67KB) (0.6%)
    3.43ms
    1 x After Access::preloadComponents (all components) (121.38KB) (0.51%)
    2.93ms
    1 x afterRenderRawModule mod_custom (Google Map) (4.3KB) (0.41%)
    2.35ms
    1 x afterRenderModule mod_menu (Top Menu) (3.36KB) (0.31%)
    1.77ms
    1 x afterDispatch (3.27KB) (0.12%)
    680μs
    1 x After Access::getAssetRules (id:542 name:com_content.article.384) (7.38KB) (0.07%)
    396μs
    1 x afterRenderModule mod_custom (Google Map) (2.97KB) (0.07%)
    384μs
    1 x afterRenderModule mod_finder (Search) (3.02KB) (0.07%)
    380μs
    1 x Before Access::getAssetRules (id:542 name:com_content.article.384) (10.65KB) (0.01%)
    84μs
    1 x Before Access::preloadPermissions (com_content) (1.66KB) (0.01%)
    52μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    37μs
    1 x beforeRenderModule mod_menu (Top Menu) (704B) (0%)
    21μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    21μs
    1 x beforeRenderModule mod_custom (Google Map) (720B) (0%)
    18μs
46 statements were executed, 7 of which were duplicates, 39 unique57.67ms204.96KB
  • SELECT @@SESSION.sql_mode;247μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `xcz7b_session` WHERE `session_id` = ?2.41ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `xcz7b_session` WHERE `session_id` = :session_id LIMIT 1310μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `xcz7b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)3.45ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `xcz7b_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.24ms1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `xcz7b_viewlevels`498μs704B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `xcz7b_usergroups` AS `a` LEFT JOIN `xcz7b_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest658μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `xcz7b_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.35ms3.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 `xcz7b_menu` AS `m` LEFT JOIN `xcz7b_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`2.3ms52.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `xcz7b_template_styles` AS `s` LEFT JOIN `xcz7b_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` = 1892μs912B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM xcz7b_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_citadel' ORDER BY s.id562μs816B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `xcz7b_languages` WHERE `published` = 1 ORDER BY `ordering` ASC483μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `xcz7b_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)1.79ms7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `xcz7b_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.7ms25.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `xcz7b_content`3.37ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `xcz7b_content` SET `hits` = (`hits` + 1) WHERE `id` = '384'3.16ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `xcz7b_content` AS `a` INNER JOIN `xcz7b_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `xcz7b_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `xcz7b_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `xcz7b_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `xcz7b_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.83ms7.38KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `xcz7b_categories` AS `s` INNER JOIN `xcz7b_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`1.51ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `xcz7b_contentitem_tag_map` AS `m` INNER JOIN `xcz7b_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)817μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `xcz7b_categories` AS `s` INNER JOIN `xcz7b_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`1.55ms3.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 xcz7b_fields AS a LEFT JOIN `xcz7b_languages` AS l ON l.lang_code = a.language LEFT JOIN xcz7b_users AS uc ON uc.id=a.checked_out LEFT JOIN xcz7b_viewlevels AS ag ON ag.id = a.access LEFT JOIN xcz7b_users AS ua ON ua.id = a.created_user_id LEFT JOIN xcz7b_fields_groups AS g ON g.id = a.group_id LEFT JOIN `xcz7b_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 ASC1.35ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `xcz7b_categories` AS `s` INNER JOIN `xcz7b_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`1.4ms3.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 `xcz7b_modules` AS `m` LEFT JOIN `xcz7b_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `xcz7b_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`2.07ms18.06KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `xcz7b_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1730μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `xcz7b_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)682μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `xcz7b_menu_types` AS `a` WHERE `a`.`client_id` = 0364μs672B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM xcz7b_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft1.16ms1.73KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT cat.id AS id FROM xcz7b_categories AS cat LEFT JOIN xcz7b_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 AND cat.published < 1 GROUP BY cat.id1.28ms568B/libraries/gantry5/src/classes/Gantry/Joomla/Category/CategoryFinder.php:205Copy
  • SELECT a.id FROM xcz7b_categories AS a WHERE `a`.`id` IN (25) AND `a`.`extension` = 'com_content' AND `a`.`id` NOT IN (24,35,36) AND `a`.`access` IN (1,5) AND `a`.`published` IN (1) AND `a`.`language` IN ('en-GB','*')331μs536B/libraries/gantry5/src/classes/Gantry/Joomla/Object/Finder.php:203Copy
  • SHOW FULL COLUMNS FROM `xcz7b_categories`2.52ms1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT a.* FROM xcz7b_categories AS a WHERE id IN (25) ORDER BY lft559μs3KB/libraries/gantry5/src/classes/Gantry/Joomla/Object/AbstractObject.php:548Copy
  • SELECT COUNT(*) FROM xcz7b_content AS a INNER JOIN xcz7b_categories AS c ON c.id = a.catid WHERE `a`.`catid` NOT IN (24,35,36) AND ((a.publish_up IN ('0000-00-00 00:00:00', '1000-01-01 00:00:00') OR a.publish_up IS NULL) OR a.publish_up <= '2025-05-04 13:32:30') AND ((a.publish_down IN ('0000-00-00 00:00:00', '1000-01-01 00:00:00') OR a.publish_down IS NULL) OR a.publish_down >= '2025-05-04 13:32:30') AND a.state >= 1 AND `a`.`access` IN (1,5) AND `c`.`access` IN (1,5) AND `a`.`state` IN (1) AND `a`.`language` IN ('en-GB','*') AND `a`.`catid` IN (25) ORDER BY a.`publish_up` ASC974μs536B/libraries/gantry5/src/classes/Gantry/Joomla/Object/Finder.php:222Copy
  • SELECT a.id FROM xcz7b_content AS a INNER JOIN xcz7b_categories AS c ON c.id = a.catid WHERE `a`.`catid` NOT IN (24,35,36) AND ((a.publish_up IN ('0000-00-00 00:00:00', '1000-01-01 00:00:00') OR a.publish_up IS NULL) OR a.publish_up <= '2025-05-04 13:32:30') AND ((a.publish_down IN ('0000-00-00 00:00:00', '1000-01-01 00:00:00') OR a.publish_down IS NULL) OR a.publish_down >= '2025-05-04 13:32:30') AND a.state >= 1 AND `a`.`access` IN (1,5) AND `c`.`access` IN (1,5) AND `a`.`state` IN (1) AND `a`.`language` IN ('en-GB','*') AND `a`.`catid` IN (25) ORDER BY a.`publish_up` ASC LIMIT 2840μs3.04KB/libraries/gantry5/src/classes/Gantry/Joomla/Object/Finder.php:203Copy
  • SELECT a.* FROM xcz7b_content AS a WHERE id IN (384,582) ORDER BY id535μs3.11KB/libraries/gantry5/src/classes/Gantry/Joomla/Object/AbstractObject.php:548Copy
  • SHOW FULL COLUMNS FROM `xcz7b_users`2.15ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `xcz7b_users` WHERE `id` = :userid413μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `xcz7b_usergroups` AS `g` INNER JOIN `xcz7b_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid566μs1.37KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `xcz7b_users` WHERE `id` = :userid377μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `xcz7b_usergroups` AS `g` INNER JOIN `xcz7b_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid507μs1.41KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `xcz7b_modules` AS `m` LEFT JOIN `xcz7b_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `xcz7b_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.91ms18.06KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM xcz7b_menu AS m WHERE m.menutype = 'staff-login' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft579μs752B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM `xcz7b_schemaorg` WHERE `itemId` = :itemId AND `context` = :context524μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `xcz7b_content` AS `a` INNER JOIN `xcz7b_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `xcz7b_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `xcz7b_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `xcz7b_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `xcz7b_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.4ms6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `xcz7b_scheduler_tasks` AS `a` WHERE `a`.`state` = 1510μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `xcz7b_session` WHERE `session_id` = ?384μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `xcz7b_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.42ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy