Офисная мебель

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (80515,80516,80540,83261,84465,5039,88600,88601,88602,88603,88604,88605,90916,90917,90918,90927,133137,133138,133139,133146,133205,133206,133207,133208,134095,134126,134134,134159,134160,134161,101705,134179,134180,134181,134182,134183,134184,134189,134190,134197,134202,134203,134204,134205,107016,107017,107020,115498,115499,115500,119867,121003,121004,121005,121006,121360,125851,127273,127274,129947,129948,129949,132006,87657,99848,100060) 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 (64987,64986,64985,64984,64979,64972,64971,64966,64965,64964,64963,64962,64961,64943,64942,64941,64916,64908,64877,65454,65453,65452,65451,65422,65417,65416,65415,63560,61979,61978,61977,59141,59140,59229,56375,58273,56463,58272,58271,56512,45005,45004,45003,54471,54469,54468,30595,61545,61516,26082,26073,26072,26071,26731,26730,26729,34136,26727,25117,25653,44810,64682,22626,19503,19502,14512) 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 ( 64877,64908,64916,64941,64942,64943,64961,64962,64963,64964,64965,64966,64979,64984,64985,64986,64987,65415,65416,65417,65422,65451,65452,65453,65454) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 8.6069107055664E-5
$time2: 0.00073909759521484
$time3: 0.0032269954681396
$time4: 0.0080671310424805
$time5: 0.069077014923096