Дебиторская задолженность

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (468,469,470,471,472,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1768,2228,2229,2276,2363,2364,2402,2533,2946,2947,2948,2949,2950,3444,3685,4864,4874,4884,4898,5141,7675,12549,76315,76435,76500,76837,77002,77017,77021,77182,77183,77197,77315,77316,77317,77318,77319,77320,77321,77322,77323,77324,77325,77326,77327,77328,77329,77330,77331,77332,77333,77334,77335,77336,77337,77338,77339,77340,77341,77342,77343,77972,78089,78090,78091,78143,78144,78145,78146,78147,78148,78176,78178,78179,78245,78247,78337,78338,78339,78340,78567,78640,78642,78643,78644,78645,78646,78647,78648,78649,78650,78651,78652,78653,78654,78655,78656,78657,78658,78659,78660,78661,78662,78663,78664,78665,78666,78668,78670,78706,78708,78709,78710,78711,78712,78713,78714,78715,78716,78717,78718,78720,78751,78924,78926,78929,81631,81632,81633,82124,82801,82802,82803,82804,82805,83082,83083,83084,83085,83086,83306,83896,85547,85880,85881,85882,85883,88929,88930,88931,88932,88933,88934,88935,88936,88937,88938,88939,88940,88941,88942,88943,88944,88945,88946,88947,88948,88949,88950,88951,88952,88953,88954,88955,88956,88957,88958,88959,88960,88961,88962,88963,88964,88965,88966,88967,88968,88970,88971,88972,88973,88974,88975,88976,88977,88978,88979,88980,88981,88983,88984,88985,88986,88987,88988,88989,88990,88991,88992,88993,88994,88995,88996,88997,88998,88999,89000,89002,89003,89004,89005,89006,89007,89008,89009,89644,89645,89997,89998,89999,90000,90001,90002,90003,90004,90005,90006,90007,90008,90009,90010,90011,90012,90013,90014,90015,90016,90017,90018,90019,90020,90021,90022,90023,90024,90025,90026,90027,90028,90072,90073,90074,90075,90076,90077,90078,90079,90080,90081,90082,90083,90084,90085,90086,90087,90088,90089,90090,90091,90092,90093,90094,90095,90096,90097,90098,90099,90331,90332,90333,92125,92462,92463,92541,92542,92543,92544,92545,92546,92904,92905,92906,92907,92908,92909,92910,92911,92912,92913,93825,93826,95477,95879,95880,95881,95882,95883,95884,95885,95886,95887,95888,95889,95890,95891,95892,95893,95894,95895,95896,95897,95898,95899,95901,95902,95903,95904,95905,95906,95907,95908,95909,95910,95911,95912,95913,95914,95915,95916,95917,95918,95919,95920,95921,95922,95923,95924,95925,95926,95927,95928,95929,95930,95931,95932,95933,95934,95935,95936,95937,95938,95939,95940,95941,95942,95943,95944,95945,95946,95947,95948,95949,95950,95951,95952,95953,95954,95955,95956,95957,95958,95959,95960,95961,95962,95963,95964,95965,95966,95967,95968,95969,95970,96029,96030,96031,96032,96033,96034,96035,96036,96037,96038,96039,96040,96041,96042,96043,96044,96045,96046,96047,96048,96049,96050,96051,96052,96053,96054,96055,96056,96057,96058,96059,96060,96061,96062,96063,96064,96068,96069,96070,96071,96072,96073,96211,96212,97072,97073,97522,97523,98468,98690,98691,98711,98767,98768,98769,98770,98850,98880,98881,98882,98883,98884,98885,98886,98889,98890,98940,98941,100114,100146,100147,100304,100335,100336,100337,100338,100339,100340,100341,100342,100343,100344,100345,100346,100348,101468,101469,101470,101471,101472,101598,101599,101600,102211,102261,102262,102485,102486,102487,102488,102489,102490,102491,103383,103384,103385,103617,103894,104435,104436,104437,104483,104484,104485,104486,104487,104488,105216,105510,106122,106376,107259,107864,107951,108372,108373,108856,108857,109450,109451,109452,109830,109831,110088,110089,110291,110350,110829,111127,111129,111743,111744,111745,111746,111747,111748,111749,111750,111751,111752,111753,111754,111755,111756,111757,111758,111759,111760,111761,111762,111763,111764,111765,111766,111767,111768,111769,111770,111771,111772,111773,111774,111775,111776,111777,111778,111779,111780,111781,111782,111783,111784,111785,111786,111787,111788,111789,111790,111791,111792,111793,111794,111795,111796,111797,111798,111799,111800,111801,111802,111803,111804,111805,111806,111807,111808,111809,111810,111811,111812,111813,111814,111815,111816,111817,111818,111819,111820,111821,111822,111823,111824,111825,111826,111827,111828,111829,111830,111831,111832,111833,111834,111835,111836,111837,111838,111839,111840,111841,111842,111843,111844,111845,111846,111847,111848,111849,111850,111851,111852,111853,111854,111855,111856,111857,111858,111859,111860,111861,111862,111863,111864,111865,111866,111867,111868,111869,111870,111871,111872,111873,111874,111875,111876,111877,111878,111879,111880,111881,111882,111883,111884,111885,111886,111887,111888,111889,111890,111891,111892,111893,111894,111895,111896,111897,111898,111899,111900,111901,111902,111903,111904,111905,111906,111907,111908,111909,111910,111911,111912,111913,111914,111915,111916,111917,111918,111919,111920,111921,111922,111923,111924,112166,112279,112686,112687,112973,113739,113740,113741,113742,113743,113744,113745,113746,113747,113748,113749,113750,113751,114561,114683,115810,115811,115812,115813,115814,117617,117618,117619,117620,117621,117622,117623,117624,117625,117626,117627,117628,117629,117630,117631,117632,117633,118754,118755,118756,118791,119366,119569,120339,120340,120341,120342,120343,120344,120345,120346,120590,120888,120889,121104,121105,121106,121107,121108,121378,122517,122518,122519,122520,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122537,122538,122539,122540,122541,122542,122543,122544,122884,122973,123495,123496,123497,123498,123499,123500,123501,123502,123503,123504,123505,123506,123507,123508,123509,123510,123511,123512,123513,123514,123515,123516,123517,123518,123519,123520,123521,123522,123523,123524,123525,123526,123527,123528,123529,123530,123531,123532,123533,123534,123535,123536,123537,123538,123539,123540,123541,123542,123543,123544,123545,123546,123547,123548,123586,123587,123588,123589,123590,123591,123592,123593,123594,123595,123596,123597,123598,123599,123600,123601,123602,123603,123604,123605,123606,123607,123608,123609,123610,123611,123612,123613,123614,123615,123616,123617,123618,123619,123620,123621,123622,123623,123624,123625,123626,123627,123628,123629,123630,123631,123632,123633,123634,123635,123636,123637,123638,123639,123640,123641,123642,123643,123644,123645,123646,123647,123648,123649,123933,123936,124076,124077,124078,125065,125133,125398,125399,125400,125401,125445,125446,125570,125571,125572,126418,126720,128336,128731,128927,128969,128970,128971,128972,128973,128974,128975,128976,128977,128978,128979,128980,128981,128982) 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 (61444,61141,61140,61139,61126,61125,61124,61123,61122,61121,61120,61119,61118,61117,61116,61115,61114,61113,61088,60627,59946,59742,59741,59740,59739,59066,58772,58620,58619,58618,58617,58616,58615,58614,58613,58612,58611,58610,58609,58608,58607,58606,58605,58604,58603,58602,58601,58600,58598,58597,58596,58595,58086,57101,57100,57099,57028,57027,57026,57025,57024,57023,57022,57021,57020,57019,57018,57017,57016,57015,57014,57013,57012,57011,57010,57009,57008,57007,57006,57005,57004,57003,57002,57001,57000,56999,56998,56997,56996,56995,56994,56993,56992,56991,56990,56989,56988,56987,56986,56985,56984,56983,56982,56981,56980,56979,56978,56977,56976,56975,56974,56973,56972,56971,56970,56969,56968,56967,56966,56965,56964,56963,56962,56961,56960,56959,56958,56957,56956,56955,56954,56953,56952,56951,56950,56949,56948,56947,56946,56945,56944,56943,56942,56941,56940,56939,56938,56937,56936,56935,56934,56933,56932,56931,56930,56929,56928,56927,56925,56923,56922,56921,56920,56919,56918,56917,56916,56915,56914,56913,56912,56911,56910,56909,56908,56907,56400,55792,55254,55253,55252,55251,55250,54978,54977,54976,54975,54974,54973,54972,54465,52996,52625,52624,52623,52328,51891,51890,51889,51888,51887,51886,51885,51884,51883,51882,51881,51880,51879,51878,51877,51876,51875,51874,51873,51872,51054,50741,50740,50281,49614,48970,48802,46926,46925,46924,45282,45259,45258,44505,44504,44503,44502,44501,44500,44499,44498,44497,44496,44495,44494,44493,44001,43907,43691,43690,43664,42074,41577,41576,41575,41574,41573,41572,41571,41570,41569,41568,41567,41566,41565,41564,41563,41562,41561,41560,41559,41558,41557,41556,41555,41554,41553,41552,41551,41550,41549,41548,41547,41546,41545,41544,41543,41542,41541,41540,41539,41538,41537,41536,41535,41534,41533,41532,41531,41530,41529,41528,41527,41526,41525,41524,41523,41522,41521,41520,41519,41518,41517,41516,41515,41514,41513,41512,41511,41510,41509,41508,41507,41506,41505,41504,41503,41502,41501,41500,41499,41498,41497,41496,41495,41494,41493,41492,41491,41490,41489,41488,41487,41486,41485,41484,41483,41482,41481,41480,41479,41478,41477,41476,41475,41474,41473,41472,41471,41470,41469,41468,41467,41466,41465,41464,41463,41462,41461,41460,41459,41458,41457,41456,41455,41454,41453,41452,41451,41450,41449,41448,41447,41446,41445,41444,41443,41442,41441,41440,41439,41438,41437,41436,41435,41434,41433,41432,41431,41430,41429,41428,41427,41426,41425,41424,41423,41422,41421,41420,41419,41418,41417,41416,41415,41414,41413,41412,41411,41410,41409,41408,41407,41406,41405,41404,41403,41402,41401,41400,41399,41398,41397,41396,41240,41130,41114,41113,40911,40910,40863,40862,40861,40860,40859,40681,40680,40679,39605,39604,39224,39223,39220,39160,37292,37000,36978,36848,35653,35652,35651,35650,35649,35648,35647,35585,35584,35583,35582,35581,35580,35579,35562,35561,35560,35454,34767,34176,34175,34174,34173,34172,34171,33210,33209,33208,33207,33206,31983,31589,31588,31587,31090,30954,30953,30903,30052,30049,30048,30047,30046,30044,30040,29577,29576,28032,28018,28017,27895,27894,27891,27890,27889,27888,27887,27886,27885,27839,27220,27219,27218,27217,27123,27051,27050,27019,27018,27017,27016,27015,27014,27013,27012,27011,27010,27009,27008,27007,27006,27005,27004,27003,27002,27001,27000,26999,26998,26997,26996,26995,26994,26993,26992,26991,26990,26989,26988,26987,26986,26985,26984,26983,26982,26981,26980,26979,26978,26977,26976,26975,26974,26973,26972,26971,26970,26969,26968,26967,26966,26965,26964,26963,26962,26961,26960,26959,26958,26957,26956,26955,26954,26953,26952,26951,26950,26949,26948,26947,26946,26945,26944,26943,26942,26941,26940,26939,26938,26937,26936,26935,26934,26933,26932,26931,26930,26929,26928,26927,26926,26925,26924,26923,26922,26921,26920,26919,26918,26917,26916,26915,26914,26912,26911,26910,26909,26908,26907,26906,26905,26904,26903,26902,26901,26900,26899,26898,26897,26896,26895,26894,26893,26892,26394,26393,26322,26321,26033,26032,25690,25689,25625,25624,25623,25622,25621,25620,25212,25211,25210,25209,25208,25207,25206,25205,25204,25203,25202,25201,25200,25199,25198,25197,25196,25195,25194,25193,25192,25191,25190,25189,23975,23974,23973,23844,23843,23842,23841,23840,23839,23838,23837,23836,23835,23684,23683,23682,23681,23680,23679,23625,23624,23431,21907,21906,21905,21904,21903,21902,21901,21900,21899,21898,21897,21896,21895,21894,21893,21892,21891,21890,21889,21888,21887,21886,21885,21884,21883,21882,21881,21880,21879,21878,21877,21876,21875,21874,21873,21872,21871,21870,21869,21868,21867,21866,21865,21864,21863,21862,21861,21860,21859,21858,21857,21856,21855,21854,21853,21852,21851,21850,21849,21848,21624,21623,21275,21274,21273,21272,21271,21270,21269,21268,21257,21256,21254,21252,21250,21248,21247,21246,21245,21244,21243,21242,21241,21240,21239,21238,21237,21235,21234,21233,21232,21231,21230,21229,21228,21226,21225,21216,21215,21214,21213,21212,21211,21210,21209,21208,21207,21206,21205,21204,21203,21202,21201,21200,21199,21198,21197,19178,19177,19176,19098,19097,19096,19095,18856,18855,18785,18784,18783,18782,18781,17481,17334,17050,16872,16871,16870,16703,16702,14856,14632,14561,14560,14504,14503,14143,14142,14141,14140,14139,14138,14137,14136,14135,14134,14133,14132,14131,13692,13691,13690,13689,13688,13687,13686,13685,13684,13683,13682,13681,13680,13679,13678,13677,13676,13675,13674,13673,13672,13671,13670,13669,13668,13667,13666,13665,13123,13122,13121,13120,12968,12967,12776,12775,12774,12768,12767,12766,12765,12764,12763,12671,12670,12669,11963,11189,11188,11187,11186,11185,11184,11183,11182,11181,11180,11179,11178,11177,11176,11175,11174,11173,11172,11171,11170,11169,11168,11167,11166,11165,11164,11163,11162,11161,11150,11148,11001,10180,10018,9605,8087,7916,7874,7845,7680,7269,7104,6719,6698,6204,4819,3237,3236,3235,3234,3233,2256,1972,1910,1909,1729,1624,984,725,724,723,722,721,720,719,718,717,716,715,714,713,712,147,146,145,144,143) 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 ( 60627,61088,61113,61114,61115,61116,61117,61118,61119,61120,61121,61122,61123,61124,61125,61126,61444) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00022220611572266
$time2: 0.0049500465393066
$time3: 0.0095491409301758
$time4: 0.013701200485229
$time5: 0.051778078079224