Square Jaw Surgery|MISOODA

Messages Timeline Exceptions Views10 Route Queries32 Models62 Mails Auth Gate Session Request

7.2.34226ms9MBGET m/{lang}/promotion/{clinic}/{slug}

Booting (61.81ms)
Application (164ms)
1 x Application (72.54%)
163.79ms
1 x Booting (27.38%)
61.81ms

10 templates were rendered

mobile.promotion.detail (resources/views/mobile/promotion/detail.blade.php)11blade
Params
0
ac
1
conf
2
langs
3
data
4
wished
5
liked
6
reviews
7
qa
8
pageTitle
9
pageDesc
10
pageImage

Params
0	`ac`
1	`conf`
2	`langs`
3	`data`
4	`wished`
5	`liked`
6	`reviews`
7	`qa`
8	`pageTitle`
9	`pageDesc`
10	`pageImage`

partials.shortcode.mobile.review_list (resources/views/partials/shortcode/mobile/review_list.blade.php)44blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
promotion_id
limit
clinic_id
doctor_id
type
cat
category_id
list
rMenuType
showCats
cats
showBest
showAll

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`promotion_id`
32	`limit`
33	`clinic_id`
34	`doctor_id`
35	`type`
36	`cat`
37	`category_id`
38	`list`
39	`rMenuType`
40	`showCats`
41	`cats`
42	`showBest`
43	`showAll`

partials.shortcode.mobile.promotion_list (resources/views/partials/shortcode/mobile/promotion_list.blade.php)40blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
title
category_id
limit
not_id
clinic_id
cat
type
list
totalPromotion

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`title`
32	`category_id`
33	`limit`
34	`not_id`
35	`clinic_id`
36	`cat`
37	`type`
38	`list`
39	`totalPromotion`

layouts.mobile_layout (resources/views/layouts/mobile_layout.blade.php)34blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`

partials.mobile.header-meta (resources/views/partials/mobile/header-meta.blade.php)35blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`

partials.mobile.header-plain (resources/views/partials/mobile/header-plain.blade.php)39blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk
request
isWebView
userData
params

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`
35	`request`
36	`isWebView`
37	`userData`
38	`params`

partials.mobile.messages (resources/views/partials/mobile/messages.blade.php)39blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk
request
isWebView
userData
params

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`
35	`request`
36	`isWebView`
37	`userData`
38	`params`

partials.mobile.footer-promotion (resources/views/partials/mobile/footer-promotion.blade.php)40blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk
request
isWebView
userData
params
promotionId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`
35	`request`
36	`isWebView`
37	`userData`
38	`params`
39	`promotionId`

partials.mobile.modal.login (resources/views/partials/mobile/modal/login.blade.php)39blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk
request
isWebView
userData
params

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`
35	`request`
36	`isWebView`
37	`userData`
38	`params`

partials.mobile.footer-meta (resources/views/partials/mobile/footer-meta.blade.php)39blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
wished
liked
reviews
qa
pageTitle
pageDesc
pageImage
rCount
r1_count
r2_count
r3_count
r4_count
r5_count
rTotal
r
total
rAvg
surl
rating
i
percent
header
footer
footerParams
tawk
request
isWebView
userData
params

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`wished`
11	`liked`
12	`reviews`
13	`qa`
14	`pageTitle`
15	`pageDesc`
16	`pageImage`
17	`rCount`
18	`r1_count`
19	`r2_count`
20	`r3_count`
21	`r4_count`
22	`r5_count`
23	`rTotal`
24	`r`
25	`total`
26	`rAvg`
27	`surl`
28	`rating`
29	`i`
30	`percent`
31	`header`
32	`footer`
33	`footerParams`
34	`tawk`
35	`request`
36	`isWebView`
37	`userData`
38	`params`

