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


Current File : /www/wwwroot/0531yanglao.com/runtime/index/log/202411/17.log
[2024-11-17T00:33:22+08:00][sql] CONNECT:[ UseTime:0.239735s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T00:33:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.078349s ]
[2024-11-17T00:33:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 13 LIMIT 1 [ RunTime:0.003115s ]
[2024-11-17T00:33:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.061324s ]
[2024-11-17T00:33:22+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 13  AND `table_type` = 'nursing_home_comment' [ RunTime:0.011061s ]
[2024-11-17T00:33:22+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 13 [ RunTime:0.115905s ]
[2024-11-17T00:33:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001221s ]
[2024-11-17T00:33:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.007856s ]
[2024-11-17T00:33:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.031838s ]
[2024-11-17T01:46:18+08:00][sql] CONNECT:[ UseTime:0.598121s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T01:46:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.091305s ]
[2024-11-17T01:46:18+08:00][sql] SELECT * FROM `dg_sojourn_city` ORDER BY `sid` ASC [ RunTime:0.000344s ]
[2024-11-17T01:46:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.166610s ]
[2024-11-17T01:46:18+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `city_id` IN (1,3) [ RunTime:0.008786s ]
[2024-11-17T02:21:30+08:00][sql] CONNECT:[ UseTime:0.343986s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T02:21:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.123845s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 3 LIMIT 1 [ RunTime:0.028792s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 3  AND `type` = 'help' ORDER BY RAND() LIMIT 4 [ RunTime:0.023210s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.066028s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.008603s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.088211s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help'  AND `article_id` < 3 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.003347s ]
[2024-11-17T02:21:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help'  AND `article_id` > 3 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.011212s ]
[2024-11-17T03:13:10+08:00][sql] CONNECT:[ UseTime:0.027838s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T03:13:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.046704s ]
[2024-11-17T03:13:10+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 53 LIMIT 1 [ RunTime:0.066180s ]
[2024-11-17T03:13:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.101334s ]
[2024-11-17T03:13:10+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 53  AND `table_type` = 'nursing_home_comment' [ RunTime:0.068984s ]
[2024-11-17T03:13:10+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 53 [ RunTime:0.103016s ]
[2024-11-17T03:13:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.023034s ]
[2024-11-17T03:13:10+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.032893s ]
[2024-11-17T03:13:10+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.036948s ]
[2024-11-17T03:20:05+08:00][sql] CONNECT:[ UseTime:0.222486s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T03:20:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.152551s ]
[2024-11-17T03:20:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.022579s ]
[2024-11-17T03:20:05+08:00][sql] SELECT * FROM `dg_nursing_home` ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000831s ]
[2024-11-17T03:20:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.210809s ]
[2024-11-17T03:20:05+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.013639s ]
[2024-11-17T03:20:05+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.010563s ]
[2024-11-17T03:20:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.033071s ]
[2024-11-17T03:20:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000487s ]
[2024-11-17T03:20:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.105328s ]
[2024-11-17T03:20:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.056751s ]
[2024-11-17T03:20:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000622s ]
[2024-11-17T03:20:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000771s ]
[2024-11-17T06:09:51+08:00][sql] CONNECT:[ UseTime:0.000428s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T06:09:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001071s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000416s ]
[2024-11-17T06:09:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001246s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.764439s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.031139s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.000833s ]
[2024-11-17T06:09:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.081547s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.041820s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000542s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000714s ]
[2024-11-17T06:09:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.045624s ]
[2024-11-17T06:09:51+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.006994s ]
[2024-11-17T06:09:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.077096s ]
[2024-11-17T06:09:51+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.071969s ]
[2024-11-17T06:10:33+08:00][sql] CONNECT:[ UseTime:0.000425s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T06:10:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.001362s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 1 LIMIT 1 [ RunTime:0.000474s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 1  AND `type` = 'news' ORDER BY RAND() LIMIT 4 [ RunTime:0.001577s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.000537s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.000554s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.000467s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news'  AND `article_id` < 1 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.000378s ]
[2024-11-17T06:10:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news'  AND `article_id` > 1 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.000438s ]
[2024-11-17T06:28:05+08:00][sql] CONNECT:[ UseTime:1.716978s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T06:28:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.039093s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.012830s ]
[2024-11-17T06:28:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.022375s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.239598s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.145813s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.049176s ]
[2024-11-17T06:28:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.098743s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.031445s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011712s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.055572s ]
[2024-11-17T06:28:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.014724s ]
[2024-11-17T06:28:05+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.046687s ]
[2024-11-17T06:28:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.048496s ]
[2024-11-17T06:28:05+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000451s ]
[2024-11-17T07:21:15+08:00][sql] CONNECT:[ UseTime:0.331615s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T07:21:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.091127s ]
[2024-11-17T07:21:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`)  AND `service` = '7' LIMIT 1 [ RunTime:0.066805s ]
[2024-11-17T07:21:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.082202s ]
[2024-11-17T07:21:15+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.022138s ]
[2024-11-17T07:21:15+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000352s ]
[2024-11-17T07:21:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.022418s ]
[2024-11-17T07:21:15+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.034177s ]
[2024-11-17T07:21:15+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.125977s ]
[2024-11-17T07:21:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.026759s ]
[2024-11-17T07:21:15+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.010847s ]
[2024-11-17T07:21:15+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.036244s ]
[2024-11-17T07:37:52+08:00][sql] CONNECT:[ UseTime:0.155494s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T07:37:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.126477s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `sid` = 1 LIMIT 1 [ RunTime:0.030725s ]
[2024-11-17T07:37:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.020594s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_sojourn_city` WHERE  `sid` = 1 [ RunTime:0.116100s ]
[2024-11-17T07:37:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.119057s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 1  AND `table_type` = 'sojourn_comment' [ RunTime:0.010651s ]
[2024-11-17T07:37:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.066707s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'sojourn' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.013173s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `sid` IN (2,1) [ RunTime:0.000571s ]
[2024-11-17T07:37:52+08:00][sql] SELECT * FROM `dg_sojourn_city` WHERE  `sid` = 1 LIMIT 1 [ RunTime:0.016371s ]
[2024-11-17T07:46:33+08:00][sql] CONNECT:[ UseTime:0.000412s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T07:46:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001403s ]
[2024-11-17T07:46:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '2'  AND `type` = '3'  AND `lnstitutional_nature` = '2'  AND `min_price` BETWEEN '5000' AND '6000'  LIMIT 1 [ RunTime:0.000517s ]
[2024-11-17T07:46:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.000307s ]
[2024-11-17T07:46:33+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000221s ]
[2024-11-17T07:46:33+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000241s ]
[2024-11-17T07:46:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.481403s ]
[2024-11-17T07:46:33+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.021011s ]
[2024-11-17T07:46:33+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.077906s ]
[2024-11-17T07:46:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.061848s ]
[2024-11-17T07:46:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022358s ]
[2024-11-17T07:46:33+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000701s ]
[2024-11-17T07:46:36+08:00][sql] CONNECT:[ UseTime:0.733945s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T07:46:36+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.072740s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.021760s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.012652s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.032576s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.013944s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000358s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.050942s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.031730s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000364s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.011186s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000328s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.011450s ]
[2024-11-17T07:46:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.021970s ]
[2024-11-17T09:22:34+08:00][sql] CONNECT:[ UseTime:0.000488s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001351s ]
[2024-11-17T09:22:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `service` = '7'  AND `type` = '3'  AND `lnstitutional_nature` = '2'  AND `min_price` BETWEEN '1000' AND '2000'  LIMIT 1 [ RunTime:0.000461s ]
[2024-11-17T09:22:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.811472s ]
[2024-11-17T09:22:34+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.010551s ]
[2024-11-17T09:22:34+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000227s ]
[2024-11-17T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001124s ]
[2024-11-17T09:22:34+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000375s ]
[2024-11-17T09:22:34+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.071908s ]
[2024-11-17T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.019353s ]
[2024-11-17T09:22:34+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.027237s ]
[2024-11-17T09:22:34+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.041677s ]
[2024-11-17T09:22:37+08:00][sql] CONNECT:[ UseTime:0.000401s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T09:22:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.012143s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lixiaqu', `location`) LIMIT 1 [ RunTime:0.010845s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shizhongqu', `location`) LIMIT 1 [ RunTime:0.000330s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('tianqiaoqu', `location`) LIMIT 1 [ RunTime:0.000306s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('lichengqu', `location`) LIMIT 1 [ RunTime:0.000276s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('huaiyinqu', `location`) LIMIT 1 [ RunTime:0.000302s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('changqingqu', `location`) LIMIT 1 [ RunTime:0.000268s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('zhangqiuqu', `location`) LIMIT 1 [ RunTime:0.000334s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('pingyinxian', `location`) LIMIT 1 [ RunTime:0.000278s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`) LIMIT 1 [ RunTime:0.000285s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`) LIMIT 1 [ RunTime:0.000291s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('laiwuqu', `location`) LIMIT 1 [ RunTime:0.000270s ]
[2024-11-17T09:22:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('gangchengqu', `location`) LIMIT 1 [ RunTime:0.000297s ]
[2024-11-17T09:46:59+08:00][sql] CONNECT:[ UseTime:0.085151s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T09:46:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001378s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000457s ]
[2024-11-17T09:46:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.993552s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.025614s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.376862s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.023346s ]
[2024-11-17T09:46:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.174429s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022252s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.003744s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.045826s ]
[2024-11-17T09:46:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.028526s ]
[2024-11-17T09:46:59+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.039505s ]
[2024-11-17T09:46:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.073135s ]
[2024-11-17T09:46:59+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000403s ]
[2024-11-17T09:47:09+08:00][sql] CONNECT:[ UseTime:0.000381s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T09:47:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001228s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.000387s ]
[2024-11-17T09:47:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001264s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.565144s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.058621s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.019521s ]
[2024-11-17T09:47:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.011779s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.027659s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.015047s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.030721s ]
[2024-11-17T09:47:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.063643s ]
[2024-11-17T09:47:09+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000369s ]
[2024-11-17T09:47:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.058918s ]
[2024-11-17T09:47:09+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.060469s ]
[2024-11-17T09:47:34+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T09:47:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.001328s ]
[2024-11-17T09:47:34+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000387s ]
[2024-11-17T09:47:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.000967s ]
[2024-11-17T09:47:34+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000373s ]
[2024-11-17T10:32:22+08:00][sql] CONNECT:[ UseTime:0.601570s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T10:32:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.044704s ]
[2024-11-17T10:32:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`)  AND `lnstitutional_nature` = '1' LIMIT 1 [ RunTime:0.012822s ]
[2024-11-17T10:32:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.142188s ]
[2024-11-17T10:32:22+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000268s ]
[2024-11-17T10:32:22+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000225s ]
[2024-11-17T10:32:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001214s ]
[2024-11-17T10:32:22+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.019006s ]
[2024-11-17T10:32:22+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.133334s ]
[2024-11-17T10:32:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.074696s ]
[2024-11-17T10:32:22+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000658s ]
[2024-11-17T10:32:22+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.013270s ]
[2024-11-17T10:58:34+08:00][sql] CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T10:58:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001465s ]
[2024-11-17T10:58:34+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 7 LIMIT 1 [ RunTime:0.000478s ]
[2024-11-17T10:58:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001005s ]
[2024-11-17T10:58:34+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 7  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000418s ]
[2024-11-17T10:58:34+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 7 [ RunTime:0.625555s ]
[2024-11-17T10:58:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.004961s ]
[2024-11-17T10:58:34+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000378s ]
[2024-11-17T10:58:34+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.061477s ]
[2024-11-17T11:53:30+08:00][sql] CONNECT:[ UseTime:0.000449s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T11:53:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001522s ]
[2024-11-17T11:53:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `lnstitutional_nature` = '4' LIMIT 1 [ RunTime:0.000476s ]
[2024-11-17T11:53:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.000339s ]
[2024-11-17T11:53:30+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000245s ]
[2024-11-17T11:53:30+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000233s ]
[2024-11-17T11:53:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001048s ]
[2024-11-17T11:53:30+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000450s ]
[2024-11-17T11:53:30+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.736634s ]
[2024-11-17T11:53:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.037665s ]
[2024-11-17T11:53:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.022194s ]
[2024-11-17T11:53:30+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.044049s ]
[2024-11-17T12:41:49+08:00][sql] CONNECT:[ UseTime:0.118194s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T12:41:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.051598s ]
[2024-11-17T12:41:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '1' LIMIT 1 [ RunTime:0.031064s ]
[2024-11-17T12:41:49+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `type` = '1' ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.003329s ]
[2024-11-17T12:41:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.211474s ]
[2024-11-17T12:41:49+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.025578s ]
[2024-11-17T12:41:49+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.006946s ]
[2024-11-17T12:41:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.005188s ]
[2024-11-17T12:41:49+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.012155s ]
[2024-11-17T12:41:49+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.048786s ]
[2024-11-17T12:41:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.088065s ]
[2024-11-17T12:41:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039586s ]
[2024-11-17T12:41:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.002685s ]
[2024-11-17T13:32:31+08:00][sql] CONNECT:[ UseTime:0.298041s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T13:32:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn` [ RunTime:0.138838s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `sid` = 2 LIMIT 1 [ RunTime:0.054670s ]
[2024-11-17T13:32:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_sojourn_city` [ RunTime:0.044897s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_sojourn_city` WHERE  `sid` = 3 [ RunTime:0.083209s ]
[2024-11-17T13:32:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.064834s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 2  AND `table_type` = 'sojourn_comment' [ RunTime:0.040676s ]
[2024-11-17T13:32:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.019833s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'sojourn' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.020412s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_sojourn` WHERE  `sid` IN (2,1) [ RunTime:0.049648s ]
[2024-11-17T13:32:31+08:00][sql] SELECT * FROM `dg_sojourn_city` WHERE  `sid` = 3 LIMIT 1 [ RunTime:0.000402s ]
[2024-11-17T14:45:45+08:00][sql] CONNECT:[ UseTime:0.214607s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.087749s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 21 LIMIT 1 [ RunTime:0.076390s ]
[2024-11-17T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.079085s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 21  AND `table_type` = 'nursing_home_comment' [ RunTime:0.021884s ]
[2024-11-17T14:45:45+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 21 [ RunTime:0.065696s ]
[2024-11-17T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001276s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000423s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.055365s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 5，36，15，20，61 [ RunTime:0.062275s ]
[2024-11-17T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.034067s ]
[2024-11-17T14:45:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.073205s ]
[2024-11-17T16:17:57+08:00][sql] CONNECT:[ UseTime:1.822947s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T16:17:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001604s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 5 LIMIT 1 [ RunTime:0.000556s ]
[2024-11-17T16:17:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.276172s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 5  AND `table_type` = 'nursing_home_comment' [ RunTime:0.216635s ]
[2024-11-17T16:17:57+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 5 [ RunTime:0.076508s ]
[2024-11-17T16:17:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.006213s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000388s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.003221s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (61,36,15,20,21) [ RunTime:0.006900s ]
[2024-11-17T16:17:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.012420s ]
[2024-11-17T16:17:57+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.001257s ]
[2024-11-17T16:24:08+08:00][sql] CONNECT:[ UseTime:0.212034s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T16:24:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.129729s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 2 LIMIT 1 [ RunTime:0.019610s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 2  AND `type` = 'regulations' ORDER BY RAND() LIMIT 4 [ RunTime:0.034640s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.058596s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.013231s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.045718s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations'  AND `article_id` < 2 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.043243s ]
[2024-11-17T16:24:08+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations'  AND `article_id` > 2 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.011303s ]
[2024-11-17T16:53:53+08:00][sql] CONNECT:[ UseTime:0.684529s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T16:53:53+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.097678s ]
[2024-11-17T16:53:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`)  AND `min_price` BETWEEN '1000' AND '2000'  LIMIT 1 [ RunTime:0.044711s ]
[2024-11-17T16:53:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.125506s ]
[2024-11-17T16:53:53+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021679s ]
[2024-11-17T16:53:53+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021453s ]
[2024-11-17T16:53:53+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.045163s ]
[2024-11-17T16:53:53+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000446s ]
[2024-11-17T16:53:53+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.072751s ]
[2024-11-17T16:53:53+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.056576s ]
[2024-11-17T16:53:53+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000651s ]
[2024-11-17T16:53:53+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000724s ]
[2024-11-17T18:44:52+08:00][sql] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T18:44:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001378s ]
[2024-11-17T18:44:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('jiyangqu', `location`)  AND `lnstitutional_nature` = '3' LIMIT 1 [ RunTime:0.000425s ]
[2024-11-17T18:44:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.660599s ]
[2024-11-17T18:44:52+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.010906s ]
[2024-11-17T18:44:52+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.000314s ]
[2024-11-17T18:44:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.023033s ]
[2024-11-17T18:44:52+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.061867s ]
[2024-11-17T18:44:52+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.091184s ]
[2024-11-17T18:44:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.051055s ]
[2024-11-17T18:44:52+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011643s ]
[2024-11-17T18:44:52+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.002595s ]
[2024-11-17T19:04:00+08:00][sql] CONNECT:[ UseTime:0.331567s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T19:04:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.064680s ]
[2024-11-17T19:04:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  FIND_IN_SET('shanghexian', `location`)  AND `service` = '10'  AND `lnstitutional_nature` = '1' LIMIT 1 [ RunTime:0.002635s ]
[2024-11-17T19:04:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.132500s ]
[2024-11-17T19:04:00+08:00][sql] SELECT MIN(`min_price`) AS think_min FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.021595s ]
[2024-11-17T19:04:00+08:00][sql] SELECT MAX(`max_price`) AS think_max FROM `dg_nursing_home` WHERE  0 = 1 LIMIT 1 [ RunTime:0.027995s ]
[2024-11-17T19:04:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.024245s ]
[2024-11-17T19:04:00+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.014207s ]
[2024-11-17T19:04:00+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.136244s ]
[2024-11-17T19:04:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.028859s ]
[2024-11-17T19:04:00+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.012107s ]
[2024-11-17T19:04:00+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.029867s ]
[2024-11-17T20:16:03+08:00][sql] CONNECT:[ UseTime:0.157789s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T20:16:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.033882s ]
[2024-11-17T20:16:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` WHERE  `type` = '1' LIMIT 1 [ RunTime:0.024326s ]
[2024-11-17T20:16:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `type` = '1' ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.065779s ]
[2024-11-17T20:16:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_nursing_home` LIMIT 1 [ RunTime:0.260246s ]
[2024-11-17T20:16:03+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.001095s ]
[2024-11-17T20:16:03+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.001451s ]
[2024-11-17T20:16:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.012623s ]
[2024-11-17T20:16:03+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.011727s ]
[2024-11-17T20:16:03+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5) [ RunTime:0.108147s ]
[2024-11-17T20:16:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.082514s ]
[2024-11-17T20:16:03+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.039183s ]
[2024-11-17T20:16:03+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.033677s ]
[2024-11-17T20:22:49+08:00][sql] CONNECT:[ UseTime:0.308697s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T20:22:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.084149s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 17 LIMIT 1 [ RunTime:0.054008s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 17  AND `type` = 'hobby' ORDER BY RAND() LIMIT 4 [ RunTime:0.024164s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` IN ('literature','history','essay') ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.018788s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` IN ('health','diet','psychology','essay') ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.034892s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` IN ('activities','RetirementLife','SenileLife','GeriatricCulture','hobby') ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.002715s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby'  AND `article_id` < 17 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.013611s ]
[2024-11-17T20:22:49+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'hobby'  AND `article_id` > 17 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.026052s ]
[2024-11-17T20:54:38+08:00][sql] CONNECT:[ UseTime:0.352686s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T20:54:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.091172s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.022431s ]
[2024-11-17T20:54:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.066760s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (22,7,49,34,58,57,61,5,1) [ RunTime:0.079945s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 2  AND `table_type` = 'NursingHome' ORDER BY `sort` ASC LIMIT 9 [ RunTime:0.088825s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (35,29,28,27,17,59,18,60,1) [ RunTime:0.033863s ]
[2024-11-17T20:54:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.045497s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.029218s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.032972s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.011824s ]
[2024-11-17T20:54:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv` [ RunTime:0.096392s ]
[2024-11-17T20:54:38+08:00][sql] SELECT * FROM `dg_adv` WHERE  `id` = 13 LIMIT 1 [ RunTime:0.000388s ]
[2024-11-17T20:54:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_adv_data` [ RunTime:0.011359s ]
[2024-11-17T20:54:38+08:00][sql] SELECT `name`,`url`,`filename`,`summary` FROM `dg_adv_data` WHERE  `ap_id` = 13 ORDER BY `sort` ASC [ RunTime:0.022055s ]
[2024-11-17T21:06:47+08:00][sql] CONNECT:[ UseTime:0.000416s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T21:06:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.001313s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 20 LIMIT 1 [ RunTime:0.000461s ]
[2024-11-17T21:06:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.001010s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 20  AND `table_type` = 'nursing_home_comment' [ RunTime:0.000355s ]
[2024-11-17T21:06:47+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 20 [ RunTime:0.596211s ]
[2024-11-17T21:06:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.002670s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.032697s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.033253s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 5，36，15，21，61 [ RunTime:0.059768s ]
[2024-11-17T21:06:47+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.032065s ]
[2024-11-17T21:06:47+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 0 [ RunTime:0.030183s ]
[2024-11-17T22:31:24+08:00][sql] CONNECT:[ UseTime:0.405080s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T22:31:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_nursing_home` [ RunTime:0.117012s ]
[2024-11-17T22:31:24+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` = 59 LIMIT 1 [ RunTime:0.011483s ]
[2024-11-17T22:31:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_comment` [ RunTime:0.033654s ]
[2024-11-17T22:31:24+08:00][sql] SELECT * FROM `dg_comment` WHERE  `table_id` = 59  AND `table_type` = 'nursing_home_comment' [ RunTime:0.033323s ]
[2024-11-17T22:31:24+08:00][sql] UPDATE `dg_nursing_home`  SET `click_num` = `click_num` + 1  WHERE  `nid` = 59 [ RunTime:0.084646s ]
[2024-11-17T22:31:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_recommend` [ RunTime:0.001237s ]
[2024-11-17T22:31:24+08:00][sql] SELECT * FROM `dg_recommend` WHERE  `r_id` = 1  AND `table_type` = 'nursinghome' ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.043267s ]
[2024-11-17T22:31:24+08:00][sql] SELECT * FROM `dg_nursing_home` WHERE  `nid` IN (1,7,49,34) [ RunTime:0.091944s ]
[2024-11-17T22:34:50+08:00][sql] CONNECT:[ UseTime:0.047294s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T22:34:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.059377s ]
[2024-11-17T22:34:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.000698s ]
[2024-11-17T22:34:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.069337s ]
[2024-11-17T22:34:50+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 9 [ RunTime:0.000595s ]
[2024-11-17T22:34:50+08:00][sql] SELECT * FROM `dg_article` ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.088715s ]
[2024-11-17T22:53:06+08:00][sql] CONNECT:[ UseTime:0.350607s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T22:53:06+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.099388s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 31 LIMIT 1 [ RunTime:0.026731s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 31  AND `type` = 'regulations' ORDER BY RAND() LIMIT 4 [ RunTime:0.029389s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.055514s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.020800s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.044027s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations'  AND `article_id` < 31 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.011299s ]
[2024-11-17T22:53:06+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations'  AND `article_id` > 31 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.022190s ]
[2024-11-17T23:50:45+08:00][sql] CONNECT:[ UseTime:0.305420s ] mysql:host=127.0.0.1;port=3306;dbname=0531yanglao_com;charset=utf8
[2024-11-17T23:50:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_article` [ RunTime:0.079798s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` = 18 LIMIT 1 [ RunTime:0.001953s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `article_id` <> 18  AND `type` = 'news' ORDER BY RAND() LIMIT 4 [ RunTime:0.056326s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.112975s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'regulations' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.000620s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'help' ORDER BY `create_time` DESC LIMIT 2 [ RunTime:0.000448s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news'  AND `article_id` < 18 ORDER BY `article_id` DESC LIMIT 1 [ RunTime:0.000414s ]
[2024-11-17T23:50:45+08:00][sql] SELECT * FROM `dg_article` WHERE  `type` = 'news'  AND `article_id` > 18 ORDER BY `article_id` ASC LIMIT 1 [ RunTime:0.011228s ]