Filter
Career
Major surgical field
Jenis Kelamin
Get my surgery quote
ac
conf
langs
doctor_ac
list
cat
all_cats
pageTitle
pageDesc
obLevel
__env
app
cl
lang
errors
showAll
url
active
cats
showall
header
params
footer
tawk
request
isWebView
userData
title
footerParams
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` = 'id'
SELECT
WHERE
select * from `mi_language` order by `id` desc
SELECT *
select * from `mi_language` where `is_active` = 1 order by `id` desc
select * from `mi_language` where `is_active` = 1 and `code` = 'id' limit 1
LIMIT
ORDER BY
select * from `mi_dc_category` where `code` = 'skin' limit 1
select count(*) as aggregate from `mi_doctor` left join `mi_doctor_trans` as `mi_trans` on `mi_trans`.`doctor_id` = `mi_doctor`.`id` and `mi_trans`.`lang_id` = 'id' 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` = 'id' left join (select `mi_doctor_category`.`doctor_id`, `mi_doctor_category`.`category_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` = 'id' 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 `mi_doc_cat`.`category_id` = 23 group by `mi_doctor`.`id`
select `mi_dc_category`.`id`, `mi_dc_category`.`code`, `mi_dct`.`title` from `mi_dc_category` left join `mi_dc_category_trans` as `mi_dct` on `mi_dct`.`cat_id` = `mi_dc_category`.`id` and `mi_dct`.`lang_id` = 'id'
select * from `mi_dc_category` left join `mi_dc_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_dc_category`.`id` where `mi_tr`.`lang_id` = 'id' order by `mi_dc_category`.`order_no` desc, `mi_dc_category`.`id` asc
200
[]
0 of 0 array: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 => "XSRF-TOKEN=eyJpdiI6Iml3T2o5NVlpTjk0TFoxcXBDWjI1d3c9PSIsInZhbHVlIjoiaXBpdWJpdHVwMXlsTGZPc2txXC9lc0hOV0VFb1NsSXdlOUhiaFNiZzBLZElhMEVES0dyVUVlcjZiRVwvQklIU2txIiwibWFjIjoiNmEwOTFhZGRhYmIyYWNmZmMzZWNiNDA4ZjZjYzdmNDEwNWE1MzRjZDlhMjYyMDgxOTYxZDc5MDE5Yjc0OTNmNSJ9; misooda=fs4ciTsr8bCq5UJTIcFJX8bqJyq2lUyrWLFdgGaE; _fbp=fb.1.1752288486229.474623200474697780 ◀XSRF-TOKEN=eyJpdiI6Iml3T2o5NVlpTjk0TFoxcXBDWjI1d3c9PSIsInZhbHVlIjoiaXBpdWJpdHVwMXlsTGZPc2txXC9lc0hOV0VFb1NsSXdlOUhiaFNiZzBLZElhMEVES0dyVUVlcjZiRVwvQklIU2txIiwib ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-d4hlf (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.1.107.43" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0 array: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" => "XSRF-TOKEN=eyJpdiI6Iml3T2o5NVlpTjk0TFoxcXBDWjI1d3c9PSIsInZhbHVlIjoiaXBpdWJpdHVwMXlsTGZPc2txXC9lc0hOV0VFb1NsSXdlOUhiaFNiZzBLZElhMEVES0dyVUVlcjZiRVwvQklIU2txIiwibWFjIjoiNmEwOTFhZGRhYmIyYWNmZmMzZWNiNDA4ZjZjYzdmNDEwNWE1MzRjZDlhMjYyMDgxOTYxZDc5MDE5Yjc0OTNmNSJ9; misooda=fs4ciTsr8bCq5UJTIcFJX8bqJyq2lUyrWLFdgGaE; _fbp=fb.1.1752288486229.474623200474697780 ◀XSRF-TOKEN=eyJpdiI6Iml3T2o5NVlpTjk0TFoxcXBDWjI1d3c9PSIsInZhbHVlIjoiaXBpdWJpdHVwMXlsTGZPc2txXC9lc0hOV0VFb1NsSXdlOUhiaFNiZzBLZElhMEVES0dyVUVlcjZiRVwvQklIU2txIiwib ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-d4hlf (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.107.43" "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.12" "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" => "6894" "REDIRECT_URL" => "/m/id/doctor/skin" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/id/doctor/skin" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1752288488.446 "REQUEST_TIME" => 1752288488 ]
0 of 0 array:3 [▶ "XSRF-TOKEN" => "DgoRa5pA1BF52TUfm0pHeQHzFU5ZgnCbmxOoAScK" "misooda" => null "_fbp" => null ]
0 of 0 array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 12 Jul 2025 02:48:08 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxqZUpHRWp4QWRpNnExbWxHRElTWnc9PSIsInZhbHVlIjoiMWd3cXpBcjkwc3ZTZWR5cGk3dnhDbVFMQUx4dVBIMklPN25UTzUwbCtlVmV6MzI2cVVITFVqVXdDa3N4N1FPYyIsIm1hYyI6Ijc5NjI0ZTFjY2NkMGM0OTU0MzVjZTg4NzU5Y2RiZWYzODM3MTQzOTM2ZWQwY2IwMmUyMjM3ZWQ5ZGYxMzY2Y2UifQ%3D%3D; expires=Sat, 12-Jul-2025 04:48:08 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxqZUpHRWp4QWRpNnExbWxHRElTWnc9PSIsInZhbHVlIjoiMWd3cXpBcjkwc3ZTZWR5cGk3dnhDbVFMQUx4dVBIMklPN25UTzUwbCtlVmV6MzI2cVVITFVqVXdDa3N4N1FPYyIsIm1hY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxqZUpHRWp4QWRpNnExbWxHRElTWnc9PSIsInZhbHVlIjoiMWd3cXpBcjkwc3ZTZWR5cGk3dnhDbVFMQUx4dVBIMklPN25UTzUwbCtlVmV6MzI2cVVITFVqVXdDa3N4N1FPYyIsIm1hYyI6Ijc5NjI0ZTFjY2NkMGM0OTU0MzVjZTg4NzU5Y2RiZWYzODM3MTQzOTM2ZWQwY2IwMmUyMjM3ZWQ5ZGYxMzY2Y2UifQ%3D%3D; expires=Sat, 12-Jul-2025 04:48:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxqZUpHRWp4QWRpNnExbWxHRElTWnc9PSIsInZhbHVlIjoiMWd3cXpBcjkwc3ZTZWR5cGk3dnhDbVFMQUx4dVBIMklPN25UTzUwbCtlVmV6MzI2cVVITFVqVXdDa3N4N1FPYyIsIm1hY ▶" ] ]
0 of 0 array:4 [▶ "_token" => "DgoRa5pA1BF52TUfm0pHeQHzFU5ZgnCbmxOoAScK" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
