Store

You can only gain access to certain items and special pricing if you have logged in. Login Now.

How to Create a Safety Program

Format:
Print

Guest, Member, NonMember - $100.00

Description:

The Safety Program is designed to assist contractors in effectively integrating safety into their organization. The product includes a comprehensive manual and CD that allows for contractors to easily customize the programs content. This purchase comes with a 90-day free trial subscription to the Safety Expert System. The manual reflects best practices for safety found in the electrical industry. The program is simple, yet complex enough to produce an effective and compliant safety program.

Product Details:

Product ID:	5001M
Publication Year:	2010
Pages, Size, or Length:	124

Total Time

Count

Avg Time

Query

0.008

23 calls
1 row

0.000

SELECT version from databasemap;

0.004

2 calls
1 row

0.002

select max(returnOrder) from Stack where sessionId = 6212443188951220054

0.004

1 call
0 rows

0.004

COMMIT

0.003

1 call
1 row

0.003

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`.`congressParty`, `Individual`.`ceus`, `Individual`.`mailChimpMergeCache`, `Individual`.`training`, `Individual`.`dateOfBirth`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`specialNeeds`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x2DF100000008 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) WHERE `Product`.`slug`='safety-program' ORDER BY `Product`.`name`

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(`ProductPrice`.`ProductPriceId`) AS `ProductPriceId`, `ProductPrice`.`amount`, `ProductPrice`.`minQuantity`, `ProductPrice`.`maxQuantity`, `ProductPrice`.`shipType`, `ProductPrice`.`priceType`, `ProductPrice`.`description`, `ProductPrice`.`accountingCode`, `ProductPrice`.`membershipTypesLabelForWWW` FROM (Product, ProductPrice) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x53D00000069 ORDER BY `ProductPrice`.`description`, `ProductPrice`.`minQuantity`

0.003

1 call
0 rows

0.003

2 calls
1 row

0.001

select mxxCreated, mxxUpdated from Product where ProductId=0x53D00000069;

0.002

1 call
0 rows

0.002

START TRANSACTION

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (MailingList2ProductPrice, ProductPrice, MailingList) WHERE (0x53D00000077=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0x1F4E7500000012 ORDER BY `Committee`.`name`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (Product, SpecialOffer, ProductPrice, ProductPrice2SpecialOffer) WHERE ((`ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x53D00000069 AND (`ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)) AND `SpecialOffer`.`expires`>'2025-08-21 17:46:13')

0.001

2 calls
4 rows

0.001

SELECT * FROM Language ORDER BY orderindex, id

0.001

1 call
18 rows

0.001

SELECT * FROM ProductType ORDER BY orderindex, id

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`.`congressParty`, `Individual`.`ceus`, `Individual`.`mailChimpMergeCache`, `Individual`.`training`, `Individual`.`dateOfBirth`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`specialNeeds`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x14D00000000 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

2 calls
2 rows

0.001

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.001

1 call
3 rows

0.001

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType2ProductPrice, ProductPrice, MembershipType) WHERE (0x53D00000077=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (Product, Product2MailingList, MailingList) WHERE (0x53D00000069=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2MailingList`.`ProductId` AND `Product2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0x53D00000069) ORDER BY `Product`.`name`

0.001

1 call
3 rows

0.001

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (Product, MembershipType2Product, MembershipType) WHERE (0x53D00000069=`Product`.`ProductId` AND `Product`.`ProductId`=`MembershipType2Product`.`ProductId` AND `MembershipType2Product`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.001

1 call
155 rows

0.001

SELECT * FROM webselect

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Product, Category2Product, Category) WHERE (0x53D00000069=`Product`.`ProductId` AND `Product`.`ProductId`=`Category2Product`.`ProductId` AND `Category2Product`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x53D00000077=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Product, File) WHERE `Product`.`downloadFileId`=`File`.`FileId` AND `Product`.`ProductId`=0x53D00000069

0.001

1 call
0 rows

0.001

2 calls
11 rows

0.000

SELECT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType) ORDER BY `ReportingType`.`orderindex` LIMIT 0, 700

0.001

1 call
1 row

0.001

2 calls
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

