【達成率No.1】掲載手数料0円のクラファン＞

ソーシャルグッドな
クラウドファンディング

FOR

なすび変更後

あああああああああああああああああああ

サポーター

テスト　フォーグッド変更後

現在の支援総額
¥39,278,144
/
目標
¥800,000
4909 %
支援者
52 人
残り
54 日

みんなの応援コメント

テストぱん

2025年3月7日

応援しています！

テストぱん

2025年3月7日

応援しています！

FOR GOOD

プロジェクト実行者が支援金を全額受け取れるよう、支援者さまからのシステム利用料（220円＋決済手数料5%）により運営しています。

プロジェクトの相談をする
本文 活動報告 9 応援コメント 49

2023/11/16 13:51

ああ

<

前の活動報告
左り
即時公開？

次の活動報告

>
活動報告の一覧へ
プロジェクト本文へ

リターンを選ぶ

3,000円

後から追加

2023年2月、福岡県の保健所に飼育放棄のために持ち込まれたオスのワンコきょうだいがいました。多頭飼育崩壊が起こり飼育を継続することが困難になったことが原因とのことでした。2023年2月、福岡県の保健所に飼育放棄のために持ち込まれたオスのワンコきょうだいがいました。多頭飼育崩壊が起こり飼育を継続することが困難になったことが原因とのことでした。2023年2月、福岡県の保健所に飼育放棄のために持ち込まれたオスのワンコきょうだいがいました。多頭飼育崩壊

支援者8人

お届け予定2023-11-28

このリターンは終了しました

10,009円

残り968

とにかく応援コース変更後

テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後
テスト・住所登録なし・選択式質問あり変更後テスト・住所登録なし・選択式質問あり変更後
テ

支援者24人

お届け予定2025-12-18

このリターンを選択する

10,000円

あああ

あああ

支援者32人

お届け予定

このリターンは終了しました

3,000円

残り23

「公開後追加」

公開後

支援者2人

お届け予定2023-10-30

このリターンを選択する

5,000円

残り97

とにかく応援コース

あ

支援者3人

お届け予定2023-11-28

このリターンを選択する

9,000円

残り100

bhblk

ああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああ

支援者0人

お届け予定2025-12-18

このリターンを選択する

このプロジェクトを
応援するために、もう一つできること

For Goodは、
みんなでより良い社会を目指す
クラウドファンディングです。

For Goodについて

FOR YOU

あなたにおすすめの
プロジェクト

FOR

は＾

2・28開始
2・28開始
は＾
は＾
70%

残り

54

日

1

人

現在

7,001,000

円
FOR

地域経済の循環

【長崎から全国へ】「観光客のやりたい」×「地域のできる」をビジネスでつなぎたい！
【長崎から全国へ】「観光客のやりたい」×「地域のできる」をビジネスでつなぎたい！
長崎市伊王島地域おこ...
長崎市伊王島地域おこし協力隊：林田...
513 %

残り

54

日

66

人

現在

2,569,721

円
FOR

地域×若者×芸術家

3/2開始消滅可能性自治体に若者とアーティストの泊まれる交流拠点をつくりたい
3/2開始消滅可能性自治体に若者とアーティストの泊まれる交流拠点をつくりたい
山田太郎
山田太郎
335 %

残り

23

日

85

人

現在

671,500

円
FOR

保護犬の居場所

【保護犬の居場所】やっと見つけた！人生の集大成！自分が残せる事！
【保護犬の居場所】やっと見つけた！人生の集大成！自分が残せる事！
テスト実行者テスト実...
テスト実行者テスト実行者テスト実行...
4025 %

残り

54

日

20

人

現在

402,500

