Korean Time
Aesthetics up!

  • Konsultasi dengan Dokter :
  • Keramahan :
  • Lingkungan :
  • Harga :
  • Kepuasan :
  • Kategori :
  • Nama Klinik :
  • Dokter : -
  • Tanggal Operasi : 2017.04.21
I arrived in Febuary when the weather was so cold, it caused my skin to start flaking in ways I have never thought it would in sunny Singapore. My skin felt really tight most of the time but a quick search linked me up to Misooda offering a myriad of services, from skin care, to dental services, to hair transplant, even to getting a new face with plastic surgery.

The pretty and pink exterior of the website immediately caught my eyes and a little navigation later, I found myself with the best deals, clinics and procedures that were available in Seoul. What I really like about this website was its high transparency, that it displayed the price so it would be hassle free for foreigners like myself to book the services and head down to the clinic instantly!

Clicking into the "Skin" section to look for the services I needed, I was amazed by the reviews left by other real users, especially with SeouLeaguer Dermatology. I decided to look for information about the clinic, which was conveniently on the website tab itself.

SeouLeaguer Dermatology offer services such as botox, laser, ultheraphy, thread lift but because skin hydration was my main concern, I opt for the No-touch Water Mesotherapy and went down to the clinic. I met with Doctor Lee Jung Hoon who has 12 years of experience, specializing in botox, thread lift and hydration injection. I was accompanied by a female translator who translated the doctor's Korean into mandarin so I could understand. The whole atmosphere and their dedicated way of treating their patients made me feel so warm and safe!

The doctor's profile and the credentials stated on Misooda's website were exactly what I got when I arrived, which really put me at ease. During the consultation, I decided to go for the nose fillers too. I was not pushed or pressured into it by the doctor. He first injected anesthesia to my skin. After awhile, the filler Neuramis was injected into my nose. The pain factor was 1/10, probably because the brand of filler already had anesthesia in it.

Next up I did the No Touch Water Mesotheraphy developed by Seoul Leaguer
I was really amazed by this procedure because while normal mesotheraphy require multiple injection and would leave behind red spots on your skin (mostly the cheek area) that requires a week of recovery, this patent pending product does not leave behind any wound or obvious mark. I only had 4 jabs compared to the traditional mesotheraphy which would leave many puncture marks on your skin.

Benefits:
♥ Improve skin brightness
♥ Moisterizing, promote collagen production
♥ Improve skin glow, skin elasticity
♥ Skin flexibility regeneration
♥ Reverse dryness of skin
♥ Quick, no downtime


Now I do not need to spend so much time contouring my nose! Love the subtle contour effect that would last me for a few months to a year. Although my nose was not as pronounced as it once was since the swelling had subsided, I love how it enhances without changing my looks or going too overboard. People can go for a touchup after 2 weeks of the nose filler procedure, however I am happy with the tweak and would not want to go for more. Bruising might occur for some, depending on the doctor's skill and how your body reacts it it. For me, I did not bruise thankfully.

Overall, I really love the results from the dermatology procedure and it was due to the convenience and ease of MISOODA that made my experience stress free one. Being a foreigner away from home can be difficult when you want to look for the best price but language barrier and lack of knowledge prevent you from doing so. This is where MISOODA, a government licensed Medical Tourism Corporation comes into the picture to ensure what you pay is what you get, and there are no fear of ghost doctor (secret swapping of doctors) and malpractice insurance would be covered.

Whats more, MISOODA allows me to source for the best price with their best price guarantee. I do not need to go through the stressful experience of conversing with doctors who might not understand me and to haggle for the price as though I am in a supermarket. Thank you for the great experience Misooda!
  • 144
  • 0
  • 3916
