QM SERIES (0)

1 - 0 of 0 results

There are currently no qm series.

1 - 0 of 0 results

Services

About

Help and Advice

Phone

402-920-7001

Address

6901 Dodge St.
Suite 201
Omaha, NE 68132

fact@factglobal.org

Promoting quality patient care and
laboratory practice in cellular therapies

Principal
Members:

The Foundation for the Accreditation of Cellular Therapy.
All Rights Reserved.

Debugging Info

pagedictsize=32

sqltime = 0.010 s

cpu time = 0.180 s

real time = 0.197 s

memory increase = 12572 kB

fields = action: 'QMSeries'

templates =
/data/fact/current/fact_org/themes/www/store_header
/data/fact/current/generic/themes/www/mako/store/productSearchResults
scrapeAndDrape (CACHED) stub: https://test.factglobal.org/store (/data/fact/current/fact_org/cachedFiles//cachedStub___forms__store__CommercePlusFormPublic__search)

dg = ['searchProductCommercePlus', 'searchProductCommercePlus', 'searchProductCommercePlus'] | [30011, 30011, 30011]

extra debug info =
libs.framework.WebForm:fillCursor starting at 1765662493.030...
libs.framework.WebForm:fillCursor took 2.855 ms
libs.framework.WebForm:outputSearchResults starting at 1765662493.124...
libs.framework.WebForm:outputSearchResults took 79.521 ms

queries = 16 queries

