Sort
Filters
Back To Top
Total execution time: 0.5238s
{
"ENV" : {
"HTTPS" : "0",
"DOCUMENT_ROOT" : "/localdata/sites/wendy.macpac1.com/web",
"REDIRECT_STATUS" : "200",
"SERVER_SOFTWARE" : "nginx/1.14.1",
"USING_HTTP" : "",
"HTTP_VIA" : "1.1 squid-proxy-5b96dc6d46-f69mq (squid/6.13)",
"DOCUMENT_URI" : "/category.html",
"GATEWAY_INTERFACE" : "CGI/1.1",
"HTTP_CACHE_CONTROL" : "max-age=0",
"SERVER_PORT" : "80",
"CONTENT_TYPE" : "",
"REQUEST_METHOD" : "GET",
"SERVER_ADDR" : "192.168.1.107",
"SCRIPT_FILENAME" : "/localdata/sites/wendy.macpac1.com/web/category.html",
"HTTP_ACCEPT_ENCODING" : "gzip, br, zstd, deflate",
"FCGI_ROLE" : "RESPONDER",
"HTTP_X_FORWARDED_FOR" : "10.8.134.100",
"HTTP_CONNECTION" : "keep-alive",
"QUERY_STRING" : "cat=72&productShowOnly=All",
"REMOTE_PORT" : "11144",
"REMOTE_ADDR" : "216.73.216.53",
"REQUEST_SCHEME" : "http",
"CONTENT_LENGTH" : "",
"HTTP_HOST" : "macpac1.com",
"SERVER_PROTOCOL" : "HTTP/1.1",
"SERVER_NAME" : "macpac1.com",
"HTTP_USER_AGENT" : "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)",
"REQUEST_URI" : "/category.html?cat=72&productShowOnly=All",
"HTTP_ACCEPT" : "*/*",
"SCRIPT_NAME" : "/category.html"
},
"FindPriceSHA" : "302644086f7519ec81935021ec01b55c365e9e76",
"afterHTML" : [
"",
"Total execution time: 0.5238s"
],
"apache_conf_path" : "/localdata/sites/wendy.macpac1.com/wendy.macpac1.com.include",
"base_path" : "/localdata/sites/wendy.macpac1.com",
"cart" : {
"itemCount" : 0,
"items" : {}
},
"cgi" : null,
"cookies" : {
"session" : "0x61426CEC5B8711F19625E9D58BEBA80B"
},
"db_host" : "lucky13",
"db_macpac" : "macpac",
"db_pass" : "wert",
"db_user" : "macpac",
"debug" : 0,
"debugStartupTime" : 1780077243.56384,
"domains" : {
"macpac.savageresearch.com" : {
"testing" : "ALLOW_WB500"
},
"macpac1.com" : {
"requireHTTPS" : 0
},
"mp1.savageresearch.com" : {
"redirect" : 1
},
"test.macpac1.com" : {
"testing" : "ALLOW_WB500"
},
"wb500.macpac1.com" : {
"testing" : "ALLOW_WB500"
},
"wendy.macpac1.com" : {
"redirect" : 1
},
"wendy.savageresearch.com" : {
"redirect" : 1
},
"www.macpac1.com" : {
"redirect" : 1
}
},
"enable_recaptcha" : true,
"errors" : [],
"file_prefix" : "",
"firstPage" : "/custHome.html",
"forceShowParams" : 0,
"form" : {
"cat" : "72",
"forceShowParams" : 1,
"productShowOnly" : "All"
},
"form_array" : {
"cat" : [
"72"
],
"productShowOnly" : [
"All"
]
},
"glob" : {
"catthumbnailPrefix" : "https://macpac1.com/catalogImages",
"contactusTo" : "macmurraymail@gmail.com",
"contactusToName" : "MacMurray Pacific",
"emailErrorsTo" : "tcadell@gmail.com",
"emailErrorsToName" : "Tim Cadell",
"emailFrom" : "macpac@macpac1.com",
"emailFromName" : "MacMurray Pacific",
"emailMask" : null,
"emailServer" : "localhost",
"include_cart" : 1,
"menu" : "",
"now" : 1780077243,
"pageColor" : "white",
"prettyDateFmt" : "%m/%d/%Y",
"salesOrderCount" : 0,
"thumbnailPrefix" : "https://macpac1.com/products",
"title" : "",
"todayDB" : "2026-05-29 10:54:03",
"todayPretty" : "05/29/2026",
"todayYYYY_MM_DD" : "2026-05-29",
"topTitle" : "MacMurray Pacific",
"webmasterEmail" : "macpac@megapathdsl.net"
},
"homePage" : "/index.html",
"isMobile" : 0,
"legacyStatus" : 1,
"logs" : "logs",
"macpacDbh" : null,
"master" : [],
"messages" : [],
"metatagKeywords" : "MacMurray Pacific,hardware,wholesale,builder,furniture,kitchen,bath,drawer,sash,clamp,router,tape,cabinet,hinge,hinges,bit,bits,bolts,deadbolt,deadbolts,lock,locks,knob,knobs,latch,latches,lever,mailplate,mortise,molding,hasp,catch,sawblade,saw,edging,putty,screw,caster,wheel,glue",
"my_redis" : null,
"mysql_time_mask" : "%Y-%m-%d %H:%M:%S",
"pageType" : "html",
"queries" : [
{
"args" : [],
"duration" : "0.0003s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.565,
"query" : "SELECT * FROM System",
"rows" : "1",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.56474,
"type" : "mysql"
},
{
"args" : [
"72"
],
"duration" : "0.0003s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.58081,
"query" : "SELECT * FROM ProductTypes WHERE id = ?",
"rows" : "1",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.5805,
"type" : "mysql"
},
{
"args" : [
null,
"FavoritesAge"
],
"duration" : "0.0001s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.581,
"query" : "SELECT * FROM CustomerOptions WHERE CustomerID = ? AND optionName = ?",
"rows" : "0",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.58087,
"type" : "mysql"
},
{
"args" : [
null,
null
],
"duration" : "0.0001s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.58116,
"query" : "SELECT * FROM Cart WHERE CustomerID = ? AND userCode = ? AND isActive = 1 AND quoteStatus = 0",
"rows" : "0",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.58105,
"type" : "mysql"
},
{
"args" : [
null,
null,
null,
"72"
],
"duration" : "0.1766s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.75788,
"query" : "SELECT SQL_CALC_FOUND_ROWS p.*, ci.Qty, w.Description, w.Cat_Description, pi.filename, IF(vm.hide, 'Misc', v.VendorName) AS VendorName, v.Buyer, vm.hide, IF(sl.DateAdded IS NULL, 0, 1) AS shoppingList, IF(f.dateAdded IS NULL, 0, 1) AS Favorite, CONCAT(pt.type, ' / ', pt.subtype) AS pt_type_subtype, pm.youtubeCode, IF(v.ShowPrices = 'Y' AND p.ShowPrices = 'Y', 1, 0) AS ShowPR FROM Products p LEFT JOIN shoppingList sl ON (p.ProductCode = sl.ProductCode AND sl.CustomerID = ?) LEFT JOIN Favorites f ON (p.ProductCode = f.ProductCode AND f.CustomerID = ?) JOIN WebProduct w ON (p.ProductCode = w.ProductCode) LEFT JOIN ProductImages pi ON (p.ProductCode = pi.ProductCode) LEFT JOIN ProductTypes pt ON (w.pt_rowid = pt.id) JOIN Vendor v ON (p.VendorCode = v.VendorCode) LEFT JOIN VendorMore vm ON (p.VendorCode = vm.VendorCode) LEFT JOIN WebProductKeys wpks ON (p.ProductCode = wpks.ProductCode) LEFT JOIN CartItems ci ON (p.ProductCode = ci.ProductCode AND ci.CartID = ?) LEFT JOIN ProductMore pm ON (p.ProductCode = pm.ProductCode) WHERE w.pt_rowid = ? GROUP BY p.ProductCode ORDER BY p.statusFlag, p.ProductCode LIMIT 0,10",
"rows" : "10",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.58129,
"type" : "mysql"
},
{
"countRequest" : 10,
"countResponse" : 10,
"duration" : "0.0015s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.75981,
"request" : {
"CustPriceCategory" : 0,
"CustomerID" : 0,
"CustomerTypeCode" : "0",
"Today" : "2026-05-29",
"debug" : 1,
"explanation" : {
"5000-102 MR" : [],
"5000-150 MR" : [],
"5002-050" : [],
"5002-102" : [],
"5002-112" : [],
"5002-260" : [],
"5004-003" : [],
"5006-102" : [],
"5006-260" : [],
"5013-102 MR" : []
},
"rows" : [
{
"AllowBrokenBox" : " ",
"AverageCost" : 59.38,
"CategoryCode" : 35,
"CurrentCost" : 128.77,
"PerBox" : 1,
"Price" : 317.96,
"PricingCategory" : 2,
"ProductCode" : "5000-102 MR",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 51.59,
"CategoryCode" : 35,
"CurrentCost" : 118,
"PerBox" : 1,
"Price" : 291.37,
"PricingCategory" : 2,
"ProductCode" : "5000-150 MR",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 14.49,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5002-050",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 24.11,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5002-102",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 14.74,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5002-112",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 21.29,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5002-260",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 24.57,
"CategoryCode" : 35,
"CurrentCost" : 49,
"PerBox" : 1,
"Price" : 120.99,
"PricingCategory" : 2,
"ProductCode" : "5004-003",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 21.68,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5006-102",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 13.1,
"CategoryCode" : 35,
"CurrentCost" : 41.71,
"PerBox" : 1,
"Price" : 102.99,
"PricingCategory" : 2,
"ProductCode" : "5006-260",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
},
{
"AllowBrokenBox" : " ",
"AverageCost" : 46.88,
"CategoryCode" : 35,
"CurrentCost" : 128.77,
"PerBox" : 1,
"Price" : 317.96,
"PricingCategory" : 2,
"ProductCode" : "5013-102 MR",
"Qty" : 1,
"ShowPR" : 1,
"VendorCode" : 1020
}
]
},
"response" : [
{
"CalculatedPrice" : 317.96,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5000-102 MR",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 291.37,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5000-150 MR",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5002-050",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5002-102",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5002-112",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5002-260",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 120.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5004-003",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5006-102",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 102.99,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5006-260",
"Qty" : 1,
"rules" : {}
},
{
"CalculatedPrice" : 317.96,
"CalculatedPriceBasedOn" : "ListPrice",
"PricingMatrixRule" : 0,
"ProductCode" : "5013-102 MR",
"Qty" : 1,
"rules" : {}
}
],
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.7583,
"type" : "redis"
},
{
"args" : [],
"duration" : "0.0003s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.76023,
"query" : "SELECT FOUND_ROWS() AS count",
"rows" : "1",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.75992,
"type" : "mysql"
},
{
"args" : [
null,
"5000-102 MR",
"5000-150 MR",
"5002-050",
"5002-102",
"5002-112",
"5002-260",
"5004-003",
"5006-102",
"5006-260",
"5013-102 MR"
],
"duration" : "0.0006s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.76091,
"query" : "SELECT ProductCode, MAX(Date) AS LastOrderedDate, SUM(QuantitySold) AS QtyOrderedInPast, COUNT(*) AS TimesOrdered FROM Trans WHERE Date > NOW() - INTERVAL 24 MONTH AND CustomerID IN (?) AND ProductCode IN (?,?,?,?,?,?,?,?,?,?) GROUP BY ProductCode",
"rows" : "0",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.76033,
"type" : "mysql"
},
{
"args" : [
null,
null,
null,
"72"
],
"duration" : "0.0823s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.84331,
"query" : "SELECT DISTINCT v.*, vm.hide FROM Products p LEFT JOIN shoppingList sl ON (p.ProductCode = sl.ProductCode AND sl.CustomerID = ?) LEFT JOIN Favorites f ON (p.ProductCode = f.ProductCode AND f.CustomerID = ?) JOIN WebProduct w ON (p.ProductCode = w.ProductCode) LEFT JOIN ProductImages pi ON (p.ProductCode = pi.ProductCode) LEFT JOIN ProductTypes pt ON (w.pt_rowid = pt.id) JOIN Vendor v ON (p.VendorCode = v.VendorCode) LEFT JOIN VendorMore vm ON (p.VendorCode = vm.VendorCode) LEFT JOIN WebProductKeys wpks ON (p.ProductCode = wpks.ProductCode) LEFT JOIN CartItems ci ON (p.ProductCode = ci.ProductCode AND ci.CartID = ?) LEFT JOIN ProductMore pm ON (p.ProductCode = pm.ProductCode) WHERE w.pt_rowid = ? ORDER BY v.VendorName",
"rows" : "3",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.76102,
"type" : "mysql"
},
{
"args" : [
null,
null,
null,
"72"
],
"duration" : "0.1010s",
"endTime" : "2026-05-29 10:54:03",
"end_ts" : 1780077243.94443,
"query" : "SELECT wpk.KeyValue, wpk.Value FROM Products p LEFT JOIN shoppingList sl ON (p.ProductCode = sl.ProductCode AND sl.CustomerID = ?) LEFT JOIN Favorites f ON (p.ProductCode = f.ProductCode AND f.CustomerID = ?) JOIN WebProduct w ON (p.ProductCode = w.ProductCode) LEFT JOIN ProductImages pi ON (p.ProductCode = pi.ProductCode) LEFT JOIN ProductTypes pt ON (w.pt_rowid = pt.id) JOIN Vendor v ON (p.VendorCode = v.VendorCode) LEFT JOIN VendorMore vm ON (p.VendorCode = vm.VendorCode) LEFT JOIN WebProductKeys wpks ON (p.ProductCode = wpks.ProductCode) LEFT JOIN CartItems ci ON (p.ProductCode = ci.ProductCode AND ci.CartID = ?) LEFT JOIN ProductMore pm ON (p.ProductCode = pm.ProductCode) JOIN WebProductKeys wpk ON (p.ProductCode = wpk.ProductCode) WHERE w.pt_rowid = ? GROUP BY 1,2",
"rows" : "57",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.84339,
"type" : "mysql"
},
{
"args" : [
null
],
"duration" : "0.1111s",
"endTime" : "2026-05-29 10:54:04",
"end_ts" : 1780077244.05685,
"query" : "SELECT COUNT(*) AS count FROM SalesOrders WHERE CustomerID = ? AND endDate IS NULL",
"rows" : "1",
"startTime" : "2026-05-29 10:54:03",
"start_ts" : 1780077243.94575,
"type" : "mysql"
},
{
"args" : [
null,
null
],
"duration" : "0.0003s",
"endTime" : "2026-05-29 10:54:04",
"end_ts" : 1780077244.0572,
"query" : "SELECT a.QtyAvailable, a.ProductCode, a.Qty, a.QuotedPrice, a.SalesPrice, a.SpecialPriceFlag, a.Description, a.Cost, a.ExpectedDate, a.OrderQuantity, a.isKit, a.additional FROM CartItems AS a JOIN Cart AS c ON (a.CartID = c.CartID) WHERE c.CustomerID = ? AND c.userCode = ? AND c.isActive = 1 AND c.quoteStatus = 0 ORDER BY a.IndexNo",
"rows" : "0",
"startTime" : "2026-05-29 10:54:04",
"start_ts" : 1780077244.05695,
"type" : "mysql"
}
],
"queryDuration" : "0.4745s",
"r" : null,
"readCart" : 1,
"recaptcha_min" : 0.5,
"recaptcha_secret" : "6Ld0qMQoAAAAAPQkfrPleu1G6tpnztat4PsyuEyZ",
"recaptcha_site_key" : "6Ld0qMQoAAAAACjs6dGNPRLgCgxjWutnprWmSwhH",
"remoteip" : "216.73.216.53",
"require" : {
"admin" : 0,
"login" : 0,
"sales" : 0
},
"rows" : "0",
"session" : {
"breadcrumb" : [
[
"cat=72",
"Door Locks / Residential Locks"
]
],
"customerRow" : [],
"favoritesSince" : 12,
"isGuest" : 1,
"productShowOnly" : "All",
"productSortBy" : "ProductCode"
},
"sessionLoaded" : 1,
"showLadders" : 1,
"showParams" : 1,
"system" : {
"CartExpireLength" : 0,
"DatabaseVersion" : 26,
"DefaultProductPerPageCust" : -1,
"DefaultProductPerPageSales" : -1,
"ExpireLength" : 7200,
"FavoritesAge" : 12,
"ID" : 1,
"SalesZones" : 30,
"TableColor" : null,
"UnavailableMessage" : "",
"UnavailableTitle" : "",
"timeoutMessage" : "System unavailable for maintenance purposes. Please try again later."
},
"template" : null,
"templateVars" : {},
"template_path" : "templates",
"testEmails" : 0,
"upload_path" : "uploads",
"user" : {},
"userAgent" : "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
}