Excessive SQL query

  • Resolved MedvidekPU

    (@medvidekpu)


    2 years, 10 months ago

    Found following excessive SQL query running several times per hour. Should be fixed i guess.

    Query lenght: 0.679716 s
    Dotaz: # Rows_affected: 0 Bytes_sent: 20788958

    SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (17,19,20,27,58,63,64,85,87,88,90,91,93,96,97,98,99,102,105,107,116,122,133,138,140,143,150,155,157,159,166,172,178,185,190,191,193,202,205,206,208,209,213,214,217,224,228,232,236,240,244,248,252,256,260,266,270,274,278,284,291,295,299,303,315,317,323,327,331,3

    … goes on and on for ALL IDs, thousands of them

    116,16118,16120,16121,16123,16129,16130,16147,16148,16182,16183,16198,16199,16203,16204,16218,16219) ORDER BY meta_id ASC;`

Viewing 1 replies (of 1 total)
  • Thread Starter MedvidekPU

    (@medvidekpu)

    Kept looking, as this bounced back. My mistake on begging, this is not related to this plugin. So my apology, marked it as resolved.

    If anyone interested – Theme Amphibious runs this massive query for every media request – something not happening in other themes.

Viewing 1 replies (of 1 total)
  • The topic ‘Excessive SQL query’ is closed to new replies.