slow queries
-
Query Monitor showing slow queries from Element Ready Lite, which is taking 0.7 seconds and have 50582 rows.
here is the query
SELECT?post_id, meta_key, meta_value
FROM?wp_postmeta
WHERE?post_id?IN?(22419,22420,22418,22378,22376,22388,22323,22322,22321,22253,22252,22251,22234,22235,22228,22115,22171,22169,22170,22120,22118,22110,22041,22033,22031,21975,21974,21973,21940,21910,21909,21892,21890,21891,21866,21864,21863,21847,21846,21845,21777,21776,21778,21747,21748,21749,21718,21720,21719,21685,21684,21686,21608,21609,21610,21597,21560,21558,21559,21540,21539,21538,21537,21381,21380,21379,21378,21218,21217,21216,21191,21190,21189,21077,21078,21062,21061,21060,21059,21026,21025,21024,21011,21012,21010,20996,20995,20994,20985,20984,20983,20967,20982,20966,20965,20940,20941,20939,20904,20903,20929,20902,20930,20882,20881,20880,20853,20854,20852,20772,20773,20771,20756,20755,20754,20700,20701,20697,20678,20677,20676,20667,20666,20665,20660,20659,20658,20593,20592,20585,20458,20498,20497,20496,20466,20457,20456,20415,20414,20413,20350,20353,20357,20747,20305,20304,20303,20229,20231,20230,20140,20139,20225,20115,20116,20073,20099,20098,20097,20749,20091,20085,20075,20074,20061,20060,20026,20025,20024,20016,19979,19978,19977,20059,16517,16519,16518,16500,16499,16498,16481,16479,16473,16446,16445,16444,16424,16425,16423,16410,16409,16396,16375,16374,16373,16372,16329,16328,16327,19874,19875,19873,16071,16072,16069,16058,16055,16053,16050,16035,16029,16025,16009,16007,16006,15998,15989,15990,15970,15972,15966,15967,15958,15956,15937,15939,15943,15925,15923,15921,15912,15911,15910,15896,15898,15900,15884,15887,15881,15867,15858,15733,15864,15824,15817,15841,15800,15804,15802,15794,15791,15787,15740,15762,15754,15744,15766,15758,15749,15830,15833,15721,15738,15730,15726,15718,15707,15704,15689,15692,15694,15797,15676,15628,15679,15683,15831,15665,15672,15669,15659,15651,15655,15641,15619,15622,15598,15595,15505,15577,15575,15603,15550,15551,15553,15530,15522,15524,15498,15496,15464,15472,15461,15438,15451,15428,15441,15408,15407,15419,15379,15382,15387,15360,15369,15358,15333,15334,15341,15297,15310,15296,15285,15279,15278,15266,15261,15260,15241,15243,15228,15211,15210,15209,15202,15201,15200,15187,15185,15183,15172,15176,15174,15155,15163,15158,15149,15152,15167,15141,15139,15137,15123,15125,15127,15110,15114,15112,15102,15100,15098,15085,15079,15087,15081,15065,15070,15067,15054,15053,15058,15037,15040,13380,15024,15020,15022,15007,15004,15006,15010,14991,14988,14989,14973,14977,14975,14658,14655,14661,14644,14638,14641,14631,14628,14625,14604,14602,14600,14580,14577,14582,14562,14566,14564,14549,14544,14542,14518,14516,14520,14500,14502,14498,14476,14480,14479,14465,14462,14466,14445,14447,14443,14420,14422,14425,14409,14404,14399,14383,14389,14386,14374,14369,14372,14354,14350,14351,14143,14141,14145,14126,14128,14131,14116,14112,14114,14073,14075,14077,14057,14063,14060,14108,14105,14102,14043,14044,14045,14035,14032,14028,14017,14014,14012,13998,13996,14001,13979,13981,13977,13953,13955,13952,13954,13940,13941,13944,13925,13921,13918,13899,13898,13897,13881,13877,13879,13861,13863,13859,13839,13838,13837,13826,13823,13817,13800,13802,13804,13773,13782,13783,13749,13757,13755,13734,13736,13711,13710,13709,13708,13742,13694,13698,13696,13685,13684,13667,13668,13671,13659,13658,13650,13636,13643,13630,13653,13647,13640,13617,13614,13609,13604,13591,13586,13594,13582,13567,13563,13562,13566,13540,13546,13538,13537,13507,13522,13521,13500,13501,13499,13489,13487,13485,13481,13476,13475,13472,13465,13453,13456,13448,13435,13429,13433,13410,13411,13393,13391,13397,13400,13382,13373,13377,13374,13358,13355,13347,13346,13317,13311,13310,13306,13302,13287,13288,13295,13283,13280,13277,13274,13262,13242,13240,13236,13238,13256,13253,13228,13220,13221,13226,13211,13213,13206,13209,13195,13193,13199,13197,13190,13187,13179,13182,13167,13170,13161,13163,13147,13150,13152,12843,13127,12836,13132,13139,13123,13121,13125,13107,13102,13099,13096,13085,13089,13087,13075,13078,13080,13072,13069,13066,13063,13040,13051,13054,13045,13042,13049,13032,13026,13022,13017,13012,13010,12973,12970,12975,12933,12929,12936,12942,12921,12917,12913,12910,12885,12884,12848,12818,12953,12863,12901,12874,12870,12958,12963,12861,12880,12906,12800,12772,12716,12715,12714,12753,12768,12811,12805,12744,12788,12757,12785,12829,12794,12776,12833,12781,12825,12692,12682,12689,12685,12670,12664,12661,12654,12667,12657,12644,12641,12638,12633,12629,12619,12622,12614,12604,12589,12601,12598,12593,12611,12607,12584,12581,12576,12573,12570,12567,12556,12553,12563,12559,12679,12650,12676,12647,12673,12549,12542,12538,12535,12532,12519,12514,12528,12525,12505,12500,12511,12508,12497,12494,12491,12488,12485,12482,12479,12473,12474,12470,12467,12464,12461,12458,12455,12452,12447,12430,12426,12411,12403,12406,12393,12376,12396,12346,12347,12352,12350,12327,12321,12291,12318,12312,12287,12315,12307,12302,12297,12267,12268,12269,12245,12240,12234,12210,12212,12211,12197,12196,12178,12170,12156,12172,12171,12167,12158,12157,12137,12136,12135,12134,12119,12118,12117,12097,12096,12109,12067,12066,12065,12040,12038,12037,12052,12049,12036,12024,12012,12011,12010,12003,11999,12076,11987,11986,11985,11943,11942,11906,11907,11904,11902,11920,11905,11903,11837,11833,11828,11827,11809,11807,11806,11824,11808,11805,11804,11794,11797,11793,11791,11763,11762,11761,11759,11784,11783,11782,11760,11749,11747,11748,11718,11717,11719,11711,11710,11700,11693,11691,11707,11701,11692,11680,11679,11678,11666,11650,11649,11648,11556,11550,11518,11517,11516,11509,11508,11488,11487,11433,11360,11359,11324,11317,10999,10998,10654,10652,10664,10653,10649,10465,10464,10043,10042,10038,10029,10022,10014,10013,9601,9592,9591,9590,9569,9553,9541,9540,9330,9327,9317,9316,9305,9306,9304,9303,9298,9291,9293,9290,8618,8617,8614,8608,8332,8324,8310,8308,8333,8323,8311,8309,8302,8299,8292,8291,7997,7985,7982,7703,7863,7879,7793,7962,7830,7807,7924,7724,7806,7952,7738,7860,7976,7787,7734,7790,7749,7900,7690,7905,7818,7883,7714,7832,7817,7959,7741,7829,7972,7760,7748,7325,7681,7296,7794,7706,7331,7284,7744,7305,7299,7771,7727,7675,7315,7287,7342,7074,7814,7319,7293,7792,7747,7679,7302,7797,7281,7775,7921,7665,7308,7290,7398,7670,7084,6044,7917,7694,7346,7680,7171,8166,7684,7183,7732,7002,7369,7678,7779,7699,7167,7358,7129,7759,7750,7272,7070,7388,7278,6972,8251,4956,7263,6993,7426,5285,7266,6916,7077,6963,5288,6911,7147,7391,6957,6705,8259,7108,6674,7420,7329,7080,6636,6714,6941,6939,7401,7316,6922,7067,7415,7269,6724,7349,7260,7343,6908,7380,6919,7423,6987,6708,7385,7362,7322,6925,6968,6901,7395,7275,6680,7412,6977,7354,6931,9196,8496,8486,9234,7928,8482,8475,9217,9254,9220,9224,9231,9237,9238,9243,5776,5262,5504,5221,5767,8080,5246,5268,5253,5761,5291,5241,5764,8062,5784,5214,5521,5257,8069,5249,5770,7335,5774,5778,5210,8092,8085,8100,5091,5201,5749,5758,5753,3306,3241,3240,3239,1113,1011,1008,1005)
ORDER?BY?meta_id?ASC
- The topic ‘slow queries’ is closed to new replies.