Автобусы

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (1867,1868,1939,2257,76828,77038,77403,77404,77405,77407,77915,77950,77951,78209,78305,81374,83450,83867,84464,85394,85399,86241,2479,87070,87507,89551,89552,89553,89554,2979,89555,89556,89557,3163,89697,90540,3472,90541,95094,3733,98990,103266,103390,106394,109301,110836,4648,110867,113766,118218,120517,120586,121078,122255,127570,127851,127852,76690,76471,76472,1706,1707,128655) 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 (60023,59373,59372,59309,52192,61592,52700,50170,47676,45144,52316,52309,50675,37586,34820,44323,42591,24977,27156,27155,30885,21582,21581,21580,21579,23694,23693,23692,58830,39098,46947,40319,29605,20465,19565,17242,25708,16512,15423,14859,11886,24480,14668,14666,21508,12883,10060,10113,9041,10119,10118,13732,7502,4429,6195,9248,5289,1654,4003,8024,16118,6445,11369) 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 ( 60023,61592) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 7.0095062255859E-5
$time2: 0.0007169246673584
$time3: 0.002701997756958
$time4: 0.0037529468536377
$time5: 0.011210918426514