7.2.34PHP Version105msRequest Duration9MBMemory UsageGET m/{lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (22.18ms)
    • Application (82.74ms)
    • 1 x Application (78.77%)
      82.74ms
      1 x Booting (21.12%)
      22.18ms
      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
      28 statements were executed23.48ms
      • 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'1.49ms/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` desc450μ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` desc480μ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 13.76msmiddleware::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` = 'dual-epi-nasap-tip-correction-lip-filler' limit 11.36ms/app/Http/Controllers/Mobile/ReviewController.php:318lv_misooda_dev
        Metadata
        Bindings
        • 0. dual-epi-nasap-tip-correction-lip-filler
        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` = 4633, `mi_review`.`updated_at` = '2025-06-04 04:45:32' where `id` = 4201.73ms/app/Http/Controllers/Mobile/ReviewController.php:322lv_misooda_dev
        Metadata
        Bindings
        • 0. 4633
        • 1. 2025-06-04 04:45:32
        • 2. 420
        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` = 174 limit 1680μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 174
        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` = 420 and `lang_id` = 'en' limit 1690μs/app/Http/Controllers/Mobile/ReviewController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        • 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` = 27 and `lang_id` = 'en' limit 1580μs/app/Http/Controllers/Mobile/ReviewController.php:171lv_misooda_dev
        Metadata
        Bindings
        • 0. 27
        • 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` = 27 limit 1570μs/app/Model/Base/BaseModel.php:236lv_misooda_dev
        Metadata
        Bindings
        • 0. 27
        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` = 174 and `lang_id` = 'en' limit 1570μs/app/Http/Controllers/Mobile/ReviewController.php:177lv_misooda_dev
        Metadata
        Bindings
        • 0. 174
        • 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` = 628 and `lang_id` = 'en' limit 1490μs/app/Http/Controllers/Mobile/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 628
        • 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` = 420 and `flag` = 'after' limit 7630μs/app/Http/Controllers/Mobile/ReviewController.php:190lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        • 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` = 420450μs/app/Http/Controllers/Mobile/ReviewController.php:331lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        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` = 420 order by `d_date` desc860μs/app/Http/Controllers/Mobile/ReviewController.php:336lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        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 (1240, 1241, 1242, 1243, 1244, 1245, 1247, 1248, 1249)1.48ms/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` = 1249 and `lang_id` = 'en' limit 1920μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1249
        • 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` = 1248 and `lang_id` = 'en' limit 1570μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1248
        • 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` = 1247 and `lang_id` = 'en' limit 1650μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1247
        • 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` = 1245 and `lang_id` = 'en' limit 1440μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1245
        • 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` = 1244 and `lang_id` = 'en' limit 1400μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1244
        • 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` = 1243 and `lang_id` = 'en' limit 1490μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1243
        • 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` = 1242 and `lang_id` = 'en' limit 1540μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1242
        • 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` = 1241 and `lang_id` = 'en' limit 1540μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1241
        • 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` = 1240 and `lang_id` = 'en' limit 1470μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1240
        • 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` = 420 group by `id`980μs/app/Http/Controllers/Mobile/ReviewController.php:346lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. 420
        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` = 420800μs/app/Model/Review.php:75lv_misooda_dev
        Metadata
        Bindings
        • 0. review
        • 1. 0
        • 2. 420
        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` = 420 and `mi_comments_review`.`post_id` is not null410μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        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
      88
      App\Model\ReviewDiary
      9
      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
          Zp881s8UMLdRFzqbEVKYxrBqhVtBurcEYhsrkCby
          PHPDEBUGBAR_STACK_DATA
          []
          _previous
          array:1 [ "url" => "http://dev.misooda.com/vi/login" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /m/en/review/top-face-plastic-surgery/dual-epi-nasap-tip-correction-lip-filler
          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:9 [ "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" ] "cookie" => array:1 [ 0 => "_fbp=fb.1.1748979927198.810445508795788031; misooda=W1O85hmfNDvwnsOFipuZhnGJroDV6qtw29gt6xq7; XSRF-TOKEN=eyJpdiI6ImdMS0x6eWlOckZ5V1BCczA0RTREK1E9PSIsInZhbHVlIjoiT3h4azJkR2phN2lFWXR2MUdwWWphdnA0UXpzbTJLa1NLTGJ1MGo2SnNUSytpTXFqbTdSWnVxa2JaQVlJOUZEYSIsIm1hYyI6ImYwZjYxZWUwODFlMzBkMTE4YzA4MzkxYmI4NTM5M2YzZDRhZWY1MjM4MGQ3MWNhMTQ4MWM2OTA4ZjA4YzI1NzAifQ%3D%3D_fbp=fb.1.1748979927198.810445508795788031; misooda=W1O85hmfNDvwnsOFipuZhnGJroDV6qtw29gt6xq7; XSRF-TOKEN=eyJpdiI6ImdMS0x6eWlOckZ5V1BCczA0RTREK1E9PSIsInZhbHVlIjo" ] ]
          request_server
          0 of 0
          array:34 [ "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" "HTTP_COOKIE" => "_fbp=fb.1.1748979927198.810445508795788031; misooda=W1O85hmfNDvwnsOFipuZhnGJroDV6qtw29gt6xq7; XSRF-TOKEN=eyJpdiI6ImdMS0x6eWlOckZ5V1BCczA0RTREK1E9PSIsInZhbHVlIjoiT3h4azJkR2phN2lFWXR2MUdwWWphdnA0UXpzbTJLa1NLTGJ1MGo2SnNUSytpTXFqbTdSWnVxa2JaQVlJOUZEYSIsIm1hYyI6ImYwZjYxZWUwODFlMzBkMTE4YzA4MzkxYmI4NTM5M2YzZDRhZWY1MjM4MGQ3MWNhMTQ4MWM2OTA4ZjA4YzI1NzAifQ%3D%3D_fbp=fb.1.1748979927198.810445508795788031; misooda=W1O85hmfNDvwnsOFipuZhnGJroDV6qtw29gt6xq7; XSRF-TOKEN=eyJpdiI6ImdMS0x6eWlOckZ5V1BCczA0RTREK1E9PSIsInZhbHVlIjo" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)" "SERVER_NAME" => "dev.misooda.com" "SERVER_ADDR" => "139.59.109.168" "SERVER_PORT" => "80" "REMOTE_ADDR" => "18.188.73.240" "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" => "2772" "REDIRECT_URL" => "/m/en/review/top-face-plastic-surgery/dual-epi-nasap-tip-correction-lip-filler" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/review/top-face-plastic-surgery/dual-epi-nasap-tip-correction-lip-filler" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1748979931.944 "REQUEST_TIME" => 1748979931 ]
          request_cookies
          0 of 0
          array:3 [ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "Zp881s8UMLdRFzqbEVKYxrBqhVtBurcEYhsrkCby" ]
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 03 Jun 2025 19:45:32 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InBRXC8zd2pkT01xcmwrNmxiZlFDNXR3PT0iLCJ2YWx1ZSI6Ikl4NFloTEx5R3Rjcm8rbVNOYjFqakk4OWxHcm1cL0k4blhkMlZWcGEwajl1S1JITWV0eDVKT0liZTJ6SGVLT3lQIiwibWFjIjoiM2M3M2MyZDA1ZWY1ZWNmNWQ4ZGRmMTNhMWM3ZjYxNDUyY2M0Y2Q4YWViNWNiMzJiZTRkN2JlNmY3YTFhZGI4NSJ9; expires=Tue, 03-Jun-2025 21:45:32 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InBRXC8zd2pkT01xcmwrNmxiZlFDNXR3PT0iLCJ2YWx1ZSI6Ikl4NFloTEx5R3Rjcm8rbVNOYjFqakk4OWxHcm1cL0k4blhkMlZWcGEwajl1S1JITWV0eDVKT0liZTJ6SGVLT3lQIiwib" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InBRXC8zd2pkT01xcmwrNmxiZlFDNXR3PT0iLCJ2YWx1ZSI6Ikl4NFloTEx5R3Rjcm8rbVNOYjFqakk4OWxHcm1cL0k4blhkMlZWcGEwajl1S1JITWV0eDVKT0liZTJ6SGVLT3lQIiwibWFjIjoiM2M3M2MyZDA1ZWY1ZWNmNWQ4ZGRmMTNhMWM3ZjYxNDUyY2M0Y2Q4YWViNWNiMzJiZTRkN2JlNmY3YTFhZGI4NSJ9; expires=Tue, 03-Jun-2025 21:45:32 GMT; path=/XSRF-TOKEN=eyJpdiI6InBRXC8zd2pkT01xcmwrNmxiZlFDNXR3PT0iLCJ2YWx1ZSI6Ikl4NFloTEx5R3Rjcm8rbVNOYjFqakk4OWxHcm1cL0k4blhkMlZWcGEwajl1S1JITWV0eDVKT0liZTJ6SGVLT3lQIiwib" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "Zp881s8UMLdRFzqbEVKYxrBqhVtBurcEYhsrkCby" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "http://dev.misooda.com/vi/login" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]