ACSA

Total Time

Count

Avg Time

Query

0.003

2 calls
0 rows

0.002

COMMIT

0.002

1 call
1 row

0.002

SELECT version from databasemap;

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-22 09:45:36',`mxxCreatedBy`=NULL, `PageRequestId`=0x14B56200000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='3318614', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='721071', `startTime`='2025-08-22 09:45:36', `sessionId`=0xBD88DD5AAF242C4, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=ADFBC00000120\\'}', `clientIPAddr`='216.73.216.122'

0.001

1 call
11 rows

0.001

DESCRIBE Ticket

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.000

1 call
167 rows

0.000

SELECT * FROM webselect

0.000

2 calls
0 rows

0.000

START TRANSACTION

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-08-22 09:45:36',`mxxUpdatedBy`=NULL, `PageRequestId`=0x14B56200000000, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='ACSA', `pid`='3318614', `requestNum`='1', `growth`='1024', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='721071', `startTime`='2025-08-22 09:45:36', `sessionId`=0x689D2499D8E983D4, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.003990650177001953', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=ADFBC00000120\\'}', `clientIPAddr`='216.73.216.122' WHERE `PageRequestId`=0x14B56200000000

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-22 09:45:36',`mxxCreatedBy`=NULL, `PageRequestId`=0x14B56200000000, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='ACSA', `pid`='3318614', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='721071', `startTime`='2025-08-22 09:45:36', `sessionId`=0x689D2499D8E983D4, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=ADFBC00000120\\'}', `clientIPAddr`='216.73.216.122'

0.000

1 call
0 rows

0.000

INSERT INTO `Ticket` SET `mxxCreated`='2025-08-22 09:45:36',`mxxCreatedBy`=NULL, `TicketId`=0x14B56200000002, `type`='2', `value`='LT-1755870336-Th3tNxwlPNGUrzFbOPwdaTuYQQVAuyU9', `expires`='2025/08/22 11:15:36.9436 US/Eastern', `username`=NULL, `service`='/members_only/membership/CompanyFormPublicMembers/view?id=ADFBC00000120', `isPrimary`='2'

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

         419484 function calls (414209 primitive calls) in 0.388 seconds

   Ordered by: cumulative time
   List reduced from 1456 to 100 due to restriction <100>

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    0.388    0.388 /data/acsa/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    0.384    0.384 /data/acsa/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    0.374    0.374 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    0.374    0.374 /data/acsa/current/generic/sites/www/forms/cas.py:186(login)
        1    0.000    0.000    0.374    0.374 /data/acsa/current/generic/sites/www/forms/cas.py:81(_presentLoginPage)
        1    0.000    0.000    0.189    0.189 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap)
        1    0.000    0.000    0.189    0.189 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML)
        1    0.000    0.000    0.096    0.096 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    0.095    0.095 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape)
        1    0.000    0.000    0.095    0.095 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache)
        1    0.000    0.000    0.094    0.094 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
        1    0.000    0.000    0.094    0.094 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
        1    0.000    0.000    0.094    0.094 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
        1    0.000    0.000    0.093    0.093 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
        1    0.000    0.000    0.093    0.093 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
        1    0.003    0.003    0.093    0.093 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
        1    0.000    0.000    0.093    0.093 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process)
        5    0.000    0.000    0.084    0.017 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML)
        1    0.000    0.000    0.084    0.084 /data/acsa/current/generic/classes/Ticket.py:42(create)
        1    0.000    0.000    0.083    0.083 /data/acsa/current/libs/PLayer/PersistentObject.py:955(save)
9005/8834    0.005    0.000    0.074    0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter)
        1    0.068    0.068    0.068    0.068 {built-in method gc.collect}
