With the passage of House Bill 2279 by the 2022 Kansas Legislature there is a lot of confusion about this new law regarding Advanced Practice Registered Nurses (APRNs). To address the most common questions we receive, we have started this Frequently Asked Questions resource at www.kmsonline.org/APRN. It will be a living document as circumstances develop.

— Last updated Sept. 17, 2022

Q1: When does the new law take effect, and what is the status of the regulations that implement the changes in the law?

A: The new law took effect July 1, 2022, and the Board of Nursing has now approved the permanent regulations which implement the new law.  Effective immediately, those regulations eliminate the legal requirement for written prescribing protocols and collaborative practice agreements (CPAs) for APRNs.

In addition, while the Board of Nursing has testified that their new regulations made no change to APRN scope of practice, KMS and others have expressed concern that some of the new regulations exceed what was authorized by the new law, and allow an APRN to practice medicine. For example, one of the new regulations reads as follows: Each APRN shall be authorized to make independent decisions about advanced practice nursing needs of families, patients, and clients and medical decisions (emphasis added).”  Another regulation allowed APRNs to “develop and manage the medical plan of care for patients… (emphasis added). KMS opposed these regulations and the others like it and urged the Board of Nursing to amend the regulations to eliminate the references to “medical”.  The Board did not make any changes to their proposed regulations, and they took effect as promulgated.

Q2:  Can an ARPN now practice independently and, if so, are there any limitations on what they can do?

A: APRNs have always been able to practice advanced practice nursing independently, but without a physician-authorized prescribing protocol or a collaborative practice agreement, their ability to practice independent of physician supervision or delegation was somewhat limited in scope. The recent changes in the law and regulations did eliminate the requirement that APRNs have a physician-authorized prescribing protocol, as well as collaborative practice agreements.  APRNs are now able to prescribe drugs (including controlled substances) and durable medical equipment (DME) in their practice without having to obtain a written protocol with a physician. The only limitation on prescribing is that APRNs cannot prescribe any drug intended to cause an abortion. The recent legislation only explicitly authorized the prescribing of drugs and DME, and did not authorize APRNs to perform any other services that constitute the practice of medicine and surgery that are not legally delegated or ordered by a physician. As noted above (Q1) there is concern that the Board of Nursing implemented regulations that go beyond what was authorized by the recent changes in law. This point is likely not going to be resolved satisfactorily until the legislature or the courts provide some clarification.

Q3: Can I still require a CPA or other employment agreement for APRNs in my practice?

A:  The new law and regulations do not prohibit collaborative practice agreements, prescribing protocols, or any other formal practice agreements. It only eliminated the requirement of a prescribing protocol and CPA. Even though the new regulations eliminate the legal requirement for CPAs, there is nothing in the law that would prevent an APRN from entering into a collaborative practice or other practice agreement with a physician, a physician clinic, hospital, or other health care facility. Parties have a right to enter into such contractual arrangements with anyone they employ or contract with, including an APRN. That employment arrangement can utilize a collaborative practice agreement; employment agreement or other practice agreements; written protocols or other formal policies that set out the clinical limitations, scope of practice, terms and conditions of the APRN’s employment, or contractual relationship with the practice or facility.

Q4: Under the new law, can a physician still supervise or delegate authority to an APRN? How does the new law affect physician-APRN relationships in hospitals or other health care facilities?

A: Consistent with current practice, a physician may still provide direction, supervision, or delegation of authority to perform acts that constitute the practice of medicine and surgery to an APRN, such as ordering tests, imaging, procedures, or other health care services. All clinical facilities — including physician clinics, hospitals, or other health care facilities — should consider reviewing and establishing clinical policies that identify those services that will continue to require physician direction, supervision, or delegation of authority to an APRN, and those services that the APRN can provide independently, consistent with the facility’s responsibilities to its patients (see Q5 below). 

Q5: Does the legislation allow APRNs to diagnose, treat, and prescribe without any physician direction or oversight?

