http://827063.czjdr4fae.asia/coin/440670

Query Metrics

16 Database Queries
14 Different statements
10.34 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.42 ms
(52.39%)
1
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 = ?
Parameters:
[
  440670
]
0.99 ms
(9.61%)
1
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 = ?
Parameters:
[
  440670
]
0.71 ms
(6.86%)
3
SELECT t0.id AS id_1, t0.authors AS authors_2, t0.editors AS editors_3, t0.title AS title_4, t0.title_edition AS title_edition_5, t0.volume AS volume_6, t0.place AS place_7, t0.year AS year_8, t0.pages AS pages_9, t0.abbreviation AS abbreviation_10, t0.uri1 AS uri1_11, t0.uri1_accession_date AS uri1_accession_date_12, t0.uri2 AS uri2_13, t0.uri2_accession_date AS uri2_accession_date_14, t0.fully_entered AS fully_entered_15, t0.deleted AS deleted_16, t0.deletedAt AS deletedAt_17, t0.internal_note AS internal_note_18, t0.sort_value AS sort_value_19, t0.has_own_column AS has_own_column_20, t0.filePath AS filePath_21, t0.is_file_public AS is_file_public_22, t0.redirect_to_reference AS redirect_to_reference_23, t0.creation_date AS creation_date_24, t0.modified_date AS modified_date_25, t0.comment AS comment_26, t0.reference_type_id AS reference_type_id_27, t0.created_by AS created_by_28, t0.modified_by AS modified_by_29 FROM reference t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  1599
]
0.48 ms
(4.61%)
1
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:
[
  18555
]
0.40 ms
(3.87%)
1
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)))
Parameters:
[
  "440670"
]
0.34 ms
(3.24%)
1
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 = ?
Parameters:
[
  440670
]
0.32 ms
(3.05%)
1
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 = ?
Parameters:
[
  440670
]
0.29 ms
(2.82%)
1
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 = ?
Parameters:
[
  440670
]
0.28 ms
(2.71%)
1
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)))
Parameters:
[
  440670
]
0.27 ms
(2.62%)
1
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 = ?
Parameters:
[
  440670
]
0.25 ms
(2.42%)
1
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 = ?
Parameters:
[
  440670
]
0.23 ms
(2.21%)
1
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 = ?
Parameters:
[
  21
]
0.19 ms
(1.84%)
1
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))
Parameters:
[
  3048
]
0.18 ms
(1.75%)
1
SELECT t0.id AS id_1, t0.coin_condition AS coin_condition_2, t0.grade AS grade_3, t0.uri1 AS uri1_4, t0.uri2 AS uri2_5, t0.deleted AS deleted_6, t0.sort_value AS sort_value_7, t0.creation_date AS creation_date_8, t0.modified_date AS modified_date_9, t0.comment AS comment_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM coin_condition t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\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\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\Condition
  • The association App\Ox\HoardBundle\Entity\Condition#coins refers to the owning side field App\Ox\HoardBundle\Entity\Coin#coin_condition which does not exist.
App\Ox\HoardBundle\Entity\Container No errors.
App\Ox\HoardBundle\Entity\Layer No errors.
App\Ox\HoardBundle\Entity\Period
  • The association App\Ox\HoardBundle\Entity\Period#mints refers to the owning side field App\Ox\HoardBundle\Entity\Mint#period which does not exist.
Nucleos\UserBundle\Model\User No errors.
App\Ox\HoardBundle\Entity\User No errors.
App\Ox\HoardBundle\Entity\CoinReference No errors.
App\Ox\HoardBundle\Entity\CoinAdditionalField No errors.
App\Ox\HoardBundle\Entity\Denomination No errors.
App\Ox\HoardBundle\Entity\Mint
  • The mappings App\Ox\HoardBundle\Entity\Mint#period1 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period2 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period3 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
  • The mappings App\Ox\HoardBundle\Entity\Mint#period4 and App\Ox\HoardBundle\Entity\Period#mints are inconsistent with each other.
App\Ox\HoardBundle\Entity\Person 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\Aspect No errors.
App\Ox\HoardBundle\Entity\CoinImage No errors.
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\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.
App\Ox\HoardBundle\Entity\UserHoard No errors.
App\Ox\HoardBundle\Entity\HoardCoinCount No errors.
App\Ox\HoardBundle\Entity\HoardNameSimple 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\Image No errors.
App\Ox\HoardBundle\Entity\CoinImageType No errors.
App\Ox\HoardBundle\Entity\OcreLookup No errors.
App\Ox\HoardBundle\Entity\Material No errors.
App\Ox\HoardBundle\Entity\ContainerSherd No errors.
App\Ox\HoardBundle\Entity\ContainerForm No errors.
App\Ox\HoardBundle\Entity\ContainerImage No errors.
App\Ox\HoardBundle\Entity\AdditionalField No errors.
App\Ox\HoardBundle\Entity\Reference No errors.
App\Ox\HoardBundle\Entity\ReferenceType No errors.
App\Ox\HoardBundle\Entity\ObjectReference No errors.