Last week, we provided the Board of Trustees with our actuarial valuation reports for the 2023 school year. Admittedly they can be pretty dry reading, but they make some important points about the financial health of ATRS.

Every pension system like ours is built on a promise to pay lifetime retirement benefits to both our retired members and our active working members. Our ability to meet that promise for generations to come depends on many different factors – the health of the national economy, the performance of our investment portfolio, our members’ life expectancy, and increases in teacher pay that affect benefits and contributions, just to name a few examples.

Our actuaries’ job is to take all those variables into account, project what it will cost to pay those decades’ worth of retirement benefits, and then evaluate how prepared our system is to keep that promise. They update their projections and evaluations every year, so that we can make course corrections as necessary.

Our actuaries are with the firm of Gabriel, Roeder, Smith & Company (GRS). They are a national firm and work with many other pension systems around the country. Their firm has a long history with ATRS – they have been preparing the ATRS actuarial valuations for more than 60 years!

We are grateful for our long partnership with GRS. You can find out more about them at their website here: https://www.grsconsulting.com/

ATRS Financial Health

These latest valuation reports find that ATRS is 100% funded as to future benefit payments for all of our current retirees and beneficiaries. In other words, ATRS has enough assets on hand to fully pay out monthly benefits for life for every retired member. This is a goal that ATRS has consistently met every year since 1980.

When we zoom out to also consider the future benefits that will be owed to our members who are still working, ATRS is 82.1% funded. In other words, even if ATRS closed up shop and did nothing but send out checks to all of our members for the benefits they’ve already earned, we have enough funds on hand to pay 82.1% of those benefits.

This is a good, healthy number; pension systems are generally considered healthy if their funded position is 80% or greater. The reason why it doesn’t have to be 100% is that this number is a very conservative estimate. It doesn’t account for the member and employer contributions that ATRS will continue to collect in the coming years. It assumes a conservative investment return, and historically ATRS has earned returns larger than that assumed rate over time.

But it’s also important to remember that this 82.1% number is only a snapshot of a single moment. What’s more important is the trend over time and whether that funded position is stable. And when you look at our history, our position is stable. Over the last 20 years our funded position has ranged between 71% and 85%, and it has been trending up for several years.

What this means is that ATRS is financially strong, and that we are prepared to keep the promise of lifetime retirement benefits for all of our members.

Interesting Facts & Figures

The actuarial valuation reports also provide some interesting information on our System and its members during the 2023 school year:

  • ATRS paid retirement benefits to 56,646 retirees and surviving beneficiaries, totaling nearly $1.347 billion. That’s about a 4% increase over 2022.
  • The average member retirement benefit was $24,653 annually.
  • We have 908 retirees who are age 90 to 94, and 246 retirees who are 95 or older.
  • The average age of an ATRS retiree is 72, and the average age of an active employee is 44.
  • About 77% of our members are female and 23% are male.
  • Schools and our other covered employers reported 75,495 employees, receiving a total payroll of $3.492 billion.
  • We have 832 active members still working who are 70 or older.

You can find our actuarial valuation reports and read them for yourself at this link: https://www.artrs.gov/publications

Retirement Season is Coming

I know some of you are starting to seriously plan for retirement at the end of this year. For those of you who intend to retire effective July 1, the application window will open March 1 and close May 31. And if you intend to enter T-DROP this year, your application must be received by ATRS between March 1 and May 31.

Please remember that you are responsible for sending us your retirement or T-DROP application. Never assume that your school business office will send the application for you, because that’s not their job.

In the coming weeks we will be distributing our 2024 Retirement Planner, applications, and other information to help you in making decisions and preparing your retirement application. If you have any questions, or if you would like to get benefit estimates to help you plan, please contact one of our counselors by emailing us at info@artrs.gov or calling (501) 682-1517.

Mark White
Executive Director, ATRS
MarkW@artrs.gov
Office: (501) 621-8853
Cell: (501) 541-2057

