Debugging Info
pagedictsize=0
sqltime = 0.017 s
cpu time = 0.400 s
real time = 0.819 s
memory increase = 14076 kB
fields =
templates =
/data/fact/current/fact_org/themes/www/store_header
/data/fact/current/generic/themes/shared/dgelements/checkbox
/data/fact/current/generic/themes/shared/dgelements/checkboxes
/data/fact/current/generic/themes/shared/dgelements/input
/data/fact/current/generic/themes/shared/dgelements/radioLinear
/data/fact/current/generic/themes/shared/dgelements/select
/data/fact/current/generic/themes/shared/dgelements/table
/data/fact/current/generic/themes/shared/dgelements/view
/data/fact/current/generic/themes/www/mako/store/searchProduct
scrapeAndDrape FRESH stub: https://test.factglobal.org/store
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 27 queries

Total TimeCountAvg TimeQuery
0.0054 calls
18 rows
0.001 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.0031 call
0 rows
0.003 COMMIT
0.00311 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
0 rows
0.001 START TRANSACTION
0.0012 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.0011 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.0011 call
4 rows
0.001 SELECT * FROM Language ORDER BY orderindex, id
0.0011 call
8 rows
0.001 SELECT * FROM ProductType ORDER BY orderindex, id
0.0011 call
158 rows
0.001 SELECT * FROM webselect
0.0011 call
4 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`=0xA ORDER BY `WebTab`.`WebTabId`
0.0001 call
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-13 16:47:29',`mxxCreatedBy`=NULL, `PageRequestId`=0x35278200000000, `path`='forms/store/ProductFormPublic/', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='618742', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='419242', `startTime`='2025-12-13 16:47:29', `sessionId`=0x2C8684FF65E97AC0, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.211'
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE