[ 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 '%,71' OR `b`.`user_tags` LIKE '%,71,%' OR `b`.`user_tags` LIKE '71,%' OR `b`.`user_tags` LIKE '71') LIMIT 1 [ RunTime:0.000356s ]

[ 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 '%,71' OR `b`.`user_tags` LIKE '%,71,%' OR `b`.`user_tags` LIKE '71,%' OR `b`.`user_tags` LIKE '71') ORDER BY `create_time` desc LIMIT 0,21 [ RunTime:0.000307s ]