[2] ErrorException in Mysql.php line 110

PDO::query(): MySQL server has gone away

  1. /**
  2. * SQL性能分析
  3. * @access protected
  4. * @param string $sql
  5. * @return array
  6. */
  7. protected function getExplain($sql)
  8. {
  9. $pdo = $this->linkID->query("EXPLAIN " . $sql);
  10. $result = $pdo->fetch(PDO::FETCH_ASSOC);
  11. $result = array_change_key_case($result);
  12. if (isset($result['extra'])) {
  13. if (strpos($result['extra'], 'filesort') || strpos($result['extra'], 'temporary')) {
  14. Log::record('SQL:' . $this->queryStr . '[' . $result['extra'] . ']', 'warn');
  15. }
  16. }
  17. return $result;
  18. }

Call Stack

  1. in Mysql.php line 110
  2. at Error::appError(2, 'PDO::query(): MySQL ...', '/www/wwwroot/syx/sim...', 110, ['sql' => 'SELECT COUNT(*) AS t...'])
  3. at PDO->query('EXPLAIN SELECT COUNT...') in Mysql.php line 110
  4. at Mysql->getExplain('SELECT COUNT(*) AS t...') in Connection.php line 920
  5. at Connection->debug(false, 'SELECT COUNT(*) AS t...', false) in Connection.php line 378
  6. at Connection->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 255
  7. at Query->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 2470
  8. at Query->getPdo() in Query.php line 441
  9. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 576
  10. at Query->aggregate('COUNT', '*', true) in Query.php line 551
  11. at Query->count() in OfficeModel.php line 1067
  12. at OfficeModel->house_list() in IndexController.php line 983
  13. at IndexController->house_list()
  14. at ReflectionMethod->invokeArgs(object(IndexController), []) in App.php line 343
  15. at App::invokeMethod([object(IndexController), 'house_list'], []) in App.php line 611
  16. at App::module(['portal', 'index', 'house_list'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 456
  17. at App::exec(['type' => 'module', 'module' => ['portal', 'index', 'house_list'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  18. at App::run() in index.php line 79

Environment Variables

GET Data
empty
POST Data
empty
Files
empty
Cookies
empty

Session

site
think
{ "host": "xzl" }

Server/Request Data

USER
www
HOME
/home/www
HTTP_HOST
www.syx51.com
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
PATH_INFO
/xzl/1_0_0_892_0_0_0_0_0_0_0_0_0_8425_0_0_0/
REDIRECT_STATUS
200
SERVER_NAME
www.syx51.com
SERVER_PORT
80
SERVER_ADDR
172.16.198.36
REMOTE_PORT
47070
REMOTE_ADDR
44.201.59.20
SERVER_SOFTWARE
nginx/1.15.9
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/syx/public
DOCUMENT_URI
/index.php
REQUEST_URI
/xzl/1_0_0_892_0_0_0_0_0_0_0_0_0_8425_0_0_0/
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/xzl/1_0_0_892_0_0_0_0_0_0_0_0_0_8425_0_0_0/
SCRIPT_FILENAME
/www/wwwroot/syx/public/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711696826.2685
REQUEST_TIME
1711696826
Environment Variables
empty

ThinkPHP Constants

APP_DEBUG
true
CMF_ROOT
/www/wwwroot/syx/public/../
APP_PATH
/www/wwwroot/syx/public/../app/
CMF_PATH
/www/wwwroot/syx/public/../simplewind/cmf/
WEB_ROOT
/www/wwwroot/syx/public/
PLUGINS_PATH
/www/wwwroot/syx/public/plugins/
UPLOAD_PATH
upload/
EXTEND_PATH
/www/wwwroot/syx/public/../simplewind/extend/
VENDOR_PATH
/www/wwwroot/syx/public/../simplewind/vendor/
RUNTIME_PATH
/www/wwwroot/syx/public/../data/runtime/
THINKCMF_VERSION
5.0.181231
THINK_VERSION
5.0.24
THINK_START_TIME
1711696826.2691
THINK_START_MEM
423768
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/syx/simplewind/thinkphp/
LIB_PATH
/www/wwwroot/syx/simplewind/thinkphp/library/
CORE_PATH
/www/wwwroot/syx/simplewind/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/syx/simplewind/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/syx/
LOG_PATH
/www/wwwroot/syx/public/../data/runtime/log/
CACHE_PATH
/www/wwwroot/syx/public/../data/runtime/cache/
TEMP_PATH
/www/wwwroot/syx/public/../data/runtime/temp/
CONF_PATH
/www/wwwroot/syx/public/../app/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
HTMLPURIFIER_PREFIX
/www/wwwroot/syx/simplewind/vendor/ezyang/htmlpurifier/library
QINIU_FUNCTIONS_VERSION
7.2.7