http://827063.czjdr4fae.asia/reference/5185

Query Metrics

3 Database Queries
3 Different statements
0.84 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.38 ms
(44.79%)
1
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:
[
  "5185"
]
0.27 ms
(32.11%)
1
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.reference_id = ? AND (((t0.deletedAt IS NULL OR t0.deletedAt > CURRENT_TIMESTAMP)))
Parameters:
[
  5185
]
0.20 ms
(23.10%)
1
SELECT t0.id AS id_1, t0.reference_type AS reference_type_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 reference_type t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Reference No errors.
App\Ox\HoardBundle\Entity\ReferenceType No errors.
Nucleos\UserBundle\Model\User No errors.
App\Ox\HoardBundle\Entity\User No errors.
App\Ox\HoardBundle\Entity\CoinReference No errors.
App\Ox\HoardBundle\Entity\HoardReference No errors.
App\Ox\HoardBundle\Entity\ObjectReference No errors.
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.