Легковые авто

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (769,2780,1126,1345,1346,1423,1480,1518,1481,1543,1553,1555,1757,1896,1971,1972,2266,2301,1976,2307,2350,2551,2968,2969,3011,3078,3730,3567,3731,2357,2403,3812,3939,4093,4647,4651,4797,4868,130104,5198,7682,7735,7736,7737,76691,76692,76694,76695,76696,76698,76796,76855,76856,76861,76979,77097,77104,77209,77210,77214,77305,77401,77402,77515,77931,4640,77952,78036,78207,78267,78347,78435,78436,78442,78783,80576,80584,80585,81341,81555,81847,81848,81849,81850,81851,81852,81857,82212,82283,82578,82843,82844,82911,83374,85388,85389,87071,87407,87408,76697,88388,89306,89609,89613,89698,76820,89995,90248,90249,90250,90251,90252,90253,90254,90255,90256,90257,90258,90530,90531,90532,90535,90537,90607,90652,90653,90654,90655,90656,90657,90658,90862,78506,78508,78681,78682,78734,78736,78787,1704,1708,90941,91661,92058,92126,92127,92128,92248,92249,92250,92251,92252,92253,92254,92255,92256,92257,92258,92259,92260,92261,92262,92885,93177,93456,94528,94529,94530,94531,94532,95109,95110,95363,96075,96775,98715,98716,98774,98775,98776,98847,98858,98859,98876,98877,98952,98976,98977,98980,100299,100300,100302,100306,100316,100350,101596,102493,102494,102501,103387,103391,103393,103569,103570,104482,105030,105041,105042,105043,105401,105403,105404,105405,105406,105512,105513,105514,105515,105516,105517,105518,106374,106958,107545,108377,108378,108379,108380,108382,108383,108384,108385,108387,108388,108389,108390,108391,108644,108645,108646,108885,109139,109278,110692,110693,110699,110700,110840,110841,110842,110843,110844,110851,110854,110855,111093,111926,112329,112761,112774,112899,113682,113866,113867,114329,114330,114331,114332,114333,114411,114918,114978,116091,116093,116094,117119,116096,117163,117164,117165,117200,117297,117329,117638,117639,118073,118219,118372,119428,120011,120180,120215,120335,120336,120521,120626,121077,121488,121490,132682,121493,132909,121720,132910,121722,132911,122256,133096,122562,133214,122563,133215,123837,133652,124947,133653,124948,133779,124949,133780,124950,134313,124951,134405,124952,134406,124953,134407,124954,134408,124966,134409,124968,134410,124969,134416,124970,134508,124971,134922,124972,134959,124973,134961,124974,134962,124975,135040,124976,135065,125126,125127,125128,125391,125948,126766,126892,126893,126894,127103,127572,127573,127978,127979,128966,129126,129202,129286,129291,129802,130579,131484,131584,131731,131877,131878,131879,131880,131881,131972,109137,117127) 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 (65653,65649,65594,65593,65592,65577,65394,65285,65139,65129,65096,65084,65083,65082,65081,65080,65079,65078,65077,65076,65075,65062,65043,64704,64703,64660,64659,64656,64651,64644,64401,64392,64307,64306,64304,64036,64035,64034,63554,63483,63473,63472,63471,63470,63238,63237,63199,62746,62403,62305,62173,62128,61858,61857,61403,61157,61151,59541,59483,59453,59312,59311,59054,58734,57990,57936,57907,56880,56879,56825,56408,56407,56406,56285,56156,56126,56125,56120,56119,56118,56105,56104,56102,56101,56100,56099,56098,55845,55674,55205,55015,54226,53564,53479,52747,52746,52312,52195,52193,51380,51114,51112,51059,50707,50283,49408,48971,48811,48803,47862,46816,46815,45836,45428,45426,45425,44410,44409,44402,44401,44400,44329,44282,44217,43903,43902,43901,43900,43899,43197,43051,42215,42202,41959,41956,41892,41234,41233,41232,41026,40889,40814,40811,40721,40720,40716,40714,40713,40712,40711,40710,40707,40443,40442,40329,39378,39230,39115,38905,38710,38709,38646,38588,37749,37671,37666,37664,37662,37661,37554,37553,37150,37105,37104,37102,37043,37042,37041,37040,37039,37038,37003,35564,35383,35379,35378,34898,34824,34821,34744,34609,34608,31647,31646,31627,31498,31096,31085,31084,30909,30886,30845,30289,30202,30054,30012,30007,29859,29857,28371,28365,28029,27969,27961,27960,27865,27731,27578,27231,27154,27152,26545,26544,26543,26389,26365,26233,25633,25631,25630,25327,25277,25267,25266,25265,25136,24993,24820,24811,24791,24790,24789,24788,24787,24777,24776,24773,24771,24769,24081,24027,23932,23796,23576,23569,23565,23564,23419,22164,22162,22161,22120,22119,22118,22023,22021,22019,22018,22017,22016,22015,22014,22013,21847,21591,21587,21531,21529,21516,20157,19844,19843,19752,19118,19104,18791,18733,17483,17482,17148,17129,16771,16582,16395,16332,16241,16240,16193,16060,16055,16052,16051,16050,15925,15857,15284,15283,14201,14038,13133,13038,12921,12904,12584,12251,11888,11617,11463,11462,11442,11152,11022,11018,11017,10300,10294,10140,10108,9724,9719,9430,9425,9424,9049,9047,9046,9045,9042,8589,7761,7760,7759,7529,7501,7194,6691,6551,6301,6175,5498,5280,5279,5243,5070,4894,4534,3551,3368,3316,3269,3268,3207,2928,2774,2773,2351,2249,2170,2074,1973,1908,1833,1792,1791,1771,1163,1162,923,726,328) 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 ( 65062,65075,65076,65077,65078,65079,65080,65081,65082,65083,65084,65096,65139,65285,65394,65577,65592,65593,65594,65649,65653) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00011992454528809
$time2: 0.00027799606323242
$time3: 0.0042338371276855
$time4: 0.009713888168335
$time5: 0.058939933776855