Все что не вошло в другие категории

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (78509,121012,14,128,3312,3314,1063,3973,3974,4895,5033,5038,5040,7660,76402,77417,77526,80431,80519,82314,80543,81194,82326,82329,82332,82333,132690,134312,83667,87382,89730,98993,98994,98996,98997,98998,98999,99000,99002,99004,99005,99006,99009,99011,99015,99016,99019,99025,99026,99029,99030,99033,99034,99035,99036,99037,99038,99041,99042,99043,99044,99047,99049,100199,100200,100201,100247,100870,105993,107200,107201,103898,107202,110421,110422,110423,110581,113689,117366,119773,120890,120891,120892,120893,120894,120895,120896,120897,120938,120939,120940,120941,120942,120943,120944,120946,120949,120953,121008,121009,121010,121364,121365,121372,121373,121374,121375,121499,121644,121665,121666,121667,121835,121836,121837,121838,121839,121840,121841,121842,121843,121844,121845,121846,121847,121848,121849,121850,121851,121852,121853,121854,121855,121856,121857,121858,121859,121860,121861,122521,125617,125618,125869,125870,128316,128864,128865,129670,77073,78513,116136,123938,1914,3310,5031,5032,77531,77532,77533,82307,82308,82309,82310,82311,82312,84422,84439,93522,93524,93525,93526,93527,93528,93529,93532,93533,93535,93537,93538,93539,93540,93541,93542,93543,93544,93546,93547,93549,93551,93552,93555,93556,93557,93558,93559,93561,93562,93563,93564,93567,93568,93569,93570,93571,93572,93573,93574,93575,93576,93577,93578,93579,93580,93581,93583,93584,93585,93586,93587,93588,93589,93593,93596,93601,93602,93604,93605,93606,93607,93608,93823,98737,98738,98739,98740,98741,98742,98743,98744,98745,98746,98747,98748,98749,98750,98757,98760,98764,98766,100159,100240,101682,101693,101694,102657,102658,102659,102660,104849,105033,105034,105036,105037,105038,105040,106677,106678,106679,106680,106681,107014,107015,107018,107326,108094,108095,108096,108097,108098,108099,108100,108101,108102,108103,108104,108105,108106,108107,108108,108109,108110,108111,108112,108113,108114,108115,108116,108117,108118,108119,108120,108121,108122,108123,108124,108125,108126,108127,108128,108129,108130,108131,108132,108133,108134,108135,108136,108137,108138,108139,108140,108141,108142,108143,108144,108145,108146,108147,108148,108149,108150,108152,108153,108157,108164,110078,110079,110082,110083,110084,110085,110086,111544,111545,112281,112284,112286,132762,132763,115228,133449,115338,133450,115339,133685,115340,134090,115341,134091,115342,134155,115343,134156,115344,134157,115345,134158,115346,134162,115352,134163,115353,134164,115354,134165,115355,134166,115356,134167,115357,134168,115358,134192,115359,134207,115360,134208,115361,134211,115362,115363,115364,115365,115366,115367,115368,115369,115370,115371,115372,115373,115374,115375,115376,115377,115378,115381,115382,115383,115384,115385,115386,115388,115389,115390,115391,115392,115393,115394,115395,115396,115397,115398,115400,115401,115402,115403,115404,115405,115406,115408,115409,115410,115411,115412,115430,115433,115434,115435,115436,115437,115450,115452,115453,115457,115478,115479,115487,115489,115490,115491,115492,115496,115497,115512,115513,115514,115515,118795,119868,120255,120290,121285,121361,122773,125640,125641,125829,126111,127276,127277,127278,127279,127280,127281,127282,127283,127284,127285,127286,127300,127301,127305,128315,132008,132013,132015,132017,132123,132124,132125,132126,132127,2336,99850,123942,123946,123948,123952,123953,123954,123955,123956,123957,123958,123959,123981,2228,5141,78640,78642,78643,78644,78645,78646,78647,78648,78649,78650,78651,78652,78653,78654,78655,78656,78657,78659,78660,78661,78662,78663,78664,78665,78666,78706,78708,78709,78710,78711,78712,78713,78714,78715,78716,78717,78718,82124,132692,132693,132868,132869,132870,132871,132872,132934,133386,133416,133916,133922,134007,134008,134009,134010,134011,134012,134013,134048,134049,134050,134412,100114,101598,101599,110291,111129,112973,113745,113746,114683,115810,117617,117618,117619,117620,117621,117622,117623,117624,117625,117626,117627,117628,117629,117630,117631,117632,117633,118754,118755,118756,120339,120340,120341,120342,120343,120344,120345,120346,120590,120888,120889,121104,121105,121106,121107,121108,121378,122517,122518,122519,122520,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122537,122538,122539,122540,122541,122542,122543,122544,122884,122973,123495,123496,123497,123498,123499,123500,123501,123502,123503,123504,123505,123506,123507,123508,123509,123510,123511,123512,123513,123514,123515,123516,123517,123518,123519,123520,123521,123522,123523,123524,123525,123526,123527,123528,123529,123530,123531,123532,123533,123534,123535,123536,123537,123538,123539,123540,123541,123542,123543,123544,123545,123546,123547,123548,123586,123587,123588,123589,123590,123591,123593,123594,123595,123596,123597,123598,123599,123600,123601,123602,123603,123604,123605,123606,123607,123608,123609,123610,123611,123612,123613,123614,123615,123616,123617,123618,123619,123620,123621,123622,123623,123624,123625,123626,123627,123628,123629,123630,123631,123632,123633,123634,123635,123636,123637,123638,123639,123640,123641,123642,123643,123644,123645,123646,123647,123648,123649,123933,123936,124076,124077,124078,125065,125133,125398,125399,125400,125401,125445,125446,125570,125571,125572,126418,126720,128336,128731,128927,128969,128970,128971,128972,128973,128974,128975,128976,128977,128978,128979,128980,128981,128982,130106,130107,130108,130109,130110,130111,130112,130113,130114,130115,130116,130117,130118,130119,130120,130121,130122,130123,130124,130125,130126,130127,130128,130129,130130,130131,130132,130133,130134,130135,130136,130137,130138,130139,130140,130141,130142,130143,130144,130145,130146,130147,130148,130149,130150,130151,130152,130965,131187,131633,131634,131873,132305,132336,719,718,717,716,715,713,125855,125856,125944,113391,118853,118856,118857,118876,119646,119647,124573,119824,119825,119826,119827,119828,125841,132011,116977,116982,116990,117010,117014,117015,117036,117058,117065,117097,117104,117105,117106,117109,117126,117144,117145,117146,117147,117148,117149,117150,117155,117156,117894,117904,117905,117946,117959,117984,117985,117986,117993,118018,118019,79147,100062,80515,80516,80540,83261,84465,5039,88600,88601,88602,88603,88604,88605,90916,90917,90918,90927,133137,133138,133139,133146,133205,133206,133207,133208,134095,134126,134134,134159,134160,134161,101705,134179,134180,134181,134182,134183,134184,134189,134190,134197,134202,134203,134204,134205,107016,107017,107020,115498,115499,115500,119867,121003,121004,121005,121006,121360,125851,127273,127274,129947,129948,129949,132006,87657,99848,100060,113399,121011,100063,87383,87384,87386,119771,132016,121362,121363,126921,126922,129954,100104,100105,100106,100107,100108,100109,117367,117368,117369,117370,117371,117372,117373,117374,117375,117376,117377,117378,117379,117380,117381,117382,117383,117384,117385,117386,117387,117388,117389,117390,117391,117392,117393,117394,117395,117396,117397,117398,117399,117400,117401,117402,120147,113998,120954,120955,120956,120957,120958,120959,120960,121672,134094,119830,119831,119832,119833,119834,119835,119836,119837,119838,119839,119840,119841,119842,119843,119844,119845,119846,119847,119848,119849,119850,119851,119852,119853,119854,119855,119856,119857,119858,119859,119860,119861,119862,119863,119864,119865,119866) GROUP BY `lotid` ORDER BY `id` DESC
$count: SELECT `modx_auc_torgi`.`id`,`modx_auc_torgi`.`lotid`,`modx_site_content_extend`.`region`,`modx_site_content_extend`.`district` FROM `modx_auc_torgi` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_auc_torgi`.`lotid` LEFT JOIN `modx_site_tmplvar_contentvalues` ON `modx_site_tmplvar_contentvalues`.`contentid` = `modx_auc_torgi`.`lotid` LEFT JOIN `modx_site_content_extend` ON `modx_site_content_extend`.`id_content` = `modx_auc_torgi`.`lotid` WHERE `modx_auc_torgi`.`id` IN (65774,65768,65767,65766,65765,65764,65763,65762,65761,65760,65759,65758,65757,65714,65713,65712,65711,65710,65709,65708,65707,65706,65705,65704,65703,65702,65701,65700,65699,65698,65697,65696,65695,65694,65693,65692,65691,65690,65689,65688,65687,65686,65685,65684,65683,65682,65681,65680,65679,65678,65677,65676,65675,65674,65673,65672,65671,65670,65669,65668,65658,65657,65656,65655,65654,65638,65637,65636,65635,65634,65633,65632,65618,65576,65575,65509,65508,65507,65506,65502,65501,65500,65487,65454,65453,65452,65451,65422,65417,65416,65415,65182,65181,65180,65179,65178,65128,65115,65108,65085,65061,65040,65039,65038,65037,65036,64993,64990,64989,64987,64986,64985,64984,64979,64974,64972,64971,64966,64965,64964,64963,64962,64961,64950,64949,64948,64947,64946,64945,64944,64943,64942,64941,64940,64939,64938,64937,64916,64908,64877,64876,64873,64872,64818,64817,64816,64809,64808,64768,64691,64682,64639,64399,64391,64321,64057,63970,63969,63957,63956,63824,63800,63774,63773,63772,63771,63770,63769,63768,63756,63755,63754,63753,63752,63751,63750,63749,63748,63747,63746,63745,63744,63743,63742,63741,63740,63739,63738,63737,63736,63735,63714,63703,63571,63570,63569,63567,63565,63562,63560,63444,63443,63442,63441,63440,63439,63438,63437,63434,63433,63432,63431,63430,63429,63428,63427,63064,63043,62991,62990,62989,62988,62987,62986,62982,62979,62828,62792,62744,62743,62738,62737,62736,62735,62734,62730,62720,62158,62074,61984,61979,61978,61977,61970,61969,61968,61967,61966,61965,61890,61721,61715,61669,61668,61554,61553,61552,61551,61546,61545,61519,61518,61517,61516,61511,61510,61462,61461,61460,61459,61458,61406,61405,61141,61140,61139,61126,61125,61124,61123,61122,61121,61120,61119,61118,61117,61116,61115,61114,61113,60938,60933,60932,60864,60828,60827,60762,60761,60760,60758,60756,60715,60650,60649,60647,60646,60645,60644,60642,60640,60639,60638,60637,60633,60631,60397,60371,60360,60349,60337,60336,60144,60143,60132,60109,60090,60089,59946,59924,59514,59435,59414,59229,59172,59168,59167,59153,59152,59151,59150,59149,59148,59147,59146,59145,59144,59143,59141,59140,59066,59011,59010,59002,58772,58660,58620,58619,58618,58617,58616,58615,58614,58613,58612,58611,58610,58609,58608,58607,58606,58605,58604,58603,58602,58601,58600,58599,58598,58597,58596,58595,58489,58397,58305,58300,58296,58293,58292,58291,58289,58288,58287,58286,58285,58284,58283,58282,58281,58280,58279,58275,58273,58267,58266,58265,58264,58263,58262,58261,58259,58258,58257,58252,58086,58006,57925,57924,57898,57892,57839,57838,57823,57511,57510,57505,57357,57296,57295,57101,57100,57099,57075,57074,57028,57027,57026,57025,57024,57023,57022,57021,57020,57019,57018,57017,57016,57015,57014,57013,57012,57011,57010,57009,57008,57007,57006,57005,57004,57003,57002,57001,57000,56999,56998,56997,56996,56995,56994,56993,56992,56991,56990,56989,56988,56987,56986,56985,56984,56983,56982,56981,56980,56979,56978,56977,56976,56975,56974,56973,56972,56970,56969,56968,56967,56966,56965,56964,56963,56962,56961,56960,56959,56958,56957,56956,56955,56954,56953,56952,56951,56950,56949,56948,56947,56946,56945,56944,56943,56942,56941,56940,56939,56938,56937,56936,56935,56934,56933,56932,56931,56930,56929,56928,56927,56925,56923,56922,56921,56920,56919,56918,56917,56916,56915,56914,56913,56912,56911,56910,56909,56908,56907,56857,56855,56803,56798,56797,56778,56767,56738,56731,56688,56687,56668,56590,56513,56512,56509,56508,56502,56500,56499,56494,56493,56487,56483,56481,56479,56468,56467,56463,56449,56446,56444,56442,56402,56400,56376,56375,56358,56127,56091,56090,56088,56085,56084,56081,56080,56079,56078,55792,55254,55253,55252,55251,55250,55085,55079,55068,55066,55046,55045,55018,54987,54978,54977,54976,54975,54974,54973,54972,54943,54937,54733,54471,54470,54469,54468,54467,54465,54175,54070,52996,52829,52826,52825,52823,52822,52819,52818,52817,52816,52811,52810,52809,52698,52697,52696,52695,52694,52693,52691,52690,52689,52688,52687,52625,52624,52623,52599,52328,51959,51958,51891,51890,51889,51888,51887,51886,51885,51884,51883,51882,51881,51880,51879,51878,51877,51876,51875,51874,51873,51872,51054,51039,50869,50868,50867,50866,50865,50864,50863,50862,50861,50860,50842,50765,50759,50741,50740,50323,50180,50179,49947,49614,49531,49486,49252,48958,48951,48935,48905,48901,48900,48899,48897,48896,48895,48894,48893,48892,48889,48201,48200,47757,47675,47674,47673,47658,47657,47656,47654,47626,47622,47621,47619,47556,47555,47554,47551,47533,47532,47531,47530,47529,47527,47525,47524,47523,47522,47511,47510,47509,47505,47504,47499,47498,47489,47487,47485,47484,47474,47468,46924,46907,46906,46904,46903,46897,46863,46860,46837,46833,46778,46644,46531,46517,46501,46460,46286,46243,46241,46235,46233,46054,45282,45072,45065,45005,45004,45003,45001,44994,44984,44940,44857,44851,44850,44849,44847,44846,44845,44844,44843,44810,44730,44728,44727,44714,44518,44510,44500,44499,44466,44458,44452,44423,44320,44153,44152,44079,44070,44067,44054,43652,43592,43588,43587,43586,43582,43571,43566,43557,43555,43303,43302,43301,43300,43299,43298,43297,42628,42260,41900,41898,41895,41858,41292,41130,41017,41007,40990,40911,40860,40859,39043,38637,37750,37748,37747,37746,37745,37744,37485,37484,37483,37482,37481,37480,37478,37477,37476,37475,37474,37473,37471,37469,37468,37467,36612,36611,36610,36608,36601,34727,34717,34706,34699,34697,34695,34694,34693,34692,34691,34687,34686,34685,34684,34683,34224,34223,34136,34121,31455,31452,31451,31433,31426,31423,31421,31420,31404,31401,31225,31224,31223,31222,31219,31216,31090,30595,30572,30221,30185,29770,29763,29724,29723,29722,29609,28426,28415,28261,27674,27646,27210,27196,27195,27194,27193,27192,27191,27190,27189,27188,27187,27186,27185,27184,27183,26731,26730,26729,26727,26082,26073,26072,26071,25653,25117,24266,24265,24264,24263,24262,24261,24258,24257,24250,24240,24239,24234,24233,24232,24221,24220,24219,24210,24203,22629,22626,21734,21082,19729,19727,19726,19503,19502,19161,19123,19119,18856,18772,18771,18770,17328,16446,16445,16442,16439,16427,16425,16424,16423,16422,16421,16420,15269,15180,15036,14512,14142,14141,14140,14139,14138,14137,14136,14135,14134,14133,14132,14131,13690,13689,13688,13687,13686,13685,13684,13683,13681,13680,13679,13678,13677,13676,13675,13674,13673,13672,13671,13670,13669,13668,13667,13666,13665,11674,11546,11478,11091,10194,8055,7104,6994,6992,4315,4314,4313,4312,4311,3969,3967,3965,3639,3338,2065) AND `modx_auc_torgi`.`result` IN (1,6,8) AND `modx_site_content`.`template`=4 AND `modx_site_content`.`published`=1 AND `modx_site_content`.`deleted`=0 GROUP BY `modx_auc_torgi`.`id`
$main_query: SELECT `modx_auc_torgi`.`id` as `torgid`,`modx_auc_torgi`.`result`,`modx_auc_torgi`.`lotid`,`modx_auc_torgi`.`price` as `torgi_price`,`modx_auc_torgi`.`minimal_price` as `torgi_minimal_price`,`modx_auc_torgi`.`discont`,`modx_auc_torgi`.`aucend`,`modx_auc_torgi`.`aucbegin`,`modx_auc_torgi`.`requestend`,`modx_auc_torgi`.`curr`,`modx_auc_torgi`.`mess`,`modx_auc_torgi`.`ndsid`,`modx_auc_shema`.`shema`,`modx_site_content_extend`.`lot`,`modx_site_content_extend`.`region`,`modx_site_content_extend`.`district`,`modx_site_content`.`pagetitle`,`modx_ms2_products`.`thumb`,`modx_auc_results`.`status`,`modx_auc_nds`.`nds`,`modx_auc_nds`.`nds_s` FROM `modx_auc_torgi` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_auc_torgi`.`lotid` LEFT JOIN `modx_ms2_products` ON `modx_ms2_products`.`id` = `modx_auc_torgi`.`lotid` LEFT JOIN `modx_site_content_extend` ON `modx_site_content_extend`.`id_content` = `modx_auc_torgi`.`lotid` LEFT JOIN `modx_auc_results` ON `modx_auc_results`.`id` = `modx_auc_torgi`.`result` LEFT JOIN `modx_auc_shema` ON `modx_auc_shema`.`id` = `modx_auc_torgi`.`shemaid` LEFT JOIN `modx_auc_nds` ON `modx_auc_nds`.`id` = `modx_auc_torgi`.`ndsid` WHERE `modx_auc_torgi`.`id` IN ( 64816,64817,64818,64916,64937,64949,64963,64964,64965,64966,64972,65085,65500,65507,65508,65509,65576,65618,65632,65633,65634,65635,65636,65637,65638,65654,65655,65656,65657,65658,65668,65669,65670,65671,65672,65673,65674,65675,65676,65677,65678,65679,65680,65681,65682,65683,65684,65685,65686,65687,65688,65689,65690,65691,65692,65693,65694,65695,65696,65697,65698,65699,65700,65701,65702,65703,65704,65705,65706,65707,65708,65709,65710,65711,65712,65713,65714,65757,65758,65759,65760,65761,65762,65763,65764,65765,65766,65767,65768,65774) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00029897689819336
$time2: 0.005763053894043
$time3: 0.011450052261353
$time4: 0.029299020767212
$time5: 0.10375714302063