Search Results For Company: DSA

Total Time

Count

Avg Time

Query

0.095

1 call
1 row

0.095

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___em...`, `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`, `Company`.`isMergeProtected` 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.019

3 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.011

1 call
0 rows

0.011

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`=0x8CC96B00000001

0.008

1 call
1 row

0.008

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.007

1 call
0 rows

0.007

SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x7F300000512

0.007

1 call
1 row

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 (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x7F300000533 ORDER BY `Address`.`zip`

0.006

11 calls
2 rows

0.001

SELECT * FROM YesNo ORDER BY orderindex, id

0.006

1 call
3 rows

0.006

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0x7F300000512=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.005

1 call
1 row

0.005

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (8740258448658)) AND `Relationship`.`relationType` IN (1, 2, 20)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.005

1 call
1 row

0.005

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x7F300000512 ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.004

1 call
6 rows

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 (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x7F300000533 ORDER BY `Address`.`zip`

0.004

1 call
1 row

0.004

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x7F300000512

0.004

2 calls
54 rows

0.002

SELECT * FROM StateProvince ORDER BY orderindex, id

0.004

1 call
4 rows

0.004

SELECT * FROM CompanyStatus ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

COMMIT

0.003

1 call
4 rows

0.003

SELECT * FROM MinorityType ORDER BY orderindex, id

0.003

2 calls
3 rows

0.002

SELECT * FROM SalesStrategy ORDER BY orderindex, id

0.003

1 call
244 rows

0.003

SELECT * FROM Country ORDER BY orderindex, id

0.002

2 calls
2 rows

0.001

SELECT * FROM CompensationPlan ORDER BY orderindex, id

0.002

1 call
11 rows

0.002

SELECT * FROM SocialNetwork ORDER BY orderindex, id

0.001

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x6C14610000000A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x922F00000026 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x86575000005F9 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x7F300000512

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-31 08:44:12',`mxxCreatedBy`=NULL, `PageRequestId`=0x8CC96B00000000, `path`='forms/CompanyFormPublicMembers/search', `formName`='dsa_CompanyFormPublicMembers', `site`='www', `clientAcronym`='DSA', `pid`='999045', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.dsa.maxx.matrixdev.net', `dbThreadId`='690923', `startTime`='2025-08-31 08:44:12', `sessionId`=0x5300B507CE972D6D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'action\\':\\'find\\', \\'pendingMemberList\\':\\'1\\'}', `clientIPAddr`='216.73.216.36'

0.001

1 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 (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x7F300000533 ORDER BY `Address`.`zip`

0.001

4 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
158 rows

0.001

SELECT * FROM webselect

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) 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.000

1 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.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x8F51A0000000A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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.000