Total Time	Count	Avg Time	Query
0.005	1 call 0 rows	0.005	COMMIT
0.002	1 call 0 rows	0.002	SELECT DISTINCT hex(`previousProduct`.`ProductId`) AS previousProduct___ProductId, `previousProduct`.`name` AS previousProduct___name, `previousProduct`.`ProductTypeId` AS previousProduct___ProductTypeId, `previousProduct`.`govRelations` AS previousProduct___govRelations, `previousProduct`.`training` AS previousProduct___training, `previousProduct`.`laborRelations` AS previousProduct___laborRelations, `previousProduct`.`MembersOnlyId` AS previousProduct___MembersOnlyId, `previousProduct`.`description` AS previousProduct___description, `previousProduct`.`size` AS previousProduct___size, `previousProduct`.`weight` AS previousProduct___weight, `previousProduct`.`year` AS previousProduct___year, `previousProduct`.`memberPrice` AS previousProduct___memberPrice, `previousProduct`.`nonMemberPrice` AS previousProduct___nonMemberPrice, `previousProduct`.`bookStorePrice` AS previousProduct___bookStorePrice, `previousProduct`.`governmentPrice` AS previousProduct___governmentPrice, `previousProduc...`.`shortDescription` AS previousProduct___shortDescription, `previousProduct`.`miniImageAltTag` AS previousProduct___miniImageAltTag, `previousProduct`.`isFeature` AS previousProduct___isFeature, `previousProduct`.`miniImage` AS previousProduct___miniImage, `previousProduct`.`isTaxable` AS previousProduct___isTaxable, `previousProduct`.`WebSiteDirectory` AS previousProduct___WebSiteDirectory, `previousProduct`.`WebSiteDirectoryURL` AS previousProduct___WebSiteDirectoryURL, `previousProduct`.`WebSiteExpirationDuration` AS previousProduct___WebSiteExpirationDuration, `previousProduct`.`WebSiteExpirationDate` AS previousProduct___WebSiteExpirationDate, `previousProduct`.`expirationDuration` AS previousProduct___expirationDuration, `previousProduct`.`activationStatus` AS previousProduct___activationStatus, `previousProduct`.`orderindex` AS previousProduct___orderindex, `previousProduct`.`mxxCreated` AS previousProduct___mxxCreated, `previousProduct`.`mxxUpdated` AS previousProduct___mxxUpdated, `previousProduct`.`recordOrigin` AS previousProduct___recordOrigin, `previousProduct`.`slug` AS previousProduct___slug, `previousProduct`.`specialNotes` AS previousProduct___specialNotes, `previousProduct`.`campaignCode` AS previousProduct___campaignCode, `previousProduct`.`originalImage` AS previousProduct___originalImage, `previousProduct`.`publishStartDate` AS previousProduct___publishStartDate, `previousProduct`.`publishEndDate` AS previousProduct___publishEndDate, `previousProduct`.`imageOverlayText` AS previousProduct___imageOverlayText, `previousProduct`.`embedCode` AS previousProduct___embedCode, `previousProduct`.`featuredExpirationDate` AS previousProduct___featuredExpirationDate, `previousProduct`.`externalContentLink` AS previousProduct___externalContentLink, hex(`reportingType`.`ReportingTypeId`) AS reportingType___ReportingTypeId, `reportingType`.`description` AS reportingType___description, `reportingType`.`orderindex` AS reportingType___orderindex, hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) left join `ReportingType` as reportingType on (`Product`.`reportingTypeId` = `reportingType`.`ReportingTypeId` ) left join `Product` as previousProduct on (`Product`.`PreviousProductId` = `previousProduct`.`ProductId` ) WHERE (`Product`.`ProductTypeId`=1 AND (`Product`.`publishStartDate`<='2025-12-13 16:48:13' AND (`Product`.`publishEndDate`>'2025-12-13 16:48:13' OR `Product`.`publishEndDate` is null))) ORDER BY ISNULL(Product.orderindex), Product.orderindex, Product.name
0.001	3 calls 1 row	0.000	SELECT version from databasemap;
0.001	1 call 13 rows	0.001	SELECT DISTINCT hex(`WebTab`.`WebTabId`) AS `WebTabId`, `WebTab`.`name`, `WebTab`.`link`, `WebTab`.`description`, hex(`WebTab`.`parent`) AS `parent`, `WebTab`.`requiredSetting`, `WebTab`.`defaultSubTab` FROM (WebTab) WHERE `WebTab`.`parent` is null ORDER BY `WebTab`.`WebTabId`
0.000	1 call 4 rows	0.000	SELECT DISTINCT hex(`WebTab`.`WebTabId`) AS `WebTabId`, `WebTab`.`name`, `WebTab`.`link`, `WebTab`.`description`, hex(`WebTab`.`parent`) AS `parent`, `WebTab`.`requiredSetting`, `WebTab`.`defaultSubTab` FROM (WebTab) WHERE `WebTab`.`parent`=0xA ORDER BY `WebTab`.`WebTabId`
0.000	1 call 158 rows	0.000	SELECT * FROM webselect
0.000	2 calls 1 row	0.000	SELECT hex(`MetaCompany`.`MetaCompanyId`) AS `MetaCompanyId`, `MetaCompany`.`storeFront`, `MetaCompany`.`howToOrder` FROM (MetaCompany)
0.000	1 call 0 rows	0.000	INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-13 16:48:13',`mxxCreatedBy`=NULL, `PageRequestId`=0x35278400000000, `path`='forms/store/CommercePlusFormPublic/search', `formName`='fact_CommercePlusFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='618781', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='419254', `startTime`='2025-12-13 16:48:13', `sessionId`=0x3965AA51C2491BF4, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'action\\':\\'QMSeries\\'}', `clientIPAddr`='216.73.216.211'
0.000	1 call 8 rows	0.000	SELECT * FROM ProductType ORDER BY orderindex, id
0.000	1 call 3 rows	0.000	SELECT * FROM PriceType ORDER BY orderindex, id
0.000	1 call 5 rows	0.000	SELECT * FROM ShipType ORDER BY orderindex, id
0.000	1 call 1 row	0.000	SELECT * FROM uuid FOR UPDATE
0.000	1 call 0 rows	0.000	START TRANSACTION

         366579 function calls (361072 primitive calls) in 0.466 seconds

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

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    0.467    0.467 /data/fact/current/libs/framework/WebManager.py:134(_newRequest)
        1    0.000    0.000    0.254    0.254 /data/fact/current/libs/framework/WebManager.py:88(createNewHandler)
        1    0.000    0.000    0.254    0.254 /data/fact/current/libs/framework/WebSite.py:91(__init__)
        1    0.000    0.000    0.200    0.200 /data/fact/current/libs/framework/WebSite.py:167(processRequest)
        1    0.000    0.000    0.177    0.177 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    0.177    0.177 /data/fact/current/generic/sites/www/forms/store/CommercePlusFormPublic.py:59(search)
        1    0.000    0.000    0.177    0.177 /data/fact/current/libs/framework/WebForm.py:1089(search)
        1    0.000    0.000    0.170    0.170 /data/fact/current/libs/framework/WebForm.py:1505(mungeResultsAfterSearch)
  328/149    0.004    0.000    0.146    0.001 {built-in method builtins.exec}
  193/123    0.001    0.000    0.146    0.001 :1165(_find_and_load)
  193/123    0.001    0.000    0.143    0.001 :1120(_find_and_load_unlocked)
  198/127    0.001    0.000    0.135    0.001 :666(_load_unlocked)
        1    0.005    0.005    0.132    0.132 /data/fact/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups)
  197/128    0.000    0.000    0.131    0.001 :934(exec_module)
  418/245    0.000    0.000    0.121    0.000 :233(_call_with_frames_removed)
        1    0.000    0.000    0.089    0.089 /data/fact/current/fact_org/sites/www/forms/store/fact_CommercePlusFormPublic.py:60(massageSearchResultsDictionary)
        1    0.000    0.000    0.089    0.089 /data/fact/current/generic/sites/www/forms/store/CommercePlusFormPublic.py:282(massageSearchResultsDictionary)
        5    0.000    0.000    0.088    0.018 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML)
        3    0.000    0.000    0.087    0.029 /data/fact/current/libs/PLayer/PersistentObject.py:2695(getCleanAttr)
        2    0.000    0.000    0.082    0.041 /data/fact/current/libs/utils/decoratorutils.py:282(wrapper)
        1    0.000    0.000    0.079    0.079 /data/fact/current/libs/framework/WebForm.py:1653(outputSearchResults)
        1    0.000    0.000    0.079    0.079 /data/fact/current/libs/framework/WebApp.py:276(writeHTMLWithWrap)
        1    0.000    0.000    0.078    0.078 /data/fact/current/libs/framework/WebApp.py:212(wrapHTML)
        2    0.001    0.000    0.076    0.038 /data/fact/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML)
        1    0.000    0.000    0.076    0.076 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize)
