MacMurray Pacific Wholesale Hardware

{ "ENV" : { "REMOTE_PORT" : "11144", "REQUEST_SCHEME" : "http", "REMOTE_ADDR" : "216.73.216.53", "CONTENT_LENGTH" : "", "HTTP_HOST" : "macpac1.com", "HTTP_CONNECTION" : "keep-alive", "QUERY_STRING" : "cat=177&productShowOnly=All", "REQUEST_URI" : "/category.html?cat=177&productShowOnly=All", "HTTP_ACCEPT" : "*/*", "SCRIPT_NAME" : "/category.html", "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)", "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", "HTTPS" : "0", "REDIRECT_STATUS" : "200", "DOCUMENT_ROOT" : "/localdata/sites/wendy.macpac1.com/web", "SERVER_SOFTWARE" : "nginx/1.14.1", "FCGI_ROLE" : "RESPONDER", "HTTP_X_FORWARDED_FOR" : "10.8.134.100", "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" }, "FindPriceSHA" : "302644086f7519ec81935021ec01b55c365e9e76", "afterHTML" : [ "

", "

Total execution time: 0.4795s

" ], "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" : "0x8C667F9E5B8711F19625E9D58BEBA80B" }, "db_host" : "lucky13", "db_macpac" : "macpac", "db_pass" : "wert", "db_user" : "macpac", "debug" : 0, "debugStartupTime" : 1780077315.94283, "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" : "177", "forceShowParams" : 1, "productShowOnly" : "All" }, "form_array" : { "cat" : [ "177" ], "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" : 1780077315, "pageColor" : "white", "prettyDateFmt" : "%m/%d/%Y", "salesOrderCount" : 0, "thumbnailPrefix" : "https://macpac1.com/products", "title" : "", "todayDB" : "2026-05-29 10:55:15", "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.0002s", "endTime" : "2026-05-29 10:55:15", "end_ts" : 1780077315.9435, "query" : "SELECT * FROM System", "rows" : "1", "startTime" : "2026-05-29 10:55:15", "start_ts" : 1780077315.94333, "type" : "mysql" }, { "args" : [ "177" ], "duration" : "0.0002s", "endTime" : "2026-05-29 10:55:15", "end_ts" : 1780077315.95857, "query" : "SELECT * FROM ProductTypes WHERE id = ?", "rows" : "1", "startTime" : "2026-05-29 10:55:15", "start_ts" : 1780077315.95841, "type" : "mysql" }, { "args" : [ null, "FavoritesAge" ], "duration" : "0.0001s", "endTime" : "2026-05-29 10:55:15", "end_ts" : 1780077315.95873, "query" : "SELECT * FROM CustomerOptions WHERE CustomerID = ? AND optionName = ?", "rows" : "0", "startTime" : "2026-05-29 10:55:15", "start_ts" : 1780077315.95862, "type" : "mysql" }, { "args" : [ null, null ], "duration" : "0.0001s", "endTime" : "2026-05-29 10:55:15", "end_ts" : 1780077315.95888, "query" : "SELECT * FROM Cart WHERE CustomerID = ? AND userCode = ? AND isActive = 1 AND quoteStatus = 0", "rows" : "0", "startTime" : "2026-05-29 10:55:15", "start_ts" : 1780077315.95876, "type" : "mysql" }, { "args" : [ null, null, null, "177" ], "duration" : "0.1517s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.1106, "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:55:15", "start_ts" : 1780077315.95894, "type" : "mysql" }, { "countRequest" : 10, "countResponse" : 10, "duration" : "0.0027s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.11355, "request" : { "CustPriceCategory" : 0, "CustomerID" : 0, "CustomerTypeCode" : "0", "Today" : "2026-05-29", "debug" : 1, "explanation" : { "1A68F-21" : [], "1A88F-18" : [], "1A88F-21" : [], "522P" : [], "563.4570B" : [], "563.5330B" : [], "563H-9" : [], "563H3050B" : [], "563H3810B" : [], "563H4570B" : [] }, "rows" : [ { "AllowBrokenBox" : " ", "AverageCost" : 12.4, "CategoryCode" : 155, "CurrentCost" : 12.4, "PerBox" : 6, "Price" : 39.28, "PricingCategory" : 26, "ProductCode" : "1A68F-21", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 5135 }, { "AllowBrokenBox" : " ", "AverageCost" : 40.1, "CategoryCode" : 155, "CurrentCost" : 40.11, "PerBox" : 2, "Price" : 145.22, "PricingCategory" : 26, "ProductCode" : "1A88F-18", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 5135 }, { "AllowBrokenBox" : " ", "AverageCost" : 41.54, "CategoryCode" : 155, "CurrentCost" : 41.54, "PerBox" : 2, "Price" : 146.54, "PricingCategory" : 26, "ProductCode" : "1A88F-21", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 5135 }, { "AllowBrokenBox" : " ", "AverageCost" : 4.7, "CategoryCode" : 150, "CurrentCost" : 4.7, "PerBox" : 20, "Price" : 12.25, "PricingCategory" : 10, "ProductCode" : "522P", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 3320 }, { "AllowBrokenBox" : " ", "AverageCost" : 14.61, "CategoryCode" : 155, "CurrentCost" : 14.61, "PerBox" : 6, "Price" : 37.55, "PricingCategory" : 404, "ProductCode" : "563.4570B", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 5145 }, { "AllowBrokenBox" : " ", "AverageCost" : 15.11, "CategoryCode" : 155, "CurrentCost" : 15.11, "PerBox" : 6, "Price" : 38.84, "PricingCategory" : 404, "ProductCode" : "563.5330B", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 5145 }, { "AllowBrokenBox" : " ", "AverageCost" : 25.51, "CategoryCode" : 155, "CurrentCost" : 25.52, "PerBox" : 6, "Price" : 65.39, "PricingCategory" : 404, "ProductCode" : "563H-9", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 3555 }, { "AllowBrokenBox" : " ", "AverageCost" : 19.56, "CategoryCode" : 155, "CurrentCost" : 19.56, "PerBox" : 6, "Price" : 55.44, "PricingCategory" : 404, "ProductCode" : "563H3050B", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 3555 }, { "AllowBrokenBox" : " ", "AverageCost" : 19.18, "CategoryCode" : 155, "CurrentCost" : 19.56, "PerBox" : 6, "Price" : 55.44, "PricingCategory" : 404, "ProductCode" : "563H3810B", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 3555 }, { "AllowBrokenBox" : " ", "AverageCost" : 18.46, "CategoryCode" : 155, "CurrentCost" : 18.46, "PerBox" : 6, "Price" : 54.46, "PricingCategory" : 404, "ProductCode" : "563H4570B", "Qty" : 1, "ShowPR" : 1, "VendorCode" : 3555 } ] }, "response" : [ { "CalculatedPrice" : 39.28, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "1A68F-21", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 145.22, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "1A88F-18", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 146.54, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "1A88F-21", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 12.25, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "522P", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 37.55, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563.4570B", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 38.84, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563.5330B", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 65.39, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563H-9", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 55.44, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563H3050B", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 55.44, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563H3810B", "Qty" : 1, "rules" : {} }, { "CalculatedPrice" : 54.46, "CalculatedPriceBasedOn" : "ListPrice", "PricingMatrixRule" : 0, "ProductCode" : "563H4570B", "Qty" : 1, "rules" : {} } ], "startTime" : "2026-05-29 10:55:16", "start_ts" : 1780077316.11086, "type" : "redis" }, { "args" : [], "duration" : "0.0002s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.11385, "query" : "SELECT FOUND_ROWS() AS count", "rows" : "1", "startTime" : "2026-05-29 10:55:16", "start_ts" : 1780077316.11366, "type" : "mysql" }, { "args" : [ null, "1A68F-21", "1A88F-18", "1A88F-21", "522P", "563.4570B", "563.5330B", "563H-9", "563H3050B", "563H3810B", "563H4570B" ], "duration" : "0.0002s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.11408, "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:55:16", "start_ts" : 1780077316.11388, "type" : "mysql" }, { "args" : [ null, null, null, "177" ], "duration" : "0.0819s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.19603, "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" : "10", "startTime" : "2026-05-29 10:55:16", "start_ts" : 1780077316.11412, "type" : "mysql" }, { "args" : [ null, null, null, "177" ], "duration" : "0.0865s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.28266, "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" : "35", "startTime" : "2026-05-29 10:55:16", "start_ts" : 1780077316.19612, "type" : "mysql" }, { "args" : [ null ], "duration" : "0.1125s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.39617, "query" : "SELECT COUNT(*) AS count FROM SalesOrders WHERE CustomerID = ? AND endDate IS NULL", "rows" : "1", "startTime" : "2026-05-29 10:55:16", "start_ts" : 1780077316.28369, "type" : "mysql" }, { "args" : [ null, null ], "duration" : "0.0004s", "endTime" : "2026-05-29 10:55:16", "end_ts" : 1780077316.39682, "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:55:16", "start_ts" : 1780077316.39637, "type" : "mysql" } ], "queryDuration" : "0.4367s", "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=177", "Slides / Undermount Slides" ] ], "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)" }