| 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 | 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:09:44') 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:09:44') 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:09:44') 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:09:44') 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=1014 AND ((News.public_date <= '2026-06-11 23:09:44') 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:09:44') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 0 | |
| SELECT `NewsCategory`.`id`, `NewsCategory`.`category_name` FROM `mfdb`.`tb_news_category` AS `NewsCategory` WHERE `NewsCategory`.`id` = 104 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ChildCategory`.`id`, `ChildCategory`.`category_name`, `ChildCategory`.`article_count`, `ChildCategory`.`tech_count`, `ChildCategory`.`parent_category_id` FROM `mfdb`.`tb_news_category` AS `ChildCategory` WHERE `ChildCategory`.`delete_flg` = '0' AND `ChildCategory`.`parent_category_id` = (104) ORDER BY `sort_no` ASC | 4 | 4 | 0 | |
| SELECT `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 `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`.`category_id` = 211 ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 10 | 10 | 10 | 59 | maybe slow |
| SELECT `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 `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`.`category_id` = 210 ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 10 | 10 | 10 | 41 | maybe slow |
| SELECT `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 `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`.`category_id` = 229 ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 10 | 7 | 7 | 40 | maybe slow |
| SELECT `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 `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`.`category_id` = 230 ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 10 | 10 | 10 | 58 | maybe slow |
| SELECT `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 `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`.`parent_category_id` = 104 AND `News`.`status` = 2 AND `News`.`show_rank_flag` = 1 AND `News`.`public_status` = '1' ORDER BY `News`.`current_day_pv` DESC LIMIT 10 | 10 | 10 | 40 | maybe slow |
| SELECT `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 `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`.`parent_category_id` = 104 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 RAND() ASC LIMIT 3 | 0 | 0 | 1 | maybe slow |
| SELECT `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 `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`.`parent_category_id` = 104 AND `News`.`id` NOT 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`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 3 | 3 | 3 | 42 | 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` IN (10019865, 10019804, 10019692) ORDER BY `sort_no` ASC | 23 | 23 | 1 | |