דלג על ניווט

נושא זה מכיל 0 תגובות, יש ל 1קוֹל.

עודכן לאחרונה על ידי colourI לפני 3 חודשים, שבוע 1.

בסיוע: Lauren.

מחבר פוסטים
אוקטובר 18, 2024בְּ- 2:44 pm #16305270

colourI

Background of the issue:
Hi
We install Query Monitor plugin and have this slow query that needs to be fix,
Query:
SELECT option_name, option_value
FROM _citioptions
WHERE option_name NOT LIKE '_transient%'
AND option_name NOT LIKE '_site_transient%'
AND ( option_name = 'rs_free_product_message_info'
OR option_name = 'rs_free_product_quantity_message_info'
OR option_name = 'rs_free_product_msg_caption'
OR option_name = 'rs_point_to_reach_next_level'
OR option_name = 'rs_mail_subject_for_reaching_maximum_threshold'
OR option_name = 'rs_mail_message_for_reaching_maximum_threshold'
OR option_name = 'rs_min_cart_total_for_earning_error_message'
OR option_name = 'rs_max_cart_total_for_earning_error_message'
OR option_name = 'rs_total_earned_point_caption'
OR option_name = 'rs_custom_message_for_points_cart'
OR option_name = 'rs_total_earned_point_caption_checkout'
OR option_name = 'rs_custom_message_for_points_checkout'
OR option_name = 'rs_total_earned_point_caption_thank_you'
OR option_name = 'rs_custom_message_for_points_thankyou'
OR option_name = 'rs_msg_for_earned_points'
OR option_name = 'rs_email_subject_referral_signup'
OR option_name = 'rs_email_message_referral_signup'
OR option_name = 'rs_email_subject_getting_referred'
OR option_name = 'rs_email_message_getting_referred'
OR option_name = 'rs_msg_for_restricted_user'
OR option_name = 'rs_generate_link_label'
OR option_name = 'rs_generate_link_sno_label'
OR option_name = 'rs_generate_link_date_label'
OR option_name = 'rs_generate_link_referrallink_label'
OR option_name = 'rs_generate_link_social_label'
OR option_name = 'rs_generate_link_action_label'
OR option_name = 'rs_generate_link_hover_label'
OR option_name = 'rs_generate_link_button_label'
OR option_name = 'rs_my_referral_link_button_label'
OR option_name = 'rs_static_generate_link'
OR option_name = 'rs_generate_link_action_label'
OR option_name = 'rs_prefill_generate_link'
OR option_name = 'rs_facebook_title'
OR option_name = 'rs_facebook_description'
OR option_name = 'rs_show_hide_generate_referral_message_text'
OR option_name = 'rs_referal_table_title'
OR option_name = 'rs_my_referal_sno_label'
OR option_name = 'rs_my_referal_userid_label'
OR option_name = 'rs_referral_email_ids'
OR option_name = 'rs_my_total_referal_points_label'
OR option_name = 'rs_referal_table_title_shortcode'
OR option_name = 'rs_my_referal_sno_label_shortcode'
OR option_name = 'rs_my_referal_userid_label_shortcode'
OR option_name = 'rs_referral_email_ids_shortcode'
OR option_name = 'rs_my_total_referal_points_label_shortcode'
OR option_name = 'rs_my_rewards_friend_name_label'
OR option_name = 'rs_my_rewards_friend_name_placeholder'
OR option_name = 'rs_my_rewards_friend_email_label'
OR option_name = 'rs_my_rewards_friend_email_placeholder'
OR option_name = 'rs_my_rewards_friend_subject_label'
OR option_name = 'rs_my_rewards_friend_email_subject_placeholder'
OR option_name = 'rs_my_rewards_friend_message_label'
OR option_name = 'rs_my_rewards_friend_email_message_placeholder'
OR option_name = 'rs_subject_field'
OR option_name = 'rs_heading_field'
OR option_name = 'rs_referral_link_refer_a_friend_form'
OR option_name = 'rs_friend_referral_link'
OR option_name = 'rs_refer_friend_iagreecaption_link'
OR option_name = 'rs_refer_friend_termscondition_caption'
OR option_name = 'rs_refer_friend_termscondition_url'
OR option_name = 'rs_my_rewards_friend_name_error_message'
OR option_name = 'rs_my_rewards_friend_email_error_message'
OR option_name = 'rs_my_rewards_friend_email_is_not_valid'
OR option_name = 'rs_my_rewards_email_subject_error_message'
OR option_name = 'rs_iagree_error_message'
OR option_name = 'rs_errmsg_when_other_products_added_to_cart_page'
OR option_name = 'rs_total_send_points_request'
OR option_name = 'rs_points_to_send_request'
OR option_name = 'rs_select_user_label'
OR option_name = 'rs_select_user_placeholder'
OR option_name = 'rs_reason_for_send_points'
OR option_name = 'rs_select_points_submit_label'
OR option_name = 'rs_message_send_point_request_submitted'
OR option_name = 'rs_message_send_point_request_submitted_for_auto'
OR option_name = 'rs_err_when_point_greater_than_limit'
OR option_name = 'rs_send_points_username_field_label'
OR option_name = 'rs_send_points_username_placeholder'
OR option_name = 'rs_email_subject_for_send_points_notification_admin'
OR option_name = 'rs_email_message_for_send_points_notification_admin'
OR option_name = 'rs_email_subject_for_send_points_confirmation'
OR option_name = 'rs_email_message_for_send_points_confirmation'
OR option_name = 'rs_email_subject_for_send_points'
OR option_name = 'rs_email_message_for_send_points'
OR option_name = 'rs_err_when_point_field_empty'
OR option_name = 'rs_msg_when_user_have_no_points'
OR option_name = 'rs_error_msg_when_points_is_more'
OR option_name = 'rs_err_for_empty_user'
OR option_name = 'rs_err_for_empty_reason_user'
OR option_name = 'rs_err_when_point_is_not_number'
OR option_name = 'rs_username_empty_error_message'
OR option_name = 'rs_invalid_username_error_message'
OR option_name = 'rs_restricted_username_error_message'
OR option_name = 'rs_email_subject_point_url'
OR option_name = 'rs_email_message_point_url'
OR option_name = 'rs_success_message_for_pointurl'
OR option_name = 'rs_message_for_pointurl'
OR option_name = 'failure_msg_for_accessed_url'
OR option_name = 'failure_msg_for_expired_url'
OR option_name = 'failure_msg_for_count_exceed'
OR option_name = 'rs_my_nominee_title_in_checkout'
OR option_name = 'rs_my_nominee_title'
OR option_name = 'rs_my_nominee_title_shortcode'
OR option_name = 'rs_total_points_for_cashback_request'
OR option_name = 'rs_encashing_points_label'
OR option_name = 'rs_encashing_reason_label'
OR option_name = 'rs_encashing_payment_method_label'
OR option_name = 'rs_encashing_payment_paypal_label'
OR option_name = 'rs_encashing_payment_custom_label'
OR option_name = 'rs_encashing_submit_button_label'
OR option_name = 'rs_google_recaptcha_label'
OR option_name = 'rs_encashing_points_label'
OR option_name = 'rs_email_subject_message_for_cashback'
OR option_name = 'rs_email_message_for_cashback'
OR option_name = 'rs_my_cashback_title'
OR option_name = 'rs_my_cashback_sno_label'
OR option_name = 'rs_my_cashback_userid_label'
OR option_name = 'rs_my_cashback_requested_label'
OR option_name = 'rs_my_cashback_status_label'
OR option_name = 'rs_my_cashback_sno_label_shortcode'
OR option_name = 'rs_my_cashback_requested_label_shortcode'
OR option_name = 'rs_my_cashback_userid_label_shortcode'
OR option_name = 'rs_my_cashback_status_label_shortcode'
OR option_name = 'rs_message_for_guest_encashing'
OR option_name = 'rs_message_for_banned_users_encashing'
OR option_name = 'rs_message_users_nopoints_encashing'
OR option_name = 'rs_message_encashing_request_submitted'
OR option_name = 'rs_encashing_paypal_custom_notes'
OR option_name = 'rs_error_message_points_empty_encash'
OR option_name = 'rs_error_message_points_number_val_encash'
OR option_name = 'rs_error_message_points_greater_than_earnpoints'
OR option_name = 'rs_error_message_currentpoints_less_than_minimum_points'
OR option_name = 'rs_error_message_points_lesser_than_minimum_points'
OR option_name = 'rs_error_message_reason_encash_empty'
OR option_name = 'rs_error_message_paypal_email_empty'
OR option_name = 'rs_error_message_paypal_email_wrong'
OR option_name = 'rs_error_custom_payment_field_empty'
OR option_name = 'rs_error_recaptcha_field_empty'
OR option_name = 'rs_ph_no_field_label_registration'
OR option_name = 'rs_ph_no_validationerror_emptyfield'
OR option_name = 'rs_points_sms_content_for_earning'
OR option_name = 'rs_points_sms_content_for_redeeming'
OR option_name = 'rs_send_sms_earning_points_content_for_actions'
OR option_name = 'rs_redeem_your_gift_voucher_label'
OR option_name = 'rs_redeem_your_gift_voucher_placeholder'
OR option_name = 'rs_redeem_gift_voucher_button_label'
OR option_name = 'rs_email_subject_gift_voucher'
OR option_name = 'rs_email_message_gift_voucher'
OR option_name = 'rs_voucher_redeem_empty_error'
OR option_name = 'rs_voucher_redeem_success_message'
OR option_name = 'rs_voucher_code_expired_error_message'
OR option_name = 'rs_invalid_voucher_code_error_message'
OR option_name = 'rs_redeem_voucher_login_link_label'
OR option_name = 'rs_voucher_redeem_guest_error_message'
OR option_name = 'rs_voucher_code_used_error_message'
OR option_name = 'rs_banned_user_redeem_voucher_error'
OR option_name = 'rs_reward_code_field_caption'
OR option_name = 'rs_reward_code_field_placeholder'
OR option_name = 'rs_reward_code_submit_field_caption'
OR option_name = 'rs_current_available_balance_caption'
OR option_name = 'rs_email_expired_name'
OR option_name = 'rs_subject_expired'
OR option_name = 'rs_email_expired_template_edit'
OR option_name = 'rs_email_subject_threshold_points'
OR option_name = 'rs_email_message_threshold_points'
OR option_name = 'rs_subject_for_user_unsubscribe'
OR option_name = 'rs_message_for_user_unsubscribe'
OR option_name = 'rs_template_name'
OR option_name = 'rs_subject'
OR option_name = 'rs_email_template_new'
OR option_name = 'rs_label_for_point_value'
OR option_name = 'rs_email_subject_account_signup'
OR option_name = 'rs_email_message_account_signup'
OR option_name = 'rs_email_subject_product_review'
OR option_name = 'rs_email_message_product_review'
OR option_name = 'rs_email_subject_blog_post_create'
OR option_name = 'rs_email_message_blog_post_create'
OR option_name = 'rs_email_subject_blog_post_comment'
OR option_name = 'rs_email_message_blog_post_comment'
OR option_name = 'rs_email_subject_page_comment'
OR option_name = 'rs_email_message_page_comment'
OR option_name = 'rs_email_subject_login'
OR option_name = 'rs_email_message_login'
OR option_name = 'rs_email_subject_payment_gateway'
OR option_name = 'rs_email_message_payment_gateway'
OR option_name = 'rs_email_subject_coupon_reward'
OR option_name = 'rs_email_message_coupon_reward'
OR option_name = 'rs_coupon_applied_reward_success'
OR option_name = 'rs_redeeming_button_option_message'
OR option_name = 'rs_reedming_field_label_checkout'
OR option_name = 'rs_reedming_field_link_label_checkout'
OR option_name = 'rs_redeeming_button_option_message_checkout'
OR option_name = 'rs_redeem_field_caption'
OR option_name = 'rs_redeem_field_placeholder'
OR option_name = 'rs_redeem_field_submit_button_caption'
OR option_name = 'rs_coupon_label_message'
OR option_name = 'rs_redeeming_message_restrict_for_sale_price_product'
OR option_name = 'rs_min_points_first_redeem_error_message'
OR option_name = 'rs_min_points_after_first_error'
OR option_name = 'rs_min_cart_total_redeem_error'
OR option_name = 'rs_max_cart_total_redeem_error'
OR option_name = 'rs_available_points_redeem_error'
OR option_name = 'rs_coupon_applied_individual_error_msg'
OR option_name = 'rs_msg_for_redeem_points'
OR option_name = 'rs_minimum_redeem_point_error_message'
OR option_name = 'rs_maximum_redeem_point_error_message'
OR option_name = 'rs_minimum_and_maximum_redeem_point_error_message'
OR option_name = 'rs_minimum_redeem_point_error_message_for_button_type'
OR option_name = 'rs_maximum_redeem_point_error_message_for_button_type'
OR option_name = 'rs_minimum_and_maximum_redeem_point_error_message_for_buttontype'
OR option_name = 'rs_redeem_empty_error_message'
OR option_name = 'rs_redeem_character_error_message'
OR option_name = 'rs_redeem_max_error_message'
OR option_name = 'rs_current_points_empty_error_message'
OR option_name = 'rs_auto_redeem_not_applicable_error_message'
OR option_name = 'rs_msg_for_redeem_points'
OR option_name = 'rs_email_subject_facebook_like'
OR option_name = 'rs_email_subject_post_fb_like'
OR option_name = 'rs_email_message_post_fb_like'
OR option_name = 'rs_email_message_facebook_like'
OR option_name = 'rs_social_message_for_facebook'
OR option_name = 'rs_succcess_message_for_facebook_like'
OR option_name = 'rs_unsucccess_message_for_facebook_unlike'
OR option_name = 'rs_email_subject_facebook_share'
OR option_name = 'rs_email_message_facebook_share'
OR option_name = 'rs_email_subject_post_fb_share'
OR option_name = 'rs_email_message_post_fb_share'
OR option_name = 'rs_social_message_for_facebook_share'
OR option_name = 'rs_succcess_message_for_facebook_share'
OR option_name = 'rs_unsucccess_message_for_facebook_share'
OR option_name = 'rs_fbshare_button_label'
OR option_name = 'rs_email_subject_twitter_tweet'
OR option_name = 'rs_email_message_twitter_tweet'
OR option_name = 'rs_email_subject_post_tweet'
OR option_name = 'rs_email_message_post_tweet'
OR option_name = 'rs_social_message_for_twitter'
OR option_name = 'rs_succcess_message_for_twitter_share'
OR option_name = 'rs_unsucccess_message_for_twitter_unshare'
OR option_name = 'rs_email_subject_twitter_follow'
OR option_name = 'rs_email_message_twitter_follow'
OR option_name = 'rs_email_subject_post_follow'
OR option_name = 'rs_email_message_post_follow'
OR option_name = 'rs_social_message_for_twitter_follow'
OR option_name = 'rs_succcess_message_for_twitter_follow'
OR option_name = 'rs_unsucccess_message_for_twitter_unfollow'
OR option_name = 'rs_global_social_twitter_profile_name'
OR option_name = 'rs_instagram_profile_name'
OR option_name = 'rs_email_subject_instagram'
OR option_name = 'rs_email_message_instagram'
OR option_name = 'rs_email_subject_post_instagram'
OR option_name = 'rs_email_message_post_instagram'
OR option_name = 'rs_social_message_for_instagram'
OR option_name = 'rs_succcess_message_for_instagram'
OR option_name = 'rs_unsucccess_message_for_instagram'
OR option_name = 'rs_email_subject_vk'
OR option_name = 'rs_email_message_vk'
OR option_name = 'rs_email_subject_post_vk'
OR option_name = 'rs_email_message_post_vk'
OR option_name = 'rs_social_message_for_vk'
OR option_name = 'rs_succcess_message_for_vk'
OR option_name = 'rs_unsucccess_message_for_vk'
OR option_name = 'rs_email_subject_google'
OR option_name = 'rs_email_message_google'
OR option_name = 'rs_email_subject_post_gplus'
OR option_name = 'rs_email_message_post_gplus'
OR option_name = 'rs_social_message_for_google_plus'
OR option_name = 'rs_succcess_message_for_google_share'
OR option_name = 'rs_unsucccess_message_for_google_unshare'
OR option_name = 'rs_email_subject_ok'
OR option_name = 'rs_email_message_ok'
OR option_name = 'rs_email_subject_post_ok_ru'
OR option_name = 'rs_email_message_post_ok_ru'
OR option_name = 'rs_social_message_for_ok_follow'
OR option_name = 'rs_succcess_message_for_ok_follow'
OR option_name = 'rs_unsucccess_message_for_ok_unfollow'
OR option_name = 'rs_restriction_message_for_fblike'
OR option_name = 'rs_restriction_message_for_fbshare'
OR option_name = 'rs_restriction_message_for_tweet'
OR option_name = 'rs_restriction_message_for_twitter_follow'
OR option_name = 'rs_restriction_message_for_instagram'
OR option_name = 'rs_restriction_message_for_vk'
OR option_name = 'rs_restriction_message_for_gplus'
OR option_name = 'rs_restriction_message_for_ok'
OR option_name = 'rs_reward_addremove_reason'
OR option_name = 'rs_email_subject_message'
OR option_name = 'rs_email_message'
OR option_name = 'rs_email_subject_for_remove'
OR option_name = 'rs_email_message_for_remove'
OR option_name = 'rs_msg_in_reg_page'
OR option_name = 'rs_msg_in_acc_page_when_checked'
OR option_name = 'rs_msg_in_acc_page_when_unchecked'
OR option_name = 'rs_alert_msg_in_acc_page_when_checked'
OR option_name = 'rs_alert_msg_in_acc_page_when_unchecked'
OR option_name = 'rs_my_reward_content_title'
OR option_name = 'rs_my_reward_url_title'
OR option_name = 'rs_message_in_shop_page_for_simple'
OR option_name = 'rs_msg_for_fixed_cart_total_based_product_purchase_in_shop'
OR option_name = 'rs_msg_for_percent_cart_total_based_product_purchase_in_shop'
OR option_name = 'rs_buy_point_message_in_shop_page_for_simple'
OR option_name = 'rs_buy_point_message_in_shop_page_for_variable'
OR option_name = 'rs_message_in_custom_shop_page_for_simple'
OR option_name = 'rs_message_for_custom_shop_variation'
OR option_name = 'rs_buy_point_message_in_custom_shop_page_for_simple'
OR option_name = 'rs_buy_point_message_in_custom_shop_page_for_variable'
OR option_name = 'rs_message_for_single_product_point_rule'
OR option_name = 'rs_message_in_single_product_page'
OR option_name = 'rs_message_in_single_product_page_related_products'
OR option_name = 'rs_message_for_single_product_variation'
OR option_name = 'rs_message_for_variation_products'
OR option_name = 'rs_message_in_variable_related_products'
OR option_name = 'rs_msg_for_fixed_cart_total_based_product_purchase'
OR option_name = 'rs_msg_for_percent_cart_total_based_product_purchase'
OR option_name = 'rs_buy_point_message_for_single_product_point_rule'
OR option_name = 'rs_buy_point_message_in_product_page_for_simple'
OR option_name = 'rs_buy_point_message_for_variation_products'
OR option_name = 'rs_buy_point_message_in_product_page_for_variable'
OR option_name = 'rs_message_for_single_product_point_rule_referral'
OR option_name = 'rs_message_for_variation_products_referral'
OR option_name = 'rs_message_for_product_review'
OR option_name = 'rs_message_for_guest_in_cart'
OR option_name = 'rs_message_product_in_cart'
OR option_name = 'rs_message_total_price_in_cart'
OR option_name = 'rs_msg_for_cart_total_based_points'
OR option_name = 'rs_buy_point_message_product_in_cart'
OR option_name = 'rs_referral_point_message_product_in_cart'
OR option_name = 'rs_message_user_points_in_cart'
OR option_name = 'rs_referer_point_message_cart_total_based_in_cart_page'
OR option_name = 'rs_message_user_points_redeemed_in_cart'
OR option_name = 'rs_message_for_guest_in_checkout'
OR option_name = 'rs_message_product_in_checkout'
OR option_name = 'rs_message_total_price_in_checkout'
OR option_name = 'rs_msg_for_cart_total_based_points_in_checkout'
OR option_name = 'rs_referral_point_message_product_in_checkout'
OR option_name = 'rs_referer_point_message_cart_total_based_in_checkout_page'
OR option_name = 'rs_buy_point_message_product_in_checkout'
OR option_name = 'rs_message_user_points_in_checkout'
OR option_name = 'rs_message_user_points_redeemed_in_checkout'
OR option_name = 'rs_message_payment_gateway_reward_points'
OR option_name = 'rs_restriction_msg_for_selected_gateway'
OR option_name = 'rs_message_for_first_purchase'
OR option_name = 'rs_success_coupon_message'
OR option_name = 'rs_automatic_success_coupon_message'
OR option_name = 'rs_remove_redeem_points_message'
OR option_name = 'rs_errmsg_for_max_discount_type'
OR option_name = 'rs_errmsg_for_redeeming_in_order'
OR option_name = 'rs_errmsg_for_coupon_in_order'
OR option_name = 'rs_errmsg_for_redeem_in_point_price_prt'
OR option_name = 'rs_msg_for_redeem_when_tax_enabled'
OR option_name = 'rs_my_rewards_total'
OR option_name = 'rs_my_rewards_title'
OR option_name = 'rs_my_rewards_sno_label'
OR option_name = 'rs_my_rewards_userid_label'
OR option_name = 'rs_my_rewards_reward_for_label'
OR option_name = 'rs_my_rewards_points_earned_label'
OR option_name = 'rs_my_rewards_redeem_points_label'
OR option_name = 'rs_my_rewards_total_points_label'
OR option_name = 'rs_my_rewards_date_label'
OR option_name = 'rs_my_rewards_points_expired_label'
OR option_name = 'rs_my_rewards_total_shortcode'
OR option_name = 'rs_my_rewards_title_shortcode'
OR option_name = 'rs_my_rewards_sno_label_shortcode'
OR option_name = 'rs_my_rewards_userid_label_shortcode'
OR option_name = 'rs_my_rewards_rewarder_label_shortcode'
OR option_name = 'rs_my_rewards_points_earned_label_shortcode'
OR option_name = 'rs_my_rewards_redeem_points_label_shortcode'
OR option_name = 'rs_my_rewards_total_points_label_shortcode'
OR option_name = 'rs_my_rewards_date_label_shortcode'
OR option_name = 'rs_my_rewards_points_expired_label_shortcode'
OR option_name = 'rs_message_shortcode_guest_display'
OR option_name = 'rs_message_shortcode_login_name'
OR option_name = 'rs_label_shortcode'
OR option_name = 'rs_unsubscribe_link_for_email'
OR option_name = 'rs_errmsg_for_normal_product_with_point_price'
OR option_name = 'rs_errmsg_for_point_price_product_with_normal'
OR option_name = 'rs_errmsg_for_point_price_product_with_same'
OR option_name = 'rs_point_price_product_added_to_cart_guest_errmsg'
OR option_name = 'rs_msg_for_account_signup'
OR option_name = 'rs_msg_for_product_review'
OR option_name = 'rs_msg_for_post_creation'
OR option_name = 'rs_msg_for_post_review'
OR option_name = 'rs_msg_for_page_comment'
OR option_name = 'rs_msg_for_create_product'
OR option_name = 'rs_msg_for_daily_login'
OR option_name = 'rs_msg_for_product_puchase'
OR option_name = 'rs_msg_for_buying_reward_points'
OR option_name = 'rs_msg_for_referral_system_product_purcase'
OR option_name = 'rs_msg_for_referral_system_login'
OR option_name = 'rs_msg_for_getting_refer_product_purchase'
OR option_name = 'rs_msg_for_social_promotion'
OR option_name = 'rs_msg_for_social_promotion_for_post'
OR option_name = 'rs_message_user_points_for_sign_up'
OR option_name = 'rs_message_user_points_for_daily_login'
OR option_name = 'rs_message_user_points_for_page_comment'
OR option_name = 'rs_message_user_points_for_blog_creation'
OR option_name = 'rs_message_user_points_for_blog_comment'
OR option_name = '_rs_localize_points_earned_for_registration'
OR option_name = '_rs_localize_points_earned_for_referral_registration'
OR option_name = 'rs_log_for_first_purchase_points'
OR option_name = 'rs_log_for_revised_first_purchase_points'
OR option_name = '_rs_localize_product_purchase_reward_points'
OR option_name = '_rs_localize_points_earned_for_purchase_main'
OR option_name = '_rs_localize_points_earned_for_purchase_based_on_cart_total_for_master_log'
OR option_name = '_rs_localize_points_earned_for_purchase_based_on_cart_total'
OR option_name = 'rs_log_for_product_purchase_when_overidded'
OR option_name = '_rs_localize_referral_reward_points_for_purchase'
OR option_name = '_rs_localize_referral_reward_points_for_purchase_gettin_referred'
OR option_name = '_rs_localize_referrer_reward_points_based_on_cart_total'
OR option_name = '_rs_localize_referred_reward_points_based_on_cart_total'
OR option_name = '_rs_localize_referral_reward_points_gettin_referred'
OR option_name = '_rs_localize_points_redeemed_towards_purchase'
OR option_name = '_rs_localize_reward_for_payment_gateway_message'
OR option_name = '_rs_localize_revise_reward_for_payment_gateway_message'
OR option_name = '_rs_reward_points_gateway_log_localizaation'
OR option_name = '_rs_localize_reward_for_using_subscription'
OR option_name = '_rs_localize_reward_for_facebook_like'
OR option_name = '_rs_localize_reward_for_facebook_share'
OR option_name = '_rs_localize_reward_for_twitter_tweet'
OR option_name = '_rs_localize_reward_for_twitter_follow'
OR option_name = '_rs_localize_reward_for_google_plus'
OR option_name = '_rs_localize_reward_for_vk'
OR option_name = '_rs_localize_reward_for_instagram'
OR option_name = '_rs_localize_reward_for_ok_follow'
OR option_name = '_rs_localize_points_earned_for_product_review'
OR option_name = '_rs_localize_points_earned_for_post'
OR option_name = '_rs_localize_points_earned_for_post_review'
OR option_name = '_rs_localize_points_earned_for_product_creation'
OR option_name = '_rs_localize_points_earned_for_page_review'
OR option_name = '_rs_localize_reward_points_for_login'
OR option_name = '_rs_localize_buying_reward_points_log'
OR option_name = '_rs_localize_buying_reward_points_log'
OR option_name = '_rs_log_revise_product_purchase'
OR option_name = '_rs_log_revise_product_purchase_main'
OR option_name = '_rs_log_revise_buy_points_main'
OR option_name = '_rs_log_revise_for_product_purchase_based_on_cart_total'
OR option_name = '_rs_log_revise_for_product_purchase_based_on_cart_total_in_my_reward'
OR option_name = '_rs_log_revise_referral_product_purchase'
OR option_name = 'rs_log_revise_referrer_points_based_cart_total'
OR option_name = '_rs_log_revise_points_redeemed_towards_purchase'
OR option_name = '_rs_log_revise_getting_referred_product_purchase'
OR option_name = 'rs_log_revise_referred_points_based_cart_total'
OR option_name = '_rs_localize_referral_account_signup_points_revised'
OR option_name = '_rs_localize_revise_points_for_referral_purchase'
OR option_name = '_rs_localize_revise_points_for_getting_referred_purchase'
OR option_name = 'rs_localize_revise_referrer_points_for_deletion_based_cart_total'
OR option_name = 'rs_localize_revise_referred_points_for_deletion_based_cart_total'
OR option_name = '_rs_localize_reward_for_facebook_like_revised'
OR option_name = '_rs_localize_reward_for_google_plus_revised'
OR option_name = '_rs_localize_reward_for_vk_like_revised'
OR option_name = '_rs_localize_log_for_reciver'
OR option_name = '_rs_localize_log_for_sender'
OR option_name = '_rs_localize_log_for_sender_after_submit'
OR option_name = '_rs_localize_points_to_send_log_revised'
OR option_name = '_rs_localize_voucher_code_usage_log_message'
OR option_name = '_rs_localize_coupon_reward_points_log'
OR option_name = '_rs_localize_max_earning_points_log'
OR option_name = '_rs_localize_points_to_cash_log'
OR option_name = '_rs_localize_points_to_cash_log_revised'
OR option_name = '_rs_localize_points_to_cash_log_in_my_cashback_table'
OR option_name = '_rs_localize_log_for_nominee'
OR option_name = '_rs_localize_log_for_nominated_user'
OR option_name = '_rs_localize_log_for_import_add'
OR option_name = '_rs_localize_log_for_import_override' )
AND LENGTH(option_value) all_strings_array()
WPML_Admin_Text_Configuration->all_strings_array()
wp-content/plugins/wpml-string-translation/inc/admin-texts/wpml-admin-text-configuration.php:132
WPML_Admin_Text_Configuration->fill_wildcards()
wp-content/plugins/wpml-string-translation/inc/admin-texts/wpml-admin-text-configuration.php:56
WPML_Admin_Text_Configuration->__construct()
wp-content/plugins/wpml-string-translation/inc/admin-texts/wpml-admin-text-configuration.php:42
wpml_st_parse_config()
wp-content/plugins/wpml-string-translation/inc/private-actions.php:7
do_action('wpml_parse_config_file')
wp-includes/plugin.php:517
WPML_Config::parse_wpml_config_files()
wp-content/plugins/sitepress-multilingual-cms/classes/xml-config/class-wpml-config.php:308
WPML_Config::load_config_run()
wp-content/plugins/sitepress-multilingual-cms/classes/xml-config/class-wpml-config.php:43
WPML_Config::load_config()
wp-content/plugins/sitepress-multilingual-cms/classes/xml-config/class-wpml-config.php:34
TranslationManagement->init()
wp-content/plugins/sitepress-multilingual-cms/inc/translation-management/translation-management.class.php:258
do_action('init')
wp-includes/plugin.php:517

Component: Plugin: wpml-string-translation
Rows: 413
Time:0,0688

Symptoms:
Slow query affecting the performance of the website

Questions: