動物のクラウドファンディングプロジェクト一覧

Messages20 Timeline Exceptions Views16 Route Queries12 Models75 Gate Session Request

8.1.2447ms3MBGET search/{category?}

infolog[18:13:38] LOG.info: [Controller] Target Controller : SearchController Method : index
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: mb_strwidth(): Passing null to parameter #1 ($string) of type string is depr...
warninglog[18:13:38] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[18:13:38] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...

Booting (8.88ms)
Application (438ms)
1 x Application (98%)
437.60ms
1 x Booting (1.99%)
8.88ms

16 templates were rendered

search.search_pc (resources/views/search/search_pc.blade.php)11bladefile


cond
categories
display_orders
projects
latest_support_comments
categoryLabel
categorySort
categorySortText
prefectures
has_session
has_project

Params
0	`cond`
1	`categories`
2	`display_orders`
3	`projects`
4	`latest_support_comments`
5	`categoryLabel`
6	`categorySort`
7	`categorySortText`
8	`prefectures`
9	`has_session`
10	`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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


project
color_types
componentName
attributes
resolve
flushCache
forgetFactory
forgetComponentsResolver
resolveComponentsUsing
slot
__laravel_slots
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

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`

Params
0	`paginator`
1	`elements`
2	`has_session`
3	`has_project`

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


__env
app
errors
cond
categories
display_orders
projects
latest_support_comments
categoryLabel
categorySort
categorySortText
prefectures
has_session
has_project
__currentLoopData
category
loop
display_order
prefecture
project
component
comment
created
now
diff
minutes
hours
days
months
years

Params
0	`__env`
1	`app`
2	`errors`
3	`cond`
4	`categories`
5	`display_orders`
6	`projects`
7	`latest_support_comments`
8	`categoryLabel`
9	`categorySort`
10	`categorySortText`
11	`prefectures`
12	`has_session`
13	`has_project`
14	`__currentLoopData`
15	`category`
16	`loop`
17	`display_order`
18	`prefecture`
19	`project`
20	`component`
21	`comment`
22	`created`
23	`now`
24	`diff`
25	`minutes`
26	`hours`
27	`days`
28	`months`
29	`years`

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


__env
app
errors
cond
categories
display_orders
projects
latest_support_comments
categoryLabel
categorySort
categorySortText
prefectures
has_session
has_project
__currentLoopData
category
loop
display_order
prefecture
project
component
comment
created
now
diff
minutes
hours
days
months
years

Params
0	`__env`
1	`app`
2	`errors`
3	`cond`
4	`categories`
5	`display_orders`
6	`projects`
7	`latest_support_comments`
8	`categoryLabel`
9	`categorySort`
10	`categorySortText`
11	`prefectures`
12	`has_session`
13	`has_project`
14	`__currentLoopData`
15	`category`
16	`loop`
17	`display_order`
18	`prefecture`
19	`project`
20	`component`
21	`comment`
22	`created`
23	`now`
24	`diff`
25	`minutes`
26	`hours`
27	`days`
28	`months`
29	`years`

uri: GET search/{category?}
middleware: web
controller: App\Http\Controllers\SearchController@index
namespace
prefix
where
as: search.index
file: app/Http/Controllers/SearchController.php:18-105

12 statements were executed, 7 of which were duplicated, 5 unique. Show only duplicated418ms

select * from `prefectures`

1.52ms/app/Http/Controllers/SearchController.php:37forgood

