Korean Time
Home Promotion Arm Liposuction
Recent View
  • Nothing to show
Arm Liposuction
The Class & Mizain Plastic Surgery
Period : Jul 01 2019 ~ Sep 30 2019
Arm Liposuction
Satisfaction
Price $ 1,568 $ 2,119

Pre paid $ 0

Clinic Pay $ 1,411

Promotion banner
Arm Liposuction

User rating

0

0%
0%
0%
0%
0%
Please Login to leave question!
No. Question & Answer Member Date Status
1 rwqrqwr 123456456 2017-10-31 Not answered
2 how long do I have to come to the clnic? 123456456 2017-11-07 Answered

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 Version264msRequest Duration9MBMemory UsageGET {lang}/promotion/{clinic}/{slug}RouteAuth status
    • Booting (59.33ms)
    • Application (204ms)
    • 1 x Application (77.4%)
      203.97ms
      1 x Booting (22.51%)
      59.33ms
      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)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
        qaItem
        33
        g
        34
        q
        35
        title
        36
        clinic_id
        37
        not_id
        38
        limit
        39
        showCats
        40
        cat
        41
        category_id
        42
        type
        43
        list
        44
        rMenuType
        45
        cats
        46
        showBest
        47
        showHotDeal
        48
        showAll
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)50blade
        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
        qaItem
        33
        g
        34
        q
        35
        limit
        36
        category_id
        37
        title
        38
        showMenu
        39
        showBest
        40
        clinic_id
        41
        cat
        42
        type
        43
        not_id
        44
        list
        45
        rMenuType
        46
        showCats
        47
        cats
        48
        showHotDeal
        49
        showAll
      • partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)50blade
        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
        qaItem
        33
        g
        34
        q
        35
        limit
        36
        category_id
        37
        title
        38
        showMenu
        39
        showBest
        40
        clinic_id
        41
        promotion_id
        42
        doctor_id
        43
        type
        44
        cat
        45
        list
        46
        rMenuType
        47
        showCats
        48
        cats
        49
        showAll
      • layouts.frontend (resources/views/layouts/frontend.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
        qaItem
        33
        g
        34
        q
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.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
        qaItem
        33
        g
        34
        q
      • partials.frontend.header (resources/views/partials/frontend/header.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
        qaItem
        33
        g
        34
        q
        35
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)37blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)43blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        footer
        37
        group
        38
        showImg
        39
        limit
        40
        list
        41
        showTitle
        42
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)37blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)37blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)37blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)37blade
        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
        qaItem
        33
        g
        34
        q
        35
        header
        36
        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
      24 statements were executed, 3 of which were duplicated, 21 unique90.28ms
      • 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'12.15ms/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` desc5.24ms/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` desc7.05ms/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 11.7msmiddleware::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` = 'arm-liposuction-1' limit 15.36ms/app/Http/Controllers/Frontend/PromotionController.php:127lv_misooda_dev
        Metadata
        Bindings
        • 0. promotion
        • 1. en
        • 2. arm-liposuction-1
        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` = 56 limit 17.15ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 56
        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` <> 143 and `mi_promotion`.`id` in (143) limit 31.42ms/app/Http/Controllers/Frontend/PromotionController.php:195lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 143
        • 2. 143
        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'1.59ms/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.29ms/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` = 1438.28ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 143
        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` = 1432.41ms/app/Http/Controllers/Frontend/PromotionController.php:221lv_misooda_dev
        Metadata
        Bindings
        • 0. 143
        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` = 143710μs/app/Http/Controllers/Frontend/PromotionController.php:227lv_misooda_dev
        Metadata
        Bindings
        • 0. 143
        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` = 56 and `mi_promotion`.`id` <> 143 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 22.36ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 56
        • 3. 143
        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` asc10.07ms/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` = 40 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.47ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. en
        • 2. 40
        Backtrace
        • 14. /app/Composers/PromotionComposer.php:66
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.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` asc950μ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` = 40 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 58.11ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. en
        • 3. en
        • 4. en
        • 5. 40
        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` = 339 and `flag` = 'after' limit 7700μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 339
        • 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` = 452 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 452
        • 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` = 448 and `flag` = 'after' limit 7390μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 448
        • 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` = 445 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 445
        • 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` = 438 and `flag` = 'after' limit 7380μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 438
        • 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` asc740μs/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` desc9.9ms/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
      5
      App\Model\Review
      5
      App\Model\Category
      33
      App\Model\PromotionQa
      2
      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
          e4OFxx02UdIWd3VVa2R25kL0iESE0yyM6zGs5P9o
          user
          array:1 [ "promotions" => array:1 [ 0 => 143 ] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/promotion/mizain-plastic-surgery/arm-liposuction-1
          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.17.23.48" "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" => "29124" "REDIRECT_URL" => "/en/promotion/mizain-plastic-surgery/arm-liposuction-1" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en/promotion/mizain-plastic-surgery/arm-liposuction-1" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746273705.41 "REQUEST_TIME" => 1746273705 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 03 May 2025 12:01:45 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJBczk3XC90ZnJNYmVaeWo2R0FGNjd3PT0iLCJ2YWx1ZSI6IlwvTmtnS3ZBanZGODdxdWkwQnl0OEcxdVJaOGlMdTFLeHBmbjZZQkRRMzErem9MM0FRSG9cL29HRTVlTDRDZG1sRiIsIm1hYyI6IjIwNzQyZTYwNDdhMzNhYzI4MGVhNWY1MDM5Y2M2MmIyOWQ2MTVhNzE5N2MyMTA2ODQwOTA2MTQxZjg4NDE4M2IifQ%3D%3D; expires=Sat, 03-May-2025 14:01:45 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjJBczk3XC90ZnJNYmVaeWo2R0FGNjd3PT0iLCJ2YWx1ZSI6IlwvTmtnS3ZBanZGODdxdWkwQnl0OEcxdVJaOGlMdTFLeHBmbjZZQkRRMzErem9MM0FRSG9cL29HRTVlTDRDZG1sRiIsI" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJBczk3XC90ZnJNYmVaeWo2R0FGNjd3PT0iLCJ2YWx1ZSI6IlwvTmtnS3ZBanZGODdxdWkwQnl0OEcxdVJaOGlMdTFLeHBmbjZZQkRRMzErem9MM0FRSG9cL29HRTVlTDRDZG1sRiIsIm1hYyI6IjIwNzQyZTYwNDdhMzNhYzI4MGVhNWY1MDM5Y2M2MmIyOWQ2MTVhNzE5N2MyMTA2ODQwOTA2MTQxZjg4NDE4M2IifQ%3D%3D; expires=Sat, 03-May-2025 14:01:45 GMT; path=/XSRF-TOKEN=eyJpdiI6IjJBczk3XC90ZnJNYmVaeWo2R0FGNjd3PT0iLCJ2YWx1ZSI6IlwvTmtnS3ZBanZGODdxdWkwQnl0OEcxdVJaOGlMdTFLeHBmbjZZQkRRMzErem9MM0FRSG9cL29HRTVlTDRDZG1sRiIsI" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "e4OFxx02UdIWd3VVa2R25kL0iESE0yyM6zGs5P9o" "user" => array:1 [ "promotions" => array:1 [ 0 => 143 ] ] "PHPDEBUGBAR_STACK_DATA" => [] ]