SELECT searchcore.searchgroupid, searchgroup.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON (searchcore.contenttypeid = 1 AND searchcore.groupid = thread.threadid) JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid) JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid) WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('а�аЕаЛаЕаЗаНб�аЙ б�аЕаЛаОаВаЕаК 2') AND thread.forumid IN (339) AND searchgroup.contenttypeid IN ('2') LIMIT 500; PROFILING: mysql> show profile for query 1; +--------------------------------+------------+ | Status | Duration | +--------------------------------+------------+ | starting | 0.000146 | | checking query cache for query | 0.000154 | | Opening tables | 0.000075 | | System lock | 0.000025 | | Table lock | 80.410162 | | init | 0.000206 | | optimizing | 0.000046 | | statistics | 0.000263 | | preparing | 0.000048 | | FULLTEXT initialization | 1.557537 | | executing | 0.000149 | | Sending data | 475.372835 | | end | 0.000139 | | query end | 0.000017 | | freeing items | 0.000091 | | logging slow query | 0.000018 | | logging slow query | 0.000097 | | cleaning up | 0.000018 | +--------------------------------+------------+ 18 rows in set (0.42 sec) mysql> show profile all for query 1\G *************************** 1. row *************************** Status: starting Duration: 0.000146 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: NULL Source_file: NULL Source_line: NULL *************************** 2. row *************************** Status: checking query cache for query Duration: 0.000154 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_cache.cc Source_line: 1446 *************************** 3. row *************************** Status: Opening tables Duration: 0.000075 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_base.cc Source_line: 4495 *************************** 4. row *************************** Status: System lock Duration: 0.000025 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: lock.cc Source_line: 258 *************************** 5. row *************************** Status: Table lock Duration: 80.410162 CPU_user: 23.540000 CPU_system: 6.520000 Context_voluntary: 135955 Context_involuntary: 7840 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 50979 Swaps: 0 Source_function: unknown function Source_file: lock.cc Source_line: 269 *************************** 6. row *************************** Status: init Duration: 0.000206 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 2485 *************************** 7. row *************************** Status: optimizing Duration: 0.000046 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 820 *************************** 8. row *************************** Status: statistics Duration: 0.000263 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 1 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 1011 *************************** 9. row *************************** Status: preparing Duration: 0.000048 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 1033 *************************** 10. row *************************** Status: FULLTEXT initialization Duration: 1.557537 CPU_user: 0.690000 CPU_system: 0.080000 Context_voluntary: 1672 Context_involuntary: 97 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 1434 Swaps: 0 Source_function: unknown function Source_file: sql_base.cc Source_line: 8630 *************************** 11. row *************************** Status: executing Duration: 0.000149 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 1756 *************************** 12. row *************************** Status: Sending data Duration: 475.372835 CPU_user: 123.170000 CPU_system: 37.350000 Context_voluntary: 405933 Context_involuntary: 24427 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 227373 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 2310 *************************** 13. row *************************** Status: end Duration: 0.000139 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_select.cc Source_line: 2531 *************************** 14. row *************************** Status: query end Duration: 0.000017 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_parse.cc Source_line: 4963 *************************** 15. row *************************** Status: freeing items Duration: 0.000091 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_parse.cc Source_line: 5989 *************************** 16. row *************************** Status: logging slow query Duration: 0.000018 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_parse.cc Source_line: 1664 *************************** 17. row *************************** Status: logging slow query Duration: 0.000097 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 1 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_parse.cc Source_line: 1674 *************************** 18. row *************************** Status: cleaning up Duration: 0.000018 CPU_user: 0.000000 CPU_system: 0.000000 Context_voluntary: 0 Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: unknown function Source_file: sql_parse.cc Source_line: 1632 18 rows in set (0.00 sec)