[ DB ] CONNECT:[ UseTime:0.001178s ] mysql:host=rm-8vb8p4b8y5v25sl93.mysql.zhangbei.rds.aliyuncs.com;port=3306;dbname=lichuang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ke_kefu` [ RunTime:0.000856s ]
[ SQL ] SELECT `id`,`qq`,`name` FROM `ke_kefu` [ RunTime:0.000455s ]
[ SQL ] SHOW COLUMNS FROM `ke_forum_cat` [ RunTime:0.000668s ]
[ SQL ] SELECT `name` FROM `ke_forum_cat` WHERE `id` = 226 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SHOW COLUMNS FROM `ke_forum` [ RunTime:0.000759s ]
[ SQL ] SELECT `title` FROM `ke_forum` WHERE `id` = 458 LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT `pid` FROM `ke_forum_cat` WHERE `id` = 226 LIMIT 1 [ RunTime:0.000375s ]
[ SQL ] SELECT `id`,`pid`,`name` FROM `ke_forum_cat` WHERE `pid` = 113 [ RunTime:0.000529s ]
[ SQL ] SHOW COLUMNS FROM `ke_user` [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `ke_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000558s ]
[ SQL ] UPDATE `ke_forum` SET `look_num`=`look_num`+1 WHERE `id` = 458 [ RunTime:0.001629s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 225 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000538s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 226 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000484s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1167 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000468s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1168 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000498s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1169 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1170 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000462s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1171 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000450s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1172 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1173 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000456s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1174 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1175 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000426s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1176 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1177 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000448s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1178 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000427s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1179 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1180 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000449s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1181 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1182 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000454s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` = 1183 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT SUM(look_num) AS tp_sum FROM `ke_forum` WHERE `cid` IN (225,226,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183) AND `add_time` BETWEEN '2019-12-06 00:00:00' AND '2019-12-07 00:00:00' LIMIT 1 [ RunTime:0.000578s ]
[ SQL ] SELECT SUM(look_num) AS tp_sum FROM `ke_forum` WHERE `cid` IN (225,226,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183) AND `add_time` BETWEEN '2019-12-05 00:00:00' AND '2019-12-06 00:00:00' LIMIT 1 [ RunTime:0.000557s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `cid` IN (225,226,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183) LIMIT 1 [ RunTime:0.000481s ]
[ SQL ] SELECT SUM(look_num) AS tp_sum FROM `ke_forum` WHERE `cid` IN (225,226,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183) LIMIT 1 [ RunTime:0.000518s ]
[ SQL ] SELECT `f`.`id`,`f`.`is_good`,`c`.`name`,`f`.`title`,`f`.`content`,`f`.`add_time`,`f`.`look_num`,`f`.`reply_num`,`f`.`cid`,`f`.`point`,`f`.`finish`,`u`.`username`,`u`.`phone`,`u`.`headimg`,`f`.`uid`,`u`.`jifen`,u.add_time as uadd_time,`f`.`type`,`f`.`wenjian`,`f`.`wenjian_type`,`f`.`wenjian_point`,`f`.`wenjian_describe`,`u`.`caiwu`,`u`.`pay_pwd`,`f`.`img` FROM `ke_forum` `f` INNER JOIN `ke_forum_cat` `c` ON `f`.`cid`=`c`.`id` INNER JOIN `ke_user` `u` ON `f`.`uid`=`u`.`id` WHERE `f`.`id` = '458' AND `f`.`is_show` = 1 AND `f`.`status` = 0 LIMIT 1 [ RunTime:0.000680s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `uid` = 1155 AND `type` = 0 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000918s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `uid` = 1155 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000723s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum` WHERE `uid` = 1155 AND `is_good` = 1 AND `is_show` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000923s ]
[ SQL ] SHOW COLUMNS FROM `ke_forum_reply` [ RunTime:0.000717s ]
[ SQL ] SELECT `u`.`username`,`u`.`phone`,`u`.`headimg`,`r`.`msg`,`r`.`add_time`,`r`.`zan`,`r`.`id`,u.id as user_id,`u`.`jifen`,u.add_time as uadd_time,`r`.`fid`,`r`.`is_use` FROM `ke_forum_reply` `r` INNER JOIN `ke_user` `u` ON `r`.`uid`=`u`.`id` WHERE `fid` = 458 AND `r`.`is_show` = 1 ORDER BY add_time asc [ RunTime:0.000555s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ke_forum_reply` `r` INNER JOIN `ke_user` `u` ON `r`.`uid`=`u`.`id` WHERE `fid` = 458 AND `r`.`is_show` = 1 LIMIT 1 [ RunTime:0.000510s ]
[ SQL ] SHOW COLUMNS FROM `ke_one_img` [ RunTime:0.000810s ]
1对1咨询
返回顶部
