View Plastic Surgery, Reviews, Images, Promotions

Địa chỉ :

Mức độ hài lòng :

Lĩnh vực chuyên môn : Môi Xương mặt Hút mỡ Mũi Mắt Ngực Mặt chảy xệ Cằm đôi Cấy mỡ Da Cấy tóc Toxin Toxin

Chat Now

tư vấn

Lời bình được ưa thích

z_ooa

View Plastic Surgery
Denny

View Plastic Surgery
Denny

View Plastic Surgery
hellobeauty21

View Plastic Surgery
ysw11

View Plastic Surgery
kystal24

View Plastic Surgery
yjk44

View Plastic Surgery
phk14

View Plastic Surgery
jhl98

View Plastic Surgery
jsl21

View Plastic Surgery
ljy91

View Plastic Surgery
ysh26

View Plastic Surgery
ysae12

View Plastic Surgery
yjy5

View Plastic Surgery
sb_p2

View Plastic Surgery
0miy

View Plastic Surgery
jiyik

View Plastic Surgery
jwpe

View Plastic Surgery
scs74

View Plastic Surgery
jjh_h

View Plastic Surgery
jay_k4

View Plastic Surgery
es_g14

View Plastic Surgery
ari0_0

View Plastic Surgery
mlk

View Plastic Surgery
ysp96

View Plastic Surgery
jhc174

View Plastic Surgery
jmk321

View Plastic Surgery
gnc412

View Plastic Surgery
ean77

View Plastic Surgery
eg_kk

View Plastic Surgery
cha12

View Plastic Surgery
hange04

View Plastic Surgery
heony

View Plastic Surgery
jhee

View Plastic Surgery
krang

View Plastic Surgery
sea_p

View Plastic Surgery
eun_be

View Plastic Surgery
ja_k21

View Plastic Surgery

Messages Timeline Exceptions Views12 Route Queries51 Models122 Mails Auth Gate Session Request

7.2.34115ms9MBGET {lang}/clinic/{slug}/reviews/{cat?}

Booting (22.98ms)
Application (92.25ms)
1 x Application (79.94%)
92.25ms
1 x Booting (19.92%)
22.98ms

12 templates were rendered

frontend.clinic.reviews (resources/views/frontend/clinic/reviews.blade.php)16blade


ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage

partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)22blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
clinic_ac
10
data
11
cats
12
cat
13
category
14
tomImages
15
rating
16
reviewCount
17
promotionCount
18
followed
19
pageTitle
20
pageDesc
21
pageImage

Params
0	`ac`
1	`conf`
2	`langs`
3	`clinic_ac`
4	`data`
5	`cats`
6	`cat`
7	`category`
8	`tomImages`
9	`rating`
10	`reviewCount`
11	`promotionCount`
12	`followed`
13	`pageTitle`
14	`pageDesc`
15	`pageImage`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`

partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)34blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
clinic_id
showBest
showAll
url
limit
promotion_id
doctor_id
type
category_id
list
rMenuType
showCats

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`clinic_id`
23	`showBest`
24	`showAll`
25	`url`
26	`limit`
27	`promotion_id`
28	`doctor_id`
29	`type`
30	`category_id`
31	`list`
32	`rMenuType`
33	`showCats`

layouts.frontend (resources/views/layouts/frontend.blade.php)23blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`

partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)23blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`

partials.frontend.header2 (resources/views/partials/frontend/header2.blade.php)23blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`

partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`

partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer
group
showImg
limit
list
showTitle
showExcerpt

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`
24	`group`
25	`showImg`
26	`limit`
27	`list`
28	`showTitle`
29	`showExcerpt`

partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`

partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`

partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`

partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`header`
23	`footer`

uri: GET {lang}/clinic/{slug}/reviews/{cat?}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\ClinicController@reviews
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/ClinicController.php:195-205

51 statements were executed33.31ms

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` = 'vi'

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

Metadata
Bindings	0. vi
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/Frontend/ClinicController.php:24 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` desc650μ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/Frontend/ClinicController.php:24 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 order by `id` desc570μ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/Frontend/ClinicController.php:24 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 and `code` = 'vi' limit 1590μsmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. vi
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::bindings:41 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select `mi_clinic`.*, `mi_tr`.`name`, `mi_tr`.`address`, `mi_tr`.`description`, `mi_tr`.`business_time`, `mi_tr`.`business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_tr` on `mi_tr`.`clinic_id` = `mi_clinic`.`id` where `mi_tr`.`lang_id` = 'vi' and `slug` = 'view-plastic-surgery' limit 1

1.09ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev

Metadata
Bindings	0. vi 1. view-plastic-surgery
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:358 16. /app/Http/Controllers/Frontend/ClinicController.php:197 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

select `mi_cat`.*, `mi_tr`.`title` from `mi_clinic_category` left join `mi_category` as `mi_cat` on `mi_cat`.`id` = `mi_clinic_category`.`category_id` left join `mi_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_cat`.`id` where `mi_clinic_category`.`clinic_id` = 58 and `mi_tr`.`lang_id` = 'vi'

1.02ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev

Metadata
Bindings	0. 58 1. vi
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:371 15. /app/Http/Controllers/Frontend/ClinicController.php:197 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_cl_image_gr` where `code` = 'top-image' limit 1520μs/app/Http/Controllers/Frontend/ClinicController.php:387lv_misooda_dev

