Query Metrics
13
Database Queries
3
Different statements
2.01 ms
Query time
7
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.98 ms (49.05%) |
1 |
SELECT a0_.id AS id_0, a0_.surname AS surname_1, a0_.first_name AS first_name_2, a0_.birthdate AS birthdate_3, a0_.birthdate_accuracy AS birthdate_accuracy_4, a0_.date_of_death AS date_of_death_5, a0_.date_of_death_accuracy AS date_of_death_accuracy_6, a0_.sv_description AS sv_description_7, a0_.en_description AS en_description_8, a0_.research_notes AS research_notes_9, a0_.gender AS gender_10, a0_.alt_surnames AS alt_surnames_11, a0_.alt_first_names AS alt_first_names_12, a0_.alvin_id AS alvin_id_13, a0_.updated_at AS updated_at_14, a0_.wikidata_id AS wikidata_id_15, a0_.sbl_id AS sbl_id_16, a0_.literature_bank_id AS literature_bank_id_17, a0_.runeberg_id AS runeberg_id_18, a0_.sv_wikipedia_link AS sv_wikipedia_link_19, a0_.en_wikipedia_link AS en_wikipedia_link_20, a0_.sv_wikisource_link AS sv_wikisource_link_21, a0_.en_wikisource_link AS en_wikisource_link_22, a0_.commons_wiki_link AS commons_wiki_link_23, a0_.display_on_frontpage AS display_on_frontpage_24, a0_.automark_ignore AS automark_ignore_25, a0_.disambiguation_page AS disambiguation_page_26, a0_.birth_place_id AS birth_place_id_27, a0_.place_of_death_id AS place_of_death_id_28, a0_.updated_by_id AS updated_by_id_29, a0_.portrait_id AS portrait_id_30 FROM actors a0_ WHERE a0_.display_on_frontpage = 1 ORDER BY a0_.updated_at DESC LIMIT 6
Parameters:
[] |
|
0.52 ms (25.97%) |
6 |
SELECT t0.id AS id_1, t0.actor_id AS actor_id_2, t0.institution_id AS institution_id_3 FROM correspondents t0 WHERE t0.actor_id = ?
Parameters:
[
2579
]
|
|
0.50 ms (24.98%) |
6 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.updated_at AS updated_at_5, t0.path AS path_6, t0.description AS description_7, t0.source_id AS source_id_8, t0.place_id AS place_id_9, t0.actor_id AS actor_id_10 FROM files t0 WHERE t0.id = ?
Parameters:
[
954
]
|
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\Entity\Source |
|
| App\Entity\Actor |
|
| App\Entity\Place |
|
| App\Entity\Volume |
|
| App\Entity\User |
|
| App\Entity\DatabaseFile |
|
| App\Entity\Relationship | No errors. |
| App\Entity\ActorOccupation | No errors. |
| App\Entity\Correspondent | No errors. |
| App\Entity\Institution | No errors. |
| App\Entity\Action | No errors. |
| App\Entity\Mention |
|
| App\Entity\ActorPlace | No errors. |
| App\Entity\IgnoreActor | No errors. |