yunseol yunseol

  • Tư vấn với bác sĩ :
  • Mức độ thân thiện :
  • Môi trường xung quanh :
  • Giá cả phẫu thuật :
  • Sự hài lòng chung :
  • Hạng mục :
  • Tên phòng khám :
  • Tên bác sĩ : -
  • Ngày phẫu thuật : 2015.02.02
  • 527
  • 2
  • 5330
When I was called thunder thighs or elephant legs, I never imagined that I could fit into short skirts or skinny jeans one day, but now I can!!! Now I can wear fashionable clothes and carry myself with confidence!
No words can describe how happy I was after the Liposuction. Not only did my legs look longer, my butt looks as if I had a butt lift done as well! After I got liposuction done, wearing the compression garment as per instructed by my doctor was a bit uncomfortable. I saw my legs got slimmer each day as I carefully followed instructions and my confidence was boosted after that.
Doctor Kim Su Cheol explained to me that the swelling and bruises on my legs would disappear really quickly and assured me not to worry too much. Low and behold, they really did disappear rather quickly! I can start to see how awesome my slim legs will turn out and I feel so happy about it!
7.2.34PHP Version306msRequest Duration9MBMemory UsageGET {lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (115ms)
    • Application (192ms)
    • 1 x Application (62.52%)
      191.54ms
      1 x Booting (37.4%)
      114.60ms
      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
      26 statements were executed89.21ms
      • 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` = 'vi'2.19ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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` desc740μ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/ReviewController.php:26
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 order by `id` desc750μ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/ReviewController.php:26
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'vi' limit 11.1msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. vi
        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` = 'shapely-body' limit 11.24ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev
        Metadata
        Bindings
        • 0. shapely-body
        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` = 5330, `mi_review`.`updated_at` = '2025-02-25 18:45:06' where `id` = 1082.32ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 5330
        • 1. 2025-02-25 18:45:06
        • 2. 108
        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` = 5 limit 112.03ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 5
        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` = 108 and `lang_id` = 'vi' limit 17.75ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev
        Metadata
        Bindings
        • 0. 108
        • 1. vi
        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` = 'vi' limit 12.89ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev
        Metadata
        Bindings
        • 0. 40
        • 1. vi
        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 111.45ms/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` = 5 and `lang_id` = 'vi' limit 14.57ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev
        Metadata
        Bindings
        • 0. 5
        • 1. vi
        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` = 'vi' limit 12.67ms/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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` = 1085.78ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev
        Metadata
        Bindings
        • 0. 108
        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` = 108 order by `d_date` desc1.03ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Bindings
        • 0. 108
        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 (132, 133, 134)830μs/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` = 134 and `lang_id` = 'vi' limit 1680μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev
        Metadata
        Bindings
        • 0. 134
        • 1. vi
        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` = 133 and `lang_id` = 'vi' limit 1630μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev
        Metadata
        Bindings
        • 0. 133
        • 1. vi
        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` = 132 and `lang_id` = 'vi' limit 16.41ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev
        Metadata
        Bindings
        • 0. 132
        • 1. vi
        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` = 'vi' and `mi_comments_review`.`post_id` = 108 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc1.96ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. 108
        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` = 680 limit 13.01ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 680
        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` = 'vi' order by RAND() limit 14.45ms/app/Composers/PromotionComposer.php:114lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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` = 'vi' 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` <> 108 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 44.38ms/app/Composers/ReviewComposer.php:413lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. vi
        • 3. 40
        • 4. 108
        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` = 'vi' limit 31.76ms/app/Composers/MainComposer.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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` = 'vi' 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` = 'vi' where `mi_promotion`.`category_id` = 40 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 42.44ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 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`1.35ms/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` = 'vi' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc4.8ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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
      4
      App\Model\ReviewDiary
      3
      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
          dG7wdKIilYQP40cKxTVscv3C8AQ9C8Tg3eFr3PBD
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /vi/review/the-plastic-surgery/shapely-body
          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.191.187.115" "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" => "18318" "REDIRECT_URL" => "/vi/review/the-plastic-surgery/shapely-body" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/vi/review/the-plastic-surgery/shapely-body" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740476706.356 "REQUEST_TIME" => 1740476706 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 09:45:06 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikl4clc5K0dBY09IaGNPSGxKbVplbkE9PSIsInZhbHVlIjoiXC9CQzJSME9IT0JialJLMWJ4NkpqSDNcL3VERTZnZlpkVjU3cGxHcU5KVkVkeExrQXNQUTR0R1BDRG56bStVNjkzIiwibWFjIjoiOGQwMDRkYjhjMTgxYTdmMjQ3ZGVjMTMyNTBkMDE3YjRhZGM2ZGVkMGU5YTZiNDNiY2Y0MTIwZDg0YzM0OWJjOCJ9; expires=Tue, 25-Feb-2025 11:45:06 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Ikl4clc5K0dBY09IaGNPSGxKbVplbkE9PSIsInZhbHVlIjoiXC9CQzJSME9IT0JialJLMWJ4NkpqSDNcL3VERTZnZlpkVjU3cGxHcU5KVkVkeExrQXNQUTR0R1BDRG56bStVNjkzIiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikl4clc5K0dBY09IaGNPSGxKbVplbkE9PSIsInZhbHVlIjoiXC9CQzJSME9IT0JialJLMWJ4NkpqSDNcL3VERTZnZlpkVjU3cGxHcU5KVkVkeExrQXNQUTR0R1BDRG56bStVNjkzIiwibWFjIjoiOGQwMDRkYjhjMTgxYTdmMjQ3ZGVjMTMyNTBkMDE3YjRhZGM2ZGVkMGU5YTZiNDNiY2Y0MTIwZDg0YzM0OWJjOCJ9; expires=Tue, 25-Feb-2025 11:45:06 GMT; path=/XSRF-TOKEN=eyJpdiI6Ikl4clc5K0dBY09IaGNPSGxKbVplbkE9PSIsInZhbHVlIjoiXC9CQzJSME9IT0JialJLMWJ4NkpqSDNcL3VERTZnZlpkVjU3cGxHcU5KVkVkeExrQXNQUTR0R1BDRG56bStVNjkzIiwib" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "dG7wdKIilYQP40cKxTVscv3C8AQ9C8Tg3eFr3PBD" "PHPDEBUGBAR_STACK_DATA" => [] ]