Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Information`.`id`, `Information`.`information_category_id`, `Information`.`informationd`, `Information`.`opend`, `Information`.`closed`, `Information`.`subject`, `Information`.`url`, `Information`.`content`, `Information`.`counter_name`, `Information`.`counter_tel`, `Information`.`counter_body`, `Information`.`recommend_menu_flg`, `Information`.`valid_flg`, `Information`.`created`, `Information`.`modified`, `InformationCategory`.`id`, `InformationCategory`.`name`, `InformationCategory`.`class`, `InformationCategory`.`icon_path` FROM `riho`.`information` AS `Information` LEFT JOIN `riho`.`information_categories` AS `InformationCategory` ON (`Information`.`information_category_id` = `InformationCategory`.`id`) WHERE `Information`.`valid_flg` = '1' AND ((((`Information`.`opend` IS NULL) OR (`Information`.`opend` <= '2021-03-08'))) AND (((`Information`.`closed` IS NULL) OR (`Information`.`closed` >= '2021-03-08')))) AND `Information`.`id` = 470 ORDER BY `Information`.`informationd` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `InformationBuilder`.`id`, `InformationBuilder`.`information_id`, `InformationBuilder`.`builder_id` FROM `riho`.`information_builders` AS `InformationBuilder` WHERE `InformationBuilder`.`information_id` = (470) | 0 | 0 | 0 | |
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 `riho`.`attachments` AS `Attachment` WHERE `model` = 'Information' AND model_id = (470) | 0 | 0 | 0 | |
SELECT `Information`.`id`, `Information`.`informationd`, `Information`.`subject`, `Information`.`url` FROM `riho`.`information` AS `Information` WHERE `Information`.`valid_flg` = '1' AND ((((`Information`.`opend` IS NULL) OR (`Information`.`opend` <= '2021-03-08'))) AND (((`Information`.`closed` IS NULL) OR (`Information`.`closed` >= '2021-03-08')))) AND NOT (`Information`.`id` = 470) ORDER BY `Information`.`informationd` DESC LIMIT 10 | 10 | 10 | 5 | maybe slow |
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 `riho`.`attachments` AS `Attachment` WHERE `model` = 'Information' AND `model_id` IN (491, 489, 490, 486, 487, 481, 482, 483, 484, 480) | 2 | 2 | 1 | maybe slow |
SELECT `WideArea`.`id`, `WideArea`.`pref_id`, `WideArea`.`name`, `WideArea`.`sort`, `WideArea`.`valid_flg`, `WideArea`.`created`, `WideArea`.`modified` FROM `riho`.`wide_areas` AS `WideArea` WHERE `WideArea`.`valid_flg` = '1' ORDER BY `WideArea`.`pref_id` ASC, `WideArea`.`sort` ASC | 7 | 7 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 1 | 1 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 2 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 3 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 4 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 2 | 2 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 5 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `RihoCounter`.`id`, `RihoCounter`.`begind`, `RihoCounter`.`endd`, `RihoCounter`.`subject`, `RihoCounter`.`direct_url`, `RihoCounterArea`.`id`, `RihoCounterArea`.`name`, `RihoCounterArea`.`color` FROM `riho`.`riho_counters` AS `RihoCounter` LEFT JOIN `riho`.`riho_counter_areas` AS `RihoCounterArea` ON (`RihoCounter`.`riho_counter_area_id` = `RihoCounterArea`.`id`) WHERE `RihoCounter`.`valid_flg` = '1' AND ((((`RihoCounter`.`opend` IS NULL) OR (`RihoCounter`.`opend` <= '2021-03-08'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-03-08')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
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 `riho`.`attachments` AS `Attachment` WHERE `model` = 'RihoCounter' AND `model_id` IN (832, 849, 850, 837, 851, 846) | 6 | 6 | 0 | |