TL Plastic Surgery, Reviews, Images, Promotions

Alamat :

Kepuasan :

Spesialisasi : Mata Hidung Face lift Payudara Fat Grafting Sedot Lemak Transplan Rambut Botoks Botoks

Chat Now

Pertanyaan

Ulasan Terbaik

Polkendotts

TL Plastic Surgery
alex

TL Plastic Surgery

Promosi

Info

Penjelasan

1. Safety

2. Surgery

3. Post Surgery Care

4. Pre/Post Surgery Customer Information Management

5. Patient' Surgery Record

6. Provided Service

7. Medical Reimbursement Insurance

8. Certification

9. Language

Dokter

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 22

Jee Myung Kim

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 27

Joong Hyuk Yim

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 17

Se Woon Choi

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 22

Wung Ki Jeong

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 11

Tae Ho Yoon

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 7

Ui Geon Kim

Kotak Spesialisasi

Spesialisasi

Tahun Berpengalaman

: 10

Eun Kyung Lee

Galeri Foto

136

138

126

133

131

128

132

144

118

Selebihnya

Jam Kerja / Peta

Waktu Operasi

Jam Beroperasi

Ikuti

Lihat semua+

Gul

Pemilik dari Klinik ini?

Tambah atau perbarui informasi Anda

Informasi Salah?

Hubungi kami dan kami akan mengoreksinya

Laporkan

Messages Timeline Exceptions Views15 Route Queries26 Models120 Mails Auth Gate Session Request

7.2.34411ms10MBGET {lang}/clinic/{slug}

Booting (83.37ms)
Application (327ms)
1 x Application (79.67%)
327.47ms
1 x Booting (20.28%)
83.37ms

15 templates were rendered

frontend.clinic.show (resources/views/frontend/clinic/show.blade.php)20blade


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

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`
16	`imageGroups`
17	`images`
18	`galleryImages`
19	`questions`

partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)26blade


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

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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
limit
clinic_id
showBest
showAll
url
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`limit`
27	`clinic_id`
28	`showBest`
29	`showAll`
30	`url`
31	`promotion_id`
32	`doctor_id`
33	`type`
34	`category_id`
35	`list`
36	`rMenuType`
37	`showCats`

partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)38blade


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

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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`clinic_id`
27	`limit`
28	`showBest`
29	`showAll`
30	`url`
31	`category_id`
32	`type`
33	`not_id`
34	`list`
35	`rMenuType`
36	`showCats`
37	`showHotDeal`

partials.shortcode.doctor_list (resources/views/partials/shortcode/doctor_list.blade.php)35blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
clinic_id
limit
list

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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`clinic_id`
33	`limit`
34	`list`

partials.shortcode.follow_list (resources/views/partials/shortcode/follow_list.blade.php)41blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
post_type
post_id
limit
showTitle
url
user_id
follows

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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`post_type`
35	`post_id`
36	`limit`
37	`showTitle`
38	`url`
39	`user_id`
40	`follows`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`
36	`group`
37	`showImg`
38	`limit`
39	`list`
40	`showTitle`
41	`showExcerpt`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

uri: GET {lang}/clinic/{slug}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\ClinicController@show
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/ClinicController.php:108-192

26 statements were executed, 2 of which were duplicated, 24 unique121ms

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

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

Metadata
Bindings	0. id
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` desc1.2ms/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` desc4.89ms/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` = 'id' limit 11.01msmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. id
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` = 'id' and `slug` = 'tl-plastic-surgery' limit 1

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

Metadata
Bindings	0. id 1. tl-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:110 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` = 30 and `mi_tr`.`lang_id` = 'id'

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

Metadata
Bindings	0. 30 1. id
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:371 15. /app/Http/Controllers/Frontend/ClinicController.php:110 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 17.09ms/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:110 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` = 30 and `group_id` = 210.82ms/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev

Metadata
Bindings	0. 30 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:110 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` = 30 group by `clinic_id` limit 1

3.24ms/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev

Metadata
Bindings	0. 30
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:110 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` = 3014.29ms/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev

