prev
next
韩国佰诺佰琪整容整形医院
韩国佰诺佰琪整容整形医院
地址 : 517, Nonhyeon-ro, Gangnam-gu, Seoul, Korea
满意度 :
专业 : 眼部 鼻部 拉皮 隆胸 脂肪移植 吸脂术 皮肤 毛发 肉毒素 玻尿酸
Chat Now 咨询
最佳评论
促销活动

韩国佰诺佰琪整容整形医院

面部雕刻

￥ 14,619
10%
￥ 13,157

韩国佰诺佰琪整容整形医院

LET美人眼部整形手术

￥ 3,119
13%
￥ 2,729

韩国佰诺佰琪整容整形医院

LET美人隆鼻整形手术

￥ 4,093
10%
￥ 3,703

韩国佰诺佰琪整容整形医院

隆鼻整形手术

￥ 0
25%
￥ 0

韩国佰诺佰琪整容整形医院

方鄂复位术，颧骨整形术，

￥ 0
30%
￥ 0

韩国佰诺佰琪整容整形医院

魔滴假体隆胸术

￥ 0
0%
￥ 0

韩国佰诺佰琪整容整形医院

切开法眼型矫正术 或 上眼睑眼型矫正

￥ 0
0%
￥ 0

韩国佰诺佰琪整容整形医院

切开法面部拉皮术 + 埋线法颈部拉皮术

￥ 0
0%
￥ 0

韩国佰诺佰琪整容整形医院

脂肪移植（整个脸）

￥ 0
0%
￥ 0

韩国佰诺佰琪整容整形医院

隆鼻整形手术

￥ 0
0%
￥ 0

韩国佰诺佰琪整容整形医院

双眼皮埋线法手术加眼型矫正

￥ 0
0%
￥ 0
信息

说明

BANOBAGI thinks that the patients are our family, therefore we do not force excessive surgery or no need surgery to patients for our profitable benefits. Our philosophy of humanism leads us to the best representative of plastic surgery in Korea.

1. 安全事项

麻醉师24小时都在吗？
- Resided Anesthesiologist is available recording 0 medical malpractice cases for 17years since the opening

2. 手术详情

3. 手术后照料

4. 手术前后顾客资料管理

5. 患者信息管理

6. 医院所提供的服务

7. 外国人赔偿保险

8. Certification

9. Language

医生
Kyeong Ho Go

专业委员会

: 整形外科医生

专业

:

经验年份

: 25

Kyeong Ho Go

Jae Sang Ban

专业委员会

:

专业

:

经验年份

: 27

Jae Sang Ban

Chang Hyun Oh

专业委员会

:

专业

:

经验年份

: 25

Chang Hyun Oh

Sun Jae Park

专业委员会

:

专业

:

经验年份

: 24

Sun Jae Park

Hyun Taek Lee

专业委员会

:

专业

:

经验年份

: 23

Hyun Taek Lee

Jong lim Park

专业委员会

:

专业

:

经验年份

: 23

Jong lim Park

Kyu Nam Han

专业委员会

:

专业

:

经验年份

: 16

Kyu Nam Han

Hak Young Kim

专业委员会

:

专业

:

经验年份

: 15

Hak Young Kim

营业时间 / 地图

517, Nonhyeon-ro, Gangnam-gu, Seoul, Korea

营业时间


Sunday and Public Holidays: Closed

营业时间


MON,WED,THU : 10am ~ 6:30pm
TUE,FRI : 10am ~ 8:00pm
SAT: 10am ~ 4:00pm

