3 | SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`status` = '有効' ORDER BY `odr` DESC | | 9 | 9 | 3 |
4 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 7 |