円
Messages37TimelineExceptionsViews9RouteQueries17Models19GateSessionRequest
8.1.2PHP Version448msRequest Duration3MBMemory UsageGET project/{project_id}/activity/detail/{activity_report_id}Route
  • infolog[12:46:35] LOG.info: [Controller] Target Controller : ProjectController Method : activityDetail
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[12:46:35] LOG.warning: strtoupper(): Passing null to parameter #1 ($string) of type string is depre...
  • debuglog[12:46:36] LOG.debug: 達成率取得
  • debuglog[12:46:36] LOG.debug: 7001000
  • debuglog[12:46:36] LOG.debug: 10000000
  • debuglog[12:46:36] LOG.debug: 70.01
  • debuglog[12:46:36] LOG.debug: 達成率取得
  • debuglog[12:46:36] LOG.debug: 2569721
  • debuglog[12:46:36] LOG.debug: 500000
  • debuglog[12:46:36] LOG.debug: 513.9442
  • debuglog[12:46:36] LOG.debug: 達成率取得
  • debuglog[12:46:36] LOG.debug: 671500
  • debuglog[12:46:36] LOG.debug: 200000
  • debuglog[12:46:36] LOG.debug: 335.75
  • debuglog[12:46:36] LOG.debug: 達成率取得
  • debuglog[12:46:36] LOG.debug: 402500
  • debuglog[12:46:36] LOG.debug: 10000
  • debuglog[12:46:36] LOG.debug: 4025
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[12:46:36] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
infowarningdebug
  • Booting (9.74ms)
  • Application (438ms)
  • 1 x Application (97.81%)
    438.12ms
    1 x Booting (2.17%)
    9.74ms
    9 templates were rendered
    • project.project_activity_report_detail_pc (resources/views/project/project_activity_report_detail_pc.blade.php)20bladefile
      Params
      0
      project_id
      1
      project
      2
      favorite_count
      3
      favorite
      4
      history_projects
      5
      activity_reports
      6
      activity_report_counts
      7
      support_comments
      8
      support_comment_counts
      9
      url
      10
      color_types
      11
      sort
      12
      activity_report
      13
      previous_activity_report
      14
      next_activity_report
      15
      recommend_projects
      16
      return_items
      17
      latestNotifications
      18
      has_session
      19
      has_project
    • project.project_pc (resources/views/project/project_pc.blade.php)27bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project_id
      4
      project
      5
      favorite_count
      6
      favorite
      7
      history_projects
      8
      activity_reports
      9
      activity_report_counts
      10
      support_comments
      11
      support_comment_counts
      12
      url
      13
      color_types
      14
      sort
      15
      activity_report
      16
      previous_activity_report
      17
      next_activity_report
      18
      recommend_projects
      19
      return_items
      20
      latestNotifications
      21
      has_session
      22
      has_project
      23
      previous_activity_title
      24
      previous_activity_thumbnail
      25
      next_activity_title
      26
      next_activity_thumbnail
    • components.project.wide_card (resources/views/components/project/wide_card.blade.php)15bladefile
      Params
      0
      project
      1
      color_types
      2
      favoriteCount
      3
      favorite
      4
      componentName
      5
      attributes
      6
      resolve
      7
      flushCache
      8
      forgetFactory
      9
      forgetComponentsResolver
      10
      resolveComponentsUsing
      11
      slot
      12
      __laravel_slots
      13
      has_session
      14
      has_project
    • components.project.card (resources/views/components/project/card.blade.php)13bladefile
      Params
      0
      project
      1
      color_types
      2
      componentName
      3
      attributes
      4
      resolve
      5
      flushCache
      6
      forgetFactory
      7
      forgetComponentsResolver
      8
      resolveComponentsUsing
      9
      slot
      10
      __laravel_slots
      11
      has_session
      12
      has_project
    • components.project.card (resources/views/components/project/card.blade.php)13bladefile
      Params
      0
      project
      1
      color_types
      2
      componentName
      3
      attributes
      4
      resolve
      5
      flushCache
      6
      forgetFactory
      7
      forgetComponentsResolver
      8
      resolveComponentsUsing
      9
      slot
      10
      __laravel_slots
      11
      has_session
      12
      has_project
    • components.project.card (resources/views/components/project/card.blade.php)13bladefile
      Params
      0
      project
      1
      color_types
      2
      componentName
      3
      attributes
      4
      resolve
      5
      flushCache
      6
      forgetFactory
      7
      forgetComponentsResolver
      8
      resolveComponentsUsing
      9
      slot
      10
      __laravel_slots
      11
      has_session
      12
      has_project
    • components.project.card (resources/views/components/project/card.blade.php)13bladefile
      Params
      0
      project
      1
      color_types
      2
      componentName
      3
      attributes
      4
      resolve
      5
      flushCache
      6
      forgetFactory
      7
      forgetComponentsResolver
      8
      resolveComponentsUsing
      9
      slot
      10
      __laravel_slots
      11
      has_session
      12
      has_project
    • layouts.header_footer (resources/views/layouts/header_footer.blade.php)35bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project_id
      4
      project
      5
      favorite_count
      6
      favorite
      7
      history_projects
      8
      activity_reports
      9
      activity_report_counts
      10
      support_comments
      11
      support_comment_counts
      12
      url
      13
      color_types
      14
      sort
      15
      activity_report
      16
      previous_activity_report
      17
      next_activity_report
      18
      recommend_projects
      19
      return_items
      20
      latestNotifications
      21
      has_session
      22
      has_project
      23
      previous_activity_title
      24
      previous_activity_thumbnail
      25
      next_activity_title
      26
      next_activity_thumbnail
      27
      component
      28
      i
      29
      created_at
      30
      now
      31
      __currentLoopData
      32
      loop
      33
      return_item
      34
      recommend_project
    • mypage.modal (resources/views/mypage/modal.blade.php)35bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project_id
      4
      project
      5
      favorite_count
      6
      favorite
      7
      history_projects
      8
      activity_reports
      9
      activity_report_counts
      10
      support_comments
      11
      support_comment_counts
      12
      url
      13
      color_types
      14
      sort
      15
      activity_report
      16
      previous_activity_report
      17
      next_activity_report
      18
      recommend_projects
      19
      return_items
      20
      latestNotifications
      21
      has_session
      22
      has_project
      23
      previous_activity_title
      24
      previous_activity_thumbnail
      25
      next_activity_title
      26
      next_activity_thumbnail
      27
      component
      28
      i
      29
      created_at
      30
      now
      31
      __currentLoopData
      32
      loop
      33
      return_item
      34
      recommend_project
    uri
    GET project/{project_id}/activity/detail/{activity_report_id}
    middleware
    web
    controller
    App\Http\Controllers\ProjectController@activityDetail
    namespace
    prefix
    where
    as
    project.activity_detail
    file
    app/Http/Controllers/ProjectController.php:215-310
    17 statements were executed, 3 of which were duplicated, 14 unique. Show only duplicated418ms
    forgood
    • select * from `projects` where `id` = '77704' limit 1
      1.37ms/app/Http/Controllers/ProjectController.php:227forgood
      Metadata
      Bindings
      • 0. 77704
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:227
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `projects`.*, CASE WHEN projects.target_amount > 0 THEN ROUND( IFNULL(support_summaries.price_support, 0) / projects.target_amount * 100, 1) ELSE 0 END AS achievement_rate, ( CASE WHEN projects.end_date IS NULL THEN '指定なし' WHEN projects.start_date IS NULL THEN '指定なし' WHEN projects.start_date > CURRENT_TIME THEN '未公開' ELSE TIMESTAMPDIFF(MINUTE, NOW(),STR_TO_DATE(CONCAT(projects.end_date,' 23:59:59'), '%Y-%m-%d %H:%i:%s')) END ) AS days_left , CASE WHEN projects.is_tran = 0 THEN support_summaries.price_support ELSE trn.total END as price_support, CASE WHEN projects.is_tran = 0 THEN support_summaries.count_support ELSE trn.count END as count_support from `projects` left join `wk_projects` on `projects`.`id` = `wk_projects`.`project_id` and `wk_projects`.`is_delete` = 0 left join ( SELECT supports.project_id, SUM(supports.price_support) as price_support, COUNT(supports.id) as count_support FROM supports WHERE payment_status = 'completed' AND is_delete = 0 GROUP BY project_id ) AS support_summaries on `projects`.`id` = `support_summaries`.`project_id` left join (SELECT ol.product_id as product_id, sum(os.net_total) as total, count(os.net_total) as count FROM wp_wc_order_product_lookup ol, wp_wc_order_stats os where ol.order_id = os.order_id AND os.status = "wc-completed" GROUP BY ol.product_id) as trn on `trn`.`product_id` = `projects`.`id` where CASE -- 申請中 WHEN wk_projects.is_apply_publish = 1 and wk_projects.is_delete = 0 THEN CASE WHEN projects.is_publish = 1 THEN 6 -- 6 : ネクスト申請中 ELSE 2 -- 2 : 公開申請中 END -- 開始日が未設定、もしくは開始日が現在時刻より未来 => 公開前 WHEN projects.start_date IS NULL OR projects.start_date > CURDATE() THEN CASE WHEN projects.is_publish = 1 THEN 3 -- 3 : 承認後公開前 ELSE 1 -- 1 : 公開申請前 END -- 終了日が現在時刻より過去 => 掲載終了 WHEN projects.end_date < CURDATE() THEN CASE WHEN projects.target_amount <= support_summaries.price_support THEN 9 -- 9 : 掲載終了(目標達成) ELSE 8 -- 8 : 掲載終了(目標未達成) END -- 掲載中、かつ支援額が達成 WHEN projects.target_amount <= support_summaries.price_support THEN CASE WHEN projects.next_target_amount IS NULL THEN 5 -- 5 : 掲載中(目標達成、ネクスト) ELSE 7 -- 7 : 掲載中(ネクスト挑戦中) END ELSE 4 -- 4 : 掲載中(目標未達成) END >= 3 and `projects`.`id` = '77704' and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 limit 1
      200ms/app/Models/Project.php:557forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 3
      • 2. 77704
      • 3. 1
      • 4. 0
      Backtrace
      • 15. /app/Models/Project.php:557
      • 16. /app/Http/Controllers/ProjectController.php:402
      • 17. /app/Http/Controllers/ProjectController.php:238
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `projects`.*, (CASE -- 申請中 WHEN wk_projects.is_apply_publish = 1 and wk_projects.is_delete = 0 THEN CASE WHEN projects.is_publish = 1 THEN 6 -- 6 : ネクスト申請中 ELSE 2 -- 2 : 公開申請中 END -- 開始日が未設定、もしくは開始日が現在時刻より未来 => 公開前 WHEN projects.start_date IS NULL OR projects.start_date > CURDATE() THEN -- 公開前 CASE WHEN projects.is_publish = 1 THEN 3 -- 3 : 承認後公開前 ELSE 1 -- 1 : 公開申請前 END -- 終了日が現在時刻より過去 => 掲載終了 WHEN projects.end_date < CURDATE() THEN CASE WHEN projects.target_amount <= support_summaries.price_support THEN 9 -- 9 : 掲載終了(目標達成) ELSE 8 -- 8 : 掲載終了(目標未達成) END -- 掲載中、かつ支援額が達成 WHEN projects.target_amount <= support_summaries.price_support THEN CASE WHEN projects.next_target_amount IS NULL THEN 5 -- 5 : 掲載中(目標達成、ネクスト) ELSE 7 -- 7 : 掲載中(ネクスト挑戦中) END ELSE 4 -- 4 : 掲載中(目標未達成) END) as status from `projects` left join `wk_projects` on `projects`.`id` = `wk_projects`.`project_id` left join ( SELECT project_id, SUM(price_support) as price_support, COUNT(supports.id) as count_support FROM supports WHERE is_delete = 0 AND payment_status = 'completed' GROUP BY project_id ) AS support_summaries on `projects`.`id` = `support_summaries`.`project_id` where (`projects`.`id` = '77704' or `wk_projects`.`project_id` = '77704') and `projects`.`is_delete` = 0 limit 1
      8.53ms/app/Models/Project.php:464forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 77704
      • 2. 0
      Backtrace
      • 15. /app/Models/Project.php:464
      • 16. /app/Http/Controllers/ProjectController.php:406
      • 17. /app/Http/Controllers/ProjectController.php:238
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `favorites` where `project_id` = '77704' and `favorites`.`deleted_at` is null
      410μs/app/Models/Favorite.php:99forgood
      Metadata
      Bindings
      • 0. 77704
      Backtrace
      • 15. /app/Models/Favorite.php:99
      • 16. /app/Http/Controllers/ProjectController.php:414
      • 17. /app/Http/Controllers/ProjectController.php:238
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `activity_reports` where `project_id` = '77704' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 12:46:35' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null order by `publishing_datetime` desc limit 3
      400μs/app/Models/ActivityReport.php:56forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 0
      • 2. 2025-04-07 12:46:35
      • 3. 1
      Backtrace
      • 14. /app/Models/ActivityReport.php:56
      • 15. /app/Http/Controllers/ProjectController.php:427
      • 16. /app/Http/Controllers/ProjectController.php:238
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `activity_reports` where `project_id` = '77704' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 12:46:35' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null
      310μs/app/Models/ActivityReport.php:42forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 0
      • 2. 2025-04-07 12:46:35
      • 3. 1
      Backtrace
      • 15. /app/Models/ActivityReport.php:42
      • 16. /app/Http/Controllers/ProjectController.php:428
      • 17. /app/Http/Controllers/ProjectController.php:238
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `support_comments` inner join `supports` on `supports`.`id` = `support_comments`.`support_id` where `supports`.`project_id` = '77704' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null order by `support_comments`.`created_at` desc limit 3
      1.21ms/app/Models/SupportComment.php:60forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. completed
      • 2. 0
      Backtrace
      • 14. /app/Models/SupportComment.php:60
      • 15. /app/Http/Controllers/ProjectController.php:441
      • 16. /app/Http/Controllers/ProjectController.php:238
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `support_comments` inner join `supports` on `supports`.`id` = `support_comments`.`support_id` where `supports`.`project_id` = '77704' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null
      550μs/app/Models/SupportComment.php:48forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. completed
      • 2. 0
      Backtrace
      • 15. /app/Models/SupportComment.php:48
      • 16. /app/Http/Controllers/ProjectController.php:442
      • 17. /app/Http/Controllers/ProjectController.php:238
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `project_id`, `message`, `url`, `created_at` from `project_notifications` where `project_id` = '77704' and `is_delete` = 0 and `project_notifications`.`deleted_at` is null order by `created_at` desc limit 3
      260μs/app/Models/ProjectNotification.php:36forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 0
      Backtrace
      • 14. /app/Models/ProjectNotification.php:36
      • 15. /app/Http/Controllers/ProjectController.php:448
      • 16. /app/Http/Controllers/ProjectController.php:238
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `return_items`.*, (CASE WHEN `capacity` > 0 THEN `capacity` - `support_quantity` ELSE 0 END) AS remaining_stock_count -- 在庫数 from `return_items` where `project_id` = '77704' and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc
      400μs/app/Models/ReturnItem.php:158forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 0
      • 2. 1
      Backtrace
      • 12. /app/Models/ReturnItem.php:158
      • 13. /app/Http/Controllers/ProjectController.php:254
      • 14. /app/Http/Controllers/Controller.php:23
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `accounts` where `id` = 10193 and `accounts`.`deleted_at` is null limit 1
      330μs/app/Http/Controllers/ProjectController.php:257forgood
      Metadata
      Bindings
      • 0. 10193
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:257
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `accounts` where `id` = 10193 and `accounts`.`deleted_at` is null limit 1
      290μs/app/Http/Controllers/ProjectController.php:257forgood
      Metadata
      Bindings
      • 0. 10193
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:257
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `accounts` where `id` = 10193 and `accounts`.`deleted_at` is null limit 1
      280μs/app/Http/Controllers/ProjectController.php:257forgood
      Metadata
      Bindings
      • 0. 10193
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:257
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `projects`.*, ( CASE WHEN projects.end_date IS NULL THEN '指定なし' WHEN projects.start_date IS NULL THEN '指定なし' WHEN projects.start_date > CURRENT_TIME THEN '未公開' ELSE TIMESTAMPDIFF(MINUTE, NOW(),STR_TO_DATE(CONCAT(projects.end_date,' 23:59:59'), '%Y-%m-%d %H:%i:%s')) END ) AS days_left , `support_summaries`.`price_support` as `total_support_price`, CASE WHEN projects.is_tran = 0 THEN support_summaries.price_support ELSE trn.total END as price_support, CASE WHEN projects.is_tran = 0 THEN support_summaries.count_support ELSE trn.count END as count_support from `projects` left join `wk_projects` on `projects`.`id` = `wk_projects`.`project_id` and `wk_projects`.`is_delete` = 0 left join ( SELECT supports.project_id, SUM(supports.price_support) as price_support, COUNT(supports.id) as count_support FROM supports WHERE payment_status = 'completed' AND is_delete = 0 GROUP BY project_id ) AS support_summaries on `projects`.`id` = `support_summaries`.`project_id` left join (SELECT ol.product_id as product_id, sum(os.net_total) as total, count(os.net_total) as count FROM wp_wc_order_product_lookup ol, wp_wc_order_stats os where ol.order_id = os.order_id AND os.status = "wc-completed" GROUP BY ol.product_id) as trn on `trn`.`product_id` = `projects`.`id` where CASE -- 申請中 WHEN wk_projects.is_apply_publish = 1 and wk_projects.is_delete = 0 THEN CASE WHEN projects.is_publish = 1 THEN 6 -- 6 : ネクスト申請中 ELSE 2 -- 2 : 公開申請中 END -- 開始日が未設定、もしくは開始日が現在時刻より未来 => 公開前 WHEN projects.start_date IS NULL OR projects.start_date > CURDATE() THEN CASE WHEN projects.is_publish = 1 THEN 3 -- 3 : 承認後公開前 ELSE 1 -- 1 : 公開申請前 END -- 終了日が現在時刻より過去 => 掲載終了 WHEN projects.end_date < CURDATE() THEN CASE WHEN projects.target_amount <= support_summaries.price_support THEN 9 -- 9 : 掲載終了(目標達成) ELSE 8 -- 8 : 掲載終了(目標未達成) END -- 掲載中、かつ支援額が達成 WHEN projects.target_amount <= support_summaries.price_support THEN CASE WHEN projects.next_target_amount IS NULL THEN 5 -- 5 : 掲載中(目標達成、ネクスト) ELSE 7 -- 7 : 掲載中(ネクスト挑戦中) END ELSE 4 -- 4 : 掲載中(目標未達成) END >= 4 and IFNULL(DATEDIFF(projects.end_date , CURDATE()), 0) > 0 and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 and `is_closed` = 0 and `projects`.`id` != 77704 order by `total_support_price` desc limit 4
      202ms/app/Models/Project.php:618forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 4
      • 2. 0
      • 3. 1
      • 4. 0
      • 5. 0
      • 6. 77704
      Backtrace
      • 14. /app/Models/Project.php:618
      • 15. /app/Models/Project.php:574
      • 16. /app/Http/Controllers/ProjectController.php:265
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `activity_reports` where `project_id` = '77704' and `id` = '42' and `activity_reports`.`deleted_at` is null limit 1
      390μs/app/Http/Controllers/ProjectController.php:271forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 42
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:271
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `activity_reports` where `project_id` = '77704' and `id` < 42 and `publishing_datetime` <= '2025-04-07 12:46:36' and `is_temporarily` = 0 and `activity_reports`.`deleted_at` is null order by `id` desc limit 1
      460μs/app/Http/Controllers/ProjectController.php:277forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 42
      • 2. 2025-04-07 12:46:36
      • 3. 0
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:277
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `activity_reports` where `project_id` = '77704' and `id` > 42 and `publishing_datetime` <= '2025-04-07 12:46:36' and `is_temporarily` = 0 and `activity_reports`.`deleted_at` is null order by `id` asc limit 1
      380μs/app/Http/Controllers/ProjectController.php:283forgood
      Metadata
      Bindings
      • 0. 77704
      • 1. 42
      • 2. 2025-04-07 12:46:36
      • 3. 0
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:283
      • 16. /app/Http/Controllers/Controller.php:23
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    App\Models\Account
    3
    App\Models\SupportComment
    3
    App\Models\ActivityReport
    6
    App\Models\Project
    7
      _token
      VhjQq6gnPfmDw04nRv4OBTQkXTEESPw6TWKi2ow2
      _previous
      array:1 [ "url" => "https://forgood-jp.com/project/77704/activity/detail/42" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /project/77704/activity/detail/42
      status_code
      200
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      []
      request_request
      []
      request_headers
        0 of 0   
      array:15 [▼
  "host" => array:1 [▶
    0 => "forgood-jp.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]
      request_server
        0 of 0   
      array:44 [▼
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "forgood-jp.com"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "forgood-jp.com"
  "HTTP_HOST" => "forgood-jp.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at forgood-jp.com Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)"
  "SERVER_NAME" => "forgood-jp.com"
  "SERVER_ADDR" => "153.127.29.106"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "18.189.182.32"
  "DOCUMENT_ROOT" => "/var/www/html/forgood/forgood-web/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/forgood/forgood-web/public"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/forgood/forgood-web/public/index.php"
  "REMOTE_PORT" => "21883"
  "REDIRECT_URL" => "/project/77704/activity/detail/42"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/project/77704/activity/detail/42"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743997595.6096
  "REQUEST_TIME" => 1743997595
]
      request_cookies
      []
      response_headers
        0 of 0   
      array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 07 Apr 2025 03:46:36 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZibDg0WFZHQmh1b3RyUzRqeWNGNkE9PSIsInZhbHVlIjoiK0VSUmlTVjJ2cTlUcVhrK3ZBS2x0L0VWWk5wa0ZGaVRNK1g2UWFnVWZwd3JEMG5xSW9STVFILy80VWxubUdnM2dJejI0aE1vNzRIODVKbFRqOFc4dFM2TXN2TGkvOURIQnU1SGVUTlYvY2llMnBzblBuSjhaNkEzdXMvdytPYnQiLCJtYWMiOiI2ZjVmYThhN2Q4Y2Y5NDM5YjBlZjg3NmU4NTg1YjI1Y2RjNDgyMDlhMjlkMDg0ZGMzM2JjYTI2ODJjZTYyYzc1IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 11:46:36 GMT; Max-Age=28800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkZibDg0WFZHQmh1b3RyUzRqeWNGNkE9PSIsInZhbHVlIjoiK0VSUmlTVjJ2cTlUcVhrK3ZBS2x0L0VWWk5wa0ZGaVRNK1g2UWFnVWZwd3JEMG5xSW9STVFILy80VWxubUdnM2dJejI0a ▶"
    1 => "forgood_session=eyJpdiI6IkxSRzY5S3NyUjh6b3Z0eXc3d2cxNFE9PSIsInZhbHVlIjoibnBTNEtZMDNuY0NmOHBUWXZ1WmlPM1NhTXZoM3lTL3pNOTZSVkZaSG9WZ0FaUlZOK2pxTkp4Z0NpUUlFc1lReVFUNjBnSUhCY2JFS2JaRHpzeitmZHNnNTM5WlBya1JRRWI5M3U5RlFTVjFhQkFxQ3J0T2o3WGovamxUaGVvVG0iLCJtYWMiOiJiNWY1ZTBkMmE5MGNjNTc2ZTE0ODA0NTUyYmM4ZjE0NTU1MGFmNjdiNTM3ZjZjYWY2ZGViYTgxOWVkOTBmOGJlIiwidGFnIjoiIn0%3D; path=/; httponly; samesite=lax ◀forgood_session=eyJpdiI6IkxSRzY5S3NyUjh6b3Z0eXc3d2cxNFE9PSIsInZhbHVlIjoibnBTNEtZMDNuY0NmOHBUWXZ1WmlPM1NhTXZoM3lTL3pNOTZSVkZaSG9WZ0FaUlZOK2pxTkp4Z0NpUUlFc1lReVFU ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZibDg0WFZHQmh1b3RyUzRqeWNGNkE9PSIsInZhbHVlIjoiK0VSUmlTVjJ2cTlUcVhrK3ZBS2x0L0VWWk5wa0ZGaVRNK1g2UWFnVWZwd3JEMG5xSW9STVFILy80VWxubUdnM2dJejI0aE1vNzRIODVKbFRqOFc4dFM2TXN2TGkvOURIQnU1SGVUTlYvY2llMnBzblBuSjhaNkEzdXMvdytPYnQiLCJtYWMiOiI2ZjVmYThhN2Q4Y2Y5NDM5YjBlZjg3NmU4NTg1YjI1Y2RjNDgyMDlhMjlkMDg0ZGMzM2JjYTI2ODJjZTYyYzc1IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 11:46:36 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkZibDg0WFZHQmh1b3RyUzRqeWNGNkE9PSIsInZhbHVlIjoiK0VSUmlTVjJ2cTlUcVhrK3ZBS2x0L0VWWk5wa0ZGaVRNK1g2UWFnVWZwd3JEMG5xSW9STVFILy80VWxubUdnM2dJejI0a ▶"
    1 => "forgood_session=eyJpdiI6IkxSRzY5S3NyUjh6b3Z0eXc3d2cxNFE9PSIsInZhbHVlIjoibnBTNEtZMDNuY0NmOHBUWXZ1WmlPM1NhTXZoM3lTL3pNOTZSVkZaSG9WZ0FaUlZOK2pxTkp4Z0NpUUlFc1lReVFUNjBnSUhCY2JFS2JaRHpzeitmZHNnNTM5WlBya1JRRWI5M3U5RlFTVjFhQkFxQ3J0T2o3WGovamxUaGVvVG0iLCJtYWMiOiJiNWY1ZTBkMmE5MGNjNTc2ZTE0ODA0NTUyYmM4ZjE0NTU1MGFmNjdiNTM3ZjZjYWY2ZGViYTgxOWVkOTBmOGJlIiwidGFnIjoiIn0%3D; path=/; httponly ◀forgood_session=eyJpdiI6IkxSRzY5S3NyUjh6b3Z0eXc3d2cxNFE9PSIsInZhbHVlIjoibnBTNEtZMDNuY0NmOHBUWXZ1WmlPM1NhTXZoM3lTL3pNOTZSVkZaSG9WZ0FaUlZOK2pxTkp4Z0NpUUlFc1lReVFU ▶"
  ]
]
      session_attributes
        0 of 0   
      array:4 [▼
  "_token" => "VhjQq6gnPfmDw04nRv4OBTQkXTEESPw6TWKi2ow2"
  "_previous" => array:1 [▶
    "url" => "https://forgood-jp.com/project/77704/activity/detail/42"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]