T-DROP is the Teacher Deferred Retirement Option Plan found at ACA § 24-7-1301 et. seq. If a member elects to participate in T-DROP, the retirement annuity benefits are frozen and any subsequent benefits in the ATRS plan will accrue in the T-DROP account. T-DROP benefits, a portion of the retirement annuity benefits for which the member is eligible, are deposited monthly in the member's T-DROP account. T-DROP accounts accrue interest on June 30 each year at 3% compounded annually.  The ATRS Board of Trustees retains the right to provide an increased incentive interest rate during years of outstanding investment returns. Upon retirement, T-DROP benefits may be annuitized with the regular retirement annuity, distributed as a lump sum payment (check, CBA, other qualified administrator) or a combined distribution of annuity and lump sum payment. A lump sum payment of a member's T-DROP account is taxable to the recipient but is eligible for rollover treatment from the IRS as a single distribution.

In order to participate in T-DROP, you must be an active member in ATRS or a reciprocal plan and you must have 30 (thirty) years of credited service for full participation, which can include service credit with an Arkansas reciprocal plan (credited service years can be contributory, noncontributory, or any combination of both). However, for those members with 28 years of service credit but less than 30 years of service credit, ATRS allows early participation in T-DROP with a reduction for early entry.

T-DROP participation begins on the first day of the fiscal year, July 1. The T-DROP application must be submitted no earlier than March 1 and no later than May 31 to be eligible to participate by July 1. An application for T-DROP received by ATRS after May 31 cannot become effective until July 1 of the following fiscal year.

Example:  To begin T-DROP on July 1, 2020, ATRS must have the completed T-DROP application on or before May 31, 2020. A T-DROP application received after May 31, 2020, would not become effective until July 1, 2021.

PLEASE NOTE: T-DROP is intended to operate in accordance with Section 415 and other applicable sections of the United States Internal Revenue Code. Any provisions of T-DROP found to be in conflict with any applicable provisions of the IRS Code will be declared invalid.


Benefits of T-DROP:

The intent of T-DROP is to recruit, retain, and reward quality educators in Arkansas schools. T-DROP incentivizes members with 28-30 years of service credit to continue to work in the public schools by allowing the member to build a savings account for when they are ready to leave the workforce. See below for an example of estimated T-DROP accrual based on the current rates.

Final Average Salary Contributory Years NonContributory Years Balance After 5 Years Balance After 10 Years
$30,000.00 0 28 $42,238.88 $97,192.39
$30,000.00 28 0 $65,333.68   $150,333.92
$30,000.00 30 0 $77,336.55   $177,954.06
         
$60,000.00 0 28 $84,477.74   $194,385.17
$60,000.00 28 0   $130,667.08   $300,667.61
$60,000.00 30 0   $154,672.08   $355,903.73
         
$100,000.00 0 28   $140,796.28   $323,975.12
$100,000.00 28 0   $217,778.49   $501,112.68
$100,000.00 30 0   $257,786.90   $593,172.90

 

The above examples are based on a fixed annual interest rate of 3% on the mean balance.  Cost-of-Living Adjustments (COLAS) are 3% and are based on the retirement benefit computed at the time of entry into T-DROP. 

 

How does T-DROP work:

T-DROP is an optional "retirement" plan for ATRS members. Members elect to participate in T-DROP in lieu of retiring and accepting a service retirement benefit.

Once you have elected and been approved to participate in T-DROP, the System processes your account as if you have retired. In other words, ATRS will review your years of service credit, (contributory – noncontributory), final average salary (based on five highest salaries), and use current multipliers to calculate your monthly benefit. This also means that, although you will continue to work with an ATRS employer, you will not accrue any additional service credit nor will any increase in salary be considered when you elect to terminate employment with an ATRS employer and truly retire.

