My ACSA

Debugging Info
pagedictsize=0
sqltime = 0.011 s
cpu time = 1.030 s
real time = 7.994 s
memory increase = 20760 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 = 34 queries

Total TimeCountAvg TimeQuery
0.0031 call
0 rows
0.003 COMMIT
0.0032 calls
112 rows
0.002 SELECT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category) ORDER BY `Category`.`description`
0.0024 calls
16 rows
0.001 SELECT DISTINCT year FROM Product WHERE year IS NOT NULL ORDER BY year DESC
0.0021 call
8 rows
0.002 SELECT * FROM ProductType ORDER BY orderindex, id
0.00210 calls
1 row
0.000 SELECT version from databasemap;
0.0021 call
4 rows
0.002 SELECT * FROM Language ORDER BY orderindex, id
0.0001 call
167 rows
0.000 SELECT * FROM webselect
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-14 16:19:17',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C8D9600000004, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='5', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:19:17', `sessionId`=0x35867B18B64F5617, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.00032258033752441406', `timeTaken`='0', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/conference/2023-acsa-eaae-teachers-conference/\\'}', `clientIPAddr`='216.73.216.172' WHERE `PageRequestId`=0x8C8D9600000004
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:12:37',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000002, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:12:37', `sessionId`=0x7C22CA42883E005C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2022-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:19:17',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000004, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='5', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:19:17', `sessionId`=0x35867B18B64F5617, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/conference/2023-acsa-eaae-teachers-conference/\\'}', `clientIPAddr`='216.73.216.172'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:10:15',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:10:15', `sessionId`=0x61F13AD5A41E632A, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2021-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172'
0.0001 call
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-14 16:10:15',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C8D9600000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='1', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:10:15', `sessionId`=0x61F13AD5A41E632A, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0041425228118896484', `timeTaken`='1', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2021-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172' WHERE `PageRequestId`=0x8C8D9600000000
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:18:27',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000003, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:18:27', `sessionId`=0x61EEC30A80C2ABB1, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/programs-and-events/webinars/\\'}', `clientIPAddr`='216.73.216.172'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-14 16:12:37',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C8D9600000002, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='3', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:12:37', `sessionId`=0x7C22CA42883E005C, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.000339508056640625', `timeTaken`='1', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2022-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172' WHERE `PageRequestId`=0x8C8D9600000002
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:20:51',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000005, `path`='forms/store/ProductFormPublic/', `formName`='ProductFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='6', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:20:51', `sessionId`=0x211EAAD2843B12BA, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.172'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-14 16:12:36',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C8D9600000001, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='2', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:12:36', `sessionId`=0x735151EDF5B8F314, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.00024890899658203125', `timeTaken`='0', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2023-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172' WHERE `PageRequestId`=0x8C8D9600000001
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-14 16:18:27',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C8D9600000003, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='4', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:18:27', `sessionId`=0x61EEC30A80C2ABB1, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0002903938293457031', `timeTaken`='0', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/programs-and-events/webinars/\\'}', `clientIPAddr`='216.73.216.172' WHERE `PageRequestId`=0x8C8D9600000003
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-14 16:12:36',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C8D9600000001, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1520712', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='390834', `startTime`='2026-04-14 16:12:36', `sessionId`=0x735151EDF5B8F314, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/competitions/2023-steel-competition/winners/\\'}', `clientIPAddr`='216.73.216.172'
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION