Query Metrics
18
Database Queries
12
Different statements
22.89 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.49 ms |
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"
]
|
| 2 | 0.40 ms |
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"
]
|
| 3 | 0.44 ms |
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" ] |
| 4 | 0.42 ms |
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" ] |
| 5 | 0.39 ms |
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 ] |
| 6 | 0.56 ms |
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" ] |
| 7 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.26 ms |
INSERT INTO daily_user_usage (count, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 "2026-04-18" 1 ] |
| 9 | 3.82 ms |
"COMMIT"
Parameters:
[] |
| 10 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.23 ms |
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 ] |
| 12 | 0.28 ms |
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 ] |
| 13 | 4.12 ms |
"COMMIT"
Parameters:
[] |
| 14 | 0.53 ms |
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" ] |
| 15 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
| 16 | 0.35 ms |
UPDATE daily_user_usage SET count = ? WHERE id = ?
Parameters:
[ 2 1 ] |
| 17 | 0.22 ms |
UPDATE word SET image_filename = ? WHERE id = ?
Parameters:
[ "five_1776505693_7387fc8a.png" 1 ] |
| 18 | 7.04 ms |
"COMMIT"
Parameters:
[] |
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. |