Metadata
Bindings	0. 30
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:415 16. /app/Http/Controllers/Frontend/ClinicController.php:110 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_cl_image_gr`.`id`, `mi_cl_image_gr`.`code`, `mi_cl_image_gr`.`order_no`, `mi_cl_image_gr`.`static`, `mi_cl_image_gr`.`created_at`, `mi_cl_image_gr`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_cl_image_gr`.`title`) as `title` from `mi_cl_image_gr` inner join `mi_cl_image` as `mi_cl_img` on `clinic_id` = 30 and `mi_cl_image_gr`.`id` = `mi_cl_img`.`group_id` left join `mi_cl_image_gr_trans` as `mi_trans` on `mi_trans`.`cl_image_gid` = `mi_cl_image_gr`.`id` and `mi_trans`.`lang_id` = 'id' where `mi_cl_image_gr`.`static` = 0 group by `mi_cl_image_gr`.`id`

9.73ms/app/Http/Controllers/Frontend/ClinicController.php:124lv_misooda_dev

Metadata
Bindings	0. 30 1. id 2. 0
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:124 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 count(*) as aggregate from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 30 and `mi_gr`.`static` = 0

7.97ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 30 1. 0
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:131 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 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `mi_cl_image`.* from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 30 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 0

1.22ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 30 1. 0
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:131 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 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select count(*) as aggregate from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'id' and `mi_gallery`.`clinic_id` = 30 group by `mi_gallery`.`id`

4.57ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev

Metadata
Bindings	0. left 1. right 2. gallery 3. id 4. 30
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:157 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 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `mi_gallery`.*, `mi_tr`.`title`, `mi_tr`.`description`, `mi_img_left`.`path` as `left_path`, `mi_img_right`.`path` as `right_path`, COUNT(mi_ul.user_id) AS like_count from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'id' and `mi_gallery`.`clinic_id` = 30 group by `mi_gallery`.`id` order by `mi_gallery`.`created_at` desc limit 20 offset 0

14.31ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev

Metadata
Bindings	0. left 1. right 2. gallery 3. id 4. 30
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:157 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 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `mi_cl_question_gr`.`id`, IFNULL(`mi_qgt`.`title`,`mi_cl_question_gr`.`title`) as `title` from `mi_cl_question_gr` left join `mi_cl_question_gr_trans` as `mi_qgt` on `mi_qgt`.`cl_q_gid` = `mi_cl_question_gr`.`id` and `mi_qgt`.`lang_id` = 'id'

7.73ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev

Metadata
Bindings	0. id
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:187 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_cl_question`.`id`, `mi_cl_question`.`group_id`, `mi_cl_question`.`order_no`, IFNULL(`mi_qt`.`question`,`mi_cl_question`.`question`) as `question`, `mi_at`.`answer` from `mi_cl_question` left join `mi_cl_question_trans` as `mi_qt` on `mi_cl_question`.`id` = `mi_qt`.`cl_q_id` and `mi_qt`.`lang_id` = 'id' left join `mi_cl_answer` as `mi_ca` on `mi_ca`.`question_id` = `mi_cl_question`.`id` left join `mi_cl_answer_trans` as `mi_at` on `mi_at`.`cl_answer_id` = `mi_ca`.`id` and `mi_at`.`lang_id` = 'id' where `mi_cl_question`.`group_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10) and `mi_ca`.`clinic_id` = 30 order by `mi_cl_question`.`order_no` asc

8.9ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev

