No Preferred Clinic
0
No Preferred Clinic
Description
Specialty
Doctor
Address
Business Time / Map
No Preferred Clinic
Description
Specialty
Doctor
Address
Business Time / Map
| 1 x Booting (50.67%) | 79.94ms |
| 1 x Application (49.19%) | 77.61ms |
| 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 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 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 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
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'4.1ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` order by `id` desc2.07ms/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc3.64ms/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 1550μsmiddleware::lang:27lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `mi_clinic`.`id`, `mi_clinic`.`slug`, `mi_clinic`.`hit`, `mi_clinic`.`gold`, `mi_clinic`.`featured`, `mi_clinic`.`logo`, `mi_clinic`.`image`, `mi_clinic`.`small_image`, `mi_clinic`.`meta_title`, `mi_clinic`.`meta_desc`, `mi_clinic`.`status`, `mi_clinic`.`show_type`, `mi_clinic`.`order_no`, `mi_clinic`.`inq_alert`, `mi_clinic`.`language_codes`, `mi_clinic`.`service_item_codes`, `mi_clinic`.`guarantee_item_codes`, `mi_clinic`.`business_time_table`, `mi_clinic`.`landing_images`, `mi_clinic`.`created_at`, `mi_clinic`.`updated_at`, IFNULL(`mi_trans`.`name`,`mi_clinic`.`name`) as `name`, IFNULL(`mi_trans`.`address`,`mi_clinic`.`address`) as `address`, IFNULL(`mi_trans`.`description`,`mi_clinic`.`description`) as `description`, IFNULL(`mi_trans`.`business_time`,`mi_clinic`.`business_time`) as `business_time`, IFNULL(`mi_trans`.`business_hour`,`mi_clinic`.`business_hour`) as `business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_trans` on `mi_trans`.`clinic_id` = `mi_clinic`.`id` and `mi_trans`.`lang_id` = 'en' where `mi_clinic`.`slug` = 'no-preferred-clinic' limit 11ms/app/Http/Controllers/Mobile/ClinicController.php:430lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `mi_cl_image`.*, `mi_gr`.`code` from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `mi_cl_image`.`clinic_id` = 179 and `mi_gr`.`code` = 'top-image'870μs/app/Http/Controllers/Mobile/ClinicController.php:441lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
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` = 179 group by `clinic_id` limit 1550μs/app/Http/Controllers/Mobile/ClinicController.php:452lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `mi_user_follow` where `post_type` = 'clinic' and `post_id` = 179440μs/app/Http/Controllers/Mobile/ClinicController.php:484lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select IFNULL(`mi_ct`.`title`, `mi_cat`.`title`) AS `title`, `mi_cat`.`code` 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_ct` on `mi_ct`.`cat_id` = `mi_cat`.`id` and `mi_ct`.`lang_id` = 'en' where `mi_clinic_category`.`clinic_id` = 179600μs/app/Http/Controllers/Mobile/ClinicController.php:122lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
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` = 'en' 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` = 'en' 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` = 'en' 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` = 179 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 1002.11ms/app/Composers/MainComposer.php:223lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:10 [▶ "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" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-ldtmg (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.2.142.175" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0array:35 [▶ "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_VIA" => "1.1 squid-proxy-5b5d847c96-ldtmg (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.2.142.175" "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.136" "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" => "2464" "REDIRECT_URL" => "/m/en/clinic/no-preferred-clinic" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/clinic/no-preferred-clinic" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750469069.908 "REQUEST_TIME" => 1750469069 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 21 Jun 2025 01:24:30 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJMdXRZWmFVanRjZHk0R0thclBzRHc9PSIsInZhbHVlIjoiMVMxVDhPTVwvVk14Q2h4cjZYMjducHU0a0FiMTRFNW9CaUZRazdNc2RjMEpLRWpWM0xEdWlWaFNJaVlmbXlvSFIiLCJtYWMiOiJkNWNjNzJlMmU5MTRhOTI5MGE5ZjUwYWExMTAwZWMxNzlkYmI3MzlmOWZkODI4MGEyNWIzNjU5YTNlNTk4MWIzIn0%3D; expires=Sat, 21-Jun-2025 03:24:30 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJMdXRZWmFVanRjZHk0R0thclBzRHc9PSIsInZhbHVlIjoiMVMxVDhPTVwvVk14Q2h4cjZYMjducHU0a0FiMTRFNW9CaUZRazdNc2RjMEpLRWpWM0xEdWlWaFNJaVlmbXlvSFIiLCJtY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJMdXRZWmFVanRjZHk0R0thclBzRHc9PSIsInZhbHVlIjoiMVMxVDhPTVwvVk14Q2h4cjZYMjducHU0a0FiMTRFNW9CaUZRazdNc2RjMEpLRWpWM0xEdWlWaFNJaVlmbXlvSFIiLCJtYWMiOiJkNWNjNzJlMmU5MTRhOTI5MGE5ZjUwYWExMTAwZWMxNzlkYmI3MzlmOWZkODI4MGEyNWIzNjU5YTNlNTk4MWIzIn0%3D; expires=Sat, 21-Jun-2025 03:24:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJMdXRZWmFVanRjZHk0R0thclBzRHc9PSIsInZhbHVlIjoiMVMxVDhPTVwvVk14Q2h4cjZYMjducHU0a0FiMTRFNW9CaUZRazdNc2RjMEpLRWpWM0xEdWlWaFNJaVlmbXlvSFIiLCJtY ▶" ] ]
0 of 0array:2 [▶ "_token" => "9fPvEjjV5aaGPsfme3Ilk5Si6nJrwcF5AatIjhus" "PHPDEBUGBAR_STACK_DATA" => [] ]