Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Module`.`id`, `Module`.`store_id`, `Module`.`merchant_id`, `Module`.`subdomain`, `Module`.`displayController`, `Module`.`displayAction`, `Module`.`is_ssl`, `Module`.`is_www`, `Module`.`type`, `Module`.`is_active`, `Module`.`is_delete`, `Module`.`created`, `Module`.`modified` FROM `db_restaurant`.`modules` AS `Module` WHERE `Module`.`subdomain` = 'abwbowie.com/products' AND `Module`.`is_delete` = 0 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `MainSiteSetting`.`id`, `MainSiteSetting`.`api_key`, `MainSiteSetting`.`api_username`, `MainSiteSetting`.`api_password`, `MainSiteSetting`.`super_email`, `MainSiteSetting`.`twilio_number`, `MainSiteSetting`.`twilio_api_key`, `MainSiteSetting`.`twilio_api_token`, `MainSiteSetting`.`twilio_api_username`, `MainSiteSetting`.`twilio_api_password`, `MainSiteSetting`.`google_site_key`, `MainSiteSetting`.`google_secret_key`, `MainSiteSetting`.`google_api_key`, `MainSiteSetting`.`google_application_name`, `MainSiteSetting`.`google_client_id`, `MainSiteSetting`.`google_client_secret`, `MainSiteSetting`.`google_redirect_uri`, `MainSiteSetting`.`smtp_port`, `MainSiteSetting`.`smtp_host`, `MainSiteSetting`.`smtp_username`, `MainSiteSetting`.`smtp_password`, `MainSiteSetting`.`is_active`, `MainSiteSetting`.`is_deleted`, `MainSiteSetting`.`created`, `MainSiteSetting`.`modified` FROM `db_restaurant`.`main_site_settings` AS `MainSiteSetting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`dst`, `Store`.`time_zone_id`, `Store`.`time_formate` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` IS NULL LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `CountryCode`.`id`, `CountryCode`.`code` FROM `db_restaurant`.`country_codes` AS `CountryCode` WHERE 1 = 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`merchant_id`, `Store`.`store_name`, `Store`.`store_url`, `Store`.`email_id`, `Store`.`service_fee`, `Store`.`delivery_fee`, `Store`.`minimum_order_price`, `Store`.`phone`, `Store`.`time_zone_id`, `Store`.`merchant_number`, `Store`.`nztoken`, `Store`.`nzgateway_apikey` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`store_url` = 'abwbowie.com' AND `Store`.`is_deleted` = 0 AND `Store`.`is_active` = 1 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`store_name`, `Store`.`store_logo`, `Store`.`merchant_id`, `Store`.`is_store_logo`, `Store`.`background_image`, `Store`.`guest_user`, `Store`.`minimum_order_price`, `Store`.`minimum_takeaway_price`, `Store`.`delivery_description`, `Store`.`take_away_description`, `Store`.`latitude`, `Store`.`logitude`, `SocialMedia`.*, `Store`.`navigation`, `StoreTheme`.`name`, `StoreTheme`.`body_horizontal`, `StoreTheme`.`main_horizontal`, `StoreTheme`.`body_vertical`, `StoreTheme`.`main_vertical`, `StoreTheme`.`keyword`, `StoreTheme`.`layout`, `StoreFont`.`name`, `StoreFont`.`class`, `Store`.`is_not_photo`, `Store`.`is_booking_open`, `Store`.`is_delivery`, `Store`.`is_take_away`, `Store`.`store_hours`, `Store`.`logotype`, `Store`.`deal_page`, `Store`.`phone`, `Store`.`address`, `Store`.`city`, `Store`.`state`, `Store`.`zipcode`, `Store`.`review_page`, `Store`.`theme_color_id`, `Store`.`store_theme_id`, `Store`.`display_email`, `TermsAndPolicy`.`id`, `TermsAndPolicy`.`terms_and_conditions`, `TermsAndPolicy`.`privacy_policy`, `Store`.`guest_user_cod`, `Store`.`store_url` FROM `db_restaurant`.`stores` AS `Store` LEFT JOIN `db_restaurant`.`store_themes` AS `StoreTheme` ON (`Store`.`store_theme_id` = `StoreTheme`.`id`) LEFT JOIN `db_restaurant`.`store_fonts` AS `StoreFont` ON (`Store`.`store_font_id` = `StoreFont`.`id`) LEFT JOIN `db_restaurant`.`social_media` AS `SocialMedia` ON (`SocialMedia`.`store_id` = `Store`.`id`) LEFT JOIN `db_restaurant`.`terms_and_policies` AS `TermsAndPolicy` ON (`TermsAndPolicy`.`store_id` = `Store`.`id` AND `TermsAndPolicy`.`is_active` = 1 AND `TermsAndPolicy`.`is_deleted` = 0) WHERE `Store`.`store_url` = 'abwbowie.com' AND `Store`.`is_deleted` = 0 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreAvailability`.`id`, `StoreAvailability`.`day_name`, `StoreAvailability`.`store_id`, `StoreAvailability`.`start_time`, `StoreAvailability`.`end_time`, `StoreAvailability`.`is_closed` FROM `db_restaurant`.`store_availabilities` AS `StoreAvailability` WHERE `StoreAvailability`.`is_active` = 1 AND `StoreAvailability`.`is_deleted` = 0 AND `StoreAvailability`.`store_id` = (1299) | 7 | 7 | 2 | maybe slow |
SELECT `StoreGallery`.`id`, `StoreGallery`.`image`, `StoreGallery`.`description`, `StoreGallery`.`position`, `StoreGallery`.`store_id`, `StoreGallery`.`merchant_id`, `StoreGallery`.`is_active`, `StoreGallery`.`is_deleted`, `StoreGallery`.`created`, `StoreGallery`.`modified` FROM `db_restaurant`.`store_galleries` AS `StoreGallery` WHERE `is_active` = 1 AND `is_deleted` = 0 AND `StoreGallery`.`store_id` = (1299) ORDER BY `StoreGallery`.`position` ASC | 1 | 1 | 2 | maybe slow |
SELECT `StoreContent`.`name`, `StoreContent`.`id`, `StoreContent`.`page_position`, `StoreContent`.`position`, `StoreContent`.`store_id` FROM `db_restaurant`.`store_contents` AS `StoreContent` WHERE `is_active` = 1 AND `is_deleted` = 0 AND `StoreContent`.`store_id` = (1299) ORDER BY `StoreContent`.`position` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Store`.`dst`, `Store`.`time_zone_id`, `Store`.`time_formate` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `TimeZone`.`code` FROM `db_restaurant`.`time_zones` AS `TimeZone` WHERE `TimeZone`.`id` = 8 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `db_restaurant`.`store_holidays` AS `StoreHoliday` WHERE `StoreHoliday`.`store_id` = 1299 AND `StoreHoliday`.`is_deleted` = 0 AND `StoreHoliday`.`holiday_date` = '2024-10-22' AND `StoreHoliday`.`is_active` = 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`order_allow`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`disable_notip`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Statement`.`id`, `Statement`.`store_id`, `Statement`.`merchant_id`, `Statement`.`store_name`, `Statement`.`updated_date`, `Statement`.`web_url`, `Statement`.`email`, `Statement`.`phone`, `Statement`.`is_active`, `Statement`.`created`, `Statement`.`modified` FROM `db_restaurant`.`statements` AS `Statement` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreStyle`.`id`, `StoreStyle`.`store_id`, `StoreStyle`.`merchant_id`, `StoreStyle`.`store_theme_id`, `StoreStyle`.`navigation`, `StoreStyle`.`css`, `StoreStyle`.`theme_color`, `StoreStyle`.`hover_color`, `StoreStyle`.`order_online_button`, `StoreStyle`.`top_menu_background`, `StoreStyle`.`top_menu_indicator_point`, `StoreStyle`.`navigation_background`, `StoreStyle`.`navigation_link`, `StoreStyle`.`online_order_button_hover`, `StoreStyle`.`button_border`, `StoreStyle`.`page_title`, `StoreStyle`.`created`, `StoreStyle`.`modified` FROM `db_restaurant`.`store_styles` AS `StoreStyle` WHERE `store_id` = 1299 AND `navigation` = 2 AND `store_theme_id` = 11 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`time_zone_id`, `Store`.`service_fee`, `Store`.`service_fee_type` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`is_delivery`, `Store`.`is_take_away` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`default_ordertype` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreAvailability`.`id`, `StoreAvailability`.`day_name`, `StoreAvailability`.`store_id`, `StoreAvailability`.`start_time`, `StoreAvailability`.`end_time`, `StoreAvailability`.`is_closed`, `StoreAvailability`.`is_active`, `StoreAvailability`.`is_deleted`, `StoreAvailability`.`created`, `StoreAvailability`.`modified` FROM `db_restaurant`.`store_availabilities` AS `StoreAvailability` WHERE `StoreAvailability`.`store_id` = 1299 AND `StoreAvailability`.`is_active` = 1 AND `StoreAvailability`.`is_closed` = 0 AND `StoreAvailability`.`is_deleted` = 0 | 7 | 7 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`store_name`, `Store`.`user_id`, `Store`.`merchant_id`, `Store`.`store_url`, `Store`.`sms_functionality`, `Store`.`minimum_order_price`, `Store`.`minimum_takeaway_price`, `Store`.`delivery_fee`, `Store`.`service_fee`, `Store`.`service_fee_type`, `Store`.`background_image`, `Store`.`navigation`, `Store`.`store_theme_id`, `Store`.`store_font_id`, `Store`.`email_id`, `Store`.`phone`, `Store`.`address`, `Store`.`city`, `Store`.`state`, `Store`.`zipcode`, `Store`.`latitude`, `Store`.`logitude`, `Store`.`store_logo`, `Store`.`is_store_logo`, `Store`.`is_booking_open`, `Store`.`dine_in_description`, `Store`.`is_take_away`, `Store`.`take_away_description`, `Store`.`is_delivery`, `Store`.`delivery_description`, `Store`.`is_break_time`, `Store`.`is_break1`, `Store`.`is_break2`, `Store`.`api_key`, `Store`.`api_username`, `Store`.`api_password`, `Store`.`nzgateway_apikey`, `Store`.`paypal_mode`, `Store`.`paypal_email`, `Store`.`paypal_password`, `Store`.`paypal_signature`, `Store`.`twilio_api_key`, `Store`.`twilio_number`, `Store`.`twilio_api_token`, `Store`.`is_receipt_printer`, `Store`.`is_receipt_category`, `Store`.`is_kitchen_printer`, `Store`.`is_kitchen_category`, `Store`.`is_dinein_printer`, `Store`.`is_signature`, `Store`.`printer_location`, `Store`.`fax_username`, `Store`.`fax_password`, `Store`.`fax_number`, `Store`.`notification_number`, `Store`.`notification_email`, `Store`.`notification_voice`, `Store`.`notification_type`, `Store`.`kitchen_dashboard_type`, `Store`.`is_not_photo`, `Store`.`paypal_business_email`, `Store`.`dst`, `Store`.`time_formate`, `Store`.`time_zone_id`, `Store`.`cash_on_delivery`, `Store`.`is_pay_by_credit_card`, `Store`.`is_express_check_out`, `Store`.`delivery_interval`, `Store`.`delivery_delay`, `Store`.`pick_up_delay`, `Store`.`calendar_limit`, `Store`.`deliverycalendar_limit`, `Store`.`pickcalendar_limit`, `Store`.`deliveryblackout_limit`, `Store`.`pickblackout_limit`, `Store`.`dineinblackout_limit`, `Store`.`close_details`, `Store`.`tip`, `Store`.`store_hours`, `Store`.`guest_user`, `Store`.`guest_user_cod`, `Store`.`pre_order_allowed`, `Store`.`allow_pop_up`, `Store`.`order_type_forms`, `Store`.`cutoff_time`, `Store`.`logotype`, `Store`.`display_email`, `Store`.`display_fax`, `Store`.`is_delivery_beftax`, `Store`.`is_pick_beftax`, `Store`.`is_active`, `Store`.`is_deleted`, `Store`.`is_allow_transaction`, `Store`.`created`, `Store`.`modified`, `Store`.`delivery_zone_type`, `Store`.`deal_page`, `Store`.`review_page`, `Store`.`merchant_number`, `Store`.`credit_card_type`, `Store`.`theme_color_id`, `Store`.`store_info_bg_image`, `Store`.`store_info_description`, `Store`.`nztoken` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreAvailability`.`id`, `StoreAvailability`.`start_time`, `StoreAvailability`.`end_time`, `StoreAvailability`.`day_name`, `StoreAvailability`.`store_id` FROM `db_restaurant`.`store_availabilities` AS `StoreAvailability` WHERE `StoreAvailability`.`day_name` = 'Tuesday' AND `StoreAvailability`.`is_deleted` = 0 AND `StoreAvailability`.`is_active` = 1 AND `is_closed` = 0 AND `StoreAvailability`.`store_id` = (1299) | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 AND `Store`.`is_deleted` = 0 AND `Store`.`is_active` = 1 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreHoliday`.`id`, `StoreHoliday`.`holiday_date`, `StoreHoliday`.`store_id`, `StoreHoliday`.`description`, `StoreHoliday`.`open_late_time`, `StoreHoliday`.`close_early_time`, `StoreHoliday`.`is_open_late_time`, `StoreHoliday`.`is_close_early_time`, `StoreHoliday`.`is_active`, `StoreHoliday`.`is_deleted`, `StoreHoliday`.`created`, `StoreHoliday`.`modified` FROM `db_restaurant`.`store_holidays` AS `StoreHoliday` WHERE `StoreHoliday`.`store_id` = 1299 AND `StoreHoliday`.`holiday_date` = '2024-10-22' AND `StoreHoliday`.`is_deleted` = 0 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `Store`.`delivery_interval`, `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreBreak`.`id`, `StoreBreak`.`store_availablity_id`, `StoreBreak`.`store_id`, `StoreBreak`.`break1_start_time`, `StoreBreak`.`break1_end_time`, `StoreBreak`.`break2_start_time`, `StoreBreak`.`break2_end_time`, `StoreBreak`.`is_active`, `StoreBreak`.`is_deleted`, `StoreBreak`.`created`, `StoreBreak`.`modified` FROM `db_restaurant`.`store_breaks` AS `StoreBreak` WHERE `StoreBreak`.`store_id` = 1299 AND `StoreBreak`.`store_availablity_id` = 5406 AND `StoreBreak`.`is_active` = 1 AND `StoreBreak`.`is_deleted` = 0 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`time_formate`, `Store`.`delivery_delay`, `Store`.`pick_up_delay`, `Store`.`cutoff_time`, `Store`.`deliverycalendar_limit`, `Store`.`pickcalendar_limit` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`is_break_time`, `Store`.`is_break1`, `Store`.`is_break2` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreHoliday`.`id`, `StoreHoliday`.`holiday_date`, `StoreHoliday`.`store_id`, `StoreHoliday`.`description`, `StoreHoliday`.`open_late_time`, `StoreHoliday`.`close_early_time`, `StoreHoliday`.`is_open_late_time`, `StoreHoliday`.`is_close_early_time`, `StoreHoliday`.`is_active`, `StoreHoliday`.`is_deleted`, `StoreHoliday`.`created`, `StoreHoliday`.`modified` FROM `db_restaurant`.`store_holidays` AS `StoreHoliday` WHERE `StoreHoliday`.`store_id` = 1299 AND `StoreHoliday`.`holiday_date` = '2024-10-22' AND `StoreHoliday`.`is_deleted` = 0 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `StoreAvailability`.`id`, `StoreAvailability`.`day_name`, `StoreAvailability`.`start_time`, `StoreAvailability`.`end_time` FROM `db_restaurant`.`store_availabilities` AS `StoreAvailability` WHERE `StoreAvailability`.`store_id` = 1299 AND `StoreAvailability`.`day_name` = 'Tuesday' AND `StoreAvailability`.`is_deleted` = 0 AND `StoreAvailability`.`is_closed` = 0 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`cutoff_time` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`time_formate`, `Store`.`delivery_delay`, `Store`.`pick_up_delay`, `StoreSetting`.`order_time_setting` FROM `db_restaurant`.`stores` AS `Store` LEFT JOIN `db_restaurant`.`store_settings` AS `StoreSetting` ON (`StoreSetting`.`store_id` = 1299) WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`store_id`, `StoreSetting`.`is_creditcard_allow`, `StoreSetting`.`paypal_allow`, `StoreSetting`.`kitchen_printer_allow`, `StoreSetting`.`fax_allow`, `StoreSetting`.`twilio_sms_allow`, `StoreSetting`.`twilio_voice_allow`, `StoreSetting`.`delivery_allow`, `StoreSetting`.`pickup_allow`, `StoreSetting`.`reservations_allow`, `StoreSetting`.`service_fee_allow`, `StoreSetting`.`delivery_zone_type`, `StoreSetting`.`before_tax_delivery`, `StoreSetting`.`before_tax_pickup`, `StoreSetting`.`merchant_online_order_btn`, `StoreSetting`.`merchant_btn_redirect`, `StoreSetting`.`merchant_gift_card_text`, `StoreSetting`.`store_closed`, `StoreSetting`.`save_to_order_btn`, `StoreSetting`.`order_allow`, `StoreSetting`.`display_contact_us_form`, `StoreSetting`.`pos_menu_allow`, `StoreSetting`.`pickup_status`, `StoreSetting`.`delivery_status`, `StoreSetting`.`discount_on_extra_fee`, `StoreSetting`.`tax_on_item_price`, `StoreSetting`.`order_time_setting`, `StoreSetting`.`bypass_date_time`, `StoreSetting`.`gift_card_allow`, `StoreSetting`.`gift_tid`, `StoreSetting`.`gift_security_code`, `StoreSetting`.`limit_gift_cart_count`, `StoreSetting`.`is_allow_giftcardbysuperadmin`, `StoreSetting`.`require_time_response`, `StoreSetting`.`require_time_response_delivery`, `StoreSetting`.`require_time_response_pickup`, `StoreSetting`.`is_store_click`, `StoreSetting`.`is_self_order`, `StoreSetting`.`self_cc_payment`, `StoreSetting`.`pre_order_sameday`, `StoreSetting`.`fb_pixel_code`, `StoreSetting`.`live_store`, `StoreSetting`.`pickup_totalorder`, `StoreSetting`.`pickup_totalminute`, `StoreSetting`.`pickup_newdelay`, `StoreSetting`.`delivery_totalorder`, `StoreSetting`.`delivery_totalminute`, `StoreSetting`.`delivery_newdelay`, `StoreSetting`.`both_orderType`, `StoreSetting`.`total_order`, `StoreSetting`.`total_minute`, `StoreSetting`.`new_delay`, `StoreSetting`.`default_ordertype`, `StoreSetting`.`disable_notip`, `StoreSetting`.`disable_comments`, `StoreSetting`.`doordash`, `StoreSetting`.`disable_notip_doordash`, `StoreSetting`.`doordash_tip`, `StoreSetting`.`super_doordash`, `StoreSetting`.`ada_type` FROM `db_restaurant`.`store_settings` AS `StoreSetting` WHERE `store_id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`delivery_delay`, `Store`.`pick_up_delay` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1299 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`default_discount`, `Category`.`discount_name`, `Category`.`discount_type`, `Category`.`discount`, `Category`.`has_topping`, `Category`.`is_meal`, `Category`.`days`, `Category`.`store_id`, `Category`.`merchant_id`, `Category`.`is_active`, `Category`.`is_deleted`, `Category`.`start_time`, `Category`.`end_time`, `Category`.`is_sizeonly`, `Category`.`is_mandatory`, `Category`.`hide_category`, `Category`.`is_expanded_menu`, `Category`.`min_value`, `Category`.`max_value`, `Category`.`imgcat`, `Category`.`position`, `Category`.`created`, `Category`.`modified` FROM `db_restaurant`.`categories` AS `Category` WHERE `Category`.`store_id` = 1299 AND `Category`.`is_active` = 1 AND `Category`.`is_deleted` = 0 ORDER BY `position` asc | 14 | 14 | 2 | maybe slow |
SELECT `Item`.`id`, `Item`.`name`, `Item`.`category_id`, `Item`.`start_date`, `Item`.`end_date`, `Item`.`image`, `Item`.`description`, `Item`.`is_seasonal_item`, `Item`.`position`, `Item`.`mandatory_item_units`, `Item`.`is_deliverable`, `Item`.`itemtags`, `Item`.`icon_spicy` FROM `db_restaurant`.`items` AS `Item` WHERE `Item`.`is_active` = 1 AND `Item`.`is_deleted` = 0 AND `Item`.`store_id` = 1299 AND `Item`.`category_id` IN (485882, 485890, 485891, 485889, 485883, 485886, 485885, 485884, 485887, 485888, 485892, 485893, 485895, 485896) ORDER BY `position` asc | 116 | 116 | 3 | |
SELECT `ItemPrice`.`id`, `ItemPrice`.`item_id`, `ItemPrice`.`price`, `ItemPrice`.`store_tax_id`, `ItemPrice`.`size_id`, `ItemPrice`.`position` FROM `db_restaurant`.`item_prices` AS `ItemPrice` WHERE `ItemPrice`.`is_active` = 1 AND `ItemPrice`.`is_deleted` = 0 AND `ItemPrice`.`store_id` = 1299 AND `ItemPrice`.`item_id` IN (940586, 940594, 940605, 940652, 940685, 940745, 940587, 940595, 940606, 940637, 940653, 940686, 940588, 940638, 940654, 940664, 940687, 940722, 940589, 940596, 940608, 940639, 940665, 940688, 940597, 940609, 940656, 940666, 940689, 940746, 940598, 940604, 940640, 940667, 940690, 940599, 940658, 940668, 940691, 940747, 940593, 940600, 940641, 940659, 940669, 940692, 940743, 940611, 940670, 940693, 940725, 940748, 940612, 940660, 940671, 940694, 940742, 940602, 940643, 940645, 940672, 940695, 940744, 940613, 940646, 940696, 940723, 940647, 940697, 940648, 940675, 940698, 940649, 940676, 940650, 940677, 940651, 940678, 940679, 940680, 940681, 940682, 940620, 940621, 940622, 940623, 940624, 940712, 940713, 940714, 940715, 940716, 940717, 940718, 940720, 940721, 940615, 940616, 940617, 940618, 940619, 940701, 940702, 940703, 940704, 940705, 940706, 940707, 940708, 940709, 940631, 940632, 940633, 940634, 940635, 940636) ORDER BY `ItemPrice`.`price` ASC | 117 | 117 | 4 | |
SELECT `Interval`.`id` FROM `db_restaurant`.`intervals` AS `Interval` WHERE `Interval`.`store_id` = 1299 AND `Interval`.`is_deleted` = 0 AND `Interval`.`is_active` = 1 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `HomeModal`.`id`, `HomeModal`.`store_id`, `HomeModal`.`merchant_id`, `HomeModal`.`added_from`, `HomeModal`.`modal_box_size_type`, `HomeModal`.`modal_text`, `HomeModal`.`days`, `HomeModal`.`start_date`, `HomeModal`.`end_date`, `HomeModal`.`popup_name`, `HomeModal`.`page_name`, `HomeModal`.`date_enabled`, `HomeModal`.`position`, `HomeModal`.`is_active`, `HomeModal`.`is_deleted`, `HomeModal`.`created`, `HomeModal`.`modified` FROM `db_restaurant`.`home_modals` AS `HomeModal` WHERE `is_active` = 1 AND `is_deleted` = 0 AND `date_enabled` = 1 AND `store_id` = 1299 AND `added_from` = 1 AND `page_name` = '2' AND Date(start_date) <= '2024-10-22' AND Date(end_date) >= '2024-10-22' AND `days` LIKE '%2%' ORDER BY `position` ASC LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `HomeModal`.`id`, `HomeModal`.`store_id`, `HomeModal`.`merchant_id`, `HomeModal`.`added_from`, `HomeModal`.`modal_box_size_type`, `HomeModal`.`modal_text`, `HomeModal`.`days`, `HomeModal`.`start_date`, `HomeModal`.`end_date`, `HomeModal`.`popup_name`, `HomeModal`.`page_name`, `HomeModal`.`date_enabled`, `HomeModal`.`position`, `HomeModal`.`is_active`, `HomeModal`.`is_deleted`, `HomeModal`.`created`, `HomeModal`.`modified` FROM `db_restaurant`.`home_modals` AS `HomeModal` WHERE `is_active` = 1 AND `is_deleted` = 0 AND `date_enabled` = 0 AND `store_id` = 1299 AND `added_from` = 1 AND `page_name` = '2' ORDER BY `position` ASC LIMIT 1 | 0 | 0 | 2 | maybe slow |
9 duplicate queries run.