Filter
Career
Major surgical field
Gender
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` = 'en'
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` = 'en' 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` = '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`, `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` = '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 `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` = 'en'
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` = 'en' 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 => "misooda=7VgPVc7iV2Iy9LshR23zGLcvAnG5bZHr8LByr80e; _fbp=fb.1.1761948991432.151995079288140923; XSRF-TOKEN=eyJpdiI6ImQrY2NpMmpHdSs0U3FicEFyb0NuYnc9PSIsInZhbHVlIjoiaUR6ODdYVVdXOEI0ME1lUUlyRkFIME9nK0MyRVdBZUp1eVZYd2lKNk1nZlRpRGdEczQ0WkxCeDVXNURZc1FlbyIsIm1hYyI6ImI3MDc3NGJkMGVlZGY4OThlMzQyNzM0ZWZmZjk2NzIxMDhkZTJiYmM2ZmFhNGUzOGI2YjA4MmQ1NmY4YTU0N2EifQ%3D%3D ◀misooda=7VgPVc7iV2Iy9LshR23zGLcvAnG5bZHr8LByr80e; _fbp=fb.1.1761948991432.151995079288140923; XSRF-TOKEN=eyJpdiI6ImQrY2NpMmpHdSs0U3FicEFyb0NuYnc9PSIsInZhbHVlIjo ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-pww5h (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.9.177.78" ] "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" => "misooda=7VgPVc7iV2Iy9LshR23zGLcvAnG5bZHr8LByr80e; _fbp=fb.1.1761948991432.151995079288140923; XSRF-TOKEN=eyJpdiI6ImQrY2NpMmpHdSs0U3FicEFyb0NuYnc9PSIsInZhbHVlIjoiaUR6ODdYVVdXOEI0ME1lUUlyRkFIME9nK0MyRVdBZUp1eVZYd2lKNk1nZlRpRGdEczQ0WkxCeDVXNURZc1FlbyIsIm1hYyI6ImI3MDc3NGJkMGVlZGY4OThlMzQyNzM0ZWZmZjk2NzIxMDhkZTJiYmM2ZmFhNGUzOGI2YjA4MmQ1NmY4YTU0N2EifQ%3D%3D ◀misooda=7VgPVc7iV2Iy9LshR23zGLcvAnG5bZHr8LByr80e; _fbp=fb.1.1761948991432.151995079288140923; XSRF-TOKEN=eyJpdiI6ImQrY2NpMmpHdSs0U3FicEFyb0NuYnc9PSIsInZhbHVlIjo ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-pww5h (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.9.177.78" "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.15" "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" => "45799" "REDIRECT_URL" => "/m/en/doctor/skin" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/doctor/skin" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1761949005.367 "REQUEST_TIME" => 1761949005 ]
0 of 0 array:3 [▶ "misooda" => null "_fbp" => null "XSRF-TOKEN" => "w61itdHY0arfFbWbahIrRA2HDN67xJLZtXV7281g" ]
0 of 0 array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 31 Oct 2025 22:16:45 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjY0aW5oRG5XXC94T09XcHJETEJXa2hRPT0iLCJ2YWx1ZSI6IndsZktUSjdHaXpsakw4Y1ZCU3krbkNyMEY0Z2NHd2d2UU95clY3SkUwTGYydldkQWdcL1llYmc0Zm9nZllSN1NtIiwibWFjIjoiZWYwM2M0OWZmYjk2MWI0NWNjNzM5NGFlOTg5NzYwYWM4ZDc0NDgyOTRjZDNlOTI0NmUzZTJmOGE0OWYwNjRlNiJ9; expires=Sat, 01-Nov-2025 00:16:45 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjY0aW5oRG5XXC94T09XcHJETEJXa2hRPT0iLCJ2YWx1ZSI6IndsZktUSjdHaXpsakw4Y1ZCU3krbkNyMEY0Z2NHd2d2UU95clY3SkUwTGYydldkQWdcL1llYmc0Zm9nZllSN1NtIiwib ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjY0aW5oRG5XXC94T09XcHJETEJXa2hRPT0iLCJ2YWx1ZSI6IndsZktUSjdHaXpsakw4Y1ZCU3krbkNyMEY0Z2NHd2d2UU95clY3SkUwTGYydldkQWdcL1llYmc0Zm9nZllSN1NtIiwibWFjIjoiZWYwM2M0OWZmYjk2MWI0NWNjNzM5NGFlOTg5NzYwYWM4ZDc0NDgyOTRjZDNlOTI0NmUzZTJmOGE0OWYwNjRlNiJ9; expires=Sat, 01-Nov-2025 00:16:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjY0aW5oRG5XXC94T09XcHJETEJXa2hRPT0iLCJ2YWx1ZSI6IndsZktUSjdHaXpsakw4Y1ZCU3krbkNyMEY0Z2NHd2d2UU95clY3SkUwTGYydldkQWdcL1llYmc0Zm9nZllSN1NtIiwib ▶" ] ]
0 of 0 array:4 [▶ "_token" => "w61itdHY0arfFbWbahIrRA2HDN67xJLZtXV7281g" "PHPDEBUGBAR_STACK_DATA" => [] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/vi/profile/silverjs/reviews" ] ]
