The HCV Cost Calculator is based off of an evidenced based model piloted at the Public Health Management Corporation Care Clinic in Philadelphia, PA. Throughout the calculator, “Standard Screening” references current risk based CDC screening guidelines including persons born 1945-1965, persons who previously or currently inject drugs, and other associated risk factors. “Universal Screening” references screening patients 18 years and older, regardless of risk factors. “Enhanced” services are those identified as promising practices in the model, including: Medical Assistant (MA) initiated opt-out universal screening, reflex testing, care coordination for prior authorizations, integrated behavioral health consultation, and onsite treatment.

NNCC’s HCV Cost Calculator is an interactive tool designed to evaluate the costs and benefits of Standard vs Enhanced HCV Care. The HCV Cost Calculator uses a numerical value-based model of health center staff training, screening, and treatment regimen to estimate the cost-benefit comparison and return on investment (ROI) to the health center.

What is the HCV prevalance in your health center?

 1%0%10%20%30%40%50%60%70%80%90%100%

How many patients does your health clinic screen?

Standard screening includes patients in the birth cohort - and other risk factors. Unviersal screening includes all patients aged 18 or older.

Standard Screening:
Risk-based, birth cohort - and associated risk factors:

Universal Screening:
Eligible patients 18 and older, if have not had test done already

What kind of insurance do your patients have?

Medicaid

 0%5%10%15%20%25%30%35%40%45%50%55%60%65%70%75%80%85%90%95%100%

Medicare/Private

 0%5%10%15%20%25%30%35%40%45%50%55%60%65%70%75%80%85%90%95%100%

Uninsured

 0%5%10%15%20%25%30%35%40%45%50%55%60%65%70%75%80%85%90%95%100%

Total: 100

What services does your health center provide on-site?

Screening Type:

Standard screening includes patients in the birth cohort - and based on other risk factors.
Universal screening includes all patients aged 18 or older who have not yet been tested.

 
Icon of Standard Screening
Standard Screening
Icon of Universal Screening
Universal Screening

HCV Test:

Rapid Test: Fingerstick that takes 20 minutes for an Ab result but still requires a blood draw to confirm RNA positive diagnosis
Reflex HCV to RNA Test: One blood draw that if Ab positive, automatically reflex tests to confirm RNA positive diagnosis.

Icon of Rapid HCV Testing
Rapid Test
Icon of HCV to RNA Testing
Reflex HCV to RNA Test

Treatment location:

Referral to Specialist: Health center does not provide HCV treatment onsite, but protocol is to refer to outside specialist, hepatology or infectious disease.
On-site HCV Treatment: Health center protocol to treat HCV positive patients with in-house primary care or in-house specialty care.

Icon of Referral to Specialist
Referral to Specialist
Icon of Onsite Treatment
On-site HCV Treatment

Additional Services:

Behavioral Health Services: counseling with Behavioral Health Specialist about medication adherence and substance use disorder and/or mental health diagnoses
Link to Primary Care: appointment to inform patient about hepatitis diagnosis, medication adherence, potential side effects and next steps to start treatment.

Icon of Behavioral Health
Behavioral Health Services

What services would you like to add to your current HCV programming?

Care Coordination: wrap around services for the patient to support throughout care continuum, specifically follow up to schedule appointments and helping with prior authorization processes, if required.
Substance Use Disorder Counseling: counseling appointment with patient to discuss co-occurring substance use disorder and impact on treatment. See above for additional definitions.

Icon of Universal Screening
Universal Screening
Icon of HCV to RNA Testing
Reflex HCV to RNA
Icon of Onsite Treatment
On-site HCV Treatment
Icon of Behavioral Health
Behavioral Health Services
Icon of Substance Disorder
Substance Use Disorder Counseling
Icon of Link to PCP
Care Coordination

What are your state Medicaid HCV treatment restrictions?

Fibrosis Severity (F-score) Restriction

Medicaid HCV Sobriety Restriction

Medicaid HCV Prescriber Restriction % Treated

Revenue includes reimbursement rates for 340B.

If the health center does not have a 340B agreement, please contact NNCC for a more detailed version of the calculator.

Results

250

Patients Screened

1

Identified Positive

550

Increase in Universal Screening

6

Increase in Universal Identified


Screening Costs and Revenue

Based on 2017 costs and reimbursement rates

Universal Screening Cost-Benefit Ratio

Benefit-Cost Ratio: Difference in savings divided by difference in costs (Benefit-cost ratio > 1 indicates that the intervention being studied saves money (relative to the comparison intervention); Benefit-cost ratio < 1 indicates that the intervention costs more than it saves)

