Magic Kiss Dental Clinic,Reviews,Images, Promotions

Magic Kiss Dental Clinic

Address : Apgujeoung-ro, Gangnam, Seoul, South, Korea

Satisfaction :

Chat Now

Inquiry

Best Review

Promotion

Info

Description

Magic Kiss Dental Clinic is staffed with English speaking doctors and staffs who are kind and skillful.

Our team is without doubt best in Korea. Dr. Yumi Jung(Ph.D, MBA, DMD) who is a chief dentist of Magic Kiss Dental Clinic is a best dentist in cosmetic dentistry in Korea.
She is an advisory for various TV programs related to medical or dental issues. For examples, TV makeover shows - “Let Me In” (season 1, 2, 3,4 and 5) of tvN, ‘Daesenam’, ‘Beautiful You’ of TV Chosun and other programs at SBS, Sen TV, etc.
Dr. Jung is especially known to be a warm-hearted cosmetic dentis. Therefore, you will be able to experience during your visit.

▶ Top 5 reasons why you visit Magic Kiss Dental Clinic
Best Dental Team, Best Result, Best Smile Makeover, Pain free treatment, Comfort!!

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

Doctor

Image Gallery

Business Time / Map

Apgujeoung-ro, Gangnam, Seoul, South, Korea

Business Time

Sundays, national holidays

Business Hour

Weekdays 10: 00-19: 00
Tue, Thu 10: 00 ~ 9: 30
Sat 10: 00 ~ 15: 00

See all+

No Followers

Owner of this Clinic?

Add or update your information

Clinic Login

Wrong information?

Report

Messages Timeline Exceptions Views15 Route Queries23 Models61 Mails Auth Gate Session Request

7.2.34155ms9MBGET {lang}/clinic/{slug}

Booting (18.39ms)
Application (136ms)
1 x Application (88.02%)
136.13ms
1 x Booting (11.89%)
18.39ms

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)34blade


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
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	`clinic_id`
32	`limit`
33	`list`

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


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
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	`gr`
32	`img`
33	`post_type`
34	`post_id`
35	`limit`
36	`showTitle`
37	`url`
38	`user_id`
39	`follows`

