Query Metrics
25
Database Queries
22
Different statements
16.17 ms
Query time
9
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.64 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:
[
"4084"
]
|
2 | 0.56 ms |
SELECT t0.id AS id_1, t0.URI1 AS URI1_2, t0.URI2 AS URI2_3, t0.deleted AS deleted_4, t0.deletedAt AS deletedAt_5, t0.creation_date AS creation_date_6, t0.modified_date AS modified_date_7, t0.comment AS comment_8, t0.hoard_id AS hoard_id_9, t0.image_id AS image_id_10, t0.created_by AS created_by_11, t0.modified_by AS modified_by_12 FROM hoard_image t0 WHERE t0.hoard_id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))
Parameters:
[
4084
]
|
3 | 0.31 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.deleted AS deleted_3, t0.user_image AS user_image_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
599
]
|
4 | 0.40 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.deleted AS deleted_3, t0.deletedAt AS deletedAt_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.hoard_id AS hoard_id_8, t0.reference_id AS reference_id_9, t0.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM hoard_reference t0 WHERE t0.hoard_id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))
Parameters:
[
4084
]
|
5 | 0.42 ms |
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:
[
3018
]
|
6 | 0.39 ms |
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:
[
227
]
|
7 | 1.77 ms |
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
Parameters:
[] |
8 | 5.65 ms |
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
Parameters:
[] |
9 | 0.64 ms |
SELECT t0.id AS id_1, t0.country AS country_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.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM country t0 INNER JOIN hoard_country ON t0.id = hoard_country.country_id WHERE hoard_country.hoard_id = ?
Parameters:
[
4084
]
|
10 | 0.30 ms |
SELECT t0.id AS id_1, t0.find_spot_location_detail AS find_spot_location_detail_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM find_spot_location_detail t0 WHERE t0.id = ?
Parameters:
[
7
]
|
11 | 1.02 ms |
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.hoard_id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))
Parameters:
[
4084
]
|
12 | 0.33 ms |
SELECT t0.id AS id_1, t0.hoard_type AS hoard_type_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.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM hoard_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
13 | 0.26 ms |
SELECT t0.id AS id_1, t0.discovery_method AS discovery_method_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM discovery_method t0 WHERE t0.id = ?
Parameters:
[
7
]
|
14 | 0.25 ms |
SELECT t0.id AS id_1, t0.discovery_land_use AS discovery_land_use_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM discovery_land_use t0 WHERE t0.id = ?
Parameters:
[
35
]
|
15 | 0.24 ms |
SELECT t0.id AS id_1, t0.coin_level_data AS coin_level_data_2, t0.deleted AS deleted_3, t0.creation_date AS creation_date_4, t0.modified_date AS modified_date_5, t0.comment AS comment_6, t0.created_by AS created_by_7, t0.modified_by AS modified_by_8 FROM coin_level_data t0 WHERE t0.id = ?
Parameters:
[
2
]
|
16 | 0.25 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM rating t0 WHERE t0.id = ?
Parameters:
[
4
]
|
17 | 0.23 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM rating t0 WHERE t0.id = ?
Parameters:
[
3
]
|
18 | 0.24 ms |
SELECT t0.id AS id_1, t0.archaeology_site_context AS archaeology_site_context_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_site_context t0 WHERE t0.id = ?
Parameters:
[
3
]
|
19 | 0.40 ms |
SELECT t0.id AS id_1, t0.archaeology_site_context_detail AS archaeology_site_context_detail_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_site_context_detail t0 INNER JOIN hoard_archaeology_site_context_detail ON t0.id = hoard_archaeology_site_context_detail.archaeology_site_context_detail_id WHERE hoard_archaeology_site_context_detail.hoard_id = ?
Parameters:
[
4084
]
|
20 | 0.41 ms |
SELECT t0.id AS id_1, t0.archaeology_context_nature AS archaeology_context_nature_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_context_nature t0 INNER JOIN hoard_archaeology_context_nature ON t0.id = hoard_archaeology_context_nature.archaeology_context_nature_id WHERE hoard_archaeology_context_nature.hoard_id = ?
Parameters:
[
4084
]
|
21 | 0.24 ms |
SELECT t0.id AS id_1, t0.archaeology_period AS archaeology_period_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_period t0 WHERE t0.id = ?
Parameters:
[
1
]
|
22 | 0.21 ms |
SELECT t0.id AS id_1, t0.archaeology_period AS archaeology_period_2, t0.deleted AS deleted_3, t0.sort_value AS sort_value_4, t0.creation_date AS creation_date_5, t0.modified_date AS modified_date_6, t0.comment AS comment_7, t0.created_by AS created_by_8, t0.modified_by AS modified_by_9 FROM archaeology_period t0 WHERE t0.id = ?
Parameters:
[
13
]
|
23 | 0.35 ms |
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.hoard_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
4084
]
|
24 | 0.30 ms |
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modified_date AS modified_date_3, t0.deleted AS deleted_4, t0.deletedAt AS deletedAt_5, t0.uri1 AS uri1_6, t0.comment AS comment_7, t0.container_id AS container_id_8, t0.image_id AS image_id_9, t0.created_by AS created_by_10, t0.modified_by AS modified_by_11 FROM container_image t0 WHERE t0.container_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
1931
]
|
25 | 0.35 ms |
SELECT t0.id AS id_1, t0.object AS object_2, t0.description AS description_3, t0.quantity AS quantity_4, t0.production_place AS production_place_5, t0.weight AS weight_6, t0.dimension_length_cm AS dimension_length_cm_7, t0.dimension_width_cm AS dimension_width_cm_8, t0.dimension_diameter_cm AS dimension_diameter_cm_9, t0.start_year AS start_year_10, t0.end_year AS end_year_11, t0.deleted AS deleted_12, t0.deletedAt AS deletedAt_13, t0.creation_date AS creation_date_14, t0.modified_date AS modified_date_15, t0.comment AS comment_16, t0.hoard_id AS hoard_id_17, t0.container_id AS container_id_18, t0.material_id AS material_id_19, t0.created_by AS created_by_20, t0.modified_by AS modified_by_21 FROM object t0 WHERE t0.hoard_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
4084
]
|
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 |
|
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 |
|
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 |
|
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 |
|
App\Ox\HoardBundle\Entity\ArchaeologySiteContextDetail |
|
App\Ox\HoardBundle\Entity\ArchaeologyContextNature |
|
App\Ox\HoardBundle\Entity\Image | No errors. |
App\Ox\HoardBundle\Entity\Reference | No errors. |
App\Ox\HoardBundle\Entity\ReferenceType | No errors. |
App\Ox\HoardBundle\Entity\CoinReference | No errors. |
App\Ox\HoardBundle\Entity\ObjectReference | No errors. |
App\Ox\HoardBundle\Entity\Period |
|
App\Ox\HoardBundle\Entity\OcreLookup | No errors. |
App\Ox\HoardBundle\Entity\Person | No errors. |
App\Ox\HoardBundle\Entity\Condition |
|
App\Ox\HoardBundle\Entity\Layer | No errors. |
App\Ox\HoardBundle\Entity\CoinAdditionalField | No errors. |
App\Ox\HoardBundle\Entity\Denomination | No errors. |
App\Ox\HoardBundle\Entity\Mint |
|
App\Ox\HoardBundle\Entity\Aspect | No errors. |
App\Ox\HoardBundle\Entity\CoinImage | No errors. |
App\Ox\HoardBundle\Entity\ContainerSherd | No errors. |
App\Ox\HoardBundle\Entity\ContainerForm | No errors. |
App\Ox\HoardBundle\Entity\Material | No errors. |
App\Ox\HoardBundle\Entity\ContainerImage | No errors. |