陈美茹医生怎么样_深圳仁爱医院陈美茹资料及治疗价格查询-土拨鼠爱牙测试

基本文件流程错误 SQL 调试

/www/wwwroot/test.92ya.com/m.php ( 1.12 KB )
/www/wwwroot/test.92ya.com/public.php ( 1.64 KB )
/www/wwwroot/test.92ya.com/thinkphp/start.php ( 0.72 KB )
/www/wwwroot/test.92ya.com/thinkphp/base.php ( 2.60 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Loader.php ( 20.23 KB )
/www/wwwroot/test.92ya.com/vendor/composer/autoload_namespaces.php ( 0.15 KB )
/www/wwwroot/test.92ya.com/vendor/composer/autoload_psr4.php ( 0.21 KB )
/www/wwwroot/test.92ya.com/vendor/composer/autoload_classmap.php ( 0.23 KB )
/www/wwwroot/test.92ya.com/vendor/composer/autoload_files.php ( 0.43 KB )
/www/wwwroot/test.92ya.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 3.96 KB )
/www/wwwroot/test.92ya.com/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Route.php ( 58.86 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Config.php ( 6.38 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Validate.php ( 40.54 KB )
/www/wwwroot/test.92ya.com/vendor/topthink/think-testing/src/config.php ( 0.65 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Console.php ( 22.65 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Error.php ( 3.79 KB )
/www/wwwroot/test.92ya.com/thinkphp/convention.php ( 10.10 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/App.php ( 22.18 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Request.php ( 48.58 KB )
/www/wwwroot/test.92ya.com/application/config.php ( 29.58 KB )
/www/wwwroot/test.92ya.com/application/database.php ( 2.49 KB )
/www/wwwroot/test.92ya.com/application/extra/case.php ( 10.14 KB )
/www/wwwroot/test.92ya.com/application/extra/cookie.php ( 0.42 KB )
/www/wwwroot/test.92ya.com/application/extra/doctor.php ( 13.22 KB )
/www/wwwroot/test.92ya.com/application/extra/expert.php ( 0.17 KB )
/www/wwwroot/test.92ya.com/application/extra/project_type.php ( 1.75 KB )
/www/wwwroot/test.92ya.com/application/extra/session.php ( 0.44 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Hook.php ( 4.71 KB )
/www/wwwroot/test.92ya.com/application/tags.php ( 1.03 KB )
/www/wwwroot/test.92ya.com/application/common.php ( 80.11 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Env.php ( 1.21 KB )
/www/wwwroot/test.92ya.com/thinkphp/helper.php ( 21.82 KB )
/www/wwwroot/test.92ya.com/application/function.php ( 149.60 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Lang.php ( 7.23 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Log.php ( 6.04 KB )
/www/wwwroot/test.92ya.com/thinkphp/lang/zh-cn.php ( 11.58 KB )
/www/wwwroot/test.92ya.com/application/route.php ( 16.42 KB )
/www/wwwroot/test.92ya.com/application/m/config.php ( 0.75 KB )
/www/wwwroot/test.92ya.com/application/m/html.php ( 0.96 KB )
/www/wwwroot/test.92ya.com/application/m/duan.php ( 36.26 KB )
/www/wwwroot/test.92ya.com/application/m/controller/Expert.php ( 36.86 KB )
/www/wwwroot/test.92ya.com/application/m/controller/MobileBase.php ( 17.04 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Controller.php ( 7.31 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/View.php ( 6.77 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Template.php ( 45.34 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/template/driver/File.php ( 2.17 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Session.php ( 10.86 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Db.php ( 6.67 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/db/Connection.php ( 30.08 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/db/Query.php ( 90.32 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/db/builder/Mysql.php ( 4.22 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/db/Builder.php ( 30.65 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Cache.php ( 6.10 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/cache/driver/File.php ( 7.22 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Cookie.php ( 7.54 KB )
/www/wwwroot/test.92ya.com/application/common/model/Region.php ( 19.92 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Model.php ( 68.14 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/cache/driver/Redis.php ( 5.64 KB )
/www/wwwroot/test.92ya.com/application/common/logic/HospitalLogic.php ( 36.70 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Debug.php ( 7.13 KB )
/www/wwwroot/test.92ya.com/application/common/model/ArticleUniqueTags.php ( 1.31 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ExpertLogic.php ( 39.01 KB )
/www/wwwroot/test.92ya.com/application/common/logic/HospitalTagsLogic.php ( 3.26 KB )
/www/wwwroot/test.92ya.com/application/common/logic/BaseLogic.php ( 5.14 KB )
/www/wwwroot/test.92ya.com/application/common/logic/HospitalMealLogic.php ( 24.70 KB )
/www/wwwroot/test.92ya.com/application/common/logic/OrderDiaryLogic.php ( 15.69 KB )
/www/wwwroot/test.92ya.com/application/common/logic/UsersLogic.php ( 3.96 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ExpertCaseLogic.php ( 8.56 KB )
/www/wwwroot/test.92ya.com/application/common/logic/KepuLogic.php ( 20.10 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ProjectYuyueLogic.php ( 3.38 KB )
/www/wwwroot/test.92ya.com/runtime/temp/17d5c1337864b9c6e256c12d5b52c623.php ( 60.82 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Url.php ( 12.71 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Response.php ( 8.33 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/debug/Html.php ( 4.16 KB )

[ LANG ] /www/wwwroot/test.92ya.com/thinkphp/lang/zh-cn.php
[ BIND ] 'm'
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'm', 1 => 'Expert', 2 => 'detail', ), 'convert' => false, )
[ HEADER ] array ( 'cookie' => 'referer_time=2025-09-08+07%3A50%3A40; area_code=0532; first_visit=https%3A%2F%2Ftest.92ya.com%2Fvideo%2Fdetail_8.html; is_mobile=0; PHPSESSID=8msckc0d6b2o573ahpqsbl5oj6; area_city_name=%E9%9D%92%E5%B2%9B', 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'host' => 'testm.92ya.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'eid' => '12', )
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'httponly' => true, 'secure' => false, 'domain' => '.92ya.com', 'expire' => 2592000, )
[ DB ] INIT mysql
[ CACHE ] INIT File
[ CACHE ] INIT redis
[ RUN ] app\m\controller\Expert->detail[ /www/wwwroot/test.92ya.com/application/m/controller/Expert.php ]
[ VIEW ] ./template/mobile/speakphp/expert/detail.html [ array ( 0 => 'action', 1 => 'template_now_time', 2 => 'is_login', 3 => 'user_info', 4 => 'tpshop_config', 5 => 'hospital_hospital_baidu_brower_key', 6 => 'username', 7 => 'M_HOST', 8 => 'PC_HOST', 9 => 'STATIC_HOST', 10 => 'ATTACHMENT_HOST', 11 => 'area_code', 12 => 'area_city_name', 13 => 'zuixin_hospital', 14 => 'hot_artcile_tags', 15 => 'info', 16 => 'comboData', 17 => 'comboDataCount', 18 => 'comboDataPagesize', 19 => 'diaryData', 20 => 'diaryDataCount', 21 => 'diaryDataPagesize', 22 => 'expertCaseData', 23 => 'expertCaseDataCount', 24 => 'expertCaseDataPagesize', 25 => 'kepuData', 26 => 'kepuDataCount', 27 => 'kepuDataPagesize', 28 => 'list_expert_edu', 29 => 'expert_haibao', 30 => 'seo_title', 31 => 'seo_keywords', 32 => 'seo_description', ) ]

[ DB ] CONNECT:[ UseTime:0.000273s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] select a.hid,a.name,a.alias_name,a.logo,a.thum,a.province,a.city,a.region,a.meal_num,a.yuyue_num,a.score from ebx_hospital as a where a.status = 1 and a.is_show = 1 AND a.city = '173' order by a.add_time desc limit 20 [ RunTime:0.000493s ]
[ SQL ] SHOW COLUMNS FROM `ebx_expert` [ RunTime:0.001106s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000836s ]
[ SQL ] select b.* from ebx_hospital_tag_config as a left join ebx_hospital_tags as b on a.number=b.tag_id where a.`is_open`=1 and a.`deleted`=0 and a.type='expert_mytag' and b.type='expert_mytag' and b.hid=12 order by a.weight asc [ RunTime:0.000439s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.000712s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 12 AND `type` = 'learn_rank' [ RunTime:0.000266s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.000699s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE ( is_open = 1 and type = "learn_rank" and number in (10) ) ORDER BY weight desc [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 12 AND `type` = 'company_auth' [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE ( is_open = 1 and type = "company_auth" and number in (9) ) ORDER BY weight desc [ RunTime:0.000208s ]
[ SQL ] select a.tid , b.name , b.w_price, b.y_price , b.thum ,b.cat_top_id , b.cat_two_id , c.name as h_name , c.yuyue_num , b.yuyue_count ,b.virtual_sell ,b.pic_data from ebx_hospital_meal_expert as a left join ebx_hospital_meal as b on a.tid = b.tid left join ebx_hospital as c on c.hid = b.hid where a.eid = '12' AND b.status = 1 and b.is_upper = 1 order by b.weight asc , b.add_time desc LIMIT 0,100 [ RunTime:0.000617s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_expert as a left join ebx_hospital_meal as b on a.tid = b.tid left join ebx_hospital as c on c.hid = b.hid where a.eid = '12' AND b.status = 1 and b.is_upper = 1 [ RunTime:0.000272s ]
[ SQL ] select * from ebx_order_diary as a where 1 = 1 AND a.is_open = 1 and a.auth_status = 1 AND a.eid = '12' order by a.create_date desc limit 0,10 [ RunTime:0.000267s ]
[ SQL ] select count(*) as c from ebx_order_diary as a where 1 = 1 AND a.is_open = 1 and a.auth_status = 1 AND a.eid = '12' [ RunTime:0.000192s ]
[ SQL ] select count(*) as c from ebx_expert_case as a left join ebx_hospital as b on a.hid=b.hid where a.is_show = 1 and a.xiaoguo_pic!='' AND a.eid = 12 [ RunTime:0.000287s ]
[ SQL ] select a.* from ebx_expert_case as a left join ebx_hospital as b on a.hid=b.hid where a.is_show = 1 and a.xiaoguo_pic!='' AND a.eid = 12 ORDER BY a.publish_time desc LIMIT 0,5 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital` [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `ebx_hospital` WHERE `hid` = 88 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000718s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `id` = 2334 LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `id` = 8673 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SHOW COLUMNS FROM `ebx_project_type` [ RunTime:0.000747s ]
[ SQL ] SELECT * FROM `ebx_project_type` WHERE `cat_id` = 91 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] select count(*) as c from ebx_kepu as a left join ebx_expert as e on a.eid=e.eid where a.is_open = 1 AND a.kepu_type = 1 AND a.eid = 12 [ RunTime:0.000330s ]
[ SQL ] select a.*, e.`eid` AS `exp__eid`, e.`name` AS `exp__name`, e.`pic` AS `exp__pic`, e.`title` AS `exp__title`, e.`description` As `exp__description`, e.`weight` AS `exp__weight`, e.`status` AS `exp__status`, e.`add_time` AS `exp__add_time`, e.`is_show` AS `exp__is_show`, e.`number` AS `exp__number`, e.`zizhi_pic` AS `exp__zizhi_pic`, e.`rongyu_pic` AS `exp__rongyu_pic`, e.`edit_time` AS `exp__edit_time`, e.`worker_year` AS `exp__worker_year`, e.`diary_count` AS `exp__diary_count` from ebx_kepu as a left join ebx_expert as e on a.eid=e.eid where a.is_open = 1 AND a.kepu_type = 1 AND a.eid = 12 ORDER BY a.publish_time desc LIMIT 0,10 [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000737s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000280s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=10 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000732s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000266s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=32 [ RunTime:0.000216s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000726s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.001309s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=31 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.001011s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000366s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=19 [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000976s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000379s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=18 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000994s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000367s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=12 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000399s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000979s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000363s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=11 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000405s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.001026s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000315s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=9 [ RunTime:0.000231s ]
[ SQL ] SELECT * FROM `ebx_expert` WHERE `eid` = 12 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] select a.hid,b.* from ebx_expert_hospital as a left join ebx_hospital as b on a.hid=b.hid where a.eid='12' order by b.weight asc [ RunTime:0.000760s ]
[ SQL ] select a.cat_id,b.cat_name from ebx_expert_project_type as a left join ebx_project_type as b on a.cat_id=b.cat_id where a.eid='12' order by b.sort_order asc [ RunTime:0.000271s ]
[ SQL ] select a.*,b.tag_id,b.letter from ebx_kepu_tags as a left join ebx_article_unique_tags as b on a.tag=b.tag where a.kepu_id=8 [ RunTime:0.000231s ]
[ SQL ] SHOW COLUMNS FROM `ebx_expert_edu` [ RunTime:0.000723s ]
[ SQL ] SELECT * FROM `ebx_expert_edu` WHERE `eid` = 12 AND `is_delete` = 2 ORDER BY weight desc [ RunTime:0.000240s ]
[ SQL ] select a.name as pyname,b.pyid,b.id,b.price,b.max_price from ebx_project_yuyue as a left join ebx_expert_project_yuyue as b on a.id=b.pyid where eid = 12 and a.is_show = 1 and b.is_show = 1 [ RunTime:0.000285s ]
[ SQL ] select d.*,(select count(*) from ebx_doctor_multi_job as dmj where dmj.doctor_id=d.doctor_id and dmj.`status`=1) as dmj_count, a.xueli_json,a.miaoshu,a.xueshu,a.title,a.jiyu from ebx_doctor as d left join ebx_doctor_data as a on d.doctor_id=a.doctor_id where d.pcno = '120360104000111' limit 1 [ RunTime:0.016580s ]