| 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 09:56:13') 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 09:56:13') 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-12 09:56:13') 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 09:56:13') 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 09:56:13') 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-12 09:56:13') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 2 | 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` = 1 ORDER BY `Menu`.`sort_no` ASC | 7 | 7 | 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 (54, 8, 9, 10, 48, 55, 56) ORDER BY `sort_no` ASC | 0 | 0 | 0 | |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`category_id`, `News`.`public_date`, (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`.`tech_flag` = '1' AND `News`.`public_flag` = '1' AND `News`.`status` = 2 AND `News`.`public_status` = '1' AND `News`.`id` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` IN (2)) ORDER BY RAND() ASC LIMIT 5 | 3 | 3 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`category_id`, `News`.`public_date`, (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`.`tech_flag` = '1' AND `News`.`status` = 2 AND `News`.`public_status` = '1' ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 18 | 18 | 18 | 13 | maybe slow |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10002234) LIMIT 4 | 2 | 2 | 1 | maybe slow |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10015052) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10015002) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020063) LIMIT 4 | 0 | 0 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020062) LIMIT 4 | 0 | 0 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020059) LIMIT 4 | 0 | 0 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020060) LIMIT 4 | 0 | 0 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020050) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020049) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020048) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020047) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020046) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020029) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020027) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020023) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10019973) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020022) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `Tag`.`target_id`, `Tag`.`article_id` FROM `mfdb`.`tb_link_info` AS `Tag` WHERE `article_flag` = 1 AND `target_flag` = 5 AND `Tag`.`article_id` = (10020021) LIMIT 4 | 1 | 1 | 0 | |
| SELECT `KeywordOther`.`id`, `KeywordOther`.`title` FROM `mfdb`.`tb_keyword_other` AS `KeywordOther` WHERE `KeywordOther`.`id` IN (70000050,70000197,70000354,70000354,70000284,70000325,70000322,70000281,70000282,70000282,70000284,70001015,70001032,70001052,70001052) | 11 | 11 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`category_id`, `News`.`public_date`, (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`.`tech_flag` = '1' AND `News`.`status` = 2 AND `News`.`show_rank_flag` = 1 AND `News`.`public_status` = '1' ORDER BY `News`.`current_day_pv` DESC LIMIT 5 | 5 | 5 | 12 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_news` AS `News` WHERE `News`.`id` = 10005760 | 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` = 10005760 LIMIT 1 | 1 | 1 | 1 | |
| 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` = (10005760) ORDER BY `sort_no` ASC | 11 | 11 | 1 | maybe slow |
| SELECT `Group`.`id`, `Group`.`group_name`, `Group`.`groupimage_file_name`, `Group`.`intro_text` FROM `mfdb`.`tb_groups_master` AS `Group` WHERE (`Group`.`group_name` IS NOT NULL AND `Group`.`group_name`<>'') AND `Group`.`profile_display` = 1 AND `Group`.`delete_flg` = '0' AND `Group`.`id` = 17 LIMIT 1 | 0 | 0 | 0 | |
| UPDATE tb_pv_totalization SET pv=pv+1,current_day_pv=current_day_pv+1 WHERE id=10005760 AND data_type=1 | 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` = 1 AND `LinkInfo`.`article_id` = 10005760 ORDER BY `LinkInfo`.`target_flag` ASC, `LinkInfo`.`id` ASC | 4 | 4 | 0 | |
| SELECT `KeywordOther`.`id`, `KeywordOther`.`title`, `KeywordOther`.`category_id` FROM `mfdb`.`tb_keyword_other` AS `KeywordOther` WHERE ((`KeywordOther`.`delete_flg` = '0') AND (`KeywordOther`.`public_flag` = '1') AND (`KeywordOther`.`status` = 2) AND (((`KeywordOther`.`id` = 70000168) OR (`KeywordOther`.`id` = 70000169) OR (`KeywordOther`.`id` = 70000197)))) | 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` = 10151042 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` = (10151042) | 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` = 10151042 | 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` = (10151042) | 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,70000168,70000169,70000197,10151042,1) AND `LinkInfo`.`article_id`<>10005760 | 370 | 370 | 2 | |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`tech_flag`, `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,10000216,10000900,10001700,10005034,10004938,10003593,10003461,10003408,10003393,10003238,10003176,10001802,10001472,10004392,10003844,10002234,10001431,10007151,10007216,10007203,10007220,10009879,10011828,10013040,10013244,10013264,10013647,10013932,10013982,10013891,10013892,10015110,10015544,10016141,10017323,10017483,10017690,10017783,10018027,10018155,10018174,10018327,10018355,10018523,10018835,10018881,10019040,10019539,10019573,10019653,10019681,10005674,10005680,10005541,10005452,10005316,10005244,10005189,10005141,10004953,10005543,10004611,10004533,10004472,10004395,10004334,10004227,10003779,10004047,10004045,10003899,10003883,10003802,10003763,10003661,10005140,10005715,10005720,10005716,10005639,10005691,10005752,10005729,10005682,10005690,10005651,10005602,10005503,10005232,10005231,10005294,10005228,10005225,10005226,10005247,10005033,10005075,10004952,10004881,10005020,10004738,10004937,10004904,10004859,10003399,10004854,10004849,10004736,10004757,10004758,10004760,10004759,10004754,10004755,10004661,10004629,10001299,10004566,10004565,10004481,10004412,10004407,10004405,10005758,10005756,10005793,10005786,10005576,10005556,10005464,10005451,10005219,10005159,10005076,10004191,10003678,10004076,10003845,10005774,10005844,10005857,10005938,10005887,10005933,10005921,10005935,10005893,10005636,10005608,10005186,10005137,10005500,10004942,10004944,10003750,10006014,10006088,10004836,10005388,10005418,10005369,10006071,10006120,10006219,10006163,10006161,10006215,10006213,10006145,10006148,10006251,10005870,10006298,10006330,10006367,10006352,10006348,10006300,10006378,10006439,10006486,10006496,10006489,10006487,10006466,10006559,10006575,10006573,10006543,10006468,10006581,10006608,10006635,10006698,10006755,10006657,10006723,10006719,10006720,10006776,10006762,10006782,10006829,10006907,10006898,10006892,10006869,10006903,10005674,10005643,10005452,10005427,10005266,10005195,10005193,10005190,10005050,10004963,10004879,10004766,10004734,10004637,10004574,10004499,10004432,10004384,10004172,10004173,10003948,10004007,10004005,10003933,10003883,10003808,10003789,10003548,10002746,10003124,10002998,10002733,10001661,10001378,10001209,10000883,10000826,10000767,10000624,10000725,10000590,10005680,10005670,10005636,10005646,10005660,10005656,10005648,10005653,10005642,10005623,10005634,10005629,10005752,10005731,10005724,10004760,10005294,10004755,10005758,10005756,10005793,10005715,10005576,10005556,10005464,10005219,10005159,10004198,10003678,10004076,10005774,10005844,10005857,10005938,10005887,10005933,10005893,10005829,10005608,10005186,10005137,10005500,10004942,10004944,10003750,10002873,10006014,10005935,10006088,10004836,10005388,10005418,10005369,10006071,10006165,10006152,10006161,10006160,10005712,10006219,10006163,10006215,10006213,10006145,10006148,10005792,10006251,10005870,10006298,10006330,10006367,10006352,10006348,10006225,10006300,10006378,10006439,10006486,10006496,10006489,10006487,10006466,10006442,10006559,10006573,10006468,10006517,10006581,10006608,10006635,10006698,10006703,10006702,10006700,10006691,10006776,10006715,10006762,10006829,10006796,10006903,10006927,10006962,10006958,10007336,10007334,10002245,10002238,10002234,10002217,10007339,10007346,10007358,10007359,10007360,10013020,10013059,10013146,10013249,10017817,10017818,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 7 | 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`.`company_name_web` LIKE '%EV%')) ORDER BY RAND() ASC LIMIT 2 | 2 | 2 | 17 | maybe slow |