http://129.67.241.168/search/?page=1

Method
GET
HTTP Status
200
IP
3.144.41.200
Profiled on
Token
04343f

Query Metrics

95 Database Queries
52 Different statements
385.77 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
127.87 ms
(33.15%) 		1 
SELECT h0_.id AS id_0, h0_.find_spot_name AS find_spot_name_1, h0_.find_spot_other_names AS find_spot_other_names_2, h0_.address AS address_3, h0_.city AS city_4, h0_.county AS county_5, h0_.region AS region_6, h0_.find_spot_latitude AS find_spot_latitude_7, h0_.find_spot_longitude AS find_spot_longitude_8, h0_.find_spot_altitude AS find_spot_altitude_9, h0_.find_spot_comment AS find_spot_comment_10, h0_.discovery_day1 AS discovery_day1_11, h0_.discovery_month1 AS discovery_month1_12, h0_.discovery_year1 AS discovery_year1_13, h0_.discovery_day2 AS discovery_day2_14, h0_.discovery_month2 AS discovery_month2_15, h0_.discovery_year2 AS discovery_year2_16, h0_.opening_year1 AS opening_year1_17, h0_.opening_year2 AS opening_year2_18, h0_.terminal_year1 AS terminal_year1_19, h0_.terminal_year2 AS terminal_year2_20, h0_.reference_string AS reference_string_21, h0_.discovery_depth AS discovery_depth_22, h0_.owner AS owner_23, h0_.finder AS finder_24, h0_.discovery_comment AS discovery_comment_25, h0_.archaeology_start_year AS archaeology_start_year_26, h0_.archaeology_end_year AS archaeology_end_year_27, h0_.archaeology_natural_features AS archaeology_natural_features_28, h0_.archaeology_site_comment AS archaeology_site_comment_29, h0_.archaeology_context_date1 AS archaeology_context_date1_30, h0_.archaeology_context_date2 AS archaeology_context_date2_31, h0_.archaeology_associated_features AS archaeology_associated_features_32, h0_.rating_comment AS rating_comment_33, h0_.validated_by_user AS validated_by_user_34, h0_.validated_by_admin AS validated_by_admin_35, h0_.coin_data_validated_by_user AS coin_data_validated_by_user_36, h0_.coin_data_validated_by_admin AS coin_data_validated_by_admin_37, h0_.deleted AS deleted_38, h0_.deletedAt AS deletedAt_39, h0_.hide_location AS hide_location_40, h0_.hide_city AS hide_city_41, h0_.hide_county AS hide_county_42, h0_.hide_finder AS hide_finder_43, h0_.credit AS credit_44, h0_.redirect_to_hoard AS redirect_to_hoard_45, h0_.internal_note AS internal_note_46, h0_.creation_date AS creation_date_47, h0_.modified_date AS modified_date_48, h0_.comment AS comment_49, h0_.coin_level_data_id AS coin_level_data_id_50, h0_.hoard_type_id AS hoard_type_id_51, h0_.province_id AS province_id_52, h0_.find_spot_location_detail_id AS find_spot_location_detail_id_53, h0_.ancient_place_id AS ancient_place_id_54, h0_.closing_reign1_id AS closing_reign1_id_55, h0_.closing_reign2_id AS closing_reign2_id_56, h0_.discovery_method_id AS discovery_method_id_57, h0_.discovery_land_use_id AS discovery_land_use_id_58, h0_.archaeology_recovery_method_id AS archaeology_recovery_method_id_59, h0_.archaeology_site_context_id AS archaeology_site_context_id_60, h0_.archaeology_period_id AS archaeology_period_id_61, h0_.archaeology_end_period_id AS archaeology_end_period_id_62, h0_.find_spot_rating_id AS find_spot_rating_id_63, h0_.contextual_rating_id AS contextual_rating_id_64, h0_.rating_id AS rating_id_65, h0_.hide_what_id AS hide_what_id_66, h0_.hide_from_id AS hide_from_id_67, h0_.created_by AS created_by_68, h0_.modified_by AS modified_by_69 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND ((h0_.validated_by_user = 1) AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL)) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))
Parameters: 
[
  2
  3
  4
  5
  6
  7
  8
  9
  10
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  46
  47
  48
  50
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  66
  70
  88
  92
  101
  102
  103
  106
  112
  138
  144
  153
  155
  156
  160
  163
  164
  165
  188
  195
  198
  200
  206
  253
  258
  261
  262
  264
  265
  266
  269
  270
  275
  277
  291
  308
  327
  367
  394
  399
  400
  401
  404
  414
  415
  418
  422
  424
  449
  457
  459
  463
  471
  496
  509
  516
  523
  525
  530
  531
  532
  548
  552
  553
  554
  555
  556
  557
  558
  560
  568
  588
  612
  613
  614
  615
  619
  620
  621
  622
  623
  644
  655
  694
  705
  707
  719
  729
  743
  744
  747
  752
  753
  757
  758
  761
  762
  763
  764
  768
  774
  777
  779
  781
  797
  798
  818
  821
  825
  831
  832
  839
  841
  845
  848
  854
  858
  863
  865
  868
  896
  910
  921
  940
  955
  965
  966
  969
  979
  980
  988
  1003
  1006
  1011
  1036
  1037
  1041
  1042
  1057
  1058
  1071
  1081
  1084
  1089
  1100
  1103
  1107
  1108
  1117
  1118
  1120
  1124
  1126
  1127
  1128
  1131
  1132
  1133
  1134
  1135
  1136
  1172
  1179
  1216
  1231
  1240
  1268
  1271
  1275
  1280
  1282
  1298
  1315
  1325
  1330
  1331
  1332
  1334
  1335
  1338
  1341
  1343
  1346
  1347
  1350
  1351
  1352
  1354
  1355
  1368
  1369
  1371
  1372
  1373
  1379
  1383
  1428
  1429
  1434
  1437
  1451
  1457
  1461
  1463
  1470
  1477
  1481
  1484
  1486
  1492
  1493
  1506
  1513
  1515
  1518
  1521
  1522
  1527
  1528
  1535
  1545
  1555
  1560
  1573
  1585
  1588
  1592
  1598
  1603
  1610
  1618
  1622
  1623
  1630
  1643
  1673
  1682
  1685
  1703
  1711
  1712
  1743
  1749
  1750
  1751
  1757
  1761
  1763
  1765
  1766
  1767
  1774
  1795
  1798
  1799
  1800
  1801
  1810
  1820
  1830
  1831
  1834
  1844
  1852
  1859
  1863
  1878
  1888
  1897
  1899
  1911
  1916
  1921
  1939
  1949
  1954
  1963
  1969
  1971
  1974
  1976
  1982
  1984
  1988
  1994
  1997
  2004
  2006
  2008
  2018
  2020
  2021
  2035
  2039
  2045
  2049
  2062
  2066
  2068
  2073
  2085
  2134
  2135
  2137
  2148
  2163
  2165
  2168
  2184
  2185
  2193
  2195
  2199
  2223
  2235
  2237
  2244
  2245
  2254
  2255
  2259
  2267
  2271
  2284
  2311
  2319
  2327
  2328
  2341
  2349
  2353
  2354
  2366
  2367
  2368
  2369
  2386
  2388
  2441
  2456
  2459
  2464
  2477
  2480
  2487
  2499
  2525
  2548
  2565
  2569
  2585
  2586
  2587
  2588
  2589
  2590
  2591
  2592
  2593
  2594
  2595
  2596
  2597
  2598
  2599
  2600
  2601
  2602
  2603
  2604
  2605
  2606
  2607
  2608
  2609
  2610
  2613
  2614
  2615
  2616
  2617
  2618
  2619
  2620
  2621
  2622
  2623
  2624
  2625
  2626
  2627
  2628
  2629
  2630
  2631
  2632
  2633
  2634
  2635
  2636
  2637
  2638
  2639
  2640
  2642
  2643
  2644
  2645
  2647
  2648
  2649
  2651
  2652
  2653
  2654
  2656
  2657
  2658
  2660
  2661
  2662
  2663
  2664
  2665
  2667
  2668
  2669
  2670
  2671
  2672
  2673
  2674
  2675
  2676
  2677
  2678
  2679
  2680
  2681
  2682
  2683
  2684
  2685
  2686
  2687
  2688
  2689
  2690
  2691
  2692
  2693
  2699
  2700
  2701
  2702
  2704
  2705
  2706
  2707
  2708
  2710
  2713
  2714
  2715
  2717
  2719
  2721
  2722
  2725
  2748
  2751
  2752
  2754
  2755
  2757
  2759
  2760
  2761
  2762
  2769
  2771
  2772
  2774
  2775
  2776
  2777
  2778
  2779
  2780
  2781
  2782
  2783
  2784
  2785
  2789
  2790
  2791
  2792
  2793
  2794
  2795
  2796
  2797
  2798
  2799
  2801
  2806
  2807
  2808
  2815
  2816
  2818
  2819
  2825
  2826
  2827
  2828
  2829
  2830
  2834
  2836
  2837
  2838
  2839
  2840
  2841
  2845
  2846
  2847
  2848
  2849
  2850
  2851
  2853
  2855
  2856
  2859
  2860
  2863
  2868
  2869
  2870
  2871
  2875
  2876
  2877
  2878
  2882
  2883
  2884
  2885
  2886
  2887
  2888
  2889
  2890
  2893
  2894
  2896
  2897
  2898
  2899
  2901
  2903
  2904
  2905
  2906
  2907
  2908
  2909
  2910
  2916
  2919
  2920
  2921
  2924
  2926
  2928
  2932
  2933
  2934
  2935
  2936
  2939
  2940
  2941
  2943
  2944
  2946
  2947
  2948
  2950
  2951
  2953
  2954
  2955
  2958
  2959
  2961
  2963
  2964
  2965
  2966
  2967
  2968
  2971
  2972
  2973
  2975
  2976
  2980
  2982
  2983
  2984
  2988
  2989
  2990
  2991
  2992
  2994
  2995
  2996
  2997
  2998
  3001
  3004
  3005
  3006
  3007
  3008
  3009
  3010
  3011
  3013
  3015
  3016
  3017
  3018
  3019
  3021
  3023
  3028
  3030
  3031
  3033
  3034
  3037
  3039
  3040
  3041
  3042
  3045
  3046
  3047
  3050
  3057
  3058
  3066
  3068
  3069
  3070
  3072
  3073
  3074
  3076
  3078
  3079
  3081
  3082
  3083
  3085
  3088
  3090
  3091
  3093
  3094
  3095
  3096
  3097
  3099
  3100
  3104
  3105
  3106
  3108
  3110
  3112
  3113
  3114
  3116
  3117
  3119
  3120
  3121
  3123
  3124
  3125
  3126
  3127
  3128
  3130
  3132
  3133
  3134
  3135
  3136
  3138
  3139
  3148
  3153
  3154
  3155
  3156
  3157
  3159
  3160
  3166
  3167
  3168
  3170
  3171
  3173
  3174
  3176
  3177
  3179
  3180
  3183
  3188
  3189
  3190
  3191
  3192
  3193
  3198
  3199
  3203
  3205
  3206
  3207
  3209
  3210
  3211
  3212
  3214
  3216
  3218
  3220
  3221
  3222
  3226
  3229
  3230
  3233
  3234
  3235
  3236
  3237
  3240
  3241
  3242
  3244
  3245
  3246
  3247
  3252
  3253
  3254
  3255
  3256
  3261
  3262
  3264
  3265
  3266
  3267
  3269
  3272
  3277
  3280
  3285
  3287
  3288
  3290
  3292
  3293
  3294
  3296
  3297
  3298
  3299
  3304
  3305
  3306
  3307
  3308
  3309
  3310
  3311
  3313
  3314
  3315
  3316
  3317
  3320
  3322
  3323
  3324
  3325
  3326
  3327
  3328
  3330
  3332
  3333
  3334
  3337
  3338
  3339
  3340
  3341
  3342
  3343
  3344
  3345
  3348
  3351
  3353
  3357
  3358
  3362
  3364
  3365
  3366
  3367
  3368
  3370
  3373
  3379
  3380
  3381
  3383
  3384
  3385
  3386
  3387
  3389
  3390
  3391
  3392
  3393
  3395
  3397
  3400
  3401
  3402
  3403
  3404
  3405
  3406
  3407
  3409
  3410
  3412
  3415
  3416
  3418
  3420
  3421
  3422
  3424
  3426
  3431
  3432
  3433
  3436
  3437
  3438
  3439
  3441
  3442
  3443
  3446
  3448
  3452
  3455
  3461
  3465
  3466
  3467
  3468
  3469
  3470
  3471
  3472
  3473
  3474
  3475
  3478
  3479
  3480
  3481
  3485
  3488
  3490
  3491
  3492
  3493
  3494
  3495
  3496
  3497
  3499
  3500
  3501
  3502
  3503
  3504
  3505
  3509
  3517
  3518
  3519
  3522
  3523
  3524
  3525
  3526
  3531
  3536
  3537
  3538
  3539
  3540
  3541
  3546
  3547
  3549
  3551
  3552
  3553
  3554
  3557
  3558
  3560
  3561
  3563
  3564
  3565
  3566
  3570
  3571
  3573
  3574
  3575
  3576
  3577
  3578
  3579
  3582
  3583
  3585
  3586
  3588
  3592
  3593
  3595
  3607
  3608
  3610
  3611
  3612
  3613
  3614
  3616
  3620
  3621
  3622
  3624
  3625
  3627
  3628
  3631
  3632
  3634
  3635
  3636
  3637
  3638
  3639
  3641
  3644
  3646
  3647
  3648
  3650
  3652
  3653
  3654
  3656
  3657
  3660
  3662
  3665
  3666
  3667
  3668
  3669
  3673
  3674
  3677
  3678
  3681
  3682
  3683
  3684
  3685
  3688
  3691
  3693
  3694
  3696
  3700
  3702
  3703
  3704
  3705
  3706
  3709
  3710
  3711
  3713
  3714
  3715
  3716
  3717
  3719
  3720
  3721
  3722
  3723
  3724
  3725
  3726
  3728
  3730
  3731
  3732
  3733
  3734
  3735
  3736
  3737
  3738
  3744
  3745
  3746
  3747
  3748
  3749
  3750
  3751
  3753
  3754
  3756
  3757
  3758
  3759
  3760
  3761
  3762
  3763
  3764
  3765
  3766
  3767
  3769
  3771
  3772
  3773
  3774
  3775
  3776
  3779
  3782
  3785
  3787
  3788
  3791
  3792
  3793
  3794
  3795
  3796
  3798
  3800
  3806
  3807
  3808
  3811
  3813
  3814
  3815
  3816
  3817
  3818
  3822
  3824
  3825
  3828
  3829
  3830
  3832
  3835
  3836
  3838
  3839
  3840
  3841
  3843
  3845
  3847
  3849
  3854
  3855
  3857
  3858
  3859
  3860
  3862
  3863
  3865
  3866
  3868
  3869
  3870
  3872
  3873
  3874
  3877
  3878
  3879
  3881
  3882
  3883
  3884
  3885
  3886
  3887
  3888
  3889
  3890
  3891
  3892
  3894
  3895
  3896
  3897
  3899
  3901
  3902
  3906
  3907
  3908
  3909
  3912
  3913
  3914
  3919
  3921
  3922
  3923
  3924
  3926
  3927
  3928
  3929
  3930
  3931
  3932
  3933
  3935
  3937
  3938
  3939
  3943
  3945
  3946
  3948
  3949
  3950
  3951
  3952
  3954
  3956
  3958
  3961
  3962
  3973
  3976
  3977
  3978
  3981
  3982
  3985
  3987
  3990
  3992
  3998
  4003
  4006
  4008
  4009
  4013
  4014
  4016
  4017
  4028
  4030
  4032
  4034
  4035
  4037
  4039
  4040
  4042
  4046
  4048
  4050
  4064
  4065
  4067
  4073
  4077
  4084
  4085
  4086
  4091
  4094
  4095
  4097
  4100
  4101
  4102
  4103
  4104
  4105
  4109
  4110
  4112
  4113
  4116
  4117
  4118
  4119
  4120
  4122
  4123
  4124
  4126
  4127
  4128
  4131
  4137
  4138
  4139
  4142
  4147
  4150
  4155
  4156
  4159
  4160
  4163
  4165
  4167
  4169
  4170
  4171
  4174
  4175
  4176
  4177
  4184
  4185
  4186
  4187
  4190
  4191
  4192
  4193
  4194
  4195
  4198
  4203
  4204
  4205
  4207
  4209
  4210
  4212
  4213
  4216
  4217
  4219
  4222
  4223
  4225
  4226
  4227
  4230
  4231
  4234
  4238
  4239
  4242
  4243
  4244
  4245
  4246
  4250
  4252
  4256
  4258
  4260
  4261
  4262
  4267
  4269
  4272
  4274
  4276
  4277
  4279
  4280
  4282
  4284
  4288
  4297
  4299
  4300
  4302
  4303
  4307
  4312
  4313
  4314
  4315
  4317
  4318
  4319
  4321
  4322
  4324
  4327
  4328
  4329
  4332
  4333
  4336
  4337
  4339
  4341
  4342
  4343
  4344
  4345
  4346
  4347
  4350
  4351
  4352
  4353
  4354
  4357
  4359
  4361
  4362
  4371
  4372
  4373
  4374
  4376
  4380
  4381
  4382
  4383
  4385
  4387
  4394
  4400
  4405
  4406
  4409
  4411
  4417
  4419
  4421
  4423
  4431
  4447
  4450
  4455
  4457
  4458
  4462
  4464
  4465
  4469
  4470
  4473
  4474
  4476
  4478
  4492
  4493
  4495
  4498
  4511
  4515
  4516
  4517
  4518
  4519
  4520
  4523
  4524
  4526
  4527
  4528
  4529
  4530
  4531
  4534
  4535
  4536
  4537
  4538
  4539
  4540
  4542
  4543
  4544
  4545
  4546
  4547
  4548
  4549
  4550
  4551
  4552
  4553
  4554
  4555
  4556
  4558
  4559
  4560
  4561
  4562
  4563
  4564
  4565
  4566
  4567
  4568
  4569
  4570
  4571
  4573
  4575
  4576
  4577
  4578
  4579
  4580
  4582
  4583
  4584
  4585
  4586
  4589
  4590
  4591
  4593
  4594
  4595
  4596
  4597
  4598
  4600
  4601
  4602
  4604
  4605
  4606
  4607
  4608
  4609
  4610
  4611
  4612
  4613
  4615
  4617
  4618
  4620
  4621
  4622
  4623
  4624
  4625
  4626
  4628
  4630
  4631
  4632
  4633
  4634
  4635
  4636
  4637
  4638
  4639
  4640
  4641
  4643
  4644
  4647
  4648
  4650
  4651
  4654
  4656
  4658
  4659
  4660
  4661
  4662
  4664
  4665
  4666
  4667
  4668
  4671
  4672
  4673
  4676
  4677
  4681
  4682
  4683
  4684
  4685
  4687
  4688
  4690
  4691
  4692
  4693
  4694
  4695
  4707
  4723
  4729
  4734
  4752
  4753
  4754
  4755
  4756
  4757
  4758
  4759
  4760
  4761
  4762
  4763
  4765
  4766
  4767
  4768
  4769
  4770
  4771
  4772
  4773
  4774
  4775
  4776
  4777
  4778
  4779
  4780
  4781
  4782
  4783
  4785
  4786
  4788
  4789
  4790
  4791
  4792
  4793
  4794
  4795
  4796
  4797
  4798
  4799
  4800
  4801
  4802
  4803
  4804
  4806
  4807
  4808
  4809
  4810
  4811
  4812
  4813
  4814
  4815
  4816
  4817
  4818
  4819
  4820
  4821
  4822
  4823
  4824
  4825
  4826
  4827
  4828
  4829
  4830
  4832
  4833
  4834
  4836
  4838
  4843
  4846
  4847
  4848
  4849
  4850
  4852
  4853
  4854
  4855
  4856
  4857
  4858
  4859
  4860
  4861
  4862
  4863
  4864
  4865
  4867
  4868
  4869
  4870
  4871
  4872
  4873
  4874
  4876
  4878
  4879
  4880
  4881
  4882
  4884
  4885
  4886
  4890
  4891
  4892
  4893
  4894
  4895
  4896
  4898
  4899
  4900
  4901
  4902
  4903
  4904
  4905
  4906
  4907
  4908
  4909
  4910
  4911
  4912
  4913
  4914
  4915
  4916
  4918
  4919
  4920
  4921
  4922
  4923
  4924
  4925
  4926
  4927
  4928
  4929
  4930
  4931
  4932
  4933
  4934
  4935
  4936
  4937
  4938
  4939
  4940
  4941
  4942
  4943
  4944
  4945
  4946
  4947
  4948
  4949
  4950
  4951
  4952
  4953
  4954
  4955
  4956
  4957
  4958
  4959
  4960
  4961
  4962
  4963
  4965
  4966
  4967
  4968
  4969
  4970
  4971
  4972
  4973
  4974
  4975
  5223
  5226
  5228
  5230
  5233
  5239
  5240
  5247
  5248
  5251
  5255
  5256
  5257
  5258
  5259
  5260
  5263
  5264
  5265
  5268
  5272
  5275
  5281
  5282
  5288
  5289
  5292
  5293
  5296
  5297
  5298
  5299
  5300
  5301
  5303
  5310
  5313
  5316
  5318
  5324
  5325
  5326
  5327
  5333
  5334
  5336
  5346
  5347
  5348
  5349
  5350
  5351
  5352
  5353
  5354
  5355
  5356
  5357
  5358
  5359
  5360
  5361
  5362
  5363
  5364
  5365
  5366
  5367
  5368
  5369
  5370
  5371
  5372
  5373
  5374
  5375
  5376
  5377
  5378
  5379
  5380
  5381
  5383
  5384
  5386
  5387
  5388
  5389
  5390
  5391
  5392
  5393
  5394
  5395
  5396
  5397
  5398
  5399
  5401
  5402
  5403
  5404
  5405
  5406
  5408
  5409
  5410
  5411
  5412
  5413
  5414
  5415
  5416
  5417
  5418
  5419
  5420
  5421
  5422
  5423
  5426
  5427
  5429
  5430
  5433
  5435
  5438
  5440
  5441
  5442
  5443
  5444
  5446
  5447
  5448
  5454
  5455
  5456
  5458
  5460
  5461
  5464
  5465
  5466
  5467
  5469
  5470
  5471
  5474
  5475
  5476
  5478
  5479
  5482
  5483
  5484
  5485
  5486
  5489
  5490
  5491
  5492
  5494
  5495
  5498
  5501
  5502
  5503
  5504
  5507
  5508
  5510
  5512
  5513
  5514
  5515
  5516
  5517
  5518
  5519
  5520
  5521
  5522
  5523
  5524
  5525
  5526
  5527
  5528
  5529
  5530
  5531
  5532
  5533
  5534
  5535
  5536
  5537
  5538
  5539
  5540
  5541
  5542
  5543
  5544
  5546
  5547
  5548
  5549
  5550
  5551
  5552
  5553
  5554
  5555
  5556
  5557
  5558
  5559
  5560
  5561
  5562
  5563
  5564
  5565
  5566
  5567
  5568
  5569
  5570
  5571
  5572
  5573
  5574
  5575
  5576
  5577
  5578
  5579
  5580
  5581
  5582
  5583
  5584
  5585
  5586
  5587
  5588
  5589
  5590
  5591
  5592
  5593
  5594
  5595
  5596
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5607
  5608
  5609
  5610
  5611
  5612
  5613
  5614
  5615
  5616
  5617
  5618
  5619
  5620
  5621
  5622
  5623
  5624
  5625
  5626
  5627
  5628
  5629
  5630
  5631
  5632
  5633
  5634
  5635
  5636
  5637
  5638
  5639
  5640
  5641
  5643
  5644
  5645
  5646
  5647
  5648
  5649
  5650
  5651
  5652
  5653
  5654
  5655
  5656
  5657
  5658
  5659
  5660
  5661
  5662
  5663
  5664
  5665
  5666
  5667
  5668
  5669
  5670
  5671
  5672
  5673
  5674
  5675
  5676
  5677
  5678
  5679
  5680
  5681
  5682
  5683
  5684
  5685
  5686
  5687
  5688
  5689
  5690
  5691
  5692
  5693
  5694
  5695
  5697
  5698
  5699
  5700
  5701
  5702
  5704
  5705
  5706
  5707
  5708
  5709
  5710
  5711
  5712
  5713
  5714
  5715
  5716
  5717
  5718
  5719
  5720
  5721
  5722
  5723
  5724
  5725
  5726
  5727
  5728
  5729
  5730
  5731
  5732
  5733
  5734
  5735
  5736
  5737
  5738
  5739
  5740
  5741
  5742
  5743
  5744
  5745
  5746
  5747
  5748
  5749
  5750
  5752
  5753
  5754
  5755
  5756
  5757
  5758
  5759
  5760
  5761
  5762
  5763
  5764
  5765
  5766
  5767
  5768
  5769
  5770
  5771
  5772
  5773
  5774
  5775
  5776
  5777
  5778
  5779
  5780
  5781
  5782
  5783
  5784
  5785
  5786
  5787
  5788
  5789
  5790
  5791
  5792
  5793
  5794
  5795
  5796
  5797
  5798
  5799
  5800
  5801
  5802
  5803
  5804
  5805
  5806
  5807
  5808
  5809
  5810
  5811
  5812
  5813
  5814
  5815
  5816
  5817
  5818
  5819
  5820
  5821
  5822
  5823
  5824
  5825
  5826
  5827
  5828
  5829
  5830
  5831
  5832
  5833
  5834
  5835
  5836
  5837
  5838
  5839
  5840
  5841
  5842
  5843
  5844
  5845
  5846
  5847
  5848
  5849
  5850
  5851
  5852
  5853
  5854
  5855
  5856
  5857
  5858
  5859
  5860
  5861
  5862
  5863
  5864
  5865
  5866
  5867
  5868
  5869
  5870
  5871
  5872
  5873
  5874
  5875
  5876
  5877
  5878
  5879
  5880
  5881
  5882
  5883
  5884
  5885
  5886
  5887
  5888
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  5897
  5898
  5899
  5900
  5901
  5902
  5903
  5904
  5905
  5906
  5907
  5908
  5909
  5910
  5911
  5912
  5913
  5914
  5915
  5916
  5917
  5919
  5920
  5921
  5922
  5923
  5924
  5925
  5926
  5927
  5928
  5929
  5930
  5931
  5932
  5933
  5934
  5935
  5936
  5937
  5938
  5939
  5940
  5941
  5942
  5943
  5944
  5945
  5946
  5947
  5948
  5949
  5950
  5951
  5952
  5953
  5954
  5955
  5956
  5957
  5958
  5959
  5960
  5961
  5962
  5963
  5964
  5965
  5966
  5967
  5968
  5969
  5970
  5971
  5972
  5973
  5974
  5975
  5976
  5977
  5978
  5979
  5980
  5981
  5982
  5983
  5984
  5985
  5986
  5988
  5989
  5990
  5991
  5992
  5993
  5994
  5995
  5996
  5997
  5998
  5999
  6000
  6001
  6002
  6003
  6004
  6005
  6006
  6007
  6008
  6009
  6010
  6011
  6012
  6013
  6014
  6015
  6016
  6017
  6018
  6019
  6020
  6021
  6022
  6023
  6024
  6025
  6026
  6027
  6028
  6029
  6030
  6031
  6032
  6033
  6034
  6035
  6036
  6037
  6038
  6039
  6040
  6041
  6042
  6043
  6044
  6045
  6046
  6047
  6048
  6049
  6050
  6051
  6052
  6053
  6054
  6055
  6056
  6057
  6058
  6059
  6060
  6061
  6062
  6063
  6064
  6065
  6066
  6067
  6068
  6069
  6070
  6071
  6072
  6073
  6074
  6075
  6076
  6077
  6078
  6079
  6080
  6081
  6082
  6083
  6084
  6085
  6086
  6087
  6088
  6089
  6090
  6091
  6092
  6093
  6094
  6096
  6097
  6098
  6099
  6100
  6101
  6102
  6103
  6104
  6105
  6106
  6107
  6108
  6109
  6110
  6111
  6112
  6113
  6114
  6115
  6117
  6119
  6123
  6124
  6127
  6129
  6132
  6134
  6135
  6136
  6138
  6140
  6141
  6142
  6143
  6144
  6146
  6149
  6150
  6152
  6153
  6154
  6156
  6157
  6161
  6164
  6166
  6167
  6168
  6169
  6170
  6171
  6172
  6173
  6175
  6177
  6178
  6181
  6182
  6183
  6185
  6186
  6188
  6189
  6190
  6191
  6192
  6193
  6194
  6195
  6196
  6197
  6198
  6199
  6200
  6201
  6202
  6203
  6204
  6205
  6206
  6207
  6208
  6209
  6210
  6211
  6212
  6213
  6214
  6215
  6216
  6217
  6218
  6220
  6222
  6223
  6224
  6228
  6232
  6233
  6234
  6235
  6236
  6237
  6238
  6240
  6241
  6242
  6246
  6247
  6248
  6249
  6252
  6254
  6257
  6259
  6260
  6262
  6263
  6264
  6265
  6266
  6267
  6268
  6269
  6270
  6271
  6272
  6273
  6274
  6275
  6276
  6277
  6278
  6279
  6280
  6281
  6282
  6283
  6284
  6285
  6286
  6287
  6288
  6289
  6290
  6291
  6292
  6293
  6294
  6295
  6296
  6297
  6298
  6299
  6301
  6303
  6306
  6307
  6308
  6309
  6310
  6311
  6312
  6313
  6314
  6315
  6316
  6317
  6318
  6319
  6320
  6321
  6322
  6323
  6324
  6325
  6326
  6327
  6328
  6329
  6330
  6331
  6332
  6333
  6334
  6335
  6336
  6337
  6338
  6339
  6340
  6341
  6342
  6343
  6344
  6345
  6346
  6347
  6348
  6349
  6350
  6351
  6352
  6353
  6354
  6355
  6357
  6358
  6359
  6360
  6361
  6362
  6363
  6364
  6365
  6366
  6367
  6368
  6369
  6370
  6371
  6372
  6373
  6374
  6375
  6376
  6377
  6378
  6379
  6380
  6381
  6382
  6383
  6402
  6403
  6404
  6405
  6407
  6409
  6410
  6411
  6412
  6413
  6414
  6416
  6417
  6418
  6419
  6420
  6422
  6423
  6424
  6428
  6429
  6430
  6432
  6433
  6434
  6436
  6437
  6440
  6442
  6443
  6445
  6446
  6447
  6451
  6453
  6455
  6456
  6457
  6459
  6460
  6462
  6463
  6469
  6475
  6482
  6487
  6496
  6500
  6504
  6511
  6513
  6514
  6515
  6519
  6521
  6525
  6526
  6529
  6530
  6534
  6540
  6543
  6546
  6553
  6557
  6559
  6561
  6562
  6563
  6566
  6567
  6574
  6576
  6578
  6584
  6587
  6593
  6595
  6598
  6603
  6605
  6606
  6607
  6609
  6610
  6611
  6614
  6617
  6618
  6619
  6620
  6624
  6643
  6655
  6656
  6657
  6658
  6667
  6669
  6670
  6671
  6672
  6673
  6674
  6675
  6680
  6683
  6696
  6708
  6710
  6711
  6712
  6713
  6714
  6715
  6716
  6717
  6719
  6720
  6721
  6722
  6723
  6724
  6725
  6726
  6727
  6728
  6729
  6730
  6731
  6732
  6733
  6735
  6736
  6737
  6738
  6739
  6740
  6741
  6743
  6744
  6745
  6746
  6747
  6749
  6750
  6751
  6752
  6753
  6754
  6757
  6759
  6760
  6762
  6763
  6764
  6765
  6766
  6767
  6768
  6769
  6770
  6771
  6772
  6773
  6774
  6775
  6778
  6779
  6780
  6781
  6782
  6794
  6796
  6797
  6798
  6799
  6800
  6801
  6803
  6804
  6805
  6806
  6807
  6808
  6809
  6810
  6811
  6812
  6813
  6814
  6815
  6816
  6817
  6819
  6820
  6821
  6822
  6823
  6824
  6825
  6826
  6827
  6828
  6829
  6830
  6831
  6832
  6833
  6834
  6835
  6836
  6837
  6838
  6839
  6840
  6841
  6842
  6843
  6844
  6845
  6846
  6847
  6849
  6851
  6852
  6853
  6855
  6856
  6857
  6858
  6859
  6860
  6861
  6862
  6864
  6865
  6866
  6867
  6868
  6869
  6870
  6871
  6872
  6873
  6874
  6875
  6876
  6877
  6878
  6879
  6880
  6881
  6882
  6883
  6885
  6886
  6887
  6888
  6889
  6890
  6891
  6892
  6893
  6894
  6895
  6896
  6897
  6898
  6899
  6900
  6901
  6902
  6904
  6905
  6906
  6907
  6908
  6909
  6910
  6911
  6912
  6913
  6914
  6920
  6921
  6922
  6923
  6924
  6925
  6926
  6928
  6929
  6931
  6932
  6935
  6936
  6939
  6940
  6941
  6942
  6944
  6945
  6947
  6948
  6950
  6951
  6952
  6953
  6955
  6956
  6957
  6958
  6959
  6960
  6961
  6963
  6964
  6965
  6966
  6967
  6968
  6969
  6970
  6972
  6973
  6974
  6975
  6976
  6977
  6978
  6979
  6980
  6981
  6982
  6983
  6984
  6985
  6986
  6987
  6988
  6989
  6990
  6991
  6992
  6993
  6994
  6995
  6996
  6997
  6998
  6999
  7000
  7001
  7002
  7003
  7004
  7005
  7006
  7007
  7008
  7009
  7010
  7011
  7012
  7013
  7014
  7015
  7016
  7018
  7019
  7020
  7021
  7022
  7023
  7024
  7025
  7026
  7027
  7028
  7029
  7030
  7031
  7032
  7033
  7034
  7035
  7036
  7037
  7038
  7039
  7040
  7041
  7042
  7043
  7044
  7045
  7046
  7047
  7048
  7049
  7050
  7051
  7052
  7053
  7054
  7055
  7056
  7057
  7058
  7060
  7061
  7062
  7063
  7064
  7065
  7066
  7067
  7068
  7070
  7071
  7072
  7073
  7074
  7075
  7076
  7077
  7078
  7079
  7080
  7082
  7083
  7084
  7085
  7086
  7087
  7088
  7089
  7090
  7091
  7092
  7093
  7094
  7095
  7096
  7097
  7098
  7099
  7100
  7101
  7102
  7104
  7105
  7106
  7107
  7108
  7109
  7110
  7111
  7112
  7113
  7114
  7115
  7116
  7117
  7118
  7119
  7120
  7121
  7122
  7123
  7124
  7125
  7126
  7127
  7128
  7130
  7131
  7132
  7133
  7134
  7135
  7136
  7137
  7138
  7139
  7140
  7141
  7142
  7144
  7145
  7146
  7147
  7148
  7149
  7150
  7151
  7152
  7153
  7154
  7156
  7157
  7158
  7159
  7160
  7161
  7162
  7163
  7164
  7165
  7166
  7167
  7168
  7169
  7170
  7171
  7173
  7174
  7175
  7176
  7177
  7178
  7179
  7180
  7181
  7182
  7183
  7184
  7185
  7186
  7187
  7188
  7189
  7190
  7191
  7192
  7193
  7194
  7195
  7196
  7197
  7198
  7199
  7200
  7201
  7202
  7203
  7204
  7205
  7206
  7207
  7208
  7209
  7210
  7211
  7212
  7213
  7214
  7215
  7216
  7217
  7218
  7219
  7220
  7221
  7222
  7223
  7224
  7225
  7226
  7227
  7228
  7229
  7230
  7231
  7232
  7233
  7234
  7235
  7236
  7237
  7238
  7239
  7240
  7241
  7242
  7243
  7244
  7245
  7246
  7247
  7248
  7249
  7250
  7251
  7252
  7253
  7254
  7255
  7256
  7257
  7258
  7259
  7260
  7261
  7262
  7263
  7265
  7267
  7268
  7269
  7270
  7272
  7273
  7274
  7275
  7276
  7277
  7280
  7281
  7282
  7284
  7288
  7289
  7290
  7291
  7292
  7293
  7294
  7295
  7296
  7297
  7298
  7299
  7300
  7301
  7302
  7303
  7304
  7305
  7306
  7307
  7308
  7309
  7310
  7311
  7312
  7313
  7314
  7315
  7316
  7317
  7318
  7319
  7320
  7321
  7322
  7323
  7324
  7325
  7326
  7327
  7328
  7329
  7330
  7331
  7332
  7333
  7334
  7335
  7336
  7337
  7338
  7339
  7340
  7341
  7342
  7343
  7344
  7345
  7346
  7347
  7348
  7349
  7350
  7351
  7352
  7353
  7354
  7355
  7356
  7357
  7358
  7359
  7360
  7361
  7362
  7363
  7364
  7365
  7366
  7367
  7368
  7369
  7371
  7372
  7373
  7374
  7375
  7376
  7377
  7378
  7379
  7380
  7381
  7382
  7383
  7384
  7385
  7386
  7387
  7388
  7389
  7390
  7391
  7392
  7393
  7394
  7395
  7396
  7397
  7398
  7399
  7400
  7401
  7402
  7403
  7404
  7405
  7406
  7407
  7408
  7409
  7410
  7411
  7412
  7413
  7414
  7415
  7416
  7417
  7418
  7419
  7420
  7421
  7422
  7423
  7424
  7425
  7426
  7427
  7428
  7429
  7430
  7431
  7432
  7433
  7434
  7435
  7436
  7437
  7438
  7439
  7440
  7441
  7442
  7443
  7444
  7445
  7446
  7447
  7448
  7449
  7450
  7451
  7452
  7453
  7454
  7455
  7456
  7457
  7458
  7459
  7460
  7461
  7462
  7463
  7464
  7465
  7466
  7467
  7468
  7469
  7470
  7471
  7472
  7473
  7474
  7475
  7476
  7478
  7479
  7480
  7481
  7482
  7483
  7484
  7485
  7486
  7487
  7488
  7490
  7491
  7493
  7495
  7496
  7497
  7499
  7500
  7501
  7502
  7503
  7504
  7505
  7506
  7507
  7508
  7509
  7510
  7511
  7512
  7514
  7515
  7516
  7517
  7518
  7519
  7520
  7521
  7522
  7523
  7524
  7526
  7527
  7528
  7529
  7530
  7531
  7532
  7533
  7534
  7535
  7536
  7537
  7538
  7539
  7540
  7541
  7542
  7543
  7544
  7545
  7546
  7547
  7548
  7550
  7551
  7552
  7553
  7554
  7555
  7556
  7557
  7558
  7559
  7560
  7561
  7562
  7564
  7565
  7566
  7567
  7568
  7569
  7570
  7571
  7572
  7573
  7574
  7575
  7576
  7577
  7578
  7579
  7580
  7581
  7582
  7583
  7584
  7585
  7586
  7588
  7589
  7590
  7591
  7592
  7594
  7595
  7596
  7598
  7600
  7601
  7603
  7604
  7605
  7606
  7607
  7608
  7609
  7610
  7612
  7615
  7616
  7617
  7618
  7619
  7620
  7621
  7622
  7623
  7624
  7625
  7626
  7627
  7628
  7629
  7630
  7631
  7632
  7633
  7635
  7636
  7638
  7639
  7640
  7641
  7642
  7643
  7644
  7645
  7646
  7647
  7650
  7652
  7653
  7654
  7655
  7657
  7659
  7660
  7664
  7665
  7666
  7667
  7668
  7669
  7670
  7672
  7673
  7677
  7679
  7681
  7683
  7684
  7685
  7686
  7689
  7690
  7691
  7692
  7693
  7694
  7695
  7696
  7697
  7698
  7700
  7701
  7702
  7703
  7704
  7705
  7706
  7707
  7708
  7709
  7710
  7711
  7713
  7714
  7715
  7716
  7717
  7718
  7719
  7720
  7721
  7722
  7723
  7724
  7725
  7726
  7727
  7728
  7729
  7730
  7732
  7733
  7734
  7736
  7738
  7739
  7740
  7741
  7742
  7743
  7744
  7746
  7748
  7749
  7750
  7751
  7752
  7753
  7754
  7755
  7756
  7757
  7758
  7759
  7760
  7762
  7763
  7764
  7765
  7766
  7767
  7768
  7769
  7770
  7771
  7772
  7773
  7774
  7775
  7776
  7778
  7779
  7780
  7781
  7782
  7783
  7784
  7785
  7786
  7787
  7788
  7789
  7790
  7791
  7792
  7793
  7794
  7795
  7796
  7798
  7799
  7800
  7801
  7802
  7803
  7804
  7805
  7806
  7807
  7813
  7814
  7815
  7818
  7822
  7824
  7825
  7828
  7829
  7830
  7831
  7832
  7834
  7835
  7836
  7837
  7839
  7841
  7843
  7844
  7845
  7848
  7850
  7851
  7852
  7853
  7855
  7856
  7857
  7860
  7862
  7863
  7864
  7865
  7867
  7868
  7869
  7870
  7871
  7872
  7873
  7874
  7875
  7877
  7878
  7879
  7880
  7881
  7883
  7884
  7885
  7886
  7888
  7890
  7891
  7892
  7893
  7894
  7895
  7896
  7897
  7899
  7900
  7901
  7903
  7904
  7905
  7906
  7907
  7908
  7909
  7910
  7911
  7912
  7913
  7914
  7915
  7917
  7918
  7919
  7920
  7921
  7922
  7923
  7924
  7925
  7926
  7927
  7928
  7929
  7930
  7931
  7932
  7933
  7934
  7935
  7936
  7937
  7938
  7939
  7940
  7941
  7942
  7943
  7944
  7946
  7947
  7948
  7949
  7950
  7952
  7953
  7954
  7955
  7956
  7957
  7958
  7959
  7960
  7961
  7962
  7963
  7964
  7965
  7966
  7967
  7968
  7969
  7970
  7971
  7972
  7973
  7974
  7975
  7976
  7977
  7978
  7979
  7980
  7981
  7982
  7983
  7985
  7986
  7987
  7988
  7989
  7991
  7993
  7998
  7999
  8000
  8001
  8002
  8004
  8009
  8010
  8012
  8013
  8014
  8016
  8017
  8018
  8023
  8024
  8029
  8030
  8031
  8032
  8033
  8034
  8035
  8036
  8037
  8038
  8039
  8041
  8042
  8043
  8044
  8045
  8046
  8047
  8048
  8049
  8052
  8053
  8054
  8055
  8056
  8057
  8058
  8059
  8062
  8063
  8068
  8069
  8076
  8077
  8078
  8079
  8080
  8081
  8082
  8083
  8084
  8085
  8086
  8088
  8089
  8090
  8091
  8092
  8093
  8095
  8096
  8097
  8099
  8101
  8105
  8110
  8111
  8112
  8113
  8114
  8116
  8117
  8118
  8119
  8120
  8121
  8122
  8123
  8124
  8125
  8126
  8127
  8128
  8129
  8130
  8131
  8132
  8134
  8136
  8137
  8139
  8140
  8141
  8143
  8144
  8148
  8149
  8151
  8152
  8155
  8156
  8157
  8158
  8159
  8161
  8162
  8163
  8165
  8166
  8167
  8168
  8169
  8170
  8172
  8173
  8174
  8175
  8176
  8177
  8178
  8179
  8180
  8182
  8183
  8184
  8185
  8187
  8189
  8190
  8191
  8192
  8193
  8195
  8196
  8197
  8198
  8199
  8201
  8202
  8203
  8204
  8205
  8206
  8207
  8209
  8210
  8211
  8212
  8213
  8214
  8215
  8216
  8217
  8218
  8219
  8220
  8221
  8222
  8223
  8224
  8225
  8226
  8227
  8228
  8229
  8230
  8231
  8232
  8233
  8234
  8235
  8236
  8237
  8238
  8239
  8240
  8241
  8242
  8243
  8244
  8245
  8246
  8247
  8248
  8249
  8250
  8251
  8252
  8253
  8254
  8255
  8256
  8257
  8258
  8259
  8260
  8261
  8262
  8263
  8264
  8265
  8267
  8268
  8269
  8270
  8271
  8272
  8273
  8274
  8275
  8276
  8277
  8278
  8279
  8280
  8281
  8282
  8283
  8284
  8285
  8286
  8287
  8288
  8289
  8290
  8291
  8292
  8293
  8294
  8295
  8296
  8297
  8298
  8299
  8300
  8301
  8302
  8303
  8304
  8305
  8306
  8307
  8308
  8309
  8310
  8312
  8313
  8314
  8315
  8316
  8317
  8318
  8319
  8320
  8321
  8323
  8324
  8325
  8326
  8327
  8328
  8329
  8330
  8331
  8332
  8333
  8334
  8335
  8336
  8337
  8338
  8339
  8341
  8342
  8343
  8344
  8345
  8346
  8347
  8348
  8349
  8350
  8351
  8352
  8353
  8354
  8355
  8356
  8357
  8358
  8359
  8360
  8361
  8362
  8363
  8364
  8365
  8366
  8367
  8368
  8369
  8370
  8371
  8372
  8373
  8374
  8375
  8376
  8377
  8378
  8379
  8380
  8381
  8382
  8383
  8384
  8385
  8387
  8388
  8389
  8390
  8391
  8392
  8393
  8394
  8395
  8396
  8397
  8398
  8399
  8400
  8402
  8403
  8404
  8405
  8406
  8407
  8408
  8409
  8411
  8412
  8413
  8414
  8416
  8417
  8418
  8419
  8420
  8421
  8422
  8423
  8424
  8425
  8426
  8427
  8428
  8429
  8430
  8431
  8432
  8433
  8434
  8435
  8436
  8437
  8439
  8440
  8441
  8442
  8443
  8444
  8445
  8447
  8451
  8452
  8454
  8455
  8457
  8458
  8460
  8463
  8464
  8465
  8466
  8467
  8468
  8469
  8472
  8474
  8475
  8476
  8477
  8478
  8479
  8480
  8481
  8482
  8483
  8484
  8485
  8486
  8487
  8488
  8490
  8491
  8492
  8493
  8494
  8495
  8496
  8497
  8498
  8499
  8500
  8501
  8502
  8503
  8504
  8505
  8506
  8507
  8508
  8509
  8510
  8511
  8512
  8513
  8514
  8515
  8516
  8517
  8518
  8519
  8520
  8521
  8522
  8524
  8525
  8526
  8527
  8528
  8529
  8530
  8531
  8532
  8533
  8534
  8535
  8536
  8537
  8538
  8539
  8540
  8541
  8542
  8543
  8544
  8545
  8546
  8548
  8549
  8550
  8551
  8552
  8553
  8554
  8555
  8556
  8557
  8558
  8559
  8560
  8561
  8562
  8563
  8564
  8567
  8568
  8569
  8570
  8571
  8572
  8573
  8574
  8575
  8576
  8577
  8578
  8579
  8580
  8581
  8582
  8583
  8584
  8585
  8586
  8588
  8590
  8592
  8593
  8594
  8595
  8596
  8597
  8598
  8599
  8600
  8601
  8602
  8603
  8604
  8605
  8606
  8607
  8608
  8609
  8610
  8611
  8612
  8613
  8614
  8616
  8617
  8618
  8619
  8620
  8621
  8622
  8623
  8624
  8625
  8626
  8627
  8628
  8629
  8630
  8631
  8632
  8633
  8634
  8635
  8636
  8637
  8638
  8640
  8641
  8642
  8643
  8644
  8645
  8646
  8647
  8648
  8649
  8650
  8651
  8652
  8653
  8654
  8655
  8656
  8657
  8658
  8661
  8662
  8663
  8664
  8665
  8666
  8667
  8668
  8670
  8671
  8672
  8673
  8674
  8675
  8676
  8677
  8678
  8679
  8680
  8681
  8682
  8683
  8684
  8685
  8686
  8688
  8689
  8690
  8691
  8692
  8693
  8694
  8695
  8696
  8697
  8698
  8699
  8700
  8701
  8702
  8703
  8704
  8705
  8706
  8707
  8708
  8709
  8710
  8711
  8712
  8713
  8714
  8715
  8716
  8717
  8718
  8719
  8720
  8721
  8722
  8723
  8724
  8725
  8726
  8727
  8728
  8729
  8730
  8731
  8732
  8733
  8734
  8735
  8736
  8737
  8738
  8740
  8741
  8742
  8743
  8744
  8745
  8746
  8747
  8748
  8749
  8750
  8751
  8752
  8753
  8754
  8755
  8756
  8757
  8758
  8759
  8760
  8761
  8762
  8763
  8764
  8765
  8766
  8768
  8769
  8770
  8771
  8772
  8773
  8775
  8776
  8777
  8781
  8782
  8783
  8784
  8785
  8786
  8789
  8790
  8792
  8793
  8794
  8795
  8796
  8797
  8798
  8799
  8800
  8801
  8802
  8803
  8804
  8805
  8806
  8807
  8808
  8810
  8811
  8812
  8813
  8814
  8815
  8816
  8817
  8818
  8819
  8821
  8822
  8823
  8824
  8825
  8826
  8827
  8828
  8829
  8830
  8831
  8832
  8834
  8835
  8836
  8837
  8838
  8839
  8840
  8841
  8842
  8843
  8844
  8845
  8846
  8847
  8848
  8849
  8850
  8851
  8852
  8853
  8854
  8855
  8856
  8857
  8858
  8859
  8860
  8861
  8862
  8863
  8864
  8865
  8866
  8868
  8869
  8870
  8871
  8872
  8874
  8875
  8876
  8877
  8878
  8879
  8880
  8881
  8882
  8883
  8884
  8885
  8886
  8887
  8888
  8889
  8890
  8891
  8892
  8893
  8894
  8895
  8896
  8897
  8898
  8899
  8900
  8901
  8902
  8903
  8904
  8905
  8906
  8907
  8908
  8909
  8910
  8911
  8912
  8913
  8914
  8915
  8916
  8917
  8918
  8919
  8920
  8921
  8922
  8923
  8924
  8925
  8926
  8927
  8928
  8929
  8930
  8931
  8932
  8933
  8934
  8935
  8936
  8937
  8938
  8939
  8940
  8941
  8942
  8943
  8945
  8948
  8949
  8951
  8952
  8953
  8954
  8955
  8956
  8957
  8958
  8959
  8960
  8961
  8963
  8965
  8966
  8967
  8968
  8969
  8970
  8971
  8972
  8973
  8974
  8975
  8976
  8977
  8978
  8979
  8980
  8981
  8982
  8983
  8984
  8985
  8986
  8987
  8988
  8989
  8990
  8991
  8992
  8993
  8994
  8995
  8996
  8997
  8998
  8999
  9000
  9001
  9002
  9003
  9004
  9005
  9006
  9007
  9008
  9009
  9010
  9011
  9012
  9013
  9016
  9017
  9018
  9019
  9020
  9021
  9023
  9024
  9025
  9026
  9027
  9028
  9029
  9030
  9031
  9033
  9034
  9035
  9036
  9037
  9038
  9039
  9040
  9041
  9043
  9044
  9045
  9046
  9047
  9048
  9049
  9050
  9051
  9052
  9053
  9054
  9055
  9056
  9057
  9058
  9059
  9060
  9061
  9063
  9064
  9065
  9066
  9067
  9068
  9069
  9070
  9071
]
View formatted query    View runnable query    Explain query
51.65 ms
(13.39%) 		2 
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND ((h0_.validated_by_user = 1) AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL))) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))
Parameters: 
[]
View formatted query    View runnable query    Explain query
48.85 ms
(12.66%) 		1 
SELECT r0_.id AS id_0, r0_.authors AS authors_1, r0_.editors AS editors_2, r0_.title AS title_3, r0_.title_edition AS title_edition_4, r0_.volume AS volume_5, r0_.place AS place_6, r0_.year AS year_7, r0_.pages AS pages_8, r0_.abbreviation AS abbreviation_9, r0_.uri1 AS uri1_10, r0_.uri1_accession_date AS uri1_accession_date_11, r0_.uri2 AS uri2_12, r0_.uri2_accession_date AS uri2_accession_date_13, r0_.fully_entered AS fully_entered_14, r0_.deleted AS deleted_15, r0_.deletedAt AS deletedAt_16, r0_.internal_note AS internal_note_17, r0_.sort_value AS sort_value_18, r0_.has_own_column AS has_own_column_19, r0_.filePath AS filePath_20, r0_.is_file_public AS is_file_public_21, r0_.redirect_to_reference AS redirect_to_reference_22, r0_.creation_date AS creation_date_23, r0_.modified_date AS modified_date_24, r0_.comment AS comment_25, r0_.reference_type_id AS reference_type_id_26, r0_.created_by AS created_by_27, r0_.modified_by AS modified_by_28 FROM reference r0_ WHERE (r0_.deletedAt IS NULL) ORDER BY r0_.sort_value DESC, r0_.abbreviation DESC, r0_.title ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
48.65 ms
(12.61%) 		1 
SELECT t0.id AS id_1, t0.authors AS authors_2, t0.editors AS editors_3, t0.title AS title_4, t0.title_edition AS title_edition_5, t0.volume AS volume_6, t0.place AS place_7, t0.year AS year_8, t0.pages AS pages_9, t0.abbreviation AS abbreviation_10, t0.uri1 AS uri1_11, t0.uri1_accession_date AS uri1_accession_date_12, t0.uri2 AS uri2_13, t0.uri2_accession_date AS uri2_accession_date_14, t0.fully_entered AS fully_entered_15, t0.deleted AS deleted_16, t0.deletedAt AS deletedAt_17, t0.internal_note AS internal_note_18, t0.sort_value AS sort_value_19, t0.has_own_column AS has_own_column_20, t0.filePath AS filePath_21, t0.is_file_public AS is_file_public_22, t0.redirect_to_reference AS redirect_to_reference_23, t0.creation_date AS creation_date_24, t0.modified_date AS modified_date_25, t0.comment AS comment_26, t0.reference_type_id AS reference_type_id_27, t0.created_by AS created_by_28, t0.modified_by AS modified_by_29 FROM reference t0 WHERE ((t0.deletedAt IS NULL)) ORDER BY t0.sort_value DESC, t0.authors ASC, t0.title ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
42.62 ms
(11.05%) 		1 
SELECT r0_.id AS id_0, r0_.authors AS authors_1, r0_.editors AS editors_2, r0_.title AS title_3, r0_.title_edition AS title_edition_4, r0_.volume AS volume_5, r0_.place AS place_6, r0_.year AS year_7, r0_.pages AS pages_8, r0_.abbreviation AS abbreviation_9, r0_.uri1 AS uri1_10, r0_.uri1_accession_date AS uri1_accession_date_11, r0_.uri2 AS uri2_12, r0_.uri2_accession_date AS uri2_accession_date_13, r0_.fully_entered AS fully_entered_14, r0_.deleted AS deleted_15, r0_.deletedAt AS deletedAt_16, r0_.internal_note AS internal_note_17, r0_.sort_value AS sort_value_18, r0_.has_own_column AS has_own_column_19, r0_.filePath AS filePath_20, r0_.is_file_public AS is_file_public_21, r0_.redirect_to_reference AS redirect_to_reference_22, r0_.creation_date AS creation_date_23, r0_.modified_date AS modified_date_24, r0_.comment AS comment_25, r0_.reference_type_id AS reference_type_id_26, r0_.created_by AS created_by_27, r0_.modified_by AS modified_by_28 FROM reference r0_ WHERE (r0_.deletedAt IS NULL) ORDER BY r0_.sort_value DESC, r0_.title ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
12.21 ms
(3.17%) 		20 
SELECT t0.id AS id_1, t0.starting_date AS starting_date_2, t0.ending_date AS ending_date_3, t0.date_text AS date_text_4, t0.issue AS issue_5, t0.officina AS officina_6, t0.obverse_inscription AS obverse_inscription_7, t0.obverse_mint_mark AS obverse_mint_mark_8, t0.obverse_description AS obverse_description_9, t0.reverse_inscription AS reverse_inscription_10, t0.reverse_mint_mark AS reverse_mint_mark_11, t0.reverse_description AS reverse_description_12, t0.weight AS weight_13, t0.quantity AS quantity_14, t0.diameter AS diameter_15, t0.axis AS axis_16, t0.imitation AS imitation_17, t0.latest_coin AS latest_coin_18, t0.intruder AS intruder_19, t0.to_check AS to_check_20, t0.deleted AS deleted_21, t0.deletedAt AS deletedAt_22, t0.creation_date AS creation_date_23, t0.modified_date AS modified_date_24, t0.comment AS comment_25, t0.hoard_id AS hoard_id_26, t0.condition_id AS condition_id_27, t0.container_id AS container_id_28, t0.layer_id AS layer_id_29, t0.period_id AS period_id_30, t0.created_by AS created_by_31, t0.modified_by AS modified_by_32 FROM coin t0 WHERE t0.hoard_id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
7.00 ms
(1.81%) 		1 
SELECT a0_.id AS id_0, a0_.ancientPlace AS ancientPlace_1, a0_.latitude AS latitude_2, a0_.longitude AS longitude_3, a0_.uri1 AS uri1_4, a0_.uri2 AS uri2_5, a0_.uri3 AS uri3_6, a0_.placeComment AS placeComment_7, a0_.deleted AS deleted_8, a0_.sort_value AS sort_value_9, a0_.creation_date AS creation_date_10, a0_.modified_date AS modified_date_11, a0_.comment AS comment_12, a0_.created_by AS created_by_13, a0_.modified_by AS modified_by_14 FROM ancient_place a0_ ORDER BY a0_.ancientPlace ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.19 ms
(1.61%) 		20 
SELECT t0.id AS id_1, t0.country AS country_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.deleted AS deleted_5, t0.sort_value AS sort_value_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9, t0.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM country t0 INNER JOIN hoard_country ON t0.id = hoard_country.country_id WHERE hoard_country.hoard_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
6.09 ms
(1.58%) 		2 
SELECT t0.id AS id_1, t0.discovery_method AS discovery_method_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM discovery_method t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
5.72 ms
(1.48%) 		1 
SELECT DISTINCT h0_.id AS id_0 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND ((h0_.validated_by_user = 1) AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL))) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP)) LIMIT 5001
Parameters: 
[]
View formatted query    View runnable query    Explain query
5.14 ms
(1.33%) 		1 
SELECT t0.id AS id_1, t0.ancientPlace AS ancientPlace_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.uri1 AS uri1_5, t0.uri2 AS uri2_6, t0.uri3 AS uri3_7, t0.placeComment AS placeComment_8, t0.deleted AS deleted_9, t0.sort_value AS sort_value_10, t0.creation_date AS creation_date_11, t0.modified_date AS modified_date_12, t0.comment AS comment_13, t0.created_by AS created_by_14, t0.modified_by AS modified_by_15 FROM ancient_place t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.93 ms
(1.02%) 		1 
SELECT t0.id AS id_1, t0.person AS person_2, t0.title AS title_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.uri1 AS uri1_6, t0.uri2 AS uri2_7, t0.deleted AS deleted_8, t0.sort_value AS sort_value_9, t0.creation_date AS creation_date_10, t0.modified_date AS modified_date_11, t0.comment AS comment_12, t0.period1_id AS period1_id_13, t0.period2_id AS period2_id_14, t0.period3_id AS period3_id_15, t0.created_by AS created_by_16, t0.modified_by AS modified_by_17 FROM person t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.56 ms
(0.92%) 		1 
SELECT p0_.id AS id_0, p0_.person AS person_1, p0_.title AS title_2, p0_.start_date AS start_date_3, p0_.end_date AS end_date_4, p0_.uri1 AS uri1_5, p0_.uri2 AS uri2_6, p0_.deleted AS deleted_7, p0_.sort_value AS sort_value_8, p0_.creation_date AS creation_date_9, p0_.modified_date AS modified_date_10, p0_.comment AS comment_11, p0_.period1_id AS period1_id_12, p0_.period2_id AS period2_id_13, p0_.period3_id AS period3_id_14, p0_.created_by AS created_by_15, p0_.modified_by AS modified_by_16 FROM person p0_ ORDER BY p0_.person ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.72 ms
(0.45%) 		1 
SELECT m0_.id AS id_0, m0_.mint AS mint_1, m0_.latitude AS latitude_2, m0_.longitude AS longitude_3, m0_.uri1 AS uri1_4, m0_.uri2 AS uri2_5, m0_.deleted AS deleted_6, m0_.sort_value AS sort_value_7, m0_.creation_date AS creation_date_8, m0_.modified_date AS modified_date_9, m0_.comment AS comment_10, m0_.period1_id AS period1_id_11, m0_.period2_id AS period2_id_12, m0_.period3_id AS period3_id_13, m0_.period4_id AS period4_id_14, m0_.created_by AS created_by_15, m0_.modified_by AS modified_by_16 FROM mint m0_ ORDER BY m0_.mint ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.54 ms
(0.40%) 		2 
SELECT t0.id AS id_1, t0.reign AS reign_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.uri1 AS uri1_5, t0.uri2 AS uri2_6, t0.deleted AS deleted_7, t0.sort_value AS sort_value_8, t0.creation_date AS creation_date_9, t0.modified_date AS modified_date_10, t0.comment AS comment_11, t0.period1_id AS period1_id_12, t0.period2_id AS period2_id_13, t0.created_by AS created_by_14, t0.modified_by AS modified_by_15 FROM reign t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.27 ms
(0.33%) 		1 
SELECT t0.id AS id_1, t0.mint AS mint_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.uri1 AS uri1_5, t0.uri2 AS uri2_6, t0.deleted AS deleted_7, t0.sort_value AS sort_value_8, t0.creation_date AS creation_date_9, t0.modified_date AS modified_date_10, t0.comment AS comment_11, t0.period1_id AS period1_id_12, t0.period2_id AS period2_id_13, t0.period3_id AS period3_id_14, t0.period4_id AS period4_id_15, t0.created_by AS created_by_16, t0.modified_by AS modified_by_17 FROM mint t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.85 ms
(0.22%) 		1 
SELECT r0_.id AS id_0, r0_.reign AS reign_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.uri1 AS uri1_4, r0_.uri2 AS uri2_5, r0_.deleted AS deleted_6, r0_.sort_value AS sort_value_7, r0_.creation_date AS creation_date_8, r0_.modified_date AS modified_date_9, r0_.comment AS comment_10, r0_.period1_id AS period1_id_11, r0_.period2_id AS period2_id_12, r0_.created_by AS created_by_13, r0_.modified_by AS modified_by_14 FROM reign r0_ ORDER BY r0_.start_date ASC, r0_.end_date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.74 ms
(0.19%) 		1 
SELECT h0_.id AS id_0, h0_.find_spot_name AS find_spot_name_1, h0_.find_spot_other_names AS find_spot_other_names_2, h0_.address AS address_3, h0_.city AS city_4, h0_.county AS county_5, h0_.region AS region_6, h0_.find_spot_latitude AS find_spot_latitude_7, h0_.find_spot_longitude AS find_spot_longitude_8, h0_.find_spot_altitude AS find_spot_altitude_9, h0_.find_spot_comment AS find_spot_comment_10, h0_.discovery_day1 AS discovery_day1_11, h0_.discovery_month1 AS discovery_month1_12, h0_.discovery_year1 AS discovery_year1_13, h0_.discovery_day2 AS discovery_day2_14, h0_.discovery_month2 AS discovery_month2_15, h0_.discovery_year2 AS discovery_year2_16, h0_.opening_year1 AS opening_year1_17, h0_.opening_year2 AS opening_year2_18, h0_.terminal_year1 AS terminal_year1_19, h0_.terminal_year2 AS terminal_year2_20, h0_.reference_string AS reference_string_21, h0_.discovery_depth AS discovery_depth_22, h0_.owner AS owner_23, h0_.finder AS finder_24, h0_.discovery_comment AS discovery_comment_25, h0_.archaeology_start_year AS archaeology_start_year_26, h0_.archaeology_end_year AS archaeology_end_year_27, h0_.archaeology_natural_features AS archaeology_natural_features_28, h0_.archaeology_site_comment AS archaeology_site_comment_29, h0_.archaeology_context_date1 AS archaeology_context_date1_30, h0_.archaeology_context_date2 AS archaeology_context_date2_31, h0_.archaeology_associated_features AS archaeology_associated_features_32, h0_.rating_comment AS rating_comment_33, h0_.validated_by_user AS validated_by_user_34, h0_.validated_by_admin AS validated_by_admin_35, h0_.coin_data_validated_by_user AS coin_data_validated_by_user_36, h0_.coin_data_validated_by_admin AS coin_data_validated_by_admin_37, h0_.deleted AS deleted_38, h0_.deletedAt AS deletedAt_39, h0_.hide_location AS hide_location_40, h0_.hide_city AS hide_city_41, h0_.hide_county AS hide_county_42, h0_.hide_finder AS hide_finder_43, h0_.credit AS credit_44, h0_.redirect_to_hoard AS redirect_to_hoard_45, h0_.internal_note AS internal_note_46, h0_.creation_date AS creation_date_47, h0_.modified_date AS modified_date_48, h0_.comment AS comment_49, h0_.coin_level_data_id AS coin_level_data_id_50, h0_.hoard_type_id AS hoard_type_id_51, h0_.province_id AS province_id_52, h0_.find_spot_location_detail_id AS find_spot_location_detail_id_53, h0_.ancient_place_id AS ancient_place_id_54, h0_.closing_reign1_id AS closing_reign1_id_55, h0_.closing_reign2_id AS closing_reign2_id_56, h0_.discovery_method_id AS discovery_method_id_57, h0_.discovery_land_use_id AS discovery_land_use_id_58, h0_.archaeology_recovery_method_id AS archaeology_recovery_method_id_59, h0_.archaeology_site_context_id AS archaeology_site_context_id_60, h0_.archaeology_period_id AS archaeology_period_id_61, h0_.archaeology_end_period_id AS archaeology_end_period_id_62, h0_.find_spot_rating_id AS find_spot_rating_id_63, h0_.contextual_rating_id AS contextual_rating_id_64, h0_.rating_id AS rating_id_65, h0_.hide_what_id AS hide_what_id_66, h0_.hide_from_id AS hide_from_id_67, h0_.created_by AS created_by_68, h0_.modified_by AS modified_by_69 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND ((h0_.validated_by_user = 1) AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL)) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))
Parameters: 
[
  2
  3
  4
  5
  6
  7
  8
  9
  10
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
]
View formatted query    View runnable query    Explain query
0.72 ms
(0.19%) 		2 
SELECT t0.id AS id_1, t0.archaeology_recovery_method AS archaeology_recovery_method_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_recovery_method t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.71 ms
(0.18%) 		2 
SELECT t0.id AS id_1, t0.discovery_land_use AS discovery_land_use_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM discovery_land_use t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.58 ms
(0.15%) 		1 
SELECT t0.id AS id_1, t0.container_form AS container_form_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM container_form t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 ms
(0.13%) 		1 
SELECT d0_.id AS id_0, d0_.denomination AS denomination_1, d0_.uri1 AS uri1_2, d0_.uri2 AS uri2_3, d0_.deleted AS deleted_4, d0_.sort_value AS sort_value_5, d0_.creation_date AS creation_date_6, d0_.modified_date AS modified_date_7, d0_.comment AS comment_8, d0_.material_id AS material_id_9, d0_.created_by AS created_by_10, d0_.modified_by AS modified_by_11 FROM denomination d0_ ORDER BY d0_.denomination ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.47 ms
(0.12%) 		1 
SELECT t0.id AS id_1, t0.archaeology_site_context_detail AS archaeology_site_context_detail_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_site_context_detail t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.43 ms
(0.11%) 		1 
SELECT m0_.id AS id_0, m0_.material AS material_1, m0_.uri1 AS uri1_2, m0_.uri2 AS uri2_3, m0_.deleted AS deleted_4, m0_.sort_value AS sort_value_5, m0_.creation_date AS creation_date_6, m0_.modified_date AS modified_date_7, m0_.comment AS comment_8, m0_.created_by AS created_by_9, m0_.modified_by AS modified_by_10 FROM material m0_ ORDER BY m0_.sort_value DESC, m0_.material ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.34 ms
(0.09%) 		1 
SELECT DISTINCT h0_.id AS id_0 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND ((h0_.validated_by_user = 1) AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL))) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP)) LIMIT 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.34 ms
(0.09%) 		1 
SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.deleted AS deleted_5, t0.sort_value AS sort_value_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9, t0.material_id AS material_id_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM denomination t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 ms
(0.09%) 		1 
SELECT t0.id AS id_1, t0.archaeology_site_context AS archaeology_site_context_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_site_context t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.31 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.find_spot_location_detail AS find_spot_location_detail_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM find_spot_location_detail t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.30 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.country AS country_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.deleted AS deleted_5, t0.sort_value AS sort_value_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9, t0.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM country t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.30 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.archaeology_context_nature AS archaeology_context_nature_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_context_nature t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.08%) 		1 
SELECT a0_.id AS id_0, a0_.aspect AS aspect_1, a0_.uri1 AS uri1_2, a0_.uri2 AS uri2_3, a0_.sort_value AS sort_value_4, a0_.deleted AS deleted_5, a0_.creation_date AS creation_date_6, a0_.modified_date AS modified_date_7, a0_.comment AS comment_8 FROM aspect a0_ ORDER BY a0_.sort_value DESC, a0_.aspect ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.08%) 		1 
SELECT c0_.id AS id_0, c0_.country AS country_1, c0_.uri1 AS uri1_2, c0_.uri2 AS uri2_3, c0_.deleted AS deleted_4, c0_.sort_value AS sort_value_5, c0_.creation_date AS creation_date_6, c0_.modified_date AS modified_date_7, c0_.comment AS comment_8, c0_.created_by AS created_by_9, c0_.modified_by AS modified_by_10 FROM country c0_ ORDER BY c0_.country ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.07%) 		1 
SELECT t0.id AS id_1, t0.archaeology_period AS archaeology_period_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_period t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.07%) 		1 
SELECT t0.id AS id_1, t0.hoard_type AS hoard_type_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.deleted AS deleted_5, t0.sort_value AS sort_value_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9, t0.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM hoard_type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.26 ms
(0.07%) 		1 
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM rating t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.26 ms
(0.07%) 		1 
SELECT a0_.id AS id_0, a0_.archaeology_context_nature AS archaeology_context_nature_1, a0_.deleted AS deleted_2, a0_.sort_value AS sort_value_3, a0_.creation_date AS creation_date_4, a0_.modified_date AS modified_date_5, a0_.comment AS comment_6, a0_.created_by AS created_by_7, a0_.modified_by AS modified_by_8 FROM archaeology_context_nature a0_ ORDER BY a0_.archaeology_context_nature ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.25 ms
(0.06%) 		1 
SELECT c0_.id AS id_0, c0_.container_form AS container_form_1, c0_.deleted AS deleted_2, c0_.sort_value AS sort_value_3, c0_.creation_date AS creation_date_4, c0_.modified_date AS modified_date_5, c0_.comment AS comment_6, c0_.created_by AS created_by_7, c0_.modified_by AS modified_by_8 FROM container_form c0_ ORDER BY c0_.sort_value DESC, c0_.container_form ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.25 ms
(0.06%) 		1 
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.deleted AS deleted_2, r0_.sort_value AS sort_value_3, r0_.creation_date AS creation_date_4, r0_.modified_date AS modified_date_5, r0_.comment AS comment_6, r0_.created_by AS created_by_7, r0_.modified_by AS modified_by_8 FROM rating r0_ ORDER BY r0_.sort_value DESC, r0_.rating ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.24 ms
(0.06%) 		1 
SELECT a0_.id AS id_0, a0_.archaeology_site_context_detail AS archaeology_site_context_detail_1, a0_.deleted AS deleted_2, a0_.sort_value AS sort_value_3, a0_.creation_date AS creation_date_4, a0_.modified_date AS modified_date_5, a0_.comment AS comment_6, a0_.created_by AS created_by_7, a0_.modified_by AS modified_by_8 FROM archaeology_site_context_detail a0_ ORDER BY a0_.archaeology_site_context_detail ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.24 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.coin_level_data AS coin_level_data_2, t0.deleted AS deleted_3, t0.creation_date AS creation_date_4, t0.modified_date AS modified_date_5, t0.comment AS comment_6, t0.created_by AS created_by_7, t0.modified_by AS modified_by_8 FROM coin_level_data t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.22 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.hide_from AS hide_from_2, t0.deleted AS deleted_3, t0.creation_date AS creation_date_4, t0.modified_date AS modified_date_5, t0.comment AS comment_6, t0.created_by AS created_by_7, t0.modified_by AS modified_by_8 FROM hide_from t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.22 ms
(0.06%) 		1 
SELECT p0_.id AS id_0, p0_.period AS period_1, p0_.person_control_name AS person_control_name_2, p0_.uri1 AS uri1_3, p0_.uri2 AS uri2_4, p0_.deleted AS deleted_5, p0_.sort_value AS sort_value_6, p0_.creation_date AS creation_date_7, p0_.modified_date AS modified_date_8, p0_.comment AS comment_9, p0_.created_by AS created_by_10, p0_.modified_by AS modified_by_11 FROM period p0_ ORDER BY p0_.sort_value DESC, p0_.period ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.22 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.hide_what AS hide_what_2, t0.deleted AS deleted_3, t0.creation_date AS creation_date_4, t0.modified_date AS modified_date_5, t0.comment AS comment_6, t0.created_by AS created_by_7, t0.modified_by AS modified_by_8 FROM hide_what t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.21 ms
(0.05%) 		1 
SELECT t0.id AS id_1, t0.period AS period_2, t0.person_control_name AS person_control_name_3, t0.uri1 AS uri1_4, t0.uri2 AS uri2_5, t0.deleted AS deleted_6, t0.sort_value AS sort_value_7, t0.creation_date AS creation_date_8, t0.modified_date AS modified_date_9, t0.comment AS comment_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM period t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.20 ms
(0.05%) 		1 
SELECT a0_.id AS id_0, a0_.archaeology_site_context AS archaeology_site_context_1, a0_.deleted AS deleted_2, a0_.sort_value AS sort_value_3, a0_.creation_date AS creation_date_4, a0_.modified_date AS modified_date_5, a0_.comment AS comment_6, a0_.created_by AS created_by_7, a0_.modified_by AS modified_by_8 FROM archaeology_site_context a0_ ORDER BY a0_.sort_value DESC, a0_.archaeology_site_context ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.20 ms
(0.05%) 		1 
SELECT p0_.id AS id_0, p0_.province AS province_1, p0_.deleted AS deleted_2, p0_.creation_date AS creation_date_3, p0_.modified_date AS modified_date_4, p0_.comment AS comment_5, p0_.created_by AS created_by_6, p0_.modified_by AS modified_by_7 FROM province p0_ ORDER BY p0_.province ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.19 ms
(0.05%) 		1 
SELECT t0.id AS id_1, t0.aspect AS aspect_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.sort_value AS sort_value_5, t0.deleted AS deleted_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9 FROM aspect t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.18 ms
(0.05%) 		1 
SELECT t0.id AS id_1, t0.province AS province_2, t0.deleted AS deleted_3, t0.creation_date AS creation_date_4, t0.modified_date AS modified_date_5, t0.comment AS comment_6, t0.created_by AS created_by_7, t0.modified_by AS modified_by_8 FROM province t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.04%) 		1 
SELECT c0_.id AS id_0, c0_.coin_condition AS coin_condition_1, c0_.grade AS grade_2, c0_.uri1 AS uri1_3, c0_.uri2 AS uri2_4, c0_.deleted AS deleted_5, c0_.sort_value AS sort_value_6, c0_.creation_date AS creation_date_7, c0_.modified_date AS modified_date_8, c0_.comment AS comment_9, c0_.created_by AS created_by_10, c0_.modified_by AS modified_by_11 FROM coin_condition c0_ ORDER BY c0_.sort_value DESC, c0_.coin_condition ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.04%) 		1 
SELECT t0.id AS id_1, t0.coin_condition AS coin_condition_2, t0.grade AS grade_3, t0.uri1 AS uri1_4, t0.uri2 AS uri2_5, t0.deleted AS deleted_6, t0.sort_value AS sort_value_7, t0.creation_date AS creation_date_8, t0.modified_date AS modified_date_9, t0.comment AS comment_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM coin_condition t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.13 ms
(0.03%) 		1 
SELECT h0_.id AS id_0, h0_.hoard_type AS hoard_type_1, h0_.uri1 AS uri1_2, h0_.uri2 AS uri2_3, h0_.deleted AS deleted_4, h0_.sort_value AS sort_value_5, h0_.creation_date AS creation_date_6, h0_.modified_date AS modified_date_7, h0_.comment AS comment_8, h0_.created_by AS created_by_9, h0_.modified_by AS modified_by_10 FROM hoard_type h0_ ORDER BY h0_.sort_value DESC, h0_.hoard_type ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.11 ms
(0.03%) 		1 
SELECT c0_.id AS id_0, c0_.coin_level_data AS coin_level_data_1, c0_.deleted AS deleted_2, c0_.creation_date AS creation_date_3, c0_.modified_date AS modified_date_4, c0_.comment AS comment_5, c0_.created_by AS created_by_6, c0_.modified_by AS modified_by_7 FROM coin_level_data c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Ox\HoardBundle\Entity\EntityBase No errors.
App\Ox\HoardBundle\Entity\Hoard
  • The field App\Ox\HoardBundle\Entity\Hoard#coinCount is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\HoardCoinCount#hoard does not contain the required 'inversedBy="coinCount"' attribute.
  • The field App\Ox\HoardBundle\Entity\Hoard#nameSimple is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\HoardNameSimple#hoard does not contain the required 'inversedBy="nameSimple"' attribute.
