Самосвалы

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (2267,2553,1880,2974,3069,4636,4649,78777,1550,4652,4653,1104,4771,4772,4780,76929,76930,76931,77046,77061,1156,77087,1306,77295,77502,78311,78312,78438,78778,80352,80355,81445,81446,81447,81451,81856,81860,82482,82870,83077,85291,85294,85393,85402,85831,85832,85833,85834,85835,87076,87080,87385,87788,89610,89638,89639,89640,89641,90852,90854,91729,92890,92895,92897,92901,93987,93988,95360,98857,103268,103388,103389,104768,106381,106685,106689,107205,107490,109269,109272,109282,109283,109286,109287,109288,109930,109932,110852,110857,110858,111986,111987,111988,111989,111990,111991,111992,111993,111994,111995,111996,111997,113289,115230,116400,116978,117166,117409,117410,117411,117412,117413,76858,119230,76859,120334,121080,121089,121346,122596,122933,123889,124513,77050,126517,127107,127108,127571,127710,132914,127711,132915,127712,132916,127713,132917,127714,133809,127715,133813,127716,133847,127717,134848,127718,135064,127719,127720,127721,127722,127723,128024,128185,128186,128187,128339,128340,128341,128342,128343,128344,131487,131723,131724,131725,131726,77910,87078,128184) 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 (65652,65536,65391,65049,65046,64760,64742,64738,64440,64061,64042,64041,64040,64039,63502,63501,63500,63499,63345,63344,63343,63235,62441,62434,62433,62432,62431,62430,62429,62405,62134,62133,62132,62131,61815,61813,61812,61811,61806,61805,59546,59352,59347,59310,59127,59053,59052,58011,55705,54464,52745,52674,52314,52313,51023,50230,50229,50228,50227,50226,49498,46557,45795,45178,45177,45176,45175,45174,45173,45137,44229,44228,43285,43280,43279,43278,41669,40877,40875,40827,39593,39402,39021,39020,39019,39015,39005,39002,37698,37007,37006,36986,36655,36619,36615,35589,35505,34454,29869,27863,27042,26103,25740,25738,25325,25324,25062,23972,23806,23804,23468,23443,22612,22563,22555,22554,22553,22552,22410,22408,21588,21519,21285,21284,21283,21282,21281,21280,19728,19657,19230,17496,16550,16063,16059,15494,15443,15055,14790,14789,14276,13423,13365,11632,11435,11434,11143,10302,10292,10123,10082,10072,10068,9428,9427,9244,9230,6521,6513,6177,6176,4883,4866,3854,1976,1047,544,431,382) 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 ( 65391,65536,65652) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00011706352233887
$time2: 0.0016491413116455
$time3: 0.0039210319519043
$time4: 0.0049030780792236
$time5: 0.015353202819824