Metadata
Bindings	0. top-image
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/Frontend/ClinicController.php:387 16. /app/Http/Controllers/Frontend/ClinicController.php:197 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

select * from `mi_cl_image` where `clinic_id` = 58 and `group_id` = 2680μs/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev

Metadata
Bindings	0. 58 1. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:392 15. /app/Http/Controllers/Frontend/ClinicController.php:197 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select COUNT(id) AS review_count, AVG(rating_01) AS rating_01, AVG(rating_02) AS rating_02, AVG(rating_03) AS rating_03, AVG(rating_04) AS rating_04, AVG(rating_05) AS rating_05 from `mi_review` where `clinic_id` = 58 group by `clinic_id` limit 1

710μs/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev

Metadata
Bindings	0. 58
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:405 16. /app/Http/Controllers/Frontend/ClinicController.php:197 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

select count(*) as aggregate from `mi_promotion` where `clinic_id` = 58600μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev

Metadata
Bindings	0. 58
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:415 16. /app/Http/Controllers/Frontend/ClinicController.php:197 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

select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, 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_img2`.`path` as `after_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_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'vi' 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` = 'vi' 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` = 'vi' where `mi_review`.`clinic_id` = 58 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 100

4.81ms/app/Composers/ReviewComposer.php:97lv_misooda_dev

Metadata
Bindings	0. before 1. after 2. vi 3. vi 4. vi 5. 58
Backtrace	14. /app/Composers/ReviewComposer.php:97 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 437 and `flag` = 'after' limit 7730μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 437 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 411 and `flag` = 'after' limit 7560μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 411 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 410 and `flag` = 'after' limit 7540μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 410 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 375 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 375 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 329 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 329 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 328 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 328 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 327 and `flag` = 'after' limit 7460μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 327 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 326 and `flag` = 'after' limit 7450μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 326 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 325 and `flag` = 'after' limit 7440μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 325 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 324 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 324 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 323 and `flag` = 'after' limit 7450μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 323 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 322 and `flag` = 'after' limit 7630μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 322 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 321 and `flag` = 'after' limit 7440μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 321 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 319 and `flag` = 'after' limit 7620μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 319 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 318 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 318 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:104 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::frontend.clinic.reviews:21

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

Metadata
Bindings	0. 317 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 316 and `flag` = 'after' limit 7350μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 316 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 315 and `flag` = 'after' limit 7400μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 315 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 314 and `flag` = 'after' limit 7360μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 314 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 313 and `flag` = 'after' limit 7340μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 313 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 312 and `flag` = 'after' limit 7460μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 312 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 311 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 311 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 310 and `flag` = 'after' limit 7510μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 310 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 309 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 309 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 308 and `flag` = 'after' limit 7510μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 308 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 307 and `flag` = 'after' limit 7510μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 307 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 306 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 306 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 305 and `flag` = 'after' limit 7490μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 305 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 304 and `flag` = 'after' limit 7520μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 304 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 303 and `flag` = 'after' limit 7490μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 303 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 302 and `flag` = 'after' limit 7500μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 302 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 301 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 301 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 298 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 298 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 297 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 297 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:104 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::frontend.clinic.reviews:21

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

Metadata
Bindings	0. 296 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 295 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 295 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 294 and `flag` = 'after' limit 7440μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 294 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:104 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::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 292 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 292 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:104 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::frontend.clinic.reviews:21

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` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

940μs/app/Composers/ReviewComposer.php:121lv_misooda_dev

Metadata
Bindings	0. vi 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Composers/ReviewComposer.php:121 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::frontend.clinic.reviews:21

select `mi_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'vi' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

1.1ms/app/Composers/BannerComposer.php:20lv_misooda_dev

Metadata
Bindings	0. vi 1. banner-footer-dark
Backtrace	14. /app/Composers/BannerComposer.php:20 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::partials.frontend.footer-dark:66