If you were contributory prior to T-DROP, you will no longer be making member contributions. Your monthly deposit for T-DROP will be based on what your regular monthly benefit would be as if you had actually retired, reduced by 1% for each year of service credit (contributory or noncontributory). If you enter T-DROP early (with at least 28 years of service credit but less than 30 years of service credit), your monthly deposit is further reduced by an additional reduction of 6% for each year below 30 years of service credit (i.e. 12%, if entering T-DROP with 28 years of service credit, 6% if entering T-DROP with 29 years, or 3% if entering T-DROP with 29.5 years of service credit).

The monthly benefit that you would have received if you had retired, less the reductions explained above, will be deposited each month in your tax-deferred T-DROP account for up to 10 (ten) years. An interest rate of 3% as adopted by the ATRS Board of Trustees will be credited to the balance of your T-DROP account each June 30. In addition, the ATRS Board of Trustees may provide an increased incentive rate during years of outstanding investment returns. The monthly benefit amount upon which the T-DROP monthly deposit is calculated will continue to accrue a Cost of Living Adjustment (COLA) annually. 

As a participant in T-DROP, your T-DROP deposits/account cannot be accessed until you exit T-DROP through retirement, separation/termination of employment with an ATRS covered employer, or death. You may not "take a loan" from your T-DROP account.

PLEASE NOTE: T-DROP members may only participate within the 10 consecutive calendar years that follow the beginning entry date into T-DROP.


T-DROP Participation:

A member may only accrue deposits in their T-DROP account for ten (10) consecutive years after their entry date into T-DROP. However, a T-DROP participant may retire at any time during the ten (10) year period. Likewise, a T-DROP participant may continue to work after completing the ten (10) year plan and continue to accrue interest on their account (see Post T-DROP).


T-DROP participants may change jobs as long as you continue working for an ATRS covered employer or the reciprocal employer for a retirement system in which reciprocal service was established before T-DROP was entered. However, if a break in service occurs (see below) between jobs, you will not receive deposits for the month(s) you were not employed by the ATRS covered employer or reciprocal employer as explained above.

If any of the following occurs, the monthly deposits stop:

  • The T-DROP participant separates/terminates from employment with an ATRS covered employer
  • The T-DROP participant dies

Additionally, in order to acquire uninterrupted monthly deposits as a participant in T-DROP, the member must receive a minimum of the following service credit during the fiscal year from their qualified employer:     

  • 15 (fifteen) service days in the first fiscal quarter (July, August, September)
  • 25 (twenty-five) days of service in the second fiscal quarter (October, November, December)
  • 25 (twenty-five) days of service in the third quarter (January, February, March)
  • 15 (fifteen) service days in the fourth quarter (April, May, June). 

As long as you work these minimum amounts for a qualified employer, then you will continue to receive monthly deposits.

 

Post T-DROP

If you wish to continue working for an ATRS employer and do not retire after completing ten (10) years in T-DROP, ATRS will pay annual interest on the T-DROP balance each June 30. The ATRS Board of Trustees sets the 10-year plus interest rate each fiscal year for the following year. The interest rate varies from a minimum of 4% to a maximum of 6%.


Retirement Out of T-DROP

As a T-DROP participant, you have already "technically" met the retirement eligibility requirements. However, you will need to submit a retirement application, all required documents, and determine your T-DROP distribution. You must adhere to the ATRS Termination Separation Period Policy if you retire prior to age 65.

 

Points to Consider

A member's retirement benefit is based on years of service credit, final average salary (5 highest salaries), and the benefit multipliers in effect at the time of entry into T-DROP. Like all decisions concerning retirement, the decision to participate in T-DROP should be made very carefully. Upon entry in T-DROP, ATRS allows a short two (2) month grace period to withdraw your T-DROP application. After the two (2) month grace period, T-DROP is irrevocable. As stated earlier, your election to enter T-DROP freezes your retirement benefit, subject only to COLA increases. Therefore, additional time you work will not accrue added service credit nor will any salary increase be considered toward your retirement benefit when you retire, since your final average salary freezes when you enter T-DROP.


