| 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-05-20 17:45:58') 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 17:45:58') 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-20 17:45:58') 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-20 17:45:58') 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-05-20 17:45:58') 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-20 17:45:58') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_news` AS `News` WHERE `News`.`id` = 10000924 | 1 | 1 | 0 | |
| 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` = 10000924 LIMIT 1 | 1 | 1 | 0 | |
| 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` = (10000924) ORDER BY `sort_no` ASC | 21 | 21 | 0 | |
| 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` = 10000924 ORDER BY `NewsImage`.`created` 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`.`article_id` = 10000924 ORDER BY `LinkInfo`.`target_flag` ASC, `LinkInfo`.`id` ASC | 2 | 2 | 0 | |
| 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` = 70000050)) | 1 | 1 | 0 | |
| SELECT `Car`.`brand_cd`, `Car`.`car_cd`, `Car`.`car_nm`, `Car`.`car_nm_eng`, `Car`.`car_sort`, `CarOther`.`car_cd`, `CarOther`.`brand_cd`, `CarOther`.`country_cd`, `CarOther`.`body_cd`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`ucar_min_price`, `CarOther`.`ucar_max_price`, `CarOther`.`pv`, `CarOther`.`prev_day_pv`, `CarOther`.`current_day_pv`, `CarOther`.`ucar_pv`, `CarOther`.`ucar_prev_day_pv`, `CarOther`.`ucar_current_day_pv`, `CarOther`.`show_rank_flag`, `CarOther`.`image_path`, `CarOther`.`year_cd`, `CarOther`.`last_model_min_price`, `CarOther`.`last_model_max_price`, `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Brand`.`brand_sort` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE `Car`.`car_cd` = 10151048 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` = (10151048) | 3 | 3 | 0 | |
| SELECT `Car`.`brand_cd`, `Car`.`car_cd`, `Car`.`car_nm`, `Car`.`car_nm_eng`, `Car`.`car_sort`, `CarOther`.`car_cd`, `CarOther`.`brand_cd`, `CarOther`.`country_cd`, `CarOther`.`body_cd`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`ucar_min_price`, `CarOther`.`ucar_max_price`, `CarOther`.`pv`, `CarOther`.`prev_day_pv`, `CarOther`.`current_day_pv`, `CarOther`.`ucar_pv`, `CarOther`.`ucar_prev_day_pv`, `CarOther`.`ucar_current_day_pv`, `CarOther`.`show_rank_flag`, `CarOther`.`image_path`, `CarOther`.`year_cd`, `CarOther`.`last_model_min_price`, `CarOther`.`last_model_max_price`, `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Brand`.`brand_sort` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE `Car`.`car_cd` = 10151048 | 1 | 1 | 0 | |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` = (10151048) | 3 | 3 | 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_id` IN (1,70000050,10151048,1) AND `LinkInfo`.`article_id`<>10000924 | 273 | 273 | 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,10000114,10000464,10000559,10000599,10000696,10000810,10000927,10000893,10000926,10000947,10000955,10001062,10001190,10002060,10002903,10003127,10003361,10004082,10004383,10004910,10004863,10004968,10005494,10004379,10004030,10002050,10002017,10001566,10001474,10003664,10003603,10003542,10002819,10002757,10002234,10002220,10002153,10007680,10007720,10008335,10008677,10004331,10010790,10012118,10012399,10013301,10013387,10012848,10012828,10011593,10008810,10008811,10008243,10007035,10006973,10013635,10013647,10013800,10014181,10014266,10014454,10014602,10014788,10015111,10015173,10015219,10015253,10015354,10015371,10015453,10015484,10015506,10015602,10015608,10015676,10015675,10015743,10015831,10015494,10016041,10016078,10016092,10016204,10016253,10016269,10016346,10016493,10016520,10016521,10016563,10016582,10016646,10016697,10016798,10016858,10016959,10016978,10016979,10017018,10017037,10017088,10017089,10017174,10017259,10017380,10017437,10017460,10017473,10017664,10017692,10017887,10018298,10018299,10018304,10018450,10018522,10018559,10018560,10018561,10018667,10018698,10018726,10018939,10018950,10018982,10019018,10019020,10019052,10019078,10019081,10019325,10019527,10019699,10019786,10019886,10019946,10020000,10019999,10001193,10001159,10001127,10001124,10001123,10001092,10001076,10000935,10000894,10000841,10000811,10000741,10000696,10000685,10000661,10000599,10000579,10000559,10000416,10000320,10000310,10000224,10000049,10001195,10001169,10001137,10001114,10001111,10001099,10001056,10001053,10001050,10001025,10000998,10000979,10000955,10000854,10000852,10000810,10000783,10000709,10000683,10000656,10000596,10000501,10000464,10000315,10000210,10000114,10000105,10000051,10001207,10001272,10001682,10002347,10002313,10002309,10002307,10002239,10002234,10002984,10002903,10002060,10004489,10015051,10015692,10015686,10015713,10015720,10015722,10015737,10015741,10015743,10015769,10015780,10015783,10015808,10015807,10015842,10015854,10015863,10015883,10015906,10015916,10015987,10016029,10016041,10016051,10016078,10016081,10016092,10016109,10016243,10016269,10016347,10016368,10016617,10016619,10016633,10016680,10016657,10016711,10016720,10017327,10017736,10017800,10017896,10018333,10018469,10018616,10018639,10018726,10018805,10018852,10018888,10018891,10018925,10018941,10018959,10018973,10019019,10019055,10019078,10019117,10019284,10019350,10019442,10019520,10019578,10019579,10019695,10019756,10019830,10019852,10019866,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 4 | maybe slow |