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

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

FOR

夏の思い出

夏季休暇を消化し忘れた

サポーター

アカサカリョウ

現在の支援総額

¥132,500

/

目標

¥200,000

FUNDED!

支援者

13 人

残り

終了

みんなの応援コメント

っっd

2023年12月5日

っっd

っj

2023年12月5日

っっh

FOR GOOD

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

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

本文活動報告 1 応援コメント 6

っっd

2023年12月5日

っっd
っj

2023年12月5日

っっh
2

2023年10月16日

2222
123

2023年10月16日

123
がゃ、

2023年10月9日

がば
在原業平

2023年9月28日

餞に

リターンを選ぶ

10,000円

残り37

かき氷をおごる

赤坂にかき氷をおごってください。
天然氷の、いいやつ。

支援者13人

お届け予定2023-10-10

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

100,000円

残り1

誕生日プレゼント

10月1日は赤坂の誕生日です。

支援者0人

お届け予定2023-10-01

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

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

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

For Goodについて

FOR YOU

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

なすび変更後

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

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

テスト　フォーグッド...

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

残り

52

日

52

人

現在

39,278,144

円

は＾

残り

52

日

1

人

現在

7,001,000

円

地域経済の循環

【長崎から全国へ】「観光客のやりたい」×「地域のできる」をビジネスでつなぎたい！

【長崎から全国へ】「観光客のやりたい」×「地域のできる」をビジネスでつなぎたい！

長崎市伊王島地域おこ...

長崎市伊王島地域おこし協力隊：林田...

残り

52

日

66

人

現在

2,569,721

円

地域×若者×芸術家

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

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

残り

21

日

85

人

現在

671,500

円

Messages29 Timeline Exceptions Views10 Route Queries23 Models27 Gate Session Request

8.1.2662ms3MBGET project/{project_id}/support

infolog[09:34:33] LOG.info: [Controller] Target Controller : ProjectController Method : supportComment
debuglog[09:34:33] LOG.debug: 達成率取得
debuglog[09:34:33] LOG.debug: 9000
debuglog[09:34:33] LOG.debug: 190000000
debuglog[09:34:33] LOG.debug: 0.0047368421052632
debuglog[09:34:33] LOG.debug: 達成率取得
debuglog[09:34:33] LOG.debug: 39278144
debuglog[09:34:33] LOG.debug: 800000
debuglog[09:34:33] LOG.debug: 4909.768
debuglog[09:34:33] LOG.debug: 達成率取得
debuglog[09:34:33] LOG.debug: 7001000
debuglog[09:34:33] LOG.debug: 10000000
debuglog[09:34:33] LOG.debug: 70.01
debuglog[09:34:33] LOG.debug: 達成率取得
debuglog[09:34:33] LOG.debug: 2569721
debuglog[09:34:33] LOG.debug: 500000
debuglog[09:34:33] LOG.debug: 513.9442
debuglog[09:34:33] LOG.debug: 達成率取得
debuglog[09:34:33] LOG.debug: 671500
debuglog[09:34:33] LOG.debug: 200000
debuglog[09:34:33] LOG.debug: 335.75
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[09:34:33] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...

Booting (8.95ms)
Application (653ms)
1 x Application (98.64%)
653.16ms
1 x Booting (1.35%)
8.95ms

10 templates were rendered

project.project_support_comment_pc (resources/views/project/project_support_comment_pc.blade.php)17bladefile


project_id
project
favorite_count
favorite
history_projects
activity_reports
activity_report_counts
support_comments
support_comment_counts
url
color_types
whole_support_comments
recommend_projects
return_items
latestNotifications
has_session
has_project

vendor.pagination.custom (resources/views/vendor/pagination/custom.blade.php)4bladefile
Params
0
paginator
1
elements
2
has_session
3
has_project

project.project_pc (resources/views/project/project_pc.blade.php)23bladefile


__env
app
errors
project_id
project
favorite_count
favorite
history_projects
activity_reports
activity_report_counts
support_comments
support_comment_counts
url
color_types
whole_support_comments
recommend_projects
return_items
latestNotifications
has_session
has_project
__currentLoopData
support_comment
loop

components.project.wide_card (resources/views/components/project/wide_card.blade.php)15bladefile


project
color_types
favoriteCount
favorite
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
has_session
has_project

components.project.card (resources/views/components/project/card.blade.php)13bladefile


project
color_types
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
has_session
has_project

components.project.card (resources/views/components/project/card.blade.php)13bladefile


project
color_types
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
has_session
has_project

