Debugging Info
pagedictsize=698
sqltime = 0.007 s
cpu time = 0.260 s
real time = 0.536 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: http://test.factglobal.org/store
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 19 queries

Total TimeCountAvg TimeQuery
0.0044 calls
17 rows
0.001 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.0016 calls
1 row
0.000 SELECT version from databasemap;
0.0001 call
13 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` is null ORDER BY `WebTab`.`WebTabId`
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-08-17 15:05:52',`mxxUpdatedBy`=NULL, `PageRequestId`=0x22B02E00000000, `path`='forms/store/ProductFormPublic/wmda-netcord-webinar-cb-outcome-data', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='2157106', `requestNum`='1', `growth`='15360', `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='226683', `startTime`='2025-08-17 15:05:51', `sessionId`=0xAE695B627D14B28, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0503382682800293', `timeTaken`='56', `dictSize`='698', `fields`='{}', `clientIPAddr`='216.73.216.186' WHERE `PageRequestId`=0x22B02E00000000
0.0001 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.0002 calls
0 rows
0.000 SELECT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category) ORDER BY `Category`.`description`
0.0001 call
8 rows
0.000 SELECT * FROM ProductType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-17 15:05:52',`mxxCreatedBy`=NULL, `PageRequestId`=0x22B02E0000001C, `path`='forms/store/ProductFormPublic/', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='2157106', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='226683', `startTime`='2025-08-17 15:05:52', `sessionId`=0xAE695B627D14B28, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.186'
0.0001 call
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
4 rows
0.000 SELECT * FROM Language ORDER BY orderindex, id