$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (482,2612,2095,3119,3120,2080,3131,2081,2082,3408,2405,2614,2811,2990,3122,3123,3142,3148,3150,3152,3157,3833,3186,3188,3189,122546,3265,4083,3439,3727,3737,3773,3774,588,3775,3776,3777,3778,3779,3780,3781,645,3782,3786,3789,648,3810,3910,3912,4665,4847,12546,5056,5057,5270,5314,672,5315,5366,5367,5368,5369,77000,679,12540,12542,699,78740,77886,701,76302,76303,76507,704,79054,76735,76736,76737,77887,76738,76739,76740,76741,76742,76743,76744,76745,76746,76747,1090,76748,76749,76791,76871,1948,76989,76990,77116,83748,77117,77118,77119,83229,77120,77135,83233,77345,83234,83749,77346,83235,84025,77445,83236,77882,77892,77893,77894,78634,1309,1310,1311,1487,1728,1755,77264,81144,81819,82581,83031,83033,83230,83231,83340,95020,83752,83753,85409,85413,85416,87086,87535,87536,108654,87537,87539,87865,88064,89309,89538,90475,91725,91728,92410,92468,103803,92469,92882,93097,93111,93112,93113,93687,94305,94588,95018,95083,97913,98971,98974,100164,100687,100688,102307,102432,103278,103279,103280,103281,103282,103283,103285,103286,103287,127872,104771,106041,106230,106232,107208,107543,108655,108668,108786,108787,109002,109003,109737,109738,110431,110433,110434,110834,111095,111096,111309,111311,112328,112991,113402,115010,116101,116824,88405,116826,88406,117294,117332,118278,118280,120508,120509,120510,89546,120512,120515,121338,121645,122603,122841,125720,90934,125721,125724,125858,125859,125860,125861,125942,126919,127204,127308,128378,93110,128650,95019,100920,105425,105428,105429,106120,110435,110436,120052) 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 (61604,61448,61341,61278,61271,61255,61187,61166,61164,61036,60014,59987,59495,59492,59490,59489,59232,57301,57300,57299,57298,57130,57127,57126,57033,56577,56148,55238,54225,54041,53570,52995,52987,52686,52349,51411,50186,50184,49649,49525,49477,48815,48362,48306,47728,47717,46813,46349,45798,44426,44262,44261,43797,43796,43794,43342,43057,42245,42244,41965,41738,41067,41046,41040,40903,40892,40696,40609,40518,40315,39360,39173,39172,38760,38759,38602,38568,38567,37715,37297,36902,36901,36900,36898,36897,36896,36895,36894,36893,36584,34464,34460,34126,34066,31679,31236,31235,31069,30487,30080,29800,27933,27880,27779,27778,27777,27776,27739,27737,26788,26749,26748,26513,26092,26091,26055,25217,25216,25083,25078,24630,24518,24434,24260,23987,23965,23778,23759,22548,22285,22150,22149,22040,21568,21534,19987,19699,19698,19697,19477,19381,19338,19325,18853,18843,18819,18816,18812,18722,16890,16849,16847,16400,16036,16035,15823,15819,15708,15598,14953,14950,14846,14418,14414,14412,14212,13247,13245,12550,12523,12415,12414,11555,11512,11450,11448,11447,11077,11076,11036,10738,10737,10736,10735,10734,10733,10731,10730,10727,10219,10034,9874,9451,9364,9254,9104,9103,9028,7960,7862,7860,7822,7675,7648,7643,7641,7634,7499,7280,7020,7002,6879,6799,6677,6326,6323,5605,5108,5068,5047,5044,5040,5039,5038,5037,5036,5035,5034,5033,5032,5031,4932,4890,4815,4394,4387,4384,4223,3917,3807,3369,3188,2630,2122,1883,1451,1400,1399,1398,944,710,207,204,134) 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 ( 60014,61164,61271,61278,61341,61448,61604) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 8.2015991210938E-5
$time2: 0.0014991760253906
$time3: 0.0038080215454102
$time4: 0.0050690174102783
$time5: 0.02603006362915
Гродненская обл.
Прием заявок на участие в торгах
66 240,00 бел. руб.
8дн
1123
Витебская обл.
Прием заявок на участие в торгах
1 390,00 бел. руб.
374дн
3066
Могилёвская обл.
Прием заявок на участие в торгах
176 202,00 бел. руб.
13дн
1039
Минская обл.
Прием заявок на участие в торгах
690 000,00 бел. руб.
2дн
6552
Витебская обл.
Прием заявок на участие в торгах
3 005,57 бел. руб.
5дн
665