Symfony Profiler

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

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

SELECT
  t0.id AS id_1,
  t0.deleted AS deleted_2,
  t0.creation_date AS creation_date_3,
  t0.modified_date AS modified_date_4,
  t0.comment AS comment_5,
  t0.coin_id AS coin_id_6,
  t0.image_id AS image_id_7,
  t0.image_type AS image_type_8,
  t0.created_by AS created_by_9,
  t0.modified_by AS modified_by_10
FROM
  coin_image t0
WHERE
  t0.coin_id = ?

SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.creation_date AS creation_date_3, t0.modified_date AS modified_date_4, t0.comment AS comment_5, t0.coin_id AS coin_id_6, t0.image_id AS image_id_7, t0.image_type AS image_type_8, t0.created_by AS created_by_9, t0.modified_by AS modified_by_10 FROM coin_image t0 WHERE t0.coin_id = 177567;

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
WHERE
  t0.id = ?

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 WHERE t0.id = 21;

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
  INNER JOIN coin_person ON t0.id = coin_person.person_id
WHERE
  coin_person.coin_id = ?

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 INNER JOIN coin_person ON t0.id = coin_person.person_id WHERE coin_person.coin_id = 177567;

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
  INNER JOIN coin_reign ON t0.id = coin_reign.reign_id
WHERE
  coin_reign.coin_id = ?

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 INNER JOIN coin_reign ON t0.id = coin_reign.reign_id WHERE coin_reign.coin_id = 177567;

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
  INNER JOIN coin_denomination ON t0.id = coin_denomination.denomination_id
WHERE
  coin_denomination.coin_id = ?

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 INNER JOIN coin_denomination ON t0.id = coin_denomination.denomination_id WHERE coin_denomination.coin_id = 177567;

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
  INNER JOIN coin_mint ON t0.id = coin_mint.mint_id
WHERE
  coin_mint.coin_id = ?

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 INNER JOIN coin_mint ON t0.id = coin_mint.mint_id WHERE coin_mint.coin_id = 177567;

SELECT
  t0.id AS id_1,
  t0.container AS container_2,
  t0.uri1 AS uri1_3,
  t0.uri2 AS uri2_4,
  t0.deleted AS deleted_5,
  t0.deletedAt AS deletedAt_6,
  t0.creation_date AS creation_date_7,
  t0.modified_date AS modified_date_8,
  t0.comment AS comment_9,
  t0.container_sherd_id AS container_sherd_id_10,
  t0.container_form_id AS container_form_id_11,
  t0.hoard_id AS hoard_id_12,
  t0.material_id AS material_id_13,
  t0.created_by AS created_by_14,
  t0.modified_by AS modified_by_15
FROM
  container t0
WHERE
  t0.id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.container AS container_2, t0.uri1 AS uri1_3, t0.uri2 AS uri2_4, t0.deleted AS deleted_5, t0.deletedAt AS deletedAt_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.comment AS comment_9, t0.container_sherd_id AS container_sherd_id_10, t0.container_form_id AS container_form_id_11, t0.hoard_id AS hoard_id_12, t0.material_id AS material_id_13, t0.created_by AS created_by_14, t0.modified_by AS modified_by_15 FROM container t0 WHERE t0.id = 717 AND ((t0.deletedAt IS NULL));

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
  INNER JOIN coin_aspect ON t0.id = coin_aspect.aspect_id
WHERE
  coin_aspect.coin_id = ?

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 INNER JOIN coin_aspect ON t0.id = coin_aspect.aspect_id WHERE coin_aspect.coin_id = 177567;

SELECT
  t0.id AS id_1,
  t0.deleted AS deleted_2,
  t0.creation_date AS creation_date_3,
  t0.modified_date AS modified_date_4,
  t0.comment AS comment_5,
  t0.coin_id AS coin_id_6,
  t0.additional_field_id AS additional_field_id_7
FROM
  coin_additional_field t0
WHERE
  t0.coin_id = ?

SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.creation_date AS creation_date_3, t0.modified_date AS modified_date_4, t0.comment AS comment_5, t0.coin_id AS coin_id_6, t0.additional_field_id AS additional_field_id_7 FROM coin_additional_field t0 WHERE t0.coin_id = 177567;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.this_specimen AS this_specimen_3,
  t0.deleted AS deleted_4,
  t0.deletedAt AS deletedAt_5,
  t0.comment AS comment_6,
  t0.creation_date AS creation_date_7,
  t0.modified_date AS modified_date_8,
  t0.coin_id AS coin_id_9,
  t0.reference_id AS reference_id_10,
  t0.created_by AS created_by_11,
  t0.modified_by AS modified_by_12
FROM
  coin_reference t0
WHERE
  t0.coin_id = ?
  AND (
    (
      (
        t0.deletedAt IS NULL
        OR t0.deletedAt > CURRENT_TIMESTAMP
      )
    )
  )

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.this_specimen AS this_specimen_3, t0.deleted AS deleted_4, t0.deletedAt AS deletedAt_5, t0.comment AS comment_6, t0.creation_date AS creation_date_7, t0.modified_date AS modified_date_8, t0.coin_id AS coin_id_9, t0.reference_id AS reference_id_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM coin_reference t0 WHERE t0.coin_id = 177567 AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)));