view gần nhất
  • Không có nội dung
Arm Liposuction
The Class & Mizain Plastic Surgery
Thòi gian : Jul 01 2019 ~ Sep 30 2019
Arm Liposuction
Mức độ hài lòng
Giá cả ₫ 1,568 ₫ 2,119

Trả trước ₫ 0

Thanh toán tại bệnh viện ₫ 1,411

Promotion banner
Arm Liposuction

Đánh giá của người sử dụng

0

0%
0%
0%
0%
0%
Hãy đăng nhập để tư vấn
No. Câu hỏi & Trả lời Hội viên Ngày Trạng thái
1 rwqrqwr 123456456 2017-10-31 Chưa trả lời
2 how long do I have to come to the clnic? 123456456 2017-11-07 Trả lời hoàn tất

-

Lưu ý trước / sau phẫu thuật

Lưu ý trước phẫu thuật

  • 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

Lưu ý sau phẫu thuật

  • 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.

Các bước tiến hành giảm giá

Promotion Process

Chính sách hủy

Tiền đặt cọc không thể hủy tức là Không trả lại tiền đã đặt cọc

Hãy cân nhắc thật kỹ trước khi mua

7.2.34PHP Version192msRequest Duration9MBMemory UsageGET {lang}/promotion/{clinic}/{slug}RouteAuth status
    • Booting (70.91ms)
    • Application (120ms)
    • 1 x Application (62.83%)
      120.32ms
      1 x Booting (37.03%)
      70.91ms
      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 unique37.42ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'vi'1.92ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/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` desc730μ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` desc590μ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` = 'vi' limit 1690μsmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. vi
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_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` = 'vi' where `mi_promotion`.`slug` = 'arm-liposuction-1' limit 12.14ms/app/Http/Controllers/Frontend/PromotionController.php:127lv_misooda_dev
        Metadata
        Bindings
        • 0. promotion
        • 1. vi
        • 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 1590μs/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` = 'vi' and `mi_promotion`.`id` <> 143 and `mi_promotion`.`id` in (143) limit 3490μs/app/Http/Controllers/Frontend/PromotionController.php:195lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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` = 'vi'930μs/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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) and `mi_tr`.`lang_id` = 'vi'1.08ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        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) and `mi_tr`.`lang_id` = 'vi' and `mi_pr_answer`.`promotion_id` = 1435.72ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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` = 143730μs/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` = 143830μ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` = 'vi' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'vi' where `mi_promotion`.`clinic_id` = 56 and `mi_promotion`.`id` <> 143 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 21.83ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 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` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc1.32ms/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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` = 'vi' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'vi' where `mi_promotion`.`category_id` = 40 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.76ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 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` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc1.25ms/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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` = 'vi' 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` = 'vi' 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` = 'vi' where `mi_review`.`category_id` = 40 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 51.97ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. vi
        • 3. vi
        • 4. vi
        • 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 7650μ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 7620μ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 7540μ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 7530μ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 7540μ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` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc990μs/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 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` = 'vi' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc8.98ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\ImagesReview
      5
      App\Model\Review
      5
      App\Model\Category
      33
      App\Model\PromotionQa
      2
      App\Model\PromotionQuestion
      1
      App\Model\PromotionQuestionGroup
      1
      App\Model\Clinic
      1
      App\Model\Promotion
      7
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          h25Yu6yKgMQunwOZTGAjFnyJuny4XI5Mz0umylKj
          user
          array:1 [ "promotions" => array:1 [ 0 => 143 ] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /vi/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" => "13.58.129.138" "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" => "15506" "REDIRECT_URL" => "/vi/promotion/mizain-plastic-surgery/arm-liposuction-1" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/vi/promotion/mizain-plastic-surgery/arm-liposuction-1" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745448828.308 "REQUEST_TIME" => 1745448828 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 23 Apr 2025 22:53:48 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IkMzc3JDdXFIaHhOc2piS1dvZXJUQWc9PSIsInZhbHVlIjoidlwvVnVmaWRFWmJJdmQyZnhYa0NBV3NDd00rODdIS1dmaXBPVVc1cUQyblBGTFFXMkpkR2hcLzRqMDZXVXBhVDZUIiwibWFjIjoiYmY5MTVjZjc2NjY4NGVmY2IxODJkZDdhYWYwOWMwZWY5OTJhZWUyMGYzNzRhNmM4ZmEyODQxY2ExYWY2ZjA3YyJ9; expires=Thu, 24-Apr-2025 00:53:48 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IkMzc3JDdXFIaHhOc2piS1dvZXJUQWc9PSIsInZhbHVlIjoidlwvVnVmaWRFWmJJdmQyZnhYa0NBV3NDd00rODdIS1dmaXBPVVc1cUQyblBGTFFXMkpkR2hcLzRqMDZXVXBhVDZUIiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IkMzc3JDdXFIaHhOc2piS1dvZXJUQWc9PSIsInZhbHVlIjoidlwvVnVmaWRFWmJJdmQyZnhYa0NBV3NDd00rODdIS1dmaXBPVVc1cUQyblBGTFFXMkpkR2hcLzRqMDZXVXBhVDZUIiwibWFjIjoiYmY5MTVjZjc2NjY4NGVmY2IxODJkZDdhYWYwOWMwZWY5OTJhZWUyMGYzNzRhNmM4ZmEyODQxY2ExYWY2ZjA3YyJ9; expires=Thu, 24-Apr-2025 00:53:48 GMT; path=/XSRF-TOKEN=eyJpdiI6IkMzc3JDdXFIaHhOc2piS1dvZXJUQWc9PSIsInZhbHVlIjoidlwvVnVmaWRFWmJJdmQyZnhYa0NBV3NDd00rODdIS1dmaXBPVVc1cUQyblBGTFFXMkpkR2hcLzRqMDZXVXBhVDZUIiwib" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "h25Yu6yKgMQunwOZTGAjFnyJuny4XI5Mz0umylKj" "user" => array:1 [ "promotions" => array:1 [ 0 => 143 ] ] "PHPDEBUGBAR_STACK_DATA" => [] ]