中山牙齿矫正_种植牙_中山口腔健康服务平台-土拨鼠爱牙测试

基本文件流程错误 SQL 调试

/www/wwwroot/test.92ya.com/home.php ( 1.08 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/home/config.php ( 1.00 KB )
/www/wwwroot/test.92ya.com/application/home/duan.php ( 36.26 KB )
/www/wwwroot/test.92ya.com/application/home/html.php ( 0.96 KB )
/www/wwwroot/test.92ya.com/application/home/common.php ( 3.70 KB )
/www/wwwroot/test.92ya.com/application/home/controller/Index.php ( 26.07 KB )
/www/wwwroot/test.92ya.com/application/home/controller/Base.php ( 30.59 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/application/common/logic/BaseLogic.php ( 5.14 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Model.php ( 68.14 KB )
/www/wwwroot/test.92ya.com/application/common/model/Region.php ( 19.92 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/cache/driver/Redis.php ( 5.64 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Cookie.php ( 7.54 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/logic/FriendLinkLogic.php ( 1.81 KB )
/www/wwwroot/test.92ya.com/application/common/model/ArticleUniqueTags.php ( 1.31 KB )
/www/wwwroot/test.92ya.com/application/common/logic/CommonCartLogic.php ( 12.61 KB )
/www/wwwroot/test.92ya.com/application/common/logic/RegionLogic.php ( 15.25 KB )
/www/wwwroot/test.92ya.com/application/common/logic/SearchLogic.php ( 142.26 KB )
/www/wwwroot/test.92ya.com/application/common/model/SearchKeywords.php ( 0.82 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ProjectTypeLogic.php ( 9.08 KB )
/www/wwwroot/test.92ya.com/application/common/model/ProjectType.php ( 1.22 KB )
/www/wwwroot/test.92ya.com/application/m/logic/MealLogic.php ( 9.05 KB )
/www/wwwroot/test.92ya.com/application/common/logic/HospitalMealLogic.php ( 24.70 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ExpertLogic.php ( 39.01 KB )
/www/wwwroot/test.92ya.com/application/common/logic/PhysicalCardLogic.php ( 23.46 KB )
/www/wwwroot/test.92ya.com/application/common/logic/KepuLogic.php ( 20.10 KB )
/www/wwwroot/test.92ya.com/application/common/logic/NewsLogic.php ( 40.78 KB )
/www/wwwroot/test.92ya.com/application/common/logic/ArticleLogic.php ( 4.68 KB )
/www/wwwroot/test.92ya.com/application/common/model/ArticleCat.php ( 0.80 KB )
/www/wwwroot/test.92ya.com/application/common/logic/UsersLogic.php ( 3.96 KB )
/www/wwwroot/test.92ya.com/application/common/logic/DaoyuanzhifuLogic.php ( 53.16 KB )
/www/wwwroot/test.92ya.com/runtime/temp/06438b60592b1b5dd66f615b3b4f0e9b.php ( 53.11 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Url.php ( 12.71 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/exception/ErrorException.php ( 1.83 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/Exception.php ( 1.60 KB )
/www/wwwroot/test.92ya.com/thinkphp/library/think/exception/Handle.php ( 8.56 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 ] 'home'
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'home', 1 => 'index', 2 => 'index', ), 'convert' => false, )
[ HEADER ] array ( 'cookie' => 'first_visit=https%3A%2F%2Ftest.92ya.com%2F020%2Fexpert; area_code=020; is_mobile=0; PHPSESSID=5nttaglsf4016uht2qobtksac5; referer_time=2025-09-07+14%3A54%3A36; area_city_name=%E5%B9%BF%E5%B7%9E', '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' => 'test.92ya.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'act' => '0760', )
[ 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\home\controller\Index->index[ /www/wwwroot/test.92ya.com/application/home/controller/Index.php ]
[ VIEW ] ./template/pc/speakphp/index/index.html [ array ( 0 => 'action', 1 => 'template_now_time', 2 => 'is_login', 3 => 'user_info', 4 => 'is_login_store', 5 => 'user_info_store', 6 => 'hospital_hospital_baidu_brower_key', 7 => 'curpageurl', 8 => 'encode_curpageurl', 9 => 'tpshop_config', 10 => 'M_HOST', 11 => 'PC_HOST', 12 => 'STATIC_HOST', 13 => 'ATTACHMENT_HOST', 14 => 'area_code', 15 => 'area_city_name', 16 => 'hot_hospital_data_small', 17 => 'friend_link', 18 => 'hot_city_data', 19 => 'zuixin_hospital', 20 => 'hot_artcile_tags', 21 => 'common_cart_number', 22 => 'CurrCityHasHospitalCity', 23 => 'hotSearchKeywords', 24 => 'common_project_type', 25 => 'ProjectType', 26 => 'cityRegion', 27 => 'project_list', 28 => 'recommend_hospital_list', 29 => 'r_hospital', 30 => 'r_expert', 31 => 'list_physical_card', 32 => 'kepu_video_74', 33 => 'kepu_video_70', 34 => 'news_list_18', 35 => 'news_list_20', 36 => 'news_list_21', 37 => 'input_project_type', 38 => 'recommendExpert', 39 => 'zizhi', 40 => 'c_menu', 41 => 'seo_title', 42 => 'seo_keywords', 43 => 'seo_description', ) ]

[ DB ] CONNECT:[ UseTime:0.000282s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] select hid,name,alias_name from ebx_hospital as a where a.status = '1' and a.is_show = 1 AND a.city = '251' order by a.weight asc,add_time desc limit 20 [ RunTime:0.000448s ]
[ SQL ] select link_id,link_name,link_url,target from ebx_friend_link where 1 = 1 AND is_show = 1 AND ( city = '251' or province = 0 ) order by `orderby` desc limit 100 [ RunTime:0.000361s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region` where 1 = 1 AND is_hot = 1 and area_code is not null and open_pingtai=1 order by weight asc limit 100 [ RunTime:0.000579s ]
[ 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 = '251' order by a.add_time desc limit 20 [ RunTime:0.000540s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_unique_tags` [ RunTime:0.000922s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` ORDER BY create_date desc LIMIT 0,20 [ RunTime:0.000335s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.000797s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = '5nttaglsf4016uht2qobtksac5' LIMIT 1 [ RunTime:0.000237s ]
[ SQL ] select a.province,a.city,a.region from ebx_hospital as a where a.status = '1' and a.is_show = 1 AND a.city = '251' group by a.region limit 1000 [ RunTime:0.000517s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000954s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE ( is_show=1 and area_code="0760" and type=1 and count>3 ) ORDER BY `count` desc,`id` desc LIMIT 10 [ RunTime:0.000489s ]
[ SQL ] select * from ebx_project_type as a where is_show = 1 order by a.sort_order asc [ RunTime:0.000459s ]
[ SQL ] SHOW COLUMNS FROM `ebx_project_type` [ RunTime:0.001011s ]
[ SQL ] SELECT * FROM `ebx_project_type` WHERE `is_show` = 1 AND `parent_id` = 0 ORDER BY `sort_order` asc [ RunTime:0.000380s ]
[ SQL ] select `id`,`name`,`area_code`,`level` from `ebx_region` where 1 = 1 AND parent_id = '251' order by weight asc limit 100 [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `ebx_project_type` WHERE `is_show` = 1 AND `parent_id` = 0 ORDER BY `sort_order` asc [ RunTime:0.000389s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '70' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000528s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '70' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000823s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '74' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000675s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '74' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000812s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '68' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000513s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '68' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000813s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '69' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000528s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '69' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000831s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '72' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000516s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '72' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000826s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '73' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000494s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '73' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000818s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '87' and a.`recommend` = '1' AND b.city = '251' [ RunTime:0.000501s ]
[ SQL ] select a.* ,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and a.`cat_top_id` = '87' and a.`recommend` = '1' AND b.city = '251' GROUP BY a.tid order by a.weight asc , a.tid asc LIMIT 0,5 [ RunTime:0.000796s ]
[ SQL ] select `id`,`name`,`area_code`,`level` from `ebx_region` where 1 = 1 AND parent_id = '251' order by weight asc limit 100 [ RunTime:0.000476s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10227' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000440s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10243' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000421s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10242' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000361s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10241' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000367s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10240' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000391s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10239' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000365s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10238' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000356s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10237' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000339s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10236' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000361s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10235' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000344s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10234' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000353s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10233' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000349s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10232' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000352s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10231' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000366s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10230' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000345s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10229' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000357s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10228' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000344s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 and region = '10244' order by a.weight asc , a.add_time desc limit 9 [ RunTime:0.000357s ]
[ SQL ] select a.* from ebx_hospital as a where a.status = 1 and a.is_show = 1 and is_recommend = 1 AND a.city = '251' order by a.weight asc,a.add_time desc limit 9 [ RunTime:0.000616s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) [ RunTime:0.000527s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000520s ]
[ SQL ] select a.*,b.cat_name as b__cat_name,b.parent_id as b__parent_id,c.hid as c__hid, c.jigoujiesuan_price as c__jigoujiesuan_price,c.xiaoshou_price as c__xiaoshou_price, c.menzhen_price as c__menzhen_price,c.haoyuan as c__haoyuan,c.is_show as c__is_show, (select count(*) from ebx_physical_card_hospital as d where d.physical_id=a.physical_id and d.hid>0) as hospital_count from ebx_physical_card as a left join ebx_project_type as b on a.cat_id=b.cat_id left join ebx_physical_card_hospital as c on c.physical_id=a.physical_id and c.is_show=1 where a.status=1 and a.is_show=1 and b.is_show=1 and c.is_show=1 and c.hid>0 and a.qudao='tuboshu' group by a.physical_id order by a.weight asc [ RunTime:0.001135s ]
[ SQL ] SELECT `cat_id`,`cat_name`,`parent_id` FROM `ebx_project_type` WHERE `is_show` = 1 ORDER BY parent_id asc [ RunTime:0.000278s ]
[ 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.cat_id in (74,104) AND a.kepu_type = 1 [ RunTime:0.000356s ]
[ 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.cat_id in (74,104) AND a.kepu_type = 1 ORDER BY a.weight asc , a.publish_time desc LIMIT 0,6 [ RunTime:0.000357s ]
[ SQL ] SELECT `cat_id`,`cat_name`,`parent_id` FROM `ebx_project_type` WHERE `is_show` = 1 ORDER BY parent_id asc [ RunTime:0.000278s ]
[ 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.cat_id in (70,93,96,92,91) AND a.kepu_type = 1 [ RunTime:0.001557s ]
[ 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.cat_id in (70,93,96,92,91) AND a.kepu_type = 1 ORDER BY a.weight asc , a.publish_time desc LIMIT 0,6 [ RunTime:0.000469s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_cat` [ RunTime:0.001100s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000235s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000224s ]
[ SQL ] select count(*) as c from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (18,25,32,33) [ RunTime:0.000583s ]
[ SQL ] select a.article_id,a.cat_id,a.title,a.author,a.come_from,a.keywords,a.add_time,a.introduction,a.update_time, a.description,a.publish_time,a.thumb,a.video_thumb,a.image_url,a.user_id,a.type,a.click,a.virtual_num,a.zan,a.virtual_zan,b.cat_name from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (18,25,32,33) order by a.weight desc,a.publish_time desc limit 0,7 [ RunTime:0.000691s ]
[ SQL ] SHOW COLUMNS FROM `ebx_users` [ RunTime:0.001092s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_tags` [ RunTime:0.000850s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 55 [ RunTime:0.000268s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('淋巴癌','淋巴癌预防') [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 54 [ RunTime:0.000240s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 53 [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 52 [ RunTime:0.000220s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('胚抗原','血清癌','饮食') [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 51 [ RunTime:0.000215s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('保证体检','注意体检') [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 50 [ RunTime:0.000232s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('伤瘢痕癌','例假期间','尿液检查','瘢痕癌') [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000235s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 46 [ RunTime:0.000198s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('临床表现','吞咽闲难','婚前检查') [ RunTime:0.000217s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '55' [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '淋巴癌' LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '淋巴癌预防' LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '54' [ RunTime:0.000186s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '53' [ RunTime:0.000172s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '52' [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '胚抗原' LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '血清癌' LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '饮食' LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '51' [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '保证体检' LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '注意体检' LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '50' [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '伤瘢痕癌' LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '例假期间' LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '尿液检查' LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '瘢痕癌' LIMIT 1 [ RunTime:0.000207s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '46' [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '临床表现' LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '吞咽闲难' LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '婚前检查' LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000237s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000199s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000196s ]
[ SQL ] select count(*) as c from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (20,35,36,37,45) [ RunTime:0.000470s ]
[ SQL ] select a.article_id,a.cat_id,a.title,a.author,a.come_from,a.keywords,a.add_time,a.introduction,a.update_time, a.description,a.publish_time,a.thumb,a.video_thumb,a.image_url,a.user_id,a.type,a.click,a.virtual_num,a.zan,a.virtual_zan,b.cat_name from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (20,35,36,37,45) order by a.weight desc,a.publish_time desc limit 0,7 [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 66 [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000237s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 65 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 64 [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 63 [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 62 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 61 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 60 [ RunTime:0.000192s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '66' [ RunTime:0.000176s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '65' [ RunTime:0.000165s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '64' [ RunTime:0.000164s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '63' [ RunTime:0.000163s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '62' [ RunTime:0.000174s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '61' [ RunTime:0.000160s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '60' [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000194s ]
[ SQL ] select count(*) as c from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (21,41,42,43,44) [ RunTime:0.000467s ]
[ SQL ] select a.article_id,a.cat_id,a.title,a.author,a.come_from,a.keywords,a.add_time,a.introduction,a.update_time, a.description,a.publish_time,a.thumb,a.video_thumb,a.image_url,a.user_id,a.type,a.click,a.virtual_num,a.zan,a.virtual_zan,b.cat_name from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND a.cat_id in (21,41,42,43,44) order by a.weight desc,a.publish_time desc limit 0,7 [ RunTime:0.000556s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 188 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 98 [ RunTime:0.000220s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('测试标签','第一','第一个标签') [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 123 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 97 [ RunTime:0.000201s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('最后标签','第一个标签') [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 96 [ RunTime:0.000206s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000230s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 73 [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 72 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 71 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 70 [ RunTime:0.000191s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '98' [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '测试标签' LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一' LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一个标签' LIMIT 1 [ RunTime:0.000235s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '97' [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '最后标签' LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一个标签' LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '96' [ RunTime:0.000194s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '73' [ RunTime:0.000180s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '72' [ RunTime:0.000163s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '71' [ RunTime:0.000161s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '70' [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `ebx_project_type` WHERE `is_show` = 1 AND `parent_id` = 0 ORDER BY `sort_order` asc [ RunTime:0.000511s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '70' ) group by aa.eid ) [ RunTime:0.000649s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '70' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000958s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '74' ) group by aa.eid ) [ RunTime:0.000647s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '74' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000598s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '68' ) group by aa.eid ) [ RunTime:0.000643s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '68' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000950s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '69' ) group by aa.eid ) [ RunTime:0.000658s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '69' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000932s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '72' ) group by aa.eid ) [ RunTime:0.000645s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '72' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000921s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '73' ) group by aa.eid ) [ RunTime:0.000643s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '73' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.001048s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '87' ) group by aa.eid ) [ RunTime:0.000643s ]
[ SQL ] select * from ebx_expert as a where a.is_show = 1 AND a.eid in ( select aa.eid from ebx_expert_hospital as aa where hid in ( select hid from ebx_hospital as h where h.is_show = 1 AND h.city = '251' ) group by aa.eid ) AND a.eid in ( select aa.eid from ebx_expert_project_type as aa where cat_id in ( select cat_id from ebx_project_type as h where h.is_show = 1 and h.cat_id = '87' ) group by aa.eid ) ORDER BY a.weight asc , a.add_time desc LIMIT 0,5 [ RunTime:0.000932s ]
[ SQL ] select count(*) as c from ebx_hospital as a where 1 = 1 AND a.status = 1 and a.is_show = 1 AND a.city = '251' limit 1 [ RunTime:0.000474s ]

热门城市

更多城市