Ehcache二级缓存使用和不使用,iterate()方法查询的sql语句对比

来源:互联网 发布:淘宝开店 虚拟商品 编辑:程序博客网 时间:2024/03/29 02:10
Hibernate: select meg0_.id as col_0_0_ from Meg meg0_
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
java
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
.net
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
1 day
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
2 days
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
better than .net!
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
well!
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
just so so!
Hibernate: select meg0_.id as id2_2_, meg0_.content as content2_2_, meg0_.topic_id as topic3_2_2_, topic1_.id as id1_0_, topic1_.category_id as category3_1_0_, topic1_.title as title1_0_, category2_.id as id0_1_, category2_.name as name0_1_ from Meg meg0_ left outer join Topic topic1_ on meg0_.topic_id=topic1_.id left outer join Category category2_ on topic1_.category_id=category2_.id where meg0_.id=?
good!

Hibernate: select meg0_.id as id2_, meg0_.content as content2_, meg0_.topic_id as topic3_2_ from Meg meg0_
Hibernate: select topic0_.id as id1_1_, topic0_.category_id as category3_1_1_, topic0_.title as title1_1_, category1_.id as id0_0_, category1_.name as name0_0_ from Topic topic0_ left outer join Category category1_ on topic0_.category_id=category1_.id where topic0_.id=?
Hibernate: select topic0_.id as id1_1_, topic0_.category_id as category3_1_1_, topic0_.title as title1_1_, category1_.id as id0_0_, category1_.name as name0_0_ from Topic topic0_ left outer join Category category1_ on topic0_.category_id=category1_.id where topic0_.id=?
Hibernate: select topic0_.id as id1_1_, topic0_.category_id as category3_1_1_, topic0_.title as title1_1_, category1_.id as id0_0_, category1_.name as name0_0_ from Topic topic0_ left outer join Category category1_ on topic0_.category_id=category1_.id where topic0_.id=?
java
.net
1 day
2 days
better than .net!
well!
just so so!
good!