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

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

FOR

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

サポーター

現在の支援総額

¥0

/

目標

¥0

0 %

支援者

0 人

残り

終了

みんなの応援コメント

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

FOR GOOD

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

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

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

実行者からのメッセージ

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

プロジェクトのポイント

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

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

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

プロジェクトの詳細

支援金の使い道

さいごに

PROFILE

リターンを選ぶ

最新の活動レポート

まだ投稿がありません

みんなの応援コメント

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

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

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

For Goodについて

FOR YOU

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

なすび変更後

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

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

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

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

残り

54

日

52

人

現在

39,278,144

円

は＾

残り

54

日

1

人

現在

7,001,000

円

地域経済の循環

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

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

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

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

残り

54

日

66

人

現在

2,569,721

円

地域×若者×芸術家

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

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

残り

23

日

85

人

現在

671,500

円

Messages39 Timeline Exceptions Views9 Route Queries14 Models8 Gate Session Request

8.1.2644ms3MBGET project/{project_id}

infolog[23:54:51] LOG.info: [Controller] Target Controller : ProjectController Method : show
debuglog[23:54:51] LOG.debug: 達成率取得
debuglog[23:54:51] LOG.debug: 671500
debuglog[23:54:51] LOG.debug: 200000
debuglog[23:54:51] LOG.debug: 335.75
debuglog[23:54:51] LOG.debug: 達成率取得
debuglog[23:54:51] LOG.debug: 39278144
debuglog[23:54:51] LOG.debug: 800000
debuglog[23:54:51] LOG.debug: 4909.768
debuglog[23:54:51] LOG.debug: 達成率取得
debuglog[23:54:51] LOG.debug: 7001000
debuglog[23:54:51] LOG.debug: 10000000
debuglog[23:54:51] LOG.debug: 70.01
debuglog[23:54:51] LOG.debug: 達成率取得
debuglog[23:54:51] LOG.debug: 2569721
debuglog[23:54:51] LOG.debug: 500000
debuglog[23:54:51] LOG.debug: 513.9442
debuglog[23:54:51] LOG.debug: 達成率取得
debuglog[23:54:51] LOG.debug: 671500
debuglog[23:54:51] LOG.debug: 200000
debuglog[23:54:51] LOG.debug: 335.75
debuglog[23:54:51] LOG.debug: recordAccessLog
debuglog[23:54:51] LOG.debug: array ( 'project_id' => 10022, 'account_id' => NULL, 'inflow_route' => '...
warninglog[23:54:51] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[23:54:51] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[23:54:51] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[23:54:51] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
warninglog[23:54:51] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
warninglog[23:54:51] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[23:54:51] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[23:54:51] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...
warninglog[23:54:51] LOG.warning: mb_strtolower(): Passing null to parameter #1 ($string) of type string is de...

Booting (11.66ms)
Application (632ms)
1 x Application (98.18%)
632.50ms
1 x Booting (1.81%)
11.66ms

9 templates were rendered

project.project_main_pc (resources/views/project/project_main_pc.blade.php)15bladefile


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

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


__env
app
errors
project
favorite
favorite_count
history_projects
recommend_projects
activity_reports
return_items
activity_report_counts
support_comments
support_comment_counts
url
color_types
latestNotifications
has_session
has_project
content_value
usage_support_value
last_word_value

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


__env
app
errors
project
favorite
favorite_count
history_projects
recommend_projects
activity_reports
return_items
activity_report_counts
support_comments
support_comment_counts
url
color_types
latestNotifications
has_session
has_project
content_value
usage_support_value
last_word_value
component
__currentLoopData
loop
recommend_project

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


__env
app
errors
project
favorite
favorite_count
history_projects
recommend_projects
activity_reports
return_items
activity_report_counts
support_comments
support_comment_counts
url
color_types
latestNotifications
has_session
has_project
content_value
usage_support_value
last_word_value
component
__currentLoopData
loop
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

14 statements were executed614ms

select * from `projects` where `id` = 10022 limit 1

1.54ms/app/Http/Controllers/ProjectController.php:44forgood

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

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

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

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

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

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

Metadata
Bindings	0. 10022
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` = 10022 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 23:54:51' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null order by `publishing_datetime` desc limit 3

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

Metadata
Bindings	0. 10022 1. 0 2. 2025-04-07 23:54:51 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` = 10022 and `is_temporarily` = 0 and `publishing_datetime` <= '2025-04-07 23:54:51' and `publishing_restrictions` = 1 and `activity_reports`.`deleted_at` is null

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

Metadata
Bindings	0. 10022 1. 0 2. 2025-04-07 23:54:51 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` = 10022 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

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

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

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

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

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

Metadata
Bindings	0. 10022 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
`return_items`.*,
(CASE
WHEN `capacity` > 0 THEN `capacity` - `support_quantity`
ELSE 0
END) AS remaining_stock_count -- 在庫数
from `return_items` where `project_id` = 10022 and `is_delete` = 0 and `is_publish` = 1 order by `order_no` asc

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

Metadata
Bindings	0. 10022 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` != 10022 and `projects`.`category` = 'Animal' order by `total_support_price` desc limit 4

203ms/app/Models/Project.php:618forgood

Metadata
Bindings	0. 0 1. 4 2. 0 3. 1 4. 0 5. 0 6. 10022 7. Animal
Backtrace	14. /app/Models/Project.php:618 15. /app/Models/Project.php:574 16. /app/Http/Controllers/ProjectController.php:80 17. /app/Http/Controllers/Controller.php:23 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `projects`.*, (
CASE
WHEN projects.end_date IS NULL THEN '指定なし'
WHEN projects.start_date IS NULL THEN '指定なし'
WHEN projects.start_date > CURRENT_TIME THEN '未公開'
ELSE TIMESTAMPDIFF(MINUTE, NOW(),STR_TO_DATE(CONCAT(projects.end_date,' 23:59:59'), '%Y-%m-%d %H:%i:%s'))
END
) AS days_left
, `support_summaries`.`price_support` as `total_support_price`,
CASE WHEN projects.is_tran = 0 THEN
support_summaries.price_support
ELSE
trn.total
END as price_support,
CASE WHEN projects.is_tran = 0 THEN
support_summaries.count_support
ELSE
trn.count
END as count_support
from `projects` left join `wk_projects` on `projects`.`id` = `wk_projects`.`project_id` and `wk_projects`.`is_delete` = 0 left join
(
SELECT
supports.project_id,
SUM(supports.price_support) as price_support,
COUNT(supports.id) as count_support
FROM supports
WHERE payment_status = 'completed' AND is_delete = 0
GROUP BY project_id
) AS support_summaries
on `projects`.`id` = `support_summaries`.`project_id` left join (SELECT ol.product_id as product_id, sum(os.net_total) as total, count(os.net_total) as count FROM wp_wc_order_product_lookup ol, wp_wc_order_stats os where ol.order_id = os.order_id AND os.status = "wc-completed" GROUP BY ol.product_id) as trn on `trn`.`product_id` = `projects`.`id` where
CASE
-- 申請中
WHEN wk_projects.is_apply_publish = 1 and wk_projects.is_delete = 0 THEN
CASE
WHEN projects.is_publish = 1 THEN 6 -- 6 : ネクスト申請中
ELSE 2 -- 2 : 公開申請中
END
-- 開始日が未設定、もしくは開始日が現在時刻より未来 => 公開前
WHEN projects.start_date IS NULL OR projects.start_date > CURDATE() THEN
CASE
WHEN projects.is_publish = 1 THEN 3 -- 3 : 承認後公開前
ELSE 1 -- 1 : 公開申請前
END
-- 終了日が現在時刻より過去 => 掲載終了
WHEN projects.end_date < CURDATE() THEN
CASE
WHEN projects.target_amount <= support_summaries.price_support THEN 9 -- 9 : 掲載終了(目標達成)
ELSE 8 -- 8 : 掲載終了(目標未達成)
END
-- 掲載中、かつ支援額が達成
WHEN projects.target_amount <= support_summaries.price_support THEN
CASE
WHEN projects.next_target_amount IS NULL THEN 5 -- 5 : 掲載中(目標達成、ネクスト)
ELSE 7 -- 7 : 掲載中(ネクスト挑戦中)
END
ELSE 4 -- 4 : 掲載中(目標未達成)
END >= 4 and IFNULL(DATEDIFF(projects.end_date , CURDATE()), 0) > 0 and `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 and `is_closed` = 0 and `projects`.`id` != 10022 order by `total_support_price` desc limit 4

204ms/app/Models/Project.php:618forgood

Metadata
Bindings	0. 0 1. 4 2. 0 3. 1 4. 0 5. 0 6. 10022
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` = 10022 and `access_date` = '2025-04-07' limit 1

1.14ms/app/Models/ProjectAccessLog.php:29forgood

Metadata
Bindings	0. 10022 1. 2025-04-07
Backtrace	15. /app/Models/ProjectAccessLog.php:29 16. /app/Http/Controllers/ProjectController.php:97 17. /app/Http/Controllers/Controller.php:23 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

insert into `project_access_logs` (`project_id`, `access_date`, `access_count`, `updated_at`, `created_at`) values (10022, '2025/04/07', 1, '2025-04-07 23:54:51', '2025-04-07 23:54:51')

1.68ms/app/Models/ProjectAccessLog.php:44forgood

Metadata
Bindings	0. 10022 1. 2025/04/07 2. 1 3. 2025-04-07 23:54:51 4. 2025-04-07 23:54:51
Backtrace	20. /app/Models/ProjectAccessLog.php:44 21. /app/Http/Controllers/ProjectController.php:97 22. /app/Http/Controllers/Controller.php:23 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

App\Models\Project: 8

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

path_info

/project/10022

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.217.145.147"
  "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" => "46112"
  "REDIRECT_URL" => "/project/10022"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/project/10022"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744037691.1214
  "REQUEST_TIME" => 1744037691
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 07 Apr 2025 14:54:51 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InAxNm1hbHdnUzBqc3JoeWlTYkoycEE9PSIsInZhbHVlIjoiRlNkNDZGQk5yclV0VVpyT096SHE3Q2EycldDSVlYSkRiT2ZTRHRWWXlCWHRvQzVqVThFVUEyV1N3TkRtY1pmcXRJZU5qQkxya0hqamxlV1FVN0VuakZSR294N2o3ZkFPYkVkd2FSbXpoOXFsUGUvN1hXdk9aNzNJL1lDTXZicFgiLCJtYWMiOiI1NDJmMmNlOTFjZGQ1MTRmYTk5MmJkN2VlZWZmMDBiMGQ5OWI5OWQyYTVkOTc0MmUwNmI4MWZiMzc1ZTQ0YzE2IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 22:54:51 GMT; Max-Age=28800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InAxNm1hbHdnUzBqc3JoeWlTYkoycEE9PSIsInZhbHVlIjoiRlNkNDZGQk5yclV0VVpyT096SHE3Q2EycldDSVlYSkRiT2ZTRHRWWXlCWHRvQzVqVThFVUEyV1N3TkRtY1pmcXRJZU5qQ ▶"
    1 => "forgood_session=eyJpdiI6IkRhdCtNU1hja1hwdGJwcC9SSHU3Y0E9PSIsInZhbHVlIjoiZUZibDdIeXBTRkRjSTl4Ly9oWnNaNUk0UC9saWUrRmtCaHJ4L0hNYmNFc1l1R0o3MkwvZ3JBRXJHU2J2SHduRUpYUHVLZUlZWTVGWXJzdEdrRy9nb1BDek1uQnZoQktXV3hsOVl1WVlKeG1XVDR5QlllcndBeVlhWnZTYjBZaFAiLCJtYWMiOiI2NjM3ZjM4YTM3MTcyYzMwMTQ0ZTYwZDA0MTJkOTcwM2RmMmU3YjU3ODM1YjkyZDY4ODZmNzk0YWQ4NjJiN2FiIiwidGFnIjoiIn0%3D; path=/; httponly; samesite=lax ◀forgood_session=eyJpdiI6IkRhdCtNU1hja1hwdGJwcC9SSHU3Y0E9PSIsInZhbHVlIjoiZUZibDdIeXBTRkRjSTl4Ly9oWnNaNUk0UC9saWUrRmtCaHJ4L0hNYmNFc1l1R0o3MkwvZ3JBRXJHU2J2SHduRUpY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InAxNm1hbHdnUzBqc3JoeWlTYkoycEE9PSIsInZhbHVlIjoiRlNkNDZGQk5yclV0VVpyT096SHE3Q2EycldDSVlYSkRiT2ZTRHRWWXlCWHRvQzVqVThFVUEyV1N3TkRtY1pmcXRJZU5qQkxya0hqamxlV1FVN0VuakZSR294N2o3ZkFPYkVkd2FSbXpoOXFsUGUvN1hXdk9aNzNJL1lDTXZicFgiLCJtYWMiOiI1NDJmMmNlOTFjZGQ1MTRmYTk5MmJkN2VlZWZmMDBiMGQ5OWI5OWQyYTVkOTc0MmUwNmI4MWZiMzc1ZTQ0YzE2IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 22:54:51 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InAxNm1hbHdnUzBqc3JoeWlTYkoycEE9PSIsInZhbHVlIjoiRlNkNDZGQk5yclV0VVpyT096SHE3Q2EycldDSVlYSkRiT2ZTRHRWWXlCWHRvQzVqVThFVUEyV1N3TkRtY1pmcXRJZU5qQ ▶"
    1 => "forgood_session=eyJpdiI6IkRhdCtNU1hja1hwdGJwcC9SSHU3Y0E9PSIsInZhbHVlIjoiZUZibDdIeXBTRkRjSTl4Ly9oWnNaNUk0UC9saWUrRmtCaHJ4L0hNYmNFc1l1R0o3MkwvZ3JBRXJHU2J2SHduRUpYUHVLZUlZWTVGWXJzdEdrRy9nb1BDek1uQnZoQktXV3hsOVl1WVlKeG1XVDR5QlllcndBeVlhWnZTYjBZaFAiLCJtYWMiOiI2NjM3ZjM4YTM3MTcyYzMwMTQ0ZTYwZDA0MTJkOTcwM2RmMmU3YjU3ODM1YjkyZDY4ODZmNzk0YWQ4NjJiN2FiIiwidGFnIjoiIn0%3D; path=/; httponly ◀forgood_session=eyJpdiI6IkRhdCtNU1hja1hwdGJwcC9SSHU3Y0E9PSIsInZhbHVlIjoiZUZibDdIeXBTRkRjSTl4Ly9oWnNaNUk0UC9saWUrRmtCaHJ4L0hNYmNFc1l1R0o3MkwvZ3JBRXJHU2J2SHduRUpY ▶"
  ]
]

session_attributes

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