The ATRS Board Modifies the Phase-in for T-DROP Annuitization Formula to Help Members

The ATRS Board just reduced the impact on current T-DROP participants who plan to convert part or all of their T-DROP balance into a supplemental monthly annuity.

Due to my interaction with members at school hall meetings, the ATRS Board has tweaked the formula for annuitization of T-DROP balances at the time of retirement. For members retiring out of T-DROP and converting all or part of their T-DROP balance into a supplemental monthly benefit, now the supplemental benefit is materially higher than recently projected. The ATRS Board balanced the need to absorb new actuarial standards with the impact the 6 year phase in of the new T-DROP annuitization would cause on extra retirements from T-DROP.

Starting immediately, all T-DROP balances accrued through the end of this fiscal year (June 30, 2018) will have an assumed rate of return of 7% for the T-DROP balance annuitized at the point of retirement.  This will prevent the annuitization amount per month from flat lining or actually decreasing over the next few years. Now the amounts will still increase to be much closer to the old formula. Also for all members in T-DROP as of June 30, 2018, the minimum assumed rate of return on all balances annuitized will be no lower than 5% (instead of a 3% assumed rate becoming effective in fiscal year 2023 as had been set in the phase in period adopted on November 13, 2017).  Hopefully this change will eliminate the pressure on this group of members to retire due to benefit projections that show declining T-DROP annuitization monthly benefits. This means that if you are in T-DROP and plan to annuitize any part of your T-DROP balance when you retire, GET A NEW PROJECTION!  If you just filed to retire from T-DROP due to the new formula's impact in a few years, you can still withdraw the retirement application and have time to think about it after getting a new projection.

For example, if a T-DROP participant has $100,000 in a T-DROP account on June 30, 2018  and the member decides to annuitize 50% of the T-DROP balance when the member retires 6 years from now, then $50,000  would be annuitized (1/2 of $100,000) with a guaranteed 7% assumed rate of return.  The balance accrued after June 30, 2018 would have a guaranteed 5% rate of return instead of a 3% assumed rate on the entire balance being annuitized according to the schedule adopted on November 13, 2017. This is good news for T-DROP participants, especially those who had planned to work longer but saw little or no additional monthly benefits since the added value of the T-DROP balance was essentially offset by the lower assumed rate of return on the whole balance being annuitized. Essentially, the ATRS Board has now modified the phase-in period on the changes to the T-DROP annuitization formula.

Monthly CBA Distributions Now Available!

When retiring out of T-DROP, establishing a Cash Balance Account (CBA) is an important option to consider.  The CBA allows you to leave all or a portion of the T-DROP balance in an interest bearing cash account.  The interest rates start at 2.5% and grow to 4% over time.

In order to make the T-DROP Cash Balance Account (CBA) program more attractive to members, ATRS now allows scheduled monthly CBA distributions.  In the past you were limited to two distributions per quarter, but now you can set up a request to receive a monthly distribution of a fixed amount.  The monthly distributions will be processed at the same time as the existing benefit payroll schedule (see ATRS website for the benefit payroll schedule).  To setup a monthly CBA withdrawal, simply complete the attached CBA Monthly Distribution Request form.  All forms received at ATRS by the 10th of any month will result in monthly deposits beginning in the same month; otherwise the deposits will start the next month.  CBA withdrawal requests in addition to the scheduled monthly distributions can be made but would require executive director approval.

Stay in Touch with ATRS and View YOUR Account Information

The ATRS website allows members to have direct access to specific member account information.  Now, approximately 14,000 members have direct account access to individualized account information.  Here is the link to the instructions to sign up: www.artrs.gov/welcome.

You can also sign up to obtain these executive director updates through your private email address.  Updates are made throughout the year such as at retirement season and other times when information needs to be shared.  Now, over 16,400 people have signed up to receive this executive director update by direct email delivery.  It is always a great pleasure for ATRS staff to learn of more ways to provide information to ATRS members, employers, beneficiaries, government officials, and the public.  The ATRS Board is committed to providing a system that is member friendly and transparent.