uri: GET m/{lang}/promotion/{clinic}/{slug}
middleware: web, redirect.topc, lang
controller: App\Http\Controllers\Mobile\PromotionController@show
namespace: App\Http\Controllers\Mobile
prefix: m/{lang}
where
file: app/Http/Controllers/Mobile/PromotionController.php:77-168

32 statements were executed50.25ms

select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'zh-CN'

14.9ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev

Metadata
Bindings	0. zh-CN
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	13. /app/Http/Controllers/FrontendController.php:33 14. /app/Http/Controllers/Mobile/PromotionController.php:19 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:667 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:615

select * from `mi_language` order by `id` desc420μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev

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	14. /app/Http/Controllers/Shared/TransController.php:38 15. /app/Http/Controllers/Shared/TransController.php:20 16. /app/Http/Controllers/FrontendController.php:39 17. /app/Http/Controllers/Mobile/PromotionController.php:19 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 order by `id` desc410μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Shared/TransController.php:45 15. /app/Http/Controllers/Shared/TransController.php:21 16. /app/Http/Controllers/FrontendController.php:39 17. /app/Http/Controllers/Mobile/PromotionController.php:19 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 and `code` = 'zh-CN' limit 11.19msmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. zh-CN
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. middleware::lang:27 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 18. middleware::redirect.topc:25 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select `mi_promotion`.`id`, `mi_promotion`.`slug`, `mi_promotion`.`category_id`, `mi_promotion`.`clinic_id`, `mi_promotion`.`user_id`, `mi_promotion`.`doctor_id`, IFNULL(`mi_pt`.`title`, `mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`price_pre`, `mi_promotion`.`price_pre`) AS `price_pre`, IFNULL(`mi_pt`.`price_after`, `mi_promotion`.`price_after`) AS `price_after`, IFNULL(`mi_pt`.`price_prepaid`, `mi_promotion`.`price_prepaid`) AS `price_prepaid`, IFNULL(`mi_pt`.`price_clinicpaid`, `mi_promotion`.`price_clinicpaid`) AS `price_clinicpaid`, IFNULL(`mi_pt`.`discount`, `mi_promotion`.`discount`) AS `discount`, IFNULL(`mi_pt`.`description`, `mi_promotion`.`description`) AS `description`, `mi_promotion`.`hit`, `mi_promotion`.`like_hit`, `mi_promotion`.`share_hit`, `mi_promotion`.`comment_hit`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`caution_before`, `mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`, `mi_promotion`.`caution_after`) AS `caution_after`, `mi_promotion`.`date_start`, `mi_promotion`.`date_end`, `mi_promotion`.`book_limit`, IFNULL(`mi_pt`.`meta_title`, `mi_promotion`.`meta_title`) AS `meta_title`, IFNULL(`mi_pt`.`meta_desc`, `mi_promotion`.`meta_desc`) AS `meta_desc`, COUNT(mi_or.id) AS book_count, AVG(rating_01 + rating_02 + rating_03 + rating_04 + rating_05) AS rating from `mi_promotion` left join `mi_review` as `mi_rv` on `mi_rv`.`promotion_id` = `mi_promotion`.`id` left join `mi_order` as `mi_or` on `mi_or`.`parent_id` = `mi_promotion`.`id` and `parent_type` = 'promotion' left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'zh-CN' where `mi_promotion`.`slug` = 'square-jaw-surgery' group by `mi_promotion`.`id` limit 1

1.79ms/app/Http/Controllers/Mobile/PromotionController.php:121lv_misooda_dev

Metadata
Bindings	0. promotion 1. zh-CN 2. square-jaw-surgery
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Http/Controllers/Mobile/PromotionController.php:121 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_clinic` where `mi_clinic`.`id` = 18 limit 1520μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 18
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	18. /app/Model/Base/BaseModel.php:236 20. /app/Http/Controllers/Mobile/PromotionController.php:123 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_review` where `promotion_id` = 195730μs/app/Http/Controllers/Mobile/PromotionController.php:154lv_misooda_dev

Metadata
Bindings	0. 195
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Mobile/PromotionController.php:154 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `mi_promotion_qa`.*, `mi_user`.`username` as `username` from `mi_promotion_qa` left join `mi_user` on `mi_user`.`id` = `mi_promotion_qa`.`user_id` where `promotion_id` = 195

2.7ms/app/Http/Controllers/Mobile/PromotionController.php:160lv_misooda_dev

Metadata
Bindings	0. 195
Backtrace	14. /app/Http/Controllers/Mobile/PromotionController.php:160 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, IFNULL(`mi_rt`.`rating_01`, `mi_review`.`rating_01`) AS `rating_01`, IFNULL(`mi_rt`.`rating_02`, `mi_review`.`rating_02`) AS `rating_02`, IFNULL(`mi_rt`.`rating_03`, `mi_review`.`rating_03`) AS `rating_03`, IFNULL(`mi_rt`.`rating_04`, `mi_review`.`rating_04`) AS `rating_04`, IFNULL(`mi_rt`.`rating_05`, `mi_review`.`rating_05`) AS `rating_05`, `mi_img1`.`path` as `before_path`, `mi_c`.`id` as `clinic_id`, `mi_c`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`, `mi_c`.`name`) AS `clinic_name`, `mi_user`.`id` as `user_id`, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`country`, `mi_user`.`profile_image`, `mi_category`.`id` as `cat_id`, IFNULL(`mi_cat_t`.`title`, `mi_category`.`title`) AS `cat_name` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'zh-CN' inner join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_c`.`id` and `mi_ct`.`lang_id` = 'zh-CN' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` inner join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_cat_t` on `mi_cat_t`.`cat_id` = `mi_category`.`id` and `mi_cat_t`.`lang_id` = 'zh-CN' where `mi_review`.`promotion_id` = 195 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 5

8.23ms/app/Composers/ReviewComposer.php:208lv_misooda_dev

Metadata
Bindings	0. before 1. zh-CN 2. zh-CN 3. zh-CN 4. 195
Backtrace	14. /app/Composers/ReviewComposer.php:208 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `review_id` = 359 and `flag` = 'after' limit 7570μs/app/Composers/ReviewComposer.php:215lv_misooda_dev

Metadata
Bindings	0. 359 1. after
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	14. /app/Composers/ReviewComposer.php:215 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `review_id` = 426 and `flag` = 'after' limit 7570μs/app/Composers/ReviewComposer.php:215lv_misooda_dev

Metadata
Bindings	0. 426 1. after
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	14. /app/Composers/ReviewComposer.php:215 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `review_id` = 374 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:215lv_misooda_dev

Metadata
Bindings	0. 374 1. after
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	14. /app/Composers/ReviewComposer.php:215 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `review_id` = 373 and `flag` = 'after' limit 7380μs/app/Composers/ReviewComposer.php:215lv_misooda_dev

Metadata
Bindings	0. 373 1. after
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	14. /app/Composers/ReviewComposer.php:215 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `review_id` = 372 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:215lv_misooda_dev

Metadata
Bindings	0. 372 1. after
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	14. /app/Composers/ReviewComposer.php:215 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'zh-CN' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

720μs/app/Composers/ReviewComposer.php:232lv_misooda_dev

Metadata
Bindings	0. zh-CN 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Composers/ReviewComposer.php:232 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:311

select * from `mi_images_review` where `mi_images_review`.`review_id` = 359 and `mi_images_review`.`review_id` is not null

2.05ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 359
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::partials.shortcode.mobile.review_list:22 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 3593.72ms/app/Model/Review.php:75lv_misooda_dev

Metadata
Bindings	0. review 1. 0 2. 359
Backtrace	15. /app/Model/Review.php:75 16. view::partials.shortcode.mobile.review_list:44 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 359 and `mi_comments_review`.`post_id` is not null

630μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Bindings	0. 359
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. view::partials.shortcode.mobile.review_list:44 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_review` where `mi_images_review`.`review_id` = 426 and `mi_images_review`.`review_id` is not null

