php 语法糖,教你用两行代码给PHP7添加一个“非空合并”语法糖-CSDN博客

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

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

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

[ 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.007656s ]

[ 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.007950s ]

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

[ 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.007960s ]

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

[ 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.008005s ]

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

[ 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.007913s ]

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

[ 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` = 105 ORDER BY `article_num` DESC [ RunTime:0.008274s ]

[ 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.007989s ]

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

[ 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.007932s ]

[ 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.007995s ]

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

[ 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.007988s ]

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

[ 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.007641s ]

[ 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` = 105 ORDER BY `article_id` DESC LIMIT 50 [ RunTime:0.008014s ]

[ 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 (64919,64910,64905,64902,64901,64893,64886,64871,64869,64865,64862,64856,64854,64853,64851,64848,64845,64842,64841,64838,64837,64833,64829,64822,64820,64817,64814,64813,64806,64804,64799,64782,64781,64777,64770,64767,64759,64754,64748,64739,64737,64736,64734,64733,64732,64729,64722,64721,64713,64710) ORDER BY `id` DESC [ RunTime:0.008316s ]

[ 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=49613) group by c.category_id,cc.column_id limit 50 [ RunTime:0.048599s ]

[ 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,1064,1065,1066,1074,1080,1087,1089,1096,1100,1104,1112,1113,1114,1115,1116,1119,1121,1127,1128,1129,1133,1135,1136,1137,1139,1141,1142,1143,1144,1145,1146,1147,1148,1152,1154,1157,1160) ORDER BY `article_num` DESC [ RunTime:0.008028s ]

[ 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=49613) group by c.tag_id,cc.column_id limit 50 [ RunTime:0.057012s ]

[ 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,153,154,155,156,157,158,159,160,161,162,163,164,169,170,171,172,174,176,177,178,179,180,181,182,184,185,186,399,400,402,403,408,410,413,415,417,418,422,423,426,427,429,430,432,433,435,436) ORDER BY `article_num` DESC [ RunTime:0.008348s ]

[ 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.008090s ]

[ SQL ] SELECT * FROM `phptext_search_keyword` WHERE ( MATCH (keyword) AGAINST ("教你用两行代码给PHP7添加一个“非空合并”语法糖") ) ORDER BY `searchtime` DESC LIMIT 50 [ RunTime:0.017247s ]

[ 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.025099s ]

[ 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' => 63416,

'filtered' => 100.0,

'extra' => 'Using where',

) ]

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

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

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