http://3.231.139.148/api/translate

Query Metrics

18 Database Queries
12 Different statements
22.89 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The field 'App\Domains\Plan\Domain\Entity\Plan#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domains\UserWord\Domain\Entity\UserWord No errors.