Прицепы и полуприцепы

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (81862,77082,89618,3683,98867,102595,102597,102599,102600,103272,105212,105213,106118,104389,107780,1844,109314,109321,113376,113377,1843,113378,113379,121501,124676,1838,124955,1839,124956,1840,124957,1841,124958,1842,124959,124960,124961,124962,127967,128323,121729,128372,128373,128374,128375,78737,84478,84479,77074,128357,128358,77069,98856,109526,88834,89612,76352,78372,78373,3177,81399,87056,3668,90243,3670,94884,95696,117566,119194,128809,78371,120578,120579,120581,104379,104380,104381,104382,1878,4695,83376,3699,4803,77399,90548,77913,93171,77914,90547,101204,109313,109740,109934,1329,110868,119429,121088,2370,76403,2484,3080,76404,78774,76424,78776,76426,78785,76427,76429,76430,76443,1347,81400,82922,82923,1469,82924,1470,82925,83377,86625,90522,90523,90524,90546,95113,97642,98041,98042,98043,98044,98045,98046,98047,98048,98049,98050,98051,98052,98053,98054,98659,101539,102565,102598,102602,102603,104918,106684,106687,106690,125395,125396,125827,664,667,666,1102,3040,3041,3431,78755,81277,81389,1297,92118,98921,1326,92119,1327,76490,76494,76915,76916,1464,1468,80354,1475,4098,80824,81391,81397,81401,81412,81413,4807,81439,81441,76920,81442,81443,83380,87057,87527,87528,88067,88884,92120,92121,92122,92123,95114,95115,98920,113374,114681,117408,125130,98870,125392,127724,665,712,2272,1118,1944,3698,4637,76793,77056,1119,77128,77912,2495,3161,85398,1239,85403,2921,1328,3429,3430,3432,3433,4635,1476,4645,4646,4724,1554,4798,4799,5199,77897,78215,78313,78608,78637,78793,79010,81392,81393,81396,81398,85552,87081,87099,89611,89717,93174,98860,98866,100131,100138,102570,102596,103265,103267,104916,104917,105211,109306,109387,110869,112985,117407,119190,120337,120338,121085,121086,121093,121094,122597,122599,127860,128353,128354,128355,128356,1720,1721,1722,1723,77393,668,669,4779,3299,85548,87413,108202,2496,112776,121087,128370,128371,1719,12561,1482,1483,2985,4667,4669,4778,5207,81402,81403,81404,81405,81406,81407,81408,81409,81410,92899,81861,82871,83068,83070,83072,83074,83076,83864,85292,90545,95362,4781,106395,106396,108203,109280,109289,109290,109291,109307,109308,109315,110870,111998,111999,112000,120143,122598,127861,127862) 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 (61601,61598,61597,61433,61287,61286,61285,61284,61283,61282,61263,61262,61261,61260,61259,61258,61257,61256,61138,61107,61105,61087,60723,60007,59985,59984,59983,59982,59981,59980,59968,59967,59966,59965,59964,59963,59865,59737,59736,59733,59472,59451,59450,59383,59382,59381,59357,58813,58732,57368,55889,55782,54971,53104,53065,52800,52677,50837,50832,50680,50679,50678,50284,49613,48964,48819,47022,47011,45723,45263,44415,44339,44326,44324,44322,44234,44100,43774,43773,43422,43395,43221,43046,43045,42156,42155,41746,41745,41318,41084,41039,41038,41032,40879,40838,40760,40643,40608,40335,39602,39193,39107,39093,39068,39066,39061,39024,39023,39022,39013,38900,38583,38581,37693,37691,37208,36685,36673,36614,35646,35636,31503,31502,31501,31317,31159,31158,31156,31155,31153,31152,31151,31121,30507,30414,30264,30129,30128,30127,29845,29827,29825,29824,29815,29812,29811,28332,28104,28099,28097,27988,27987,27876,27866,27862,27837,27826,27160,27159,27146,26599,26517,26272,25734,25733,25732,25731,25730,25729,25728,25727,25726,25725,25723,25722,25721,25687,25686,25328,24999,24997,24965,24884,24528,24524,24479,24307,24022,23890,23888,23885,23882,23876,23868,23808,23430,23429,23427,23426,23420,23403,23394,22263,22145,22134,22112,22111,22110,22008,21722,21685,21590,21554,21147,21131,20201,19869,19855,19854,19791,19790,19627,19530,19221,19217,19216,18857,18845,18801,18732,17743,17741,17739,17737,17735,17680,17132,17131,17064,16955,16879,16784,16631,16630,16296,16065,16064,15785,15765,15627,15416,15395,15388,15213,14750,14233,13663,13627,13427,13286,13096,12999,12929,12908,12907,12831,12655,12474,12443,11973,11875,11768,11648,11547,11460,11373,11372,11371,11006,10291,10090,9610,9599,9598,9597,9596,9595,9579,9578,9365,9306,9303,9256,9253,9088,8373,8171,8093,7679,7651,7203,7195,6293,6270,6170,6161,5502,4989,4831,4791,4757,4642,4541,4327,4007,3828,3779,3597,3553,3494,3254,3253,3249,3247,3182,2775,2207,2126,2125,1727,1418,1417,1416,1415,1216,769,684,683,671,670,565,541,514,224,223) 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 ( 59865,60723,61138,61256,61257,61258,61259,61260,61261,61262,61263,61282,61283,61284,61285,61286,61287,61433,61597,61598,61601) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00014019012451172
$time2: 0.00027704238891602
$time3: 0.0030670166015625
$time4: 0.0067141056060791
$time5: 0.053898096084595