1.12

Universal Screening ROI

Return on Investment (ROI): (Savings-Costs)/Costs, measured in percentage

11.84%


Treatment Costs and Revenue

Enhanced Treatment Cost-Benefit Ratio

Benefit-Cost Ratio: Difference in savings divided by difference in costs (Benefit-cost ratio > 1 indicates that the intervention being studied saves money (relative to the comparison intervention); Benefit-cost ratio < 1 indicates that the intervention costs more than it saves)

1.04

Enhanced Treatment ROI

Return on Investment (ROI): (Savings-Costs)/Costs, measured in percentage

3.68%


Overall Margins

Universal Screening and Enhanced Treatment Cost-Benefit Ratio

Benefit-Cost Ratio: Difference in savings divided by difference in costs (Benefit-cost ratio > 1 indicates that the intervention being studied saves money (relative to the comparison intervention); Benefit-cost ratio < 1 indicates that the intervention costs more than it saves)

1.04

Universal Screening and Enhanced Treatment ROI

Return on Investment (ROI): (Savings-Costs)/Costs, measured in percentage

4.2%

Thank you for using NNCC's HCV Cost Calculator.
Please click below to print your results

If you need technical assistance or would like to see a more detailed cost calculator to evaluate the costs for your health center, please contact NNCC.