MessagesTimelineExceptionsViews15RouteQueries34Models163MailsAuthGateSessionRequest
7.2.34PHP Version325msRequest Duration10MBMemory UsageGET {lang}/clinic/{slug}RouteAuth status
    • Booting (36.66ms)
    • Application (288ms)
    • 1 x Application (88.64%)
      287.87ms
      1 x Booting (11.29%)
      36.66ms
      15 templates were rendered
      • frontend.clinic.show (resources/views/frontend/clinic/show.blade.php)20blade
        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
        16
        imageGroups
        17
        images
        18
        galleryImages
        19
        questions
      • partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)26blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
      • partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)38blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        limit
        27
        clinic_id
        28
        showBest
        29
        showAll
        30
        url
        31
        promotion_id
        32
        doctor_id
        33
        type
        34
        category_id
        35
        list
        36
        rMenuType
        37
        showCats
      • partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)38blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        clinic_id
        27
        limit
        28
        showBest
        29
        showAll
        30
        url
        31
        category_id
        32
        type
        33
        not_id
        34
        list
        35
        rMenuType
        36
        showCats
        37
        showHotDeal
      • partials.shortcode.doctor_list (resources/views/partials/shortcode/doctor_list.blade.php)35blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        clinic_id
        33
        limit
        34
        list
      • partials.shortcode.follow_list (resources/views/partials/shortcode/follow_list.blade.php)41blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        post_type
        35
        post_id
        36
        limit
        37
        showTitle
        38
        url
        39
        user_id
        40
        follows
      • layouts.frontend (resources/views/layouts/frontend.blade.php)35blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
      • partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)35blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
      • partials.frontend.header2 (resources/views/partials/frontend/header2.blade.php)35blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
      • partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)36blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
      • partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)42blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
        36
        group
        37
        showImg
        38
        limit
        39
        list
        40
        showTitle
        41
        showExcerpt
      • partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)36blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
      • partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)36blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
      • partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)36blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
      • partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)36blade
        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
        imageGroups
        23
        images
        24
        galleryImages
        25
        questions
        26
        q_index
        27
        first_col
        28
        __currentLoopData
        29
        item
        30
        loop
        31
        q
        32
        gr
        33
        img
        34
        header
        35
        footer
      uri
      GET {lang}/clinic/{slug}
      middleware
      web, lang, redirect.tomobile
      controller
      App\Http\Controllers\Frontend\ClinicController@show
      namespace
      App\Http\Controllers\Frontend
      prefix
      /{lang}
      where
      file
      app/Http/Controllers/Frontend/ClinicController.php:108-192
      34 statements were executed, 2 of which were duplicated, 32 unique129ms
      lv_misooda_dev
      • 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` = 'zh-CN'7.51ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        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` desc490μ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` desc410μ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` = 'zh-CN' limit 12.27msmiddleware::lang:27lv_misooda_dev
        Metadata
        Bindings
        • 0. 1
        • 1. zh-CN
        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` = 'zh-CN' and `slug` = 'banobagi-plastic-surgery' limit 14.28ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 1. banobagi-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:110
        • 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` = 19 and `mi_tr`.`lang_id` = 'zh-CN'1.49ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 1. zh-CN
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:371
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:110
        • 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 13.96ms/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:110
        • 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` = 19 and `group_id` = 21.53ms/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 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:110
        • 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` = 19 group by `clinic_id` limit 12.16ms/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        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:110
        • 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` = 198.19ms/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:415
        • 16. /app/Http/Controllers/Frontend/ClinicController.php:110
        • 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_cl_image_gr`.`id`, `mi_cl_image_gr`.`code`, `mi_cl_image_gr`.`order_no`, `mi_cl_image_gr`.`static`, `mi_cl_image_gr`.`created_at`, `mi_cl_image_gr`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_cl_image_gr`.`title`) as `title` from `mi_cl_image_gr` inner join `mi_cl_image` as `mi_cl_img` on `clinic_id` = 19 and `mi_cl_image_gr`.`id` = `mi_cl_img`.`group_id` left join `mi_cl_image_gr_trans` as `mi_trans` on `mi_trans`.`cl_image_gid` = `mi_cl_image_gr`.`id` and `mi_trans`.`lang_id` = 'zh-CN' where `mi_cl_image_gr`.`static` = 0 group by `mi_cl_image_gr`.`id`1.28ms/app/Http/Controllers/Frontend/ClinicController.php:124lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 1. zh-CN
        • 2. 0
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:124
        • 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_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 19 and `mi_gr`.`static` = 0520μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 1. 0
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:131
        • 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
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `mi_cl_image`.* from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 19 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 0530μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev
        Metadata
        Bindings
        • 0. 19
        • 1. 0
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:131
        • 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
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select count(*) as aggregate from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'zh-CN' and `mi_gallery`.`clinic_id` = 19 group by `mi_gallery`.`id`14.68ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. left
        • 1. right
        • 2. gallery
        • 3. zh-CN
        • 4. 19
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:157
        • 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
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `mi_gallery`.*, `mi_tr`.`title`, `mi_tr`.`description`, `mi_img_left`.`path` as `left_path`, `mi_img_right`.`path` as `right_path`, COUNT(mi_ul.user_id) AS like_count from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'zh-CN' and `mi_gallery`.`clinic_id` = 19 group by `mi_gallery`.`id` order by `mi_gallery`.`created_at` desc limit 20 offset 061.53ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev
        Metadata
        Bindings
        • 0. left
        • 1. right
        • 2. gallery
        • 3. zh-CN
        • 4. 19
        Backtrace
        • 15. /app/Http/Controllers/Frontend/ClinicController.php:157
        • 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
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `mi_cl_question_gr`.`id`, IFNULL(`mi_qgt`.`title`,`mi_cl_question_gr`.`title`) as `title` from `mi_cl_question_gr` left join `mi_cl_question_gr_trans` as `mi_qgt` on `mi_qgt`.`cl_q_gid` = `mi_cl_question_gr`.`id` and `mi_qgt`.`lang_id` = 'zh-CN'1.32ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Http/Controllers/Frontend/ClinicController.php:187
        • 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 `mi_cl_question`.`id`, `mi_cl_question`.`group_id`, `mi_cl_question`.`order_no`, IFNULL(`mi_qt`.`question`,`mi_cl_question`.`question`) as `question`, `mi_at`.`answer` from `mi_cl_question` left join `mi_cl_question_trans` as `mi_qt` on `mi_cl_question`.`id` = `mi_qt`.`cl_q_id` and `mi_qt`.`lang_id` = 'zh-CN' left join `mi_cl_answer` as `mi_ca` on `mi_ca`.`question_id` = `mi_cl_question`.`id` left join `mi_cl_answer_trans` as `mi_at` on `mi_at`.`cl_answer_id` = `mi_ca`.`id` and `mi_at`.`lang_id` = 'zh-CN' where `mi_cl_question`.`group_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10) and `mi_ca`.`clinic_id` = 19 order by `mi_cl_question`.`order_no` asc1.97ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 1. zh-CN
        • 2. 19
        Backtrace
        • 19. /app/Http/Controllers/Frontend/ClinicController.php:187
        • 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 `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` = 'zh-CN' 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` = 'zh-CN' 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` = 'zh-CN' where `mi_review`.`clinic_id` = 19 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 102.2ms/app/Composers/ReviewComposer.php:97lv_misooda_dev
        Metadata
        Bindings
        • 0. before
        • 1. after
        • 2. zh-CN
        • 3. zh-CN
        • 4. zh-CN
        • 5. 19
        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.show:222
      • select * from `mi_images_review` where `review_id` = 72 and `flag` = 'after' limit 7710μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 72
        • 1. after
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/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.show:222
      • select * from `mi_images_review` where `review_id` = 446 and `flag` = 'after' limit 7550μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 446
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 382 and `flag` = 'after' limit 7520μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 382
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 139 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 139
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 133 and `flag` = 'after' limit 7390μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 133
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 128 and `flag` = 'after' limit 7410μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 128
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 122 and `flag` = 'after' limit 71.65ms/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 122
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 117 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 117
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 118 and `flag` = 'after' limit 7420μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 118
        • 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.show:222
      • select * from `mi_images_review` where `review_id` = 116 and `flag` = 'after' limit 7400μs/app/Composers/ReviewComposer.php:104lv_misooda_dev
        Metadata
        Bindings
        • 0. 116
        • 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.show:222
      • 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` = 'zh-CN' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc650μs/app/Composers/ReviewComposer.php:121lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 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.show:222
      • select `mi_promotion`.*, IFNULL(`mi_pt`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`title`,`mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`description`,`mi_promotion`.`description`) AS `description`, IFNULL(`mi_pt`.`caution_before`,`mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`,`mi_promotion`.`caution_after`) AS `caution_after`, `mi_clinic`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `clinic_name` from `mi_promotion` left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'zh-CN' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'zh-CN' where `mi_promotion`.`clinic_id` = 19 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 121.76ms/app/Composers/PromotionComposer.php:66lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 1. zh-CN
        • 2. 19
        Backtrace
        • 14. /app/Composers/PromotionComposer.php:66
        • 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.show:230
      • 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` = 'zh-CN' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc730μs/app/Composers/PromotionComposer.php:79lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Composers/PromotionComposer.php:79
        • 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.show:230
      • select `mi_doctor`.`id`, `mi_doctor`.`email`, `mi_doctor`.`gender`, `mi_doctor`.`board_of_specialty`, `mi_doctor`.`years_of_experiences`, `mi_doctor`.`active_clinic`, `mi_doctor`.`created_at`, `mi_doctor`.`updated_at`, `mi_doctor`.`meta_title`, `mi_doctor`.`meta_desc`, `mi_doctor`.`image`, `mi_doctor`.`cover_image`, IFNULL(`mi_trans`.`name`,`mi_doctor`.`name`) as `name`, IFNULL(`mi_trans`.`title`,`mi_doctor`.`title`) as `title`, IFNULL(`mi_trans`.`school_name`,`mi_doctor`.`school_name`) as `school_name`, IFNULL(`mi_trans`.`internship`,`mi_doctor`.`internship`) as `internship`, IFNULL(`mi_trans`.`residentship`,`mi_doctor`.`residentship`) as `residentship`, IFNULL(`mi_trans`.`academic_activity`,`mi_doctor`.`academic_activity`) as `academic_activity`, IFNULL(`mi_trans`.`awards`,`mi_doctor`.`awards`) as `awards`, IFNULL(`mi_trans`.`thesis`,`mi_doctor`.`thesis`) as `thesis`, 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`, IFNULL(`mi_cdbt`.`title`, `mi_cdb`.`title`) AS `board_specialty_title`, `mi_doc_cat`.`cat_title` as `specialty_title`, `mi_doc_cat`.`cat_percent` as `specialty_percent`, `mi_doc_cat`.`sub_title1`, `mi_doc_cat`.`sub_title2`, `mi_doc_cat`.`sub_title3` from `mi_doctor` left join `mi_doctor_trans` as `mi_trans` on `mi_trans`.`doctor_id` = `mi_doctor`.`id` and `mi_trans`.`lang_id` = 'zh-CN' left join `mi_review` on `mi_review`.`doctor_id` = `mi_doctor`.`id` left join `mi_category_doctor_board` as `mi_cdb` on `mi_cdb`.`id` = `mi_doctor`.`board_of_specialty` left join `mi_category_doctor_board_trans` as `mi_cdbt` on `mi_cdbt`.`cat_id` = `mi_cdb`.`id` and `mi_cdbt`.`lang_id` = 'zh-CN' left join (select `mi_doctor_category`.`doctor_id`, GROUP_CONCAT(IFNULL(`mi_dct`.`title`, `mi_dc`.`title`)) AS `cat_title`, GROUP_CONCAT(IFNULL(`mi_doctor_category`.`percent`, 0)) AS `cat_percent`, GROUP_CONCAT(`mi_dccs1`.`title`) AS `sub_title1`, GROUP_CONCAT(`mi_dccs2`.`title`) AS `sub_title2`, GROUP_CONCAT(`mi_dccs3`.`title`) AS `sub_title3` from `mi_doctor_category` left join `mi_dc_category` as `mi_dc` on `mi_dc`.`id` = `mi_doctor_category`.`category_id` left join `mi_dc_category_trans` as `mi_dct` on `mi_dct`.`cat_id` = `mi_dc`.`id` and `mi_dct`.`lang_id` = 'zh-CN' left join `mi_dc_category_sub` as `mi_dccs1` on `mi_dccs1`.`id` = `mi_doctor_category`.`sub_1` left join `mi_dc_category_sub` as `mi_dccs2` on `mi_dccs2`.`id` = `mi_doctor_category`.`sub_2` left join `mi_dc_category_sub` as `mi_dccs3` on `mi_dccs3`.`id` = `mi_doctor_category`.`sub_3` group by `mi_doctor_category`.`doctor_id`) as `mi_doc_cat` on `mi_doc_cat`.`doctor_id` = `mi_doctor`.`id` where `active_clinic` = 19 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 82.29ms/app/Composers/MainComposer.php:223lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 1. zh-CN
        • 2. zh-CN
        • 3. 19
        Backtrace
        • 14. /app/Composers/MainComposer.php:223
        • 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.show:294
      • select `mi_user_follow`.*, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`profile_image` from `mi_user_follow` left join `mi_user` on `mi_user`.`id` = `mi_user_follow`.`user_id` where `post_type` = 'clinic' and `post_id` = 19 order by `mi_user_follow`.`created_at` desc840μs/app/Composers/MainComposer.php:264lv_misooda_dev
        Metadata
        Bindings
        • 0. clinic
        • 1. 19
        Backtrace
        • 14. /app/Composers/MainComposer.php:264
        • 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.show:423
      • 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` = 'zh-CN' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc810μs/app/Composers/BannerComposer.php:20lv_misooda_dev
        Metadata
        Bindings
        • 0. zh-CN
        • 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\UserFollow
      1
      App\Model\Doctor
      8
      App\Model\Promotion
      11
      App\Model\Category
      22
      App\Model\ImagesReview
      10
      App\Model\ClinicQuestion
      35
      App\Model\ClinicQuestionGroup
      9
      App\Model\Gallery
      20
      App\Model\Review
      11
      App\Model\ClinicImage
      5
      App\Model\ClinicImageGroup
      2
      App\Model\ClinicCategory
      10
      App\Model\Clinic
      1
      App\Model\Language
      18
        web
        null
        api
        null
          _token
          Mv1YNUd5kZZnLMIZrT3aLCQrAi4JmJUXKMQPWEg6
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /zh-CN/clinic/banobagi-plastic-surgery
          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.222.220.80"
  "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" => "7822"
  "REDIRECT_URL" => "/zh-CN/clinic/banobagi-plastic-surgery"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/zh-CN/clinic/banobagi-plastic-surgery"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744628589.635
  "REQUEST_TIME" => 1744628589
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 14 Apr 2025 11:03:09 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZZZ1hRZGREdHJcL2R4dkdldnV4V0x3PT0iLCJ2YWx1ZSI6IjFpQXJDMlp0U0pYZmZOWE84YUJaZlE0SU0zT3hteWdFeHd2Q2k1NTBxdmxyQXFrSTZxZlRoMkpZdGpCR3piYUUiLCJtYWMiOiJhNjllN2ZlODY4OWFmNGIyYTBjMDU3ZjAzNzA4Y2JmZmM0NzJiMDVlNmFlZmI2MTZmN2MwODFjNjI3OWVlMGU2In0%3D; expires=Mon, 14-Apr-2025 13:03:09 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZZZ1hRZGREdHJcL2R4dkdldnV4V0x3PT0iLCJ2YWx1ZSI6IjFpQXJDMlp0U0pYZmZOWE84YUJaZlE0SU0zT3hteWdFeHd2Q2k1NTBxdmxyQXFrSTZxZlRoMkpZdGpCR3piYUUiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZZZ1hRZGREdHJcL2R4dkdldnV4V0x3PT0iLCJ2YWx1ZSI6IjFpQXJDMlp0U0pYZmZOWE84YUJaZlE0SU0zT3hteWdFeHd2Q2k1NTBxdmxyQXFrSTZxZlRoMkpZdGpCR3piYUUiLCJtYWMiOiJhNjllN2ZlODY4OWFmNGIyYTBjMDU3ZjAzNzA4Y2JmZmM0NzJiMDVlNmFlZmI2MTZmN2MwODFjNjI3OWVlMGU2In0%3D; expires=Mon, 14-Apr-2025 13:03:09 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZZZ1hRZGREdHJcL2R4dkdldnV4V0x3PT0iLCJ2YWx1ZSI6IjFpQXJDMlp0U0pYZmZOWE84YUJaZlE0SU0zT3hteWdFeHd2Q2k1NTBxdmxyQXFrSTZxZlRoMkpZdGpCR3piYUUiLCJtY ▶"
  ]
]
          session_attributes
            0 of 0   
          array:2 [▶
  "_token" => "Mv1YNUd5kZZnLMIZrT3aLCQrAi4JmJUXKMQPWEg6"
  "PHPDEBUGBAR_STACK_DATA" => []
]