7.2.34PHP Version118msRequest Duration9MBMemory UsageGET m/{lang}/review/{clinic}/{slug}RouteAuth status
    • Booting (31.99ms)
    • Application (85.64ms)
    • 1 x Application (72.72%)
      85.64ms
      1 x Booting (27.17%)
      31.99ms
      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 executed30.75ms
      • select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'id'2.33ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/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` desc1.16ms/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` desc1.44ms/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` = 'id' limit 15.46msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::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.58ms/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` = 4693, `mi_review`.`updated_at` = '2025-06-22 03:02:53' where `id` = 4201.61ms/app/Http/Controllers/Mobile/ReviewController.php:322lv_misooda_dev
        Metadata
        Bindings
        • 0. 4693
        • 1. 2025-06-22 03:02:53
        • 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 1590μ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` = 'id' limit 1710μs/app/Http/Controllers/Mobile/ReviewController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. 420
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 11.85ms/app/Http/Controllers/Mobile/ReviewController.php:171lv_misooda_dev
        Metadata
        Bindings
        • 0. 27
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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 1450μ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` = 'id' limit 13.92ms/app/Http/Controllers/Mobile/ReviewController.php:177lv_misooda_dev
        Metadata
        Bindings
        • 0. 174
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1700μs/app/Http/Controllers/Mobile/ReviewController.php:183lv_misooda_dev
        Metadata
        Bindings
        • 0. 628
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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 7790μ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` = 420480μ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` desc660μ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)930μs/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` = 'id' limit 1560μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1249
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1450μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1248
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1390μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1247
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1400μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1245
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1410μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1244
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1440μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1243
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1420μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1242
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1470μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1241
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' limit 1420μs/app/Http/Controllers/Mobile/ReviewController.php:201lv_misooda_dev
        Metadata
        Bindings
        • 0. 1240
        • 1. id
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /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` = 'id' and `post_id` = 420 group by `id`740μs/app/Http/Controllers/Mobile/ReviewController.php:346lv_misooda_dev
        Metadata
        Bindings
        • 0. id
        • 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` = 420900μ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 null490μ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
          zMyhEqgoYKbIyHuSvYBvntlr08g2pgBr0OPKFqIj
          _previous
          array:1 [ "url" => "http://dev.misooda.com/add/follow/user/670" ]
          _flash
          array:2 [ "old" => array:1 [ 0 => "message" ] "new" => [] ]
          login_after_url
          http://dev.misooda.com/add/follow/user/670
          message
          Login required. Please log in
          path_info
          /m/id/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: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.1750528965800.298954924766520063; misooda=2UmN8JrPgTkjjH9SzALFqTQrRXYb6Y0W8vrb8Ey8; XSRF-TOKEN=eyJpdiI6IlRENW5QVXdcL2JGTVhpWWRSSUl0N2NBPT0iLCJ2YWx1ZSI6ImxiZTFnUWQ3ZWFlUWJ6NTROMk1lYWxvbUJES2lrOXp5OTRIVWRJMEZpYUdWb3d5dVVmTzhWNVFTXC8yR1BDUlFlIiwibWFjIjoiNGY4NTczOTM4ZWNlZDcyMzFkZTZiNDdjYTUwMjQyODVlNWRjZGI4ZDEwY2YxOGQyZjI3ZDU4OTllNDc0YjAzZSJ9_fbp=fb.1.1750528965800.298954924766520063; misooda=2UmN8JrPgTkjjH9SzALFqTQrRXYb6Y0W8vrb8Ey8; XSRF-TOKEN=eyJpdiI6IlRENW5QVXdcL2JGTVhpWWRSSUl0N2NBPT0iLCJ2YWx1ZSI" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)" ] "x-forwarded-for" => array:1 [ 0 => "10.3.59.54" ] "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.1750528965800.298954924766520063; misooda=2UmN8JrPgTkjjH9SzALFqTQrRXYb6Y0W8vrb8Ey8; XSRF-TOKEN=eyJpdiI6IlRENW5QVXdcL2JGTVhpWWRSSUl0N2NBPT0iLCJ2YWx1ZSI6ImxiZTFnUWQ3ZWFlUWJ6NTROMk1lYWxvbUJES2lrOXp5OTRIVWRJMEZpYUdWb3d5dVVmTzhWNVFTXC8yR1BDUlFlIiwibWFjIjoiNGY4NTczOTM4ZWNlZDcyMzFkZTZiNDdjYTUwMjQyODVlNWRjZGI4ZDEwY2YxOGQyZjI3ZDU4OTllNDc0YjAzZSJ9_fbp=fb.1.1750528965800.298954924766520063; misooda=2UmN8JrPgTkjjH9SzALFqTQrRXYb6Y0W8vrb8Ey8; XSRF-TOKEN=eyJpdiI6IlRENW5QVXdcL2JGTVhpWWRSSUl0N2NBPT0iLCJ2YWx1ZSI" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.3.59.54" "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.254" "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" => "57745" "REDIRECT_URL" => "/m/id/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/id/review/top-face-plastic-surgery/dual-epi-nasap-tip-correction-lip-filler" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750528973.061 "REQUEST_TIME" => 1750528973 ]
          request_cookies
          0 of 0
          array:3 [ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "zMyhEqgoYKbIyHuSvYBvntlr08g2pgBr0OPKFqIj" ]
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 21 Jun 2025 18:02:53 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Im01aHFsTTk2MjlZU1BibDR4TlNoVGc9PSIsInZhbHVlIjoiRHoyMFhGeEYyc0NmVjVwUHZNVGd5NmdKSDI1XC9qblFFSm5GYmdQY1lSc1BNZU9HTEk5b0pnMkF0T1dacGcwZWQiLCJtYWMiOiI1MjQzMGM3ZjRjMmE5Nzg3NzhlNDI3MGRhYjU3NGY5ZTNmMzQ2OGE2Y2Y3ZmJhNzFjYjA4NmM3YjdhNGY0ZjAzIn0%3D; expires=Sat, 21-Jun-2025 20:02:53 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Im01aHFsTTk2MjlZU1BibDR4TlNoVGc9PSIsInZhbHVlIjoiRHoyMFhGeEYyc0NmVjVwUHZNVGd5NmdKSDI1XC9qblFFSm5GYmdQY1lSc1BNZU9HTEk5b0pnMkF0T1dacGcwZWQiLCJtY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Im01aHFsTTk2MjlZU1BibDR4TlNoVGc9PSIsInZhbHVlIjoiRHoyMFhGeEYyc0NmVjVwUHZNVGd5NmdKSDI1XC9qblFFSm5GYmdQY1lSc1BNZU9HTEk5b0pnMkF0T1dacGcwZWQiLCJtYWMiOiI1MjQzMGM3ZjRjMmE5Nzg3NzhlNDI3MGRhYjU3NGY5ZTNmMzQ2OGE2Y2Y3ZmJhNzFjYjA4NmM3YjdhNGY0ZjAzIn0%3D; expires=Sat, 21-Jun-2025 20:02:53 GMT; path=/XSRF-TOKEN=eyJpdiI6Im01aHFsTTk2MjlZU1BibDR4TlNoVGc9PSIsInZhbHVlIjoiRHoyMFhGeEYyc0NmVjVwUHZNVGd5NmdKSDI1XC9qblFFSm5GYmdQY1lSc1BNZU9HTEk5b0pnMkF0T1dacGcwZWQiLCJtY" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "zMyhEqgoYKbIyHuSvYBvntlr08g2pgBr0OPKFqIj" "_previous" => array:1 [ "url" => "http://dev.misooda.com/add/follow/user/670" ] "_flash" => array:2 [ "old" => array:1 [ 0 => "message" ] "new" => [] ] "login_after_url" => "http://dev.misooda.com/add/follow/user/670" "message" => "Login required. Please log in" ]