| 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-17 12:33:45') 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-17 12:33:45') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 2 | 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-17 12:33:45') 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-17 12:33:45') 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-17 12:33:45') 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-17 12:33:45') 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`.`v_job_data` AS `Job` WHERE `Job`.`id` = 478245 | 1 | 1 | 1 | |
| SELECT `Job`.`id`, `Job`.`company_id`, `Job`.`company_name`, `Job`.`company_name_web`, `Job`.`public_flag`, `Job`.`prefecture_ids`, `Job`.`category_ids`, `Job`.`min_salary`, `Job`.`max_salary`, `Job`.`foreign_company`, `Job`.`position_name`, `Job`.`application_requirement`, `Job`.`work_location`, `Job`.`overseas_work`, `Job`.`employment_type`, `Job`.`working_hours`, `Job`.`salary_type`, `Job`.`transfer_flag`, `Job`.`other_benefits`, `Job`.`training`, `Job`.`feature`, `Job`.`consultant_comment`, `Job`.`job_description`, `Job`.`responsible_product`, `Job`.`organization`, `Job`.`report_line`, `Job`.`management`, `Job`.`rd_bases`, `Job`.`production_bases`, `Job`.`business_trip`, `Job`.`english_req_flag`, `Job`.`english_requirement`, `Job`.`recruit_background`, `Job`.`update_date`, `Job`.`regist_date`, `Job`.`industry_1`, `Job`.`industry_2`, `Job`.`industry_3`, `Job`.`industry_4`, `Job`.`confirm_date`, `Job`.`show_company_name`, `Job`.`search_category_ids`, `Job`.`search_prefecture_ids` FROM `mfdb`.`v_job_data` AS `Job` WHERE `Job`.`id` = 478245 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Job`.`id`, `Job`.`company_id`, `Job`.`company_name`, `Job`.`company_name_web`, `Job`.`public_flag`, `Job`.`prefecture_ids`, `Job`.`category_ids`, `Job`.`min_salary`, `Job`.`max_salary`, `Job`.`foreign_company`, `Job`.`position_name`, `Job`.`application_requirement`, `Job`.`work_location`, `Job`.`overseas_work`, `Job`.`employment_type`, `Job`.`working_hours`, `Job`.`salary_type`, `Job`.`transfer_flag`, `Job`.`other_benefits`, `Job`.`training`, `Job`.`feature`, `Job`.`consultant_comment`, `Job`.`job_description`, `Job`.`responsible_product`, `Job`.`organization`, `Job`.`report_line`, `Job`.`management`, `Job`.`rd_bases`, `Job`.`production_bases`, `Job`.`business_trip`, `Job`.`english_req_flag`, `Job`.`english_requirement`, `Job`.`recruit_background`, `Job`.`update_date`, `Job`.`regist_date`, `Job`.`industry_1`, `Job`.`industry_2`, `Job`.`industry_3`, `Job`.`industry_4`, `Job`.`confirm_date`, `Job`.`show_company_name`, `Job`.`search_category_ids`, `Job`.`search_prefecture_ids` FROM `mfdb`.`v_job_data` AS `Job` WHERE ((NOT (`Job`.`id` = 478245)) AND (FIND_IN_SET(7, `Job`.`search_category_ids`)) AND (FIND_IN_SET(14, `Job`.`search_prefecture_ids`))) ORDER BY `Job`.`update_date` ASC LIMIT 4 | 4 | 4 | 5 | maybe slow |
| SELECT `Job`.`id`, `Job`.`company_id`, `Job`.`company_name`, `Job`.`company_name_web`, `Job`.`public_flag`, `Job`.`prefecture_ids`, `Job`.`category_ids`, `Job`.`min_salary`, `Job`.`max_salary`, `Job`.`foreign_company`, `Job`.`position_name`, `Job`.`application_requirement`, `Job`.`work_location`, `Job`.`overseas_work`, `Job`.`employment_type`, `Job`.`working_hours`, `Job`.`salary_type`, `Job`.`transfer_flag`, `Job`.`other_benefits`, `Job`.`training`, `Job`.`feature`, `Job`.`consultant_comment`, `Job`.`job_description`, `Job`.`responsible_product`, `Job`.`organization`, `Job`.`report_line`, `Job`.`management`, `Job`.`rd_bases`, `Job`.`production_bases`, `Job`.`business_trip`, `Job`.`english_req_flag`, `Job`.`english_requirement`, `Job`.`recruit_background`, `Job`.`update_date`, `Job`.`regist_date`, `Job`.`industry_1`, `Job`.`industry_2`, `Job`.`industry_3`, `Job`.`industry_4`, `Job`.`confirm_date`, `Job`.`show_company_name`, `Job`.`search_category_ids`, `Job`.`search_prefecture_ids` FROM `mfdb`.`v_job_data` AS `Job` WHERE `Job`.`id`>0 ORDER BY `Job`.`update_date` ASC LIMIT 10 | 10 | 10 | 4 | maybe slow |
| SELECT `AjCategory`.`id`, `AjCategory`.`name` FROM `mfdb`.`tb_aj_categories` AS `AjCategory` WHERE 1 = 1 ORDER BY `AjCategory`.`sort` ASC | 13 | 13 | 0 | |
