โรงพยาบาลศัลยกรรม นานะ
โรงพยาบาลศัลยกรรม นานะ
ที่อยู่ : 165-8, Nonhyeon-dong, Gangnam-gu, Seoul, South Korea
ความพึงพอใจ :
สิ่งพิเศษ : ตา จมูก ยกกระชับใบหน้า หน้าอก การปลูกถ่ายไขมัน ดูดไขมัน โบท็อกซ์ ฟิลเลอร์ ปาก กระดูกโครงหน้า
  • jud_jelly86

    โรงพยาบาลศัลยกรรม นานะ

  • s_smith8

    โรงพยาบาลศัลยกรรม นานะ

  • bunny_ri2

    โรงพยาบาลศัลยกรรม นานะ

  • chase_xeno

    โรงพยาบาลศัลยกรรม นานะ

  • danika_im3

    โรงพยาบาลศัลยกรรม นานะ

  • milie_s0u

    โรงพยาบาลศัลยกรรม นานะ

  • kevin_clame

    โรงพยาบาลศัลยกรรม นานะ

  • jfferi_5

    โรงพยาบาลศัลยกรรม นานะ

  • nami_alenxei

    โรงพยาบาลศัลยกรรม นานะ

  • poco12

    โรงพยาบาลศัลยกรรม นานะ

หมอ
Hyeong Jun Kim

บอร์ดของความเชี่ยวชาญ

:

ความเชี่ยวชาญ

:

จำนวนปีประสบการณ์

: 17

Hyeong Jun Kim

Sang Reok Choi

บอร์ดของความเชี่ยวชาญ

:

ความเชี่ยวชาญ

:

จำนวนปีประสบการณ์

: 17

Sang Reok Choi

Dong Yeon Hwang

บอร์ดของความเชี่ยวชาญ

:

ความเชี่ยวชาญ

:

จำนวนปีประสบการณ์

: 16

Dong Yeon Hwang

Sun Hee Park

บอร์ดของความเชี่ยวชาญ

:

ความเชี่ยวชาญ

:

จำนวนปีประสบการณ์

: 16

Sun Hee Park

วันทำการ / แผนที่

165-8, Nonhyeon-dong, Gangnam-gu, Seoul, South Korea

วันทำการ

Weekday 10:00 AM ~ 7:00 PM
Friday 10:00 AM ~ 7:00 PM
Saturday 10:00 AM ~ 7:00 PM

เวลาทำการ

Sunday and Public Holidays: Closed

