| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`tech_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`public_date`, `News`.`category_id`, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', `ParentCategory`.`category_name`, `Category`.`category_name` FROM `mfdb`.`tb_news` AS `News` LEFT JOIN `mfdb`.`tb_news_category` AS `ParentCategory` ON (`News`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_news_category` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`News`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`News`.`request_group_id` = `Group`.`id`) WHERE ((`News`.`delete_flg` = '0') AND (`News`.`public_flag` = '1') AND (`News`.`status` = 2) AND (`News`.`public_status` = '1') AND (`News`.`id` IN (1,10000509,10000531,10000589,10000725,10000590,10000624,10000767,10000794,10000845,10000883,10000977,10000936,10000822,10001071,10001234,10001209,10001107,10001252,10001378,10001226,10000790,10001816,10001661,10001469,10001845,10001879,10001989,10001993,10002055,10002063,10002110,10002160,10002181,10002159,10002136,10002161,10002248,10002993,10002733,10002253,10002218,10002216,10002998,10003124,10003063,10003213,10003307,10003411,10002875,10002914,10003633,10003683,10003548,10003763,10003847,10003808,10003789,10003883,10003899,10003933,10004005,10004045,10004007,10004047,10003948,10003779,10004173,10004227,10004172,10004384,10004395,10004432,10004472,10004499,10004533,10004574,10004611,10004637,10004701,10004734,10004766,10004807,10004821,10004879,10004911,10004963,10005005,10005050,10004953,10005141,10005164,10005189,10005244,10005266,10005316,10005543,10005427,10005643,10005541,10005680,10005674,10005793,10005844,10005938,10006014,10005712,10006152,10006298,10006219,10006330,10006486,10006559,10006581,10006635,10006698,10006776,10006903,10007090,10007117,10007141,10007156,10007193,10007350,10007349,10007348,10007443,10007411,10007390,10007663,10007674,10007714,10007790,10007750,10007823,10007857,10007933,10007962,10007993,10008034,10008030,10005963,10008152,10008161,10005638,10008249,10008089,10008338,10008389,10008362,10008514,10008543,10008561,10008562,10008617,10008669,10008647,10008565,10008705,10008828,10008893,10008944,10000624,10000767,10000725,10000590,10000589,10000531,10000509,10000494,10000774,10000826,10000822,10000794,10000790,10000936,10001378,10001469,10001226,10001661,10001816,10001879,10001845,10001989,10001993,10002055,10002063,10002110,10001252,10001234,10001071,10001209,10002136,10002159,10002181,10002160,10002161,10002216,10002218,10002248,10002253,10002733,10002993,10002998,10003124,10003063,10003213,10003307,10003411,10002875,10002914,10003413,10003633,10003683,10003548,10003763,10003847,10003808,10003883,10003899,10003933,10004005,10004045,10004007,10004047,10003948,10003779,10004173,10004227,10004172,10001107,10004384,10004395,10004432,10004472,10004499,10004533,10004611,10004574,10004637,10004701,10004734,10004766,10004879,10004911,10004963,10005005,10005050,10004953,10005141,10005189,10005164,10005244,10005266,10005316,10005543,10005427,10005643,10005541,10005674,10005680,10005793,10005844,10005938,10005887,10005933,10006014,10006152,10006298,10006219,10006330,10006486,10006559,10006581,10006635,10006903,10006962,10007018,10007062,10007090,10007117,10007141,10007267,10007349,10007348,10007350,10005674,10005680,10005541,10005452,10005316,10005244,10005189,10005141,10004953,10005543,10004611,10004533,10004472,10004395,10004334,10004227,10003779,10004047,10004045,10003899,10003883,10003802,10003763,10003661,10005140,10005715,10005720,10005716,10005639,10005691,10005752,10005729,10005682,10005690,10005651,10005602,10005503,10005232,10005231,10005294,10005228,10005225,10005226,10005247,10005033,10005075,10004952,10004881,10005020,10004738,10004937,10004904,10004859,10003399,10004854,10004849,10004736,10004757,10004758,10004760,10004759,10004754,10004755,10004661,10004629,10001299,10004566,10004565,10004481,10004412,10004407,10004405,10005758,10005756,10005793,10005786,10005576,10005556,10005464,10005451,10005219,10005159,10005076,10004191,10003678,10004076,10003845,10005774,10005760,10005844,10005857,10005938,10005887,10005933,10005921,10005935,10005893,10005636,10005608,10005186,10005137,10005500,10004942,10004944,10003750,10006014,10006088,10004836,10005388,10005418,10005369,10006071,10006120,10006219,10006163,10006161,10006215,10006213,10006145,10006148,10006251,10005870,10006298,10006330,10006367,10006352,10006348,10006300,10006378,10006486,10006496,10006489,10006487,10006466,10006559,10006575,10006573,10006543,10006468,10006581,10006608,10006635,10006698,10006755,10006657,10006723,10006719,10006720,10006776,10006762,10006782,10006829,10006907,10006898,10006892,10006869,10006903,10005674,10005643,10005452,10005427,10005266,10005195,10005193,10005190,10005050,10004963,10004879,10004766,10004734,10004637,10004574,10004499,10004432,10004384,10004172,10004173,10003948,10004007,10004005,10003933,10003883,10003808,10003789,10003548,10002746,10003124,10002998,10002733,10001661,10001378,10001209,10000883,10000826,10000767,10000624,10000725,10000590,10005680,10005670,10005636,10005646,10005660,10005656,10005648,10005653,10005642,10005623,10005634,10005629,10005752,10005731,10005724,10004760,10005294,10004755,10005758,10005756,10005793,10005715,10005576,10005556,10005464,10005219,10005159,10004198,10003678,10004076,10005774,10005760,10005844,10005857,10005938,10005887,10005933,10005893,10005829,10005608,10005186,10005137,10005500,10004942,10004944,10003750,10002873,10006014,10005935,10006088,10004836,10005388,10005418,10005369,10006071,10006165,10006152,10006161,10006160,10005712,10006219,10006163,10006215,10006213,10006145,10006148,10005792,10006251,10005870,10006298,10006330,10006367,10006352,10006348,10006225,10006300,10006378,10006486,10006496,10006489,10006487,10006466,10006442,10006559,10006573,10006468,10006517,10006581,10006608,10006635,10006698,10006703,10006702,10006700,10006691,10006776,10006715,10006762,10006829,10006796,10006903,10006927,10006962,10006958,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 7 | maybe slow |