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` = 489 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` = (489) | 1 | 1 | 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 = (489) | 1 | 1 | 1 | |
SELECT `Builder`.`id`, `Builder`.`type`, `Builder`.`name`, `Builder`.`name_kana`, `Builder`.`branch_name`, `Builder`.`peculiarity`, `Builder`.`message`, `Builder`.`sales_point`, `Builder`.`main_area_id`, `Builder`.`postcode`, `Builder`.`pref_id`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Builder`.`tel`, `Builder`.`tel_original`, `Builder`.`fax`, `Builder`.`email`, `Builder`.`working_hour`, `Builder`.`holiday`, `Builder`.`reserve_flg`, `Builder`.`reserve_start`, `Builder`.`reserve_end`, `Builder`.`reserve_holiday`, `Builder`.`5year_guaranty`, `Builder`.`defect_insurance`, `Builder`.`credit_card`, `Builder`.`building_license_no`, `Builder`.`organization`, `Builder`.`url`, `Builder`.`winning_prize`, `Builder`.`organization_year`, `Builder`.`president_post`, `Builder`.`president_name`, `Builder`.`employees`, `Builder`.`capital_stock`, `Builder`.`corporate_philosophy`, `Builder`.`latitude`, `Builder`.`longitude`, `Builder`.`valid_flg`, `Builder`.`created`, `Builder`.`modified` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`id` = 132 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Work`.`id`, `Work`.`name`, `BuildersWork`.`id`, `BuildersWork`.`builder_id`, `BuildersWork`.`work_id` FROM `riho`.`works` AS `Work` JOIN `riho`.`builders_works` AS `BuildersWork` ON (`BuildersWork`.`builder_id` = 132 AND `BuildersWork`.`work_id` = `Work`.`id`) | 18 | 18 | 0 | |
SELECT `ServiceArea`.`id`, `ServiceArea`.`name`, `BuildersArea`.`id`, `BuildersArea`.`builder_id`, `BuildersArea`.`area_id` FROM `riho`.`areas` AS `ServiceArea` JOIN `riho`.`builders_areas` AS `BuildersArea` ON (`BuildersArea`.`builder_id` = 132 AND `BuildersArea`.`area_id` = `ServiceArea`.`id`) ORDER BY `ServiceArea`.`pref_id` ASC, `ServiceArea`.`sort` ASC | 15 | 15 | 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` = 'Builder' AND model_id = (132) | 2 | 2 | 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` = 489) 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, 490, 486, 487, 481, 482, 483, 484, 480, 472) | 1 | 1 | 1 | |
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 166 | 166 | 1 | |
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` = 'Adviser' AND `model_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 183 | 183 | 8 | |
SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 107 | 107 | 1 | |
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` = 'Builder' AND `model_id` IN (162, 161, 159, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 213 | 213 | 4 | |
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` = 132 AND `Portfolio`.`valid_flg` = '1' | 1 | 1 | 1 | |
SELECT `Pref`.`id`, `Pref`.`name`, `Pref`.`valid_flg`, `Pref`.`created`, `Pref`.`modified` FROM `riho`.`prefs` AS `Pref` WHERE `Pref`.`id` = 44 LIMIT 1 | 1 | 1 | 0 | |
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 | 8 | 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 | 1 | maybe slow |