| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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 | 4 | 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=1019 AND ((News.public_date <= '2026-05-20 20:03:51') 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-05-20 20:03:51') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 11 | 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-05-20 20:03:51') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 22 | 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-05-20 20:03:51') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 5 | 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=1014 AND ((News.public_date <= '2026-05-20 20:03:52') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 6 | |
| 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-05-20 20:03:52') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 4 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_news` AS `News` WHERE `News`.`id` = 10015560 | 1 | 1 | 10 | maybe slow |
| 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` = 10015560 LIMIT 1 | 1 | 1 | 5 | maybe slow |
| 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` = (10015560) ORDER BY `sort_no` ASC | 10 | 10 | 2 | maybe slow |
| 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` = 10015560 ORDER BY `NewsImage`.`created` ASC | 0 | 0 | 8 | maybe slow |
| 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` = 10015560 ORDER BY `LinkInfo`.`target_flag` ASC, `LinkInfo`.`id` ASC | 3 | 3 | 1 | maybe slow |
| 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` = 70000716) OR (`KeywordOther`.`id` = 70000547) OR (`KeywordOther`.`id` = 70000393)))) | 3 | 3 | 4 | maybe slow |
| 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,70000716,70000547,70000393,1) AND `LinkInfo`.`article_id`<>10015560 | 229 | 229 | 8 | |
| 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,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,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10015891,10016066,10016345,10016498,10017245,10017542,10017543,10017573,10018120,10018030,10018179,10012115,10012093,10012192,10013969,10014626,10015319,10015502,10015537,10015556,10015538,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10016345,10016429,10016372,10017245,10017542,10017543,10017573,10018120,10018030,10018179,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,10008845,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,10015507,10015576,10015579,10015539,10015584,10015670,10015874,10015693,10015721,10016064,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 104 | maybe slow |