| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `FeatureCategory`.`id`, `FeatureCategory`.`category_name` FROM `mfdb`.`tb_feature_category` AS `FeatureCategory` WHERE `FeatureCategory`.`delete_flg` = '0' ORDER BY `FeatureCategory`.`sort_no` asc | 36 | 36 | 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 | 1 | |
| 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-24 18:41:12') 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-24 18:41:12') 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-05-24 18:41:12') 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-05-24 18:41:12') 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-05-24 18:41:12') 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-05-24 18:41:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT `Feature`.`id`, `Feature`.`feature_name`, `Feature`.`url_text`, `Feature`.`top_image_file_name`, `Feature`.`head_image_file_name`, `Feature`.`head_color`, `Feature`.`template_id`, `Feature`.`seo_title`, `Feature`.`seo_keyword`, `Feature`.`seo_description`, `Feature`.`parent_category_id`, `Feature`.`category_id`, `Feature`.`sort_no`, `Feature`.`public_flag`, `Feature`.`delete_flg`, `Feature`.`created`, `Feature`.`creator`, `Feature`.`modified`, `Feature`.`modifier` FROM `mfdb`.`tb_feature` AS `Feature` WHERE `Feature`.`delete_flg` = '0' AND `Feature`.`public_flag` = '1' AND `Feature`.`url_text` = '2020techexpo' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `FeatureCategory`.`id`, `FeatureCategory`.`category_name` FROM `mfdb`.`tb_feature_category` AS `FeatureCategory` WHERE `FeatureCategory`.`delete_flg` = '0' AND `FeatureCategory`.`feature_id` = 106 ORDER BY `FeatureCategory`.`sort_no` asc | 4 | 4 | 0 | |
| SELECT `FeatureCategory`.`id`, `FeatureCategory`.`feature_id`, `FeatureCategory`.`category_name`, `FeatureCategory`.`article_type`, `FeatureCategory`.`sort_no`, `FeatureCategory`.`article_count`, `FeatureCategory`.`status`, `FeatureCategory`.`delete_flg`, `FeatureCategory`.`created`, `FeatureCategory`.`creator`, `FeatureCategory`.`modified`, `FeatureCategory`.`modifier`, `Feature`.`feature_name` FROM `mfdb`.`tb_feature_category` AS `FeatureCategory` LEFT JOIN `mfdb`.`tb_feature` AS `Feature` ON (`FeatureCategory`.`feature_id` = `Feature`.`id`) WHERE `FeatureCategory`.`id` = 31 LIMIT 1 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_article_images` AS `AarticleImage` WHERE ((`AarticleImage`.`delete_flg` = '0') AND (`AarticleImage`.`feature_id` = 106) AND (`AarticleImage`.`public_flag` = '1') AND (`AarticleImage`.`category_id` = 31)) | 1 | 1 | 1 | |
| SELECT `AarticleImage`.`id`, `AarticleImage`.`title`, `AarticleImage`.`created`, `AarticleImage`.`category_id`, `AarticleImage`.`main_image_file_name`, `AarticleImage`.`main_image_caption`, `AarticleImage`.`public_flag` FROM `mfdb`.`tb_article_images` AS `AarticleImage` LEFT JOIN `mfdb`.`tb_feature_category` AS `Category` ON (`AarticleImage`.`feature_category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`AarticleImage`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`AarticleImage`.`request_group_id` = `Group`.`id`) WHERE ((`AarticleImage`.`delete_flg` = '0') AND (`AarticleImage`.`feature_id` = 106) AND (`AarticleImage`.`public_flag` = '1') AND (`AarticleImage`.`category_id` = 31)) ORDER BY `AarticleImage`.`created` desc LIMIT 20 | 0 | 0 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`public_date`, `News`.`pr_flag`, `News`.`category_id`, `News`.`tas_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`.`feature_id` IS NULL AND `News`.`autosalon_flag` = 1 AND `News`.`status` = 2 AND `News`.`public_status` = '1' ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 15 | 0 | 0 | 1 | maybe slow |