Query Metrics
3
Database Queries
3
Different statements
16517.98 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
16450.38 ms (99.59%) |
1 |
select t.id, t.locale, t.domain, t.translation_key as 'key', t.translation_value as 'value', (select t2.translation_value from `translation` t2 where t2.`domain` = t.domain and t2.translation_key = binary t.translation_key and t2.locale = :currentDefaultLocale and t2.project_id = t.project_id) as defaultTranslation from `translation` t where t.locale like :locale and t.domain like :domain and t.project_id = :projectId order by t.id desc
Parameters:
[ "locale" => "uk" "domain" => "text" "projectId" => 4 "currentDefaultLocale" => "en" ] |
63.80 ms (0.39%) |
1 |
SELECT DISTINCT t0_.locale AS locale_0 FROM translation t0_ INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE p1_.id = ? ORDER BY t0_.locale ASC
Parameters:
[
4
]
|
3.79 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.auth_token AS auth_token_3, t0.hash AS hash_4, t0.hash_updated_at AS hash_updated_at_5, t0.default_locale AS default_locale_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM project t0 WHERE t0.auth_token = ? LIMIT 1
Parameters:
[
"Vf7cR8ZAsNQvhEwteiJqzl42Sn5DMBj1"
]
|
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\User | No errors. |
App\Entity\Project | No errors. |
App\Entity\Translation | No errors. |