0.001

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0x53D00000069

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (Site, Product2Site, Product) WHERE (0x53D00000069=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2Site`.`ProductId` AND `Product2Site`.`SiteId`=`Site`.`SiteId`)

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 17:46:13',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4E7500000000, `path`='forms/store/ProductFormPublic/safety-program', `formName`='ProductFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2971967', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='640565', `startTime`='2025-08-21 17:46:13', `sessionId`=0x5637082A58BB7F56, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.122'

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x1F4E7500000002 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ParentProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x53D00000069

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x1F4E7500000006 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
3 rows

0.000

SELECT * FROM PriceType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (Site, Product, ProductFeaturedOn2Site) WHERE (0x53D00000069=`Product`.`ProductId` AND `Product`.`ProductId`=`ProductFeaturedOn2Site`.`ProductId` AND `ProductFeaturedOn2Site`.`SiteId`=`Site`.`SiteId`)

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ChildProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x53D00000069

0.000

1 call
1 row

0.000

SELECT * FROM Folks ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x1F4E7500000002 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`FileProtectionType`.`FileProtectionTypeId`) AS `FileProtectionTypeId`, `FileProtectionType`.`name`, `FileProtectionType`.`description`, `FileProtectionType`.`path`, `FileProtectionType`.`prefix` FROM (File, FileProtectionType) WHERE `File`.`FileId`=0x1F4E7500000013 AND `File`.`fileProtectionTypeId`=`FileProtectionType`.`FileProtectionTypeId`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x1F4E7500000006 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
2 rows

0.000

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (Product, ReportingType) WHERE `Product`.`ProductId`=0x53D00000069 AND `Product`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
12 rows

0.000

SELECT * FROM Month ORDER BY orderindex, id

0.000

1 call
1 row

0.000

1101642 function calls (1091006 primitive calls) in 1.295 seconds Ordered by: cumulative time List reduced from 2609 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.295 1.295 /data/demo/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.969 0.969 /data/demo/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.936 0.936 /data/demo/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.936 0.936 /data/demo/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 0.931 0.931 /data/demo/current/libs/framework/WebForm.py:190(view) 1 0.000 0.000 0.551 0.551 /data/demo/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.550 0.550 /data/demo/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.422 0.422 /data/demo/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.421 0.421 /data/demo/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 7/1 0.000 0.000 0.330 0.330 /data/demo/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 8/1 0.000 0.000 0.330 0.330 /data/demo/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 1 0.000 0.000 0.314 0.314 /data/demo/current/libs/framework/WebManager.py:90(createNewHandler) 1 0.000 0.000 0.314 0.314 /data/demo/current/libs/framework/WebSite.py:92(__init__) 113 0.003 0.000 0.287 0.003 /data/demo/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 12 0.000 0.000 0.239 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.238 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.238 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.233 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.233 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.007 0.001 0.232 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 352/174 0.005 0.000 0.169 0.001 {built-in method builtins.exec} 197/128 0.001 0.000 0.166 0.001 :1165(_find_and_load) 197/128 0.001 0.000 0.163 0.001 :1120(_find_and_load_unlocked) 1 0.000 0.000 0.162 0.162 /data/demo/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 214/146 0.003 0.000 0.160 0.001 :666(_load_unlocked) 215/149 0.001 0.000 0.157 0.001 :934(exec_module) 72 0.000 0.000 0.156 0.002 /data/demo/current/libs/framework/DGEAttribute.py:58(getEditHTML) 16 0.000 0.000 0.149 0.009 /data/demo/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 16 0.000 0.000 0.149 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 16 0.000 0.000 0.149 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 16 0.000 0.000 0.145 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 25 0.000 0.000 0.145 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 25 0.003 0.000 0.144 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 435/272 0.000 0.000 0.142 0.001 :233(_call_with_frames_removed) 2 0.000 0.000 0.139 0.070 /data/demo/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 2 0.001 0.000 0.138 0.069 /data/demo/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 8 0.008 0.001 0.137 0.017 /data/demo/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 1 0.004 0.004 0.131 0.131 /data/demo/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 8 0.106 0.013 0.129 0.016 /data/demo/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 1 0.000 0.000 0.129 0.129 /data/demo/current/libs/framework/baseScrapeAndDrape.py:714(process) 28446/28044 0.016 0.000 0.127 0.000 /data/demo/current/libs/framework/BaseHandler.py:1458(mxxImporter) 3581 0.019 0.000 0.116 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 359 0.001 0.000 0.114 0.000 /data/demo/current/libs/framework/DGEAttribute.py:207(getValue) 229 0.001 0.000 0.113 0.000 /data/demo/current/libs/framework/DTWrapper.py:47(__call__) 229 0.002 0.000 0.111 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 28466/28048 0.014 0.000 0.106 0.000 {built-in method builtins.__import__} 5724 0.006 0.000 0.106 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 51 0.000 0.000 0.105 0.002 /data/demo/current/libs/utils/htmlTools.py:100(cleanHTML) 72 0.000 0.000 0.104 0.001 /data/demo/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 62 0.000 0.000 0.101 0.002 /data/demo/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 15/10 0.001 0.000 0.100 0.010 /data/demo/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 110 0.000 0.000 0.098 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 7/5 0.000 0.000 0.097 0.019 /data/demo/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 110 0.001 0.000 0.097 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.091 0.091 /usr/lib/python3.11/urllib/request.py:139(urlopen) 3 0.000 0.000 0.090 0.030 /data/demo/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 1 0.000 0.000 0.090 0.090 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 0.090 0.090 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.090 0.045 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 0.090 0.090 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.090 0.090 /usr/lib/python3.11/urllib/request.py:1307(do_open) 110 0.000 0.000 0.082 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 1 0.000 0.000 0.082 0.082 /data/demo/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 110 0.082 0.001 0.082 0.001 {function Connection.query at 0xe4860eaaf100} 101 0.001 0.000 0.081 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 97 0.000 0.000 0.081 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 5724 0.007 0.000 0.080 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.080 0.080 /data/demo/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 48 0.000 0.000 0.078 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.077 0.077 /data/demo/current/libs/framework/DisplayGroup.py:311(initialize) 324/229 0.000 0.000 0.073 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 939/229 0.016 0.000 0.073 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 1 0.000 0.000 0.070 0.070 /data/demo/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 5724 0.004 0.000 0.066 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 1 0.000 0.000 0.064 0.064 /usr/lib/python3.11/http/client.py:1426(__init__) 1 0.000 0.000 0.061 0.061 /usr/lib/python3.11/ssl.py:745(create_default_context) 1 0.000 0.000 0.057 0.057 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.057 0.057 0.057 0.057 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 1039/961 0.004 0.000 0.056 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 48 0.000 0.000 0.055 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.053 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1080 0.005 0.000 0.049 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 6247 0.045 0.000 0.047 0.000 /data/demo/current/libs/framework/LazyDict.py:71(__setitem__) 44 0.001 0.000 0.046 0.001 /data/demo/current/libs/framework/BaseHandler.py:311(getTemplate) 1 0.000 0.000 0.046 0.046 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 113 0.041 0.000 0.044 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 5724 0.006 0.000 0.044 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 1 0.000 0.000 0.043 0.043 /data/demo/current/libs/framework/WebManInterface.py:92(createBroker) 94/76 0.000 0.000 0.042 0.001 /data/demo/current/libs/PLayer/PersistentBroker.py:78(__new__) 4 0.000 0.000 0.042 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 1459/4 0.011 0.000 0.042 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 1459/4 0.006 0.000 0.042 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 594/552 0.001 0.000 0.042 0.000 :1207(_handle_fromlist) 1 0.012 0.012 0.039 0.039 /data/demo/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 23 0.002 0.000 0.038 0.002 /data/demo/current/libs/framework/BaseHandler.py:584(getTemplateDefaults) 14 0.000 0.000 0.038 0.003 /data/demo/current/libs/framework/DGESelect.py:36(getEditHTML) 1 0.000 0.000 0.038 0.038 /data/demo/current/libs/framework/DGEEmail.py:1() 821/48 0.005 0.000 0.036 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 8 0.000 0.000 0.036 0.005 /data/demo/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1()