7.2.34PHP Version75.98msRequest Duration9MBMemory UsageGET m/{lang}/review/{clinic}/{slug}/commentsRouteAuth status
    • Booting (19.42ms)
    • Application (56.38ms)
    • 1 x Application (74.2%)
      56.38ms
      1 x Booting (25.57%)
      19.42ms
      8 templates were rendered
      • mobile.review.detail-comment (resources/views/mobile/review/detail-comment.blade.php)12blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        review
        4
        clinic
        5
        category
        6
        user
        7
        doctor
        8
        data
        9
        images
        10
        diary
        11
        comments
      • layouts.mobile_layout (resources/views/layouts/mobile_layout.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
      • partials.mobile.header-meta (resources/views/partials/mobile/header-meta.blade.php)37blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
      • partials.mobile.header2 (resources/views/partials/mobile/header2.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
        37
        request
        38
        isWebView
        39
        userData
        40
        title
      • partials.mobile.messages (resources/views/partials/mobile/messages.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
        37
        request
        38
        isWebView
        39
        userData
      • partials.mobile.footer-comment (resources/views/partials/mobile/footer-comment.blade.php)77blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
        37
        request
        38
        isWebView
        39
        userData
        40
        id
        41
        category_id
        42
        user_id
        43
        clinic_id
        44
        promotion_id
        45
        doctor_id
        46
        quote_id
        47
        slug
        48
        title
        49
        cost
        50
        content
        51
        procedure_date
        52
        hit
        53
        like_hit
        54
        rating_01
        55
        rating_02
        56
        rating_03
        57
        rating_04
        58
        rating_05
        59
        isopen
        60
        photos
        61
        diarys
        62
        img_before
        63
        img_after
        64
        status
        65
        show_type
        66
        order_no
        67
        review_type
        68
        meta_title
        69
        meta_desc
        70
        created_at
        71
        updated_at
        72
        type_code
        73
        is_helpful_count
        74
        comments_count
        75
        after_images
        76
        clinic_slug
      • partials.mobile.modal.login (resources/views/partials/mobile/modal/login.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
        37
        request
        38
        isWebView
        39
        userData
      • partials.mobile.footer-meta (resources/views/partials/mobile/footer-meta.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        review
        10
        clinic
        11
        category
        12
        user
        13
        doctor
        14
        data
        15
        images
        16
        diary
        17
        comments
        18
        like_base_url
        19
        unlike_base_url
        20
        __currentLoopData
        21
        dd
        22
        loop
        23
        img
        24
        like_url
        25
        i
        26
        d
        27
        ddate
        28
        pdate
        29
        datediff
        30
        dayafter
        31
        mainImage
        32
        header
        33
        params
        34
        footer
        35
        footerParams
        36
        tawk
        37
        request
        38
        isWebView
        39
        userData
      uri
      GET m/{lang}/review/{clinic}/{slug}/comments
      middleware
      web, redirect.topc, lang
      controller
      App\Http\Controllers\Mobile\ReviewController@showComments
      namespace
      App\Http\Controllers\Mobile
      prefix
      m/{lang}
      where
      file
      app/Http/Controllers/Mobile/ReviewController.php:422-469
      28 statements were executed, 4 of which were duplicated, 24 unique16.23ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'vi'1.27ms/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/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` desc550μ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` desc430μ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` = 'vi' limit 1660μsmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. vi
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::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` = 'face-contouring-+-rhinoplasty-+-eyelid-revision-surgery' limit 1880μs/app/Http/Controllers/Mobile/ReviewController.php:426lv_misooda_dev
        Metadata
        Bindings
        • 0. face-contouring-+-rhinoplasty-+-eyelid-revision-surgery
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:426
        • 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` = 19 limit 1600μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        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:428
        • 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_category` where `mi_category`.`id` = 48 limit 1380μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 48
        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:429
        • 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` = 72 and `lang_id` = 'vi' limit 1470μs/app/Http/Controllers/Mobile/ReviewController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:157
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:433
        • 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` = 48 and `lang_id` = 'vi' limit 1640μs/app/Http/Controllers/Mobile/ReviewController.php:171lv_misooda_dev
        Metadata
        Bindings
        • 0. 48
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:171
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:433
        • 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_clinic_trans` where `clinic_id` = 19 and `lang_id` = 'vi' limit 1630μs/app/Http/Controllers/Mobile/ReviewController.php:177lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:177
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:433
        • 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` is null and `lang_id` = 'vi' limit 1510μs/app/Http/Controllers/Mobile/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 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. /app/Http/Controllers/Mobile/ReviewController.php:183
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:433
        • 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` = 72 and `flag` = 'after' limit 7520μs/app/Http/Controllers/Mobile/ReviewController.php:190lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        • 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:433
        • 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_clinic` where `mi_clinic`.`id` = 19 limit 1630μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        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
        • 17. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 20. /app/Http/Controllers/Mobile/ReviewController.php:440
        • 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_user` where `mi_user`.`id` = 656 limit 1510μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 656
        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
        • 17. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 20. /app/Http/Controllers/Mobile/ReviewController.php:441
        • 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_category` where `mi_category`.`id` = 48 limit 1380μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 48
        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
        • 17. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 20. /app/Http/Controllers/Mobile/ReviewController.php:442
        • 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_images_review` where `review_id` = 72420μs/app/Http/Controllers/Mobile/ReviewController.php:451lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:451
        • 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` = 72 order by `d_date` desc670μs/app/Http/Controllers/Mobile/ReviewController.php:456lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:456
        • 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 (33, 34, 35, 37, 39, 40, 42)720μs/app/Http/Controllers/Mobile/ReviewController.php:456lv_misooda_dev
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/Mobile/ReviewController.php:456
        • 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` = 42 and `lang_id` = 'vi' limit 1490μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 42
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 40 and `lang_id` = 'vi' limit 1370μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 40
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 39 and `lang_id` = 'vi' limit 1350μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 39
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 37 and `lang_id` = 'vi' limit 1470μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 37
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 35 and `lang_id` = 'vi' limit 1420μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 35
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 34 and `lang_id` = 'vi' limit 1420μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 34
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 33 and `lang_id` = 'vi' limit 1400μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 33
        • 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. /app/Http/Controllers/Mobile/ReviewController.php:201
        • 16. /app/Http/Controllers/Mobile/ReviewController.php:457
        • 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` = 'vi' and `post_id` = 721.1ms/app/Http/Controllers/Mobile/ReviewController.php:465lv_misooda_dev
        Metadata
        Bindings
        • 0. vi
        • 1. 72
        Backtrace
        • 14. /app/Http/Controllers/Mobile/ReviewController.php:465
        • 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` = 72770μs/app/Model/Review.php:75lv_misooda_dev
        Metadata
        Bindings
        • 0. review
        • 1. 0
        • 2. 72
        Backtrace
        • 15. /app/Model/Review.php:75
        • 16. view::mobile.review.detail-comment:75
        • 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` = 72 and `mi_comments_review`.`post_id` is not null570μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        Backtrace
        • 15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 17. view::mobile.review.detail-comment:77
        • 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
      12
      App\Model\ReviewDiary
      7
      App\Model\User
      1
      App\Model\ImagesReview
      3
      App\Model\ClinicTrans
      1
      App\Model\CategoryTrans
      1
      App\Model\ReviewTrans
      1
      App\Model\Category
      2
      App\Model\Clinic
      2
      App\Model\Review
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          itmogrKjhl7UAKYhfPT902BvkcGLKbTkYwAR1KwL
          PHPDEBUGBAR_STACK_DATA
          []
          _previous
          array:1 [ "url" => "http://dev.misooda.com/zh-CN/clinic/view-plastic-surgery/reviews/breast" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /m/vi/review/banobagi-plastic-surgery/face-contouring-+-rhinoplasty-+-eyelid-revision-surgery/comments
          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 => "misooda=VwZX8nWQKf6hviQuIo9bZwN7gLH15MWa6OkSqp0G; _fbp=fb.1.1753234687219.27485724613603009; XSRF-TOKEN=eyJpdiI6ImxwOXgrNndCVG9sU3A4cW1SNUYrMGc9PSIsInZhbHVlIjoiclwvdFwvRVcyNzhTTHBVa0xiNWxObnBSMEo1dThUR2tqXC9VallLWTJ1Q3FaK21ackVVSWR2V1d1U01vVUpnb2lxbyIsIm1hYyI6IjUyM2ExZjQ4YzYxODdjM2RiOWRkMjk1MzYzYTE5YjEyY2JkZWFjOTE1YmU4ZjIwYTg0NmRhYmFhNjQxMTE0MTEifQ%3D%3Dmisooda=VwZX8nWQKf6hviQuIo9bZwN7gLH15MWa6OkSqp0G; _fbp=fb.1.1753234687219.27485724613603009; XSRF-TOKEN=eyJpdiI6ImxwOXgrNndCVG9sU3A4cW1SNUYrMGc9PSIsInZhbHVlIjoi" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-mnm4m (squid/6.10)" ] "x-forwarded-for" => array:1 [ 0 => "10.1.229.238" ] "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" => "misooda=VwZX8nWQKf6hviQuIo9bZwN7gLH15MWa6OkSqp0G; _fbp=fb.1.1753234687219.27485724613603009; XSRF-TOKEN=eyJpdiI6ImxwOXgrNndCVG9sU3A4cW1SNUYrMGc9PSIsInZhbHVlIjoiclwvdFwvRVcyNzhTTHBVa0xiNWxObnBSMEo1dThUR2tqXC9VallLWTJ1Q3FaK21ackVVSWR2V1d1U01vVUpnb2lxbyIsIm1hYyI6IjUyM2ExZjQ4YzYxODdjM2RiOWRkMjk1MzYzYTE5YjEyY2JkZWFjOTE1YmU4ZjIwYTg0NmRhYmFhNjQxMTE0MTEifQ%3D%3Dmisooda=VwZX8nWQKf6hviQuIo9bZwN7gLH15MWa6OkSqp0G; _fbp=fb.1.1753234687219.27485724613603009; XSRF-TOKEN=eyJpdiI6ImxwOXgrNndCVG9sU3A4cW1SNUYrMGc9PSIsInZhbHVlIjoi" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-mnm4m (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.229.238" "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.216.0" "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" => "48287" "REDIRECT_URL" => "/m/vi/review/banobagi-plastic-surgery/face-contouring-+-rhinoplasty-+-eyelid-revision-surgery/comments" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/vi/review/banobagi-plastic-surgery/face-contouring-+-rhinoplasty-+-eyelid-revision-surgery/comments" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1753234690.014 "REQUEST_TIME" => 1753234690 ]
          request_cookies
          0 of 0
          array:3 [ "misooda" => null "_fbp" => null "XSRF-TOKEN" => "itmogrKjhl7UAKYhfPT902BvkcGLKbTkYwAR1KwL" ]
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 23 Jul 2025 01:38:10 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZJakZDU1JnSG03akU0NTFqWm1WdlE9PSIsInZhbHVlIjoiZ3VcL2lwXC84Z2JyRWJseU9UWEJ6RXRlU3JiSHIzYnk2M0dFc0FuM1JGUENLajZIdjQ3cURMWTRORE9kUkQ1d3p4IiwibWFjIjoiYTAyZTFlZmYzNTI5ZTAwNDA0NDg5ZDFjMDZmOGNhY2E1NmRkZWI4NjJhZjNiMDE1YjA3ZDE4NTVhOTJiYzFiMSJ9; expires=Wed, 23-Jul-2025 03:38:10 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlZJakZDU1JnSG03akU0NTFqWm1WdlE9PSIsInZhbHVlIjoiZ3VcL2lwXC84Z2JyRWJseU9UWEJ6RXRlU3JiSHIzYnk2M0dFc0FuM1JGUENLajZIdjQ3cURMWTRORE9kUkQ1d3p4Iiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZJakZDU1JnSG03akU0NTFqWm1WdlE9PSIsInZhbHVlIjoiZ3VcL2lwXC84Z2JyRWJseU9UWEJ6RXRlU3JiSHIzYnk2M0dFc0FuM1JGUENLajZIdjQ3cURMWTRORE9kUkQ1d3p4IiwibWFjIjoiYTAyZTFlZmYzNTI5ZTAwNDA0NDg5ZDFjMDZmOGNhY2E1NmRkZWI4NjJhZjNiMDE1YjA3ZDE4NTVhOTJiYzFiMSJ9; expires=Wed, 23-Jul-2025 03:38:10 GMT; path=/XSRF-TOKEN=eyJpdiI6IlZJakZDU1JnSG03akU0NTFqWm1WdlE9PSIsInZhbHVlIjoiZ3VcL2lwXC84Z2JyRWJseU9UWEJ6RXRlU3JiSHIzYnk2M0dFc0FuM1JGUENLajZIdjQ3cURMWTRORE9kUkQ1d3p4Iiwib" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "itmogrKjhl7UAKYhfPT902BvkcGLKbTkYwAR1KwL" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "http://dev.misooda.com/zh-CN/clinic/view-plastic-surgery/reviews/breast" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]