Metadata
Bindings	0. id 1. id 2. 30
Backtrace	19. /app/Http/Controllers/Frontend/ClinicController.php:187 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /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`.`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` = 'id' 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` = 'id' 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` = 'id' where `mi_review`.`clinic_id` = 30 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 10

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

Metadata
Bindings	0. before 1. after 2. id 3. id 4. id 5. 30
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.show:222

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

Metadata
Bindings	0. 444 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.show:222

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

Metadata
Bindings	0. 264 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.show:222

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

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

Metadata
Bindings	0. id 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.show:222

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` = 'id' 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` = 'id' where `mi_promotion`.`clinic_id` = 30 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 12

1.5ms/app/Composers/PromotionComposer.php:66lv_misooda_dev

Metadata
Bindings	0. id 1. id 2. 30
Backtrace	14. /app/Composers/PromotionComposer.php:66 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.show:230

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

1.01ms/app/Composers/PromotionComposer.php:79lv_misooda_dev

Metadata
Bindings	0. id 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Composers/PromotionComposer.php:79 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.show:230

select `mi_doctor`.`id`, `mi_doctor`.`email`, `mi_doctor`.`gender`, `mi_doctor`.`board_of_specialty`, `mi_doctor`.`years_of_experiences`, `mi_doctor`.`active_clinic`, `mi_doctor`.`created_at`, `mi_doctor`.`updated_at`, `mi_doctor`.`meta_title`, `mi_doctor`.`meta_desc`, `mi_doctor`.`image`, `mi_doctor`.`cover_image`, IFNULL(`mi_trans`.`name`,`mi_doctor`.`name`) as `name`, IFNULL(`mi_trans`.`title`,`mi_doctor`.`title`) as `title`, IFNULL(`mi_trans`.`school_name`,`mi_doctor`.`school_name`) as `school_name`, IFNULL(`mi_trans`.`internship`,`mi_doctor`.`internship`) as `internship`, IFNULL(`mi_trans`.`residentship`,`mi_doctor`.`residentship`) as `residentship`, IFNULL(`mi_trans`.`academic_activity`,`mi_doctor`.`academic_activity`) as `academic_activity`, IFNULL(`mi_trans`.`awards`,`mi_doctor`.`awards`) as `awards`, IFNULL(`mi_trans`.`thesis`,`mi_doctor`.`thesis`) as `thesis`, 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`, IFNULL(`mi_cdbt`.`title`, `mi_cdb`.`title`) AS `board_specialty_title`, `mi_doc_cat`.`cat_title` as `specialty_title`, `mi_doc_cat`.`cat_percent` as `specialty_percent`, `mi_doc_cat`.`sub_title1`, `mi_doc_cat`.`sub_title2`, `mi_doc_cat`.`sub_title3` from `mi_doctor` left join `mi_doctor_trans` as `mi_trans` on `mi_trans`.`doctor_id` = `mi_doctor`.`id` and `mi_trans`.`lang_id` = 'id' left join `mi_review` on `mi_review`.`doctor_id` = `mi_doctor`.`id` left join `mi_category_doctor_board` as `mi_cdb` on `mi_cdb`.`id` = `mi_doctor`.`board_of_specialty` left join `mi_category_doctor_board_trans` as `mi_cdbt` on `mi_cdbt`.`cat_id` = `mi_cdb`.`id` and `mi_cdbt`.`lang_id` = 'id' left join (select `mi_doctor_category`.`doctor_id`, GROUP_CONCAT(IFNULL(`mi_dct`.`title`, `mi_dc`.`title`)) AS `cat_title`, GROUP_CONCAT(IFNULL(`mi_doctor_category`.`percent`, 0)) AS `cat_percent`, GROUP_CONCAT(`mi_dccs1`.`title`) AS `sub_title1`, GROUP_CONCAT(`mi_dccs2`.`title`) AS `sub_title2`, GROUP_CONCAT(`mi_dccs3`.`title`) AS `sub_title3` from `mi_doctor_category` left join `mi_dc_category` as `mi_dc` on `mi_dc`.`id` = `mi_doctor_category`.`category_id` left join `mi_dc_category_trans` as `mi_dct` on `mi_dct`.`cat_id` = `mi_dc`.`id` and `mi_dct`.`lang_id` = 'id' left join `mi_dc_category_sub` as `mi_dccs1` on `mi_dccs1`.`id` = `mi_doctor_category`.`sub_1` left join `mi_dc_category_sub` as `mi_dccs2` on `mi_dccs2`.`id` = `mi_doctor_category`.`sub_2` left join `mi_dc_category_sub` as `mi_dccs3` on `mi_dccs3`.`id` = `mi_doctor_category`.`sub_3` group by `mi_doctor_category`.`doctor_id`) as `mi_doc_cat` on `mi_doc_cat`.`doctor_id` = `mi_doctor`.`id` where `active_clinic` = 30 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 8

