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

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

FOR

キーワード10001

プロジェクトタイトルですですです

サポーター

テストアカウント

現在の支援総額
¥275,000
/
目標
¥10,000
2750 %
支援者
28 人
残り
終了
プロジェクトは終了しました

みんなの応援コメント

vvv

2023年7月11日

ccc

テストテストテストテストテストテストテスト

2023年6月19日

テストテストテストテストテストテストテストテストテスト テストテストテストテストテストテストテストテストテスト テストテストテストテストテストテストテストテストテスト テストテスト...

FOR GOOD

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

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

実行者からのメッセージ

プロジェクトのメッセージ

プロジェクトのポイント

1.プロジェクトのポイント1

2.プロジェクトのポイント2

3.プロジェクトのポイント3

プロジェクトの詳細


支援金の使い道


さいごに


PROFILE

テストアカウント

プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　プロフィール　

リターンを選ぶ

1,000円

残り19

リターンアイテム1

説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文

支援者1人

お届け予定

プロジェクトは終了しました

1,000円

残り16

リターンアイテム2

説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文

支援者4人

お届け予定

プロジェクトは終了しました

1,000円

残り10

リターンアイテム3

説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文説明文

支援者10人

お届け予定

プロジェクトは終了しました

最新の活動レポート

2024.12.23

っf

っf

2024.07.03

s

a

2024.05.13

Body&Coのコンセプトムービーを公開致しました📣

ああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああ...

もっと見る

みんなの応援コメント

vvv

2023年7月11日

ccc

テストテストテストテストテストテストテスト

2023年6月19日

テストテストテストテストテストテストテストテストテスト テストテストテストテストテストテストテストテストテスト テストテストテストテストテスト...

それ

2023年6月19日

ここ

もっと見る

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

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

For Goodについて

FOR YOU

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

FOR

なすび変更後

あああああああああああああああああああ
あああああああああああああああああああ
テスト　フォーグッド...
テスト　フォーグッド変更後
4909 %

残り

54

日

52

人

現在

39,278,144

円
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

