[ SQL ] SELECT COUNT(*) AS tp_count FROM `itkee_user` `a` LEFT JOIN `itkee_user_have_tags` `b` ON `a`.`id`=`b`.`user_id` WHERE (`b`.`user_tags` LIKE '%,83' OR `b`.`user_tags` LIKE '%,83,%' OR `b`.`user_tags` LIKE '83,%' OR `b`.`user_tags` LIKE '83') LIMIT 1 [ RunTime:0.000351s ]

[ SQL ] SELECT `a`.`id`,`a`.`user_nickname`,`a`.`avatar`,`b`.`user_tag_names` FROM `itkee_user` `a` LEFT JOIN `itkee_user_have_tags` `b` ON `a`.`id`=`b`.`user_id` WHERE (`b`.`user_tags` LIKE '%,83' OR `b`.`user_tags` LIKE '%,83,%' OR `b`.`user_tags` LIKE '83,%' OR `b`.`user_tags` LIKE '83') ORDER BY `create_time` desc LIMIT 0,21 [ RunTime:0.000302s ]