| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `KeywordDictionary`.`id`, `KeywordDictionary`.`title`, `KeywordDictionary`.`body_text` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` WHERE `KeywordDictionary`.`delete_flg` = '0' AND `KeywordDictionary`.`public_flag` = '1' AND `KeywordDictionary`.`status` = 2 AND ((`KeywordDictionary`.`public_date` <= '2026-06-11') OR (`KeywordDictionary`.`public_date` IS NULL)) AND `KeywordDictionary`.`id` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` = 3) ORDER BY RAND() ASC LIMIT 3 | 3 | 3 | 2 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`public_date`, `Group`.`group_name`, (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` 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_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`.`tech_flag` = '0' AND `News`.`public_flag` = '1' AND `News`.`status` = 2 AND `News`.`show_rank_flag` = 1 AND `News`.`public_status` = '1' ORDER BY `News`.`current_day_pv` DESC LIMIT 5 | 5 | 5 | 62 | maybe slow |
| 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`, `Group`.`group_name`, (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 (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` IN (1,2)) ORDER BY `News`.`current_day_pv` DESC LIMIT 10 | 10 | 10 | 1 | maybe slow |
| SELECT DISTINCT `Catalog`.`brand_name`, `Catalog`.`car_name`, `Catalog`.`cat_id`, `Catalog`.`car_cd`, `Catalog`.`brand_name_en`, `Catalog`.`price`, `Catalog`.`photo_main` FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE 1 = 1 ORDER BY `Catalog`.`year_cd` DESC LIMIT 8 | 8 | 8 | 0 | |
| SELECT `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Car`.`car_nm`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`image_path`, `Car`.`car_cd` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE `Car`.`car_cd` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site`=6) ORDER BY RAND() ASC LIMIT 8 | 5 | 5 | 1 | maybe slow |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` IN (10052002, 35201531, 10452019, 10552002, 10201018) | 26 | 26 | 0 | |
| SELECT `SerialStory`.`id`, `SerialStory`.`title`, `SerialStory`.`url_text`, `SerialStory`.`description`, `SerialStory`.`main_image_file_name`, `SerialStory`.`article_top_flag`, `SerialStory`.`article_detail_flag`, `SerialStory`.`tech_top_flag`, `SerialStory`.`tech_detail_flag`, `SerialStory`.`bikes_top_flag`, `SerialStory`.`bikes_detail_flag`, `SerialStory`.`sort_no`, `SerialStory`.`delete_flg`, `SerialStory`.`created`, `SerialStory`.`creator`, `SerialStory`.`modified`, `SerialStory`.`modifier` FROM `mfdb`.`tb_serial_stories` AS `SerialStory` WHERE `SerialStory`.`delete_flg` = '0' ORDER BY `SerialStory`.`sort_no` asc | 28 | 28 | 0 | |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1019 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1032 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1026 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1013 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 0 | |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1014 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT
SerialStoryDetail.sort_no,
News.id,
News.title,
News.lead,
News.pr_flag,
News.main_image_file_name,
News.parent_category_id,
News.public_date,
News.category_id,
News.tech_flag,
(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
tb_serial_story_detail AS SerialStoryDetail
LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id)
LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id)
LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id)
LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id)
LEFT JOIN 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 SerialStoryDetail.story_id=1015 AND ((News.public_date <= '2026-06-11 23:02:24') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`menu_text`, `Menu`.`link_url`, `Menu`.`target_type` FROM `mfdb`.`tb_menu` AS `Menu` WHERE `Menu`.`delete_flg` = '0' AND `Menu`.`parent_menu_id` = 0 AND `Menu`.`site_flag` = 0 ORDER BY `Menu`.`sort_no` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `ChildMenu`.`id`, `ChildMenu`.`menu_text`, `ChildMenu`.`link_url`, `ChildMenu`.`target_type`, `ChildMenu`.`parent_menu_id` FROM `mfdb`.`tb_menu` AS `ChildMenu` WHERE `ChildMenu`.`delete_flg` = '0' AND `ChildMenu`.`parent_menu_id` IN (12, 17, 14, 13, 15, 16, 19, 57) ORDER BY `sort_no` ASC | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_news` AS `News` WHERE `News`.`id` = 10000119 | 1 | 1 | 0 | |
| 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` = 10000119 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `NewsDetail`.`id`, `NewsDetail`.`articles_id`, `NewsDetail`.`detail_type`, `NewsDetail`.`detail_title`, `NewsDetail`.`detail_image_file_name`, `NewsDetail`.`detail_image2_file_name`, `NewsDetail`.`detail_link`, `NewsDetail`.`detail_text`, `NewsDetail`.`sort_no` FROM `mfdb`.`tb_news_detail` AS `NewsDetail` WHERE `NewsDetail`.`articles_id` = (10000119) ORDER BY `sort_no` ASC | 9 | 9 | 0 | |
| SELECT `NewsImage`.`id`, `NewsImage`.`articles_id`, `NewsImage`.`detail_type`, `NewsImage`.`image_file_name`, `NewsImage`.`image_file_ext`, `NewsImage`.`image_caption`, `NewsImage`.`image_alttext`, `NewsImage`.`image_link`, `NewsImage`.`sort_no`, `NewsImage`.`created`, `NewsImage`.`creator` FROM `mfdb`.`tb_news_images` AS `NewsImage` WHERE `NewsImage`.`articles_id` = 10000119 ORDER BY `NewsImage`.`created` ASC | 0 | 0 | 0 | |
| SELECT `LinkInfo`.`id`, `LinkInfo`.`article_id`, `LinkInfo`.`article_flag`, `LinkInfo`.`target_flag`, `LinkInfo`.`target_id` FROM `mfdb`.`tb_link_info` AS `LinkInfo` WHERE `LinkInfo`.`article_flag` = 1 AND `LinkInfo`.`article_id` = 10000119 ORDER BY `LinkInfo`.`target_flag` ASC, `LinkInfo`.`id` ASC | 11 | 11 | 0 | |
| SELECT `KeywordOther`.`id`, `KeywordOther`.`title` FROM `mfdb`.`tb_keyword_other` AS `KeywordOther` WHERE ((`KeywordOther`.`delete_flg` = '0') AND (`KeywordOther`.`public_flag` = '1') AND (`KeywordOther`.`status` = 2) AND (`KeywordOther`.`id` = 70000024)) | 1 | 1 | 0 | |
| SELECT `Car`.`brand_cd`, `Car`.`car_cd`, `Car`.`car_nm`, `Car`.`car_nm_eng`, `Car`.`car_sort`, `CarOther`.`car_cd`, `CarOther`.`brand_cd`, `CarOther`.`country_cd`, `CarOther`.`body_cd`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`ucar_min_price`, `CarOther`.`ucar_max_price`, `CarOther`.`pv`, `CarOther`.`prev_day_pv`, `CarOther`.`current_day_pv`, `CarOther`.`ucar_pv`, `CarOther`.`ucar_prev_day_pv`, `CarOther`.`ucar_current_day_pv`, `CarOther`.`show_rank_flag`, `CarOther`.`image_path`, `CarOther`.`year_cd`, `CarOther`.`last_model_min_price`, `CarOther`.`last_model_max_price`, `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Brand`.`brand_sort` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE `Car`.`car_cd` = 10151006 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` = (10151006) | 1 | 1 | 0 | |
| SELECT `Car`.`brand_cd`, `Car`.`car_cd`, `Car`.`car_nm`, `Car`.`car_nm_eng`, `Car`.`car_sort`, `CarOther`.`car_cd`, `CarOther`.`brand_cd`, `CarOther`.`country_cd`, `CarOther`.`body_cd`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`ucar_min_price`, `CarOther`.`ucar_max_price`, `CarOther`.`pv`, `CarOther`.`prev_day_pv`, `CarOther`.`current_day_pv`, `CarOther`.`ucar_pv`, `CarOther`.`ucar_prev_day_pv`, `CarOther`.`ucar_current_day_pv`, `CarOther`.`show_rank_flag`, `CarOther`.`image_path`, `CarOther`.`year_cd`, `CarOther`.`last_model_min_price`, `CarOther`.`last_model_max_price`, `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Brand`.`brand_sort` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE ((`Car`.`car_cd` = 10151006) OR (`Car`.`car_cd` = 10051009) OR (`Car`.`car_cd` = 10101072) OR (`Car`.`car_cd` = 20151524) OR (`Car`.`car_cd` = 10252021) OR (`Car`.`car_cd` = 20352516) OR (`Car`.`car_cd` = 10451018) OR (`Car`.`car_cd` = 20101502) OR (`Car`.`car_cd` = 10251020) OR (`Car`.`car_cd` = 10451016)) | 10 | 10 | 0 | |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` IN (10051009, 10101072, 10151006, 10251020, 10252021, 10451016, 10451018, 20101502, 20151524, 20352516) | 60 | 60 | 0 | |
| SELECT `LinkInfo`.`id`, `LinkInfo`.`article_id`, `LinkInfo`.`article_flag`, `LinkInfo`.`target_flag`, `LinkInfo`.`target_id` FROM `mfdb`.`tb_link_info` AS `LinkInfo` WHERE `LinkInfo`.`article_flag` = 1 AND `LinkInfo`.`target_id` IN (1,70000024,10151006,10051009,10101072,20151524,10252021,20352516,10451018,20101502,10251020,10451016,1) AND `LinkInfo`.`article_id`<>10000119 | 333 | 333 | 3 | |
| 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,10005477,10006304,10006340,10010095,10005713,10012208,10015836,10016400,10016970,10017689,10002228,10000242,10000920,10004256,10003239,10010801,10010799,10014602,10015379,10017302,10000565,10000729,10003492,10005187,10009875,10010052,10010121,10012001,10012588,10012791,10012923,10012915,10013701,10014954,10014957,10014975,10015154,10015546,10015653,10016150,10016167,10016218,10016353,10016421,10016435,10016449,10016455,10016554,10017123,10017144,10017341,10017391,10017479,10017222,10018004,10018782,10018818,10019161,10019602,10000695,10002315,10004352,10004450,10004143,10003775,10003720,10001696,10001645,10001153,10005418,10005447,10005462,10005492,10005505,10005510,10005526,10005836,10005318,10004500,10001110,10004566,10001678,10001152,10006452,10006498,10006939,10007389,10007894,10007881,10007849,10007715,10007583,10007403,10008361,10008173,10008171,10007363,10007292,10008995,10008844,10009965,10010029,10010056,10010236,10011511,10011517,10011518,10011422,10011063,10012161,10012351,10012391,10012836,10013060,10013792,10013949,10015005,10015205,10015247,10015335,10015429,10015681,10015761,10015787,10015794,10015848,10015850,10015893,10015898,10015904,10015919,10015920,10015986,10016049,10016112,10016134,10016161,10016467,10017144,10017533,10017726,10017925,10018176,10018497,10018723,10000191,10000053,10000682,10000681,10000807,10001128,10001146,10001145,10001131,10001133,10001134,10001135,10001136,10001142,10001143,10001144,10003367,10001577,10000630,10001904,10001941,10003843,10004198,10003695,10001760,10004805,10005073,10005388,10005461,10006002,10004392,10006215,10006029,10005836,10004798,10004684,10004073,10005033,10006375,10007727,10009198,10009400,10009569,10010354,10010349,10009381,10009858,10009199,10008358,10008658,10008509,10007367,10010726,10010732,10010949,10011394,10012735,10012801,10013145,10013290,10013398,10014015,10014359,10014397,10014493,10014707,10014937,10015503,10016604,10016873,10017382,10017442,10017760,10017944,10018055,10018079,10018937,10019155,10020039,10000155,10000578,10000628,10000724,10000748,10000747,10000746,10000744,10000749,10000750,10000754,10000755,10000756,10000757,10000758,10000760,10000939,10000973,10001161,10004800,10004015,10004012,10001470,10001088,10000154,10010027,10010061,10011685,10015680,10015867,10017080,10017249,10017264,10017268,10017313,10017345,10017391,10018723,10018813,10018814,10018816,10018817,10018818,10000267,10000260,10000240,10000563,10000614,10000623,10001160,10002872,10004973,10005180,10009668,10010103,10011340,10011941,10012109,10012158,10012642,10012644,10012647,10012631,10012723,10013060,10013198,10013248,10016100,10018600,10012684,10000511,10003343,10005922,10013490,10017798,10018384,10000603,10003362,10005406,10006058,10006474,10009482,10012891,10014478,10014485,10014903,10015415,10015811,10019236,10019290,10019982,10000130,10000122,10000120,10000118,10000117,10000116,10000115,10000114,10000113,10000112,10000111,10000110,10000109,10000105,10000102,10000101,10000100,10000103,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 9 | maybe slow |