EXPLAIN
SELECT COUNT(*) FROM ol_answerresult_1 INNER JOIN ol_question ON ol_answerresult_1.QuestionId = ol_question.QuestionId AND PaperId='00000000-0000-0000-0000-000000000000' AND ol_question.IsConfirmed=1 AND QuestionCategory=1 AND ol_question.SimilarType<>2 AND (GKYear!=0 OR GKArea!=0) WHERE ol_answerresult_1.userid=39176 AND ol_answerresult_1.SUBJECT=10
EXPLAIN
SELECT SQL_NO_CACHE questionid,AllTagCatalogId
FROM ol_question WHERE MATCH(AllTagCatalogId)AGAINST (7117,7116);
EXPLAIN
MATCH() AGAINST
SELECT SQL_NO_CACHE questionid
FROM ol_question WHERE AllTagCatalogId LIKE '%7116%';
SELECT BENCHMARK(1000000,(SELECT SQL_NO_CACHE questionid FROM ol_question WHERE MATCH(AllTagCatalogId)AGAINST ('7116') LIMIT 1))
SELECT BENCHMARK(1000000,(SELECT SQL_NO_CACHE questionid FROM ol_question WHERE AllTagCatalogId LIKE '%7116%' LIMIT 1))
SELECT BENCHMARK(10000000,CURRENT_DATE())
