Debugging Info
pagedictsize=625
sqltime = 0.021 s
cpu time = 0.320 s
real time = 0.709 s
memory increase = 0 kB
fields =
templates =
/data/fact/current/fact_org/themes/www/store_header
/data/fact/current/generic/themes/shared/dgelements/checkboxes
/data/fact/current/generic/themes/shared/dgelements/table
/data/fact/current/generic/themes/www/mako/store/searchProduct
scrapeAndDrape FRESH stub: https://test.factglobal.org/store
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 19 queries

Total TimeCountAvg TimeQuery
0.0114 calls
17 rows
0.003 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.0036 calls
1 row
0.001 SELECT version from databasemap;
0.0032 calls
0 rows
0.001 SELECT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category) ORDER BY `Category`.`description`
0.0021 call
13 rows
0.002 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.0021 call
4 rows
0.002 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.0011 call
8 rows
0.001 SELECT * FROM ProductType ORDER BY orderindex, id
0.0011 call
5 rows
0.001 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-10-16 14:54:59',`mxxUpdatedBy`=NULL, `PageRequestId`=0x23AD340000001A, `path`='forms/store/ProductFormPublic/completeing-fact-required-outcome-analyses', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='1090199', `requestNum`='2', `growth`='0', `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='674287', `startTime`='2025-10-16 14:54:58', `sessionId`=0x7286F45159D3225E, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03948020935058594', `timeTaken`='41', `dictSize`='625', `fields`='{}', `clientIPAddr`='216.73.216.214' WHERE `PageRequestId`=0x23AD340000001A
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-10-16 14:54:59',`mxxCreatedBy`=NULL, `PageRequestId`=0x23AD3400000034, `path`='forms/store/ProductFormPublic/', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='1090199', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='674287', `startTime`='2025-10-16 14:54:59', `sessionId`=0x7286F45159D3225E, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.214'
0.0001 call
4 rows
0.000 SELECT * FROM Language ORDER BY orderindex, id