App\Ox\HoardBundle\Entity\CoinLevelData No errors.
App\Ox\HoardBundle\Entity\HoardType No errors.
App\Ox\HoardBundle\Entity\Province No errors.
App\Ox\HoardBundle\Entity\FindSpotLocationDetail No errors.
App\Ox\HoardBundle\Entity\AncientPlace No errors.
App\Ox\HoardBundle\Entity\Reign
  • The field App\Ox\HoardBundle\Entity\Reign#ocreLookups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\OcreLookup#reign does not contain the required 'inversedBy="ocreLookups"' attribute.
App\Ox\HoardBundle\Entity\DiscoveryMethod No errors.
App\Ox\HoardBundle\Entity\DiscoveryLandUse No errors.
App\Ox\HoardBundle\Entity\ArchaeologyRecoveryMethod No errors.
App\Ox\HoardBundle\Entity\ArchaeologySiteContext No errors.
App\Ox\HoardBundle\Entity\ArchaeologyPeriod No errors.
App\Ox\HoardBundle\Entity\Rating No errors.
App\Ox\HoardBundle\Entity\HideWhat No errors.
App\Ox\HoardBundle\Entity\HideFrom No errors.
Nucleos\UserBundle\Model\User No errors.
App\Ox\HoardBundle\Entity\User No errors.
App\Ox\HoardBundle\Entity\UserHoard No errors.
App\Ox\HoardBundle\Entity\Coin
  • The mappings App\Ox\HoardBundle\Entity\Coin#condition and App\Ox\HoardBundle\Entity\Condition#coins are inconsistent with each other.
