| 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` = 10018179 LIMIT 1 | 1 | 1 | 1 | |
| 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,10014605,10014606,10014607,10015950,10015457,10015456,10015455,10015999,10016026,10016589,10017542,10017543,10016668,10017573,10018120,10018030,10004590,10000088,10000099,10001606,10001611,10002263,10002266,10002856,10002877,10003232,10003787,10004070,10004912,10004987,10004991,10005486,10007074,10010621,10011412,10011421,10011662,10012936,10012949,10014084,10014105,10014132,10014133,10014134,10014585,10014649,10014658,10014841,10015006,10000087,10000158,10000168,10000255,10000309,10000321,10000425,10001069,10004979,10004980,10005119,10005135,10005200,10005532,10006166,10006695,10007071,10007950,10008723,10009582,10009690,10010460,10010966,10011031,10011037,10011371,10011725,10013498,10013731,10014541,10014605,10014606,10014607,10014631,10004332,10005833,10005869,10014841,10015136,10015319,10015229,10015502,10015537,10015556,10015538,10015560,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10015891,10016066,10016345,10016498,10017245,10017542,10017543,10017573,10018120,10018030,10014541,10000255,10000309,10007525,10007969,10014105,10015584,10016835,10018120,10018030,10017573,10017543,10017542,10012115,10012093,10012192,10013969,10014626,10015319,10015502,10015537,10015556,10015538,10015560,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10016345,10016429,10016372,10017245,10017542,10017543,10017573,10018120,10018030,10000088,10000844,10001697,10002013,10002089,10002141,10002156,10002972,10003870,10003903,10004987,10004991,10006080,10006663,10006667,10006827,10007936,10008702,10009414,10009470,10009538,10010447,10010452,10010649,10010906,10010996,10011406,10011740,10011931,10012956,10013549,10013827,10014603,10014683,10001697,10004511,10005221,10005339,10005425,10005994,10006115,10008713,10009408,10010456,10010460,10011006,10011008,10011693,10011725,10012622,10014631,10014824,10006164,10006361,10006890,10006923,10007820,10015229,10015455,10015456,10015457,10015578,10015772,10015984,10015996,10016104,10016357,10016424,10016485,10016484,10016498,10016497,10016835,10018120,10018030,10018625,10018461,10018618,10018118,10018592,10018554,10018325,10018502,10018507,10018540,10018403,10018424,10018411,10018356,10018335,10018272,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 6 | maybe slow |