Incision Ptosis Revision

Beckyiy Beckyiy

  • 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 : 2018.11.23
It’s been 3 weeks after I had double eyelid surgery! Last week the stitches are removed all and I apply the ice pack every day to reduce puffy eyes. I’m very pleased with my overall experience in Hyundai aesthetics plastic surgery and highly recommend you. The best thing was their services I received from them and I also like my natural result. I will definitely be going back to my future procedures. This was the best decision of my life!
  • 65
  • 0
  • 2534
7.2.34PHP Version469msRequest Duration10MBMemory UsageGET {lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (198ms)
    • Application (271ms)
    • 1 x Application (57.72%)
      270.92ms
      1 x Booting (42.22%)
      198.17ms
      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)23blade
        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
        id
      • partials.shortcode.review_sidebar (resources/views/partials/shortcode/review_sidebar.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
        cat_id
        23
        not_id
        24
        limit
        25
        cat
        26
        clinic_id
        27
        type
        28
        reviews
      • partials.shortcode.post_module (resources/views/partials/shortcode/post_module.blade.php)24blade
        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
        limit
        23
        list
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_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
        category_id
        23
        limit
        24
        rMenuType
        25
        title
        26
        clinic_id
        27
        cat
        28
        type
        29
        not_id
        30
        list
        31
        showCats
        32
        totalPromotion
        33
        showBest
        34
        showHotDeal
        35
        showAll
      • layouts.frontend (resources/views/layouts/frontend.blade.php)23blade
        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
        mainImage
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)23blade
        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
        mainImage
      • partials.frontend.header (resources/views/partials/frontend/header.blade.php)24blade
        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
        mainImage
        23
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)25blade
        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
        mainImage
        23
        header
        24
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)31blade
        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
        mainImage
        23
        header
        24
        footer
        25
        group
        26
        showImg
        27
        limit
        28
        list
        29
        showTitle
        30
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)25blade
        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
        mainImage
        23
        header
        24
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)25blade
        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
        mainImage
        23
        header
        24
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)25blade
        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
        mainImage
        23
        header
        24
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)25blade
        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
        mainImage
        23
        header
        24
        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
      22 statements were executed107ms
      • 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'19.17ms/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` desc2.19ms/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` desc6.28ms/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 13.14msmiddleware::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` = 'incision-ptosis-revision' limit 113.61ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev
        Metadata
        Bindings
        • 0. incision-ptosis-revision
        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` = 2534, `mi_review`.`updated_at` = '2025-02-25 18:44:58' where `id` = 3837.33ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 2534
        • 1. 2025-02-25 18:44:58
        • 2. 383
        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` = 61 limit 16.16ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 61
        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` = 383 and `lang_id` = 'vi' limit 12.08ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev
        Metadata
        Bindings
        • 0. 383
        • 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` = 25 and `lang_id` = 'vi' limit 12.69ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev
        Metadata
        Bindings
        • 0. 25
        • 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` = 25 limit 13.14ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 25
        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` = 61 and `lang_id` = 'vi' limit 17.23ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev
        Metadata
        Bindings
        • 0. 61
        • 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 1630μs/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` = 3831.82ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev
        Metadata
        Bindings
        • 0. 383
        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` = 383 order by `d_date` desc7.18ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Bindings
        • 0. 383
        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 `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` = 383 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc4.54ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. 383
        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` = 1190 limit 18.04ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 1190
        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 13.37ms/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` = 25 and `mi_review`.`id` <> 383 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 42.06ms/app/Composers/ReviewComposer.php:413lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. vi
        • 3. 25
        • 4. 383
        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 32.65ms/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` = 25 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.77ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 2. 25
        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`520μ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` = 'vi' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc980μs/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\ImagesReview
      2
      App\Model\ClinicTrans
      1
      App\Model\Category
      1
      App\Model\CategoryTrans
      1
      App\Model\Clinic
      1
      App\Model\Review
      5
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          OfCseFk0xhdrnbbdgH0Jz8kWhHF8Gg0MsG9D349q
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /vi/review/hyundal-mlhak-plastic-surgery/incision-ptosis-revision
          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.138.86.166" "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" => "6020" "REDIRECT_URL" => "/vi/review/hyundal-mlhak-plastic-surgery/incision-ptosis-revision" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/vi/review/hyundal-mlhak-plastic-surgery/incision-ptosis-revision" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740476697.808 "REQUEST_TIME" => 1740476697 ]
          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:44:58 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtWZjdERzFkc1IxWlc1SXl6WDNGSHc9PSIsInZhbHVlIjoidmNZcVB5XC9EMnVoa0F4TTNEQVhwVlFWSE9cL05XdkJ3MFwvWWlhSUx6NE91UURsQ2p4Wnp1WHZmaFc5YlF5cFZRZSIsIm1hYyI6ImNmMmMxMzI2YWJkYzYyNGJmMDJkYzhhODdmZWQ5ZmE4OGI1YTBkZTBmYTI4MmFhZDI5ZTQ4YTY4MTYzY2YxNDkifQ%3D%3D; expires=Tue, 25-Feb-2025 11:44:58 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6ImtWZjdERzFkc1IxWlc1SXl6WDNGSHc9PSIsInZhbHVlIjoidmNZcVB5XC9EMnVoa0F4TTNEQVhwVlFWSE9cL05XdkJ3MFwvWWlhSUx6NE91UURsQ2p4Wnp1WHZmaFc5YlF5cFZRZSIsI" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtWZjdERzFkc1IxWlc1SXl6WDNGSHc9PSIsInZhbHVlIjoidmNZcVB5XC9EMnVoa0F4TTNEQVhwVlFWSE9cL05XdkJ3MFwvWWlhSUx6NE91UURsQ2p4Wnp1WHZmaFc5YlF5cFZRZSIsIm1hYyI6ImNmMmMxMzI2YWJkYzYyNGJmMDJkYzhhODdmZWQ5ZmE4OGI1YTBkZTBmYTI4MmFhZDI5ZTQ4YTY4MTYzY2YxNDkifQ%3D%3D; expires=Tue, 25-Feb-2025 11:44:58 GMT; path=/XSRF-TOKEN=eyJpdiI6ImtWZjdERzFkc1IxWlc1SXl6WDNGSHc9PSIsInZhbHVlIjoidmNZcVB5XC9EMnVoa0F4TTNEQVhwVlFWSE9cL05XdkJ3MFwvWWlhSUx6NE91UURsQ2p4Wnp1WHZmaFc5YlF5cFZRZSIsI" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "OfCseFk0xhdrnbbdgH0Jz8kWhHF8Gg0MsG9D349q" "PHPDEBUGBAR_STACK_DATA" => [] ]