Debugging Info
pagedictsize=0
sqltime = 0.019 s
cpu time = 0.400 s
real time = 0.746 s
memory increase = 14132 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: http://test.factglobal.org/store
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 27 queries

Total TimeCountAvg TimeQuery
0.0061 call
0 rows
0.006 COMMIT
0.0061 call
0 rows
0.006 INSERT INTO PageRequest SET mxxCreated='2025-07-01 07:53:31',mxxCreatedBy=NULL, PageRequestId=0x21E2D200000000, path='forms/store/ProductFormPublic/', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='2804914', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='418954', startTime='2025-07-01 07:53:31', sessionId=0x4982EAB56204BFCA, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.125'
0.0034 calls
17 rows
0.001 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.00211 calls
1 row
0.000 SELECT version from databasemap;
0.0001 call
158 rows
0.000 SELECT * FROM webselect
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
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
4 rows
0.000 SELECT * FROM Language ORDER BY orderindex, id
0.0001 call
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION