| 1 x Application (68.91%) | 91.70ms |
| 1 x Booting (30.89%) | 41.11ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
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'3.78ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` order by `id` desc2.05ms/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc6.86ms/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'zh-CN' limit 11.07msmiddleware::lang:27lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, 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_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_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` = '46' order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 2 offset 22.94ms/app/Http/Controllers/Mobile/ReviewController.php:536lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `mi_images_review` where `review_id` = 447 and `flag` = 'after' limit 7930μs/app/Http/Controllers/Mobile/ReviewController.php:542lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_images_review` where `review_id` = 431 and `flag` = 'after' limit 7840μs/app/Http/Controllers/Mobile/ReviewController.php:542lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_category_trans` where `cat_id` = 48 and `lang_id` = 'zh-CN' limit 1860μs/app/Http/Controllers/Mobile/ReviewController.php:124lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_clinic_trans` where `clinic_id` = 46 and `lang_id` = 'zh-CN' limit 1870μs/app/Http/Controllers/Mobile/ReviewController.php:130lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_review_trans` where `review_id` = 447 and `lang_id` = 'zh-CN' limit 1880μs/app/Http/Controllers/Mobile/ReviewController.php:136lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_images_review` where `review_id` = 447 and `flag` = 'after' limit 7780μs/app/Http/Controllers/Mobile/ReviewController.php:145lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_category_trans` where `cat_id` = 39 and `lang_id` = 'zh-CN' limit 1780μs/app/Http/Controllers/Mobile/ReviewController.php:124lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_clinic_trans` where `clinic_id` = 46 and `lang_id` = 'zh-CN' limit 1840μs/app/Http/Controllers/Mobile/ReviewController.php:130lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_review_trans` where `review_id` = 431 and `lang_id` = 'zh-CN' limit 1770μs/app/Http/Controllers/Mobile/ReviewController.php:136lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_images_review` where `review_id` = 431 and `flag` = 'after' limit 7750μs/app/Http/Controllers/Mobile/ReviewController.php:145lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 4471.16ms/app/Model/Review.php:75lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 447 and `mi_comments_review`.`post_id` is not null1.03ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 4311.01ms/app/Model/Review.php:75lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 431 and `mi_comments_review`.`post_id` is not null820μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:2 [▶ "clinic_id" => "46" "page" => "2" ]
0 of 0array:2 [▶ "clinic_id" => "46" "page" => "2" ]
0 of 0array:11 [▶ "host" => array:1 [▶ 0 => "dev.misooda.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate" ] "cookie" => array:1 [▶ 0 => "misooda=LLgiZtza0mHmaZxwSPn6CSEx2iLKTKGtDqER0GOn; _fbp=fb.1.1763115925549.222966654616623780; XSRF-TOKEN=eyJpdiI6Inc2OUJUMHFKakk5VCtLb21UbGUzalE9PSIsInZhbHVlIjoiV2lrZDhQRHU5T3NOZmIrbHlSV2Q4V2JVK1grUnZCZ0orWVJ1QytrK0lFYlhcL0FNTlNmV0s2VXdwK3ZcL1dPYUJQIiwibWFjIjoiMjJmMzgzZDU0YTc2NzY4MWFhZDgwMzJiOGM1OWYzMzZmMmFiMWNiNzk3MzU4N2FmOGM4NDlhZjIxMDExZmUzOSJ9 ◀misooda=LLgiZtza0mHmaZxwSPn6CSEx2iLKTKGtDqER0GOn; _fbp=fb.1.1763115925549.222966654616623780; XSRF-TOKEN=eyJpdiI6Inc2OUJUMHFKakk5VCtLb21UbGUzalE9PSIsInZhbHVlIjo ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-bg2d9 (squid/6.13)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.9.237.221" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0array:37 [▶ "REDIRECT_STATUS" => "200" "HTTP_HOST" => "dev.misooda.com" "HTTP_PRAGMA" => "no-cache" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate" "HTTP_COOKIE" => "misooda=LLgiZtza0mHmaZxwSPn6CSEx2iLKTKGtDqER0GOn; _fbp=fb.1.1763115925549.222966654616623780; XSRF-TOKEN=eyJpdiI6Inc2OUJUMHFKakk5VCtLb21UbGUzalE9PSIsInZhbHVlIjoiV2lrZDhQRHU5T3NOZmIrbHlSV2Q4V2JVK1grUnZCZ0orWVJ1QytrK0lFYlhcL0FNTlNmV0s2VXdwK3ZcL1dPYUJQIiwibWFjIjoiMjJmMzgzZDU0YTc2NzY4MWFhZDgwMzJiOGM1OWYzMzZmMmFiMWNiNzk3MzU4N2FmOGM4NDlhZjIxMDExZmUzOSJ9 ◀misooda=LLgiZtza0mHmaZxwSPn6CSEx2iLKTKGtDqER0GOn; _fbp=fb.1.1763115925549.222966654616623780; XSRF-TOKEN=eyJpdiI6Inc2OUJUMHFKakk5VCtLb21UbGUzalE9PSIsInZhbHVlIjo ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-bg2d9 (squid/6.13)" "HTTP_X_FORWARDED_FOR" => "10.9.237.221" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)" "SERVER_NAME" => "dev.misooda.com" "SERVER_ADDR" => "139.59.109.168" "SERVER_PORT" => "80" "REMOTE_ADDR" => "216.73.216.99" "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" => "4308" "REDIRECT_URL" => "/m/zh-CN/review/ajax" "REDIRECT_QUERY_STRING" => "clinic_id=46&page=2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "clinic_id=46&page=2" "REQUEST_URI" => "/m/zh-CN/review/ajax?clinic_id=46&page=2" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1763115937.937 "REQUEST_TIME" => 1763115937 ]
0 of 0array:3 [▶ "misooda" => null "_fbp" => null "XSRF-TOKEN" => "T5f7mYfdTMvEauibuoyUYHYx4AxG0IaqE8LNCxNS" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 14 Nov 2025 10:25:38 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Iml2dk9uQ0VUYVRrYmJ0U2hhK1FmK2c9PSIsInZhbHVlIjoiRWRoYjJkejdXT3RoTldUdnJhcEVPZ2x2Q3BGeE5Ub2NJeE93UjE2SGFEYk1ESk5mdHd5MmFWZGVzQThtdXJyaSIsIm1hYyI6IjBhOTU1YTVhNDA2NzRiYzIxZGMzMmUwZDE4OGU3YTA5YTA2MjRkMzE1NzNhZmIxMjNlZjZlOWRkNWNjYjA1MDQifQ%3D%3D; expires=Fri, 14-Nov-2025 12:25:38 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Iml2dk9uQ0VUYVRrYmJ0U2hhK1FmK2c9PSIsInZhbHVlIjoiRWRoYjJkejdXT3RoTldUdnJhcEVPZ2x2Q3BGeE5Ub2NJeE93UjE2SGFEYk1ESk5mdHd5MmFWZGVzQThtdXJyaSIsIm1hY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Iml2dk9uQ0VUYVRrYmJ0U2hhK1FmK2c9PSIsInZhbHVlIjoiRWRoYjJkejdXT3RoTldUdnJhcEVPZ2x2Q3BGeE5Ub2NJeE93UjE2SGFEYk1ESk5mdHd5MmFWZGVzQThtdXJyaSIsIm1hYyI6IjBhOTU1YTVhNDA2NzRiYzIxZGMzMmUwZDE4OGU3YTA5YTA2MjRkMzE1NzNhZmIxMjNlZjZlOWRkNWNjYjA1MDQifQ%3D%3D; expires=Fri, 14-Nov-2025 12:25:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Iml2dk9uQ0VUYVRrYmJ0U2hhK1FmK2c9PSIsInZhbHVlIjoiRWRoYjJkejdXT3RoTldUdnJhcEVPZ2x2Q3BGeE5Ub2NJeE93UjE2SGFEYk1ESk5mdHd5MmFWZGVzQThtdXJyaSIsIm1hY ▶" ] ]
0 of 0array:4 [▶ "_token" => "T5f7mYfdTMvEauibuoyUYHYx4AxG0IaqE8LNCxNS" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/en/clinic/top-class-plastic-surgery/promotions/two-jaw" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]