prev
next
Jewelry Plastic Surgery
Jewelry Plastic Surgery
Address : Nonhyeon-dong 3-2 Gangnam-gu, South Korea
Satisfaction :
Specialty : Eye Nose Breast Fat Grafting Liposuction Toxin Filler Facial Bone
Chat Now Inquiry
Best Review
Promotion

Jewelry Plastic Surgery

Face off! Eyes+ Nose +Fat Graft (Contact MISOODA for price)

$ 0
0%
$ 0

Jewelry Plastic Surgery

Double Eyelid Reopreation by incisional method (Contact MISOODA for price)

$ 0
0%
$ 0

Jewelry Plastic Surgery

Double eyelid reoperation with Non-incisional method (Contact MISOODA for price)

$ 0
35%
$ 0

Jewelry Plastic Surgery

Reduction face V contour (Contact MISOODA for price)

$ 0
0%
$ 0

Jewelry Plastic Surgery

Double Eyelid Surgery (Contact MISOODA for price)

$ 0
0%
$ 0

Jewelry Plastic Surgery

Front Chin V-fit Lifting (Contact MISOODA for price)

$ 0
0%
$ 0
Info

Description

Three Promises of Jewelry
A reliable hospital, Jewerly Plastic Surgery Hospital makes promises to our Patients.
1. All doctors at Jewelry Plastic Surgery Hospital are plastic surgery specialists.
2. Jewelry Plastic Surgery Hospital does not allow doctors or ghost doctors
3. Anesthesia specialists are always on duty at Jewelry Plastic Surgery Hospital

1. Safety

2. Surgery

3. Post Surgery Care

4. Pre/Post Surgery Customer Information Management

5. Patient' Surgery Record

6. Provided Service

Pick up & sending
- Pick up & sending
Wifi-free
- Wifi-free
1 recovery room
- 1 recovery room
Sending service
- Sending service

7. Medical Reimbursement Insurance

8. Certification

CCTV
- CCTV
Post care
- Post Care
Emergency System
- Emergency System
Real Doc
- Real Doctor
Medical Ins.
- Medical insurance

9. Language

Doctor
Ki Chul Shin

Board of Speciality

: Plastic Surgeon

Speciality

: Eyes,Facial Bone,Nose

Years of Experiences

: 12

Ki Chul Shin

Yong Jin Cho

Board of Speciality

:

Speciality

:

Years of Experiences

: 12

Yong Jin Cho

In Su Baek

Board of Speciality

:

Speciality

:

Years of Experiences

: 14

In Su Baek

Yong Weon Shin

Board of Speciality

:

Speciality

:

Years of Experiences

: 21

Yong Weon Shin

Yu Jin Mun

Board of Speciality

:

Speciality

:

Years of Experiences

: 14

Yu Jin Mun

Yeon Sik Yoo

Board of Speciality

:

Speciality

:

Years of Experiences

: 15

Yeon Sik Yoo

Hyeong Woo Lim

Board of Speciality

:

Speciality

:

Years of Experiences

: 16

Hyeong Woo Lim

Jeong Ho Yoon

Board of Speciality

:

Speciality

:

Years of Experiences

: 14

Jeong Ho Yoon

Business Time / Map

Nonhyeon-dong 3-2 Gangnam-gu, South Korea

Business Time

Pre-arranged consultations are available

Business Hour

Weekdays : AM 10:00 ~ PM 07:00

Saturdays : AM 10:00 ~ PM : 04:00

