Debugging Info
pagedictsize=0
sqltime = 0.075 s
cpu time = 0.390 s
real time = 0.815 s
memory increase = 14068 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/webform/searchProduct
scrapeAndDrape FRESH stub: http://test.factglobal.org/store
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 27 queries

Total TimeCountAvg TimeQuery
0.0152 calls
0 rows
0.008 SELECT hex(Category.CategoryId) AS CategoryId, Category.description, hex(Category.ParentCategoryId) AS ParentCategoryId FROM (Category) ORDER BY Category.description
0.0131 call
4 rows
0.013 SELECT * FROM Language ORDER BY orderindex, id
0.0114 calls
17 rows
0.003 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.0091 call
13 rows
0.009 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.0081 call
0 rows
0.008 COMMIT
0.0081 call
4 rows
0.008 SELECT * FROM ShipType ORDER BY orderindex, id
0.0061 call
0 rows
0.006 INSERT INTO PageRequest SET mxxCreated='2025-05-09 07:50:21',mxxCreatedBy=NULL, PageRequestId=0x21122C00000000, path='forms/store/ProductFormPublic/', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='269486', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='80334', startTime='2025-05-09 07:50:21', sessionId=0x332B20FF5E3778F5, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='13.58.170.28'
0.00211 calls
1 row
0.000 SELECT version from databasemap;
0.0021 call
1 row
0.002 SELECT * FROM uuid FOR UPDATE
0.0021 call
8 rows
0.002 SELECT * FROM ProductType ORDER BY orderindex, id
0.0011 call
158 rows
0.001 SELECT * FROM webselect
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.0001 call
0 rows
0.000 START TRANSACTION