Query Metrics
3
Database Queries
3
Different statements
0.63 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.24 ms (37.42%) |
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:
[
"25"
]
|
0.20 ms (31.69%) |
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:
[
25
]
|
0.19 ms (30.89%) |
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:
[
5
]
|
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 |
|