Debugging Info
pagedictsize=372
sqltime = 0.219 s
cpu time = 0.330 s
real time = 0.933 s
memory increase = 15688 kB
fields = action: 'find'
pendingMemberList: '1'
templates =
/data/dsa/current/dsa_org/themes/www/webform/searchRSMemberPublic
/data/dsa/current/generic/themes/shared/dgelements/viewphunkyFone
scrapeAndDrape ATTEMPTED stub: https://www.dsa.maxx.matrixdev.net/scrape.axd?target=https://www.dsa.maxx.matrixdev.net/benefits/dsadirectory/list-of-members-stub
dg = ['searchMemberPublic', 'searchRSMemberPublic', 'searchRSMemberPublic'] | [-45937, -45938, -45938]
extra debug info =
libs.framework.WebForm:fillCursor starting at 1751298944.933...
libs.framework.WebForm:fillCursor took 125.935 ms
libs.framework.WebForm:outputSearchResults starting at 1751298945.193...
libs.framework.WebForm:outputSearchResults took 576.422 ms
queries = 58 queries

Total TimeCountAvg TimeQuery
0.1081 call
1 row
0.108 SELECT DISTINCT hex(researchContact.IndividualId) AS researchContact___IndividualId, researchContact.EthnicityId AS researchContact___EthnicityId, researchContact.firstName AS researchContact___firstName, researchContact.lastName AS researchContact___lastName, researchContact.prefix AS researchContact___prefix, researchContact.suffix AS researchContact___suffix, researchContact.title AS researchContact___title, researchContact.mxxUpdatedBy AS researchContact___mxxUpdatedBy, researchContact.enteredBy AS researchContact___enteredBy, researchContact.gender AS researchContact___gender, researchContact.SalaryId AS researchContact___SalaryId, researchContact.ssn AS researchContact___ssn, researchContact.middleInitial AS researchContact___middleInitial, researchContact.email AS researchContact___email, researchContact.alternateEmail AS researchContact___alternateEmail, researchContact.emailFromThirdPartyId AS researchContact___emailFromThirdPartyId, researchContact.mxxUpdated AS researchConta..., Company.firstNameHumanResources, Company.lastNameHumanResources, Company.firstNameInformationTechnology, Company.lastNameInformationTechnology, Company.firstNameInsurance, Company.lastNameInsurance, Company.firstNameInternational, Company.lastNameInternational, Company.firstNameLegalCounsel, Company.lastNameLegalCounsel, Company.firstNameManufacturing, Company.lastNameManufacturing, Company.firstNameMarketResearch, Company.lastNameMarketResearch, Company.firstNameMarketing, Company.lastNameMarketing, Company.firstNameMeetingsEvents, Company.lastNameMeetingsEvents, Company.firstNameRecognitionAwards, Company.lastNameRecognitionAwards, Company.firstNameSalesforceCommunications, Company.lastNameSalesforceCommunications, Company.firstNameSalesforceTraining, Company.lastNameSalesforceTraining, Company.participantGoldIdCard, Company.uploadFilename1, Company.uploadFilename2, Company.uploadFilename3, Company.uploadFileDesc1, Company.uploadFileDesc2, Company.uploadFileDesc3, Company.QPSurvey, Company.DTSurvey, Company.DTRespondent, Company.QPRespondent, Company.managementCompSurvey, Company.nationalSalesSurvey, Company.nationalPartyPlanSurvey, Company.operatingInformationSurvey, Company.showLogoOnSupplierDir, Company.additionalRosterSlots, Company.Video, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.congresspersonFor, Company.numFilledSlots, Company.codeOfEthicsCompliance, Company.emailForConsultantLeads, Company.codeOfEthicsParticipationYears, Company.codeOfEthicsParticipationSeal, Company.GORespondentName, Company.speakersBureauParticipant, Company.congressRep, Company.congressionalDistrict, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.embeddedVideo, Company.initialContactDate, Company.mostRecentContactDate, Company.companyMaterialsReceivedDate, Company.confirmationOfBuybackNotification, Company.linkToTradeshowInfo, Company.linkToTradeshowInfoText, Company.isSuperPACContributer, Company.superPACContributerNotes, Company.webSurveyParticipation, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.companyMaterialsInformation, Company.createdOnWWW, Company.mxxCreated, Company.supplierApptBooking, Company.foundingDate, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company) left join SizeCode as sizeCode on (Company.SizeCodeId = sizeCode.SizeCodeId ) left join Individual as keyContact on (Company.KeyContactId = keyContact.IndividualId ) left join Individual as billingContact on (Company.BillingContactId = billingContact.IndividualId ) left join Individual as directoryContact on (Company.DirectoryContactId = directoryContact.IndividualId ) left join Individual as codeResponsibilityOfficer on (Company.CodeResponsibilityOfficer = codeResponsibilityOfficer.IndividualId ) left join Individual as chiefLegalCounsel on (Company.ChiefLegalCounsel = chiefLegalCounsel.IndividualId ) left join Individual as fieldSalesPerson on (Company.FieldSalesPerson = fieldSalesPerson.IndividualId ) left join Individual as meetingProductionPerson on (Company.MeetingProductionPerson = meetingProductionPerson.IndividualId ) left join Individual as communicationPerson on (Company.CommunicationPerson = communicationPerson.IndividualId ) left join Individual as graphicsPerson on (Company.GraphicsPerson = graphicsPerson.IndividualId ) left join Individual as chiefExecutiveOfficer on (Company.chiefExecutiveOfficer = chiefExecutiveOfficer.IndividualId ) left join Individual as chairmanOfBoard on (Company.chairmanOfBoard = chairmanOfBoard.IndividualId ) left join Individual as governmentRelations on (Company.governmentRelations = governmentRelations.IndividualId ) left join Individual as researchContact on (Company.ResearchContact = researchContact.IndividualId ) WHERE (Company.CompanyId IN (8740258448658, 8740258456268) AND IFNULL(Company.silent, "2")=\'2\') ORDER BY Company.alphaSort, Company.name LIMIT 0, 200
0.0244 calls
4 rows
0.006 SELECT DISTINCT hex(Meeting.MeetingId) AS MeetingId, Meeting.name, Meeting.hostName, Meeting.description, Meeting.audienceDescription, Meeting.cosponsors, Meeting.includes, Meeting.attire, Meeting.cancellationPolicy, Meeting.thankYouText, Meeting.registrationStarts, Meeting.registrationEnds, Meeting.earlybirdCutoff, Meeting.onlineRegistrationsEnabled, Meeting.selectSessionsOnRegForm, Meeting.accountingCode, Meeting.maximumNumAttendees, Meeting.type, Meeting.showPublicSessionSearch, Meeting.allowSpouseReg, Meeting.continuingEdUnits, Meeting.mediaAllowed, Meeting.travelInfo, Meeting.hotelBlurb, Meeting.dateClosed, Meeting.showFeesOnPublicView, Meeting.showPublicSchedule, Meeting.calendarLinkType, Meeting.calendarBlurb, Meeting.retainedEarningsAcctCode, Meeting.enableHousing, Meeting.eventId, Meeting.staffNotificationEmail, Meeting.paymentInstructions, Meeting.staffCancellationEmail, Meeting.lowRoomTrigger, Meeting.continuingEdNumber, Meeting.enableRSVP, Meeting.micrositePath, Meeting.bgcolor, Meeting.accentColor, Meeting.tabTitleColor, Meeting.bodyTextColor, Meeting.linkTextColor, Meeting.rightNavTextColor, Meeting.fontTitleSize, Meeting.fontBodySize, Meeting.fontName, Meeting.navbarColor, Meeting.sidebarColor, Meeting.highlightedTabTextColor, Meeting.headlineColor, Meeting.highlightedTabColor, Meeting.inSiteAccentColor, Meeting.inSiteBodyTextColor, Meeting.inSiteHeadlineColor, Meeting.inSiteHighlightedTabColor, Meeting.inSiteHighlightedTabTextColor, Meeting.inSiteLinkTextColor, Meeting.inSiteNavbarColor, Meeting.inSiteRightNavTextColor, Meeting.inSiteSidebarColor, Meeting.inSiteTabTitleColor, Meeting.inSiteFontBodySize, Meeting.inSiteFontName, Meeting.inSiteFontTitleSize, Meeting.useBadges, Meeting.staffNotificationRevisitedEmail, Meeting.anticipatedRegistrations, Meeting._budgetedRevenue, Meeting.groupRegistrationOn, Meeting.allowPlaceholders, Meeting.feesPageTopText, Meeting.badgesPageTopText, Meeting.questionsPageTopText, Meeting.eventsPageTopText, Meeting.reviewPageTopText, Meeting.paymentPageTopText, Meeting.micrositeTemplate, Meeting.inSiteTemplate, Meeting.isWebinar, Meeting.housingPageTopText, Meeting.attendeesPageTopText, Meeting.shortCalDescription, Meeting.allowAddToCalendar, Meeting.campaignCode, Meeting.altDomain, Meeting.altScrapeAndDrapeURL, Meeting.recordOrigin, Meeting.additionalFeesPageTopText, Meeting.referralText, Meeting.hasReferrals, Meeting.wwwRegistrationsEditAlwaysApprove, Meeting.thankYouFullyPaidText, Meeting.venue, Meeting.sendToLMS, Meeting.showSponsorLogos, Meeting.confSponsorText, Meeting.isArchived FROM (Meeting) WHERE Meeting.altDomain is not null ORDER BY mxxCreated
0.0131 call
0 rows
0.013 SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (Company, File) WHERE Company.supplierBannerFileId=File.FileId AND Company.CompanyId=0x8CBA1100000001
0.0071 call
0 rows
0.007 COMMIT
0.0071 call
6 rows
0.007 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x7F300000533 ORDER BY Address.zip
0.0061 call
1 row
0.006 SELECT DISTINCT hex(Company.CompanyId) AS CompanyId FROM (Company, Membership) WHERE (Company.MembershipId=Membership.MembershipId AND ((Company.MembershipId=Membership.MembershipId AND Membership.status=1) AND Membership.MembershipTypeId=2)) ORDER BY Company.alphaSort, Company.name
0.0061 call
0 rows
0.006 SELECT DISTINCT hex(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0x7F300000512
0.0051 call
0 rows
0.005 INSERT INTO PageRequest SET mxxCreated='2025-06-30 11:55:44',mxxCreatedBy=NULL, PageRequestId=0x8CBA1100000000, path='forms/CompanyFormPublicMembers/search', formName='dsa_CompanyFormPublicMembers', site='www', clientAcronym='DSA', pid='2684273', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.dsa.maxx.matrixdev.net', dbThreadId='362125', startTime='2025-06-30 11:55:44', sessionId=0x248FBAC95F365232, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'action\\':\\'find\\', \\'pendingMemberList\\':\\'1\\'}', clientIPAddr='216.73.216.179'
0.0041 call
1 row
0.004 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Branch.primaryAddressId=Address.AddressId AND Branch.BranchId=0x7F300000533 ORDER BY Address.zip
0.0041 call
3 rows
0.004 SELECT DISTINCT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Company, Company2Service, Service) WHERE (0x7F300000512=Company.CompanyId AND Company.CompanyId=Company2Service.CompanyId AND Company2Service.ServiceId=Service.ServiceId) ORDER BY orderindex
0.0041 call
1 row
0.004 SELECT DISTINCT hex(Company.CompanyId) AS CompanyId FROM (Relationship, Company) WHERE ((Company.CompanyId=Relationship.childCompanyId AND Relationship.parentCompanyId in (8740258448658)) AND Relationship.relationType IN (1, 2, 20)) ORDER BY Company.alphaSort, Company.name
0.0031 call
1 row
0.003 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x7F300000512 ORDER BY Branch.isMain, Branch.name
0.0031 call
1 row
0.003 SELECT DISTINCT hex(Website.WebsiteId) AS WebsiteId, Website.description, Website.address FROM (Company, Website) WHERE Website.CompanyId=Company.CompanyId AND Company.CompanyId=0x7F300000512
0.00311 calls
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0032 calls
54 rows
0.001 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0021 call
244 rows
0.002 SELECT * FROM Country ORDER BY orderindex, id
0.0021 call
4 rows
0.002 SELECT * FROM MinorityType ORDER BY orderindex, id
0.0021 call
1 row
0.002 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x6C14610000000A AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0021 call
4 rows
0.002 SELECT * FROM CompanyStatus ORDER BY orderindex, id
0.0011 call
1 row
0.001 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x922F00000026 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0012 calls
3 rows
0.001 SELECT * FROM SalesStrategy ORDER BY orderindex, id
0.0011 call
1 row
0.001 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x86575000005F9 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0012 calls
2 rows
0.001 SELECT * FROM CompensationPlan ORDER BY orderindex, id
0.0011 call
11 rows
0.001 SELECT * FROM SocialNetwork ORDER BY orderindex, id
0.0011 call
1 row
0.001 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Branch.directoryAddressId=Address.AddressId AND Branch.BranchId=0x7F300000533 ORDER BY Address.zip
0.0014 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(Relationship.RelationshipId) AS RelationshipId, Relationship.relationType FROM (Relationship, Company) WHERE Relationship.childCompanyId=Company.CompanyId AND Company.CompanyId=0x7F300000512
0.0011 call
158 rows
0.001 SELECT * FROM webselect
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address) WHERE Address.AddressId=0x8F51A0000000A ORDER BY Address.zip
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Company.CompanyId) AS CompanyId FROM (Relationship, Company) WHERE ((Company.CompanyId=Relationship.childCompanyId AND Relationship.parentCompanyId in (8740258448658, 8740258456268)) AND Relationship.relationType IN (1, 2, 20)) ORDER BY Company.alphaSort, Company.name
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x8F51A0000000A AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (Company, File) WHERE Company.electronicPamphletFileId=File.FileId AND Company.CompanyId=0x8CBA1100000001
0.0001 call
1 row
0.000 SELECT COUNT(DISTINCT Company.CompanyId) AS count FROM (Company) WHERE (Company.CompanyId IN (8740258448658, 8740258456268) AND IFNULL(Company.silent, "2")=\'2\')
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
54 rows
0.000 select id, abbreviation from StateProvince
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x7F300000534 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Branch.shippingAddressId=Address.AddressId AND Branch.BranchId=0x7F300000533 ORDER BY Address.zip
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x7F300000535 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
0 rows
0.000 START TRANSACTION