-
select distinct
node.*,
note.*,
original_author,
weight , votetime,
considernodes.considernodes_id,
considernodes.description as considertext
from node
left join note on note_id = node_id
left join vote on (vote_id = node_id and voter_user = 108447)
left join considernodes on considernodes_id = node_id
left join contributor on contributor_id = node_id
where type_nodetype in (7487 , 1036 , 115 , 120 , 23614 , 121 , 1584 , 1588 , 1042 , 956 , 31663 , 31670 , 1823 , 1857 , 1888 , 1980 , 1748 , 1440 , 389544 , 4,5 , 106924 , 14 , 397475 , 112733 , 356170 , 17338 , 370024 , 11 , 15)
and createtime >= DATE_ADD('2006-03-31 16:00:14' , INTERVAL -1 DAY) and createtime <= '2006-03-31 16:00:14'
limit 2000
node |
range |
typecreatetime,type |
typecreatetime |
12 |
|
353 |
Using where; Using temporary |
note |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
vote |
eq_ref |
PRIMARY,voter_user_idx |
PRIMARY |
8 |
node.node_id,const |
1 |
Using where |
considernodes |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
contributor |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
-
select node.*,
note.*,
original_author,
weight , votetime,
considernodes.considernodes_id,
considernodes.description as considertext
from node
left join note on node_id = note_id
left join considernodes on considernodes_id = node_id
left join contributor on contributor_id = node_id
left join vote on (vote_id = node_id and voter_user = 108447)
where node_id in ( 68307, 458233, 504328, 532692, 538243, 539202, 539324, 539575, 539619, 539653, 539720, 539816, 539829, 539862, 539903, 540025, 540053, 540080, 540136, 540167, 540182, 540184, 540231, 540237, 540253, 540262, 540263, 540267, 540276 )
and type_nodetype in (7487 , 1036 , 115 , 120 , 23614 , 121 , 1584 , 1588 , 1042 , 956 , 31663 , 31670 , 1823 , 1857 , 1888 , 1980 , 1748 , 1440 , 389544 , 4,5 , 106924 , 14 , 397475 , 112733 , 356170 , 17338 , 370024 , 11 , 15)
node |
range |
PRIMARY,typecreatetime,type |
PRIMARY |
4 |
|
29 |
Using where |
note |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
considernodes |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
contributor |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
vote |
eq_ref |
PRIMARY,voter_user_idx |
PRIMARY |
8 |
node.node_id,const |
1 |
Using where |
-
select node.*,
note.*,
original_author,
weight , votetime,
considernodes.considernodes_id,
considernodes.description as considertext
from node , note
left join considernodes on considernodes_id = node_id
left join contributor on contributor_id = node_id
left join vote on (vote_id = node_id and voter_user = 108447)
where (
root_node in ( 68307, 458233, 504328, 532692, 538243, 539202, 539324, 539575, 539619, 539653, 539720, 539816, 539829, 539862, 539903, 540025, 540053, 540080, 540136, 540167, 540182, 540184, 540231, 540237, 540253, 540262, 540263, 540267, 540276, 540282, 540285, 540301, 540307, 540311, 540314, 540325, 540335, 540340, 540354, 540357, 540365, 540369, 540374, 540377, 540402, 540413, 540417, 540426, 540439, 540440, 540445, 540447, 540450, 540460, 540498, 540499, 540500, 540508, 540511, 540533, 540536 )
)
and not ( createtime >= DATE_ADD('2006-03-31 16:00:14' , INTERVAL -1 DAY) and createtime <= '2006-03-31 16:00:14' )
and node_id = note_id
limit 2000
note |
range |
PRIMARY,root_node |
root_node |
4 |
|
605 |
Using where |
node |
eq_ref |
PRIMARY |
PRIMARY |
4 |
note.note_id |
1 |
Using where |
considernodes |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
contributor |
eq_ref |
PRIMARY |
PRIMARY |
4 |
node.node_id |
1 |
|
vote |
eq_ref |
PRIMARY,voter_user_idx |
PRIMARY |
8 |
node.node_id,const |
1 |
Using where |
|
|