6.371MBMemory Usage182msRequest Duration
Joomla! Version5.2.3
PHP Version8.2.28
Identityguest
Response200
Templatenncc
Database
Server
mysql
Version
10.5.26-MariaDB
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:59 [ "USER" => "g5487" "HOME" => "/var/www/vhosts/phmc.org" "SCRIPT_NAME" => "/index.php...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743886068 "last" => 1743886068...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (107.39KB) (5.57ms)
  • afterInitialise (2.51MB) (39.78ms)
  • Before Access::preloadComponents (all components) (253.51KB) (3.25ms)
  • After Access::preloadComponents (all components) (144.76KB) (704μs)
  • Before Access::getAssetRules (id:1 name:root.1) (104B) (17μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.73KB) (142μs)
  • afterRoute (127.02KB) (47.8ms)
  • beforeRenderComponent com_content (39.96KB) (1.15ms)
  • Before Access::preloadPermissions (com_content) (210.3KB) (3.11ms)
  • After Access::preloadPermissions (com_content) (45.22KB) (527μs)
  • Before Access::getAssetRules (id:231 name:com_content.article.28) (304B) (15μs)
  • After Access::getAssetRules (id:231 name:com_content.article.28) (6.34KB) (31μs)
  • afterRenderComponent com_content (1012.68KB) (32.07ms)
  • afterDispatch (361.02KB) (3.38ms)
  • beforeRenderRawModule mod_custom (Footer Social Media) (108.63KB) (2.93ms)
  • afterRenderRawModule mod_custom (Footer Social Media) (4.27KB) (935μs)
  • beforeRenderModule mod_custom (Footer Social Media) (720B) (6μs)
  • afterRenderModule mod_custom (Footer Social Media) (5.09KB) (616μs)
  • beforeRenderRawModule mod_custom (Footer Address) (520B) (62μs)
  • afterRenderRawModule mod_custom (Footer Address) (1008B) (98μs)
  • beforeRenderModule mod_custom (Footer Address) (720B) (4μs)
  • afterRenderModule mod_custom (Footer Address) (2.34KB) (160μs)
  • beforeRenderRawModule mod_custom (Footer Content 1) (424B) (49μs)
  • afterRenderRawModule mod_custom (Footer Content 1) (1008B) (106μs)
  • beforeRenderModule mod_custom (Footer Content 1) (720B) (4μs)
  • afterRenderModule mod_custom (Footer Content 1) (2.34KB) (164μs)
  • beforeRenderRawModule mod_menu (footer menu) (1.66KB) (49μs)
  • afterRenderRawModule mod_menu (footer menu) (66.9KB) (2.43ms)
  • beforeRenderModule mod_menu (footer menu) (720B) (5μs)
  • afterRenderModule mod_menu (footer menu) (2.66KB) (173μs)
  • beforeRenderRawModule mod_menu (Donate) (680B) (57μs)
  • afterRenderRawModule mod_menu (Donate) (8.93KB) (473μs)
  • beforeRenderModule mod_menu (Donate) (704B) (5μs)
  • afterRenderModule mod_menu (Donate) (3.89KB) (162μs)
  • beforeRenderRawModule mod_custom (MailChimp inner) (2.26KB) (51μs)
  • afterRenderRawModule mod_custom (MailChimp inner) (1008B) (94μs)
  • beforeRenderModule mod_custom (MailChimp inner) (720B) (3μs)
  • afterRenderModule mod_custom (MailChimp inner) (2.34KB) (158μs)
  • beforeRenderRawModule mod_finder (NNCC Search) (1.59KB) (126μs)
  • afterRenderRawModule mod_finder (NNCC Search) (57.96KB) (4.26ms)
  • beforeRenderModule mod_finder (NNCC Search) (720B) (6μs)
  • afterRenderModule mod_finder (NNCC Search) (2.31KB) (182μs)
  • beforeRenderRawModule mod_custom (Subscribe Button) (712B) (62μs)
  • afterRenderRawModule mod_custom (Subscribe Button) (1008B) (98μs)
  • beforeRenderModule mod_custom (Subscribe Button) (720B) (4μs)
  • afterRenderModule mod_custom (Subscribe Button) (2.34KB) (155μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.66KB) (50μs)
  • afterRenderRawModule mod_menu (Main Menu) (301.65KB) (6.97ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (2.64KB) (182μs)
  • beforeRenderRawModule mod_menu (Top Menu) (552B) (69μs)
  • afterRenderRawModule mod_menu (Top Menu) (5.35KB) (406μs)
  • beforeRenderModule mod_menu (Top Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Top Menu) (2.64KB) (158μs)
  • beforeRenderRawModule mod_menu (Mobile Menu) (616B) (53μs)
  • afterRenderRawModule mod_menu (Mobile Menu) (8.61KB) (5.57ms)
  • beforeRenderModule mod_menu (Mobile Menu) (720B) (4μs)
  • afterRenderModule mod_menu (Mobile Menu) (2.66KB) (176μs)
  • beforeRenderRawModule mod_custom (Logo) (1.7KB) (53μs)
  • afterRenderRawModule mod_custom (Logo) (1008B) (94μs)
  • beforeRenderModule mod_custom (Logo) (704B) (4μs)
  • afterRenderModule mod_custom (Logo) (2.33KB) (179μs)
  • afterRender (450.8KB) (16.28ms)
  • 1 x afterRoute (127.02KB) (26.22%)
    47.80ms
    1 x afterInitialise (2.51MB) (21.82%)
    39.78ms
    1 x afterRenderComponent com_content (1012.68KB) (17.59%)
    32.07ms
    1 x afterRender (450.8KB) (8.93%)
    16.28ms
    1 x afterRenderRawModule mod_menu (Main Menu) (301.65KB) (3.83%)
    6.97ms
    1 x afterLoad (107.39KB) (3.06%)
    5.57ms
    1 x afterRenderRawModule mod_menu (Mobile Menu) (8.61KB) (3.05%)
    5.57ms
    1 x afterRenderRawModule mod_finder (NNCC Search) (57.96KB) (2.34%)
    4.26ms
    1 x afterDispatch (361.02KB) (1.86%)
    3.38ms
    1 x Before Access::preloadComponents (all components) (253.51KB) (1.78%)
    3.25ms
    1 x Before Access::preloadPermissions (com_content) (210.3KB) (1.71%)
    3.11ms
    1 x beforeRenderRawModule mod_custom (Footer Social Media) (108.63KB) (1.61%)
    2.93ms
    1 x afterRenderRawModule mod_menu (footer menu) (66.9KB) (1.33%)
    2.43ms
    1 x beforeRenderComponent com_content (39.96KB) (0.63%)
    1.15ms
    1 x afterRenderRawModule mod_custom (Footer Social Media) (4.27KB) (0.51%)
    935μs
    1 x After Access::preloadComponents (all components) (144.76KB) (0.39%)
    704μs
    1 x afterRenderModule mod_custom (Footer Social Media) (5.09KB) (0.34%)
    616μs
    1 x After Access::preloadPermissions (com_content) (45.22KB) (0.29%)
    527μs
    1 x afterRenderRawModule mod_menu (Donate) (8.93KB) (0.26%)
    473μs
    1 x afterRenderRawModule mod_menu (Top Menu) (5.35KB) (0.22%)
    406μs
    1 x afterRenderModule mod_finder (NNCC Search) (2.31KB) (0.1%)
    182μs
    1 x afterRenderModule mod_menu (Main Menu) (2.64KB) (0.1%)
    182μs
    1 x afterRenderModule mod_custom (Logo) (2.33KB) (0.1%)
    179μs
    1 x afterRenderModule mod_menu (Mobile Menu) (2.66KB) (0.1%)
    176μs
    1 x afterRenderModule mod_menu (footer menu) (2.66KB) (0.09%)
    173μs
    1 x afterRenderModule mod_custom (Footer Content 1) (2.34KB) (0.09%)
    164μs
    1 x afterRenderModule mod_menu (Donate) (3.89KB) (0.09%)
    162μs
    1 x afterRenderModule mod_custom (Footer Address) (2.34KB) (0.09%)
    160μs
    1 x afterRenderModule mod_menu (Top Menu) (2.64KB) (0.09%)
    158μs
    1 x afterRenderModule mod_custom (MailChimp inner) (2.34KB) (0.09%)
    158μs
    1 x afterRenderModule mod_custom (Subscribe Button) (2.34KB) (0.08%)
    155μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.73KB) (0.08%)
    142μs
    1 x beforeRenderRawModule mod_finder (NNCC Search) (1.59KB) (0.07%)
    126μs
    1 x afterRenderRawModule mod_custom (Footer Content 1) (1008B) (0.06%)
    106μs
    1 x afterRenderRawModule mod_custom (Footer Address) (1008B) (0.05%)
    98μs
    1 x afterRenderRawModule mod_custom (Subscribe Button) (1008B) (0.05%)
    98μs
    1 x afterRenderRawModule mod_custom (MailChimp inner) (1008B) (0.05%)
    94μs
    1 x afterRenderRawModule mod_custom (Logo) (1008B) (0.05%)
    94μs
    1 x beforeRenderRawModule mod_menu (Top Menu) (552B) (0.04%)
    69μs
    1 x beforeRenderRawModule mod_custom (Footer Address) (520B) (0.03%)
    62μs
    1 x beforeRenderRawModule mod_custom (Subscribe Button) (712B) (0.03%)
    62μs
    1 x beforeRenderRawModule mod_menu (Donate) (680B) (0.03%)
    57μs
    1 x beforeRenderRawModule mod_menu (Mobile Menu) (616B) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_custom (Logo) (1.7KB) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_custom (MailChimp inner) (2.26KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.66KB) (0.03%)
    50μs
    1 x beforeRenderRawModule mod_custom (Footer Content 1) (424B) (0.03%)
    49μs
    1 x beforeRenderRawModule mod_menu (footer menu) (1.66KB) (0.03%)
    49μs
    1 x After Access::getAssetRules (id:231 name:com_content.article.28) (6.34KB) (0.02%)
    31μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%)
    17μs
    1 x Before Access::getAssetRules (id:231 name:com_content.article.28) (304B) (0.01%)
    15μs
    1 x beforeRenderModule mod_custom (Footer Social Media) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (NNCC Search) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (footer menu) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Donate) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Top Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Footer Address) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Footer Content 1) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Subscribe Button) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Logo) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Mobile Menu) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (MailChimp inner) (720B) (0%)
    3μs
