测试一个系统-IT界青草根

[ DB ] CONNECT:[ UseTime:0.000563s ] mysql:host=127.0.0.1;port=3306;dbname=52qcgblog;charset=utf8

[ SQL ] SHOW COLUMNS FROM `think_article` [ RunTime:0.001651s ]

[ SQL ] SELECT * FROM `think_article` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000392s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_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 `think_article_cate` [ RunTime:0.001133s ]

[ SQL ] SELECT * FROM `think_article_cate` WHERE `status` = 1 [ RunTime:0.000343s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where', ) ]

[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000257s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('9') AND `r`.`status` = 1 LIMIT 1 [ RunTime:0.000375s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]

[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('9') AND `r`.`status` = 1 ORDER BY `views` DESC LIMIT 0,10 [ RunTime:0.000475s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000265s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('9') LIMIT 1 [ RunTime:0.000304s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]

[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('9') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000453s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000293s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('9') LIMIT 1 [ RunTime:0.000310s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]

[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('9') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000429s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SHOW COLUMNS FROM `think_article_tag` [ RunTime:0.000952s ]

[ SQL ] SELECT tag,count(*) number FROM `think_article_tag` GROUP BY `tag` ORDER BY `number` DESC LIMIT 15 [ RunTime:0.000323s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_tag', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '96', 'ref' => NULL, 'rows' => 13, 'filtered' => 100.0, 'extra' => 'Using index; Using temporary; Using filesort', ) ]

[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000277s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('9') LIMIT 1 [ RunTime:0.000327s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]

[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('9') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000434s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SELECT `id`,`pid`,`name`,`type` FROM `think_article_cate` [ RunTime:0.000228s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT `id`,`pid`,`name`,`type` FROM `think_article_cate` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000269s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '2', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 120 LIMIT 1 [ RunTime:0.000363s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]

[ SQL ] UPDATE `think_article` SET `views`=`views`+1 WHERE `id` = 120 [ RunTime:0.004320s ]

[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 119 LIMIT 1 [ RunTime:0.000385s ]

[ 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' => 'Impossible WHERE noticed after reading const tables', ) ]

[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 121 LIMIT 1 [ RunTime:0.000340s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]

测试一个系统

最新文章

Tags

热门文章

图片文章

关于博主

订阅消息

关注我

联系我