| SELECT `News`.`id`, `News`.`tech_flag`, `News`.`parent_category_id`, `News`.`category_id`, `News`.`type_id`, `News`.`title`, `News`.`sub_title`, `News`.`lead`, `News`.`main_image_file_name`, `News`.`main_image_caption`, `News`.`body_text`, `News`.`written_name_flag`, `News`.`pv`, `News`.`prev_day_pv`, `News`.`current_day_pv`, `News`.`show_rank_flag`, `News`.`request_group_id`, `News`.`request_user_id`, `News`.`request_date`, `News`.`approval_user_id`, `News`.`approval_date`, `News`.`reject_user_id`, `News`.`reject_date`, `News`.`reject_reason`, `News`.`status`, `News`.`public_flag`, `News`.`pr_flag`, `News`.`tc_flag`, `News`.`display_flag`, `News`.`ad_flag`, `News`.`feed`, `News`.`media_feed`, `News`.`embargo_flag`, `News`.`embargo_date`, `News`.`public_date`, `News`.`public_status`, `News`.`rss_flag`, `News`.`rss_url`, `News`.`redirect_flag`, `News`.`redirect_url`, `News`.`job_keyword`, `News`.`feature_id`, `News`.`autosalon_flag`, `News`.`tas_p_category_id`, `News`.`tas_category_id`, `News`.`guid`, `News`.`delete_flg`, `News`.`created`, `News`.`creator`, `News`.`modified`, `News`.`modifier`, `ParentCategory`.`category_name`, `Category`.`category_name`, `User`.`user_name`, `User`.`nick_name`, `Group`.`group_name`, `Group`.`intro_text`, `Group`.`groupimage_file_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`.`id` = 10008845 LIMIT 1 | 1 | 1 | 0 | |
| 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,10001247,10001570,10001679,10001792,10002813,10003419,10003421,10005558,10006256,10006257,10006259,10008912,10011120,10001247,10001570,10001679,10001792,10002813,10002934,10003220,10003419,10003421,10003769,10004529,10005558,10006256,10006257,10006259,10008107,10008912,10011032,10011371,10011932,10014851,10014881,10000087,10000099,10001247,10001570,10001606,10001611,10001679,10001784,10001792,10002100,10002101,10002813,10002934,10003220,10003221,10003232,10003354,10003419,10003421,10003769,10004070,10004321,10004529,10005239,10005240,10005508,10005557,10006055,10006176,10006256,10006257,10006259,10006317,10006763,10007138,10007706,10007989,10008103,10008107,10008680,10008715,10008912,10008916,10009455,10009806,10009835,10009841,10009898,10009900,10010133,10010135,10010137,10010283,10010573,10010607,10010704,10010728,10010753,10010832,10011031,10011032,10011037,10011118,10011120,10011371,10011391,10011408,10011412,10011421,10011662,10011932,10011958,10012028,10012093,10012119,10012192,10012269,10012715,10013969,10014605,10014606,10014607,10014626,10014765,10014773,10015319,10015381,10015502,10015537,10015556,10015538,10015560,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10016064,10012314,10012663,10014295,10004590,10006983,10006988,10002845,10004505,10004590,10005697,10007911,10008681,10008710,10008711,10008730,10008788,10008797,10010083,10010725,10011830,10012715,10013603,10014146,10001697,10006256,10006257,10006259,10006642,10006670,10007793,10007837,10008694,10008779,10010880,10011790,10013522,10013715,10013720,10014157,10014296,10000425,10010211,10015139,10008707,10008722,10008755,10008756,10008772,10008795,10008796,10008799,10008809,10008813,10008922,10008941,10008951,10008973,10008976,10009013,10009076,10009164,10008771,10008793,10008534,10008563,10008697,10008699,10008768,10008783,10008808,10008862,10008866,10008913,10009006,10008676,10008679,10008680,10008683,10008692,10008719,10008721,10008792,10008822,10008842,10008850,10008917,10008678,10008680,10008681,10008693,10008695,10008696,10008733,10008785,10008788,10008797,10008798,10008846,10008848,10008849,10008873,10008910,10008911,10008916,10008691,10008777,10008779,10008794,10008912,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 3 | maybe slow |