Грузовые авто

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (466,660,661,662,1869,663,1873,1981,1241,1308,1330,1419,3075,3076,3077,1471,1549,1551,78782,1973,1974,1759,2092,2093,2269,124963,2299,2300,3256,2482,2494,2942,2943,2944,3038,3039,3079,3160,3164,127854,127855,3267,3404,3421,76689,3422,3423,3424,3425,3426,3427,3428,76797,3576,3667,3669,77129,3697,3732,4097,4631,4632,4633,4639,4642,4643,4666,4644,4668,4854,4857,4920,5260,7721,76349,76350,76351,76417,76419,76493,76699,76700,76917,76701,76921,76857,76932,76933,76884,76934,76860,76885,76935,76936,76937,77041,77047,77048,77049,77053,77127,77057,77226,77227,77228,77229,77230,77231,77234,77235,77236,77237,77242,77246,77247,77248,77249,77251,77255,77281,77397,77398,77400,77406,77888,77889,77898,77908,77926,77927,77984,78206,78208,78211,78213,78216,78303,78314,78354,78356,78357,78358,78359,78360,78361,78362,78363,78364,78365,78366,78367,78368,78369,78370,78374,78375,78376,78377,78378,78379,78380,78381,78382,78383,78384,78385,78386,78439,78605,78606,78683,78684,78685,78690,78691,78692,78693,78694,78695,78696,78697,78698,78743,78789,78790,78931,79008,79012,79110,80346,80347,80348,80349,80350,80351,80353,80356,80357,80583,81373,81383,81384,81385,81386,81387,81388,81390,81394,81395,81438,81448,81453,81454,81455,81764,81853,81854,81859,81863,81983,82213,82214,82215,82216,82217,82219,82284,82285,82286,82845,83375,83379,84417,83824,85295,85296,85297,85390,85391,85392,85400,85404,86628,86755,87059,87073,87101,87148,87400,87401,87402,87403,87404,87518,87519,87520,87522,87523,87524,87525,87526,88066,88128,88229,88395,88883,89696,89860,89861,90241,90242,90244,90245,90246,90247,126421,90528,90550,90857,127259,91455,92117,92246,92675,92888,92889,92891,92892,92893,92894,92896,92898,92900,92903,93173,93455,93457,93458,93459,93745,93746,93747,93748,94286,94287,1710,1711,1712,1713,94885,95112,97641,97643,97644,97712,98038,98039,98040,98056,98855,98862,98865,98869,98917,98918,98919,98979,100130,100137,100141,100158,100917,100918,101203,102161,102162,102563,102564,102568,102569,102586,102587,102588,102590,102591,102593,103262,103269,103811,104214,104215,104216,104217,104218,104219,104221,104222,104375,104376,104377,104378,104769,104913,104914,105031,105205,105206,105207,106226,106393,132907,106397,132908,107491,132928,132929,132930,107899,133092,133613,108201,133614,108204,133615,108205,133616,133617,133677,133808,109268,133811,109270,133817,109275,133845,134577,109284,134578,109285,134579,134581,134582,109386,134583,134584,134585,110694,134586,110697,134587,110827,134588,110845,134589,110846,134590,110847,134591,110848,134592,110849,134593,110850,134594,110853,134595,110856,134596,110859,134597,110860,134598,134599,110872,134600,134601,110917,134602,111061,134603,111062,134604,111063,134605,134606,112001,134607,112002,134608,112777,134609,113220,134610,134611,113868,134612,134613,114917,134614,115229,134615,115801,134616,134617,116700,134623,116865,134624,134625,117167,117330,134626,117403,134627,117404,134629,117405,134630,117406,134631,117635,134632,117916,134633,117917,134634,118072,134635,119184,134636,119185,134637,119186,134638,119187,134639,119188,134640,119191,134641,119192,134642,119471,134643,119487,134644,119686,134645,120251,134646,120459,134647,120460,134648,120462,134649,120576,134650,120577,134651,120582,134652,121079,134653,121101,134654,121102,134655,121345,134656,121347,134657,121489,134658,121491,134659,121492,134660,121494,134661,121495,134662,121496,134663,122249,134849,122250,122251,122252,122253,122254,122564,122578,122595,123219,124675,125125,125129,126433,126518,126519,127708,127709,127856,127857,127858,127859,127916,128183,128322,128324,128337,128338,128967,129287,129288,130292,131292,131293,131294,131335,131459,131485,131722,131769,132432,132433,132434,132435,132499) 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 (65651,65623,65622,65621,65620,65619,65583,65582,65581,65538,65537,65489,65390,65279,65278,65277,65276,65275,65274,65273,65272,65271,65269,65268,65267,65266,65265,65264,65263,65262,65261,65260,65259,65258,65257,65256,65255,65254,65253,65252,65251,65250,65249,65248,65247,65246,65245,65244,65241,65240,65239,65238,65237,65230,65229,65228,65227,65226,65225,65224,65223,65222,65221,65220,65219,65218,65217,65216,65215,65214,65213,65212,65211,65210,65209,65208,65207,65206,65205,65204,65203,65202,65201,65200,65199,65198,65197,65196,65195,65194,65193,65192,65191,65092,65068,65067,65066,65064,65045,64819,64758,64746,64740,64737,64670,64663,64658,64653,64652,64459,64305,64197,64087,64086,64084,64060,64055,64054,64053,64033,64032,63796,63724,63596,63574,63540,63537,63497,63134,62581,62580,62222,62150,61964,61767,61393,61274,61265,61104,61086,60006,60005,59893,59880,59574,59342,59341,59121,58994,58992,58832,58311,58310,58108,58100,58048,57367,57153,56746,56362,56076,55888,55843,55706,55539,55207,55204,54475,53072,53002,52832,52831,52673,52310,52215,52191,52190,52189,52188,52187,52186,52029,51126,51000,50852,50225,50169,50099,49052,48963,48650,48639,48638,48634,48630,46370,46363,46360,45507,45465,45297,45183,44404,44403,44213,43984,43964,43910,43909,43908,43503,43388,43344,43208,43192,43185,43044,43043,42228,42227,42218,42160,42159,42083,42067,42066,42065,41951,41235,41231,41206,41083,41081,40884,40854,40842,40826,40816,40815,40331,39361,39080,39071,38599,38582,37684,37683,37681,37680,37679,37678,37569,37568,37117,37045,36987,35643,35635,35633,35632,35552,34754,34164,34161,34069,34068,33212,33211,32277,32274,31707,31147,31146,31144,31142,30944,30413,30280,30079,29902,29873,29872,29871,29796,29604,29558,28370,28198,28095,28094,27986,27985,27984,27930,27929,27928,27875,27822,27581,27579,27221,27161,27044,27039,27038,27037,27036,27035,27034,27027,27025,26715,26640,26567,26519,26516,26102,26096,26094,26093,25823,25751,25750,25745,25741,25735,25724,25707,25680,25326,24996,24922,24920,24885,24614,24613,24529,24504,24442,24441,24440,24439,24308,24305,24301,24300,24130,24127,23900,23869,23811,23754,23685,23548,23469,23445,23444,23424,22586,22338,22329,22328,22327,22324,22168,22147,22116,22012,22011,22010,22009,22007,21846,21842,21755,21754,21150,20328,20199,20162,20155,20074,20073,20072,20070,20065,20064,20023,20020,19989,19845,19783,19782,19781,19688,19545,19544,19543,19542,19541,19481,19270,19074,19069,19068,18847,18794,18747,18741,17857,17759,17758,17757,17503,17486,17484,17164,17163,17133,17049,16878,16627,16626,16625,16624,16623,16398,16397,16396,16295,16279,16247,16225,16224,16223,16179,16147,16145,16144,16066,16057,15594,15521,15480,15452,15445,15405,15404,15400,15398,15397,15314,15312,15311,15309,15282,15215,15053,15051,15050,15049,14814,14791,14781,14763,14757,14747,14746,14745,14744,14743,14742,14691,14688,14683,14603,14513,14433,14432,13624,13399,13396,13395,13375,13374,13371,13366,13282,13281,13280,13279,12927,12925,12922,12919,12882,12703,12673,12409,11972,11971,11969,11968,11946,11934,11933,11928,11927,11926,11914,11907,11841,11840,11824,11649,11647,11529,11528,11504,11503,11458,11041,10297,10285,10281,10070,10069,9937,9631,9616,9612,9486,9461,9259,9051,8072,8070,7971,7964,7915,7678,7527,7165,6877,6695,6448,6447,6196,6192,6157,6156,4985,4839,4758,4640,4339,4182,3922,3830,3655,3615,3613,3596,3552,3550,3549,3548,3495,3294,3231,3230,3229,2616,2248,1768,1767,1682,1414,1413,1214,1165,1040,975,930,672,638,516,222,219) 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 ( 65092,65191,65192,65193,65194,65195,65196,65197,65198,65199,65200,65201,65202,65203,65204,65205,65206,65207,65208,65209,65210,65211,65212,65213,65214,65215,65216,65217,65218,65219,65220,65221,65222,65223,65224,65225,65226,65227,65228,65229,65230,65237,65238,65239,65240,65241,65244,65245,65246,65247,65248,65249,65250,65251,65252,65253,65254,65255,65256,65257,65258,65259,65260,65261,65262,65263,65264,65265,65266,65267,65268,65269,65271,65272,65273,65274,65275,65276,65277,65278,65279,65390,65489,65537,65538,65581,65582,65583,65619,65620,65621,65622,65623,65651) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00017690658569336
$time2: 0.00047397613525391
$time3: 0.0052869319915771
$time4: 0.023663997650146
$time5: 0.093985080718994