Сельхозтехника

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (1072,1836,1837,1832,1833,87340,1834,88597,1835,88598,88606,89164,96216,96777,100322,104392,106867,106868,109174,109175,109180,91244,109294,110546,110547,112332,112333,112334,112335,112336,112337,112338,112339,112340,112343,112344,112773,112780,112781,113372,113373,113375,113999,116398,118321,121670,122565,121673,2916,2917,112775,121668,1071,86372,12559,12560,108374,108375,108376,85299,85300,85741,85992,86167,86332,86478,86479,86480,87381,87390,87391,83898,87392,87395,87396,87398,87777,88609,88612,88613,88614,91981,88615,93195,88617,93196,93197,93198,93199,93200,93201,93202,93203,93204,93205,93208,97721,97724,98841,98909,98911,98934,100149,100152,100153,100154,100155,100156,100330,106388,106389,106398,106399,106400,106865,106869,107484,107485,109169,109170,109171,109172,109173,109177,109178,109179,109181,109182,109183,109184,109185,109186,109187,109188,109191,109243,109244,109245,109246,109247,109248,109249,109250,109251,109252,109253,109256,109257,109258,109295,110537,110538,110539,110540,110541,112769,112986,112987,113384,113385,116399,122548,122551,122552,122553,122554,122585,122587,122588,122590,126724,121674,122594,129526,121675,4111,4112,4113,4114,4115,4116,4117,4118,4119,4120,4121,4122,4123,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,4143,4144,4145,4146,4147,4148,4149,4150,4151,4152,4153,4154,4155,4156,4157,4158,4159,4160,78409,110424,110425,110426,3411,3412,78800,82872,78801,82873,78802,2014,2986,2015,2987,3224,4802,7690,2016,78688,81195,1153,2017,2648,3700,78689,86371,2632,2641,2651,2633,2920,77922,76428,2923,102601,102604,1489,1544,80896,80897,81449,81871,81872,81873,81874,81875,81876,81877,82759,83865,86166,86627,86977,87388,87409,88616,88623,88624,88627,92521,93461,94521,94522,94523,94524,94525,94526,98677,98678,98679,98773,98947,98981,100150,100325,100326,100329,100331,100332,100735,106385,106386,106390,106962,109168,109189,109196,109198,109199,109200,109201,109202,109203,109204,109241,109242,109255,109259,109260,109261,109262,109263,109264,109265,109266,109267,109273,109274,109293,110542,110543,110544,112770,112771,112772,112786,119486,121660,121663,122547,122549,122550,122556,122557,122558,122559,122560,122593,1148,2640,2642,1424,2644,1546,2645,2654,2655,2656,2919,2981,4801,5352,12557,12558,76333,77307,77447,78212,78687,1068,78891,78892,80820,80821,80895,81371,81864,81865,81866,81867,81868,81869,81870,82765,82874,82912,87079,87389,87406,87779,87780,87782,87783,88129,113683,89615,89718,90849,90850,90853,90855,90858,90861,91100,93172,93178,93179,93180,93182,93183,93190,93192,93194,93460,95116,96778,96779,98668,98669,98670,98672,98673,98674,98676,98772,98912,98913,98942,98943,98944,98945,98946,98948,100134,100327,100333,101537,102562,102580,102581,102582,102583,104919,106378,106382,106383,106384,106391,106392,108828,109142,109143,109144,109145,109146,109147,109148,109149,109150,109151,109152,109153,109154,109155,109156,109157,109158,109159,109160,109161,109162,109163,109164,109165,109167,109741,109742,109893,110531,110532,110533,112653,112654,112762,112763,112764,113685,113686,116097,116098,116099,116401,119485,121081,121082,121661,121662,122583,122934,124827,125393,128812,128813,128814,128815,128816,128817,128818,128819,106866,109141,110545,112765,1154,112767,1155,112768,123879,123880,88626,1069,2043,2044,2046,2047,2048,2049,2643,2646,2647,80342,80344,2649,3955,2650,2652,88599,2653,2657,88619,2658,2659,2660,3915,3916,3917,106961,107804,12532,76334,76335,76336,76337,76338,76339,76340,76341,76512,76513,76514,76515,76829,76830,76831,76832,76833,77273,77521,78029,78077,78078,78079,78154,78155,78156,128808,80345,81556,81773,81814,81815,82012,82013,82452,83078,83079,83080,83081,83897,84212,84310,85742,85993,86125,88618,88610,88625,88611,88620,93185,88621,93186,93188,93191,93452,95543,98910,98949,98950,100328,102209,105087,106387,106574,106575,106576,106823,106824,106864,108824,108825,108827,109190,109254,110399,110530,110535,110536,112655,113370,113371,115336,117287,118320,119470,122592,122555,123887,123888,124829,125123,127350,127351,127574,127575,4005,5294,76361,78749,1066,1070,2045,86626,87394,87397,88622,97719,97723,98843,98844,100151,100321,109192,109193,109194,109195,110534,112766,88628,88629,122821,122822,122823,122824,122825,122826,122827,122828,122829,122830,122831,122832,122833,122834,113954,113955,113956) 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 (61388,61387,61386,61290,61280,61279,61264,61194,61193,61192,61191,61190,61189,61188,61176,61175,61035,60749,60748,60747,60746,60745,60744,60743,60742,60722,59826,59811,59734,59449,59448,59447,59446,59445,59314,59313,59260,58768,58750,58749,58748,58746,58740,58739,58737,58680,58679,58624,57376,57375,57097,56860,56858,56852,56404,56097,56060,55129,54448,54447,53630,52980,52979,52978,52977,52976,52975,52974,52973,52972,52971,52970,52969,52968,52967,52668,52665,52661,52351,51975,51314,50826,50825,50705,50701,50700,50699,50698,50697,50696,50695,50694,50693,50692,50691,50690,50689,50688,50687,50686,50085,49495,49253,48916,48915,48886,48885,48847,48846,48844,48841,48810,47770,47442,47441,47438,47405,47404,47402,47391,47388,47387,47386,46007,45787,45784,45783,45782,45781,45780,45779,45778,45777,45776,45775,45773,45772,45771,45508,45501,45500,45496,45495,45494,45493,45492,45491,45490,45489,45451,45441,45440,45430,45129,44486,44221,44204,44198,44194,44186,44180,44178,44175,44173,44011,44005,44004,44003,44002,43809,43688,43686,43685,43462,43461,43460,43425,43414,43411,43409,43408,43219,43218,43169,43159,43153,43146,43138,43137,43093,42233,42231,42229,42214,42205,42204,42203,42178,42177,42007,42006,42005,41980,41758,41753,41752,41750,41749,41748,41739,41662,41654,41630,41629,41624,41623,41619,41618,41604,41319,40686,40604,40603,40598,40596,40591,40590,40589,40588,40568,40567,39464,39390,39205,39112,39110,39079,39027,39007,38989,38981,38980,38978,38974,38973,38971,38970,38969,38968,38967,38963,38959,38936,38934,38930,38928,38926,38925,38922,38921,38920,38919,38917,38916,38914,38913,38912,38911,38629,38627,38606,38605,38604,38579,37591,37584,37582,37581,37580,37578,37577,37561,37332,37205,36982,36677,36649,36648,36645,36643,36642,36628,36627,36550,35613,35608,35607,35606,35600,35596,35591,35312,35311,35310,35309,35308,35307,35306,35305,35292,35291,34642,34592,34588,34146,34086,34043,31701,31700,31160,31157,31139,31138,31137,31136,31118,30947,30945,30922,30898,30831,30203,30122,30120,30118,30117,30116,30115,30111,30110,30108,30107,30105,30035,30032,30028,30027,29855,29853,29837,29682,29653,29651,29603,29602,29601,29599,29598,29596,29555,28703,28582,28372,28052,28046,28020,27701,27228,27227,27147,26842,26838,26837,26836,26835,26832,26831,26828,26827,26812,26740,26733,26579,26576,26564,26563,26562,26305,25841,25828,25742,25127,25126,25123,24786,24785,24784,24783,24782,24781,24633,24534,24477,24139,24058,24055,24045,24044,24042,24038,24033,24032,24030,24029,24028,23660,23621,23620,23618,23614,23587,23467,23464,23449,23448,23422,22643,22426,22409,22378,22363,22250,22246,22240,22237,22144,22089,21723,21291,21288,21287,21286,21279,20297,20294,20289,20288,20285,20283,20282,20280,20267,20264,20236,20080,20079,19859,19754,19741,19740,19739,19738,19737,19735,19734,19733,19732,19731,19725,19724,19710,19596,19584,19532,19531,19480,19479,19478,19474,19459,19458,19427,19425,19424,19422,19267,19174,19173,19057,19040,19039,17505,17504,17495,17440,17362,17357,17047,16954,16953,16901,16736,16735,16734,16617,16615,16182,16099,16079,16078,16077,16076,16075,16073,16072,16071,16070,16069,16047,16046,15737,15626,15593,15590,15589,15529,15464,15462,15418,15385,15384,14969,14966,14620,14619,14301,14299,13742,13741,13740,13635,13567,13336,12984,12926,12786,12644,12643,12556,12254,11154,11005,11004,11003,10157,10150,10115,10114,10038,9492,9490,9420,9419,9418,9417,9357,9356,9250,8459,8081,8001,7952,7865,7694,7275,6996,6705,6703,6556,6202,5574,5573,5572,5571,5570,5569,5568,5567,5566,5565,5564,5563,5562,5561,5560,5559,5558,5557,5556,5555,5554,5553,5552,5551,5550,5549,5548,5547,5546,5545,5544,5543,5542,5541,5540,5539,5538,5537,5536,5535,5534,5533,5532,5531,5530,5529,5528,5527,5526,5525,4937,4936,4833,4216,4215,3832,3771,3286,3285,3184,3181,3180,3178,3177,2744,2743,2742,2740,2739,2738,2737,2735,2734,2733,2732,2731,2729,2728,2727,2726,2725,2724,2723,2722,2721,2720,2719,2718,2717,2660,2659,2310,2309,2308,1285,1284,1282,1280,761,759,691,643,423,351,350,348) 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 ( 60722,60742,60743,60744,60745,60746,60747,60748,60749,61035,61264,61279,61280,61290,61386,61387,61388) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00020003318786621
$time2: 0.00054001808166504
$time3: 0.0044159889221191
$time4: 0.0090639591217041
$time5: 0.047747135162354