The 1099R tax forms are now available in your Member Portal and are in the process of being mailed.

To access your 1099 in the Member Portal, please follow the steps below:

1. Log in to your existing account or register at www.artrs.gov/registration

2. After logging in, click on the Member Portal icon

3. Click the Tax Forms icon

4. Click the View 1099 icon

Below are some frequently asked questions regarding your 1099R tax forms.  If you have additional questions, please feel free to contact us.

Who receives a Form 1099?

Any payee who receives taxable income from our system will receive a 1099.  This includes all monthly benefit recipients, members who have received a refund of contributions, or a Cash and Savings Help Program lump sum payment.  Members who have received a distribution from their T-DROP accounts including distributions from their Cash Balance Account (CBA) will also receive a 1099.

When are 1099s mailed?

The 1099s are mailed near the end of January.

What is the amount in Box 5?

If you have an amount in Box 5, this is the non-taxable portion of your retirement income.  Prior to 1997, member contributions were taken out of an active member’s check after tax.  Therefore, the taxes have already been paid on a certain amount of your contribution.  Upon retirement, ATRS used the IRS Simplified Method to determine the amount that should be excluded annually for tax purposes. This is the difference between Box 1 (Gross Amount) and Box 2 (Taxable Amount). This is does not include insurance premiums.

Why have I not received my 1099?

If you have not received your 1099, it is most likely a result of an incorrect address.  If you need to update your address, you may now update your address in your Member Portal or you may contact our office and request a Change of Address Form.  Once we receive the Change of Address Form and your address is updated, we can re-send your 1099.

Can I receive a duplicate 1099?

Yes.  You may contact our office after FEBRUARY 14, 2025 to request a duplicate 1099.

If you are receiving a monthly retirement benefit, you may print a copy of your 1099R from your Member Portal.  To view the 1099 in your Member Portal, you will first need to register at www.artrs.gov/registration.

Where do I find the amount paid for health insurance?

If ATRS deducts your health insurance premiums from your monthly benefit, the year to date amount paid for health insurance will be listed on your December Direct Deposit Detail you received in the mail near the end of December.  This information is not provided on the 1099.

