Квартиры, дома, коттеджи

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (2933,4763,4871,5011,77304,81310,81554,82841,87838,93022,93024,96705,101474,101475,101476,101477,101478,101481,101484,101485,101486,101534,102708,103275,105169,109299,110382,110383,110384,110385,110386,110387,110388,110389,116540,118358,118359,118360,118361,118362,118365,118366,118367,118368,118369,121648,78081,121649,121650,121651,121652,121653,121654,121655,121656,121657,121658,121659,122566,122567,122568,122569,122570,122571,122572,122573,122575,122818,122819,124301,125349,125705,83823,125725,125726,125727,125728,125729,125730,125731,125732,125733,125734,125735,125736,125737,125738,125739,125740,125741,125946,126678,126679,126680,126681,126682,126683,126684,126685,126686,126687,126688,126689,126690,126691,126692,126693,126694,126695,126696,126697,126698,126699,126700,126701,126702,126703,126704,126705,126706,126707,126708,126709,126710,126711,126712,126713,126714,126715,126716,126717,126718,128180,128249,128250,128251,128252,128253,128254,128255,128256,128257,128258,128259,130539,131862,131863,131864,132463,1895) 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 (65486,65396,65395,65385,64699,64696,64695,64118,64103,64102,64101,64100,64098,64097,64096,64094,64093,64092,64090,63324,63125,62375,62374,62299,62289,62288,62287,62286,62285,62284,62283,62282,62281,62280,62279,62278,62277,62276,62275,62274,62273,62272,62271,62270,62269,62268,62267,62266,62265,62264,62263,62262,62261,62260,62259,62258,62257,62256,62255,62254,62253,62252,62251,62250,62249,62248,62247,62246,62245,62244,61775,61774,61773,61772,61771,61770,61769,61768,61752,61751,61746,61741,61740,61729,61724,61233,61226,61225,61213,61169,60032,59819,59049,58578,57111,55116,55115,55108,55009,52966,52965,52587,52586,52585,52054,51297,51291,51264,51081,51080,51079,51078,51077,51076,51075,51074,51073,51072,44138,44134,43198,40526,40520,40519,35470,35299,34768,31982,31461,30466,30465,30464,30461,30458,30457,30456,30455,30454,30256,27352,19582,17435,15824,13696,12664,12585,11410,6697,3206,1059) 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 ( 65385,65395,65396,65486) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 7.6055526733398E-5
$time2: 0.0014700889587402
$time3: 0.0036730766296387
$time4: 0.0038869380950928
$time5: 0.015496015548706