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