Korean Time

Hansot Hansot

  • Konsultasi dengan Dokter :
  • Keramahan :
  • Lingkungan :
  • Harga :
  • Kepuasan :
  • Kategori :
  • Nama Klinik :
  • Dokter : -
  • Tanggal Operasi : 2016.10.22
  • 105
  • 0
  • 3719
I was a size 66 before but now those clothings are big on me. It was important to maintain an active lifestyle after surgery so I tried to change mine by incorporating some jogging and exercising in my daily routine. I’ve heard so many stories about people re-gaining their confidence once their complex are no more, I too feel like I did a good job by undergoing thighs liposuction and now live each day with a thankful heart. I would also like to say a big thank you to my doctor who gave me such beautiful thighs.
I was able to walk like normal after surgery even though it did hurt a bit. Walking for 1 hour per day has also helped to speed up recovery. I thought my thighs would swell a lot after surgery, as my body type is the kind that gets bloated very easily too. However, they didn’t swell up as much as I’d expected. It was mainly my ankles and calves that were slightly swollen. The pain and swelling got worse after a few days but they didn’t last long. I was able to fully function like healthy person after a week or so. The aftercare treatment I received from the hospital was really helpful, I could feel the pain in my thighs alleviate a lot. It didn’t hurt as much when walking anymore and the swelling has gone down a lot.
7.2.34PHP Version338msRequest Duration9MBMemory UsageGET {lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (104ms)
    • Application (234ms)
    • 1 x Application (69.11%)
      233.84ms
      1 x Booting (30.8%)
      104.21ms
      14 templates were rendered
      • frontend.review.detail (resources/views/frontend/review/detail.blade.php)12blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        data
        4
        images
        5
        diary
        6
        wished
        7
        user
        8
        comments
        9
        pageTitle
        10
        pageDesc
        11
        pageImage
      • partials.shortcode.promotion_show (resources/views/partials/shortcode/promotion_show.blade.php)28blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        id
      • partials.shortcode.review_sidebar (resources/views/partials/shortcode/review_sidebar.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        cat_id
        28
        not_id
        29
        limit
        30
        cat
        31
        clinic_id
        32
        type
        33
        reviews
      • partials.shortcode.post_module (resources/views/partials/shortcode/post_module.blade.php)29blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        limit
        28
        list
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        category_id
        28
        limit
        29
        rMenuType
        30
        title
        31
        clinic_id
        32
        cat
        33
        type
        34
        not_id
        35
        list
        36
        showCats
        37
        totalPromotion
        38
        showBest
        39
        showHotDeal
        40
        showAll
      • layouts.frontend (resources/views/layouts/frontend.blade.php)28blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)28blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
      • partials.frontend.header (resources/views/partials/frontend/header.blade.php)29blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
        30
        group
        31
        showImg
        32
        limit
        33
        list
        34
        showTitle
        35
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        wished
        13
        user
        14
        comments
        15
        pageTitle
        16
        pageDesc
        17
        pageImage
        18
        i
        19
        __currentLoopData
        20
        img
        21
        loop
        22
        d
        23
        ddate
        24
        pdate
        25
        datediff
        26
        dayafter
        27
        mainImage
        28
        header
        29
        footer
      uri
      GET {lang}/review/{clinic}/{slug}
      middleware
      web, lang, redirect.tomobile
      controller
      App\Http\Controllers\Frontend\ReviewController@show
      namespace
      App\Http\Controllers\Frontend
      prefix
      /{lang}
      where
      file
      app/Http/Controllers/Frontend/ReviewController.php:171-250
      25 statements were executed86.43ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'id'4.33ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/ReviewController.php:26
        • 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` desc4.01ms/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/ReviewController.php:26
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 order by `id` desc2.19ms/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/ReviewController.php:26
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'id' limit 17.74msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_review`.*, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` where `slug` = 'thighs-liposuction-1' limit 11.53ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev
        Metadata
        Bindings
        • 0. thighs-liposuction-1
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:175
        • 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
      • update `mi_review` set `hit` = 3719, `mi_review`.`updated_at` = '2025-05-11 15:51:15' where `id` = 27313.31ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 3719
        • 1. 2025-05-11 15:51:15
        • 2. 273
        Backtrace
        • 13. /app/Http/Controllers/Frontend/ReviewController.php:183
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select * from `mi_clinic` where `mi_clinic`.`id` = 42 limit 11.05ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 42
        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
        • 18. /app/Model/Base/BaseModel.php:236
        • 20. /app/Http/Controllers/Frontend/ReviewController.php:186
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_review_trans` where `review_id` = 273 and `lang_id` = 'id' limit 1900μs/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev
        Metadata
        Bindings
        • 0. 273
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:126
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 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_category_trans` where `cat_id` = 40 and `lang_id` = 'id' limit 111.03ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev
        Metadata
        Bindings
        • 0. 40
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:140
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 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_category` where `mi_category`.`id` = 40 limit 1780μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 40
        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
        • 18. /app/Model/Base/BaseModel.php:236
        • 20. /app/Http/Controllers/Frontend/ReviewController.php:141
        • 21. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `mi_clinic_trans` where `clinic_id` = 42 and `lang_id` = 'id' limit 11.14ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev
        Metadata
        Bindings
        • 0. 42
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:146
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 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_doctor_trans` where `doctor_id` is null and `lang_id` = 'id' limit 12.46ms/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:152
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 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_images_review` where `review_id` = 2732.18ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev
        Metadata
        Bindings
        • 0. 273
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ReviewController.php:194
        • 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 * from `mi_review_diary` where `review_id` = 273 order by `d_date` desc2.52ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Bindings
        • 0. 273
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ReviewController.php:199
        • 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 * from `mi_images_diary` where `mi_images_diary`.`diary_id` in (666, 667)12.01ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/Frontend/ReviewController.php:199
        • 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 * from `mi_review_diary_trans` where `review_diary_id` = 667 and `lang_id` = 'id' limit 15.77ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev
        Metadata
        Bindings
        • 0. 667
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:164
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:201
        • 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_review_diary_trans` where `review_diary_id` = 666 and `lang_id` = 'id' limit 1950μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev
        Metadata
        Bindings
        • 0. 666
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:164
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:201
        • 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_comments_review`.`id`, `mi_comments_review`.`name`, `mi_comments_review`.`comment`, `mi_tr`.`comment`, `mi_comments_review`.`like_count`, `mi_comments_review`.`dislike_count`, `mi_comments_review`.`date`, `mi_user`.`username`, `mi_user`.`profile_image`, COUNT(mi_sub.id) AS reply_count from `mi_comments_review` left join `mi_user` on `mi_user`.`id` = `mi_comments_review`.`user_id` left join `mi_comments_review` as `mi_sub` on `mi_sub`.`parent_id` = `mi_comments_review`.`id` left join `mi_comments_review_trans` as `mi_tr` on `mi_tr`.`comment_id` = `mi_comments_review`.`id` where `mi_tr`.`lang_id` = 'id' and `mi_comments_review`.`post_id` = 273 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc1.33ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. 273
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ReviewController.php:241
        • 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 * from `mi_user` where `mi_user`.`id` = 530 limit 1840μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 530
        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
        • 18. /app/Model/Base/BaseModel.php:236
        • 20. view::frontend.review.detail:42
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:142
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:125
      • select `mi_promotion`.*, IFNULL(`mi_tr`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_tr`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_tr`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, `mi_tr`.`title`, `mi_tr`.`description`, `mi_tr`.`caution_before`, `mi_tr`.`caution_after`, `mi_u`.`name` as `user_name`, `mi_c`.`slug` as `clinic_slug` from `mi_promotion` left join `mi_promotion_trans` as `mi_tr` on `mi_tr`.`promotion_id` = `mi_promotion`.`id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_promotion`.`user_id` left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_promotion`.`clinic_id` where `mi_tr`.`lang_id` = 'id' order by RAND() limit 13.81ms/app/Composers/PromotionComposer.php:114lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
        Backtrace
        • 15. /app/Composers/PromotionComposer.php:114
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::frontend.review.detail:379
      • select `mi_review`.`id`, `mi_review`.`slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`slug` as `clinic_slug`, `mi_u`.`username` as `user_name` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'id' left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_review`.`user_id` where `mi_review`.`category_id` = 40 and `mi_review`.`id` <> 273 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 41.67ms/app/Composers/ReviewComposer.php:413lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. id
        • 3. 40
        • 4. 273
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:413
        • 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.review.detail:383
      • select `mi_post`.`id`, `mi_post`.`slug`, `mi_post`.`image`, `mi_post`.`user_id`, `mi_post`.`category_id`, `mi_post`.`hit`, `mi_post`.`order_no`, `mi_post`.`meta_title`, `mi_post`.`meta_desc`, `mi_post`.`created_at`, `mi_post`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_post`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_post`.`content`) as `content` from `mi_post` left join `mi_post_trans` as `mi_trans` on `mi_trans`.`post_id` = `mi_post`.`id` and `mi_trans`.`lang_id` = 'id' limit 31.32ms/app/Composers/MainComposer.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/MainComposer.php:236
        • 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.review.detail:387
      • select `mi_promotion`.*, IFNULL(`mi_pt`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`title`,`mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`description`,`mi_promotion`.`description`) AS `description`, IFNULL(`mi_pt`.`caution_before`,`mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`,`mi_promotion`.`caution_after`) AS `caution_after`, `mi_clinic`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `clinic_name` from `mi_promotion` left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'id' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'id' where `mi_promotion`.`category_id` = 40 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.78ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. id
        • 2. 40
        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.review.detail:397
      • select count(*) as aggregate from `mi_promotion`570μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/Composers/PromotionComposer.php:82
        • 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90
      • select `mi_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'id' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc1.21ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\Post
      3
      App\Model\Promotion
      5
      App\Model\User
      1
      App\Model\ImagesDiary
      5
      App\Model\ReviewDiary
      2
      App\Model\ImagesReview
      2
      App\Model\ClinicTrans
      1
      App\Model\Category
      1
      App\Model\CategoryTrans
      1
      App\Model\ReviewTrans
      1
      App\Model\Clinic
      1
      App\Model\Review
      5
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          FmS4uM1ulGWWrl6JY5FhwR5xBYLhdP5kcCfGQ16k
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /id/review/rovl-avenue-plastic-surgery/thighs-liposuction-1
          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.144.211.57" "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" => "25733" "REDIRECT_URL" => "/id/review/rovl-avenue-plastic-surgery/thighs-liposuction-1" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/id/review/rovl-avenue-plastic-surgery/thighs-liposuction-1" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746946275.714 "REQUEST_TIME" => 1746946275 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 11 May 2025 06:51:16 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlR3SzEydlZiamhzNCthQStoV0V0bWc9PSIsInZhbHVlIjoiRXhVVFZyNDRKYjhVQ1JTczdQNVF6QVZsQzBUK3ZKSTJvTGJVTDBVaWFraXBzQ0dYYlpWNDlXUDIyM2lDUUhXbSIsIm1hYyI6IjgyOTdlMDU0NWRmMWJiN2QxNDM2YWQyMWFmNWFhNDEzYzM0MDQ0NTdkNmEyOTQxYWQxNTEzMjdmNmY1ZTU3YTUifQ%3D%3D; expires=Sun, 11-May-2025 08:51:16 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlR3SzEydlZiamhzNCthQStoV0V0bWc9PSIsInZhbHVlIjoiRXhVVFZyNDRKYjhVQ1JTczdQNVF6QVZsQzBUK3ZKSTJvTGJVTDBVaWFraXBzQ0dYYlpWNDlXUDIyM2lDUUhXbSIsIm1hY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlR3SzEydlZiamhzNCthQStoV0V0bWc9PSIsInZhbHVlIjoiRXhVVFZyNDRKYjhVQ1JTczdQNVF6QVZsQzBUK3ZKSTJvTGJVTDBVaWFraXBzQ0dYYlpWNDlXUDIyM2lDUUhXbSIsIm1hYyI6IjgyOTdlMDU0NWRmMWJiN2QxNDM2YWQyMWFmNWFhNDEzYzM0MDQ0NTdkNmEyOTQxYWQxNTEzMjdmNmY1ZTU3YTUifQ%3D%3D; expires=Sun, 11-May-2025 08:51:16 GMT; path=/XSRF-TOKEN=eyJpdiI6IlR3SzEydlZiamhzNCthQStoV0V0bWc9PSIsInZhbHVlIjoiRXhVVFZyNDRKYjhVQ1JTczdQNVF6QVZsQzBUK3ZKSTJvTGJVTDBVaWFraXBzQ0dYYlpWNDlXUDIyM2lDUUhXbSIsIm1hY" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "FmS4uM1ulGWWrl6JY5FhwR5xBYLhdP5kcCfGQ16k" "PHPDEBUGBAR_STACK_DATA" => [] ]