WordPress.org

Ready to get started?Download WordPress

Forums

Pierre's Wordspew
[Plugin: Pierre's Wordspew] Slow queries (2 posts)

  1. halluzineyt
    Member
    Posted 3 years ago #

    my wordspew seems to be generating slow queries

    Executed 22 min ago for 2 sec on Database --> TABLES.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3024 ORDER BY id DESC
    Executed 20 min ago for 2 sec on Database --> TABLES.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3026 ORDER BY id DESC
    Executed 19 min ago for 2 sec on Database --> TABLES.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3028 ORDER BY id DESC
    Executed 18 min ago for 3 sec on Database --> TABLES.
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes
    Executed 14 min ago for 3 sec on Database --> 90.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3041 ORDER BY id DESC
    Executed 12 min ago for 3 sec on Database --> 90.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3041 ORDER BY id DESC
    Executed 11 min ago for 6 sec on Database --> 90.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3044 ORDER BY id DESC
    Executed 10 min ago for 7 sec on Database --> 90.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3044 ORDER BY id DESC
    Executed 6 min ago for 2 sec on Database --> 90.
    SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (8150,8141,8134,8064,8068,8048,8045,8041,8039,8032,8026,8015,8006,5422,7979,7899,7894,7889,7875,7847,7843,7811,7766,7748,7989,7726,7771,7722,7710,7699,7695,7689,7684,7680,7671,7663,7655,7659,7649,7636,7634,7632,7622,7620,7618,7609,7600,7597,7593,7582,7573,7567,7543,7540,7538,7531,7518,7519,7516,7514,7510,7507,7502,7498,7490,7488,7481,7458,7463,7456,7451,7449,7436,7433,7419,7413,7410,7407,7398,7388,7377,7379,7374,7368,7370,7352,7341,7339,7331,7310,7318,7292,7283,7275,7270,7287,7254,7250,7246,7232,7215,7204,7199,7182,7184,7168,7166,7164,7108,7154,7151,7149,7146,7134,7126,7121,7119,7112,7101,7095,7106,7085,7080,7103,7074,7073,7067,7063,6966,6949,6943,6507,6510,6391,6383,6946,6364,6329,6347,6308,6311,6302,6280,6257,6259,6247,6233,6228,6225,6157,6155,6153,6148,6137,6135,6130,6127,6121,6117,6110,6108,6106,6099,6096,6094,6090,6085,6072,6069,6066,6028,6025,6013,6010,6007,6005,6002,5995,5973,5953,5951,5942,5937,5920,5924,5907,5874,5869,5867,5865,5851,5835,5801,5798,5773,5771,5769,5748,5751,5629,5620,5566,5551,5549,5537,5539,5514,5495,5491,5474,5458,5426,5406,5352,5348,5341,5328,5325,5316,5306,5292,5286,4448,4883,4879,4691,4629,4495,4292,4494,3968,4383,4342,4336,4311,4288,4269,4264,4251,4239,4208,4218,4189,4204,4151,4146,4134,3964,4118,4098,4084,4061,4050,3997,3969,3961,3953,3949,3938,3929,3924,3918,3908,3905,3896,3840,3838,3835,3823,3819,3813,3811,3805,3795,3791,3786,3784,3781,3778,3773,3682,3697,3680,3687,3684,3657,3652,3646,3639,3636,3631,3628,3622,3618,3615,3612,3602,3597,3594,3589,3585,3582,3580,3563,3558,3509,3507,3478,3474,3439,3414,3164,3159,3157,3144,3113,3106,2875,2858,2849,2816,2798,2781,2769,2762,2758,2747,2731,2724,2714,2701,2691,2679,2672,2653,2648,2643,2554,2541,2539,2534,2468,2453,2406,2395,2389,2383,2377,2369,2360,2347,2335,2329,2322,2315,2306,2278,2260,2251,2247,2237,2229,2223,2208,2165,2152,2132,2124,2114,2104,2091,2067,2051,2043,2039,2029,2018,2010,2003,1996,1991,1983,1968,1961,1951,1949,1946,1939,1931,1926,1819,1804,1794,1784,1763,1746,1743,1729,1720,1671,1676,1647,1644,1635,1619,1609,1603,1597,1435,1430,1403,1404,1396,1388,1371,1340,1063,1013,1007,1003,960,865,786,767,747,746,691,683,670,638,603,588,585,550,496,481,440,424,28
    Executed 6 min ago for 5 sec on Database --> 90.
    SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (85
    Executed 6 min ago for 2 sec on Database --> 90.
    SELECT DISTINCT wp_posts.*, (meta_value+0) AS views FROM wp_posts LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE post_date < '2011-02-24 17:20:10' AND post_type = 'post' AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER BY views DESC LIMIT 15
    Executed 5 min ago for 2 sec on Database --> TABLES.
    SELECT * FROM wp_liveshoutbox WHERE cat='' AND id > 3055 ORDER BY id DESC

    http://wordpress.org/extend/plugins/pierres-wordspew/

  2. halluzineyt
    Member
    Posted 3 years ago #

    anybody ? is there any updated shoutbox with the same features as the piere wordspew?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic