Погрузчики

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (670,1977,2221,2481,2552,2600,2924,2945,3037,4099,84418,4573,4574,4575,1107,4576,91712,1120,4577,97717,98991,4579,98992,4581,4582,4585,4777,4785,4805,4855,7723,12556,76912,76975,1421,1422,77054,77055,1547,78235,78302,78450,78686,78744,78791,78794,78795,80661,80822,80823,81155,81338,81339,81340,81879,82122,82220,82472,82620,82908,82913,82914,83787,85396,85452,85453,85463,85551,85830,86946,87077,87393,88050,88393,88394,88607,88608,89543,89614,89616,89637,89733,91101,91730,93462,93681,94886,95185,95628,97709,98664,98842,98868,100160,100323,100324,102549,102571,102579,102605,105215,105784,105977,106379,106380,106960,106968,107213,107483,108607,108608,108609,108610,108611,108826,109009,109176,109197,109292,109320,110320,110861,110862,111547,112004,113386,113389,113757,116402,117162,117444,117848,117977,118071,118075,118076,118077,118078,118079,118180,118223,119189,119195,119780,120010,120140,120148,120572,120658,121095,132657,121862,132764,122248,133654,122835,133655,134044,125783,127053,126561,127055,127202,127258,127516,127517,128303,128348,128349,128376,128887,129201,129290,130960,131453,131454,131458,131460,131461,131466,131467,131468,131469,131470,131471,131472,131473,131474,131475,131476,131477,131671,132279,76974,78389,78391) 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 (65334,64852,64835,64834,64833,64832,64831,64830,64829,64828,64827,64826,64825,64824,64801,64662,64661,64655,64565,64013,63940,63828,63300,63211,63210,63204,63203,62423,62400,62161,61149,61023,60996,59986,59959,59958,59836,59120,59108,59040,59039,58464,58318,57218,57109,57031,57029,56790,55846,55702,55211,55210,54683,54680,54600,52185,51464,51062,51061,51060,50839,50329,50286,49542,48642,47416,47365,47364,47359,47358,46969,45790,45130,44266,44191,43215,43147,43128,42224,42223,42169,41691,41236,40832,40831,40647,40451,37742,37739,36980,36880,36781,36678,36675,35642,35298,34765,33965,31504,31321,31161,30923,30500,30104,30030,29662,27917,27897,27874,26844,26546,26277,25297,25272,25069,25040,24886,23994,23421,22613,22596,22139,22031,21737,21617,21594,21571,21522,20276,20275,19974,19848,19660,19595,19369,19076,19055,18840,18824,17858,17768,17391,16769,16540,16259,16245,16191,16081,15868,15730,15729,15728,15411,15387,15386,15316,14780,14293,14290,14215,14105,13390,12905,12420,12289,12288,12287,11002,10660,10658,10653,10652,10076,10075,9721,9720,8850,7963,7746,6790,6605,6518,5503,4865,3607,3560,3544,3232,3185,2165,2017,1520,641,640,229) 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 ( 64801,65334) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 8.4877014160156E-5
$time2: 0.00019001960754395
$time3: 0.0026528835296631
$time4: 0.0030629634857178
$time5: 0.010315895080566