About Us
- About Us
- History
- Leadership
- Staff
- Policy Statements
- Contact Us
- Careers
  - Job Listings
- Year in Review
Join FMI
Careers
- Job Listings
Newsroom
- Latest News
- News Archive
  - 2024
  - 2023
  - 2022
  - 2021
  - 2020
  - 2019
  - 2018
  - 2017
  - 2016
  - 2015
  - 2014
  - 2013
  - 2012
  - 2011
  - 2010
  - 2009
  - 2008
  - 2007
  - 2006
  - 2005
  - 2004
  - 2003
  - 2002
  - 2001
  - 2000
  - 1999
  - 1998
- Press Credentials
- Voice of The Food Industry Blog
Store

Home / Store

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

SafeMark® Food Protection Manager Training (English)

Format:
Digital

FMI Members and NonMembers - $60.00

Description:

A certified food protection manager in a retail food establishment equates to better food safety practices and fewer critical violations. The SafeMark® Food Protection Manager training is an 8-hour/9-module online course with both English and Spanish versions available. Content is updated to the 2022 Food Code standards.

This training provides the necessary tools to become a Certified Food Protection Manager and meets the Person in Charge requirements in your regulatory jurisdictions. The comprehensive course covers all areas of food safety, following HACCP principles, in an easy-to-understand manner, presented through retail-focused scenarios.

Duration: 8 hours. Certification is valid for 5 years.

Note: Some states have different training requirements. SafeMark® offers state-specific training that is required, and most often, approved by the state regulatory agency. See all our training products and review additional courses we offer for retailers operating in states with additional requirements.

After successfully completing the Food Manager training, you will take the SafeMark® Grocery Manager Certification Exam. Accredited by ANAB against the Conference for Food Protection standards, this exam is the only grocery-oriented exam that meets Certified Food Protection Manager (CFPM) and “Person in Charge” government regulatory requirements. The certification is valid for 5 years. Learn more through the National Registry of Food Safety Professionals here.

Product Details:

Product ID:	1000443

2345 Crystal Drive, Suite 800, Arlington, VA 22202 | phone: 202-452-8444 | fax: 202-429-4519

Website design by Matrix Group International, Inc. ®

Sign Up for the

FREE daily briefing on top stories in food retailing.

fmi-icon-frozen-goods
fmi-icon-workforce
fmi-icon-certificate
fmi-icon-pharmacy
fmi-icon-food-safety
fmi-icon-asset-protection
fmi-icon-education force-icon-3
fmi-icon-research
fmi-icon-government-affairs
fmi-icon-get-involved
fmi-icon-industry-topic force-icon-3
fmi-icon-labeling
fmi-icon-corporate-social-responsibility
fmi-icon-payments
fmi-icon-crisis-management
fmi-icon-private-brands
fmi-icon-food-assistance
fmi-icon-supplier-diversity
fmi-icon-fresh-foods
fmi-icon-supply-chain
fmi-icon-general-merchandise
fmi-icon-technology
fmi-icon-health-wellness
fmi-icon-total-store-collaboration
fmi-icon-Health-Reform
fmi-icon-wage-labor
fmi-icon-independent-operator
fmi-icon-wholesaler-topic
fmi-icon-newsroom force-icon-3
fmi-icon-tax-reform
fmi-icon-about_icon force-icon-4
fmi-icon-about_icon
fmi-icon-cart
fmi-icon-blog_icon force-icon-5
fmi-icon-cart
fmi-icon-Communications
fmi-icon-omnichannel
fmi-icon-biotechnology-topic

Total Time

Count

Avg Time

Query

0.022

1 call
1 row

0.022

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`='safemark-food-manager-training-2024' ORDER BY `Product`.`name`

0.016

1 call
0 rows

0.016

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

0.016

2 calls
5 rows

0.008

SELECT * FROM Language ORDER BY orderindex, id

0.014

1 call
2 rows

0.014

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

0.010

1 call
12 rows

0.010

SELECT * FROM Month ORDER BY orderindex, id

0.009

1 call
1 row

0.009

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

0.009

1 call
2 rows

0.009

SELECT * FROM YesNo ORDER BY orderindex, id

0.008

1 call
0 rows

0.008

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

0.007

24 calls
1 row

0.000

SELECT version from databasemap;

0.006

1 call
21 rows

0.006

SELECT * FROM ProductType ORDER BY orderindex, id

0.006

1 call
0 rows

0.006

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

0.005

2 calls
1 row

0.003

select max(returnOrder) from Stack where sessionId = 7488139571561345189

0.005

1 call
13 rows

0.005

SELECT * FROM Folks ORDER BY orderindex, id

0.005

1 call
0 rows

0.005

COMMIT

0.005

1 call
0 rows

0.005

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`=0xF569D70000000E ORDER BY `Committee`.`category`, `Committee`.`name`

0.003

1 call
13 rows

0.003

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

0.003

2 calls
2 rows

0.002

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.002

1 call
1 row

