• Resolved egocefalo

    (@egocefalo)


    Hi, since last update I’m getting a very slow backend, mostly when adding/saving a new post. Checking with Query Monitor plugin I can count up to 30 slow queries when loading the add new post page for example. This is a copy paste of it: (I’m sure you know what may be happening, can you point me to a solution plase? I’m running the Latest WP version on PHP 8.0 ) Thank you!

    DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_wpseo_total_unindexed_posts_limited'

    1. delete_option()

    Plugin: wordpress-seo 1 0.8471 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_timeout_wpseo_total_unindexed_posts_limited'

    1. delete_option()

    Plugin: wordpress-seo 1 0.4377 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_timeout_wpseo_total_unindexed_posts_limited', '1693298616', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 1.0242 SELECT P.ID
    FROM wp_posts AS P
    WHERE P.post_type IN ('post', 'page', 'tdc-review', 'tdc-review-email', 'tdb_templates')
    AND P.post_status NOT IN ('auto-draft')
    AND P.ID not in (
    SELECT I.object_id from wp_yoast_indexable as I
    WHERE I.object_type = 'post'
    AND I.version = 2 )
    LIMIT 2

    1. Yoast\W\S\A\I\Abstract_Indexing_Action->get_limited_unindexed_count()

    Plugin: wordpress-seo 0 10.1299 UPDATE wp_options
    SET option_value = '1693298627'
    WHERE option_name = '_transient_timeout_wpseo_total_unindexed_posts_limited'

    1. update_option()

    Plugin: wordpress-seo 1 0.4552 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_wpseo_total_unindexed_terms_limited'

    1. delete_option()

    Plugin: wordpress-seo 1 0.5737 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_timeout_wpseo_total_unindexed_terms_limited'

    1. delete_option()

    Plugin: wordpress-seo 1 0.1947 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_wpseo_total_unindexed_terms_limited', '0', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 0.1944 SELECT term_id
    FROM wp_term_taxonomy AS T
    LEFT JOIN wp_yoast_indexable AS I
    ON T.term_id = I.object_id
    AND I.object_type = 'term'
    AND I.version = 2
    WHERE I.object_id IS NULL
    AND taxonomy IN ('category', 'post_tag', 'post_format', 'tdc-review-criteria')
    LIMIT 2

    1. Yoast\W\S\A\I\Abstract_Indexing_Action->get_limited_unindexed_count()

    Plugin: wordpress-seo 2 0.1301 UPDATE wp_options
    SET option_value = '1693298629'
    WHERE option_name = '_transient_timeout_wpseo_total_unindexed_terms_limited'

    1. update_option()

    Plugin: wordpress-seo 1 0.1312 UPDATE wp_options
    SET option_value = '2'
    WHERE option_name = '_transient_wpseo_total_unindexed_terms_limited'

    1. update_option()

    Plugin: wordpress-seo 1 0.3085 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_wpseo_total_unindexed_general_items'

    1. delete_option()

    Plugin: wordpress-seo 1 0.1943 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_timeout_wpseo_total_unindexed_general_items'

    1. delete_option()

    Plugin: wordpress-seo 1 0.6995 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_timeout_wpseo_total_unindexed_general_items', '1693384130', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 0.6460 UPDATE wp_options
    SET option_value = 'a:106:{s:8:\"tracking\";b:0;s:16:\"toggled_tracking\";b:0;s:22:\"license_server_version\";s:5:\"false\";s:15:\"ms_defaults_set\";b:0;s:40:\"ignore_search_engines_discouraged_notice\";b:0;s:19:\"indexing_first_time\";b:0;s:16:\"indexing_started\";b:0;s:15:\"indexing_reason\";s:20:\"taxonomy_made_public\";s:29:\"indexables_indexing_completed\";b:1;s:13:\"index_now_key\";s:0:\"\";s:7:\"version\";s:4:\"21.0\";s:16:\"previous_version\";s:5:\"20.12\";s:20:\"disableadvanced_meta\";b:1;s:30:\"enable_headless_rest_endpoints\";b:1;s:17:\"ryte_indexability\";b:0;s:11:\"baiduverify\";s:0:\"\";s:12:\"googleverify\";s:0:\"\";s:8:\"msverify\";s:0:\"\";s:12:\"yandexverify\";s:0:\"\";s:9:\"site_type\";s:4:\"blog\";s:20:\"has_multiple_authors\";b:1;s:16:\"environment_type\";s:10:\"production\";s:23:\"content_analysis_active\";b:1;s:23:\"keyword_analysis_active\";b:1;s:34:\"inclusive_language_analysis_active\";b:0;s:21:\"enable_admin_bar_menu\";b:0;s:26:\"enable_cornerstone_content\";b:0;s:18:\"enable_xml_sitemap\";b:0;s:24:\"enable_text_link_counter\";b:0;s:16:\"enable_index_now\";b:1;s:19:\"enable_ai_generator\";b:0;s:22:\"show_onboarding_notice\";b:0;s:18:\"first_activated_on\";s:10:\"1669769053\";s:13:\"myyoast-oauth\";b:0;s:26:\"semrush_integration_active\";b:0;s:14:\"semrush_tokens\";a:0:{}s:20:\"semrush_country_code\";s:2:\"us\";s:19:\"permalink_structure\";s:12:\"/%postname%/\";s:8:\"home_url\";s:21:\"https://pipilopop.com\";s:18:\"dynamic_permalinks\";b:0;s:17:\"category_base_url\";s:3:\"cat\";s:12:\"tag_base_url\";s:3:\"tag\";s:21:\"custom_taxonomy_slugs\";a:3:{s:6:\"sc_tag\";s:6:\"sc_tag\";s:19:\"tdc-review-criteria\";s:19:\"tdc-review-criteria\";s:22:\"cookielawinfo-category\";s:22:\"cookielawinfo-category\";}s:29:\"enable_enhanced_slack_sharing\";b:0;s:25:\"zapier_integration_active\";b:0;s:19:\"zapier_subscription\";a:0:{}s:14:\"zapier_api_key\";s:0:\"\";s:23:\"enable_metabox_insights\";b:0;s:23:\"enable_link_suggestions\";b:1;s:26:\"algolia_integration_active\";b:0;s:14:\"import_cursors\";a:0:{}s:13:\"workouts_data\";a:1:{s:13:\"configuration\";a:1:{s:13:\"finishedSteps\";a:0:{}}}s:28:\"configuration_finished_steps\";a:0:{}s:36:\"dismiss_configuration_workout_notice\";b:0;s:34:\"dismiss_premium_deactivated_notice\";b:0;s:19:\"importing_completed\";a:0:{}s:26:\"wincher_integration_active\";b:0;s:14:\"wincher_tokens\";a:0:{}s:36:\"wincher_automatically_add_keyphrases\";b:0;s:18:\"wincher_website_id\";s:0:\"\";s:28:\"wordproof_integration_active\";b:0;s:29:\"wordproof_integration_changed\";b:0;s:18:\"first_time_install\";b:0;s:34:\"should_redirect_after_install_free\";b:0;s:34:\"activation_redirect_timestamp_free\";b:0;s:18:\"remove_feed_global\";b:0;s:27:\"remove_feed_global_comments\";b:0;s:25:\"remove_feed_post_comments\";b:0;s:19:\"remove_feed_authors\";b:0;s:22:\"remove_feed_categories\";b:0;s:16:\"remove_feed_tags\";b:0;s:29:\"remove_feed_custom_taxonomies\";b:0;s:22:\"remove_feed_post_types\";b:0;s:18:\"remove_feed_search\";b:0;s:21:\"remove_atom_rdf_feeds\";b:0;s:17:\"remove_shortlinks\";b:0;s:21:\"remove_rest_api_links\";b:0;s:20:\"remove_rsd_wlw_links\";b:0;s:19:\"remove_oembed_links\";b:0;s:16:\"remove_generator\";b:0;s:20:\"remove_emoji_scripts\";b:0;s:24:\"remove_powered_by_header\";b:0;s:22:\"remove_pingback_header\";b:0;s:28:\"clean_campaign_tracking_urls\";b:0;s:16:\"clean_permalinks\";b:0;s:32:\"clean_permalinks_extra_variables\";s:0:\"\";s:14:\"search_cleanup\";b:0;s:20:\"search_cleanup_emoji\";b:0;s:23:\"search_cleanup_patterns\";b:0;s:22:\"search_character_limit\";i:50;s:20:\"deny_search_crawling\";b:0;s:21:\"deny_wp_json_crawling\";b:0;s:20:\"deny_adsbot_crawling\";b:0;s:27:\"redirect_search_pretty_urls\";b:0;s:29:\"least_readability_ignore_list\";a:0:{}s:27:\"least_seo_score_ignore_list\";a:0:{}s:23:\"most_linked_ignore_list\";a:0:{}s:24:\"least_linked_ignore_list\";a:0:{}s:28:\"indexables_page_reading_list\";a:5:{i:0;b:0;i:1;b:0;i:2;b:0;i:3;b:0;i:4;b:0;}s:25:\"indexables_overview_state\";s:21:\"dashboard-not-visited\";s:28:\"last_known_public_post_types\";a:6:{i:0;s:4:\"post\";i:1;s:4:\"page\";i:2;s:10:\"attachment\";i:3;s:10:\"tdc-review\";i:4;s:16:\"tdc-review-email\";i:5;s:13:\"tdb_templates\";}s:28:\"last_known_public_taxonomies\";a:4:{i:0;s:8:\"category\";i:1;s:8:\"post_tag\";i:2;s:11:\"post_format\";i:3;s:19:\"tdc-review-criteria\";}s:23:\"last_known_no_unindexed\";a:6:{s:40:\"wpseo_total_unindexed_post_type_archives\";i:1693296137;s:35:\"wpseo_total_unindexed_general_items\";i:1693297731;s:31:\"wpseo_unindexed_post_link_count\";i:1693210966;s:31:\"wpseo_unindexed_term_link_count\";i:1693210967;s:27:\"wpseo_total_unindexed_posts\";i:1693296248;s:27:\"wpseo_total_unindexed_terms\";i:1693295302;}s:14:\"new_post_types\";a:0:{}s:14:\"new_taxonomies\";a:0:{}s:34:\"show_new_content_type_notification\";b:0;}'
    WHERE option_name = 'wpseo'

    1. update_option()

    Plugin: wordpress-seo 1 0.2498 UPDATE wp_options
    SET option_value = ''
    WHERE option_name = 'rewrite_rules'

    1. update_option()

    Plugin: wordpress-seo 1 0.1232 SELECT autoload
    FROM wp_options
    WHERE option_name = 'wordproof_access_token'

    1. delete_option()

    Plugin: wordpress-seo 0 0.3111 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_timeout_wpseo_unindexed_post_link_count'

    1. delete_option()

    Plugin: wordpress-seo 1 0.2521 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_timeout_wpseo_unindexed_post_link_count', '1693298632', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 0.5575 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_wpseo_unindexed_post_link_count', '0', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 0.4521 SELECT COUNT(P.ID)
    FROM wp_posts AS P
    LEFT JOIN wp_yoast_indexable AS I
    ON P.ID = I.object_id
    AND I.link_count IS NOT NULL
    AND I.object_type = 'post'
    LEFT JOIN wp_yoast_seo_links AS L
    ON L.post_id = P.ID
    AND L.target_indexable_id IS NULL
    AND L.type = 'internal'
    AND L.target_post_id IS NOT NULL
    AND L.target_post_id != 0
    WHERE ( I.object_id IS NULL
    OR L.post_id IS NOT NULL )
    AND P.post_status = 'publish'
    AND P.post_type IN ('post', 'page', 'tdc-review', 'tdc-review-email', 'tdb_templates')

    1. Yoast\W\S\A\I\Abstract_Indexing_Action->get_total_unindexed()

    Plugin: wordpress-seo 1 14.7233 UPDATE wp_options
    SET option_value = '1693384147'
    WHERE option_name = '_transient_timeout_wpseo_unindexed_post_link_count'

    1. update_option()

    Plugin: wordpress-seo 1 0.1339 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_wpseo_unindexed_term_link_count'

    1. delete_option()

    Plugin: wordpress-seo 1 0.1831 DELETE
    FROM
    wp_options
    WHERE option_name = '_transient_timeout_wpseo_unindexed_term_link_count'

    1. delete_option()

    Plugin: wordpress-seo 1 0.3892 INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES ('_transient_timeout_wpseo_unindexed_term_link_count', '1693298648', 'no')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    1. add_option()

    Plugin: wordpress-seo 1 0.3215 UPDATE wp_options
    SET option_value = '1693384149'
    WHERE option_name = '_transient_timeout_wpseo_unindexed_term_link_count'

    1. update_option()

    Plugin: wordpress-seo 1 0.3576 UPDATE wp_options
    SET option_value = '0'
    WHERE option_name = '_transient_wpseo_unindexed_term_link_count'

    1. update_option()

    Plugin: wordpress-seo 0 0.3871 UPDATE wp_options
    SET option_value = 'a:106:{s:8:\"tracking\";b:0;s:16:\"toggled_tracking\";b:0;s:22:\"license_server_version\";s:5:\"false\";s:15:\"ms_defaults_set\";b:0;s:40:\"ignore_search_engines_discouraged_notice\";b:0;s:19:\"indexing_first_time\";b:0;s:16:\"indexing_started\";b:0;s:15:\"indexing_reason\";s:20:\"taxonomy_made_public\";s:29:\"indexables_indexing_completed\";b:1;s:13:\"index_now_key\";s:0:\"\";s:7:\"version\";s:4:\"21.0\";s:16:\"previous_version\";s:5:\"20.12\";s:20:\"disableadvanced_meta\";b:1;s:30:\"enable_headless_rest_endpoints\";b:1;s:17:\"ryte_indexability\";b:0;s:11:\"baiduverify\";s:0:\"\";s:12:\"googleverify\";s:0:\"\";s:8:\"msverify\";s:0:\"\";s:12:\"yandexverify\";s:0:\"\";s:9:\"site_type\";s:4:\"blog\";s:20:\"has_multiple_authors\";b:1;s:16:\"environment_type\";s:10:\"production\";s:23:\"content_analysis_active\";b:1;s:23:\"keyword_analysis_active\";b:1;s:34:\"inclusive_language_analysis_active\";b:0;s:21:\"enable_admin_bar_menu\";b:0;s:26:\"enable_cornerstone_content\";b:0;s:18:\"enable_xml_sitemap\";b:0;s:24:\"enable_text_link_counter\";b:0;s:16:\"enable_index_now\";b:1;s:19:\"enable_ai_generator\";b:0;s:22:\"show_onboarding_notice\";b:0;s:18:\"first_activated_on\";s:10:\"1669769053\";s:13:\"myyoast-oauth\";b:0;s:26:\"semrush_integration_active\";b:0;s:14:\"semrush_tokens\";a:0:{}s:20:\"semrush_country_code\";s:2:\"us\";s:19:\"permalink_structure\";s:12:\"/%postname%/\";s:8:\"home_url\";s:21:\"https://pipilopop.com\";s:18:\"dynamic_permalinks\";b:0;s:17:\"category_base_url\";s:3:\"cat\";s:12:\"tag_base_url\";s:3:\"tag\";s:21:\"custom_taxonomy_slugs\";a:3:{s:6:\"sc_tag\";s:6:\"sc_tag\";s:19:\"tdc-review-criteria\";s:19:\"tdc-review-criteria\";s:22:\"cookielawinfo-category\";s:22:\"cookielawinfo-category\";}s:29:\"enable_enhanced_slack_sharing\";b:0;s:25:\"zapier_integration_active\";b:0;s:19:\"zapier_subscription\";a:0:{}s:14:\"zapier_api_key\";s:0:\"\";s:23:\"enable_metabox_insights\";b:0;s:23:\"enable_link_suggestions\";b:1;s:26:\"algolia_integration_active\";b:0;s:14:\"import_cursors\";a:0:{}s:13:\"workouts_data\";a:1:{s:13:\"configuration\";a:1:{s:13:\"finishedSteps\";a:0:{}}}s:28:\"configuration_finished_steps\";a:0:{}s:36:\"dismiss_configuration_workout_notice\";b:0;s:34:\"dismiss_premium_deactivated_notice\";b:0;s:19:\"importing_completed\";a:0:{}s:26:\"wincher_integration_active\";b:0;s:14:\"wincher_tokens\";a:0:{}s:36:\"wincher_automatically_add_keyphrases\";b:0;s:18:\"wincher_website_id\";s:0:\"\";s:28:\"wordproof_integration_active\";b:0;s:29:\"wordproof_integration_changed\";b:0;s:18:\"first_time_install\";b:0;s:34:\"should_redirect_after_install_free\";b:0;s:34:\"activation_redirect_timestamp_free\";b:0;s:18:\"remove_feed_global\";b:0;s:27:\"remove_feed_global_comments\";b:0;s:25:\"remove_feed_post_comments\";b:0;s:19:\"remove_feed_authors\";b:0;s:22:\"remove_feed_categories\";b:0;s:16:\"remove_feed_tags\";b:0;s:29:\"remove_feed_custom_taxonomies\";b:0;s:22:\"remove_feed_post_types\";b:0;s:18:\"remove_feed_search\";b:0;s:21:\"remove_atom_rdf_feeds\";b:0;s:17:\"remove_shortlinks\";b:0;s:21:\"remove_rest_api_links\";b:0;s:20:\"remove_rsd_wlw_links\";b:0;s:19:\"remove_oembed_links\";b:0;s:16:\"remove_generator\";b:0;s:20:\"remove_emoji_scripts\";b:0;s:24:\"remove_powered_by_header\";b:0;s:22:\"remove_pingback_header\";b:0;s:28:\"clean_campaign_tracking_urls\";b:0;s:16:\"clean_permalinks\";b:0;s:32:\"clean_permalinks_extra_variables\";s:0:\"\";s:14:\"search_cleanup\";b:0;s:20:\"search_cleanup_emoji\";b:0;s:23:\"search_cleanup_patterns\";b:0;s:22:\"search_character_limit\";i:50;s:20:\"deny_search_crawling\";b:0;s:21:\"deny_wp_json_crawling\";b:0;s:20:\"deny_adsbot_crawling\";b:0;s:27:\"redirect_search_pretty_urls\";b:0;s:29:\"least_readability_ignore_list\";a:0:{}s:27:\"least_seo_score_ignore_list\";a:0:{}s:23:\"most_linked_ignore_list\";a:0:{}s:24:\"least_linked_ignore_list\";a:0:{}s:28:\"indexables_page_reading_list\";a:5:{i:0;b:0;i:1;b:0;i:2;b:0;i:3;b:0;i:4;b:0;}s:25:\"indexables_overview_state\";s:21:\"dashboard-not-visited\";s:28:\"last_known_public_post_types\";a:6:{i:0;s:4:\"post\";i:1;s:4:\"page\";i:2;s:10:\"attachment\";i:3;s:10:\"tdc-review\";i:4;s:16:\"tdc-review-email\";i:5;s:13:\"tdb_templates\";}s:28:\"last_known_public_taxonomies\";a:4:{i:0;s:8:\"category\";i:1;s:8:\"post_tag\";i:2;s:11:\"post_format\";i:3;s:19:\"tdc-review-criteria\";}s:23:\"last_known_no_unindexed\";a:6:{s:40:\"wpseo_total_unindexed_post_type_archives\";i:1693296137;s:35:\"wpseo_total_unindexed_general_items\";i:1693297731;s:31:\"wpseo_unindexed_post_link_count\";i:1693297748;s:31:\"wpseo_unindexed_term_link_count\";i:1693297749;s:27:\"wpseo_total_unindexed_posts\";i:1693296248;s:27:\"wpseo_total_unindexed_terms\";i:1693295302;}s:14:\"new_post_types\";a:0:{}s:14:\"new_taxonomies\";a:0:{}s:34:\"show_new_content_type_notification\";b:0;}'
    WHERE option_name = 'wpseo'

    1. update_option()

    Plugin: wordpress-seo 1 0.1540 UPDATE wp_options
    SET option_value = 'a:38:{i:1693297220;a:1:{s:23:\"swcfpc_cache_purge_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:32:\"swcfpc_purge_cache_cron_interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:10;}}}i:1693297848;a:1:{s:33:\"wc_admin_process_orders_milestone\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693297856;a:1:{s:29:\"wc_admin_unsnooze_admin_notes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693298012;a:1:{s:25:\"group_post_scheduler_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693298139;a:1:{s:16:\"nxs_hourly_event\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693298180;a:1:{s:25:\"wpp_maybe_performance_nag\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693299361;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693300176;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1693301349;a:1:{s:27:\"wpseo_indexable_index_batch\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:15:\"fifteen_minutes\";s:4:\"args\";a:0:{}s:8:\"interval\";i:900;}}}i:1693308283;a:1:{s:28:\"wpacu_daily_scheduled_events\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693308290;a:1:{s:21:\"wp_update_user_counts\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693309147;a:1:{s:18:\"wp_https_detection\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693311231;a:2:{s:31:\"wpseo_permalink_structure_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}s:20:\"wpseo_home_url_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693311494;a:1:{s:13:\"wpseo-reindex\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693312842;a:1:{s:15:\"ao_cachechecker\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693314576;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693319720;a:1:{s:41:\"googlesitekit_cron_update_remote_features\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693321316;a:1:{s:21:\"td_instagram_cron_job\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1693323227;a:1:{s:19:\"td_clear_transients\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693327117;a:1:{s:13:\"sm_ping_daily\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693348541;a:1:{s:30:\"wp_scheduled_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693349535;a:1:{s:19:\"wpseo-reindex-links\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693353600;a:1:{s:14:\"tptn_cron_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693355133;a:1:{s:25:\"hmwp_update_ips_to_server\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}}i:1693357775;a:1:{s:32:\"recovery_mode_clean_expired_keys\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693366250;a:1:{s:14:\"wc_admin_daily\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693369223;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693369224;a:1:{s:25:\"delete_expired_transients\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693375200;a:1:{s:15:\"wpp_cache_event\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693375605;a:1:{s:16:\"optml_daily_sync\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693381596;a:1:{s:20:\"jetpack_v2_heartbeat\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1693400103;a:1:{s:30:\"wp_delete_temp_updater_backups\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}}i:1693487375;a:1:{s:22:\"dst_update_ad-inserter\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:7:\"monthly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:2592000;}}}i:1693616976;a:1:{s:30:\"yotuwp_weekly_scheduled_events\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}}i:1693788567;a:1:{s:30:\"wp_site_health_scheduled_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}}i:1693850593;a:1:{s:21:\"wpo_weekly_cron_tasks\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}}i:1694692792;a:1:{s:18:\"yotuwp_cache_event\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"montly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:2592000;}}}s:7:\"version\";i:2;}'
    WHERE option_name = 'cron'

    1. update_option()

    Plugin: wordpress-seo 1 0.4266 SELECT *
    FROM
    wp_yoast_primary_term
    WHERE post_id = '53741'
    AND taxonomy = 'category'
    LIMIT 1

    1. Yoast\W\S\R\Primary_Term_Repository->find_by_post_id_and_taxonomy()

    Plugin: wordpress-seo 0 0.5537

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @egocefalo

    I’m sorry about the slow queries. Assuming you are running Yoast SEO 21.0 and WordPress 6.3, can you confirm you have run the SEO data optimization analysis in WordPress > Yoast SEO > Tools?

    Thread Starter egocefalo

    (@egocefalo)

    Hi @maybellyne Yes optimization is complete.

    Plugin Support Suwash

    (@suascat_wp)

    @egocefalo

    Can you please try resetting our indexables in the database tables by following the steps below?
    1. Install & activate the?Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Hit the “Reset indexables & migrations” button.
    4. Go to SEO > Tools, and under SEO data, click the “SEO Data Optimization” button to allow Yoast to rescan your pages.


    For your site’s health and safety, we recommend creating regular backups of your site and database. This is especially important before installing, updating, or removing plugins. Learn more about the benefits of regular backups.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Many ( up to 30) slow queries from Plugin: wordpress-seo’ is closed to new replies.