My ACSA

Debugging Info
pagedictsize=165
sqltime = 0.013 s
cpu time = 0.630 s
real time = 0.784 s
memory increase = 2352 kB
fields =
templates =
/data/acsa/current/generic/themes/shared/dgelements/checkbox
/data/acsa/current/generic/themes/shared/dgelements/checkboxes
/data/acsa/current/generic/themes/shared/dgelements/input
/data/acsa/current/generic/themes/shared/dgelements/radioLinear
/data/acsa/current/generic/themes/shared/dgelements/select
/data/acsa/current/generic/themes/shared/dgelements/table
/data/acsa/current/generic/themes/shared/dgelements/view
/data/acsa/current/generic/themes/www/mako/store/searchProduct
scrapeAndDrape FRESH stub: https://www.acsa.maxx.matrixdev.net/template-page
dg = ['searchProductPublic'] | [80049]
extra debug info =
queries = 21 queries

Total TimeCountAvg TimeQuery
0.0074 calls
16 rows
0.002 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.00310 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
8 rows
0.001 SELECT * FROM ProductType ORDER BY orderindex, id
0.0012 calls
112 rows
0.001 SELECT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category) ORDER BY `Category`.`description`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-11-05 17:20:19',`mxxCreatedBy`=NULL, `PageRequestId`=0x833F870000000B, `path`='forms/store/ProductFormPublic/', `formName`='ProductFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1379896', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='372021', `startTime`='2025-11-05 17:20:19', `sessionId`=0x2FCC82FBEEAB9442, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.40'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-11-05 17:20:16',`mxxUpdatedBy`=NULL, `PageRequestId`=0x833F8700000000, `path`='forms/store/CommercePlusFormPublic/search', `formName`='acsa_CommercePlusFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1379896', `requestNum`='1', `growth`='14100', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='372021', `startTime`='2025-11-05 17:20:16', `sessionId`=0x2FCC82FBEEAB9442, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.008517026901245117', `timeTaken`='29', `dictSize`='165', `fields`='{\\'action\\':\\'HowToOrder\\'}', `clientIPAddr`='216.73.216.40' WHERE `PageRequestId`=0x833F8700000000
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