关于盖楼式评论的测试报告

最新推荐文章于 2019-06-21 09:49:19 发布

桃根仙

最新推荐文章于 2019-06-21 09:49:19 发布

阅读量435

点赞数

分类专栏： php mysql

本文链接：https://blog.csdn.net/taotaobaobei/article/details/89299326

版权

php 同时被 2 个专栏收录

118 篇文章 0 订阅

订阅专栏

mysql

25 篇文章 0 订阅

订阅专栏

针对文章评论的sql:

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '3' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '3' LIMIT 1

SELECT `tableid`,`commentid` FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SELECT `tableid`,`total` FROM `phpcmsv9`.`v9_comment_table` ORDER BY tableid desc LIMIT 1

INSERT INTO `phpcmsv9`.`v9_comment`(`commentid`,`siteid`,`tableid`,`display_type`,`title`,`url`) VALUES ('content_6-3-1','1','1','1','phpcms 第三篇文章','http://phpcms.io/index.php?m=content&c=index&a=show&catid=6&id=3')

SHOW TABLES

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

INSERT INTO `phpcmsv9`.`v9_comment_data_1`(`userid`,`username`,`content`,`direction`,`commentid`,`siteid`,`ip`,`status`,`creat_at`) VALUES ('1','www','第三篇文章的第一篇评论，www进行评论测试','1','content_6-3-1','1','127.0.0.1','1','1555236005')

UPDATE `phpcmsv9`.`v9_comment_table` SET `total`=`total`+1 WHERE `tableid` = '1'

UPDATE `phpcmsv9`.`v9_comment` SET `lastupdate`='1555236005',`total`=`total`+1,`square`=`square`+1 WHERE `commentid` = 'content_6-3-1'

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '3' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment_data_1` WHERE `commentid` = 'content_6-3-1' AND `status` = '1' ORDER BY id desc LIMIT 0,20

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

针对评论回复的sql:

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '2' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '2' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '2' LIMIT 1

SELECT `tableid`,`commentid` FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-2-1' AND `siteid` = '1' LIMIT 1

SHOW TABLES

SELECT * FROM `phpcmsv9`.`v9_comment_data_1` WHERE `id` = '13' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

INSERT INTO `phpcmsv9`.`v9_comment_data_1`(`userid`,`username`,`content`,`direction`,`commentid`,`siteid`,`ip`,`status`,`creat_at`,`reply`) VALUES ('4','member3','

www 于 2019-04-14 17:25:40发布
我是www,我也对第二篇文章进行一次评论
member2 于 2019-04-14 17:30:04发布我是member2，对第二篇评论进行回复一下
member1 于 2019-04-14 17:46:20发布qq 回复的消息
www 于 2019-04-14 17:49:23发布再盖楼
member3 对www的评论进行回复，这是栏目6的第二篇文章','','content_6-2-1','1','127.0.0.1','1','1555235733','1')
UPDATE `phpcmsv9`.`v9_comment_table` SET `total`=`total`+1 WHERE `tableid` = '1'

UPDATE `phpcmsv9`.`v9_comment` SET `lastupdate`='1555235733',`total`=`total`+1 WHERE `commentid` = 'content_6-2-1'

190414 17:55:34	662 Connect	root@localhost on phpcmsv9

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '2' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '2' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '2' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-2-1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-2-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-2-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment_data_1` WHERE `commentid` = 'content_6-2-1' AND `status` = '1' ORDER BY id desc LIMIT 0,20

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '2' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '3' LIMIT 1

切换用户进行回复测试：

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '3' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '3' LIMIT 1

SELECT `tableid`,`commentid` FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SHOW TABLES

SELECT * FROM `phpcmsv9`.`v9_comment_data_1` WHERE `id` = '15' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

INSERT INTO `phpcmsv9`.`v9_comment_data_1`(`userid`,`username`,`content`,`direction`,`commentid`,`siteid`,`ip`,`status`,`creat_at`,`reply`) VALUES ('4','member3','

www 于 2019-04-14 18:00:05发布
第三篇文章的第一篇评论，www进行评论测试
对第三篇文章第一条评论进行回复测试，我是用户member3','','content_6-3-1','1','127.0.0.1','1','1555236354','1')
UPDATE `phpcmsv9`.`v9_comment_table` SET `total`=`total`+1 WHERE `tableid` = '1'

UPDATE `phpcmsv9`.`v9_comment` SET `lastupdate`='1555236354',`total`=`total`+1 WHERE `commentid` = 'content_6-3-1'

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_comment_setting` WHERE `siteid` = '1' LIMIT 1

SELECT `title` FROM `phpcmsv9`.`v9_news` WHERE `catid` = '6' AND `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_news_data` WHERE `id` = '3' LIMIT 1

SELECT `url` FROM `phpcmsv9`.`v9_news` WHERE `id` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment` WHERE `commentid` = 'content_6-3-1' AND `siteid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_comment_data_1` WHERE `commentid` = 'content_6-3-1' AND `status` = '1' ORDER BY id desc LIMIT 0,20

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1