Склады

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (2612,2080,2614,2811,3122,3157,3186,3188,122546,4083,3439,3737,588,3780,648,4665,5057,5270,5314,5315,5366,5367,5369,77000,12540,699,78740,77886,701,76302,76303,704,76735,76736,76737,77887,76738,76740,76742,76744,76745,76747,76748,76749,76989,76990,77116,83748,77117,77118,77119,83229,77120,77345,83749,77346,77445,77892,77893,77894,78634,1309,1310,1311,1755,77264,81144,81819,83033,83230,83231,83340,95020,83752,83753,87086,87536,87537,87539,87865,88064,89538,91725,91728,92410,103803,93097,93111,93112,93113,95018,97913,98974,100164,100687,100688,102307,103279,103280,103282,103283,127872,106041,107208,107543,108668,108786,109737,109738,110834,112328,112991,113402,115010,116824,116826,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,129942,130102,95019,105425,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 (65628,65606,65400,65284,65130,64673,63331,63159,63139,62578,61941,61788,61716,61448,61036,59495,59492,59490,59489,57301,57300,57299,57298,57130,57127,57126,57033,56577,56148,55238,54225,54041,53570,52995,52987,52686,52349,50184,49649,49525,47728,47717,46349,45798,44426,42245,42244,41965,41738,41067,41040,40696,40609,40315,39360,38602,37715,37297,36898,36897,36895,36894,34460,34066,31679,31236,31235,30487,29800,27933,27880,27739,27737,26788,26092,26091,26055,25083,25078,24518,23987,23965,23778,23759,22548,22150,22149,22040,21568,19987,19381,19338,19325,18722,16890,16849,16400,16036,16035,15823,15819,15708,15598,14953,14950,14846,14412,14212,12550,12415,12414,11512,11450,11448,11447,11077,11076,11036,10738,10737,10736,10734,10733,10731,10727,10219,9874,9104,9103,7822,7675,7648,7499,7280,7020,6879,6799,5605,5108,5038,4932,4815,3807,3369,2630,1883,1398,710,207) 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 ( 65284,65400,65606,65628) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 7.7009201049805E-5
$time2: 0.0015530586242676
$time3: 0.0036189556121826
$time4: 0.0051338672637939
$time5: 0.018249988555908