$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (1069,2043,2044,2046,2047,2048,2049,2643,2646,2647,80342,80344,2649,3955,2650,2652,88599,2653,2657,88619,2658,2659,2660,3915,3916,3917,106961,107804,12532,76334,76335,76336,76337,76338,76339,76340,76341,76512,76513,76514,76515,76829,76830,76831,76832,76833,77273,77521,78029,78077,78078,78079,78154,78155,78156,128808,80345,81556,81773,81814,81815,82012,82013,82452,83078,83079,83080,83081,83897,84212,84310,85742,85993,86125,88618,88610,88625,88611,88620,93185,88621,93186,93188,93191,93452,95543,98910,98949,98950,100328,102209,105087,106387,106574,106575,106576,106823,106824,106864,108824,108825,108827,109190,109254,110399,110530,110535,110536,112655,113370,113371,115336,117287,118320,119470,122592,122555,123887,123888,124829,125123,127350,127351,127574,127575,4005,5294,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 (60722,59314,59313,61388,61387,56404,58680,61035,57097,59447,61193,48886,47770,59260,44486,43218,44003,49253,42229,41750,41749,41980,45451,38959,38629,38627,58679,39205,37205,38604,36628,36627,37591,36550,41748,37581,34642,30898,34592,30122,39079,61280,26812,25828,29653,24038,29651,30945,35311,20289,20288,35307,35306,26733,35305,20267,19267,19174,19040,19474,19584,17504,21288,21287,21286,19710,22363,16953,16099,16047,16046,17440,16954,16615,17495,17047,15593,14620,14619,13635,14969,12644,12643,12556,12254,14966,9492,10115,9357,9356,10114,9420,9419,9418,9417,8001,7952,10157,20080,20079,24534,17357,12984,13567,15418,9490,16901,6996,6705,7275,6703,2737,15590,2735,2734,15589,2729,2727,2726,2724,2723,2720,2740,1285,1284,2739,2738,1280,348) 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 ( 60722,61035,61280,61387,61388) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 7.4148178100586E-5
$time2: 0.0011920928955078
$time3: 0.0031089782714844
$time4: 0.0041351318359375
$time5: 0.01994514465332
Минская обл.
Прием заявок на участие в торгах
4 185,00 бел. руб.
12дн
191
Минская обл.
Прием заявок на участие в торгах
4 185,00 бел. руб.
12дн
196
Минская обл.
Прием заявок на участие в торгах
24 105,71 бел. руб.
22дн
2020
Минская обл.
Прием заявок на участие в торгах
172 540,54 бел. руб.
8дн
539
Минская обл.
Прием заявок на участие в торгах
19 507,66 бел. руб.
6дн
108