Advertising
- Someone
- Thursday, May 3rd, 2012 at 2:23:09am MDT
- |
- +--------------+---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------------+
- | primary_term | CREATE TABLE `primary_term` (
- `type` varchar(64) NOT NULL DEFAULT '0',
- `tid` int(10) unsigned NOT NULL DEFAULT '0',
- `weight` int(11) NOT NULL DEFAULT '0',
- `top_tid` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`type`,`tid`),
- KEY `idx_weight` (`weight`),
- KEY `idx_tid` (`tid`),
- KEY `top_tid` (`top_tid`,`tid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
- +--------------+---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------------+
- 1 row in set (0.00 sec)
- mysql> SELECT sql_no_cache DISTINCT direction FROM saxotech_wires sw JOIN term_node tn ON tn.nid = sw.nid JOIN primary_term pt ON pt.tid = tn.tid WHERE sw.wire_id = 981978 AND pt.top_tid = 65324 AND wiredate = 1335970492;
- Empty set (3.77 sec)
- mysql> explain SELECT sql_no_cache DISTINCT direction FROM saxotech_wires sw JOIN term_node tn ON tn.nid = sw.nid JOIN primary_term pt ON pt.tid = tn.tid WHERE sw.wire_id = 981978 AND pt.top_tid = 65324 AND wiredate = 1335970492;
- +----+-------------+-------+--------+---------------------+---------+---------+--------------------------+------+------------------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+-------+--------+---------------------+---------+---------+--------------------------+------+------------------------------+
- | 1 | SIMPLE | pt | ref | idx_tid,top_tid | top_tid | 4 | const | 797 | Using index; Using temporary |
- | 1 | SIMPLE | tn | ref | PRIMARY,nid,tid_nid | tid_nid | 4 | pbond.pt.tid | 209 | Using index |
- | 1 | SIMPLE | sw | eq_ref | PRIMARY | PRIMARY | 16 | pbond.tn.nid,const,const | 1 | |
- +----+-------------+-------+--------+---------------------+---------+---------+--------------------------+------+------------------------------+
- 3 rows in set (0.00 sec)
- mysql> SELECT sql_no_cache DISTINCT direction FROM saxotech_wires sw JOIN term_node tn ON tn.nid = sw.nid JOIN primary_term pt ON pt.tid = tn.tid WHERE sw.wire_id = 981978 AND pt.top_tid = 65324 AND wiredate = 1335970492;
- Empty set (5.83 sec)
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.