Query Metrics
95
Database Queries
52
Different statements
471.10 ms
Query time
9
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 14.81 ms |
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:
[] |
| 2 | 13.90 ms |
SELECT DISTINCT h0_.id AS id_0, h0_.discovery_year1 AS discovery_year1_1 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)) ORDER BY h0_.discovery_year1 ASC LIMIT 5001
Parameters:
[] |
| 3 | 76.24 ms |
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)) ORDER BY h0_.discovery_year1 ASC
Parameters:
[ 12433 17376 6 13211 9765 11159 18020 23 12197 17501 10219 13218 12825 10921 11440 16106 9191 18155 10931 11806 9223 9323 9324 12688 13045 10657 18109 11647 17141 10106 10232 153 9190 9189 17885 12190 9187 198 200 15802 17560 264 265 266 17515 18664 13390 16766 17482 17709 12342 17246 457 463 17933 11778 9325 13884 15836 11819 555 18523 12429 17701 12180 15853 644 9186 18548 18549 18445 18543 9751 12561 9771 13082 15705 16498 18616 9271 17197 17712 11106 15963 9273 12777 9119 16500 16746 11152 16387 1058 19992 20012 9127 9218 10829 12200 1117 12438 14241 1132 18208 18091 11779 12827 11810 16108 1325 1330 1331 1332 13068 12737 13332 13335 12814 17704 12189 12053 1373 11651 10210 10768 18015 17211 12705 18527 9787 11526 13345 9790 17546 16169 9289 13113 15499 12712 12711 19942 13259 17166 9270 18640 12745 18053 18068 1799 17587 9154 18574 12723 18466 9333 17976 18468 1954 16670 14996 1974 1984 12763 9281 17409 17707 10437 17389 12748 16372 14389 17195 13358 12858 2148 10261 16674 9192 13925 9552 13362 15776 11043 2319 18801 13088 13091 13393 11809 16408 9623 9240 19991 18076 11575 17503 16777 11808 11911 15768 11669 13097 2598 13049 16686 18095 10614 18272 13065 16695 17705 10479 11231 16158 17711 10746 12803 17997 9668 11787 11853 12199 11983 10897 12043 11360 16161 10567 15835 18702 16013 11508 17035 14697 10904 10848 12813 2662 13398 12103 13368 12820 18695 11942 18836 10105 10851 15773 16365 13343 12698 2691 11824 11578 11579 10065 12830 18531 13108 16853 11004 10671 12328 2725 12183 12704 11717 15732 11008 12751 14732 12076 10295 12703 2780 2784 2789 2790 2791 10916 12652 14742 13538 13071 15895 12710 14544 17007 10722 11248 11322 15846 12524 13380 13379 14257 9458 9457 11756 11467 11323 16655 18899 12186 11017 18307 13337 14955 15735 9715 12352 13254 16113 15496 13115 2871 17172 16484 13382 11924 15787 13353 2885 2886 17142 13346 11564 12849 11798 2897 12431 17550 9280 2906 17092 12336 12014 2919 11517 2926 2928 12392 11839 18465 18062 11629 10877 2944 17563 10925 10601 11566 12356 18043 14989 17383 11426 13921 11630 14550 17979 18799 10506 11525 11518 17307 17552 14997 16136 11331 18478 17003 13387 14235 3007 16665 10777 10929 3016 17696 3019 17981 11544 3031 12535 12567 12771 10882 16125 18798 3057 10258 17896 18562 3070 16669 17145 12021 11104 16557 10323 18157 13084 18138 18262 12720 13204 12341 17012 11702 16585 10555 3119 10936 3121 17898 3126 18162 12721 14809 11490 14848 16673 12722 18296 16215 11570 12028 17238 12435 15001 11070 3168 16601 3171 17998 3176 3177 9773 16747 12195 17020 15656 10700 14813 15997 13322 16604 3212 12781 11357 16521 12785 16153 17987 15765 16750 13394 13861 12490 11739 10984 16514 18172 16154 11394 3266 3269 10745 12584 13860 12098 3290 15832 17614 11705 10455 10452 12542 3308 11307 15762 11531 17498 11111 18181 3320 12409 3323 12440 13329 3330 16404 13397 3339 12422 10461 17594 12500 16605 10463 16406 18697 3365 20008 12546 3370 11614 15719 3385 10990 3389 11932 13096 11234 12374 16275 10470 18506 3405 12044 18000 11811 11813 12312 3420 10346 10473 10993 17350 12347 11052 11990 16162 15766 15838 14671 12172 11200 15015 3467 3468 3469 16017 13093 12686 18195 9831 16623 10905 3485 15769 10957 12045 13334 13942 11940 16624 3499 18703 12696 11994 13895 18597 18603 13101 3518 3519 11347 18605 12413 11521 10906 16028 16410 11450 16776 13103 18515 11822 11363 16696 14242 13900 12948 14446 13069 11349 9740 13374 3595 3607 15854 17719 15681 18629 11173 10965 3625 10294 12108 12179 17168 18306 16010 12514 17623 18892 12702 3654 3657 11421 15786 12518 15888 11557 17878 11623 12961 18902 18017 11682 15645 18034 17869 11534 10533 12832 17718 18638 10416 11353 12519 18903 15852 20036 18906 18713 18639 16931 16702 11754 16341 11093 10167 12351 11624 13109 17156 11656 17628 18908 17954 12756 10917 18914 16713 12135 14477 13376 12185 16445 18569 13111 12757 12715 10771 11436 18721 3806 16724 17387 11061 17881 13188 12277 10724 3829 18722 17965 18532 11690 14538 14266 3858 17962 14371 17645 10914 16934 10299 10297 12713 12717 3883 18131 16653 3889 18533 12479 15689 18072 14480 11438 3906 10636 3912 3913 19948 3927 14225 19955 12769 15843 10774 10920 18063 14987 16184 18481 13354 18354 17884 11425 13078 17653 16668 3985 18768 13388 11025 13915 11955 17553 4032 14548 4039 9768 4048 16123 12432 10922 10257 15642 17904 14791 12092 18568 11966 12391 10600 13384 17382 15960 9689 18796 18045 15815 10436 10314 18049 18552 11099 15752 13385 18800 17320 14792 11329 18546 4176 4177 4184 11354 4186 15931 14502 12859 16364 16120 4198 13286 15922 4209 17013 18142 16121 15947 12338 4223 12419 4230 15805 12089 15758 14551 4250 11768 12768 12286 4262 13927 12191 14795 10550 14489 4300 13923 11528 4318 11841 13087 4327 10315 4329 9664 17971 12340 12395 4347 18482 13357 4353 10690 11771 17703 16671 11773 12192 12398 18253 12573 4383 12420 10780 10728 11803 10781 13083 19972 18717 17764 16368 4431 17110 4458 4462 18707 10554 4473 4478 4493 4498 13086 13940 4517 4518 11334 10144 4523 14495 14549 12681 16366 4539 11636 13356 4545 17339 4550 4552 12194 4554 4555 4561 11906 4563 14503 4565 18164 4568 13457 13391 10886 4576 4578 12096 17418 4583 13392 17980 4586 4589 19982 4593 4594 4595 4598 16230 11929 18270 4607 13926 12032 4610 4611 16754 4613 4617 16587 11927 12728 16137 4630 16220 17982 4634 16744 11740 4637 17018 4644 4647 4648 17413 12196 12296 4664 17229 16511 14247 4671 17912 4676 18487 18838 4683 4684 19996 4688 18495 4692 15450 12405 4695 18295 11908 4755 15998 12299 4760 4761 4762 9471 13361 4768 10613 16003 4772 17411 4776 18584 12300 17228 4782 10520 18593 13321 4788 4790 17497 13061 11449 4794 20002 4797 10327 10744 11076 18601 10139 12550 4811 11396 11474 19993 4816 12041 13047 10335 12408 4826 12037 16616 16398 4833 19990 4843 4847 12038 15761 4852 12039 16085 15602 4860 11400 16753 18277 11337 11338 11605 17037 11339 18691 10987 13365 12166 4879 11158 14515 4886 13212 11972 13395 4894 13369 4896 4898 18807 11404 16748 4904 4905 4907 4909 4911 4912 19999 12410 13095 17996 4919 16251 4921 4922 10283 4924 4925 11607 13151 13059 18867 11975 16009 17130 15012 18001 4938 4939 4940 13938 17403 11047 10464 4946 4947 17931 4949 11198 18002 4956 11980 11982 11981 13943 12345 11781 10942 12624 12468 12198 11672 11342 12307 17254 12731 17935 16527 17937 13945 16250 14248 13063 18516 10992 10209 11199 17929 15721 12469 12346 10839 5297 12690 16087 10901 11080 10472 5318 18288 10571 5326 5327 13333 12412 12623 12730 12202 5357 17934 5359 12424 10398 9643 18885 11782 10476 18003 13217 12426 5375 5376 13066 12692 11674 11315 5384 9184 9183 9123 5390 11785 5393 15767 10750 12427 5397 9246 12739 5404 17630 5408 10211 11993 18100 13098 16542 14418 11345 5418 11916 18293 18607 9833 10289 14386 13371 18573 9732 16411 13315 10710 16499 16018 10406 17019 15472 11085 11821 10907 11119 18110 20005 12173 11117 9675 11203 18513 10484 15481 12349 14255 10714 17943 17355 17512 17580 11615 11318 11909 17744 17136 16625 17040 17914 5551 13235 18610 13352 15774 13902 12000 11365 11943 5592 17730 14468 15845 13104 17944 17517 17049 16089 12700 14712 15847 12701 9085 18611 12181 18612 16784 16091 15850 12379 5647 16787 13751 16544 16547 5661 14258 9789 18522 10769 16795 12840 13240 15629 13340 16097 13341 13342 5704 18630 13486 11683 15882 5713 5717 16850 16552 13726 5725 10915 10809 18023 10495 10166 15889 13355 18718 10162 10160 10176 11587 10161 18382 18118 12969 17159 18222 18385 13110 17174 17625 16104 16334 15489 16645 5788 17631 5791 17760 16352 5795 5797 17956 11176 5804 13074 11922 14536 18125 18738 14478 15862 11951 5819 18128 18038 17957 5827 5829 18434 15490 5834 10672 18438 13075 13112 17769 17373 14537 17299 20055 13347 10427 5879 5881 5883 15883 12278 18752 11627 11628 17282 18444 17810 5904 16566 11895 18529 18225 14766 17545 17083 17047 15736 18226 17285 19941 12188 12187 18645 18040 17286 13350 18234 13080 15842 18159 5960 19943 18244 5966 19944 18041 16640 18133 19949 19950 17874 19954 18534 16925 5995 12529 16355 17375 17381 17877 13965 10300 12668 16466 18628 10727 12354 11899 6022 16660 6025 18042 11466 14227 18134 17377 6035 6037 17967 10546 11381 13266 12355 12283 17897 17889 18451 16468 18147 18136 17892 16497 15967 18245 17672 12974 17002 18537 6086 18658 17107 19981 18139 6097 13383 6100 16571 11139 6109 6110 16490 10923 11465 10927 17379 10638 16948 15910 16534 18550 14374 12337 15808 12534 12764 12284 6170 13282 12766 6181 17895 6183 18571 11956 6189 14375 18248 6203 6205 18469 17391 6215 6216 6217 6222 17384 6224 17001 16667 12716 11546 17386 18665 17385 6246 13437 6260 12434 9809 11032 6267 12137 6269 15701 15943 6275 17622 14230 10820 18050 18475 17392 6291 6292 17694 16491 10928 6299 14529 13386 15950 17695 6314 6315 13924 17911 6326 14492 11727 6332 6334 16363 17098 17968 6345 18254 18663 17576 12339 18106 6359 11962 12020 17970 6369 11027 16122 6372 16496 17191 17402 17105 19961 12155 17326 17697 17240 10552 10641 15821 9581 6418 6419 17523 17579 18797 6437 18570 18275 10438 14379 10688 9282 11800 10930 17903 10938 12767 17325 18061 12289 6513 11802 10645 15486 9656 12396 16128 18065 6543 9334 12397 9718 12855 14493 6605 10932 9693 9284 6620 17398 11469 6673 12093 14497 11718 11470 11804 10259 11905 12158 6723 9283 6725 16740 15686 10120 9752 10260 16676 11633 10685 12095 11174 17412 12719 11634 13239 6753 10189 17209 18059 11445 13389 9502 10934 6769 11147 16697 18561 9663 6775 6778 10694 6780 11926 10123 14811 6799 10263 11770 6804 18782 13891 13073 6808 11731 11597 6812 16663 11068 17617 6819 17692 11037 11040 11041 6825 6827 12770 10740 13081 10190 9272 17203 17942 9307 15839 13543 12725 13344 20029 9197 9196 9195 9194 9193 9201 9200 16008 15849 15000 11151 18907 10697 16386 9174 9161 15711 6883 13057 9661 9660 11182 9696 11429 10395 10516 18803 9274 9320 9666 9206 9205 13370 18014 9321 12775 9662 18805 17608 10441 6923 10440 10612 17924 12699 11736 10558 17121 11356 11388 12421 12437 12436 18575 12691 17596 18098 10133 13314 12538 11044 17585 13089 11389 12727 11776 13090 16141 13062 6991 19986 18499 16234 14383 13092 17983 13359 17410 18501 18598 9720 13668 15834 16249 14384 12540 9775 18873 9624 10743 9776 12406 17706 18271 16221 18666 13931 12570 13051 18184 16388 17235 18074 18489 18596 9778 9777 12035 9667 13363 10274 9781 17985 18085 17440 16246 16143 9665 18075 17441 17442 11073 17237 18505 7114 10443 17603 18808 17461 16600 18671 18809 17480 11601 7136 7144 14387 17588 18822 14999 17991 18079 18166 18672 13396 7164 10394 14519 15713 7175 9472 17605 7183 7185 7186 16752 11074 17342 13935 16393 10451 13044 12687 16274 18186 11395 12343 18276 17989 13056 10703 14609 10651 19994 9723 7245 14388 9753 18700 10790 17486 10096 18173 18081 18013 7262 18866 13364 17530 13054 7280 10895 18845 7289 18084 11971 7292 18704 7294 13932 16761 14509 13094 12161 9754 13863 15003 14405 16749 7320 10342 11451 16682 13933 13366 13055 7331 16248 7338 12040 7340 14516 7342 15833 16000 14411 18594 19997 17032 13208 18278 12620 13367 7367 7368 7369 7371 7372 7373 9180 7376 18290 14517 17925 17591 17593 18279 10282 10279 12305 13058 17994 17613 16001 18701 14518 14896 11232 10462 7409 9179 11167 17945 9178 9177 7415 7417 7418 18282 11709 9782 10098 7424 7425 20000 12344 9286 9285 10832 13937 7435 15764 16415 16694 13323 13060 7452 16771 15658 7459 7460 7462 12348 7464 15659 7466 7467 16622 18093 7474 15017 9181 11196 17125 12547 12689 7482 7483 10100 7485 7488 10526 10835 16285 10468 12441 17999 16157 13324 12042 18292 16531 11197 7512 16610 16399 17607 16253 14901 16522 16613 11644 18871 13880 17926 11163 18872 17936 11784 18900 18004 11986 17616 10396 10397 17122 14443 16163 18107 13064 7564 10946 11165 10345 7572 12733 10568 13888 12423 7586 7588 7589 7590 7591 12729 9146 16691 16405 10950 10841 10842 10404 12812 10749 17171 12552 12167 12170 12168 12171 12407 9166 9725 12201 16778 10708 10663 16173 12036 14413 9339 17236 7642 9222 10348 16142 12403 10709 18012 10574 11817 16155 9726 9728 10912 11816 13067 10570 16523 10846 18077 14505 7691 17988 12203 10798 9783 13336 11458 11361 18692 16293 9571 10656 12174 18102 15840 9326 9287 17344 9245 17277 9275 9228 9225 9224 10718 9124 16402 9182 15844 15019 13944 10954 12734 12444 12442 15470 14423 7754 17255 12693 12270 13375 7762 7763 7764 7765 7766 12301 14897 18201 13399 13221 17615 12625 14520 15841 12695 7781 7782 7783 12628 13816 12269 7792 14524 7795 10480 7799 15271 16060 10147 13894 12707 11639 7822 14504 11883 11204 12694 7831 16289 10712 10290 18517 12740 13372 10212 13373 12645 10355 13225 18581 18678 10213 13621 7862 17348 14522 13226 13227 12428 13228 12780 12473 18202 10218 13230 11121 11086 12414 11348 15479 18508 13099 18876 16024 10482 12697 13100 18021 12271 10291 18893 7915 12272 12274 18588 18880 13102 12941 11867 11868 18512 15772 7935 11870 11873 7940 15020 18705 7944 10471 11874 10485 11876 10704 9786 12411 12175 11880 17713 12425 13360 18528 13233 12944 12831 15635 7977 14696 11884 20027 11890 14253 11891 18769 11892 15023 11919 11617 11677 12176 8002 12754 9185 16331 11997 10666 11364 12177 11552 16412 12204 10667 11553 11998 8038 16295 10717 14531 9276 13070 13946 9087 9234 17724 10486 11789 18518 17721 10487 11751 16628 12065 12242 12068 12760 16310 15775 13167 14466 11999 12178 10488 17738 15680 11419 18019 11580 12744 20028 11089 11921 8122 16705 8128 8129 13237 9086 16649 20030 11556 10668 11123 10168 11687 17632 17154 9381 10489 8159 11208 18316 14467 18609 10756 10853 16111 18231 18740 8175 10624 8177 9355 8180 9134 16549 17940 17082 16434 10490 17163 8197 8198 9327 18483 18519 8204 8205 16698 8207 8209 8211 16313 8214 16703 18708 19289 15851 14527 12350 8223 16321 12850 18891 15848 8236 11753 12003 8240 8242 8244 11790 8247 12182 8249 13077 18420 8253 8255 11715 16860 11681 18124 16736 12415 18132 18104 10857 8271 18310 18314 13105 11006 8280 18613 10673 8285 8286 18218 8290 8291 8292 8293 8294 8297 11948 18617 8305 8307 8309 17946 8312 8313 18521 8316 18114 8318 8319 8320 8323 12753 8326 8327 18115 8330 8331 18625 8333 17525 17151 8338 14261 13903 8351 8352 8353 8355 13106 12656 8363 8367 20032 10814 8375 11894 17527 8380 8381 8384 16701 18710 13522 8391 8394 8395 18137 15633 17624 8403 8409 8413 12184 12004 18632 11351 12761 8424 8425 15674 18716 12006 12276 18657 13107 10494 15856 9760 11059 18536 13377 17362 9136 9074 10069 14534 17774 13351 16661 14407 13693 11686 9278 9277 12134 17960 13187 16870 20049 10417 13378 18737 12010 9453 17275 18440 10496 10418 10296 10177 10763 8503 8504 12709 17959 8508 14546 18743 14532 9454 13076 8517 11795 18535 18651 18425 10540 9084 15684 15871 14224 18024 12416 11435 11514 18117 10497 8542 17756 8545 20037 14533 12078 13526 11720 11725 12553 17670 18016 13072 10767 9650 8567 18446 18120 8575 17757 8577 12842 13339 18039 10421 10720 8593 8594 8595 15734 18526 10815 12430 11375 8610 8611 8612 8614 15487 15858 18720 10721 14950 11177 18426 17093 8629 16646 11497 8632 8633 8635 13133 8638 8640 8641 16103 11136 8644 8645 8648 8649 8650 8651 8652 8653 8655 8656 8657 13731 17267 20051 8670 12851 13079 18530 12009 14265 15884 12531 18783 11437 16181 12759 15866 16356 16332 17071 17633 11428 11834 20052 17368 13912 17538 18742 10725 16561 18130 18033 11376 11794 11945 12383 8743 8745 13381 17961 17636 12477 13114 14222 17641 17794 18744 10869 16088 8769 8770 10870 20050 12385 18719 17536 18255 9279 9247 9125 8789 15497 8792 8794 18067 15401 11005 9269 8800 8801 13348 9682 8805 8806 8807 8808 8810 8812 8813 8814 8815 8816 8817 8818 8819 8821 8822 8823 8824 8825 8826 8827 12136 12418 10681 16626 18037 11923 16851 12080 17634 18641 11957 15890 10872 11148 13338 8857 16114 15885 8862 8863 11563 11631 14547 16183 8871 8872 8874 8877 9770 8879 8880 8881 8882 8884 15795 8887 8888 8889 8890 8891 8893 8894 17088 18443 8897 8899 8900 8901 8902 8903 11422 17276 8907 8908 8909 8910 8911 8912 13349 8914 8915 8916 8917 8918 8919 8920 8921 8922 8923 8924 8925 8926 8927 8928 8929 8930 8931 8932 8933 8935 8936 9767 10972 17647 8951 9317 10637 8955 9358 10595 12762 12353 8968 12417 8971 17547 18150 8977 8978 8979 8980 8981 8982 8983 8984 8985 8986 8987 8988 8989 8990 8991 8992 8993 8994 8995 8996 8998 8999 9000 9001 9002 9003 9004 9005 9006 9007 9008 9009 9010 9011 9012 9013 9016 9017 9018 9019 9020 9021 9024 9025 9026 9027 9028 9030 9031 9033 9034 9035 9036 12718 11424 15951 9044 9687 18631 9048 9049 9050 9051 9052 9053 9054 9055 9056 9057 9058 9059 9065 9066 9067 9068 9069 9070 9072 15991 12389 16575 10051 6173 15973 13307 705 6515 1372 8405 3896 14380 7416 16512 9486 9488 8546 622 6669 764 400 11675 6603 11446 6670 18080 5514 6985 15982 17224 17188 17225 5616 10615 8347 6333 5914 7053 8315 13514 7110 18427 8383 7379 7443 17590 16170 16718 10642 5525 13192 9965 12241 12363 7275 8261 11984 11022 7112 4729 17990 8346 8406 3558 6153 7316 17597 13197 401 9963 17357 11523 12568 6966 8398 8302 5674 16923 15422 7191 8306 2199 4269 14635 5598 7419 5643 14953 4534 12372 11202 14903 4640 7111 11016 6656 15358 8597 7893 1878 1767 10742 6308 10691 10040 22 15409 7157 2525 7259 5660 7232 13604 327 16569 15488 7097 8868 13184 15643 17330 7192 14665 17296 1751 14855 9887 6667 37 614 743 1350 15425 16641 14885 12238 15414 5556 5633 5635 13904 19960 7087 13470 7273 7509 7520 17252 7570 11412 7922 7926 12237 10677 13453 8705 12559 4631 14948 5586 17241 16596 2 7307 13601 13627 13637 13636 13628 16580 12256 14651 5727 10064 10039 6202 6352 8321 7308 11116 1573 10960 5675 6289 15280 9397 17322 9396 15447 15614 15615 17601 552 763 11696 5555 12223 61 1949 17922 7923 3028 12666 17157 10824 11169 17327 9847 11172 13032 16570 17000 7179 15448 9719 7875 7253 16247 6235 17714 17354 11712 13426 14710 15427 8718 16109 1976 18187 18018 11431 4832 17511 7140 17595 13667 11454 7223 10971 8365 17873 5934 6976 17693 12210 15112 5644 16581 797 798 1712 11988 5799 6327 6672 6674 7325 16168 8366 44 17574 16576 7222 11535 8760 5559 16166 15264 1555 13638 5994 3624 4526 1766 9892 16099 5516 5623 5636 11496 16244 10523 16537 11585 8354 17870 14564 10372 13661 1618 3552 16726 5588 6273 7395 7396 7947 15480 8621 5699 6049 367 18007 9335 2905 5517 6103 7499 8196 11350 3788 4580 5937 5962 7213 9252 17986 6136 7090 9890 7169 8399 966 5589 5626 7115 7167 10005 11697 4567 12527 15483 13147 13549 18709 6248 10823 10826 10988 7332 11090 2163 12362 10375 11289 10374 4175 10376 16678 5617 16677 16654 10997 16642 10377 10378 7558 7574 7966 14709 17321 10379 5579 6004 10380 10381 7206 3863 11430 11215 10382 10383 10384 10385 12370 12503 818 1127 11211 11212 7124 10658 11362 16565 10367 11393 3578 10621 17360 5925 17923 8734 777 17927 16167 5856 11223 7333 16165 9717 8295 10939 10368 8750 10369 13655 17308 11233 13650 10019 4217 5538 16644 5571 5581 5668 5924 16586 12366 7472 12230 17258 11463 18206 8356 8358 10370 8733 9944 620 757 1131 1994 2244 6008 6186 15228 8690 554 1801 13707 9515 7109 12921 9516 10623 18223 8703 3881 4672 16687 7274 7449 10863 8342 10371 13634 3189 10995 10828 7394 11237 16658 8387 4238 4374 5599 5775 5869 6044 7392 17951 17158 9681 1969 18500 2223 4528 10970 6161 8282 9677 9678 4474 4495 15203 9964 8361 9683 17297 18733 13662 12521 9593 9443 5956 9430 9363 7194 7212 7221 11459 8224 8264 9680 9429 747 2367 10616 5518 16734 16769 17589 16679 12844 531 5859 3 2368 2369 15465 9840 612 5813 11767 8701 8969 62 14942 4677 17271 7391 11229 13715 6409 6433 48 10856 10758 4267 4359 16573 3310 6368 4091 5860 6306 8185 8368 33 9897 164 394 10713 12662 753 9554 9470 9583 1120 1335 9854 14771 1774 1939 2185 2327 9573 10864 2971 3079 3097 10511 3123 9417 3193 14858 16609 15474 13713 15618 10998 13120 18064 4225 13565 19964 12874 16519 4801 16147 9475 14618 13623 10707 5356 17131 9574 5596 5634 5656 17947 5843 5858 5871 5878 5984 18448 10505 11799 18257 6487 9466 16188 12251 16742 17371 7004 13578 9582 16226 7244 17334 11306 7397 12228 9436 9477 17938 11405 13155 12907 9438 20010 9512 13892 13616 12644 9572 14945 9904 11417 13721 14946 8357 10716 11898 8956 8957 8958 9685 9433 16737 3167 10599 13030 4560 11149 6149 11904 7578 8374 16738 10975 9413 3637 11698 11775 11621 6046 7071 7094 7366 7487 11858 8272 8360 8536 8666 8706 8744 8751 1135 15239 11654 3818 4546 5584 5681 6196 6212 7227 7910 8714 8715 8716 8717 11252 9688 17423 18269 10683 16690 5535 5554 5563 13425 6284 7207 7553 10959 11772 10953 14720 4245 4274 12209 9412 7 18560 10983 15855 11213 5657 5935 6066 6117 6142 13615 8379 1231 1428 15639 2959 4650 4771 5531 5811 5970 5971 6374 6977 7041 15627 8766 621 1282 11662 11769 14729 11330 3849 6322 6696 9428 11042 11048 3824 16461 10956 11918 18113 5715 6593 15657 7552 7567 16458 2245 16418 10963 11483 3566 3717 3884 5638 6085 6213 12854 11384 7036 7197 7644 12934 12233 10966 10539 8580 12526 11221 2366 11650 9997 17361 6065 6313 11053 10840 8680 14251 11225 14250 10388 11183 10386 7002 7201 11192 10387 13177 11494 18674 11222 11732 12373 12510 5905 5982 16659 11774 7208 17 9705 1750 10755 11548 4615 11479 16553 5755 6080 10977 7237 7335 10752 14659 1528 2989 11481 16119 9966 16779 5567 6067 7220 10994 8675 1429 12530 17004 11815 14762 7209 13590 8221 8350 14 16 18 12887 4577 11226 12475 12239 5852 5901 6082 11903 13574 9695 7078 7447 10834 11618 10589 8691 11021 11007 12375 4122 9691 5536 13561 11224 13232 13532 619 3575 9594 13620 5519 5520 5574 13552 6209 10508 7104 7151 14871 11480 11321 14798 11230 12255 12499 17318 11540 15699 13575 16529 13596 11477 15238 13641 5583 5621 5666 5690 5760 5789 5814 5861 6081 16782 7040 7113 13593 11560 13223 8404 13544 8934 1560 11377 17146 3908 4156 16743 10748 5486 5585 5890 6281 10063 11512 16728 11003 10818 3650 15423 4558 11227 17256 5582 5667 5969 14557 12671 12742 11462 10825 11777 11372 10504 17143 10875 4244 13203 5920 5947 17193 10507 6540 10560 15440 17329 11406 18103 613 3050 15651 15523 3888 11444 11341 9708 5547 5548 5549 5716 5806 5839 6094 6343 6417 17234 7003 7099 7210 7217 7268 15064 10577 8698 980 11646 11645 16218 2982 11969 11228 16764 11492 16219 10776 14558 4662 11670 5550 5695 5720 5747 16727 6010 6069 6083 11530 7218 11655 7566 14521 17153 10503 11484 9 53 63 2548 5564 5649 5689 5748 5824 10973 5893 13753 6309 6430 7219 7349 7357 11264 12826 7921 13687 9536 8283 17544 10751 261 16688 10185 15904 11550 15478 12564 10509 11265 5537 5692 5723 5820 5849 18360 18240 12566 15209 13582 7141 16692 7555 15332 10180 10181 8967 9701 11374 10186 10187 2569 10184 10043 12563 4559 9697 11397 5605 5838 5848 5870 5891 5998 18141 6373 6587 9698 7360 7473 9700 7551 11760 8940 12560 979 10474 11367 13433 17114 10650 10392 14378 11427 10791 6206 11967 11108 15837 16693 10799 13897 9707 16657 11499 17374 8574 11485 26 399 9702 821 2237 14650 11482 3288 3688 16636 17312 11439 15463 18194 15248 5349 5485 13413 5686 5697 5712 5718 5761 5767 5787 5805 5872 5921 13427 6277 6344 6351 11735 10733 11219 13200 17102 6680 17103 10738 17459 7249 7295 13874 11992 7561 15281 12631 10350 16652 8334 11371 16117 8755 65 262 15426 1921 12903 13248 11369 11278 11127 4105 5762 5828 5926 6199 7298 12579 10356 8225 8299 12554 10860 9714 8811 103 3307 3753 3859 3909 15421 10644 11195 13499 5763 5768 5781 5801 5857 17106 9395 10538 7057 10566 10964 8373 13422 9684 694 1011 1623 9575 11102 11185 15650 4707 9561 11194 5569 5974 11214 10510 14485 13711 7927 11273 11240 8571 8765 9945 2354 10844 11543 11676 11539 5441 18335 5783 5802 5844 10635 5967 6001 15539 14376 10559 7159 12368 7174 7196 7233 11433 7355 7398 7457 16526 9483 13645 8578 270 10865 11844 3787 11098 12371 15130 5568 5573 5601 5682 5830 6053 15537 6296 10193 10200 7088 7098 16768 7381 7503 9703 11879 12231 11864 16723 8393 11582 9679 10004 8682 11288 9546 9071 17363 9694 11366 12520 11218 3439 15531 11473 13619 10795 10796 10753 5532 5693 5698 5835 5917 17190 6074 6092 6307 6316 6325 6328 6330 6335 6339 6341 6365 11217 10981 10785 7148 7568 11407 10952 16288 11616 8230 8235 8579 9692 459 1172 11684 1592 9461 11611 2996 3124 16680 15610 3416 3583 16630 4013 12457 4549 4853 14905 16090 11269 5722 5756 5769 5784 5803 5855 5999 6016 6021 10876 6295 7399 13152 11414 13722 10861 8605 8608 8693 11410 9403 1863 11100 13519 15164 17247 17532 3976 18151 4123 12360 9463 15826 11188 11408 15246 5774 15644 5955 5963 6193 6455 16709 9710 18200 6973 17487 7199 7211 7257 13675 7505 7575 8155 13696 8665 11487 18028 12213 11358 10830 17496 9850 11254 4288 4604 11472 11750 5986 6000 13546 6264 10979 11220 6957 15237 10951 8210 15078 9712 9716 14596 13172 744 779 1315 1820 12369 11713 12549 15224 3674 10544 10542 15952 13577 11184 11190 17250 5540 5572 5609 5610 17149 5676 5821 5862 5866 5985 17324 11033 6280 11699 11259 11447 10787 17245 7070 18669 7228 7234 7236 7261 14888 7362 12548 18284 18191 13630 16567 8336 8345 8370 12212 18358 10536 10543 9939 15384 8730 195 11311 10849 12465 11113 3764 3843 3879 4423 11310 5611 18215 15091 6039 15700 11028 6207 6214 6317 6574 7400 7577 8288 10969 13728 1134 10999 14998 19967 3678 11828 10813 11762 11961 12218 4556 4734 9600 11275 5625 5664 5776 5832 13178 5892 13754 17204 11067 16200 11382 6606 11038 13602 7006 15591 17248 7444 7892 16712 16417 8289 8505 10182 10183 19963 15827 15803 1118 1585 10989 10991 3262 16859 12390 11638 9419 10706 15611 11643 5580 6027 6099 11665 6195 6432 15690 15235 7054 13148 7101 15655 9530 15240 7348 9699 7471 7522 11082 14909 15831 14528 8344 8696 8906 13558 13586 2948 3828 18779 11744 11622 5659 5796 5880 11260 17201 6079 17683 6191 6338 10512 9709 15829 11186 13862 7426 9914 13220 10579 8303 8885 11963 761 17319 17202 9310 16551 2950 13162 9999 9855 3730 3732 4165 13305 4591 4665 9311 11707 11114 11995 5553 15730 5765 5850 5882 11722 5980 6200 6357 11036 15654 7354 7531 7536 9601 17140 13957 15362 10805 8301 8324 8378 8407 19290 11251 15694 12532 9629 13629 13222 12599 3304 3332 3342 18281 12236 3610 17300 16118 4169 13145 13205 4862 4900 5527 5539 5570 5591 10361 5705 18210 5792 5836 5854 6029 6077 6171 11730 11146 11635 12522 15205 7215 7241 15668 10754 8279 18336 8343 18298 8609 17161 12211 11380 14616 17243 1133 16773 9340 17115 13236 15779 13755 3919 3945 17652 11620 9598 15021 9347 5515 5530 5622 13241 5669 15303 10765 5898 15520 6034 6036 6101 15536 6210 6318 6319 13569 9625 17242 7260 17244 15607 7451 9633 9632 7645 11788 14784 8763 11970 12452 762 1136 11386 13682 3652 15407 11262 9434 20059 4621 4626 11153 10800 9982 13531 5752 5785 5845 5865 5894 17284 10514 10515 15672 7158 7203 14857 7388 13229 11861 15671 8364 10537 10719 8607 10723 10782 308 15045 11502 11914 3772 3776 3830 15390 15148 16603 11851 11915 5612 18338 5782 6057 6363 6375 17094 6994 10788 7100 7132 7142 7153 7337 7461 7964 8269 15634 11761 15059 10020 15247 9875 1763 2477 10622 12482 3174 3207 14507 12467 3536 12214 17857 16472 4109 4302 14576 4687 5247 11456 9533 15039 5558 5624 5764 5825 11014 14767 6150 6178 17551 6257 10736 6358 10880 10778 13571 10734 6741 9394 15638 17345 7044 7055 7089 7137 17239 17116 7311 7375 7393 7453 17347 17039 17349 9479 7924 13408 9534 14925 15698 8246 8276 8298 17602 8418 8531 8582 8634 15457 8695 14218 14221 8736 8843 8864 13117 8963 9109 1124 15630 17181 2657 11387 11907 15724 16322 11964 12224 4906 5754 5913 5923 13306 6240 6270 12661 6566 11805 11039 12670 15707 15592 7284 7356 7429 10958 15296 11996 14706 8389 8620 10502 8692 8749 12215 1515 1535 17964 11913 2943 3010 3082 3293 14926 3749 3877 4551 13149 5562 5575 11833 5899 5943 6011 6084 16574 6482 11110 15605 7318 10530 8667 11626 8756 8853 8860 15702 11743 832 10664 1911 9555 2604 13196 3112 11266 11565 11486 13756 13283 14595 4618 13598 13597 10986 11268 17519 5673 5706 6068 6197 6254 16681 6283 6288 6290 11700 7012 11574 7061 12225 7138 11985 9706 15727 15278 16643 8227 15688 8339 18340 8392 15087 8674 18129 8849 17179 8945 10784 13570 10764 9529 11745 3040 17333 15637 3822 4382 4641 10794 11267 15723 11457 5728 5773 5948 5990 17184 6198 6204 6220 11766 6293 6362 6557 11968 16774 15624 12232 7939 15756 16683 14256 8369 18219 14745 8623 16637 8876 8997 9029 11442 16460 13554 11255 11741 13698 13758 14249 11019 5972 6089 6175 6286 13566 6563 7107 15828 15712 15715 7177 7313 17253 11441 16563 ] |
| 4 | 16.81 ms |
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:
[] |
| 5 | 30.11 ms |
SELECT DISTINCT h0_.id AS id_0, h0_.discovery_year1 AS discovery_year1_1 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)) ORDER BY h0_.discovery_year1 ASC LIMIT 20
Parameters:
[] |
| 6 | 1.67 ms |
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)) ORDER BY h0_.discovery_year1 ASC
Parameters:
[ 1058 198 1330 23 1325 644 555 457 1132 1117 266 1332 265 153 200 1373 1331 6 463 264 ] |
| 7 | 0.19 ms |
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:
[] |
| 8 | 6.50 ms |
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:
[] |
| 9 | 0.18 ms |
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:
[] |
| 10 | 3.54 ms |
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:
[] |
| 11 | 5.47 ms |
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:
[] |
| 12 | 3.97 ms |
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:
[] |
| 13 | 0.34 ms |
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:
[] |
| 14 | 0.65 ms |
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:
[] |
| 15 | 7.87 ms |
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:
[] |
| 16 | 0.17 ms |
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:
[] |
| 17 | 0.15 ms |
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:
[] |
| 18 | 0.13 ms |
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:
[] |
| 19 | 0.12 ms |
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:
[] |
| 20 | 6.47 ms |
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:
[] |
| 21 | 0.15 ms |
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:
[] |
| 22 | 0.15 ms |
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:
[] |
| 23 | 0.12 ms |
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:
[] |
| 24 | 0.22 ms |
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:
[] |
| 25 | 5.50 ms |
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:
[] |
| 26 | 0.14 ms |
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:
[] |
| 27 | 2.23 ms |
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:
[] |
| 28 | 13.53 ms |
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:
[] |
| 29 | 14.61 ms |
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:
[] |
| 30 | 7.35 ms |
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:
[] |
| 31 | 0.36 ms |
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:
[] |
| 32 | 1.42 ms |
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:
[] |
| 33 | 0.33 ms |
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:
[] |
| 34 | 115.99 ms |
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:
[] |
| 35 | 0.26 ms |
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:
[] |
| 36 | 35.29 ms |
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:
[] |
| 37 | 0.25 ms |
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:
[] |
| 38 | 0.14 ms |
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:
[] |
| 39 | 0.16 ms |
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:
[] |
| 40 | 0.34 ms |
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:
[] |
| 41 | 0.22 ms |
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:
[] |
| 42 | 6.74 ms |
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:
[] |
| 43 | 0.83 ms |
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:
[] |
| 44 | 0.20 ms |
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:
[] |
| 45 | 0.27 ms |
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:
[] |
| 46 | 0.24 ms |
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:
[] |
| 47 | 0.20 ms |
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:
[] |
| 48 | 3.60 ms |
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:
[] |
| 49 | 0.46 ms |
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:
[] |
| 50 | 1.77 ms |
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:
[] |
| 51 | 0.36 ms |
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:
[] |
| 52 | 0.19 ms |
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:
[] |
| 53 | 51.14 ms |
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:
[] |
| 54 | 1.07 ms |
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:
[] |
| 55 | 0.54 ms |
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:
[] |
| 56 | 0.82 ms |
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:
[
6
]
|
| 57 | 0.51 ms |
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:
[
6
]
|
| 58 | 0.52 ms |
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:
[
264
]
|
| 59 | 0.41 ms |
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:
[
264
]
|
| 60 | 0.52 ms |
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:
[
265
]
|
| 61 | 0.40 ms |
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:
[
265
]
|
| 62 | 0.54 ms |
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:
[
266
]
|
| 63 | 0.38 ms |
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:
[
266
]
|
| 64 | 0.56 ms |
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:
[
23
]
|
| 65 | 0.38 ms |
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:
[
23
]
|
| 66 | 0.47 ms |
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:
[
1058
]
|
| 67 | 0.42 ms |
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:
[
1058
]
|
| 68 | 0.56 ms |
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:
[
555
]
|
| 69 | 0.40 ms |
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:
[
555
]
|
| 70 | 0.49 ms |
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:
[
1325
]
|
| 71 | 0.39 ms |
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:
[
1325
]
|
| 72 | 0.54 ms |
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:
[
1330
]
|
| 73 | 0.38 ms |
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:
[
1330
]
|
| 74 | 0.55 ms |
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:
[
1331
]
|
| 75 | 0.30 ms |
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:
[
1331
]
|
| 76 | 0.32 ms |
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:
[
1332
]
|
| 77 | 0.25 ms |
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:
[
1332
]
|
| 78 | 0.31 ms |
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:
[
1117
]
|
| 79 | 0.24 ms |
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:
[
1117
]
|
| 80 | 0.32 ms |
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:
[
1373
]
|
| 81 | 0.25 ms |
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:
[
1373
]
|
| 82 | 0.31 ms |
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:
[
1132
]
|
| 83 | 0.24 ms |
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:
[
1132
]
|
| 84 | 0.34 ms |
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:
[
644
]
|
| 85 | 0.26 ms |
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:
[
644
]
|
| 86 | 0.33 ms |
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:
[
153
]
|
| 87 | 0.25 ms |
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:
[
153
]
|
| 88 | 0.40 ms |
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:
[
198
]
|
| 89 | 0.26 ms |
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:
[
198
]
|
| 90 | 0.46 ms |
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:
[
200
]
|
| 91 | 0.26 ms |
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:
[
200
]
|
| 92 | 0.34 ms |
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:
[
457
]
|
| 93 | 0.25 ms |
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:
[
457
]
|
| 94 | 0.32 ms |
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:
[
463
]
|
| 95 | 0.18 ms |
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:
[
463
]
|
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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| App\Ox\HoardBundle\Entity\ArchaeologySiteContextDetail |
|
| App\Ox\HoardBundle\Entity\ArchaeologyContextNature |
|
| App\Ox\HoardBundle\Entity\Reference | No errors. |
| App\Ox\HoardBundle\Entity\ReferenceType | No errors. |
| App\Ox\HoardBundle\Entity\Period |
|
| 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 |
|
| App\Ox\HoardBundle\Entity\Aspect | No errors. |
| App\Ox\HoardBundle\Entity\Condition |
|
| 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. |