Query Metrics
18
Database Queries
12
Different statements
22.89 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.97 ms (65.41%) |
3 |
"COMMIT"
Parameters:
[] |
|
3.49 ms (15.24%) |
1 |
SELECT t0.id AS id_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM app_version t0 WHERE t0.version = ? LIMIT 1
Parameters:
[
"1.0.0"
]
|
|
1.50 ms (6.57%) |
3 |
SELECT t0.id AS id_1, t0.count AS count_2, t0.date AS date_3, t0.user_id AS user_id_4 FROM daily_user_usage t0 WHERE t0.user_id = ? AND t0.date = ? LIMIT 1
Parameters:
[ 1 "2026-04-18" ] |
|
0.44 ms (1.90%) |
1 |
SELECT t0.id AS id_1, t0.word AS word_2, t0.translation AS translation_3, t0.meaning AS meaning_4, t0.`usage` AS usage_5, t0.synonyms AS synonyms_6, t0.examples AS examples_7, t0.language_from AS language_from_8, t0.language_to AS language_to_9, t0.created_at AS created_at_10, t0.image_filename AS image_filename_11 FROM word t0 WHERE t0.word = ? AND t0.language_from = ? AND t0.language_to = ? LIMIT 1
Parameters:
[ "five" "english" "german" ] |
|
0.40 ms (1.75%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.status AS status_7, t0.google_id AS google_id_8 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admin@example.com"
]
|
|
0.39 ms (1.68%) |
1 |
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.is_active AS is_active_4, t0.user_id AS user_id_5, t0.plan_id AS plan_id_6 FROM user_subscription t0 WHERE t0.user_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ 1 1 ] |
|
0.36 ms (1.58%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.35 ms (1.53%) |
1 |
UPDATE daily_user_usage SET count = ? WHERE id = ?
Parameters:
[ 2 1 ] |
|
0.28 ms (1.21%) |
1 |
INSERT INTO user_word (status, interval_days, ease_factor, repetition, next_review_date, created_at, user_id, word_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "new" 1 2.5 0 "2026-04-18" "2026-04-18 09:47:50" 1 1 ] |
|
0.26 ms (1.15%) |
1 |
INSERT INTO daily_user_usage (count, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 "2026-04-18" 1 ] |
|
0.23 ms (1.01%) |
1 |
INSERT INTO word (word, translation, meaning, `usage`, synonyms, examples, language_from, language_to, created_at, image_filename) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "five" "fünf" "Die Zahl nach vier." "Zum Zählen oder Zählen von Dingen verwenden." "["f\u00fcnf (5)","f\u00fcnfter (5)","Pentagon (F\u00fcnfeck)"]" "["Ich habe f\u00fcnf \u00c4pfel gekauft.","Das Buch hat f\u00fcnf Kapitel.","Es sind f\u00fcnf Personen in der Gruppe."]" "english" "german" "2026-04-18 09:47:50" null ] |
|
0.22 ms (0.98%) |
1 |
UPDATE word SET image_filename = ? WHERE id = ?
Parameters:
[ "five_1776505693_7387fc8a.png" 1 ] |
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\Domains\Shared\Entity\AppVersion | No errors. |
| App\Domains\User\Domain\Entity\User | No errors. |
| App\Domains\Word\Domain\Entity\Word | No errors. |
| App\Domains\User\Domain\Entity\DailyWordUsage | No errors. |
| App\Domains\UserPlan\Domain\Entity\UserSubscription | No errors. |
| App\Domains\Plan\Domain\Entity\Plan |
|
| App\Domains\UserWord\Domain\Entity\UserWord | No errors. |