You can also get helpful ATRS information on the ATRS Facebook page under the name of Arkansas Teacher Retirement System.  Over 4,500 Facebook users get updates via the ATRS Facebook page.  Go to the Facebook page and "like" ATRS to get daily updates.  I try to go to the Facebook page every day to post information and answer member questions about ATRS.  In addition, if you use Twitter, you can join over 920 others by following events at ATRS and issues of interest on the ATRS Twitter page.  Remember that ATRS is here to serve you!  If you have questions, email me or call.

Respectfully,

George Hopkins

(501) 682-1820 Office
(501) 318-5998 Cell
georgeh@artrs.gov

List of Attachments:

1. CBA Monthly Distribution Request Form

 

20.007MBMemory Usage165msRequest 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-CmvombIdHC@2HjGT4EnAAAAGk" "REDIRECT_HTTP_AUTHORIZATION" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743824574 "last" => 1743824574...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.44MB) (40.16ms)
  • afterInitialise (6.65MB) (54.76ms)
  • afterRoute (1.08MB) (7.26ms)
  • beforeRenderComponent com_content (834.39KB) (5.43ms)
  • Before Access::preloadComponents (all components) (459.81KB) (2.2ms)
  • After Access::preloadComponents (all components) (123.09KB) (696μs)
  • Before Access::preloadPermissions (com_content) (4.84KB) (13μs)
  • After Access::preloadPermissions (com_content) (457.36KB) (1.21ms)
  • Before Access::getAssetRules (id:1149 name:com_content.article.836) (35.17KB) (28μs)
  • After Access::getAssetRules (id:1149 name:com_content.article.836) (27.27KB) (215μs)
  • afterRenderComponent com_content (2.65MB) (26.77ms)
  • afterDispatch (2.25KB) (71μs)
  • beforeRenderRawModule mod_menu (Administration) (658.1KB) (4.91ms)
  • afterRenderRawModule mod_menu (Administration) (258.13KB) (2.42ms)
  • beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (49μs)
  • afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (1.66ms)
  • beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (25μs)
  • afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (978μs)
  • beforeRenderRawModule mod_finder (Search Box) (960B) (32μs)
  • afterRenderRawModule mod_finder (Search Box) (467.79KB) (4.37ms)
  • beforeRenderRawModule mod_custom (Top Login) (464B) (21μs)
  • afterRenderRawModule mod_custom (Top Login) (1000B) (126μs)
  • beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (43μs)
  • afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (921μs)
  • beforeRenderRawModule mod_custom (ATRS Copyright Info) (1.13KB) (20μs)
  • afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (119μs)
  • beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (258μs)
  • afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (125μs)
  • beforeRenderModule mod_custom (ATRS Copyright Info) (2.98KB) (17μs)
  • afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (98μs)
  • beforeRenderModule mod_menu (Administration) (2.21KB) (61μs)
  • afterRenderModule mod_menu (Administration) (4.02KB) (85μs)
  • beforeRenderModule mod_finder (Search Box) (2.42KB) (29μs)
  • afterRenderModule mod_finder (Search Box) (5.77KB) (80μs)
  • beforeRenderModule mod_custom (Top Login) (1.4KB) (15μs)
  • afterRenderModule mod_custom (Top Login) (3.02KB) (74μs)
  • beforeRenderModule mod_custom (Top Login-mobile) (800B) (29μs)
  • afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (76μs)
  • beforeRenderModule mod_menu (atrsmenu) (808B) (17μs)
  • afterRenderModule mod_menu (atrsmenu) (3.05KB) (51μs)
  • afterRender (1.26MB) (8.3ms)
  • 1 x afterInitialise (6.65MB) (33.21%)
    54.76ms
    1 x afterLoad (4.44MB) (24.35%)
    40.16ms
    1 x afterRenderComponent com_content (2.65MB) (16.23%)
    26.77ms
    1 x afterRender (1.26MB) (5.03%)
    8.30ms
    1 x afterRoute (1.08MB) (4.4%)
    7.26ms
    1 x beforeRenderComponent com_content (834.39KB) (3.29%)
    5.43ms
    1 x beforeRenderRawModule mod_menu (Administration) (658.1KB) (2.98%)
    4.91ms
    1 x afterRenderRawModule mod_finder (Search Box) (467.79KB) (2.65%)
    4.37ms
    1 x afterRenderRawModule mod_menu (Administration) (258.13KB) (1.47%)
    2.42ms
    1 x Before Access::preloadComponents (all components) (459.81KB) (1.33%)
    2.20ms
    1 x afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (1%)
    1.66ms
    1 x After Access::preloadPermissions (com_content) (457.36KB) (0.73%)
    1.21ms
    1 x afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (0.59%)
    978μs
    1 x afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (0.56%)
    921μs
    1 x After Access::preloadComponents (all components) (123.09KB) (0.42%)
    696μs
    1 x beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (0.16%)
    258μs
    1 x After Access::getAssetRules (id:1149 name:com_content.article.836) (27.27KB) (0.13%)
    215μs
    1 x afterRenderRawModule mod_custom (Top Login) (1000B) (0.08%)
    126μs
    1 x afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (0.08%)
    125μs
    1 x afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (0.07%)
    119μs
    1 x afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (0.06%)
    98μs
    1 x afterRenderModule mod_menu (Administration) (4.02KB) (0.05%)
    85μs
    1 x afterRenderModule mod_finder (Search Box) (5.77KB) (0.05%)
    80μs
    1 x afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (0.05%)
    76μs
    1 x afterRenderModule mod_custom (Top Login) (3.02KB) (0.04%)
    74μs
    1 x afterDispatch (2.25KB) (0.04%)
    71μs
    1 x beforeRenderModule mod_menu (Administration) (2.21KB) (0.04%)
    61μs
    1 x afterRenderModule mod_menu (atrsmenu) (3.05KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (0.03%)
    49μs
    1 x beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (0.03%)
    43μs
    1 x beforeRenderRawModule mod_finder (Search Box) (960B) (0.02%)
    32μs
    1 x beforeRenderModule mod_finder (Search Box) (2.42KB) (0.02%)
    29μs
    1 x beforeRenderModule mod_custom (Top Login-mobile) (800B) (0.02%)
    29μs
    1 x Before Access::getAssetRules (id:1149 name:com_content.article.836) (35.17KB) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (0.02%)
    25μ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 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
    1 x Before Access::preloadPermissions (com_content) (4.84KB) (0.01%)
    13μs
33 statements were executed, 3 of which were duplicates, 30 unique32.77ms449.57KB
  • SELECT @@SESSION.sql_mode;88μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `lv09n_session` WHERE `session_id` = ?174μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = :session_id LIMIT 1129μ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)12.17ms944BParams/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` = 1324μs21.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lv09n_viewlevels`128μ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` = :guest223μ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`598μs16.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`737μ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`379μs13.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lv09n_content` WHERE `alias` = :alias AND `catid` = :catid193μs1.66KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `lv09n_languages` WHERE `published` = 1 ORDER BY `ordering` ASC148μ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` = 1218μ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)421μ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` = 0622μs109.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lv09n_content`376μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `lv09n_content` SET `hits` = (`hits` + 1) WHERE `id` = '836'7.97ms2.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)308μ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`350μ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)224μ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`341μ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 ASC633μs6.58KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `lv09n_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid151μ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`315μ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`596μ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 ASC563μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `lv09n_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1282μ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)194μ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` = 1148μs1.71KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SHOW TABLES444μs5.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM lv09n_acymailing_config190μs12.88KB/administrator/components/com_acymailing/compat/joomla.php:629Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = ?125μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `lv09n_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.01ms11.89KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy