All
Korean Time
Home Review Detail Page
Eyelid Revision
Inquiry

jenny lim jenny lim

  • Consultation with Doctor :
  • Friendliness :
  • Environment :
  • Price :
  • Satisfaction :
I did double eyelid revision surgery, closed rhinoplasty revision and fat grafting at Dream plastic surgery. I paid about $5,000 USD and it’s been about 2 weeks post recovery now. I really like my new look, changing my messenger cover photo and sending selfies to my friends are one of my pleasure hobbies recently. LOL The first photo is before my revision surgery. One eyelid side was unraveled and the other double eyelid on the other side was hidden inside. It was barely seen. My nose was getting shorter due to capsular contracture. The photo was taken from the front, so you may not see my short nose clearly T.T Good revision clinics has to be really chosen carefully. I googled and found out that many K-pop stars did their surgery at Dream Plastic Surgery. I don’t expect to look like a celebrity but I just want to look normal again. I like K-celebrity Hong Soo-Ah’s eyes so I took her picture to the surgeon asked if he could give me similar eyes. I booked the surgery and felt such a relief after the procedures. I am really satisfied with the revision surgery and I am very thankful to the surgeon who did my complicated procedure. The second picture was on the day of surgery. Even though I had a splint on the nose, my friends were commenting on my other procedure of fat grafting looking so good and not overly done. This third picture is about a week later. Isn’t it quite natural already? Makeup was able to hide the bruising and daily routine was not affected at all. The last picture is the latest picture and I just LOVE my nose line!!! I am very excited!!! My flat face became more 3D which makes my face so much smaller. I feel like I am starting a new life!
  • 886
  • 3
  • 8872
V-line Surgery
Other Reviews

Written by 123456456

Written by 123456456

Written by iooseo

Written by girinplasticsurgery

K-Beauty
Customers who saw this also saw these promotions
MORE (137)

Tc Clinic

Secondary Eye Surgery

$ 847
20%
$ 678

BK Plastic Surgery

Eyelid (incisional) + Ptosis Correction

$ 3,265
30%
$ 2,291

BK Plastic Surgery

Eyelid (incisional) + Epicanthoplasty

$ 3,265
30%
$ 2,291

Jewelry Plastic Surgery

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

$ 0
0%
$ 0
MessagesTimelineExceptionsViews14RouteQueries22Models38MailsAuthGateSessionRequest
7.2.34PHP Version363msRequest Duration10MBMemory UsageGET {lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (158ms)
    • Application (204ms)
    • 1 x Application (56.26%)
      203.96ms
      1 x Booting (43.67%)
      158.33ms
      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 executed75.04ms
      lv_misooda_dev
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'en'3.25ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/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.4ms/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` desc1.58ms/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` = 'en' limit 15.73msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_review`.*, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` where `slug` = 'eyelid-revision' limit 17.26ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev
        Metadata
        Bindings
        • 0. eyelid-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` = 8872, `mi_review`.`updated_at` = '2025-05-09 14:57:42' where `id` = 924.18ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 8872
        • 1. 2025-05-09 14:57:42
        • 2. 92
        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` = 6 limit 12.9ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 6
        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` = 92 and `lang_id` = 'en' limit 11.89ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev
        Metadata
        Bindings
        • 0. 92
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'en' limit 12.1ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev
        Metadata
        Bindings
        • 0. 25
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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 12.82ms/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` = 6 and `lang_id` = 'en' limit 18.09ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev
        Metadata
        Bindings
        • 0. 6
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'en' limit 1600μs/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 922.16ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev
        Metadata
        Bindings
        • 0. 92
        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` = 92 order by `d_date` desc1.62ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Bindings
        • 0. 92
        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` = 'en' and `mi_comments_review`.`post_id` = 92 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc3.22ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 92
        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` = 612 limit 13.91ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 612
        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` = 'en' order by RAND() limit 110.67ms/app/Composers/PromotionComposer.php:114lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        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` = 'en' 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` <> 92 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 41.44ms/app/Composers/ReviewComposer.php:413lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. en
        • 3. 25
        • 4. 92
        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` = 'en' limit 31.22ms/app/Composers/MainComposer.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        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` = 'en' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'en' where `mi_promotion`.`category_id` = 25 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.18ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 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`3.34ms/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` = 'en' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc3.48ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\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
          sDESj2uvY468PN4vg1iUjH7kpL4Yj6ffxYkKmyrR
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/review/dream-plastic-surgery/eyelid-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.143.212.252"
  "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" => "64511"
  "REDIRECT_URL" => "/en/review/dream-plastic-surgery/eyelid-revision"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/dream-plastic-surgery/eyelid-revision"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746770262.154
  "REQUEST_TIME" => 1746770262
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 09 May 2025 05:57:42 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNlcXY2M0ordmpmUlpRVUYwaitQc0E9PSIsInZhbHVlIjoiN2E1VUFabzI1c2tFQ2xsV3ZrTWFKQzJXc0JwVVJcL0x2Q0lSQzAxZ1ZOVHZieUd1eWRhZWtLcUQ3SGhzSDFtZ2YiLCJtYWMiOiIwZTM5OWUxYzQ4NjYyNGNiM2U5MTVlYTI3OWUzOTY3MjlmZDJlOTExOTQ4NTcxM2NkMjZiNTNkYTFkNWFhOTJmIn0%3D; expires=Fri, 09-May-2025 07:57:42 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNlcXY2M0ordmpmUlpRVUYwaitQc0E9PSIsInZhbHVlIjoiN2E1VUFabzI1c2tFQ2xsV3ZrTWFKQzJXc0JwVVJcL0x2Q0lSQzAxZ1ZOVHZieUd1eWRhZWtLcUQ3SGhzSDFtZ2YiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNlcXY2M0ordmpmUlpRVUYwaitQc0E9PSIsInZhbHVlIjoiN2E1VUFabzI1c2tFQ2xsV3ZrTWFKQzJXc0JwVVJcL0x2Q0lSQzAxZ1ZOVHZieUd1eWRhZWtLcUQ3SGhzSDFtZ2YiLCJtYWMiOiIwZTM5OWUxYzQ4NjYyNGNiM2U5MTVlYTI3OWUzOTY3MjlmZDJlOTExOTQ4NTcxM2NkMjZiNTNkYTFkNWFhOTJmIn0%3D; expires=Fri, 09-May-2025 07:57:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNlcXY2M0ordmpmUlpRVUYwaitQc0E9PSIsInZhbHVlIjoiN2E1VUFabzI1c2tFQ2xsV3ZrTWFKQzJXc0JwVVJcL0x2Q0lSQzAxZ1ZOVHZieUd1eWRhZWtLcUQ3SGhzSDFtZ2YiLCJtY ▶"
  ]
]
          session_attributes
            0 of 0   
          array:2 [▶
  "_token" => "sDESj2uvY468PN4vg1iUjH7kpL4Yj6ffxYkKmyrR"
  "PHPDEBUGBAR_STACK_DATA" => []
]