1.57ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 426
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::partials.shortcode.mobile.review_list:22 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 426520μs/app/Model/Review.php:75lv_misooda_dev

Metadata
Bindings	0. review 1. 0 2. 426
Backtrace	15. /app/Model/Review.php:75 16. view::partials.shortcode.mobile.review_list:44 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 426 and `mi_comments_review`.`post_id` is not null

2.71ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Bindings	0. 426
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. view::partials.shortcode.mobile.review_list:44 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_review` where `mi_images_review`.`review_id` = 374 and `mi_images_review`.`review_id` is not null

500μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 374
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::partials.shortcode.mobile.review_list:22 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 374430μs/app/Model/Review.php:75lv_misooda_dev

Metadata
Bindings	0. review 1. 0 2. 374
Backtrace	15. /app/Model/Review.php:75 16. view::partials.shortcode.mobile.review_list:44 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 374 and `mi_comments_review`.`post_id` is not null

360μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Bindings	0. 374
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. view::partials.shortcode.mobile.review_list:44 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_review` where `mi_images_review`.`review_id` = 373 and `mi_images_review`.`review_id` is not null

370μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 373
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::partials.shortcode.mobile.review_list:22 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 373410μs/app/Model/Review.php:75lv_misooda_dev

Metadata
Bindings	0. review 1. 0 2. 373
Backtrace	15. /app/Model/Review.php:75 16. view::partials.shortcode.mobile.review_list:44 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 373 and `mi_comments_review`.`post_id` is not null

360μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Bindings	0. 373
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. view::partials.shortcode.mobile.review_list:44 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_review` where `mi_images_review`.`review_id` = 372 and `mi_images_review`.`review_id` is not null

380μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 372
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::partials.shortcode.mobile.review_list:22 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 372410μs/app/Model/Review.php:75lv_misooda_dev

Metadata
Bindings	0. review 1. 0 2. 372
Backtrace	15. /app/Model/Review.php:75 16. view::partials.shortcode.mobile.review_list:44 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 372 and `mi_comments_review`.`post_id` is not null

370μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Bindings	0. 372
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. view::partials.shortcode.mobile.review_list:44 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select `mi_promotion`.*, IFNULL(`mi_pt`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`title`,`mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`description`,`mi_promotion`.`description`) AS `description`, IFNULL(`mi_pt`.`caution_before`,`mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`,`mi_promotion`.`caution_after`) AS `caution_after`, `mi_clinic`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `clinic_name` from `mi_promotion` left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'zh-CN' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'zh-CN' where `mi_promotion`.`category_id` = 48 and `mi_promotion`.`id` <> 195 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 5

1.19ms/app/Composers/PromotionComposer.php:171lv_misooda_dev

Metadata
Bindings	0. zh-CN 1. zh-CN 2. 48 3. 195
Backtrace	14. /app/Composers/PromotionComposer.php:171 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::mobile.promotion.detail:428

select count(*) as aggregate from `mi_promotion`300μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/Composers/PromotionComposer.php:173 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90

App\Model\Category: 11
App\Model\ImagesReview: 15
App\Model\Review: 11
App\Model\Clinic: 1
App\Model\Promotion: 6
App\Model\Language: 18

web: null
api: null

_token: gyglvoK2j3QBSEYVFMwWBO50H0ZYrgTeofLlrBoR
PHPDEBUGBAR_STACK_DATA: []

path_info

