Company: Melbourne Polytechnic: ACSA

Melbourne Polytechnic

corner Dalton Road and Cooper Streets,
Epping, VIC 3076
Australia

International Programs

Peter Hogg, Head of School

Faculty/Staff Roster

ACSA Members: Click here to view detailed Faculty/Staff information (Members Only Content)

Last Updated: 10/24/2023

Total Time

Count

Avg Time

Query

0.010

12 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.005

7 calls
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (BranchAffiliationHistory, Branch, Company, Individual) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xE20A100000052) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.004

1 call
0 rows

0.004

UPDATE PageRequest SET mxxUpdated='2025-07-05 01:04:44',mxxUpdatedBy=NULL, PageRequestId=0x13AC1100000000, path='forms/cas/login', formName='cas', site='www', clientAcronym='ACSA', pid='3409959', requestNum='1', growth='13392', server='www.acsa.maxx.matrixdev.net', dbThreadId='134608', startTime='2025-07-05 01:04:44', sessionId=0x1B9E6D4C2CBAE444, userId=0x0, userName='public', result='0', sqltime='0.023723363876342773', timeTaken='26', dictSize='0', fields='{\\'service\\':\\'/members_only/FacultyDirectory/detail?id=12E30300000007\\'}', clientIPAddr='216.73.216.138' WHERE PageRequestId=0x13AC1100000000

0.003

1 call
0 rows

0.003

INSERT INTO PageRequest SET mxxCreated='2025-07-05 01:05:34',mxxCreatedBy=NULL, PageRequestId=0x13AC1100000002, path='forms/CompanyFormPublic/view', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3409959', requestNum='2', pageDictSize=NULL, objectId='E20A20000001D', templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='134608', startTime='2025-07-05 01:05:34', sessionId=0x2320A41A04FC263F, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'id\\':\\'E20A20000001D\\'}', clientIPAddr='216.73.216.138'

0.002

1 call
0 rows

0.002

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

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Individual) WHERE SocialNetworking.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xE20A100000052

0.002

2 calls
0 rows

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Branch, Individual2JobFunction, Individual, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (13) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0xE20A20000001D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

7 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Branch, Individual2JobFunction, Individual, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (15) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0xE20A20000001D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Branch, Individual2JobFunction, Individual, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (12) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0xE20A20000001D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (BranchAffiliationHistory, Branch, Individual) WHERE ((((BranchAffiliationHistory.active='Y' AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=0xE20A20000001D) AND Individual.personalStatus=1) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

2 calls
54 rows

0.000

SELECT * FROM StateProvince ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Company, Individual, Company2AlternateContact) WHERE (0xE20A20000001D=Company.CompanyId AND Company.CompanyId=Company2AlternateContact.CompanyId AND Company2AlternateContact.IndividualId=Individual.IndividualId) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (User, Individual) WHERE Individual.userId=User.UserId AND User.UserId=0x19B0005B91E ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company) WHERE Company.CompanyId=0xE20A20000001D ORDER BY Company.alphaSort, Company.name

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Company, Individual) WHERE Company.CompanyId=0xE20A20000001D AND Company.KeyContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

3 calls
1 row

0.000

select mxxCreated, mxxUpdated from Company where CompanyId=0xE20A20000001D;

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Company, Individual) WHERE Company.CompanyId=0xE20A20000001D AND Company.DirectoryContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Company, Individual) WHERE Company.CompanyId=0xE20A20000001D AND Company.BillingContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0xE20A20000001E ORDER BY Address.zip

0.000

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 2531203422241957439

0.000

2 calls
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

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 (Company, Branch) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D ORDER BY Branch.isMain, Branch.name