components.project.card (resources/views/components/project/card.blade.php)13bladefile


project
color_types
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
has_session
has_project

components.project.card (resources/views/components/project/card.blade.php)13bladefile


project
color_types
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
has_session
has_project

layouts.header_footer (resources/views/layouts/header_footer.blade.php)29bladefile


__env
app
errors
project_id
project
favorite_count
favorite
history_projects
activity_reports
activity_report_counts
support_comments
support_comment_counts
url
color_types
whole_support_comments
recommend_projects
return_items
latestNotifications
has_session
has_project
__currentLoopData
support_comment
loop
component
i
created_at
now
return_item
recommend_project

mypage.modal (resources/views/mypage/modal.blade.php)29bladefile


__env
app
errors
project_id
project
favorite_count
favorite
history_projects
activity_reports
activity_report_counts
support_comments
support_comment_counts
url
color_types
whole_support_comments
recommend_projects
return_items
latestNotifications
has_session
has_project
__currentLoopData
support_comment
loop
component
i
created_at
now
return_item
recommend_project

uri: GET project/{project_id}/support
middleware: web
controller: App\Http\Controllers\ProjectController@supportComment
namespace
prefix
where
as: project.support_comment
file: app/Http/Controllers/ProjectController.php:315-391

23 statements were executed, 8 of which were duplicated, 15 unique. Show only duplicated630ms

select * from `projects` where `id` = '77711' limit 1

1.41ms/app/Http/Controllers/ProjectController.php:325forgood

Metadata
Bindings	0. 77711
Backtrace	15. /app/Http/Controllers/ProjectController.php:325 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` = '77711' and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 limit 1

199ms/app/Models/Project.php:557forgood

Metadata
Bindings	0. 0 1. 3 2. 77711 3. 1 4. 0
Backtrace	15. /app/Models/Project.php:557 16. /app/Http/Controllers/ProjectController.php:402 17. /app/Http/Controllers/ProjectController.php:336 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` = '77711' or `wk_projects`.`project_id` = '77711') and `projects`.`is_delete` = 0 limit 1

8.58ms/app/Models/Project.php:464forgood

Metadata
Bindings	0. 77711 1. 77711 2. 0
Backtrace	15. /app/Models/Project.php:464 16. /app/Http/Controllers/ProjectController.php:406 17. /app/Http/Controllers/ProjectController.php:336 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` = '77711' and `favorites`.`deleted_at` is null

360μs/app/Models/Favorite.php:99forgood

Metadata
Bindings	0. 77711
Backtrace	15. /app/Models/Favorite.php:99 16. /app/Http/Controllers/ProjectController.php:414 17. /app/Http/Controllers/ProjectController.php:336 18. /app/Http/Controllers/Controller.php:23 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `activity_reports` where `project_id` = '77711' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-09 09:34:33' 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. 77711 1. 0 2. 2025-04-09 09:34:33 3. 1
Backtrace	14. /app/Models/ActivityReport.php:56 15. /app/Http/Controllers/ProjectController.php:427 16. /app/Http/Controllers/ProjectController.php:336 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` = '77711' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-09 09:34:33' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null

270μs/app/Models/ActivityReport.php:42forgood

Metadata
Bindings	0. 77711 1. 0 2. 2025-04-09 09:34:33 3. 1
Backtrace	15. /app/Models/ActivityReport.php:42 16. /app/Http/Controllers/ProjectController.php:428 17. /app/Http/Controllers/ProjectController.php:336 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` = '77711' 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

700μs/app/Models/SupportComment.php:60forgood

Metadata
Bindings	0. 77711 1. completed 2. 0
Backtrace	14. /app/Models/SupportComment.php:60 15. /app/Http/Controllers/ProjectController.php:441 16. /app/Http/Controllers/ProjectController.php:336 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` = '77711' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null

380μs/app/Models/SupportComment.php:48forgood

Metadata
Bindings	0. 77711 1. completed 2. 0
Backtrace	15. /app/Models/SupportComment.php:48 16. /app/Http/Controllers/ProjectController.php:442 17. /app/Http/Controllers/ProjectController.php:336 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` = '77711' and `is_delete` = 0 and `project_notifications`.`deleted_at` is null order by `created_at` desc limit 3

270μs/app/Models/ProjectNotification.php:36forgood

Metadata
Bindings	0. 77711 1. 0
Backtrace	14. /app/Models/ProjectNotification.php:36 15. /app/Http/Controllers/ProjectController.php:448 16. /app/Http/Controllers/ProjectController.php:336 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` = '77711' and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc

1.12ms/app/Models/ReturnItem.php:158forgood

Metadata
Bindings	0. 77711 1. 0 2. 1
Backtrace	12. /app/Models/ReturnItem.php:158 13. /app/Http/Controllers/ProjectController.php:340 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` != 77711 and `projects`.`category` = 'earth' 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. 77711 7. earth
Backtrace	14. /app/Models/Project.php:618 15. /app/Models/Project.php:574 16. /app/Http/Controllers/ProjectController.php:345 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` != 77711 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. 77711
Backtrace	14. /app/Models/Project.php:618 15. /app/Models/Project.php:579 16. /app/Http/Controllers/ProjectController.php:345 17. /app/Http/Controllers/Controller.php:23 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `accounts` where `id` = 117 and `accounts`.`deleted_at` is null limit 1

490μs/app/Http/Controllers/ProjectController.php:357forgood

Metadata
Bindings	0. 117
Backtrace	15. /app/Http/Controllers/ProjectController.php:357 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` = 117 and `accounts`.`deleted_at` is null limit 1

330μs/app/Http/Controllers/ProjectController.php:357forgood

Metadata
Bindings	0. 117
Backtrace	15. /app/Http/Controllers/ProjectController.php:357 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

320μs/app/Http/Controllers/ProjectController.php:357forgood

Metadata
Bindings	0. 10000
Backtrace	15. /app/Http/Controllers/ProjectController.php:357 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 count(*) as aggregate from `support_comments` inner join `supports` on `supports`.`id` = `support_comments`.`support_id` left join (select `account_id`, COUNT(*) as support_count from `supports` where `payment_status` = 'completed' group by `account_id`) as `support_counts` on `support_comments`.`account_id` = `support_counts`.`account_id` where `supports`.`project_id` = '77711' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null

2.46ms/app/Models/SupportComment.php:82forgood

Metadata
Bindings	0. completed 1. 77711 2. completed 3. 0
Backtrace	15. /app/Models/SupportComment.php:82 16. /app/Http/Controllers/ProjectController.php:363 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

select `support_comments`.*, `support_counts`.`support_count` from `support_comments` inner join `supports` on `supports`.`id` = `support_comments`.`support_id` left join (select `account_id`, COUNT(*) as support_count from `supports` where `payment_status` = 'completed' group by `account_id`) as `support_counts` on `support_comments`.`account_id` = `support_counts`.`account_id` where `supports`.`project_id` = '77711' 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 20 offset 0

2.24ms/app/Models/SupportComment.php:82forgood

Metadata
Bindings	0. completed 1. 77711 2. completed 3. 0
Backtrace	15. /app/Models/SupportComment.php:82 16. /app/Http/Controllers/ProjectController.php:363 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

select * from `accounts` where `id` = 117 and `accounts`.`deleted_at` is null limit 1

340μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 117
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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` = 117 and `accounts`.`deleted_at` is null limit 1

280μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 117
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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

260μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 10000
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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

250μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 10000
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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` = 117 and `accounts`.`deleted_at` is null limit 1

240μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 117
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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` = 10137 and `accounts`.`deleted_at` is null limit 1

240μs/app/Http/Controllers/ProjectController.php:365forgood

Metadata
Bindings	0. 10137
Backtrace	15. /app/Http/Controllers/ProjectController.php:365 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: 9
App\Models\SupportComment: 9
App\Models\ActivityReport: 1
App\Models\Project: 8