0.002

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`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x8D77DA00000025 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 call
1 row

0.002

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`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0xBD416D00000002 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 call
1 row

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 08:40:40',`mxxCreatedBy`=NULL, `PageRequestId`=0xF569D700000000, `path`='forms/store/ProductFormPublic/safemark-food-manager-training-2024', `formName`='fmiam_ProductFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3313880', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='494377', `startTime`='2025-12-26 08:40:40', `sessionId`=0x67EB37443775B0A5, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.150'

0.002

2 calls
5 rows

0.001

SELECT * FROM ShipType ORDER BY orderindex, id

0.002

1 call
1 row

0.002

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`=0xA1F01900000005 ORDER BY ProductPrice.description NOT LIKE '%Ret./Whslr.%', ProductPrice.description NOT LIKE '%NAPAR%', ProductPrice.description NOT LIKE '%Associate Member%', minQuantity IS NOT NULL, minQuantity, maxQuantity

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`.`showNewsletterMemberParticipationReport`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (Product, Product2MailingList, MailingList) WHERE (0xA1F01900000005=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2MailingList`.`ProductId` AND `Product2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.002

1 call
1 row

0.002

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`=0x858C0D00000002 ORDER BY ProductPrice.description NOT LIKE '%Ret./Whslr.%', ProductPrice.description NOT LIKE '%NAPAR%', ProductPrice.description NOT LIKE '%Associate Member%', minQuantity IS NOT NULL, minQuantity, maxQuantity

0.001

1 call
1 row

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`.`ProductId`=0xA1F01900000005 ORDER BY `Product`.`name`

0.001

1 call
11 rows

0.001

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

0.001

1 call
0 rows

0.001

START TRANSACTION

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 (Product, Site, ProductFeaturedOn2Site) WHERE (0xA1F01900000005=`Product`.`ProductId` AND `Product`.`ProductId`=`ProductFeaturedOn2Site`.`ProductId` AND `ProductFeaturedOn2Site`.`SiteId`=`Site`.`SiteId`)

0.001

1 call
13 rows

0.001

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

0.001

1 call
1 row

0.001

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

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xF569D700000006 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

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`.`showNewsletterMemberParticipationReport`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (ProductPrice, MailingList, MailingList2ProductPrice) WHERE (0xA1F01900000006=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

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 (Product, Site, Product2Site) WHERE (0xA1F01900000005=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2Site`.`ProductId` AND `Product2Site`.`SiteId`=`Site`.`SiteId`)

0.001

1 call
1 row

0.001

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

0.001

1 call
1 row

0.001

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

0.001

1 call
3 rows

0.001

SELECT * FROM PriceType ORDER BY orderindex, id

0.001

1 call
2 rows

0.001

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.001

1 call
173 rows

0.001

SELECT * FROM webselect

0.001

1 call
1 row

0.001

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`=0x8A4D6E000000E3 ORDER BY ProductPrice.description NOT LIKE '%Ret./Whslr.%', ProductPrice.description NOT LIKE '%NAPAR%', ProductPrice.description NOT LIKE '%Associate Member%', minQuantity IS NOT NULL, minQuantity, maxQuantity

0.001

2 calls
28 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
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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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 = 0xA1F01900000005) ORDER BY `Product`.`name`

0.001

1 call
0 rows

0.001

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`=0xF569D700000011 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
13 rows

