| 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 | 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-06-12 20:48:15') 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=1032 AND ((News.public_date <= '2026-06-12 20:48:15') 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-12 20:48:15') 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-12 20:48:15') 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-12 20:48:15') 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=1015 AND ((News.public_date <= '2026-06-12 20:48:15') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 0 | |
| SELECT `DictionaryCategory`.`id`, `DictionaryCategory`.`category_name` FROM `mfdb`.`tb_dictionary_category` AS `DictionaryCategory` WHERE `DictionaryCategory`.`delete_flg` = '0' AND `DictionaryCategory`.`parent_category_id` = 0 ORDER BY `DictionaryCategory`.`sort_no` ASC | 12 | 12 | 0 | |
| SELECT `EngineCategory`.`id`, `EngineCategory`.`category_name` FROM `mfdb`.`tb_engine_category` AS `EngineCategory` WHERE `EngineCategory`.`delete_flg` = '0' AND `EngineCategory`.`parent_category_id` = 0 ORDER BY `EngineCategory`.`sort_no` ASC | 3 | 3 | 0 | |
| SELECT `OrtherCategory`.`id`, `OrtherCategory`.`category_name` FROM `mfdb`.`tb_orther_category` AS `OrtherCategory` WHERE `OrtherCategory`.`delete_flg` = '0' AND `OrtherCategory`.`parent_category_id` = 0 ORDER BY `OrtherCategory`.`sort_no` ASC | 5 | 5 | 0 | |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` WHERE `KeywordDictionary`.`id` = 30001314 | 1 | 1 | 0 | |
| SELECT `KeywordDictionary`.`id`, `KeywordDictionary`.`parent_category_id`, `KeywordDictionary`.`category_id`, `KeywordDictionary`.`title`, `KeywordDictionary`.`sub_title`, `KeywordDictionary`.`lead`, `KeywordDictionary`.`main_image_file_name`, `KeywordDictionary`.`main_image_caption`, `KeywordDictionary`.`body_text`, `KeywordDictionary`.`written_name_flag`, `KeywordDictionary`.`pv`, `KeywordDictionary`.`prev_day_pv`, `KeywordDictionary`.`current_day_pv`, `KeywordDictionary`.`show_rank_flag`, `KeywordDictionary`.`request_group_id`, `KeywordDictionary`.`request_user_id`, `KeywordDictionary`.`request_date`, `KeywordDictionary`.`approval_user_id`, `KeywordDictionary`.`approval_date`, `KeywordDictionary`.`reject_user_id`, `KeywordDictionary`.`reject_date`, `KeywordDictionary`.`reject_reason`, `KeywordDictionary`.`status`, `KeywordDictionary`.`public_flag`, `KeywordDictionary`.`public_date`, `KeywordDictionary`.`job_keyword`, `KeywordDictionary`.`guid`, `KeywordDictionary`.`delete_flg`, `KeywordDictionary`.`created`, `KeywordDictionary`.`creator`, `KeywordDictionary`.`modified`, `KeywordDictionary`.`modifier`, `ParentCategory`.`category_name`, `Category`.`category_name`, `User`.`user_name`, `User`.`nick_name`, `Group`.`group_name` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` LEFT JOIN `mfdb`.`tb_dictionary_category` AS `ParentCategory` ON (`KeywordDictionary`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_dictionary_category` AS `Category` ON (`KeywordDictionary`.`category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`KeywordDictionary`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`KeywordDictionary`.`request_group_id` = `Group`.`id`) WHERE `KeywordDictionary`.`id` = 30001314 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `KeywordDictionaryDetail`.`id`, `KeywordDictionaryDetail`.`articles_id`, `KeywordDictionaryDetail`.`detail_type`, `KeywordDictionaryDetail`.`detail_title`, `KeywordDictionaryDetail`.`detail_image_file_name`, `KeywordDictionaryDetail`.`detail_image2_file_name`, `KeywordDictionaryDetail`.`detail_link`, `KeywordDictionaryDetail`.`detail_text`, `KeywordDictionaryDetail`.`sort_no` FROM `mfdb`.`tb_keyword_dictionary_detail` AS `KeywordDictionaryDetail` WHERE `KeywordDictionaryDetail`.`articles_id` = (30001314) ORDER BY `sort_no` ASC | 0 | 0 | 0 | |
| UPDATE tb_pv_totalization SET pv=pv+1,current_day_pv=current_day_pv+1 WHERE id=30001314 AND data_type=3 | 1 | 1 | 1 | |
| 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` = 3 AND `LinkInfo`.`article_id` = 30001314 ORDER BY `LinkInfo`.`target_flag` 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`.`target_flag` = 3 AND `LinkInfo`.`target_id` = 30001314 | 162 | 162 | 1 | |
| 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,10000509,10000531,10000589,10000725,10000590,10000624,10000767,10000794,10000845,10000883,10000977,10000936,10000822,10001071,10001234,10001209,10001107,10001252,10001378,10001226,10000790,10001816,10001661,10001469,10001845,10001879,10001989,10001993,10002055,10002063,10002110,10002160,10002181,10002159,10002136,10002161,10002248,10002993,10002733,10002253,10002218,10002216,10002998,10003124,10003063,10003213,10003307,10003411,10002875,10002914,10003633,10003683,10003548,10003763,10003847,10003808,10003789,10003883,10003899,10003933,10004005,10004045,10004007,10004047,10003948,10003779,10004173,10004227,10004172,10004384,10004395,10004432,10004472,10004499,10004533,10004574,10004611,10004637,10004701,10004734,10004766,10004807,10004821,10004879,10004911,10004963,10005005,10005050,10004953,10005141,10005164,10005189,10005244,10005266,10005316,10005543,10005427,10005643,10005541,10005680,10005674,10005793,10005844,10005938,10006014,10005712,10006152,10006298,10006219,10006330,10006439,10006486,10006559,10006581,10006635,10006698,10006776,10006903,10007090,10007117,10007141,10007156,10007193,10007350,10007349,10007348,10007443,10007411,10007390,10007663,10007674,10007714,10007790,10007750,10007823,10007857,10007933,10007962,10007993,10008034,10008030,10005963,10008152,10008161,10005638,10008249,10008089,10008338,10008389,10008362,10008514,10008543,10008561,10008562,10008617,10008669,10008647,10008565,10008705,10008828,10008893,10008944,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 6 | 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`.`company_name_web` LIKE '%自動車%') OR (`Job`.`job_description` LIKE '%自動車%')) ORDER BY RAND() ASC LIMIT 2 | 2 | 2 | 46 | maybe slow |