9020/8834    0.006    0.000    0.067    0.000 {built-in method builtins.__import__}
     36/6    0.000    0.000    0.061    0.010 :1165(_find_and_load)
     36/6    0.000    0.000    0.061    0.010 :1120(_find_and_load_unlocked)
    85/12    0.000    0.000    0.060    0.005 :233(_call_with_frames_removed)
     34/7    0.000    0.000    0.060    0.009 :666(_load_unlocked)
     35/8    0.000    0.000    0.060    0.008 :934(exec_module)
     35/8    0.000    0.000    0.059    0.007 {built-in method builtins.exec}
        3    0.000    0.000    0.051    0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
        3    0.000    0.000    0.051    0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
        3    0.000    0.000    0.051    0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
        8    0.000    0.000    0.051    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
        8    0.001    0.000    0.050    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
     1572    0.008    0.000    0.050    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
        1    0.000    0.000    0.045    0.045 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
     1971    0.002    0.000    0.042    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)
        1    0.000    0.000    0.037    0.037 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin)
       39    0.000    0.000    0.037    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       37    0.000    0.000    0.037    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
       26    0.000    0.000    0.036    0.001 /usr/lib/python3.11/re/_compiler.py:740(compile)
        1    0.000    0.000    0.035    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1()
     1971    0.003    0.000    0.033    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
   109/77    0.000    0.000    0.031    0.000 :1207(_handle_fromlist)
        2    0.000    0.000    0.030    0.015 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm)
  729/657    0.001    0.000    0.029    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
      656    0.001    0.000    0.024    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)
        1    0.000    0.000    0.022    0.022 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:703(_drape)
        4    0.000    0.000    0.021    0.005 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS)
        9    0.021    0.002    0.021    0.002 /data/acsa/current/libs/utils/htmlTools.py:53(init)
        1    0.000    0.000    0.021    0.021 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:574(_fixStubAuthLinks)
        1    0.000    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__)
        1    0.000    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)
    656/1    0.005    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)
    656/1    0.002    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents)
     1971    0.001    0.000    0.021    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag)
       26    0.000    0.000    0.019    0.001 /usr/lib/python3.11/re/_compiler.py:573(_code)
       10    0.000    0.000    0.018    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all)
       10    0.001    0.000    0.018    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all)
        3    0.000    0.000    0.017    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean)
        1    0.000    0.000    0.017    0.017 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:636(doPostScrapeStuff)
       26    0.000    0.000    0.017    0.001 /usr/lib/python3.11/re/_parser.py:979(parse)
       19    0.000    0.000    0.016    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
        1    0.000    0.000    0.016    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()
       19    0.000    0.000    0.016    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
    81/26    0.001    0.000    0.016    0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)
   662/26    0.006    0.000    0.016    0.001 /usr/lib/python3.11/re/_parser.py:516(_parse)
        1    0.000    0.000    0.016    0.016 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:598(_addUserNameToElement)
       19    0.000    0.000    0.016    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       19    0.016    0.001    0.016    0.001 {function Connection.query at 0xfcd0b3f69c60}
        3    0.000    0.000    0.015    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__)
        1    0.000    0.000    0.015    0.015 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:402(_applyTitle)
     2131    0.002    0.000    0.015    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search)
        1    0.000    0.000    0.014    0.014 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:9(getTitleElement)
        3    0.000    0.000    0.014    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__)
        3    0.000    0.000    0.014    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__)
     5084    0.010    0.000    0.014    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower)
     1971    0.002    0.000    0.014    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname)
   719/26    0.004    0.000    0.013    0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        3    0.000    0.000    0.013    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder)
     3161    0.005    0.000    0.013    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil)
        1    0.012    0.012    0.012    0.012 {built-in method gc.get_referrers}
        1    0.000    0.000    0.012    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1()
     1407    0.003    0.000    0.012    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1980(search_tag)
        1    0.000    0.000    0.012    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1()
        1    0.000    0.000    0.011    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1()
      657    0.002    0.000    0.011    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass)
     2978    0.004    0.000    0.011    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState)
       60    0.010    0.000    0.010    0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)
60541/60438    0.009    0.000    0.010    0.000 {built-in method builtins.isinstance}
      216    0.000    0.000    0.010    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP)
     1644    0.002    0.000    0.009    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute)
        1    0.000    0.000    0.009    0.009 /data/acsa/current/libs/framework/BaseHandler.py:311(getTemplate)
     4932    0.003    0.000    0.009    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag)
        1    0.000    0.000    0.009    0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re)
        1    0.000    0.000    0.009    0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re)
        1    0.000    0.000    0.008    0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1()
     1027    0.002    0.000    0.008    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild)
     2641    0.002    0.000    0.008    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:1007(attributeValueDoubleQuotedState)
        8    0.000    0.000    0.008    0.001 /data/acsa/current/generic/classes/ClientSetting.py:97(getClientSettingValue)

Other ACSA Websites

Login

Log In

Already have an account?

I’m new here

Stay in Touch