1 x Application (68.93%) | 31.65ms |
1 x Booting (30.84%) | 14.16ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'ja'
1.32ms/app/Http/Controllers/FrontendController.php:33lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_language` order by `id` desc
480μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_devMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc
420μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'ja' limit 1
640μsmiddleware::lang:27lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_category` where `code` = 'hairline' limit 1
520μs/app/Http/Controllers/Mobile/ClinicController.php:89lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `mi_clinic` left join `mi_clinic_category` as `mi_c_cat` on `mi_c_cat`.`clinic_id` = `mi_clinic`.`id` left join (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, `clinic_id` from `mi_review` group by `clinic_id`) AS mi_rev on `mi_rev`.`clinic_id` = `mi_clinic`.`id` left join (select COUNT(id) AS promotion_count, `clinic_id` from `mi_promotion` group by `clinic_id`) AS mi_pr on `mi_pr`.`clinic_id` = `mi_clinic`.`id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'ja' where `mi_clinic`.`status` = 1 and `mi_c_cat`.`category_id` = 42 group by `mi_clinic`.`id`
1.89ms/app/Http/Controllers/Mobile/ClinicController.php:95lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `mi_clinic`.`id`, `mi_clinic`.`slug`, `mi_clinic`.`image`, `mi_clinic`.`logo`, `mi_clinic`.`featured`, `mi_clinic`.`gold`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `name`, `mi_rev`.`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, `mi_pr`.`promotion_count` from `mi_clinic` left join `mi_clinic_category` as `mi_c_cat` on `mi_c_cat`.`clinic_id` = `mi_clinic`.`id` left join (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, `clinic_id` from `mi_review` group by `clinic_id`) AS mi_rev on `mi_rev`.`clinic_id` = `mi_clinic`.`id` left join (select COUNT(id) AS promotion_count, `clinic_id` from `mi_promotion` group by `clinic_id`) AS mi_pr on `mi_pr`.`clinic_id` = `mi_clinic`.`id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'ja' where `mi_clinic`.`status` = 1 and `mi_c_cat`.`category_id` = 42 group by `mi_clinic`.`id` order by `mi_clinic`.`order_no` desc limit 10 offset 0
1.99ms/app/Http/Controllers/Mobile/ClinicController.php:95lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `mi_category`.`id`, `mi_category`.`code`, `mi_category`.`title`, `mi_category`.`icon`, `mi_category`.`icon1`, `mi_category`.`icon_another`, `mi_category`.`menu_type`, `mi_category`.`order_no`, `mi_category`.`created_at`, `mi_category`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_category`.`title`) as `title` from `mi_category` left join `mi_category_trans` as `mi_trans` on `mi_trans`.`cat_id` = `mi_category`.`id` and `mi_trans`.`lang_id` = 'ja' order by `mi_category`.`order_no` desc, `mi_category`.`id` asc
970μs/app/Composers/MainComposer.php:39lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
200
[]
[]
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 => "_fbp=fb.1.1750455348516.513023033885978827; misooda=EfzJzq3mcEeyGKkvgQXng7mCAnI8DU7nRBZrca5E; XSRF-TOKEN=eyJpdiI6IkpDM0RZN0phTkVTV3FhdjROeVwvYm5BPT0iLCJ2YWx1ZSI6ImJrbitVNXFzUHJVSGVoSVRqQUhoU3ZDaDIxSHlxcWxhVmMrVG5Sc3dScWd1RjEzMlZ0bVBSYm5QdWRNMnJ3RVgiLCJtYWMiOiJkYTgxM2YyODg3MDkwY2QwNjYxOGZiNTVkODY4ZGUyNDllYjFmYTQ3MTQzM2JjYTI3YzZmN2M0ZjRmZDczYjhlIn0%3D ◀_fbp=fb.1.1750455348516.513023033885978827; misooda=EfzJzq3mcEeyGKkvgQXng7mCAnI8DU7nRBZrca5E; XSRF-TOKEN=eyJpdiI6IkpDM0RZN0phTkVTV3FhdjROeVwvYm5BPT0iLCJ2YWx1ZSI ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-44k92 (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.1.17.91" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0array:36 [▶ "REDIRECT_STATUS" => "200" "HTTP_HOST" => "dev.misooda.com" "HTTP_PRAGMA" => "no-cache" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate" "HTTP_COOKIE" => "_fbp=fb.1.1750455348516.513023033885978827; misooda=EfzJzq3mcEeyGKkvgQXng7mCAnI8DU7nRBZrca5E; XSRF-TOKEN=eyJpdiI6IkpDM0RZN0phTkVTV3FhdjROeVwvYm5BPT0iLCJ2YWx1ZSI6ImJrbitVNXFzUHJVSGVoSVRqQUhoU3ZDaDIxSHlxcWxhVmMrVG5Sc3dScWd1RjEzMlZ0bVBSYm5QdWRNMnJ3RVgiLCJtYWMiOiJkYTgxM2YyODg3MDkwY2QwNjYxOGZiNTVkODY4ZGUyNDllYjFmYTQ3MTQzM2JjYTI3YzZmN2M0ZjRmZDczYjhlIn0%3D ◀_fbp=fb.1.1750455348516.513023033885978827; misooda=EfzJzq3mcEeyGKkvgQXng7mCAnI8DU7nRBZrca5E; XSRF-TOKEN=eyJpdiI6IkpDM0RZN0phTkVTV3FhdjROeVwvYm5BPT0iLCJ2YWx1ZSI ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-44k92 (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.17.91" "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.206" "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" => "13809" "REDIRECT_URL" => "/m/ja/clinics/hairline" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/ja/clinics/hairline" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750455352.586 "REQUEST_TIME" => 1750455352 ]
0 of 0array:3 [▶ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "a4mLsfLiNUdG9fDM9oEeeJXl5EyA9uMKqYH3pAkq" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 20 Jun 2025 21:35:52 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNoenZLRnlRVW5cL1pLbUVIMzJ0QXdBPT0iLCJ2YWx1ZSI6Ink0Q0dKZ3dNa0xYa2s0XC81XC9YZXZ5cHd4MDNmV3hjTmYzYWZvVnRLQUJrd0x6WGtZTmR3cERJTmFXTWl1eHFnbyIsIm1hYyI6IjJiYTVmOWI0YjdjMDhmYzdkNzU0OGQzNjc5MDQ2MjQ5MGE5YzE5MGY3NjliZDE5MGY2ODYxODVkMTQ2NWVmNTMifQ%3D%3D; expires=Fri, 20-Jun-2025 23:35:52 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNoenZLRnlRVW5cL1pLbUVIMzJ0QXdBPT0iLCJ2YWx1ZSI6Ink0Q0dKZ3dNa0xYa2s0XC81XC9YZXZ5cHd4MDNmV3hjTmYzYWZvVnRLQUJrd0x6WGtZTmR3cERJTmFXTWl1eHFnbyIsI ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNoenZLRnlRVW5cL1pLbUVIMzJ0QXdBPT0iLCJ2YWx1ZSI6Ink0Q0dKZ3dNa0xYa2s0XC81XC9YZXZ5cHd4MDNmV3hjTmYzYWZvVnRLQUJrd0x6WGtZTmR3cERJTmFXTWl1eHFnbyIsIm1hYyI6IjJiYTVmOWI0YjdjMDhmYzdkNzU0OGQzNjc5MDQ2MjQ5MGE5YzE5MGY3NjliZDE5MGY2ODYxODVkMTQ2NWVmNTMifQ%3D%3D; expires=Fri, 20-Jun-2025 23:35:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNoenZLRnlRVW5cL1pLbUVIMzJ0QXdBPT0iLCJ2YWx1ZSI6Ink0Q0dKZ3dNa0xYa2s0XC81XC9YZXZ5cHd4MDNmV3hjTmYzYWZvVnRLQUJrd0x6WGtZTmR3cERJTmFXTWl1eHFnbyIsI ▶" ] ]
0 of 0array:5 [▶ "_token" => "a4mLsfLiNUdG9fDM9oEeeJXl5EyA9uMKqYH3pAkq" "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/th/inquiry/promotion/121" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "login_after_url" => "http://dev.misooda.com/zh-CN/chat/clinic/lyhn-clinic" "PHPDEBUGBAR_STACK_DATA" => [] ]