A. Prior to passage of HB 2279, Kansas law required physician involvement in the form of a prescribing protocol and collaborative practice agreement (CPA) in order for an APRN to diagnose, treat, or prescribe. The only change specifically authorized by HB 2279 was limited to the requirement that in order to prescribe drugs an APRN must enter into a written prescribing protocol with a physician. That requirement was the only element which was specifically eliminated by the bill. The legislation was silent on the broader issue of collaborative practice agreements, but the Board of Nursing also eliminated them as a mandatory requirement with the regulatory changes it adopted.

The legislation also amended a key provision of the nurse practice act which relates to APRN practice. In the section directing the Kansas State Board of Nursing to adopt regulations relating to APRN practice (K.S.A. 65-1130, subsection (c)), the legislature made it clear that the regulations must be consistent with the nurse practice act. The nurse practice act at K.S.A. 65-1113 subsection (b) defines “diagnosis” in the context of nursing practice means “that identification of and discrimination between physical and psychosocial signs and symptoms essential to effective execution and management of the nursing regimen and shall be construed as distinct from a medical diagnosis”.  Additionally, the nurse practice act defines “treatment” as “the selection and performance of those therapeutic measures essential to effective execution and management of the nursing regimen, and any prescribed medical regimen [emphasis added].  

In other words, the nurse practice act still clearly distinguishes between the practice of nursing and the practice of medicine, and — with the exception of prescribing drugs and durable medical equipment by APRNs — nothing in HB 2279 changes that distinction. For example, while the new law authorized APRNs to prescribe drugs and DME, it was silent on whether APRNs could order or perform laboratory or imaging services, invasive tests or procedures, or perform surgery.  Until either the courts or the legislature provides more clarity on the limits of APRN scope of practice, it may be prudent for clinics, hospitals, or other facilities that currently require APRNs to have a CPA or other employment agreement that sets forth practice parameters and/or limits to wait to make changes until the potential liability and other practice issues are sorted out more conclusively.

Q6. Am I still liable for the actions of the APRNs that I employ in my practice?

A. Notwithstanding the new law and regulations, if you employ or contract with, or supervise or sign off on the care provided by an APRN in any clinical site, you are most likely going to be at least partially if not wholly responsible for the care they provide to patients pursuant to the supervision or delegation you provide, unless there are mitigating circumstances, which would be very fact-dependent on the clinical situation, the supervisory documents in effect, reporting relationships, etc.

Q7. Do my employed APRNs have to have their own medical malpractice insurance policy, or can I continue to cover them in my corporation’s policy?

A. You will have a choice, just as you do currently. Some practices obtain individual medical malpractice policies for their employed APRNs, while others cover the APRNs in the corporation’s overall liability policy as an “additional insured.” There is no right or wrong answer to this question, it is just a business decision that has cost considerations, as well as practice considerations.  In any case, as an employer you would likely want to have written policies about whether your clinical employees can work or “moonlight” outside of your practice, which will also have liability insurance implications and perhaps cost considerations.

Q8. What malpractice policy limits do the new law require for APRNs to carry?

A. The new law does not specify how much malpractice coverage an APRN must obtain. The law only says that the APRN “shall maintain malpractice insurance coverage as a condition of rendering professional clinical services.” The APRN must provide proof of coverage at initial licensure and each renewal thereafter. All physicians must carry a minimum of $1 million coverage, but no such limit is required for APRNs, with the exception of nurse midwives and nurse anesthetists, who are required to participate in the Health Care Stabilization Fund.  If your practice employs APRNs you should consult with your insurance provider about what makes sense for your particular situation. In all probability, they are likely to recommend that you also provide similar insurance limits for APRNs that you choose to provide an individual policy for.

Q9: Are APRNs required to be covered by the Health Care Stabilization Fund (HCSF)?