5.37ms/app/Composers/MainComposer.php:223lv_misooda_dev

Metadata
Bindings	0. id 1. id 2. id 3. 30
Backtrace	14. /app/Composers/MainComposer.php:223 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.show:294

select `mi_user_follow`.*, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`profile_image` from `mi_user_follow` left join `mi_user` on `mi_user`.`id` = `mi_user_follow`.`user_id` where `post_type` = 'clinic' and `post_id` = 30 order by `mi_user_follow`.`created_at` desc

1.51ms/app/Composers/MainComposer.php:264lv_misooda_dev

Metadata
Bindings	0. clinic 1. 30
Backtrace	14. /app/Composers/MainComposer.php:264 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.show:423

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` = 'id' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

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

Metadata
Bindings	0. id 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\UserFollow: 1
App\Model\Doctor: 7
App\Model\Category: 22
App\Model\ImagesReview: 1
App\Model\ClinicQuestion: 22
App\Model\ClinicQuestionGroup: 9
App\Model\Gallery: 20
App\Model\Review: 3
App\Model\ClinicImage: 5
App\Model\ClinicImageGroup: 2
App\Model\ClinicCategory: 9
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: r2atMy2vluqP6RCCWbBJupLrMG66tbDM6S8VoLZr
PHPDEBUGBAR_STACK_DATA: []

path_info

/id/clinic/tl-plastic-surgery

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:8 [▶
  "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"
  ]
]

request_server

  0 of 0   
array:33 [▶
  "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"
  "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" => "3.133.130.192"
  "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" => "57090"
  "REDIRECT_URL" => "/id/clinic/tl-plastic-surgery"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/id/clinic/tl-plastic-surgery"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1745470292.548
  "REQUEST_TIME" => 1745470292
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 24 Apr 2025 04:51:32 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlljTGpCckxEaVo5QzdJRnd1UHg0aFE9PSIsInZhbHVlIjoiQlBcL0d0RG5FOXdlQ2FaVHk0T244MTJYMHJzMUg3N2VCTFlyYzRDRlJ5RWRsZ2lsRWFLajJJeTZmb04yVzd3R1AiLCJtYWMiOiIwOWNhYmEwNTc1NDc3YWFmMDFkYmI2YTVjNDZjNWZjODgwNGZlYzZmNzg2ZTYzYzgxZDlkZGRmOWQ3NzgzZjFlIn0%3D; expires=Thu, 24-Apr-2025 06:51:32 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlljTGpCckxEaVo5QzdJRnd1UHg0aFE9PSIsInZhbHVlIjoiQlBcL0d0RG5FOXdlQ2FaVHk0T244MTJYMHJzMUg3N2VCTFlyYzRDRlJ5RWRsZ2lsRWFLajJJeTZmb04yVzd3R1AiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlljTGpCckxEaVo5QzdJRnd1UHg0aFE9PSIsInZhbHVlIjoiQlBcL0d0RG5FOXdlQ2FaVHk0T244MTJYMHJzMUg3N2VCTFlyYzRDRlJ5RWRsZ2lsRWFLajJJeTZmb04yVzd3R1AiLCJtYWMiOiIwOWNhYmEwNTc1NDc3YWFmMDFkYmI2YTVjNDZjNWZjODgwNGZlYzZmNzg2ZTYzYzgxZDlkZGRmOWQ3NzgzZjFlIn0%3D; expires=Thu, 24-Apr-2025 06:51:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlljTGpCckxEaVo5QzdJRnd1UHg0aFE9PSIsInZhbHVlIjoiQlBcL0d0RG5FOXdlQ2FaVHk0T244MTJYMHJzMUg3N2VCTFlyYzRDRlJ5RWRsZ2lsRWFLajJJeTZmb04yVzd3R1AiLCJtY ▶"
  ]
]

session_attributes

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

1 x Application (79.67%)	327.47ms
1 x Booting (20.28%)	83.37ms