Current threads_connected: 583 Process List: Id User Host db Command Time State Info Progress 22791113 replication_web2_22 14.13.93.25:40722 NULL Binlog Dump 137777 Master has sent all binlog to slave; waiting for more updates NULL 0.000 22793019 replication_web2_22 10.10.10.7:64618 NULL Binlog Dump 137760 Master has sent all binlog to slave; waiting for more updates NULL 0.000 25857848 replication_web2_22 10.10.10.5:40140 NULL Binlog Dump 46111 Master has sent all binlog to slave; waiting for more updates NULL 0.000 25860589 replication_web2_22 10.10.10.1:34514 NULL Binlog Dump 46028 Master has sent all binlog to slave; waiting for more updates NULL 0.000 26957657 user_all 10.10.10.5:38982 user_jobs2 Sleep 699 NULL 0.000 27281497 user_all 10.10.10.1:50968 user_jobs2 Query 734 Updating UPDATE jobs SET expiry_date = '2023-04-26' WHERE expiry_date > '2023-04-26' AND id IN (2284503901,2284503904,2284503906,2284503917,2284503925,2284503966,2284503969,2284503975,2284503978,2284503993,2284504039,2284504041,2284504045,2284504053,2284504070,2284504165,2284504173,2284504176,2284504178,2284504183,2284504184,2284504215,2284504221,2284504232,2284504260,2284504263,2284504274,2284504295,2284504305,2284504306,2284504321,2284504322,2284504323,2284504325,2284504328,2284504340,2284504366,2284504377,2284504378,2284504435,2284504436,2284504437,2284504438,2284504439,2284504440,2284504441,2284504442,2284504443,2284504444,2284504445,2284504446,2284504447,2284504448,2284504449,2284504450,2284504451,2284504452,2284504453,2284504454,2284504455,2284504456,2284504457,2284504458,2284504459,2284504460,2284504461,2284504462,2284504463,2284504466,2284504467,2284504468,2284504471,2284504472,2284504475,2284504476,2284504477,22 84504478,2284504479,2284504480,2284504481,2284504488,2284504489,2284504490,2284504491,2284504494,2284504495,2284504496,2284504497,2284504551,2284504557,2284504558,2284504559,2284504567,2284504570,2284504571,2284504589,2284504599,2284504630,2284504635,2284504636,2284504640,2284504670,2284504676,2284504677,2284504678,2284504687,2284504700,2284504705,2284504723,2284504726,2284504743,2284504745,2284504759,2284504893,2284504913,2284504938,2284504942,2284504976,2284505010,2284505011,2284505035,2284505036,2284505038,2284505043,2284505080,2284505083,2284505097,2284505153,2284505186,2284505207,2284505242,2284505243,2284505246,2284505247,2284505248,2284505249,2284505250,2284505251,2284505252,2284505269,2284505296,2284505298,2284505330,2284505339,2284505406,2284505414,2284505441,2284505443,2284505446,2284505449,2284505573,2284505620,2284505635,2284505694,2284505717,2284505730,2284505733,2284505745,2284505764,2284505786,2284505913,2284505921,2284505926,2284505928,2284505938,2284505939,228450594 3,2284505946,2284505981,2284505990,2284506064,2284506181,2284506194,2284506239,2284506246,2284506302,2284506303,2284506327,2284506335,2284506336,2284506340,2284506363,2284506387,2284506390,2284506396,2284506408,2284506409,2284506411,2284506414,2284506417,2284506435,2284506436,2284506464,2284506465,2284506485,2284506487,2284506489,2284506540,2284506606,2284506647,2284506705,2284506711,2284506717,2284506760,2284506775,2284506787,2284506793,2284506835,2284506842,2284506843,2284506854,2284506871,2284506889,2284506912,2284506918,2284506930,2284506935,2284506952,2284506962,2284506963,2284506968,2284506986,2284507001,2284507003,2284507019,2284507021,2284507065,2284507079,2284507086,2284507089,2284507100,2284507136,2284507138,2284507143,2284507161,2284507174,2284507251,2284507312,2284507324,2284507326,2284507333,2284507341,2284507356,2284507372,2284507376,2284507408,2284507442,2284507444,2284507445,2284507473,2284507475,2284507477,2284507478,2284507483,2284507511,2284507545,2284507554,22845 07555,2284507568,2284507572,2284507603,2284507605,2284507683,2284507685,2284507732,2284507780,2284507784,2284507794,2284507804,2284507808,2284507810,2284507815,2284507830,2284507836,2284507841,2284507907,2284507923,2284507924,2284507933,2284507954,2284507956,2284507959,2284507996,2284508018,2284508027,2284508031,2284508068,2284508082,2284508094,2284508095,2284508097,2284508149,2284508228,2284508253,2284508258,2284508268,2284508276,2284508280,2284508296,2284508327,2284508334,2284508343,2284508347,2284508356,2284508384,2284508407,2284508410,2284508412,2284508423,2284508426,2284508429,2284508430,2284508462,2284508493,2284508499,2284508502,2284508504,2284508505,2284508514,2284508518,2284508519,2284508548,2284508582,2284508588,2284508612,2284508613,2284508623,2284508624,2284508701,2284508714,2284508720,2284508729,2284508743,2284508761,2284508762,2284508777,2284508781,2284508820,2284508822,2284508843,2284508860,2284508887,2284508904,2284508921,2284508976,2284509000,2284509004,2284509017,2 284509046,2284509071,2284509139,2284509144,2284509150,2284509158,2284509180,2284509196,2284509201,2284509208,2284509217,2284509229,2284509279,2284509310,2284509321,2284509353,2284509368,2284509372,2284509376,2284509392,2284509395,2284509410,2284509459,2284509484,2284509491,2284509502,2284509503,2284509523,2284509539,2284509558,2284509563,2284509564,2284509573,2284509619,2284509640,2284509659,2284509666,2284509671,2284509727,2284509779,2284509784,2284509786,2284509793,2284509805,2284509814,2284509894,2284509909,2284509917,2284509958,2284509975,2284509997,2284510029,2284510044,2284510076,2284510111,2284510123,2284510124,2284510128,2284510135,2284510141,2284510152,2284510179,2284510208,2284510230,2284510234,2284510308,2284510368,2284510370,2284510382,2284510400,2284510418,2284510433,2284510437,2284510441,2284510445,2284510446,2284510448,2284510485,2284510491,2284510595,2284510607,2284510615,2284510786,2284510795,2284510807,2284510811,2284510814,2284510828,2284510854,2284510857,22845108 82,2284510885,2284510908,2284510939,2284510941,2284510942,2284510945,2284510952,2284510967,2284510971,2284510977,2284510986,2284510995,2284511007,2284511084,2284511106,2284511116,2284511159,2284511184,2284511194,2284511198,2284511200,2284511204,2284511207,2284511214,2284511266,2284511273,2284511278,2284511308,2284511318,2284511321,2284511352,2284511370,2284511382,2284511387,2284511443,2284511451,2284511464,2284511485,2284511488,2284511494,2284511500,2284511520,2284511522,2284511546,2284511557,2284511564,2284511587,2284511601,2284511602,2284511607,2284511630,2284511637,2284511663,2284511668,2284511672,2284511687,2284511700,2284511732,2284511738,2284511761,2284511764,2284511765,2284511766,2284511783,2284511834,2284511855,2284511871,2284511877,2284511912,2284511949,2284511967,2284512012,2284512046,2284512053,2284512062,2284512080,2284512086,2284512118,2284512176,2284512193,2284512206,2284512208,2284512209,2284512216,2284512217,2284512219,2284512229,2284512234,2284512286,2284512295,2284 512314,2284512351,2284512360,2284512363,2284512370,2284512379,2284512382,2284512386,2284512387,2284512398,2284512409,2284512429,2284512455,2284512460,2284512462,2284512487,2284512491,2284512501,2284512510,2284512524,2284512525,2284512528,2284512529,2284512534,2284512541,2284512543,2284512545,2284512558,2284512563,2284512597,2284512602,2284512608,2284512624,2284512638,2284512644,2284512650,2284512651,2284512661,2284512667,2284512678,2284512691,2284512698,2284512699,2284512714,2284512750,2284512771,2284512775,2284512781,2284512793,2284512794,2284512843,2284512968,2284512971,2284512972,2284512973,2284512978,2284512980,2284512985,2284512990,2284513040,2284513069,2284513082,2284513083,2284513092,2284513101,2284513107,2284513120,2284513163,2284513238,2284513246,2284513271,2284513275,2284513278,2284513279,2284513280,2284513294,2284513333,2284513356,2284513357,2284513358,2284513404,2284513427,2284513464,2284513553,2284513557,2284513583,2284513587,2284513594,2284513608,2284513614,2284513638, 2284513664,2284513668,2284513703,2284513708,2284513715,2284513723,2284513725,2284513790,2284513795,2284513800,2284513812,2284513821,2284513823,2284513835,2284513853,2284513855,2284513884,2284513963,2284513965,2284513993,2284514022,2284514051,2284514052,2284514054,2284514092,2284514102,2284514106,2284514118,2284514139,2284514142,2284514159,2284514168,2284514170,2284514214,2284514224,2284514250,2284514264,2284514310,2284514311,2284514387,2284514400,2284514407,2284514418,2284514434,2284514447,2284514450,2284514452,2284514464,2284514465,2284514468,2284514471,2284514473,2284514483,2284514486,2284514490,2284514491,2284514502,2284514504,2284514510,2284514514,2284514516,2284514519,2284514526,2284514541,2284514553,2284514567,2284514572,2284514588,2284514619,2284514650,2284514674,2284514695,2284514696,2284514704,2284514726,2284514776,2284514797,2284514821,2284514843,2284514848,2284514855,2284514866,2284514870,2284514928,2284514952,2284514957,2284515046,2284515067,2284515085,2284515110,2284515 111,2284515114,2284515115,2284515164,2284515181,2284515184,2284515187,2284515189,2284515195,2284515197,2284515205,2284515218,2284515251,2284515252,2284515255,2284515257,2284515258,2284515259,2284515262,2284515266,2284515286,2284515301,2284515305,2284515310,2284515311,2284515343,2284515357,2284515358,2284515365,2284515387,2284515448,2284515456,2284515458,2284515471,2284515475,2284515478,2284515500,2284515514,2284515515,2284515525,2284515546,2284515555,2284515557,2284515576,2284515583,2284515631,2284515639,2284515660,2284515669,2284515688,2284515723,2284515727,2284515737,2284515745,2284515803,2284515817,2284515822,2284515836,2284515884,2284515886,2284515893,2284515897,2284515935,2284515951,2284515962,2284515974,2284515981,2284515992,2284515993,2284515994,2284516000,2284516006,2284516007,2284516025,2284516029,2284516041,2284516045,2284516049,2284516052,2284516053,2284516081,2284516084,2284516086,2284516096,2284516118,2284516121,2284516122,2284516147,2284516172,2284516230,2284516257,228 4516291,2284516293,2284516318,2284516358,2284516364,2284516374,2284516380,2284516414,2284516418,2284516453,2284516464,2284516483,2284516489,2284516494,2284516538,2284516555,2284516602,2284516630,2284516635,2284516644,2284516657,2284516660,2284516682,2284516703,2284516743,2284516749,2284516755,2284516793,2284516797,2284516808,2284516815,2284516816,2284516844,2284516875,2284516884,2284516895,2284516896,2284516904,2284516906,2284516907,2284516923,2284516946,2284516960,2284516966,2284516979,2284516983,2284516989,2284517025,2284517064,2284517080,2284517093,2284517114,2284517124,2284517134,2284517145,2284517172,2284517181,2284517189,2284517201,2284517218,2284517242,2284517255,2284517267,2284517269,2284517277,2284517288,2284517334,2284517338,2284517343,2284517357,2284517386,2284517404,2284517411,2284517413,2284517421,2284517488,2284517500,2284517524,2284517531,2284517546,2284517565,2284517599,2284517604,2284517618,2284517619,2284517625,2284517631,2284517642,2284517652,2284517668,2284517695 ,2284517713,2284517716,2284517747,2284517753,2284517794,2284517800,2284517816,2284517846,2284517849,2284517854,2284517860,2284517893,2284517901,2284517904,2284517905,2284517912,2284517923,2284517941,2284517963,2284518006,2284518009,2284518016,2284518023,2284518052,2284518060,2284518129,2284518132,2284518145,2284518153,2284518165,2284518185,2284518205,2284518233,2284518234,2284518241,2284518255,2284518261,2284518266,2284518299,2284518311,2284518315,2284518317,2284518326,2284518334,2284518349,2284518351,2284518355,2284518395,2284518396,2284518397,2284518409,2284518416,2284518417,2284518418,2284518420,2284518421,2284518424,2284518429,2284518435,2284518442,2284518447,2284518453,2284518458,2284518459,2284518484,2284518487,2284518492,2284518503,2284518513,2284518514,2284518523,2284518527,2284518533,2284518559,2284518565,2284518575,2284518579,2284518580,2284518585,2284518607,2284518617,2284518620,2284518622,2284518634,2284518637,2284518639,2284518656,2284518657,2284518667,2284518674,228451 8695,2284518697,2284518747,2284518755,2284518765,2284518772,2284518776,2284518793,2284518829,2284518835,2284518840,2284518905,2284518927,2284518930,2284518949,2284518955,2284518959,2284518967) 0.000 27283143 user_all 127.0.0.1:50330 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287464275) 0.000 27283144 user_all 127.0.0.1:50346 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465279) 0.000 27283145 user_all 127.0.0.1:50350 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279372455) 0.000 27283146 user_all 127.0.0.1:50352 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465177) 0.000 27283147 user_all 127.0.0.1:50356 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465262) 0.000 27283148 user_all 127.0.0.1:50368 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2276985539) 0.000 27283149 user_all 127.0.0.1:50370 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2276314092) 0.000 27283150 user_all 127.0.0.1:50382 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2167375126) 0.000 27283151 user_all 127.0.0.1:50394 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465258) 0.000 27283152 user_all 127.0.0.1:50398 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465225) 0.000 27283153 user_all 127.0.0.1:50402 user_jobs2 Query 734 Statistics SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465173) 0.000 27283154 user_all 127.0.0.1:50418 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2278484329) 0.000 27283155 user_all 127.0.0.1:50426 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282507279) 0.000 27283157 user_all 127.0.0.1:50430 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2264728877) 0.000 27283159 user_all 127.0.0.1:50438 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2236199668) 0.000 27283160 user_all 127.0.0.1:50450 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2277072492) 0.000 27283161 user_all 127.0.0.1:50456 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281861948) 0.000 27283162 user_all 127.0.0.1:50472 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284544530) 0.000 27283163 user_all 127.0.0.1:50484 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2276195837) 0.000 27283164 user_all 127.0.0.1:50496 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2227440573) 0.000 27283165 user_all 127.0.0.1:50510 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2219922209) 0.000 27283166 user_all 127.0.0.1:50514 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE title,id FROM jobs WHERE id IN (2243027241,2243027058,2243019129,2230254888,2222187534,2221964678,2217089000,2216921900,2212272159,2212283346) 0.000 27283167 user_all 127.0.0.1:50518 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2259198719) 0.000 27283168 user_all 127.0.0.1:50526 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282289775) 0.000 27283171 user_all 127.0.0.1:50542 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2261882878) 0.000 27283173 user_all 127.0.0.1:50558 user_jobs2 Query 734 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2262634133) 0.000 27283174 user_all 127.0.0.1:45212 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273745108) 0.000 27283176 user_all 127.0.0.1:45222 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465336) 0.000 27283177 user_all 127.0.0.1:45224 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280515386) 0.000 27283180 user_all 127.0.0.1:45240 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2130415210) 0.000 27283181 user_all 127.0.0.1:45250 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465428) 0.000 27283183 user_all 127.0.0.1:45254 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465411) 0.000 27283185 user_all 127.0.0.1:45262 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286934488) 0.000 27283186 user_all 127.0.0.1:45274 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2191804772) 0.000 27283187 user_all 127.0.0.1:45278 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2217628159) 0.000 27283189 user_all 127.0.0.1:45284 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465385) 0.000 27283191 user_all 127.0.0.1:45292 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465360) 0.000 27283193 user_all 127.0.0.1:45306 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2262544292) 0.000 27283194 user_all 127.0.0.1:45312 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269456589) 0.000 27283195 user_all 127.0.0.1:45326 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273543744) 0.000 27283196 user_all 127.0.0.1:45340 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281875745) 0.000 27283197 user_all 127.0.0.1:45352 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (1587853045) 0.000 27283198 user_all 127.0.0.1:45368 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280452764) 0.000 27283199 user_all 127.0.0.1:45376 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286666802) 0.000 27283200 user_all 127.0.0.1:45390 user_jobs2 Query 733 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465362) 0.000 27283201 user_all 127.0.0.1:45398 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286779223) 0.000 27283202 user_all 127.0.0.1:45404 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269150464) 0.000 27283203 user_all 127.0.0.1:45406 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465216) 0.000 27283205 user_all 127.0.0.1:45412 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2267351030) 0.000 27283207 user_all 127.0.0.1:45426 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2154986893) 0.000 27283208 user_all 127.0.0.1:45434 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282276640) 0.000 27283211 user_all 127.0.0.1:45438 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2277057411) 0.000 27283212 user_all 127.0.0.1:45454 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284292793) 0.000 27283214 user_all 127.0.0.1:45466 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465677) 0.000 27283216 user_all 127.0.0.1:45490 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2253714460) 0.000 27283217 user_all 127.0.0.1:45496 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465439) 0.000 27283219 user_all 127.0.0.1:45512 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281745695) 0.000 27283220 user_all 127.0.0.1:45524 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286264523) 0.000 27283224 user_all 127.0.0.1:45562 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273353416) 0.000 27283225 user_all 127.0.0.1:45568 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465443) 0.000 27283226 user_all 127.0.0.1:45580 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280377825) 0.000 27283227 user_all 127.0.0.1:45592 user_jobs2 Query 732 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282199093) 0.000 27283229 user_all 127.0.0.1:45608 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465664) 0.000 27283230 user_all 127.0.0.1:45612 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2242175288) 0.000 27283234 user_all 127.0.0.1:45626 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282047982) 0.000 27283238 user_all 127.0.0.1:45634 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286910857) 0.000 27283252 user_all 127.0.0.1:45682 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281666979) 0.000 27283240 user_all 127.0.0.1:45660 user_jobs2 Query 731 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272428567) 0.000 27283262 user_all 127.0.0.1:45692 user_jobs2 Query 730 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273195581) 0.000 27283267 user_all 127.0.0.1:45708 user_jobs2 Query 729 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2278098630) 0.000 27283292 user_all 127.0.0.1:45762 user_jobs2 Query 726 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465772) 0.000 27283401 user_all 10.10.10.5:49008 user_jobs2 Query 721 Opening tables DELETE jfr FROM jobs_for_recaching jfr JOIN jobs j ON jfr.job_id = j.id WHERE j.is_suspended = 1 0.000 27283410 user_all 10.10.10.1:35344 user_jobs2 Query 721 Opening tables SELECT SQL_NO_CACHE jobs.id,jobs.title,jobs.employer_id,jobs.email,jobs.city_id,jobs.state_id,jobs.country_id,jobs.original_job_category_id,jobs.is_online,jobs.posting_app_language_id,jobs.original_creation_date FROM jobs WHERE expiry_date <= '2023-01-27' AND jobs.xml_id = '' ORDER BY jobs.id DESC LIMIT 500 0.000 27283415 user_all 10.10.10.1:35372 user_jobs2 Query 721 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2270698605) 0.000 27283420 user_all 10.10.10.1:35396 user_jobs2 Query 721 Opening tables SELECT jobs.id,jobs.skills,jobs.benefits,jobs.employer_id,jobs.description_compressed FROM jobs WHERE jobs.xml_id = '' AND modification_timestamp >= '2023-04-27 03:45:02' ORDER BY jobs.modification_timestamp DESC 0.000 27283427 user_all 10.10.10.7:51082 user_jobs2 Query 721 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2280349543) 0.000 27283460 user_all 127.0.0.1:64186 user_jobs2 Query 721 Opening tables SELECT SQL_NO_CACHE title,id FROM jobs WHERE id IN (1526313581) 0.000 27283486 user_all 10.10.10.1:35502 user_jobs2 Query 719 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2281760829,2282038447,2283276172,2231182154,2283276570,2267945424,2283250329,2286838367,2286792076,2282085598,2285045505) 0.000 27283547 user_all 127.0.0.1:31598 user_jobs2 Query 712 Opening tables SELECT SQL_NO_CACHE website,city_id,state_id,country_id,original_job_category_id,is_online,employer_id,applicant_filter_id FROM jobs WHERE id IN (2286792076) 0.000 27283853 user_all 127.0.0.1:53644 user_jobs2 Query 678 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2202545729) 0.000 27283856 user_all 127.0.0.1:53658 user_jobs2 Query 678 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285045505) 0.000 27283882 user_all 127.0.0.1:53722 user_jobs2 Query 676 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2235668119) 0.000 27283937 user_all 127.0.0.1:46686 user_jobs2 Query 669 Opening tables SELECT jobs.id,jobs.title,jobs.applicant_filter_id FROM jobs WHERE jobs.employer_id = 240954 ORDER BY jobs.modification_timestamp DESC LIMIT 1 0.000 27283939 user_all 127.0.0.1:46708 user_jobs2 Query 668 Opening tables INSERT IGNORE INTO jobs_for_reindexing (job_id) SELECT id FROM jobs WHERE employer_id = 240954 0.000 27284057 user_all 10.10.10.5:51668 user_jobs2 Query 661 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282080274,2278280769,2249842124,2285045505,2271209059,2273854281,2254905611) 0.000 27284153 user_all 127.0.0.1:57518 user_jobs2 Query 654 Opening tables SELECT SQL_NO_CACHE website,city_id,state_id,country_id,original_job_category_id,is_online,employer_id,applicant_filter_id FROM jobs WHERE id IN (2286792076) 0.000 27284310 user_all 127.0.0.1:39924 user_jobs2 Query 643 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285973743) 0.000 27284493 user_all 127.0.0.1:39704 user_jobs2 Query 628 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283632782) 0.000 27284500 user_all 127.0.0.1:39740 user_jobs2 Query 626 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281265317) 0.000 27284510 user_all 127.0.0.1:39766 user_jobs2 Query 626 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2208702076) 0.000 27284521 user_all 127.0.0.1:39790 user_jobs2 Query 624 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2243045948) 0.000 27284525 user_all 127.0.0.1:39808 user_jobs2 Query 624 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2265308714) 0.000 27284542 user_all 127.0.0.1:55562 user_jobs2 Query 622 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285045505) 0.000 27284550 user_all 127.0.0.1:55590 user_jobs2 Query 621 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280478860) 0.000 27284549 user_all 127.0.0.1:55578 user_jobs2 Query 621 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2266712545) 0.000 27284551 user_all 127.0.0.1:55598 user_jobs2 Query 621 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269200327) 0.000 27284553 user_all 127.0.0.1:55614 user_jobs2 Query 621 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282656713) 0.000 27284556 user_all 127.0.0.1:55630 user_jobs2 Query 621 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280295841) 0.000 27284563 user_all 127.0.0.1:55632 user_jobs2 Query 620 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280445173) 0.000 27284568 user_all 127.0.0.1:55662 user_jobs2 Query 619 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271064798) 0.000 27284572 user_all 127.0.0.1:55676 user_jobs2 Query 619 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283180579) 0.000 27284579 user_all 127.0.0.1:55700 user_jobs2 Query 619 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282072316) 0.000 27284581 user_all 127.0.0.1:55710 user_jobs2 Query 619 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2138361443) 0.000 27284586 user_all 127.0.0.1:55742 user_jobs2 Query 618 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2275541142) 0.000 27284585 user_all 127.0.0.1:55730 user_jobs2 Query 618 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284296229) 0.000 27284591 user_all 127.0.0.1:55758 user_jobs2 Query 618 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2041445269) 0.000 27284594 user_all 127.0.0.1:55778 user_jobs2 Query 617 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280360408) 0.000 27284603 user_all 127.0.0.1:55814 user_jobs2 Query 617 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2234315818) 0.000 27284604 user_all 127.0.0.1:55816 user_jobs2 Query 617 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285195633) 0.000 27284599 user_all 127.0.0.1:55796 user_jobs2 Query 617 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283262941) 0.000 27284608 user_all 127.0.0.1:55828 user_jobs2 Query 616 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271491300) 0.000 27284606 user_all 127.0.0.1:55818 user_jobs2 Query 616 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2274220149) 0.000 27284618 user_all 127.0.0.1:55844 user_jobs2 Query 616 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2268823505) 0.000 27284619 user_all 127.0.0.1:55858 user_jobs2 Query 616 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283574483) 0.000 27284623 user_all 127.0.0.1:55876 user_jobs2 Query 615 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465171) 0.000 27284624 user_all 127.0.0.1:55878 user_jobs2 Query 615 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (1861487338) 0.000 27284625 user_all 127.0.0.1:55880 user_jobs2 Query 615 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2182191855) 0.000 27284628 user_all 127.0.0.1:55888 user_jobs2 Query 615 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465681) 0.000 27284632 user_all 127.0.0.1:55910 user_jobs2 Query 615 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465347) 0.000 27284635 user_all 127.0.0.1:55926 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2245047492) 0.000 27284631 user_all 127.0.0.1:55904 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269366729) 0.000 27284644 user_all 127.0.0.1:55992 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2276374101) 0.000 27284642 user_all 127.0.0.1:55980 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279683857) 0.000 27284646 user_all 127.0.0.1:55998 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283358455) 0.000 27284647 user_all 127.0.0.1:56014 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2246616436) 0.000 27284639 user_all 127.0.0.1:55956 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2157545726) 0.000 27284638 user_all 127.0.0.1:55954 user_jobs2 Query 614 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2222976946) 0.000 27284653 user_all 127.0.0.1:56026 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2266169368) 0.000 27284655 user_all 127.0.0.1:27472 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280566664) 0.000 27284650 user_all 127.0.0.1:56024 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280298847) 0.000 27284656 user_all 127.0.0.1:27482 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2232999900) 0.000 27284654 user_all 127.0.0.1:27468 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285376356) 0.000 27284657 user_all 127.0.0.1:27488 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282026872) 0.000 27284663 user_all 127.0.0.1:27500 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280308100) 0.000 27284666 user_all 127.0.0.1:27520 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269242040) 0.000 27284659 user_all 127.0.0.1:27494 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465710) 0.000 27284665 user_all 127.0.0.1:27510 user_jobs2 Query 613 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2254395841) 0.000 27284671 user_all 127.0.0.1:27540 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269729448) 0.000 27284672 user_all 127.0.0.1:27552 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284908714) 0.000 27284673 user_all 127.0.0.1:27558 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283141500) 0.000 27284669 user_all 127.0.0.1:27538 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2252966510) 0.000 27284674 user_all 127.0.0.1:27560 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2223773539) 0.000 27284675 user_all 127.0.0.1:27574 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284414214) 0.000 27284678 user_all 127.0.0.1:27582 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280710955) 0.000 27284679 user_all 127.0.0.1:27596 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2277534778) 0.000 27284684 user_all 127.0.0.1:27636 user_jobs2 Query 612 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280563686) 0.000 27284680 user_all 127.0.0.1:27612 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280515567) 0.000 27284689 user_all 127.0.0.1:27656 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286710219) 0.000 27284691 user_all 127.0.0.1:27672 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269578321) 0.000 27284693 user_all 127.0.0.1:27688 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280236949) 0.000 27284692 user_all 127.0.0.1:27682 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281673715) 0.000 27284690 user_all 127.0.0.1:27668 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269545956) 0.000 27284696 user_all 127.0.0.1:27698 user_jobs2 Query 611 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269460100) 0.000 27284697 user_all 127.0.0.1:27706 user_jobs2 Query 610 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286651090) 0.000 27284708 user_all 127.0.0.1:27732 user_jobs2 Query 609 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465712) 0.000 27284816 user_all 10.10.10.1:42660 user_jobs2 Query 601 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2282080274) 0.000 27284808 user_all 10.10.10.5:45618 user_jobs2 Query 601 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2285045505) 0.000 27284871 user_all 127.0.0.1:59752 user_jobs2 Query 600 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283276172) 0.000 27284912 user_all 127.0.0.1:60028 user_jobs2 Query 599 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2283571664,2185854643) 0.000 27284935 user_all 127.0.0.1:60076 user_jobs2 Query 597 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285394811) 0.000 27285171 user_all 127.0.0.1:42164 user_jobs2 Query 569 Opening tables SELECT COUNT(*) FROM jobs WHERE jobs.posting_app_language_id = 1 AND jobs.is_suspended = 0 AND expiry_date >= '2023-04-28' AND jobs.domain_id = 1 AND (jobs.city_id = 10967) AND (display_status <> 2) 0.000 27285273 user_all 127.0.0.1:27062 user_jobs2 Query 556 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283236263) 0.000 27285459 user_all 10.10.10.1:56852 user_jobs2 Query 540 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2260843605,2280983178,2136281361) 0.000 27285522 user_all 127.0.0.1:56772 user_jobs2 Query 539 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2232340899) 0.000 27285563 user_all 127.0.0.1:56846 user_jobs2 Query 535 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283240779) 0.000 27285682 user_all 127.0.0.1:44600 user_jobs2 Query 520 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284302704) 0.000 27285697 user_all 127.0.0.1:44674 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282323815) 0.000 27285691 user_all 127.0.0.1:44644 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286580018) 0.000 27285692 user_all 127.0.0.1:44660 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286280519) 0.000 27285695 user_all 127.0.0.1:44664 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2267479614) 0.000 27285693 user_all 127.0.0.1:44662 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280316142) 0.000 27285698 user_all 127.0.0.1:44680 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282088173) 0.000 27285700 user_all 127.0.0.1:44688 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2265397805) 0.000 27285704 user_all 127.0.0.1:44714 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2230625220) 0.000 27285708 user_all 127.0.0.1:44728 user_jobs2 Query 519 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285025804) 0.000 27285703 user_all 127.0.0.1:44704 user_jobs2 Query 518 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280538670) 0.000 27285712 user_all 127.0.0.1:44748 user_jobs2 Query 518 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2172894929) 0.000 27285715 user_all 127.0.0.1:44752 user_jobs2 Query 518 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271515840) 0.000 27285725 user_all 127.0.0.1:44766 user_jobs2 Query 517 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284767219) 0.000 27285726 user_all 127.0.0.1:44774 user_jobs2 Query 517 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2261841468) 0.000 27285732 user_all 127.0.0.1:44800 user_jobs2 Query 517 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286362062) 0.000 27285737 user_all 127.0.0.1:44838 user_jobs2 Query 517 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280377825) 0.000 27285736 user_all 127.0.0.1:44822 user_jobs2 Query 517 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2247649374) 0.000 27285743 user_all 127.0.0.1:44870 user_jobs2 Query 516 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283276217) 0.000 27285750 user_all 127.0.0.1:44908 user_jobs2 Query 516 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285126910) 0.000 27285749 user_all 127.0.0.1:44898 user_jobs2 Query 516 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280550310) 0.000 27285748 user_all 127.0.0.1:44890 user_jobs2 Query 516 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281854082) 0.000 27285756 user_all 127.0.0.1:44956 user_jobs2 Query 515 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285425321) 0.000 27285757 user_all 127.0.0.1:44972 user_jobs2 Query 515 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2119294465) 0.000 27285762 user_all 127.0.0.1:44994 user_jobs2 Query 515 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280765825) 0.000 27285755 user_all 127.0.0.1:44940 user_jobs2 Query 515 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280565272) 0.000 27285761 user_all 127.0.0.1:44988 user_jobs2 Query 515 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272867502) 0.000 27285768 user_all 127.0.0.1:45028 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2172624051) 0.000 27285763 user_all 127.0.0.1:44998 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286785885) 0.000 27285766 user_all 127.0.0.1:45012 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280297911) 0.000 27285774 user_all 127.0.0.1:45044 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272625751) 0.000 27285769 user_all 127.0.0.1:45036 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2242175288) 0.000 27285775 user_all 127.0.0.1:45058 user_jobs2 Query 514 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279311677) 0.000 27285782 user_all 127.0.0.1:57504 user_jobs2 Query 513 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2270251761) 0.000 27285777 user_all 127.0.0.1:45070 user_jobs2 Query 513 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280598925) 0.000 27285784 user_all 127.0.0.1:57516 user_jobs2 Query 513 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280424221) 0.000 27285781 user_all 127.0.0.1:57494 user_jobs2 Query 513 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2274216413) 0.000 27285783 user_all 127.0.0.1:57510 user_jobs2 Query 513 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286792471) 0.000 27285796 user_all 127.0.0.1:57550 user_jobs2 Query 512 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2247364569) 0.000 27285800 user_all 127.0.0.1:57560 user_jobs2 Query 511 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280348487) 0.000 27285804 user_all 127.0.0.1:57568 user_jobs2 Query 511 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279921678) 0.000 27285811 user_all 127.0.0.1:57578 user_jobs2 Query 511 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280452313) 0.000 27285821 user_all 127.0.0.1:57594 user_jobs2 Query 509 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2208702076) 0.000 27285826 user_all 127.0.0.1:57628 user_jobs2 Query 509 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2264559301) 0.000 27285831 user_all 127.0.0.1:57638 user_jobs2 Query 509 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286050776) 0.000 27285835 user_all 127.0.0.1:57640 user_jobs2 Query 509 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2278308688) 0.000 27285848 user_all 127.0.0.1:57682 user_jobs2 Query 507 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280302136) 0.000 27285857 user_all 127.0.0.1:57694 user_jobs2 Query 507 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279930824) 0.000 27285863 user_all 127.0.0.1:57718 user_jobs2 Query 506 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286776138) 0.000 27285865 user_all 127.0.0.1:57724 user_jobs2 Query 506 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280421498) 0.000 27285868 user_all 127.0.0.1:57740 user_jobs2 Query 505 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280488651) 0.000 27285869 user_all 127.0.0.1:57750 user_jobs2 Query 505 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287472138) 0.000 27285877 user_all 127.0.0.1:57768 user_jobs2 Query 505 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280313018) 0.000 27285882 user_all 127.0.0.1:57792 user_jobs2 Query 504 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281197564) 0.000 27285889 user_all 127.0.0.1:57822 user_jobs2 Query 504 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286048402) 0.000 27285884 user_all 127.0.0.1:57808 user_jobs2 Query 504 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272973614) 0.000 27285891 user_all 127.0.0.1:57850 user_jobs2 Query 503 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281142046) 0.000 27285895 user_all 127.0.0.1:53698 user_jobs2 Query 503 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287464943) 0.000 27285896 user_all 127.0.0.1:53708 user_jobs2 Query 503 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2278184742) 0.000 27285897 user_all 127.0.0.1:53724 user_jobs2 Query 503 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2269200327) 0.000 27285908 user_all 127.0.0.1:53746 user_jobs2 Query 502 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2104561225) 0.000 27285911 user_all 127.0.0.1:53766 user_jobs2 Query 501 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2232307027) 0.000 27285921 user_all 127.0.0.1:53794 user_jobs2 Query 501 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2268379265) 0.000 27285917 user_all 127.0.0.1:53786 user_jobs2 Query 500 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284494205) 0.000 27285933 user_all 127.0.0.1:53846 user_jobs2 Query 500 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2264255202) 0.000 27285936 user_all 127.0.0.1:53862 user_jobs2 Query 500 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283266534) 0.000 27285931 user_all 127.0.0.1:53832 user_jobs2 Query 500 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465841) 0.000 27285941 user_all 127.0.0.1:53878 user_jobs2 Query 499 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2277295205) 0.000 27285953 user_all 127.0.0.1:53910 user_jobs2 Query 499 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465873) 0.000 27285954 user_all 127.0.0.1:53926 user_jobs2 Query 498 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280305080) 0.000 27286143 user_all 10.10.10.1:56062 user_jobs2 Query 481 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2262180406) 0.000 27286131 user_all 10.10.10.5:65348 user_jobs2 Query 481 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2260843605) 0.000 27286209 user_all 10.10.10.5:65426 user_jobs2 Query 479 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282088173,2277083601,2124577413,2272259753,2262180406,2285391222,2283578385,2280983178,2286792916) 0.000 27286415 user_all 127.0.0.1:43148 user_jobs2 Query 455 Opening tables SELECT SQL_NO_CACHE title,id FROM jobs WHERE id IN (2287577338,2287577421,2287640795,2287604996,2287640798,2287640803,2287578836,2287640814,2287640815,2287640819) 0.000 27286528 user_all 127.0.0.1:49254 user_jobs2 Query 442 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2237259558) 0.000 27286547 user_all 127.0.0.1:49298 user_jobs2 Query 441 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2237259558) 0.000 27286553 user_all 127.0.0.1:49316 user_jobs2 Query 440 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2237259558) 0.000 27286773 user_all 10.10.10.5:29790 user_jobs2 Query 421 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2286794243,2281853787,2285391222,2286790002,2283866960) 0.000 27286851 user_all 127.0.0.1:38278 user_jobs2 Query 416 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272713990) 0.000 27286854 user_all 127.0.0.1:38290 user_jobs2 Query 416 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271205535) 0.000 27286860 user_all 127.0.0.1:38302 user_jobs2 Query 415 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465923) 0.000 27286863 user_all 127.0.0.1:38326 user_jobs2 Query 415 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2055810694) 0.000 27286862 user_all 127.0.0.1:38312 user_jobs2 Query 415 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287167351) 0.000 27286867 user_all 127.0.0.1:38334 user_jobs2 Query 415 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465747) 0.000 27286868 user_all 127.0.0.1:38348 user_jobs2 Query 414 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282314709) 0.000 27286875 user_all 127.0.0.1:38354 user_jobs2 Query 414 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283245366) 0.000 27286876 user_all 127.0.0.1:38356 user_jobs2 Query 413 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285017142) 0.000 27286894 user_all 127.0.0.1:47684 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2163472284) 0.000 27286893 user_all 127.0.0.1:47668 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2237997412) 0.000 27286890 user_all 127.0.0.1:47652 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2236250438) 0.000 27286897 user_all 127.0.0.1:47692 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280483626) 0.000 27286892 user_all 127.0.0.1:47664 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2277157922) 0.000 27286902 user_all 127.0.0.1:47700 user_jobs2 Query 412 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280505391) 0.000 27286906 user_all 127.0.0.1:47702 user_jobs2 Query 411 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280523747) 0.000 27286916 user_all 10.10.10.1:35446 user_jobs2 Sleep 410 NULL 0.000 27286918 user_all 127.0.0.1:47746 user_jobs2 Query 410 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280525724) 0.000 27286911 user_all 127.0.0.1:47718 user_jobs2 Query 410 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280543659) 0.000 27286924 user_all 127.0.0.1:47764 user_jobs2 Query 410 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2270807419) 0.000 27286930 user_all 127.0.0.1:47792 user_jobs2 Query 409 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284604457) 0.000 27286940 user_all 127.0.0.1:47826 user_jobs2 Query 408 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285977949) 0.000 27286947 user_all 127.0.0.1:47866 user_jobs2 Query 408 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272752955) 0.000 27286960 user_all 127.0.0.1:47912 user_jobs2 Query 407 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280306253) 0.000 27286958 user_all 127.0.0.1:47886 user_jobs2 Query 407 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2009538143) 0.000 27286966 user_all 127.0.0.1:47972 user_jobs2 Query 407 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283830795) 0.000 27286967 user_all 127.0.0.1:47980 user_jobs2 Query 406 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2281760829,2282038447,2283276172,2231182154,2283276570,2267945424,2283250329,2286838367,2286792076,2282085598,2285045505) 0.000 27286980 user_all 127.0.0.1:48046 user_jobs2 Query 406 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280335072) 0.000 27286977 user_all 127.0.0.1:48034 user_jobs2 Query 406 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465435) 0.000 27286981 user_all 127.0.0.1:48048 user_jobs2 Query 405 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285285799) 0.000 27286995 user_all 127.0.0.1:48068 user_jobs2 Query 405 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280578703) 0.000 27286992 user_all 127.0.0.1:48062 user_jobs2 Query 405 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280446163) 0.000 27286997 user_all 127.0.0.1:48090 user_jobs2 Query 404 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286190214) 0.000 27286996 user_all 127.0.0.1:48080 user_jobs2 Query 404 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280067745) 0.000 27287001 user_all 127.0.0.1:48104 user_jobs2 Query 404 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (88083) 0.000 27286993 user_all 127.0.0.1:48064 user_jobs2 Query 401 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280574748) 0.000 27287006 user_all 127.0.0.1:48118 user_jobs2 Query 403 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280560092) 0.000 27287012 user_all 127.0.0.1:28552 user_jobs2 Query 403 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465924) 0.000 27287011 user_all 127.0.0.1:28546 user_jobs2 Query 403 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280340725) 0.000 27287013 user_all 127.0.0.1:28558 user_jobs2 Query 403 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281195238) 0.000 27287014 user_all 127.0.0.1:28572 user_jobs2 Query 403 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282030938) 0.000 27287017 user_all 127.0.0.1:28598 user_jobs2 Query 402 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280549883) 0.000 27287019 user_all 127.0.0.1:28612 user_jobs2 Query 402 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2177054319) 0.000 27287028 user_all 127.0.0.1:28656 user_jobs2 Query 401 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286037021) 0.000 27287029 user_all 127.0.0.1:28660 user_jobs2 Query 401 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281346593) 0.000 27287037 user_all 127.0.0.1:28678 user_jobs2 Query 400 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280919446) 0.000 27287040 user_all 127.0.0.1:28716 user_jobs2 Query 400 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280508304) 0.000 27287042 user_all 127.0.0.1:28726 user_jobs2 Query 400 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280447729) 0.000 27287038 user_all 127.0.0.1:28694 user_jobs2 Query 400 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280501971) 0.000 27287053 user_all 127.0.0.1:28744 user_jobs2 Query 399 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280508040) 0.000 27287059 user_all 127.0.0.1:28762 user_jobs2 Query 398 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283957077) 0.000 27287064 user_all 127.0.0.1:28776 user_jobs2 Query 397 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284828324) 0.000 27287068 user_all 127.0.0.1:28778 user_jobs2 Query 397 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2278948276) 0.000 27287071 user_all 127.0.0.1:28802 user_jobs2 Query 397 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2237259558) 0.000 27287047 user_all 127.0.0.1:28742 user_jobs2 Query 383 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2240339960) 0.000 27287080 user_all 127.0.0.1:28844 user_jobs2 Query 396 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271172813) 0.000 27287077 user_all 127.0.0.1:28832 user_jobs2 Query 396 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280527697) 0.000 27287082 user_all 127.0.0.1:28854 user_jobs2 Query 396 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2226664344) 0.000 27287085 user_all 127.0.0.1:28868 user_jobs2 Query 395 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287464291) 0.000 27287092 user_all 127.0.0.1:28930 user_jobs2 Query 395 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280323512) 0.000 27287089 user_all 127.0.0.1:28926 user_jobs2 Query 395 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2283884670) 0.000 27287100 user_all 127.0.0.1:28980 user_jobs2 Query 395 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2267105214) 0.000 27287105 user_all 127.0.0.1:28990 user_jobs2 Query 394 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280365271) 0.000 27287115 user_all 127.0.0.1:26814 user_jobs2 Query 393 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285930659) 0.000 27287119 user_all 127.0.0.1:26816 user_jobs2 Query 393 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280354193) 0.000 27287123 user_all 127.0.0.1:26820 user_jobs2 Query 393 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465859) 0.000 27287125 user_all 127.0.0.1:26828 user_jobs2 Query 392 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286900494) 0.000 27287128 user_all 127.0.0.1:26840 user_jobs2 Query 392 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2268733426) 0.000 27287131 user_all 127.0.0.1:26850 user_jobs2 Query 392 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280359500) 0.000 27287129 user_all 127.0.0.1:26846 user_jobs2 Query 392 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279371083) 0.000 27287139 user_all 127.0.0.1:26878 user_jobs2 Query 391 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465332) 0.000 27287132 user_all 127.0.0.1:26856 user_jobs2 Query 391 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2116204300) 0.000 27287133 user_all 127.0.0.1:26858 user_jobs2 Query 391 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280512893) 0.000 27287138 user_all 127.0.0.1:26868 user_jobs2 Query 391 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2272983882) 0.000 27287144 user_all 127.0.0.1:26898 user_jobs2 Query 391 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280312685) 0.000 27287146 user_all 127.0.0.1:26930 user_jobs2 Query 390 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280332751) 0.000 27287251 user_all 10.10.10.1:33878 user_schools2 Sleep 6 NULL 0.000 27287346 user_all 10.10.10.1:54040 user_jobs2 Query 366 Opening tables INSERT IGNORE INTO jobs_for_reindexing (job_id) SELECT id FROM jobs WHERE employer_id = 240954 0.000 27287424 user_all 10.10.10.5:54684 user_jobs2 Query 361 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2286794243) 0.000 27287457 user_all 10.10.10.1:41458 user_jobs2 Query 360 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2285391222) 0.000 27287498 user_all 10.10.10.1:41544 user_jobs2 Query 359 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282536916,2282536930,2282536948,2282537031,2282537024,2282536996,2282536971,2285621506,2282536917,2282536980,2282536914,2282536937,2282536955,2282537022,2282537012,2282536991,2287568271,2280318164,2285614499,2282323745,2283262704) 0.000 27287522 user_all 10.10.10.11:46672 user_jobs2 Query 358 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282080274,2278280769,2249842124,2285045505,2271209059,2273854281,2254905611) 0.000 27287539 user_all 127.0.0.1:31002 user_jobs2 Query 355 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2263072188) 0.000 27287635 user_all 10.10.10.1:63158 user_phpbt Sleep 3 NULL 0.000 27287807 user_all 127.0.0.1:34414 user_jobs2 Query 324 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2213942669) 0.000 27287872 user_all 10.10.10.1:48452 user_jobs2 Query 316 Opening tables SELECT SQL_NO_CACHE display_status,title,skills,employer_id,is_suspended,applicant_filter_id,description_compressed FROM jobs WHERE id IN (2262522095) 0.000 27287921 user_all 127.0.0.1:50604 user_jobs2 Query 312 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465445) 0.000 27287916 user_all 127.0.0.1:50582 user_jobs2 Query 312 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273420405) 0.000 27287920 user_all 127.0.0.1:50592 user_jobs2 Query 312 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280295229) 0.000 27287924 user_all 127.0.0.1:50626 user_jobs2 Query 311 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285342352) 0.000 27287925 user_all 127.0.0.1:50632 user_jobs2 Query 311 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280406594) 0.000 27287928 user_all 127.0.0.1:50646 user_jobs2 Query 311 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271560484) 0.000 27287927 user_all 127.0.0.1:50642 user_jobs2 Query 311 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465186) 0.000 27287933 user_all 127.0.0.1:50666 user_jobs2 Query 311 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2270198083) 0.000 27287938 user_all 127.0.0.1:50690 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280294591) 0.000 27287939 user_all 127.0.0.1:50702 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2268485617) 0.000 27287937 user_all 127.0.0.1:50680 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285574541) 0.000 27287936 user_all 127.0.0.1:50672 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2274745021) 0.000 27287940 user_all 127.0.0.1:50710 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2254519295) 0.000 27287942 user_all 127.0.0.1:50724 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285538960) 0.000 27287943 user_all 127.0.0.1:50736 user_jobs2 Query 310 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282002242) 0.000 27287944 user_all 127.0.0.1:50740 user_jobs2 Query 309 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285942771) 0.000 27287946 user_all 127.0.0.1:50756 user_jobs2 Query 309 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2255497238) 0.000 27287953 user_all 127.0.0.1:50786 user_jobs2 Query 309 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281312583) 0.000 27287951 user_all 127.0.0.1:50774 user_jobs2 Query 308 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280477684) 0.000 27287960 user_all 127.0.0.1:50798 user_jobs2 Query 308 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271358320) 0.000 27287966 user_all 127.0.0.1:50812 user_jobs2 Query 307 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285711972) 0.000 27287954 user_all 127.0.0.1:50790 user_jobs2 Query 298 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279659770) 0.000 27287971 user_all 127.0.0.1:50822 user_jobs2 Query 306 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279534849) 0.000 27287970 user_all 127.0.0.1:50818 user_jobs2 Query 306 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2275503798) 0.000 27287968 user_all 127.0.0.1:50814 user_jobs2 Query 306 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2270777352) 0.000 27287979 user_all 127.0.0.1:50840 user_jobs2 Query 306 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280343869) 0.000 27287986 user_all 127.0.0.1:50854 user_jobs2 Query 305 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465195) 0.000 27287995 user_all 127.0.0.1:50864 user_jobs2 Query 304 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280416175) 0.000 27287999 user_all 127.0.0.1:50870 user_jobs2 Query 304 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465803) 0.000 27288006 user_all 127.0.0.1:59904 user_jobs2 Query 303 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2279269333) 0.000 27288005 user_all 127.0.0.1:59902 user_jobs2 Query 303 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2274291793) 0.000 27288003 user_all 127.0.0.1:59888 user_jobs2 Query 303 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2196395623) 0.000 27288004 user_all 127.0.0.1:59890 user_jobs2 Query 303 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2287465853) 0.000 27288012 user_all 127.0.0.1:59928 user_jobs2 Query 303 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2271101263) 0.000 27288022 user_all 127.0.0.1:59988 user_jobs2 Query 302 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2286372407) 0.000 27288024 user_all 127.0.0.1:60002 user_jobs2 Query 302 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282420427) 0.000 27288028 user_all 127.0.0.1:60004 user_jobs2 Query 302 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285399890) 0.000 27288030 user_all 127.0.0.1:60006 user_jobs2 Query 302 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2273766023) 0.000 27288031 user_all 127.0.0.1:60010 user_jobs2 Query 302 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280302768) 0.000 27288117 user_all 127.0.0.1:60210 user_jobs2 Query 300 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2275390358) 0.000 27288118 user_all 127.0.0.1:60222 user_jobs2 Query 300 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2282422905) 0.000 27288134 user_all 127.0.0.1:60330 user_jobs2 Query 300 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2095503357) 0.000 27288141 user_all 127.0.0.1:60342 user_jobs2 Query 299 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280935851) 0.000 27288140 user_all 127.0.0.1:60334 user_jobs2 Query 299 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2285005795) 0.000 27288138 user_all 14.13.93.25:26620 user_jobs2 Query 299 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282323745,2285614499,2282183552,2287243132,2283263941) 0.000 27288142 user_all 127.0.0.1:60350 user_jobs2 Query 299 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2284439060) 0.000 27288147 user_all 127.0.0.1:60374 user_jobs2 Query 298 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2280556198) 0.000 27288153 user_all 127.0.0.1:60382 user_jobs2 Query 298 Opening tables SELECT SQL_NO_CACHE * FROM jobs WHERE id IN (2281704395) 0.000 27288159 user_all 10.10.10.1:51584 user_jobs2 Query 297 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2283571664,2185854643) 0.000 27288211 user_all 10.10.10.5:51606 user_schools2 Sleep 2 NULL 0.000 27288352 user_all 14.13.93.25:57910 user_jobs2 Query 274 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2285937065) 0.000 27288648 user_all 10.10.10.7:54380 user_jobs2 Query 241 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2285614499) 0.000 27288683 user_all 10.10.10.11:43116 user_jobs2 Query 241 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2282323745) 0.000 27288800 user_all 10.10.10.11:42252 user_jobs2 Query 232 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2260843605,2280983178,2136281361) 0.000 27288853 user_marko 10.10.10.11:55508 user_jobs2 Sleep 112 NULL 0.000 27289530 user_all 127.0.0.1:43234 user_jobs2 Query 167 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282088173,2277083601,2124577413,2272259753,2262180406,2285391222,2283578385,2280983178,2286792916) 0.000 27290191 user_all 10.10.10.5:29638 user_jobs2 Query 121 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2262180406) 0.000 27290198 user_all 10.10.10.1:60118 user_jobs2 Query 121 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2259810482) 0.000 27290239 user_all 10.10.10.1:60166 user_jobs2 Query 120 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (153677132,433883991,2280212928,769510620,2213325844,2286592245,2267945235) 0.000 27290275 user_all 127.0.0.1:46830 user_jobs2 Sleep 116 NULL 0.000 27290282 user_all 127.0.0.1:46846 user_jobs2 Query 116 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2286794243,2281853787,2285391222,2286790002,2283866960) 0.000 27290304 user_all 10.10.10.1:60262 user_jobs2 Query 113 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2281760829,2282038447,2283276172,2231182154,2283276570,2267945424,2283250329,2286838367,2286792076,2282085598,2285045505) 0.000 27290582 user_all 10.10.10.1:40064 user_jobs2 Query 88 Opening tables SELECT SQL_NO_CACHE website,country_id,state_id,city_id,employer_contact_method_id,is_online,original_job_category_id,applicant_filter_id,employer_id FROM jobs WHERE id IN (2136281361) 0.000 27290657 user_marko 10.10.10.11:55522 user_jobs2 Sleep 18 NULL 0.000 27290865 user_all 10.10.10.7:37082 user_jobs2 Query 62 Opening tables INSERT IGNORE INTO jobs_for_reindexing (job_id) SELECT id FROM jobs WHERE employer_id = 240954 0.000 27290973 user_all 10.10.10.7:37224 user_jobs2 Query 60 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2286592245,2273057741,2281182393,2282438985,2283276685,2287493173) 0.000 27290983 user_all 10.10.10.7:37246 user_jobs2 Query 59 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282536916,2282536930,2282536948,2282537031,2282537024,2282536996,2282536971,2285621506,2282536917,2282536980,2282536914,2282536937,2282536955,2282537022,2282537012,2282536991,2287568271,2280318164,2285614499,2282323745,2283262704) 0.000 27291011 user_all 10.10.10.1:32626 user_jobs2 Query 56 Opening tables SELECT jobs.* FROM jobs WHERE jobs.id IN (2282080274,2278280769,2249842124,2285045505,2271209059,2273854281,2254905611) 0.000 27291060 user_all 10.10.10.7:26810 user_schools2 Sleep 0 NULL 0.000 27291087 user_all 127.0.0.1:58682 user_jobs2 Sleep 48 NULL 0.000 27291109 user_all 10.10.10.7:26892 user_phpbt Sleep 1 NULL 0.000 27291091 user_all 127.0.0.1:58690 user_jobs2 Sleep 4 NULL 0.000 27291201 user_all 10.10.10.5:61936 user_jobs2 Sleep 36 NULL 0.000 27291238 user_all 127.0.0.1:39876 user_phpbt Sleep 0 NULL 0.000 27291187 user_all 127.0.0.1:46760 user_jobs2 Sleep 17 NULL 0.000 27291251 user_all 127.0.0.1:39896 user_schools2 Sleep 31 NULL 0.000 27291252 user_all 127.0.0.1:39900 user_schools2 Sleep 0 NULL 0.000 27291272 user_all 10.10.10.5:50346 user_phpbt Sleep 0 NULL 0.000 27291287 user_all 10.10.10.5:50434 user_jobs2 Sleep 28 NULL 0.000 27291300 user_all 127.0.0.1:39948 user_jobs2 Sleep 27 NULL 0.000 27291308 user_all 127.0.0.1:39964 user_jobs2 Sleep 26 NULL 0.000 27291324 user_all 10.10.10.7:64554 user_jobs2 Sleep 26 NULL 0.000 27291348 user_all 10.10.10.1:30584 user_jobs2 Sleep 24 NULL 0.000 27291370 user_all 10.10.10.5:28696 user_jobs2 Sleep 22 NULL 0.000 27291387 user_all 10.10.10.1:45984 user_jobs2 Sleep 20 NULL 0.000 27291386 user_all 10.10.10.7:59700 user_jobs2 Sleep 20 NULL 0.000 27291412 user_all 10.10.10.1:46024 user_jobs2 Sleep 18 NULL 0.000 27291414 user_all 14.13.93.25:42120 user_jobs2 Sleep 18 NULL 0.000 27291415 user_all 14.13.93.25:42128 user_jobs2 Sleep 18 NULL 0.000 27291429 user_all 14.13.93.25:42142 user_jobs2 Sleep 17 NULL 0.000 27291379 user_all 10.10.10.5:28756 user_jobs2 Sleep 0 NULL 0.000 27291494 user_all 14.13.93.25:42184 user_schools2 Sleep 1 NULL 0.000 27291497 user_all 14.13.93.25:42194 user_jobs2 Sleep 13 NULL 0.000 27291504 user_all 14.13.93.25:42208 user_phpbt Sleep 2 NULL 0.000 27291520 user_all 10.10.10.7:29506 user_jobs2 Sleep 11 NULL 0.000 27291521 user_all 10.10.10.5:60954 user_jobs2 Sleep 10 NULL 0.000 27291526 user_all 127.0.0.1:26392 user_jobs2 Sleep 9 NULL 0.000 27291475 user_all 10.10.10.5:29216 user_jobs2 Sleep 1 NULL 0.000 27291529 user_all 14.13.93.25:35342 user_jobs2 Sleep 9 NULL 0.000 27291531 user_all 127.0.0.1:26416 user_jobs2 Sleep 9 NULL 0.000 27291538 user_all 10.10.10.7:29536 user_jobs2 Sleep 8 NULL 0.000 27291535 user_all 10.10.10.5:61016 user_jobs2 Sleep 8 NULL 0.000 27291536 user_all 10.10.10.1:57556 user_jobs2 Sleep 8 NULL 0.000 27291544 user_all 10.10.10.11:31902 user_jobs2 Sleep 8 NULL 0.000 27291553 user_all 14.13.93.25:35360 user_jobs2 Sleep 7 NULL 0.000 27291549 user_all 10.10.10.5:61088 user_jobs2 Sleep 7 NULL 0.000 27291550 user_all 10.10.10.1:57558 user_jobs2 Sleep 7 NULL 0.000 27291559 user_all 10.10.10.11:31908 user_jobs2 Sleep 7 NULL 0.000 27291562 user_all 10.10.10.5:61130 user_jobs2 Sleep 6 NULL 0.000 27291569 user_all 127.0.0.1:26442 user_jobs2 Sleep 6 NULL 0.000 27291572 user_all 10.10.10.11:31910 user_jobs2 Sleep 6 NULL 0.000 27291573 user_all 10.10.10.7:29554 user_jobs2 Sleep 6 NULL 0.000 27291579 user_all 127.0.0.1:26452 user_jobs2 Sleep 5 NULL 0.000 27291587 user_all 127.0.0.1:26468 user_jobs2 Sleep 5 NULL 0.000 27291590 user_all 10.10.10.11:31930 user_jobs2 Sleep 5 NULL 0.000 27291588 user_all 10.10.10.11:31916 user_phpbt Sleep 5 NULL 0.000 27291589 user_all 10.10.10.11:31926 user_jobs2 Sleep 5 NULL 0.000 27291595 user_all 14.13.93.25:35380 user_jobs2 Sleep 1 NULL 0.000 27291598 user_all 10.10.10.7:29570 user_jobs2 Sleep 0 NULL 0.000 27291597 user_all 127.0.0.1:26480 user_jobs2 Sleep 4 NULL 0.000 27291617 user_all 14.13.93.25:35406 user_jobs2 Sleep 3 NULL 0.000 27291616 user_all 127.0.0.1:55820 user_jobs2 Sleep 3 NULL 0.000 27291615 user_all 10.10.10.7:27488 user_jobs2 Sleep 3 NULL 0.000 27291624 user_all 10.10.10.5:52044 user_jobs2 Sleep 0 NULL 0.000 27291621 user_all 127.0.0.1:55830 user_jobs2 Sleep 3 NULL 0.000 27291622 user_all 127.0.0.1:55846 user_jobs2 Sleep 2 NULL 0.000 27291635 user_all 10.10.10.1:60124 user_jobs2 Sleep 0 NULL 0.000 27291649 user_all 10.10.10.11:31968 user_jobs2 Sleep 2 NULL 0.000 27291641 user_all 127.0.0.1:55854 user_jobs2 Sleep 2 NULL 0.000 27291643 user_all 127.0.0.1:55882 user_jobs2 Sleep 2 NULL 0.000 27291653 user_all 10.10.10.7:27522 user_jobs2 Sleep 2 NULL 0.000 27291674 user_all 10.10.10.7:27550 user_cms Sleep 1 NULL 0.000 27291659 user_all 127.0.0.1:55944 user_jobs2 Sleep 1 NULL 0.000 27291678 user_all 10.10.10.7:27570 user_jobs2 Sleep 0 NULL 0.000 27291679 user_all 10.10.10.7:27576 user_jobs2 Query 1 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2286592245) 0.000 27291676 user_all 10.10.10.7:27562 user_schools2 Sleep 1 NULL 0.000 27291684 user_all 10.10.10.7:27614 user_jobs2 Sleep 0 NULL 0.000 27291686 user_all 10.10.10.7:27630 user_schools2 Sleep 0 NULL 0.000 27291687 user_all 10.10.10.7:27632 user_jobs2 Sleep 1 NULL 0.000 27291689 user_all 10.10.10.7:27652 user_jobs2 Sleep 1 NULL 0.000 27291688 user_all 10.10.10.7:27640 user_jobs2 Sleep 1 NULL 0.000 27291690 user_all 10.10.10.7:27668 user_jobs2 Sleep 1 NULL 0.000 27291683 user_all 10.10.10.7:27598 user_jobs2 Sleep 1 NULL 0.000 27291677 user_all 10.10.10.7:27568 user_jobs2 Sleep 1 NULL 0.000 27291682 user_all 10.10.10.7:27596 user_jobs2 Sleep 1 NULL 0.000 27291680 user_all 10.10.10.7:27582 user_jobs2 Sleep 1 NULL 0.000 27291681 user_all 10.10.10.7:27594 user_jobs2 Sleep 1 NULL 0.000 27291747 user_all 10.10.10.1:60348 user_jobs2 Sleep 1 NULL 0.000 27291745 user_all 10.10.10.5:52344 user_jobs2 Sleep 0 NULL 0.000 27291750 user_all 10.10.10.5:52364 user_jobs2 Sleep 1 NULL 0.000 27291751 user_all 10.10.10.5:52372 user_jobs2 Query 0 Opening tables SELECT SQL_NO_CACHE title,employer_id,country_id,state_id,city_id,cpc,cpa,description_compressed FROM jobs WHERE id IN (2286592245) 0.000 27291748 user_all 10.10.10.1:60350 user_jobs2 Sleep 1 NULL 0.000 27291696 user_all 14.13.93.25:35470 user_jobs2 Sleep 0 NULL 0.000 27291691 user_all 10.10.10.7:27680 user_jobs2 Sleep 1 NULL 0.000 27291701 user_all 127.0.0.1:55972 user_jobs2 Sleep 1 NULL 0.000 27291704 user_all 127.0.0.1:55994 user_jobs2 Sleep 1 NULL 0.000 27291708 user_all 10.10.10.5:52272 user_schools2 Sleep 1 NULL 0.000 27291705 user_all 127.0.0.1:56002 user_jobs2 Sleep 1 NULL 0.000 27291710 user_all 127.0.0.1:56030 user_jobs2 Sleep 1 NULL 0.000 27291703 user_all 127.0.0.1:55976 user_cms Sleep 1 NULL 0.000 27291744 user_all 10.10.10.1:60334 user_jobs2 Sleep 1 NULL 0.000 27291711 user_all 127.0.0.1:56034 user_schools2 Sleep 0 NULL 0.000 27291715 user_all 10.10.10.5:52282 user_schools2 Sleep 1 NULL 0.000 27291713 user_all 127.0.0.1:56040 user_jobs2 Sleep 1 NULL 0.000 27291709 user_all 127.0.0.1:56016 user_jobs2 Sleep 1 NULL 0.000 27291734 user_all 10.10.10.5:52332 user_jobs2 Sleep 1 NULL 0.000 27291722 user_all 127.0.0.1:56080 user_jobs2 Sleep 1 NULL 0.000 27291726 user_all 10.10.10.5:52312 user_jobs2 Sleep 1 NULL 0.000 27291741 user_all 10.10.10.1:60314 user_schools2 Sleep 1 NULL 0.000 27291725 user_all 10.10.10.1:60214 user_jobs2 Sleep 1 NULL 0.000 27291732 user_all 10.10.10.1:60246 user_schools2 Sleep 1 NULL 0.000 27291716 user_all 10.10.10.5:52284 user_jobs2 Sleep 1 NULL 0.000 27291737 user_all 10.10.10.1:60286 user_jobs2 Sleep 1 NULL 0.000 27291720 user_all 127.0.0.1:56062 user_jobs2 Sleep 1 NULL 0.000 27291733 user_all 10.10.10.1:60254 user_jobs2 Sleep 1 NULL 0.000 27291717 user_all 10.10.10.5:52298 user_jobs2 Sleep 1 NULL 0.000 27291724 user_all 14.13.93.25:35476 user_schools2 Sleep 0 NULL 0.000 27291736 user_all 10.10.10.1:60278 user_jobs2 Sleep 1 NULL 0.000 27291730 user_all 10.10.10.5:52324 user_jobs2 Sleep 1 NULL 0.000 27291735 user_all 10.10.10.1:60268 user_jobs2 Sleep 1 NULL 0.000 27291700 user_all 127.0.0.1:55958 user_schools2 Sleep 0 NULL 0.000 27291721 user_all 127.0.0.1:56064 user_jobs2 Sleep 1 NULL 0.000 27291739 user_all 10.10.10.1:60302 user_schools2 Sleep 0 NULL 0.000 27291719 user_all 127.0.0.1:56060 user_jobs2 Sleep 1 NULL 0.000 27291749 user_all 10.10.10.5:52352 user_jobs2 Sleep 1 NULL 0.000 27291746 user_all 10.10.10.5:52346 user_jobs2 Sleep 1 NULL 0.000 27291728 user_all 10.10.10.5:52314 user_jobs2 Sleep 1 NULL 0.000 27291712 user_all 10.10.10.5:52278 user_schools2 Sleep 1 NULL 0.000 27291702 user_all 127.0.0.1:55974 user_jobs2 Sleep 1 NULL 0.000 27291685 user_all 10.10.10.7:27624 user_jobs2 Sleep 1 NULL 0.000 27291723 user_all 10.10.10.1:60204 user_jobs2 Sleep 1 NULL 0.000 27291729 user_all 127.0.0.1:56092 user_schools2 Sleep 0 NULL 0.000 27291714 user_all 10.10.10.5:52280 user_jobs2 Sleep 1 NULL 0.000 27291738 user_all 10.10.10.1:60292 user_jobs2 Sleep 1 NULL 0.000 27291727 user_all 127.0.0.1:56086 user_jobs2 Sleep 1 NULL 0.000 27291755 user_all 14.13.93.25:35486 user_cms Sleep 0 NULL 0.000 27291753 user_all 10.10.10.1:60380 user_jobs2 Sleep 0 NULL 0.000 27291760 user_all 10.10.10.11:32070 user_jobs2 Sleep 0 NULL 0.000 27291754 user_all 10.10.10.7:27686 user_jobs2 Sleep 0 NULL 0.000 27291757 user_all 10.10.10.11:32036 user_schools2 Sleep 0 NULL 0.000 27291758 user_all 10.10.10.11:32052 user_schools2 Sleep 0 NULL 0.000 27291767 user_all 10.10.10.11:32136 user_jobs2 Sleep 0 NULL 0.000 27291770 user_all 10.10.10.11:32150 user_jobs2 Sleep 0 NULL 0.000 27291769 user_all 10.10.10.11:32140 user_jobs2 Sleep 0 NULL 0.000 27291773 user_all 10.10.10.11:32166 user_jobs2 Sleep 0 NULL 0.000 27291756 user_all 10.10.10.11:32028 user_jobs2 Sleep 0 NULL 0.000 27291771 user_all 10.10.10.11:32158 user_jobs2 Sleep 0 NULL 0.000 27291752 user_all 10.10.10.1:60364 user_jobs2 Sleep 0 NULL 0.000 27291768 user_all 14.13.93.25:35490 user_schools2 Sleep 0 NULL 0.000 27291777 user_all 127.0.0.1:56096 user_cms Sleep 0 NULL 0.000 27291776 user_all 14.13.93.25:35506 user_schools2 Sleep 0 NULL 0.000 27291779 user_all 127.0.0.1:56112 user_schools2 Sleep 0 NULL 0.000 27291785 user_all 127.0.0.1:56170 user_jobs2 Sleep 0 NULL 0.000 27291759 user_all 10.10.10.11:32066 user_cms Sleep 0 NULL 0.000 27291786 user_all 127.0.0.1:56186 user_jobs2 Sleep 0 NULL 0.000 27291706 user_all 10.10.10.5:52268 user_cms Sleep 0 NULL 0.000 27291789 user_all 127.0.0.1:56226 user_jobs2 Sleep 0 NULL 0.000 27291788 user_all 127.0.0.1:56210 user_jobs2 Sleep 0 NULL 0.000 27291731 user_all 10.10.10.1:60230 user_jobs2 Sleep 0 NULL 0.000 27291742 user_all 10.10.10.5:52340 user_jobs2 Sleep 0 NULL 0.000 27291784 user_all 127.0.0.1:56166 user_jobs2 Sleep 0 NULL 0.000 27291743 user_all 10.10.10.1:60320 user_jobs2 Sleep 0 NULL 0.000 27291780 user_all 127.0.0.1:56114 user_schools2 Sleep 0 NULL 0.000 27291707 user_all 127.0.0.1:56008 user_jobs2 Sleep 0 NULL 0.000 27291740 user_all 10.10.10.5:52338 user_jobs2 Sleep 0 NULL 0.000 27291790 user_all 127.0.0.1:56234 user_jobs2 Sleep 0 NULL 0.000 27291718 user_all 127.0.0.1:56052 user_jobs2 Sleep 0 NULL 0.000 27291778 user_all 127.0.0.1:56098 user_schools2 Sleep 0 NULL 0.000 27291766 user_all 10.10.10.11:32128 user_jobs2 Sleep 0 NULL 0.000 27291772 user_all 10.10.10.11:32164 user_jobs2 Sleep 0 NULL 0.000 27291791 user_all 127.0.0.1:56242 user_jobs2 Sleep 0 NULL 0.000 27291762 user_all 10.10.10.11:32086 user_schools2 Sleep 0 NULL 0.000 27291774 user_all 10.10.10.11:32176 user_jobs2 Sleep 0 NULL 0.000 27291761 user_all 10.10.10.11:32084 user_jobs2 Sleep 0 NULL 0.000 27291764 user_all 10.10.10.11:32116 user_jobs2 Sleep 0 NULL 0.000 27291783 user_all 127.0.0.1:56150 user_jobs2 Sleep 0 NULL 0.000 27291787 user_all 127.0.0.1:56194 user_jobs2 Sleep 0 NULL 0.000 27291797 user_all 10.10.10.1:60382 user_jobs2 Sleep 0 NULL 0.000 27291792 user_all 127.0.0.1:56258 user_jobs2 Sleep 0 NULL 0.000 27291801 user_all 10.10.10.1:60394 user_jobs2 Sleep 0 NULL 0.000 27291794 user_all 127.0.0.1:56284 user_jobs2 Sleep 0 NULL 0.000 27291796 root localhost NULL Query 0 starting SHOW FULL PROCESSLIST 0.000 27291795 user_all 10.10.10.5:52380 user_jobs2 Sleep 0 NULL 0.000 27291775 user_all 10.10.10.11:32188 user_jobs2 Sleep 0 NULL 0.000 27291782 user_all 127.0.0.1:56142 user_jobs2 Sleep 0 NULL 0.000 27291781 user_all 127.0.0.1:56126 user_jobs2 Sleep 0 NULL 0.000 27291804 user_all 10.10.10.11:57814 user_schools2 Sleep 0 NULL 0.000 27291798 user_all 127.0.0.1:56296 user_jobs2 Sleep 0 NULL 0.000 27291799 user_all 127.0.0.1:56310 user_jobs2 Sleep 0 NULL 0.000