7.2.34PHP Version103msRequest Duration9MBMemory UsageGET m/{lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (22.32ms)
    • Application (79.99ms)
    • 1 x Application (78.02%)
      79.99ms
      1 x Booting (21.78%)
      22.32ms
      8 templates were rendered
      • mobile.review.detail (resources/views/mobile/review/detail.blade.php)7blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        data
        4
        images
        5
        diary
        6
        comments
      • layouts.mobile_layout (resources/views/layouts/mobile_layout.blade.php)31blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
      • partials.mobile.header-meta (resources/views/partials/mobile/header-meta.blade.php)32blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
      • partials.mobile.header2 (resources/views/partials/mobile/header2.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
        32
        request
        33
        isWebView
        34
        userData
        35
        title
      • partials.mobile.messages (resources/views/partials/mobile/messages.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
        32
        request
        33
        isWebView
        34
        userData
      • partials.mobile.footer-comment (resources/views/partials/mobile/footer-comment.blade.php)73blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
        32
        request
        33
        isWebView
        34
        userData
        35
        id
        36
        category_id
        37
        user_id
        38
        clinic_id
        39
        promotion_id
        40
        doctor_id
        41
        quote_id
        42
        slug
        43
        title
        44
        cost
        45
        content
        46
        procedure_date
        47
        hit
        48
        like_hit
        49
        rating_01
        50
        rating_02
        51
        rating_03
        52
        rating_04
        53
        rating_05
        54
        isopen
        55
        photos
        56
        diarys
        57
        img_before
        58
        img_after
        59
        status
        60
        show_type
        61
        order_no
        62
        review_type
        63
        meta_title
        64
        meta_desc
        65
        created_at
        66
        updated_at
        67
        type_code
        68
        is_helpful_count
        69
        comments_count
        70
        after_images
        71
        clinic
        72
        category
      • partials.mobile.modal.login (resources/views/partials/mobile/modal/login.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
        32
        request
        33
        isWebView
        34
        userData
      • partials.mobile.footer-meta (resources/views/partials/mobile/footer-meta.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        data
        10
        images
        11
        diary
        12
        comments
        13
        like_base_url
        14
        unlike_base_url
        15
        __currentLoopData
        16
        i
        17
        loop
        18
        img_span
        19
        like_url
        20
        d
        21
        ddate
        22
        pdate
        23
        datediff
        24
        dayafter
        25
        mainImage
        26
        img
        27
        header
        28
        params
        29
        footer
        30
        footerParams
        31
        tawk
        32
        request
        33
        isWebView
        34
        userData
      uri
      GET m/{lang}/review/{clinic}/{slug}
      middleware
      web, redirect.topc, lang
      controller
      App\Http\Controllers\Mobile\ReviewController@show
      namespace
      App\Http\Controllers\Mobile
      prefix
      m/{lang}
      where
      file
      app/Http/Controllers/Mobile/ReviewController.php:316-350
      32 statements were executed26.88ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'en'2.14ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:35
        • 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` desc880μ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/Mobile/ReviewController.php:35
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 order by `id` desc930μ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/Mobile/ReviewController.php:35
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 11.1msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::redirect.topc:25
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_review`.*, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` where `slug` = 'two-jaw-ar-zy-t-front-zygomasil-forehead-sil-calibration-o-ceramic' limit 11.48ms/app/Http/Controllers/Mobile/ReviewController.php:318lv_misooda_dev
        Metadata
        Bindings
        • 0. two-jaw-ar-zy-t-front-zygomasil-forehead-sil-calibration-o-ceramic
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:318
        • 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
      • update `mi_review` set `hit` = 2665, `mi_review`.`updated_at` = '2025-07-09 18:02:03' where `id` = 2921.94ms/app/Http/Controllers/Mobile/ReviewController.php:322lv_misooda_dev
        Metadata
        Bindings
        • 0. 2665
        • 1. 2025-07-09 18:02:03
        • 2. 292
        Backtrace
        • 13. /app/Http/Controllers/Mobile/ReviewController.php:322
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select * from `mi_clinic` where `mi_clinic`.`id` = 58 limit 1770μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        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/Mobile/ReviewController.php:324
        • 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 * from `mi_review_trans` where `review_id` = 292 and `lang_id` = 'en' limit 1830μs/app/Http/Controllers/Mobile/ReviewController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. 292
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:157
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 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
      • select * from `mi_category_trans` where `cat_id` = 49 and `lang_id` = 'en' limit 1750μs/app/Http/Controllers/Mobile/ReviewController.php:171lv_misooda_dev
        Metadata
        Bindings
        • 0. 49
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:171
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 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
      • select * from `mi_category` where `mi_category`.`id` = 49 limit 1980μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 49
        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/Mobile/ReviewController.php:172
        • 21. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `mi_clinic_trans` where `clinic_id` = 58 and `lang_id` = 'en' limit 1650μs/app/Http/Controllers/Mobile/ReviewController.php:177lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:177
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 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
      • select * from `mi_doctor_trans` where `doctor_id` = 444 and `lang_id` = 'en' limit 11.03ms/app/Http/Controllers/Mobile/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 444
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:183
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 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
      • select * from `mi_images_review` where `review_id` = 292 and `flag` = 'after' limit 7790μs/app/Http/Controllers/Mobile/ReviewController.php:190lv_misooda_dev
        Metadata
        Bindings
        • 0. 292
        • 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/Http/Controllers/Mobile/ReviewController.php:190
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:329
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `mi_images_review` where `review_id` = 292680μs/app/Http/Controllers/Mobile/ReviewController.php:331lv_misooda_dev
        Metadata
        Bindings
        • 0. 292
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:331
        • 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 * from `mi_review_diary` where `review_id` = 292 order by `d_date` desc920μs/app/Http/Controllers/Mobile/ReviewController.php:336lv_misooda_dev
        Metadata
        Bindings
        • 0. 292
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:336
        • 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 * from `mi_images_diary` where `mi_images_diary`.`diary_id` in (727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739)1.32ms/app/Http/Controllers/Mobile/ReviewController.php:336lv_misooda_dev
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/Mobile/ReviewController.php:336
        • 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 * from `mi_review_diary_trans` where `review_diary_id` = 739 and `lang_id` = 'en' limit 1870μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 739
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 738 and `lang_id` = 'en' limit 1600μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 738
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 737 and `lang_id` = 'en' limit 1620μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 737
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 736 and `lang_id` = 'en' limit 1590μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 736
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 735 and `lang_id` = 'en' limit 1610μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 735
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 733 and `lang_id` = 'en' limit 1590μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 733
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 734 and `lang_id` = 'en' limit 1580μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 734
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 732 and `lang_id` = 'en' limit 1430μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 732
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 731 and `lang_id` = 'en' limit 1620μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 731
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 730 and `lang_id` = 'en' limit 1520μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 730
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 729 and `lang_id` = 'en' limit 1500μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 729
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 728 and `lang_id` = 'en' limit 1430μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 728
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select * from `mi_review_diary_trans` where `review_diary_id` = 727 and `lang_id` = 'en' limit 1450μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 727
        • 1. en
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:337
        • 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
      • select `mi_comments_review`.`id`, `mi_comments_review`.`date`, `mi_u`.`username` as `username`, `mi_u`.`profile_image`, `mi_tr`.`comment` from `mi_comments_review` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_comments_review`.`user_id` left join `mi_comments_review_trans` as `mi_tr` on `mi_tr`.`comment_id` = `mi_comments_review`.`id` where `mi_tr`.`lang_id` = 'en' and `post_id` = 292 group by `id`680μs/app/Http/Controllers/Mobile/ReviewController.php:346lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 292
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:346
        • 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 count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 292850μs/app/Model/Review.php:75lv_misooda_dev
        Metadata
        Bindings
        • 0. review
        • 1. 0
        • 2. 292
        Backtrace
        • 15. /app/Model/Review.php:75
        • 16. view::mobile.review.detail:36
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125
      • select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 292 and `mi_comments_review`.`post_id` is not null750μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 292
        Backtrace
        • 15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 17. view::mobile.review.detail:36
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:142
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:125
      App\Model\ImagesDiary
      52
      App\Model\ReviewDiary
      13
      App\Model\ImagesReview
      3
      App\Model\ClinicTrans
      1
      App\Model\Category
      1
      App\Model\CategoryTrans
      1
      App\Model\ReviewTrans
      1
      App\Model\Clinic
      1
      App\Model\Review
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          ldvGpTfyZMGdeaeZoedqi9VTByLqwYT4blpXklEL
          _previous
          array:1 [ "url" => "http://dev.misooda.com/m/en/review/seoul-365mc/finally-did-liposuction" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          login_after_url
          http://dev.misooda.com/add/like/review/360
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /m/en/review/view-plastic-surgery/two-jaw-ar-zy-t-front-zygomasil-forehead-sil-calibration-o-ceramic
          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:11 [ "host" => array:1 [ 0 => "dev.misooda.com" ] "pragma" => 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" ] "cookie" => array:1 [ 0 => "_fbp=fb.1.1752051720326.481452588634864370; misooda=8CvKqeyyeEvN6foGTxNXPpGROCbeMwoIb9YZtFRb; XSRF-TOKEN=eyJpdiI6InFSdHVqN2FmbW5PTjRyc3pRbHZjaEE9PSIsInZhbHVlIjoiMEZQXC80KzBGSVlBbk9rUjBYMW1vU1wvWmdVUHpLeFJcL24xZlFqUTlrVXJ4eDJ6R1p0NndnK3k3UXQ1WGl4QTlrNCIsIm1hYyI6Ijg3ZmFmY2NlYmJmOTQxZjIxMTdjNjQ0OTZhZDNmMjhkNjhjMzMxMThlYzk5ZWNlZDgwZjg5NjM2NTZjY2RiY2MifQ%3D%3D_fbp=fb.1.1752051720326.481452588634864370; misooda=8CvKqeyyeEvN6foGTxNXPpGROCbeMwoIb9YZtFRb; XSRF-TOKEN=eyJpdiI6InFSdHVqN2FmbW5PTjRyc3pRbHZjaEE9PSIsInZhbHVlIjo" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-xkbxz (squid/6.10)" ] "x-forwarded-for" => array:1 [ 0 => "10.1.226.204" ] "cache-control" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] ]
          request_server
          0 of 0
          array:36 [ "REDIRECT_STATUS" => "200" "HTTP_HOST" => "dev.misooda.com" "HTTP_PRAGMA" => "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" "HTTP_COOKIE" => "_fbp=fb.1.1752051720326.481452588634864370; misooda=8CvKqeyyeEvN6foGTxNXPpGROCbeMwoIb9YZtFRb; XSRF-TOKEN=eyJpdiI6InFSdHVqN2FmbW5PTjRyc3pRbHZjaEE9PSIsInZhbHVlIjoiMEZQXC80KzBGSVlBbk9rUjBYMW1vU1wvWmdVUHpLeFJcL24xZlFqUTlrVXJ4eDJ6R1p0NndnK3k3UXQ1WGl4QTlrNCIsIm1hYyI6Ijg3ZmFmY2NlYmJmOTQxZjIxMTdjNjQ0OTZhZDNmMjhkNjhjMzMxMThlYzk5ZWNlZDgwZjg5NjM2NTZjY2RiY2MifQ%3D%3D_fbp=fb.1.1752051720326.481452588634864370; misooda=8CvKqeyyeEvN6foGTxNXPpGROCbeMwoIb9YZtFRb; XSRF-TOKEN=eyJpdiI6InFSdHVqN2FmbW5PTjRyc3pRbHZjaEE9PSIsInZhbHVlIjo" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-xkbxz (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.226.204" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "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" => "216.73.217.2" "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" => "29554" "REDIRECT_URL" => "/m/en/review/view-plastic-surgery/two-jaw-ar-zy-t-front-zygomasil-forehead-sil-calibration-o-ceramic" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/review/view-plastic-surgery/two-jaw-ar-zy-t-front-zygomasil-forehead-sil-calibration-o-ceramic" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1752051723.366 "REQUEST_TIME" => 1752051723 ]
          request_cookies
          0 of 0
          array:3 [ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "ldvGpTfyZMGdeaeZoedqi9VTByLqwYT4blpXklEL" ]
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 09 Jul 2025 09:02:03 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1WDFYSCtJOVNOcVQ2NGVPU3ZybVE9PSIsInZhbHVlIjoiUzVjMVwvXC9hRXgzY1dwMStJc3docGxKUHdwbkc4MzlBc2ZUVk9hanpjeFJaR251UHYwb1NpY2lZaUtPZFVkcXFQIiwibWFjIjoiNjQxMThkYjE1MGZhMThlOTRiNjgwNjA3NzllNzMxMWE2YTVmZTgwYmIwYjk4Y2JmMzllOGViN2M3ZDI4ZmEwMCJ9; expires=Wed, 09-Jul-2025 11:02:03 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjI1WDFYSCtJOVNOcVQ2NGVPU3ZybVE9PSIsInZhbHVlIjoiUzVjMVwvXC9hRXgzY1dwMStJc3docGxKUHdwbkc4MzlBc2ZUVk9hanpjeFJaR251UHYwb1NpY2lZaUtPZFVkcXFQIiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1WDFYSCtJOVNOcVQ2NGVPU3ZybVE9PSIsInZhbHVlIjoiUzVjMVwvXC9hRXgzY1dwMStJc3docGxKUHdwbkc4MzlBc2ZUVk9hanpjeFJaR251UHYwb1NpY2lZaUtPZFVkcXFQIiwibWFjIjoiNjQxMThkYjE1MGZhMThlOTRiNjgwNjA3NzllNzMxMWE2YTVmZTgwYmIwYjk4Y2JmMzllOGViN2M3ZDI4ZmEwMCJ9; expires=Wed, 09-Jul-2025 11:02:03 GMT; path=/XSRF-TOKEN=eyJpdiI6IjI1WDFYSCtJOVNOcVQ2NGVPU3ZybVE9PSIsInZhbHVlIjoiUzVjMVwvXC9hRXgzY1dwMStJc3docGxKUHdwbkc4MzlBc2ZUVk9hanpjeFJaR251UHYwb1NpY2lZaUtPZFVkcXFQIiwib" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "ldvGpTfyZMGdeaeZoedqi9VTByLqwYT4blpXklEL" "_previous" => array:1 [ "url" => "http://dev.misooda.com/m/en/review/seoul-365mc/finally-did-liposuction" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "login_after_url" => "http://dev.misooda.com/add/like/review/360" "PHPDEBUGBAR_STACK_DATA" => [] ]