$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (779,780,781,782,783,2519,2520,1103,2681,2918,2975,92245,7688,1151,76688,76918,76919,77039,77040,77124,77132,1384,77895,78214,1539,78301,81025,82225,1552,1556,82481,83862,87094,87100,87102,90538,90539,102566,103263,104839,106042,106233,109135,109166,109300,109318,110864,112016,112017,113768,116124,116656,116657,116658,116659,116682,116683,116684,116985,116991,117023,117842,117843,117844,117846,117853,117854,117856,117859,117863,117869,117872,117873,117874,117879,117887,117902,117908,117914,117919,117931,117934,117938,117957,117996,118007,118014,118021,118022,118026,118794,118797,118798,118799,118800,118220,118801,118221,118802,118803,118804,118806,118808,118812,118828,119621,119622,119623,119624,119628,119639,119642,119643,119644,119648,119655,119659,119660,119661,119662,119663,119664,119665,119666,119667,119668,120587,121083,121343,121604,122009,122101,122102,122107,122120,122121,122122,123811,123812,123825,125862,127844,127845,127846,127847,127964,127965,129289,129754,129755,129756,129757,129758,129759,129760,129761,131032,131058,131059,131720,131721,5333,76411,77488,123826,123827) 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 (64182,64082,63531,63341,63340,62964,62963,62952,62951,62885,62884,62883,62882,62881,62880,62879,62878,62877,62876,62875,62874,62864,62863,62805,62804,62802,62801,62800,62797,62772,62756,62754,62749,62747,62672,62669,62650,62649,62648,62625,62624,62623,62622,62523,62522,62496,61871,61664,61663,61662,61661,61660,61659,61657,61656,61249,60545,60519,60512,60511,60510,60507,60187,60176,60175,60142,60141,59507,59470,59469,59367,58530,58507,58500,58494,58460,58459,58458,58412,57992,57991,57844,57314,57313,57302,56824,56757,56748,56740,56736,56726,56718,56716,56706,56704,56691,56608,56584,56583,56361,54445,54428,54337,54192,54179,54178,54110,54103,54102,53694,52369,51974,51263,50254,48172,44174,43956,43737,43492,43058,41957,40834,39063,39047,37646,31122,25059,23547,22421,22126,22125,19685,19683,18850,17500,16549,16262,15968,14695,13084,12650,11962,11766,11425,10235,10106,10061,9614,9245,8064,7692,7569,7524,7523,5000,4884,3481,3179,1793,426,381,342,341,340,339,338) 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 ( 64182) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 8.392333984375E-5
$time2: 0.0016639232635498
$time3: 0.0037031173706055
$time4: 0.0039680004119873
$time5: 0.0086770057678223