ACSA

Total Time

Count

Avg Time

Query

0.018

2 calls
0 rows

0.009

COMMIT

0.010

1 call
167 rows

0.010

SELECT * FROM webselect

0.002

1 call
11 rows

0.002

DESCRIBE Ticket

0.001

1 call
0 rows

0.001

UPDATE `PageRequest` SET `mxxUpdated`='2025-11-07 07:59:07',`mxxUpdatedBy`=NULL, `PageRequestId`=0x83463D00000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1711945', `requestNum`='1', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='564404', `startTime`='2025-11-07 07:59:07', `sessionId`=0xA875CEABA53FF0A, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.019016027450561523', `timeTaken`='0', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/forms/CompanyFormPublic/search?action=find&amp;amp;amp;amp;Company_region=5\\'}', `clientIPAddr`='217.113.194.15' WHERE `PageRequestId`=0x83463D00000000

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

INSERT INTO `PageRequest` SET `mxxCreated`='2025-11-07 07:59:07',`mxxCreatedBy`=NULL, `PageRequestId`=0x83463D00000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1711945', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='564404', `startTime`='2025-11-07 07:59:07', `sessionId`=0xA875CEABA53FF0A, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/forms/CompanyFormPublic/search?action=find&amp;amp;amp;amp;Company_region=5\\'}', `clientIPAddr`='217.113.194.15'

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`='newUserHeaderText' 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.000

2 calls
0 rows

0.000

START TRANSACTION

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-11-07 07:59:57',`mxxCreatedBy`=NULL, `PageRequestId`=0x83463D00000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1711945', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='564404', `startTime`='2025-11-07 07:59:57', `sessionId`=0x4C84B4472AF6EAC7, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=19B00000210\\'}', `clientIPAddr`='216.73.216.163'

0.000

1 call
0 rows

0.000

INSERT INTO `Ticket` SET `mxxCreated`='2025-11-07 07:59:57',`mxxCreatedBy`=NULL, `TicketId`=0x83463D00000002, `type`='2', `value`='LT-1762520397-ViqHe4w933wMPiGZuDuKzEh3NmFrb2EG', `expires`='2025/11/07 09:29:57.4884 US/Eastern', `username`=NULL, `service`='/members_only/membership/CompanyFormPublicMembers/view?id=19B00000210', `isPrimary`='2'

0.000

1 call
1 row

0.000

SELECT version from databasemap;

         420418 function calls (415125 primitive calls) in 0.323 seconds

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

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    0.323    0.323 /data/acsa/current/libs/framework/WebManager.py:134(_newRequest)
        1    0.000    0.000    0.321    0.321 /data/acsa/current/libs/framework/WebSite.py:167(processRequest)
        1    0.000    0.000    0.315    0.315 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    0.315    0.315 /data/acsa/current/generic/sites/www/forms/cas.py:186(login)
        1    0.000    0.000    0.315    0.315 /data/acsa/current/generic/sites/www/forms/cas.py:81(_presentLoginPage)
        1    0.000    0.000    0.190    0.190 /data/acsa/current/libs/framework/WebApp.py:276(writeHTMLWithWrap)
        1    0.000    0.000    0.190    0.190 /data/acsa/current/libs/framework/WebApp.py:212(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:272(scrape)
        1    0.000    0.000    0.095    0.095 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache)
        1    0.000    0.000    0.094    0.094 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:718(process)
        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.092    0.092 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
        5    0.000    0.000    0.079    0.016 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML)
8986/8815    0.005    0.000    0.069    0.000 /data/acsa/current/libs/framework/BaseHandler.py:1471(mxxImporter)
9001/8815    0.006    0.000    0.062    0.000 {built-in method builtins.__import__}
     36/6    0.000    0.000    0.056    0.009 :1165(_find_and_load)
     36/6    0.000    0.000    0.056    0.009 :1120(_find_and_load_unlocked)
    84/11    0.000    0.000    0.055    0.005 :233(_call_with_frames_removed)
     33/6    0.000    0.000    0.055    0.009 :666(_load_unlocked)
     34/7    0.000    0.000    0.055    0.008 :934(exec_module)
     34/7    0.000    0.000    0.053    0.008 {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.051    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
     1562    0.008    0.000    0.050    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
     1974    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.041    0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
        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.036    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       37    0.000    0.000    0.035    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
       26    0.000    0.000    0.035    0.001 /usr/lib/python3.11/re/_compiler.py:740(compile)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1()
        1    0.000    0.000    0.034    0.034 /data/acsa/current/generic/classes/Ticket.py:42(create)
        1    0.000    0.000    0.033    0.033 /data/acsa/current/libs/PLayer/PersistentObject.py:955(save)
     1974    0.003    0.000    0.033    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
        2    0.000    0.000    0.030    0.015 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:378(getElm)
   106/74    0.000    0.000    0.029    0.000 :1207(_handle_fromlist)
  728/658    0.001    0.000    0.029    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
      657    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.024    0.024    0.024    0.024 {built-in method gc.collect}
        1    0.000    0.000    0.023    0.023 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:707(_drape)
        1    0.000    0.000    0.022    0.022 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:578(_fixStubAuthLinks)
        4    0.000    0.000    0.021    0.005 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS)
        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)
        9    0.021    0.002    0.021    0.002 /data/acsa/current/libs/utils/htmlTools.py:53(init)
    657/1    0.005    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)
    657/1    0.002    0.000    0.021    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents)
     1974    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)
        1    0.000    0.000    0.017    0.017 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:640(doPostScrapeStuff)
        3    0.000    0.000    0.016    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean)
       26    0.000    0.000    0.016    0.001 /usr/lib/python3.11/re/_parser.py:979(parse)
        1    0.000    0.000    0.016    0.016 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:602(_addUserNameToElement)
        1    0.000    0.000    0.016    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()
    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)
     2157    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.015    0.015 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:406(_applyTitle)
        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.014    0.014 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:9(getTitleElement)
     5119    0.010    0.000    0.014    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower)
        3    0.000    0.000    0.014    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__)
     1974    0.002    0.000    0.014    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname)
        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__)
   719/26    0.004    0.000    0.013    0.000 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        3    0.000    0.000    0.012    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder)
     1445    0.003    0.000    0.012    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1980(search_tag)
     3137    0.005    0.000    0.012    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil)
        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()
       19    0.000    0.000    0.011    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       19    0.000    0.000    0.011    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
        1    0.000    0.000    0.011    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1()
     2958    0.004    0.000    0.011    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState)
        1    0.000    0.000    0.011    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1()
       19    0.000    0.000    0.011    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       19    0.011    0.001    0.011    0.001 {function Connection.query at 0xf7c884cb6de0}
       60    0.010    0.000    0.010    0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)
60866/60763    0.008    0.000    0.010    0.000 {built-in method builtins.isinstance}
      658    0.002    0.000    0.010    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass)
      216    0.000    0.000    0.010    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP)
        8    0.000    0.000    0.010    0.001 /data/acsa/current/generic/classes/ClientSetting.py:97(getClientSettingValue)
     1646    0.002    0.000    0.009    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute)
     4920    0.003    0.000    0.009    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag)
        8    0.000    0.000    0.009    0.001 /data/acsa/current/generic/classes/ClientSetting.py:33(getClientSetting)
        7    0.000    0.000    0.009    0.001 /data/acsa/current/libs/framework/BaseHandler.py:831(getClientSetting)
        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.008    0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re)
     1022    0.002    0.000    0.008    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild)
        8    0.000    0.000    0.008    0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:769(processCriteria)
     1977    0.002    0.000    0.008    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants)

Other ACSA Websites

Login

Log In

Already have an account?

I’m new here

Stay in Touch