綠屋異國風味美食館(健康)-ESGPB撇步現正折扣中

商品名稱數量小計

合計：$
0
前往購物車
註冊 / 登入

健康

綠屋異國風味美食館

關於商家

巷子內的平價美味簡餐店

台南市東區勝利路52巷22號

0620 033 51

營業時間

星期一：09:00:00 ~ 21:00:00
星期四：09:00:00 ~ 21:00:00
星期五：09:00:00 ~ 21:00:00
星期六：09:16:48 ~ 21:16:48

335 評論數

4.6

認同收藏

加入我們的行列，用ESG行動為地球降溫！

猜你也有興趣的店

其他人也會逛的店

5 點換

累積點數

Messages Timeline Exceptions Views10 Route Queries45 Mails Gate Session Request

7.4.33144ms13MBGET store/{id}

Booting (32.88ms)
Application (111ms)
1 x Application (77.1%)
111.16ms
1 x Booting (22.81%)
32.88ms

10 templates were rendered

bonus.store.show (resources/views/bonus/store/show.blade.php)19blade


store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon

Params
0	`store`
1	`sc`
2	`posts`
3	`recommended_stores`
4	`otherPeopleVisit`
5	`user_vip_ids`
6	`vip_discounts`
7	`vip_titles`
8	`now_discount`
9	`today_discount`
10	`group_discounts`
11	`products`
12	`mapEmbedUrl`
13	`user_already_has_vips`
14	`groupNames`
15	`event`
16	`storeEsgCategories`
17	`videos`
18	`lotteryCoupon`

