php开原系统,OneBase

[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:dbname=shan_yin;host=127.0.0.1;port=3306;charset=utf8

[ SQL ] SHOW COLUMNS FROM `ob_config` [ RunTime:0.000000s ]

[ SQL ] SELECT * FROM `ob_config` [ RunTime:0.000000s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'ob_config',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 25,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `ob_hook` [ RunTime:0.015625s ]

[ SQL ] SELECT `id`,`name`,`addon_list` FROM `ob_hook` [ RunTime:0.000000s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'ob_hook',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 3,

'filtered' => 100.0,

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.000000s ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` `a` INNER JOIN `ob_member` `m` ON `a`.`member_id`=`m`.`id` INNER JOIN `ob_article_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000000s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'm',

'partitions' => NULL,

'type' => 'index',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => 6,

'filtered' => 100.0,

'extra' => 'Using index',

) ]

[ SQL ] SELECT `a`.*,`m`.`nickname`,c.name as category_name FROM `ob_article` `a` INNER JOIN `ob_member` `m` ON `a`.`member_id`=`m`.`id` INNER JOIN `ob_article_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`status` <> -1 ORDER BY a.create_time desc LIMIT 0,10 [ RunTime:0.015625s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'm',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => 'PRIMARY',

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 6,

'filtered' => 100.0,

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

) ]

[ SQL ] SHOW COLUMNS FROM `ob_article_category` [ RunTime:0.000000s ]

[ SQL ] SELECT `id`,`name`,`describe`,`create_time`,`update_time`,`status`,`icon` FROM `ob_article_category` WHERE `status` <> -1 ORDER BY create_time asc [ RunTime:0.000000s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'ob_article_category',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 9,

'filtered' => 88.8888931274414,

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

) ]