3231/2849    0.002    0.000    0.075    0.000 /data/fact/current/libs/framework/BaseHandler.py:1471(mxxImporter)
        8    0.005    0.001    0.074    0.009 /data/fact/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile)
3255/2854    0.003    0.000    0.074    0.000 {built-in method builtins.__import__}
       60    0.001    0.000    0.072    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       54    0.000    0.000    0.072    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
       38    0.000    0.000    0.070    0.002 /usr/lib/python3.11/re/_compiler.py:740(compile)
        8    0.055    0.007    0.070    0.009 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML)
       38    0.000    0.000    0.051    0.001 /usr/lib/python3.11/re/_compiler.py:573(_code)
     5125    0.046    0.000    0.048    0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__)
        1    0.000    0.000    0.044    0.044 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    0.043    0.043 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker)
    58/40    0.000    0.000    0.043    0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:77(__new__)
      111    0.041    0.000    0.042    0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)
        1    0.000    0.000    0.042    0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
        1    0.011    0.011    0.039    0.039 /data/fact/current/libs/PLayer/PersistentBroker.py:441(retrieveClassMaps)
        1    0.000    0.000    0.038    0.038 /data/fact/current/libs/framework/DGEEmail.py:1()
        1    0.000    0.000    0.035    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1()
        1    0.000    0.000    0.035    0.035 /data/fact/current/libs/framework/baseScrapeAndDrape.py:272(scrape)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1()
        1    0.000    0.000    0.034    0.034 /data/fact/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache)
        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/fact/current/libs/framework/baseScrapeAndDrape.py:718(process)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1()
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
        1    0.000    0.000    0.033    0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1()
   787/38    0.004    0.000    0.033    0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        1    0.000    0.000    0.033    0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
        1    0.000    0.000    0.032    0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
        1    0.001    0.001    0.032    0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
  333/293    0.000    0.000    0.032    0.000 :1207(_handle_fromlist)
       29    0.000    0.000    0.030    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       29    0.000    0.000    0.030    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
      197    0.001    0.000    0.025    0.000 :1007(get_code)
        4    0.000    0.000    0.024    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean)
        3    0.000    0.000    0.022    0.007 /data/fact/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS)
        8    0.022    0.003    0.022    0.003 /data/fact/current/libs/utils/htmlTools.py:53(init)
       29    0.000    0.000    0.020    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       29    0.020    0.001    0.020    0.001 {function Connection.query at 0xf0d1bb4b5580}
       38    0.000    0.000    0.019    0.001 /usr/lib/python3.11/re/_parser.py:979(parse)
   116/38    0.001    0.000    0.019    0.000 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)
   710/38    0.007    0.000    0.019    0.000 /usr/lib/python3.11/re/_parser.py:516(_parse)
       38    0.000    0.000    0.018    0.000 /usr/lib/python3.11/re/_compiler.py:511(_compile_info)
        1    0.000    0.000    0.016    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()
      192    0.002    0.000    0.015    0.000 :1054(_find_spec)
        4    0.000    0.000    0.015    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__)
     8635    0.007    0.000    0.015    0.000 /data/fact/current/libs/utils/maxxConfigHelper.py:39(_extractSetting)
  265/264    0.005    0.000    0.014    0.000 {built-in method builtins.__build_class__}
        4    0.000    0.000    0.014    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__)
      197    0.001    0.000    0.014    0.000 :727(_compile_bytecode)
        4    0.000    0.000    0.014    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__)
       10    0.000    0.000    0.014    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all)
       10    0.002    0.000    0.014    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all)
      828    0.002    0.000    0.013    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
      197    0.013    0.000    0.013    0.000 {built-in method marshal.loads}
       10    0.000    0.000    0.013    0.001 /data/fact/current/libs/framework/BaseHandler.py:1340(importModule)
        4    0.000    0.000    0.013    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder)
        8    0.000    0.000    0.013    0.002 /data/fact/current/libs/framework/WebSite.py:1133(_loadModule)
      192    0.000    0.000    0.012    0.000 :1499(find_spec)
      192    0.001    0.000    0.012    0.000 :1467(_get_spec)
        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()
        1    0.000    0.000    0.011    0.011 /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()
        2    0.000    0.000    0.011    0.006 /data/fact/current/libs/framework/baseScrapeAndDrape.py:378(getElm)
        2    0.000    0.000    0.011    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
        2    0.000    0.000    0.011    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
        8    0.000    0.000    0.011    0.001 /usr/lib/python3.11/imp.py:220(load_module)
        8    0.000    0.000    0.011    0.001 /usr/lib/python3.11/imp.py:166(load_source)
        8    0.000    0.000    0.011    0.001 :711(_load)
        2    0.000    0.000    0.011    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
        2    0.000    0.000    0.011    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
        2    0.000    0.000    0.011    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
      238    0.002    0.000    0.010    0.000 :1607(find_spec)
     3194    0.003    0.000    0.010    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search)