7.2.34PHP Version622msRequest Duration9MBMemory UsageGET {lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (207ms)
    • Application (415ms)
    • 1 x Application (66.67%)
      414.67ms
      1 x Booting (33.29%)
      207.08ms
      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 executed197ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'id'11.65ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/ReviewController.php:26
        • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:667
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:615
      • select * from `mi_language` order by `id` desc5.73ms/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` desc5.12ms/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Shared/TransController.php:45
        • 15. /app/Http/Controllers/Shared/TransController.php:21
        • 16. /app/Http/Controllers/FrontendController.php:39
        • 17. /app/Http/Controllers/Frontend/ReviewController.php:26
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'id' limit 111.26msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_review`.*, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` where `slug` = 'aesthetics-up' limit 15.67ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev
        Metadata
        Bindings
        • 0. aesthetics-up
        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` = 3916, `mi_review`.`updated_at` = '2025-02-25 18:53:43' where `id` = 1798.04ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 3916
        • 1. 2025-02-25 18:53:43
        • 2. 179
        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` = 40 limit 15.8ms/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: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` = 179 and `lang_id` = 'id' limit 15.52ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev
        Metadata
        Bindings
        • 0. 179
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:126
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_category_trans` where `cat_id` = 41 and `lang_id` = 'id' limit 123.18ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev
        Metadata
        Bindings
        • 0. 41
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:140
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_category` where `mi_category`.`id` = 41 limit 17.47ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 41
        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` = 40 and `lang_id` = 'id' limit 13.11ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev
        Metadata
        Bindings
        • 0. 40
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:146
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_doctor_trans` where `doctor_id` is null and `lang_id` = 'id' limit 113.1ms/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ReviewController.php:152
        • 16. /app/Http/Controllers/Frontend/ReviewController.php:191
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_images_review` where `review_id` = 1793.25ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev
        Metadata
        Bindings
        • 0. 179
        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` = 179 order by `d_date` desc12.02ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev
        Metadata
        Bindings
        • 0. 179
        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` = 'id' and `mi_comments_review`.`post_id` = 179 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc9.74ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. 179
        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` = 212 limit 121.31ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 212
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/Model/Base/BaseModel.php:236
        • 20. view::frontend.review.detail:42
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:142
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:125
      • select `mi_promotion`.*, IFNULL(`mi_tr`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_tr`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_tr`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, `mi_tr`.`title`, `mi_tr`.`description`, `mi_tr`.`caution_before`, `mi_tr`.`caution_after`, `mi_u`.`name` as `user_name`, `mi_c`.`slug` as `clinic_slug` from `mi_promotion` left join `mi_promotion_trans` as `mi_tr` on `mi_tr`.`promotion_id` = `mi_promotion`.`id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_promotion`.`user_id` left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_promotion`.`clinic_id` where `mi_tr`.`lang_id` = 'id' order by RAND() limit 111.95ms/app/Composers/PromotionComposer.php:114lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
        Backtrace
        • 15. /app/Composers/PromotionComposer.php:114
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::frontend.review.detail:379
      • select `mi_review`.`id`, `mi_review`.`slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`slug` as `clinic_slug`, `mi_u`.`username` as `user_name` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'id' left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_review`.`user_id` where `mi_review`.`category_id` = 41 and `mi_review`.`id` <> 179 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 46.71ms/app/Composers/ReviewComposer.php:413lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. id
        • 3. 41
        • 4. 179
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:413
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.review.detail:383
      • select `mi_post`.`id`, `mi_post`.`slug`, `mi_post`.`image`, `mi_post`.`user_id`, `mi_post`.`category_id`, `mi_post`.`hit`, `mi_post`.`order_no`, `mi_post`.`meta_title`, `mi_post`.`meta_desc`, `mi_post`.`created_at`, `mi_post`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_post`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_post`.`content`) as `content` from `mi_post` left join `mi_post_trans` as `mi_trans` on `mi_trans`.`post_id` = `mi_post`.`id` and `mi_trans`.`lang_id` = 'id' limit 310.89ms/app/Composers/MainComposer.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/MainComposer.php:236
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.review.detail:387
      • select `mi_promotion`.*, IFNULL(`mi_pt`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`title`,`mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`description`,`mi_promotion`.`description`) AS `description`, IFNULL(`mi_pt`.`caution_before`,`mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`,`mi_promotion`.`caution_after`) AS `caution_after`, `mi_clinic`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `clinic_name` from `mi_promotion` left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'id' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'id' where `mi_promotion`.`category_id` = 41 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 47.83ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. id
        • 2. 41
        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.59ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/Composers/PromotionComposer.php:82
        • 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90
      • select `mi_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'id' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc6.21ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\Post
      3
      App\Model\Promotion
      5
      App\Model\User
      1
      App\Model\ImagesReview
      1
      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
          rtLWz6QSc29HyoxhdQpaxpxXy9DbN5dPtuVxJWBI
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /id/review/seouleaguer-dermatology/aesthetics-up
          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.222.142.215" "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" => "51679" "REDIRECT_URL" => "/id/review/seouleaguer-dermatology/aesthetics-up" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/id/review/seouleaguer-dermatology/aesthetics-up" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740477223.068 "REQUEST_TIME" => 1740477223 ]
          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:53:43 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjRHd0ppZDBRR2dDWUZCbXV5UWt1XC9RPT0iLCJ2YWx1ZSI6Im9WV21NXC9sNkJkdFdDbUt1RGx4MDJXUHRmR3N0Mkc1SXJSMm16aXpLeUFHVmZ5SWN0NWtIS21UbmpMbmNEdkc2IiwibWFjIjoiOGQ3MjQxMDhkM2E3NmYwNmE3OGUxMDQyM2I2OGRhNDg4ZmE5YTFiZWQyYWM3OTlkYWZlZTQ0ODY1YTJkZGJlYiJ9; expires=Tue, 25-Feb-2025 11:53:43 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjRHd0ppZDBRR2dDWUZCbXV5UWt1XC9RPT0iLCJ2YWx1ZSI6Im9WV21NXC9sNkJkdFdDbUt1RGx4MDJXUHRmR3N0Mkc1SXJSMm16aXpLeUFHVmZ5SWN0NWtIS21UbmpMbmNEdkc2Iiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjRHd0ppZDBRR2dDWUZCbXV5UWt1XC9RPT0iLCJ2YWx1ZSI6Im9WV21NXC9sNkJkdFdDbUt1RGx4MDJXUHRmR3N0Mkc1SXJSMm16aXpLeUFHVmZ5SWN0NWtIS21UbmpMbmNEdkc2IiwibWFjIjoiOGQ3MjQxMDhkM2E3NmYwNmE3OGUxMDQyM2I2OGRhNDg4ZmE5YTFiZWQyYWM3OTlkYWZlZTQ0ODY1YTJkZGJlYiJ9; expires=Tue, 25-Feb-2025 11:53:43 GMT; path=/XSRF-TOKEN=eyJpdiI6IjRHd0ppZDBRR2dDWUZCbXV5UWt1XC9RPT0iLCJ2YWx1ZSI6Im9WV21NXC9sNkJkdFdDbUt1RGx4MDJXUHRmR3N0Mkc1SXJSMm16aXpLeUFHVmZ5SWN0NWtIS21UbmpMbmNEdkc2Iiwib" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "rtLWz6QSc29HyoxhdQpaxpxXy9DbN5dPtuVxJWBI" "PHPDEBUGBAR_STACK_DATA" => [] ]