shop.main (resources/views/shop/main.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

shop.head-section (resources/views/shop/head-section.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

3rd.gtm-tag-head (resources/views/3rd/gtm-tag-head.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

3rd.gtm-tag-body (resources/views/3rd/gtm-tag-body.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

shop.header (resources/views/shop/header.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

shop.header-menu (resources/views/shop/header-menu.blade.php)34blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store
referer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`
33	`referer`

shop.header-cart (resources/views/shop/header-cart.blade.php)40blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store
referer
header_vips
user
hasStores
hasGroups
isApplyStorePage
isGroupManagePage

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`
33	`referer`
34	`header_vips`
35	`user`
36	`hasStores`
37	`hasGroups`
38	`isApplyStorePage`
39	`isGroupManagePage`

shop.footer (resources/views/shop/footer.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

about.in-privacy (resources/views/about/in-privacy.blade.php)33blade


obLevel
__env
app
errors
store
sc
posts
recommended_stores
otherPeopleVisit
user_vip_ids
vip_discounts
vip_titles
now_discount
today_discount
group_discounts
products
mapEmbedUrl
user_already_has_vips
groupNames
event
storeEsgCategories
videos
lotteryCoupon
__currentLoopData
link
loop
businessHour
rating
i
recommended_store
checkeds
checked
visit_store

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`store`
5	`sc`
6	`posts`
7	`recommended_stores`
8	`otherPeopleVisit`
9	`user_vip_ids`
10	`vip_discounts`
11	`vip_titles`
12	`now_discount`
13	`today_discount`
14	`group_discounts`
15	`products`
16	`mapEmbedUrl`
17	`user_already_has_vips`
18	`groupNames`
19	`event`
20	`storeEsgCategories`
21	`videos`
22	`lotteryCoupon`
23	`__currentLoopData`
24	`link`
25	`loop`
26	`businessHour`
27	`rating`
28	`i`
29	`recommended_store`
30	`checkeds`
31	`checked`
32	`visit_store`

uri: GET store/{id}
middleware: web
controller: App\Http\Controllers\Store\StoreIndexController@show
namespace: App\Http\Controllers
prefix
where
as: store.detail
file: app/Http/Controllers/Store/StoreIndexController.php:62-282

45 statements were executed, 2 of which were duplicated, 43 unique37.04ms

select * from `tracker_routes` where `name` = 'store.detail' and `action` = 'App\Http\Controllers\Store\StoreIndexController@show' limit 1

1.25ms/vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127chi_bonus

Metadata
Bindings	0. store.detail 1. App\Http\Controllers\Store\StoreIndexController@show
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127 16. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:540 17. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:589 18. /vendor/pragmarx/tracker/src/Tracker.php:224 19. /vendor/pragmarx/tracker/src/Tracker.php:470

select * from `tracker_route_paths` where `route_id` = 1223 and `path` = 'store/163' limit 1420μs/vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127chi_bonus

Metadata
Bindings	0. 1223 1. store/163
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127 16. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:578 17. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:597 18. /vendor/pragmarx/tracker/src/Tracker.php:224 19. /vendor/pragmarx/tracker/src/Tracker.php:470

select * from `tracker_sessions` where `uuid` = 'a367090b-b1d7-48a4-8aa1-ef1ac02eb80a' limit 1910μs/vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127chi_bonus

Metadata
Bindings	0. a367090b-b1d7-48a4-8aa1-ef1ac02eb80a
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:127 16. /vendor/pragmarx/tracker/src/Data/Repositories/Session.php:97 17. /vendor/pragmarx/tracker/src/Data/Repositories/Session.php:53 18. /vendor/pragmarx/tracker/src/Data/Repositories/Session.php:44 19. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:635

insert into `tracker_sessions` (`user_id`, `device_id`, `client_ip`, `geoip_id`, `agent_id`, `referer_id`, `cookie_id`, `language_id`, `is_robot`, `uuid`, `updated_at`, `created_at`) values ('', '', '192.168.114.194', '', '', '', '', '', 1, 'a367090b-b1d7-48a4-8aa1-ef1ac02eb80a', '2025-04-09 14:06:20', '2025-04-09 14:06:20')

1.83ms/vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34chi_bonus

Metadata
Bindings	0. 1. 2. 192.168.114.194 3. 4. 5. 6. 7. 8. 1 9. a367090b-b1d7-48a4-8aa1-ef1ac02eb80a 10. 2025-04-09 14:06:20 11. 2025-04-09 14:06:20
Backtrace	15. /vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34 16. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:83 17. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:128 18. /vendor/pragmarx/tracker/src/Data/Repositories/Session.php:97 19. /vendor/pragmarx/tracker/src/Data/Repositories/Session.php:53

insert into `tracker_log` (`session_id`, `method`, `path_id`, `query_id`, `referer_id`, `is_ajax`, `is_secure`, `is_json`, `wants_json`, `updated_at`, `created_at`) values (76808, 'GET', '', '', '', 0, 1, 0, 0, '2025-04-09 14:06:20', '2025-04-09 14:06:20')

1.72ms/vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34chi_bonus

Metadata
Bindings	0. 76808 1. GET 2. 3. 4. 5. 0 6. 1 7. 0 8. 0 9. 2025-04-09 14:06:20 10. 2025-04-09 14:06:20
Backtrace	15. /vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34 16. /vendor/pragmarx/tracker/src/Data/Repositories/Repository.php:83 17. /vendor/pragmarx/tracker/src/Data/Repositories/Log.php:74 18. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:259 19. /vendor/pragmarx/tracker/src/Tracker.php:506

update `tracker_log` set `route_path_id` = 8353, `tracker_log`.`updated_at` = '2025-04-09 14:06:20' where `id` = 3351761.85ms/vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34chi_bonus

Metadata
Bindings	0. 8353 1. 2025-04-09 14:06:20 2. 335176
Backtrace	13. /vendor/pragmarx/tracker/src/Vendor/Laravel/Models/Base.php:34 14. /vendor/pragmarx/tracker/src/Data/Repositories/Log.php:22 15. /vendor/pragmarx/tracker/src/Data/Repositories/Log.php:76 16. /vendor/pragmarx/tracker/src/Data/RepositoryManager.php:259 17. /vendor/pragmarx/tracker/src/Tracker.php:506

select * from `stores` where `stores`.`id` = '163' and `stores`.`deleted_at` is null limit 1540μs/app/Http/Controllers/Store/StoreIndexController.php:64chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. /app/Http/Controllers/Store/StoreIndexController.php:64 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `store_categories`480μs/app/Http/Controllers/Store/StoreIndexController.php:72chi_bonus

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:72 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `events`.*, `stores_events`.`store_id` as `pivot_store_id`, `stores_events`.`event_id` as `pivot_event_id` from `events` inner join `stores_events` on `events`.`id` = `stores_events`.`event_id` where `stores_events`.`store_id` = 163 and `enabled` = 1 and `start_at` <= '2025-04-09 14:06:20' and `display_end_at` >= '2025-04-09 14:06:20' limit 1

530μs/app/Http/Controllers/Store/StoreIndexController.php:100chi_bonus

Metadata
Bindings	0. 163 1. 1 2. 2025-04-09 14:06:20 3. 2025-04-09 14:06:20
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:100 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `vip_discount_times` where `vip_discount_times`.`store_id` = 163 and `vip_discount_times`.`store_id` is not null and exists (select * from `vip_discount_time_days` where `vip_discount_times`.`id` = `vip_discount_time_days`.`vip_discount_time_id` and `week_day` = 3) and exists (select * from `vips` inner join `vip_discount_time_vip_map` on `vips`.`id` = `vip_discount_time_vip_map`.`vip_id` where `vip_discount_times`.`id` = `vip_discount_time_vip_map`.`vip_discount_time_id` and `enable` = 1 and `use_start_at` <= '2025-04-09 14:06:20' and `use_end_at` >= '2025-04-09 14:06:20') and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' order by `end_at` asc

670μs/app/Http/Controllers/Store/StoreIndexController.php:118chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 14:06:20 4. 2025-04-09 14:06:20 5. 1 6. 2025-04-09 7. 2025-04-09
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:118 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select distinct `title` from `vips` where `enable` = 1 and `use_start_at` <= '2025-04-09 14:06:20' and `use_end_at` >= '2025-04-09 14:06:20' and exists (select * from `vip_discount_times` inner join `vip_discount_time_vip_map` on `vip_discount_times`.`id` = `vip_discount_time_vip_map`.`vip_discount_time_id` where `vips`.`id` = `vip_discount_time_vip_map`.`vip_id` and 0 = 1)

500μs/app/Http/Controllers/Store/StoreIndexController.php:162chi_bonus

Metadata
Bindings	0. 1 1. 2025-04-09 14:06:20 2. 2025-04-09 14:06:20
Backtrace	13. /app/Http/Controllers/Store/StoreIndexController.php:162 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `discount_times` where `discount_times`.`store_id` = 163 and `discount_times`.`store_id` is not null and exists (select * from `discount_time_days` where `discount_times`.`id` = `discount_time_days`.`discount_time_id` and `weekday` = 3) and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' and `open_time` <= '14:06:20' and `end_time` >= '14:06:20' order by `end_at` asc limit 1

580μs/app/Http/Controllers/Store/StoreIndexController.php:165chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 4. 2025-04-09 5. 14:06:20 6. 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:165 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `discount_times` where `discount_times`.`store_id` = 163 and `discount_times`.`store_id` is not null and exists (select * from `discount_time_days` where `discount_times`.`id` = `discount_time_days`.`discount_time_id` and `weekday` = 3) and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' and `end_time` > '14:06:20' order by `end_at` asc limit 1

450μs/app/Http/Controllers/Store/StoreIndexController.php:174chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 4. 2025-04-09 5. 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:174 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `group_store_discounts` where `group_store_discounts`.`store_id` = 163 and `group_store_discounts`.`store_id` is not null and exists (select * from `groups` where `group_store_discounts`.`group_id` = `groups`.`id` and `status` = 1 and `groups`.`deleted_at` is null) and `status` = 1 and (`has_deadline` = 0 or (`has_deadline` = 1 and `start_at` <= '2025-04-09 14:06:20' and `end_at` >= '2025-04-09 14:06:20')) and `group_store_discounts`.`deleted_at` is null

550μs/app/Http/Controllers/Store/StoreIndexController.php:195chi_bonus

Metadata
Bindings	0. 163 1. 1 2. 1 3. 0 4. 1 5. 2025-04-09 14:06:20 6. 2025-04-09 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:195 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `posts` where `posts`.`store_id` = 163 and `posts`.`store_id` is not null order by `created_at` desc420μs/app/Http/Controllers/Store/StoreIndexController.php:212chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Store/StoreIndexController.php:212 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 163

440μs/app/Http/Controllers/Store/StoreIndexController.php:434chi_bonus

Metadata
Bindings	0. 163
Backtrace	19. /app/Http/Controllers/Store/StoreIndexController.php:434 20. /app/Http/Controllers/Store/StoreIndexController.php:223 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select *, ST_Distance_Sphere(point(stores.lng, stores.lat), point(120.2184666, 22.9913768)) as distance from `stores` where `checkout` = 1 and `show` = 1 and `id` != 163 and `lat` is not null and `lng` is not null and exists (select * from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `stores`.`id` = `st_categories`.`store_id` and `store_category_id` in (6)) and `stores`.`deleted_at` is null order by `distance` asc limit 10

5.44ms/app/Http/Controllers/Store/StoreIndexController.php:452chi_bonus

Metadata
Bindings	0. 120.2184666 1. 22.9913768 2. 1 3. 1 4. 163 5. 6
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:452 15. /app/Http/Controllers/Store/StoreIndexController.php:223 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `stores` where `id` != 163 and `checkout` = 1 and `show` = 1 and `id` not in (7792, 7796) and `stores`.`deleted_at` is null order by RAND() limit 1

4.65ms/app/Http/Controllers/Store/StoreIndexController.php:467chi_bonus

Metadata
Bindings	0. 163 1. 1 2. 1 3. 7792 4. 7796
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:467 15. /app/Http/Controllers/Store/StoreIndexController.php:223 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `store_interest_categories` where `store_id` = 163 limit 1460μs/app/Http/Controllers/Store/StoreIndexController.php:494chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:494 16. /app/Http/Controllers/Store/StoreIndexController.php:224 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `store_view_ranks` where `store_id` != 163 and `category_id` = 1 order by RAND() limit 1520μs/app/Http/Controllers/Store/StoreIndexController.php:515chi_bonus

Metadata
Bindings	0. 163 1. 1
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:515 15. /app/Http/Controllers/Store/StoreIndexController.php:224 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `stores` where `stores`.`id` in (3) and `stores`.`deleted_at` is null440μs/app/Http/Controllers/Store/StoreIndexController.php:515chi_bonus

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Store/StoreIndexController.php:515 20. /app/Http/Controllers/Store/StoreIndexController.php:224 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `store_view_ranks` where `store_id` != 163 and `category_id` = 4 order by RAND() limit 1430μs/app/Http/Controllers/Store/StoreIndexController.php:515chi_bonus

Metadata
Bindings	0. 163 1. 4
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:515 15. /app/Http/Controllers/Store/StoreIndexController.php:224 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `stores` where `stores`.`id` in (182) and `stores`.`deleted_at` is null460μs/app/Http/Controllers/Store/StoreIndexController.php:515chi_bonus

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Store/StoreIndexController.php:515 20. /app/Http/Controllers/Store/StoreIndexController.php:224 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `store_view_ranks` where `store_id` != 163 and `category_id` not in (1, 4) and `store_id` not in (3, 182) order by RAND() limit 1

400μs/app/Http/Controllers/Store/StoreIndexController.php:528chi_bonus

Metadata
Bindings	0. 163 1. 1 2. 4 3. 3 4. 182
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:528 15. /app/Http/Controllers/Store/StoreIndexController.php:224 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `stores` where `stores`.`id` in (245) and `stores`.`deleted_at` is null530μs/app/Http/Controllers/Store/StoreIndexController.php:528chi_bonus

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Store/StoreIndexController.php:528 20. /app/Http/Controllers/Store/StoreIndexController.php:224 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `organizer_contacts` where `organizer_contacts`.`store_id` = 163 and `organizer_contacts`.`store_id` is not null

350μs/app/Http/Controllers/Store/StoreIndexController.php:543chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:543 16. /app/Http/Controllers/Store/StoreIndexController.php:225 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `id` from `products` where `products`.`store_id` = 163 and `products`.`store_id` is not null and `online` = '1' and `pay_begin` <= '2025-04-09 14:06:20' and `pay_end` >= '2025-04-09 14:06:20' and exists (select * from `sales_targets` inner join `products_sales_targets` on `sales_targets`.`id` = `products_sales_targets`.`sales_target_id` where `products`.`id` = `products_sales_targets`.`product_id` and `sales_targets`.`slug` in ('to_c'))

1.55ms/app/Http/Controllers/Store/StoreIndexController.php:560chi_bonus

Metadata
Bindings	0. 163 1. 1 2. 2025-04-09 14:06:20 3. 2025-04-09 14:06:20 4. to_c
Backtrace	15. /app/Http/Controllers/Store/StoreIndexController.php:560 16. /app/Http/Controllers/Store/StoreIndexController.php:225 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `products` where `online` = 1 and 0 = 1390μs/app/Http/Controllers/Store/StoreIndexController.php:563chi_bonus

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:563 15. /app/Http/Controllers/Store/StoreIndexController.php:225 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `store_esg_categories` where `store_esg_categories`.`store_id` = 163 and `store_esg_categories`.`store_id` is not null limit 1

420μs/app/Http/Controllers/Store/StoreIndexController.php:229chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. /app/Http/Controllers/Store/StoreIndexController.php:229 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `esg_store_categories` where 0 = 1 and `enable` = 1410μs/app/Http/Controllers/Store/StoreIndexController.php:230chi_bonus

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:230 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `videos` where `store_id` = 163 and exists (select * from `places` inner join `videos_places` on `places`.`id` = `videos_places`.`place_id` where `videos`.`id` = `videos_places`.`videos_id` and `slug` = 'store-view') order by `created_at` desc

470μs/app/Http/Controllers/Store/StoreIndexController.php:250chi_bonus

Metadata
Bindings	0. 163 1. store-view
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Store/StoreIndexController.php:250 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `store_lottery_coupons` where `store_lottery_coupons`.`store_id` = 163 and `store_lottery_coupons`.`store_id` is not null and `start_at` <= '2025-04-09 14:06:20' and `announcement_at` > '2025-04-09 14:06:20' and `store_lottery_coupons`.`deleted_at` is null order by CASE WHEN end_at > '2025-04-09 14:06:20' THEN 1 ELSE 2 END, end_at ASC limit 1

560μs/app/Http/Controllers/Store/StoreIndexController.php:256chi_bonus

Metadata
Bindings	0. 163 1. 2025-04-09 14:06:20 2. 2025-04-09 14:06:20 3. 2025-04-09 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Http/Controllers/Store/StoreIndexController.php:256 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `vip_discount_times` where `vip_discount_times`.`store_id` = 163 and `vip_discount_times`.`store_id` is not null and exists (select * from `vip_discount_time_days` where `vip_discount_times`.`id` = `vip_discount_time_days`.`vip_discount_time_id` and `week_day` = 3) and exists (select * from `vips` inner join `vip_discount_time_vip_map` on `vips`.`id` = `vip_discount_time_vip_map`.`vip_id` where `vip_discount_times`.`id` = `vip_discount_time_vip_map`.`vip_discount_time_id` and `enable` = 1 and `use_start_at` <= '2025-04-09 14:06:20' and `use_end_at` >= '2025-04-09 14:06:20') and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' order by `end_at` asc

420μsview::0e8f95eb4a146824998d12fe26eee87f523da785:558chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 14:06:20 4. 2025-04-09 14:06:20 5. 1 6. 2025-04-09 7. 2025-04-09
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:558 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `discount_times` where `discount_times`.`store_id` = 163 and `discount_times`.`store_id` is not null and exists (select * from `discount_time_days` where `discount_times`.`id` = `discount_time_days`.`discount_time_id` and `weekday` = 3) and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' and `open_time` <= '14:06:20' and `end_time` >= '14:06:20' order by `end_at` asc

1.27msview::0e8f95eb4a146824998d12fe26eee87f523da785:562chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 4. 2025-04-09 5. 14:06:20 6. 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:562 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `discount_times` where `discount_times`.`store_id` = 163 and `discount_times`.`store_id` is not null and exists (select * from `discount_time_days` where `discount_times`.`id` = `discount_time_days`.`discount_time_id` and `weekday` = 3) and `enable` = 1 and `start_at` <= '2025-04-09' and `end_at` >= '2025-04-09' and `end_time` > '14:06:20' order by `end_at` asc

460μsview::0e8f95eb4a146824998d12fe26eee87f523da785:566chi_bonus

Metadata
Bindings	0. 163 1. 3 2. 1 3. 2025-04-09 4. 2025-04-09 5. 14:06:20
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:566 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `business_hours` where `business_hours`.`store_id` = 163 and `business_hours`.`store_id` is not null order by `day_of_week` asc

520μsview::0e8f95eb4a146824998d12fe26eee87f523da785:639chi_bonus

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:639 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `merchants` where `merchants`.`store_id` = 163 and `merchants`.`store_id` is not null limit 1850μs/app/Traits/HandlesGoogleBooking.php:16gmb

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. /app/Traits/HandlesGoogleBooking.php:16 26. view::0e8f95eb4a146824998d12fe26eee87f523da785:694 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 30. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 7792

370μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1259chi_bonus

Metadata
Bindings	0. 7792
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1259 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 7796

330μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1259chi_bonus

Metadata
Bindings	0. 7796
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1259 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 237

350μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1259chi_bonus

Metadata
Bindings	0. 237
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1259 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 3

350μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1309chi_bonus

Metadata
Bindings	0. 3
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1309 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 182

330μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1309chi_bonus

Metadata
Bindings	0. 182
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1309 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `store_categories`.*, `st_categories`.`store_id` as `pivot_store_id`, `st_categories`.`store_category_id` as `pivot_store_category_id` from `store_categories` inner join `st_categories` on `store_categories`.`id` = `st_categories`.`store_category_id` where `st_categories`.`store_id` = 245

360μsview::0e8f95eb4a146824998d12fe26eee87f523da785:1309chi_bonus

Metadata
Bindings	0. 245
Backtrace	19. view::0e8f95eb4a146824998d12fe26eee87f523da785:1309 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select exists(select * from `favorites` where `favorites`.`favoriteable_id` = 163 and `favorites`.`favoriteable_id` is not null and `favorites`.`favoriteable_type` = 'App\Models\Products\Store' and `user_id` is null) as `exists`

380μs/vendor/christiankuri/laravel-favorite/src/Traits/Favoriteable.php:68chi_bonus

Metadata
Bindings	0. 163 1. App\Models\Products\Store
Backtrace	12. /vendor/christiankuri/laravel-favorite/src/Traits/Favoriteable.php:68 13. view::0e8f95eb4a146824998d12fe26eee87f523da785:1385 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `vips` where `enable` = 1430μsview::e8dc18be7caa64c295aaaa865932c4897d99d905:91chi_bonus

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. view::e8dc18be7caa64c295aaaa865932c4897d99d905:91 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 18. /vendor/laravel/framework/src/Illuminate/View/View.php:139 19. /vendor/laravel/framework/src/Illuminate/View/View.php:122

_token: fgRzZ6P89tHYDgr2mggSh3Fmywf6NU01fdlLyrAk
_previous: array:1 [ "url" => "https://202-rd.paybonus.tw/store/163" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/store/163

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "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"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "host" => array:1 [▶
    0 => "202-rd.paybonus.tw"
  ]
]

request_server

  0 of 0   
array:64 [▼
  "REDIRECT_UNIQUE_ID" => "Z_YOXHwytsooDYmwJOgyqQAAVgQ"
  "REDIRECT_SCRIPT_URL" => "/store/163"
  "REDIRECT_SCRIPT_URI" => "https://202-rd.paybonus.tw/store/163"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "202-rd.paybonus.tw"
  "REDIRECT_HTTP2" => "on"
  "REDIRECT_H2PUSH" => "off"
  "REDIRECT_H2_PUSH" => "off"
  "REDIRECT_H2_PUSHED" => ""
  "REDIRECT_H2_PUSHED_ON" => ""
  "REDIRECT_H2_STREAM_ID" => "1"
  "REDIRECT_H2_STREAM_TAG" => "9194-714-1"
  "REDIRECT_STATUS" => "200"
  "UNIQUE_ID" => "Z_YOXHwytsooDYmwJOgyqQAAVgQ"
  "SCRIPT_URL" => "/store/163"
  "SCRIPT_URI" => "https://202-rd.paybonus.tw/store/163"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "202-rd.paybonus.tw"
  "HTTP2" => "on"
  "H2PUSH" => "off"
  "H2_PUSH" => "off"
  "H2_PUSHED" => ""
  "H2_PUSHED_ON" => ""
  "H2_STREAM_ID" => "1"
  "H2_STREAM_TAG" => "9194-714-1"
  "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"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_HOST" => "202-rd.paybonus.tw"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache/2.4.62 (codeit) OpenSSL/3.0.9+quic mod_fcgid/2.3.9 PHP/7.4.33"
  "SERVER_NAME" => "202-rd.paybonus.tw"
  "SERVER_ADDR" => "192.168.114.202"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "192.168.114.194"
  "DOCUMENT_ROOT" => "/home/htdocs/projects/PayBonus/htdocs/bonus/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/home/htdocs/projects/PayBonus/htdocs/bonus/public"
  "SERVER_ADMIN" => "root@localhost"
  "SCRIPT_FILENAME" => "/home/htdocs/projects/PayBonus/htdocs/bonus/public/index.php"
  "REMOTE_PORT" => "43604"
  "REDIRECT_URL" => "/store/163"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/store/163"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744178780.7919
  "REQUEST_TIME" => 1744178780
]

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 06:06:20 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkM5TndlWTh5aEdlbnBpWXBOckowenc9PSIsInZhbHVlIjoiR0ZzZHpacFVlZGZNSVdMMWQ3WUpTak1jeUsxQmRVb0IxNmFxaVZrUzFWcjlFRFBJNytXUG9UOU1qVmYwMTZkaFZhbXRpNVVidkl2TVNEdS9TeklMVGxOeUZqVk1CT0U5UWNqaHd4YklDN0luTERpZ3FzS2xBWURaUnYweVlPU3AiLCJtYWMiOiI2N2Y0NDgzMTU3ODhlNWJjOTFiNjg2ZTU5MGM2Yjg1NDU1MjNhMjdiYWUzNzUzYTE0OTljMDQ4NTA3ZjJkNTVhIn0%3D; expires=Wed, 09-Apr-2025 08:06:20 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkM5TndlWTh5aEdlbnBpWXBOckowenc9PSIsInZhbHVlIjoiR0ZzZHpacFVlZGZNSVdMMWQ3WUpTak1jeUsxQmRVb0IxNmFxaVZrUzFWcjlFRFBJNytXUG9UOU1qVmYwMTZkaFZhbXRpN ▶"
    1 => "esgpb_session=eyJpdiI6InRXZ1AxRkZYdStCYjdYYXZBclBtSXc9PSIsInZhbHVlIjoib00wM3k5ZzlOS2YxN3BwZThnQzg4Y1FaRVRZS3U4Vzd0RzBROVhldlh5T2lmTTlPNGRxV0xuM2RuaVdWUmY4S3d1ckc1UGpmSzBkUmErRU5ScUp0MFhuZUVNMHY4alBRNE1hNFVIeEdRMGdBMjU0ZlhxbXpVZDlUZGZVdGlkVk8iLCJtYWMiOiJjNzE4NjhkMjJjYmYzNDNmMTY3MmNlZjEzMjAyNDA2ZjJmN2M4ODkyODU0ZDAyMWU0NzQzMTVjYWE0MzZlMDlmIn0%3D; path=/; httponly ◀esgpb_session=eyJpdiI6InRXZ1AxRkZYdStCYjdYYXZBclBtSXc9PSIsInZhbHVlIjoib00wM3k5ZzlOS2YxN3BwZThnQzg4Y1FaRVRZS3U4Vzd0RzBROVhldlh5T2lmTTlPNGRxV0xuM2RuaVdWUmY4S3d1ck ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkM5TndlWTh5aEdlbnBpWXBOckowenc9PSIsInZhbHVlIjoiR0ZzZHpacFVlZGZNSVdMMWQ3WUpTak1jeUsxQmRVb0IxNmFxaVZrUzFWcjlFRFBJNytXUG9UOU1qVmYwMTZkaFZhbXRpNVVidkl2TVNEdS9TeklMVGxOeUZqVk1CT0U5UWNqaHd4YklDN0luTERpZ3FzS2xBWURaUnYweVlPU3AiLCJtYWMiOiI2N2Y0NDgzMTU3ODhlNWJjOTFiNjg2ZTU5MGM2Yjg1NDU1MjNhMjdiYWUzNzUzYTE0OTljMDQ4NTA3ZjJkNTVhIn0%3D; expires=Wed, 09-Apr-2025 08:06:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkM5TndlWTh5aEdlbnBpWXBOckowenc9PSIsInZhbHVlIjoiR0ZzZHpacFVlZGZNSVdMMWQ3WUpTak1jeUsxQmRVb0IxNmFxaVZrUzFWcjlFRFBJNytXUG9UOU1qVmYwMTZkaFZhbXRpN ▶"
    1 => "esgpb_session=eyJpdiI6InRXZ1AxRkZYdStCYjdYYXZBclBtSXc9PSIsInZhbHVlIjoib00wM3k5ZzlOS2YxN3BwZThnQzg4Y1FaRVRZS3U4Vzd0RzBROVhldlh5T2lmTTlPNGRxV0xuM2RuaVdWUmY4S3d1ckc1UGpmSzBkUmErRU5ScUp0MFhuZUVNMHY4alBRNE1hNFVIeEdRMGdBMjU0ZlhxbXpVZDlUZGZVdGlkVk8iLCJtYWMiOiJjNzE4NjhkMjJjYmYzNDNmMTY3MmNlZjEzMjAyNDA2ZjJmN2M4ODkyODU0ZDAyMWU0NzQzMTVjYWE0MzZlMDlmIn0%3D; path=/; httponly ◀esgpb_session=eyJpdiI6InRXZ1AxRkZYdStCYjdYYXZBclBtSXc9PSIsInZhbHVlIjoib00wM3k5ZzlOS2YxN3BwZThnQzg4Y1FaRVRZS3U4Vzd0RzBROVhldlh5T2lmTTlPNGRxV0xuM2RuaVdWUmY4S3d1ck ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "fgRzZ6P89tHYDgr2mggSh3Fmywf6NU01fdlLyrAk"
  "_previous" => array:1 [▶
    "url" => "https://202-rd.paybonus.tw/store/163"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (77.1%)	111.16ms
1 x Booting (22.81%)	32.88ms