円
Messages31TimelineExceptionsViews9RouteQueries17Models17GateSessionRequest
8.1.2PHP Version652msRequest Duration3MBMemory UsageGET project/{project_id}Route
  • infolog[18:29:17] LOG.info: [Controller] Target Controller : ProjectController Method : show
  • debuglog[18:29:18] LOG.debug: 達成率取得
  • debuglog[18:29:18] LOG.debug: 671500
  • debuglog[18:29:18] LOG.debug: 200000
  • debuglog[18:29:18] LOG.debug: 335.75
  • debuglog[18:29:18] LOG.debug: 達成率取得
  • debuglog[18:29:18] LOG.debug: 39278144
  • debuglog[18:29:18] LOG.debug: 800000
  • debuglog[18:29:18] LOG.debug: 4909.768
  • debuglog[18:29:18] LOG.debug: 達成率取得
  • debuglog[18:29:18] LOG.debug: 7001000
  • debuglog[18:29:18] LOG.debug: 10000000
  • debuglog[18:29:18] LOG.debug: 70.01
  • debuglog[18:29:18] LOG.debug: 達成率取得
  • debuglog[18:29:18] LOG.debug: 2569721
  • debuglog[18:29:18] LOG.debug: 500000
  • debuglog[18:29:18] LOG.debug: 513.9442
  • debuglog[18:29:18] LOG.debug: 達成率取得
  • debuglog[18:29:18] LOG.debug: 671500
  • debuglog[18:29:18] LOG.debug: 200000
  • debuglog[18:29:18] LOG.debug: 335.75
  • debuglog[18:29:18] LOG.debug: recordAccessLog
  • debuglog[18:29:18] LOG.debug: array ( 'project_id' => 10001, 'account_id' => NULL, 'inflow_route' => '...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[18:29:18] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
infodebugwarning
  • Booting (8.61ms)
  • Application (643ms)
  • 1 x Application (98.67%)
    643.07ms
    1 x Booting (1.32%)
    8.61ms
    9 templates were rendered
    • project.project_main_pc (resources/views/project/project_main_pc.blade.php)15bladefile
      Params
      0
      project
      1
      favorite
      2
      favorite_count
      3
      history_projects
      4
      recommend_projects
      5
      activity_reports
      6
      return_items
      7
      activity_report_counts
      8
      support_comments
      9
      support_comment_counts
      10
      url
      11
      color_types
      12
      latestNotifications
      13
      has_session
      14
      has_project
    • project.project_pc (resources/views/project/project_pc.blade.php)24bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project
      4
      favorite
      5
      favorite_count
      6
      history_projects
      7
      recommend_projects
      8
      activity_reports
      9
      return_items
      10
      activity_report_counts
      11
      support_comments
      12
      support_comment_counts
      13
      url
      14
      color_types
      15
      latestNotifications
      16
      has_session
      17
      has_project
      18
      content_value
      19
      usage_support_value
      20
      last_word_value
      21
      i
      22
      created_at
      23
      now
    • 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)29bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project
      4
      favorite
      5
      favorite_count
      6
      history_projects
      7
      recommend_projects
      8
      activity_reports
      9
      return_items
      10
      activity_report_counts
      11
      support_comments
      12
      support_comment_counts
      13
      url
      14
      color_types
      15
      latestNotifications
      16
      has_session
      17
      has_project
      18
      content_value
      19
      usage_support_value
      20
      last_word_value
      21
      i
      22
      created_at
      23
      now
      24
      component
      25
      __currentLoopData
      26
      loop
      27
      return_item
      28
      recommend_project
    • mypage.modal (resources/views/mypage/modal.blade.php)29bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      project
      4
      favorite
      5
      favorite_count
      6
      history_projects
      7
      recommend_projects
      8
      activity_reports
      9
      return_items
      10
      activity_report_counts
      11
      support_comments
      12
      support_comment_counts
      13
      url
      14
      color_types
      15
      latestNotifications
      16
      has_session
      17
      has_project
      18
      content_value
      19
      usage_support_value
      20
      last_word_value
      21
      i
      22
      created_at
      23
      now
      24
      component
      25
      __currentLoopData
      26
      loop
      27
      return_item
      28
      recommend_project
    uri
    GET project/{project_id}
    middleware
    web
    controller
    App\Http\Controllers\ProjectController@show
    namespace
    prefix
    where
    as
    project.index
    file
    app/Http/Controllers/ProjectController.php:31-119
    17 statements were executed623ms
    forgood
    • select * from `projects` where `id` = 10001 limit 1
      1.45ms/app/Http/Controllers/ProjectController.php:44forgood
      Metadata
      Bindings
      • 0. 10001
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:44
      • 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` = 10001 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. 10001
      • 3. 1
      • 4. 0
      Backtrace
      • 15. /app/Models/Project.php:557
      • 16. /app/Http/Controllers/ProjectController.php:402
      • 17. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 or `wk_projects`.`project_id` = 10001) and `projects`.`is_delete` = 0 limit 1
      3.71ms/app/Models/Project.php:464forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 10001
      • 2. 0
      Backtrace
      • 15. /app/Models/Project.php:464
      • 16. /app/Http/Controllers/ProjectController.php:406
      • 17. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 and `favorites`.`deleted_at` is null
      410μs/app/Models/Favorite.php:99forgood
      Metadata
      Bindings
      • 0. 10001
      Backtrace
      • 15. /app/Models/Favorite.php:99
      • 16. /app/Http/Controllers/ProjectController.php:414
      • 17. /app/Http/Controllers/ProjectController.php:52
      • 18. /app/Http/Controllers/Controller.php:23
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `activity_reports` where `project_id` = 10001 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 18:29:17' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null order by `publishing_datetime` desc limit 3
      460μs/app/Models/ActivityReport.php:56forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 0
      • 2. 2025-04-07 18:29:17
      • 3. 1
      Backtrace
      • 14. /app/Models/ActivityReport.php:56
      • 15. /app/Http/Controllers/ProjectController.php:427
      • 16. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 18:29:17' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null
      310μs/app/Models/ActivityReport.php:42forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 0
      • 2. 2025-04-07 18:29:17
      • 3. 1
      Backtrace
      • 15. /app/Models/ActivityReport.php:42
      • 16. /app/Http/Controllers/ProjectController.php:428
      • 17. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 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
      750μs/app/Models/SupportComment.php:60forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. completed
      • 2. 0
      Backtrace
      • 14. /app/Models/SupportComment.php:60
      • 15. /app/Http/Controllers/ProjectController.php:441
      • 16. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null
      460μs/app/Models/SupportComment.php:48forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. completed
      • 2. 0
      Backtrace
      • 15. /app/Models/SupportComment.php:48
      • 16. /app/Http/Controllers/ProjectController.php:442
      • 17. /app/Http/Controllers/ProjectController.php:52
      • 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` = 10001 and `is_delete` = 0 and `project_notifications`.`deleted_at` is null order by `created_at` desc limit 3
      340μs/app/Models/ProjectNotification.php:36forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 0
      Backtrace
      • 14. /app/Models/ProjectNotification.php:36
      • 15. /app/Http/Controllers/ProjectController.php:448
      • 16. /app/Http/Controllers/ProjectController.php:52
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `accounts` where `id` = 10000 and `accounts`.`deleted_at` is null limit 1
      360μs/app/Http/Controllers/ProjectController.php:70forgood
      Metadata
      Bindings
      • 0. 10000
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:70
      • 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` = 10017 and `accounts`.`deleted_at` is null limit 1
      330μs/app/Http/Controllers/ProjectController.php:70forgood
      Metadata
      Bindings
      • 0. 10017
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:70
      • 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` = 10024 and `accounts`.`deleted_at` is null limit 1
      360μs/app/Http/Controllers/ProjectController.php:70forgood
      Metadata
      Bindings
      • 0. 10024
      Backtrace
      • 15. /app/Http/Controllers/ProjectController.php:70
      • 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 `return_items`.*, (CASE WHEN `capacity` > 0 THEN `capacity` - `support_quantity` ELSE 0 END) AS remaining_stock_count -- 在庫数 from `return_items` where `project_id` = 10001 and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc
      440μs/app/Models/ReturnItem.php:158forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 0
      • 2. 1
      Backtrace
      • 12. /app/Models/ReturnItem.php:158
      • 13. /app/Http/Controllers/ProjectController.php:76
      • 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 `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` != 10001 and `projects`.`category` = 'ANIMAL' order by `total_support_price` desc limit 4
      206ms/app/Models/Project.php:618forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 4
      • 2. 0
      • 3. 1
      • 4. 0
      • 5. 0
      • 6. 10001
      • 7. ANIMAL
      Backtrace
      • 14. /app/Models/Project.php:618
      • 15. /app/Models/Project.php:574
      • 16. /app/Http/Controllers/ProjectController.php:80
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • 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` != 10001 order by `total_support_price` desc limit 4
      205ms/app/Models/Project.php:618forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 4
      • 2. 0
      • 3. 1
      • 4. 0
      • 5. 0
      • 6. 10001
      Backtrace
      • 14. /app/Models/Project.php:618
      • 15. /app/Models/Project.php:579
      • 16. /app/Http/Controllers/ProjectController.php:80
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `project_access_logs` where `project_id` = 10001 and `access_date` = '2025-04-07' limit 1
      910μs/app/Models/ProjectAccessLog.php:29forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 2025-04-07
      Backtrace
      • 15. /app/Models/ProjectAccessLog.php:29
      • 16. /app/Http/Controllers/ProjectController.php:97
      • 17. /app/Http/Controllers/Controller.php:23
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • insert into `project_access_logs` (`project_id`, `access_date`, `access_count`, `updated_at`, `created_at`) values (10001, '2025/04/07', 1, '2025-04-07 18:29:18', '2025-04-07 18:29:18')
      1.79ms/app/Models/ProjectAccessLog.php:44forgood
      Metadata
      Bindings
      • 0. 10001
      • 1. 2025/04/07
      • 2. 1
      • 3. 2025-04-07 18:29:18
      • 4. 2025-04-07 18:29:18
      Backtrace
      • 20. /app/Models/ProjectAccessLog.php:44
      • 21. /app/Http/Controllers/ProjectController.php:97
      • 22. /app/Http/Controllers/Controller.php:23
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    App\Models\Account
    3
    App\Models\SupportComment
    3
    App\Models\ActivityReport
    3
    App\Models\Project
    8
      _token
      Vgxa7sxno7W3V5Vwt0Ti7wiyog57fi2H8xt3E6yA
      _previous
      array:1 [ "url" => "https://forgood-jp.com/project/10001" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /project/10001
      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" => "3.134.111.219"
  "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" => "64213"
  "REDIRECT_URL" => "/project/10001"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/project/10001"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744018157.6681
  "REQUEST_TIME" => 1744018157
]
      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 09:29:18 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRkdS9meG1zZnJVN1hTaUh2RVNnNnc9PSIsInZhbHVlIjoiM2IrcE5GRTRFZ3R1Vk94T1lsM1orUUwxaHRsZ1J2UmU2c013UjNTcEhmZXgrSEdkYnFjNGEveTRVeFRtaXN1WTdVR2ZCWlZpWlNrV0Qyd1ZraGVpL05GUkRwR1lIVkVianNRQkZFUGQ3ODg1U3ZRZ3hQQWR5cTd5T2VYTWpTVmMiLCJtYWMiOiJmOWE1MjFhN2Y4Njc0MTAxNTFjOTkzOWY3ZGM2NTBjYjJkNjYwMjA1MWY1ZDZiY2I0NTNkNzI1MDliOTkzZmE3IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 17:29:18 GMT; Max-Age=28800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjRkdS9meG1zZnJVN1hTaUh2RVNnNnc9PSIsInZhbHVlIjoiM2IrcE5GRTRFZ3R1Vk94T1lsM1orUUwxaHRsZ1J2UmU2c013UjNTcEhmZXgrSEdkYnFjNGEveTRVeFRtaXN1WTdVR2ZCW ▶"
    1 => "forgood_session=eyJpdiI6IkhpZ2t2T3VqM3lidEoxdTJtU0dLUUE9PSIsInZhbHVlIjoicHVqbkV2UllkSWFBY3lYcitiTXJrYlI2bzkvNTRBbzRKQVZMejlydjV3YVZXS2dCSmxJcmM4L0dhOFA5YTB4MEx3QzZuVng5S3dtVStGb3J1OUxlbVhHUFUxN1VGdlMrNUhBSnVoZjc4YnBja08yY2tmWVZGM0lpU0dwdDVVQ0QiLCJtYWMiOiJhMmU4YzBiNGMxYjhlNjNmYzU5MDU1NTk0ZjQ3ZjM0ZGZmYjE0NjQ0M2Q2ZmQ5Mzc3ZDYxNDMxMWNkOGVjZDAyIiwidGFnIjoiIn0%3D; path=/; httponly; samesite=lax ◀forgood_session=eyJpdiI6IkhpZ2t2T3VqM3lidEoxdTJtU0dLUUE9PSIsInZhbHVlIjoicHVqbkV2UllkSWFBY3lYcitiTXJrYlI2bzkvNTRBbzRKQVZMejlydjV3YVZXS2dCSmxJcmM4L0dhOFA5YTB4MEx3 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRkdS9meG1zZnJVN1hTaUh2RVNnNnc9PSIsInZhbHVlIjoiM2IrcE5GRTRFZ3R1Vk94T1lsM1orUUwxaHRsZ1J2UmU2c013UjNTcEhmZXgrSEdkYnFjNGEveTRVeFRtaXN1WTdVR2ZCWlZpWlNrV0Qyd1ZraGVpL05GUkRwR1lIVkVianNRQkZFUGQ3ODg1U3ZRZ3hQQWR5cTd5T2VYTWpTVmMiLCJtYWMiOiJmOWE1MjFhN2Y4Njc0MTAxNTFjOTkzOWY3ZGM2NTBjYjJkNjYwMjA1MWY1ZDZiY2I0NTNkNzI1MDliOTkzZmE3IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 17:29:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRkdS9meG1zZnJVN1hTaUh2RVNnNnc9PSIsInZhbHVlIjoiM2IrcE5GRTRFZ3R1Vk94T1lsM1orUUwxaHRsZ1J2UmU2c013UjNTcEhmZXgrSEdkYnFjNGEveTRVeFRtaXN1WTdVR2ZCW ▶"
    1 => "forgood_session=eyJpdiI6IkhpZ2t2T3VqM3lidEoxdTJtU0dLUUE9PSIsInZhbHVlIjoicHVqbkV2UllkSWFBY3lYcitiTXJrYlI2bzkvNTRBbzRKQVZMejlydjV3YVZXS2dCSmxJcmM4L0dhOFA5YTB4MEx3QzZuVng5S3dtVStGb3J1OUxlbVhHUFUxN1VGdlMrNUhBSnVoZjc4YnBja08yY2tmWVZGM0lpU0dwdDVVQ0QiLCJtYWMiOiJhMmU4YzBiNGMxYjhlNjNmYzU5MDU1NTk0ZjQ3ZjM0ZGZmYjE0NjQ0M2Q2ZmQ5Mzc3ZDYxNDMxMWNkOGVjZDAyIiwidGFnIjoiIn0%3D; path=/; httponly ◀forgood_session=eyJpdiI6IkhpZ2t2T3VqM3lidEoxdTJtU0dLUUE9PSIsInZhbHVlIjoicHVqbkV2UllkSWFBY3lYcitiTXJrYlI2bzkvNTRBbzRKQVZMejlydjV3YVZXS2dCSmxJcmM4L0dhOFA5YTB4MEx3 ▶"
  ]
]
      session_attributes
        0 of 0   
      array:4 [▼
  "_token" => "Vgxa7sxno7W3V5Vwt0Ti7wiyog57fi2H8xt3E6yA"
  "_previous" => array:1 [▶
    "url" => "https://forgood-jp.com/project/10001"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]