MessagesTimelineExceptionsViews15RouteQueries34Models163MailsAuthGateSessionRequest
7.2.34PHP Version183msRequest Duration10MBMemory UsageGET {lang}/clinic/{slug}RouteAuth status
    • Booting (30.94ms)
    • Application (152ms)
    • 1 x Application (82.98%)
      152.25ms
      1 x Booting (16.86%)
      30.94ms
      15 templates were rendered
      • frontend.clinic.show (resources/views/frontend/clinic/show.blade.php)20blade
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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
      34 statements were executed, 2 of which were duplicated, 32 unique47.08ms
      lv_misooda_dev
      • 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.41ms/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` desc680μ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` desc580μ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 1480μ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` = 'jewelry-plastic-surgery' limit 11.15ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. jewelry-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` = 74 and `mi_tr`.`lang_id` = 'en'1.18ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        • 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 1640μ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` = 74 and `group_id` = 2900μs/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        • 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` = 74 group by `clinic_id` limit 1780μs/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        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` = 74590μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        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` = 74 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.31ms/app/Http/Controllers/Frontend/ClinicController.php:124lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        • 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` = 74 and `mi_gr`.`static` = 01.61ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        • 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` = 74 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 01.05ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 74
        • 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` = 74 group by `mi_gallery`.`id`3.56ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. left
        • 1. right
        • 2. gallery
        • 3. en
        • 4. 74
        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` = 'en' and `mi_gallery`.`clinic_id` = 74 group by `mi_gallery`.`id` order by `mi_gallery`.`created_at` desc limit 20 offset 07.04ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. left
        • 1. right
        • 2. gallery
        • 3. en
        • 4. 74
        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.2ms/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` = 74 order by `mi_cl_question`.`order_no` asc2.78ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 74
        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` = 74 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 104.18ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. en
        • 3. en
        • 4. en
        • 5. 74
        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` = 290 and `flag` = 'after' limit 7790μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 290
        • 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` = 288 and `flag` = 'after' limit 7890μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 288
        • 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` = 427 and `flag` = 'after' limit 7530μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 427
        • 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` = 404 and `flag` = 'after' limit 7460μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 404
        • 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` = 403 and `flag` = 'after' limit 7570μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 403
        • 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` = 402 and `flag` = 'after' limit 7560μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 402
        • 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` = 381 and `flag` = 'after' limit 7560μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 381
        • 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` = 380 and `flag` = 'after' limit 7520μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 380
        • 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` = 377 and `flag` = 'after' limit 7450μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 377
        • 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` = 293 and `flag` = 'after' limit 7690μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 293
        • 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` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc890μs/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` = 74 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 122.51ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 74
        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` asc890μ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` = 74 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 83.46ms/app/Composers/MainComposer.php:223lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. en
        • 3. 74
        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` = 74 order by `mi_user_follow`.`created_at` desc980μs/app/Composers/MainComposer.php:264lv_misooda_dev
        Metadata
        Bindings
        • 0. clinic
        • 1. 74
        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` desc1.21ms/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\UserFollow
      1
      App\Model\Doctor
      8
      App\Model\Promotion
      6
      App\Model\Category
      22
      App\Model\ImagesReview
      10
      App\Model\ClinicQuestion
      35
      App\Model\ClinicQuestionGroup
      9
      App\Model\Gallery
      20
      App\Model\Review
      11
      App\Model\ClinicImage
      9
      App\Model\ClinicImageGroup
      5
      App\Model\ClinicCategory
      8
      App\Model\Clinic
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          UjCzmwrdwy01zyWEei7ezpy1hKjNPVDxRpQsEaZK
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/clinic/jewelry-plastic-surgery
          status_code
          200
          status_text
          OK
          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.129.12.100"
  "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" => "40736"
  "REDIRECT_URL" => "/en/clinic/jewelry-plastic-surgery"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/clinic/jewelry-plastic-surgery"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1745858618.864
  "REQUEST_TIME" => 1745858618
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 28 Apr 2025 16:43:38 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImdaUnJleHJNTlRJT3pZdWhzWU1Uc2c9PSIsInZhbHVlIjoid1R4YnRcL1k4ejI2bk5NWnJcL255Q2NZSXZBbUxlR09kcng0UVVGNnhTaWl2MGNaWlhzSDJhSWdBdlYwdjFoTURwIiwibWFjIjoiNWJkMDQ4MTg5MTFhNTVhMWFlZTRkMWQxMzA3YzlmYjJlMWJhMjM5ZGMyN2IyYjQ2NmRhMjNiMTY2ZmVkMzAxMiJ9; expires=Mon, 28-Apr-2025 18:43:39 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImdaUnJleHJNTlRJT3pZdWhzWU1Uc2c9PSIsInZhbHVlIjoid1R4YnRcL1k4ejI2bk5NWnJcL255Q2NZSXZBbUxlR09kcng0UVVGNnhTaWl2MGNaWlhzSDJhSWdBdlYwdjFoTURwIiwib ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImdaUnJleHJNTlRJT3pZdWhzWU1Uc2c9PSIsInZhbHVlIjoid1R4YnRcL1k4ejI2bk5NWnJcL255Q2NZSXZBbUxlR09kcng0UVVGNnhTaWl2MGNaWlhzSDJhSWdBdlYwdjFoTURwIiwibWFjIjoiNWJkMDQ4MTg5MTFhNTVhMWFlZTRkMWQxMzA3YzlmYjJlMWJhMjM5ZGMyN2IyYjQ2NmRhMjNiMTY2ZmVkMzAxMiJ9; expires=Mon, 28-Apr-2025 18:43:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImdaUnJleHJNTlRJT3pZdWhzWU1Uc2c9PSIsInZhbHVlIjoid1R4YnRcL1k4ejI2bk5NWnJcL255Q2NZSXZBbUxlR09kcng0UVVGNnhTaWl2MGNaWlhzSDJhSWdBdlYwdjFoTURwIiwib ▶"
  ]
]
          session_attributes
            0 of 0   
          array:2 [▶
  "_token" => "UjCzmwrdwy01zyWEei7ezpy1hKjNPVDxRpQsEaZK"
  "PHPDEBUGBAR_STACK_DATA" => []
]