Korean Time
Home Promotion SMAS Full Facelift
Recent View
  • Nothing to show
SMAS Full Facelift
Apgujeong Seoul Plastic Surgery
Period : Jul 01 2019 ~ Sep 30 2019
SMAS Full Facelift
Satisfaction
Price $ 13,983 $ 13,983

Pre paid $ 1,398

Clinic Pay $ 12,585

Promotion banner

Duration 11N12D

(Approx. 15,000USD)

*Amount will be calculated in KRW on the day. 

SMAS Full Facelift

User rating

0

0%
0%
0%
0%
0%
Please Login to leave question!
No. Question & Answer Member Date Status
No Result

Surgery Information

Surgery duration3 -
Anesthesia -
Hospitalization -
Removal of stitches -
Number of postoperative visits -
Recovery period -

Provided Service

Medicine -
Post-care Treatment -
Transportation -
Language -
Hospitalization -
Others -

Conditions

Conditions -

Precautions before / after surgery

Caution before surgery

  • 1. Do not eat or drink (including candy, gum and water) at least 4 hours for sedation anesthesia and at least 10 hours for general anesthesia.
  • 2. Please remove make up, accessories and manicure before visiting the clinic.
  • 3. Do not smoke and drink alcohol preferably 1 week before surgery.
  • 4. A cap and a pair of sunglasses will be useful to cover up post surgery.
  • 5. Please do not drive on the day of the surgery as post surgery may cause dizziness.
  • 6. Please inform the clinic if you are having a cold or taking medication. Medication may hinder the surgery or recovery process.
  • 7. Do not take vitamin E, omega 3, hormone pills, oriental herbs, aspirin and other health supplements 2 weeks before surgery. Long term medication such as blood pressure, thyroid, diabetes etc, are allowed to be taken and should inform the clinic in advance.
    Birth control pills are also recommended to stop

Caution after surgery

  • 1. Swelling
    - After the surgery, there will be general swelling and bruising for 2-3 days. They will be subsided as time goes by.
    - It is recommended to lie straight down on your back and position your head higher than your heart for faster recovery. Please avoid lying face down.
  • 2. Cold pack
    - Please apply cold pack for 3 days after surgery. It will help swelling and bruising to subside faster.
    - Please apply the cold pack about 5~6 times for 30 minutes each time per day.
  • 3. Maintain cleanliness
    - Please do not touch or rub the surgical area. It may cause infection and may affect the recovery and result.
    - Please do not remove any bandages or cast or cottons on the surgical area until a nurse does it.
  • 4. Scar
    - There will not be any visible scars with non-incisional surgeries such as non-incisional double eyelids surgery with Ptosis correction. But, occasionally whiteheads/ pus could occur, if so, please visit the clinic to remove it.
    - In case of incisional surgeries, scar cream can be applied after stitches removal if the doctor advises so.
  • 5. Medicine
    - Clinics will prescribe medicine which usually consists of antibiotics, pain killers and anti-inflammatory.
    Additional costs for medication may be required. Please avoid any aspirin related medicine because it may cause bleeding.
  • 6. Wash and Makeup
    - You may wash your face and do make-up after the stitches removed. Do not rub around the surgical area when you remove make-up.
    - Showers can be done on the next day of the stitches removal, but please avoid sauna or hot bath for 4 weeks.
  • 7. Exercise and after care
    - Taking walks are recommended for faster recovery. However, heavy exercises are only possible after 3-4 weeks.
    - Please avoid wearing contact lenses for 3 weeks and wear glasses or sunglasses (except rhinoplasty) during this period.
    - Drinking and smoking should be avoided for 4 weeks. It can cause infection or delay the recovery process.

Promotion process

Promotion Process

Cancellation policy

Surgery deposit payments are non-cancellable nor refundable.

Please consider carefully before making decision.

7.2.34PHP Version120msRequest Duration9MBMemory UsageGET {lang}/promotion/{clinic}/{slug}RouteAuth status
    • Booting (31.99ms)
    • Application (87.62ms)
    • 1 x Application (73.12%)
      87.62ms
      1 x Booting (26.7%)
      31.99ms
      13 templates were rendered
      • frontend.promotion.detail (resources/views/frontend/promotion/detail.blade.php)13blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        recents
        4
        groups
        5
        data
        6
        reviews
        7
        qa
        8
        wished
        9
        liked
        10
        pageTitle
        11
        pageDesc
        12
        pageImage
      • partials.shortcode.promotion_horizontal (resources/views/partials/shortcode/promotion_horizontal.blade.php)48blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        title
        35
        clinic_id
        36
        not_id
        37
        limit
        38
        showCats
        39
        cat
        40
        category_id
        41
        type
        42
        list
        43
        rMenuType
        44
        cats
        45
        showBest
        46
        showHotDeal
        47
        showAll
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        limit
        35
        category_id
        36
        title
        37
        showMenu
        38
        showBest
        39
        clinic_id
        40
        cat
        41
        type
        42
        not_id
        43
        list
        44
        rMenuType
        45
        showCats
        46
        cats
        47
        showHotDeal
        48
        showAll
      • partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        limit
        35
        category_id
        36
        title
        37
        showMenu
        38
        showBest
        39
        clinic_id
        40
        promotion_id
        41
        doctor_id
        42
        type
        43
        cat
        44
        list
        45
        rMenuType
        46
        showCats
        47
        cats
        48
        showAll
      • layouts.frontend (resources/views/layouts/frontend.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
      • partials.frontend.header (resources/views/partials/frontend/header.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)42blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
        36
        group
        37
        showImg
        38
        limit
        39
        list
        40
        showTitle
        41
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      uri
      GET {lang}/promotion/{clinic}/{slug}
      middleware
      web, lang, redirect.tomobile
      controller
      App\Http\Controllers\Frontend\PromotionController@show
      namespace
      App\Http\Controllers\Frontend
      prefix
      /{lang}
      where
      file
      app/Http/Controllers/Frontend/PromotionController.php:85-257
      23 statements were executed, 3 of which were duplicated, 20 unique25.79ms
      • 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'2.2ms/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/PromotionController.php:21
        • 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` desc650μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Http/Controllers/Shared/TransController.php:38
        • 15. /app/Http/Controllers/Shared/TransController.php:20
        • 16. /app/Http/Controllers/FrontendController.php:39
        • 17. /app/Http/Controllers/Frontend/PromotionController.php:21
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 order by `id` desc520μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Shared/TransController.php:45
        • 15. /app/Http/Controllers/Shared/TransController.php:21
        • 16. /app/Http/Controllers/FrontendController.php:39
        • 17. /app/Http/Controllers/Frontend/PromotionController.php:21
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 1510μsmiddleware::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_promotion`.`id`, IFNULL(`mi_pt`.`title`, `mi_promotion`.`title`) AS `title`, `mi_promotion`.`slug`, `mi_promotion`.`category_id`, `mi_promotion`.`clinic_id`, `mi_promotion`.`user_id`, `mi_promotion`.`doctor_id`, `mi_promotion`.`price_pre`, `mi_promotion`.`price_after`, `mi_promotion`.`price_prepaid`, `mi_promotion`.`price_clinicpaid`, `mi_promotion`.`discount`, IFNULL(`mi_pt`.`description`, `mi_promotion`.`description`) AS `description`, `mi_promotion`.`hit`, `mi_promotion`.`like_hit`, `mi_promotion`.`share_hit`, `mi_promotion`.`comment_hit`, 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`.`caution_before`, `mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`, `mi_promotion`.`caution_after`) AS `caution_after`, `mi_promotion`.`date_start`, `mi_promotion`.`date_end`, `mi_promotion`.`book_limit`, `mi_promotion`.`meta_title`, `mi_promotion`.`meta_desc`, COUNT(mi_or.id) AS book_count from `mi_promotion` left join `mi_order` as `mi_or` on `mi_or`.`parent_id` = `mi_promotion`.`id` and `mi_or`.`parent_type` = 'promotion' left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'en' where `mi_promotion`.`slug` = 'smas-full-facelift' limit 11.75ms/app/Http/Controllers/Frontend/PromotionController.php:127lv_misooda_dev
        Metadata
        Bindings
        • 0. promotion
        • 1. en
        • 2. smas-full-facelift
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Http/Controllers/Frontend/PromotionController.php:127
        • 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
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select * from `mi_clinic` where `mi_clinic`.`id` = 10 limit 1760μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 10
        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/PromotionController.php:129
        • 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 IFNULL(`mi_tr2`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, `mi_tr2`.`title`, `mi_promotion`.`slug`, `mi_cl`.`slug` as `clinic_slug` from `mi_promotion` left join `mi_clinic` as `mi_cl` on `mi_cl`.`id` = `mi_promotion`.`clinic_id` left join `mi_promotion_trans` as `mi_tr2` on `mi_tr2`.`promotion_id` = `mi_promotion`.`id` where `mi_tr2`.`lang_id` = 'en' and `mi_promotion`.`id` <> 238 and `mi_promotion`.`id` in (238) limit 3760μs/app/Http/Controllers/Frontend/PromotionController.php:195lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 238
        • 2. 238
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Http/Controllers/Frontend/PromotionController.php:195
        • 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_pr_question_gr`.`id`, `mi_tr1`.`title` from `mi_pr_question_gr` left join `mi_pr_question_gr_trans` as `mi_tr1` on `mi_tr1`.`pr_q_gid` = `mi_pr_question_gr`.`id` where `mi_tr1`.`lang_id` = 'en'1ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        Backtrace
        • 14. /app/Http/Controllers/Frontend/PromotionController.php:214
        • 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_pr_question`.*, `mi_tr`.`question` from `mi_pr_question` left join `mi_pr_question_trans` as `mi_tr` on `mi_tr`.`pr_q_id` = `mi_pr_question`.`id` where `mi_pr_question`.`group_id` in (3, 4, 5) and `mi_tr`.`lang_id` = 'en'1.11ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        Backtrace
        • 19. /app/Http/Controllers/Frontend/PromotionController.php:214
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `mi_pr_answer`.*, `mi_tr`.`answer` from `mi_pr_answer` left join `mi_pr_answer_trans` as `mi_tr` on `mi_tr`.`pr_ans_id` = `mi_pr_answer`.`id` where `mi_pr_answer`.`question_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15) and `mi_tr`.`lang_id` = 'en' and `mi_pr_answer`.`promotion_id` = 2384.42ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 238
        Backtrace
        • 24. /app/Http/Controllers/Frontend/PromotionController.php:214
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select * from `mi_review` where `promotion_id` = 238830μs/app/Http/Controllers/Frontend/PromotionController.php:221lv_misooda_dev
        Metadata
        Bindings
        • 0. 238
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/PromotionController.php:221
        • 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_promotion_qa`.*, `mi_user`.`username` as `username` from `mi_promotion_qa` left join `mi_user` on `mi_user`.`id` = `mi_promotion_qa`.`user_id` where `promotion_id` = 238840μs/app/Http/Controllers/Frontend/PromotionController.php:227lv_misooda_dev
        Metadata
        Bindings
        • 0. 238
        Backtrace
        • 14. /app/Http/Controllers/Frontend/PromotionController.php:227
        • 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_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`.`clinic_id` = 10 and `mi_promotion`.`id` <> 238 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 21.4ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 10
        • 3. 238
        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.promotion.detail:449
      • select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc930μs/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Composers/PromotionComposer.php:79
        • 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.promotion.detail:449
      • 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` = 28 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.21ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 28
        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.promotion.detail:464
      • select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc780μs/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Composers/PromotionComposer.php:79
        • 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.promotion.detail:464
      • select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`rating_01`, `mi_review`.`rating_01`) AS `rating_01`, IFNULL(`mi_rt`.`rating_02`, `mi_review`.`rating_02`) AS `rating_02`, IFNULL(`mi_rt`.`rating_03`, `mi_review`.`rating_03`) AS `rating_03`, IFNULL(`mi_rt`.`rating_04`, `mi_review`.`rating_04`) AS `rating_04`, IFNULL(`mi_rt`.`rating_05`, `mi_review`.`rating_05`) AS `rating_05`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`id` as `clinic_id`, `mi_c`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`, `mi_c`.`name`) AS `clinic_name`, `mi_user`.`id` as `user_id`, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`country`, `mi_user`.`profile_image`, `mi_category`.`id` as `cat_id`, IFNULL(`mi_cat_t`.`title`, `mi_category`.`title`) AS `cat_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' inner join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_c`.`id` and `mi_ct`.`lang_id` = 'en' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` inner join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_cat_t` on `mi_cat_t`.`cat_id` = `mi_category`.`id` and `mi_cat_t`.`lang_id` = 'en' where `mi_review`.`category_id` = 28 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 51.49ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. en
        • 3. en
        • 4. en
        • 5. 28
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:97
        • 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.promotion.detail:472
      • select * from `mi_images_review` where `review_id` = 354 and `flag` = 'after' limit 7690μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 354
        • 1. after
        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
        • 14. /app/Composers/ReviewComposer.php:104
        • 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.promotion.detail:472
      • select * from `mi_images_review` where `review_id` = 440 and `flag` = 'after' limit 7570μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 440
        • 1. after
        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
        • 14. /app/Composers/ReviewComposer.php:104
        • 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.promotion.detail:472
      • select * from `mi_images_review` where `review_id` = 427 and `flag` = 'after' limit 7520μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 427
        • 1. after
        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
        • 14. /app/Composers/ReviewComposer.php:104
        • 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.promotion.detail:472
      • select * from `mi_images_review` where `review_id` = 414 and `flag` = 'after' limit 7570μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 414
        • 1. after
        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
        • 14. /app/Composers/ReviewComposer.php:104
        • 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.promotion.detail:472
      • select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc1.06ms/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:121
        • 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.promotion.detail:472
      • 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` desc1.22ms/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\ImagesReview
      4
      App\Model\Review
      4
      App\Model\Category
      33
      App\Model\PromotionQuestion
      13
      App\Model\PromotionQuestionGroup
      3
      App\Model\Clinic
      1
      App\Model\Promotion
      7
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          nVh7OOQiCKmsQIWDNUQMT389o0V32Knnrpgc1EN7
          user
          array:1 [ "promotions" => array:1 [ 0 => 238 ] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/promotion/apgujeong-seoul-plastic-surgery/smas-full-facelift
          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" => "30862" "REDIRECT_URL" => "/en/promotion/apgujeong-seoul-plastic-surgery/smas-full-facelift" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en/promotion/apgujeong-seoul-plastic-surgery/smas-full-facelift" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740258540.037 "REQUEST_TIME" => 1740258540 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 22 Feb 2025 21:09:00 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InJFRFJOK3JpNlQ3bXV5OHlEK2w1ZHc9PSIsInZhbHVlIjoiNW0xZ2h2d0VrU0ZFM1c1OUUzeEFuK24zTHZMRU8raHdmMWFDVVZmdVhmcTRRZVh5SEdmcVRxUUdRUllcL3ZIMTYiLCJtYWMiOiJmMTM3ZWY2NjFhZjdjNzMzOTBmNjE0ZDBiNjI3NjJlOWViM2JmOTljY2Q5MDBkNDU5NDM0Mzc3NjEyYTc4OGFkIn0%3D; expires=Sat, 22-Feb-2025 23:09:00 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InJFRFJOK3JpNlQ3bXV5OHlEK2w1ZHc9PSIsInZhbHVlIjoiNW0xZ2h2d0VrU0ZFM1c1OUUzeEFuK24zTHZMRU8raHdmMWFDVVZmdVhmcTRRZVh5SEdmcVRxUUdRUllcL3ZIMTYiLCJtY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InJFRFJOK3JpNlQ3bXV5OHlEK2w1ZHc9PSIsInZhbHVlIjoiNW0xZ2h2d0VrU0ZFM1c1OUUzeEFuK24zTHZMRU8raHdmMWFDVVZmdVhmcTRRZVh5SEdmcVRxUUdRUllcL3ZIMTYiLCJtYWMiOiJmMTM3ZWY2NjFhZjdjNzMzOTBmNjE0ZDBiNjI3NjJlOWViM2JmOTljY2Q5MDBkNDU5NDM0Mzc3NjEyYTc4OGFkIn0%3D; expires=Sat, 22-Feb-2025 23:09:00 GMT; path=/XSRF-TOKEN=eyJpdiI6InJFRFJOK3JpNlQ3bXV5OHlEK2w1ZHc9PSIsInZhbHVlIjoiNW0xZ2h2d0VrU0ZFM1c1OUUzeEFuK24zTHZMRU8raHdmMWFDVVZmdVhmcTRRZVh5SEdmcVRxUUdRUllcL3ZIMTYiLCJtY" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "nVh7OOQiCKmsQIWDNUQMT389o0V32Knnrpgc1EN7" "user" => array:1 [ "promotions" => array:1 [ 0 => 238 ] ] "PHPDEBUGBAR_STACK_DATA" => [] ]