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

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

FOR

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

サポーター

現在の支援総額

¥0

/

目標

¥0

0 %

支援者

0 人

残り

終了

みんなの応援コメント

まだ応援コメントがありません

FOR GOOD

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

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

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

まだコメントがありません

※プロジェクト支援時に応援コメントを記載できます

リターンを選ぶ

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

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

円

Messages35 Timeline Exceptions Views9 Route Queries13 Models8 Gate Session Request

8.1.2654ms3MBGET project/{project_id}/support

infolog[01:34:39] LOG.info: [Controller] Target Controller : ProjectController Method : supportComment
debuglog[01:34:39] LOG.debug: 達成率取得
debuglog[01:34:39] LOG.debug: 671500
debuglog[01:34:39] LOG.debug: 200000
debuglog[01:34:39] LOG.debug: 335.75
debuglog[01:34:39] LOG.debug: 達成率取得
debuglog[01:34:39] LOG.debug: 39278144
debuglog[01:34:39] LOG.debug: 800000
debuglog[01:34:39] LOG.debug: 4909.768
debuglog[01:34:39] LOG.debug: 達成率取得
debuglog[01:34:39] LOG.debug: 7001000
debuglog[01:34:39] LOG.debug: 10000000
debuglog[01:34:39] LOG.debug: 70.01
debuglog[01:34:39] LOG.debug: 達成率取得
debuglog[01:34:39] LOG.debug: 2569721
debuglog[01:34:39] LOG.debug: 500000
debuglog[01:34:39] LOG.debug: 513.9442
debuglog[01:34:39] LOG.debug: 達成率取得
debuglog[01:34:39] LOG.debug: 671500
debuglog[01:34:39] LOG.debug: 200000
debuglog[01:34:39] LOG.debug: 335.75
warninglog[01:34:39] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[01:34:39] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
warninglog[01:34:39] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
warninglog[01:34:39] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[01:34:39] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[01:34:39] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[01:34:39] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...

Booting (9.38ms)
Application (644ms)
1 x Application (98.56%)
644.42ms
1 x Booting (1.43%)
9.38ms

9 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

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


__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

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)24bladefile


__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
component
__currentLoopData
loop
recommend_project

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


__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
component
__currentLoopData
loop
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

13 statements were executed626ms

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

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

Metadata
Bindings	0. 10018
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` = '10018' and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 limit 1

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

Metadata
Bindings	0. 0 1. 3 2. 10018 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` = '10018' or `wk_projects`.`project_id` = '10018') and `projects`.`is_delete` = 0 limit 1

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

Metadata
Bindings	0. 10018 1. 10018 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` = '10018' and `favorites`.`deleted_at` is null

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

Metadata
Bindings	0. 10018
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` = '10018' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-09 01:34:39' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null order by `publishing_datetime` desc limit 3

370μs/app/Models/ActivityReport.php:56forgood

Metadata
Bindings	0. 10018 1. 0 2. 2025-04-09 01:34:39 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` = '10018' and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-09 01:34:39' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null

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

Metadata
Bindings	0. 10018 1. 0 2. 2025-04-09 01:34:39 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` = '10018' 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

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

Metadata
Bindings	0. 10018 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` = '10018' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null

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

Metadata
Bindings	0. 10018 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` = '10018' and `is_delete` = 0 and `project_notifications`.`deleted_at` is null order by `created_at` desc limit 3

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

Metadata
Bindings	0. 10018 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` = '10018' and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc

330μs/app/Models/ReturnItem.php:158forgood

Metadata
Bindings	0. 10018 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` != 10018 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. 10018 7. Animal
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` != 10018 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. 10018
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 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` = '10018' and `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `support_comments`.`deleted_at` is null

830μs/app/Models/SupportComment.php:82forgood

Metadata
Bindings	0. completed 1. 10018 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

App\Models\Project: 8

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

path_info

/project/10018/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" => "3.135.185.223"
  "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" => "19521"
  "REDIRECT_URL" => "/project/10018/support"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/project/10018/support"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744130079.2168
  "REQUEST_TIME" => 1744130079
]

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

session_attributes

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