1 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`=0x8CC96B00000001

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x7F300000534 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
54 rows

0.000

select id, abbreviation from StateProvince

0.000

1 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 (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x7F300000533 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x7F300000535 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

START TRANSACTION

         350531 function calls (343146 primitive calls) in 4.052 seconds

   Ordered by: cumulative time
   List reduced from 2884 to 100 due to restriction <100>

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    4.052    4.052 /data/dsa/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    3.797    3.797 /data/dsa/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    3.755    3.755 /data/dsa/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    3.755    3.755 /data/dsa/current/dsa_org/sites/www/forms/dsa_CompanyFormPublicMembers.py:92(search)
        1    0.000    0.000    3.755    3.755 /data/dsa/current/libs/framework/WebForm.py:1090(search)
        1    0.000    0.000    3.547    3.547 /data/dsa/current/libs/framework/WebForm.py:1506(mungeResultsAfterSearch)
        2    0.000    0.000    3.520    1.760 /data/dsa/current/libs/utils/decoratorutils.py:282(wrapper)
        1    0.000    0.000    3.405    3.405 /data/dsa/current/libs/framework/WebForm.py:1654(outputSearchResults)
        1    0.000    0.000    3.394    3.394 /data/dsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap)
        1    0.000    0.000    3.393    3.393 /data/dsa/current/libs/framework/WebApp.py:213(wrapHTML)
        2    0.000    0.000    3.345    1.672 /data/dsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    3.340    3.340 /data/dsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape)
        1    0.000    0.000    3.279    3.279 /usr/lib/python3.11/urllib/request.py:139(urlopen)
        1    0.000    0.000    3.278    3.278 /usr/lib/python3.11/urllib/request.py:500(open)
        4    0.000    0.000    3.278    0.819 /usr/lib/python3.11/urllib/request.py:489(_call_chain)
        1    0.000    0.000    3.278    3.278 /usr/lib/python3.11/urllib/request.py:529(_open)
        1    0.000    0.000    3.278    3.278 /usr/lib/python3.11/urllib/request.py:1390(https_open)
        1    0.000    0.000    3.278    3.278 /usr/lib/python3.11/urllib/request.py:1307(do_open)
       33    0.010    0.000    3.181    0.096 {method 'readline' of '_io.BufferedReader' objects}
        1    0.000    0.000    3.172    3.172 /usr/lib/python3.11/http/client.py:1351(getresponse)
        1    0.000    0.000    3.172    3.172 /usr/lib/python3.11/http/client.py:318(begin)
        1    0.000    0.000    3.171    3.171 /usr/lib/python3.11/http/client.py:285(_read_status)
        1    0.000    0.000    3.171    3.171 /usr/lib/python3.11/socket.py:704(readinto)
        1    0.000    0.000    3.171    3.171 /usr/lib/python3.11/ssl.py:1299(recv_into)
        1    0.000    0.000    3.171    3.171 /usr/lib/python3.11/ssl.py:1157(read)
        1    3.171    3.171    3.171    3.171 {method 'read' of '_ssl._SSLSocket' objects}
        1    0.000    0.000    0.242    0.242 /data/dsa/current/libs/framework/WebManager.py:90(createNewHandler)
        1    0.000    0.000    0.242    0.242 /data/dsa/current/libs/framework/WebSite.py:92(__init__)
       71    0.000    0.000    0.233    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       71    0.000    0.000    0.232    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
       71    0.000    0.000    0.218    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       71    0.218    0.003    0.218    0.003 {function Connection.query at 0xffe2788c4900}
  237/132    0.001    0.000    0.205    0.002 :1165(_find_and_load)
  236/131    0.001    0.000    0.203    0.002 :1120(_find_and_load_unlocked)
  242/141    0.001    0.000    0.198    0.001 :666(_load_unlocked)
  240/141    0.001    0.000    0.193    0.001 :934(exec_module)
  375/165    0.004    0.000    0.191    0.001 {built-in method builtins.exec}
       27    0.000    0.000    0.181    0.007 /data/dsa/current/libs/PLayer/PersistentBroker.py:267(processSqlList)
  514/260    0.000    0.000    0.175    0.001 :233(_call_with_frames_removed)
        1    0.000    0.000    0.138    0.138 /data/dsa/current/libs/framework/WebForm.py:3255(processCursorForSearch)
      7/4    0.000    0.000    0.137    0.034 /data/dsa/current/libs/PLayer/PersistentBroker.py:770(processCriteria)
3978/3397    0.003    0.000    0.133    0.000 /data/dsa/current/libs/framework/BaseHandler.py:1458(mxxImporter)
4012/3402    0.003    0.000    0.131    0.000 {built-in method builtins.__import__}
      6/1    0.000    0.000    0.131    0.131 /data/dsa/current/libs/framework/DisplayGroup.py:552(getDataDictionary)
        1    0.004    0.004    0.127    0.127 /data/dsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups)
        1    0.000    0.000    0.115    0.115 /data/dsa/current/libs/framework/WebForm.py:2984(fillCursor)
       25    0.000    0.000    0.102    0.004 /data/dsa/current/libs/framework/DGEAttribute.py:111(getDataDictionary)
        1    0.000    0.000    0.102    0.102 /data/dsa/current/libs/framework/DGEMethod.py:107(getDataDictionary)
       29    0.000    0.000    0.096    0.003 /data/dsa/current/libs/framework/DGEAttribute.py:207(getValue)
       11    0.000    0.000    0.083    0.008 /data/dsa/current/libs/utils/htmlTools.py:100(cleanHTML)
        6    0.000    0.000    0.082    0.014 /data/dsa/current/generic/classes/Address.py:340(generatePrettyHTML)
        1    0.000    0.000    0.078    0.078 /data/dsa/current/generic/classes/Address.py:226(getPrintPrettyHTML)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:1300(request)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:1305(_send_request)
        1    0.000    0.000    0.077    0.077 /data/dsa/current/libs/framework/DisplayGroup.py:311(initialize)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:1287(endheaders)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:1049(_send_output)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:988(send)
        1    0.000    0.000    0.077    0.077 /usr/lib/python3.11/http/client.py:1465(connect)
       78    0.001    0.000    0.076    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       77    0.000    0.000    0.076    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
        2    0.001    0.000    0.075    0.037 /data/dsa/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML)
       53    0.000    0.000    0.075    0.001 /usr/lib/python3.11/re/_compiler.py:740(compile)
        1    0.000    0.000    0.074    0.074 /data/dsa/current/libs/framework/WebForm.py:1302(getCompleteSearchPC)
        8    0.005    0.001    0.073    0.009 /data/dsa/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile)
        1    0.000    0.000    0.072    0.072 /usr/lib/python3.11/http/client.py:959(connect)
        1    0.000    0.000    0.072    0.072 /usr/lib/python3.11/socket.py:821(create_connection)
        1    0.000    0.000    0.072    0.072 /usr/lib/python3.11/socket.py:957(getaddrinfo)
        1    0.072    0.072    0.072    0.072 {built-in method _socket.getaddrinfo}
      240    0.002    0.000    0.069    0.000 :1007(get_code)
        8    0.055    0.007    0.069    0.009 /data/dsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML)
        3    0.000    0.000    0.060    0.020 /data/dsa/current/libs/framework/baseScrapeAndDrape.py:214(stubURL)
        3    0.000    0.000    0.060    0.020 /data/dsa/current/dsa_org/classes/dsa_ScrapeAndDrape.py:41(getPath)
  455/388    0.001    0.000    0.056    0.000 /data/dsa/current/libs/PLayer/PersistentObject.py:2675(__getattr__)
    17/11    0.000    0.000    0.055    0.005 /data/dsa/current/libs/PLayer/PersistentObject.py:2039(loadAssoc)
       53    0.000    0.000    0.052    0.001 /usr/lib/python3.11/re/_compiler.py:573(_code)
      240    0.001    0.000    0.046    0.000 :1127(get_data)
       18    0.000    0.000    0.044    0.002 /data/dsa/current/libs/framework/BaseHandler.py:1327(importModule)
       15    0.000    0.000    0.044    0.003 /data/dsa/current/libs/framework/WebSite.py:1134(_loadModule)
      128    0.042    0.000    0.043    0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)
   247/92    0.000    0.000    0.043    0.000 /data/dsa/current/libs/PLayer/PersistentObject.py:108(new_init)
     5219    0.007    0.000    0.042    0.000 /data/dsa/current/libs/framework/LazyDict.py:71(__setitem__)
        1    0.000    0.000    0.041    0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
        1    0.000    0.000    0.040    0.040 /data/dsa/current/libs/framework/DisplayedAttribute.py:209(getCriteria)
      3/1    0.000    0.000    0.040    0.040 /data/dsa/current/libs/framework/DisplayedAttribute.py:229(process)
        1    0.000    0.000    0.039    0.039 /data/dsa/current/libs/framework/WebManInterface.py:92(createBroker)
  197/179    0.000    0.000    0.039    0.000 /data/dsa/current/libs/PLayer/PersistentBroker.py:78(__new__)
        1    0.000    0.000    0.038    0.038 /data/dsa/current/libs/framework/DGEEmail.py:1()
  377/326    0.000    0.000    0.038    0.000 :1207(_handle_fromlist)
      242    0.037    0.000    0.037    0.000 {method 'read' of '_io.BufferedReader' objects}
  259/254    0.000    0.000    0.037    0.000 /data/dsa/current/generic/classes/Company.py:365(__getattr__)
        1    0.000    0.000    0.036    0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1()
       92    0.001    0.000    0.035    0.000 /data/dsa/current/libs/PLayer/PersistentObject.py:348(__init__)
        1    0.011    0.011    0.035    0.035 /data/dsa/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps)
        1    0.000    0.000    0.035    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1()
       17    0.000    0.000    0.035    0.002 /data/dsa/current/libs/framework/BaseHandler.py:1301(getModuleFromBase)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1()
   842/53    0.005    0.000    0.034    0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1()
     5360    0.034    0.000    0.034    0.000 /data/dsa/current/libs/framework/LazyDict.py:29(explode_any_access)