0.000

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Company where CompanyId=0xE20A20000001D

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramStudyAbroad.ProgramStudyAbroadId) AS ProgramStudyAbroadId, ProgramStudyAbroad.name, ProgramStudyAbroad.url FROM (Company, ProgramStudyAbroad) WHERE ProgramStudyAbroad.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Membership.MembershipId) AS MembershipId, Membership.MembershipTypeId, Membership.joined, Membership.expires, Membership.billingCycle, Membership.billingStart, Membership.renewalNoticeSent, Membership.dateRenewed, Membership.dateRenewallLetterSent, Membership.lastRenewallLentDate, Membership.dateCanncelled, Membership.cancelReason, Membership.enteredBy, Membership.updatedBy, Membership.dateofPaymeny, Membership.balanceDue, Membership.renewalAmount, Membership.paidDues, Membership.renewalStatus, Membership.memberSinceDate, Membership.status, Membership.marketingCode, Membership.memberRecordComment FROM (Company, Membership) WHERE Company.MembershipId=Membership.MembershipId AND Company.CompanyId=0xE20A20000001D

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xE20A100000052 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramPreprofessional.ProgramPreprofessionalId) AS ProgramPreprofessionalId, ProgramPreprofessional.name, ProgramPreprofessional.url FROM (Company, ProgramPreprofessional) WHERE ProgramPreprofessional.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramPostprofessional.ProgramPostprofessionalId) AS ProgramPostprofessionalId, ProgramPostprofessional.name, ProgramPostprofessional.url FROM (Company, ProgramPostprofessional) WHERE ProgramPostprofessional.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramSpecialProgram.ProgramSpecialProgramId) AS ProgramSpecialProgramId, ProgramSpecialProgram.name, ProgramSpecialProgram.url FROM (Company, ProgramSpecialProgram) WHERE ProgramSpecialProgram.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.primaryAddressId=Address.AddressId AND Branch.BranchId=0xE20A20000001E ORDER BY Address.zip

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000018 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.directoryAddressId=Address.AddressId AND Branch.BranchId=0xE20A20000001E ORDER BY Address.zip

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xE20A100000052 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramCommunityDesign.ProgramCommunityDesignId) AS ProgramCommunityDesignId, ProgramCommunityDesign.name, ProgramCommunityDesign.url FROM (Company, ProgramCommunityDesign) WHERE ProgramCommunityDesign.CompanyId=Company.CompanyId AND Company.CompanyId=0xE20A20000001D

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000008 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000022 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC110000000D AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC110000001D AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000012 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company, Country, Company2Country) WHERE (0xE20A20000001D=Company.CompanyId AND Company.CompanyId=Company2Country.CompanyId AND Company2Country.CountryId=Country.CountryId) ORDER BY orderindex

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC110000001D AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address) WHERE Address.AddressId=0xE20A300000016 ORDER BY Address.zip

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.shippingAddressId=Address.AddressId AND Branch.BranchId=0xE20A20000001E ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000018 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC110000000D AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000012 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000008 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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=0x13AC110000000A AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

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

0.000

1 call
0 rows

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.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC1100000022 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

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=0x13AC1100000025 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

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=0x13AC110000001F AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
11 rows

0.000

SELECT * FROM SocialNetwork ORDER BY orderindex, id

0.000

1 call
0 rows

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=0x13AC110000000F AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC110000000B AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(User.UserId) AS UserId, User.username, User.password, User.encoding, hex(User.VotingId) AS VotingId, User.lastSearchType, User.oneTimeKey, User.recoverPasswordKey, User.recoverPasswordTimeout, User.disableAllNotifications, User.otCodeTime, User.otCode, User.holyGrailSections FROM (User) WHERE User.UserId=0x19B0005B91E

0.000

1 call
0 rows

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=0x13AC1100000014 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC110000001A AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC1100000024 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC1100000010 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC1100000015 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC1100000020 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

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=0x13AC110000001B AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
7 rows

0.000

SELECT * FROM Region ORDER BY orderindex, id

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

