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

FOR

ネクストゴール確認用

ネクストゴール確認用3・1開始

サポーター

ネクストゴール確認用

現在の支援総額
¥101,500
/
目標
¥100,000
101 %
支援者
3
残り
26

FOR GOOD

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

プロジェクトの相談をする

実行者からのメッセージ

プロジェクトのポイント

1.1つ目

2.2tume

3.3rd

プロジェクトの詳細

はじめに

ー簡単な自己紹介

ープロジェクトの概要

プロジェクトの冒頭が最も読んでもらえる箇所です。

メンバーやプロジェクトの画像を挿入する、または読み手を惹きつける一言を入れると良いでしょう。冒頭の文章は、300文字前後をオススメします。


解決したい社会課題

ーどのような社会課題を解決したいのか

ー取り組む課題の詳細図表やデータ、エピソードなどを載せるのもオススメです!


この課題に向き合う背景

ー具体的なエピソード

ー普段の活動内容

課題と向き合うきっかけや経緯などを簡単に紹介しましょう。


このプロジェクトで実現したいこと

ー課題に対して、どのような手段で取り組むのか

ーその活動・サービスで課題がどのように解決されるのか

ーどんな未来を目指すのか

プロジェクトの内容や目的を、具体的に書きましょう。


リターンについて

お返しの品やサービスのおすすめポイントや特徴を紹介しましょう。


応援メッセージ

ー応援いただいている方々からのメッセージ

ページの信頼性を高めるために、プロジェクトを応援いただいている方からの応援メッセージを記載しましょう。


スケジュール

集めた支援金の使用用途や内訳を書きましょう。

【記載例】

〇月 実行委員会の立ち上げ

〇月 イベントの告知開始

〇月〇日 クラウドファンディング終了

〇月〇日 イベント開催日

〇年〇月 リターン発送





支援金の使い道

ー目標金額の内訳、具体的な資金の使い道

集まった支援を何の目的で、具体的にどんな内訳で使用する予定なのか、記載しましょう。

【例】

会場費:約〇〇万円

材料費:約〇〇万円

リターン準備費用:約〇〇万円


<募集方式について>

本プロジェクトはAll-in方式で実施します。目標金額に満たない場合も、計画を実行し、リターンをお届けします。

さいごに

ープロジェクトを通して目指している社会

ープロジェクトにかける思いや意気込み

最後にプロジェクトに対する想いやプロジェクトを通して目指している社会を積極的に伝えることで、より共感を呼ぶページになります。

PROFILE

ネクストゴール確認用

2010年 てつがうつ病を発症し会社を退職。ちゃんちき堂を創業!
2011年 ライフワークとなるリヤカー(名称:チキチキ5)での行商を開始
2012年 ひみつ工場をオープン
2014年 廃屋をDIYし、起業支援の日替わりcafe「ころん」をスタート(今回のプロジェクトの対象カフェ)
2015年 cafeころん裏にレンタルスペース「おうめシネマ」をDIYにて作る。
2016年 cafeころんを含めた空間をDIYし「ぼくらのひみつ基地」スタート。
2021年 武藤治作酒店の武藤さんと「田んぼマルシェ」をスタート。また、日本初となる川の対岸にスクリーンを張った野外映画イベント「せせらぎシアター」スタート
2022年 「うつ病のぼくが始めた行商って仕事の話」

リターンを選ぶ

500

a

a

支援者3人

お届け予定2025-02-21

7,000

とにかく

s

支援者0人

お届け予定2025-02-14

3,000

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

支援者0人

お届け予定2025-02-21

最新の活動レポート

まだ投稿がありません

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

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

FOR YOU

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

