Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Query 1
- SELECT id
- FROM archive, topic
- WHERE topic.type=0 AND archive.status=2
- AND MATCH(title, description) AGAINST ('+house* +tz*' IN BOOLEAN MODE)
- AND archive.topicId = topic.id
- ORDER BY archive.featured DESC, archive.submissionDate DESC LIMIT 0,20
- Total count: 12
- Key_read_requests: 2384607
- Creating sort index: 7.950430 sec (!)
- Duration: 8.851252 sec
- # Query 2
- SELECT id
- FROM archive, topic
- WHERE topic.type=0 AND archive.status=2
- AND MATCH(title, description) AGAINST ('+tz* +house*' IN BOOLEAN MODE)
- AND archive.topicId = topic.id
- ORDER BY archive.featured DESC, archive.submissionDate DESC LIMIT 0,20
- Total count: 12
- Key_read_requests: 415
- Creating sort index: 0.003449
- Duration: 0.004054 sec
- tz*: 135092
- tz: 25596
- house*: 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement