view gần nhất
  • Không có nội dung
New Promotion
GIRIN Plastic Surgery
Thòi gian : May 01 2020 ~ May 31 2020
New Promotion
Mức độ hài lòng
Giá cả ₫ 0 ₫ 1

Trả trước ₫ 0

Thanh toán tại bệnh viện ₫ 0

Promotion banner
New Promotion

Đá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
Không tìm thấy kết quả

-

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

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

Xem đợt khuyến mại khác của bệnh viện

7.2.34PHP Version268msRequest Duration9MBMemory UsageGET {lang}/promotion/{clinic}/{slug}RouteAuth status
    • Booting (87.16ms)
    • Application (180ms)
    • 1 x Application (67.37%)
      180.44ms
      1 x Booting (32.54%)
      87.16ms
      13 templates were rendered
      • frontend.promotion.detail (resources/views/frontend/promotion/detail.blade.php)13blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        recents
        4
        groups
        5
        data
        6
        reviews
        7
        qa
        8
        wished
        9
        liked
        10
        pageTitle
        11
        pageDesc
        12
        pageImage
      • partials.shortcode.promotion_horizontal (resources/views/partials/shortcode/promotion_horizontal.blade.php)48blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        title
        35
        clinic_id
        36
        not_id
        37
        limit
        38
        showCats
        39
        cat
        40
        category_id
        41
        type
        42
        list
        43
        rMenuType
        44
        cats
        45
        showBest
        46
        showHotDeal
        47
        showAll
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        limit
        35
        category_id
        36
        title
        37
        showMenu
        38
        showBest
        39
        clinic_id
        40
        cat
        41
        type
        42
        not_id
        43
        list
        44
        rMenuType
        45
        showCats
        46
        cats
        47
        showHotDeal
        48
        showAll
      • partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        limit
        35
        category_id
        36
        title
        37
        showMenu
        38
        showBest
        39
        clinic_id
        40
        promotion_id
        41
        doctor_id
        42
        type
        43
        cat
        44
        list
        45
        rMenuType
        46
        showCats
        47
        cats
        48
        showAll
      • layouts.frontend (resources/views/layouts/frontend.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
      • partials.frontend.header (resources/views/partials/frontend/header.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)42blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
        36
        group
        37
        showImg
        38
        limit
        39
        list
        40
        showTitle
        41
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        recents
        10
        groups
        11
        data
        12
        reviews
        13
        qa
        14
        wished
        15
        liked
        16
        pageTitle
        17
        pageDesc
        18
        pageImage
        19
        rCount
        20
        r1_count
        21
        r2_count
        22
        r3_count
        23
        r4_count
        24
        r5_count
        25
        rTotal
        26
        rAvg
        27
        __currentLoopData
        28
        loop
        29
        i
        30
        surl
        31
        percent
        32
        g
        33
        q
        34
        header
        35
        footer
      uri
      GET {lang}/promotion/{clinic}/{slug}
      middleware
      web, lang, redirect.tomobile
      controller
      App\Http\Controllers\Frontend\PromotionController@show
      namespace
      App\Http\Controllers\Frontend
      prefix
      /{lang}
      where
      file
      app/Http/Controllers/Frontend/PromotionController.php:85-257
      24 statements were executed, 3 of which were duplicated, 21 unique82.63ms
      • 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'2.8ms/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` desc2.04ms/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` desc8.5ms/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 14.7msmiddleware::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` = 'new-promotion-1' limit 15.03ms/app/Http/Controllers/Frontend/PromotionController.php:127lv_misooda_dev
        Metadata
        Bindings
        • 0. promotion
        • 1. vi
        • 2. new-promotion-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` = 51 limit 11.54ms/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 51
        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` <> 252 and `mi_promotion`.`id` in (252) limit 31.88ms/app/Http/Controllers/Frontend/PromotionController.php:195lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. 252
        • 2. 252
        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'2.14ms/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'6.04ms/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` = 2521.36ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. 252
        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` = 252960μs/app/Http/Controllers/Frontend/PromotionController.php:221lv_misooda_dev
        Metadata
        Bindings
        • 0. 252
        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` = 2521.75ms/app/Http/Controllers/Frontend/PromotionController.php:227lv_misooda_dev
        Metadata
        Bindings
        • 0. 252
        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` = 51 and `mi_promotion`.`id` <> 252 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 26.33ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 2. 51
        • 3. 252
        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.53ms/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` = 48 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 43.1ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. vi
        • 2. 48
        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` asc2.56ms/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` = 48 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 59.75ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. vi
        • 3. vi
        • 4. vi
        • 5. 48
        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` = 456 and `flag` = 'after' limit 72.52ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 456
        • 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` = 359 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 359
        • 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` = 408 and `flag` = 'after' limit 7500μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 408
        • 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` = 395 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 395
        • 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` = 290 and `flag` = 'after' limit 76.34ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 290
        • 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` asc1.26ms/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` desc9.1ms/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\PromotionQuestion
      1
      App\Model\PromotionQuestionGroup
      1
      App\Model\Clinic
      1
      App\Model\Promotion
      6
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          9hgMbSjVqILgXoXxZWhadFWZUbmk8KsO4szJ16PU
          user
          array:1 [ "promotions" => array:1 [ 0 => 252 ] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /vi/promotion/girin-plastic-surgery/new-promotion-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" => "18.188.83.180" "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" => "27035" "REDIRECT_URL" => "/vi/promotion/girin-plastic-surgery/new-promotion-1" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/vi/promotion/girin-plastic-surgery/new-promotion-1" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745476706.087 "REQUEST_TIME" => 1745476706 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 24 Apr 2025 06:38:26 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InlVZTZ2ZWlTdzM2ZG1xM1lsQlY0OWc9PSIsInZhbHVlIjoiMnd3S3JET1BlV21cL1Bha2pzb0pib0d2V0V3YXJTdlU2MXBRbTBIY0FQOVVNNVg0dlRuMFBhRFwvUVE1eTk3VSs0IiwibWFjIjoiNTAwODQzNDY1OGY3YmJhNGE5MjkwNTFmOTdiZDEzMTc4ZjQyNmYxYTYwN2ZmZDgwMzZmY2Q4NDhkYWY5ZDFmYiJ9; expires=Thu, 24-Apr-2025 08:38:26 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InlVZTZ2ZWlTdzM2ZG1xM1lsQlY0OWc9PSIsInZhbHVlIjoiMnd3S3JET1BlV21cL1Bha2pzb0pib0d2V0V3YXJTdlU2MXBRbTBIY0FQOVVNNVg0dlRuMFBhRFwvUVE1eTk3VSs0Iiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InlVZTZ2ZWlTdzM2ZG1xM1lsQlY0OWc9PSIsInZhbHVlIjoiMnd3S3JET1BlV21cL1Bha2pzb0pib0d2V0V3YXJTdlU2MXBRbTBIY0FQOVVNNVg0dlRuMFBhRFwvUVE1eTk3VSs0IiwibWFjIjoiNTAwODQzNDY1OGY3YmJhNGE5MjkwNTFmOTdiZDEzMTc4ZjQyNmYxYTYwN2ZmZDgwMzZmY2Q4NDhkYWY5ZDFmYiJ9; expires=Thu, 24-Apr-2025 08:38:26 GMT; path=/XSRF-TOKEN=eyJpdiI6InlVZTZ2ZWlTdzM2ZG1xM1lsQlY0OWc9PSIsInZhbHVlIjoiMnd3S3JET1BlV21cL1Bha2pzb0pib0d2V0V3YXJTdlU2MXBRbTBIY0FQOVVNNVg0dlRuMFBhRFwvUVE1eTk3VSs0Iiwib" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "9hgMbSjVqILgXoXxZWhadFWZUbmk8KsO4szJ16PU" "user" => array:1 [ "promotions" => array:1 [ 0 => 252 ] ] "PHPDEBUGBAR_STACK_DATA" => [] ]