Компьютеры и оргтехника

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (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) 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 (65576,65575,65182,65181,65180,65179,65178,65115,64993,64990,64989,64974,64950,64949,64948,64947,64946,64945,64944,64940,64939,64938,64937,64873,64872,64809,64808,63774,63773,63772,63771,63770,63769,63768,63571,63569,63567,63562,63434,63433,63432,63431,63430,63429,63428,63427,63064,62991,62990,62989,62988,62987,62986,62982,62979,61890,61405,60938,60933,60932,60650,60649,60647,60646,60645,60644,60642,60640,60639,60638,60637,60633,60631,60132,60109,59435,59172,59168,59167,59153,59152,59151,59150,59149,59148,59147,59146,59145,59144,59143,58660,58397,58006,57511,57510,57075,57074,56513,56402,56376,56127,54943,54937,54470,54467,52698,52697,52696,52695,52694,52693,52691,52690,52689,52688,52687,50869,50868,50867,50866,50865,50864,50863,50862,50861,50860,50323,49486,48905,48901,48900,48899,48897,48896,48895,48894,48893,48892,48889,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,46907,46906,46904,46903,46897,46778,46531,46517,46501,46460,46233,45072,45065,45001,44994,44984,44940,44857,44851,44850,44849,44847,44846,44845,44844,44843,44466,44458,44452,44320,44079,44070,44067,44054,43592,43588,43587,43586,43582,43571,43566,43557,43555,43303,43302,43301,43300,43299,43298,43297,41900,41898,41895,41858,41292,41017,41007,40990,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,34121,31455,31452,31451,31433,31426,31423,31421,31420,31404,31401,31225,31224,31223,31222,31219,31216,30572,30185,29763,29609,28261,27674,27646,27210,27196,27195,27194,27193,27192,27191,27190,27189,27188,27187,27186,27185,27184,27183,24266,24265,24264,24263,24262,24261,24258,24257,24250,24240,24239,24234,24233,24232,24221,24220,24219,24210,24203,21082,18772,18771,18770,16425,16424,16423,16422,16421,16420,15269,11091,3965,3639,3338) 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 ( 64872,64873,64937,64938,64939,64940,64944,64945,64946,64947,64948,64949,64950,64974,64989,64990,64993,65182,65575,65576) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00011301040649414
$time2: 0.002007007598877
$time3: 0.0050899982452393
$time4: 0.010478019714355
$time5: 0.060134887695312