8.1.2PHP Version847msRequest Duration3MBMemory UsageGET project/{project_id}Route
  • infolog[23:57:58] LOG.info: [Controller] Target Controller : ProjectController Method : show
  • debuglog[23:57:58] LOG.debug: 達成率取得
  • debuglog[23:57:58] LOG.debug: 7310
  • debuglog[23:57:58] LOG.debug: 100000
  • debuglog[23:57:58] LOG.debug: 7.31
  • debuglog[23:57:58] LOG.debug: 達成率取得
  • debuglog[23:57:58] LOG.debug: 39278144
  • debuglog[23:57:58] LOG.debug: 800000
  • debuglog[23:57:58] LOG.debug: 4909.768
  • debuglog[23:57:58] LOG.debug: 達成率取得
  • debuglog[23:57:58] LOG.debug: 7001000
  • debuglog[23:57:58] LOG.debug: 10000000
  • debuglog[23:57:58] LOG.debug: 70.01
  • debuglog[23:57:58] LOG.debug: 達成率取得
  • debuglog[23:57:58] LOG.debug: 2569721
  • debuglog[23:57:58] LOG.debug: 500000
  • debuglog[23:57:58] LOG.debug: 513.9442
  • debuglog[23:57:58] LOG.debug: 達成率取得
  • debuglog[23:57:58] LOG.debug: 627500
  • debuglog[23:57:58] LOG.debug: 200000
  • debuglog[23:57:58] LOG.debug: 313.75
  • debuglog[23:57:58] LOG.debug: recordAccessLog
  • debuglog[23:57:58] LOG.debug: array ( 'project_id' => 77877, 'account_id' => NULL, 'inflow_route' => '...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • warninglog[23:57:59] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
  • Booting (8.72ms)
  • Application (838ms)
  • 1 x Application (98.96%)
    837.85ms
    1 x Booting (1.03%)
    8.72ms
    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 executed, 2 of which were duplicated, 15 unique. Show only duplicated817ms
    • select * from `projects` where `id` = 77877 limit 1
      1.57ms/app/Http/Controllers/ProjectController.php:44forgood
      Metadata
      Bindings
      • 0. 77877
      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` = 77877 and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 limit 1
      195ms/app/Models/Project.php:557forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 3
      • 2. 77877
      • 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` = 77877 or `wk_projects`.`project_id` = 77877) and `projects`.`is_delete` = 0 limit 1
      10.21ms/app/Models/Project.php:464forgood
      Metadata
      Bindings
      • 0. 77877
      • 1. 77877
      • 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` = 77877 and `favorites`.`deleted_at` is null
      350μs/app/Models/Favorite.php:99forgood
      Metadata
      Bindings
      • 0. 77877
      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` = 77877 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-04 23:57:58' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null order by `publishing_datetime` desc limit 3
      340μs/app/Models/ActivityReport.php:56forgood
      Metadata
      Bindings
      • 0. 77877
      • 1. 0
      • 2. 2025-04-04 23:57:58
      • 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` = 77877 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-04 23:57:58' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null
      260μs/app/Models/ActivityReport.php:42forgood
      Metadata
      Bindings
      • 0. 77877
      • 1. 0
      • 2. 2025-04-04 23:57:58
      • 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` = 77877 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
      640μs/app/Models/SupportComment.php:60forgood
      Metadata
      Bindings
      • 0. 77877
      • 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` = 77877 and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null
      360μs/app/Models/SupportComment.php:48forgood
      Metadata
      Bindings
      • 0. 77877
      • 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` = 77877 and `is_delete` = 0 and `project_notifications`.`deleted_at` is null order by `created_at` desc limit 3
      250μs/app/Models/ProjectNotification.php:36forgood
      Metadata
      Bindings
      • 0. 77877
      • 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
      310μ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` = 10000 and `accounts`.`deleted_at` is null limit 1
      310μ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` = 10193 and `accounts`.`deleted_at` is null limit 1
      270μs/app/Http/Controllers/ProjectController.php:70forgood
      Metadata
      Bindings
      • 0. 10193
      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` = 77877 and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc
      370μs/app/Models/ReturnItem.php:158forgood
      Metadata
      Bindings
      • 0. 77877
      • 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` != 77877 and `projects`.`category` = 'HumanRights' order by `total_support_price` desc limit 4
      201ms/app/Models/Project.php:618forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 4
      • 2. 0
      • 3. 1
      • 4. 0
      • 5. 0
      • 6. 77877
      • 7. HumanRights
      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` != 77877 order by `total_support_price` desc limit 4
      201ms/app/Models/Project.php:618forgood
      Metadata
      Bindings
      • 0. 0
      • 1. 4
      • 2. 0
      • 3. 1
      • 4. 0
      • 5. 0
      • 6. 77877
      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` = 77877 and `access_date` = '2025-04-04' limit 1
      500μs/app/Models/ProjectAccessLog.php:29forgood
      Metadata
      Bindings
      • 0. 77877
      • 1. 2025-04-04
      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
    • update `project_access_logs` set `access_count` = 4, `project_access_logs`.`updated_at` = '2025-04-04 23:57:58' where `id` = 10936
      204ms/app/Models/ProjectAccessLog.php:34forgood
      Metadata
      Bindings
      • 0. 4
      • 1. 2025-04-04 23:57:58
      • 2. 10936
      Backtrace
      • 13. /app/Models/ProjectAccessLog.php:34
      • 14. /app/Http/Controllers/ProjectController.php:97
      • 15. /app/Http/Controllers/Controller.php:23
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    App\Models\ProjectAccessLog
    1
    App\Models\Account
    3
    App\Models\SupportComment
    3
    App\Models\Project
    8
      _token
      ndOPZBmdQWF0ctgbIimUp9oc3HUYtOGAPpKCzPmE
      _previous
      array:1 [ "url" => "https://forgood-jp.com/project/77877" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /project/77877
      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" => "13.58.64.128" "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" => "44933" "REDIRECT_URL" => "/project/77877" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/project/77877" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743778678.3586 "REQUEST_TIME" => 1743778678 ]
      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 => "Fri, 04 Apr 2025 14:57:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9hMUxaOGV6eUlhbFlQbzZKdzRJRmc9PSIsInZhbHVlIjoiRFBtWWltUHhpK01KeS9nT0hnVlhFeG5FUS9vZFI3MkhuNHNvZ2FPMFlNTkVjU1VPN2dJWk1oSG1qbCt2U0d5WUg2T2t1QU0rY0RWZ0U1VHU2bDZCcitkRWtwRFpVSzVVdm1uckIvTU5hSVh3MW5NMExYREw0RjduSzJuUStWaXMiLCJtYWMiOiIzN2M5ZmFmM2RmZmEwNjNlZWI0NjBkZDgyZWU1NDE1ZTE1OGYyZjhkNDA5NDU1MGIxNjc4ODYxNWE3YTczOTA4IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 22:57:59 GMT; Max-Age=28800; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ii9hMUxaOGV6eUlhbFlQbzZKdzRJRmc9PSIsInZhbHVlIjoiRFBtWWltUHhpK01KeS9nT0hnVlhFeG5FUS9vZFI3MkhuNHNvZ2FPMFlNTkVjU1VPN2dJWk1oSG1qbCt2U0d5WUg2T2t1Q" 1 => "forgood_session=eyJpdiI6IjVvcmdlZ25mZlhjL1Y1aEc3VkZSbEE9PSIsInZhbHVlIjoiMlRkd3lGL3NsdDlWQzRSVklkMS8xZGJuajBraUovNzRFWEdXQ2VIaFJYeGx0YVozS09tbkg5SWxWSVlobG9sMVltWThzd0xnL29mRXRxUE15c2lNZktzN1A5bVI0dnRiMEh2b1pZdHlBNFFTTzRJeUhqWk9Ic3BZaHBOcTd2bnAiLCJtYWMiOiJkZjBiYjE1NmRmMjdhNmFlZjUwZDg0NGY5MjYyNDI3ZTc0MmNkMzAwZjM4NzQwMTRkNzI4MGI3NzAzNTViYTYyIiwidGFnIjoiIn0%3D; path=/; httponly; samesite=laxforgood_session=eyJpdiI6IjVvcmdlZ25mZlhjL1Y1aEc3VkZSbEE9PSIsInZhbHVlIjoiMlRkd3lGL3NsdDlWQzRSVklkMS8xZGJuajBraUovNzRFWEdXQ2VIaFJYeGx0YVozS09tbkg5SWxWSVlobG9sMVlt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9hMUxaOGV6eUlhbFlQbzZKdzRJRmc9PSIsInZhbHVlIjoiRFBtWWltUHhpK01KeS9nT0hnVlhFeG5FUS9vZFI3MkhuNHNvZ2FPMFlNTkVjU1VPN2dJWk1oSG1qbCt2U0d5WUg2T2t1QU0rY0RWZ0U1VHU2bDZCcitkRWtwRFpVSzVVdm1uckIvTU5hSVh3MW5NMExYREw0RjduSzJuUStWaXMiLCJtYWMiOiIzN2M5ZmFmM2RmZmEwNjNlZWI0NjBkZDgyZWU1NDE1ZTE1OGYyZjhkNDA5NDU1MGIxNjc4ODYxNWE3YTczOTA4IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 22:57:59 GMT; path=/XSRF-TOKEN=eyJpdiI6Ii9hMUxaOGV6eUlhbFlQbzZKdzRJRmc9PSIsInZhbHVlIjoiRFBtWWltUHhpK01KeS9nT0hnVlhFeG5FUS9vZFI3MkhuNHNvZ2FPMFlNTkVjU1VPN2dJWk1oSG1qbCt2U0d5WUg2T2t1Q" 1 => "forgood_session=eyJpdiI6IjVvcmdlZ25mZlhjL1Y1aEc3VkZSbEE9PSIsInZhbHVlIjoiMlRkd3lGL3NsdDlWQzRSVklkMS8xZGJuajBraUovNzRFWEdXQ2VIaFJYeGx0YVozS09tbkg5SWxWSVlobG9sMVltWThzd0xnL29mRXRxUE15c2lNZktzN1A5bVI0dnRiMEh2b1pZdHlBNFFTTzRJeUhqWk9Ic3BZaHBOcTd2bnAiLCJtYWMiOiJkZjBiYjE1NmRmMjdhNmFlZjUwZDg0NGY5MjYyNDI3ZTc0MmNkMzAwZjM4NzQwMTRkNzI4MGI3NzAzNTViYTYyIiwidGFnIjoiIn0%3D; path=/; httponlyforgood_session=eyJpdiI6IjVvcmdlZ25mZlhjL1Y1aEc3VkZSbEE9PSIsInZhbHVlIjoiMlRkd3lGL3NsdDlWQzRSVklkMS8xZGJuajBraUovNzRFWEdXQ2VIaFJYeGx0YVozS09tbkg5SWxWSVlobG9sMVlt" ] ]
      session_attributes
      0 of 0
      array:4 [ "_token" => "ndOPZBmdQWF0ctgbIimUp9oc3HUYtOGAPpKCzPmE" "_previous" => array:1 [ "url" => "https://forgood-jp.com/project/77877" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]