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` = 'others' 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` = 35 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 => "XSRF-TOKEN=eyJpdiI6Ik5HSzBkSEoyVm5vYkE5OGxva01QZFE9PSIsInZhbHVlIjoiRkh2K0VRam44UThMQklwWGUxOElMeFVEWlQ3XC9wUWd4M0hBRDNyRzJhQWJCelB5WHVWYkU2RTQ1RXNzTmEycG8iLCJtYWMiOiIzMmZjMDU4MDczNDgwZDc1YzUzMTM3MzRkYmQ5YTUwNDg5OTgwNDFjZmU4MmY2ODQzZjk3ZTkzYjRlN2I3ZWIwIn0%3D; misooda=S4neDCK7SnjWuCdnRywhoEjblVwAXlyGDALT1rYn; _fbp=fb.1.1750277938441.457865499680825600 ◀XSRF-TOKEN=eyJpdiI6Ik5HSzBkSEoyVm5vYkE5OGxva01QZFE9PSIsInZhbHVlIjoiRkh2K0VRam44UThMQklwWGUxOElMeFVEWlQ3XC9wUWd4M0hBRDNyRzJhQWJCelB5WHVWYkU2RTQ1RXNzTmEycG8iLCJtY ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-gnzl5 (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.1.189.34" ] "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=eyJpdiI6Ik5HSzBkSEoyVm5vYkE5OGxva01QZFE9PSIsInZhbHVlIjoiRkh2K0VRam44UThMQklwWGUxOElMeFVEWlQ3XC9wUWd4M0hBRDNyRzJhQWJCelB5WHVWYkU2RTQ1RXNzTmEycG8iLCJtYWMiOiIzMmZjMDU4MDczNDgwZDc1YzUzMTM3MzRkYmQ5YTUwNDg5OTgwNDFjZmU4MmY2ODQzZjk3ZTkzYjRlN2I3ZWIwIn0%3D; misooda=S4neDCK7SnjWuCdnRywhoEjblVwAXlyGDALT1rYn; _fbp=fb.1.1750277938441.457865499680825600 ◀XSRF-TOKEN=eyJpdiI6Ik5HSzBkSEoyVm5vYkE5OGxva01QZFE9PSIsInZhbHVlIjoiRkh2K0VRam44UThMQklwWGUxOElMeFVEWlQ3XC9wUWd4M0hBRDNyRzJhQWJCelB5WHVWYkU2RTQ1RXNzTmEycG8iLCJtY ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-gnzl5 (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.189.34" "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.211" "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" => "10804" "REDIRECT_URL" => "/m/en/doctor/others" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/doctor/others" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750277938.832 "REQUEST_TIME" => 1750277938 ]
0 of 0 array:3 [▶ "XSRF-TOKEN" => "7dtas2QddVON3Eu27Ugy2upaaArSj684dKDaM0tC" "misooda" => null "_fbp" => null ]
0 of 0 array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 18 Jun 2025 20:18:58 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBZRlBtbGVSSzg4ZGhSaUpJRGNGOWc9PSIsInZhbHVlIjoiUTZ2TXQ1cGdOUGk3TjhjRkNGUE94QzJJVzJqTzB1M2xGczNScVEzYVpUbTY2M0ZYeXdybFhNb1FVVnVrVTQ0ZyIsIm1hYyI6IjNjZGQwNDRlOWI0N2E3MDM2MDZmYmUwYmQ4MDZlZTNlOGZjMjJkN2ViNzk3ODUzNWJlNGUxMTBjZGI5MmM3YjgifQ%3D%3D; expires=Wed, 18-Jun-2025 22:18:58 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBZRlBtbGVSSzg4ZGhSaUpJRGNGOWc9PSIsInZhbHVlIjoiUTZ2TXQ1cGdOUGk3TjhjRkNGUE94QzJJVzJqTzB1M2xGczNScVEzYVpUbTY2M0ZYeXdybFhNb1FVVnVrVTQ0ZyIsIm1hY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBZRlBtbGVSSzg4ZGhSaUpJRGNGOWc9PSIsInZhbHVlIjoiUTZ2TXQ1cGdOUGk3TjhjRkNGUE94QzJJVzJqTzB1M2xGczNScVEzYVpUbTY2M0ZYeXdybFhNb1FVVnVrVTQ0ZyIsIm1hYyI6IjNjZGQwNDRlOWI0N2E3MDM2MDZmYmUwYmQ4MDZlZTNlOGZjMjJkN2ViNzk3ODUzNWJlNGUxMTBjZGI5MmM3YjgifQ%3D%3D; expires=Wed, 18-Jun-2025 22:18:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBZRlBtbGVSSzg4ZGhSaUpJRGNGOWc9PSIsInZhbHVlIjoiUTZ2TXQ1cGdOUGk3TjhjRkNGUE94QzJJVzJqTzB1M2xGczNScVEzYVpUbTY2M0ZYeXdybFhNb1FVVnVrVTQ0ZyIsIm1hY ▶" ] ]
0 of 0 array:4 [▶ "_token" => "7dtas2QddVON3Eu27Ugy2upaaArSj684dKDaM0tC" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