0.001

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x858C1800000023=`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(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (SpecialOffer, Product, ProductPrice2SpecialOffer, ProductPrice) WHERE ((`ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0xA1F01900000005 AND (`ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)) AND `SpecialOffer`.`expires`>'2025-12-26 08:40:40')

0.001

1 call
1 row

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xE3897A00000001 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.001

2 calls
1 row

0.000

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

0.001

2 calls
1 row

0.000

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

0.001

1 call
0 rows

0.001

1 call
1 row

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xE1F6BA00000001 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xF569D700000002 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xF569D700000006 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

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

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0xF569D700000002 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

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

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

1917709 function calls (1903939 primitive calls) in 7.034 seconds Ordered by: cumulative time List reduced from 2678 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 7.036 7.036 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 6.351 6.351 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 6.306 6.306 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 6.306 6.306 /data/fmiam/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 6.280 6.280 /data/fmiam/current/libs/framework/WebForm.py:189(view) 1 0.000 0.000 5.754 5.754 /data/fmiam/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 5.754 5.754 /data/fmiam/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 4.625 4.625 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 4.624 4.624 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 2.569 2.569 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1 0.000 0.000 2.569 2.569 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 2.569 2.569 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 2.569 1.284 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 2.569 2.569 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 2.569 2.569 /usr/lib/python3.11/urllib/request.py:1307(do_open) 1 0.000 0.000 2.531 2.531 /usr/lib/python3.11/http/client.py:1351(getresponse) 1 0.000 0.000 2.531 2.531 /usr/lib/python3.11/http/client.py:318(begin) 6 0.000 0.000 2.531 0.422 /usr/lib/python3.11/socket.py:704(readinto) 6 0.000 0.000 2.531 0.422 /usr/lib/python3.11/ssl.py:1299(recv_into) 6 0.000 0.000 2.531 0.422 /usr/lib/python3.11/ssl.py:1157(read) 6 2.531 0.422 2.531 0.422 {method 'read' of '_ssl._SSLSocket' objects} 65 0.000 0.000 2.531 0.039 {method 'readline' of '_io.BufferedReader' objects} 1 0.000 0.000 2.531 2.531 /usr/lib/python3.11/http/client.py:285(_read_status) 17 0.000 0.000 1.349 0.079 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 17 0.000 0.000 1.349 0.079 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 17 0.000 0.000 1.348 0.079 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 17 0.000 0.000 1.317 0.077 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 25 0.000 0.000 1.317 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 25 0.015 0.001 1.314 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 12 0.000 0.000 1.249 0.104 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 1.247 0.104 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 1.247 0.104 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 1.243 0.104 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 1.243 0.104 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.031 0.003 1.242 0.103 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 1.214 1.214 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:530(_addStylesAndScripts) 1 0.000 0.000 1.129 1.129 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:718(process) 2 0.000 0.000 1.111 0.556 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup) 10913 0.037 0.000 0.892 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.882 0.882 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:498(_includeMaxxJavascript) 10913 0.053 0.000 0.654 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.614 0.614 /data/fmiam/current/libs/framework/WebManager.py:88(createNewHandler) 1 0.001 0.001 0.614 0.614 /data/fmiam/current/libs/framework/WebSite.py:91(__init__) 1 0.001 0.001 0.575 0.575 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:663(addMetaTags) 10913 0.030 0.000 0.553 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 7427 0.084 0.000 0.485 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 58347/57925 0.142 0.000 0.445 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 2011/1957 0.012 0.000 0.425 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 10930 0.059 0.000 0.407 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 361/175 0.011 0.000 0.407 0.002 {built-in method builtins.exec} 7/1 0.000 0.000 0.400 0.400 /data/fmiam/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 10/1 0.000 0.000 0.400 0.400 /data/fmiam/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 204/130 0.001 0.000 0.398 0.003 :1165(_find_and_load) 204/130 0.001 0.000 0.392 0.003 :1120(_find_and_load_unlocked) 223/147 0.001 0.000 0.378 0.003 :666(_load_unlocked) 41300 0.119 0.000 0.377 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 224/150 0.004 0.000 0.368 0.002 :934(exec_module) 10913 0.065 0.000 0.366 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 130 0.001 0.000 0.339 0.003 /data/fmiam/current/libs/framework/DGEAttribute.py:138(getBBTDictionary) 1 0.000 0.000 0.332 0.332 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:477(_includeMaxxCSS) 1 0.008 0.008 0.318 0.318 /data/fmiam/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 1929 0.011 0.000 0.317 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 120 0.001 0.000 0.301 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 120 0.001 0.000 0.300 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.284 0.284 /data/fmiam/current/libs/framework/DisplayGroup.py:311(initialize) 4 0.000 0.000 0.277 0.069 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 2595/4 0.056 0.000 0.277 0.069 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 2595/4 0.035 0.000 0.277 0.069 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 18 0.000 0.000 0.268 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 18 0.030 0.002 0.268 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 120 0.000 0.000 0.260 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 120 0.259 0.002 0.259 0.002 {function Connection.query at 0xfd2ae62ad800} 22315 0.166 0.000 0.257 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 1 0.000 0.000 0.242 0.242 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:654(prepMetaTags) 58371/57929 0.116 0.000 0.241 0.000 {built-in method builtins.__import__} 3554 0.006 0.000 0.223 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 456/273 0.000 0.000 0.219 0.001 :233(_call_with_frames_removed) 3554 0.013 0.000 0.214 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 17929 0.069 0.000 0.198 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 5540 0.054 0.000 0.196 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 2 0.000 0.000 0.195 0.098 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 85 0.001 0.000 0.183 0.002 /data/fmiam/current/libs/framework/DGEAttribute.py:57(getEditHTML) 2 0.001 0.000 0.181 0.090 /data/fmiam/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML) 8 0.010 0.001 0.179 0.022 /data/fmiam/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile) 224 0.003 0.000 0.176 0.001 :1007(get_code) 10913 0.042 0.000 0.174 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:501(get_tag) 2719 0.011 0.000 0.173 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 8 0.140 0.017 0.169 0.021 /data/fmiam/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 1 0.000 0.000 0.159 0.159 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin) 1941 0.023 0.000 0.159 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 425 0.002 0.000 0.158 0.000 /data/fmiam/current/libs/framework/DGEAttribute.py:206(getValue) 10913 0.049 0.000 0.157 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:648(match_namespace) 271303/270564 0.151 0.000 0.156 0.000 {built-in method builtins.isinstance} 69 0.000 0.000 0.150 0.002 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 224 0.002 0.000 0.146 0.001 :727(_compile_bytecode) 224 0.143 0.001 0.143 0.001 {built-in method marshal.loads} 85 0.001 0.000 0.139 0.002 /data/fmiam/current/libs/framework/DGEAttribute.py:44(massageDictForEditHTML) 161 0.001 0.000 0.136 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 149 0.000 0.000 0.135 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 630 0.011 0.000 0.134 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1062(startTagListItem)

Description:

Product Details:

Related Products

Mega Menu

Sign Up for the