$max_torgi_query: SELECT MAX(`id`) as `mtid`,`lotid` FROM `modx_auc_torgi` WHERE `modx_auc_torgi`.`lotid` IN (84447,84448,84460,84462,88533,88534,88540,90919,93530,93531,93553,93566,95464,95466,95467,95468,95469,95470,95471,95472,95473,95474,95475,133241,95562,96708,98765,98964,101473,101929,106590,106591,106601,106605,107019,108053,108056,110406,110407,110408,110409,110410,112175,112176,116158,119822,119823,120299,120300,122886,125622,125633,125639,125785,125789,125790,125833,125842,126872,126873,126874,126875,126876,126877,127302,127304,129516,129517,129518,129519,129520,129521,129522,129523,132131,132132,132133,132134,132135,132136,100007,100008,100009) 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 (64313,63669,63668,63667,63666,63665,63664,61385,61384,61383,61382,61381,61380,61379,61378,59171,59169,61688,61687,61686,61685,61684,61683,57276,59217,61411,61410,57219,57073,57067,57056,64128,52715,52714,55055,53120,59529,41872,41871,43361,52589,43359,43358,52588,44047,60630,39623,36580,36576,36566,36565,30776,54985,61541,54814,58235,29868,27211,29687,27345,31626,31625,31624,31623,31622,31621,31620,31619,31618,31617,30167,46780,28262,30358,30357,26074,26069,53797,23687,17902,21128,17888,17887) 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 ( 64313) ORDER BY `publishedon` DESC LIMIT 30 OFFSET 0
$getid:
$time1: 9.2983245849609E-5
$time2: 0.00014901161193848
$time3: 0.0022358894348145
$time4: 0.0024738311767578
$time5: 0.0072770118713379
Гродненская обл.
Прием заявок на участие в торгах
70 460,24 бел. руб.
20дн
90