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

Managerial Best Practices: Guide for Food Retail Store Managers and Food Warehouse Managers

For FMI by Ernest Baskin, Ph.D., Gerald E. Peck Fellow and assistant professor of food marketing in the Erivan K. Haub School of Business at Saint Joseph’s University

Format:
Digital

Members/Non Members - $0.00

Description:

As the third in a three-part Gerald E. Peck Fellowship research series that explores workforce attractiveness in the food retail industry, this report explores managerial best practices at the store/warehouse level to help improve employee retention. The report is authored by Ernest Baskin, Ph.D., Gerald E. Peck Fellow and assistant professor of food marketing in the Erivan K. Haub School of Business at Saint Joseph’s University.

Product Details:

Product ID: 1000310
Publication Year: 2023
Pages, Size, or Length: 19 pages
Debugging Info
pagedictsize=713
sqltime = 0.092 s
cpu time = 1.100 s
real time = 1.965 s
memory increase = 18432 kB
fields =
templates =
/data/fmiam/current/fmiam_org/themes/www/dgelements/money
/data/fmiam/current/fmiam_org/themes/www/dgelements/moneyView
/data/fmiam/current/fmiam_org/themes/www/footer
/data/fmiam/current/fmiam_org/themes/www/store_header
/data/fmiam/current/generic/themes/shared/dgelements/button
/data/fmiam/current/generic/themes/shared/dgelements/checkbox
/data/fmiam/current/generic/themes/shared/dgelements/checkboxyesno
/data/fmiam/current/generic/themes/shared/dgelements/date
/data/fmiam/current/generic/themes/shared/dgelements/datetime
/data/fmiam/current/generic/themes/shared/dgelements/fileView
/data/fmiam/current/generic/themes/shared/dgelements/find
/data/fmiam/current/generic/themes/shared/dgelements/input
/data/fmiam/current/generic/themes/shared/dgelements/objectSelect
/data/fmiam/current/generic/themes/shared/dgelements/radio
/data/fmiam/current/generic/themes/shared/dgelements/radioLinear
/data/fmiam/current/generic/themes/shared/dgelements/select
/data/fmiam/current/generic/themes/shared/dgelements/submitButton
/data/fmiam/current/generic/themes/shared/dgelements/text
/data/fmiam/current/generic/themes/shared/dgelements/view
/data/fmiam/current/generic/themes/shared/dgelements/viewHref
/data/fmiam/current/generic/themes/shared/mako/dgelements/file.html
/data/fmiam/current/generic/themes/www/mako/store/viewProduct.html
scrapeAndDrape FRESH stub: https://www.fmiam.maxx.matrixdev.net/scrape.axd?target=https://www.fmiam.maxx.matrixdev.net/store/full-width-stub
dg = ['viewProduct'] | [80040]
extra debug info =
queries = 84 queries