7.2.34PHP Version462msRequest Duration10MBMemory UsageGET {lang}/clinic/{slug}RouteAuth status
    • Booting (111ms)
    • Application (350ms)
    • 1 x Application (75.86%)
      350.19ms
      1 x Booting (24.09%)
      111.20ms
      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
      33 statements were executed, 2 of which were duplicated, 31 unique140ms
      • 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` = 'th'8.68ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        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` desc750μ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` desc640μ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` = 'th' limit 1590μsmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. th
        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` = 'th' and `slug` = 'nana-plastic-surgery' limit 14.01ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 1. nana-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` = 170 and `mi_tr`.`lang_id` = 'th'1.59ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        • 1. th
        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 114.57ms/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` = 170 and `group_id` = 21.05ms/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        • 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` = 170 group by `clinic_id` limit 18.29ms/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        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` = 1707.41ms/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        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` = 170 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` = 'th' where `mi_cl_image_gr`.`static` = 0 group by `mi_cl_image_gr`.`id`2.44ms/app/Http/Controllers/Frontend/ClinicController.php:124lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        • 1. th
        • 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` = 170 and `mi_gr`.`static` = 01.84ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        • 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` = 170 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 03.02ms/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 170
        • 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` = 'th' and `mi_gallery`.`clinic_id` = 170 group by `mi_gallery`.`id`3.34ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. left
        • 1. right
        • 2. gallery
        • 3. th
        • 4. 170
        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` = 'th'1.04ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        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` = 'th' 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` = 'th' where `mi_cl_question`.`group_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10) and `mi_ca`.`clinic_id` = 170 order by `mi_cl_question`.`order_no` asc5.73ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 1. th
        • 2. 170
        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` = 'th' 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` = 'th' 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` = 'th' where `mi_review`.`clinic_id` = 170 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 1013.88ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. th
        • 3. th
        • 4. th
        • 5. 170
        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` = 395 and `flag` = 'after' limit 72.69ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 395
        • 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` = 401 and `flag` = 'after' limit 77.8ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 401
        • 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` = 399 and `flag` = 'after' limit 73.05ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 399
        • 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` = 398 and `flag` = 'after' limit 72.74ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 398
        • 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` = 397 and `flag` = 'after' limit 77.31ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 397
        • 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` = 396 and `flag` = 'after' limit 73.08ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 396
        • 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` = 394 and `flag` = 'after' limit 72.13ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 394
        • 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` = 393 and `flag` = 'after' limit 73.58ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 393
        • 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` = 392 and `flag` = 'after' limit 7540μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 392
        • 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` = 391 and `flag` = 'after' limit 7490μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 391
        • 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` = 'th' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc1.98ms/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 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` = 'th' 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` = 'th' where `mi_promotion`.`clinic_id` = 170 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 123.24ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 1. th
        • 2. 170
        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` = 'th' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc5.72ms/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 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` = 'th' 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` = 'th' 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` = 'th' 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` = 170 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 810.55ms/app/Composers/MainComposer.php:223lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 1. th
        • 2. th
        • 3. 170
        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` = 170 order by `mi_user_follow`.`created_at` desc3.79ms/app/Composers/MainComposer.php:264lv_misooda_dev
        Metadata
        Bindings
        • 0. clinic
        • 1. 170
        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` = 'th' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc2ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. th
        • 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
      4
      App\Model\Promotion
      3
      App\Model\Category
      22
      App\Model\ImagesReview
      10
      App\Model\ClinicQuestion
      23
      App\Model\ClinicQuestionGroup
      9
      App\Model\Review
      11
      App\Model\ClinicImage
      5
      App\Model\ClinicImageGroup
      2
      App\Model\ClinicCategory
      10
      App\Model\Clinic
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          FXLJf5EhZJ6smpkuIvjHSVGAjo9RPQ3J8dWRpo1F
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /th/clinic/nana-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" => "18.118.218.112" "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" => "49496" "REDIRECT_URL" => "/th/clinic/nana-plastic-surgery" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/th/clinic/nana-plastic-surgery" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740353374.32 "REQUEST_TIME" => 1740353374 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 23 Feb 2025 23:29:34 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikx5aSszNE5NSXNoVEpoN05zU2x3SGc9PSIsInZhbHVlIjoiNndlaFJxMzg2NjlJbFJvNFBwaW9QUWxIblwvaVBhdEsxM1psQVNuMzIxdVlmY1ptdGRDdVI2RjNyM1RHcDhQS3giLCJtYWMiOiJhYTVkZDI3ZmRiNjNjYWJlN2NlYTgyMDliYjNkMWY4ZTg5Y2RjYzMyOTIwMmRlNzRjMGMzNmY1MTQ5MGJiMzhlIn0%3D; expires=Mon, 24-Feb-2025 01:29:34 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Ikx5aSszNE5NSXNoVEpoN05zU2x3SGc9PSIsInZhbHVlIjoiNndlaFJxMzg2NjlJbFJvNFBwaW9QUWxIblwvaVBhdEsxM1psQVNuMzIxdVlmY1ptdGRDdVI2RjNyM1RHcDhQS3giLCJtY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikx5aSszNE5NSXNoVEpoN05zU2x3SGc9PSIsInZhbHVlIjoiNndlaFJxMzg2NjlJbFJvNFBwaW9QUWxIblwvaVBhdEsxM1psQVNuMzIxdVlmY1ptdGRDdVI2RjNyM1RHcDhQS3giLCJtYWMiOiJhYTVkZDI3ZmRiNjNjYWJlN2NlYTgyMDliYjNkMWY4ZTg5Y2RjYzMyOTIwMmRlNzRjMGMzNmY1MTQ5MGJiMzhlIn0%3D; expires=Mon, 24-Feb-2025 01:29:34 GMT; path=/XSRF-TOKEN=eyJpdiI6Ikx5aSszNE5NSXNoVEpoN05zU2x3SGc9PSIsInZhbHVlIjoiNndlaFJxMzg2NjlJbFJvNFBwaW9QUWxIblwvaVBhdEsxM1psQVNuMzIxdVlmY1ptdGRDdVI2RjNyM1RHcDhQS3giLCJtY" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "FXLJf5EhZJ6smpkuIvjHSVGAjo9RPQ3J8dWRpo1F" "PHPDEBUGBAR_STACK_DATA" => [] ]