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` = 'semi-permanent-make-up' 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` = 30 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 => "_fbp=fb.1.1750259425198.916274390207141175; XSRF-TOKEN=eyJpdiI6Im00U0I1cko1b1wvNGxPQjBjd3BhVHFRPT0iLCJ2YWx1ZSI6ImkzY0N4b1wvbFFINEYweDF2N3c5d3BWcW01UVRQbk0wTFdUam40b3ArSUplTVdobStMbXhwWlZkR2dXV3A5OERUIiwibWFjIjoiZDIxNzgwMDQ4YWJhNWFlN2VlZDlmZDM1MDA4OTY1YWY3MmYwOTk4ZTIxNzI5YzJmZTFjMTM5OGY4MjRmOTE2ZCJ9; misooda=xch5j6MdMhibz7yg0ikzLMLyGYlNOFgJhTiYAM4r ◀_fbp=fb.1.1750259425198.916274390207141175; XSRF-TOKEN=eyJpdiI6Im00U0I1cko1b1wvNGxPQjBjd3BhVHFRPT0iLCJ2YWx1ZSI6ImkzY0N4b1wvbFFINEYweDF2N3c5d3BWcW01UVRQbk0wTFdUa ▶" ] "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" => "_fbp=fb.1.1750259425198.916274390207141175; XSRF-TOKEN=eyJpdiI6Im00U0I1cko1b1wvNGxPQjBjd3BhVHFRPT0iLCJ2YWx1ZSI6ImkzY0N4b1wvbFFINEYweDF2N3c5d3BWcW01UVRQbk0wTFdUam40b3ArSUplTVdobStMbXhwWlZkR2dXV3A5OERUIiwibWFjIjoiZDIxNzgwMDQ4YWJhNWFlN2VlZDlmZDM1MDA4OTY1YWY3MmYwOTk4ZTIxNzI5YzJmZTFjMTM5OGY4MjRmOTE2ZCJ9; misooda=xch5j6MdMhibz7yg0ikzLMLyGYlNOFgJhTiYAM4r ◀_fbp=fb.1.1750259425198.916274390207141175; XSRF-TOKEN=eyJpdiI6Im00U0I1cko1b1wvNGxPQjBjd3BhVHFRPT0iLCJ2YWx1ZSI6ImkzY0N4b1wvbFFINEYweDF2N3c5d3BWcW01UVRQbk0wTFdUa ▶" "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" => "40116" "REDIRECT_URL" => "/m/en/doctor/semi-permanent-make-up" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/doctor/semi-permanent-make-up" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750259427.068 "REQUEST_TIME" => 1750259427 ]
0 of 0 array:3 [▶ "_fbp" => null "XSRF-TOKEN" => "SBUHODWj0aUvffhWx59RenMouXvptLjOAUVpdr0j" "misooda" => null ]
0 of 0 array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 18 Jun 2025 15:10:27 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRVRjdKOGttUE5CNUhQdW9zMGJISGc9PSIsInZhbHVlIjoid2pSNXI1NlV0S0pwbEhRUUMyWDQrbGtERlp1OGFUdExyVHM2SXM5NlhxTGFHS0Y5M0ZBcGJjU1wvOU1wdVJPNHYiLCJtYWMiOiIxMWMyYTkyY2U5ZTVlM2EzZWQ2MmZjYzNmMjBhMjNmZDQ5ZTM3YmQzOGNkYzRlOGVhNjRiMjUwNzE1NGMzODljIn0%3D; expires=Wed, 18-Jun-2025 17:10:27 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRVRjdKOGttUE5CNUhQdW9zMGJISGc9PSIsInZhbHVlIjoid2pSNXI1NlV0S0pwbEhRUUMyWDQrbGtERlp1OGFUdExyVHM2SXM5NlhxTGFHS0Y5M0ZBcGJjU1wvOU1wdVJPNHYiLCJtY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRVRjdKOGttUE5CNUhQdW9zMGJISGc9PSIsInZhbHVlIjoid2pSNXI1NlV0S0pwbEhRUUMyWDQrbGtERlp1OGFUdExyVHM2SXM5NlhxTGFHS0Y5M0ZBcGJjU1wvOU1wdVJPNHYiLCJtYWMiOiIxMWMyYTkyY2U5ZTVlM2EzZWQ2MmZjYzNmMjBhMjNmZDQ5ZTM3YmQzOGNkYzRlOGVhNjRiMjUwNzE1NGMzODljIn0%3D; expires=Wed, 18-Jun-2025 17:10:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRVRjdKOGttUE5CNUhQdW9zMGJISGc9PSIsInZhbHVlIjoid2pSNXI1NlV0S0pwbEhRUUMyWDQrbGtERlp1OGFUdExyVHM2SXM5NlhxTGFHS0Y5M0ZBcGJjU1wvOU1wdVJPNHYiLCJtY ▶" ] ]
0 of 0 array:5 [▶ "_token" => "SBUHODWj0aUvffhWx59RenMouXvptLjOAUVpdr0j" "login_after_url" => "http://dev.misooda.com/add/wish/promotion/132" "_flash" => array:2 [▶ "new" => [] "old" => [] ] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542" ] "PHPDEBUGBAR_STACK_DATA" => [] ]
