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/ |
[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