An "early" entry (you plan to work well past the maximum *10 years of T-DROP) into T-DROP may not optimize years of service credit. Members should target T-DROP entry to match your mostly likely retirement date.  Monthly deposits in the T-DROP account cease after ten (10) years of participation.  However, ATRS does pay interest on T-DROP account balances after completion of the ten (10) years participation period. Large salary increases after T-DROP entry does not increase retirement benefits, since entry into T-DROP freezes final average salary for retirement.


For more information Contact ATRS at (501) 682-1517 or info@artrs.gov for more information regarding T-DROP, or see the T-DROP FAQs

 

20.038MBMemory Usage172msRequest 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-ARExAK9wHX65ZWZIJs8wAAABQ" "REDIRECT_HTTP_AUTHORIZATION" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743786259 "last" => 1743786259...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.44MB) (39.49ms)
  • afterInitialise (6.65MB) (63.96ms)
  • afterRoute (409.78KB) (3.94ms)
  • beforeRenderComponent com_content (1.01MB) (8.04ms)
  • Before Access::preloadComponents (all components) (627.3KB) (3.76ms)
  • After Access::preloadComponents (all components) (123.09KB) (759μs)
  • Before Access::preloadPermissions (com_content) (4.84KB) (14μs)
  • After Access::preloadPermissions (com_content) (456.38KB) (1.36ms)
  • Before Access::getAssetRules (id:480 name:com_content.article.440) (35.17KB) (27μs)
  • After Access::getAssetRules (id:480 name:com_content.article.440) (27.27KB) (221μs)
  • afterRenderComponent com_content (2.95MB) (22.83ms)
  • afterDispatch (2.25KB) (95μs)
  • beforeRenderRawModule mod_menu (Member Topics) (665.72KB) (4.58ms)
  • afterRenderRawModule mod_menu (Member Topics) (292.94KB) (2.39ms)
  • beforeRenderRawModule mod_custom (Top Login-mobile) (760B) (46μs)
  • afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (1.67ms)
  • beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (27μs)
  • afterRenderRawModule mod_menu (atrsmenu) (50.66KB) (968μs)
  • beforeRenderRawModule mod_finder (Search Box) (960B) (29μs)
  • afterRenderRawModule mod_finder (Search Box) (467.79KB) (4.6ms)
  • beforeRenderRawModule mod_custom (Top Login) (464B) (22μs)
  • afterRenderRawModule mod_custom (Top Login) (1000B) (137μs)
  • beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (44μs)
  • afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (944μs)
  • beforeRenderRawModule mod_custom (ATRS Copyright Info) (1.13KB) (20μs)
  • afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (148μs)
  • beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (263μs)
  • afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (183μs)
  • beforeRenderModule mod_custom (ATRS Copyright Info) (2.98KB) (20μs)
  • afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (128μs)
  • beforeRenderModule mod_menu (Member Topics) (2.2KB) (68μs)
  • afterRenderModule mod_menu (Member Topics) (4.27KB) (111μs)
  • beforeRenderModule mod_finder (Search Box) (2.41KB) (32μs)
  • afterRenderModule mod_finder (Search Box) (5.77KB) (91μs)
  • beforeRenderModule mod_custom (Top Login) (1.4KB) (17μs)
  • afterRenderModule mod_custom (Top Login) (3.02KB) (87μs)
  • beforeRenderModule mod_custom (Top Login-mobile) (800B) (32μs)
  • afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (99μs)
  • beforeRenderModule mod_menu (atrsmenu) (808B) (18μs)
  • afterRenderModule mod_menu (atrsmenu) (3.05KB) (58μs)
  • afterRender (1.27MB) (8.99ms)
  • 1 x afterInitialise (6.65MB) (37.28%)
    63.96ms
    1 x afterLoad (4.44MB) (23.02%)
    39.49ms
    1 x afterRenderComponent com_content (2.95MB) (13.31%)
    22.83ms
    1 x afterRender (1.27MB) (5.24%)
    8.99ms
    1 x beforeRenderComponent com_content (1.01MB) (4.69%)
    8.04ms
    1 x afterRenderRawModule mod_finder (Search Box) (467.79KB) (2.68%)
    4.60ms
    1 x beforeRenderRawModule mod_menu (Member Topics) (665.72KB) (2.67%)
    4.58ms
    1 x afterRoute (409.78KB) (2.3%)
    3.94ms
    1 x Before Access::preloadComponents (all components) (627.3KB) (2.19%)
    3.76ms
    1 x afterRenderRawModule mod_menu (Member Topics) (292.94KB) (1.39%)
    2.39ms
    1 x afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (0.97%)
    1.67ms
    1 x After Access::preloadPermissions (com_content) (456.38KB) (0.79%)
    1.36ms
    1 x afterRenderRawModule mod_menu (atrsmenu) (50.66KB) (0.56%)
    968μs
    1 x afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (0.55%)
    944μs
    1 x After Access::preloadComponents (all components) (123.09KB) (0.44%)
    759μs
    1 x beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (0.15%)
    263μs
    1 x After Access::getAssetRules (id:480 name:com_content.article.440) (27.27KB) (0.13%)
    221μs
    1 x afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (0.11%)
    183μs
    1 x afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (0.09%)
    148μs
    1 x afterRenderRawModule mod_custom (Top Login) (1000B) (0.08%)
    137μs
    1 x afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (0.07%)
    128μs
    1 x afterRenderModule mod_menu (Member Topics) (4.27KB) (0.06%)
    111μs
    1 x afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (0.06%)
    99μs
    1 x afterDispatch (2.25KB) (0.06%)
    95μs
    1 x afterRenderModule mod_finder (Search Box) (5.77KB) (0.05%)
    91μs
    1 x afterRenderModule mod_custom (Top Login) (3.02KB) (0.05%)
    87μs
    1 x beforeRenderModule mod_menu (Member Topics) (2.2KB) (0.04%)
    68μs
    1 x afterRenderModule mod_menu (atrsmenu) (3.05KB) (0.03%)
    58μs
    1 x beforeRenderRawModule mod_custom (Top Login-mobile) (760B) (0.03%)
    46μs
    1 x beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (0.03%)
    44μs
    1 x beforeRenderModule mod_finder (Search Box) (2.41KB) (0.02%)
    32μs
    1 x beforeRenderModule mod_custom (Top Login-mobile) (800B) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_finder (Search Box) (960B) (0.02%)
    29μs
    1 x Before Access::getAssetRules (id:480 name:com_content.article.440) (35.17KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_custom (Top Login) (464B) (0.01%)
    22μ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%)
    20μs
    1 x beforeRenderModule mod_menu (atrsmenu) (808B) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (Top Login) (1.4KB) (0.01%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (4.84KB) (0.01%)
    14μs
30 statements were executed, 2 of which were duplicates, 28 unique14ms439.8KB
  • SELECT @@SESSION.sql_mode;95μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `lv09n_session` WHERE `session_id` = ?195μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = :session_id LIMIT 1114μ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.38ms944BParams/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` = 1304μs21.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lv09n_viewlevels`323μ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` = :guest387μ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.16ms16.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`1.14ms143.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `lv09n_languages` WHERE `published` = 1 ORDER BY `ordering` ASC215μ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` = 1257μ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)448μ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` = 0708μs109.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lv09n_content`481μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `lv09n_content` SET `hits` = (`hits` + 1) WHERE `id` = '440'910μs48B/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)370μs49.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`427μs8.56KBParams/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)275μ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`332μ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 ASC723μ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` = :itemid171μs1.69KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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`585μs5.53KBParams/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 ASC615μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `lv09n_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1314μ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)190μ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` = 1175μs1.71KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SHOW TABLES447μs5.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM lv09n_acymailing_config209μ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` = ?926μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy