http://129.67.241.168/search/?direction=asc&page=2

Method
GET
HTTP Status
200
IP
3.21.46.68
Profiled on
Token
7f3a88

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
153.12 ms
(31.53%) 		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: 
[
  9072
  9073
  9074
  9080
  9081
  9082
  9083
  9084
  9085
  9086
  9087
  9093
  9094
  9098
  9101
  9106
  9107
  9108
  9109
  9114
  9115
  9117
  9119
  9120
  9122
  9123
  9124
  9125
  9126
  9127
  9128
  9130
  9131
  9132
  9133
  9134
  9135
  9136
  9139
  9140
  9141
  9142
  9143
  9144
  9145
  9146
  9147
  9148
  9149
  9150
  9151
  9152
  9153
  9154
  9155
  9156
  9157
  9159
  9160
  9161
  9162
  9163
  9164
  9166
  9167
  9168
  9169
  9170
  9171
  9172
  9173
  9174
  9176
  9177
  9178
  9179
  9180
  9181
  9182
  9183
  9184
  9185
  9186
  9187
  9188
  9189
  9190
  9191
  9192
  9193
  9194
  9195
  9196
  9197
  9198
  9199
  9200
  9201
  9202
  9204
  9205
  9206
  9207
  9209
  9210
  9211
  9212
  9213
  9215
  9216
  9217
  9218
  9219
  9222
  9223
  9224
  9225
  9228
  9229
  9230
  9231
  9232
  9233
  9234
  9235
  9236
  9237
  9238
  9239
  9240
  9241
  9242
  9243
  9244
  9245
  9246
  9247
  9248
  9249
  9250
  9251
  9252
  9253
  9254
  9255
  9256
  9257
  9263
  9264
  9266
  9267
  9268
  9269
  9270
  9271
  9272
  9273
  9274
  9275
  9276
  9277
  9278
  9279
  9280
  9281
  9282
  9283
  9284
  9285
  9286
  9287
  9288
  9289
  9290
  9291
  9292
  9293
  9294
  9295
  9296
  9297
  9298
  9299
  9300
  9301
  9302
  9303
  9304
  9305
  9306
  9307
  9308
  9309
  9310
  9311
  9312
  9313
  9314
  9315
  9316
  9317
  9318
  9319
  9320
  9321
  9322
  9323
  9324
  9325
  9326
  9327
  9328
  9329
  9330
  9331
  9332
  9333
  9334
  9335
  9336
  9337
  9338
  9339
  9340
  9347
  9348
  9349
  9351
  9355
  9356
  9358
  9359
  9360
  9361
  9362
  9363
  9364
  9365
  9366
  9367
  9368
  9369
  9370
  9371
  9372
  9373
  9374
  9375
  9377
  9378
  9379
  9380
  9381
  9383
  9384
  9385
  9386
  9387
  9388
  9389
  9390
  9391
  9392
  9393
  9394
  9395
  9396
  9397
  9398
  9399
  9401
  9402
  9403
  9404
  9405
  9406
  9409
  9410
  9411
  9412
  9413
  9414
  9416
  9417
  9418
  9419
  9420
  9421
  9422
  9423
  9424
  9425
  9426
  9427
  9428
  9429
  9430
  9431
  9432
  9433
  9434
  9435
  9436
  9437
  9438
  9439
  9440
  9441
  9442
  9443
  9444
  9445
  9446
  9447
  9448
  9449
  9450
  9451
  9452
  9453
  9454
  9455
  9456
  9457
  9458
  9459
  9460
  9461
  9462
  9463
  9464
  9465
  9466
  9467
  9468
  9469
  9470
  9471
  9472
  9473
  9475
  9476
  9477
  9478
  9479
  9480
  9481
  9482
  9483
  9484
  9485
  9486
  9488
  9492
  9493
  9494
  9495
  9496
  9497
  9498
  9499
  9500
  9501
  9502
  9504
  9505
  9506
  9507
  9509
  9510
  9511
  9512
  9513
  9514
  9515
  9516
  9517
  9518
  9519
  9520
  9521
  9522
  9523
  9524
  9525
  9526
  9527
  9528
  9529
  9530
  9531
  9532
  9533
  9534
  9535
  9536
  9537
  9538
  9539
  9540
  9541
  9542
  9543
  9544
  9545
  9546
  9548
  9549
  9550
  9551
  9552
  9553
  9554
  9555
  9556
  9557
  9558
  9559
  9560
  9561
  9562
  9563
  9564
  9565
  9566
  9567
  9568
  9569
  9570
  9571
  9572
  9573
  9574
  9575
  9576
  9577
  9578
  9579
  9580
  9581
  9582
  9583
  9584
  9591
  9592
  9593
  9594
  9595
  9596
  9598
  9599
  9600
  9601
  9602
  9603
  9604
  9605
  9606
  9607
  9608
  9609
  9610
  9611
  9612
  9613
  9615
  9616
  9617
  9618
  9619
  9620
  9621
  9622
  9623
  9624
  9625
  9626
  9627
  9628
  9629
  9630
  9631
  9632
  9633
  9634
  9635
  9637
  9638
  9639
  9640
  9642
  9643
  9644
  9645
  9646
  9647
  9648
  9649
  9650
  9651
  9652
  9653
  9655
  9656
  9658
  9659
  9660
  9661
  9662
  9663
  9664
  9665
  9666
  9667
  9668
  9669
  9670
  9672
  9673
  9674
  9675
  9676
  9677
  9678
  9679
  9680
  9681
  9682
  9683
  9684
  9685
  9686
  9687
  9688
  9689
  9690
  9691
  9692
  9693
  9694
  9695
  9696
  9697
  9698
  9699
  9700
  9701
  9702
  9703
  9704
  9705
  9706
  9707
  9708
  9709
  9710
  9711
  9712
  9713
  9714
  9715
  9716
  9717
  9718
  9719
  9720
  9721
  9722
  9723
  9724
  9725
  9726
  9728
  9729
  9732
  9733
  9734
  9736
  9738
  9739
  9740
  9741
  9742
  9743
  9744
  9745
  9746
  9747
  9748
  9749
  9751
  9752
  9753
  9754
  9755
  9756
  9757
  9758
  9759
  9760
  9761
  9765
  9766
  9767
  9768
  9769
  9770
  9771
  9772
  9773
  9774
  9775
  9776
  9777
  9778
  9779
  9780
  9781
  9782
  9783
  9784
  9785
  9786
  9787
  9788
  9789
  9790
  9793
  9795
  9796
  9797
  9798
  9801
  9802
  9803
  9805
  9808
  9809
  9810
  9811
  9812
  9813
  9814
  9815
  9816
  9822
  9829
  9830
  9831
  9832
  9833
  9834
  9835
  9836
  9840
  9841
  9842
  9843
  9844
  9845
  9846
  9847
  9848
  9850
  9852
  9854
  9855
  9856
  9858
  9859
  9860
  9863
  9864
  9865
  9866
  9868
  9870
  9871
  9872
  9875
  9877
  9878
  9880
  9881
  9882
  9885
  9886
  9887
  9888
  9889
  9890
  9891
  9892
  9893
  9897
  9898
  9899
  9900
  9901
  9903
  9904
  9905
  9908
  9909
  9910
  9911
  9912
  9913
  9914
  9916
  9917
  9918
  9919
  9921
  9922
  9923
  9925
  9926
  9927
  9930
  9931
  9933
  9934
  9935
  9936
  9937
  9939
  9940
  9941
  9942
  9944
  9945
  9947
  9948
  9949
  9950
  9952
  9954
  9955
  9956
  9958
  9959
  9960
  9961
  9962
  9963
  9964
  9965
  9966
  9968
  9969
  9970
  9971
  9972
  9973
  9974
  9975
  9977
  9982
  9983
  9984
  9985
  9988
  9990
  9991
  9992
  9993
  9994
  9995
  9996
  9997
  9998
  9999
  10000
  10002
  10003
  10004
  10005
  10006
  10007
  10009
  10010
  10011
  10012
  10013
  10014
  10015
  10016
  10017
  10018
  10019
  10020
  10021
  10022
  10027
  10029
  10030
  10031
  10032
  10033
  10034
  10035
  10036
  10037
  10038
  10039
  10040
  10041
  10042
  10043
  10044
  10045
  10046
  10047
  10049
  10050
  10051
  10052
  10053
  10054
  10055
  10056
  10057
  10058
  10059
  10060
  10061
  10062
  10063
  10064
  10065
  10066
  10067
  10068
  10069
  10070
  10071
  10072
  10073
  10074
  10075
  10076
  10077
  10078
  10079
  10080
  10081
  10082
  10083
  10084
  10085
  10086
  10087
  10088
  10089
  10090
  10091
  10092
  10093
  10094
  10095
  10096
  10097
  10098
  10099
  10100
  10101
  10102
  10103
  10104
  10105
  10106
  10107
  10108
  10109
  10110
  10111
  10112
  10113
  10114
  10115
  10116
  10117
  10118
  10119
  10120
  10121
  10122
  10123
  10124
  10125
  10126
  10127
  10128
  10129
  10130
  10131
  10132
  10133
  10134
  10135
  10136
  10137
  10138
  10139
  10140
  10141
  10142
  10143
  10144
  10145
  10146
  10147
  10148
  10149
  10150
  10151
  10152
  10153
  10154
  10155
  10156
  10157
  10158
  10159
  10160
  10161
  10162
  10163
  10164
  10165
  10166
  10167
  10168
  10169
  10170
  10171
  10172
  10173
  10174
  10175
  10176
  10177
  10179
  10180
  10181
  10182
  10183
  10184
  10185
  10186
  10187
  10188
  10189
  10190
  10191
  10192
  10193
  10194
  10195
  10196
  10198
  10199
  10200
  10201
  10202
  10203
  10204
  10205
  10206
  10207
  10208
  10209
  10210
  10211
  10212
  10213
  10214
  10215
  10218
  10219
  10220
  10221
  10222
  10223
  10225
  10226
  10227
  10228
  10229
  10230
  10231
  10232
  10233
  10234
  10235
  10236
  10237
  10238
  10239
  10240
  10241
  10242
  10243
  10244
  10245
  10246
  10247
  10248
  10249
  10250
  10251
  10252
  10253
  10254
  10255
  10256
  10257
  10258
  10259
  10260
  10261
  10262
  10263
  10264
  10265
  10266
  10267
  10268
  10269
  10270
  10271
  10272
  10273
  10274
  10275
  10276
  10277
  10278
  10279
  10280
  10281
  10282
  10283
  10284
  10285
  10286
  10287
  10288
  10289
  10290
  10291
  10292
  10293
  10294
  10295
  10296
  10297
  10298
  10299
  10300
  10301
  10302
  10303
  10304
  10305
  10306
  10307
  10308
  10309
  10310
  10311
  10312
  10313
  10314
  10315
  10316
  10317
  10318
  10319
  10320
  10321
  10322
  10323
  10324
  10325
  10326
  10327
  10328
  10329
  10330
  10331
  10332
  10333
  10334
  10335
  10336
  10337
  10338
  10339
  10340
  10341
  10342
  10343
  10344
  10345
  10346
  10347
  10348
  10349
  10350
  10351
  10352
  10353
  10354
  10355
  10356
  10357
  10358
  10359
  10360
  10361
  10362
  10363
  10365
  10366
  10367
  10368
  10369
  10370
  10371
  10372
  10373
  10374
  10375
  10376
  10377
  10378
  10379
  10380
  10381
  10382
  10383
  10384
  10385
  10386
  10387
  10388
  10389
  10390
  10391
  10392
  10393
  10394
  10395
  10396
  10397
  10398
  10399
  10400
  10401
  10402
  10403
  10404
  10405
  10406
  10407
  10408
  10409
  10410
  10411
  10412
  10413
  10414
  10415
  10416
  10417
  10418
  10419
  10420
  10421
  10422
  10423
  10424
  10425
  10426
  10427
  10428
  10429
  10430
  10431
  10432
  10433
  10434
  10436
  10437
  10438
  10439
  10440
  10441
  10442
  10443
  10444
  10445
  10446
  10447
  10448
  10449
  10450
  10451
  10452
  10453
  10454
  10455
  10456
  10457
  10458
  10459
  10460
  10461
  10462
  10463
  10464
  10465
  10466
  10467
  10468
  10469
  10470
  10471
  10472
  10473
  10474
  10475
  10476
  10477
  10478
  10479
  10480
  10481
  10482
  10483
  10484
  10485
  10486
  10487
  10488
  10489
  10490
  10491
  10492
  10493
  10494
  10495
  10496
  10497
  10498
  10499
  10500
  10501
  10502
  10503
  10504
  10505
  10506
  10507
  10508
  10509
  10510
  10511
  10512
  10513
  10514
  10515
  10516
  10517
  10518
  10519
  10520
  10521
  10522
  10523
  10524
  10525
  10526
  10527
  10528
  10529
  10530
  10531
  10532
  10533
  10534
  10535
  10536
  10537
  10538
  10539
  10540
  10541
  10542
  10543
  10544
  10545
  10546
  10547
  10548
  10549
  10550
  10551
  10552
  10553
  10554
  10555
  10556
  10557
  10558
  10559
  10560
  10561
  10562
  10563
  10564
  10565
  10566
  10567
  10568
  10569
  10570
  10571
  10572
  10573
  10574
  10575
  10576
  10577
  10578
  10579
  10580
  10581
  10582
  10583
  10584
  10585
  10586
  10587
  10588
  10589
  10590
  10591
  10592
  10593
  10594
  10595
  10596
  10597
  10598
  10599
  10600
  10601
  10602
  10603
  10604
  10605
  10606
  10607
  10608
  10609
  10610
  10611
  10612
  10613
  10614
  10615
  10616
  10617
  10618
  10619
  10620
  10621
  10622
  10623
  10624
  10625
  10626
  10627
  10628
  10629
  10630
  10631
  10632
  10633
  10634
  10635
  10636
  10637
  10638
  10639
  10640
  10641
  10642
  10643
  10644
  10645
  10646
  10647
  10648
  10649
  10650
  10651
  10652
  10653
  10654
  10655
  10656
  10657
  10658
  10659
  10660
  10661
  10662
  10663
  10664
  10665
  10666
  10667
  10668
  10669
  10670
  10671
  10672
  10673
  10674
  10675
  10676
  10677
  10678
  10679
  10680
  10681
  10682
  10683
  10684
  10685
  10686
  10687
  10688
  10689
  10690
  10691
  10692
  10693
  10694
  10695
  10696
  10697
  10698
  10699
  10700
  10701
  10702
  10703
  10704
  10705
  10706
  10707
  10708
  10709
  10710
  10711
  10712
  10713
  10714
  10715
  10716
  10717
  10718
  10719
  10720
  10721
  10722
  10723
  10724
  10725
  10726
  10727
  10728
  10729
  10730
  10731
  10732
  10733
  10734
  10735
  10736
  10737
  10738
  10739
  10740
  10741
  10742
  10743
  10744
  10745
  10746
  10747
  10748
  10749
  10750
  10751
  10752
  10753
  10754
  10755
  10756
  10757
  10758
  10759
  10760
  10761
  10762
  10763
  10764
  10765
  10766
  10767
  10768
  10769
  10770
  10771
  10772
  10773
  10774
  10775
  10776
  10777
  10778
  10779
  10780
  10781
  10782
  10783
  10784
  10785
  10786
  10787
  10788
  10789
  10790
  10791
  10792
  10793
  10794
  10795
  10796
  10797
  10798
  10799
  10800
  10801
  10802
  10803
  10804
  10805
  10806
  10807
  10808
  10809
  10810
  10811
  10812
  10813
  10814
  10815
  10816
  10817
  10818
  10819
  10820
  10821
  10822
  10823
  10824
  10825
  10826
  10827
  10828
  10829
  10830
  10831
  10832
  10833
  10834
  10835
  10836
  10837
  10838
  10839
  10840
  10841
  10842
  10843
  10844
  10845
  10846
  10847
  10848
  10849
  10850
  10851
  10852
  10853
  10854
  10855
  10856
  10857
  10858
  10859
  10860
  10861
  10862
  10863
  10864
  10865
  10866
  10867
  10868
  10869
  10870
  10871
  10872
  10873
  10874
  10875
  10876
  10877
  10878
  10879
  10880
  10881
  10882
  10883
  10884
  10885
  10886
  10887
  10888
  10889
  10890
  10891
  10892
  10893
  10894
  10895
  10896
  10897
  10898
  10899
  10900
  10901
  10902
  10903
  10904
  10905
  10906
  10907
  10908
  10909
  10910
  10911
  10912
  10913
  10914
  10915
  10916
  10917
  10918
  10919
  10920
  10921
  10922
  10923
  10924
  10925
  10926
  10927
  10928
  10929
  10930
  10931
  10932
  10933
  10934
  10935
  10936
  10937
  10938
  10939
  10940
  10941
  10942
  10943
  10944
  10945
  10946
  10947
  10948
  10949
  10950
  10951
  10952
  10953
  10954
  10955
  10956
  10957
  10958
  10959
  10960
  10961
  10962
  10963
  10964
  10965
  10966
  10967
  10968
  10969
  10970
  10971
  10972
  10973
  10974
  10975
  10976
  10977
  10978
  10979
  10980
  10981
  10982
  10983
  10984
  10985
  10986
  10987
  10988
  10989
  10990
  10991
  10992
  10993
  10994
  10995
  10996
  10997
  10998
  10999
  11000
  11001
  11002
  11003
  11004
  11005
  11006
  11007
  11008
  11009
  11010
  11011
  11012
  11013
  11014
  11015
  11016
  11017
  11018
  11019
  11020
  11021
  11022
  11023
  11024
  11025
  11026
  11027
  11028
  11029
  11030
  11031
  11032
  11033
  11034
  11035
  11036
  11037
  11038
  11039
  11040
  11041
  11042
  11043
  11044
  11045
  11046
  11047
  11048
  11049
  11050
  11051
  11052
  11053
  11054
  11055
  11056
  11057
  11058
  11059
  11060
  11061
  11062
  11063
  11064
  11065
  11066
  11067
  11068
  11069
  11070
  11071
  11072
  11073
  11074
  11075
  11076
  11077
  11078
  11079
  11080
  11081
  11082
  11083
  11084
  11085
  11086
  11087
  11088
  11089
  11090
  11091
  11092
  11093
  11094
  11095
  11096
  11097
  11098
  11099
  11100
  11101
  11102
  11103
  11104
  11105
  11106
  11107
  11108
  11109
  11110
  11111
  11112
  11113
  11114
  11115
  11116
  11117
  11118
  11119
  11120
  11121
  11122
  11123
  11124
  11125
  11126
  11127
  11128
  11129
  11130
  11131
  11132
  11133
  11134
  11135
  11136
  11137
  11138
  11139
  11140
  11141
  11142
  11143
  11144
  11145
  11146
  11147
  11148
  11149
  11150
  11151
  11152
  11153
  11154
  11155
  11156
  11157
  11158
  11159
  11160
  11161
  11162
  11163
  11164
  11165
  11166
  11167
  11168
  11169
  11170
  11171
  11172
  11173
  11174
  11175
  11176
  11177
  11178
  11179
  11180
  11181
  11182
  11183
  11184
  11185
  11186
  11187
  11188
  11189
  11190
  11191
  11192
  11193
  11194
  11195
  11196
  11197
  11198
  11199
  11200
  11201
  11202
  11203
  11204
  11205
  11206
  11207
  11208
  11209
  11210
  11211
  11212
  11213
  11214
  11215
  11216
  11217
  11218
  11219
  11220
  11221
  11222
  11223
  11224
  11225
  11226
  11227
  11228
  11229
  11230
  11231
  11232
  11233
  11234
  11235
  11236
  11237
  11238
  11239
  11240
  11241
  11242
  11243
  11244
  11245
  11246
  11247
  11248
  11249
  11250
  11251
  11252
  11253
  11254
  11255
  11256
  11257
  11258
  11259
  11260
  11261
  11262
  11263
  11264
  11265
  11266
  11267
  11268
  11269
  11270
  11271
  11272
  11273
  11274
  11275
  11276
  11277
  11278
  11279
  11280
  11281
  11282
  11283
  11284
  11285
  11286
  11287
  11288
  11289
  11290
  11291
  11292
  11293
  11294
  11295
  11296
  11297
  11298
  11299
  11300
  11301
  11302
  11303
  11304
  11305
  11306
  11307
  11308
  11309
  11310
  11311
  11312
  11313
  11314
  11315
  11316
  11317
  11318
  11319
  11320
  11321
  11322
  11323
  11324
  11325
  11326
  11327
  11328
  11329
  11330
  11331
  11332
  11333
  11334
  11335
  11336
  11337
  11338
  11339
  11340
  11341
  11342
  11343
  11344
  11345
  11346
  11347
  11348
  11349
  11350
  11351
  11352
  11353
  11354
  11355
  11356
  11357
  11358
  11359
  11360
  11361
  11362
  11363
  11364
  11365
  11366
  11367
  11368
  11369
  11370
  11371
  11372
  11373
  11374
  11375
  11376
  11377
  11378
  11379
  11380
  11381
  11382
  11383
  11384
  11385
  11386
  11387
  11388
  11389
  11390
  11391
  11392
  11393
  11394
  11395
  11396
  11397
  11398
  11399
  11400
  11401
  11402
  11403
  11404
  11405
  11406
  11407
  11408
  11409
  11410
  11411
  11412
  11413
  11414
  11415
  11416
  11417
  11418
  11419
  11420
  11421
  11422
  11423
  11424
  11425
  11426
  11427
  11428
  11429
  11430
  11431
  11432
  11433
  11434
  11435
  11436
  11437
  11438
  11439
  11440
  11441
  11442
  11443
  11444
  11445
  11446
  11447
  11448
  11449
  11450
  11451
  11452
  11453
  11454
  11455
  11456
  11457
  11458
  11459
  11460
  11461
  11462
  11463
  11464
  11465
  11466
  11467
  11468
  11469
  11470
  11471
  11472
  11473
  11474
  11475
  11476
  11477
  11478
  11479
  11480
  11481
  11482
  11483
  11484
  11485
  11486
  11487
  11488
  11489
  11490
  11491
  11492
  11493
  11494
  11495
  11496
  11497
  11498
  11499
  11500
  11501
  11502
  11503
  11504
  11505
  11506
  11507
  11508
  11509
  11510
  11511
  11512
  11513
  11514
  11515
  11516
  11517
  11518
  11519
  11520
  11521
  11522
  11523
  11524
  11525
  11526
  11527
  11528
  11529
  11530
  11531
  11532
  11533
  11534
  11535
  11536
  11537
  11538
  11539
  11540
  11541
  11542
  11543
  11544
  11545
  11546
  11547
  11548
  11549
  11550
  11551
  11552
  11553
  11554
  11555
  11556
  11557
  11558
  11560
  11561
  11562
  11563
  11564
  11565
  11566
  11567
  11569
  11570
  11571
  11572
  11573
  11574
  11575
  11576
  11577
  11578
  11579
  11580
  11581
  11582
  11583
  11584
  11585
  11586
  11587
  11588
  11589
  11590
  11591
  11592
  11593
  11594
  11595
  11596
  11597
  11598
  11599
  11600
  11601
  11602
  11603
  11604
  11605
  11606
  11607
  11608
  11609
  11610
  11611
  11612
  11613
  11614
  11615
  11616
  11617
  11618
  11619
  11620
  11621
  11622
  11623
  11624
  11625
  11626
  11627
  11628
  11629
  11630
  11631
  11632
  11633
  11634
  11635
  11636
  11637
  11638
  11639
  11640
  11641
  11642
  11643
  11644
  11645
  11646
  11647
  11648
  11649
  11650
  11651
  11652
  11653
  11654
  11655
  11656
  11657
  11658
  11659
  11660
  11661
  11662
  11663
  11664
  11665
  11666
  11667
  11668
  11669
  11670
  11671
  11672
  11673
  11674
  11675
  11676
  11677
  11678
  11679
  11680
  11681
  11682
  11683
  11684
  11685
  11686
  11687
  11688
  11689
  11690
  11691
  11692
  11693
  11694
  11695
  11696
  11697
  11698
  11699
  11700
  11701
  11702
  11703
  11704
  11705
  11706
  11707
  11708
  11709
  11710
  11711
  11712
  11713
  11714
  11715
  11716
  11717
  11718
  11719
  11720
  11721
  11722
  11724
  11725
  11726
  11727
  11728
  11729
  11730
  11731
  11732
  11733
  11734
  11735
  11736
  11737
  11738
  11739
  11740
  11741
  11742
  11743
  11744
  11745
  11746
  11747
  11748
  11749
  11750
  11751
  11752
  11753
  11754
  11755
  11756
  11757
  11758
  11759
  11760
  11761
  11762
  11763
  11764
  11765
  11766
  11767
  11768
  11769
  11770
  11771
  11772
  11773
  11774
  11775
  11776
  11777
  11778
  11779
  11780
  11781
  11782
  11783
  11784
  11785
  11786
  11787
  11788
  11789
  11790
  11791
  11792
  11793
  11794
  11795
  11796
  11797
  11798
  11799
  11800
  11801
  11802
  11803
  11804
  11805
  11806
  11807
  11808
  11809
  11810
  11811
  11812
  11813
  11814
  11815
  11816
  11817
  11818
  11819
  11820
  11821
  11822
  11823
  11824
  11825
  11826
  11827
  11828
  11829
  11830
  11831
  11832
  11833
  11834
  11835
  11836
  11837
  11838
  11839
  11840
  11841
  11842
  11843
  11844
  11845
  11846
  11847
  11848
  11849
  11850
  11851
  11852
  11853
  11854
  11855
  11856
  11857
  11858
  11859
  11860
  11861
  11862
  11863
  11864
  11865
  11866
  11867
  11868
  11869
  11870
  11871
  11872
  11873
  11874
  11875
  11876
  11877
  11878
  11879
  11880
  11881
  11882
  11883
  11884
  11885
  11886
  11887
  11888
  11889
  11890
  11891
  11892
  11893
  11894
  11895
  11896
  11897
  11898
  11899
  11900
  11901
  11902
  11903
  11904
  11905
  11906
  11907
  11908
  11909
  11910
  11911
  11912
  11913
  11914
  11915
  11916
  11917
  11918
  11919
  11920
  11921
  11922
  11923
  11924
  11925
  11926
  11927
  11928
  11929
  11930
  11931
  11932
  11933
  11934
  11935
  11936
  11937
  11938
  11939
  11940
  11941
  11942
  11943
  11944
  11945
  11946
  11947
  11948
  11949
  11950
  11951
  11952
  11953
  11954
  11955
  11956
  11957
  11958
  11959
  11960
  11961
  11962
  11963
  11964
  11965
  11966
  11967
  11968
  11969
  11970
  11971
  11972
  11973
  11974
  11975
  11976
  11977
  11978
  11979
  11980
  11981
  11982
  11983
  11984
  11985
  11986
  11987
  11988
  11989
  11990
  11991
  11992
  11993
  11994
  11995
  11996
  11997
  11998
  11999
  12000
  12001
  12002
  12003
  12004
  12005
  12006
  12007
  12008
  12009
  12010
  12011
  12014
  12015
  12017
  12019
  12020
  12021
  12022
  12023
  12024
  12025
  12026
  12027
  12028
  12029
  12030
  12031
  12032
  12033
  12035
  12036
  12037
  12038
  12039
  12040
  12041
  12042
  12043
  12044
  12045
  12046
  12047
  12048
  12049
  12051
  12052
  12053
  12054
  12055
  12056
  12057
  12058
  12059
  12060
  12061
  12062
  12063
  12064
  12065
  12066
  12067
  12068
  12069
  12070
  12071
  12072
  12074
  12075
  12076
  12077
  12078
  12079
  12080
  12081
  12082
  12083
  12084
  12085
  12086
  12087
  12088
  12089
  12090
  12091
  12092
  12093
  12094
  12095
  12096
  12097
  12098
  12099
  12100
  12101
  12102
  12103
  12104
  12105
  12106
  12107
  12108
  12109
  12110
  12111
  12112
  12113
  12114
  12115
  12116
  12117
  12118
  12119
  12120
  12121
  12122
  12123
  12124
  12125
  12126
  12127
  12128
  12129
  12130
  12131
  12132
  12133
  12134
  12135
  12136
  12137
  12138
  12139
  12140
  12141
  12142
  12143
  12144
  12145
  12146
  12147
  12148
  12149
  12150
  12151
  12152
  12153
  12154
  12155
  12156
  12157
  12158
  12159
  12160
  12161
  12162
  12163
  12164
  12165
  12166
  12167
  12168
  12169
  12170
  12171
  12172
  12173
  12174
  12175
  12176
  12177
  12178
  12179
  12180
  12181
  12182
  12183
  12184
  12185
  12186
  12187
  12188
  12189
  12190
  12191
  12192
  12194
  12195
  12196
  12197
  12198
  12199
  12200
  12201
  12202
  12203
  12204
  12205
  12206
  12207
  12208
  12209
  12210
  12211
  12212
  12213
  12214
  12215
  12216
  12217
  12218
  12219
  12220
  12221
  12222
  12223
  12224
  12225
  12226
  12227
  12228
  12229
  12230
  12231
  12232
  12233
  12234
  12235
  12236
  12237
  12238
  12239
  12240
  12241
  12242
  12243
  12244
  12245
  12246
  12247
  12248
  12249
  12250
  12251
  12252
  12253
  12254
  12255
  12256
  12257
  12258
  12259
  12260
  12261
  12262
  12263
  12264
  12265
  12267
  12268
  12269
  12270
  12271
  12272
  12273
  12274
  12275
  12276
  12277
  12278
  12279
  12280
  12281
  12282
  12283
  12284
  12285
  12286
  12287
  12288
  12289
  12290
  12291
  12292
  12293
  12294
  12295
  12296
  12297
  12298
  12299
  12300
  12301
  12302
  12303
  12304
  12305
  12306
  12307
  12308
  12309
  12310
  12311
  12312
  12313
  12314
  12315
  12316
  12317
  12318
  12319
  12320
  12321
  12322
  12323
  12324
  12325
  12326
  12327
  12328
  12329
  12330
  12331
  12332
  12333
  12334
  12335
  12336
  12337
  12338
  12339
  12340
  12341
  12342
  12343
  12344
  12345
  12346
  12347
  12348
  12349
  12350
  12351
  12352
  12353
  12354
  12355
  12356
  12357
  12358
  12359
  12360
  12361
  12362
  12363
  12365
  12366
  12367
  12368
  12369
  12370
  12371
  12372
  12373
  12374
  12375
  12376
  12377
  12378
  12379
  12380
  12381
  12382
  12383
  12384
  12385
  12386
  12387
  12388
  12389
  12390
  12391
  12392
  12393
  12394
  12395
  12396
  12397
  12398
  12399
  12400
  12401
  12402
  12403
  12405
  12406
  12407
  12408
  12409
  12410
  12411
  12412
  12413
  12414
  12415
  12416
  12417
  12418
  12419
  12420
  12421
  12422
  12423
  12424
  12425
  12426
  12427
  12428
  12429
  12430
  12431
  12432
  12433
  12434
  12435
  12436
  12437
  12438
  12439
  12440
  12441
  12442
  12443
  12444
  12445
  12446
  12447
  12448
  12449
  12450
  12451
  12452
  12453
  12454
  12455
  12456
  12457
  12458
  12459
  12460
  12461
  12462
  12464
  12465
  12466
  12467
  12468
  12469
  12470
  12471
  12472
  12473
  12474
  12475
  12476
  12477
  12478
  12479
  12480
  12481
  12482
  12483
  12484
  12485
  12486
  12487
  12488
  12489
  12490
  12491
  12492
  12493
  12494
  12495
  12496
  12497
  12498
  12499
  12500
  12501
  12502
  12503
  12505
  12507
  12508
  12509
  12510
  12511
  12513
  12514
  12515
  12516
  12518
  12519
  12520
  12521
  12522
  12524
  12526
  12527
  12528
  12529
  12530
  12531
  12532
  12533
  12534
  12535
  12536
  12537
  12538
  12539
  12540
  12541
  12542
  12543
  12544
  12545
  12546
  12547
  12548
  12549
  12550
  12551
  12552
  12553
  12554
  12557
  12558
  12559
  12560
  12561
  12562
  12563
  12564
  12565
  12566
  12567
  12568
  12569
  12570
  12571
  12572
  12573
  12574
  12575
  12578
  12579
  12580
  12583
  12584
  12585
  12599
  12609
  12610
  12611
  12612
  12613
  12614
  12615
  12616
  12617
  12618
  12619
  12620
  12621
  12622
  12623
  12624
  12625
  12626
  12627
  12628
  12630
  12631
  12632
  12633
  12634
  12635
  12636
  12639
  12640
  12642
  12643
  12644
  12645
  12646
  12647
  12648
  12649
  12650
  12651
  12652
  12653
  12654
  12655
  12656
  12657
  12658
  12659
  12660
  12661
  12662
  12663
  12664
  12665
  12666
  12667
  12668
  12669
  12670
  12671
  12672
  12673
  12674
  12675
  12676
  12678
  12681
  12682
  12683
  12685
  12686
  12687
  12688
  12689
  12690
  12691
  12692
  12693
  12694
  12695
  12696
  12697
  12698
  12699
  12700
  12701
  12702
  12703
  12704
  12705
  12706
  12707
  12708
  12709
  12710
  12711
  12712
  12713
  12714
  12715
  12716
  12717
  12718
  12719
  12720
  12721
  12722
  12723
  12724
  12725
  12726
  12727
  12728
  12729
  12730
  12731
  12732
  12733
  12734
  12735
  12736
  12737
  12738
  12739
  12740
  12741
  12742
  12743
  12744
  12745
  12746
  12747
  12748
  12749
  12750
  12751
  12753
  12754
  12755
  12756
  12757
  12758
  12759
  12760
  12761
  12762
  12763
  12764
  12765
  12766
  12767
  12768
  12769
  12770
  12771
  12772
  12774
  12775
  12776
  12777
  12778
  12779
  12780
  12781
  12782
  12783
  12784
  12785
  12786
  12787
  12788
  12789
  12790
  12791
  12792
  12793
  12794
  12795
  12796
  12797
  12798
  12799
  12800
  12801
  12802
  12803
  12804
  12805
  12806
  12807
  12808
  12809
  12810
  12811
  12812
  12813
  12814
  12815
  12817
  12818
  12819
  12820
  12821
  12822
  12823
  12824
  12825
  12826
  12827
  12829
  12830
  12831
  12832
  12833
  12834
  12835
  12836
  12838
  12839
  12840
  12841
  12842
  12843
  12844
  12845
  12846
  12847
  12849
  12850
  12851
  12853
  12854
  12855
  12856
  12857
  12858
  12859
  12860
  12861
  12862
  12863
  12864
  12865
  12866
  12867
  12868
  12869
  12870
  12871
  12872
  12873
  12874
  12875
  12876
  12877
  12878
  12879
  12880
  12881
  12882
  12883
  12884
  12885
  12886
  12887
  12888
  12889
  12890
  12891
  12892
  12893
  12894
  12895
  12896
  12897
  12898
  12899
  12900
  12901
  12902
  12903
  12904
  12905
  12906
  12907
  12909
  12910
  12911
  12912
  12913
  12914
  12917
  12918
  12919
  12920
  12921
  12922
  12925
  12926
  12927
  12928
  12929
  12930
  12931
  12932
  12933
  12934
  12935
  12936
  12937
  12939
  12940
  12941
  12942
  12943
  12944
  12946
  12947
  12948
  12949
  12950
  12951
  12952
  12954
  12955
  12958
  12961
  12962
  12963
  12964
  12965
  12966
  12967
  12968
  12969
  12970
  12971
  12972
  12973
  12974
  12975
  12976
  12977
  12978
  12979
  12980
  12981
  12982
  12983
  12984
  12985
  12986
  12987
  12988
  12989
  12991
  12992
  12993
  12994
  12995
  12996
  12997
  13005
  13011
  13012
  13013
  13014
  13015
  13016
  13018
  13019
  13020
  13021
  13022
  13023
  13024
  13025
  13026
  13027
  13028
  13030
  13031
  13032
  13033
  13034
  13035
  13036
  13037
  13038
  13039
  13040
  13041
  13042
  13043
  13044
  13045
  13046
  13047
  13048
  13049
  13050
  13051
  13053
  13054
  13055
  13056
  13057
  13058
  13059
  13060
  13061
  13062
  13063
  13064
  13065
  13066
  13067
  13068
  13069
  13070
  13071
  13072
  13073
  13074
  13075
  13076
  13077
  13078
  13079
  13080
  13081
  13082
  13083
  13084
  13086
  13087
  13088
  13089
  13090
  13091
  13092
  13093
  13094
  13095
  13096
  13097
  13098
  13099
  13100
  13101
  13102
  13103
  13104
  13105
  13106
  13107
  13108
  13109
  13110
  13111
  13112
  13113
  13114
  13115
  13116
  13117
  13118
  13119
  13120
  13121
  13122
  13123
  13124
  13125
  13126
  13127
  13128
  13129
  13130
  13131
  13132
  13133
  13134
  13135
  13136
  13137
  13138
  13139
  13140
  13141
  13142
  13144
  13145
  13146
  13147
  13148
  13149
  13150
  13151
  13152
  13153
  13154
  13155
  13156
  13157
  13158
  13159
  13160
  13161
  13162
  13163
  13164
  13165
  13166
  13167
  13168
  13169
  13170
  13171
  13172
  13173
  13174
  13175
  13176
  13177
  13178
  13179
  13180
  13181
  13182
  13183
  13184
  13185
  13186
  13187
  13188
  13189
  13190
  13191
  13192
  13193
  13194
  13195
  13196
  13197
  13198
  13200
  13201
  13202
  13203
  13204
  13205
  13206
  13207
  13208
  13209
  13210
  13211
  13212
  13213
  13214
  13215
  13216
  13217
  13218
  13219
  13220
  13221
  13222
  13223
  13224
  13225
  13226
  13227
  13228
  13229
  13230
  13231
  13232
  13233
  13234
  13235
  13236
  13237
  13238
  13239
  13240
  13241
  13242
  13243
  13244
  13245
  13246
  13247
  13248
  13249
  13250
  13251
  13252
  13253
  13254
  13255
  13256
  13257
  13258
  13259
  13260
  13261
  13262
  13263
  13264
  13265
  13266
  13267
  13268
  13269
  13270
  13271
  13272
  13273
  13274
  13275
  13276
  13277
  13278
  13279
  13280
  13281
  13282
  13283
  13284
  13285
  13286
  13287
  13288
  13289
  13290
  13291
  13292
  13293
  13294
  13295
  13296
  13297
  13298
  13299
  13300
  13301
  13302
  13303
  13304
  13305
  13306
  13307
  13308
  13309
  13310
  13311
  13312
  13313
  13314
  13315
  13317
  13318
  13319
  13320
  13321
  13322
  13323
  13324
  13325
  13326
  13327
  13328
  13329
  13330
  13331
  13332
  13333
  13334
  13335
  13336
  13337
  13338
  13339
  13340
  13341
  13342
  13343
  13344
  13345
  13346
  13347
  13348
  13349
  13350
  13351
  13352
  13353
  13354
  13355
  13356
  13357
  13358
  13359
  13360
  13361
  13362
  13363
  13364
  13365
  13366
  13367
  13368
  13369
  13370
  13371
  13372
  13373
  13374
  13375
  13376
  13377
  13378
  13379
  13380
  13381
  13382
  13383
  13384
  13385
  13386
  13387
  13388
  13389
  13390
  13391
  13392
  13393
  13394
  13395
  13396
  13397
  13398
  13399
  13401
  13402
  13403
  13404
  13405
  13406
  13407
  13408
  13409
  13410
  13411
  13412
  13413
  13414
  13415
  13416
  13417
  13418
  13419
  13420
  13421
  13422
  13425
  13426
  13427
  13428
  13429
  13430
  13431
  13432
  13433
  13434
  13435
  13436
  13437
  13438
  13439
  13440
  13441
  13442
  13443
  13444
  13445
  13446
  13447
  13448
  13449
  13450
  13451
  13452
  13453
  13454
  13455
  13457
  13458
  13459
  13460
  13461
  13462
  13463
  13464
  13465
  13467
  13468
  13469
  13470
  13471
  13472
  13473
  13474
  13475
  13476
  13477
  13478
  13479
  13480
  13481
  13482
  13483
  13484
  13485
  13486
  13487
  13488
  13489
  13490
  13491
  13492
  13494
  13495
  13496
  13497
  13498
  13499
  13500
  13501
  13502
  13503
  13504
  13505
  13506
  13507
  13508
  13509
  13510
  13511
  13512
  13513
  13514
  13515
  13516
  13517
  13519
  13520
  13521
  13522
  13523
  13525
  13526
  13527
  13528
  13529
  13530
  13531
  13532
  13533
  13534
  13535
  13536
  13537
  13538
  13539
  13543
  13544
  13545
  13546
  13548
  13549
  13550
  13551
  13552
  13553
  13554
  13555
  13556
  13557
  13558
  13559
  13560
  13561
  13562
  13563
  13564
  13565
  13566
  13567
  13568
  13569
  13570
  13571
  13572
  13573
  13574
  13575
  13576
  13577
  13578
  13579
  13580
  13581
  13582
  13583
  13584
  13585
  13586
  13587
  13588
  13589
  13590
  13591
  13592
  13593
  13594
  13595
  13596
  13597
  13598
  13599
  13600
  13601
  13602
  13603
  13604
  13605
  13606
  13607
  13608
  13609
  13610
  13611
  13612
  13613
  13614
  13615
  13616
  13617
  13618
  13619
  13620
  13621
  13622
  13623
  13624
  13625
  13626
  13627
  13628
  13629
  13630
  13631
  13632
  13633
  13634
  13635
  13636
  13637
  13638
  13639
  13640
  13641
  13642
  13643
  13644
  13645
  13646
  13647
  13648
  13649
  13650
  13651
  13652
  13653
  13654
  13655
  13656
  13657
  13658
  13659
  13660
  13661
  13662
  13663
  13664
  13665
  13666
  13667
  13668
  13669
  13670
  13671
  13672
  13673
  13674
  13675
  13676
  13677
  13678
  13679
  13680
  13681
  13682
  13683
  13684
  13685
  13686
  13687
  13688
  13689
  13690
  13691
  13692
  13693
  13694
  13695
  13696
  13697
  13698
  13699
  13700
  13701
  13702
  13703
  13704
  13705
  13706
  13707
  13708
  13709
  13710
  13711
  13712
  13713
  13714
  13715
  13716
  13717
  13718
  13719
  13720
  13721
  13722
  13723
  13724
  13725
  13726
  13727
  13728
  13729
  13730
  13731
  13732
  13733
  13734
  13735
  13736
  13737
  13738
  13739
  13740
  13741
  13742
  13743
  13744
  13745
  13746
  13747
  13748
  13749
  13750
  13751
  13752
  13753
  13754
  13755
  13756
  13757
  13758
  13759
  13760
  13761
  13762
  13763
  13764
  13765
  13766
  13767
  13768
  13769
  13770
  13771
  13772
  13773
  13774
  13775
  13776
  13777
  13778
  13779
  13780
  13781
  13782
  13783
  13784
  13785
  13786
  13787
  13788
  13789
  13790
  13791
  13792
  13793
  13794
  13795
  13796
  13797
  13798
  13799
  13800
  13801
  13802
  13803
  13804
  13805
  13806
  13807
  13808
  13809
  13810
  13811
  13812
  13813
  13814
  13815
  13816
  13817
  13818
  13819
  13820
  13821
  13822
  13823
  13824
  13825
  13826
  13827
  13828
  13829
  13830
  13831
  13832
  13833
  13834
  13835
  13836
  13837
  13838
  13839
  13840
  13841
  13842
  13843
  13844
  13845
  13846
  13847
  13848
  13849
  13850
  13851
  13852
  13853
  13854
  13855
  13856
  13857
  13858
  13859
  13860
  13861
  13862
  13863
  13864
  13865
  13866
  13867
  13868
  13869
  13870
  13871
  13872
  13873
  13874
  13875
  13876
  13877
  13878
  13879
  13880
  13881
  13882
  13883
  13884
  13885
  13886
  13887
  13888
  13889
  13890
  13891
  13892
  13893
  13894
  13895
  13896
  13897
  13898
  13899
  13900
  13901
  13902
  13903
  13904
  13905
  13906
  13907
  13908
  13909
  13910
  13911
  13912
  13913
  13914
  13915
  13916
  13917
  13918
  13919
  13920
  13921
  13922
  13923
  13924
  13925
  13926
  13927
  13928
  13929
  13930
  13931
  13932
  13933
  13934
  13935
  13936
  13937
  13938
  13939
  13940
  13941
  13942
  13943
  13944
  13945
  13946
  13947
  13948
  13949
  13950
  13951
  13954
  13955
  13956
  13957
  13958
  13959
  13960
  13961
  13962
  13963
  13964
  13965
  14218
  14219
  14220
  14221
  14222
  14223
  14224
  14225
  14227
  14228
  14229
  14230
  14231
  14232
  14233
  14234
  14235
  14236
  14237
  14238
  14239
  14240
  14241
  14242
  14243
  14244
  14245
  14246
  14247
  14248
  14249
  14250
  14251
  14252
  14253
  14255
  14256
  14257
  14258
  14259
  14260
  14261
  14262
  14263
  14264
  14265
  14266
  14371
  14372
  14373
  14374
  14375
  14376
  14377
  14378
  14379
  14380
  14381
  14382
  14383
  14384
  14385
  14386
  14387
  14388
  14389
  14405
  14406
  14407
  14408
  14409
  14410
  14411
  14412
  14413
  14414
  14415
  14416
  14417
  14418
  14419
  14420
  14421
  14422
  14423
  14424
  14440
  14441
  14442
  14443
  14444
  14445
  14446
  14447
  14448
  14449
  14465
  14466
  14467
  14468
  14469
  14470
  14471
  14472
  14473
  14474
  14475
  14476
  14477
  14478
  14480
  14481
  14482
  14483
  14484
  14485
  14486
  14487
  14488
  14489
  14490
  14491
  14492
  14493
  14494
  14495
  14496
  14497
  14498
  14499
  14500
  14501
  14502
  14503
  14504
  14505
  14506
  14507
  14508
  14509
  14510
  14511
  14512
  14513
  14514
  14515
  14516
  14517
  14518
  14519
  14520
  14521
  14522
  14524
  14525
  14526
  14527
  14528
  14529
  14530
  14531
  14532
  14533
  14534
  14535
  14536
  14537
  14538
  14539
  14540
  14541
  14542
  14543
  14544
  14545
  14546
  14547
  14548
  14549
  14550
  14551
  14554
  14555
  14556
  14557
  14558
  14559
  14560
  14561
  14562
  14563
  14564
  14565
  14566
  14567
  14568
  14569
  14570
  14571
  14572
  14573
  14574
  14575
  14576
  14577
  14578
  14579
  14580
  14581
  14582
  14583
  14584
  14585
  14586
  14587
  14588
  14589
  14590
  14591
  14592
  14593
  14594
  14595
  14596
  14597
  14598
  14599
  14600
  14601
  14602
  14603
  14604
  14605
  14606
  14607
  14608
  14609
  14610
  14611
  14612
  14613
  14614
  14615
  14616
  14617
  14618
  14619
  14620
  14621
  14622
  14623
  14624
  14625
  14626
  14627
  14628
  14629
  14630
  14631
  14632
  14633
  14634
  14635
  14636
  14637
  14638
  14639
  14640
  14641
  14642
  14643
  14644
  14645
  14646
  14647
  14648
  14649
  14650
  14651
  14652
  14653
  14654
  14655
  14656
  14657
  14658
  14659
  14660
  14661
  14662
  14663
  14664
  14665
  14666
  14667
  14668
  14669
  14670
  14671
  14672
  14674
  14675
  14676
  14677
  14678
  14679
  14680
  14681
  14682
  14683
  14684
  14687
  14688
  14689
  14690
  14691
  14692
  14693
  14694
  14695
  14696
  14697
  14698
  14699
  14700
  14701
  14702
  14703
  14704
  14705
  14706
  14707
  14708
  14709
  14710
  14711
  14712
  14713
  14714
  14715
  14716
  14717
  14718
  14719
  14720
  14721
  14722
  14723
  14724
  14725
  14726
  14727
  14728
  14729
  14730
  14731
  14732
  14733
  14734
  14735
  14736
  14737
  14738
  14739
  14740
  14741
  14742
  14743
  14744
  14745
  14746
  14747
  14748
  14749
  14750
  14751
  14752
  14753
  14754
  14755
  14756
  14757
  14758
  14759
  14760
  14761
  14762
]
View formatted query    View runnable query    Explain query
67.95 ms
(13.99%) 		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
48.21 ms
(9.93%) 		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
47.75 ms
(9.83%) 		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
42.53 ms
(8.76%) 		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
20.91 ms
(4.31%) 		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
12.68 ms
(2.61%) 		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
10.82 ms
(2.23%) 		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 OFFSET 5001
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.39 ms
(1.73%) 		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
7.29 ms
(1.50%) 		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
6.68 ms
(1.38%) 		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 OFFSET 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.49 ms
(1.34%) 		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
5.51 ms
(1.13%) 		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
5.38 ms
(1.11%) 		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
5.07 ms
(1.04%) 		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: 
[
  25
]
View formatted query    View runnable query    Explain query
4.40 ms
(0.91%) 		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
3.74 ms
(0.77%) 		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: 
[
  25
]
View formatted query    View runnable query    Explain query
3.53 ms
(0.73%) 		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
3.52 ms
(0.72%) 		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.27 ms
(0.67%) 		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: 
[
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
]
View formatted query    View runnable query    Explain query
3.08 ms
(0.63%) 		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
2.48 ms
(0.51%) 		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
1.93 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.91 ms
(0.39%) 		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
1.66 ms
(0.34%) 		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.14 ms
(0.24%) 		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.17%) 		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.67 ms
(0.14%) 		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.42 ms
(0.09%) 		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.39 ms
(0.08%) 		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.32 ms
(0.07%) 		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.28 ms
(0.06%) 		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.24 ms
(0.05%) 		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
0.23 ms
(0.05%) 		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.23 ms
(0.05%) 		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.22 ms
(0.04%) 		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.21 ms
(0.04%) 		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.20 ms
(0.04%) 		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.19 ms
(0.04%) 		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.18 ms
(0.04%) 		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.04%) 		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.18 ms
(0.04%) 		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.17 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.16 ms
(0.03%) 		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.15 ms
(0.03%) 		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.13 ms
(0.03%) 		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.12 ms
(0.02%) 		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.12 ms
(0.02%) 		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.11 ms
(0.02%) 		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.09 ms
(0.02%) 		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.09 ms
(0.02%) 		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.08 ms
(0.02%) 		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

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.