Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`reform_category_id`, `Article`.`sort`, `Article`.`subject`, `Article`.`summary`, `Article`.`date`, `Article`.`superviser_name`, `Article`.`superviser_text`, `Article`.`superviser_photo`, `Article`.`block_contents`, `Article`.`photo`, `Article`.`valid_flg`, `Article`.`created`, `Article`.`modified`, `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`articles` AS `Article` LEFT JOIN `riho`.`reform_categories` AS `ReformCategory` ON (`Article`.`reform_category_id` = `ReformCategory`.`id`) WHERE `Article`.`valid_flg` = '1' AND `Article`.`id` = 78 ORDER BY `Article`.`date` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `id` = 62 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`subject`, `Article`.`photo`, `ReformCategory`.`name`, `ReformCategory`.`id` FROM `riho`.`articles` AS `Article` LEFT JOIN `riho`.`reform_categories` AS `ReformCategory` ON (`Article`.`reform_category_id` = `ReformCategory`.`id`) WHERE `Article`.`valid_flg` = '1' ORDER BY `date` DESC, `Article`.`date` DESC LIMIT 6 | 6 | 6 | 2 | maybe slow |
SELECT `Article`.`id`, `Article`.`reform_category_id`, `Article`.`sort`, `Article`.`subject`, `Article`.`summary`, `Article`.`date`, `Article`.`superviser_name`, `Article`.`superviser_text`, `Article`.`superviser_photo`, `Article`.`block_contents`, `Article`.`photo`, `Article`.`valid_flg`, `Article`.`created`, `Article`.`modified` FROM `riho`.`articles` AS `Article` WHERE `Article`.`valid_flg` = '1' AND `Article`.`id` = 78 ORDER BY `Article`.`date` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id` FROM `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` WHERE `reform_category_id` = 62 | 171 | 171 | 1 | |
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 165 | 165 | 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` = 'Adviser' AND `model_id` IN (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) | 182 | 182 | 4 | |
SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 106 | 106 | 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 (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) | 211 | 211 | 2 | |
SELECT `Portfolio`.`id`, `Portfolio`.`subject`, `Portfolio`.`cost`, `Portfolio`.`postcode` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (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` IN (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) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` IN (7, 6, 14, 17, 55, 56, 66, 68, 77, 86, 88, 103, 113, 13, 52, 33, 29, 107, 30, 60, 92, 69, 120, 182, 183, 185, 191, 192, 194, 203, 235, 269, 270, 271, 273, 289, 339, 364, 375, 381, 384, 411, 423, 433, 441, 465, 471, 496, 497, 498, 554, 555, 556, 557, 649, 658, 676, 689, 690, 786, 858, 1067, 1068, 1079, 1080, 1088, 1101, 1102, 1104, 1112, 1117, 1239, 1246, 1247, 1248, 1250, 1252, 1257, 1258, 1269, 1278, 1300, 1301, 1325, 1328, 1332, 1334, 1340, 1349, 1408, 1409, 1411, 1453, 1521, 1526, 1533, 1563, 1586, 1587, 1588, 1644, 1657, 1707, 1734, 1788, 1793, 1816, 1818, 1825, 1874, 1875, 1899, 1909, 1921, 1958, 1964, 1967, 1971, 1988, 1991, 2013, 2018, 2043, 2045, 2052, 2054, 2055, 2061, 2062, 2068, 2074, 2087, 2104, 2106, 2110, 2113, 2116, 2132, 2138, 2145, 2152, 2175, 2186, 2189, 2191, 2195, 2196, 2219, 2220, 2222, 2229, 2232, 2245, 2247, 2252, 2254, 2255, 2270, 2275, 2276, 2292, 2296, 2308, 2360, 2362, 2370, 2374, 2406, 2408, 2433, 2448) ORDER BY `Portfolio`.`created` DESC LIMIT 6 | 6 | 6 | 7 | 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` = 'Portfolio' AND `model_id` IN (2448, 2433, 2408, 2406, 2374, 2370) | 6 | 6 | 1 | maybe slow |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 1 | 1 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 2 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 3 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 4 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 2 | 2 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 5 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8140164' LIMIT 1 | 1 | 1 | 33 | maybe slow |
SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8140100' LIMIT 1 | 1 | 1 | 33 | maybe slow |
SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8420000' LIMIT 1 | 1 | 1 | 34 | maybe slow |
SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8180100' LIMIT 1 | 1 | 1 | 34 | maybe slow |
SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8240600' LIMIT 1 | 1 | 1 | 36 | maybe slow |
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 | 1 | |
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-01-19'))) AND (((`RihoCounter`.`closed` IS NULL) OR (`RihoCounter`.`closed` >= '2021-01-19')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6 | 6 | 6 | 9 | 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 (768, 805, 806, 808, 803, 804) | 6 | 6 | 1 | maybe slow |