Symfony Profiler

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 = 921) AND ((h0_.deletedAt IS NULL OR h0_.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 = ?
  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 = '921' AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)));