19.999MBMemory Usage185msRequest Duration
Joomla! Version4.4.6
PHP Version8.0.30
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.7.4-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "REDIRECT_UNIQUE_ID" => "Z-SHa4VE1MTFlm9moHDnKAAAAAs" "REDIRECT_HTTP_AUTHORIZATION" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744078699 "last" => 1744078699...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.44MB) (40.39ms)
  • afterInitialise (6.65MB) (63.3ms)
  • afterRoute (1.08MB) (7.44ms)
  • beforeRenderComponent com_content (834.44KB) (6.82ms)
  • Before Access::preloadComponents (all components) (459.82KB) (3.14ms)
  • After Access::preloadComponents (all components) (123.09KB) (900μs)
  • Before Access::preloadPermissions (com_content) (4.84KB) (18μs)
  • After Access::preloadPermissions (com_content) (457.36KB) (1.65ms)
  • Before Access::getAssetRules (id:1557 name:com_content.article.1150) (35.17KB) (34μs)
  • After Access::getAssetRules (id:1557 name:com_content.article.1150) (27.27KB) (261μs)
  • afterRenderComponent com_content (2.65MB) (34.89ms)
  • afterDispatch (2.25KB) (75μs)
  • beforeRenderRawModule mod_menu (Administration) (658.1KB) (4.96ms)
  • afterRenderRawModule mod_menu (Administration) (258.13KB) (2.26ms)
  • beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (44μs)
  • afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (1.5ms)
  • beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (24μs)
  • afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (953μs)
  • beforeRenderRawModule mod_finder (Search Box) (960B) (29μs)
  • afterRenderRawModule mod_finder (Search Box) (467.79KB) (4.54ms)
  • beforeRenderRawModule mod_custom (Top Login) (464B) (21μs)
  • afterRenderRawModule mod_custom (Top Login) (1000B) (135μs)
  • beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (44μs)
  • afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (916μs)
  • beforeRenderRawModule mod_custom (ATRS Copyright Info) (1.13KB) (20μs)
  • afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (120μs)
  • beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (235μs)
  • afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (124μs)
  • beforeRenderModule mod_custom (ATRS Copyright Info) (2.98KB) (17μs)
  • afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (100μs)
  • beforeRenderModule mod_menu (Administration) (2.21KB) (60μs)
  • afterRenderModule mod_menu (Administration) (4.02KB) (105μs)
  • beforeRenderModule mod_finder (Search Box) (2.42KB) (33μs)
  • afterRenderModule mod_finder (Search Box) (5.77KB) (81μs)
  • beforeRenderModule mod_custom (Top Login) (1.4KB) (15μs)
  • afterRenderModule mod_custom (Top Login) (3.02KB) (76μs)
  • beforeRenderModule mod_custom (Top Login-mobile) (800B) (31μs)
  • afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (75μs)
  • beforeRenderModule mod_menu (atrsmenu) (808B) (17μs)
  • afterRenderModule mod_menu (atrsmenu) (3.05KB) (51μs)
  • afterRender (1.25MB) (8.06ms)
  • 1 x afterInitialise (6.65MB) (34.3%)
    63.30ms
    1 x afterLoad (4.44MB) (21.89%)
    40.39ms
    1 x afterRenderComponent com_content (2.65MB) (18.91%)
    34.89ms
    1 x afterRender (1.25MB) (4.37%)
    8.06ms
    1 x afterRoute (1.08MB) (4.03%)
    7.44ms
    1 x beforeRenderComponent com_content (834.44KB) (3.69%)
    6.82ms
    1 x beforeRenderRawModule mod_menu (Administration) (658.1KB) (2.68%)
    4.96ms
    1 x afterRenderRawModule mod_finder (Search Box) (467.79KB) (2.46%)
    4.54ms
    1 x Before Access::preloadComponents (all components) (459.82KB) (1.7%)
    3.14ms
    1 x afterRenderRawModule mod_menu (Administration) (258.13KB) (1.22%)
    2.26ms
    1 x After Access::preloadPermissions (com_content) (457.36KB) (0.89%)
    1.65ms
    1 x afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (0.81%)
    1.50ms
    1 x afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (0.52%)
    953μs
    1 x afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (0.5%)
    916μs
    1 x After Access::preloadComponents (all components) (123.09KB) (0.49%)
    900μs
    1 x After Access::getAssetRules (id:1557 name:com_content.article.1150) (27.27KB) (0.14%)
    261μs
    1 x beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (0.13%)
    235μs
    1 x afterRenderRawModule mod_custom (Top Login) (1000B) (0.07%)
    135μs
    1 x afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (0.07%)
    124μs
    1 x afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (0.06%)
    120μs
    1 x afterRenderModule mod_menu (Administration) (4.02KB) (0.06%)
    105μs
    1 x afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (0.05%)
    100μs
    1 x afterRenderModule mod_finder (Search Box) (5.77KB) (0.04%)
    81μs
    1 x afterRenderModule mod_custom (Top Login) (3.02KB) (0.04%)
    76μs
    1 x afterDispatch (2.25KB) (0.04%)
    75μs
    1 x afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (0.04%)
    75μs
    1 x beforeRenderModule mod_menu (Administration) (2.21KB) (0.03%)
    60μs
    1 x afterRenderModule mod_menu (atrsmenu) (3.05KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (0.02%)
    44μs
    1 x beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (0.02%)
    44μs
    1 x Before Access::getAssetRules (id:1557 name:com_content.article.1150) (35.17KB) (0.02%)
    34μs
    1 x beforeRenderModule mod_finder (Search Box) (2.42KB) (0.02%)
    33μs
    1 x beforeRenderModule mod_custom (Top Login-mobile) (800B) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_finder (Search Box) (960B) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (0.01%)
    24μs
    1 x beforeRenderRawModule mod_custom (Top Login) (464B) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_custom (ATRS Copyright Info) (1.13KB) (0.01%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (4.84KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (ATRS Copyright Info) (2.98KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_menu (atrsmenu) (808B) (0.01%)
    17μs
    1 x beforeRenderModule mod_custom (Top Login) (1.4KB) (0.01%)
    15μs
33 statements were executed, 3 of which were duplicates, 30 unique18.34ms449.57KB
  • SELECT @@SESSION.sql_mode;134μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `lv09n_session` WHERE `session_id` = ?232μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = :session_id LIMIT 1159μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `lv09n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.6ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lv09n_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1624μs21.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lv09n_viewlevels`295μs1.81KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `lv09n_usergroups` AS `a` LEFT JOIN `lv09n_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest413μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `lv09n_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2,:preparedArray3) ORDER BY `ordering`1.1ms16.33KBParams/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 `lv09n_menu` AS `m` LEFT JOIN `lv09n_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`723μs143.8KBParams/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 `lv09n_categories` AS `s` INNER JOIN `lv09n_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`417μs13.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lv09n_content` WHERE `alias` = :alias AND `catid` = :catid204μs1.66KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `lv09n_languages` WHERE `published` = 1 ORDER BY `ordering` ASC205μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `lv09n_template_styles` AS `s` LEFT JOIN `lv09n_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` = 1290μs1.22KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lv09n_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)499μs11.13KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lv09n_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0855μs109.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lv09n_content`836μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `lv09n_content` SET `hits` = (`hits` + 1) WHERE `id` = '1150'1.67ms2.55KB/libraries/src/Table/Table.php:1325Copy
  • 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 `lv09n_content` AS `a` INNER JOIN `lv09n_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `lv09n_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `lv09n_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `lv09n_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `lv09n_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)555μs25.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 `lv09n_categories` AS `s` INNER JOIN `lv09n_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,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`569μs6.06KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `lv09n_contentitem_tag_map` AS `m` INNER JOIN `lv09n_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,:preparedArray3)422μs5.25KBParams/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 `lv09n_categories` AS `s` INNER JOIN `lv09n_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,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`571μs6.06KBParams/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 lv09n_fields AS a LEFT JOIN `lv09n_languages` AS l ON l.lang_code = a.language LEFT JOIN lv09n_users AS uc ON uc.id=a.checked_out LEFT JOIN lv09n_viewlevels AS ag ON ag.id = a.access LEFT JOIN lv09n_users AS ua ON ua.id = a.created_user_id LEFT JOIN lv09n_fields_groups AS g ON g.id = a.group_id LEFT JOIN `lv09n_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,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) 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.08ms6.58KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `lv09n_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid262μs1.69KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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 `lv09n_categories` AS `s` INNER JOIN `lv09n_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,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`368μs6.06KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `lv09n_modules` AS `m` LEFT JOIN `lv09n_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `lv09n_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,:preparedArray3)) 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`650μs6.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 lv09n_fields AS a LEFT JOIN `lv09n_languages` AS l ON l.lang_code = a.language LEFT JOIN lv09n_users AS uc ON uc.id=a.checked_out LEFT JOIN lv09n_viewlevels AS ag ON ag.id = a.access LEFT JOIN lv09n_users AS ua ON ua.id = a.created_user_id LEFT JOIN lv09n_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4,: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 ASC512μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `lv09n_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1300μs1.16KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `lv09n_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,4,14)168μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • 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 `lv09n_scheduler_tasks` AS `a` WHERE `a`.`state` = 1146μs1.71KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SHOW TABLES396μs5.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM lv09n_acymailing_config215μs12.88KB/administrator/components/com_acymailing/compat/joomla.php:629Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = ?122μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `lv09n_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.75ms11.89KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy