ACSA

Total Time

Count

Avg Time

Query

0.023

1 call
11 rows

0.023

DESCRIBE Ticket

0.019

2 calls
0 rows

0.009

COMMIT

0.007

1 call
1 row

0.007

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.004

1 call
0 rows

0.004

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-22 07:13:03',`mxxCreatedBy`=NULL, `PageRequestId`=0x14B52700000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='3249314', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='712245', `startTime`='2025-08-22 07:13:03', `sessionId`=0x468999582148467B, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=1EECA0000000C\\'}', `clientIPAddr`='216.73.216.122'

0.004

1 call
167 rows

0.004

SELECT * FROM webselect

0.003

1 call
1 row

0.003

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.003

1 call
0 rows

0.003

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

0.003

1 call
0 rows

0.003

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.002

1 call
1 row

0.002

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.002

1 call
0 rows

0.002

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.002

1 call
0 rows

0.002

INSERT INTO `Ticket` SET `mxxCreated`='2025-08-22 07:13:03',`mxxCreatedBy`=NULL, `TicketId`=0x14B52700000002, `type`='2', `value`='LT-1755861183-H5HoDLl8K0HJGdnoq387eXbzlPVgqOMW', `expires`='2025/08/22 08:43:03.7836 US/Eastern', `username`=NULL, `service`='/members_only/membership/CompanyFormPublicMembers/view?id=1EECA0000000C', `isPrimary`='2'

0.002

1 call
0 rows

0.002

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.002

1 call
0 rows

0.002

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.002

1 call
0 rows

0.002

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.002

1 call
1 row

0.002

SELECT version from databasemap;

0.001

2 calls
0 rows

0.001

START TRANSACTION

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-08-22 07:13:03',`mxxUpdatedBy`=NULL, `PageRequestId`=0x14B52700000000, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='ACSA', `pid`='3249314', `requestNum`='1', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='712245', `startTime`='2025-08-22 07:13:03', `sessionId`=0x468999582148467B, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.023475170135498047', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/members_only/membership/CompanyFormPublicMembers/view?id=1EECA0000000C\\'}', `clientIPAddr`='216.73.216.122' WHERE `PageRequestId`=0x14B52700000000

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

         976053 function calls (966378 primitive calls) in 1.701 seconds

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

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    1.701    1.701 /data/acsa/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    1.698    1.698 /data/acsa/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    1.679    1.679 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    1.679    1.679 /data/acsa/current/generic/sites/www/forms/cas.py:186(login)
        1    0.000    0.000    1.679    1.679 /data/acsa/current/generic/sites/www/forms/cas.py:81(_presentLoginPage)
        1    0.000    0.000    1.324    1.324 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap)
        1    0.000    0.000    1.324    1.324 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML)
        1    0.000    0.000    1.139    1.139 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    1.138    1.138 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape)
       12    0.000    0.000    0.802    0.067 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
       12    0.000    0.000    0.802    0.067 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
       12    0.000    0.000    0.802    0.067 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
       12    0.000    0.000    0.792    0.066 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
       12    0.000    0.000    0.792    0.066 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
       12    0.015    0.001    0.790    0.066 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
        1    0.000    0.000    0.591    0.591 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts)
        2    0.000    0.000    0.549    0.275 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup)
     4775    0.074    0.000    0.432    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
        1    0.000    0.000    0.315    0.315 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS)
        1    0.000    0.000    0.276    0.276 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript)
        9    0.000    0.000    0.262    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
        9    0.000    0.000    0.262    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
        9    0.000    0.000    0.260    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
       19    0.000    0.000    0.259    0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
       19    0.005    0.000    0.258    0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
2218/2005    0.006    0.000    0.252    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
        5    0.000    0.000    0.237    0.047 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML)
24512/24341    0.028    0.000    0.229    0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter)
     1977    0.015    0.000    0.215    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)
     5894    0.007    0.000    0.215    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)
        8    0.000    0.000    0.211    0.026 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm)
