Hello,
I am using native SQLQueries to perform searches on my database, and whenever I use the addJoin() method, the object returned by SQLQuery.list() are anonymous objects rather than the persistent objects I am looking for. Reflection indicates that these objects do not have any extra properties or methods so I'm assuming this means something is failing at some point.
The relevant classes are Venue, VenueSectionMapping, and RestaurantInfo. RestaurantInfo is a subclass of VenueSectionMapping that uses a table-per-subclass inheritance strategy.
I've read and re-read the chapter in the Hibernate manual on Native SQL Queries and experimented with a few different strategies for injecting column aliases, but everything I do either throws an exception or gives me back these anonymous objects. If I only do the main addEntity() and leave out the addJoin(), it works just fine. Any help would be appreciated!
Hibernate version:
3.1
Mapping documents:
Code:
<hibernate-mapping>
<class name="com.timeout.data.Venue" table="venue">
<!-- Primary Key -->
<id name="id" column="id">
<generator class="native"/>
</id>
<!-- Natural ID -->
<property name="name"
type="string"
index="index_name"/>
<!-- Foreign Keys -->
<many-to-one name="neighborhood"
column="neighbourhood_id"
class="com.timeout.data.Neighborhood"
not-null="true"
index="neighborhood_fkey"/>
<many-to-one name="image"
column="image_id"
class="com.timeout.data.Image"
index="image_fkey"/>
<!-- Local properties -->
<property name="altName"
column="alt_name"
type="string"
index="index_alt_name"/>
<property name="buildingName"
column="building_name"
type="string"/>
<property name="openingTimes"
column="opening_times"
type="string"/>
<property name="url"
type="string"/>
<component name="address"
class="com.timeout.data.component.Address">
<property name="street"
type="text"
column="address"/>
<property name="intersection"
type="text"
column="cross_street"/>
<property name="postcode"
type="string"
index="index_postcode"/>
<component name="coordinates"
class="com.timeout.data.component.Coordinates">
<property name="latitude"
type="java.lang.Double"
not-null="true"
index="index_coordinates"/>
<property name="longitude"
type="java.lang.Double"
not-null="true"
index="index_coordinates"/>
</component>
</component>
<property name="travel"
type="text"/>
<property name="phone"
type="string"/>
<property name="email"
type="string"/>
<property name="status"
type="integer"
not-null="true"/>
<properties name="unique_source" unique="true">
<property name="source"
type="string"
not-null="true"/>
<property name="sourceId"
column="source_id"
type="integer"
not-null="true"/>
</properties>
<property name="annotation"
type="text"/>
<property name="searchPriority"
column="search_priority"
type="java.lang.Short"/>
<!-- One-to-many Containers -->
<set name="occurrences"
inverse="true"
access="field">
<key column="venue_id" not-null="true"/>
<one-to-many class="com.timeout.data.Occurrence"/>
</set>
<!-- Simple Many-to-many Containers -->
<set name="venueGroups"
table="venue_venue_group_mapping"
inverse="true"
access="field">
<key column="venue_id" not-null="true"/>
<many-to-many column="venue_group_id"
class="com.timeout.data.VenueGroup"/>
</set>
<!-- Complex Many-to-many Containers -->
<map name="attributes"
inverse="true"
access="field">
<key column="venue_id"
not-null="true"/>
<map-key-many-to-many column="attribute_key_id"
class="com.timeout.data.AttributeKey"/>
<one-to-many class="com.timeout.data.VenueAttribute"/>
</map>
<map name="sectionMappings"
inverse="true"
cascade="all,delete-orphan"
access="field">
<key column="venue_id" not-null="true"/>
<map-key-many-to-many column="category_id"
class="com.timeout.data.Section"/>
<one-to-many class="com.timeout.data.VenueSectionMapping"/>
</map>
</class>
<class name="com.timeout.data.VenueSectionMapping" table="venue_category_mapping">
<!-- Primary Composite Key -->
<composite-id>
<key-many-to-one name="venue"
column="venue_id"
class="com.timeout.data.Venue"/>
<key-many-to-one name="section"
column="category_id"
class="com.timeout.data.Section"/>
</composite-id>
<joined-subclass name="com.timeout.data.RestaurantInfo" table="restaurant_extra_info">
<!-- Composite Primary Key Assocation -->
<key>
<column name="venue_id"/>
<column name="category_id"/>
</key>
<!-- Foreign Keys -->
<many-to-one name="primaryCuisine"
column="primary_cuisine_id"
class="com.timeout.data.Cuisine"/>
<!-- Local Properties -->
<property name="annotation"
type="text"/>
<property name="annotationCapsule">
<column name="annotation_capsule" sql-type="tinytext"/>
</property>
<property name="prices">
<column name="prices" sql-type="tinytext"/>
</property>
<property name="paymentInfo">
<column name="payment_info" sql-type="tinytext"/>
</property>
<property name="openingTimes">
<column name="opening_times" sql-type="tinytext"/>
</property>
<property name="keywords">
<column name="keywords" sql-type="tinytext"/>
</property>
<property name="eatOutAward">
<column name="eat_out_award" sql-type="tinytext"/>
</property>
<property name="recommended" type="boolean"/>
<property name="budget" type="boolean"/>
<property name="source" type="string"/>
<property name="sourceId"
column="source_id"
type="integer"/>
<!-- Simple Many-to-many Mappings -->
<set name="cuisines"
table="restaurant_cuisine_mapping"
access="field">
<key>
<column name="category_id"/>
<column name="venue_id"/>
</key>
<many-to-many column="category_id_cuisine"
class="com.timeout.data.Cuisine"/>
</set>
</joined-subclass>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():The relevant code is:
Code:
String queryString = this.buildQuery();
log.debug(queryString);
SQLQuery query = util.session.createSQLQuery(queryString);
query.addEntity("restaurant", RestaurantInfo.class);
query.addJoin("venue", "restaurant.venue");
return query.list();
The value of queryString is:
Code:
SELECT {venue.*}, {restaurant.*}
FROM venue venue
INNER JOIN venue_category_mapping VenueSectionMapping
ON VenueSectionMapping.venue_id = Venue.id
INNER JOIN category Section
ON VenueSectionMapping.category_id = Section.id
INNER JOIN restaurant_extra_info restaurant
ON Restaurant.venue_id = Venue.id AND Restaurant.category_id = Section.id
INNER JOIN neighbourhood Neighborhood
ON Neighborhood.id = Venue.neighbourhood_id
INNER JOIN city City
ON City.id = Neighborhood.city_id
WHERE (Neighborhood.id = 5)
ORDER BY Venue.name ASC;
Name and version of the database you are using:MySQL 5.0.37
The generated SQL (show_sql=true):Code:
SELECT venue.id as id12_1_, venue.name as name12_1_, venue.neighbourhood_id as neighbou3_12_1_, venue.image_id as image4_12_1_, venue.alt_name as alt5_12_1_, venue.building_name as building6_12_1_, venue.opening_times as opening7_12_1_, venue.url as url12_1_, venue.address as address12_1_, venue.cross_street as cross10_12_1_, venue.postcode as postcode12_1_, venue.latitude as latitude12_1_, venue.longitude as longitude12_1_, venue.travel as travel12_1_, venue.phone as phone12_1_, venue.email as email12_1_, venue.status as status12_1_, venue.source as source12_1_, venue.source_id as source19_12_1_, venue.annotation as annotation12_1_, venue.search_priority as search21_12_1_, restaurant.venue_id as venue1_25_0_, restaurant.category_id as category2_25_0_, restaurant.primary_cuisine_id as primary3_26_0_, restaurant.annotation as annotation26_0_, restaurant.annotation_capsule as annotation5_26_0_, restaurant.prices as prices26_0_, restaurant.payment_info as payment7_26_0_, restaurant.opening_times as opening8_26_0_, restaurant.keywords as keywords26_0_, restaurant.eat_out_award as eat10_26_0_, restaurant.recommended as recomme11_26_0_, restaurant.budget as budget26_0_, restaurant.source as source26_0_, restaurant.source_id as source14_26_0_ FROM venue venue
INNER JOIN venue_category_mapping VenueSectionMapping
ON VenueSectionMapping.venue_id = Venue.id
INNER JOIN category Section
ON VenueSectionMapping.category_id = Section.id
INNER JOIN restaurant_extra_info restaurant
ON Restaurant.venue_id = Venue.id AND Restaurant.category_id = Section.id
INNER JOIN neighbourhood Neighborhood
ON Neighborhood.id = Venue.neighbourhood_id
INNER JOIN city City
ON City.id = Neighborhood.city_id
WHERE (Neighborhood.id = 5)
ORDER BY Venue.name ASC;
Debug level Hibernate log excerpt:
11:18:12,092 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2056]
11:18:12,093 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2056]
11:18:12,093 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#838, section=com.timeout.data.Section#4}]
11:18:12,094 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,094 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,095 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#838, section=com.timeout.data.Section#4}]
11:18:12,095 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#838, section=com.timeout.data.Section#4}]
11:18:12,095 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#838]
11:18:12,096 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,097 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,097 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#838]
11:18:12,098 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#838]
11:18:12,099 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#838]
11:18:12,100 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#838]
11:18:12,101 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#838]
11:18:12,102 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2571, section=com.timeout.data.Section#3}]
11:18:12,105 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#22]
11:18:12,107 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,107 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2571, section=com.timeout.data.Section#3}]
11:18:12,108 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2571, section=com.timeout.data.Section#3}]
11:18:12,108 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2571]
11:18:12,110 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,110 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,111 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2571]
11:18:12,112 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2571]
11:18:12,114 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2571]
11:18:12,115 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2571]
11:18:12,116 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2571]
11:18:12,116 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#809, section=com.timeout.data.Section#4}]
11:18:12,117 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,117 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,118 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#809, section=com.timeout.data.Section#4}]
11:18:12,120 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#809, section=com.timeout.data.Section#4}]
11:18:12,121 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#809]
11:18:12,121 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,122 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,123 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#809]
11:18:12,124 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#809]
11:18:12,124 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#809]
11:18:12,126 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#809]
11:18:12,127 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#809]
11:18:12,127 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2009, section=com.timeout.data.Section#3}]
11:18:12,127 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#31]
11:18:12,128 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,128 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2009, section=com.timeout.data.Section#3}]
11:18:12,129 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2009, section=com.timeout.data.Section#3}]
11:18:12,129 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2009]
11:18:12,130 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,131 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,131 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2009]
11:18:12,131 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2009]
11:18:12,132 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2009]
11:18:12,132 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2009]
11:18:12,133 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2009]
11:18:12,135 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#719, section=com.timeout.data.Section#4}]
11:18:12,135 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,136 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,137 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#719, section=com.timeout.data.Section#4}]
11:18:12,137 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#719, section=com.timeout.data.Section#4}]
11:18:12,138 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#719]
11:18:12,138 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,139 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,140 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#719]
11:18:12,140 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#719]
11:18:12,141 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#719]
11:18:12,142 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#719]
11:18:12,142 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#719]
11:18:12,143 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2450, section=com.timeout.data.Section#3}]
11:18:12,143 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#22]
11:18:12,145 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,146 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2450, section=com.timeout.data.Section#3}]
11:18:12,147 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2450, section=com.timeout.data.Section#3}]
11:18:12,147 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2450]
11:18:12,148 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,148 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,149 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2450]
11:18:12,150 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2450]
11:18:12,159 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2450]
11:18:12,160 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2450]
11:18:12,161 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2450]
11:18:12,161 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1500, section=com.timeout.data.Section#3}]
11:18:12,162 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#47]
11:18:12,163 DEBUG DefaultLoadEventListener:255 - creating new proxy for entity
11:18:12,165 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1500, section=com.timeout.data.Section#3}]
11:18:12,166 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1500, section=com.timeout.data.Section#3}]
11:18:12,167 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1500]
11:18:12,168 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,169 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,169 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1500]
11:18:12,170 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1500]
11:18:12,171 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1500]
11:18:12,171 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1500]
11:18:12,173 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1500]
11:18:12,173 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1638, section=com.timeout.data.Section#3}]
11:18:12,174 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#21]
11:18:12,175 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,176 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1638, section=com.timeout.data.Section#3}]
11:18:12,176 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1638, section=com.timeout.data.Section#3}]
11:18:12,180 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1638]
11:18:12,180 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,181 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,182 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1638]
11:18:12,183 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1638]
11:18:12,184 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1638]
11:18:12,185 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1638]
11:18:12,186 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1638]
11:18:12,186 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#933, section=com.timeout.data.Section#4}]
11:18:12,187 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,188 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,188 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#933, section=com.timeout.data.Section#4}]
11:18:12,189 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#933, section=com.timeout.data.Section#4}]
11:18:12,189 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#933]
11:18:12,190 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,190 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,191 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#933]
11:18:12,191 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#933]
11:18:12,192 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#933]
11:18:12,192 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#933]
11:18:12,193 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#933]
11:18:12,193 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3272, section=com.timeout.data.Section#3}]
11:18:12,194 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#43]
11:18:12,194 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,195 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3272, section=com.timeout.data.Section#3}]
11:18:12,196 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3272, section=com.timeout.data.Section#3}]
11:18:12,196 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3272]
11:18:12,197 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,197 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,197 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3272]
11:18:12,198 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3272]
11:18:12,198 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3272]
11:18:12,199 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3272]
11:18:12,201 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3272]
11:18:12,201 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#398, section=com.timeout.data.Section#4}]
11:18:12,201 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,202 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,202 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#398, section=com.timeout.data.Section#4}]
11:18:12,203 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#398, section=com.timeout.data.Section#4}]
11:18:12,203 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#398]
11:18:12,204 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,206 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,206 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#398]
11:18:12,207 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#398]
11:18:12,207 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#398]
11:18:12,208 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#398]
11:18:12,209 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#398]
11:18:12,211 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3371, section=com.timeout.data.Section#3}]
11:18:12,211 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#31]
11:18:12,212 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,213 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3371, section=com.timeout.data.Section#3}]
11:18:12,214 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3371, section=com.timeout.data.Section#3}]
11:18:12,214 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3371]
11:18:12,215 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,216 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,216 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3371]
11:18:12,218 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3371]
11:18:12,219 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3371]
11:18:12,221 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3371]
11:18:12,222 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3371]
11:18:12,222 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#449, section=com.timeout.data.Section#4}]
11:18:12,223 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,224 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,224 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#449, section=com.timeout.data.Section#4}]
11:18:12,227 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#449, section=com.timeout.data.Section#4}]
11:18:12,227 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#449]
11:18:12,228 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,228 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,230 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#449]
11:18:12,231 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#449]
11:18:12,231 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#449]
11:18:12,233 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#449]
11:18:12,233 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#449]
11:18:12,235 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1477, section=com.timeout.data.Section#3}]
11:18:12,235 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#41]
11:18:12,236 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,237 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1477, section=com.timeout.data.Section#3}]
11:18:12,237 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1477, section=com.timeout.data.Section#3}]
11:18:12,238 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1477]
11:18:12,240 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,240 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,241 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1477]
11:18:12,242 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1477]
11:18:12,242 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1477]
11:18:12,243 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1477]
11:18:12,243 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1477]
11:18:12,244 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2717, section=com.timeout.data.Section#3}]
11:18:12,244 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#26]
11:18:12,245 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,245 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2717, section=com.timeout.data.Section#3}]
11:18:12,246 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2717, section=com.timeout.data.Section#3}]
11:18:12,246 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2717]
11:18:12,247 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,247 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,248 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2717]
11:18:12,249 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2717]
11:18:12,249 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2717]
11:18:12,250 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2717]
11:18:12,250 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2717]
11:18:12,250 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2634, section=com.timeout.data.Section#3}]
11:18:12,251 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#36]
11:18:12,251 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,252 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2634, section=com.timeout.data.Section#3}]
11:18:12,253 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2634, section=com.timeout.data.Section#3}]
11:18:12,253 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2634]
11:18:12,254 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,254 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,254 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2634]
11:18:12,255 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2634]
11:18:12,255 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2634]
11:18:12,256 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2634]
11:18:12,257 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2634]
11:18:12,257 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1735, section=com.timeout.data.Section#3}]
11:18:12,257 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#12]
11:18:12,258 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,258 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1735, section=com.timeout.data.Section#3}]
11:18:12,259 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1735, section=com.timeout.data.Section#3}]
11:18:12,259 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1735]
11:18:12,260 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,260 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,261 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1735]
11:18:12,261 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1735]
11:18:12,262 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1735]
11:18:12,262 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1735]
11:18:12,263 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1735]
11:18:12,264 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#4147, section=com.timeout.data.Section#3}]
11:18:12,264 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#12]
11:18:12,265 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,265 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#4147, section=com.timeout.data.Section#3}]
11:18:12,266 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#4147, section=com.timeout.data.Section#3}]
11:18:12,266 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#4147]
11:18:12,267 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,267 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,268 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#4147]
11:18:12,268 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#4147]
11:18:12,269 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#4147]
11:18:12,269 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#4147]
11:18:12,270 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#4147]
11:18:12,270 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1074, section=com.timeout.data.Section#4}]
11:18:12,271 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,272 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,274 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1074, section=com.timeout.data.Section#4}]
11:18:12,274 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1074, section=com.timeout.data.Section#4}]
11:18:12,275 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1074]
11:18:12,275 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,276 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,277 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1074]
11:18:12,277 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1074]
11:18:12,279 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1074]
11:18:12,279 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1074]
11:18:12,281 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1074]
11:18:12,282 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3580, section=com.timeout.data.Section#3}]
11:18:12,282 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#37]
11:18:12,283 DEBUG DefaultLoadEventListener:255 - creating new proxy for entity
11:18:12,284 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3580, section=com.timeout.data.Section#3}]
11:18:12,285 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3580, section=com.timeout.data.Section#3}]
11:18:12,286 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3580]
11:18:12,287 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,287 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,288 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3580]
11:18:12,289 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3580]
11:18:12,289 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3580]
11:18:12,290 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3580]
11:18:12,291 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3580]
11:18:12,292 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3533, section=com.timeout.data.Section#3}]
11:18:12,292 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#45]
11:18:12,293 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,293 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3533, section=com.timeout.data.Section#3}]
11:18:12,294 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3533, section=com.timeout.data.Section#3}]
11:18:12,294 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3533]
11:18:12,295 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,295 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,296 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3533]
11:18:12,296 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3533]
11:18:12,297 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3533]
11:18:12,297 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3533]
11:18:12,298 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3533]
11:18:12,298 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3075, section=com.timeout.data.Section#3}]
11:18:12,299 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#12]
11:18:12,300 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,300 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3075, section=com.timeout.data.Section#3}]
11:18:12,301 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3075, section=com.timeout.data.Section#3}]
11:18:12,301 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3075]
11:18:12,301 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,302 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,302 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3075]
11:18:12,303 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3075]
11:18:12,304 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3075]
11:18:12,304 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3075]
11:18:12,305 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3075]
11:18:12,305 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2468, section=com.timeout.data.Section#3}]
11:18:12,305 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#18]
11:18:12,306 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,306 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2468, section=com.timeout.data.Section#3}]
11:18:12,307 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2468, section=com.timeout.data.Section#3}]
11:18:12,308 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2468]
11:18:12,308 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,309 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,309 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2468]
11:18:12,309 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2468]
11:18:12,310 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2468]
11:18:12,311 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2468]
11:18:12,312 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2468]
11:18:12,312 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2552, section=com.timeout.data.Section#3}]
11:18:12,312 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#15]
11:18:12,313 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,313 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2552, section=com.timeout.data.Section#3}]
11:18:12,314 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2552, section=com.timeout.data.Section#3}]
11:18:12,314 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2552]
11:18:12,315 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,315 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,316 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2552]
11:18:12,316 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2552]
11:18:12,317 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2552]
11:18:12,318 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2552]
11:18:12,318 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2552]
11:18:12,318 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#496, section=com.timeout.data.Section#4}]
11:18:12,319 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,320 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,320 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#496, section=com.timeout.data.Section#4}]
11:18:12,321 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#496, section=com.timeout.data.Section#4}]
11:18:12,322 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#496]
11:18:12,326 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,326 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,328 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#496]
11:18:12,331 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#496]
11:18:12,332 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#496]
11:18:12,333 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#496]
11:18:12,333 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#496]
11:18:12,334 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#736, section=com.timeout.data.Section#4}]
11:18:12,336 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#7]
11:18:12,336 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,337 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#736, section=com.timeout.data.Section#4}]
11:18:12,338 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#736, section=com.timeout.data.Section#4}]
11:18:12,339 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#736]
11:18:12,339 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,340 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,341 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#736]
11:18:12,341 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#736]
11:18:12,342 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#736]
11:18:12,343 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#736]
11:18:12,344 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#736]
11:18:12,346 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2988, section=com.timeout.data.Section#3}]
11:18:12,346 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#37]
11:18:12,347 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,347 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2988, section=com.timeout.data.Section#3}]
11:18:12,348 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2988, section=com.timeout.data.Section#3}]
11:18:12,349 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2988]
11:18:12,350 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,351 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,351 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2988]
11:18:12,352 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2988]
11:18:12,352 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2988]
11:18:12,353 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2988]
11:18:12,353 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2988]
11:18:12,354 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2173, section=com.timeout.data.Section#3}]
11:18:12,355 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#12]
11:18:12,355 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,356 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#2173, section=com.timeout.data.Section#3}]
11:18:12,356 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#2173, section=com.timeout.data.Section#3}]
11:18:12,356 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#2173]
11:18:12,357 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,357 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,358 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#2173]
11:18:12,359 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#2173]
11:18:12,359 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#2173]
11:18:12,360 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#2173]
11:18:12,360 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#2173]
11:18:12,360 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1110, section=com.timeout.data.Section#4}]
11:18:12,361 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#8]
11:18:12,361 DEBUG DefaultLoadEventListener:255 - creating new proxy for entity
11:18:12,362 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#1110, section=com.timeout.data.Section#4}]
11:18:12,363 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#1110, section=com.timeout.data.Section#4}]
11:18:12,363 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#1110]
11:18:12,364 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,364 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,364 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#1110]
11:18:12,365 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#1110]
11:18:12,366 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#1110]
11:18:12,366 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#1110]
11:18:12,367 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#1110]
11:18:12,367 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#438, section=com.timeout.data.Section#4}]
11:18:12,368 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#6]
11:18:12,368 DEBUG DefaultLoadEventListener:255 - creating new proxy for entity
11:18:12,369 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#438, section=com.timeout.data.Section#4}]
11:18:12,369 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#438, section=com.timeout.data.Section#4}]
11:18:12,370 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#438]
11:18:12,371 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,371 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,371 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#438]
11:18:12,372 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#438]
11:18:12,372 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#438]
11:18:12,373 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#438]
11:18:12,373 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#438]
11:18:12,374 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#693, section=com.timeout.data.Section#4}]
11:18:12,374 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,375 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,375 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#693, section=com.timeout.data.Section#4}]
11:18:12,376 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#693, section=com.timeout.data.Section#4}]
11:18:12,376 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#693]
11:18:12,377 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,377 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,378 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#693]
11:18:12,378 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#693]
11:18:12,379 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#693]
11:18:12,380 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#693]
11:18:12,381 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#693]
11:18:12,382 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3071, section=com.timeout.data.Section#3}]
11:18:12,385 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#42]
11:18:12,386 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,386 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#3071, section=com.timeout.data.Section#3}]
11:18:12,387 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#3071, section=com.timeout.data.Section#3}]
11:18:12,387 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#3071]
11:18:12,387 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,389 DEBUG DefaultLoadEventListener:244 - entity found in session cache
11:18:12,390 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.occurrences#3071]
11:18:12,390 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.venueGroups#3071]
11:18:12,391 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.attributes#3071]
11:18:12,392 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.Venue.sectionMappings#3071]
11:18:12,392 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.Venue#3071]
11:18:12,393 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#883, section=com.timeout.data.Section#4}]
11:18:12,393 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Cuisine#5]
11:18:12,394 DEBUG DefaultLoadEventListener:214 - entity proxy found in session cache
11:18:12,394 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.timeout.data.RestaurantInfo.cuisines#component[venue,section]{venue=com.timeout.data.Venue#883, section=com.timeout.data.Section#4}]
11:18:12,397 DEBUG TwoPhaseLoad:206 - done materializing entity [com.timeout.data.RestaurantInfo#component[venue,section]{venue=com.timeout.data.Venue#883, section=com.timeout.data.Section#4}]
11:18:12,397 DEBUG TwoPhaseLoad:107 - resolving associations for [com.timeout.data.Venue#883]
11:18:12,398 DEBUG DefaultLoadEventListener:171 - loading entity: [com.timeout.data.Neighborhood#5]
11:18:12,399 DEBUG De