[ DB ] CONNECT:[ UseTime:0.006656s ] mysql:host=mysql-84;port=3306;dbname=tg_iymei;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `app_zhifa_links` [ RunTime:0.004441s ]
[ SQL ] SELECT * FROM `app_zhifa_links` ORDER BY `order_sort` ASC [ RunTime:0.001516s ]
[ SQL ] SHOW COLUMNS FROM `sys_sitetongji` [ RunTime:0.005888s ]
[ SQL ] SELECT * FROM `sys_sitetongji` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002363s ]
[ SQL ] SHOW COLUMNS FROM `sys_areainfo` [ RunTime:0.009536s ]
[ SQL ] SELECT * FROM `sys_areainfo` WHERE ( id='610000' ) LIMIT 1 [ RunTime:0.002097s ]
[ SQL ] SHOW COLUMNS FROM `app_tdk` [ RunTime:0.003246s ]
[ SQL ] SELECT * FROM `app_tdk` WHERE `en_name` = 'hospital' LIMIT 1 [ RunTime:0.001458s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals` [ RunTime:0.004035s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `app_hospitals` `hospital` INNER JOIN `sys_areainfo` `area` ON `area`.`id`=`hospital`.`area` INNER JOIN `app_hospital_project` `ahp` ON `ahp`.`hospital_id`=`hospital`.`id` WHERE `hospital`.`status` = 1 AND `ahp`.`project_id` IN (20009,20010,20012,20013,20014,20017,20018,20019,20025,20026,20027,20028,20029,20030,20031,20032,20034,20036,20037,20041,20079,20088,20094,20097,20098,20106,20107,20108,20109,20110,20111,20112,20113,20117,20118,20119,20120,20121,20123,20124,20125,20126,20129,20131,20132,20133,20134,20135,20136,20137,20138,20139,20140,20142,20143,20144,20154,20155,20156,20157,20158,20159,20160,20161,20166,20167,20168,20169,20170,20171,20172,20173,20174,20175,20177,20181,20182,20183,20184,20185,20186,20187,20188,20189,20190,20191,20194,20195,20196,20197,20198,20199,20200,20204,20205,20207,20208,20209,20210,20225,20226,20227,20228,20229,20230,20231,20232,20233,20234,20235,20236,20237,20238,20239,20240,20241,20242,20243,20244,20245,20246,20247,20248,20249,20250,20251,20252,20253,20254,20255,20256,20257,20258,20259,20260,20261,20262,20263,20264,20265,20266,20267,20268,20269,20270,20271,20272,20273,20274,20275,20276,20278,20279,20280,20281,20282,20283,20284,20285,20286,20287,20288,20289,20290,20291,20292,20293,20294,20295,20296,20297,20298,20299,20300,20301,20302,20303,20304,20305,20306,20307,20308,20309,20310,20311,20312,20313,20314,20315,20316,20317,20318,20319,20320,20321,20322,20323,20324,20325,20326,20327,20328,20329,20330,20331,20332,20333,20334,20335,20336,20337,20338,20339,20340,20341,20342,20343,20344,20345,20346,20347,20348,20349,20350,20351,20352,20353,20354,20355,20356,20357,20358,20359,20360,20361,20362,20363,20364,20365,20366,20367,20368,20369,20370,20371,20372,20373,20374,20375,20376,20377,20378,20379,20380,20381,20382,20383,20384,20385,20386,20387,20388,20389,20390,20391,20392,20393,20394,20395,20396,20397,20398,20399,20400,20401,20402,20403,20404,20405,20406,20407,20408,20409,20410,20411,20412,20413,20414,20415,20416,20417,20418,20419,20420,20421,20422,20423,20424,20425,20426,20427,20428,20429,20430,20431,20432,20433,20434,20435,20436,20437,20438,20439,20440,20441,20442,20443,20444,20445,20446,20447,20448,20449,20450,20451,20452,20453,20454,20455,20456,20457,20458,20459,20460,20461,20462,20463,20464,20465,20466,20467,20468,20469,20470,20471,20472,20473,20474,20475,20476,20477,20478,20479,20480,20481,20482,20483,20484,20485,20486,20487,20488,20489,20490,20491,20492,20493,20494,20495,20496,20497,20498,20499,20500,20501,20502,20503,20504,20505,20506,20507,20508,20509,20530,20531,20532,20533,20534,20535,20536,20537,20538,20539,20540,20541,20542,20543,20544,20545,20546,20558,20559,20560,20561,20562,20563,20564,20565,20566,20567,20568,20569,20570,20571,20572,20573,20575,20576,20578,20579,20580,20581,20593,20594,20595,20724) AND `area`.`fid` = 610000 GROUP BY `hospital`.`id` ) `_group_count_` [ RunTime:0.018714s ]
[ SQL ] SHOW COLUMNS FROM `sys_consult` [ RunTime:0.009346s ]
[ SQL ] SELECT `news`.`id`,`news`.`title`,`news`.`create_time`,`news`.`title_img`,`news`.`view_num`,`news`.`is_show`,`news`.`open_time`,`news`.`type` FROM `sys_consult` `news` WHERE `news`.`open_time` < '2025-04-11 10:22:51' AND `news`.`is_show` = 1 ORDER BY `news`.`is_top` DESC,`news`.`view_num` DESC LIMIT 7 [ RunTime:0.002351s ]
[ SQL ] SELECT `hospital`.`id`,`hospital`.`name`,`hospital`.`logo`,`hospital`.`city`,`hospital`.`state_hospital` FROM `app_hospitals` `hospital` INNER JOIN `app_hospital_project` `shp` ON `shp`.`hospital_id`=`hospital`.`id` WHERE `hospital`.`status` = 1 GROUP BY `hospital`.`id` ORDER BY `hospital`.`is_top` DESC LIMIT 0,5 [ RunTime:0.089560s ]
