Server : nginx/1.20.1
System : Linux iZ2ze9ojcl78uluczwag69Z 4.18.0-240.22.1.el8_3.x86_64 #1 SMP Thu Apr 8 19:01:30 UTC 2021 x86_64
User : www ( 1000)
PHP Version : 7.3.28
Disable Function : passthru,exec,system,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
Directory :  /www/wwwroot/0531yanglao.com/runtime/index/log/202411/
Upload File :
Current Directory [ Writeable ] Root Directory [ Writeable ]


Current File : /www/wwwroot/0531yanglao.com/runtime/index/log/202411/09.log
[2024-11-09T00:12:37+08:00][sql] CONNECT:[ UseTime:0.265468s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:12:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.143694s ]
[2024-11-09T00:12:37+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 54 LIMIT 1 [ RunTime:0.031701s ]
[2024-11-09T00:12:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.081675s ]
[2024-11-09T00:12:37+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 54  AND `table_type` = 'nursing_home_comment' [ RunTime:0.011879s ]
[2024-11-09T00:12:37+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 54 [ RunTime:0.139904s ]
[2024-11-09T00:12:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.011979s ]
[2024-11-09T00:12:37+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000663s ]
[2024-11-09T00:12:37+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.084027s ]
[2024-11-09T00:12:41+08:00][sql] CONNECT:[ UseTime:0.046075s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:12:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.148967s ]
[2024-11-09T00:12:41+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 54 LIMIT 1 [ RunTime:0.030488s ]
[2024-11-09T00:12:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.018868s ]
[2024-11-09T00:12:41+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 54  AND `table_type` = 'nursing_home_comment' [ RunTime:0.011070s ]
[2024-11-09T00:12:41+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 54 [ RunTime:0.063766s ]
[2024-11-09T00:12:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.057470s ]
[2024-11-09T00:12:41+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.012776s ]
[2024-11-09T00:12:41+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.045482s ]
[2024-11-09T00:12:45+08:00][sql] CONNECT:[ UseTime:0.000460s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:12:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001769s ]
[2024-11-09T00:12:45+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 54 LIMIT 1 [ RunTime:0.000556s ]
[2024-11-09T00:12:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001182s ]
[2024-11-09T00:12:45+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 54  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000321s ]
[2024-11-09T00:12:45+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 54 [ RunTime:0.540535s ]
[2024-11-09T00:12:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.041186s ]
[2024-11-09T00:12:45+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000466s ]
[2024-11-09T00:12:45+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.085401s ]
[2024-11-09T00:23:29+08:00][sql] CONNECT:[ UseTime:0.050145s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.092575s ]
[2024-11-09T00:23:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '3'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '2000' AND '3000'  LIMIT 1 [ RunTime:0.041401s ]
[2024-11-09T00:23:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.169102s ]
[2024-11-09T00:23:29+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.010822s ]
[2024-11-09T00:23:29+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000244s ]
[2024-11-09T00:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.067709s ]
[2024-11-09T00:23:29+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.021633s ]
[2024-11-09T00:23:29+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.090363s ]
[2024-11-09T00:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.034670s ]
[2024-11-09T00:23:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000674s ]
[2024-11-09T00:23:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.023650s ]
[2024-11-09T00:23:33+08:00][sql] CONNECT:[ UseTime:0.086048s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:23:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.106517s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.033531s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000362s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.022022s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.021822s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000300s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.011190s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000324s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.021582s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000328s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.011243s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.010569s ]
[2024-11-09T00:23:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.022059s ]
[2024-11-09T00:31:10+08:00][sql] CONNECT:[ UseTime:0.390545s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T00:31:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.072417s ]
[2024-11-09T00:31:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.038715s ]
[2024-11-09T00:31:10+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.028749s ]
[2024-11-09T00:31:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.131203s ]
[2024-11-09T00:31:10+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` = 42 LIMIT 1 [ RunTime:0.028651s ]
[2024-11-09T00:31:10+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` = 42 LIMIT 1 [ RunTime:0.010701s ]
[2024-11-09T00:31:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.087159s ]
[2024-11-09T00:31:10+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.010940s ]
[2024-11-09T00:31:10+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.112736s ]
[2024-11-09T00:31:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.025693s ]
[2024-11-09T00:31:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000725s ]
[2024-11-09T00:31:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.054672s ]
[2024-11-09T01:03:33+08:00][sql] CONNECT:[ UseTime:0.000475s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:03:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001733s ]
[2024-11-09T01:03:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '1' LIMIT 1 [ RunTime:0.000457s ]
[2024-11-09T01:03:33+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `type` = '1' ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.001013s ]
[2024-11-09T01:03:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.106315s ]
[2024-11-09T01:03:33+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (53,50,49,48,43,39,38,33,32,31) LIMIT 1 [ RunTime:0.000475s ]
[2024-11-09T01:03:33+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (53,50,49,48,43,39,38,33,32,31) LIMIT 1 [ RunTime:0.021827s ]
[2024-11-09T01:03:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.012413s ]
[2024-11-09T01:03:33+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.012071s ]
[2024-11-09T01:03:33+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.141839s ]
[2024-11-09T01:03:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.051899s ]
[2024-11-09T01:03:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.053081s ]
[2024-11-09T01:03:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.055558s ]
[2024-11-09T01:04:55+08:00][sql] CONNECT:[ UseTime:0.345604s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:04:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.113728s ]
[2024-11-09T01:04:55+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 53 LIMIT 1 [ RunTime:0.043375s ]
[2024-11-09T01:04:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.035882s ]
[2024-11-09T01:04:55+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 53  AND `table_type` = 'nursing_home_comment' [ RunTime:0.033909s ]
[2024-11-09T01:04:55+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 53 [ RunTime:0.088091s ]
[2024-11-09T01:04:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.049136s ]
[2024-11-09T01:04:55+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.011155s ]
[2024-11-09T01:04:55+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.034415s ]
[2024-11-09T01:05:22+08:00][sql] CONNECT:[ UseTime:0.000460s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:05:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001634s ]
[2024-11-09T01:05:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 22 LIMIT 1 [ RunTime:0.000548s ]
[2024-11-09T01:05:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001155s ]
[2024-11-09T01:05:22+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 22  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000388s ]
[2024-11-09T01:05:22+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 22 [ RunTime:0.548220s ]
[2024-11-09T01:05:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.055264s ]
[2024-11-09T01:05:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.022691s ]
[2024-11-09T01:05:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.069840s ]
[2024-11-09T01:08:37+08:00][sql] CONNECT:[ UseTime:0.039604s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:08:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.110779s ]
[2024-11-09T01:08:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '2' LIMIT 1 [ RunTime:0.025208s ]
[2024-11-09T01:08:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.094272s ]
[2024-11-09T01:08:37+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.022599s ]
[2024-11-09T01:08:37+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.001071s ]
[2024-11-09T01:08:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.016002s ]
[2024-11-09T01:08:37+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.082606s ]
[2024-11-09T01:08:37+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.106370s ]
[2024-11-09T01:08:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.031457s ]
[2024-11-09T01:08:37+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011729s ]
[2024-11-09T01:08:37+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.045542s ]
[2024-11-09T01:27:31+08:00][sql] CONNECT:[ UseTime:0.358965s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:27:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.065553s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000460s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000310s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.011636s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000359s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.022069s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.010793s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.010858s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.011793s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.002205s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.010487s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000265s ]
[2024-11-09T01:27:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.022443s ]
[2024-11-09T01:54:50+08:00][sql] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T01:54:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001579s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 36 LIMIT 1 [ RunTime:0.000513s ]
[2024-11-09T01:54:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001132s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 36  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000381s ]
[2024-11-09T01:54:50+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 36 [ RunTime:0.549299s ]
[2024-11-09T01:54:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001589s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.010755s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.122755s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 5,20,15,21,61 [ RunTime:0.079302s ]
[2024-11-09T01:54:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.024393s ]
[2024-11-09T01:54:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.000389s ]
[2024-11-09T02:08:31+08:00][sql] CONNECT:[ UseTime:0.128828s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T02:08:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.106363s ]
[2024-11-09T02:08:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '8'  AND `lnstitutional_nature` = '2' LIMIT 1 [ RunTime:0.026310s ]
[2024-11-09T02:08:31+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `type` = '8'  AND `lnstitutional_nature` = '2' ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.043596s ]
[2024-11-09T02:08:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.111457s ]
[2024-11-09T02:08:31+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` = 58 LIMIT 1 [ RunTime:0.010587s ]
[2024-11-09T02:08:31+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` = 58 LIMIT 1 [ RunTime:0.010678s ]
[2024-11-09T02:08:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001370s ]
[2024-11-09T02:08:31+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.010874s ]
[2024-11-09T02:08:31+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.066823s ]
[2024-11-09T02:08:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.034131s ]
[2024-11-09T02:08:31+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.042149s ]
[2024-11-09T02:08:31+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000802s ]
[2024-11-09T02:08:34+08:00][sql] CONNECT:[ UseTime:0.023779s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T02:08:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.135613s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.010846s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.049366s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000382s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.034834s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000323s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.038828s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.022758s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000321s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.028012s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.021753s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.072740s ]
[2024-11-09T02:08:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.032140s ]
[2024-11-09T02:47:25+08:00][sql] CONNECT:[ UseTime:0.000409s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T02:47:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001373s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000458s ]
[2024-11-09T02:47:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001389s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.000803s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000387s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000663s ]
[2024-11-09T02:47:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.001197s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000591s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000534s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000713s ]
[2024-11-09T02:47:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001155s ]
[2024-11-09T02:47:25+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000275s ]
[2024-11-09T02:47:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.001156s ]
[2024-11-09T02:47:25+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000305s ]
[2024-11-09T03:47:50+08:00][sql] CONNECT:[ UseTime:0.000406s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T03:47:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001624s ]
[2024-11-09T03:47:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '2'  AND `type` = '8'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '3000' AND '4000'  LIMIT 1 [ RunTime:0.000503s ]
[2024-11-09T03:47:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.536784s ]
[2024-11-09T03:47:50+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.012451s ]
[2024-11-09T03:47:50+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021387s ]
[2024-11-09T03:47:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.058274s ]
[2024-11-09T03:47:50+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.053528s ]
[2024-11-09T03:47:50+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.099998s ]
[2024-11-09T03:47:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.022972s ]
[2024-11-09T03:47:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000714s ]
[2024-11-09T03:47:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000756s ]
[2024-11-09T03:47:52+08:00][sql] CONNECT:[ UseTime:0.062306s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T03:47:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.136955s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.033436s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.010605s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.029741s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.010913s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000297s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000312s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000282s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000282s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.010853s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000326s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.009113s ]
[2024-11-09T03:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.011091s ]
[2024-11-09T03:50:42+08:00][sql] CONNECT:[ UseTime:0.286481s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T03:50:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.049883s ]
[2024-11-09T03:50:42+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 54 LIMIT 1 [ RunTime:0.000588s ]
[2024-11-09T03:50:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.067409s ]
[2024-11-09T03:50:42+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 54  AND `table_type` = 'nursing_home_comment' [ RunTime:0.028267s ]
[2024-11-09T03:50:42+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 54 [ RunTime:0.061295s ]
[2024-11-09T03:50:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001305s ]
[2024-11-09T03:50:42+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.032218s ]
[2024-11-09T03:50:42+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.058733s ]
[2024-11-09T04:10:29+08:00][sql] CONNECT:[ UseTime:0.333395s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T04:10:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.094675s ]
[2024-11-09T04:10:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`)  AND `service` = '1' LIMIT 1 [ RunTime:0.069497s ]
[2024-11-09T04:10:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.057506s ]
[2024-11-09T04:10:29+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021635s ]
[2024-11-09T04:10:29+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000236s ]
[2024-11-09T04:10:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.025908s ]
[2024-11-09T04:10:29+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.016072s ]
[2024-11-09T04:10:29+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.176979s ]
[2024-11-09T04:10:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.045823s ]
[2024-11-09T04:10:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000710s ]
[2024-11-09T04:10:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.001103s ]
[2024-11-09T04:37:29+08:00][sql] CONNECT:[ UseTime:0.021707s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T04:37:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.081007s ]
[2024-11-09T04:37:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '3'  AND `type` = '8'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '2000' AND '3000'  LIMIT 1 [ RunTime:0.055770s ]
[2024-11-09T04:37:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.105436s ]
[2024-11-09T04:37:29+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.039663s ]
[2024-11-09T04:37:29+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.010540s ]
[2024-11-09T04:37:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.011936s ]
[2024-11-09T04:37:29+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.041487s ]
[2024-11-09T04:37:29+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.083286s ]
[2024-11-09T04:37:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.095186s ]
[2024-11-09T04:37:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011175s ]
[2024-11-09T04:37:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022675s ]
[2024-11-09T04:37:33+08:00][sql] CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T04:37:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001716s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000397s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000356s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000305s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000357s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000282s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000281s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000292s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000293s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000321s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000304s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000299s ]
[2024-11-09T04:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000298s ]
[2024-11-09T05:27:09+08:00][sql] CONNECT:[ UseTime:0.310481s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T05:27:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.068632s ]
[2024-11-09T05:27:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '7'  AND `type` = '8'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '2000' AND '3000'  LIMIT 1 [ RunTime:0.055053s ]
[2024-11-09T05:27:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.109336s ]
[2024-11-09T05:27:09+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021566s ]
[2024-11-09T05:27:09+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000255s ]
[2024-11-09T05:27:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022715s ]
[2024-11-09T05:27:09+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.032639s ]
[2024-11-09T05:27:09+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.105949s ]
[2024-11-09T05:27:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.059328s ]
[2024-11-09T05:27:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.024009s ]
[2024-11-09T05:27:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.057232s ]
[2024-11-09T05:27:12+08:00][sql] CONNECT:[ UseTime:0.204616s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T05:27:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.093822s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000565s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.011392s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000314s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000310s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000301s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.015989s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000389s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.010553s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000311s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000499s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.028551s ]
[2024-11-09T05:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.010867s ]
[2024-11-09T06:07:51+08:00][sql] CONNECT:[ UseTime:0.332736s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:07:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.099654s ]
[2024-11-09T06:07:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '5' LIMIT 1 [ RunTime:0.045513s ]
[2024-11-09T06:07:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `type` = '5' ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000676s ]
[2024-11-09T06:07:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.117107s ]
[2024-11-09T06:07:51+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` = 61 LIMIT 1 [ RunTime:0.010953s ]
[2024-11-09T06:07:51+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` = 61 LIMIT 1 [ RunTime:0.010679s ]
[2024-11-09T06:07:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.034105s ]
[2024-11-09T06:07:51+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.052066s ]
[2024-11-09T06:07:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.165917s ]
[2024-11-09T06:07:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.041805s ]
[2024-11-09T06:07:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.021414s ]
[2024-11-09T06:07:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011464s ]
[2024-11-09T06:16:48+08:00][sql] CONNECT:[ UseTime:0.120209s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:16:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.161253s ]
[2024-11-09T06:16:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '3'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '3000' AND '4000'  LIMIT 1 [ RunTime:0.000496s ]
[2024-11-09T06:16:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.044433s ]
[2024-11-09T06:16:48+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.024221s ]
[2024-11-09T06:16:48+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000289s ]
[2024-11-09T06:16:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.038657s ]
[2024-11-09T06:16:48+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.033166s ]
[2024-11-09T06:16:48+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.090890s ]
[2024-11-09T06:16:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.040242s ]
[2024-11-09T06:16:48+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000645s ]
[2024-11-09T06:16:48+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011687s ]
[2024-11-09T06:16:50+08:00][sql] CONNECT:[ UseTime:0.013063s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:16:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.054824s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000455s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.071766s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000551s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000345s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000359s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000336s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.049749s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.002052s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.012921s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000335s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000375s ]
[2024-11-09T06:16:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.050930s ]
[2024-11-09T06:18:14+08:00][sql] CONNECT:[ UseTime:0.365351s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:18:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.129201s ]
[2024-11-09T06:18:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.012847s ]
[2024-11-09T06:18:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.081419s ]
[2024-11-09T06:18:14+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.010891s ]
[2024-11-09T06:18:14+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.102196s ]
[2024-11-09T06:18:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001435s ]
[2024-11-09T06:18:14+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.014417s ]
[2024-11-09T06:18:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.110098s ]
[2024-11-09T06:18:17+08:00][sql] CONNECT:[ UseTime:0.258035s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:18:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.158754s ]
[2024-11-09T06:18:17+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.032698s ]
[2024-11-09T06:18:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.034792s ]
[2024-11-09T06:18:17+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000460s ]
[2024-11-09T06:18:17+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.042767s ]
[2024-11-09T06:18:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.048588s ]
[2024-11-09T06:18:17+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.034692s ]
[2024-11-09T06:18:17+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.068884s ]
[2024-11-09T06:18:22+08:00][sql] CONNECT:[ UseTime:0.252643s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:18:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.105868s ]
[2024-11-09T06:18:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.013663s ]
[2024-11-09T06:18:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.059653s ]
[2024-11-09T06:18:22+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.026082s ]
[2024-11-09T06:18:22+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.080591s ]
[2024-11-09T06:18:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.018514s ]
[2024-11-09T06:18:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000376s ]
[2024-11-09T06:18:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.104438s ]
[2024-11-09T06:20:11+08:00][sql] CONNECT:[ UseTime:0.062562s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.107454s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.055102s ]
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.032332s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.018891s ]
[2024-11-09T06:20:11+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.042124s ]
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.008909s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.012220s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.053754s ]
[2024-11-09T06:20:11+08:00][sql] CONNECT:[ UseTime:0.013564s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.066281s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.022881s ]
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.076996s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.003618s ]
[2024-11-09T06:20:11+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.145206s ]
[2024-11-09T06:20:11+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.013435s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.011312s ]
[2024-11-09T06:20:11+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.073212s ]
[2024-11-09T06:20:14+08:00][sql] CONNECT:[ UseTime:0.000401s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001652s ]
[2024-11-09T06:20:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.000471s ]
[2024-11-09T06:20:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001157s ]
[2024-11-09T06:20:14+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000368s ]
[2024-11-09T06:20:14+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.640688s ]
[2024-11-09T06:20:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001397s ]
[2024-11-09T06:20:14+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.005894s ]
[2024-11-09T06:20:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.043431s ]
[2024-11-09T06:20:15+08:00][sql] CONNECT:[ UseTime:0.117954s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.088849s ]
[2024-11-09T06:20:15+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.079357s ]
[2024-11-09T06:20:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.102584s ]
[2024-11-09T06:20:15+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.018992s ]
[2024-11-09T06:20:15+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.107748s ]
[2024-11-09T06:20:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001336s ]
[2024-11-09T06:20:15+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000372s ]
[2024-11-09T06:20:15+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.048836s ]
[2024-11-09T06:20:19+08:00][sql] CONNECT:[ UseTime:0.000427s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001461s ]
[2024-11-09T06:20:19+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.000482s ]
[2024-11-09T06:20:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001072s ]
[2024-11-09T06:20:19+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000323s ]
[2024-11-09T06:20:19+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.577415s ]
[2024-11-09T06:20:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.012146s ]
[2024-11-09T06:20:19+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.022180s ]
[2024-11-09T06:20:19+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.048511s ]
[2024-11-09T06:20:20+08:00][sql] CONNECT:[ UseTime:0.447685s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:20+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.066698s ]
[2024-11-09T06:20:20+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.061283s ]
[2024-11-09T06:20:20+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.150013s ]
[2024-11-09T06:20:20+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.008012s ]
[2024-11-09T06:20:20+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.099596s ]
[2024-11-09T06:20:20+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001321s ]
[2024-11-09T06:20:20+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000467s ]
[2024-11-09T06:20:20+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.058709s ]
[2024-11-09T06:20:56+08:00][sql] CONNECT:[ UseTime:0.000384s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001584s ]
[2024-11-09T06:20:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.000517s ]
[2024-11-09T06:20:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001201s ]
[2024-11-09T06:20:56+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000337s ]
[2024-11-09T06:20:56+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.532195s ]
[2024-11-09T06:20:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.023174s ]
[2024-11-09T06:20:56+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.043104s ]
[2024-11-09T06:20:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.039879s ]
[2024-11-09T06:20:58+08:00][sql] CONNECT:[ UseTime:0.236024s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:20:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.065491s ]
[2024-11-09T06:20:58+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.035548s ]
[2024-11-09T06:20:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.057655s ]
[2024-11-09T06:20:58+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.021956s ]
[2024-11-09T06:20:58+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.105470s ]
[2024-11-09T06:20:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001486s ]
[2024-11-09T06:20:58+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.020102s ]
[2024-11-09T06:20:58+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.074497s ]
[2024-11-09T06:21:03+08:00][sql] CONNECT:[ UseTime:0.287725s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T06:21:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.098685s ]
[2024-11-09T06:21:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.054738s ]
[2024-11-09T06:21:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.033326s ]
[2024-11-09T06:21:03+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.053130s ]
[2024-11-09T06:21:03+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.109797s ]
[2024-11-09T06:21:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001328s ]
[2024-11-09T06:21:03+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.010676s ]
[2024-11-09T06:21:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.037263s ]
[2024-11-09T07:06:28+08:00][sql] CONNECT:[ UseTime:0.465614s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T07:06:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.066750s ]
[2024-11-09T07:06:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '6'  AND `type` = '3'  AND `lnstitutional_nature` = '2'  AND `min_price` BETWEEN '1000' AND '2000'  LIMIT 1 [ RunTime:0.030415s ]
[2024-11-09T07:06:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.105860s ]
[2024-11-09T07:06:28+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.022351s ]
[2024-11-09T07:06:28+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000987s ]
[2024-11-09T07:06:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.015714s ]
[2024-11-09T07:06:28+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.054083s ]
[2024-11-09T07:06:28+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.082278s ]
[2024-11-09T07:06:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.045619s ]
[2024-11-09T07:06:28+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011384s ]
[2024-11-09T07:06:28+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.036295s ]
[2024-11-09T07:06:31+08:00][sql] CONNECT:[ UseTime:0.328972s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T07:06:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.093757s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000437s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000312s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.011076s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000303s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.011380s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.021833s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.039550s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.039824s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000380s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000300s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000314s ]
[2024-11-09T07:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000324s ]
[2024-11-09T07:56:07+08:00][sql] CONNECT:[ UseTime:0.266506s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T07:56:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.122332s ]
[2024-11-09T07:56:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '4'  AND `lnstitutional_nature` = '4' LIMIT 1 [ RunTime:0.002161s ]
[2024-11-09T07:56:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.105145s ]
[2024-11-09T07:56:07+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.046818s ]
[2024-11-09T07:56:07+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000261s ]
[2024-11-09T07:56:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.012830s ]
[2024-11-09T07:56:07+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.013488s ]
[2024-11-09T07:56:07+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.135483s ]
[2024-11-09T07:56:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.008696s ]
[2024-11-09T07:56:07+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.064066s ]
[2024-11-09T07:56:07+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.004086s ]
[2024-11-09T07:56:10+08:00][sql] CONNECT:[ UseTime:0.097386s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T07:56:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.117807s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.024518s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.011229s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.018416s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.039867s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.031672s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000279s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000284s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000263s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000287s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.001588s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000324s ]
[2024-11-09T07:56:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.010863s ]
[2024-11-09T08:23:29+08:00][sql] CONNECT:[ UseTime:0.448181s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T08:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.054828s ]
[2024-11-09T08:23:29+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 31 LIMIT 1 [ RunTime:0.021804s ]
[2024-11-09T08:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.069503s ]
[2024-11-09T08:23:29+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 31  AND `table_type` = 'nursing_home_comment' [ RunTime:0.010860s ]
[2024-11-09T08:23:29+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 31 [ RunTime:0.090251s ]
[2024-11-09T08:23:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.047139s ]
[2024-11-09T08:23:29+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.028232s ]
[2024-11-09T08:23:29+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.128811s ]
[2024-11-09T08:45:47+08:00][sql] CONNECT:[ UseTime:0.439303s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T08:45:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.152687s ]
[2024-11-09T08:45:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '6'  AND `lnstitutional_nature` = '2'  AND `min_price` BETWEEN '5000' AND '6000'  LIMIT 1 [ RunTime:0.020642s ]
[2024-11-09T08:45:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.170123s ]
[2024-11-09T08:45:47+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.012987s ]
[2024-11-09T08:45:47+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000255s ]
[2024-11-09T08:45:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001332s ]
[2024-11-09T08:45:47+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.042736s ]
[2024-11-09T08:45:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.145071s ]
[2024-11-09T08:45:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.050194s ]
[2024-11-09T08:45:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.021684s ]
[2024-11-09T08:45:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.013296s ]
[2024-11-09T08:45:50+08:00][sql] CONNECT:[ UseTime:0.000443s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T08:45:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001832s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.000430s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000323s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000346s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000334s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000298s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000298s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000319s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000288s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000283s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000299s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000328s ]
[2024-11-09T08:45:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000287s ]
[2024-11-09T08:52:26+08:00][sql] CONNECT:[ UseTime:0.223975s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T08:52:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.087706s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 21 LIMIT 1 [ RunTime:0.107252s ]
[2024-11-09T08:52:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.036869s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 21  AND `table_type` = 'nursing_home_comment' [ RunTime:0.045038s ]
[2024-11-09T08:52:26+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 21 [ RunTime:0.117925s ]
[2024-11-09T08:52:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001543s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.011010s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.042903s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 5,36,15,20,61 [ RunTime:0.010725s ]
[2024-11-09T08:52:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.011841s ]
[2024-11-09T08:52:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.000321s ]
[2024-11-09T09:35:26+08:00][sql] CONNECT:[ UseTime:0.280444s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:35:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.111747s ]
[2024-11-09T09:35:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '3'  AND `type` = '3'  AND `lnstitutional_nature` = '2'  AND `min_price` BETWEEN '2000' AND '3000'  LIMIT 1 [ RunTime:0.056476s ]
[2024-11-09T09:35:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.182144s ]
[2024-11-09T09:35:26+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.001967s ]
[2024-11-09T09:35:26+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.059777s ]
[2024-11-09T09:35:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.003743s ]
[2024-11-09T09:35:26+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.013587s ]
[2024-11-09T09:35:26+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.179773s ]
[2024-11-09T09:35:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.053886s ]
[2024-11-09T09:35:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.012775s ]
[2024-11-09T09:35:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039261s ]
[2024-11-09T09:35:29+08:00][sql] CONNECT:[ UseTime:0.789560s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:35:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.150622s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.034367s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.010950s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.010796s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.032407s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.035647s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000471s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.022572s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.021771s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.022338s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000369s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.042798s ]
[2024-11-09T09:35:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000478s ]
[2024-11-09T09:38:54+08:00][sql] CONNECT:[ UseTime:0.000423s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:38:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.012640s ]
[2024-11-09T09:38:54+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 53 LIMIT 1 [ RunTime:0.000601s ]
[2024-11-09T09:38:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001130s ]
[2024-11-09T09:38:54+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 53  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000368s ]
[2024-11-09T09:38:54+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 53 [ RunTime:0.799920s ]
[2024-11-09T09:38:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.153332s ]
[2024-11-09T09:38:54+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000805s ]
[2024-11-09T09:38:54+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.068128s ]
[2024-11-09T09:43:40+08:00][sql] CONNECT:[ UseTime:0.126140s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022999s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.002644s ]
[2024-11-09T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.073037s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.116499s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.105985s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.067714s ]
[2024-11-09T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.013249s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011542s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.012399s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000743s ]
[2024-11-09T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.033528s ]
[2024-11-09T09:43:40+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000327s ]
[2024-11-09T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.022467s ]
[2024-11-09T09:43:40+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.011360s ]
[2024-11-09T09:43:44+08:00][sql] CONNECT:[ UseTime:0.082452s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.107156s ]
[2024-11-09T09:43:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.022586s ]
[2024-11-09T09:43:44+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.022182s ]
[2024-11-09T09:43:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.328398s ]
[2024-11-09T09:43:44+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (56,52,47,46,45,39,38,23,22,19) LIMIT 1 [ RunTime:0.034547s ]
[2024-11-09T09:43:44+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (56,52,47,46,45,39,38,23,22,19) LIMIT 1 [ RunTime:0.020083s ]
[2024-11-09T09:43:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.039568s ]
[2024-11-09T09:43:44+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.046048s ]
[2024-11-09T09:43:44+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.148883s ]
[2024-11-09T09:43:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.029094s ]
[2024-11-09T09:43:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000654s ]
[2024-11-09T09:43:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.041656s ]
[2024-11-09T09:43:48+08:00][sql] CONNECT:[ UseTime:0.000407s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001526s ]
[2024-11-09T09:43:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000449s ]
[2024-11-09T09:43:48+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000651s ]
[2024-11-09T09:43:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.000308s ]
[2024-11-09T09:43:48+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,36,21,20,15,5) LIMIT 1 [ RunTime:0.000323s ]
[2024-11-09T09:43:48+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,36,21,20,15,5) LIMIT 1 [ RunTime:0.000318s ]
[2024-11-09T09:43:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001071s ]
[2024-11-09T09:43:48+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000339s ]
[2024-11-09T09:43:48+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.000724s ]
[2024-11-09T09:43:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.001083s ]
[2024-11-09T09:43:48+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000551s ]
[2024-11-09T09:43:48+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000733s ]
[2024-11-09T09:43:51+08:00][sql] CONNECT:[ UseTime:0.373585s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.107366s ]
[2024-11-09T09:43:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.071515s ]
[2024-11-09T09:43:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.001082s ]
[2024-11-09T09:43:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.143673s ]
[2024-11-09T09:43:51+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (60,58,55,54,53,51,49,43,40,34) LIMIT 1 [ RunTime:0.064864s ]
[2024-11-09T09:43:51+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (60,58,55,54,53,51,49,43,40,34) LIMIT 1 [ RunTime:0.033577s ]
[2024-11-09T09:43:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.014649s ]
[2024-11-09T09:43:51+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.061277s ]
[2024-11-09T09:43:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.052309s ]
[2024-11-09T09:43:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.024844s ]
[2024-11-09T09:43:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000655s ]
[2024-11-09T09:43:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000760s ]
[2024-11-09T09:43:55+08:00][sql] CONNECT:[ UseTime:0.084906s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.127005s ]
[2024-11-09T09:43:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.042635s ]
[2024-11-09T09:43:55+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.030827s ]
[2024-11-09T09:43:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.251901s ]
[2024-11-09T09:43:55+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (50,48,18,17,9) LIMIT 1 [ RunTime:0.019891s ]
[2024-11-09T09:43:55+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (50,48,18,17,9) LIMIT 1 [ RunTime:0.000410s ]
[2024-11-09T09:43:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001380s ]
[2024-11-09T09:43:55+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.017487s ]
[2024-11-09T09:43:55+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.089503s ]
[2024-11-09T09:43:55+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.030794s ]
[2024-11-09T09:43:55+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011201s ]
[2024-11-09T09:43:55+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.028673s ]
[2024-11-09T09:43:59+08:00][sql] CONNECT:[ UseTime:0.016902s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:43:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.027756s ]
[2024-11-09T09:43:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.026504s ]
[2024-11-09T09:43:59+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000827s ]
[2024-11-09T09:43:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.251042s ]
[2024-11-09T09:43:59+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.010601s ]
[2024-11-09T09:43:59+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.037435s ]
[2024-11-09T09:43:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.034262s ]
[2024-11-09T09:43:59+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.012394s ]
[2024-11-09T09:43:59+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.106410s ]
[2024-11-09T09:43:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.022956s ]
[2024-11-09T09:43:59+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.063859s ]
[2024-11-09T09:43:59+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011163s ]
[2024-11-09T09:44:02+08:00][sql] CONNECT:[ UseTime:0.206985s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:02+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.083566s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.033987s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.053672s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.046188s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.012966s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.041968s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000502s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.021835s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.029692s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.030628s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000464s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.034079s ]
[2024-11-09T09:44:02+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.021655s ]
[2024-11-09T09:44:05+08:00][sql] CONNECT:[ UseTime:0.136102s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.067690s ]
[2024-11-09T09:44:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.034019s ]
[2024-11-09T09:44:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.131227s ]
[2024-11-09T09:44:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.042210s ]
[2024-11-09T09:44:05+08:00][sql] SELECT * FROM `dg_article` ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.004682s ]
[2024-11-09T09:44:09+08:00][sql] CONNECT:[ UseTime:0.185015s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.108507s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.031285s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.067683s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.029188s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.056659s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000556s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011140s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000460s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.010694s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011184s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000448s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.024047s ]
[2024-11-09T09:44:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.010811s ]
[2024-11-09T09:44:13+08:00][sql] CONNECT:[ UseTime:0.137577s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.079098s ]
[2024-11-09T09:44:13+08:00][sql] SELECT * FROM `dg_sojourn_city` ORDER BY `sid` ASC [ RunTime:0.039216s ]
[2024-11-09T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.001460s ]
[2024-11-09T09:44:13+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `city_id` IN (1,3) [ RunTime:0.036709s ]
[2024-11-09T09:44:16+08:00][sql] CONNECT:[ UseTime:0.053341s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.049208s ]
[2024-11-09T09:44:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.069260s ]
[2024-11-09T09:44:16+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.003711s ]
[2024-11-09T09:44:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.195323s ]
[2024-11-09T09:44:16+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.027381s ]
[2024-11-09T09:44:16+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.011519s ]
[2024-11-09T09:44:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.020581s ]
[2024-11-09T09:44:16+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000474s ]
[2024-11-09T09:44:16+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.118755s ]
[2024-11-09T09:44:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.096471s ]
[2024-11-09T09:44:16+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.100073s ]
[2024-11-09T09:44:16+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.049927s ]
[2024-11-09T09:44:19+08:00][sql] CONNECT:[ UseTime:0.206604s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_intro` [ RunTime:0.191481s ]
[2024-11-09T09:44:19+08:00][sql] SELECT * FROM `dg_intro` WHERE  `type` = 'about' LIMIT 1 [ RunTime:0.005810s ]
[2024-11-09T09:44:26+08:00][sql] CONNECT:[ UseTime:0.102788s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.092752s ]
[2024-11-09T09:44:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.019736s ]
[2024-11-09T09:44:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.094427s ]
[2024-11-09T09:44:26+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.031803s ]
[2024-11-09T09:44:26+08:00][sql] SELECT * FROM `dg_article` ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.016184s ]
[2024-11-09T09:44:29+08:00][sql] CONNECT:[ UseTime:0.255489s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.128764s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.147360s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.077018s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.060656s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000896s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.027159s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000451s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000409s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000339s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000398s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.004308s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.002297s ]
[2024-11-09T09:44:29+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011091s ]
[2024-11-09T09:44:32+08:00][sql] CONNECT:[ UseTime:0.207471s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:32+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.144531s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.012518s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.057415s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000466s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000367s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.020243s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.039855s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000491s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000375s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.022401s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011502s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011358s ]
[2024-11-09T09:44:32+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000487s ]
[2024-11-09T09:44:34+08:00][sql] CONNECT:[ UseTime:0.000421s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.001379s ]
[2024-11-09T09:44:34+08:00][sql] SELECT * FROM `dg_sojourn_city` ORDER BY `sid` ASC [ RunTime:0.000335s ]
[2024-11-09T09:44:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.486123s ]
[2024-11-09T09:44:34+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `city_id` IN (1,3) [ RunTime:0.048204s ]
[2024-11-09T09:44:38+08:00][sql] CONNECT:[ UseTime:0.505423s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.071651s ]
[2024-11-09T09:44:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.044428s ]
[2024-11-09T09:44:38+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.029190s ]
[2024-11-09T09:44:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.255581s ]
[2024-11-09T09:44:38+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.034239s ]
[2024-11-09T09:44:38+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.022002s ]
[2024-11-09T09:44:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.025964s ]
[2024-11-09T09:44:38+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.011029s ]
[2024-11-09T09:44:38+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.120316s ]
[2024-11-09T09:44:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.035229s ]
[2024-11-09T09:44:38+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.027539s ]
[2024-11-09T09:44:38+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011578s ]
[2024-11-09T09:44:41+08:00][sql] CONNECT:[ UseTime:0.619813s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:44:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.103718s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.012676s ]
[2024-11-09T09:44:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.050665s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.109220s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.077445s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.061764s ]
[2024-11-09T09:44:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.032751s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.032316s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.019585s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.020527s ]
[2024-11-09T09:44:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.013382s ]
[2024-11-09T09:44:41+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.049308s ]
[2024-11-09T09:44:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.021117s ]
[2024-11-09T09:44:41+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.017668s ]
[2024-11-09T09:49:47+08:00][sql] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:49:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001325s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000422s ]
[2024-11-09T09:49:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001329s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.668644s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.132980s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.050198s ]
[2024-11-09T09:49:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.011269s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011398s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000524s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.018399s ]
[2024-11-09T09:49:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.023947s ]
[2024-11-09T09:49:47+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.012588s ]
[2024-11-09T09:49:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.036105s ]
[2024-11-09T09:49:47+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.032792s ]
[2024-11-09T09:49:51+08:00][sql] CONNECT:[ UseTime:0.077098s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:49:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.073465s ]
[2024-11-09T09:49:51+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.056850s ]
[2024-11-09T09:49:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.069382s ]
[2024-11-09T09:49:51+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 2 ORDER BY `sort` ASC [ RunTime:0.003211s ]
[2024-11-09T09:49:57+08:00][sql] CONNECT:[ UseTime:0.646360s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:49:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.137647s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000461s ]
[2024-11-09T09:49:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.049146s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.058276s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.160957s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000837s ]
[2024-11-09T09:49:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.054201s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.040252s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000496s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.021252s ]
[2024-11-09T09:49:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.012192s ]
[2024-11-09T09:49:57+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000305s ]
[2024-11-09T09:49:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.054415s ]
[2024-11-09T09:49:57+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000387s ]
[2024-11-09T09:50:00+08:00][sql] CONNECT:[ UseTime:0.039328s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:50:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.166546s ]
[2024-11-09T09:50:00+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000543s ]
[2024-11-09T09:50:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.022255s ]
[2024-11-09T09:50:00+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 2 ORDER BY `sort` ASC [ RunTime:0.010832s ]
[2024-11-09T09:53:22+08:00][sql] CONNECT:[ UseTime:0.176252s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T09:53:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.171986s ]
[2024-11-09T09:53:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 31 LIMIT 1 [ RunTime:0.017626s ]
[2024-11-09T09:53:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.087557s ]
[2024-11-09T09:53:22+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 31  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000436s ]
[2024-11-09T09:53:22+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 31 [ RunTime:0.082771s ]
[2024-11-09T09:53:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.018845s ]
[2024-11-09T09:53:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000466s ]
[2024-11-09T09:53:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.060463s ]
[2024-11-09T10:25:05+08:00][sql] CONNECT:[ UseTime:0.310941s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T10:25:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.083842s ]
[2024-11-09T10:25:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '6'  AND `type` = '8'  AND `lnstitutional_nature` = '1'  AND `min_price` < '1000' LIMIT 1 [ RunTime:0.013213s ]
[2024-11-09T10:25:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.147202s ]
[2024-11-09T10:25:05+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.001108s ]
[2024-11-09T10:25:05+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.018182s ]
[2024-11-09T10:25:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.014096s ]
[2024-11-09T10:25:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.035089s ]
[2024-11-09T10:25:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.114720s ]
[2024-11-09T10:25:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.030887s ]
[2024-11-09T10:25:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000672s ]
[2024-11-09T10:25:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.016638s ]
[2024-11-09T10:25:08+08:00][sql] CONNECT:[ UseTime:0.489457s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T10:25:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.133227s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.040273s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.001895s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000291s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000333s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.001875s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.043859s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000322s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000345s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000306s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000298s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.020626s ]
[2024-11-09T10:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.016436s ]
[2024-11-09T10:41:27+08:00][sql] CONNECT:[ UseTime:0.000400s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T10:41:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001544s ]
[2024-11-09T10:41:27+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 22 LIMIT 1 [ RunTime:0.000534s ]
[2024-11-09T10:41:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001115s ]
[2024-11-09T10:41:27+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 22  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000337s ]
[2024-11-09T10:41:27+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 22 [ RunTime:0.604098s ]
[2024-11-09T10:41:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.014432s ]
[2024-11-09T10:41:27+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.100122s ]
[2024-11-09T10:41:27+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.071812s ]
[2024-11-09T10:41:57+08:00][sql] CONNECT:[ UseTime:0.262103s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T10:41:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.091181s ]
[2024-11-09T10:41:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 22 LIMIT 1 [ RunTime:0.057952s ]
[2024-11-09T10:41:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.068654s ]
[2024-11-09T10:41:57+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 22  AND `table_type` = 'nursing_home_comment' [ RunTime:0.030734s ]
[2024-11-09T10:41:57+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 22 [ RunTime:0.061531s ]
[2024-11-09T10:41:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.023558s ]
[2024-11-09T10:41:57+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.023068s ]
[2024-11-09T10:41:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.123455s ]
[2024-11-09T11:14:44+08:00][sql] CONNECT:[ UseTime:0.023743s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T11:14:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.641057s ]
[2024-11-09T11:14:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '7'  AND `type` = '3'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '1000' AND '2000'  LIMIT 1 [ RunTime:0.037470s ]
[2024-11-09T11:14:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.119670s ]
[2024-11-09T11:14:44+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000276s ]
[2024-11-09T11:14:44+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.046578s ]
[2024-11-09T11:14:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.029850s ]
[2024-11-09T11:14:44+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.012502s ]
[2024-11-09T11:14:44+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.060188s ]
[2024-11-09T11:14:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.072641s ]
[2024-11-09T11:14:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.050467s ]
[2024-11-09T11:14:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000848s ]
[2024-11-09T11:14:49+08:00][sql] CONNECT:[ UseTime:0.165918s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T11:14:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.099730s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.055025s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000445s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000304s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.010746s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000327s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000289s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000313s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.005369s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000315s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.010377s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000313s ]
[2024-11-09T11:14:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000325s ]
[2024-11-09T11:42:23+08:00][sql] CONNECT:[ UseTime:0.039417s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T11:42:23+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.076192s ]
[2024-11-09T11:42:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`)  AND `lnstitutional_nature` = '1' LIMIT 1 [ RunTime:0.043112s ]
[2024-11-09T11:42:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.124405s ]
[2024-11-09T11:42:23+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.028364s ]
[2024-11-09T11:42:23+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.010656s ]
[2024-11-09T11:42:23+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022668s ]
[2024-11-09T11:42:23+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.018597s ]
[2024-11-09T11:42:23+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.141999s ]
[2024-11-09T11:42:23+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.037807s ]
[2024-11-09T11:42:23+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.018073s ]
[2024-11-09T11:42:23+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.051338s ]
[2024-11-09T12:04:24+08:00][sql] CONNECT:[ UseTime:0.000421s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T12:04:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001555s ]
[2024-11-09T12:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '9'  AND `type` = '3'  AND `lnstitutional_nature` = '1'  AND `min_price` BETWEEN '4000' AND '5000'  LIMIT 1 [ RunTime:0.000552s ]
[2024-11-09T12:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.000287s ]
[2024-11-09T12:04:24+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000279s ]
[2024-11-09T12:04:24+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000203s ]
[2024-11-09T12:04:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001137s ]
[2024-11-09T12:04:24+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000378s ]
[2024-11-09T12:04:24+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.000757s ]
[2024-11-09T12:04:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.001209s ]
[2024-11-09T12:04:24+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000595s ]
[2024-11-09T12:04:24+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000746s ]
[2024-11-09T12:04:25+08:00][sql] CONNECT:[ UseTime:1.209233s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T12:04:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.053631s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.035155s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000416s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000296s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.030907s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000330s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.022021s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.010819s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000319s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000335s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.033097s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000312s ]
[2024-11-09T12:04:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000307s ]
[2024-11-09T12:44:13+08:00][sql] CONNECT:[ UseTime:0.345367s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T12:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.070715s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 61 LIMIT 1 [ RunTime:0.027202s ]
[2024-11-09T12:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.085245s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 61  AND `table_type` = 'nursing_home_comment' [ RunTime:0.002971s ]
[2024-11-09T12:44:13+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 61 [ RunTime:0.114235s ]
[2024-11-09T12:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.047041s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.030768s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.068241s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (5,36,15,20,21) [ RunTime:0.046305s ]
[2024-11-09T12:44:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.012953s ]
[2024-11-09T12:44:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.010536s ]
[2024-11-09T13:10:52+08:00][sql] CONNECT:[ UseTime:0.000414s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:10:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:1.179265s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.013583s ]
[2024-11-09T13:10:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.045052s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.074112s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.077985s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.022057s ]
[2024-11-09T13:10:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.049122s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022193s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011510s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.055273s ]
[2024-11-09T13:10:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.011895s ]
[2024-11-09T13:10:52+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.019245s ]
[2024-11-09T13:10:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.058945s ]
[2024-11-09T13:10:52+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.022177s ]
[2024-11-09T13:10:56+08:00][sql] CONNECT:[ UseTime:0.716447s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:10:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.074734s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.011387s ]
[2024-11-09T13:10:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.014339s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.148140s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.078134s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.049829s ]
[2024-11-09T13:10:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.014369s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.028560s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.002749s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.065588s ]
[2024-11-09T13:10:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001423s ]
[2024-11-09T13:10:56+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.003263s ]
[2024-11-09T13:10:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.019655s ]
[2024-11-09T13:10:56+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.068195s ]
[2024-11-09T13:11:01+08:00][sql] CONNECT:[ UseTime:0.261451s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.083075s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.026163s ]
[2024-11-09T13:11:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001387s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.150116s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.113057s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.069599s ]
[2024-11-09T13:11:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.063692s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.051914s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.016999s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.002225s ]
[2024-11-09T13:11:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.046541s ]
[2024-11-09T13:11:01+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000276s ]
[2024-11-09T13:11:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.034830s ]
[2024-11-09T13:11:01+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.028338s ]
[2024-11-09T13:11:03+08:00][sql] CONNECT:[ UseTime:0.065767s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.034512s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.054247s ]
[2024-11-09T13:11:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.036943s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.198569s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.202823s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.004312s ]
[2024-11-09T13:11:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.041561s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.003527s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.045515s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.019391s ]
[2024-11-09T13:11:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.019503s ]
[2024-11-09T13:11:03+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.023135s ]
[2024-11-09T13:11:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.012016s ]
[2024-11-09T13:11:03+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.019339s ]
[2024-11-09T13:11:07+08:00][sql] CONNECT:[ UseTime:0.000410s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001323s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000424s ]
[2024-11-09T13:11:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.011873s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.711136s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.011738s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.063753s ]
[2024-11-09T13:11:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.035474s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000685s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.001013s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.010142s ]
[2024-11-09T13:11:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.011799s ]
[2024-11-09T13:11:07+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000291s ]
[2024-11-09T13:11:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.039364s ]
[2024-11-09T13:11:07+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000418s ]
[2024-11-09T13:11:08+08:00][sql] CONNECT:[ UseTime:0.263478s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.093213s ]
[2024-11-09T13:11:08+08:00][sql] SELECT * FROM `dg_sojourn_city` ORDER BY `sid` ASC [ RunTime:0.021967s ]
[2024-11-09T13:11:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.066750s ]
[2024-11-09T13:11:08+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `city_id` IN (1,3) [ RunTime:0.028259s ]
[2024-11-09T13:11:10+08:00][sql] CONNECT:[ UseTime:0.890257s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.148580s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.051093s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.033607s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000504s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.018855s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.018895s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000458s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.047605s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.020183s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000442s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.019643s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000437s ]
[2024-11-09T13:11:10+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000452s ]
[2024-11-09T13:11:12+08:00][sql] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.078635s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.041618s ]
[2024-11-09T13:11:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.039931s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.094200s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.208638s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.029134s ]
[2024-11-09T13:11:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.051304s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039229s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.038829s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039561s ]
[2024-11-09T13:11:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.020613s ]
[2024-11-09T13:11:12+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000339s ]
[2024-11-09T13:11:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.013372s ]
[2024-11-09T13:11:12+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.011006s ]
[2024-11-09T13:11:13+08:00][sql] CONNECT:[ UseTime:0.765714s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.154597s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.055444s ]
[2024-11-09T13:11:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.039361s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.122598s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.072212s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.029344s ]
[2024-11-09T13:11:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.047917s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.021416s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000510s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.023426s ]
[2024-11-09T13:11:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001298s ]
[2024-11-09T13:11:13+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000349s ]
[2024-11-09T13:11:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.032118s ]
[2024-11-09T13:11:13+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000327s ]
[2024-11-09T13:11:17+08:00][sql] CONNECT:[ UseTime:0.054758s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.094673s ]
[2024-11-09T13:11:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.030347s ]
[2024-11-09T13:11:17+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000850s ]
[2024-11-09T13:11:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.247011s ]
[2024-11-09T13:11:17+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.002657s ]
[2024-11-09T13:11:17+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.033655s ]
[2024-11-09T13:11:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022862s ]
[2024-11-09T13:11:17+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000417s ]
[2024-11-09T13:11:17+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.107517s ]
[2024-11-09T13:11:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.066029s ]
[2024-11-09T13:11:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011102s ]
[2024-11-09T13:11:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000704s ]
[2024-11-09T13:11:21+08:00][sql] CONNECT:[ UseTime:0.000387s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.012769s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000442s ]
[2024-11-09T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001347s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.000836s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000395s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000650s ]
[2024-11-09T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.001207s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.001512s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000488s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000691s ]
[2024-11-09T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001060s ]
[2024-11-09T13:11:21+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000294s ]
[2024-11-09T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.001088s ]
[2024-11-09T13:11:21+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000364s ]
[2024-11-09T13:27:28+08:00][sql] CONNECT:[ UseTime:0.105591s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:27:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.060443s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.021979s ]
[2024-11-09T13:27:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.011556s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.096313s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.148023s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.044839s ]
[2024-11-09T13:27:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.023608s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011381s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000487s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.017852s ]
[2024-11-09T13:27:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.018618s ]
[2024-11-09T13:27:28+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.013023s ]
[2024-11-09T13:27:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.031851s ]
[2024-11-09T13:27:28+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.044067s ]
[2024-11-09T13:27:40+08:00][sql] CONNECT:[ UseTime:1.116475s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T13:27:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.083373s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.003233s ]
[2024-11-09T13:27:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.019327s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.133628s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.164315s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000857s ]
[2024-11-09T13:27:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.018297s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.024777s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000702s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039908s ]
[2024-11-09T13:27:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.031952s ]
[2024-11-09T13:27:40+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.047138s ]
[2024-11-09T13:27:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.011750s ]
[2024-11-09T13:27:40+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000364s ]
[2024-11-09T14:11:56+08:00][sql] CONNECT:[ UseTime:1.290515s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:11:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.074495s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.047762s ]
[2024-11-09T14:11:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.014029s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.104793s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.065814s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.009256s ]
[2024-11-09T14:11:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.077986s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.018182s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.027005s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.023211s ]
[2024-11-09T14:11:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.025459s ]
[2024-11-09T14:11:56+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.011074s ]
[2024-11-09T14:11:56+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.097214s ]
[2024-11-09T14:11:56+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000392s ]
[2024-11-09T14:12:01+08:00][sql] CONNECT:[ UseTime:0.211152s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:12:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.061571s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.012982s ]
[2024-11-09T14:12:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.018364s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.096228s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.121662s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.095937s ]
[2024-11-09T14:12:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.069891s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000672s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.038646s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.018906s ]
[2024-11-09T14:12:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001370s ]
[2024-11-09T14:12:01+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000429s ]
[2024-11-09T14:12:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.001140s ]
[2024-11-09T14:12:01+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000399s ]
[2024-11-09T14:13:05+08:00][sql] CONNECT:[ UseTime:0.810282s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.097416s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000852s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.043623s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.050691s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.059831s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.052060s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.079821s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.068598s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.012075s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022808s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.052303s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.030180s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.057063s ]
[2024-11-09T14:13:05+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.010988s ]
[2024-11-09T14:13:05+08:00][sql] CONNECT:[ UseTime:0.073264s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.066817s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.010834s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.067614s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.077292s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.083076s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.054984s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.044941s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000679s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.083802s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011245s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001144s ]
[2024-11-09T14:13:05+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.021737s ]
[2024-11-09T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.040147s ]
[2024-11-09T14:13:05+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.010930s ]
[2024-11-09T14:13:10+08:00][sql] CONNECT:[ UseTime:0.000462s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.001495s ]
[2024-11-09T14:13:10+08:00][sql] SELECT * FROM `dg_sojourn_city` ORDER BY `sid` ASC [ RunTime:0.000390s ]
[2024-11-09T14:13:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.001227s ]
[2024-11-09T14:13:10+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `city_id` IN (1,3) [ RunTime:0.000464s ]
[2024-11-09T14:13:12+08:00][sql] CONNECT:[ UseTime:0.000470s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001406s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000481s ]
[2024-11-09T14:13:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001331s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.000807s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.625119s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.033482s ]
[2024-11-09T14:13:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.048095s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011235s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.016031s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000697s ]
[2024-11-09T14:13:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.003989s ]
[2024-11-09T14:13:12+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000298s ]
[2024-11-09T14:13:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.011784s ]
[2024-11-09T14:13:12+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.001599s ]
[2024-11-09T14:13:13+08:00][sql] CONNECT:[ UseTime:0.166880s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.082587s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.010919s ]
[2024-11-09T14:13:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001423s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.151965s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.067391s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.023465s ]
[2024-11-09T14:13:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.089831s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022333s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.005833s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.032641s ]
[2024-11-09T14:13:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.022993s ]
[2024-11-09T14:13:13+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.001606s ]
[2024-11-09T14:13:13+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.002475s ]
[2024-11-09T14:13:13+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.043131s ]
[2024-11-09T14:13:17+08:00][sql] CONNECT:[ UseTime:0.513114s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.041343s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'literature' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000813s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'history' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.121571s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011659s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'health' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.029850s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'diet' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.022021s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'psychology' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000455s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'essay' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.021331s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'activities' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.025455s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'RetirementLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000481s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'SenileLife' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000396s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'GeriatricCulture' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.027758s ]
[2024-11-09T14:13:17+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby' ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.011036s ]
[2024-11-09T14:13:19+08:00][sql] CONNECT:[ UseTime:0.129817s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.142620s ]
[2024-11-09T14:13:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.032482s ]
[2024-11-09T14:13:19+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.011523s ]
[2024-11-09T14:13:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.205511s ]
[2024-11-09T14:13:19+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.021338s ]
[2024-11-09T14:13:19+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  `nid` IN (61,60,59,58,57,56,55,54,53,52) LIMIT 1 [ RunTime:0.011000s ]
[2024-11-09T14:13:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022995s ]
[2024-11-09T14:13:19+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.011296s ]
[2024-11-09T14:13:19+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.099983s ]
[2024-11-09T14:13:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.004102s ]
[2024-11-09T14:13:19+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.013020s ]
[2024-11-09T14:13:19+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.033151s ]
[2024-11-09T14:13:21+08:00][sql] CONNECT:[ UseTime:0.000418s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001311s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000444s ]
[2024-11-09T14:13:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001368s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.000782s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.675587s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000936s ]
[2024-11-09T14:13:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.094098s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011248s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022271s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.013771s ]
[2024-11-09T14:13:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001381s ]
[2024-11-09T14:13:21+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000322s ]
[2024-11-09T14:13:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.029747s ]
[2024-11-09T14:13:21+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000376s ]
[2024-11-09T14:13:22+08:00][sql] CONNECT:[ UseTime:0.377721s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.084173s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.038350s ]
[2024-11-09T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.017608s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.165330s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.068095s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.040509s ]
[2024-11-09T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.030746s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000682s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.017444s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.001000s ]
[2024-11-09T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.002568s ]
[2024-11-09T14:13:22+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000304s ]
[2024-11-09T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.086202s ]
[2024-11-09T14:13:22+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.037441s ]
[2024-11-09T14:15:34+08:00][sql] CONNECT:[ UseTime:1.296853s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.073339s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.023904s ]
[2024-11-09T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.032310s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.116925s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.099943s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.016747s ]
[2024-11-09T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.084559s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.002166s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.029986s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.045889s ]
[2024-11-09T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.021506s ]
[2024-11-09T14:15:34+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000340s ]
[2024-11-09T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.052982s ]
[2024-11-09T14:15:34+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.023008s ]
[2024-11-09T14:15:38+08:00][sql] CONNECT:[ UseTime:0.086180s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:15:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.040578s ]
[2024-11-09T14:15:38+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.005424s ]
[2024-11-09T14:15:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.043500s ]
[2024-11-09T14:15:38+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 2 ORDER BY `sort` ASC [ RunTime:0.037678s ]
[2024-11-09T14:15:44+08:00][sql] CONNECT:[ UseTime:0.541241s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.077709s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.004806s ]
[2024-11-09T14:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.028753s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.107532s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.043101s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.009256s ]
[2024-11-09T14:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.059015s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.019427s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.040522s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039766s ]
[2024-11-09T14:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.084306s ]
[2024-11-09T14:15:44+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000325s ]
[2024-11-09T14:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.047964s ]
[2024-11-09T14:15:44+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.049945s ]
[2024-11-09T14:15:47+08:00][sql] CONNECT:[ UseTime:0.413457s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T14:15:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.120669s ]
[2024-11-09T14:15:47+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.018998s ]
[2024-11-09T14:15:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.044588s ]
[2024-11-09T14:15:47+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 2 ORDER BY `sort` ASC [ RunTime:0.019055s ]
[2024-11-09T15:38:14+08:00][sql] CONNECT:[ UseTime:0.349223s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T15:38:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.029726s ]
[2024-11-09T15:38:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 31 LIMIT 1 [ RunTime:0.041940s ]
[2024-11-09T15:38:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.046437s ]
[2024-11-09T15:38:14+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 31  AND `table_type` = 'nursing_home_comment' [ RunTime:0.040195s ]
[2024-11-09T15:38:14+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 31 [ RunTime:0.148695s ]
[2024-11-09T15:38:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001195s ]
[2024-11-09T15:38:14+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000417s ]
[2024-11-09T15:38:14+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.034501s ]
[2024-11-09T17:37:06+08:00][sql] CONNECT:[ UseTime:0.000388s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-09T17:37:06+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001175s ]
[2024-11-09T17:37:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `lnstitutional_nature` = '4' LIMIT 1 [ RunTime:0.000314s ]
[2024-11-09T17:37:06+08:00][sql] SELECT COUNT(*) AS think_co