Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.starting_date AS starting_date_1,
  c0_.ending_date AS ending_date_2,
  c0_.date_text AS date_text_3,
  c0_.issue AS issue_4,
  c0_.officina AS officina_5,
  c0_.obverse_inscription AS obverse_inscription_6,
  c0_.obverse_mint_mark AS obverse_mint_mark_7,
  c0_.obverse_description AS obverse_description_8,
  c0_.reverse_inscription AS reverse_inscription_9,
  c0_.reverse_mint_mark AS reverse_mint_mark_10,
  c0_.reverse_description AS reverse_description_11,
  c0_.weight AS weight_12,
  c0_.quantity AS quantity_13,
  c0_.diameter AS diameter_14,
  c0_.axis AS axis_15,
  c0_.imitation AS imitation_16,
  c0_.latest_coin AS latest_coin_17,
  c0_.intruder AS intruder_18,
  c0_.to_check AS to_check_19,
  c0_.deleted AS deleted_20,
  c0_.deletedAt AS deletedAt_21,
  c0_.creation_date AS creation_date_22,
  c0_.modified_date AS modified_date_23,
  c0_.comment AS comment_24,
  r1_.id AS id_25,
  r1_.reign AS reign_26,
  r1_.start_date AS start_date_27,
  r1_.end_date AS end_date_28,
  r1_.uri1 AS uri1_29,
  r1_.uri2 AS uri2_30,
  r1_.deleted AS deleted_31,
  r1_.sort_value AS sort_value_32,
  r1_.creation_date AS creation_date_33,
  r1_.modified_date AS modified_date_34,
  r1_.comment AS comment_35,
  p2_.id AS id_36,
  p2_.person AS person_37,
  p2_.title AS title_38,
  p2_.start_date AS start_date_39,
  p2_.end_date AS end_date_40,
  p2_.uri1 AS uri1_41,
  p2_.uri2 AS uri2_42,
  p2_.deleted AS deleted_43,
  p2_.sort_value AS sort_value_44,
  p2_.creation_date AS creation_date_45,
  p2_.modified_date AS modified_date_46,
  p2_.comment AS comment_47,
  d3_.id AS id_48,
  d3_.denomination AS denomination_49,
  d3_.uri1 AS uri1_50,
  d3_.uri2 AS uri2_51,
  d3_.deleted AS deleted_52,
  d3_.sort_value AS sort_value_53,
  d3_.creation_date AS creation_date_54,
  d3_.modified_date AS modified_date_55,
  d3_.comment AS comment_56,
  m4_.id AS id_57,
  m4_.material AS material_58,
  m4_.uri1 AS uri1_59,
  m4_.uri2 AS uri2_60,
  m4_.deleted AS deleted_61,
  m4_.sort_value AS sort_value_62,
  m4_.creation_date AS creation_date_63,
  m4_.modified_date AS modified_date_64,
  m4_.comment AS comment_65,
  m5_.id AS id_66,
  m5_.mint AS mint_67,
  m5_.latitude AS latitude_68,
  m5_.longitude AS longitude_69,
  m5_.uri1 AS uri1_70,
  m5_.uri2 AS uri2_71,
  m5_.deleted AS deleted_72,
  m5_.sort_value AS sort_value_73,
  m5_.creation_date AS creation_date_74,
  m5_.modified_date AS modified_date_75,
  m5_.comment AS comment_76,
  p6_.id AS id_77,
  p6_.period AS period_78,
  p6_.person_control_name AS person_control_name_79,
  p6_.uri1 AS uri1_80,
  p6_.uri2 AS uri2_81,
  p6_.deleted AS deleted_82,
  p6_.sort_value AS sort_value_83,
  p6_.creation_date AS creation_date_84,
  p6_.modified_date AS modified_date_85,
  p6_.comment AS comment_86,
  a7_.id AS id_87,
  a7_.aspect AS aspect_88,
  a7_.uri1 AS uri1_89,
  a7_.uri2 AS uri2_90,
  a7_.sort_value AS sort_value_91,
  a7_.deleted AS deleted_92,
  a7_.creation_date AS creation_date_93,
  a7_.modified_date AS modified_date_94,
  a7_.comment AS comment_95,
  c8_.id AS id_96,
  c8_.reference AS reference_97,
  r9_.id AS id_98,
  r9_.abbreviation AS abbreviation_99
FROM
  coin c0_
  LEFT JOIN coin_reign c10_ ON c0_.id = c10_.coin_id
  LEFT JOIN reign r1_ ON r1_.id = c10_.reign_id
  LEFT JOIN coin_person c11_ ON c0_.id = c11_.coin_id
  LEFT JOIN person p2_ ON p2_.id = c11_.person_id
  LEFT JOIN coin_denomination c12_ ON c0_.id = c12_.coin_id
  LEFT JOIN denomination d3_ ON d3_.id = c12_.denomination_id
  LEFT JOIN material m4_ ON d3_.material_id = m4_.id
  LEFT JOIN coin_mint c13_ ON c0_.id = c13_.coin_id
  LEFT JOIN mint m5_ ON m5_.id = c13_.mint_id
  LEFT JOIN period p6_ ON c0_.period_id = p6_.id
  LEFT JOIN coin_aspect c14_ ON c0_.id = c14_.coin_id
  LEFT JOIN aspect a7_ ON a7_.id = c14_.aspect_id
  LEFT JOIN coin_reference c8_ ON c0_.id = c8_.coin_id
  AND (
    (
      c8_.deletedAt IS NULL
      OR c8_.deletedAt > CURRENT_TIMESTAMP
    )
  )
  LEFT JOIN reference r9_ ON c8_.reference_id = r9_.id
  AND (r9_.deletedAt IS NULL)
