Авто, башенные, мостовые краны

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (779,76412,780,781,782,783,2519,784,2520,1103,2681,2918,2975,2976,92245,1121,2309,2978,7687,1127,2436,7688,1129,12533,1130,76470,1151,76688,76918,76919,77039,77040,77124,77132,1384,77308,77895,77911,78214,1539,78301,81025,82223,82224,82225,1552,82464,1556,82465,82481,83862,83863,85451,87094,87100,87102,90538,90539,101202,102157,102158,102159,102566,103179,103263,104839,106042,106233,109135,109166,109300,109305,109310,109311,109318,110583,110839,110864,112016,112017,113764,113768,116124,116656,116657,116658,116659,116682,116683,116684,116985,116991,117023,117842,117843,117844,117846,117853,117854,117856,117859,117863,117869,117872,117873,117874,117879,117887,117902,117908,117914,117919,117931,117934,117938,117957,117996,118007,118014,118020,118021,118022,118023,118024,118025,118026,118027,118028,118029,118794,118797,118798,118799,118800,118220,118801,118221,118802,118803,118804,118806,118808,118812,118828,119621,119622,119623,119624,119628,119639,119642,119643,119644,119648,119655,119659,119660,119661,119662,119663,119664,119665,119666,119667,119668,120587,121083,121343,121604,122009,122101,122102,122107,122120,122121,122122,123811,123812,123825,125862,127844,127845,127846,127847,127964,127965,129289,3687,5332,5333,76394,76411,77488,123826,123827) 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 (61595,61249,60567,60553,60550,60545,60544,60542,60541,60519,60515,60514,60512,60511,60510,60509,60508,60507,60506,60341,60338,60316,60315,60314,60291,60290,60289,60288,60187,60182,60181,60180,60178,60176,60175,60171,60170,60169,60168,60167,60166,60165,60164,60163,60162,60160,60142,60141,60140,60139,60138,59507,59470,59469,59368,59367,59366,59365,58530,58507,58500,58494,58460,58459,58458,58412,57992,57991,57844,57314,57313,57302,56824,56757,56748,56740,56736,56726,56718,56716,56706,56704,56691,56608,56584,56583,56361,54445,54428,54337,54192,54179,54178,54110,54103,54102,53694,52369,51974,51263,50683,50682,50668,50667,50666,50664,50663,50662,50659,50254,49256,48172,45298,45142,44174,43956,43737,43492,43058,41957,40834,40809,40635,39063,39047,37646,31500,31469,31468,31467,31122,25059,24464,23547,22421,22376,22126,22125,19685,19683,18850,18822,17500,16549,16532,16262,16261,16260,15968,15465,14695,13574,13424,13084,12699,12650,11962,11961,11766,11622,11425,10235,10117,10106,10061,9614,9586,9570,9247,9246,9245,8590,8110,8109,8064,7692,7569,7524,7523,5000,4884,3496,3481,3179,3003,2127,1836,1793,426,381,342,341,340,339,338) 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 ( 61249,61595) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 7.3909759521484E-5
$time2: 0.0019028186798096
$time3: 0.0041120052337646
$time4: 0.004586935043335
$time5: 0.012383937835693