リフォームお役立ちコンテンツ
部位別でリフォーム記事を検索

全面リフォーム

• 家全体リフォーム

水回りリフォーム

• 浴室リフォーム
• トイレリフォーム
• 洗面リフォーム
• キッチンリフォーム

外回りリフォーム

• 屋根・外壁リフォーム
• ベランダ・バルコニーリフォーム
• 外構・ガーデンスペースリフォーム
• 太陽光リフォーム

居室リフォーム

• リビング・ダイニングリフォーム
• 和室･洋室リフォーム

その他リフォーム

• 窓・サッシリフォーム
• 玄関･廊下リフォーム
• 階段リフォーム
• その他リフォーム

• 
• Session
  +

  Session

  • 0(null)

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerportfolios
  • actionindex
  • named(array)
    • builder_id11
    • adviser_id18
    • area_id12
  • pass(empty)
  • isAjax(false)
  • paging(array)
    • Portfolio(array)
      • page1
      • current20
      • count20
      • prevPage(false)
      • nextPage(false)
      • pageCount1
      • order(array)
        • Portfolio.createdDESC
      • limit24
      • options(empty)
      • paramTypenamed
      • queryScope(null)

  Post data

  • Portfolio(array)
    • area_id12
    • builder_id11
    • adviser_id18

  Query string

  No querystring data.

  Cookie

  • 0(empty)

  Current Route

  • keys(array)
    • 0controller
    • 1action
  • options(array)
    • defaultRoute(true)
  • defaults(array)
    • plugin(null)
  • template/:controller/:action/*

  ====
• Sql Log
  +

  Sql Logs

  default

  Total Time: 403 ms
  Total Queries: 387 queries

  Query	Affected	Num. rows	Took (ms)	Actions
  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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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 (189, 187, 509, 510, 517, 518, 519, 520, 521, 522, 523, 524, 606, 632, 714, 715, 716, 719, 720, 721, 722, 747, 748, 749, 750, 753, 754, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 789, 790, 791, 792, 793, 794, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 823, 832, 833, 834, 835, 836, 837, 838, 839, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 876, 877, 878, 879, 880, 881, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 925, 926, 927, 928, 929, 930, 943, 944, 945, 946, 947, 987, 988, 991, 992, 1006, 1007, 1021, 1022, 1039, 1040, 1552, 1557, 1558, 1559, 1560, 1561, 766, 755, 633)	1	1	1
  SELECT `PortfoliosReformCategory`.`portfolio_id` FROM `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` WHERE `PortfoliosReformCategory`.`reform_category_id` = 98	19	19	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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 (50, 505, 506, 507, 540, 648, 919, 957, 1196, 1537, 1651, 1714, 1738, 1822, 1843, 1857, 1898, 2337, 2424)	1	1	1
  SELECT `PortfoliosReformCategory`.`portfolio_id` FROM `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` WHERE `PortfoliosReformCategory`.`reform_category_id` = 88	77	77	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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 (51, 83, 101, 183, 297, 304, 306, 317, 346, 347, 358, 413, 420, 421, 422, 432, 457, 557, 609, 610, 676, 695, 705, 726, 730, 738, 820, 821, 822, 851, 960, 973, 1045, 1071, 1072, 1095, 1099, 1164, 1177, 1305, 1419, 1428, 1442, 1640, 1671, 1715, 1719, 1771, 1783, 1851, 1854, 1855, 1860, 1895, 1970, 1976, 1980, 1997, 2017, 2060, 2088, 2089, 2111, 2134, 2157, 2183, 2204, 2259, 2298, 2307, 2315, 2330, 2334, 2349, 2364, 2379, 2214)	1	1	1
  SELECT `PortfoliosReformCategory`.`portfolio_id` FROM `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` WHERE `PortfoliosReformCategory`.`reform_category_id` = 99	10	10	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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 (350, 349, 348, 446, 453, 740, 942, 1188, 1540, 1780)	1	1	1
  SELECT `PortfoliosReformCategory`.`portfolio_id` FROM `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` WHERE `PortfoliosReformCategory`.`reform_category_id` = 92	131	131	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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 (35, 162, 163, 160, 199, 294, 312, 314, 318, 426, 428, 444, 449, 456, 459, 468, 469, 472, 473, 474, 476, 479, 480, 482, 504, 508, 539, 651, 656, 657, 678, 679, 739, 741, 817, 818, 819, 918, 948, 958, 966, 976, 983, 985, 986, 997, 998, 999, 1001, 1002, 1003, 1004, 1005, 1018, 1019, 1020, 1035, 1037, 1038, 1047, 1048, 1074, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1090, 1108, 1189, 1201, 1223, 1280, 599, 1182, 202, 1307, 1351, 1352, 1380, 1425, 1455, 1546, 1551, 1585, 1589, 1620, 1650, 1655, 1660, 1664, 1668, 1673, 1678, 1679, 1682, 1736, 1756, 1769, 1148, 967, 684, 683, 500, 742, 1778, 1782, 1819, 1842, 1852, 1870, 1878, 1880, 1881, 1882, 1891, 1915, 1916, 1922, 2006, 2114, 2162, 2181, 2212, 2297, 2348, 2385, 2392, 2428)	1	1	1
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	1
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 1235 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1235 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1235 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	10	10	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` = 'Portfolio' AND model_id = (1235)	1	1	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` = '8000000' LIMIT 1	1	1	32	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 1102 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1102 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1102 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	7	7	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` = 'Portfolio' AND model_id = (1102)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 742 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 742 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 742 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (742)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 549 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 549 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 549 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (549)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 545 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 545 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 545 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	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` = 'Portfolio' AND model_id = (545)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 538 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 538 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 538 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (538)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 534 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	1
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 534 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 534 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (534)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 294 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 294 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 294 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	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` = 'Portfolio' AND model_id = (294)	1	1	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` = '8060000' LIMIT 1	1	1	33	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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 (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 293 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 293 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 293 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	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` = 'Portfolio' AND model_id = (293)	1	1	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` = '8060000' LIMIT 1	1	1	33	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 291 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 291 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 291 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (291)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 285 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 285 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 285 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (285)	1	1	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` = '8060000' LIMIT 1	1	1	33	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 282 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 282 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 282 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (282)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 267 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	1
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 267 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 267 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (267)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 265 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 265 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 265 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (265)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 254 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	5	maybe slow
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 254 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 254 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	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` = 'Portfolio' AND model_id = (254)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 251 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 251 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 251 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	7	7	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` = 'Portfolio' AND model_id = (251)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	5
  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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 237 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 237 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 237 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (237)	1	1	1
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 225 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 225 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 225 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (225)	1	1	1
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	5
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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 (164, 162, 161, 159, 158, 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)	217	217	5
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 219 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	1
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 219 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 219 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	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` = 'Portfolio' AND model_id = (219)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	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 (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	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` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 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)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 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 (164, 162, 161, 159, 158, 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` = 30 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 30 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 30 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	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` = 'Portfolio' AND model_id = (30)	1	1	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` = '8060000' LIMIT 1	1	1	33	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	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-04-19'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-04-19')))) 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 (886, 889, 884, 881, 872, 873)	6	6	1	maybe slow

  98 duplicate queries run.

  Query Explain:

  Click an "Explain" link above, to see the query explanation.

  ====
• Timer
  +

  Memory

  Peak Memory Use 5.83 MB

  Message	Memory use
  Component initialization	1.32 MB
  Controller action start	2.13 MB
  Controller render start	2.78 MB
  View render complete	4.38 MB

  Timers

  Total Request Time: 965 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.27
  Event: Controller.initialize	8.63
  Event: Controller.startup	0.15
  Controller action	37.86
  Event: Controller.beforeRender	1.13
  » Processing toolbar data	1.04
  Rendering View	865.06
  » Event: View.beforeRender	0.72
  » Rendering APP/View/Portfolios/index.ctp	847.17
  » » Rendering APP/View/Elements/Web/breadcrumb.ctp	0.05
  » » Rendering APP/View/Portfolios/_popular.ctp	2.79
  » » Rendering APP/View/Elements/Web/portfolio_search.ctp	195.14
  » » » Rendering APP/View/Elements/Web/builder_search_js.ctp	0.38
  » » » Rendering APP/View/Elements/Web/counter.ctp	0.32
  » » » Rendering APP/View/Elements/Web/pagination.ctp	0.08
  » » Rendering APP/View/Elements/Web/portfolios.ctp	447.94
  » » Rendering APP/View/Elements/Web/counter.ctp #2	0.06
  » » Rendering APP/View/Elements/Web/pagination.ctp #2	0.05
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/default.ctp	16.91
  » » Rendering APP/View/Elements/Web/meta.ctp	0.04
  » » Rendering APP/View/Elements/Web/gdn_code.ctp	0.01
  » » Rendering APP/View/Elements/Web/header.ctp	0.31
  » » » Rendering APP/View/Elements/Web/link.ctp	0.20
  » » » Rendering APP/View/Elements/Web/phone.ctp	0.04
  » » Rendering APP/View/Elements/Web/nav_pc.ctp	0.25
  » » Rendering APP/View/Elements/Web/nav_sp.ctp	0.23
  » » Rendering APP/View/Elements/Web/article_link.ctp	3.90
  » » Rendering APP/View/Elements/Web/events.ctp	11.30
  » » Rendering APP/View/Elements/Web/footer.ctp	0.31
  » » » Rendering APP/View/Elements/Web/link.ctp #2	0.18
  » » » Rendering APP/View/Elements/Web/phone2.ctp	0.02
  » » Rendering APP/View/Elements/Web/ydn_code.ctp	0.01
  Event: View.afterLayout	0.00

  ====
• Log
  +

  Logs

  There were no log entries made this request

  ====
• Variables
  +

  View Variables

  • builders(array)
    • 162株式会社はぴりの
    • 161トシ企画インテリア株式会社
    • 157株式会社セイコー・トータル・ホーム
    • 154株式会社ファンタジスタ
    • 146株式会社ハウジングプラザ 八幡店
    • 145株式会社ハウジングプラザ 本店
    • 144株式会社　小林組
    • 141リフレ福岡株式会社
    • 135有限会社ライフ
    • 134株式会社ホームケア
    • 132株式会社いろは建築技巧
    • 131くりえいとダイイチ
    • 129株式会社エフォート
    • 128株式会社ムサシ
    • 126株式会社スペースデザイン モブ
    • 115株式会社ピュアスマイル
    • 113株式会社青柳工務店
    • 112昭栄物産株式会社
    • 108株式会社リビングデザイン
    • 104株式会社須原建材
    • 97クラフト リノベーションスタジオ
    • 95リフォーム北九州　㈱福喜
    • 86有限会社松本住宅設備
    • 79株式会社リフォームたつみ
    • 75㈱原工務店
    • 71有限会社松永建設
    • 67ＮＡＲＡインテリア
    • 59有限会社丸の内建設
    • 56有限会社住栄ホーム
    • 51ワークショップｋ＆ｆ 株式会社
    • 42有限会社翔鷹技建
    • 39ホームクリエイト悠
    • 37株式会社テクノス
    • 36リフォームのいずみたに
    • 34東洋テクニカ株式会社（ミセスリフォームスタイル）
    • 33株式会社新田中
    • 32TOTO水彩プラザ傳株式会社(北九州小倉店)
    • 31中田ホームズ有限会社(直方営業所)
    • 30中田ホームズ有限会社(飯塚支店)
    • 29株式会社大信住器
    • 25株式会社尾山建設
    • 21株式会社ホーム機器いのくち
    • 20株式会社リューズ
    • 18有限会社横溝工務店
    • 17株式会社福田工務店
    • 16グットリノベーション
    • 15中田ホームズ有限会社(本社)
    • 13有限会社カネタケ
    • 12有限会社アポロ燃機工業
    • 11LIXILリフォームショップ山﨑建材
    • 9株式会社山内工務店
  • advisers(array)
    • 308後藤　洋
    • 307岡根　修平
    • 304吉原　正幸
    • 302近藤　優
    • 289恒宮　和明
    • 288瀬川　里詩
    • 287五嶋　三千代
    • 286坪見　憲人
    • 266田中 隆二
    • 263植山　拓也
    • 258cozy
    • 257安坂　晃一
    • 256安坂　文一
    • 253久木田　弘毅
    • 251岡 祐次
    • 239野中　大志
    • 227江口　礼奈
    • 222青柳　徹也
    • 221藤原　孝彦
    • 220中村　康志
    • 219中山　和大
    • 218光富　誠
    • 217衛藤　雅樹
    • 216永井　康祐
    • 212森　美朗
    • 209須原　聡彦
    • 200江口　雅敏
    • 181松本　龍彦
    • 167鍵本　実
    • 166鍵本　達実
    • 165原　義浩
    • 164嶋田　由美子
    • 163原　和人
    • 148松永　揚治
    • 141楢崎　弘子
    • 140楢崎　晋介
    • 137楢崎　四郎
    • 122内藤　秀典
    • 117檜垣　欣一郎
    • 110木下　和大
    • 109木下　文夫
    • 105石堂　直子
    • 104楠田　るみ子
    • 103谷倉　秀治
    • 98羽矢　文人
    • 97江口　新二
    • 94栗野　紘明
    • 93古賀　哲夫
    • 92泉谷　勇吾
    • 89田中　邦和
    • 83吉田　勝実
    • 80元吉　敏文
    • 76尾山　幸男
    • 68重村　英臣
    • 62朝　巧
    • 61吉田　伸一郎
    • 60福田　秀典
    • 56鎌田　親人
    • 55鬼武　昂輔
    • 54小田　圭介
    • 52中田　進
    • 45濱島　節子
    • 44兼竹　義彦
    • 43和田 剛志
    • 42山﨑　星児
    • 31本田 照子
    • 25中原　竜一
    • 21岩崎　誠
    • 20山﨑　祥子
    • 19本田　浩二
    • 18大崎　勝也
  • crumbs(array)
    • 0(array)
      • title施工事例検索
  • smartphoneTopPortfolios(array)
    • 0(array)
      • SmartphoneTopPortfolio(array)
        • id264
        • portfolio_id2407
        • sort1
        • created2021-04-16 15:50:33
        • modified2021-04-16 15:50:33
      • Portfolio(array)
        • id2407
        • subject北欧風リフォーム　～　キャットウォークのある吹き抜け　～
        • budget約８００万円
        • construction_period４５日間
        • postcode8140100
        • areaname福岡市城南区
        • main_image(array)
          • id26708
          • modelPortfolio
          • model_id2407
          • field_namemain_image
          • file_nametop画像.jpg
          • file_content_typeimage/jpeg
          • file_size133342
          • created2020-09-02 10:11:59
          • modified2020-09-02 10:11:59
          • file_path/var/www/riho2/app/tmp/file/Portfolio/2407/main_image/top画像.jpg
          • bindedModelAttachment
        • tagsペット,デザイン,アンティーク,アクセント,防犯,省エネ
      • Tag(array)
        • 0(array)
          • id14
          • nameペット
          • PortfoliosTag(array)
            • id2700
            • portfolio_id2407
            • tag_id14
        • 1(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id2701
            • portfolio_id2407
            • tag_id42
        • 2(array)
          • id25
          • nameアンティーク
          • PortfoliosTag(array)
            • id2702
            • portfolio_id2407
            • tag_id25
        • 3(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id2703
            • portfolio_id2407
            • tag_id36
        • 4(array)
          • id39
          • name防犯
          • PortfoliosTag(array)
            • id4814
            • portfolio_id2407
            • tag_id39
        • 5(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id5018
            • portfolio_id2407
            • tag_id1
    • 1(array)
      • SmartphoneTopPortfolio(array)
        • id263
        • portfolio_id549
        • sort2
        • created2021-04-13 13:14:17
        • modified2021-04-13 13:14:17
      • Portfolio(array)
        • id549
        • subject家族が自然に集まるキッチン
        • budget150万円
        • construction_period４日間
        • postcode
        • areaname
        • main_image(array)
          • id3504
          • modelPortfolio
          • model_id549
          • field_namemain_image
          • file_nameK様　後1.JPG
          • file_content_typeimage/jpeg
          • file_size3184841
          • created2014-08-04 19:48:21
          • modified2014-08-04 19:48:21
          • file_path/var/www/riho2/app/tmp/file/Portfolio/549/main_image/K様　後1.JPG
          • bindedModelAttachment
        • tags収納,デザイン,お掃除,照明,アクセント,壁紙
      • Tag(array)
        • 0(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id9415
            • portfolio_id549
            • tag_id33
        • 1(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id9416
            • portfolio_id549
            • tag_id42
        • 2(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id9417
            • portfolio_id549
            • tag_id40
        • 3(array)
          • id23
          • name照明
          • PortfoliosTag(array)
            • id9418
            • portfolio_id549
            • tag_id23
        • 4(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id9419
            • portfolio_id549
            • tag_id36
        • 5(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id9420
            • portfolio_id549
            • tag_id38
    • 2(array)
      • SmartphoneTopPortfolio(array)
        • id262
        • portfolio_id77
        • sort3
        • created2021-04-09 11:01:37
        • modified2021-04-09 11:01:37
      • Portfolio(array)
        • id77
        • subject寝室とキッチンを作り変え
        • budget1470万円
        • construction_period2ヶ月
        • postcode8140000
        • areaname
        • main_image(array)
          • id1163
          • modelPortfolio
          • model_id77
          • field_namemain_image
          • file_namet-tei_after_4.jpg
          • file_content_typeimage/jpeg
          • file_size147411
          • created2014-03-17 17:26:28
          • modified2014-03-17 17:26:28
          • file_path/var/www/riho2/app/tmp/file/Portfolio/77/main_image/t-tei_after_4.jpg
          • bindedModelAttachment
        • tagsデザイン,収納,壁紙,お掃除,断熱,安全
      • Tag(array)
        • 0(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id4617
            • portfolio_id77
            • tag_id42
        • 1(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id4618
            • portfolio_id77
            • tag_id33
        • 2(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id4619
            • portfolio_id77
            • tag_id38
        • 3(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id4620
            • portfolio_id77
            • tag_id40
        • 4(array)
          • id6
          • name断熱
          • PortfoliosTag(array)
            • id4621
            • portfolio_id77
            • tag_id6
        • 5(array)
          • id41
          • name安全
          • PortfoliosTag(array)
            • id4622
            • portfolio_id77
            • tag_id41
    • 3(array)
      • SmartphoneTopPortfolio(array)
        • id261
        • portfolio_id2125
        • sort4
        • created2021-04-06 10:35:19
        • modified2021-04-06 10:35:19
      • Portfolio(array)
        • id2125
        • subject人生設計～退職『前』に全面改装！
        • budget800万円
        • construction_period60日間
        • postcode8150000
        • areaname
        • main_image(array)
          • id23469
          • modelPortfolio
          • model_id2125
          • field_namemain_image
          • file_nameTOP.jpg
          • file_content_typeimage/jpeg
          • file_size193146
          • created2020-02-18 13:53:44
          • modified2020-02-18 13:53:44
          • file_path/var/www/riho2/app/tmp/file/Portfolio/2125/main_image/TOP.jpg
          • bindedModelAttachment
        • tags間取り,壁紙,お掃除,省エネ,収納,アクセント,テレビ
      • Tag(array)
        • 0(array)
          • id15
          • name間取り
          • PortfoliosTag(array)
            • id8906
            • portfolio_id2125
            • tag_id15
        • 1(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id8907
            • portfolio_id2125
            • tag_id38
        • 2(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id8908
            • portfolio_id2125
            • tag_id40
        • 3(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id8909
            • portfolio_id2125
            • tag_id1
        • 4(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id8910
            • portfolio_id2125
            • tag_id33
        • 5(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id8911
            • portfolio_id2125
            • tag_id36
        • 6(array)
          • id20
          • nameテレビ
          • PortfoliosTag(array)
            • id8912
            • portfolio_id2125
            • tag_id20
    • 4(array)
      • SmartphoneTopPortfolio(array)
        • id260
        • portfolio_id1103
        • sort5
        • created2021-04-02 11:05:02
        • modified2021-04-02 11:05:02
      • Portfolio(array)
        • id1103
        • subject出来るだけ自然素材をとりいれたい！
        • budget1500万円
        • construction_period３ヶ月間
        • postcode
        • areaname
        • main_image(array)
          • id7995
          • modelPortfolio
          • model_id1103
          • field_namemain_image
          • file_nametopアフター内部k邸.JPG
          • file_content_typeimage/jpeg
          • file_size3740600
          • created2014-12-22 16:39:14
          • modified2014-12-22 16:39:15
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1103/main_image/topアフター内部k邸.JPG
          • bindedModelAttachment
        • tags間取り,自然素材,省エネ,アクセント
      • Tag(array)
        • 0(array)
          • id15
          • name間取り
          • PortfoliosTag(array)
            • id8179
            • portfolio_id1103
            • tag_id15
        • 1(array)
          • id30
          • name自然素材
          • PortfoliosTag(array)
            • id8180
            • portfolio_id1103
            • tag_id30
        • 2(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id8181
            • portfolio_id1103
            • tag_id1
        • 3(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id8182
            • portfolio_id1103
            • tag_id36
  • portfolios(array)
    • 0(array)
      • Portfolio(array)
        • id1235
        • builder_id11
        • adviser_id18
        • subject二人仕様の広さに、スペースも「断捨離」　第二の人生を送る和モダン住空間
        • headlineご主人様の現役引退やご実家が空家になることなどが重なり、これからどうするかを考えていた矢先、昨今のリフォーム技術の高さを知ったのが始まり。 築６１年のお宅、２階建てのうち１階を全面リフォーム。８畳の和室を減築し、縁側をリビングに、使いやすい空間を確保しました。
        • postcode8000000
        • areaname
        • cost1400
        • adviser_commentお施主様の将来のことを考えながら、コンパクトな家づくりを行いました。構造上、残さなくてはならない柱を活かして部屋の配置を考えました。
        • modified2020-11-19 09:26:12
        • created2015-07-17 08:50:52
        • main_image(array)
          • id9989
          • modelPortfolio
          • model_id1235
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size744190
          • created2015-07-17 08:50:52
          • modified2015-07-17 08:50:52
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1235/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 1(array)
      • Portfolio(array)
        • id1102
        • builder_id11
        • adviser_id18
        • subject憩の場へと一新　間取り変更によって実現した寛ぎのＬＤＫ
        • headline築３４年のマンションは、部屋が細かく仕切られ、太陽光が入りにくいスペースが多くありました。また、キッチンや浴室の老朽化などの理由から、改装を決断しました。
        • postcode
        • areaname
        • cost620
        • adviser_comment築年数の古いマンションを、現在のご夫婦の生活スタイルに合わせたカタチで改装。機能面とデザイン面を良質したお住まいです。
        • modified2020-11-19 09:27:08
        • created2014-12-19 12:27:56
        • main_image(array)
          • id7976
          • modelPortfolio
          • model_id1102
          • field_namemain_image
          • file_name1.jpg
          • file_content_typeimage/jpeg
          • file_size1441742
          • created2014-12-19 12:29:06
          • modified2014-12-19 12:29:06
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1102/main_image/1.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 2(array)
      • Portfolio(array)
        • id742
        • builder_id11
        • adviser_id18
        • subject店舗リフォーム～ドックサロン☆～
        • headlineビルの通路と２階一室を改装し、ドッグサロンをオープン!! 大きな窓ガラス取り付け、室内を明るく、また外から中の様子も伺えるつくりにしました。
        • postcode
        • areaname
        • cost400
        • adviser_comment小倉北区のオフィスビルの通路だった場所と２階の一室を、新店舗オープンに伴い店舗工事をさせていただきました。
        • modified2020-11-19 09:28:57
        • created2014-08-29 18:57:46
        • main_image(array)
          • id5013
          • modelPortfolio
          • model_id742
          • field_namemain_image
          • file_name無題.png
          • file_content_typeimage/png
          • file_size503352
          • created2014-08-29 19:02:49
          • modified2014-08-29 19:02:49
          • file_path/var/www/riho2/app/tmp/file/Portfolio/742/main_image/無題.png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 3(array)
      • Portfolio(array)
        • id549
        • builder_id11
        • adviser_id18
        • subject家族が自然に集まるキッチン
        • headline小さなお子様が２人いらっしゃるＫ様のために、いつもリビングに目が行き届く対面型キッチンをご提案しました。ＬＩＸＩＬのシステムキッチン『サンヴァリエ リシェル』は、フォルムのデザイン性はもちろん、充実した収納設備や節水型の水栓など、"便利＆エコ"の機能が満載です。
        • postcode
        • areaname
        • cost150
        • adviser_comment工事着工前に奥様からお部屋全体のクロスの汚れが目立つとご相談をお受けしました。 調べた結果、クロスの糊がきちんと拭けてなかったのでゴミが付着し汚れが目立っていました。工事最終日に美装業者の方に落としていただきました。この結果、お部屋全体がより明るくなりました。
        • modified2020-11-19 09:35:30
        • created2014-08-04 19:48:21
        • main_image(array)
          • id3504
          • modelPortfolio
          • model_id549
          • field_namemain_image
          • file_nameK様　後1.JPG
          • file_content_typeimage/jpeg
          • file_size3184841
          • created2014-08-04 19:48:21
          • modified2014-08-04 19:48:21
          • file_path/var/www/riho2/app/tmp/file/Portfolio/549/main_image/K様　後1.JPG
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 4(array)
      • Portfolio(array)
        • id545
        • builder_id11
        • adviser_id18
        • subjectフロアタイル使用で強い床に
        • headlineトイレのクロスと床の張替え、洗面化粧台のリフォームです。 床はＣＦシート（クッションフロアシート）を貼りました。クッション性が高く、水がこぼれても大丈夫なので、洗面・脱衣室やトイレなどに適しています。しかもトイレはテラコッタ風のＣＦシートに。お気に入りの床にリフォームできました。
        • postcode
        • areaname
        • cost25
        • adviser_commentテラコッタ風の床がいい雰囲気ですね。壁も真っ白に張替え清潔感のあるトイレになりました。
        • modified2020-11-19 09:37:03
        • created2014-08-04 18:40:30
        • main_image(array)
          • id3478
          • modelPortfolio
          • model_id545
          • field_namemain_image
          • file_name新しい画像 (9).png
          • file_content_typeimage/png
          • file_size1135820
          • created2014-08-04 18:40:30
          • modified2014-08-04 18:40:30
          • file_path/var/www/riho2/app/tmp/file/Portfolio/545/main_image/新しい画像 (9).png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 5(array)
      • Portfolio(array)
        • id538
        • builder_id11
        • adviser_id18
        • subject天窓塞ぎ　ユニットバスを導入
        • headline天窓やジャグジー窓の為、冬が寒いとお困りだったN様。 天窓をなくし、上げ下げ窓に変更したことで、冬場もゆっくりお風呂に入れるようになりました。 浴槽は、「キレイ浴槽」でお掃除もしやすくなりました。 浴室入口の段差もなくなり、バリアフリーで安心です。
        • postcode
        • areaname
        • cost160
        • adviser_comment換気乾燥暖房機を取り付けたことにより換気機能はもちろん、浴室空間を快適に調節できるようになりました。
        • modified2020-11-19 09:38:03
        • created2014-08-04 17:41:42
        • main_image(array)
          • id3461
          • modelPortfolio
          • model_id538
          • field_namemain_image
          • file_name新しい画像 (1).png
          • file_content_typeimage/png
          • file_size897880
          • created2014-08-04 17:46:03
          • modified2014-08-04 17:46:03
          • file_path/var/www/riho2/app/tmp/file/Portfolio/538/main_image/新しい画像 (1).png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 6(array)
      • Portfolio(array)
        • id534
        • builder_id11
        • adviser_id18
        • subject明るく柔らかな玄関で迎える
        • headlineリフォーム前は道路から丸見えだったお庭。防犯面での心配もありましたので、今回しっかりと外壁を設けました。
        • postcode
        • areaname
        • cost(null)
        • adviser_commentすべて壁にしてしまうのではなく、枕木やガラスブロックをアクセントに解放感とプライバシーを確保しました。
        • modified2020-11-19 09:38:28
        • created2014-08-04 17:03:41
        • main_image(array)
          • id3450
          • modelPortfolio
          • model_id534
          • field_namemain_image
          • file_name新しい画像.png
          • file_content_typeimage/png
          • file_size848333
          • created2014-08-04 17:05:36
          • modified2014-08-04 17:05:36
          • file_path/var/www/riho2/app/tmp/file/Portfolio/534/main_image/新しい画像.png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 7(array)
      • Portfolio(array)
        • id294
        • builder_id11
        • adviser_id18
        • subjectトイレ手洗器のリフォーム
        • headline今回のご依頼は「トイレの手洗いをコンパクトにして、水栓を自動水栓にしたい」という事でした。 現場調査をした際に、手洗器は出幅２０センチとコンパクトになったのですが、自動水栓にするには電気が必要でした。Ｔ様のトイレにはコンセントがありませんでしたので、電気不要の「アクエナジー」付きの自動水栓に取り替えました。 「アクエナジー」は吐水のパワーで自己発電するので電気の節約と、水の節約とってもでエコロジーなリフォームとなりました。
        • postcode8060000
        • areaname(null)
        • cost7.5
        • adviser_comment「アクエナジー」は吐水のパワーで自己発電するので電気の節約と、水の節約とってもでエコロジーなリフォームとなりました。
        • modified2019-12-07 12:45:27
        • created2014-07-08 17:39:38
        • main_image(array)
          • id2433
          • modelPortfolio
          • model_id294
          • field_namemain_image
          • file_nametoile15after01.jpg
          • file_content_typeimage/jpeg
          • file_size42069
          • created2014-07-08 17:41:53
          • modified2014-07-08 17:41:53
          • file_path/var/www/riho2/app/tmp/file/Portfolio/294/main_image/toile15after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 8(array)
      • Portfolio(array)
        • id293
        • builder_id11
        • adviser_id18
        • subject収納◎お掃除◎デザイン◎ なトイレ
        • headline老朽化に伴い、LIXIL　エレシャスに取替えました。 『 以前はタンクの後ろまで、手を伸ばしてお掃除をするのが大変でした。 しかし、これからはキャビネットを拭くだけなので、とっても楽にお掃除が出来ます。』とお施主様。 今回は便器の交換のみでしたが、キャビネットの木目調が雰囲気をガラっと変えてくれています。 以前より落ち着きのある空間になりました。
        • postcode8060000
        • areaname
        • cost16
        • adviser_commentたっぷりしまえるキャビネットが付いたインテリアトイレ“エレシャス”。便器まわりもスッキリでお掃除もラクラクです。
        • modified2020-11-19 09:52:39
        • created2014-07-08 17:21:11
        • main_image(array)
          • id2432
          • modelPortfolio
          • model_id293
          • field_namemain_image
          • file_nametoile21after01.jpg
          • file_content_typeimage/jpeg
          • file_size46421
          • created2014-07-08 17:21:11
          • modified2014-07-08 17:21:11
          • file_path/var/www/riho2/app/tmp/file/Portfolio/293/main_image/toile21after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 9(array)
      • Portfolio(array)
        • id291
        • builder_id11
        • adviser_id18
        • subjectぬくもりのあるトイレ空間
        • headline和式トイレから洋式トイレ「LIXIL　エレシャス」にリフォームしました。 洋式トイレに変更することで足腰の負担がなくなり、使い勝手がよりくりました。 エレシャスは背面に収納があるため、見た目がスッキリとし、収納力は抜群です。 また便器回りの掃除は背面収納の手前までと、手が届きお掃除がとても簡単です。 以前はタイル張りだった壁や床は木目調に変更し、ぬくもりのある空間になりました。
        • postcode
        • areaname
        • cost40
        • adviser_commentエレシャスは背面に収納があるため、見た目がスッキリとし、収納力は抜群です。 また便器回りの掃除は背面収納の手前までと、手が届きお掃除がとても簡単です。
        • modified2020-11-19 09:53:30
        • created2014-07-08 16:20:51
        • main_image(array)
          • id2430
          • modelPortfolio
          • model_id291
          • field_namemain_image
          • file_nametoile18after01.jpg
          • file_content_typeimage/jpeg
          • file_size130446
          • created2014-07-08 16:20:51
          • modified2014-07-08 16:20:51
          • file_path/var/www/riho2/app/tmp/file/Portfolio/291/main_image/toile18after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 10(array)
      • Portfolio(array)
        • id285
        • builder_id11
        • adviser_id18
        • subjectゆったり広々トイレ
        • headline従来のタンク付きトイレよりも奥行寸法が14センチも小さくなったタンクレストイレ「サティス」にリフォームしました。 今回は換気扇連動型人感センサー付ダウンライトを取り付けたので、スイッチを押さなくても照明が点灯し、換気扇が作動します。 さらに、洗面化粧台もサイズアップし、奥様の家事動線を考慮して今まであった場所から位置を変更しました。 その他にも、トイレのドアや外部の排水管、玄関照明やインターホンなど、住まいの気になる部分もご相談いただき、リフォームさせていただきました。
        • postcode8060000
        • areaname
        • cost168
        • adviser_commentさらに、住まいの気になる部分もご相談いただき、リフォームさせていただきました。洗面化粧台もサイズアップし、奥様の家事動線を考慮して今まであった場所から位置を変更しました。 その他にも、トイレのドアや外部の排水管、玄関照明やインターホンなど。ありがとうございました。
        • modified2020-11-19 09:55:02
        • created2014-07-07 18:29:00
        • main_image(array)
          • id2401
          • modelPortfolio
          • model_id285
          • field_namemain_image
          • file_nametoile16after01.jpg
          • file_content_typeimage/jpeg
          • file_size33735
          • created2014-07-07 18:29:00
          • modified2014-07-07 18:29:00
          • file_path/var/www/riho2/app/tmp/file/Portfolio/285/main_image/toile16after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 11(array)
      • Portfolio(array)
        • id282
        • builder_id11
        • adviser_id18
        • subjectホテルのようなトイレ空間
        • headlineタンクレストイレの「サティス」と、家具のような手洗いカウンター「セレビオ」を組み合わせてホテルのような佇まいのトイレ空間になりました。
        • postcode
        • areaname
        • cost51
        • adviser_comment 壁には脱臭効果のある健康建材「エコカラットタイル」を貼りました。 ナチュラルな石面凹凸のデザインなので、ライティングによる陰影が美しい壁面を演出します。
        • modified2020-11-19 09:55:59
        • created2014-07-07 18:11:54
        • main_image(array)
          • id2396
          • modelPortfolio
          • model_id282
          • field_namemain_image
          • file_nametoile13after01.jpg
          • file_content_typeimage/jpeg
          • file_size28568
          • created2014-07-07 18:11:54
          • modified2014-07-07 18:11:54
          • file_path/var/www/riho2/app/tmp/file/Portfolio/282/main_image/toile13after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 12(array)
      • Portfolio(array)
        • id267
        • builder_id11
        • adviser_id18
        • subject家族みなさまが使いやすい♪
        • headline家族みなさまが使いやすい、ＬＩＸＩＬピアラに取替えです。90ｃｍ幅の大きな洗面ボウルは、バケツや洗面桶を置いたままでも作業が出来るほどの大きさです。そして洗面ボウルの右には濡らしたくないものを置く場所、左には濡れたものを乾かす場所があるため大変使いやすい形になっています。
        • postcode
        • areaname
        • cost20
        • adviser_comment家族みなさまが使いやすい、ＬＩＸＩＬピアラに取替えです。90ｃｍ幅の大きな洗面ボウルは、バケツや洗面桶を置いたままでも作業が出来るほどの大きさです。そして洗面ボウルの右には濡らしたくないものを置く場所、左には濡れたものを乾かす場所があるため大変使いやすい形になっています。
        • modified2020-11-19 09:59:32
        • created2014-07-07 12:37:47
        • main_image(array)
          • id2364
          • modelPortfolio
          • model_id267
          • field_namemain_image
          • file_namewashroom12after01.jpg
          • file_content_typeimage/jpeg
          • file_size438120
          • created2014-07-07 12:43:00
          • modified2014-07-07 12:43:00
          • file_path/var/www/riho2/app/tmp/file/Portfolio/267/main_image/washroom12after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 13(array)
      • Portfolio(array)
        • id265
        • builder_id11
        • adviser_id18
        • subject洗面化粧台は3面鏡内部もすべて収納できます。
        • headline以前は洗濯機を置いていましたが今回は洗面化粧台を設置しました。洗面化粧台は3面鏡内部もすべて収納できます。隣の収納扉も既存の枠の色にあわせて作り替えをしました。床にはINAX　ｻｰﾓﾀｲﾙを使用し　ヒヤッと感じにくくしました。
        • postcode
        • areaname
        • cost26
        • adviser_comment以前は洗濯機を置いていましたが今回は洗面化粧台を設置しました。洗面化粧台は3面鏡内部もすべて収納できます。隣の収納扉も既存の枠の色にあわせて作り替えをしました。床にはINAX　ｻｰﾓﾀｲﾙを使用し　ヒヤッと感じにくくしました。
        • modified2020-11-19 10:00:07
        • created2014-07-07 11:37:28
        • main_image(array)
          • id2361
          • modelPortfolio
          • model_id265
          • field_namemain_image
          • file_nameo0336044811180848055.jpg
          • file_content_typeimage/jpeg
          • file_size17063
          • created2014-07-07 11:37:28
          • modified2014-07-07 11:37:28
          • file_path/var/www/riho2/app/tmp/file/Portfolio/265/main_image/o0336044811180848055.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 14(array)
      • Portfolio(array)
        • id254
        • builder_id11
        • adviser_id18
        • subjectNo1キッチン
        • headline今回は「汚れにくい」「お掃除しやすい」にポイントを置いてLIXILの「リシェル」にリフォームしました。
        • postcode
        • areaname
        • cost99
        • adviser_comment以前のキッチンは壁がタイル張りの為コンロまわりの汚れが気になっていたそうです。 今回は「汚れにくい」「お掃除しやすい」にポイントを置いてLIXILの「リシェル」にリフォームしました。
        • modified2020-11-19 10:07:39
        • created2014-07-05 13:38:43
        • main_image(array)
          • id2350
          • modelPortfolio
          • model_id254
          • field_namemain_image
          • file_nameキャプチャ.PNG
          • file_content_typeimage/png
          • file_size185166
          • created2014-07-05 13:38:43
          • modified2014-07-05 13:38:43
          • file_path/var/www/riho2/app/tmp/file/Portfolio/254/main_image/キャプチャ.PNG
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 15(array)
      • Portfolio(array)
        • id251
        • builder_id11
        • adviser_id18
        • subject女性の心をくすぐるキッチン
        • headlineキッチンはクリナップの「新クリンレディ」にリフォームしました。新クリンレディは扉や引き出しの床板もステンレスのなので汚れが付きにくく、丈夫でお掃除ラクラクです。オール電化にしたので、もちろんIHクッキングヒーターに♪
        • postcode
        • areaname
        • cost285
        • adviser_commentキッチン・浴室・洗面・オール電化と水廻りりのオールリフレッシュをされたH様のキッチンリフォームです。パールピンクのシンクやワゴンタイプで収納力抜群のコーナーキャビネットなど、女性の心をくすぐるキッチンになりました。
        • modified2020-11-19 10:09:32
        • created2014-07-04 19:50:28
        • main_image(array)
          • id2347
          • modelPortfolio
          • model_id251
          • field_namemain_image
          • file_namekitchen17after01.jpg
          • file_content_typeimage/jpeg
          • file_size38849
          • created2014-07-04 19:51:53
          • modified2014-07-04 19:51:53
          • file_path/var/www/riho2/app/tmp/file/Portfolio/251/main_image/kitchen17after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 16(array)
      • Portfolio(array)
        • id237
        • builder_id11
        • adviser_id18
        • subjectバスルームを上質なインテリア空間に
        • headlineLIXILのシステムバス「ラ・バス」を採用。 壁パネルを鏡面パネル（柄入り）全面張りにしたことで、艶ある高級感あふれる浴室空間となりました。
        • postcode
        • areaname
        • cost175
        • adviser_commentバスルームを上質なインテリア空間に変える艶やかな壁パネルで"趣と味わいのある"バスルームになりました。
        • modified2020-11-19 13:17:28
        • created2014-07-04 18:16:03
        • main_image(array)
          • id9859
          • modelPortfolio
          • model_id237
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size144822
          • created2015-06-17 10:43:17
          • modified2015-06-17 10:43:17
          • file_path/var/www/riho2/app/tmp/file/Portfolio/237/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 17(array)
      • Portfolio(array)
        • id225
        • builder_id11
        • adviser_id18
        • subject念願だった　足を伸ばしてゆっ~くり入浴！
        • headline既存は在来の浴室。浴槽はかなり狭く、脚をかかえての入浴でした。リフォームし、スペースいっぱいに浴槽を設置したので、足を伸ばしてゆっくり入浴することができるようになりました。
        • postcode
        • areaname
        • cost104
        • adviser_commentシステムバス『ラ・バス』を採用しました。浴槽にはステップがついているので、腰を掛けて半身浴も楽しめます。
        • modified2020-11-19 13:21:27
        • created2014-07-03 21:36:39
        • main_image(array)
          • id9811
          • modelPortfolio
          • model_id225
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size164941
          • created2015-06-11 16:50:09
          • modified2015-06-11 16:50:09
          • file_path/var/www/riho2/app/tmp/file/Portfolio/225/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 18(array)
      • Portfolio(array)
        • id219
        • builder_id11
        • adviser_id18
        • subject在来浴室でもシステムバス風に!!
        • headline在来浴室ですが『システムバス風　バスルーム』に生まれ変わりました。 床には冷たさを感じにくいINAXｻｰﾓﾀｲﾙ　ﾐﾙｷｰDXⅡを採用。冬場でもヒヤッとしにくく、また滑りにくいので安心して入浴できます。
        • postcode
        • areaname
        • cost82
        • adviser_comment全タイル張りの浴室からパネル仕上げのバスルームになりました。 在来の浴室なのに『システムバス風　バスルーム』に生まれ変わりました。 床にはINAX　ｻｰﾓﾀｲﾙ　ﾐﾙｷｰDXⅡ　を使用しました。冷たさを感じにくいので 冬場でもヒヤッとしにくく、また滑りにくいので安心して入浴できます。
        • modified2020-11-19 13:24:29
        • created2014-07-03 09:24:21
        • main_image(array)
          • id2259
          • modelPortfolio
          • model_id219
          • field_namemain_image
          • file_namebathroom14after01.jpg
          • file_content_typeimage/jpeg
          • file_size44301
          • created2014-07-03 09:24:21
          • modified2014-07-03 09:24:21
          • file_path/var/www/riho2/app/tmp/file/Portfolio/219/main_image/bathroom14after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 19(array)
      • Portfolio(array)
        • id30
        • builder_id11
        • adviser_id18
        • subject築32年のマンションを、海辺のリゾートホテル風に。
        • headline床、壁ともに白を採用した住まいは、海辺のリゾートホテルを思わせる涼やかな雰囲気に。各部屋のトーンを合わせて、スタイリッシュさを強調しました。
        • postcode8060000
        • areaname
        • cost614
        • adviser_commentお施主様が希望されるプランを組み合わせて、和モダンテイストを完成させました。
        • modified2020-11-19 13:56:04
        • created2013-12-20 22:44:17
        • main_image(array)
          • id413
          • modelPortfolio
          • model_id30
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size744648
          • created2013-12-20 22:44:17
          • modified2013-12-20 22:44:17
          • file_path/var/www/riho2/app/tmp/file/Portfolio/30/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
  • isSearch(true)
  • familyStructures(array)
    • 1単身（一人暮らし）
    • 2単身（親と同居）
    • 3夫婦のみ
    • 4夫婦（子供あり）
    • 5夫婦（親・子供・3世代）
  • tastes(array)
    • 67モダン
    • 68和モダン
    • 69シンプル
    • 70南欧風
    • 71北欧風
    • 72アジア風
    • 73ナチュラル
    • 74レトロモダン
    • 75古民家風
    • 76職人/デザイナー
    • 77眺望を活かす
    • 78隠れ家的
    • 79倉庫風
    • 102自分好み
    • 103使い勝手良く
  • areas(empty)
  • residenceStatuses(array)
    • 30一戸建て
    • 33マンション
    • 93店舗
    • 100その他
  • populatedPlaces(array)
    • 19都市部
    • 20郊外
    • 21新興住宅地
    • 22旧来の住宅地
    • 23リゾート
    • 24平地
    • 25高台
    • 26傾斜地
    • 27海沿い
    • 28川沿い
    • 29山沿い
  • lifestages(array)
    • 12結婚
    • 13出産
    • 14兄弟が増える
    • 15子供独立
    • 16二世帯
    • 17老後
    • 18子供へ
  • wideAreas(array)
    • 5下関・山口エリア
    • 1福岡エリア
    • 2北九州エリア
    • 3筑豊エリア
    • 4筑後エリア
    • 6佐賀エリア
    • 7中津・大分エリア
  • tags(array)
    • 44書斎
    • 43リノベーション
    • 42デザイン
    • 34趣味
    • 41安全
    • 38壁紙
    • 28造作
    • 33収納
    • 39防犯
  • is_smartphone(false)
  • baseUrl/
  • $request->data(array)
    • Portfolio(array)
      • area_id12
      • builder_id11
      • adviser_id18
  • $this->validationErrors(array)
    • WideArea(empty)
    • Category(empty)
    • Portfolio(empty)
    • Attachment(empty)
    • Tag(empty)
    • Builder(empty)
    • BuildersArea(empty)
    • Adviser(empty)
    • SmartphoneTopPortfolio(empty)
    • PortfoliosTag(empty)
  • Loaded Helpers(array)
    • 0Session
    • 1Form
    • 2Html
    • 3Paginator
    • 4ImageLabel
    • 5Escape
    • 6Number
    • 7SimpleGraph
    • 8DebugTimer
    • 9Toolbar
    • 10Format
    • 11Time
    • 12HtmlToolbar

  ====
• Environment
  +

  App Constants

  Constant	Value
  CONFIG	'/var/www/riho2/app/Config/'
  USE_DEBUGLIB	true
  FILE_STORAGE_STORE_PATH	'/var/www/riho2/app/tmp/FileStorage/'
  AJAX_FILE_UPLOAD_WRAPPER_SUFFIX	'_wrapper'
  AJAX_FILE_UPLOAD_FILE_FIELD_SUFFIX	'_ajax'
  AJAX_FILE_UPLOAD_HIDDEN_FIELD_SUFFIX	'_cash'
  AJAX_FILE_UPLOAD_CASH_MODEL_ID	'cash'
  AJAX_FILE_UPLOAD_FILE_PATH	'/var/www/riho2/app/tmp/files/'
  AJAX_FILE_UPLOAD_TMP_PATH	'/var/www/riho2/app/tmp/files/cache/'
  BLOCK_CONTENTS_PLUGIN_NAME	'BlockContents'
  EXPORT_PATH	'/tmp/'
  DEFAULT_CONFIG	'default'
  BACKUP_ROTATE	(int) 3
  FILE_STORAGE_TEMPORARY	'/var/www/riho2/app/tmp/FileStorageTmp/'
  FILE_STORAGE_STRAGETYPE_LOCAL	'local'
  FILE_STORAGE_STRAGETYPE_S3	's3'
  SECURIMAGE_PATH	'/var/www/riho2/app/Plugin/Securimage/'
  TINYMCE_PLUGIN_NAME	'TinyMce'
  SITE_TITLE	'リフォームならRiho（リホ）|福岡・北九州・山口・佐賀・大分で展開中'
  ADMIN_SITE_TITLE	'Riho管理サイト'
  SENDER_ADDRESS	'sender@ri-ho.jp'
  SENDER_NAME	'RIHO'
  CATEGORY_TYPE_FAMILY_STRUCTURE	(int) 1
  CATEGORY_TYPE_AGE	(int) 2
  CATEGORY_TYPE_LIFESTAGE	(int) 3
  CATEGORY_TYPE_POPULATED_PLACE	(int) 4
  CATEGORY_TYPE_RESIDENCE_STATUS	(int) 5
  CATEGORY_TYPE_LIFESTYLE	(int) 6
  CATEGORY_TYPE_REPAIR	(int) 7
  CATEGORY_TYPE_REFRESH	(int) 8
  CATEGORY_TYPE_REFORM	(int) 9
  CATEGORY_TYPE_TASTE	(int) 10
  CATEGORY_TYPE_FACULTY	(int) 11
  CATEGORY_TYPE_MEISTER_WORK	(int) 12
  EVENT_TYPE_OPENHOUSE	(int) 1
  EVENT_TYPE_EVENT	(int) 2
  BUILDER_TYPE_AREA	(int) 1
  BUILDER_TYPE_LARGE	(int) 2
  BUILDER_TYPE_PERSONAL	(int) 3
  BUILDER_TYPE_SPEED	(int) 4
  ADVISER_NEW_CREATED	'-14 day'
  ADVISER_NEW_LABEL	'登録2週間以内！'
  ADVISER_HOT_PORTFOLIO_COUNT	(int) 20
  FILEBINDER_FILE_PATH	'/var/www/riho2/app/tmp/file/'
  FILEBINDER_TMP_PATH	'/var/www/riho2/app/tmp/file/cache/'
  FILEBINDER_FILE_FIELD_SUFFIX	'_buffer'
  FILEBINDER_FILE_FIELD_DELETE	'delete_'
  REFORM_CATEGORY_TYPE_ALL	(int) 1
  REFORM_CATEGORY_TYPE_WATER	(int) 2
  REFORM_CATEGORY_TYPE_OUTER	(int) 3
  REFORM_CATEGORY_TYPE_ROOM	(int) 4
  REFORM_CATEGORY_TYPE_OTHER	(int) 5
  MAIN_AREA_COOKIE_NAME	'main_area_id'
  MAIN_AREA_COOKIE_LIFETIME	'+1 month'
  REFORM_PACK_COOKIE_NAME	'REFORM_PACK'
  INQUIRY_SUMMARY_SESSION_NAME	'Inquiry.summary'
  CONTACT_TYPE_KITAKYUSHU	(int) 1
  RIHO_COUNTER_URL	'http://riho2.ri-ho.jp/riho_counter'
  RIHO_EVENT_URL	'http://event.ri-ho.jp/'
  CONTENT_IMAGE_BASE_URL	'/images/upload/articles'
  CONTENT_IMAGE_BASE_PATH	'/var/www/riho2/app/webroot/images/upload/articles'
  REFORM_PACK_URL	'pdf/De-Repa_2017-03-27.pdf'
  RIHO_COUNTER_COUNT	(int) 6
  GOOGLE_MAP_API_KEY	'AIzaSyAoakoSB5NvntNjtfnjBmgNr4v8vqa9wkI'
  GOOD_VALUE_KIND_MAKER_CAMPAIGN	(int) 1
  GOOD_VALUE_KIND_EVENT	(int) 2
  GOOD_VALUE_KIND_PACK	(int) 3
  INSTAGRAM_URL	'https://www.instagram.com/reformpotal/'
  USE_TRUE	(int) 1
  USE_FALSE	(int) 2
  DENHITI_REQUEST_KIND_1	(int) 1
  DENHITI_REQUEST_KIND_2	(int) 2
  DENHITI_REQUEST_KIND_3	(int) 3
  DENHITI_REQUEST_OPTION_1	(int) 1
  DENHITI_REQUEST_OPTION_2	(int) 2
  DENHITI_REQUEST_OPTION_3	(int) 3
  DENHITI_REQUEST_OPTION_4	(int) 4
  DENHITI_REQUEST_OPTION_5	(int) 5
  DENHITI_REQUEST_OPTION_6	(int) 6
  DENHITI_REQUEST_OPTION_7	(int) 7
  PORTFOLIOS_COUNT	'2,000'
  FOUNDING_YEARS	'139'

  CakePHP Constants

  Constant	Value
  APP	'/var/www/riho2/app/'
  APP_DIR	'app'
  APPLIBS	'/var/www/riho2/app/Lib/'
  CACHE	'/var/www/riho2/app/tmp/cache/'
  CAKE	'/var/www/riho2/Vendor/cakephp/cakephp/lib/Cake/'
  CAKE_CORE_INCLUDE_PATH	'/var/www/riho2/Vendor/cakephp/cakephp/lib'
  CORE_PATH	'/var/www/riho2/Vendor/cakephp/cakephp/lib/'
  CAKE_VERSION	'2.10.20'
  CSS	'/var/www/riho2/app/webroot/css/'
  CSS_URL	'css/'
  DS	'/'
  FULL_BASE_URL	'http://riho2.ri-ho.jp'
  IMAGES	'/var/www/riho2/app/webroot/img/'
  IMAGES_URL	'img/'
  JS	'/var/www/riho2/app/webroot/js/'
  JS_URL	'js/'
  LOGS	'/var/www/riho2/app/tmp/logs/'
  ROOT	'/var/www/riho2'
  TESTS	'/var/www/riho2/app/Test/'
  TMP	'/var/www/riho2/app/tmp/'
  VENDORS	'/var/www/riho2/vendors/'
  WEBROOT_DIR	'webroot'
  WWW_ROOT	'/var/www/riho2/app/webroot/'

  PHP Environment

  Environment Variable	Value
  Php Version	'7.3.17'
  Redirect Redirect Unique Id	'YHyRnuo5LOE40yrYil3uIAAAAAA'
  Redirect Redirect Cake Env Mode	'riho2'
  Redirect Redirect Status	'200'
  Redirect Unique Id	'YHyRnuo5LOE40yrYil3uIAAAAAA'
  Redirect Cake Env Mode	'riho2'
  Redirect Status	'200'
  Unique Id	'YHyRnuo5LOE40yrYil3uIAAAAAA'
  Cake Env Mode	'riho2'
  Http User Agent	'CCBot/2.0 (https://commoncrawl.org/faq/)'
  Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  Http Accept Language	'en-US,en;q=0.5'
  Http Accept Encoding	'br,gzip'
  Http Host	'riho2.ri-ho.jp'
  Http Connection	'Keep-Alive'
  Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
  Server Signature	''
  Server Software	'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.17'
  Server Name	'riho2.ri-ho.jp'
  Server Addr	'153.127.48.136'
  Server Port	'80'
  Remote Addr	'3.227.208.0'
  Document Root	'/var/www/riho2'
  Request Scheme	'http'
  Context Prefix	''
  Context Document Root	'/var/www/riho2'
  Server Admin	'root@localhost'
  Script Filename	'/var/www/riho2/app/webroot/index.php'
  Remote Port	'46174'
  Redirect Url	'/app/webroot/portfolios/index/builder_id:11/adviser_id:18/area_id:12'
  Gateway Interface	'CGI/1.1'
  Server Protocol	'HTTP/1.1'
  Request Method	'GET'
  Query String	''
  Request Uri	'/portfolios/index/builder_id:11/adviser_id:18/area_id:12'
  Script Name	'/app/webroot/index.php'
  Php Self	'/app/webroot/index.php'
  Request Time Float	(float) 1618776478.809
  Request Time	(int) 1618776478

  ====
• Include
  +

  Included Files

  Include Paths

  • 1/usr/share/pear
  • 2/usr/share/php
  • 3-> /var/www/riho2/Vendor/cakephp/cakephp/lib/Cake/

  Included Files

  • core(array)
    • Behavior(array)
      • 0CORE/Model/Behavior/ContainableBehavior.php
    • Cache(array)
      • 0CORE/Cache/Cache.php
      • 1CORE/Cache/Engine/FileEngine.php
      • 2CORE/Cache/CacheEngine.php
    • Component(array)
      • 0CORE/Controller/Component/SessionComponent.php
      • 1CORE/Controller/Component/FlashComponent.php
      • 2CORE/Controller/Component/CookieComponent.php
      • 3CORE/Controller/Component/RequestHandlerComponent.php
      • 4CORE/Controller/Component/PaginatorComponent.php
    • Config(array)
      • 0CORE/Config/routes.php
      • 1CORE/Config/config.php
    • Controller(array)
      • 0CORE/Controller/Controller.php
      • 1CORE/Controller/ComponentCollection.php
      • 2CORE/Controller/Component.php
    • Datasource(array)
      • 0CORE/Model/Datasource/CakeSession.php
      • 1CORE/Model/Datasource/Database/Mysql.php
      • 2CORE/Model/Datasource/DboSource.php
      • 3CORE/Model/Datasource/DataSource.php
    • Error(array)
      • 0CORE/Error/exceptions.php
      • 1CORE/Error/ErrorHandler.php
    • I18n(array)
      • 0CORE/I18n/I18n.php
      • 1CORE/I18n/L10n.php
    • Log(array)
      • 0CORE/Log/CakeLog.php
      • 1CORE/Log/LogEngineCollection.php
      • 2CORE/Log/Engine/FileLog.php
      • 3CORE/Log/Engine/BaseLog.php
      • 4CORE/Log/CakeLogInterface.php
    • Model(array)
      • 0CORE/Model/Model.php
      • 1CORE/Model/BehaviorCollection.php
      • 2CORE/Model/ModelBehavior.php
      • 3CORE/Model/ConnectionManager.php
    • Network(array)
      • 0CORE/Network/CakeRequest.php
      • 1CORE/Network/CakeResponse.php
    • Other(array)
      • 0CORE/bootstrap.php
      • 1CORE/basics.php
      • 2CORE/Core/App.php
      • 3CORE/Core/Configure.php
      • 4CORE/Core/CakePlugin.php
      • 5CORE/Event/CakeEventListener.php
      • 6CORE/Event/CakeEvent.php
      • 7CORE/Event/CakeEventManager.php
      • 8CORE/Core/CakeObject.php
    • Routing(array)
      • 0CORE/Routing/Router.php
      • 1CORE/Routing/Route/CakeRoute.php
      • 2CORE/Routing/Route/PluginShortRoute.php
      • 3CORE/Routing/Dispatcher.php
      • 4CORE/Routing/Filter/AssetDispatcher.php
      • 5CORE/Routing/DispatcherFilter.php
      • 6CORE/Routing/Filter/CacheDispatcher.php
    • Utility(array)
      • 0CORE/Utility/Hash.php
      • 1CORE/Utility/Inflector.php
      • 2CORE/Utility/Folder.php
      • 3CORE/Utility/ObjectCollection.php
      • 4CORE/Utility/Debugger.php
      • 5CORE/Utility/CakeText.php
      • 6CORE/Utility/Set.php
      • 7CORE/Utility/ClassRegistry.php
    • View(array)
      • 0CORE/View/Helper.php
      • 1CORE/View/HelperCollection.php
  • app(array)
    • Behavior(array)
      • 0APP/Model/Behavior/AssociationValidationBehavior.php
      • 1APP/Model/Behavior/RihoBehavior.php
      • 2APP/Model/Behavior/TagUtilityBehavior.php
      • 3APP/Model/Behavior/HabtmValidateBehavior.php
    • Config(array)
      • 0APP/Config/core.php
      • 1APP/Config/bootstrap.php
      • 2APP/Config/maintenance.php
      • 3APP/Config/riho_counter.php
      • 4APP/Config/Bootstraps/staging.php
      • 5APP/Config/routes.php
      • 6APP/Config/meta.php
      • 7APP/Config/meta_static.php
      • 8APP/Config/database.php
    • Controller(array)
      • 0APP/Controller/PortfoliosController.php
      • 1APP/Lib/Controller/WebAppController.php
      • 2APP/Lib/Controller/AppController.php
    • Model(array)
      • 0APP/Model/WideArea.php
      • 1APP/Lib/Model/AppModel.php
      • 2APP/Model/Category.php
      • 3APP/Model/Portfolio.php
      • 4APP/Model/Tag.php
      • 5APP/Model/Builder.php
      • 6APP/Model/BuildersArea.php
      • 7APP/Model/Adviser.php
      • 8APP/Model/SmartphoneTopPortfolio.php
    • Other(array)
      • 0APP/webroot/index.php
      • 1APP/Vendor/debuglib.php
    • View(array)
      • 0APP/View/Helper/AppHelper.php
  • plugins(array)
    • AjaxFileUpload(array)
      • Config(array)
        • 0AjaxFileUpload/Config/bootstrap.php
    • BlockContents(array)
      • Config(array)
        • 0BlockContents/Config/bootstrap.php
    • Cakeplus(array)
      • Behavior(array)
        • 0Cakeplus/Model/Behavior/ValidationPatternsBehavior.php
        • 1Cakeplus/Model/Behavior/ValidationErrorI18nBehavior.php
        • 2Cakeplus/Model/Behavior/AddValidationRuleBehavior.php
    • ControllerPrefix(array)
      • Plugin(array)
        • 0ControllerPrefix/Lib/Routing/Route/ControllerPrefixRoute.php
    • DbBackup(array)
      • Config(array)
        • 0DbBackup/Config/bootstrap.php
    • DebugKit(array)
      • Component(array)
        • 0DebugKit/Controller/Component/ToolbarComponent.php
      • Plugin(array)
        • 0DebugKit/Lib/DebugMemory.php
        • 1DebugKit/Lib/Panel/SessionPanel.php
        • 2DebugKit/Lib/DebugPanel.php
        • 3DebugKit/Lib/Panel/RequestPanel.php
        • 4DebugKit/Lib/Panel/SqlLogPanel.php
        • 5DebugKit/Lib/Panel/TimerPanel.php
        • 6DebugKit/Lib/Panel/LogPanel.php
        • 7DebugKit/Lib/Log/Engine/DebugKitLog.php
        • 8DebugKit/Lib/Panel/VariablesPanel.php
        • 9DebugKit/Lib/Panel/EnvironmentPanel.php
        • 10DebugKit/Lib/Panel/IncludePanel.php
        • 11DebugKit/Lib/DebugTimer.php
    • Escape(array)
      • Component(array)
        • 0Escape/Controller/Component/EscapeComponent.php
    • FileStorage(array)
      • Config(array)
        • 0FileStorage/Config/bootstrap.php
    • Filebinder(array)
      • Plugin(array)
        • 0Filebinder/View/Helper/LabelHelper.php
      • Behavior(array)
        • 0Filebinder/Model/Behavior/BindableBehavior.php
    • Imagebinder(array)
      • Plugin(array)
        • 0Imagebinder/View/Helper/ImageLabelHelper.php
    • Maintenance(array)
      • Component(array)
        • 0Maintenance/Controller/Component/MaintenanceComponent.php
    • Multivalidatable(array)
      • Behavior(array)
        • 0Multivalidatable/Model/Behavior/MultivalidatableBehavior.php
    • Search(array)
      • Component(array)
        • 0Search/Controller/Component/PrgComponent.php
      • Behavior(array)
        • 0Search/Model/Behavior/SearchableBehavior.php
    • Securimage(array)
      • Config(array)
        • 0Securimage/Config/bootstrap.php
    • TinyMce(array)
      • Config(array)
        • 0TinyMce/Config/bootstrap.php

  ====