Лесовозы

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (2368,3072,3094,5340,5341,5348,2706,5351,1465,76390,76409,78775,1941,78781,5353,78761,78769,78770,78758,78763,78780,78760,78765,78762,78767,78764,78772,78766,78799,78768,78771,103567,124631,78881,78882,82915,82916,82917,82918,82919,82920,2483,82921,86624,87069,87781,87784,87785,87786,125394,87787,90519,90520,90521,90533,90915,95117,95118,98028,98029,98030,98031,98032,98033,98034,98035,98036,98037,98656,98657,98658,98661,98662,98663,98666,98667,98671,100297,100298,100734,101536,102552,102578,102592,103270,103271,104721,104912,104722,106683,106686,106688,106691,109008,109676,109677,110914,111733,111734,111742,113380,113381,113382,113383,113387,114252,114253,117197,120573,120574,120580,125070,125071,76398,125072,125073,76400,125074,76401,125075,125076,76418,127977,76421,76422,77213,124964,124965,76414) 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 (61391,59735,61298,58552,61297,61296,61295,61294,61293,61273,59543,61110,61106,50243,50242,61390,56144,61292,61291,51279,61289,61288,51276,43978,43970,43969,43966,40851,40850,60970,46996,36618,36616,46997,34575,41024,41023,39213,44325,43209,42158,31134,42161,39100,30179,29843,30874,29854,34968,29847,34967,29848,26820,29844,39225,29840,29810,28092,30126,30125,27817,30124,30123,61281,29805,51270,29593,29592,24825,22121,22109,22108,22107,23971,24963,24962,24961,26304,25818,19529,19853,19063,22033,19851,22032,16777,16776,15582,19034,19936,15512,26269,45262,27749,21462,14269,16321,14267,27770,14265,14264,14263,23696,14261,22169,14259,14258,11021,9593,9592,9590,8067,9584,9577,9576,9574,8044,9382,9381,9378,9371,9370,3593,3545,7930,4641,6763,4005,667) 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 ( 61273,61281,61288,61289,61291,61292,61293,61294,61295,61296,61297,61298,61390,61391) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 5.793571472168E-5
$time2: 0.0011420249938965
$time3: 0.0030648708343506
$time4: 0.0056619644165039
$time5: 0.039613962173462