/m/zh-CN/promotion/cinderella-plastic-surgery/square-jaw-surgery

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:10 [▶
  "host" => array:1 [▶
    0 => "dev.misooda.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-79fjh (squid/6.10)"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.37.190"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
]

request_server

  0 of 0   
array:35 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_PRAGMA" => "no-cache"
  "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_ACCEPT_ENCODING" => "gzip, deflate"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-79fjh (squid/6.10)"
  "HTTP_X_FORWARDED_FOR" => "10.1.37.190"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)"
  "SERVER_NAME" => "dev.misooda.com"
  "SERVER_ADDR" => "139.59.109.168"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "216.73.216.190"
  "DOCUMENT_ROOT" => "/var/www/dev/html"
  "REQUEST_SCHEME" => "http"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/dev/html"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/dev/html/index.php"
  "REMOTE_PORT" => "37685"
  "REDIRECT_URL" => "/m/zh-CN/promotion/cinderella-plastic-surgery/square-jaw-surgery"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/m/zh-CN/promotion/cinderella-plastic-surgery/square-jaw-surgery"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1753633415.991
  "REQUEST_TIME" => 1753633415
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 27 Jul 2025 16:23:36 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InByZU9BcGtIdVZpS2p2VWI5NXhUXC9nPT0iLCJ2YWx1ZSI6IjIwYVBYVnNNS1dubG1wRFNaVzVRS2s3NDVJQ1FnQkJOeTFncElOT21XbUgyekd5am1rZ2V4WitLSzcxSHFrVGUiLCJtYWMiOiI5M2EwZjU4OTY1M2E1NmJkZWRkYjY3NTQ2YTI5MTc5MTdiMWMyYjZlZGQwZWJiNDExZDg1ZjM3MjRmNGZiMTRmIn0%3D; expires=Sun, 27-Jul-2025 18:23:36 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InByZU9BcGtIdVZpS2p2VWI5NXhUXC9nPT0iLCJ2YWx1ZSI6IjIwYVBYVnNNS1dubG1wRFNaVzVRS2s3NDVJQ1FnQkJOeTFncElOT21XbUgyekd5am1rZ2V4WitLSzcxSHFrVGUiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InByZU9BcGtIdVZpS2p2VWI5NXhUXC9nPT0iLCJ2YWx1ZSI6IjIwYVBYVnNNS1dubG1wRFNaVzVRS2s3NDVJQ1FnQkJOeTFncElOT21XbUgyekd5am1rZ2V4WitLSzcxSHFrVGUiLCJtYWMiOiI5M2EwZjU4OTY1M2E1NmJkZWRkYjY3NTQ2YTI5MTc5MTdiMWMyYjZlZGQwZWJiNDExZDg1ZjM3MjRmNGZiMTRmIn0%3D; expires=Sun, 27-Jul-2025 18:23:36 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InByZU9BcGtIdVZpS2p2VWI5NXhUXC9nPT0iLCJ2YWx1ZSI6IjIwYVBYVnNNS1dubG1wRFNaVzVRS2s3NDVJQ1FnQkJOeTFncElOT21XbUgyekd5am1rZ2V4WitLSzcxSHFrVGUiLCJtY ▶"
  ]
]

session_attributes

  0 of 0   
array:2 [▶
  "_token" => "gyglvoK2j3QBSEYVFMwWBO50H0ZYrgTeofLlrBoR"
  "PHPDEBUGBAR_STACK_DATA" => []
]

面部轮廓

...

0 Likes · Comment 0

点赞 Comment

Hi, my name is Wiwat and I work in the broadcast field in Thailand. Before getting my surgery done, my biggest complex was my facial structure. My fac...

I’ve heard from many people that my eyes, nose and lips are pretty but I received a lot of stress because of the shape of my face. Because of that, I ...

鼻部

Rhinoplasty & Double Eyelid Revision Surgery

Now a days everybody does plastic surgery so I don’t see a reason why I should hide mine! This is why I have decided to write a review for the surgeri...

双鄂手术

方鄂整形术

手术前的注意事项

手术后的注意事项

Related Promotion

Dual Fix Malar Reduction

必妩整形外科：方鄂复位术

V-线手术（不涉及骨科手术）

4重面部雕刻

颧骨整形术

1 x Application (72.54%)	163.79ms
1 x Booting (27.38%)	61.81ms