App\Model\Category: 11
App\Model\ImagesReview: 38
App\Model\Review: 39
App\Model\ClinicImage: 1
App\Model\ClinicImageGroup: 1
App\Model\ClinicCategory: 13
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: hYGIiCxhydRv116NffnaFADqtxgcok6DvfQCXDvP
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://dev.misooda.com/ja/clinic/braun-plastic-surgery/promotions/lip" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/vi/clinic/view-plastic-surgery/reviews

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:9 [▶
  "host" => array:1 [▶
    0 => "dev.misooda.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => 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"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZSd1wvMWlPekxtYm5uRk1YT1JzSzBBPT0iLCJ2YWx1ZSI6IjJwenB4Z0ZDYTFCMmhyUVVPK25TOUVRcCtzeXJTUHhVaDIwdjc0dGQwMlJBU1JacE5BVlZlcWhOWllpZ3R0Z3kiLCJtYWMiOiJkODZkNGViY2ZiOWE3MTI1ZDQyNmZhMzVhNDZkOTZhOGFhMjdmNDI1ZjlkNDRhNjk3NWUzZTAxMmRhNDE1NTQ5In0%3D; _fbp=fb.1.1748145434598.515822249222791711; misooda=HvQIibFME2DUuIR16ueTCF0n2IO99Qyc0t91gUiC ◀XSRF-TOKEN=eyJpdiI6IjZSd1wvMWlPekxtYm5uRk1YT1JzSzBBPT0iLCJ2YWx1ZSI6IjJwenB4Z0ZDYTFCMmhyUVVPK25TOUVRcCtzeXJTUHhVaDIwdjc0dGQwMlJBU1JacE5BVlZlcWhOWllpZ3R0Z3kiLCJtY ▶"
  ]
]

request_server

  0 of 0   
array:34 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "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_COOKIE" => "XSRF-TOKEN=eyJpdiI6IjZSd1wvMWlPekxtYm5uRk1YT1JzSzBBPT0iLCJ2YWx1ZSI6IjJwenB4Z0ZDYTFCMmhyUVVPK25TOUVRcCtzeXJTUHhVaDIwdjc0dGQwMlJBU1JacE5BVlZlcWhOWllpZ3R0Z3kiLCJtYWMiOiJkODZkNGViY2ZiOWE3MTI1ZDQyNmZhMzVhNDZkOTZhOGFhMjdmNDI1ZjlkNDRhNjk3NWUzZTAxMmRhNDE1NTQ5In0%3D; _fbp=fb.1.1748145434598.515822249222791711; misooda=HvQIibFME2DUuIR16ueTCF0n2IO99Qyc0t91gUiC ◀XSRF-TOKEN=eyJpdiI6IjZSd1wvMWlPekxtYm5uRk1YT1JzSzBBPT0iLCJ2YWx1ZSI6IjJwenB4Z0ZDYTFCMmhyUVVPK25TOUVRcCtzeXJTUHhVaDIwdjc0dGQwMlJBU1JacE5BVlZlcWhOWllpZ3R0Z3kiLCJtY ▶"
  "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" => "18.223.124.91"
  "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" => "4532"
  "REDIRECT_URL" => "/vi/clinic/view-plastic-surgery/reviews"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/vi/clinic/view-plastic-surgery/reviews"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1748145436.456
  "REQUEST_TIME" => 1748145436
]

request_cookies

  0 of 0   
array:3 [▶
  "XSRF-TOKEN" => "hYGIiCxhydRv116NffnaFADqtxgcok6DvfQCXDvP"
  "_fbp" => null
  "misooda" => null
]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 25 May 2025 03:57:16 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikt2MlwvTzhZTlM0K21pcFwvU0ZZTVhiUT09IiwidmFsdWUiOiJOK1pWK1FlTVJFWE9IVmZ3UTc5Q2pcLzQ2bHo0VUFYMHlHMXA4ZUJWb0tUVndjSkViT3dsZHY3ZFJyNTM5Q2djZiIsIm1hYyI6ImIxNzNkNGRlYjk0ZGE2MGYxZGU3ZjNiNzllYjA3YTc0OTI2NDMwMjNkMWMwMmEwYWI4YTVlZGNlMzhkZjRkMTAifQ%3D%3D; expires=Sun, 25-May-2025 05:57:16 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikt2MlwvTzhZTlM0K21pcFwvU0ZZTVhiUT09IiwidmFsdWUiOiJOK1pWK1FlTVJFWE9IVmZ3UTc5Q2pcLzQ2bHo0VUFYMHlHMXA4ZUJWb0tUVndjSkViT3dsZHY3ZFJyNTM5Q2djZiIsI ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikt2MlwvTzhZTlM0K21pcFwvU0ZZTVhiUT09IiwidmFsdWUiOiJOK1pWK1FlTVJFWE9IVmZ3UTc5Q2pcLzQ2bHo0VUFYMHlHMXA4ZUJWb0tUVndjSkViT3dsZHY3ZFJyNTM5Q2djZiIsIm1hYyI6ImIxNzNkNGRlYjk0ZGE2MGYxZGU3ZjNiNzllYjA3YTc0OTI2NDMwMjNkMWMwMmEwYWI4YTVlZGNlMzhkZjRkMTAifQ%3D%3D; expires=Sun, 25-May-2025 05:57:16 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikt2MlwvTzhZTlM0K21pcFwvU0ZZTVhiUT09IiwidmFsdWUiOiJOK1pWK1FlTVJFWE9IVmZ3UTc5Q2pcLzQ2bHo0VUFYMHlHMXA4ZUJWb0tUVndjSkViT3dsZHY3ZFJyNTM5Q2djZiIsI ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "hYGIiCxhydRv116NffnaFADqtxgcok6DvfQCXDvP"
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/ja/clinic/braun-plastic-surgery/promotions/lip"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

1 x Application (79.94%)	92.25ms
1 x Booting (19.92%)	22.98ms