A. Of the four categories of APRN (nurse practitioner, nurse anesthetist, nurse midwife, and clinical nurse specialist) only nurse anesthetists and nurse midwives are required to be covered by the HCSF. Nurse practitioners and clinical nurse specialists may not be covered by the HCSF, as they are not included in the list of “defined healthcare providers” that are required by law to be covered by the HCSF.

logo kms

KaMMCO 2018

logo khc

logo khin

20.154MBMemory Usage216msRequest Duration
Joomla! Version4.4.11
PHP Version8.1.31
Identityguest
Response200
Templatecassiopeia_umbrella
Database
Server
mysql
Version
10.2.44-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "0cc5c1c75aec4939404b8a433ddce789" => "c1c8fa758c1dd63bae1f05690fc47595" ]
$_SERVER
array:60 [ "USER" => "kmsonline" "HOME" => "/home/kmsonline" "SCRIPT_NAME" => "/index.php" "...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1741857298 "last" => 1741857298...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.88MB) (32.49ms)
  • afterInitialise (9.18MB) (87.8ms)
  • afterRoute (834.2KB) (8.75ms)
  • beforeRenderComponent com_content (417.46KB) (4.01ms)
  • Before Access::preloadComponents (all components) (560.81KB) (5.77ms)
  • After Access::preloadComponents (all components) (124.46KB) (1.67ms)
  • Before Access::preloadPermissions (com_content) (4.07KB) (35μs)
  • After Access::preloadPermissions (com_content) (845.8KB) (3.54ms)
  • Before Access::getAssetRules (id:2468 name:com_content.article.3259) (66.8KB) (66μs)
  • After Access::getAssetRules (id:2468 name:com_content.article.3259) (91.41KB) (356μs)
  • afterRenderComponent com_content (2.99MB) (46.18ms)
  • afterDispatch (22.84KB) (807μs)
  • beforeRenderRawModule mod_head_css_script (Head CSS, Script) (304.07KB) (4.68ms)
  • afterRenderRawModule mod_head_css_script (Head CSS, Script) (102.17KB) (997μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.45KB) (44μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (50.48KB) (1.54ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (31.51KB) (1.5ms)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.73KB) (206μs)
  • beforeRenderModule mod_head_css_script (Head CSS, Script) (1.41KB) (202μs)
  • afterRenderModule mod_head_css_script (Head CSS, Script) (1.84KB) (130μs)
  • afterRender (486.16KB) (14.48ms)
  • 1 x afterInitialise (9.18MB) (40.66%)
    87.80ms
    1 x afterRenderComponent com_content (2.99MB) (21.39%)
    46.18ms
    1 x afterLoad (3.88MB) (15.05%)
    32.49ms
    1 x afterRender (486.16KB) (6.71%)
    14.48ms
    1 x afterRoute (834.2KB) (4.05%)
    8.75ms
    1 x Before Access::preloadComponents (all components) (560.81KB) (2.67%)
    5.77ms
    1 x beforeRenderRawModule mod_head_css_script (Head CSS, Script) (304.07KB) (2.17%)
    4.68ms
    1 x beforeRenderComponent com_content (417.46KB) (1.86%)
    4.01ms
    1 x After Access::preloadPermissions (com_content) (845.8KB) (1.64%)
    3.54ms
    1 x After Access::preloadComponents (all components) (124.46KB) (0.77%)
    1.67ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (50.48KB) (0.71%)
    1.54ms
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (31.51KB) (0.7%)
    1.50ms
    1 x afterRenderRawModule mod_head_css_script (Head CSS, Script) (102.17KB) (0.46%)
    997μs
    1 x afterDispatch (22.84KB) (0.37%)
    807μs
    1 x After Access::getAssetRules (id:2468 name:com_content.article.3259) (91.41KB) (0.16%)
    356μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.73KB) (0.1%)
    206μs
    1 x beforeRenderModule mod_head_css_script (Head CSS, Script) (1.41KB) (0.09%)
    202μs
    1 x afterRenderModule mod_head_css_script (Head CSS, Script) (1.84KB) (0.06%)
    130μs
    1 x Before Access::getAssetRules (id:2468 name:com_content.article.3259) (66.8KB) (0.03%)
    66μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.45KB) (0.02%)
    44μs
    1 x Before Access::preloadPermissions (com_content) (4.07KB) (0.02%)
    35μs