layouts.frontend (resources/views/layouts/frontend.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
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
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	`gr`
32	`img`
33	`header`

partials.frontend.header-meta (resources/views/partials/frontend/header-meta.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
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
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	`gr`
32	`img`
33	`header`

partials.frontend.header2 (resources/views/partials/frontend/header2.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
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
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	`gr`
32	`img`
33	`header`

partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.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
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	`gr`
32	`img`
33	`header`
34	`footer`

partials.shortcode.banner_list (resources/views/partials/shortcode/banner_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
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	`gr`
32	`img`
33	`header`
34	`footer`
35	`group`
36	`showImg`
37	`limit`
38	`list`
39	`showTitle`
40	`showExcerpt`

partials.frontend.footer-meta (resources/views/partials/frontend/footer-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
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	`gr`
32	`img`
33	`header`
34	`footer`

partials.frontend.login-modal (resources/views/partials/frontend/login-modal.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
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	`gr`
32	`img`
33	`header`
34	`footer`

partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.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
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	`gr`
32	`img`
33	`header`
34	`footer`

partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.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
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	`gr`
32	`img`
33	`header`
34	`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

23 statements were executed, 2 of which were duplicated, 21 unique22.55ms

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

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

Metadata
Bindings	0. en
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` desc570μ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` desc440μ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` = 'en' limit 1640μsmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. en
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` = 'en' and `slug` = 'magic-kiss-dental-clinic' limit 1

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

Metadata
Bindings	0. en 1. magic-kiss-dental-clinic
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` = 128 and `mi_tr`.`lang_id` = 'en'

860μs/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev

Metadata
Bindings	0. 128 1. en
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 1490μ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: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` = 128 and `group_id` = 2820μs/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev

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

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

Metadata
Bindings	0. 128
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` = 128390μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev

Metadata
Bindings	0. 128
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` = 128 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` = 'en' where `mi_cl_image_gr`.`static` = 0 group by `mi_cl_image_gr`.`id`

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

Metadata
Bindings	0. 128 1. en 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` = 128 and `mi_gr`.`static` = 0

660μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 128 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` = 128 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 0

780μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 128 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` = 'en' and `mi_gallery`.`clinic_id` = 128 group by `mi_gallery`.`id`

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

Metadata
Bindings	0. left 1. right 2. gallery 3. en 4. 128
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` = 'en'

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

Metadata
Bindings	0. en
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` = 'en' 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` = 'en' where `mi_cl_question`.`group_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10) and `mi_ca`.`clinic_id` = 128 order by `mi_cl_question`.`order_no` asc

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

Metadata
Bindings	0. en 1. en 2. 128
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` = 'en' 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` = 'en' 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` = 'en' where `mi_review`.`clinic_id` = 128 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 10

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

Metadata
Bindings	0. before 1. after 2. en 3. en 4. en 5. 128
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_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

1.08ms/app/Composers/ReviewComposer.php:121lv_misooda_dev

Metadata
Bindings	0. en 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` = 'en' 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` = 'en' where `mi_promotion`.`clinic_id` = 128 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 12

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

Metadata
Bindings	0. en 1. en 2. 128
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` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

970μs/app/Composers/PromotionComposer.php:79lv_misooda_dev

Metadata
Bindings	0. en 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` = 'en' 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` = 'en' 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` = 'en' 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` = 128 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 8

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

Metadata
Bindings	0. en 1. en 2. en 3. 128
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` = 128 order by `mi_user_follow`.`created_at` desc

980μs/app/Composers/MainComposer.php:264lv_misooda_dev

Metadata
Bindings	0. clinic 1. 128
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` = 'en' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

920μs/app/Composers/BannerComposer.php:20lv_misooda_dev

Metadata
Bindings	0. en 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: 22
App\Model\ClinicQuestionGroup: 9
App\Model\ClinicImage: 8
App\Model\ClinicImageGroup: 3
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: YixdQlKLcvkWmVgy7AXLTHXDR8Qvta22RFLWddz1
login_after_url: http://dev.misooda.com/en/chat/clinic/jewelry-plastic-surgery
_flash: array:2 [ "new" => [] "old" => [] ]
_previous: array:1 [ "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/clinic/magic-kiss-dental-clinic

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 => "_fbp=fb.1.1748880344569.772317330979387260; XSRF-TOKEN=eyJpdiI6ImhoeUw4aFwvV21ha2VMMnJMM1dsZFZRPT0iLCJ2YWx1ZSI6Im5oWXBwXC9lTng0Z20zTjl4cVdRNUpsRFZQZ0haTTEwOGs3V21YemI1SnQrNkxYVVlZM28zYXlEMFlCNndzc0lOIiwibWFjIjoiMDVkNDNkNTVmMGJhYTU3ZjBmZmFmMWEyMDI4MDQ5YmE5ZjlmMjhjNGU1ODBhNjIyMTc0YWE5N2U5MWIyNjc4MSJ9; misooda=j4Dn9x27Jbd2DbRG664wmPWfpTgJROoImHol6QBi ◀_fbp=fb.1.1748880344569.772317330979387260; XSRF-TOKEN=eyJpdiI6ImhoeUw4aFwvV21ha2VMMnJMM1dsZFZRPT0iLCJ2YWx1ZSI6Im5oWXBwXC9lTng0Z20zTjl4cVdRNUpsRFZQZ0haTTEwOGs3V ▶"
  ]
]

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" => "_fbp=fb.1.1748880344569.772317330979387260; XSRF-TOKEN=eyJpdiI6ImhoeUw4aFwvV21ha2VMMnJMM1dsZFZRPT0iLCJ2YWx1ZSI6Im5oWXBwXC9lTng0Z20zTjl4cVdRNUpsRFZQZ0haTTEwOGs3V21YemI1SnQrNkxYVVlZM28zYXlEMFlCNndzc0lOIiwibWFjIjoiMDVkNDNkNTVmMGJhYTU3ZjBmZmFmMWEyMDI4MDQ5YmE5ZjlmMjhjNGU1ODBhNjIyMTc0YWE5N2U5MWIyNjc4MSJ9; misooda=j4Dn9x27Jbd2DbRG664wmPWfpTgJROoImHol6QBi ◀_fbp=fb.1.1748880344569.772317330979387260; XSRF-TOKEN=eyJpdiI6ImhoeUw4aFwvV21ha2VMMnJMM1dsZFZRPT0iLCJ2YWx1ZSI6Im5oWXBwXC9lTng0Z20zTjl4cVdRNUpsRFZQZ0haTTEwOGs3V ▶"
  "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.191.174.190"
  "DOCUMENT_ROOT" => "/var/www/dev/html"
  "REQUEST_SCHEME" => "http"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/dev/html"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/dev/html/index.php"
  "REMOTE_PORT" => "16430"
  "REDIRECT_URL" => "/en/clinic/magic-kiss-dental-clinic"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/clinic/magic-kiss-dental-clinic"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1748880347.074
  "REQUEST_TIME" => 1748880347
]

request_cookies

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

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 02 Jun 2025 16:05:47 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZyYTJ3WGorUndVbGVHVXFnUVdnWXc9PSIsInZhbHVlIjoiRGJsWk1zODNsZEFpSWptalM1XC9PZ1wvbGNRTTRIQVhHQTRqQVBzTHpJak5QYTlXcnA5aERDSm9ySmdHMGRCVWwwIiwibWFjIjoiYmMwOTVjYzg1NjEwZDM2M2NiMGM1NWM4ZjQ0NTFiZmVlMjk0ZjU0YWE2YTliYTdjNTczMjRiMjE1YzQyZTIyZiJ9; expires=Mon, 02-Jun-2025 18:05:47 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InZyYTJ3WGorUndVbGVHVXFnUVdnWXc9PSIsInZhbHVlIjoiRGJsWk1zODNsZEFpSWptalM1XC9PZ1wvbGNRTTRIQVhHQTRqQVBzTHpJak5QYTlXcnA5aERDSm9ySmdHMGRCVWwwIiwib ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZyYTJ3WGorUndVbGVHVXFnUVdnWXc9PSIsInZhbHVlIjoiRGJsWk1zODNsZEFpSWptalM1XC9PZ1wvbGNRTTRIQVhHQTRqQVBzTHpJak5QYTlXcnA5aERDSm9ySmdHMGRCVWwwIiwibWFjIjoiYmMwOTVjYzg1NjEwZDM2M2NiMGM1NWM4ZjQ0NTFiZmVlMjk0ZjU0YWE2YTliYTdjNTczMjRiMjE1YzQyZTIyZiJ9; expires=Mon, 02-Jun-2025 18:05:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InZyYTJ3WGorUndVbGVHVXFnUVdnWXc9PSIsInZhbHVlIjoiRGJsWk1zODNsZEFpSWptalM1XC9PZ1wvbGNRTTRIQVhHQTRqQVBzTHpJak5QYTlXcnA5aERDSm9ySmdHMGRCVWwwIiwib ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "YixdQlKLcvkWmVgy7AXLTHXDR8Qvta22RFLWddz1"
  "login_after_url" => "http://dev.misooda.com/en/chat/clinic/jewelry-plastic-surgery"
  "_flash" => array:2 [▶
    "new" => []
    "old" => []
  ]
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

1 x Application (88.02%)	136.13ms
1 x Booting (11.89%)	18.39ms