Gallery

Profiling Summary Report (Time: 0.01741s, Memory: 3,387KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
MinisiteModule/GalleryController::actionIndex 1 0.01493 0.01493 0.01493 0.01493
system.db.CDbCommand.query(SELECT `profile`.`idLocationProfile` AS `t1_c0`, `profile`.`idLocation` AS `t1_c1`, `profile`.`navigationBarColour` AS `t1_c2`, `profile`.`navigationBarTextColour` AS `t1_c3`, `profile`.`customColours` AS `t1_c4`, `profile`.`bookappSiteTheme` AS `t1_c5`, `profile`.`bookTabEnabled` AS `t1_c6`, `profile`.`bookTabName` AS `t1_c7`, `profile`.`bookTabInformation` AS `t1_c8`, `profile`.`bookNewCustomerFields` AS `t1_c9`, `profile`.`bookMode` AS `t1_c10`, `profile`.`bookShowGroupDetail` AS `t1_c11`, `profile`.`bookShowServicePrices` AS `t1_c12`, `profile`.`bookTermsRequireAgreement` AS `t1_c13`, `profile`.`bookTermsTitle` AS `t1_c14`, `profile`.`bookTermsContent` AS `t1_c15`, `profile`.`bookTermsAcceptLabel` AS `t1_c16`, `profile`.`bookAllowWaitlist` AS `t1_c17`, `profile`.`bookAllowWaitSlots` AS `t1_c18`, `profile`.`timetableTabEnabled` AS `t1_c19`, `profile`.`timetableTabName` AS `t1_c20`, `profile`.`timetableTabInformation` AS `t1_c21`, `profile`.`lastMinuteTabEnabled` AS `t1_c22`, `profile`.`lastMinuteTabName` AS `t1_c23`, `profile`.`lastMinuteTabInformation` AS `t1_c24`, `profile`.`contactTabEnabled` AS `t1_c25`, `profile`.`contactTabName` AS `t1_c26`, `profile`.`contactTabContactBusiness` AS `t1_c27`, `profile`.`contactTabContactName` AS `t1_c28`, `profile`.`contactTabContactEmail` AS `t1_c29`, `profile`.`contactTabContactPhone` AS `t1_c30`, `profile`.`contactTabContactWebsite` AS `t1_c31`, `profile`.`contactTabAddressLat` AS `t1_c32`, `profile`.`contactTabAddressLong` AS `t1_c33`, `profile`.`contactTabAddressStreet` AS `t1_c34`, `profile`.`contactTabAddressCity` AS `t1_c35`, `profile`.`contactTabAddressPostcode` AS `t1_c36`, `profile`.`contactTabAddressRegion` AS `t1_c37`, `profile`.`contactTabAddressCountry` AS `t1_c38`, `profile`.`contactTabAddressShowMap` AS `t1_c39`, `profile`.`contactTabHoursEnabled` AS `t1_c40`, `profile`.`contactTabHoursMonday` AS `t1_c41`, `profile`.`contactTabHoursTuesday` AS `t1_c42`, `profile`.`contactTabHoursWednesday` AS `t1_c43`, `profile`.`contactTabHoursThursday` AS `t1_c44`, `profile`.`contactTabHoursFriday` AS `t1_c45`, `profile`.`contactTabHoursSaturday` AS `t1_c46`, `profile`.`contactTabHoursSunday` AS `t1_c47`, `profile`.`galleryTabEnabled` AS `t1_c48`, `profile`.`galleryTabName` AS `t1_c49`, `profile`.`reviewTabEnabled` AS `t1_c50`, `profile`.`reviewTabName` AS `t1_c51`, `profile`.`reviewTabShowService` AS `t1_c52`, `profile`.`reviewTabShowReplies` AS `t1_c53`, `profile`.`giftCardTabEnabled` AS `t1_c54`, `profile`.`giftCardTabName` AS `t1_c55`, `profile`.`giftCardTabInformation` AS `t1_c56`, `profile`.`giftCardTermsRequireAgreement` AS `t1_c57`, `profile`.`giftCardTermsTitle` AS `t1_c58`, `profile`.`giftCardTermsContent` AS `t1_c59`, `profile`.`giftCardTermsAcceptLabel` AS `t1_c60`, `profile`.`passTabEnabled` AS `t1_c61`, `profile`.`passTabName` AS `t1_c62`, `profile`.`passTabInformation` AS `t1_c63`, `profile`.`passTermsRequireAgreement` AS `t1_c64`, `profile`.`passTermsTitle` AS `t1_c65`, `profile`.`passTermsContent` AS `t1_c66`, `profile`.`passTermsAcceptLabel` AS `t1_c67`, `profile`.`twitterTabEnabled` AS `t1_c68`, `profile`.`twitterTabName` AS `t1_c69`, `profile`.`twitterTabUsername` AS `t1_c70`, `profile`.`facebookTabEnabled` AS `t1_c71`, `profile`.`facebookTabName` AS `t1_c72`, `profile`.`facebookTabPageID` AS `t1_c73`, `profile`.`googlePlusTabEnabled` AS `t1_c74`, `profile`.`googlePlusTabName` AS `t1_c75`, `profile`.`googlePlusTabPageID` AS `t1_c76`, `profile`.`pinterestTabEnabled` AS `t1_c77`, `profile`.`pinterestTabName` AS `t1_c78`, `profile`.`pinterestTabUsername` AS `t1_c79`, `profile`.`instagramTabEnabled` AS `t1_c80`, `profile`.`instagramTabName` AS `t1_c81`, `profile`.`instagramTabUsername` AS `t1_c82`, `profile`.`userTabEnabled` AS `t1_c83`, `profile`.`userTabName` AS `t1_c84`, `profile`.`userTabInformation` AS `t1_c85`, `profile`.`userTabShowUpcomingReservations` AS `t1_c86`, `profile`.`userTabShowPastReservations` AS `t1_c87`, `profile`.`userTabShowOrders` AS `t1_c88`, `profile`.`userTabShowGiftCards` AS `t1_c89`, `profile`.`userTabShowPasses` AS `t1_c90`, `profile`.`userTabShowPhotos` AS `t1_c91`, `profile`.`userTabShowBalances` AS `t1_c92`, `profile`.`noticeEnabled` AS `t1_c93`, `profile`.`noticeContent` AS `t1_c94`, `profile`.`created` AS `t1_c95`, `profile`.`modified` AS `t1_c96` FROM `locationProfile` `profile` WHERE (`profile`.`idLocation`=:ypl0)) 2 0.00130 0.00065 0.00064 0.00067
system.db.CDbCommand.query(SELECT `location`.`idLocation` AS `t1_c0`, `location`.`idClient` AS `t1_c1`, `location`.`idAffiliate` AS `t1_c2`, `location`.`idLocationType` AS `t1_c3`, `location`.`signupData` AS `t1_c4`, `location`.`title` AS `t1_c5`, `location`.`slug` AS `t1_c6`, `location`.`firstName` AS `t1_c7`, `location`.`lastName` AS `t1_c8`, `location`.`address` AS `t1_c9`, `location`.`city` AS `t1_c10`, `location`.`region` AS `t1_c11`, `location`.`postcode` AS `t1_c12`, `location`.`country` AS `t1_c13`, `location`.`countryCode` AS `t1_c14`, `location`.`information` AS `t1_c15`, `location`.`phone` AS `t1_c16`, `location`.`lat` AS `t1_c17`, `location`.`lng` AS `t1_c18`, `location`.`timezone` AS `t1_c19`, `location`.`timezoneUnix` AS `t1_c20`, `location`.`timezoneOffsetCurrent` AS `t1_c21`, `location`.`idEmailMasterTemplate` AS `t1_c22`, `location`.`agreedToTerms` AS `t1_c23`, `location`.`agreedToPrivacy` AS `t1_c24`, `location`.`code` AS `t1_c25`, `location`.`email` AS `t1_c26`, `location`.`emailVerification` AS `t1_c27`, `location`.`emailBounced` AS `t1_c28`, `location`.`passwordHash` AS `t1_c29`, `location`.`pinHash` AS `t1_c30`, `location`.`source` AS `t1_c31`, `location`.`hasLogoImage` AS `t1_c32`, `location`.`hasOnlineHeroImage` AS `t1_c33`, `location`.`hasOnlineLogoImage` AS `t1_c34`, `location`.`hasOnlineIconImage` AS `t1_c35`, `location`.`hasImage1` AS `t1_c36`, `location`.`hasImage2` AS `t1_c37`, `location`.`hasImage3` AS `t1_c38`, `location`.`hasImage4` AS `t1_c39`, `location`.`hasImage5` AS `t1_c40`, `location`.`hasGiftCardImage` AS `t1_c41`, `location`.`hasPassImage` AS `t1_c42`, `location`.`employeeMaxOverride` AS `t1_c43`, `location`.`employeePlanOverride` AS `t1_c44`, `location`.`adminNotes` AS `t1_c45`, `location`.`facebookPageID` AS `t1_c46`, `location`.`facebookAccountAuthToken` AS `t1_c47`, `location`.`facebookAuthToken` AS `t1_c48`, `location`.`twitterAuthToken` AS `t1_c49`, `location`.`twitterUsername` AS `t1_c50`, `location`.`resetCode` AS `t1_c51`, `location`.`remindersEnabled` AS `t1_c52`, `location`.`remindersTime` AS `t1_c53`, `location`.`remindersConfirmationsEnabled` AS `t1_c54`, `location`.`remindersSmsEnabled` AS `t1_c55`, `location`.`remindersSmsBody` AS `t1_c56`, `location`.`reviewRemindersEnabled` AS `t1_c57`, `location`.`reviewRemindersTime` AS `t1_c58`, `location`.`reviewAlertEmployees` AS `t1_c59`, `location`.`birthdayMessageEnabled` AS `t1_c60`, `location`.`birthdayMessageTime` AS `t1_c61`, `location`.`sendInternalReservationCreateNotifications` AS `t1_c62`, `location`.`sendInternalReservationMoveNotifications` AS `t1_c63`, `location`.`sendInternalReservationConfirmNotifications` AS `t1_c64`, `location`.`sendInternalReservationCancelNotifications` AS `t1_c65`, `location`.`sendInternalReservationCheckInNotifications` AS `t1_c66`, `location`.`sendInternalReservationNoShowNotifications` AS `t1_c67`, `location`.`sendInternalCustomerCreateNotifications` AS `t1_c68`, `location`.`sendInternalOrderCloseNotifications` AS `t1_c69`, `location`.`enablePassbookIntegration` AS `t1_c70`, `location`.`enableSchemaOrgIntegration` AS `t1_c71`, `location`.`enableConnect` AS `t1_c72`, `location`.`idPhoneNumber` AS `t1_c73`, `location`.`subscriptionIsBeta` AS `t1_c74`, `location`.`subscriptionProvider` AS `t1_c75`, `location`.`subscriptionState` AS `t1_c76`, `location`.`subscriptionStateUpdated` AS `t1_c77`, `location`.`subscriptionEmail` AS `t1_c78`, `location`.`subscriptionIdentifier` AS `t1_c79`, `location`.`subscriptionTemporaryExpiry` AS `t1_c80`, `location`.`idPlan` AS `t1_c81`, `location`.`trialStartTime` AS `t1_c82`, `location`.`trialEndTime` AS `t1_c83`, `location`.`trialNotificationCheckupSent` AS `t1_c84`, `location`.`trialNotificationAlmostOverSent` AS `t1_c85`, `location`.`trialNotificationLastChanceSent` AS `t1_c86`, `location`.`trialNotificationOverSent` AS `t1_c87`, `location`.`massEmailUnsubscribed` AS `t1_c88`, `location`.`slotSize` AS `t1_c89`, `location`.`scheduleDisplaySize` AS `t1_c90`, `location`.`scheduleShowPrices` AS `t1_c91`, `location`.`bookingThreshold` AS `t1_c92`, `location`.`bookingFutureLimit` AS `t1_c93`, `location`.`currencySymbol` AS `t1_c94`, `location`.`defaultPhonePrefix` AS `t1_c95`, `location`.`defaultPhonePrefixReplaces` AS `t1_c96`, `location`.`locale` AS `t1_c97`, `location`.`enabled` AS `t1_c98`, `location`.`deleted` AS `t1_c99`, `location`.`created` AS `t1_c100`, `location`.`modified` AS `t1_c101`, `location`.`widgetCSS` AS `t1_c102`, `location`.`minisiteCSS` AS `t1_c103`, `location`.`facebookCSS` AS `t1_c104`, `location`.`receiptHeader` AS `t1_c105`, `location`.`receiptFooter` AS `t1_c106`, `location`.`appPINRequired` AS `t1_c107`, `location`.`appPINTimeout` AS `t1_c108`, `location`.`webPINRequired` AS `t1_c109`, `location`.`webPINTimeout` AS `t1_c110`, `location`.`emailUseInternal` AS `t1_c111`, `location`.`transactionalEmailProvider` AS `t1_c112`, `location`.`customerReservationCancel` AS `t1_c113`, `location`.`customerReservationCancelWindow` AS `t1_c114`, `location`.`customerReservationCancelNotice` AS `t1_c115`, `location`.`customerReservationMove` AS `t1_c116`, `location`.`customerReservationMoveWindow` AS `t1_c117`, `location`.`sendNotificationOnCheckIn` AS `t1_c118`, `location`.`extraSmsCredit` AS `t1_c119`, `location`.`smsIncludedOverride` AS `t1_c120`, `location`.`smsCountry` AS `t1_c121`, `location`.`smsSendingCountry` AS `t1_c122`, `location`.`smsAutoTopupEnabled` AS `t1_c123`, `location`.`smsAutoTopupLimit` AS `t1_c124`, `location`.`smsAutoTopupRefill` AS `t1_c125`, `location`.`smsFromNumber` AS `t1_c126`, `location`.`allowInternetMultiService` AS `t1_c127`, `location`.`allowInternetSelectEmployee` AS `t1_c128`, `location`.`reservationRateWarningThreshold` AS `t1_c129`, `location`.`loyaltyEnabled` AS `t1_c130`, `location`.`loyaltyPointsBuyMoneyUnit` AS `t1_c131`, `location`.`loyaltyPointsEarnMoneyUnit` AS `t1_c132`, `location`.`loyaltyIncludeTax` AS `t1_c133`, `location`.`orderTaxDetails` AS `t1_c134`, `location`.`defaultCustomerSendNotifications` AS `t1_c135`, `location`.`minisiteEnabled` AS `t1_c136`, `location`.`minisiteVersion` AS `t1_c137`, `location`.`onlineOrderRequestRemainder` AS `t1_c138`, `location`.`onlinePaymentDepositRequired` AS `t1_c139`, `location`.`onlinePaymentDepositRequiredType` AS `t1_c140`, `location`.`onlinePaymentCaptureDetails` AS `t1_c141`, `location`.`onlinePaymentProcessor` AS `t1_c142`, `location`.`onlinePaymentAllowPayLater` AS `t1_c143`, `location`.`onlinePaymentAllowPayInFull` AS `t1_c144`, `location`.`onlinePaymentMessageTemplate` AS `t1_c145`, `location`.`onlinePaymentCaptureMessageTemplate` AS `t1_c146`, `location`.`onlineBookingConversionCode` AS `t1_c147`, `location`.`onlineBookingAllowNewRegistrations` AS `t1_c148`, `location`.`onlineBookingIPBlacklist` AS `t1_c149`, `location`.`onlineBookingShowCookieConsent` AS `t1_c150`, `location`.`onlineBookingMinimiseGaps` AS `t1_c151`, `location`.`onlineBookingAllowCustomers` AS `t1_c152`, `location`.`waitlistMode` AS `t1_c153`, `location`.`customerConsentEnabled` AS `t1_c154`, `location`.`customerConsentTitle` AS `t1_c155`, `location`.`customerConsentContent` AS `t1_c156`, `location`.`customerConsentAcceptLabel` AS `t1_c157`, `location`.`customerMarketingConsentEnabled` AS `t1_c158`, `location`.`customerMarketingConsentTitle` AS `t1_c159`, `location`.`customerMarketingConsentContent` AS `t1_c160`, `location`.`customerMarketingConsentAcceptLabel` AS `t1_c161`, `location`.`paypalMerchantID` AS `t1_c162`, `location`.`paypalEmail` AS `t1_c163`, `location`.`paypalCurrency` AS `t1_c164`, `location`.`paypalHereAccessToken` AS `t1_c165`, `location`.`paypalHereRefreshToken` AS `t1_c166`, `location`.`paypalHereExpiresIn` AS `t1_c167`, `location`.`stripeAccessToken` AS `t1_c168`, `location`.`stripeRefreshToken` AS `t1_c169`, `location`.`stripePublishableKey` AS `t1_c170`, `location`.`stripeUserID` AS `t1_c171`, `location`.`stripeCurrency` AS `t1_c172`, `location`.`mailchimpAccessToken` AS `t1_c173`, `location`.`mailchimpEndpoint` AS `t1_c174`, `location`.`mailchimpAccountName` AS `t1_c175`, `location`.`mailchimpListID` AS `t1_c176`, `location`.`mailchimpListMergeVars` AS `t1_c177`, `location`.`mailchimpLastSync` AS `t1_c178`, `location`.`xeroAccessToken` AS `t1_c179`, `location`.`xeroAccessTokenSecret` AS `t1_c180`, `location`.`xeroAccessOrgId` AS `t1_c181`, `location`.`alertNotificationSettings` AS `t1_c182`, `location`.`howDidYouFindUs` AS `t1_c183`, `location`.`notesFormulaTemplate` AS `t1_c184`, `location`.`notificationsEnabled` AS `t1_c185`, `location`.`employeeIPRestriction` AS `t1_c186`, `location`.`locationIPBlacklist` AS `t1_c187`, `location`.`giftCardExpiryDays` AS `t1_c188`, `location`.`giftCardPresetAmounts` AS `t1_c189`, `location`.`reportOffsetTimeZone` AS `t1_c190`, `location`.`currentMonthSmsCredits` AS `t1_c191`, `location`.`syncLoggingEnabled` AS `t1_c192`, `location`.`useReplyEmails` AS `t1_c193`, `location`.`showCurrentTimeLine` AS `t1_c194`, `location`.`disableEmailLinkLogins` AS `t1_c195`, `location`.`featuresEnabled` AS `t1_c196`, `location`.`newsLastChecked` AS `t1_c197`, `location`.`dripUserID` AS `t1_c198`, `location`.`dripLastUpdate` AS `t1_c199` FROM `location` `location` WHERE (`location`.`idLocation`=:ypl0)) 1 0.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `locationProfile`) 1 0.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SELECT * FROM `location` `t` WHERE t.idLocation = :idLocation and deleted = 0 LIMIT 1) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `locationReview`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT `customer`.`idCustomer` AS `t1_c0`, `customer`.`guid` AS `t1_c1`, `customer`.`idClient` AS `t1_c2`, `customer`.`firstName` AS `t1_c3`, `customer`.`lastName` AS `t1_c4`, `customer`.`email` AS `t1_c5`, `customer`.`emailBounced` AS `t1_c6`, `customer`.`phone` AS `t1_c7`, `customer`.`homePhone` AS `t1_c8`, `customer`.`workPhone` AS `t1_c9`, `customer`.`code` AS `t1_c10`, `customer`.`passwordHash` AS `t1_c11`, `customer`.`address` AS `t1_c12`, `customer`.`address2` AS `t1_c13`, `customer`.`suburb` AS `t1_c14`, `customer`.`city` AS `t1_c15`, `customer`.`region` AS `t1_c16`, `customer`.`postcode` AS `t1_c17`, `customer`.`country` AS `t1_c18`, `customer`.`company` AS `t1_c19`, `customer`.`occupation` AS `t1_c20`, `customer`.`notes` AS `t1_c21`, `customer`.`gender` AS `t1_c22`, `customer`.`dateOfBirth` AS `t1_c23`, `customer`.`dayOfBirth` AS `t1_c24`, `customer`.`creditBalance` AS `t1_c25`, `customer`.`loyaltyPointBalance` AS `t1_c26`, `customer`.`sendNotifications` AS `t1_c27`, `customer`.`facebookID` AS `t1_c28`, `customer`.`source` AS `t1_c29`, `customer`.`resetCode` AS `t1_c30`, `customer`.`massEmailUnsubscribed` AS `t1_c31`, `customer`.`massSMSUnsubscribed` AS `t1_c32`, `customer`.`birthdayMessageSentForYear` AS `t1_c33`, `customer`.`allowOnlineBooking` AS `t1_c34`, `customer`.`importGuid` AS `t1_c35`, `customer`.`consentAccepted` AS `t1_c36`, `customer`.`marketingConsentAccepted` AS `t1_c37`, `customer`.`deleted` AS `t1_c38`, `customer`.`created` AS `t1_c39`, `customer`.`modified` AS `t1_c40` FROM `customer` `customer` WHERE (`customer`.`idCustomer`=:ypl0)) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `service`.`idService` AS `t1_c0`, `service`.`guid` AS `t1_c1`, `service`.`idLocation` AS `t1_c2`, `service`.`idServiceCategory` AS `t1_c3`, `service`.`title` AS `t1_c4`, `service`.`information` AS `t1_c5`, `service`.`duration` AS `t1_c6`, `service`.`processing` AS `t1_c7`, `service`.`finishing` AS `t1_c8`, `service`.`colour` AS `t1_c9`, `service`.`hasImage` AS `t1_c10`, `service`.`price` AS `t1_c11`, `service`.`priceFrom` AS `t1_c12`, `service`.`costPrice` AS `t1_c13`, `service`.`customerType` AS `t1_c14`, `service`.`customerMax` AS `t1_c15`, `service`.`allowInternet` AS `t1_c16`, `service`.`nextReservationReminderEnabled` AS `t1_c17`, `service`.`nextReservationReminderDays` AS `t1_c18`, `service`.`reviewReminderSendOnce` AS `t1_c19`, `service`.`reviewReminderMode` AS `t1_c20`, `service`.`loyaltyEnabled` AS `t1_c21`, `service`.`multiServiceWeight` AS `t1_c22`, `service`.`onlinePaymentDepositFixed` AS `t1_c23`, `service`.`onlinePaymentDepositFixedType` AS `t1_c24`, `service`.`onlinePaymentRequireCardCapture` AS `t1_c25`, `service`.`customerTimeMode` AS `t1_c26`, `service`.`bufferTimePre` AS `t1_c27`, `service`.`bufferTimePost` AS `t1_c28`, `service`.`bufferTimeMode` AS `t1_c29`, `service`.`listOrder` AS `t1_c30`, `service`.`deleted` AS `t1_c31`, `service`.`created` AS `t1_c32`, `service`.`modified` AS `t1_c33` FROM `service` `service` WHERE (`service`.`idService`=:ypl0)) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `locationProfile`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT `employee`.`idEmployee` AS `t1_c0`, `employee`.`guid` AS `t1_c1`, `employee`.`idLocation` AS `t1_c2`, `employee`.`idCommission` AS `t1_c3`, `employee`.`type` AS `t1_c4`, `employee`.`code` AS `t1_c5`, `employee`.`passwordHash` AS `t1_c6`, `employee`.`pinHash` AS `t1_c7`, `employee`.`firstName` AS `t1_c8`, `employee`.`lastName` AS `t1_c9`, `employee`.`bio` AS `t1_c10`, `employee`.`email` AS `t1_c11`, `employee`.`emailVerification` AS `t1_c12`, `employee`.`phone` AS `t1_c13`, `employee`.`address` AS `t1_c14`, `employee`.`city` AS `t1_c15`, `employee`.`region` AS `t1_c16`, `employee`.`postcode` AS `t1_c17`, `employee`.`country` AS `t1_c18`, `employee`.`allowInternet` AS `t1_c19`, `employee`.`sendNotifications` AS `t1_c20`, `employee`.`allowTeamScheduling` AS `t1_c21`, `employee`.`allowRoster` AS `t1_c22`, `employee`.`allowReporting` AS `t1_c23`, `employee`.`allowOrders` AS `t1_c24`, `employee`.`allowTeamRoster` AS `t1_c25`, `employee`.`allowTeamReporting` AS `t1_c26`, `employee`.`allowTeamOrders` AS `t1_c27`, `employee`.`allowCustomer` AS `t1_c28`, `employee`.`allowCustomerAccess` AS `t1_c29`, `employee`.`allowCustomerDetail` AS `t1_c30`, `employee`.`allowModifySchedule` AS `t1_c31`, `employee`.`allowWaitlist` AS `t1_c32`, `employee`.`allowPurchaseOrders` AS `t1_c33`, `employee`.`allowGiftCards` AS `t1_c34`, `employee`.`allowProducts` AS `t1_c35`, `employee`.`allowServices` AS `t1_c36`, `employee`.`allowForms` AS `t1_c37`, `employee`.`allowMarketing` AS `t1_c38`, `employee`.`allowAppAccess` AS `t1_c39`, `employee`.`allowHistory` AS `t1_c40`, `employee`.`resourceRostered` AS `t1_c41`, `employee`.`onlineBookingMinimiseGaps` AS `t1_c42`, `employee`.`resetCode` AS `t1_c43`, `employee`.`enabled` AS `t1_c44`, `employee`.`hasImage` AS `t1_c45`, `employee`.`loyaltyEnabled` AS `t1_c46`, `employee`.`alertNotificationSettings` AS `t1_c47`, `employee`.`listOrder` AS `t1_c48`, `employee`.`deletedShowToDate` AS `t1_c49`, `employee`.`deleted` AS `t1_c50`, `employee`.`created` AS `t1_c51`, `employee`.`modified` AS `t1_c52` FROM `employee` `employee` WHERE (`employee`.`idEmployee`=:ypl0)) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT `reviews`.`idLocationReview` AS `t1_c0`, `reviews`.`idLocation` AS `t1_c1`, `reviews`.`idCustomer` AS `t1_c2`, `reviews`.`idReservation` AS `t1_c3`, `reviews`.`idService` AS `t1_c4`, `reviews`.`idEmployee` AS `t1_c5`, `reviews`.`recommend` AS `t1_c6`, `reviews`.`comment` AS `t1_c7`, `reviews`.`rating` AS `t1_c8`, `reviews`.`displayName` AS `t1_c9`, `reviews`.`reply` AS `t1_c10`, `reviews`.`approved` AS `t1_c11`, `reviews`.`featured` AS `t1_c12`, `reviews`.`created` AS `t1_c13`, `reviews`.`modified` AS `t1_c14`, `reviews`.`deleted` AS `t1_c15` FROM `locationReview` `reviews` WHERE ((reviews.deleted = 0) AND (approved = 1 and deleted = 0)) AND (`reviews`.`idLocation`=:ypl0) ORDER BY created desc, reviews.created desc LIMIT 1) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `locationReview`) 1 0.00020 0.00020 0.00020 0.00020