Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT Site.*, SiteSetting.* FROM `sites` AS `Site` inner JOIN `site_settings` AS `SiteSetting` ON (`Site`.`id` = `SiteSetting`.`site_id`) WHERE `Site`.`domain` = 'salishsearealestategroup.com' ORDER BY `Site`.`created` ASC LIMIT 1 | | 1 | 1 | 9 | maybe slow |
SELECT * FROM `search_refine_fields` AS `SearchRefineField` WHERE `SearchRefineField`.`site_id` = 903 AND `SearchRefineField`.`status` = 1 | | 2 | 2 | 2 | |
SELECT `CreaFeed`.`id`, `CreaFeed`.`site_id`, `CreaFeed`.`crea_username`, `CreaFeed`.`crea_password`, `CreaFeed`.`crea_username_feed_office`, `CreaFeed`.`crea_password_feed_office`, `CreaFeed`.`crea_username_full`, `CreaFeed`.`crea_password_full`, `CreaFeed`.`crea_full_status`, `CreaFeed`.`vow_active`, `CreaFeed`.`vow_username`, `CreaFeed`.`vow_password`, `CreaFeed`.`vow_status`, `CreaFeed`.`san_diego_active`, `CreaFeed`.`san_diego_status`, `CreaFeed`.`ihome_finder_status`, `CreaFeed`.`ihome_finder_id`, `CreaFeed`.`ihome_finder_board_id`, `CreaFeed`.`ihome_finder_scroll`, `CreaFeed`.`created`, `CreaFeed`.`modified`, `CreaFeed`.`crea_username_destination_id`, `CreaFeed`.`crea_username_feed_office_destination_id`, `CreaFeed`.`crea_username_full_destination_id`, `CreaFeed`.`trreb_active`, `CreaFeed`.`trreb_status` FROM `crea_feeds` AS `CreaFeed` WHERE `site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `CrmUserCredit`.`id`, `CrmUserCredit`.`user_id`, `CrmUserCredit`.`email_credits`, `CrmUserCredit`.`customer_id`, `CrmUserCredit`.`billing_cycle_start_date`, `CrmUserCredit`.`billing_cycle_end_date`, `CrmUserCredit`.`free_email_credits`, `CrmUserCredit`.`paid_email_credits`, `CrmUserCredit`.`monthly_used_email_credits`, `CrmUserCredit`.`last_month_used_email_credits`, `CrmUserCredit`.`total_assigned_email_credits`, `CrmUserCredit`.`email_credits_quota_used`, `CrmUserCredit`.`twilio_sid`, `CrmUserCredit`.`twilio_token`, `CrmUserCredit`.`twilio_phone`, `CrmUserCredit`.`twilio_app_sid`, `CrmUserCredit`.`twilio_api_sid`, `CrmUserCredit`.`twilio_api_secret`, `CrmUserCredit`.`twilo_permission`, `CrmUserCredit`.`enable_incoming_message_notification`, `CrmUserCredit`.`created`, `CrmUserCredit`.`modified`, `CrmUserCredit`.`recieve_incoming_call_phone`, `CrmUserCredit`.`assign_email_credit_permission`, `CrmUserCredit`.`default_free_email_credits`, `CrmUserCredit`.`is_field_show_hide`, `CrmUserCredit`.`enable_twilio_account`, `CrmUserCredit`.`enable_auto_charge_email_credits`, `CrmUserCredit`.`auto_charge_crm_user_payment_method_id`, `CrmUserCredit`.`auto_charge_crm_mass_email_plan_id`, `CrmUserCredit`.`send_email_credit_usage_alert`, `CrmUserCredit`.`enable_new_lead_sms_notification`, `CrmUserCredit`.`ibm_watson_credentials`, `CrmUserCredit`.`crm_menu_position`, `CrmUserCredit`.`enable_twilio_call_recording`, `CrmUserCredit`.`place_twilio_call`, `CrmUserCredit`.`default_voicemail_method`, `CrmUserCredit`.`slybroadcast_uid`, `CrmUserCredit`.`slybroadcast_password`, `CrmUserCredit`.`slybroadcast_caller_id`, `CrmUserCredit`.`enable_slybroadcast_account`, `CrmUserCredit`.`slybroadcast_permission`, `CrmUserCredit`.`sorted_tag_arr`, `CrmUserCredit`.`enable_daily_report_email`, `CrmUserCredit`.`enable_weekely_report_email`, `CrmUserCredit`.`enable_billing_cycle_monthly_notification`, `CrmUserCredit`.`update_lead_basic_info`, `CrmUserCredit`.`quick_access_tags`, `CrmUserCredit`.`enable_system_updates_email`, `CrmUserCredit`.`is_show_lead_sidebar`, `CrmUserCredit`.`draft_email`, `CrmUserCredit`.`outgoing_caller_id`, `CrmUserCredit`.`search_design_type`, `CrmUserCredit`.`twilio_video_enabled`, `CrmUserCredit`.`twilio_video_api_key`, `CrmUserCredit`.`twilio_video_api_secret`, `CrmUserCredit`.`crm_theme_type`, `CrmUserCredit`.`bombbomb_video_api_key`, `CrmUserCredit`.`sorted_auto_tag_arr`, `CrmUserCredit`.`leads_column_state`, `CrmUserCredit`.`lead_summery_blocks_state`, `CrmUserCredit`.`lead_summary_design`, `CrmUserCredit`.`verify_lead_phone`, `CrmUserCredit`.`gen_settings` FROM `crm_user_credits` AS `CrmUserCredit` WHERE `user_id` = 358 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `ChatgptKey`.`id`, `ChatgptKey`.`user_id`, `ChatgptKey`.`key`, `ChatgptKey`.`error` FROM `chatgpt_keys` AS `ChatgptKey` WHERE `user_id` = 358 LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `Logo`.`id`, `Logo`.`user_id`, `Logo`.`is_preset`, `Logo`.`title`, `Logo`.`header_file_name`, `Logo`.`photo_file_name`, `Logo`.`logo_file_name`, `Logo`.`upload_file_name`, `Logo`.`gallery_file_name`, `Logo`.`created`, `Logo`.`modified` FROM `photos` AS `Logo` WHERE `id` = 4688 AND `Logo`.`is_preset` = 1 AND NOT (`logo_file_name` IS NULL) ORDER BY `title` ASC LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `CustomLogosSite`.`id`, `CustomLogosSite`.`site_id`, `CustomLogosSite`.`photo_id`, `CustomLogosSite`.`header_order`, `CustomLogosSite`.`gallery_order`, `CustomLogosSite`.`crop_x`, `CustomLogosSite`.`crop_y`, `CustomLogosSite`.`crop_x2`, `CustomLogosSite`.`crop_y2`, `CustomLogosSite`.`use_custom_size`, `CustomLogosSite`.`custom_width`, `CustomLogosSite`.`custom_height`, `CustomLogosSite`.`description`, `CustomLogosSite`.`is_includephoto_frontend`, `CustomLogosSite`.`header_photo_link`, `CustomLogosSite`.`is_showphoto_otherusers`, (crop_x2 - crop_x) AS `CustomLogosSite__crop_width`, (crop_y2 - crop_y) AS `CustomLogosSite__crop_height`, `Logo`.`id`, `Logo`.`user_id`, `Logo`.`is_preset`, `Logo`.`title`, `Logo`.`header_file_name`, `Logo`.`photo_file_name`, `Logo`.`logo_file_name`, `Logo`.`upload_file_name`, `Logo`.`gallery_file_name`, `Logo`.`created`, `Logo`.`modified` FROM `photos_sites` AS `CustomLogosSite` LEFT JOIN `photos` AS `Logo` ON (`CustomLogosSite`.`photo_id` = `Logo`.`id`) WHERE `photo_id` = 4688 AND `site_id` = 903 AND NOT (`logo_file_name` IS NULL) LIMIT 1 | | 1 | 1 | 2 | maybe slow |
SELECT *, (crop_x2 - crop_x) AS `PhotosSite__crop_width`, (crop_y2 - crop_y) AS `PhotosSite__crop_height` FROM `photos_sites` AS `PhotosSite` INNER JOIN `photos` AS `Logo` ON (`Logo`.`id` = `PhotosSite`.`photo_id`) WHERE `photo_id` = 4226 AND `site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT *, (crop_x2 - crop_x) AS `PhotosSite__crop_width`, (crop_y2 - crop_y) AS `PhotosSite__crop_height` FROM `photos_sites` AS `PhotosSite` INNER JOIN `photos` AS `Logo` ON (`Logo`.`id` = `PhotosSite`.`photo_id`) WHERE `photo_id` = 4226 AND `site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `FollowUpBoss`.`id`, `FollowUpBoss`.`site_id`, `FollowUpBoss`.`is_active`, `FollowUpBoss`.`api_key`, `FollowUpBoss`.`assigned_to_agent`, `FollowUpBoss`.`method`, `FollowUpBoss`.`round_robin_email`, `FollowUpBoss`.`ixact_contact_is_active`, `FollowUpBoss`.`ixact_contact_lead_capture_id`, `FollowUpBoss`.`infusion_soft_contact_active`, `FollowUpBoss`.`infusion_soft_api_key`, `FollowUpBoss`.`infusion_soft_application_name`, `FollowUpBoss`.`solve360_contact_active`, `FollowUpBoss`.`solve360_contact_email`, `FollowUpBoss`.`solve360_contact_token`, `FollowUpBoss`.`pipedrive_active`, `FollowUpBoss`.`pipedrive_token`, `FollowUpBoss`.`contactually_active`, `FollowUpBoss`.`contactually_key`, `FollowUpBoss`.`contactually_source`, `FollowUpBoss`.`enable_bombbomb_api`, `FollowUpBoss`.`bombbomb_api_key`, `FollowUpBoss`.`bombbomb_list_id`, `FollowUpBoss`.`solve360_workgroup_id`, `FollowUpBoss`.`solve360_tag_id`, `FollowUpBoss`.`riley_active`, `FollowUpBoss`.`riley_email`, `FollowUpBoss`.`pipedrive_serialized_data`, `FollowUpBoss`.`track_website_activity`, `FollowUpBoss`.`contactually_bucket_id`, `FollowUpBoss`.`kv_core`, `FollowUpBoss`.`kv_core_email`, `FollowUpBoss`.`enable_sierra`, `FollowUpBoss`.`sierra_api`, `FollowUpBoss`.`sierra_source` FROM `follow_up_bosses` AS `FollowUpBoss` WHERE `FollowUpBoss`.`site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `ContentPage`.`id`, `ContentPage`.`site_id`, `ContentPage`.`link_id`, `ContentPage`.`optin_enabled`, `ContentPage`.`title`, `ContentPage`.`title_params`, `ContentPage`.`slug`, `ContentPage`.`content`, `ContentPage`.`custom_thank_you_message`, `ContentPage`.`is_show_custom_thanks_message`, `ContentPage`.`created`, `ContentPage`.`modified`, `ContentPage`.`description`, `ContentPage`.`team_members`, `ContentPage`.`external_embed_script`, `ContentPage`.`calculator`, `ContentPage`.`affiliates`, `ContentPage`.`external_frame_link`, `ContentPage`.`video`, `ContentPage`.`is_hide_default_report_pdf`, `ContentPage`.`is_display_video`, `ContentPage`.`is_show_sold_listings`, `ContentPage`.`show_open_houses`, `ContentPage`.`enable_cookie`, `ContentPage`.`analytics_code`, `ContentPage`.`why_choose_us`, `ContentPage`.`is_show_scroll_listings`, `ContentPage`.`is_show_videos`, `ContentPage`.`meta_keywords`, `ContentPage`.`optin_type`, `ContentPage`.`is_show_community`, `ContentPage`.`is_show_my_home_val_form`, `ContentPage`.`auto_profile_create`, `ContentPage`.`save_default_search`, `ContentPage`.`scroll_listings_type`, `ContentPage`.`is_show_two_column_layout`, `ContentPage`.`two_column_layout_params`, `ContentPage`.`content_page_desing_params`, `ContentPage`.`content_page_block_name`, `ContentPage`.`show_recent_listings`, `ContentPage`.`partners`, `ContentPage`.`show_default_thanks`, `ContentPage`.`is_show_testimonials`, `ContentPage`.`status`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`user_id_in_rotation`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`logo_id2`, `Site`.`logo2_position`, `Site`.`logo_id3`, `Site`.`logo3_position`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_listings_params`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`video_youtube_display`, `Site`.`video_youtube_params`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`show_manhome_photo`, `Site`.`socialmedia_position`, `Site`.`id_user_id`, `Site`.`id_user_id_always`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`team_rotation_weekdays`, `Site`.`assign_leads_sechdule`, `Site`.`has_profile_pic`, `Site`.`profile_pic_path`, `Site`.`profile_pic_params`, `Site`.`profile_pic_clip`, `Site`.`has_profile_pic_l`, `Site`.`profile_pic_path_l`, `Site`.`profile_pic_params_l`, `Site`.`profile_pic_clip_l`, `Site`.`has_profile_pic_o`, `Site`.`profile_pic_path_o`, `Site`.`profile_pic_params_o`, `Site`.`listing_search_form`, `Site`.`listing_search_place`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`banner_objects`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`custom_address`, `Site`.`address_type`, `Site`.`show_testimonials`, `Site`.`show_testimonial_photo`, `Site`.`show_testimonial_lines`, `Site`.`show_have_question`, `Site`.`show_more_contacts`, `Site`.`scroll_slider_pos`, `Site`.`grl_contact_active`, `Site`.`signature_params`, `Site`.`theme`, `Site`.`theme_name`, `Site`.`testimonial_design`, `Site`.`show_testimonial_rating`, `Site`.`language_translate_code`, `Site`.`top_producer_lead_assignment_method`, `Site`.`signature`, `Site`.`site_timezone`, `Site`.`crm_email`, `Site`.`email_params`, `Site`.`header_photo_params`, `Site`.`listing_rotation`, `Site`.`site_style`, `Site`.`subsite_of`, `Site`.`subsite_params`, `Site`.`is_seo_site`, `Site`.`ssl_protocol`, `Site`.`scroll_feed_settings`, `Site`.`ssl_expire_date`, `Link`.`id`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`site_id`, `Link`.`url`, `Link`.`target_blank`, `Link`.`created`, `Link`.`modified` FROM `content_pages` AS `ContentPage` LEFT JOIN `sites` AS `Site` ON (`ContentPage`.`site_id` = `Site`.`id`) LEFT JOIN `links` AS `Link` ON (`ContentPage`.`link_id` = `Link`.`id`) WHERE `ContentPage`.`site_id` = 903 AND `ContentPage`.`slug` = 'scroll_seo' ORDER BY `ContentPage`.`title` ASC LIMIT 1 | | 0 | 0 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `content_page_blocks` | | 10 | 10 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 | |
SELECT `ContentPageBlock`.`id`, `ContentPageBlock`.`site_id`, `ContentPageBlock`.`name`, `ContentPageBlock`.`type`, `ContentPageBlock`.`order`, `ContentPageBlock`.`show_on_all_pages`, `ContentPageBlock`.`status`, `ContentPageBlock`.`block_params`, `ContentPageBlock`.`created`, `ContentPageBlock`.`modified` FROM `content_page_blocks` AS `ContentPageBlock` WHERE `site_id` = 903 AND `status` = 1 ORDER BY `order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `Color`.`id`, `Color`.`site_id`, `Color`.`color_type_id`, `Color`.`color_theme_id`, `Color`.`title`, `Color`.`valuex`, `Color`.`created`, `Color`.`modified` FROM `colors` AS `Color` WHERE `Color`.`color_type_id` = 22 AND `Color`.`site_id` = 903 ORDER BY `color_type_id` ASC LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Color`.`id`, `Color`.`site_id`, `Color`.`color_type_id`, `Color`.`color_theme_id`, `Color`.`title`, `Color`.`valuex`, `Color`.`created`, `Color`.`modified` FROM `colors` AS `Color` WHERE `Color`.`color_type_id` = 26 AND `Color`.`site_id` = 903 ORDER BY `color_type_id` ASC LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Color`.`id`, `Color`.`site_id`, `Color`.`color_type_id`, `Color`.`color_theme_id`, `Color`.`title`, `Color`.`valuex`, `Color`.`created`, `Color`.`modified` FROM `colors` AS `Color` WHERE `Color`.`color_type_id` = 27 AND `Color`.`site_id` = 903 ORDER BY `color_type_id` ASC LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Color`.`id`, `Color`.`site_id`, `Color`.`color_type_id`, `Color`.`color_theme_id`, `Color`.`title`, `Color`.`valuex`, `Color`.`created`, `Color`.`modified` FROM `colors` AS `Color` WHERE `Color`.`color_type_id` = 28 AND `Color`.`site_id` = 903 ORDER BY `color_type_id` ASC LIMIT 1 | | 1 | 1 | 1 | |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_type_id` = 1 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 6 | 6 | 2 | maybe slow |
SELECT `Link`.`id`, `Link`.`link_type_id`, `Link`.`content_page_id`, `Link`.`url`, `Link`.`target_blank`, `LinkType`.`abbrev`, `LinkType`.`id` FROM `links` AS `Link` LEFT JOIN `link_types` AS `LinkType` ON (`Link`.`link_type_id` = `LinkType`.`id`) WHERE ((`Link`.`content_page_id` > 0) OR (`Link`.`url` != '')) AND `Link`.`id` IN (48967, 49031, 48988, 48971, 49022, 49008) AND `Link`.`site_id` = 903 | | 6 | 6 | 1 | maybe slow |
SELECT `ContentPage`.`id`, `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` IN (47815, 47817, 47832, 47816, 47862, 47846) AND `ContentPage`.`site_id` = 903 ORDER BY `ContentPage`.`title` ASC | | 6 | 6 | 1 | maybe slow |
SELECT `Contact`.`id`, `Contact`.`site_id`, `Contact`.`type_code`, `Contact`.`label_txt`, `Contact`.`text_c`, `Contact`.`created`, `Contact`.`modified`, `Contact`.`status`, `Contact`.`order` FROM `contacts` AS `Contact` WHERE `site_id` = 903 AND `status` = 1 | | 0 | 0 | 1 | maybe slow |
SELECT `Profile`.`id`, `Profile`.`user_id`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`fname_drop_down`, `Profile`.`lname_drop_down`, `Profile`.`phone`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, `Profile`.`user_level`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`title`, `Profile`.`company`, `Profile`.`country_id`, `Profile`.`sites_allotted`, `Profile`.`affiliate_code`, `Profile`.`show_affiliate_button`, `Profile`.`fax`, `Profile`.`text_sign`, `Profile`.`signature_type`, `Profile`.`custom_signature`, `Profile`.`manage_email_header`, `Profile`.`new_user`, `Profile`.`crea_agent_id`, `Profile`.`crm_checklist_enabled`, `Profile`.`clickdigs_app_url`, (CONCAT(`Profile`.`first_name`, ' ', `Profile`.`last_name`)) AS `Profile__name` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 358 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `ContentBlock`.`id`, `ContentBlock`.`site_id`, `ContentBlock`.`content_block_type_id`, `ContentBlock`.`content`, `ContentBlockType`.`id`, `ContentBlockType`.`title`, `ContentBlockType`.`abbrev` FROM `content_blocks` AS `ContentBlock` LEFT JOIN `content_block_types` AS `ContentBlockType` ON (`ContentBlock`.`content_block_type_id` = `ContentBlockType`.`id`) WHERE `ContentBlock`.`site_id` = 903 ORDER BY `content_block_type_id` ASC | | 12 | 12 | 11 | maybe slow |
SELECT `HeaderPhoto`.`id`, `HeaderPhoto`.`site_id`, `HeaderPhoto`.`photo_id`, `HeaderPhoto`.`header_order`, `HeaderPhoto`.`gallery_order`, `HeaderPhoto`.`crop_x`, `HeaderPhoto`.`crop_y`, `HeaderPhoto`.`crop_x2`, `HeaderPhoto`.`crop_y2`, `HeaderPhoto`.`use_custom_size`, `HeaderPhoto`.`custom_width`, `HeaderPhoto`.`custom_height`, `HeaderPhoto`.`description`, `HeaderPhoto`.`is_includephoto_frontend`, `HeaderPhoto`.`header_photo_link`, `HeaderPhoto`.`is_showphoto_otherusers`, (crop_x2 - crop_x) AS `HeaderPhoto__crop_width`, (crop_y2 - crop_y) AS `HeaderPhoto__crop_height`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`user_id_in_rotation`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`logo_id2`, `Site`.`logo2_position`, `Site`.`logo_id3`, `Site`.`logo3_position`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_listings_params`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`video_youtube_display`, `Site`.`video_youtube_params`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`show_manhome_photo`, `Site`.`socialmedia_position`, `Site`.`id_user_id`, `Site`.`id_user_id_always`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`team_rotation_weekdays`, `Site`.`assign_leads_sechdule`, `Site`.`has_profile_pic`, `Site`.`profile_pic_path`, `Site`.`profile_pic_params`, `Site`.`profile_pic_clip`, `Site`.`has_profile_pic_l`, `Site`.`profile_pic_path_l`, `Site`.`profile_pic_params_l`, `Site`.`profile_pic_clip_l`, `Site`.`has_profile_pic_o`, `Site`.`profile_pic_path_o`, `Site`.`profile_pic_params_o`, `Site`.`listing_search_form`, `Site`.`listing_search_place`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`banner_objects`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`custom_address`, `Site`.`address_type`, `Site`.`show_testimonials`, `Site`.`show_testimonial_photo`, `Site`.`show_testimonial_lines`, `Site`.`show_have_question`, `Site`.`show_more_contacts`, `Site`.`scroll_slider_pos`, `Site`.`grl_contact_active`, `Site`.`signature_params`, `Site`.`theme`, `Site`.`theme_name`, `Site`.`testimonial_design`, `Site`.`show_testimonial_rating`, `Site`.`language_translate_code`, `Site`.`top_producer_lead_assignment_method`, `Site`.`signature`, `Site`.`site_timezone`, `Site`.`crm_email`, `Site`.`email_params`, `Site`.`header_photo_params`, `Site`.`listing_rotation`, `Site`.`site_style`, `Site`.`subsite_of`, `Site`.`subsite_params`, `Site`.`is_seo_site`, `Site`.`ssl_protocol`, `Site`.`scroll_feed_settings`, `Site`.`ssl_expire_date`, `Photo`.`id`, `Photo`.`user_id`, `Photo`.`is_preset`, `Photo`.`title`, `Photo`.`header_file_name`, `Photo`.`photo_file_name`, `Photo`.`logo_file_name`, `Photo`.`upload_file_name`, `Photo`.`gallery_file_name`, `Photo`.`created`, `Photo`.`modified` FROM `photos_sites` AS `HeaderPhoto` LEFT JOIN `sites` AS `Site` ON (`HeaderPhoto`.`site_id` = `Site`.`id`) LEFT JOIN `photos` AS `Photo` ON (`HeaderPhoto`.`photo_id` = `Photo`.`id`) WHERE `HeaderPhoto`.`site_id` = 903 AND `is_includephoto_frontend` = '1' AND NOT (`header_file_name` IS NULL) ORDER BY `header_order` ASC, `Photo`.`created` DESC, `Photo`.`id` ASC LIMIT 1 | | 1 | 1 | 2 | maybe slow |
SELECT `Offer`.`id`, `Offer`.`site_id`, `Offer`.`title`, `Offer`.`description`, `Offer`.`amount`, `Offer`.`howworks`, `Offer`.`valid_days`, `Offer`.`status`, `Offer`.`created`, `Offer`.`modified`, `Offer`.`email_from`, `Offer`.`email_subject`, `Offer`.`facebook_share_title`, `Offer`.`email_template`, `Offer`.`order` FROM `offers` AS `Offer` WHERE `site_id` = 903 AND `status` = 1 ORDER BY `Offer`.`order` asc, `Offer`.`created` desc | | 0 | 0 | 1 | maybe slow |
SELECT `FooterFormSetting`.`id`, `FooterFormSetting`.`site_id`, `FooterFormSetting`.`footer_form_params`, `FooterFormSetting`.`show_form_fields`, `FooterFormSetting`.`comp_fields`, `FooterFormSetting`.`is_active_image`, `FooterFormSetting`.`image_params`, `FooterFormSetting`.`created`, `FooterFormSetting`.`modified`, `FooterFormSetting`.`footer_params` FROM `footer_form_settings` AS `FooterFormSetting` WHERE `FooterFormSetting`.`site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Color`.`id`, `Color`.`site_id`, `Color`.`color_type_id`, `Color`.`color_theme_id`, `Color`.`title`, `Color`.`valuex`, `Color`.`created`, `Color`.`modified` FROM `colors` AS `Color` WHERE `Color`.`color_type_id` = 29 AND `Color`.`site_id` = 903 ORDER BY `color_type_id` ASC LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image`, `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id`, `Site`.`subdomain` FROM `menu_items` AS `MenuItem` LEFT JOIN `links` AS `Link` ON (`MenuItem`.`link_id` = `Link`.`id`) inner JOIN `sites` AS `Site` ON (`MenuItem`.`site_id` = `Site`.`id`) WHERE `status` = 1 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`menu_type_id` = 10 ORDER BY `order` ASC | | 0 | 0 | 1 | maybe slow |
SELECT `SocialMedia`.`id`, `SocialMedia`.`site_id`, `SocialMedia`.`placeholder`, `SocialMedia`.`facebook_app_id`, `SocialMedia`.`facebook_secret_id`, `SocialMedia`.`facebook`, `SocialMedia`.`twitter`, `SocialMedia`.`linkdin`, `SocialMedia`.`google_plus`, `SocialMedia`.`youtube`, `SocialMedia`.`youtube_url`, `SocialMedia`.`pinterest`, `SocialMedia`.`facebook_image`, `SocialMedia`.`twitter_image`, `SocialMedia`.`linkdin_image`, `SocialMedia`.`google_image`, `SocialMedia`.`youtube_image`, `SocialMedia`.`pinterest_image`, `SocialMedia`.`email_image`, `SocialMedia`.`skype_image`, `SocialMedia`.`email_share`, `SocialMedia`.`skypecall`, `SocialMedia`.`skype_name`, `SocialMedia`.`favicon`, `SocialMedia`.`favicon_image`, `SocialMedia`.`social_bar_content`, `SocialMedia`.`meta_tag_image` FROM `social_medias` AS `SocialMedia` WHERE `SocialMedia`.`site_id` = 903 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Listing`.* FROM `listings` AS `Listing` inner JOIN `listing_sites` AS `ListingSite` ON (`Listing`.`id` = `ListingSite`.`listing_id`) WHERE `Listing`.`is_crea_feed` IN ('1', '2') AND `Listing`.`cre_property_listingId` = '1002772' AND `Listing`.`is_active` = '1' AND `ListingSite`.`site_id` = 903 LIMIT 1 | | 1 | 1 | 33 | maybe slow |
SELECT `Image`.`id`, `Image`.`path`, `Image`.`listing_id`, `Image`.`type`, `Image`.`order`, `Image`.`is_crea_feed`, `Image`.`feed_upd_date`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`listing_id` = 11097701 ORDER BY `Image`.`order` ASC | | 0 | 0 | 1 | maybe slow |
SELECT `Attachment`.`id`, `Attachment`.`site_id`, `Attachment`.`content_page_id`, `Attachment`.`listing_id`, `Attachment`.`attachment_type_id`, `Attachment`.`file_name`, `Attachment`.`attachment`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `listing_id` = 11097701 AND `attachment_type_id` = 1 | | 0 | 0 | 1 | maybe slow |
SELECT `User`.`id`, `User`.`is_admin`, `User`.`is_agent`, `User`.`email`, `User`.`password`, `User`.`status`, `User`.`created`, `User`.`modified`, `User`.`grl_email`, `User`.`grl_password`, `User`.`is_subscribe_lead_emails`, `User`.`activate_crm`, `User`.`app_calling_method`, `User`.`notification_api_email`, `User`.`notification_api_email_site`, `User`.`active_gmail`, `User`.`fb_access_token`, `User`.`fb_login_email`, `User`.`enable_two_step_authentication`, `User`.`last_log_in`, `User`.`from_my_email`, `User`.`is_standalone_crm`, `User`.`leadbooker_app_usage`, `User`.`leadbooker_app_last_log_in`, `User`.`g_calendar_watch`, `User`.`watch_resource_id`, `User`.`g_calendar_params`, `User`.`google_calendar_watch_exp`, `User`.`bs_admin_activate`, `User`.`bs_admin_params`, `User`.`fav_email`, `User`.`show_own_leads` FROM `users` AS `User` WHERE `id` = 358 AND `status` = 1 LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Site`.`active`, `Site`.`domain`, `Site`.`site_style`, `Site`.`subsite_of`, `Site`.`coverflow_above`, `display_listings` AS `coverflow_show`, `Site`.`display_opt_in`, `Site`.`auto_scroll` FROM `sites` AS `Site` WHERE `domain` = 'salishsearealestategroup.com' ORDER BY `Site`.`created` ASC LIMIT 1 | | 1 | 1 | 1 | |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41904 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41951 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 4 | 4 | 1 | maybe slow |
SELECT `Link`.`id`, `Link`.`link_type_id`, `Link`.`content_page_id`, `Link`.`url`, `Link`.`target_blank`, `LinkType`.`abbrev`, `LinkType`.`id` FROM `links` AS `Link` LEFT JOIN `link_types` AS `LinkType` ON (`Link`.`link_type_id` = `LinkType`.`id`) WHERE ((`Link`.`content_page_id` > 0) OR (`Link`.`url` != '')) AND `Link`.`id` IN (49033, 49032, 49034, 49038) AND `Link`.`site_id` = 903 | | 4 | 4 | 1 | maybe slow |
SELECT `ContentPage`.`id`, `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` IN (47826, 47845, 47816, 47870) AND `ContentPage`.`site_id` = 903 ORDER BY `ContentPage`.`title` ASC | | 4 | 4 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41953 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41952 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41954 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41958 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41917 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 4 | 4 | 1 | maybe slow |
SELECT `Link`.`id`, `Link`.`link_type_id`, `Link`.`content_page_id`, `Link`.`url`, `Link`.`target_blank`, `LinkType`.`abbrev`, `LinkType`.`id` FROM `links` AS `Link` LEFT JOIN `link_types` AS `LinkType` ON (`Link`.`link_type_id` = `LinkType`.`id`) WHERE ((`Link`.`content_page_id` > 0) OR (`Link`.`url` != '')) AND `Link`.`id` IN (49042, 49039, 49045, 49040) AND `Link`.`site_id` = 903 | | 4 | 4 | 1 | maybe slow |
SELECT `ContentPage`.`id`, `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` IN (47871, 47850, 47832, 47881) AND `ContentPage`.`site_id` = 903 ORDER BY `ContentPage`.`title` ASC | | 4 | 4 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41962 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41959 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41965 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41960 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41908 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 3 | 3 | 1 | maybe slow |
SELECT `Link`.`id`, `Link`.`link_type_id`, `Link`.`content_page_id`, `Link`.`url`, `Link`.`target_blank`, `LinkType`.`abbrev`, `LinkType`.`id` FROM `links` AS `Link` LEFT JOIN `link_types` AS `LinkType` ON (`Link`.`link_type_id` = `LinkType`.`id`) WHERE ((`Link`.`content_page_id` > 0) OR (`Link`.`url` != '')) AND `Link`.`id` IN (49044, 49046, 49047) AND `Link`.`site_id` = 903 | | 3 | 3 | 1 | maybe slow |
SELECT `ContentPage`.`id`, `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` IN (47817, 47880, 47879) AND `ContentPage`.`site_id` = 903 ORDER BY `ContentPage`.`title` ASC | | 3 | 3 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41964 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41966 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41967 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41942 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41930 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 6 | 6 | 1 | maybe slow |
SELECT `Link`.`id`, `Link`.`link_type_id`, `Link`.`content_page_id`, `Link`.`url`, `Link`.`target_blank`, `LinkType`.`abbrev`, `LinkType`.`id` FROM `links` AS `Link` LEFT JOIN `link_types` AS `LinkType` ON (`Link`.`link_type_id` = `LinkType`.`id`) WHERE ((`Link`.`content_page_id` > 0) OR (`Link`.`url` != '')) AND `Link`.`id` IN (49043, 49048, 49019, 49036, 49041, 49035) AND `Link`.`site_id` = 903 | | 6 | 6 | 1 | maybe slow |
SELECT `ContentPage`.`id`, `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` IN (47859, 47861, 47816, 47872, 47876, 47874) AND `ContentPage`.`site_id` = 903 ORDER BY `ContentPage`.`title` ASC | | 6 | 6 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41963 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41968 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41939 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41956 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41961 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_pic_params`, `MenuItem`.`button_description`, `MenuItem`.`attrib1`, `MenuItem`.`color1`, `MenuItem`.`color2`, `MenuItem`.`color3`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `MenuItem`.`is_show_submenu`, `MenuItem`.`item_type`, `MenuItem`.`parent_id`, `MenuItem`.`content_id`, `MenuItem`.`auto_populate`, `MenuItem`.`description`, `MenuItem`.`url`, `MenuItem`.`url_target`, `MenuItem`.`size`, `MenuItem`.`default_image`, `MenuItem`.`rollover_image` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 41955 AND `MenuItem`.`site_id` = 903 AND `MenuItem`.`status` = 1 ORDER BY `MenuItem`.`order` asc | | 0 | 0 | 1 | maybe slow |