App\Ox\HoardBundle\Entity\HoardCoinCount No errors.
App\Ox\HoardBundle\Entity\HoardNameSimple No errors.
App\Ox\HoardBundle\Entity\Container No errors.
App\Ox\HoardBundle\Entity\HoardImage No errors.
App\Ox\HoardBundle\Entity\HoardReference No errors.
App\Ox\HoardBundle\Entity\HObject No errors.
App\Ox\HoardBundle\Entity\Country
  • The field App\Ox\HoardBundle\Entity\Country#hoards is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\Hoard#countries does not contain the required 'inversedBy="hoards"' attribute.
App\Ox\HoardBundle\Entity\ArchaeologySiteContextDetail
  • The association App\Ox\HoardBundle\Entity\ArchaeologySiteContextDetail#hoards refers to the owning side field App\Ox\HoardBundle\Entity\Hoard#archaeologySiteContextDetail which does not exist.
App\Ox\HoardBundle\Entity\ArchaeologyContextNature
  • The association App\Ox\HoardBundle\Entity\ArchaeologyContextNature#hoards refers to the owning side field App\Ox\HoardBundle\Entity\Hoard#archaeologyContextNature which does not exist.
App\Ox\HoardBundle\Entity\Reference No errors.
App\Ox\HoardBundle\Entity\ReferenceType No errors.
App\Ox\HoardBundle\Entity\Period
  • The association App\Ox\HoardBundle\Entity\Period#mints refers to the owning side field App\Ox\HoardBundle\Entity\Mint#period which does not exist.
App\Ox\HoardBundle\Entity\Person No errors.
App\Ox\HoardBundle\Entity\Denomination No errors.
App\Ox\HoardBundle\Entity\Material No errors.
App\Ox\HoardBundle\Entity\Mint
  • The mappings App\Ox\HoardBundle\Entity\Mint#period1 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period2 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period3 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period4 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
App\Ox\HoardBundle\Entity\Aspect No errors.
App\Ox\HoardBundle\Entity\Condition
  • The association App\Ox\HoardBundle\Entity\Condition#coins refers to the owning side field App\Ox\HoardBundle\Entity\Coin#coin_condition which does not exist.
App\Ox\HoardBundle\Entity\ContainerForm No errors.
App\Ox\HoardBundle\Entity\OcreLookup No errors.
App\Ox\HoardBundle\Entity\CoinReference No errors.
App\Ox\HoardBundle\Entity\ObjectReference No errors.
App\Ox\HoardBundle\Entity\Layer No errors.
App\Ox\HoardBundle\Entity\CoinAdditionalField No errors.
App\Ox\HoardBundle\Entity\CoinImage No errors.