Metadata
Backtrace	15. /app/Http/Controllers/SearchController.php:37 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(distinct `projects`.`id`) as aggregate 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 `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 and `projects`.`is_closed` = 0 and
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
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 <= 9 and `projects`.`category` = 'ANIMAL'

200ms/app/Models/Project.php:369forgood

Metadata
Bindings	0. 0 1. 1 2. 0 3. 0 4. 3 5. 9 6. ANIMAL
Backtrace	15. /app/Models/Project.php:369 16. /app/Http/Controllers/SearchController.php:83 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 distinct `projects`.*, CASE
WHEN DATE(projects.start_date) > CURDATE()  and projects.is_publish  = 1 THEN 1 -- : 承認後公開前
WHEN DATE(projects.start_date) <= CURDATE() and DATE(projects.end_date) >= CURDATE()  and projects.is_publish  = 1 THEN 0  -- : 公開中
ELSE 2  -- : 終了
END
AS is_active, CASE
WHEN projects.is_tran > 0 THEN
CASE
WHEN projects.target_amount > 0 THEN
ROUND( IFNULL(trn.total, 0) / projects.target_amount * 100, 1)
ELSE 0
END
ELSE
CASE
WHEN projects.target_amount > 0 THEN
ROUND( IFNULL(support_summaries.price_support, 0) / projects.target_amount * 100, 1)
ELSE 0
END
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 `projects`.`is_publish` = 1 and `projects`.`is_delete` = 0 and `projects`.`is_closed` = 0 and
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
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 <= 9 and `projects`.`category` = 'ANIMAL' order by `is_active` asc, `count_support` desc limit 12 offset 24

209ms/app/Models/Project.php:369forgood

Metadata
Bindings	0. 0 1. 1 2. 0 3. 0 4. 3 5. 9 6. ANIMAL
Backtrace	15. /app/Models/Project.php:369 16. /app/Http/Controllers/SearchController.php:83 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`.* from `support_comments` inner join `supports` on `supports`.`id` = `support_comments`.`support_id` inner join `projects` on `projects`.`id` = `support_comments`.`project_id` inner join (select `project_id`, MAX(created_at) as latest_created_at from `support_comments` where `is_delete` = 0 group by `project_id`) as `latest_comments` on `support_comments`.`project_id` = `latest_comments`.`project_id` and `support_comments`.`created_at` = `latest_comments`.`latest_created_at` where `supports`.`payment_status` = 'completed' and `support_comments`.`is_delete` = 0 and `projects`.`is_closed` = 0 and `projects`.`category` = 'ANIMAL' and `support_comments`.`deleted_at` is null order by `latest_comments`.`latest_created_at` desc limit 12

4.55ms/app/Models/SupportComment.php:137forgood

Metadata
Bindings	0. 0 1. completed 2. 0 3. 0 4. ANIMAL
Backtrace	14. /app/Models/SupportComment.php:137 15. /app/Http/Controllers/SearchController.php:95 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

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

450μs/app/Http/Controllers/SearchController.php:97forgood

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

340μs/app/Http/Controllers/SearchController.php:97forgood

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

330μs/app/Http/Controllers/SearchController.php:97forgood

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

310μs/app/Http/Controllers/SearchController.php:97forgood

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

270μs/app/Http/Controllers/SearchController.php:97forgood

Metadata
Bindings	0. 5303
Backtrace	15. /app/Http/Controllers/SearchController.php:97 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

300μs/app/Http/Controllers/SearchController.php:97forgood

Metadata
Bindings	0. 10137
Backtrace	15. /app/Http/Controllers/SearchController.php:97 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

260μs/app/Http/Controllers/SearchController.php:97forgood

Metadata
Bindings	0. 10137
Backtrace	15. /app/Http/Controllers/SearchController.php:97 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/SearchController.php:97forgood

Metadata
Bindings	0. 10000
Backtrace	15. /app/Http/Controllers/SearchController.php:97 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: 8
App\Models\SupportComment: 8
App\Models\Project: 12
App\Models\Prefecture: 47