33 statements were executed, 5 of which were duplicates, 28 unique18.55ms181.16KB
  • SELECT @@SESSION.sql_mode;98μs1.57KB/libraries/src/Session/MetadataManager.php:184Copy
  • SELECT `session_id` FROM `yxyug_session` WHERE `session_id` = :session_id LIMIT 1258μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `yxyug_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id209μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `yxyug_viewlevels`171μs928B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `yxyug_usergroups` AS `a` LEFT JOIN `yxyug_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest266μs2.27KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `yxyug_admintools_storage` WHERE `key` = 'cparams'294μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `yxyug_admintools_wafexceptions`153μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `yxyug_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'334μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `yxyug_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'298μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `yxyug_admintools_ipautoban`165μs960B/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `yxyug_admintools_ipblock`119μs840B/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `yxyug_admintools_storage` WHERE `key` LIKE 'timestamp_%'184μs912B/plugins/system/admintools/src/Feature/Base.php:253Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `yxyug_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC205μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • 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 `yxyug_categories` AS `s` INNER JOIN `yxyug_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`647μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `yxyug_admintools_wafblacklists` WHERE `enabled` = 1176μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `yxyug_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)936μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `yxyug_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.76ms72.3KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `yxyug_content`733μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `yxyug_content` SET `hits` = (`hits` + 1) WHERE `id` = '3259'733μ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 `yxyug_content` AS `a` INNER JOIN `yxyug_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `yxyug_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `yxyug_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `yxyug_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `yxyug_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)576μs24.63KBParams/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 `yxyug_categories` AS `s` INNER JOIN `yxyug_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`689μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `yxyug_contentitem_tag_map` AS `m` INNER JOIN `yxyug_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)468μs5.22KBParams/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 `yxyug_categories` AS `s` INNER JOIN `yxyug_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.5ms5.22KBParams/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 yxyug_fields AS a LEFT JOIN `yxyug_languages` AS l ON l.lang_code = a.language LEFT JOIN yxyug_users AS uc ON uc.id=a.checked_out LEFT JOIN yxyug_viewlevels AS ag ON ag.id = a.access LEFT JOIN yxyug_users AS ua ON ua.id = a.created_user_id LEFT JOIN yxyug_fields_groups AS g ON g.id = a.group_id LEFT JOIN `yxyug_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC2.39ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `yxyug_categories` AS `s` INNER JOIN `yxyug_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.43ms5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM yxyug_jmap_metainfo WHERE `linkurl` = 'https://kms.umbrellahost.net/resources/practice-operations/3259-aprn-faq-2022' AND `published` = 1455μs1.2KB/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM yxyug_jmap_canonicals WHERE `linkurl` = 'https://kms.umbrellahost.net/resources/practice-operations/3259-aprn-faq-2022'276μs960B/plugins/system/jmap/jmap.php:940Copy
  • 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 `yxyug_scheduler_tasks` AS `a` WHERE `a`.`state` = 1464μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `value` FROM `yxyug_admintools_storage` WHERE `key` = 'criticalfiles'364μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM yxyug_jmap_headings WHERE `linkurl` = 'https://kms.umbrellahost.net/resources/practice-operations/3259-aprn-faq-2022'287μs1.05KB/plugins/system/jmap/jmap.php:1155Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `yxyug_jmap_text_replacements` WHERE `published` = 1280μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `alias` FROM `yxyug_content` WHERE `id` = :id281μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `yxyug_categories` AS `s` INNER JOIN `yxyug_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.36ms16.38KBParams/libraries/src/Categories/Categories.php:375Copy