• Query Monitor showing 14 calls on every page from your Plugin, each of them taking ~0.2 seconds to execute 

    SELECT COUNT() FROM wp_visitors_stat WHERE time BETWEEN 1702512000 AND 1702598399 wvw_visitors_widget() Plugin: wp-visitors-widget 1 0.1933 SELECT COUNT()
    FROM wp_visitors_stat
    wvw_visitors_widget()
    Plugin: wp-visitors-widget 1 0.1197
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702553863
    AND 1702571863
    wvw_visitors_widget()
    Plugin: wp-visitors-widget 220 0.2247
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702512000
    AND 1702533600
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 235 0.2050
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702533600
    AND 1702555200
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 246 0.2237
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702555200
    AND 1702576800
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 202 0.2119
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702576800
    AND 1702598400
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 0 0.2106
    SELECT COUNT() FROM wp_visitors_stat WHERE time BETWEEN 1702512000 AND 1702598399 wvw_visitors_widget() Plugin: wp-visitors-widget 1 0.2160 SELECT COUNT()
    FROM wp_visitors_stat
    wvw_visitors_widget()
    Plugin: wp-visitors-widget 1 0.1174
    SELECT DISTINCT ip
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702553865
    AND 1702571865
    wvw_visitors_widget()
    Plugin: wp-visitors-widget 220 0.2083
    SELECT COUNT() FROM wp_visitors_stat WHERE time BETWEEN 1702121865 AND 1702229865 wvw_get_graph_array() Plugin: wp-visitors-widget 1 0.1752 SELECT COUNT()
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702229865
    AND 1702337865
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 1 0.2010
    SELECT COUNT() FROM wp_visitors_stat WHERE time BETWEEN 1702337866 AND 1702445866 wvw_get_graph_array() Plugin: wp-visitors-widget 1 0.1771 SELECT COUNT()
    FROM wp_visitors_stat
    WHERE time BETWEEN 1702445866
    AND 1702553866
    wvw_get_graph_array()
    Plugin: wp-visitors-widget 1 0.1719
  • The topic ‘slow queries’ is closed to new replies.