472340 function calls (468666 primitive calls) in 0.348 seconds Ordered by: cumulative time List reduced from 1502 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.348 0.348 /data/acsa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.340 0.340 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.305 0.305 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.305 0.305 /data/acsa/current/libs/webform/CompanyForm.py:138(view) 1 0.000 0.000 0.303 0.303 /data/acsa/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.146 0.146 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.146 0.146 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML) 2/1 0.000 0.000 0.134 0.134 /data/acsa/current/libs/framework/DGEGroup.py:43(getDataDictionary) 28/1 0.000 0.000 0.134 0.134 /data/acsa/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 26/19 0.000 0.000 0.098 0.005 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 1 0.000 0.000 0.075 0.075 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process) 1 0.000 0.000 0.071 0.071 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.071 0.071 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.071 0.071 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 1 0.000 0.000 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.002 0.002 0.070 0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 5 0.000 0.000 0.060 0.012 /data/acsa/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 108 0.000 0.000 0.052 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 108 0.000 0.000 0.051 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 80 0.003 0.000 0.046 0.001 /data/acsa/current/libs/framework/DGESelect.py:120(getDataDictionary) 108 0.000 0.000 0.046 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 108 0.045 0.000 0.045 0.000 {function Connection.query at 0xe7ffd6088d60} 341 0.001 0.000 0.043 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:111(getDataDictionary) 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 8 0.000 0.000 0.041 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 8 0.001 0.000 0.041 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 6143 0.013 0.000 0.038 0.000 /usr/lib/python3.11/copy.py:66(copy) 1287 0.006 0.000 0.036 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 80 0.002 0.000 0.034 0.000 /data/acsa/current/libs/framework/DGESelect.py:154() 65 0.001 0.000 0.034 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 1614 0.002 0.000 0.034 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 435 0.002 0.000 0.032 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 1 0.000 0.000 0.030 0.030 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin) 1614 0.003 0.000 0.026 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 8742/8589 0.005 0.000 0.024 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 2 0.000 0.000 0.024 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 357/315 0.001 0.000 0.024 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 48/47 0.000 0.000 0.023 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 589/538 0.001 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 21 0.000 0.000 0.019 0.001 /data/acsa/current/generic/classes/Address.py:340(generatePrettyHTML) 63 0.000 0.000 0.019 0.000 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 20 0.000 0.000 0.018 0.001 /data/acsa/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 63 0.001 0.000 0.018 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 537 0.001 0.000 0.018 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 20 0.002 0.000 0.018 0.001 /data/acsa/current/libs/framework/WebManInterface.py:37(readWebSelect) 115/50 0.000 0.000 0.018 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 43 0.000 0.000 0.018 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1530(createPOClassByName) 43 0.000 0.000 0.018 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:160(createPO) 62 0.000 0.000 0.018 0.000 /data/acsa/current/libs/framework/DGEPhunkyFone.py:104(getValue) 1 0.000 0.000 0.017 0.017 /data/acsa/current/libs/framework/WebForm.py:95(__init__) 1515/1488 0.001 0.000 0.017 0.000 /data/acsa/current/libs/framework/LazyDict.py:186(__getitem__) 8750/8589 0.005 0.000 0.017 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.017 0.017 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:703(_drape) 1614 0.001 0.000 0.017 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 1 0.000 0.000 0.017 0.017 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:574(_fixStubAuthLinks) 1 0.000 0.000 0.016 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.016 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 537/1 0.004 0.000 0.016 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 537/1 0.002 0.000 0.016 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 2 0.000 0.000 0.015 0.008 /data/acsa/current/libs/framework/WebForm.py:2883(getViewDG) 2 0.000 0.000 0.015 0.008 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:176(_getDGByName) 1 0.000 0.000 0.015 0.015 /data/acsa/current/libs/framework/WebForm.py:149(getDGGreedyAssocs) 2 0.000 0.000 0.015 0.008 /data/acsa/current/libs/framework/WebSite.py:973(getDGByName) 2 0.000 0.000 0.015 0.008 /data/acsa/current/libs/framework/LazyDict.py:172(get) 18/1 0.000 0.000 0.015 0.015 /data/acsa/current/libs/framework/BaseHandler.py:470(_createDisplayGroup) 16303/16188 0.005 0.000 0.015 0.000 {built-in method builtins.getattr} 115/1 0.000 0.000 0.015 0.015 /data/acsa/current/libs/framework/DisplayGroup.py:631(_createDGE) 2/1 0.000 0.000 0.015 0.015 /data/acsa/current/libs/framework/DisplayGroup.py:835(_createDGEGroup) 5626 0.008 0.000 0.015 0.000 /usr/lib/python3.11/copy.py:259(_reconstruct) 10 0.000 0.000 0.015 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.001 0.000 0.015 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 34 0.000 0.000 0.015 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:336(processSql) 26 0.000 0.000 0.014 0.001 /data/acsa/current/libs/framework/BaseHandler.py:1327(importModule) 1 0.000 0.000 0.014 0.014 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:636(doPostScrapeStuff) 11 0.000 0.000 0.014 0.001 /data/acsa/current/libs/framework/BaseHandler.py:1202(WSKey2Value) 19 0.000 0.000 0.014 0.001 /data/acsa/current/libs/framework/WebSite.py:1134(_loadModule) 35/34 0.000 0.000 0.013 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 49 0.001 0.000 0.013 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:348(__init__) 35/34 0.000 0.000 0.013 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 13 0.000 0.000 0.013 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 17 0.000 0.000 0.013 0.001 /data/acsa/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 39/21 0.000 0.000 0.013 0.001 :666(_load_unlocked) 1 0.000 0.000 0.013 0.013 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:598(_addUserNameToElement) 1 0.000 0.000 0.012 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:402(_applyTitle) 1777 0.002 0.000 0.012 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 9 0.000 0.000 0.012 0.001 /data/acsa/current/generic/classes/Address.py:1010(getCountryName) 3 0.000 0.000 0.012 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:385(cook) 39/21 0.000 0.000 0.012 0.001 :934(exec_module) 48/3 0.000 0.000 0.012 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:177(parse) 1 0.000 0.000 0.012 0.012 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:9(getTitleElement) 63522/63086 0.010 0.000 0.011 0.000 {built-in method builtins.isinstance} 43/23 0.000 0.000 0.011 0.000 {built-in method builtins.exec} 28/11 0.000 0.000 0.011 0.001 :1165(_find_and_load) 4169 0.008 0.000 0.011 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower)

Other ACSA Websites

Program Directory

Already have an account?

I’m new here

Stay in Touch