_token: KAbN4YdbR2ksMXD53VEUWHox54p3gKIbhkOglLuA
_previous: array:1 [ "url" => "https://forgood-jp.com/search/animal?page=3" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/search/animal

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "3"
]

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:45 [▼
  "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.147.49.219"
  "DOCUMENT_ROOT" => "/var/www/html/forgood/forgood-web/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/forgood/forgood-web/public"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/forgood/forgood-web/public/index.php"
  "REMOTE_PORT" => "38420"
  "REDIRECT_URL" => "/search/animal"
  "REDIRECT_QUERY_STRING" => "page=3"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=3"
  "REQUEST_URI" => "/search/animal?page=3"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743930818.2995
  "REQUEST_TIME" => 1743930818
]

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 => "Sun, 06 Apr 2025 09:13:38 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im12OThjZ2dOeU00aGVNZEJxeWErckE9PSIsInZhbHVlIjoiWDFOdlJWTHpjbkNvTDJPS0Z6eEtRUGxwUzBiUUlsUlJhQlVTOTZ6dkFaL1JZZUkwbENBZjk1LytHamFjVWRMUHZrUVhOeTdHVHp1ZFduUytvZUkrUGExMllpU0JpemlZZzlEYXRjalJBZnpYenNwWUwwNHhiWkhaa2ZWQTZvbk8iLCJtYWMiOiIxODU0MDZjM2Y3ZmRmYWUyNDRlNjk0ZjBlMTIzODAxMjI4MmQ4MTVlOTJhMzNlOWIxNGJjZTE4MjY5NGIwNjQ5IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 17:13:38 GMT; Max-Age=28800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im12OThjZ2dOeU00aGVNZEJxeWErckE9PSIsInZhbHVlIjoiWDFOdlJWTHpjbkNvTDJPS0Z6eEtRUGxwUzBiUUlsUlJhQlVTOTZ6dkFaL1JZZUkwbENBZjk1LytHamFjVWRMUHZrUVhOe ▶"
    1 => "forgood_session=eyJpdiI6ImNqMktWVTlnczRyRFA0cEZlVUc1dnc9PSIsInZhbHVlIjoiNTlGYnQvMkFHd3UvOFRqZk45TDVuNzNVOE5IbU9UbVFaYnRWTlBzbnVPQ3dVRVZYNTM0UVVkemdiRysrdW56MFBYcjFtQnMxbUdmWW50M3Y0K3VPa1NDRFBzajdMbjFsMjkyNU1meksxY2g3K1Rnc2Q0QXQzOWFPbjRONEMwbmUiLCJtYWMiOiI5Mjg0MmM3NzU2YjM1MzFiYmRiNDBkOTA0MDlkMGJjYTEzZTdmZTc3Yzk5NGU3NGFiZGQwOTlkZTI0ZTkyNDk4IiwidGFnIjoiIn0%3D; path=/; httponly; samesite=lax ◀forgood_session=eyJpdiI6ImNqMktWVTlnczRyRFA0cEZlVUc1dnc9PSIsInZhbHVlIjoiNTlGYnQvMkFHd3UvOFRqZk45TDVuNzNVOE5IbU9UbVFaYnRWTlBzbnVPQ3dVRVZYNTM0UVVkemdiRysrdW56MFBY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im12OThjZ2dOeU00aGVNZEJxeWErckE9PSIsInZhbHVlIjoiWDFOdlJWTHpjbkNvTDJPS0Z6eEtRUGxwUzBiUUlsUlJhQlVTOTZ6dkFaL1JZZUkwbENBZjk1LytHamFjVWRMUHZrUVhOeTdHVHp1ZFduUytvZUkrUGExMllpU0JpemlZZzlEYXRjalJBZnpYenNwWUwwNHhiWkhaa2ZWQTZvbk8iLCJtYWMiOiIxODU0MDZjM2Y3ZmRmYWUyNDRlNjk0ZjBlMTIzODAxMjI4MmQ4MTVlOTJhMzNlOWIxNGJjZTE4MjY5NGIwNjQ5IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 17:13:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im12OThjZ2dOeU00aGVNZEJxeWErckE9PSIsInZhbHVlIjoiWDFOdlJWTHpjbkNvTDJPS0Z6eEtRUGxwUzBiUUlsUlJhQlVTOTZ6dkFaL1JZZUkwbENBZjk1LytHamFjVWRMUHZrUVhOe ▶"
    1 => "forgood_session=eyJpdiI6ImNqMktWVTlnczRyRFA0cEZlVUc1dnc9PSIsInZhbHVlIjoiNTlGYnQvMkFHd3UvOFRqZk45TDVuNzNVOE5IbU9UbVFaYnRWTlBzbnVPQ3dVRVZYNTM0UVVkemdiRysrdW56MFBYcjFtQnMxbUdmWW50M3Y0K3VPa1NDRFBzajdMbjFsMjkyNU1meksxY2g3K1Rnc2Q0QXQzOWFPbjRONEMwbmUiLCJtYWMiOiI5Mjg0MmM3NzU2YjM1MzFiYmRiNDBkOTA0MDlkMGJjYTEzZTdmZTc3Yzk5NGU3NGFiZGQwOTlkZTI0ZTkyNDk4IiwidGFnIjoiIn0%3D; path=/; httponly ◀forgood_session=eyJpdiI6ImNqMktWVTlnczRyRFA0cEZlVUc1dnc9PSIsInZhbHVlIjoiNTlGYnQvMkFHd3UvOFRqZk45TDVuNzNVOE5IbU9UbVFaYnRWTlBzbnVPQ3dVRVZYNTM0UVVkemdiRysrdW56MFBY ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "KAbN4YdbR2ksMXD53VEUWHox54p3gKIbhkOglLuA"
  "_previous" => array:1 [▶
    "url" => "https://forgood-jp.com/search/animal?page=3"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

みんなの応援コメント

For Good（フォーグッド）｜ソーシャ... For Good（フォーグッ...

テストユーザーテストユーザー

テスト送信_上尾テスト送信_上尾

sss sss

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

銀振梶浦銀振梶浦

かじうらかじうら

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

1 x Application (98%)	437.60ms
1 x Booting (1.99%)	8.88ms

「動物」で注目のプロジェクト

目標金額

リターン金額

達成率

公開ステータス

地域

みんなの応援コメント

For Good（フォーグッド）｜ソーシャ... For Good（フォーグッ...

テスト ユーザー テスト ユーザー

テスト送信_上尾 テスト送信_上尾

sss sss

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

銀振梶浦 銀振梶浦

かじうら かじうら

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

テストユーザーテストユーザー

テスト送信_上尾テスト送信_上尾

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

銀振梶浦銀振梶浦

かじうらかじうら