24527/24341    0.029    0.000    0.195    0.000 {built-in method builtins.__import__}
        1    0.000    0.000    0.185    0.185 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process)
     5894    0.013    0.000    0.176    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
    85/12    0.000    0.000    0.172    0.014 :233(_call_with_frames_removed)
     34/7    0.000    0.000    0.170    0.024 :666(_load_unlocked)
     35/8    0.000    0.000    0.170    0.021 :934(exec_module)
     35/8    0.004    0.000    0.167    0.021 {built-in method builtins.exec}
     36/6    0.002    0.000    0.166    0.028 :1165(_find_and_load)
     36/6    0.000    0.000    0.166    0.028 :1120(_find_and_load_unlocked)
     5894    0.006    0.000    0.128    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag)
        1    0.000    0.000    0.127    0.127 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
        4    0.000    0.000    0.117    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)
   2649/4    0.037    0.000    0.117    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)
       41    0.001    0.000    0.116    0.003 /usr/lib/python3.11/re/__init__.py:225(compile)
   2649/4    0.010    0.000    0.116    0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents)
       43    0.001    0.000    0.116    0.003 /usr/lib/python3.11/re/__init__.py:272(_compile)
       30    0.000    0.000    0.115    0.004 /usr/lib/python3.11/re/_compiler.py:740(compile)
        1    0.000    0.000    0.115    0.115 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1()
     1989    0.012    0.000    0.097    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass)
        1    0.000    0.000    0.097    0.097 /usr/lib/python3.11/urllib/request.py:139(urlopen)
     9509    0.037    0.000    0.095    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil)
        1    0.000    0.000    0.093    0.093 /usr/lib/python3.11/urllib/request.py:500(open)
        1    0.000    0.000    0.093    0.093 /usr/lib/python3.11/urllib/request.py:529(_open)
        2    0.000    0.000    0.093    0.046 /usr/lib/python3.11/urllib/request.py:489(_call_chain)
        1    0.000    0.000    0.093    0.093 /usr/lib/python3.11/urllib/request.py:1390(https_open)
        1    0.000    0.000    0.093    0.093 /usr/lib/python3.11/urllib/request.py:1307(do_open)
     8888    0.040    0.000    0.091    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState)
        1    0.000    0.000    0.090    0.090 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin)
     5894    0.009    0.000    0.088    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname)
        2    0.000    0.000    0.085    0.043 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__)
      648    0.003    0.000    0.084    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP)
    13210    0.058    0.000    0.083    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower)
  220/188    0.000    0.000    0.081    0.000 :1207(_handle_fromlist)
        1    0.000    0.000    0.076    0.076 /data/acsa/current/generic/classes/Ticket.py:42(create)
        1    0.000    0.000    0.074    0.074 /data/acsa/current/libs/PLayer/PersistentObject.py:955(save)
     3095    0.026    0.000    0.068    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild)
       30    0.000    0.000    0.066    0.002 /usr/lib/python3.11/re/_compiler.py:573(_code)
        4    0.000    0.000    0.064    0.016 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS)
        9    0.064    0.007    0.064    0.007 /data/acsa/current/libs/utils/htmlTools.py:53(init)
        1    0.000    0.000    0.060    0.060 /usr/lib/python3.11/http/client.py:1426(__init__)
        1    0.000    0.000    0.060    0.060 /usr/lib/python3.11/ssl.py:745(create_default_context)
     5108    0.022    0.000    0.059    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:332(setAttributes)
    53173    0.053    0.000    0.059    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:234(char)
       19    0.000    0.000    0.059    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       19    0.000    0.000    0.058    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
       19    0.000    0.000    0.057    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       19    0.057    0.003    0.057    0.003 {function Connection.query at 0xf63d71549620}
        1    0.000    0.000    0.057    0.057 /data/acsa/current/libs/framework/BaseHandler.py:1587(writeCachedFile)
        1    0.000    0.000    0.057    0.057 /usr/lib/python3.11/ssl.py:591(load_default_certs)
        1    0.057    0.057    0.057    0.057 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects}
     5894    0.010    0.000    0.054    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:501(get_tag)
     1990    0.011    0.000    0.053    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:455(new_tag)
        1    0.000    0.000    0.051    0.051 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:574(_fixStubAuthLinks)
    11040    0.026    0.000    0.049    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:434(tagNameState)
       30    0.000    0.000    0.048    0.002 /usr/lib/python3.11/re/_parser.py:979(parse)
    89/30    0.004    0.000    0.048    0.002 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)
   670/30    0.017    0.000    0.047    0.002 /usr/lib/python3.11/re/_parser.py:516(_parse)
   732/30    0.011    0.000    0.047    0.002 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        1    0.000    0.000    0.046    0.046 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:650(prepMetaTags)
        3    0.000    0.000    0.045    0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean)
     6577    0.013    0.000    0.044    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute)
      270    0.001    0.000    0.042    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:957(addFormattingElement)
    14750    0.017    0.000    0.042    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag)
     1034    0.003    0.000    0.042    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText)
     3640    0.032    0.000    0.041    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:228(emitCurrentToken)
     2026    0.035    0.000    0.041    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1068(__init__)
        1    0.000    0.000    0.041    0.041 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:694(_findPlace)
     3950    0.004    0.000    0.041    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:1070(afterAttributeValueState)
        1    0.000    0.000    0.041    0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()

Other ACSA Websites

Login

Log In

Already have an account?

I’m new here

Stay in Touch