NAMU Plastic Surgery
NAMU Plastic Surgery
Address : 4th floor, Korea Montessori Bldg, 399, Gangnam-daero, Seocho-gu, Seoul, Korea
Satisfaction :
Specialty : Eye Nose Face lift Breast Fat Grafting Liposuction Toxin Filler Facial Bone
7.2.34PHP Version152msRequest Duration9MBMemory UsageGET {lang}/clinic/{slug}/reviews/{cat?}RouteAuth status
    • Booting (64.82ms)
    • Application (87.28ms)
    • 1 x Application (57.29%)
      87.28ms
      1 x Booting (42.55%)
      64.82ms
      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
        category_id
        31
        list
        32
        rMenuType
        33
        showCats
      • 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
      36 statements were executed25.07ms
      • 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.8ms/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/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` desc1.45ms/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` desc620μ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` = 'en' limit 1580μsmiddleware::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::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` = 'en' and `slug` = 'namu-plastic-surgery' limit 11.27ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 1. namu-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` = 46 and `mi_tr`.`lang_id` = 'en'1.15ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev
        Metadata
        Bindings
        • 0. 46
        • 1. en
        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 * from `mi_cl_image_gr` where `code` = 'top-image' limit 1620μ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` = 46 and `group_id` = 21.03ms/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev
        Metadata
        Bindings
        • 0. 46
        • 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` = 46 group by `clinic_id` limit 1740μs/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev
        Metadata
        Bindings
        • 0. 46
        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` = 46550μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev
        Metadata
        Bindings
        • 0. 46
        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 `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` = 'en' 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` = 'en' 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` = 'en' where `mi_review`.`clinic_id` = 46 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 1003.57ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. en
        • 3. en
        • 4. en
        • 5. 46
        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` = 457 and `flag` = 'after' limit 7630μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 457
        • 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` = 430 and `flag` = 'after' limit 7630μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 430
        • 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` = 447 and `flag` = 'after' limit 7470μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 447
        • 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` = 431 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 431
        • 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` = 429 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 429
        • 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` = 76 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 76
        • 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` = 489 and `flag` = 'after' limit 7380μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 489
        • 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` = 472 and `flag` = 'after' limit 7400μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 472
        • 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` = 461 and `flag` = 'after' limit 7400μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 461
        • 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` = 460 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 460
        • 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` = 455 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 455
        • 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` = 137 and `flag` = 'after' limit 7490μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 137
        • 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` = 136 and `flag` = 'after' limit 7550μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 136
        • 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` = 135 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 135
        • 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` = 134 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 134
        • 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` = 132 and `flag` = 'after' limit 7460μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 132
        • 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` = 130 and `flag` = 'after' limit 7440μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 130
        • 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` = 129 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 129
        • 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` = 127 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 127
        • 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` = 126 and `flag` = 'after' limit 7480μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 126
        • 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` = 124 and `flag` = 'after' limit 7330μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 124
        • 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` = 131 and `flag` = 'after' limit 7310μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 131
        • 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` = 125 and `flag` = 'after' limit 7320μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 125
        • 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` = 'en' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc720μs/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 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` = 'en' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc930μs/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. en
        • 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\Category
      11
      App\Model\ImagesReview
      20
      App\Model\Review
      24
      App\Model\ClinicImage
      5
      App\Model\ClinicImageGroup
      1
      App\Model\ClinicCategory
      9
      App\Model\Clinic
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          qykMsROD0t9SpMuAvSEQ2ziDOR1yyxoObLh5dSaN
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/clinic/namu-plastic-surgery/reviews
          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:8 [ "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" ] ]
          request_server
          0 of 0
          array:33 [ "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" "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.191.246.216" "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" => "24992" "REDIRECT_URL" => "/en/clinic/namu-plastic-surgery/reviews" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en/clinic/namu-plastic-surgery/reviews" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740375655.6 "REQUEST_TIME" => 1740375655 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 24 Feb 2025 05:40:55 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlDbmhKbE1XNnhTVVl0bDVNbFVseGc9PSIsInZhbHVlIjoiUDY5NXNkTlZBb2hDQURHaThCaUd6WDRlc0tOUXNiaVIrcDJJUVU4ZnJLTW5zTEhWeEw3M01lSHBuQ3BhR1c5NSIsIm1hYyI6ImU2NTJjZWMxODkwNzU3Y2UxMjU0ZjM3MDljYzlkNjczOTk4NjMwZjZjNzQzODI2MTg5MjAyYWI4ZDFkNDE4YWEifQ%3D%3D; expires=Mon, 24-Feb-2025 07:40:55 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6ImlDbmhKbE1XNnhTVVl0bDVNbFVseGc9PSIsInZhbHVlIjoiUDY5NXNkTlZBb2hDQURHaThCaUd6WDRlc0tOUXNiaVIrcDJJUVU4ZnJLTW5zTEhWeEw3M01lSHBuQ3BhR1c5NSIsIm1hY" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlDbmhKbE1XNnhTVVl0bDVNbFVseGc9PSIsInZhbHVlIjoiUDY5NXNkTlZBb2hDQURHaThCaUd6WDRlc0tOUXNiaVIrcDJJUVU4ZnJLTW5zTEhWeEw3M01lSHBuQ3BhR1c5NSIsIm1hYyI6ImU2NTJjZWMxODkwNzU3Y2UxMjU0ZjM3MDljYzlkNjczOTk4NjMwZjZjNzQzODI2MTg5MjAyYWI4ZDFkNDE4YWEifQ%3D%3D; expires=Mon, 24-Feb-2025 07:40:55 GMT; path=/XSRF-TOKEN=eyJpdiI6ImlDbmhKbE1XNnhTVVl0bDVNbFVseGc9PSIsInZhbHVlIjoiUDY5NXNkTlZBb2hDQURHaThCaUd6WDRlc0tOUXNiaVIrcDJJUVU4ZnJLTW5zTEhWeEw3M01lSHBuQ3BhR1c5NSIsIm1hY" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "qykMsROD0t9SpMuAvSEQ2ziDOR1yyxoObLh5dSaN" "PHPDEBUGBAR_STACK_DATA" => [] ]