Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

408.24 ms Query time

6 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.76 ms	SELECT t0.id AS id_1, t0.find_spot_name AS find_spot_name_2, t0.find_spot_other_names AS find_spot_other_names_3, t0.address AS address_4, t0.city AS city_5, t0.county AS county_6, t0.region AS region_7, t0.find_spot_latitude AS find_spot_latitude_8, t0.find_spot_longitude AS find_spot_longitude_9, t0.find_spot_altitude AS find_spot_altitude_10, t0.find_spot_comment AS find_spot_comment_11, t0.discovery_day1 AS discovery_day1_12, t0.discovery_month1 AS discovery_month1_13, t0.discovery_year1 AS discovery_year1_14, t0.discovery_day2 AS discovery_day2_15, t0.discovery_month2 AS discovery_month2_16, t0.discovery_year2 AS discovery_year2_17, t0.opening_year1 AS opening_year1_18, t0.opening_year2 AS opening_year2_19, t0.terminal_year1 AS terminal_year1_20, t0.terminal_year2 AS terminal_year2_21, t0.reference_string AS reference_string_22, t0.discovery_depth AS discovery_depth_23, t0.owner AS owner_24, t0.finder AS finder_25, t0.discovery_comment AS discovery_comment_26, t0.archaeology_start_year AS archaeology_start_year_27, t0.archaeology_end_year AS archaeology_end_year_28, t0.archaeology_natural_features AS archaeology_natural_features_29, t0.archaeology_site_comment AS archaeology_site_comment_30, t0.archaeology_context_date1 AS archaeology_context_date1_31, t0.archaeology_context_date2 AS archaeology_context_date2_32, t0.archaeology_associated_features AS archaeology_associated_features_33, t0.rating_comment AS rating_comment_34, t0.validated_by_user AS validated_by_user_35, t0.validated_by_admin AS validated_by_admin_36, t0.coin_data_validated_by_user AS coin_data_validated_by_user_37, t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38, t0.deleted AS deleted_39, t0.deletedAt AS deletedAt_40, t0.hide_location AS hide_location_41, t0.hide_city AS hide_city_42, t0.hide_county AS hide_county_43, t0.hide_finder AS hide_finder_44, t0.credit AS credit_45, t0.redirect_to_hoard AS redirect_to_hoard_46, t0.internal_note AS internal_note_47, t0.creation_date AS creation_date_48, t0.modified_date AS modified_date_49, t0.comment AS comment_50, t0.coin_level_data_id AS coin_level_data_id_51, t0.hoard_type_id AS hoard_type_id_52, t0.province_id AS province_id_53, t0.find_spot_location_detail_id AS find_spot_location_detail_id_54, t0.ancient_place_id AS ancient_place_id_55, t0.closing_reign1_id AS closing_reign1_id_56, t0.closing_reign2_id AS closing_reign2_id_57, t0.discovery_method_id AS discovery_method_id_58, t0.discovery_land_use_id AS discovery_land_use_id_59, t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60, t0.archaeology_site_context_id AS archaeology_site_context_id_61, t0.archaeology_period_id AS archaeology_period_id_62, t0.archaeology_end_period_id AS archaeology_end_period_id_63, t0.find_spot_rating_id AS find_spot_rating_id_64, t0.contextual_rating_id AS contextual_rating_id_65, t0.rating_id AS rating_id_66, t0.hide_what_id AS hide_what_id_67, t0.hide_from_id AS hide_from_id_68, t0.created_by AS created_by_69, t0.modified_by AS modified_by_70 FROM hoard t0 WHERE t0.id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP))) Parameters: [`"3943"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.find_spot_name AS find_spot_name_2, t0.find_spot_other_names AS find_spot_other_names_3, t0.address AS address_4, t0.city AS city_5, t0.county AS county_6, t0.region AS region_7, t0.find_spot_latitude AS find_spot_latitude_8, t0.find_spot_longitude AS find_spot_longitude_9, t0.find_spot_altitude AS find_spot_altitude_10, t0.find_spot_comment AS find_spot_comment_11, t0.discovery_day1 AS discovery_day1_12, t0.discovery_month1 AS discovery_month1_13, t0.discovery_year1 AS discovery_year1_14, t0.discovery_day2 AS discovery_day2_15, t0.discovery_month2 AS discovery_month2_16, t0.discovery_year2 AS discovery_year2_17, t0.opening_year1 AS opening_year1_18, t0.opening_year2 AS opening_year2_19, t0.terminal_year1 AS terminal_year1_20, t0.terminal_year2 AS terminal_year2_21, t0.reference_string AS reference_string_22, t0.discovery_depth AS discovery_depth_23, t0.owner AS owner_24, t0.finder AS finder_25, t0.discovery_comment AS discovery_comment_26, t0.archaeology_start_year AS archaeology_start_year_27, t0.archaeology_end_year AS archaeology_end_year_28, t0.archaeology_natural_features AS archaeology_natural_features_29, t0.archaeology_site_comment AS archaeology_site_comment_30, t0.archaeology_context_date1 AS archaeology_context_date1_31, t0.archaeology_context_date2 AS archaeology_context_date2_32, t0.archaeology_associated_features AS archaeology_associated_features_33, t0.rating_comment AS rating_comment_34, t0.validated_by_user AS validated_by_user_35, t0.validated_by_admin AS validated_by_admin_36, t0.coin_data_validated_by_user AS coin_data_validated_by_user_37, t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38, t0.deleted AS deleted_39, t0.deletedAt AS deletedAt_40, t0.hide_location AS hide_location_41, t0.hide_city AS hide_city_42, t0.hide_county AS hide_county_43, t0.hide_finder AS hide_finder_44, t0.credit AS credit_45, t0.redirect_to_hoard AS redirect_to_hoard_46, t0.internal_note AS internal_note_47, t0.creation_date AS creation_date_48, t0.modified_date AS modified_date_49, t0.comment AS comment_50, t0.coin_level_data_id AS coin_level_data_id_51, t0.hoard_type_id AS hoard_type_id_52, t0.province_id AS province_id_53, t0.find_spot_location_detail_id AS find_spot_location_detail_id_54, t0.ancient_place_id AS ancient_place_id_55, t0.closing_reign1_id AS closing_reign1_id_56, t0.closing_reign2_id AS closing_reign2_id_57, t0.discovery_method_id AS discovery_method_id_58, t0.discovery_land_use_id AS discovery_land_use_id_59, t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60, t0.archaeology_site_context_id AS archaeology_site_context_id_61, t0.archaeology_period_id AS archaeology_period_id_62, t0.archaeology_end_period_id AS archaeology_end_period_id_63, t0.find_spot_rating_id AS find_spot_rating_id_64, t0.contextual_rating_id AS contextual_rating_id_65, t0.rating_id AS rating_id_66, t0.hide_what_id AS hide_what_id_67, t0.hide_from_id AS hide_from_id_68, t0.created_by AS created_by_69, t0.modified_by AS modified_by_70 FROM hoard t0 WHERE t0.id = ? AND ( ( ( t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP ) ) ) SELECT t0.id AS id_1, t0.find_spot_name AS find_spot_name_2, t0.find_spot_other_names AS find_spot_other_names_3, t0.address AS address_4, t0.city AS city_5, t0.county AS county_6, t0.region AS region_7, t0.find_spot_latitude AS find_spot_latitude_8, t0.find_spot_longitude AS find_spot_longitude_9, t0.find_spot_altitude AS find_spot_altitude_10, t0.find_spot_comment AS find_spot_comment_11, t0.discovery_day1 AS discovery_day1_12, t0.discovery_month1 AS discovery_month1_13, t0.discovery_year1 AS discovery_year1_14, t0.discovery_day2 AS discovery_day2_15, t0.discovery_month2 AS discovery_month2_16, t0.discovery_year2 AS discovery_year2_17, t0.opening_year1 AS opening_year1_18, t0.opening_year2 AS opening_year2_19, t0.terminal_year1 AS terminal_year1_20, t0.terminal_year2 AS terminal_year2_21, t0.reference_string AS reference_string_22, t0.discovery_depth AS discovery_depth_23, t0.owner AS owner_24, t0.finder AS finder_25, t0.discovery_comment AS discovery_comment_26, t0.archaeology_start_year AS archaeology_start_year_27, t0.archaeology_end_year AS archaeology_end_year_28, t0.archaeology_natural_features AS archaeology_natural_features_29, t0.archaeology_site_comment AS archaeology_site_comment_30, t0.archaeology_context_date1 AS archaeology_context_date1_31, t0.archaeology_context_date2 AS archaeology_context_date2_32, t0.archaeology_associated_features AS archaeology_associated_features_33, t0.rating_comment AS rating_comment_34, t0.validated_by_user AS validated_by_user_35, t0.validated_by_admin AS validated_by_admin_36, t0.coin_data_validated_by_user AS coin_data_validated_by_user_37, t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38, t0.deleted AS deleted_39, t0.deletedAt AS deletedAt_40, t0.hide_location AS hide_location_41, t0.hide_city AS hide_city_42, t0.hide_county AS hide_county_43, t0.hide_finder AS hide_finder_44, t0.credit AS credit_45, t0.redirect_to_hoard AS redirect_to_hoard_46, t0.internal_note AS internal_note_47, t0.creation_date AS creation_date_48, t0.modified_date AS modified_date_49, t0.comment AS comment_50, t0.coin_level_data_id AS coin_level_data_id_51, t0.hoard_type_id AS hoard_type_id_52, t0.province_id AS province_id_53, t0.find_spot_location_detail_id AS find_spot_location_detail_id_54, t0.ancient_place_id AS ancient_place_id_55, t0.closing_reign1_id AS closing_reign1_id_56, t0.closing_reign2_id AS closing_reign2_id_57, t0.discovery_method_id AS discovery_method_id_58, t0.discovery_land_use_id AS discovery_land_use_id_59, t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60, t0.archaeology_site_context_id AS archaeology_site_context_id_61, t0.archaeology_period_id AS archaeology_period_id_62, t0.archaeology_end_period_id AS archaeology_end_period_id_63, t0.find_spot_rating_id AS find_spot_rating_id_64, t0.contextual_rating_id AS contextual_rating_id_65, t0.rating_id AS rating_id_66, t0.hide_what_id AS hide_what_id_67, t0.hide_from_id AS hide_from_id_68, t0.created_by AS created_by_69, t0.modified_by AS modified_by_70 FROM hoard t0 WHERE t0.id = '3943' AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)));
2	407.48 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, h1_.id AS id_50, h1_.hoard_type AS hoard_type_51, h2_.hoard_id AS hoard_id_52, h2_.coin_count AS coin_count_53, c3_.id AS id_54, c3_.country AS country_55, p4_.id AS id_56, p4_.province AS province_57, a5_.id AS id_58, a5_.ancientPlace AS ancientPlace_59, f6_.id AS id_60, f6_.find_spot_location_detail AS find_spot_location_detail_61, r7_.id AS id_62, r7_.reign AS reign_63, r8_.id AS id_64, r8_.reign AS reign_65, d9_.id AS id_66, d9_.discovery_method AS discovery_method_67, d10_.id AS id_68, d10_.discovery_land_use AS discovery_land_use_69, a11_.id AS id_70, a11_.archaeology_recovery_method AS archaeology_recovery_method_71, a12_.id AS id_72, a12_.archaeology_site_context AS archaeology_site_context_73, a13_.id AS id_74, a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75, a14_.id AS id_76, a14_.archaeology_period AS archaeology_period_77, a15_.id AS id_78, a15_.archaeology_context_nature AS archaeology_context_nature_79, a16_.id AS id_80, a16_.archaeology_period AS archaeology_period_81, r17_.id AS id_82, r17_.rating AS rating_83, r18_.id AS id_84, r18_.rating AS rating_85, r19_.id AS id_86, r19_.rating AS rating_87, c20_.id AS id_88, c20_.container AS container_89, o21_.id AS id_90, o21_.object AS object_91, c22_.id AS id_92, c22_.coin_level_data AS coin_level_data_93, h23_.id AS id_94, h23_.reference AS reference_95, r24_.id AS id_96, r24_.authors AS authors_97, r24_.title AS title_98, r24_.year AS year_99, r24_.abbreviation AS abbreviation_100, r25_.id AS id_101 FROM hoard h0_ LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id LEFT JOIN country c3_ ON c3_.id = h26_.country_id LEFT JOIN province p4_ ON h0_.province_id = p4_.id LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id AND (c20_.deletedAt IS NULL) LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id AND (o21_.deletedAt IS NULL) LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id AND ((h23_.deletedAt IS NULL OR h23_.deletedAt > CURRENT_TIMESTAMP)) LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id AND (r24_.deletedAt IS NULL) LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id WHERE (h0_.id = ?) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP)) Parameters: [`3943`] View formatted query View runnable query Explain query 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, h1_.id AS id_50, h1_.hoard_type AS hoard_type_51, h2_.hoard_id AS hoard_id_52, h2_.coin_count AS coin_count_53, c3_.id AS id_54, c3_.country AS country_55, p4_.id AS id_56, p4_.province AS province_57, a5_.id AS id_58, a5_.ancientPlace AS ancientPlace_59, f6_.id AS id_60, f6_.find_spot_location_detail AS find_spot_location_detail_61, r7_.id AS id_62, r7_.reign AS reign_63, r8_.id AS id_64, r8_.reign AS reign_65, d9_.id AS id_66, d9_.discovery_method AS discovery_method_67, d10_.id AS id_68, d10_.discovery_land_use AS discovery_land_use_69, a11_.id AS id_70, a11_.archaeology_recovery_method AS archaeology_recovery_method_71, a12_.id AS id_72, a12_.archaeology_site_context AS archaeology_site_context_73, a13_.id AS id_74, a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75, a14_.id AS id_76, a14_.archaeology_period AS archaeology_period_77, a15_.id AS id_78, a15_.archaeology_context_nature AS archaeology_context_nature_79, a16_.id AS id_80, a16_.archaeology_period AS archaeology_period_81, r17_.id AS id_82, r17_.rating AS rating_83, r18_.id AS id_84, r18_.rating AS rating_85, r19_.id AS id_86, r19_.rating AS rating_87, c20_.id AS id_88, c20_.container AS container_89, o21_.id AS id_90, o21_.object AS object_91, c22_.id AS id_92, c22_.coin_level_data AS coin_level_data_93, h23_.id AS id_94, h23_.reference AS reference_95, r24_.id AS id_96, r24_.authors AS authors_97, r24_.title AS title_98, r24_.year AS year_99, r24_.abbreviation AS abbreviation_100, r25_.id AS id_101 FROM hoard h0_ LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id LEFT JOIN country c3_ ON c3_.id = h26_.country_id LEFT JOIN province p4_ ON h0_.province_id = p4_.id LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id AND (c20_.deletedAt IS NULL) LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id AND (o21_.deletedAt IS NULL) LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id AND ( ( h23_.deletedAt IS NULL OR h23_.deletedAt > CURRENT_TIMESTAMP ) ) LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id AND (r24_.deletedAt IS NULL) LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id WHERE (h0_.id = ?) AND ( ( h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP ) ) 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, h1_.id AS id_50, h1_.hoard_type AS hoard_type_51, h2_.hoard_id AS hoard_id_52, h2_.coin_count AS coin_count_53, c3_.id AS id_54, c3_.country AS country_55, p4_.id AS id_56, p4_.province AS province_57, a5_.id AS id_58, a5_.ancientPlace AS ancientPlace_59, f6_.id AS id_60, f6_.find_spot_location_detail AS find_spot_location_detail_61, r7_.id AS id_62, r7_.reign AS reign_63, r8_.id AS id_64, r8_.reign AS reign_65, d9_.id AS id_66, d9_.discovery_method AS discovery_method_67, d10_.id AS id_68, d10_.discovery_land_use AS discovery_land_use_69, a11_.id AS id_70, a11_.archaeology_recovery_method AS archaeology_recovery_method_71, a12_.id AS id_72, a12_.archaeology_site_context AS archaeology_site_context_73, a13_.id AS id_74, a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75, a14_.id AS id_76, a14_.archaeology_period AS archaeology_period_77, a15_.id AS id_78, a15_.archaeology_context_nature AS archaeology_context_nature_79, a16_.id AS id_80, a16_.archaeology_period AS archaeology_period_81, r17_.id AS id_82, r17_.rating AS rating_83, r18_.id AS id_84, r18_.rating AS rating_85, r19_.id AS id_86, r19_.rating AS rating_87, c20_.id AS id_88, c20_.container AS container_89, o21_.id AS id_90, o21_.object AS object_91, c22_.id AS id_92, c22_.coin_level_data AS coin_level_data_93, h23_.id AS id_94, h23_.reference AS reference_95, r24_.id AS id_96, r24_.authors AS authors_97, r24_.title AS title_98, r24_.year AS year_99, r24_.abbreviation AS abbreviation_100, r25_.id AS id_101 FROM hoard h0_ LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id LEFT JOIN country c3_ ON c3_.id = h26_.country_id LEFT JOIN province p4_ ON h0_.province_id = p4_.id LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id AND (c20_.deletedAt IS NULL) LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id AND (o21_.deletedAt IS NULL) LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id AND ((h23_.deletedAt IS NULL OR h23_.deletedAt > CURRENT_TIMESTAMP)) LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id AND (r24_.deletedAt IS NULL) LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id WHERE (h0_.id = 3943) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP));

#▲

Time

Info

0.76 ms

SELECT t0.id AS id_1, t0.find_spot_name AS find_spot_name_2, t0.find_spot_other_names AS find_spot_other_names_3, t0.address AS address_4, t0.city AS city_5, t0.county AS county_6, t0.region AS region_7, t0.find_spot_latitude AS find_spot_latitude_8, t0.find_spot_longitude AS find_spot_longitude_9, t0.find_spot_altitude AS find_spot_altitude_10, t0.find_spot_comment AS find_spot_comment_11, t0.discovery_day1 AS discovery_day1_12, t0.discovery_month1 AS discovery_month1_13, t0.discovery_year1 AS discovery_year1_14, t0.discovery_day2 AS discovery_day2_15, t0.discovery_month2 AS discovery_month2_16, t0.discovery_year2 AS discovery_year2_17, t0.opening_year1 AS opening_year1_18, t0.opening_year2 AS opening_year2_19, t0.terminal_year1 AS terminal_year1_20, t0.terminal_year2 AS terminal_year2_21, t0.reference_string AS reference_string_22, t0.discovery_depth AS discovery_depth_23, t0.owner AS owner_24, t0.finder AS finder_25, t0.discovery_comment AS discovery_comment_26, t0.archaeology_start_year AS archaeology_start_year_27, t0.archaeology_end_year AS archaeology_end_year_28, t0.archaeology_natural_features AS archaeology_natural_features_29, t0.archaeology_site_comment AS archaeology_site_comment_30, t0.archaeology_context_date1 AS archaeology_context_date1_31, t0.archaeology_context_date2 AS archaeology_context_date2_32, t0.archaeology_associated_features AS archaeology_associated_features_33, t0.rating_comment AS rating_comment_34, t0.validated_by_user AS validated_by_user_35, t0.validated_by_admin AS validated_by_admin_36, t0.coin_data_validated_by_user AS coin_data_validated_by_user_37, t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38, t0.deleted AS deleted_39, t0.deletedAt AS deletedAt_40, t0.hide_location AS hide_location_41, t0.hide_city AS hide_city_42, t0.hide_county AS hide_county_43, t0.hide_finder AS hide_finder_44, t0.credit AS credit_45, t0.redirect_to_hoard AS redirect_to_hoard_46, t0.internal_note AS internal_note_47, t0.creation_date AS creation_date_48, t0.modified_date AS modified_date_49, t0.comment AS comment_50, t0.coin_level_data_id AS coin_level_data_id_51, t0.hoard_type_id AS hoard_type_id_52, t0.province_id AS province_id_53, t0.find_spot_location_detail_id AS find_spot_location_detail_id_54, t0.ancient_place_id AS ancient_place_id_55, t0.closing_reign1_id AS closing_reign1_id_56, t0.closing_reign2_id AS closing_reign2_id_57, t0.discovery_method_id AS discovery_method_id_58, t0.discovery_land_use_id AS discovery_land_use_id_59, t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60, t0.archaeology_site_context_id AS archaeology_site_context_id_61, t0.archaeology_period_id AS archaeology_period_id_62, t0.archaeology_end_period_id AS archaeology_end_period_id_63, t0.find_spot_rating_id AS find_spot_rating_id_64, t0.contextual_rating_id AS contextual_rating_id_65, t0.rating_id AS rating_id_66, t0.hide_what_id AS hide_what_id_67, t0.hide_from_id AS hide_from_id_68, t0.created_by AS created_by_69, t0.modified_by AS modified_by_70 FROM hoard t0 WHERE t0.id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))

Parameters:

[
  "3943"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.find_spot_name AS find_spot_name_2,
  t0.find_spot_other_names AS find_spot_other_names_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.county AS county_6,
  t0.region AS region_7,
  t0.find_spot_latitude AS find_spot_latitude_8,
  t0.find_spot_longitude AS find_spot_longitude_9,
  t0.find_spot_altitude AS find_spot_altitude_10,
  t0.find_spot_comment AS find_spot_comment_11,
  t0.discovery_day1 AS discovery_day1_12,
  t0.discovery_month1 AS discovery_month1_13,
  t0.discovery_year1 AS discovery_year1_14,
  t0.discovery_day2 AS discovery_day2_15,
  t0.discovery_month2 AS discovery_month2_16,
  t0.discovery_year2 AS discovery_year2_17,
  t0.opening_year1 AS opening_year1_18,
  t0.opening_year2 AS opening_year2_19,
  t0.terminal_year1 AS terminal_year1_20,
  t0.terminal_year2 AS terminal_year2_21,
  t0.reference_string AS reference_string_22,
  t0.discovery_depth AS discovery_depth_23,
  t0.owner AS owner_24,
  t0.finder AS finder_25,
  t0.discovery_comment AS discovery_comment_26,
  t0.archaeology_start_year AS archaeology_start_year_27,
  t0.archaeology_end_year AS archaeology_end_year_28,
  t0.archaeology_natural_features AS archaeology_natural_features_29,
  t0.archaeology_site_comment AS archaeology_site_comment_30,
  t0.archaeology_context_date1 AS archaeology_context_date1_31,
  t0.archaeology_context_date2 AS archaeology_context_date2_32,
  t0.archaeology_associated_features AS archaeology_associated_features_33,
  t0.rating_comment AS rating_comment_34,
  t0.validated_by_user AS validated_by_user_35,
  t0.validated_by_admin AS validated_by_admin_36,
  t0.coin_data_validated_by_user AS coin_data_validated_by_user_37,
  t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38,
  t0.deleted AS deleted_39,
  t0.deletedAt AS deletedAt_40,
  t0.hide_location AS hide_location_41,
  t0.hide_city AS hide_city_42,
  t0.hide_county AS hide_county_43,
  t0.hide_finder AS hide_finder_44,
  t0.credit AS credit_45,
  t0.redirect_to_hoard AS redirect_to_hoard_46,
  t0.internal_note AS internal_note_47,
  t0.creation_date AS creation_date_48,
  t0.modified_date AS modified_date_49,
  t0.comment AS comment_50,
  t0.coin_level_data_id AS coin_level_data_id_51,
  t0.hoard_type_id AS hoard_type_id_52,
  t0.province_id AS province_id_53,
  t0.find_spot_location_detail_id AS find_spot_location_detail_id_54,
  t0.ancient_place_id AS ancient_place_id_55,
  t0.closing_reign1_id AS closing_reign1_id_56,
  t0.closing_reign2_id AS closing_reign2_id_57,
  t0.discovery_method_id AS discovery_method_id_58,
  t0.discovery_land_use_id AS discovery_land_use_id_59,
  t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60,
  t0.archaeology_site_context_id AS archaeology_site_context_id_61,
  t0.archaeology_period_id AS archaeology_period_id_62,
  t0.archaeology_end_period_id AS archaeology_end_period_id_63,
  t0.find_spot_rating_id AS find_spot_rating_id_64,
  t0.contextual_rating_id AS contextual_rating_id_65,
  t0.rating_id AS rating_id_66,
  t0.hide_what_id AS hide_what_id_67,
  t0.hide_from_id AS hide_from_id_68,
  t0.created_by AS created_by_69,
  t0.modified_by AS modified_by_70
FROM
  hoard t0
WHERE
  t0.id = ?
  AND (
    (
      (
        t0.deletedAt IS NULL
        OR t0.deletedAt > CURRENT_TIMESTAMP
      )
    )
  )

SELECT t0.id AS id_1, t0.find_spot_name AS find_spot_name_2, t0.find_spot_other_names AS find_spot_other_names_3, t0.address AS address_4, t0.city AS city_5, t0.county AS county_6, t0.region AS region_7, t0.find_spot_latitude AS find_spot_latitude_8, t0.find_spot_longitude AS find_spot_longitude_9, t0.find_spot_altitude AS find_spot_altitude_10, t0.find_spot_comment AS find_spot_comment_11, t0.discovery_day1 AS discovery_day1_12, t0.discovery_month1 AS discovery_month1_13, t0.discovery_year1 AS discovery_year1_14, t0.discovery_day2 AS discovery_day2_15, t0.discovery_month2 AS discovery_month2_16, t0.discovery_year2 AS discovery_year2_17, t0.opening_year1 AS opening_year1_18, t0.opening_year2 AS opening_year2_19, t0.terminal_year1 AS terminal_year1_20, t0.terminal_year2 AS terminal_year2_21, t0.reference_string AS reference_string_22, t0.discovery_depth AS discovery_depth_23, t0.owner AS owner_24, t0.finder AS finder_25, t0.discovery_comment AS discovery_comment_26, t0.archaeology_start_year AS archaeology_start_year_27, t0.archaeology_end_year AS archaeology_end_year_28, t0.archaeology_natural_features AS archaeology_natural_features_29, t0.archaeology_site_comment AS archaeology_site_comment_30, t0.archaeology_context_date1 AS archaeology_context_date1_31, t0.archaeology_context_date2 AS archaeology_context_date2_32, t0.archaeology_associated_features AS archaeology_associated_features_33, t0.rating_comment AS rating_comment_34, t0.validated_by_user AS validated_by_user_35, t0.validated_by_admin AS validated_by_admin_36, t0.coin_data_validated_by_user AS coin_data_validated_by_user_37, t0.coin_data_validated_by_admin AS coin_data_validated_by_admin_38, t0.deleted AS deleted_39, t0.deletedAt AS deletedAt_40, t0.hide_location AS hide_location_41, t0.hide_city AS hide_city_42, t0.hide_county AS hide_county_43, t0.hide_finder AS hide_finder_44, t0.credit AS credit_45, t0.redirect_to_hoard AS redirect_to_hoard_46, t0.internal_note AS internal_note_47, t0.creation_date AS creation_date_48, t0.modified_date AS modified_date_49, t0.comment AS comment_50, t0.coin_level_data_id AS coin_level_data_id_51, t0.hoard_type_id AS hoard_type_id_52, t0.province_id AS province_id_53, t0.find_spot_location_detail_id AS find_spot_location_detail_id_54, t0.ancient_place_id AS ancient_place_id_55, t0.closing_reign1_id AS closing_reign1_id_56, t0.closing_reign2_id AS closing_reign2_id_57, t0.discovery_method_id AS discovery_method_id_58, t0.discovery_land_use_id AS discovery_land_use_id_59, t0.archaeology_recovery_method_id AS archaeology_recovery_method_id_60, t0.archaeology_site_context_id AS archaeology_site_context_id_61, t0.archaeology_period_id AS archaeology_period_id_62, t0.archaeology_end_period_id AS archaeology_end_period_id_63, t0.find_spot_rating_id AS find_spot_rating_id_64, t0.contextual_rating_id AS contextual_rating_id_65, t0.rating_id AS rating_id_66, t0.hide_what_id AS hide_what_id_67, t0.hide_from_id AS hide_from_id_68, t0.created_by AS created_by_69, t0.modified_by AS modified_by_70 FROM hoard t0 WHERE t0.id = '3943' AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)));

407.48 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, h1_.id AS id_50, h1_.hoard_type AS hoard_type_51, h2_.hoard_id AS hoard_id_52, h2_.coin_count AS coin_count_53, c3_.id AS id_54, c3_.country AS country_55, p4_.id AS id_56, p4_.province AS province_57, a5_.id AS id_58, a5_.ancientPlace AS ancientPlace_59, f6_.id AS id_60, f6_.find_spot_location_detail AS find_spot_location_detail_61, r7_.id AS id_62, r7_.reign AS reign_63, r8_.id AS id_64, r8_.reign AS reign_65, d9_.id AS id_66, d9_.discovery_method AS discovery_method_67, d10_.id AS id_68, d10_.discovery_land_use AS discovery_land_use_69, a11_.id AS id_70, a11_.archaeology_recovery_method AS archaeology_recovery_method_71, a12_.id AS id_72, a12_.archaeology_site_context AS archaeology_site_context_73, a13_.id AS id_74, a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75, a14_.id AS id_76, a14_.archaeology_period AS archaeology_period_77, a15_.id AS id_78, a15_.archaeology_context_nature AS archaeology_context_nature_79, a16_.id AS id_80, a16_.archaeology_period AS archaeology_period_81, r17_.id AS id_82, r17_.rating AS rating_83, r18_.id AS id_84, r18_.rating AS rating_85, r19_.id AS id_86, r19_.rating AS rating_87, c20_.id AS id_88, c20_.container AS container_89, o21_.id AS id_90, o21_.object AS object_91, c22_.id AS id_92, c22_.coin_level_data AS coin_level_data_93, h23_.id AS id_94, h23_.reference AS reference_95, r24_.id AS id_96, r24_.authors AS authors_97, r24_.title AS title_98, r24_.year AS year_99, r24_.abbreviation AS abbreviation_100, r25_.id AS id_101 FROM hoard h0_ LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id LEFT JOIN country c3_ ON c3_.id = h26_.country_id LEFT JOIN province p4_ ON h0_.province_id = p4_.id LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id AND (c20_.deletedAt IS NULL) LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id AND (o21_.deletedAt IS NULL) LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id AND ((h23_.deletedAt IS NULL OR h23_.deletedAt > CURRENT_TIMESTAMP)) LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id AND (r24_.deletedAt IS NULL) LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id WHERE (h0_.id = ?) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))

Parameters:

[
  3943
]

View formatted query View runnable query Explain query

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,
  h1_.id AS id_50,
  h1_.hoard_type AS hoard_type_51,
  h2_.hoard_id AS hoard_id_52,
  h2_.coin_count AS coin_count_53,
  c3_.id AS id_54,
  c3_.country AS country_55,
  p4_.id AS id_56,
  p4_.province AS province_57,
  a5_.id AS id_58,
  a5_.ancientPlace AS ancientPlace_59,
  f6_.id AS id_60,
  f6_.find_spot_location_detail AS find_spot_location_detail_61,
  r7_.id AS id_62,
  r7_.reign AS reign_63,
  r8_.id AS id_64,
  r8_.reign AS reign_65,
  d9_.id AS id_66,
  d9_.discovery_method AS discovery_method_67,
  d10_.id AS id_68,
  d10_.discovery_land_use AS discovery_land_use_69,
  a11_.id AS id_70,
  a11_.archaeology_recovery_method AS archaeology_recovery_method_71,
  a12_.id AS id_72,
  a12_.archaeology_site_context AS archaeology_site_context_73,
  a13_.id AS id_74,
  a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75,
  a14_.id AS id_76,
  a14_.archaeology_period AS archaeology_period_77,
  a15_.id AS id_78,
  a15_.archaeology_context_nature AS archaeology_context_nature_79,
  a16_.id AS id_80,
  a16_.archaeology_period AS archaeology_period_81,
  r17_.id AS id_82,
  r17_.rating AS rating_83,
  r18_.id AS id_84,
  r18_.rating AS rating_85,
  r19_.id AS id_86,
  r19_.rating AS rating_87,
  c20_.id AS id_88,
  c20_.container AS container_89,
  o21_.id AS id_90,
  o21_.object AS object_91,
  c22_.id AS id_92,
  c22_.coin_level_data AS coin_level_data_93,
  h23_.id AS id_94,
  h23_.reference AS reference_95,
  r24_.id AS id_96,
  r24_.authors AS authors_97,
  r24_.title AS title_98,
  r24_.year AS year_99,
  r24_.abbreviation AS abbreviation_100,
  r25_.id AS id_101
FROM
  hoard h0_
  LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id
  LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id
  LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id
  LEFT JOIN country c3_ ON c3_.id = h26_.country_id
  LEFT JOIN province p4_ ON h0_.province_id = p4_.id
  LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id
  LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id
  LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id
  LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id
  LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id
  LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id
  LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id
  LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id
  LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id
  LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id
  LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id
  LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id
  LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id
  LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id
  LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id
  LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id
  LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id
  LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id
  AND (c20_.deletedAt IS NULL)
  LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id
  AND (o21_.deletedAt IS NULL)
  LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id
  LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id
  AND (
    (
      h23_.deletedAt IS NULL
      OR h23_.deletedAt > CURRENT_TIMESTAMP
    )
  )
  LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id
  AND (r24_.deletedAt IS NULL)
  LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id
WHERE
  (h0_.id = ?)
  AND (
    (
      h0_.deletedAt IS NULL
      OR h0_.deletedAt > CURRENT_TIMESTAMP
    )
  )

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, h1_.id AS id_50, h1_.hoard_type AS hoard_type_51, h2_.hoard_id AS hoard_id_52, h2_.coin_count AS coin_count_53, c3_.id AS id_54, c3_.country AS country_55, p4_.id AS id_56, p4_.province AS province_57, a5_.id AS id_58, a5_.ancientPlace AS ancientPlace_59, f6_.id AS id_60, f6_.find_spot_location_detail AS find_spot_location_detail_61, r7_.id AS id_62, r7_.reign AS reign_63, r8_.id AS id_64, r8_.reign AS reign_65, d9_.id AS id_66, d9_.discovery_method AS discovery_method_67, d10_.id AS id_68, d10_.discovery_land_use AS discovery_land_use_69, a11_.id AS id_70, a11_.archaeology_recovery_method AS archaeology_recovery_method_71, a12_.id AS id_72, a12_.archaeology_site_context AS archaeology_site_context_73, a13_.id AS id_74, a13_.archaeology_site_context_detail AS archaeology_site_context_detail_75, a14_.id AS id_76, a14_.archaeology_period AS archaeology_period_77, a15_.id AS id_78, a15_.archaeology_context_nature AS archaeology_context_nature_79, a16_.id AS id_80, a16_.archaeology_period AS archaeology_period_81, r17_.id AS id_82, r17_.rating AS rating_83, r18_.id AS id_84, r18_.rating AS rating_85, r19_.id AS id_86, r19_.rating AS rating_87, c20_.id AS id_88, c20_.container AS container_89, o21_.id AS id_90, o21_.object AS object_91, c22_.id AS id_92, c22_.coin_level_data AS coin_level_data_93, h23_.id AS id_94, h23_.reference AS reference_95, r24_.id AS id_96, r24_.authors AS authors_97, r24_.title AS title_98, r24_.year AS year_99, r24_.abbreviation AS abbreviation_100, r25_.id AS id_101 FROM hoard h0_ LEFT JOIN hoard_type h1_ ON h0_.hoard_type_id = h1_.id LEFT JOIN hoard_coin_count h2_ ON h0_.id = h2_.hoard_id LEFT JOIN hoard_country h26_ ON h0_.id = h26_.hoard_id LEFT JOIN country c3_ ON c3_.id = h26_.country_id LEFT JOIN province p4_ ON h0_.province_id = p4_.id LEFT JOIN ancient_place a5_ ON h0_.ancient_place_id = a5_.id LEFT JOIN find_spot_location_detail f6_ ON h0_.find_spot_location_detail_id = f6_.id LEFT JOIN reign r7_ ON h0_.closing_reign1_id = r7_.id LEFT JOIN reign r8_ ON h0_.closing_reign2_id = r8_.id LEFT JOIN discovery_method d9_ ON h0_.discovery_method_id = d9_.id LEFT JOIN discovery_land_use d10_ ON h0_.discovery_land_use_id = d10_.id LEFT JOIN archaeology_recovery_method a11_ ON h0_.archaeology_recovery_method_id = a11_.id LEFT JOIN archaeology_site_context a12_ ON h0_.archaeology_site_context_id = a12_.id LEFT JOIN hoard_archaeology_site_context_detail h27_ ON h0_.id = h27_.hoard_id LEFT JOIN archaeology_site_context_detail a13_ ON a13_.id = h27_.archaeology_site_context_detail_id LEFT JOIN archaeology_period a14_ ON h0_.archaeology_period_id = a14_.id LEFT JOIN hoard_archaeology_context_nature h28_ ON h0_.id = h28_.hoard_id LEFT JOIN archaeology_context_nature a15_ ON a15_.id = h28_.archaeology_context_nature_id LEFT JOIN archaeology_period a16_ ON h0_.archaeology_end_period_id = a16_.id LEFT JOIN rating r17_ ON h0_.find_spot_rating_id = r17_.id LEFT JOIN rating r18_ ON h0_.contextual_rating_id = r18_.id LEFT JOIN rating r19_ ON h0_.rating_id = r19_.id LEFT JOIN container c20_ ON h0_.id = c20_.hoard_id AND (c20_.deletedAt IS NULL) LEFT JOIN object o21_ ON h0_.id = o21_.hoard_id AND (o21_.deletedAt IS NULL) LEFT JOIN coin_level_data c22_ ON h0_.coin_level_data_id = c22_.id LEFT JOIN hoard_reference h23_ ON h0_.id = h23_.hoard_id AND ((h23_.deletedAt IS NULL OR h23_.deletedAt > CURRENT_TIMESTAMP)) LEFT JOIN reference r24_ ON h23_.reference_id = r24_.id AND (r24_.deletedAt IS NULL) LEFT JOIN reference_type r25_ ON r24_.reference_type_id = r25_.id WHERE (h0_.id = 3943) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP));

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

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

Symfony Profiler

http://827063.czjdr4fae.asia/hoard/3943/csv

Configuration Settings

Theme