SHOW FULL COLUMNS FROM `information` [ RunTime:0.001347s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `information` `i` LEFT JOIN `information_tag` `it` ON `i`.`id`=`it`.`information_id` LEFT JOIN `tag` `t` ON `it`.`tag_id`=`t`.`id` WHERE `i`.`is_del` = '0' GROUP BY `i`.`id` ) `_group_count_` [ RunTime:0.000379s ]
SELECT `i`.*,GROUP_CONCAT(t.id SEPARATOR ",") as tag_ids,GROUP_CONCAT(t.tag_name SEPARATOR ", ") as tag_names FROM `information` `i` LEFT JOIN `information_tag` `it` ON `i`.`id`=`it`.`information_id` LEFT JOIN `tag` `t` ON `it`.`tag_id`=`t`.`id` WHERE `i`.`is_del` = '0' GROUP BY `i`.`id` ORDER BY `i`.`id` DESC LIMIT 0,10 [ RunTime:0.000287s ]