WHERE
  (c0_.hoard_id = ?)
  AND (
    (
      c0_.deletedAt IS NULL
      OR c0_.deletedAt > CURRENT_TIMESTAMP
    )
  )

SELECT c0_.id AS id_0, c0_.starting_date AS starting_date_1, c0_.ending_date AS ending_date_2, c0_.date_text AS date_text_3, c0_.issue AS issue_4, c0_.officina AS officina_5, c0_.obverse_inscription AS obverse_inscription_6, c0_.obverse_mint_mark AS obverse_mint_mark_7, c0_.obverse_description AS obverse_description_8, c0_.reverse_inscription AS reverse_inscription_9, c0_.reverse_mint_mark AS reverse_mint_mark_10, c0_.reverse_description AS reverse_description_11, c0_.weight AS weight_12, c0_.quantity AS quantity_13, c0_.diameter AS diameter_14, c0_.axis AS axis_15, c0_.imitation AS imitation_16, c0_.latest_coin AS latest_coin_17, c0_.intruder AS intruder_18, c0_.to_check AS to_check_19, c0_.deleted AS deleted_20, c0_.deletedAt AS deletedAt_21, c0_.creation_date AS creation_date_22, c0_.modified_date AS modified_date_23, c0_.comment AS comment_24, r1_.id AS id_25, r1_.reign AS reign_26, r1_.start_date AS start_date_27, r1_.end_date AS end_date_28, r1_.uri1 AS uri1_29, r1_.uri2 AS uri2_30, r1_.deleted AS deleted_31, r1_.sort_value AS sort_value_32, r1_.creation_date AS creation_date_33, r1_.modified_date AS modified_date_34, r1_.comment AS comment_35, p2_.id AS id_36, p2_.person AS person_37, p2_.title AS title_38, p2_.start_date AS start_date_39, p2_.end_date AS end_date_40, p2_.uri1 AS uri1_41, p2_.uri2 AS uri2_42, p2_.deleted AS deleted_43, p2_.sort_value AS sort_value_44, p2_.creation_date AS creation_date_45, p2_.modified_date AS modified_date_46, p2_.comment AS comment_47, d3_.id AS id_48, d3_.denomination AS denomination_49, d3_.uri1 AS uri1_50, d3_.uri2 AS uri2_51, d3_.deleted AS deleted_52, d3_.sort_value AS sort_value_53, d3_.creation_date AS creation_date_54, d3_.modified_date AS modified_date_55, d3_.comment AS comment_56, m4_.id AS id_57, m4_.material AS material_58, m4_.uri1 AS uri1_59, m4_.uri2 AS uri2_60, m4_.deleted AS deleted_61, m4_.sort_value AS sort_value_62, m4_.creation_date AS creation_date_63, m4_.modified_date AS modified_date_64, m4_.comment AS comment_65, m5_.id AS id_66, m5_.mint AS mint_67, m5_.latitude AS latitude_68, m5_.longitude AS longitude_69, m5_.uri1 AS uri1_70, m5_.uri2 AS uri2_71, m5_.deleted AS deleted_72, m5_.sort_value AS sort_value_73, m5_.creation_date AS creation_date_74, m5_.modified_date AS modified_date_75, m5_.comment AS comment_76, p6_.id AS id_77, p6_.period AS period_78, p6_.person_control_name AS person_control_name_79, p6_.uri1 AS uri1_80, p6_.uri2 AS uri2_81, p6_.deleted AS deleted_82, p6_.sort_value AS sort_value_83, p6_.creation_date AS creation_date_84, p6_.modified_date AS modified_date_85, p6_.comment AS comment_86, a7_.id AS id_87, a7_.aspect AS aspect_88, a7_.uri1 AS uri1_89, a7_.uri2 AS uri2_90, a7_.sort_value AS sort_value_91, a7_.deleted AS deleted_92, a7_.creation_date AS creation_date_93, a7_.modified_date AS modified_date_94, a7_.comment AS comment_95, c8_.id AS id_96, c8_.reference AS reference_97, r9_.id AS id_98, r9_.abbreviation AS abbreviation_99 FROM coin c0_ LEFT JOIN coin_reign c10_ ON c0_.id = c10_.coin_id LEFT JOIN reign r1_ ON r1_.id = c10_.reign_id LEFT JOIN coin_person c11_ ON c0_.id = c11_.coin_id LEFT JOIN person p2_ ON p2_.id = c11_.person_id LEFT JOIN coin_denomination c12_ ON c0_.id = c12_.coin_id LEFT JOIN denomination d3_ ON d3_.id = c12_.denomination_id LEFT JOIN material m4_ ON d3_.material_id = m4_.id LEFT JOIN coin_mint c13_ ON c0_.id = c13_.coin_id LEFT JOIN mint m5_ ON m5_.id = c13_.mint_id LEFT JOIN period p6_ ON c0_.period_id = p6_.id LEFT JOIN coin_aspect c14_ ON c0_.id = c14_.coin_id LEFT JOIN aspect a7_ ON a7_.id = c14_.aspect_id LEFT JOIN coin_reference c8_ ON c0_.id = c8_.coin_id AND ((c8_.deletedAt IS NULL OR c8_.deletedAt > CURRENT_TIMESTAMP)) LEFT JOIN reference r9_ ON c8_.reference_id = r9_.id AND (r9_.deletedAt IS NULL) WHERE (c0_.hoard_id = 31) AND ((c0_.deletedAt IS NULL OR c0_.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 = '31' AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)));