ビュー美容外科
ビュー美容外科
住所 : ソウル特別市 江南区 奉恩寺路(ポンウンサロ)107
満足度 :
専門分野 : 顔面輪郭 脂肪吸引 フェイスリフト 両顎 脂肪注入 皮膚 ボトックス フィラー 毛髪移植
7.2.34PHP Version90.24msRequest Duration9MBMemory UsageGET {lang}/clinic/{slug}/reviews/{cat?}RouteAuth status
    • Booting (20.28ms)
    • Application (69.81ms)
    • 1 x Application (77.36%)
      69.81ms
      1 x Booting (22.47%)
      20.28ms
      12 templates were rendered
      • frontend.clinic.reviews (resources/views/frontend/clinic/reviews.blade.php)16blade
        Params
        0
        ac
        1
        conf
        2
        langs
        3
        clinic_ac
        4
        data
        5
        cats
        6
        cat
        7
        category
        8
        tomImages
        9
        rating
        10
        reviewCount
        11
        promotionCount
        12
        followed
        13
        pageTitle
        14
        pageDesc
        15
        pageImage
      • partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)22blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
      • partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        clinic_id
        23
        showBest
        24
        showAll
        25
        url
        26
        limit
        27
        promotion_id
        28
        doctor_id
        29
        type
        30
        list
        31
        rMenuType
        32
        showCats
        33
        category_id
      • layouts.frontend (resources/views/layouts/frontend.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
      • partials.frontend.header2 (resources/views/partials/frontend/header2.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
        24
        group
        25
        showImg
        26
        limit
        27
        list
        28
        showTitle
        29
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        cl
        4
        lang
        5
        errors
        6
        ac
        7
        conf
        8
        langs
        9
        clinic_ac
        10
        data
        11
        cats
        12
        cat
        13
        category
        14
        tomImages
        15
        rating
        16
        reviewCount
        17
        promotionCount
        18
        followed
        19
        pageTitle
        20
        pageDesc
        21
        pageImage
        22
        header
        23
        footer
      uri
      GET {lang}/clinic/{slug}/reviews/{cat?}
      middleware
      web, lang, redirect.tomobile
      controller
      App\Http\Controllers\Frontend\ClinicController@reviews
      namespace
      App\Http\Controllers\Frontend
      prefix
      /{lang}
      where
      file
      app/Http/Controllers/Frontend/ClinicController.php:195-205
      32 statements were executed23.84ms
      • 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` = 'ja'1.48ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. ja
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 13. /app/Http/Controllers/FrontendController.php:33
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:24
        • 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` desc590μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Http/Controllers/Shared/TransController.php:38
        • 15. /app/Http/Controllers/Shared/TransController.php:20
        • 16. /app/Http/Controllers/FrontendController.php:39
        • 17. /app/Http/Controllers/Frontend/ClinicController.php:24
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 order by `id` desc500μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Shared/TransController.php:45
        • 15. /app/Http/Controllers/Shared/TransController.php:21
        • 16. /app/Http/Controllers/FrontendController.php:39
        • 17. /app/Http/Controllers/Frontend/ClinicController.php:24
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825
      • select * from `mi_language` where `is_active` = 1 and `code` = 'ja' limit 1490μsmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. ja
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. middleware::lang:27
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
        • 18. middleware::bindings:41
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
      • select `mi_clinic`.*, `mi_tr`.`name`, `mi_tr`.`address`, `mi_tr`.`description`, `mi_tr`.`business_time`, `mi_tr`.`business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_tr` on `mi_tr`.`clinic_id` = `mi_clinic`.`id` where `mi_tr`.`lang_id` = 'ja' and `slug` = 'view-plastic-surgery' limit 1900μs/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev
        Metadata
        Bindings
        • 0. ja
        • 1. view-plastic-surgery
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:358
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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_cat`.*, `mi_tr`.`title` from `mi_clinic_category` left join `mi_category` as `mi_cat` on `mi_cat`.`id` = `mi_clinic_category`.`category_id` left join `mi_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_cat`.`id` where `mi_clinic_category`.`clinic_id` = 58 and `mi_tr`.`lang_id` = 'ja'850μs/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        • 1. ja
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:371
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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 `mi_category`.*, `mi_tr`.`title` from `mi_category` left join `mi_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_category`.`id` where `mi_tr`.`lang_id` = 'ja' and `code` = 'facial-bone' limit 1530μs/app/Http/Controllers/Frontend/ClinicController.php:379lv_misooda_dev
        Metadata
        Bindings
        • 0. ja
        • 1. facial-bone
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:379
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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_cl_image_gr` where `code` = 'top-image' limit 1460μs/app/Http/Controllers/Frontend/ClinicController.php:387lv_misooda_dev
        Metadata
        Bindings
        • 0. top-image
        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/Frontend/ClinicController.php:387
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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_cl_image` where `clinic_id` = 58 and `group_id` = 2540μs/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        • 1. 2
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:392
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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 COUNT(id) AS review_count, AVG(rating_01) AS rating_01, AVG(rating_02) AS rating_02, AVG(rating_03) AS rating_03, AVG(rating_04) AS rating_04, AVG(rating_05) AS rating_05 from `mi_review` where `clinic_id` = 58 group by `clinic_id` limit 1680μs/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:405
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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 count(*) as aggregate from `mi_promotion` where `clinic_id` = 58410μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev
        Metadata
        Bindings
        • 0. 58
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:415
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:197
        • 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 `code` = 'facial-bone' limit 1920μs/app/Composers/ReviewComposer.php:89lv_misooda_dev
        Metadata
        Bindings
        • 0. facial-bone
        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/Composers/ReviewComposer.php:89
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::frontend.clinic.reviews:21
      • select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`rating_01`, `mi_review`.`rating_01`) AS `rating_01`, IFNULL(`mi_rt`.`rating_02`, `mi_review`.`rating_02`) AS `rating_02`, IFNULL(`mi_rt`.`rating_03`, `mi_review`.`rating_03`) AS `rating_03`, IFNULL(`mi_rt`.`rating_04`, `mi_review`.`rating_04`) AS `rating_04`, IFNULL(`mi_rt`.`rating_05`, `mi_review`.`rating_05`) AS `rating_05`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`id` as `clinic_id`, `mi_c`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`, `mi_c`.`name`) AS `clinic_name`, `mi_user`.`id` as `user_id`, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`country`, `mi_user`.`profile_image`, `mi_category`.`id` as `cat_id`, IFNULL(`mi_cat_t`.`title`, `mi_category`.`title`) AS `cat_name` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'ja' inner join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_c`.`id` and `mi_ct`.`lang_id` = 'ja' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` inner join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_cat_t` on `mi_cat_t`.`cat_id` = `mi_category`.`id` and `mi_cat_t`.`lang_id` = 'ja' where `mi_review`.`clinic_id` = 58 and `mi_review`.`category_id` = 48 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 1003.61ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. ja
        • 3. ja
        • 4. ja
        • 5. 58
        • 6. 48
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:97
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 410 and `flag` = 'after' limit 7740μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 410
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 375 and `flag` = 'after' limit 7680μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 375
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 326 and `flag` = 'after' limit 7640μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 326
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 325 and `flag` = 'after' limit 7670μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 325
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 324 and `flag` = 'after' limit 7590μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 324
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 323 and `flag` = 'after' limit 7610μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 323
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 322 and `flag` = 'after' limit 7580μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 322
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 321 and `flag` = 'after' limit 7560μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 321
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 318 and `flag` = 'after' limit 7610μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 318
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 315 and `flag` = 'after' limit 7580μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 315
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 313 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 313
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 312 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 312
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 311 and `flag` = 'after' limit 7500μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 311
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 310 and `flag` = 'after' limit 7580μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 310
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 309 and `flag` = 'after' limit 7540μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 309
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 308 and `flag` = 'after' limit 7590μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 308
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_images_review` where `review_id` = 302 and `flag` = 'after' limit 7460μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 302
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:104
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'ja' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc920μs/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. ja
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Composers/ReviewComposer.php:121
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::frontend.clinic.reviews:21
      • select `mi_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'ja' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc1.08ms/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. ja
        • 1. banner-footer-dark
        Backtrace
        • 14. /app/Composers/BannerComposer.php:20
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 22. view::partials.frontend.footer-dark:66
      App\Model\ImagesReview
      17
      App\Model\Review
      18
      App\Model\ClinicImage
      1
      App\Model\ClinicImageGroup
      1
      App\Model\Category
      13
      App\Model\ClinicCategory
      13
      App\Model\Clinic
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          kscKs1rSACxmaqXzn3DInUVWL2H8ixS7tyryIMa7
          PHPDEBUGBAR_STACK_DATA
          []
          _previous
          array:1 [ "url" => "http://dev.misooda.com/en/clinic/well-plastic-surgery/reviews/liposuction" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /ja/clinic/view-plastic-surgery/reviews/facial-bone
          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.1748673368315.332232797785003425; misooda=f0F1dSN9hs8luYXaWGQF4pPoOIVB8VXNDnibZJ6P; XSRF-TOKEN=eyJpdiI6IjRybWhLMUtKdU1GZ2lLWEhXWjVqQnc9PSIsInZhbHVlIjoiZ0xqdjljeCswQnQ1QjhGdnhLbXBlZ2l5WVgxdmVFd0pPVHlIMU5cLzRZVmt3STFUc3VieFlOSUdSSGc5ODBJbWEiLCJtYWMiOiI1ZjU4OGNjNjhkNjlhYWFlZDNlYjk3NzIwZjNjNTE4MWRhZTZiZTRiOTkxM2RiMmZiMWJhY2NhNWQyZWMxYzM3In0%3D_fbp=fb.1.1748673368315.332232797785003425; misooda=f0F1dSN9hs8luYXaWGQF4pPoOIVB8VXNDnibZJ6P; XSRF-TOKEN=eyJpdiI6IjRybWhLMUtKdU1GZ2lLWEhXWjVqQnc9PSIsInZhbHVlIjo" ] ]
          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.1748673368315.332232797785003425; misooda=f0F1dSN9hs8luYXaWGQF4pPoOIVB8VXNDnibZJ6P; XSRF-TOKEN=eyJpdiI6IjRybWhLMUtKdU1GZ2lLWEhXWjVqQnc9PSIsInZhbHVlIjoiZ0xqdjljeCswQnQ1QjhGdnhLbXBlZ2l5WVgxdmVFd0pPVHlIMU5cLzRZVmt3STFUc3VieFlOSUdSSGc5ODBJbWEiLCJtYWMiOiI1ZjU4OGNjNjhkNjlhYWFlZDNlYjk3NzIwZjNjNTE4MWRhZTZiZTRiOTkxM2RiMmZiMWJhY2NhNWQyZWMxYzM3In0%3D_fbp=fb.1.1748673368315.332232797785003425; misooda=f0F1dSN9hs8luYXaWGQF4pPoOIVB8VXNDnibZJ6P; XSRF-TOKEN=eyJpdiI6IjRybWhLMUtKdU1GZ2lLWEhXWjVqQnc9PSIsInZhbHVlIjo" "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.173.56" "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" => "13399" "REDIRECT_URL" => "/ja/clinic/view-plastic-surgery/reviews/facial-bone" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/ja/clinic/view-plastic-surgery/reviews/facial-bone" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1748673370.886 "REQUEST_TIME" => 1748673370 ]
          request_cookies
          0 of 0
          array:3 [ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "kscKs1rSACxmaqXzn3DInUVWL2H8ixS7tyryIMa7" ]
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 31 May 2025 06:36:10 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IklGUExoeXpJenNOTlZLaDVLdUpKTVE9PSIsInZhbHVlIjoiUmxrUk1NMHhwRHhDampPXC9ybk9nNVdPQVF1VWdPbldXWTZZcEhaTk14SE90VVg0TjhVbTJKM3hFTis5VzZFMWYiLCJtYWMiOiI4YjViODJhNTc5NjQwNjA2ZmI2NWQyZTI1NTQ0ODA5NDMzMjkxNTM0YzMzNDI4MDViOTFjNGI2ODhlNGY3YmNjIn0%3D; expires=Sat, 31-May-2025 08:36:10 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IklGUExoeXpJenNOTlZLaDVLdUpKTVE9PSIsInZhbHVlIjoiUmxrUk1NMHhwRHhDampPXC9ybk9nNVdPQVF1VWdPbldXWTZZcEhaTk14SE90VVg0TjhVbTJKM3hFTis5VzZFMWYiLCJtY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IklGUExoeXpJenNOTlZLaDVLdUpKTVE9PSIsInZhbHVlIjoiUmxrUk1NMHhwRHhDampPXC9ybk9nNVdPQVF1VWdPbldXWTZZcEhaTk14SE90VVg0TjhVbTJKM3hFTis5VzZFMWYiLCJtYWMiOiI4YjViODJhNTc5NjQwNjA2ZmI2NWQyZTI1NTQ0ODA5NDMzMjkxNTM0YzMzNDI4MDViOTFjNGI2ODhlNGY3YmNjIn0%3D; expires=Sat, 31-May-2025 08:36:10 GMT; path=/XSRF-TOKEN=eyJpdiI6IklGUExoeXpJenNOTlZLaDVLdUpKTVE9PSIsInZhbHVlIjoiUmxrUk1NMHhwRHhDampPXC9ybk9nNVdPQVF1VWdPbldXWTZZcEhaTk14SE90VVg0TjhVbTJKM3hFTis5VzZFMWYiLCJtY" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "kscKs1rSACxmaqXzn3DInUVWL2H8ixS7tyryIMa7" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "http://dev.misooda.com/en/clinic/well-plastic-surgery/reviews/liposuction" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]