Total TimeCountAvg TimeQuery
0.0121 call
1 row
0.012 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`='managerial-best-practices' ORDER BY `Product`.`name`
0.01024 calls
1 row
0.000 SELECT version from databasemap;
0.0051 call
0 rows
0.005 COMMIT
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Product) WHERE `Product`.`downloadFileId`=`File`.`FileId` AND `Product`.`ProductId`=0x74191E00000064
0.0031 call
13 rows
0.003 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x74191E00000065=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0031 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 (ProductPrice, Product) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x74191E00000064 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.0031 call
2 rows
0.003 SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category2Product, Category, Product) WHERE (0x74191E00000064=`Product`.`ProductId` AND `Product`.`ProductId`=`Category2Product`.`ProductId` AND `Category2Product`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`
0.0032 calls
1 row
0.002 select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0x74191E00000064
0.0031 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 (ProductPrice, Product) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x6BF3DD00000385 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.0031 call
0 rows
0.003 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 (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF568AB0000000E ORDER BY `Committee`.`category`, `Committee`.`name`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (SpecialOffer, Product) WHERE `SpecialOffer`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x74191E00000064
0.0031 call
0 rows
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`.`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`=0xF568AB00000002 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0031 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`.`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`=0x3E9DC000000236 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
0 rows
0.002 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`=0xF568AB00000006 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0022 calls
5 rows
0.001 SELECT * FROM Language ORDER BY orderindex, id
0.0021 call
13 rows
0.002 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x6635060000020B=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0021 call
1 row
0.002 SELECT * FROM uuid FOR UPDATE
0.0021 call
13 rows
0.002 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType, MembershipType2Product, Product) WHERE (0x74191E00000064=`Product`.`ProductId` AND `Product`.`ProductId`=`MembershipType2Product`.`ProductId` AND `MembershipType2Product`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0021 call
0 rows
0.002 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`=0xF568AB00000006 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0021 call
1 row
0.002 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`=0x74191E00000066 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0021 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 (ProductPrice, MailingList2ProductPrice, MailingList) WHERE (0x74191E00000065=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`
0.0021 call
13 rows
0.002 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x6BF3DD00000386=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0021 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 (ProductPrice, Product) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x66355600000021 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.0011 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`=0x741A9B00000001 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ChildProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x74191E00000064
0.0011 call
0 rows
0.001 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 06:31:49',`mxxCreatedBy`=NULL, `PageRequestId`=0xF568AB00000000, `path`='forms/store/ProductFormPublic/managerial-best-practices', `formName`='fmiam_ProductFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3269583', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='489824', `startTime`='2025-12-26 06:31:49', `sessionId`=0x72CEF0FFFC3C51DF, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.150'
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice2SpecialOffer, SpecialOffer, ProductPrice) WHERE (0x74191E00000065=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice2SpecialOffer, SpecialOffer, ProductPrice) WHERE (0x6635060000020B=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)
0.0011 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 (Product2MailingList, Product, MailingList) WHERE (0x74191E00000064=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2MailingList`.`ProductId` AND `Product2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`
0.0011 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 = 0x74191E00000064) ORDER BY `Product`.`name`
0.0012 calls
1 row
0.000 select max(returnOrder) from Stack where sessionId = 8272814547765318111
0.0011 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`=0xF568AB00000002 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0012 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.0012 calls
2 rows
0.000 SELECT * FROM ProductActivationStatus ORDER BY orderindex, id
0.0011 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 (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF568AB00000011 ORDER BY `Committee`.`category`, `Committee`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`FileProtectionType`.`FileProtectionTypeId`) AS `FileProtectionTypeId`, `FileProtectionType`.`name`, `FileProtectionType`.`description`, `FileProtectionType`.`path`, `FileProtectionType`.`prefix` FROM (File, FileProtectionType) WHERE `File`.`FileId`=0x741AB300000002 AND `File`.`fileProtectionTypeId`=`FileProtectionType`.`FileProtectionTypeId`
0.0011 call
173 rows
0.001 SELECT * FROM webselect
0.0012 calls
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0011 call
2 rows
0.001 SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ParentProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x74191E00000064
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (SpecialOffer, ProductPrice, ProductPrice2SpecialOffer, Product) WHERE ((`ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x74191E00000064 AND (`ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)) AND `SpecialOffer`.`expires`>'2025-12-26 06:31:49')
0.0002 calls
1 row
0.000 select mxxCreated, mxxUpdated from Product where ProductId=0x74191E00000064;
0.0001 call
1 row
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 (Product) WHERE `Product`.`ProductId`=0x74191E00000064 ORDER BY `Product`.`name`
0.0001 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, Product2Site) WHERE (0x74191E00000064=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2Site`.`ProductId` AND `Product2Site`.`SiteId`=`Site`.`SiteId`)
0.0001 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, ProductFeaturedOn2Site, Product) WHERE (0x74191E00000064=`Product`.`ProductId` AND `Product`.`ProductId`=`ProductFeaturedOn2Site`.`ProductId` AND `ProductFeaturedOn2Site`.`SiteId`=`Site`.`SiteId`)
0.0001 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`=0x3E9DC000000236
0.0001 call
21 rows
0.000 SELECT * FROM ProductType ORDER BY orderindex, id
0.0001 call
13 rows
0.000 SELECT * FROM Folks ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType, Product) WHERE `Product`.`ProductId`=0x74191E00000064 AND `Product`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`
0.0001 call
3 rows
0.000 SELECT * FROM PriceType ORDER BY orderindex, id
0.0001 call
2 rows
0.000 SELECT * FROM ProductStatus ORDER BY orderindex, id
0.0001 call
12 rows
0.000 SELECT * FROM Month ORDER BY orderindex, id
0.0001 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 (0x6BF3DD00000386=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)
0.0001 call
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0001 call
0 rows
0.000 START TRANSACTION