55 statements were executed, 17 of which were duplicates, 38 unique24.04ms1.06MB
  • SELECT @@SESSION.sql_mode;99μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `womv1_session` WHERE `session_id` = ?162μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `womv1_session` WHERE `session_id` = :session_id LIMIT 1102μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `womv1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)832μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `womv1_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1317μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `womv1_viewlevels`106μs704B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `womv1_usergroups` AS `a` LEFT JOIN `womv1_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest142μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `womv1_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`689μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `womv1_admintools_storage` WHERE `key` = 'cparams'101μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `womv1_admintools_wafexceptions`92μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `womv1_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'146μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));59μs0B/administrator/components/com_osmembership/loader.php:94Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));53μs0B/administrator/components/com_jdonation/loader.php:71Copy
  • SELECT `storage_value` FROM `womv1_securitycheckpro_storage` WHERE `storage_key` = 'pro_plugin'112μs536B/plugins/system/securitycheck_spam_protection/src/Extension/Securitycheck_spam_protection.php:134Copy
  • SELECT count(*) from `womv1_extensions`188μs536B/plugins/system/securitycheck_spam_protection/src/Extension/Securitycheck_spam_protection.php:77Copy
  • SELECT * FROM womv1_rsform_config129μs1.31KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • 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 `womv1_menu` AS `m` LEFT JOIN `womv1_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`763μs54.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `womv1_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,:preparedArray46)402μs7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT * FROM womv1_osmembership_schedulecontent WHERE article_id = 28116μs752B/plugins/system/schedulecontent/schedulecontent.php:201Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `womv1_template_styles` AS `s` LEFT JOIN `womv1_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` = 1202μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT enabled from womv1_extensions WHERE element='Securitycheckpro' and type='plugin'193μs536B/plugins/system/securitycheckpro/src/Extension/Securitycheckpro.php:1994Copy
  • SELECT storage_value from womv1_securitycheckpro_storage WHERE storage_key = 'locked'105μs536B/plugins/system/securitycheckpro/src/Extension/Securitycheckpro.php:2004Copy
  • SELECT `storage_value` FROM `womv1_securitycheckpro_storage` WHERE `storage_key` = 'pro_plugin'109μs536B/administrator/components/com_securitycheckpro/src/Model/BaseModel.php:337Copy
  • DELETE from womv1_securitycheckpro_users_control WHERE id='1'87μs0B/plugins/system/securitycheckpro/src/Extension/Securitycheckpro.php:2639Copy
  • SELECT * FROM womv1_securitycheckpro_blacklist5.31ms768.51KB/administrator/components/com_securitycheckpro/src/Model/BaseModel.php:720Copy
  • SELECT * FROM womv1_securitycheckpro_blacklist5.21ms0B/administrator/components/com_securitycheckpro/src/Model/BaseModel.php:721Copy
  • SELECT * FROM womv1_securitycheckpro_whitelist124μs1.01KB/administrator/components/com_securitycheckpro/src/Model/BaseModel.php:720Copy
  • SELECT * FROM womv1_securitycheckpro_whitelist100μs0B/administrator/components/com_securitycheckpro/src/Model/BaseModel.php:721Copy
  • DELETE FROM womv1_securitycheckpro_dynamic_blacklist WHERE (DATE_ADD(timeattempt, INTERVAL 600 SECOND)) < NOW();75μs0B/plugins/system/securitycheckpro/src/Extension/Securitycheckpro.php:946Copy
  • SELECT COUNT(*) from womv1_securitycheckpro_dynamic_blacklist WHERE (ip = '18.191.112.81' AND counter >= 5)100μs536B/plugins/system/securitycheckpro/src/Extension/Securitycheckpro.php:910Copy
  • SELECT * FROM `womv1_languages` WHERE `published` = 1 ORDER BY `ordering` ASC154μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `womv1_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0309μs2.23KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `womv1_content`379μs4.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `womv1_content` SET `hits` = (`hits` + 1) WHERE `id` = '28'832μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `womv1_content` AS `a` INNER JOIN `womv1_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `womv1_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `womv1_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `womv1_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `womv1_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)314μs46.13KBParams/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 `womv1_categories` AS `s` INNER JOIN `womv1_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`315μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `womv1_contentitem_tag_map` AS `m` INNER JOIN `womv1_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)268μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM womv1_osmembership_schedulecontent WHERE article_id = 28108μs752B/plugins/system/schedulecontent/schedulecontent.php:201Copy
  • 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 `womv1_categories` AS `s` INNER JOIN `womv1_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`282μs3.91KBParams/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 womv1_fields AS a LEFT JOIN `womv1_languages` AS l ON l.lang_code = a.language LEFT JOIN womv1_users AS uc ON uc.id=a.checked_out LEFT JOIN womv1_viewlevels AS ag ON ag.id = a.access LEFT JOIN womv1_users AS ua ON ua.id = a.created_user_id LEFT JOIN womv1_fields_groups AS g ON g.id = a.group_id LEFT JOIN `womv1_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (: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 ASC576μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `womv1_users`361μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `womv1_users` WHERE `id` = :userid141μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `womv1_usergroups` AS `g` INNER JOIN `womv1_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid149μs1.38KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `womv1_users` WHERE `id` = :userid135μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `womv1_usergroups` AS `g` INNER JOIN `womv1_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid146μs1.38KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `b`.`id` FROM `womv1_user_usergroup_map` AS `map` LEFT JOIN `womv1_usergroups` AS `a` ON `a`.`id` = `map`.`group_id` LEFT JOIN `womv1_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `map`.`user_id` = :userId163μs1.38KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `womv1_modules` AS `m` LEFT JOIN `womv1_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `womv1_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)) 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`826μs18.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `womv1_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1390μs672B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `womv1_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)186μs712B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `womv1_schemaorg` WHERE `itemId` = :itemId AND `context` = :context138μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `womv1_content` AS `a` INNER JOIN `womv1_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `womv1_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `womv1_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `womv1_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `womv1_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)359μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `womv1_content` AS `a` INNER JOIN `womv1_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `womv1_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `womv1_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `womv1_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `womv1_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)280μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `womv1_scheduler_tasks` AS `a` WHERE `a`.`state` = 1152μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `womv1_session` WHERE `session_id` = ?132μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `womv1_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?729μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy