| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `KeywordDictionary`.`id`, `KeywordDictionary`.`title`, `KeywordDictionary`.`body_text` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` WHERE `KeywordDictionary`.`delete_flg` = '0' AND `KeywordDictionary`.`public_flag` = '1' AND `KeywordDictionary`.`status` = 2 AND ((`KeywordDictionary`.`public_date` <= '2026-05-21') OR (`KeywordDictionary`.`public_date` IS NULL)) AND `KeywordDictionary`.`id` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` = 3) ORDER BY RAND() ASC LIMIT 3 | 3 | 3 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`public_date`, `Group`.`group_name`, (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` 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_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` = '0' AND `News`.`public_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 | 45 | maybe slow |
| 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`, `Group`.`group_name`, (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 (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` IN (1,2)) ORDER BY `News`.`current_day_pv` DESC LIMIT 10 | 10 | 10 | 1 | maybe slow |
| SELECT DISTINCT `Catalog`.`brand_name`, `Catalog`.`car_name`, `Catalog`.`cat_id`, `Catalog`.`car_cd`, `Catalog`.`brand_name_en`, `Catalog`.`price`, `Catalog`.`photo_main` FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE 1 = 1 ORDER BY `Catalog`.`year_cd` DESC LIMIT 8 | 8 | 8 | 0 | |
| SELECT `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Car`.`car_nm`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`image_path`, `Car`.`car_cd` 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` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site`=6) ORDER BY RAND() ASC LIMIT 8 | 5 | 5 | 1 | maybe slow |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` IN (35201531, 10552002, 10452019, 10052002, 10201018) | 26 | 26 | 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 | 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-05-21 02:51:04') 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-21 02:51:04') 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-21 02:51:04') 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-21 02:51:04') 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-21 02:51:04') 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-21 02:51:04') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `BrandImage`.`brand_image_file_name` FROM `mfdb`.`tb_brand_master` AS `Brand` LEFT JOIN `mfdb`.`tb_brand_images` AS `BrandImage` ON (`Brand`.`brand_cd` = `BrandImage`.`id`) WHERE 1 = 1 ORDER BY `Brand`.`brand_cd` ASC | 78 | 78 | 0 | |
| SELECT `Brand`.`brand_cd`, `Brand`.`brand_nm` FROM `mfdb`.`tb_brand_master` AS `Brand` WHERE 1 = 1 ORDER BY `Brand`.`brand_sort` ASC | 78 | 78 | 0 | |
| SELECT `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Brand`.`brand_sort`, `BrandImage`.`brand_image_file_name` FROM `mfdb`.`tb_brand_master` AS `Brand` LEFT JOIN `mfdb`.`tb_brand_images` AS `BrandImage` ON (`Brand`.`brand_cd` = `BrandImage`.`id`) WHERE REPLACE(REPLACE(`Brand`.`brand_nm_eng`,' ',''),'-','')='ISUZU' LIMIT 1 | 1 | 1 | 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`.`target_flag` = 6 AND `LinkInfo`.`target_id` = 10601004 ORDER BY `LinkInfo`.`article_flag` ASC | 3 | 3 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_car_master` AS `Car` WHERE `Car`.`car_cd` = 10601004 | 1 | 1 | 0 | |
| SELECT `CatalogArticle`.`id`, `CatalogArticle`.`pv`, `CatalogArticle`.`prev_day_pv`, `CatalogArticle`.`current_day_pv`, `CatalogArticle`.`show_rank_flag`, `CatalogArticle`.`public_flag`, `CatalogArticle`.`delete_flg`, `CatalogArticle`.`created`, `CatalogArticle`.`creator`, `CatalogArticle`.`modified`, `CatalogArticle`.`modifier` FROM `mfdb`.`tb_catalog_article` AS `CatalogArticle` WHERE `CatalogArticle`.`id` = 10601004 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` = 10601004 ORDER BY `CarImage`.`sort_no` ASC, `CarImage`.`id` DESC | 21 | 21 | 0 | |
| SELECT MAX(`Catalog`.`year_cd`) as year_cd FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE `Catalog`.`car_cd` = 10601004 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Catalog`.`cat_id`, `Catalog`.`uri_flag`, `Catalog`.`jou_syo`, `Catalog`.`special_flg`, `Catalog`.`year_cd`, `Catalog`.`country_cd`, `Catalog`.`country_j`, `Catalog`.`brand_cd`, `Catalog`.`brand_name`, `Catalog`.`brand_name_en`, `Catalog`.`car_cd`, `Catalog`.`car_name`, `Catalog`.`car_name_en`, `Catalog`.`body_cd`, `Catalog`.`body_nm`, `Catalog`.`body_nm_en`, `Catalog`.`drive_cd`, `Catalog`.`drive_nm`, `Catalog`.`door_cd`, `Catalog`.`door_nm`, `Catalog`.`teiin_cd`, `Catalog`.`teiin_nm`, `Catalog`.`mission_cd`, `Catalog`.`mission_nm`, `Catalog`.`exhaust_cd`, `Catalog`.`exhaust_nm_cc`, `Catalog`.`p_grade_id`, `Catalog`.`grade_nm`, `Catalog`.`debut_year`, `Catalog`.`debut_month`, `Catalog`.`end_year`, `Catalog`.`end_month`, `Catalog`.`drive60km`, `Catalog`.`price`, `Catalog`.`price_total`, `Catalog`.`katashiki`, `Catalog`.`length`, `Catalog`.`width`, `Catalog`.`height`, `Catalog`.`weight`, `Catalog`.`wheelbase`, `Catalog`.`ftred`, `Catalog`.`rtred`, `Catalog`.`domestic_import`, `Catalog`.`engine_type`, `Catalog`.`engine`, `Catalog`.`bore`, `Catalog`.`stroke`, `Catalog`.`cat_exhaust`, `Catalog`.`comp`, `Catalog`.`fuel_serve`, `Catalog`.`max_power`, `Catalog`.`max_power_kw`, `Catalog`.`max_power_rev`, `Catalog`.`max_torque`, `Catalog`.`max_torque_nm`, `Catalog`.`max_torque_rev`, `Catalog`.`turbo_nm`, `Catalog`.`tank`, `Catalog`.`fuel_nm`, `Catalog`.`nenpi`, `Catalog`.`p_mission_nm`, `Catalog`.`option_id_137`, `Catalog`.`hensoku_cvt`, `Catalog`.`hensoku1`, `Catalog`.`hensoku2`, `Catalog`.`hensoku3`, `Catalog`.`hensoku4`, `Catalog`.`hensoku5`, `Catalog`.`hensoku6`, `Catalog`.`hensoku7`, `Catalog`.`hensoku8`, `Catalog`.`hensoku_back`, `Catalog`.`steering`, `Catalog`.`f_sus`, `Catalog`.`r_sus`, `Catalog`.`f_brake`, `Catalog`.`r_brake`, `Catalog`.`f_tire`, `Catalog`.`r_tire`, `Catalog`.`min_tum`, `Catalog`.`gensoku1`, `Catalog`.`gensoku2`, `Catalog`.`option_id_101`, `Catalog`.`option_id_102`, `Catalog`.`option_id_103`, `Catalog`.`option_id_104`, `Catalog`.`option_id_105`, `Catalog`.`option_id_106`, `Catalog`.`option_id_107`, `Catalog`.`option_id_108`, `Catalog`.`option_id_142`, `Catalog`.`option_id_109`, `Catalog`.`option_id_110`, `Catalog`.`option_id_111`, `Catalog`.`option_id_112`, `Catalog`.`option_id_113`, `Catalog`.`option_id_114`, `Catalog`.`option_id_115`, `Catalog`.`option_id_116`, `Catalog`.`option_id_117`, `Catalog`.`option_id_118`, `Catalog`.`option_id_119`, `Catalog`.`option_id_120`, `Catalog`.`option_id_139`, `Catalog`.`option_id_140`, `Catalog`.`option_id_141`, `Catalog`.`option_id_143`, `Catalog`.`safty_others`, `Catalog`.`option_id_121`, `Catalog`.`option_id_122`, `Catalog`.`option_id_123`, `Catalog`.`option_id_124`, `Catalog`.`option_id_125`, `Catalog`.`option_id_126`, `Catalog`.`option_id_127`, `Catalog`.`option_id_128`, `Catalog`.`option_id_129`, `Catalog`.`option_id_130`, `Catalog`.`option_id_131`, `Catalog`.`option_id_132`, `Catalog`.`option_id_133`, `Catalog`.`option_id_134`, `Catalog`.`option_id_135`, `Catalog`.`option_id_136`, `Catalog`.`color_type_std_10`, `Catalog`.`color_type_std_25`, `Catalog`.`color_type_std_34`, `Catalog`.`color_type_std_26`, `Catalog`.`color_type_std_36`, `Catalog`.`color_type_std_37`, `Catalog`.`color_type_std_60`, `Catalog`.`color_type_std_45`, `Catalog`.`color_type_std_27`, `Catalog`.`color_type_std_21`, `Catalog`.`color_type_std_16`, `Catalog`.`color_type_std_41`, `Catalog`.`color_type_std_15`, `Catalog`.`color_type_std_20`, `Catalog`.`color_type_std_24`, `Catalog`.`color_type_std_43`, `Catalog`.`color_type_std_42`, `Catalog`.`color_type_std_30`, `Catalog`.`color_type_opt_10`, `Catalog`.`color_type_opt_25`, `Catalog`.`color_type_opt_34`, `Catalog`.`color_type_opt_26`, `Catalog`.`color_type_opt_36`, `Catalog`.`color_type_opt_37`, `Catalog`.`color_type_opt_60`, `Catalog`.`color_type_opt_45`, `Catalog`.`color_type_opt_27`, `Catalog`.`color_type_opt_21`, `Catalog`.`color_type_opt_16`, `Catalog`.`color_type_opt_41`, `Catalog`.`color_type_opt_15`, `Catalog`.`color_type_opt_20`, `Catalog`.`color_type_opt_24`, `Catalog`.`color_type_opt_43`, `Catalog`.`color_type_opt_42`, `Catalog`.`color_type_opt_30`, `Catalog`.`handle_pos`, `Catalog`.`del_flg`, `Catalog`.`entry_date`, `Catalog`.`up_date`, `Catalog`.`photo_file`, `Catalog`.`debut_type_id`, `Catalog`.`room_length`, `Catalog`.`room_width`, `Catalog`.`room_height`, `Catalog`.`final_gensoku`, `Catalog`.`photo_aa`, `Catalog`.`photo_aa_comment`, `Catalog`.`photo_bb`, `Catalog`.`photo_bb_comment`, `Catalog`.`photo_cc`, `Catalog`.`photo_cc_comment`, `Catalog`.`photo_dd`, `Catalog`.`photo_dd_comment`, `Catalog`.`photo_ee`, `Catalog`.`photo_ee_comment`, `Catalog`.`photo_ff`, `Catalog`.`photo_ff_comment`, `Catalog`.`photo_gg`, `Catalog`.`photo_gg_comment`, `Catalog`.`photo_hh`, `Catalog`.`photo_hh_comment`, `Catalog`.`photo_ii`, `Catalog`.`photo_ii_comment`, `Catalog`.`photo_jj`, `Catalog`.`photo_jj_comment`, `Catalog`.`photo_kk`, `Catalog`.`photo_kk_comment`, `Catalog`.`photo_ll`, `Catalog`.`photo_ll_comment`, `Catalog`.`photo_mm`, `Catalog`.`photo_mm_comment`, `Catalog`.`photo_nn`, `Catalog`.`photo_nn_comment`, `Catalog`.`photo_oo`, `Catalog`.`photo_oo_comment`, `Catalog`.`photo_pp`, `Catalog`.`photo_pp_comment`, `Catalog`.`photo_main`, `Catalog`.`photo_main_comment`, `Catalog`.`photo_in`, `Catalog`.`photo_in_comment`, `Catalog`.`photo_bk`, `Catalog`.`photo_bk_comment`, `Catalog`.`photo_op`, `Catalog`.`photo_op_comment`, `Catalog`.`p_model_cd_1_nm`, `Catalog`.`nenpi_jc08` FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE `Catalog`.`car_cd` = 10601004 AND `Catalog`.`year_cd` = 199901 | 7 | 7 | 1 | maybe slow |
| SELECT DISTINCT `Catalog`.`year_cd`, `Catalog`.`debut_year`, `Catalog`.`debut_month` FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE `Catalog`.`car_cd` = 10601004 ORDER BY `Catalog`.`year_cd` DESC | 10 | 10 | 1 | maybe slow |
| SELECT `CarReview`.`id`, `CarReview`.`car_cd`, `CarReview`.`overall_comment`, `CarReview`.`review_title1`, `CarReview`.`review_rank1`, `CarReview`.`review_comment1`, `CarReview`.`review_title2`, `CarReview`.`review_rank2`, `CarReview`.`review_comment2`, `CarReview`.`review_title3`, `CarReview`.`review_rank3`, `CarReview`.`review_comment3`, `CarReview`.`review_title4`, `CarReview`.`review_rank4`, `CarReview`.`review_comment4`, `CarReview`.`review_title5`, `CarReview`.`review_rank5`, `CarReview`.`review_comment5`, `CarReview`.`review_title6`, `CarReview`.`review_rank6`, `CarReview`.`review_comment6`, `CarReview`.`review_title7`, `CarReview`.`review_rank7`, `CarReview`.`review_comment7`, `CarReview`.`review_title8`, `CarReview`.`review_rank8`, `CarReview`.`review_comment8`, `CarReview`.`review_title9`, `CarReview`.`review_rank9`, `CarReview`.`review_comment9`, `CarReview`.`review_title10`, `CarReview`.`review_rank10`, `CarReview`.`review_comment10`, `CarReview`.`review_user_name`, `CarReview`.`delete_flg`, `CarReview`.`created`, `CarReview`.`creator`, `CarReview`.`modified`, `CarReview`.`modifier`, `Car`.`brand_cd`, `Car`.`car_cd`, `Car`.`car_nm`, `Car`.`car_nm_eng`, `Car`.`car_sort` FROM `mfdb`.`tb_car_reviews` AS `CarReview` LEFT JOIN `mfdb`.`tb_car_master` AS `Car` ON (`CarReview`.`car_cd` = `Car`.`car_cd`) WHERE `CarReview`.`car_cd` = 10601004 | 0 | 0 | 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` = 10601004 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` = (10601004) | 21 | 21 | 0 | |
| UPDATE tb_pv_totalization SET pv=pv+1,current_day_pv=current_day_pv+1 WHERE id=10601004 AND data_type=6 | 1 | 1 | 0 | |
| SELECT `Brand`.`brand_nm` FROM `mfdb`.`tb_brand_master` AS `Brand` WHERE `Brand`.`brand_cd` = 1060 LIMIT 1 | 1 | 1 | 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`.`target_flag` = 6 AND `LinkInfo`.`article_flag` = 1 AND `LinkInfo`.`target_id` = 10601004 ORDER BY `LinkInfo`.`article_flag` ASC | 3 | 3 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`tech_flag`, `News`.`title`, `News`.`lead`, `News`.`main_image_file_name`, `News`.`public_date` FROM `mfdb`.`tb_news` AS `News` WHERE ((`News`.`delete_flg` = '0') AND (`News`.`public_flag` = '1') AND (`News`.`status` = 2) AND (`News`.`public_status` = '1') AND (`News`.`id` IN (1,10018242,10014619,10018431,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC | 3 | 3 | 1 | maybe slow |