19.98MBMemory Usage160msRequest 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@-Jn7OJdhvDw25V5mpVGwAAADo" "REDIRECT_HTTP_AUTHORIZATION" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743767967 "last" => 1743767967...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.44MB) (22.54ms)
  • afterInitialise (6.65MB) (39.97ms)
  • afterRoute (1.08MB) (9.07ms)
  • beforeRenderComponent com_content (834.47KB) (12.91ms)
  • Before Access::preloadComponents (all components) (459.82KB) (5.45ms)
  • After Access::preloadComponents (all components) (123.09KB) (1.62ms)
  • Before Access::preloadPermissions (com_content) (4.84KB) (33μs)
  • After Access::preloadPermissions (com_content) (456.38KB) (2.3ms)
  • Before Access::getAssetRules (id:1597 name:com_content.article.1186) (35.17KB) (39μs)
  • After Access::getAssetRules (id:1597 name:com_content.article.1186) (27.27KB) (266μs)
  • afterRenderComponent com_content (2.63MB) (40.85ms)
  • afterDispatch (2.25KB) (97μs)
  • beforeRenderRawModule mod_menu (Administration) (656.77KB) (4.63ms)
  • afterRenderRawModule mod_menu (Administration) (258.09KB) (2.24ms)
  • beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (44μs)
  • afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (1.53ms)
  • beforeRenderRawModule mod_menu (atrsmenu) (2.66KB) (25μs)
  • afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (946μs)
  • beforeRenderRawModule mod_finder (Search Box) (960B) (40μs)
  • afterRenderRawModule mod_finder (Search Box) (467.79KB) (4.57ms)
  • beforeRenderRawModule mod_custom (Top Login) (464B) (21μs)
  • afterRenderRawModule mod_custom (Top Login) (1000B) (143μs)
  • beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (45μs)
  • afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (929μs)
  • beforeRenderRawModule mod_custom (ATRS Copyright Info) (1.13KB) (21μs)
  • afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (121μs)
  • beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (237μ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) (99μs)
  • beforeRenderModule mod_menu (Administration) (2.21KB) (60μs)
  • afterRenderModule mod_menu (Administration) (4.02KB) (86μs)
  • beforeRenderModule mod_finder (Search Box) (2.42KB) (44μs)
  • afterRenderModule mod_finder (Search Box) (5.77KB) (85μ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) (29μs)
  • afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (78μs)
  • beforeRenderModule mod_menu (atrsmenu) (808B) (16μs)
  • afterRenderModule mod_menu (atrsmenu) (3.05KB) (53μs)
  • afterRender (1.25MB) (8.17ms)
  • 1 x afterRenderComponent com_content (2.63MB) (25.46%)
    40.85ms
    1 x afterInitialise (6.65MB) (24.91%)
    39.97ms
    1 x afterLoad (4.44MB) (14.05%)
    22.54ms
    1 x beforeRenderComponent com_content (834.47KB) (8.04%)
    12.91ms
    1 x afterRoute (1.08MB) (5.65%)
    9.07ms
    1 x afterRender (1.25MB) (5.09%)
    8.17ms
    1 x Before Access::preloadComponents (all components) (459.82KB) (3.4%)
    5.45ms
    1 x beforeRenderRawModule mod_menu (Administration) (656.77KB) (2.89%)
    4.63ms
    1 x afterRenderRawModule mod_finder (Search Box) (467.79KB) (2.85%)
    4.57ms
    1 x After Access::preloadPermissions (com_content) (456.38KB) (1.43%)
    2.30ms
    1 x afterRenderRawModule mod_menu (Administration) (258.09KB) (1.39%)
    2.24ms
    1 x After Access::preloadComponents (all components) (123.09KB) (1.01%)
    1.62ms
    1 x afterRenderRawModule mod_custom (Top Login-mobile) (51.03KB) (0.95%)
    1.53ms
    1 x afterRenderRawModule mod_menu (atrsmenu) (51.4KB) (0.59%)
    946μs
    1 x afterRenderRawModule mod_menu (ATRS Footer Menu Bar) (58.15KB) (0.58%)
    929μs
    1 x After Access::getAssetRules (id:1597 name:com_content.article.1186) (27.27KB) (0.17%)
    266μs
    1 x beforeRenderModule mod_menu (ATRS Footer Menu Bar) (22.6KB) (0.15%)
    237μs
    1 x afterRenderRawModule mod_custom (Top Login) (1000B) (0.09%)
    143μs
    1 x afterRenderModule mod_menu (ATRS Footer Menu Bar) (4.95KB) (0.08%)
    124μs
    1 x afterRenderRawModule mod_custom (ATRS Copyright Info) (1000B) (0.08%)
    121μs
    1 x afterRenderModule mod_custom (ATRS Copyright Info) (4.39KB) (0.06%)
    99μs
    1 x afterDispatch (2.25KB) (0.06%)
    97μs
    1 x afterRenderModule mod_menu (Administration) (4.02KB) (0.05%)
    86μs
    1 x afterRenderModule mod_finder (Search Box) (5.77KB) (0.05%)
    85μs
    1 x afterRenderModule mod_custom (Top Login-mobile) (3.02KB) (0.05%)
    78μs
    1 x afterRenderModule mod_custom (Top Login) (3.02KB) (0.05%)
    76μs
    1 x beforeRenderModule mod_menu (Administration) (2.21KB) (0.04%)
    60μs
    1 x afterRenderModule mod_menu (atrsmenu) (3.05KB) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_menu (ATRS Footer Menu Bar) (2.58KB) (0.03%)
    45μs
    1 x beforeRenderRawModule mod_custom (Top Login-mobile) (776B) (0.03%)
    44μs
    1 x beforeRenderModule mod_finder (Search Box) (2.42KB) (0.03%)
    44μs
    1 x beforeRenderRawModule mod_finder (Search Box) (960B) (0.02%)
    40μs
    1 x Before Access::getAssetRules (id:1597 name:com_content.article.1186) (35.17KB) (0.02%)
    39μs
    1 x Before Access::preloadPermissions (com_content) (4.84KB) (0.02%)
    33μs
    1 x beforeRenderModule mod_custom (Top Login-mobile) (800B) (0.02%)
    29μ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%)
    21μs
    1 x beforeRenderModule mod_custom (ATRS Copyright Info) (2.98KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_menu (atrsmenu) (808B) (0.01%)
    16μs
    1 x beforeRenderModule mod_custom (Top Login) (1.4KB) (0.01%)
    15μs
33 statements were executed, 3 of which were duplicates, 30 unique20.38ms432.51KB
  • SELECT @@SESSION.sql_mode;88μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `lv09n_session` WHERE `session_id` = ?165μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = :session_id LIMIT 1116μ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)3.1ms944BParams/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` = 1303μs21.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lv09n_viewlevels`115μ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` = :guest162μ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`490μ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`698μ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`981μs13.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lv09n_content` WHERE `alias` = :alias AND `catid` = :catid419μs1.66KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `lv09n_languages` WHERE `published` = 1 ORDER BY `ordering` ASC348μ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` = 1526μ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)939μ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` = 01.32ms109.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lv09n_content`769μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `lv09n_content` SET `hits` = (`hits` + 1) WHERE `id` = '1186'1.23ms2.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)744μs9.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`907μ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)557μ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`737μ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.45ms6.58KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `lv09n_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid264μ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`387μ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`597μ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 ASC550μ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)169μ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` = 1169μs1.71KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SHOW TABLES455μs5.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM lv09n_acymailing_config188μs12.88KB/administrator/components/com_acymailing/compat/joomla.php:629Copy
  • SELECT `session_id` FROM `lv09n_session` WHERE `session_id` = ?123μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `lv09n_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.01ms11.89KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy