Korean Time
Beranda Promosi New Promotion
Terakhir Dilihat
  • Tidak ada yang bisa ditunjukkan
New Promotion
GIRIN Plastic Surgery
Periode : May 01 2020 ~ May 31 2020
New Promotion
Kepuasan
Harga Rp 0 Rp 1

Pra bayar Rp 0

Bayar Klinik Rp 0

Promotion banner
New Promotion

Penilaian Pengguna

0

0%
0%
0%
0%
0%
Harap Login untuk meninggalkan pertanyaan!
No. Pertanyaan & Jawaban Anggota Tanggal Status
Tidak ada hasil

-

Hal yang harus diperhatikan sebelum / sesudah operasi

Proses Promosi

Promotion Process

Kebijakan Pembatalan

Pembayaran Deposit Operasi tidak dapat dibatalkan atau dikembalikan.

Harap pertimbangkan dengan cermat sebelum membuat keputusan.

Promosi lainnya dari klinik ini

7.2.34PHP Version155msRequest Duration9MBMemory UsageGET {lang}/promotion/{clinic}/{slug}RouteAuth status
    • Booting (60.39ms)
    • Application (94.82ms)
    • 1 x Application (60.98%)
      94.82ms
      1 x Booting (38.84%)
      60.39ms
      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 unique18.18ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'id'1.36ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/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` desc510μ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` desc470μ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` = 'id' limit 1430μsmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_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` = 'id' where `mi_promotion`.`slug` = 'new-promotion-1' limit 11.47ms/app/Http/Controllers/Frontend/PromotionController.php:127lv_misooda_dev
        Metadata
        Bindings
        • 0. promotion
        • 1. id
        • 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 1510μs/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` = 'id' and `mi_promotion`.`id` <> 252 and `mi_promotion`.`id` in (252) limit 3460μs/app/Http/Controllers/Frontend/PromotionController.php:195lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 'id'920μs/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        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` = 'id'1.18ms/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        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` = 'id' and `mi_pr_answer`.`promotion_id` = 252920μs/app/Http/Controllers/Frontend/PromotionController.php:214lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 252580μ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` = 252750μs/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` = 'id' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'id' where `mi_promotion`.`clinic_id` = 51 and `mi_promotion`.`id` <> 252 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 21.29ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. id
        • 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` = 'id' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc900μs/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 'id' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'id' where `mi_promotion`.`category_id` = 48 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 41.13ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. id
        • 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` = 'id' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc700μs/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 'id' 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` = 'id' 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` = 'id' where `mi_review`.`category_id` = 48 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 51.44ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. id
        • 3. id
        • 4. id
        • 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 7430μs/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 7370μ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 7360μ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 7340μ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 7380μs/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` = 'id' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc700μs/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 'id' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc580μs/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\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
          NO4bZbXD5cXot6bMMV5cwGzH6A8FLNInhhNRztfg
          user
          array:1 [ "promotions" => array:1 [ 0 => 252 ] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /id/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.216.186.122" "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" => "61596" "REDIRECT_URL" => "/id/promotion/girin-plastic-surgery/new-promotion-1" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/id/promotion/girin-plastic-surgery/new-promotion-1" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745402571.591 "REQUEST_TIME" => 1745402571 ]
          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 10:02:51 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZyQzFZQSszckFlbDdlSW1RYXFNaUE9PSIsInZhbHVlIjoiWlR5WEFXUHZ4bmFwUjFVSDJvalo1azBjbktab09MNlh2SFBWaVdiNnVnWnNXNkVRcE5nK2ZSb28xXC9OMk5lcW0iLCJtYWMiOiJjZmI1YzAzODM5MTZiMjZlYTgwZDBiYTMzOGZkYTg0NTUwNjJlZDhiMmY1ODNiYmQzODc2ODQ4NzU4MmY5OWQ2In0%3D; expires=Wed, 23-Apr-2025 12:02:51 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlZyQzFZQSszckFlbDdlSW1RYXFNaUE9PSIsInZhbHVlIjoiWlR5WEFXUHZ4bmFwUjFVSDJvalo1azBjbktab09MNlh2SFBWaVdiNnVnWnNXNkVRcE5nK2ZSb28xXC9OMk5lcW0iLCJtY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZyQzFZQSszckFlbDdlSW1RYXFNaUE9PSIsInZhbHVlIjoiWlR5WEFXUHZ4bmFwUjFVSDJvalo1azBjbktab09MNlh2SFBWaVdiNnVnWnNXNkVRcE5nK2ZSb28xXC9OMk5lcW0iLCJtYWMiOiJjZmI1YzAzODM5MTZiMjZlYTgwZDBiYTMzOGZkYTg0NTUwNjJlZDhiMmY1ODNiYmQzODc2ODQ4NzU4MmY5OWQ2In0%3D; expires=Wed, 23-Apr-2025 12:02:51 GMT; path=/XSRF-TOKEN=eyJpdiI6IlZyQzFZQSszckFlbDdlSW1RYXFNaUE9PSIsInZhbHVlIjoiWlR5WEFXUHZ4bmFwUjFVSDJvalo1azBjbktab09MNlh2SFBWaVdiNnVnWnNXNkVRcE5nK2ZSb28xXC9OMk5lcW0iLCJtY" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "NO4bZbXD5cXot6bMMV5cwGzH6A8FLNInhhNRztfg" "user" => array:1 [ "promotions" => array:1 [ 0 => 252 ] ] "PHPDEBUGBAR_STACK_DATA" => [] ]