_token: oxS2spcA7oswIrKhkbTmQWD0mMxOpKbWrDTzqgAD
_previous: array:1 [ "url" => "https://forgood-jp.com/project/77711/support" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/project/77711/support

status_code

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.218.183.7"
  "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" => "22354"
  "REDIRECT_URL" => "/project/77711/support"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/project/77711/support"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744158873.0216
  "REQUEST_TIME" => 1744158873
]

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 => "Wed, 09 Apr 2025 00:34:33 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJmVlFSdVhxcmRhWkFFWmdoTTBlSVE9PSIsInZhbHVlIjoiZDgzc1VmYlRNREpKK212dzduOUdnT0ovK0J4VFNjcFNSQ09vMDZXTGZqcFV6YUs1TG5zTC9ZaHdEOUlCUk43dEt3OVpJUFl2S0lBcjJZVHhHSkdLSTNTNlZWdW03OG1Bb3RyZ3hpMDdsWk15KzFPbktka3hzNmF0VUN6Ym9zb0giLCJtYWMiOiIxMjM3NmRiMTllZjg5ZTFlNzdmYzM2MGMzMzhlZTgyMTNkYmMxN2E5NDgxZjFkZDYxM2E2MDk2ZTNhNjUyNDY1IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 08:34:33 GMT; Max-Age=28800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJmVlFSdVhxcmRhWkFFWmdoTTBlSVE9PSIsInZhbHVlIjoiZDgzc1VmYlRNREpKK212dzduOUdnT0ovK0J4VFNjcFNSQ09vMDZXTGZqcFV6YUs1TG5zTC9ZaHdEOUlCUk43dEt3OVpJU ▶"
    1 => "forgood_session=eyJpdiI6Iks2TzdSK2lMSEZxL1FHT1lweGFaYUE9PSIsInZhbHVlIjoiN3Y2bExDR051NXgwN1JCcFhxSnFGbnpQYUg2TTB4K3NSWjA0ZTVYSnp2OFdTT3dSbWtadldDWUZqLy9aSDE5RmJ0cldFWTBOSkhudjlkQmdqRzluU3EzTGp5Z0NYVUhCZWZpV2J6NVZIbklxNW11ai9jK2YzT2s1VnNibXJtZmciLCJtYWMiOiIxYjJhMTcyNTlhNzRkNjY4ZWIzYWNkNzQzMWQyZDQwM2NkOThhMzViM2U1NzAwMWM1Njg1OTg4ZjRkODY1NjhmIiwidGFnIjoiIn0%3D; path=/; httponly; samesite=lax ◀forgood_session=eyJpdiI6Iks2TzdSK2lMSEZxL1FHT1lweGFaYUE9PSIsInZhbHVlIjoiN3Y2bExDR051NXgwN1JCcFhxSnFGbnpQYUg2TTB4K3NSWjA0ZTVYSnp2OFdTT3dSbWtadldDWUZqLy9aSDE5RmJ0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJmVlFSdVhxcmRhWkFFWmdoTTBlSVE9PSIsInZhbHVlIjoiZDgzc1VmYlRNREpKK212dzduOUdnT0ovK0J4VFNjcFNSQ09vMDZXTGZqcFV6YUs1TG5zTC9ZaHdEOUlCUk43dEt3OVpJUFl2S0lBcjJZVHhHSkdLSTNTNlZWdW03OG1Bb3RyZ3hpMDdsWk15KzFPbktka3hzNmF0VUN6Ym9zb0giLCJtYWMiOiIxMjM3NmRiMTllZjg5ZTFlNzdmYzM2MGMzMzhlZTgyMTNkYmMxN2E5NDgxZjFkZDYxM2E2MDk2ZTNhNjUyNDY1IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 08:34:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJmVlFSdVhxcmRhWkFFWmdoTTBlSVE9PSIsInZhbHVlIjoiZDgzc1VmYlRNREpKK212dzduOUdnT0ovK0J4VFNjcFNSQ09vMDZXTGZqcFV6YUs1TG5zTC9ZaHdEOUlCUk43dEt3OVpJU ▶"
    1 => "forgood_session=eyJpdiI6Iks2TzdSK2lMSEZxL1FHT1lweGFaYUE9PSIsInZhbHVlIjoiN3Y2bExDR051NXgwN1JCcFhxSnFGbnpQYUg2TTB4K3NSWjA0ZTVYSnp2OFdTT3dSbWtadldDWUZqLy9aSDE5RmJ0cldFWTBOSkhudjlkQmdqRzluU3EzTGp5Z0NYVUhCZWZpV2J6NVZIbklxNW11ai9jK2YzT2s1VnNibXJtZmciLCJtYWMiOiIxYjJhMTcyNTlhNzRkNjY4ZWIzYWNkNzQzMWQyZDQwM2NkOThhMzViM2U1NzAwMWM1Njg1OTg4ZjRkODY1NjhmIiwidGFnIjoiIn0%3D; path=/; httponly ◀forgood_session=eyJpdiI6Iks2TzdSK2lMSEZxL1FHT1lweGFaYUE9PSIsInZhbHVlIjoiN3Y2bExDR051NXgwN1JCcFhxSnFGbnpQYUg2TTB4K3NSWjA0ZTVYSnp2OFdTT3dSbWtadldDWUZqLy9aSDE5RmJ0 ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "oxS2spcA7oswIrKhkbTmQWD0mMxOpKbWrDTzqgAD"
  "_previous" => array:1 [▶
    "url" => "https://forgood-jp.com/project/77711/support"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]