Slow queries (frontend)

  • Resolved lgivanovivan

    (@lgivanovivan)


    2 years, 1 month ago

    Hello!
    I have 2 slow queries on all web pages:

    1.3 sec:
    SELECT SQL_CALC_FOUND_ROWS wp_users.*
    FROM wp_users
    INNER JOIN wp_usermeta
    ON ( wp_users.ID = wp_usermeta.user_id )
    WHERE 1=1
    AND ( ( ( wp_usermeta.meta_key = ‘wp_capabilities’
    AND wp_usermeta.meta_value LIKE ‘%\”Administrator\”%’ ) ) )
    ORDER BY user_login ASC
    LIMIT 0, 1

    1.2 sec:
    SELECT SQL_CALC_FOUND_ROWS wp_users.*
    FROM wp_users
    INNER JOIN wp_usermeta
    ON ( wp_users.ID = wp_usermeta.user_id )
    WHERE 1=1
    AND ( ( ( wp_usermeta.meta_key = ‘wp_capabilities’
    AND wp_usermeta.meta_value LIKE ‘%\”Administrator\”%’ ) ) )
    ORDER BY user_login ASC
    LIMIT 0, 1

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Adam Dunnage

    (@adamdunnage)

    Hi @lgivanovivan thanks for getting in touch. You have opened this topic on the Site Kit plugin support forum so can I ask if this related to an issue with the plugin you are having? If yes then could you please explain exactly what the issue is?

    Site Kit allows you to connect various Google services as modules within the plugin and simply places any code needed for these services on your site.

    Thread Starter lgivanovivan

    (@lgivanovivan)

    These slow requests are generated by the google-site-kit plugin. I don’t understand why the plugin analyzes site users. Are these requests only for the administrator?

    Plugin Support Adam Dunnage

    (@adamdunnage)

    @lgivanovivan I will discuss this in more depth with the team and get back to you on this once I have an update.

    Thread Starter lgivanovivan

    (@lgivanovivan)

    I found the cause of the problem. Slow requests are caused by the “Show current page statistics on the admin panel” settings item. If you turn it off, the problem goes away.

    Plugin Support Adam Dunnage

    (@adamdunnage)

    @lgivanovivan Thanks for the update. These requests will only be made when logged in as admin and checking those statistics. As you noted you can also turn this setting off if you wish to do so.

    Is there anything else I can help you with?

    Thread Starter lgivanovivan

    (@lgivanovivan)

    No, thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Slow queries (frontend)’ is closed to new replies.