| 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` = 10008161 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,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,10006439,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,10005638,10008249,10008089,10008338,10008389,10008362,10008514,10008543,10008561,10008562,10008617,10008669,10008647,10008565,10008705,10008828,10008893,10008944,10006962,10006958,10007018,10007062,10007090,10007117,10007141,10007156,10007134,10007193,10007267,10007350,10007349,10007348,10007242,10007264,10007443,10007411,10007390,10007663,10007674,10007714,10007727,10007718,10007072,10007677,10007653,10007790,10007750,10007823,10007857,10007841,10007917,10007387,10007384,10006631,10007933,10007962,10007993,10007986,10007985,10007902,10007833,10007976,10008034,10008030,10005963,10008152,10008178,10008147,10008123,10008067,10008106,10008094,10008217,10008200,10008199,10008138,10007671,10008222,10005638,10008249,10008089,10008338,10008389,10008362,10008514,10008543,10008561,10008562,10008617,10008669,10008647,10008664,10008565,10008705,10008828,10005772,10004924,10008893,10008944,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 4 | maybe slow |