Тракторные прицепы

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (3411,3412,78800,82872,78801,82873,78802,2014,2986,2015,2987,3224,4802,7690,2016,78688,81195,1153,2017,2648,3700,78689,86371,2632,2641,2651,2633,2920,77922,76428,2923,102601,102604,1489,1544,80896,80897,81449,81871,81872,81873,81874,81875,81876,81877,82759,83865,86166,86627,86977,87388,87409,88616,88623,88624,88627,92521,93461,94521,94522,94523,94524,94525,94526,98677,98678,98679,98773,98947,98981,100150,100325,100326,100329,100331,100332,100735,106385,106386,106390,106962,109168,109189,109196,109198,109199,109200,109201,109202,109203,109204,109241,109242,109255,109259,109260,109261,109262,109263,109264,109265,109266,109267,109273,109274,109293,110542,110543,110544,112770,112771,112772,112786,119486,121660,121663,122547,122549,122550,122556,122557,122558,122559,122560,122593) 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 (59448,58750,58749,58748,61194,58746,58740,58739,58737,61175,61176,48916,45783,45784,45782,45781,42233,43411,42231,44221,39007,41662,50701,50700,50699,50698,50697,41654,50696,50695,47405,50694,50689,38974,38973,48847,38971,38970,38969,38968,38967,43159,41630,44175,36677,43409,37580,43408,31160,31157,39464,31701,31700,30035,30032,35613,35291,28372,53630,27228,26838,26837,26836,24786,24785,24784,24783,24782,24781,24139,23660,26740,35310,35309,25127,19754,19731,19596,19532,19458,21279,22378,16735,16734,16617,19425,16079,16078,16077,16076,16075,19424,25742,15626,15464,16182,14301,15529,14299,13742,13741,24477,8081,7694,10038,4833,4216,4215,3832,3286,3285,3184,3181,2728,2725,2718,2660,2659,6202,3771,4937,4936,759,691,2308) 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 ( 61175,61176,61194) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 6.413459777832E-5
$time2: 0.0011570453643799
$time3: 0.0032260417938232
$time4: 0.004094123840332
$time5: 0.013877153396606