Посадка и уборка сельхозкультур

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (80342,80344,3955,88599,88619,2660,3915,3916,3917,12532,76334,76335,76337,76338,76341,76830,76831,76833,77273,78077,78078,78079,78154,78155,78156,128808,80345,81773,81814,81815,82012,82013,82452,83078,83079,83080,83081,83897,84212,84310,85742,85993,86125,88618,88625,88611,88620,93185,88621,93186,93188,93191,95543,98910,98949,98950,100328,102209,106387,106574,106575,106576,106823,106864,132723,108824,132724,108825,132725,108827,132836,109190,133362,109254,133363,110399,133680,110530,133681,110535,133775,110536,133776,112655,134270,113370,134443,113371,134619,115336,134620,117287,134621,118320,134924,135004,122592,122555,123887,123888,124829,125123,127350,127351,127574,127575,130496,130497,130619,130620,131288,131712,132053,132055,132059,4005,76361,78749) 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 (65624,65578,65236,65235,65234,65109,65030,64702,64701,65111,65110,65281,65280,64856,63931,63930,63929,64312,64309,64308,64851,63827,64813,62394,64492,63898,61993,64397,64396,63706,64814,56404,58680,65398,57097,65126,61765,47770,59260,44486,43218,44003,49253,42229,41750,41749,41980,45451,38959,38629,38627,58679,38604,36627,37591,36550,41748,37581,30898,34592,30122,39079,65232,26812,29653,24038,29651,30945,35311,20289,20288,35307,35306,26733,20267,19267,19174,19040,19474,19584,17504,21288,21287,21286,19710,22363,16953,16099,16047,16046,17440,16615,17495,17047,15593,14620,14619,13635,14969,12644,12643,14966,9492,9357,9356,8001,7952,20079,24534,12984,13567,15418,16901,6996,6705,7275,6703,2737) 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 ( 64701,64702,65030,65109,65126,65232,65234,65235,65236,65280,65281,65398,65578,65624) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 9.4890594482422E-5
$time2: 0.0012218952178955
$time3: 0.0037229061126709
$time4: 0.0063610076904297
$time5: 0.041601896286011