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` = 'honshusushi.iorderfoods.com/' AND `Module`.`is_delete` = 0 LIMIT 1 | 1 | 1 | 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` = 1230 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `TimeZone`.`difference_in_seconds`, `TimeZone`.`code` FROM `db_restaurant`.`time_zones` AS `TimeZone` WHERE `TimeZone`.`id` = 5 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`time_zone_id` FROM `db_restaurant`.`stores` AS `Store` WHERE `Store`.`id` = 1230 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` = 1230 AND `StoreHoliday`.`is_deleted` = 0 AND `StoreHoliday`.`holiday_date` = '2024-10-22' AND `StoreHoliday`.`is_active` = 1 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 `StoreSetting`.`store_id` = 1230 LIMIT 1 | 1 | 1 | 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`.`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` = 'honshusushi.iorderfoods.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` = (1230) | 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` = (1230) 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` = (1230) 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` = 1230 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `TimeZone`.`code` FROM `db_restaurant`.`time_zones` AS `TimeZone` WHERE `TimeZone`.`id` = 5 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `db_restaurant`.`store_holidays` AS `StoreHoliday` WHERE `StoreHoliday`.`store_id` = 1230 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` = 1230 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` = 1230 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` = 1230 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` = 1230 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `StoreFeaturedSection`.`id`, `StoreFeaturedSection`.`featured_name`, `StoreFeaturedSection`.`image`, `StoreFeaturedSection`.`background_image` FROM `db_restaurant`.`store_featured_sections` AS `StoreFeaturedSection` WHERE `StoreFeaturedSection`.`store_id` = 1230 AND `StoreFeaturedSection`.`merchant_id` = 518 AND `StoreFeaturedSection`.`is_active` = 1 AND `StoreFeaturedSection`.`is_deleted` = 0 ORDER BY `StoreFeaturedSection`.`position` asc | 10 | 10 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5931) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5932) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5933) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5934) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5935) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5936) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5937) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5938) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5939) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `FeaturedItem`.`id`, `FeaturedItem`.`item_id`, `FeaturedItem`.`store_featured_section_id` FROM `db_restaurant`.`featured_items` AS `FeaturedItem` WHERE `FeaturedItem`.`is_deleted` = 0 AND `FeaturedItem`.`is_active` = 1 AND `FeaturedItem`.`store_id` = 1230 AND `FeaturedItem`.`merchant_id` = 518 AND `FeaturedItem`.`store_featured_section_id` = (5940) ORDER BY `FeaturedItem`.`position` asc LIMIT 4 | 0 | 0 | 2 | maybe slow |
SELECT `Store`.`deal_page`, `Store`.`id` FROM `db_restaurant`.`stores` AS `Store` LEFT JOIN `db_restaurant`.`store_fonts` AS `StoreFont` ON (`Store`.`store_font_id` = `StoreFont`.`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`.`id` = 1230 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` = (1230) | 7 | 7 | 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` = 1230 AND `added_from` = 1 AND `page_name` = '1' 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` = 1230 AND `added_from` = 1 AND `page_name` = '1' ORDER BY `position` ASC LIMIT 1 | 0 | 0 | 2 | maybe slow |
2 duplicate queries run.