$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (530,643,703,2609,3485,3738,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3861,3862,1158,3863,1159,3864,3865,3866,3867,3868,3869,3870,3871,3872,4085,4693,4839,4841,4842,4850,4955,1485,1521,1522,88392,1523,1524,1525,1526,1527,1528,1529,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5363,133647,76554,76555,76556,76557,76558,76559,76560,76561,76562,76563,76564,76567,76568,76569,76570,76571,76572,76573,76574,76575,76576,76577,76578,76579,76580,76581,76582,76583,76584,76585,76586,76587,76588,76589,76590,76591,76592,76593,76594,76595,76596,76597,76598,76599,76600,76601,76602,76604,76605,76607,76608,76609,76611,76612,76613,76614,76615,76616,76617,76618,76619,76620,76621,76622,76623,76624,76625,76626,76627,76628,76629,76630,76631,76633,76634,76635,76636,76639,76640,76642,76643,76645,76646,76647,76650,76649,76651,76653,76656,76660,76663,76664,76666,76687,76729,76730,76731,76732,77386,77389,77390,77391,78239,78240,83750,87075,87531,87867,89992,90933,93103,95368,95369,95370,95371,98908,100272,105028,108210,111589,111592,115957,119680,123414,124564,124565,125857,128383,129713,129714) 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 (64643,63896,62417,61562,61561,58312,57297,56438,55244,55243,49648,49231,45326,43870,42198,41693,41254,37643,35492,35301,34076,34074,31167,31166,30916,30902,30486,30250,30231,28358,28357,28342,28336,27744,27216,26843,26765,26763,24095,24094,24093,24092,24091,24090,24089,24087,24085,24084,24083,23981,23770,23756,21192,21165,21162,21159,21158,19311,19310,19308,19307,19299,19295,19294,19293,19292,19291,19290,19288,19287,19286,19283,19282,19281,19280,19277,19275,19273,15710,15699,15697,15692,15690,15678,15677,15671,15670,15667,15663,15660,15659,15657,15656,15654,15647,15645,15641,15640,15638,15635,15318,15317,14952,14715,14618,14616,14614,14613,14612,14611,14610,13324,13323,13322,13321,13319,13316,13251,13250,13229,13222,13221,13219,13206,13192,13190,13177,13172,13162,13161,13158,13157,13151,13150,12953,12762,12760,12745,11525,10834,10832,10753,10723,9802,9801,9795,9794,9793,9566,9565,9564,9563,9562,9561,9560,9559,9558,9557,9556,9555,9554,9553,9552,9551,9550,9549,9548,9547,9546,9545,9240,9239,9238,9237,9236,9235,9234,9010,9008,9007,8961,8960,8959,8947,8927,8926,8200,7593,6679,6671,6670,6668,6609,6269,4551,4241,2617,2251,2060,1945,1686,1685,202) 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 ( ) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 8.392333984375E-5
$time2: 0.0011749267578125
$time3: 0.003436803817749
$time4: 0.003436803817749
$time5: 0.0037980079650879
