mysql搜索标题及时间_mysql搜索标题，描述和多行标记

我有以下表格。

入口表描述

+-------------+-------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------------+-------------------+------+-----+---------+----------------+

| id | int(11) unsigned | NO | PRI | NULL | auto_increment |

| title | varchar(255) | YES | | NULL | |

| slug | varchar(255) | YES | | NULL | |

| description | text | YES | | NULL | |

| user_id | int(10) unsigned | NO | | NULL | |

| unsafe | enum('0','1') | NO | | NULL | |

| copyright | enum('0','1') | NO | | 0 | |

| status | enum('0','1','2') | NO | | 0 | |

| date_add | datetime | NO | | NULL | |

+-------------+-------------------+------+-----+---------+----------------+标签表格描述

+-------------+---------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------------+---------------------+------+-----+---------+----------------+

| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |

| relation_id | int(10) unsigned | NO | | NULL | |

| name | varchar(255) | NO | | NULL | |

+-------------+---------------------+------+-----+---------+----------------+我想在entry.title和tag.name中搜索。这个查询的性能如何？

我继续使用全文。你怎么 ？