Магазины, кафе, рестораны

$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (2554,2953,2135,2423,4079,2630,3130,3134,4369,3135,3463,3464,76304,3831,3842,4088,76889,76669,4753,76670,77300,77312,7663,7664,77491,77880,78638,7665,7666,7728,702,7729,7730,7733,7734,76521,1075,1077,76988,76997,76998,76999,77933,77934,77935,78250,1112,83637,78549,78726,78742,78907,78921,81818,83237,84284,84286,87864,90260,90938,90939,90940,91713,91714,93388,94044,102709,1444,98898,98899,98900,103058,1479,98901,98902,98903,98904,98905,112472,112473,112474,100274,100318,102306,1750,106876,123770,1751,107579,120149,107901,1753,108886,120456,109005,120885,109006,109007,109102,122580,124612,111307,132271,112689,112785,112990,114919,114920,114921,114922,114923,114924,114925,114926,114927,114928,1848,114929,114930,114931,115305,116309,116375,116376,116377,116378,116379,88402,116380,88403,116381,116382,116383,116384,116385,116386,116387,132839,116388,116389,116390,132623,116391,132624,116392,132625,116393,116394,133055,116395,133063,116827,133064,116828,133065,116829,133328,116830,133547,117673,134732,117674,134957,118318,118319,118324,119669,119670,119671,119672,119673,119674,119675,119676,119677,119678,119679,119682,119683,119684,119685,119687,119778,120348,120884,121209,121281,121458,121459,121460,121461,121462,121463,121464,121465,121466,121467,121468,121469,121470,121471,121472,121473,121474,121475,121476,121477,121478,121479,121480,121481,121482,121483,121484,121485,121486,121487,121502,122007,122432,122579,123134,123135,123136,123882,125290,125291,125292,125945,126863,127205,127206,127207,127208,127209,127210,128027,128030,130022,130103,131592,131706,132282) 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 (65615,65614,65613,65610,65609,65608,65607,65591,65588,65485,65442,65343,65243,65131,65107,65071,65070,65069,64858,64797,64672,64557,64402,63484,63418,63368,63303,62495,62298,62233,62232,61988,61973,61972,61971,61963,61961,61960,61959,61958,61957,61956,61955,61954,61953,61952,61950,61949,61948,61947,61946,61945,61944,61943,61942,61820,61145,61143,59932,59931,59930,59919,59918,59901,59898,59897,59892,59891,59890,59889,59888,59887,59886,59885,59884,59883,59882,59881,59879,59878,59877,59876,59875,59874,59873,59872,59871,59870,59869,59868,59867,59384,59125,59116,59045,59042,59008,59006,58306,58030,58029,58028,58004,57678,57032,56836,56835,56576,56390,56333,56332,56327,56326,56061,55884,55183,55161,55160,55012,54601,52994,52993,51393,51091,51082,51013,50870,50097,49622,49236,49233,49230,49228,49221,49220,47790,47726,47725,46982,46352,45767,45766,45759,45758,45757,45754,45753,43983,43982,43981,43780,42031,41044,39500,38894,37302,36971,36661,35559,35558,35557,35556,35555,35554,35511,34790,34456,31648,31356,31063,30713,30219,30218,27936,24507,24124,22598,22597,22333,22287,22027,20176,20175,17679,17677,17436,17329,17327,17326,16699,16696,16109,15822,15713,14951,14899,14845,14549,14437,14218,14213,13551,13550,13549,13255,12971,12970,12969,11891,11759,11513,11078,11035,9432,9412,9411,9410,9409,9408,7941,7758,7753,7668,7667,7665,7272,7270,7001,5845,5095,4088,3696,3694,3064,2986,2657,2354,2055,1482,1023,1022,354) 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 ( 65131,65243,65343,65442,65485,65588,65591,65607,65608,65609,65610,65613,65614,65615) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 0.00011491775512695
$time2: 0.0014169216156006
$time3: 0.0041580200195312
$time4: 0.008173942565918
$time5: 0.042155981063843