php 413,[PHP]解决nginx php上传文件限制413 Request Entity Too Large

[ DB ] CONNECT:[ UseTime:0.013055s ] mysql:host=sdm722905177.my3w.com;port=3306;dbname=sdm722905177_db;charset=utf8mb4

[ SQL ] SHOW COLUMNS FROM `phptext_plugin` [ RunTime:0.008043s ]

[ SQL ] SELECT `config` FROM `phptext_plugin` WHERE `name` = 'SuxMobileTheme' LIMIT 1 [ RunTime:0.007586s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_plugin',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 10,

'filtered' => 10.0,

'extra' => 'Using where',

) ]

[ SQL ] SELECT `config` FROM `phptext_plugin` WHERE `name` = 'SuxSwitchHttpsUrl' LIMIT 1 [ RunTime:0.007537s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_plugin',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 10,

'filtered' => 10.0,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_column` [ RunTime:0.007934s ]

[ SQL ] SELECT * FROM `phptext_column` [ RunTime:0.007599s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_column',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 30,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_category` [ RunTime:0.007917s ]

[ SQL ] SELECT * FROM `phptext_category` [ RunTime:0.007708s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_category',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 205,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_article` [ RunTime:0.007915s ]

[ SQL ] SELECT * FROM `phptext_article` WHERE `id` = 40225 LIMIT 1 [ RunTime:0.008092s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_article_column` [ RunTime:0.007863s ]

[ SQL ] SELECT * FROM `phptext_article_column` WHERE `article_id` = 40225 LIMIT 50 [ RunTime:0.007736s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_column',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using index',

) ]

[ SQL ] SELECT `id`,`title` FROM `phptext_column` WHERE `id` = 141 ORDER BY `article_num` DESC [ RunTime:0.007582s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_column',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_article_category` [ RunTime:0.007886s ]

[ SQL ] SELECT * FROM `phptext_article_category` WHERE `article_id` = 40225 LIMIT 50 [ RunTime:0.007757s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_category',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using index',

) ]

[ SQL ] SELECT `id`,`title` FROM `phptext_category` WHERE `id` = 1015 ORDER BY `article_num` DESC [ RunTime:0.007649s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_category',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_article_tag` [ RunTime:0.008097s ]

[ SQL ] SELECT * FROM `phptext_article_tag` WHERE `article_id` = 40225 LIMIT 50 [ RunTime:0.007750s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_tag',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using index',

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_tags` [ RunTime:0.008237s ]

[ SQL ] SELECT `id`,`title` FROM `phptext_tags` WHERE `id` IN ('') ORDER BY `article_num` DESC [ RunTime:0.007564s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => NULL,

'partitions' => NULL,

'type' => NULL,

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => NULL,

'filtered' => NULL,

'extra' => 'no matching row in const table',

) ]

[ SQL ] SELECT `config` FROM `phptext_plugin` WHERE `name` = 'SuxVicWord' LIMIT 1 [ RunTime:0.007610s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_plugin',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 10,

'filtered' => 10.0,

'extra' => 'Using where',

) ]

[ SQL ] SELECT * FROM `phptext_article_column` WHERE `column_id` = 141 ORDER BY `article_id` DESC LIMIT 50 [ RunTime:0.007703s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_column',

'partitions' => NULL,

'type' => 'index',

'possible_keys' => NULL,

'key' => 'PRIMARY',

'key_len' => '8',

'ref' => NULL,

'rows' => 50,

'filtered' => 10.0,

'extra' => 'Using where; Using index',

) ]

[ SQL ] SELECT `id`,`title`,`pubtime` FROM `phptext_article` WHERE `id` IN (65240,65235,65234,65232,65228,65226,65225,65224,65223,65218,65217,65215,65211,65210,65206,65204,65201,65200,65199,65196,65194,65193,65185,65183,65182,65178,65177,65173,65169,65168,65166,65165,65164,65163,65162,65160,65159,65158,65153,65152,65151,65149,65147,65144,65136,65135,65132,65130,65126,65125) ORDER BY `id` DESC [ RunTime:0.007743s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article',

'partitions' => NULL,

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => 50,

'filtered' => 100.0,

'extra' => 'Using index condition',

) ]

[ SQL ] select c.category_id from phptext_article_category c INNER JOIN phptext_article_column cc ON cc.article_id=c.article_id where cc.column_id in (select column_id from phptext_article_column where article_id=40225) group by c.category_id,cc.column_id limit 50 [ RunTime:0.081736s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_column',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using index; Using temporary; Using filesort',

) ]

[ SQL ] SELECT `id`,`title` FROM `phptext_category` WHERE `id` IN (1011,1012,1013,1014,1015,1016,1017,1018,1019,1023,1057,1058,1059,1067,1068,1069,1070,1072,1074,1075,1077,1078,1084,1085,1088,1090,1091,1092,1094,1105,1106,1110,1117,1123,1124,1125,1126,1127,1128,1129,1131,1134,1138,1140,1148,1151,1172,1173,1178,1179) ORDER BY `article_num` DESC [ RunTime:0.007744s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_category',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => 'PRIMARY',

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 205,

'filtered' => 24.390243530273438,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] select c.tag_id from phptext_article_tag c INNER JOIN phptext_article_column cc ON cc.article_id=c.article_id where cc.column_id in (select column_id from phptext_article_column where article_id=40225) group by c.tag_id,cc.column_id limit 50 [ RunTime:0.138596s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_article_column',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using index; Using temporary; Using filesort',

) ]

[ SQL ] SELECT `id`,`title` FROM `phptext_tags` WHERE `id` IN (101,102,103,155,156,158,159,162,163,164,168,169,171,172,174,175,176,177,178,181,182,184,185,186,187,400,402,403,408,413,415,416,417,418,422,423,425,426,427,428,429,430,431,432,433,436,437,439,440,444) ORDER BY `article_num` DESC [ RunTime:0.010848s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_tags',

'partitions' => NULL,

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => 50,

'filtered' => 100.0,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_search_keyword` [ RunTime:0.007972s ]

[ SQL ] SELECT * FROM `phptext_search_keyword` WHERE ( MATCH (keyword) AGAINST ("[PHP]解决nginx php上传文件限制413 Request Entity Too Large") ) ORDER BY `searchtime` DESC LIMIT 50 [ RunTime:0.031848s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_search_keyword',

'partitions' => NULL,

'type' => 'fulltext',

'possible_keys' => 'keyword_fulltext',

'key' => 'keyword_fulltext',

'key_len' => '0',

'ref' => 'const',

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SELECT id,title,image,pubtime,views FROM phptext_article WHERE id >= ( SELECT floor(RAND() * ((SELECT MAX(id) FROM phptext_article)-10000))+10000) LIMIT 100; [ RunTime:0.025096s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'PRIMARY',

'table' => 'phptext_article',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 63735,

'filtered' => 100.0,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `phptext_theme_file` [ RunTime:0.008427s ]

[ SQL ] SELECT `more` FROM `phptext_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'app/home/article' ) [ RunTime:0.007669s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_theme_file',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 1,

'filtered' => 100.0,

'extra' => 'Using where',

) ]

[ SQL ] SELECT `config` FROM `phptext_plugin` WHERE `name` = 'SuxPageContentFilter' LIMIT 1 [ RunTime:0.011424s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'phptext_plugin',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 10,

'filtered' => 10.0,

'extra' => 'Using where',

) ]