$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (665,712,2272,1118,1944,3698,4637,76793,77056,1119,77128,77912,2495,3161,85398,1239,85403,2921,1328,3429,3430,3432,3433,4635,1476,4645,4646,4724,1554,4798,4799,5199,77897,78215,78313,78608,78637,78793,79010,81392,81393,81396,81398,85552,87081,87099,89611,89717,93174,98860,98866,100131,100138,102570,102596,103265,103267,104916,104917,105211,109306,109387,110869,112985,117407,119190,120337,120338,121085,121086,121093,121094,122597,122599,127860,128353,128354,128355,128356,1720,1721,1722,1723) 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 (59966,59965,59964,59963,59381,52677,59450,61601,50837,58813,61597,49613,54971,61087,48964,50284,43395,39093,50678,41038,43046,43045,44324,44322,31152,35636,36673,39602,41084,27866,38583,21722,23420,24528,24524,24479,24307,18801,15765,20201,25723,25722,16879,30264,13663,13627,13096,12929,30507,11768,16296,12655,9256,7195,9303,45723,6293,6170,11973,6161,10291,4831,16631,16630,12443,21554,7651,3182,3597,1727,4007,11373,11372,4541,11371,769,3254,3494,514,2126,2125,2207,224) 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 ( 61597,61601) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 5.6982040405273E-5
$time2: 0.0010471343994141
$time3: 0.0029129981994629
$time4: 0.0033621788024902
$time5: 0.010329961776733
